SARS-CoV-2-Queries

allCoronaViruses.rq

Code examples: curl

SPARQL

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

run or edit

Output

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

Code examples

curl

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

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

This SPARQL query is available under CCZero.

This site is open source. Improve this page.