SARS-CoV-2-Queries

allBetacoronaVirusesGraph.rq

Code examples: curl

SPARQL

#defaultView:Graph
SELECT ?parent ?parentLabel ?virus ?virusLabel ?ncbi WHERE {
  ?virus wdt:P171+ wd:Q16532287 .
  ?virus wdt:P171 ?parent .
  OPTIONAL { ?virus wdt:P685 ?ncbi }
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en,en". }
}

run or edit

Output

parent virus ncbi
Betacoronavirus (edit) SARSr-CoV (edit) 694009
Sarbecovirus (edit) SARSr-CoV (edit) 694009
Betacoronavirus (edit) SARSr-CoV (edit) 227859
Sarbecovirus (edit) SARSr-CoV (edit) 227859
Betacoronavirus (edit) Middle East respiratory syndrome coronavirus (edit) 1335626
Merbecovirus (edit) Middle East respiratory syndrome coronavirus (edit) 1335626
SARSr-CoV (edit) Bat SARS-like coronavirus WIV1 (edit) 1415852
Betacoronavirus (edit) Human coronavirus HKU1 (edit) 290028
Embecovirus (edit) Human coronavirus HKU1 (edit) 290028
Middle East respiratory syndrome coronavirus (edit) London1 novel CoV/2012 (edit)
Betacoronavirus (edit) Pipistrellus bat coronavirus HKU5 (edit) 694008
Merbecovirus (edit) Pipistrellus bat coronavirus HKU5 (edit) 694008
Betacoronavirus (edit) Rousettus bat coronavirus HKU9 (edit) 694006
Nobecovirus (edit) Rousettus bat coronavirus HKU9 (edit) 694006
Betacoronavirus (edit) Tylonycteris bat coronavirus HKU4 (edit) 694007
Merbecovirus (edit) Tylonycteris bat coronavirus HKU4 (edit) 694007
Betacoronavirus (edit) Murine coronavirus (edit) 694005
Embecovirus (edit) Murine coronavirus (edit) 694005
Betacoronavirus (edit) Betacoronavirus 1 (edit) 694003
Embecovirus (edit) Betacoronavirus 1 (edit) 694003
Betacoronavirus (edit) Hedgehog coronavirus 1 (edit) 1965093
Merbecovirus (edit) Hedgehog coronavirus 1 (edit) 1965093
Betacoronavirus (edit) Embecovirus (edit) 2509481
Betacoronavirus (edit) Hibecovirus (edit) 2509486
Betacoronavirus (edit) Merbecovirus (edit) 2509494
Betacoronavirus (edit) Nobecovirus (edit) 2509502
Betacoronavirus (edit) Sarbecovirus (edit) 2509511
Hibecovirus (edit) Bat Hp-betacoronavirus Zhejiang2013 (edit)
Embecovirus (edit) China Rattus coronavirus HKU24 (edit) 2501960
Nobecovirus (edit) Rousettus bat coronavirus GCCDC1 (edit) 2501962
SARSr-CoV (edit) SARS-CoV-2 (edit) 2697049
SARSr-CoV (edit) SARS-CoV-1 (edit)
SARSr-CoV (edit) SHC014-CoV (edit) 1415851
SARSr-CoV (edit) Bat SARS coronavirus Rp1 (edit) 349342
SARSr-CoV (edit) SARS coronavirus B024 (edit) 305407
Human coronavirus HKU1 (edit) Human coronavirus HKU1 (isolate N1) (edit) 443239
Embecovirus (edit) Rabbit Coronavirus HKU14 (edit) 1160968
Betacoronavirus (edit) Erinaceus coronavirus (edit)
Middle East respiratory syndrome coronavirus (edit) Coronavirus Neoromicia/PML-PHE1/RSA/2011 (edit) 1368314
Merbecovirus (edit) Erinaceus amurensis hedgehog coronavirus HKU31 (edit) 2664184
Betacoronavirus (edit) Hp-BatCoV HKU25 (edit)
SARSr-CoV (edit) RaTG13 (edit) 2709072
Embecovirus (edit) Myodes coronavirus 2JL14 (edit)
Nobecovirus (edit) Eidolon bat coronavirus C704 (edit)
SARSr-CoV (edit) Bat SARS CoV Rf1 (edit) 347537
SARSr-CoV (edit) Bat SARS CoV Rm1 (edit) 347536
SARSr-CoV (edit) Bat SARS CoV Rp3 (edit) 349344
SARSr-CoV (edit) RmYN02 (edit)
SARSr-CoV (edit) Civet SARS-CoV (edit)
SARSr-CoV (edit) RacCS203 (edit)
SARSr-CoV (edit) Rc-o319 (edit)
SARSr-CoV (edit) 16BO133 (edit)
SARSr-CoV (edit) BtKY72/Rhinolophus sp./Kenya/2007 (edit)
SARSr-CoV (edit) BtCoV/BM48-31/Rhi bla/Bulgaria/2008 (edit)
SARSr-CoV (edit) RpYN06 (edit)
SARSr-CoV (edit) RhGB01 (edit)
SARSr-CoV (edit) BANAL-52 (edit)
SARSr-CoV (edit) BANAL-103 (edit)

Code examples

curl

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

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

This SPARQL query is available under CCZero.