User:SCIdude/Rotavirus

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)     , main subject (P921)     , describes a project that uses (P4510)     
    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)     , publication date (P577)     , PMC publication ID (P932)     , DOI (P356)     , main subject (P921)     
    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'))
    }