SARS-CoV-2-Queries

virusProteins.rq

Code examples: curl

SPARQL

SELECT ?protein ?proteinLabel ?short ?refseq ?uniprot ?guideToPharma WHERE {
  ?protein wdt:P703 wd:Q82069695 ; wdt:P31 wd:Q8054 .
  OPTIONAL { ?protein wdt:P637 ?refseq }
  OPTIONAL { ?protein wdt:P352 ?uniprot }
  OPTIONAL { ?protein wdt:P5458 ?guideToPharma }
  OPTIONAL { ?protein wdt:P1813 ?short }
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en,en". }
} ORDER BY ASC(?protein) ASC(?uniprot)

run or edit

Output

protein short refseq uniprot guideToPharma
putative protein ORF3c (edit) P0DTG1
Non-structural protein 11 [SARS CoV-2] (edit) nsp11
ORF3b protein [SARS-CoV-2] (edit) P0DTF1
ORF9c protein [SARS CoV-2] (edit) P0DTD3
Non-structural protein 10 [SARS CoV-2] (edit) nsp10
non-structural protein 15 [SARS-CoV-2] (edit) nsp15
non-structural protein 16 [SARS-CoV-2] (edit) nsp16 P0DTD1-PRO_0000449633
Papain-like proteinase [SARS-CoV-2] (edit) nsp3 YP_009725299.1 P0DTC1-PRO_0000449637
Papain-like proteinase [SARS-CoV-2] (edit) nsp3 YP_009725299.1 P0DTD1-PRO_0000449621
non-structural protein 5 [SARS-CoV-2] (edit) nsp5 YP_009725301 P0DTC1-PRO_0000449639 3111
non-structural protein 5 [SARS-CoV-2] (edit) nsp5 YP_009725301 P0DTD1-PRO_0000449623 3111
nucleocapsid protein [SARS-CoV-2] (edit) N YP_009724397.2 P0DTC9 3121
spike glycoprotein [SARS-CoV-2] (edit) S YP_009724390.1 P0DTC2 3114
orf1ab polyprotein [SARS-Cov 2] (edit) QHD43415 P0DTD1 3125
Viroporin 3a [SARS-CoV-2] (edit) YP_009724391.1 P0DTC3 3115
envelope protein [SARS-CoV-2] (edit) YP_009724392.1 P0DTC4 3116
membrane protein [SARS-CoV-2] (edit) YP_009724393.1 P0DTC5 3117
non-structural protein 6 [SARS-CoV-2] (edit) nsp6 P0DTC1-PRO_0000449640 3118
non-structural protein 6 [SARS-CoV-2] (edit) nsp6 P0DTD1-PRO_0000449624 3118
ORF1a polyprotein (edit) P0DTC1 3124
Protein 7a [SARS-CoV-2] (edit) YP_009724395.1 P0DTC7 3119
Protein non-structural 7b [SARS-CoV-2] (edit) YP_009725318.1 P0DTD8 3123
ORF8 protein [SARS-CoV-2] (edit) YP_009724396.1 P0DTC8 3120
Non-structural protein 2 [SARS CoV-2] (edit) nsp2 P0DTC1-PRO_0000449636
Non-structural protein 2 [SARS CoV-2] (edit) nsp2 P0DTD1-PRO_0000449620
ORF6 protein [SARS-CoV-2] (edit) YP_009724394.1 P0DTC6
ORF10 protein [SARS-CoV-2] (edit) YP_009725255.1 A0A663DJA2
Protein ORF9b [SARS-CoV-2] (edit) P0DTD2 3122
Non-structural protein 9 [SARS-CoV-2] (edit) nsp9 P0DTC1-PRO_0000449643
Non-structural protein 9 [SARS-CoV-2] (edit) nsp9 P0DTD1-PRO_0000449627
Host translation inhibitor nsp1 [SARS-CoV-2] (edit) nsp1 P0DTC1-PRO_0000449635
Host translation inhibitor nsp1 [SARS-CoV-2] (edit) nsp1 P0DTD1-PRO_0000449619
Non-structural protein 4 [SARS-CoV-2] (edit) nsp4 P0DTC1-PRO_0000449638
Non-structural protein 4 [SARS-CoV-2] (edit) nsp4 P0DTD1-PRO_0000449622
Non-structural protein 7 [SARS-CoV-2] (edit) nsp7 P0DTC1-PRO_0000449641
Non-structural protein 7 [SARS-CoV-2] (edit) nsp7 P0DTD1-PRO_0000449625
RNA-directed RNA polymerase [SARS-CoV-2] (edit) nsp12 P0DTD1-PRO_0000449629
Non-structural protein 14 [SARS-CoV-2] (edit) nsp14 P0DTD1-PRO_0000449631
Helicase [SARS-CoV-2] (edit) nsp13
Uncharacterized protein 14 (edit) P0DTD3
Non-structural protein nsp8 [SARS-CoV-2] (edit) nsp8 P0DTC1-PRO_0000449642
Non-structural protein nsp8 [SARS-CoV-2] (edit) nsp8 P0DTD1-PRO_0000449626

Code examples

curl

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

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

This SPARQL query is available under CCZero.