SARS-CoV-2-Queries

allCoronaVirusesGraph.rq

Code examples: curl

SPARQL

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

run or edit

Output

parent	virus	ncbi
Amalacovirus (edit)	Alphacoronavirus AMALF (edit)
Alphacoronavirus HKU33 (edit)	Tylonycteris robustula bat coronavirus HKU33 (edit)	2586420
Betacoronavirus (edit)	Human coronavirus HKU1 (edit)	290028
Betacoronavirus (edit)	Pipistrellus bat coronavirus HKU5 (edit)	694008
Betacoronavirus (edit)	Rousettus bat coronavirus HKU9 (edit)	694006
Betacoronavirus (edit)	Tylonycteris bat coronavirus HKU4 (edit)	694007
Betacoronavirus (edit)	Murine coronavirus (edit)	694005
Betacoronavirus (edit)	Betacoronavirus 1 (edit)	694003
Betacoronavirus (edit)	Hedgehog coronavirus 1 (edit)	1965093
Betacoronavirus (edit)	SARSr-CoV (edit)	694009
Betacoronavirus (edit)	SARSr-CoV (edit)	227859
Betacoronavirus (edit)	Middle East respiratory syndrome coronavirus (edit)	1335626
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
Betacoronavirus (edit)	Erinaceus coronavirus (edit)
Betacoronavirus (edit)	Hp-BatCoV HKU25 (edit)
Alphacoronavirus (edit)	Amalacovirus (edit)
Alphacoronavirus (edit)	porcine epidemic diarrhea virus (edit)	28295
Alphacoronavirus (edit)	Human coronavirus 229E (edit)	11137
Alphacoronavirus (edit)	Miniopterus Bat coronavirus 1 (edit)	694000
Alphacoronavirus (edit)	Miniopterus Bat coronavirus HKU8 (edit)	694001
Alphacoronavirus (edit)	Rhinolophus Bat coronavirus HKU2 (edit)	693998
Alphacoronavirus (edit)	Scotophilus Bat coronavirus 512 (edit)	693999
Alphacoronavirus (edit)	Alphacoronavirus 1 (edit)	693997
Alphacoronavirus (edit)	Bat coronavirus CDPHE15 (edit)	1913643
Alphacoronavirus (edit)	Bat coronavirus HKU10 (edit)	1244203
Alphacoronavirus (edit)	Mink coronavirus 1 (edit)	1913642
Alphacoronavirus (edit)	Colacovirus (edit)	2509477
Alphacoronavirus (edit)	Decacovirus (edit)	2509479
Alphacoronavirus (edit)	Duvinacovirus (edit)	2509480
Alphacoronavirus (edit)	Luchacovirus (edit)	2509492
Alphacoronavirus (edit)	Minacovirus (edit)	2509496
Alphacoronavirus (edit)	Minunacovirus (edit)	2509497
Alphacoronavirus (edit)	Myotacovirus (edit)	2509500
Alphacoronavirus (edit)	Nyctacovirus (edit)	2509503
Alphacoronavirus (edit)	Pedacovirus (edit)	2509505
Alphacoronavirus (edit)	Rhinacovirus (edit)	2509509
Alphacoronavirus (edit)	Setracovirus (edit)	2509512
Alphacoronavirus (edit)	Tegacovirus (edit)	2509514
Alphacoronavirus (edit)	human Coronavirus NL63 (edit)	277944
Alphacoronavirus (edit)	Soracovirus (edit)	2733306
Alphacoronavirus (edit)	Sunacovirus (edit)
Deltacoronavirus (edit)	Bulbul coronavirus HKU11 (edit)	574549
Deltacoronavirus (edit)	Porcine coronavirus HKU15 (edit)	1159905
Deltacoronavirus (edit)	Munia coronavirus HKU13 (edit)	1297661
Deltacoronavirus (edit)	Thrush coronavirus HKU12 (edit)	1297662
Deltacoronavirus (edit)	Common moorhen coronavirus HKU21 (edit)	1159902
Deltacoronavirus (edit)	Night heron coronavirus HKU19 (edit)	1159904
Deltacoronavirus (edit)	White-eye coronavirus HKU16 (edit)	1159907
Deltacoronavirus (edit)	Wigeon coronavirus HKU20 (edit)	1159908
Deltacoronavirus (edit)	Andecovirus (edit)	2509469
Deltacoronavirus (edit)	Buldecovirus (edit)	2509474
Deltacoronavirus (edit)	Herdecovirus (edit)	2509485
Deltacoronavirus (edit)	Moordecovirus (edit)	2509499
Deltacoronavirus (edit)	sparrow coronavirus HKU17 (edit)
Gammacoronavirus (edit)	Avian coronavirus (edit)	694014
Gammacoronavirus (edit)	Beluga whale coronavirus SW1 (edit)	694015
Gammacoronavirus (edit)	Cegacovirus (edit)	2509476
Gammacoronavirus (edit)	Igacovirus (edit)	2509487
Gammacoronavirus (edit)	Cetacean coronavirus (edit)
Gammacoronavirus (edit)	Brangacovirus (edit)
Human coronavirus HKU1 (edit)	Human coronavirus HKU1 (isolate N1) (edit)	443239
Tylonycteris bat coronavirus HKU4 (edit)	TyRo-CoV-162275 (edit)
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)
SARSr-CoV (edit)	Bat SARS-like coronavirus WIV1 (edit)	1415852
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
SARSr-CoV (edit)	RaTG13 (edit)	2709072
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
Coronavirus (edit)	porcine epidemic diarrhea virus (edit)	28295
Coronavirus (edit)	Human coronavirus 229E (edit)	11137
Coronavirus (edit)	human Coronavirus NL63 (edit)	277944
Middle East respiratory syndrome coronavirus (edit)	London1 novel CoV/2012 (edit)
Middle East respiratory syndrome coronavirus (edit)	Coronavirus Neoromicia/PML-PHE1/RSA/2011 (edit)	1368314
Coronavirus (edit)	Betacoronavirus (edit)	694002
Coronavirus (edit)	Alphacoronavirus (edit)	693996
Coronavirus (edit)	Deltacoronavirus (edit)	1159901
Coronavirus (edit)	Gammacoronavirus (edit)	694013
Colacovirus (edit)	Bat coronavirus CDPHE15 (edit)	1913643
Decacovirus (edit)	Alphacoronavirus CHB25 (edit)
Decacovirus (edit)	Alphacoronavirus WA3607 (edit)
Decacovirus (edit)	Bat coronavirus HKU10 (edit)	1244203
Decacovirus (edit)	Rhinolophus ferrumequinum alphacoronavirus HuB-2013 (edit)	2501926
Decacovirus (edit)	Rhinolophus sinicus bat coronavirus HKU32 (edit)	2586419
Decacovirus (edit)	Rousettus bat coronavirus HKU10 (edit)	1241933
Duvinacovirus (edit)	Human coronavirus 229E (edit)	11137
Luchacovirus (edit)	Lucheng Rn rat coronavirus (edit)	1508224
Minacovirus (edit)	Mink coronavirus 1 (edit)	1913642
Minacovirus (edit)	Ferret coronavirus (edit)	1264898
Minunacovirus (edit)	Miniopterus Bat coronavirus 1 (edit)	694000
Minunacovirus (edit)	Miniopterus Bat coronavirus HKU8 (edit)	694001
Myotacovirus (edit)	Myotis ricketti alphacoronavirus Sax-2011 (edit)	2501927
Nyctacovirus (edit)	Alphacoronavirus HKU33 (edit)
Nyctacovirus (edit)	Alphacoronavirus WA2028 (edit)
Nyctacovirus (edit)	Nyctalus velutinus alphacoronavirus SC-2013 (edit)	2501928
Nyctacovirus (edit)	Pipistrellus kuhlii coronavirus 3398 (edit)
Pedacovirus (edit)	Alphacoronavirus BT020 (edit)
Pedacovirus (edit)	Alphacoronavirus WA1087 (edit)
Pedacovirus (edit)	porcine epidemic diarrhea virus (edit)	28295
Pedacovirus (edit)	Scotophilus Bat coronavirus 512 (edit)	693999
Rhinacovirus (edit)	Rhinolophus Bat coronavirus HKU2 (edit)	693998
Rhinacovirus (edit)	SADS coronavirus (edit)	2032731
Setracovirus (edit)	NL63-related bat coronavirus strain BtKYNL63-9b (edit)	2501929
Setracovirus (edit)	human Coronavirus NL63 (edit)	277944
Tegacovirus (edit)	Canine coronavirus HuPn-2018 (edit)
Tegacovirus (edit)	Alphacoronavirus 1 (edit)	693997
Embecovirus (edit)	Human coronavirus HKU1 (edit)	290028
Embecovirus (edit)	Murine coronavirus (edit)	694005
Embecovirus (edit)	Betacoronavirus 1 (edit)	694003
Embecovirus (edit)	China Rattus coronavirus HKU24 (edit)	2501960
Embecovirus (edit)	Rabbit Coronavirus HKU14 (edit)	1160968
Embecovirus (edit)	Myodes coronavirus 2JL14 (edit)
Hibecovirus (edit)	Bat Hp-betacoronavirus Zhejiang2013 (edit)
Merbecovirus (edit)	Pipistrellus bat coronavirus HKU5 (edit)	694008
Merbecovirus (edit)	Tylonycteris bat coronavirus HKU4 (edit)	694007
Merbecovirus (edit)	Hedgehog coronavirus 1 (edit)	1965093
Merbecovirus (edit)	Middle East respiratory syndrome coronavirus (edit)	1335626
Merbecovirus (edit)	Erinaceus amurensis hedgehog coronavirus HKU31 (edit)	2664184
Nobecovirus (edit)	Rousettus bat coronavirus HKU9 (edit)	694006
Nobecovirus (edit)	Rousettus bat coronavirus GCCDC1 (edit)	2501962
Nobecovirus (edit)	Eidolon bat coronavirus C704 (edit)
Sarbecovirus (edit)	SARSr-CoV (edit)	694009
Sarbecovirus (edit)	SARSr-CoV (edit)	227859
Sarbecovirus (edit)	SARS-CoV-2 (edit)	2697049
Andecovirus (edit)	Wigeon coronavirus HKU20 (edit)	1159908
Buldecovirus (edit)	Bulbul coronavirus HKU11 (edit)	574549
Buldecovirus (edit)	Porcine coronavirus HKU15 (edit)	1159905
Buldecovirus (edit)	Munia coronavirus HKU13 (edit)	1297661
Buldecovirus (edit)	Common moorhen coronavirus HKU21 (edit)	1159902
Buldecovirus (edit)	White-eye coronavirus HKU16 (edit)	1159907
Buldecovirus (edit)	Quail coronavirus UAE-HKU30 (edit)	2078581
Buldecovirus (edit)	FalCoV UAE-HKU27 (edit)	2078576
Herdecovirus (edit)	Night heron coronavirus HKU19 (edit)	1159904
Moordecovirus (edit)	Common moorhen coronavirus HKU21 (edit)	1159902
Cegacovirus (edit)	Beluga whale coronavirus SW1 (edit)	694015
Igacovirus (edit)	Avian coronavirus (edit)	694014
Igacovirus (edit)	Avian coronavirus 9203 (edit)
Igacovirus (edit)	Duck coronavirus 2714 (edit)
SARS-CoV-2 (edit)	variants of SARS-CoV-2 (edit)
Soracovirus (edit)	Sorex araneus coronavirus T14 (edit)
Sunacovirus (edit)	Suncus murinus coronavirus X74 (edit)
Brangacovirus (edit)	Goose coronavirus CB17 (edit)

Code examples

curl

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

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

This SPARQL query is available under CCZero.

This site is open source. Improve this page.