User:SCIdude/Rotavirus

From Wikidata
Jump to navigation Jump to search

Rotavirus A annotation[edit]

InterPro families[edit]

Strains / generic groups used in experimental papers[edit]

Strains / generic groups in WD[edit]

Roughly sorted by usage.

Query[edit]

The following query uses these:

Papers using many strains[edit]

The following query uses these:

  • Properties: instance of (P31)  View with Reasonator View with SQID, main subject (P921)  View with Reasonator View with SQID, describes a project that uses (P4510)  View with Reasonator View with SQID
    SELECT ?item ?itemLabel ?cnt
    {
      {
           SELECT ?item (COUNT(?value) AS ?cnt)
           {
              ?item wdt:P31 wd:Q13442814.
              ?item wdt:P921 wd:Q164778.
              ?item wdt:P4510 ?value
           }
           GROUP BY ?item ORDER BY DESC(?cnt) LIMIT 100
      }
      SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
    }
    ORDER BY DESC(?cnt)
    

Literature Queries[edit]

The following query uses these:

  • Properties: cites work (P2860)  View with Reasonator View with SQID, publication date (P577)  View with Reasonator View with SQID, PMCID (P932)  View with Reasonator View with SQID, DOI (P356)  View with Reasonator View with SQID, main subject (P921)  View with Reasonator View with SQID
    SELECT DISTINCT ?label ?item ?pmcid ?doi ?date
    {
      VALUES ?pw { wd:Q164778 }
      VALUES ?top { wd:Q128406 wd:Q908902 wd:Q4118894 wd:Q3933202 wd:Q14916420 wd:Q27108123 wd:Q898362 wd:Q14818042 wd:Q22244941 wd:Q11053 wd:Q83133549 wd:Q24745872 wd:Q24770641 wd:Q81490100 wd:Q24774064 wd:Q24773176 wd:Q24724262 wd:Q24719751 wd:Q24785520 wd:Q24726417 wd:Q24739451 wd:Q24782928 }
      ?item p:P921 [ ps:P921 ?pw].
      ?item p:P921 [ ps:P921 ?top].
      MINUS { ?item wdt:P2860 [] }
      ?item wdt:P577 ?date.
      OPTIONAL { 
        ?item wdt:P932 ?pmcid.
      }
      OPTIONAL { 
        ?item wdt:P356 ?doi.
      }
      ?item rdfs:label ?label.
      FILTER(lang(?label) = 'en' && !STRENDS(?doi, 'PDB'))
    }