SARS-CoV-2-Queries

virusProteinsSARSr.rq

Code examples: curl

SPARQL

SELECT ?virus ?virusLabel ?protein ?proteinLabel ?refseq ?uniprot WHERE {
  VALUES ?virus {
    wd:Q16000326 # SL-CoV-WIV1
    wd:Q88162038 # Bat SARS coronavirus Rp1
    wd:Q85939995 # SHC014-CoV
    wd:Q82069695 # SARS-CoV-2
    wd:Q34967815 # SARS coronavirus
    wd:Q85438966 # severe acute respiratory syndrome coronavirus
    wd:Q278567   # SARSr-CoV / SARS-CoV
  }
  ?protein wdt:P703 ?virus ; wdt:P31 wd:Q8054 .
  OPTIONAL { ?protein wdt:P637 ?refseq }
  OPTIONAL { ?protein wdt:P352 ?uniprot }
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en,en". }
} ORDER BY ASC(?virus) ASC(?protein)

run or edit

Output

virus protein refseq uniprot
SARSr-CoV (edit) Protein 3a [SARS-Cov] (edit) NP_828852.2 P59632
SARSr-CoV (edit) Replicase polyprotein 1a (edit) P0C6U8
SARS-CoV-2 (edit) putative protein ORF3c (edit) P0DTG1
SARS-CoV-2 (edit) Non-structural protein 11 [SARS CoV-2] (edit) YP_009725312 P0DTC1-PRO_0000449645
SARS-CoV-2 (edit) ORF3b protein [SARS-CoV-2] (edit) P0DTF1
SARS-CoV-2 (edit) ORF9c protein [SARS CoV-2] (edit) P0DTD3
SARS-CoV-2 (edit) S1 Subunit of Spike Protein (edit) P0DTC2-PRO_0000449647
SARS-CoV-2 (edit) S2 Subunit of Spike Protein (edit) P0DTC2-PRO_0000449648
SARS-CoV-2 (edit) S2' Subunit of Spike Protein (edit) P0DTC2-PRO_0000449649
SARS-CoV-2 (edit) Non-structural protein 10 [SARS CoV-2] (edit) YP_009725306 P0DTC1-PRO_0000449644
SARS-CoV-2 (edit) Non-structural protein 10 [SARS CoV-2] (edit) YP_009725306 P0DTD1-PRO_0000449628
SARS-CoV-2 (edit) non-structural protein 15 [SARS-CoV-2] (edit) YP_009725310 P0DTD1-PRO_0000449632
SARS-CoV-2 (edit) non-structural protein 16 [SARS-CoV-2] (edit) YP_009725311 P0DTD1-PRO_0000449633
SARS-CoV-2 (edit) Papain-like proteinase [SARS-CoV-2] (edit) YP_009725299.1 P0DTC1-PRO_0000449637
SARS-CoV-2 (edit) Papain-like proteinase [SARS-CoV-2] (edit) YP_009725299.1 P0DTD1-PRO_0000449621
SARS-CoV-2 (edit) non-structural protein 5 [SARS-CoV-2] (edit) YP_009725301 P0DTC1-PRO_0000449639
SARS-CoV-2 (edit) non-structural protein 5 [SARS-CoV-2] (edit) YP_009725301 P0DTD1-PRO_0000449623
SARS-CoV-2 (edit) nucleocapsid protein [SARS-CoV-2] (edit) YP_009724397.2 P0DTC9
SARS-CoV-2 (edit) spike glycoprotein [SARS-CoV-2] (edit) YP_009724390.1 P0DTC2
SARS-CoV-2 (edit) orf1ab polyprotein [SARS-Cov 2] (edit) YP_009724389.1 P0DTD1
SARS-CoV-2 (edit) Viroporin 3a [SARS-CoV-2] (edit) YP_009724391.1 P0DTC3
SARS-CoV-2 (edit) envelope protein [SARS-CoV-2] (edit) YP_009724392.1 P0DTC4
SARS-CoV-2 (edit) membrane protein [SARS-CoV-2] (edit) YP_009724393.1 P0DTC5
SARS-CoV-2 (edit) non-structural protein 6 [SARS-CoV-2] (edit) P0DTC1-PRO_0000449640
SARS-CoV-2 (edit) non-structural protein 6 [SARS-CoV-2] (edit) P0DTD1-PRO_0000449624
SARS-CoV-2 (edit) ORF1a polyprotein (edit) YP_009725295.1 P0DTC1
SARS-CoV-2 (edit) Protein 7a [SARS-CoV-2] (edit) YP_009724395.1 P0DTC7
SARS-CoV-2 (edit) Protein non-structural 7b [SARS-CoV-2] (edit) YP_009725318.1 P0DTD8
SARS-CoV-2 (edit) ORF8 protein [SARS-CoV-2] (edit) YP_009724396.1 P0DTC8
SARS-CoV-2 (edit) Non-structural protein 2 [SARS CoV-2] (edit) P0DTC1-PRO_0000449636
SARS-CoV-2 (edit) Non-structural protein 2 [SARS CoV-2] (edit) P0DTD1-PRO_0000449620
SARS-CoV-2 (edit) ORF6 protein [SARS-CoV-2] (edit) YP_009724394.1 P0DTC6
SARS-CoV-2 (edit) ORF10 protein [SARS-CoV-2] (edit) YP_009725255.1 A0A663DJA2
SARS-CoV-2 (edit) Protein ORF9b [SARS-CoV-2] (edit) P0DTD2
SARS-CoV-2 (edit) Non-structural protein 9 [SARS-CoV-2] (edit) P0DTC1-PRO_0000449643
SARS-CoV-2 (edit) Non-structural protein 9 [SARS-CoV-2] (edit) P0DTD1-PRO_0000449627
SARS-CoV-2 (edit) Host translation inhibitor nsp1 [SARS-CoV-2] (edit) P0DTC1-PRO_0000449635
SARS-CoV-2 (edit) Host translation inhibitor nsp1 [SARS-CoV-2] (edit) P0DTD1-PRO_0000449619
SARS-CoV-2 (edit) Non-structural protein 4 [SARS-CoV-2] (edit) P0DTC1-PRO_0000449638
SARS-CoV-2 (edit) Non-structural protein 4 [SARS-CoV-2] (edit) P0DTD1-PRO_0000449622
SARS-CoV-2 (edit) Non-structural protein 7 [SARS-CoV-2] (edit) P0DTC1-PRO_0000449641
SARS-CoV-2 (edit) Non-structural protein 7 [SARS-CoV-2] (edit) P0DTD1-PRO_0000449625
SARS-CoV-2 (edit) RNA-directed RNA polymerase [SARS-CoV-2] (edit) YP_009725307 P0DTD1-PRO_0000449629
SARS-CoV-2 (edit) Non-structural protein 14 [SARS-CoV-2] (edit) YP_009725309 P0DTD1-PRO_0000449631
SARS-CoV-2 (edit) Helicase [SARS-CoV-2] (edit) YP_009725308 P0DTD1-PRO_0000449630
SARS-CoV-2 (edit) Non-structural protein nsp8 [SARS-CoV-2] (edit) P0DTC1-PRO_0000449642
SARS-CoV-2 (edit) Non-structural protein nsp8 [SARS-CoV-2] (edit) P0DTD1-PRO_0000449626
SARS-CoV-1 (edit) Envelope small membrane protein [SARS-Cov] (edit) NP_828854.1 P59637
SARS-CoV-1 (edit) Non-structural protein NS6 [SARS-Cov] (edit) NP_828856.1 P59634
SARS-CoV-1 (edit) Protein 9b [SARS-Cov] (edit) NP_828859.1 P59636
SARS-CoV-1 (edit) Protein 7a [SARS-Cov] (edit) NP_828857.1 P59635
SARS-CoV-1 (edit) Protein non-structural 7b [SARS-Cov] (edit) NP_849175.1 Q7TFA1
SARS-CoV-1 (edit) Protein 3a [SARS-Cov] (edit) NP_828852.2 P59632
SARS-CoV-1 (edit) Membrane protein [SARS-Cov] (edit) NP_828855.1 P59596
SARS-CoV-1 (edit) Non-structural protein 3b [SARS-Cov] (edit) NP_828853.1 P59633
SARS-CoV-1 (edit) replicase polyprotein 1ab [SARS-Cov] (edit) P0C6X7
SARS-CoV-1 (edit) 2'-O-methyltransferase [SARS-Cov] (edit)
SARS-CoV-1 (edit) 3C-like proteinase [SARS-Cov] (edit)
SARS-CoV-1 (edit) non-structural protein 9 [SARS-Cov] (edit)
SARS-CoV-1 (edit) nucleoprotein [SARS-Cov] (edit) P59595
SARS-CoV-1 (edit) spike glycoprotein [SARS-Cov] (edit) NP_828851.1 P59594
SARS-CoV-1 (edit) spike protein S2 [SARS-Cov] (edit)
SARS-CoV-1 (edit) non-structural protein 7 [SARS-Cov] (edit)
SARS-CoV-1 (edit) uridylate-specific endoribonuclease [SARS-Cov] (edit)
SARS-CoV-1 (edit) non-structural protein 8 [SARS-Cov] (edit)
SARS-CoV-1 (edit) papain-like proteinase [SARS-Cov] (edit)
SARS-CoV-1 (edit) host translation inhibitor nsp1 [SARS-Cov] (edit)
SARS-CoV-1 (edit) non-structural protein 10 [SARS-Cov] (edit)
SARS-CoV-1 (edit) Guanine-N7 methyltransferase [SARS-Cov] (edit)
SARS-CoV-1 (edit) RNA-directed RNA polymerase [SARS-Cov] (edit)
SARS-CoV-1 (edit) helicase [SARS-Cov] (edit)
SARS-CoV-1 (edit) non-structural protein 4 [SARS-Cov] (edit)
SARS-CoV-1 (edit) non-structural protein 6 [SARS-Cov] (edit)
SARS-CoV-1 (edit) non-structural protein 2 [SARS-Cov] (edit)
SARS-CoV-1 (edit) non-structural protein 11 [SARS-Cov] (edit)
SARS-CoV-1 (edit) protein non-structural 8a [SARS-Cov] (edit) NP_849176.1 Q7TFA0
SARS-CoV-1 (edit) protein non-structural 8b [SARS-Cov] (edit) NP_849177.1 Q80H93

Code examples

curl

curl -s https://raw.githubusercontent.com/egonw/SARS-CoV-2-Queries/master/sparql/virusProteinsSARSr.rq | sed 's+<lang/>+en+' > virusProteinsSARSr.rq

curl -H "Accept: text/tab-separated-values" -G https://query.wikidata.org/bigdata/namespace/wdq/sparql --data-urlencode query@virusProteinsSARSr.rq

This SPARQL query is available under CCZero.