SARS-CoV-2-Queries

virusProteinsAll.rq

Code examples: curl

SPARQL

SELECT ?virus ?virusLabel ?protein ?proteinLabel ?refseq ?uniprot WHERE {
  VALUES ?virus {
    wd:Q82069695 # SARS-CoV-2
    wd:Q16983360 # HKU1
    wd:Q16991954 # OC43
    wd:Q8351095  # NL63 
    wd:Q16983356 # 229E
    wd:Q4902157  # MERS-CoV
    wd:Q278567   # 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 ?virus

run or edit

Output

virus protein refseq uniprot
Human coronavirus 229E (edit) Non-structural protein 4a (edit) NP_073552.1 P19739
Human coronavirus 229E (edit) Non-structural protein 4b (edit) NP_073553.1 P19740
Human coronavirus 229E (edit) Spike glycoprotein (edit) NP_073551.1 P15423
Human coronavirus 229E (edit) Membrane protein (edit) NP_073555.1 P15422
Human coronavirus 229E (edit) Nucleoprotein (edit) NP_073556.1 P15130
Human coronavirus 229E (edit) Envelope small membrane protein (edit) NP_073554.1 P19741
Human coronavirus 229E (edit) Replicase polyprotein 1a (edit) NP_073550.1 P0C6U2
Human coronavirus 229E (edit) Replicase polyprotein 1ab (edit) NP_073549.1 P0C6X1
Human coronavirus HKU1 (edit) Protein I (edit) YP_173243.1 Q5MQC5
Human coronavirus HKU1 (edit) Spike glycoprotein (edit) E0YJ44
Human coronavirus HKU1 (edit) Non-structural protein 4 (edit) YP_173239.1 Q5MQC9
Human coronavirus HKU1 (edit) Spike glycoprotein (edit) YP_173238.1 Q5MQD0
Human coronavirus HKU1 (edit) Envelope small membrane protein (edit) YP_173240.1 Q5MQC8
Human coronavirus HKU1 (edit) Nucleoprotein (edit) YP_173242.1 Q5MQC6
Human coronavirus HKU1 (edit) Replicase polyprotein 1ab (edit) YP_173236.1 P0C6X2
Human coronavirus HKU1 (edit) Hemagglutinin-esterase (edit) YP_173237.1 Q5MQD1
Human coronavirus HKU1 (edit) Membrane protein (edit) YP_173241.1 Q5MQC7
Human coronavirus OC43 (edit) hemagglutinin-esterase (edit) YP_009555240.1 P30215
Human coronavirus OC43 (edit) envelope protein (edit) YP_009555243.1
Human coronavirus OC43 (edit) ns2 (edit) YP_009555239.1
Human coronavirus OC43 (edit) ns12.9 (edit) YP_009555242.1
Human coronavirus OC43 (edit) nucleocapsid protein (edit) YP_009555245.1
Human coronavirus OC43 (edit) spike surface glycoprotein (edit) YP_009555241.1
Human coronavirus OC43 (edit) Orf1ab (edit) YP_009555238.1
Human coronavirus OC43 (edit) membrane protein (edit) YP_009555244.1
severe acute respiratory syndrome-related coronavirus (edit) Protein 3a [SARS-Cov] (edit) NP_828852.2 P59632
severe acute respiratory syndrome-related coronavirus (edit) Replicase polyprotein 1a (edit) P0C6U8
Middle East respiratory syndrome coronavirus (edit) spike glycoprotein (edit) YP_009047204.1 K9N5Q8
Middle East respiratory syndrome coronavirus (edit) nucleoprotein (edit) YP_009047211.1 K9N4V7
Middle East respiratory syndrome coronavirus (edit) NS3 protein (edit) YP_009047205.1 K9N796
Middle East respiratory syndrome coronavirus (edit) NS4B protein (edit) YP_009047207.1 K9N643
Middle East respiratory syndrome coronavirus (edit) Envelope small membrane protein (edit) K9N5R3
Middle East respiratory syndrome coronavirus (edit) Replicase polyprotein 1ab (edit) K9N7C7
Middle East respiratory syndrome coronavirus (edit) Non-structural protein ORF5 (edit) K9N7D2
Middle East respiratory syndrome coronavirus (edit) Replicase polyprotein 1a (edit) K9N638
Middle East respiratory syndrome coronavirus (edit) Membrane protein (edit) K9N7A1
SARS-CoV-2 (edit) Non-structural protein 10 [SARS CoV-2] (edit)
SARS-CoV-2 (edit) non-structural protein 15 [SARS-CoV-2] (edit)
SARS-CoV-2 (edit) non-structural protein 16 [SARS-CoV-2] (edit) P0DTD1-PRO_0000449633
SARS-CoV-2 (edit) Papain-like proteinase [SARS-CoV-2] (edit) YP_009725299.1 P0DTD1-PRO_0000449621
SARS-CoV-2 (edit) Papain-like proteinase [SARS-CoV-2] (edit) YP_009725299.1 P0DTC1-PRO_0000449637
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) QHD43415 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) 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) P0DTD1-PRO_0000449620
SARS-CoV-2 (edit) Non-structural protein 2 [SARS CoV-2] (edit) P0DTC1-PRO_0000449636
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) P0DTD1-PRO_0000449629
SARS-CoV-2 (edit) Non-structural protein 14 [SARS-CoV-2] (edit) P0DTD1-PRO_0000449631
SARS-CoV-2 (edit) Helicase [SARS-CoV-2] (edit)
SARS-CoV-2 (edit) Uncharacterized protein 14 (edit) P0DTD3
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-2 (edit) putative protein ORF3c (edit) P0DTG1
SARS-CoV-2 (edit) Non-structural protein 11 [SARS CoV-2] (edit)
SARS-CoV-2 (edit) ORF3b protein [SARS-CoV-2] (edit) P0DTF1
SARS-CoV-2 (edit) ORF9c protein [SARS CoV-2] (edit) P0DTD3
Human Coronavirus NL63 (edit) Spike glycoprotein [NL63] (edit) YP_003767.1 Q6Q1S2
Human Coronavirus NL63 (edit) Non-structural protein 3 (edit) YP_003768.1 Q6Q1S1
Human Coronavirus NL63 (edit) Envelope small membrane protein (edit) YP_003769.1 Q6Q1S0
Human Coronavirus NL63 (edit) Nucleoprotein (edit) YP_003771.1 Q6Q1R8
Human Coronavirus NL63 (edit) Membrane protein (edit) YP_003770.1 Q6Q1R9
Human Coronavirus NL63 (edit) Replicase polyprotein 1ab (edit) YP_003766.2 P0C6X5

Code examples

curl

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

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

This SPARQL query is available under CCZero.