SARS-CoV-2-Queries

virusGenesAll.rq

Code examples: curl

SPARQL

SELECT ?virus ?virusLabel ?gene ?geneLabel ?ncbigene 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
  }
  ?gene wdt:P703 ?virus ; wdt:P31 wd:Q7187 .
  OPTIONAL { ?gene wdt:P351 ?ncbigene }
  SERVICE wikibase:label { bd:serviceParam wikibase:language "pt,en". }
} ORDER BY ?virus ?ncbigene ?gene

run or edit

Output

virus	gene	ncbigene
Coronavírus humano 229E (edit)	Record to support submission of GeneRIFs for a gene not in Gene (Coronavirus 229E; Human coronavirus (STRAIN 229E); Human coronavirus serogroup 229E; Human coronavirus strain 229E). (edit)	2828637
Coronavírus humano 229E (edit)	surface glycoprotein (edit)	918758
Coronavírus humano 229E (edit)	4a protein (edit)	918759
Coronavírus humano 229E (edit)	4b protein (edit)	918760
Coronavírus humano 229E (edit)	envelope protein (edit)	918761
Coronavírus humano 229E (edit)	membrane protein (edit)	918762
Coronavírus humano 229E (edit)	nucleocapsid protein (edit)	918763
Coronavírus humano 229E (edit)	replicase polyprotein 1a;replicase polyprotein 1ab (edit)	918764
Coronavírus humano HKU1 (edit)	nucleocapsid phosphoprotein (edit)	3200423
Coronavírus humano HKU1 (edit)	ORF8 (edit)	3200424
Coronavírus humano HKU1 (edit)	hemagglutinin-esterase glycoprotein (edit)	3200425
Coronavírus humano HKU1 (edit)	spike glycoprotein (edit)	3200426
Coronavírus humano HKU1 (edit)	non-structural protein (edit)	3200427
Coronavírus humano HKU1 (edit)	membrane glycoprotein (edit)	3200428
Coronavírus humano HKU1 (edit)	ORF1a polyprotein;ORF1ab polyprotein (edit)	3200429
Coronavírus humano HKU1 (edit)	envelope protein (edit)	3200430
Coronavírus humano HKU1 (edit)	Record to support submission of GeneRIFs for a gene not in Gene (CoV-HKU1; Human CoV/HKU1). (edit)	3293713
Coronavírus humano OC43 (edit)	Record to support submission of GeneRIFs for a gene not in Gene (Human coronavirus (strain OC43); Human coronavirus strain OC43). (edit)	2829172
Coronavírus humano OC43 (edit)	ns2 (edit)	39105215
Coronavírus humano OC43 (edit)	hemagglutinin-esterase (edit)	39105216
Coronavírus humano OC43 (edit)	envelope protein (edit)	39105217
Coronavírus humano OC43 (edit)	spike surface glycoprotein (edit)	39105218
Coronavírus humano OC43 (edit)	ns12.9 (edit)	39105219
Coronavírus humano OC43 (edit)	membrane protein (edit)	39105220
Coronavírus humano OC43 (edit)	I protein;nucleocapsid protein (edit)	39105221
Coronavírus humano OC43 (edit)	ORF1a polyprotein;ORF1ab polyprotein (edit)	39105222
SARS-CoV (edit)	E2 glycoprotein precursor (edit)	1489668
SARS-CoV (edit)	hypothetical protein sars3a (edit)	1489669
SARS-CoV (edit)	hypothetical protein sars3b (edit)	1489670
SARS-CoV (edit)	protein E (edit)	1489671
SARS-CoV (edit)	matrix protein (edit)	1489672
SARS-CoV (edit)	hypothetical protein sars6 (edit)	1489673
SARS-CoV (edit)	hypothetical protein sars7a (edit)	1489674
SARS-CoV (edit)	hypothetical protein sars7b (edit)	1489675
SARS-CoV (edit)	hypothetical protein sars8a (edit)	1489676
SARS-CoV (edit)	hypothetical protein sars8b (edit)	1489677
SARS-CoV (edit)	nucleocapsid protein (edit)	1489678
SARS-CoV (edit)	hypothetical protein sars9b (edit)	1489679
SARS-CoV (edit)	orf1a polyprotein (pp1a);orf1ab polyprotein (pp1ab) (edit)	1489680
SARS-CoV (edit)	Record to support submission of GeneRIFs for a gene not in Gene (Human coronavirus (strain SARS); SARS-like coronavirus; SARS-related coronavirus). (edit)	8673700
coronavírus da síndrome respiratória do Oriente Médio (edit)	spike protein (edit)	14254594
coronavírus da síndrome respiratória do Oriente Médio (edit)	NS3 protein (edit)	14254595
coronavírus da síndrome respiratória do Oriente Médio (edit)	NS4A protein (edit)	14254596
coronavírus da síndrome respiratória do Oriente Médio (edit)	NS4B protein (edit)	14254597
coronavírus da síndrome respiratória do Oriente Médio (edit)	NS5 protein (edit)	14254598
coronavírus da síndrome respiratória do Oriente Médio (edit)	envelope protein (edit)	14254599
coronavírus da síndrome respiratória do Oriente Médio (edit)	membrane protein (edit)	14254600
coronavírus da síndrome respiratória do Oriente Médio (edit)	nucleocapsid protein (edit)	14254601
coronavírus da síndrome respiratória do Oriente Médio (edit)	1A polyprotein;1AB polyprotein (edit)	14254602
coronavírus da síndrome respiratória do Oriente Médio (edit)	Record to support submission of GeneRIFs for a gene not in Gene (MERS coronavirus; MERS virus; Middle East Respiratory Syndrome Coronavirus (MERS-CoV); Middle East respiratory syndrome coronavirus). (edit)	18938949
coronavírus da síndrome respiratória do Oriente Médio (edit)	ORF8b protein (edit)	19910005
coronavírus da síndrome respiratória aguda grave 2 (edit)	ORF3d (edit)
coronavírus da síndrome respiratória aguda grave 2 (edit)	Record to support submission of GeneRIFs for a gene not in Gene (COVID-19 virus; HCoV-19; Human coronavirus 2019; SARS-2; SARS-CoV2; SARS2). (edit)	43562271
coronavírus da síndrome respiratória aguda grave 2 (edit)	surface glycoprotein (edit)	43740568
coronavírus da síndrome respiratória aguda grave 2 (edit)	ORF3a protein-encoding gene (edit)	43740569
coronavírus da síndrome respiratória aguda grave 2 (edit)	envelope protein (edit)	43740570
coronavírus da síndrome respiratória aguda grave 2 (edit)	membrane glycoprotein (edit)	43740571
coronavírus da síndrome respiratória aguda grave 2 (edit)	ORF6 protein (edit)	43740572
coronavírus da síndrome respiratória aguda grave 2 (edit)	ORF7a protein (edit)	43740573
coronavírus da síndrome respiratória aguda grave 2 (edit)	ORF7b (edit)	43740574
coronavírus da síndrome respiratória aguda grave 2 (edit)	nucleocapsid phosphoprotein (edit)	43740575
coronavírus da síndrome respiratória aguda grave 2 (edit)	ORF10 protein (edit)	43740576
coronavírus da síndrome respiratória aguda grave 2 (edit)	ORF8 protein (edit)	43740577
coronavírus da síndrome respiratória aguda grave 2 (edit)	ORF1a polyprotein;ORF1ab polyprotein (edit)	43740578
Coronavírus humano NL63 (edit)	spike protein (edit)	2943499
Coronavírus humano NL63 (edit)	protein 3 (edit)	2943500
Coronavírus humano NL63 (edit)	ORF1a polyprotein;ORF1ab polyprotein (edit)	2943501
Coronavírus humano NL63 (edit)	envelope protein (edit)	2943502
Coronavírus humano NL63 (edit)	membrane protein (edit)	2943503
Coronavírus humano NL63 (edit)	nucleocapsid protein (edit)	2943504
Coronavírus humano NL63 (edit)	Record to support submission of GeneRIFs for a gene not in Gene (Coronavirus NL63; Human coronavirus NL). (edit)	3293659

Code examples

curl

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

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

This SPARQL query is available under CCZero.

This site is open source. Improve this page.