contig_metadata
23 rows where bioproject = "PRJNA1059246" and tax_kingdom = "Orthornavirae"
This data as json, CSV (advanced)
| Link | rowid ▼ | query | bioproject | node | length | coverage | rel_abundance | taxname_lca | taxid_lca | taxoncategory | taxoncategorysimple | bits | evalue | lowcoverage_flag | analysis_used | target | taxid | gene | allele | pident | sumperc_cov | alnlen | mismatch | qcov | gapopen | qstart | qend | tstart | tend | target_title | analysis | sumalnlen | maxbits | bits_percmax | tax_superkingdom | tax_clade | tax_kingdom | tax_phylum | tax_class | tax_order | tax_family | tax_genus | tax_species |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 177086 | 177086 | PRJNA1059246_P_NODE_39161_length_341_cov_1.500000_g38535_i0 | PRJNA1059246 | 39161 | 341 | 1.5 | 5.115 | Ripigleb virus | 3130924 | Viruses | Viruses | 383 | 1.01e-101 | NTclustered | gi|2717321151|gb|PP173226.1| | 3130924 | g38535 | i0 | 87.842 | 214.24926686217 | 329 | 37 | 96 | 2 | 1 | 328 | 8521 | 8195 | MAG: Ripigleb virus isolate KCAP3_k141_261307 genomic sequence | blastn | 73059 | 383 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Marnaviridae | Ripigleb virus | |||
| 1451492 | 1451492 | PRJNA1059246_P_NODE_23982_length_458_cov_1.600000_g23358_i0 | PRJNA1059246 | 23982 | 458 | 1.6 | 7.328 | Cardiovirus rueckerti | 3427730 | Viruses | Viruses | 846 | 0 | NTclustered | gi|1943777380|gb|MT250508.1| | 12104 | g23358 | i0 | 100 | 5.95414847161572 | 458 | 0 | 100 | 0 | 1 | 458 | 5005 | 4548 | Encephalomyocarditis virus isolate FRA/SIG/1/2013, complete genome | blastn | 2727 | 846 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Cardiovirus | Cardiovirus rueckerti | ||
| 1451986 | 1451986 | PRJNA1059246_P_NODE_6082_length_1003_cov_2.043011_g5635_i0 | PRJNA1059246 | 6082 | 1003 | 2.043011 | 20.49140033 | Cardiovirus rueckerti | 3427730 | Viruses | Viruses | 1847 | 0 | NTclustered | gi|1943777380|gb|MT250508.1| | 12104 | g5635 | i0 | 99.9 | 54.8683948155533 | 1003 | 1 | 100 | 0 | 1 | 1003 | 7281 | 6279 | Encephalomyocarditis virus isolate FRA/SIG/1/2013, complete genome | blastn | 55033 | 1847 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Cardiovirus | Cardiovirus rueckerti | ||
| 4003503 | 4003503 | PRJNA1059246_P_NODE_38924_length_342_cov_2.252788_g38298_i0 | PRJNA1059246 | 38924 | 342 | 2.252788 | 7.70453496 | Cardiovirus rueckerti | 3427730 | Viruses | Viruses | 632 | 9.079999999999999e-177 | NTclustered | gi|1943777380|gb|MT250508.1| | 12104 | g38298 | i0 | 100 | 40 | 342 | 0 | 100 | 0 | 1 | 342 | 5644 | 5985 | Encephalomyocarditis virus isolate FRA/SIG/1/2013, complete genome | blastn | 13680 | 632 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Cardiovirus | Cardiovirus rueckerti | ||
| 4003543 | 4003543 | PRJNA1059246_P_NODE_42604_length_323_cov_1.900000_g41978_i0 | PRJNA1059246 | 42604 | 323 | 1.9 | 6.137 | Cardiovirus rueckerti | 3427730 | Viruses | Viruses | 592 | 1.4499999999999999e-164 | NTclustered | gi|1943777380|gb|MT250508.1| | 12104 | g41978 | i0 | 99.69 | 5.95665634674923 | 323 | 1 | 100 | 0 | 1 | 323 | 3097 | 3419 | Encephalomyocarditis virus isolate FRA/SIG/1/2013, complete genome | blastn | 1924 | 592 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Cardiovirus | Cardiovirus rueckerti | ||
| 4003651 | 4003651 | PRJNA1059246_P_NODE_4_length_8291_cov_108.076661_g3_i0 | PRJNA1059246 | 4 | 8291 | 108.076661 | 8960.63596351 | Zebrafish picornavirus 1 | 2304617 | Viruses | Viruses | 13477 | 0 | NTclustered | gi|2500378199|ref|NC_076245.1| | 2304617 | g3 | i0 | 96.021 | 3.05391388252322 | 8293 | 321 | 99 | 7 | 1 | 8289 | 8295 | 8 | Zebrafish picornavirus 1 strain IDEXX/ZfPV-1/2017/USA, complete genome | blastn | 25320 | 13477 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Zebrafish picornavirus 1 | |||
| 5279841 | 5279841 | PRJNA1059246_P_NODE_40125_length_336_cov_1.171103_g39499_i0 | PRJNA1059246 | 40125 | 336 | 1.171103 | 3.93490608 | Ripothoz virus | 3131336 | Viruses | Viruses | 316 | 1.02e-81 | NTclustered | gi|2717322249|gb|PP173638.1| | 3131336 | g39499 | i0 | 84.83 | 45.2142857142857 | 323 | 39 | 95 | 8 | 17 | 336 | 5301 | 5616 | MAG: Ripothoz virus isolate MP3_k141_314104 genomic sequence | blastn | 15192 | 316 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Magsaviricetes | Nodamuvirales | Ripothoz virus | ||||
| 6555172 | 6555172 | PRJNA1059246_P_NODE_52626_length_281_cov_1.480769_g52000_i0 | PRJNA1059246 | 52626 | 281 | 1.480769 | 4.16096089 | Cardiovirus rueckerti | 3427730 | Viruses | Viruses | 520 | 5.909999999999999e-143 | NTclustered | gi|1943777380|gb|MT250508.1| | 12104 | g52000 | i0 | 100 | 4 | 281 | 0 | 100 | 0 | 1 | 281 | 1340 | 1620 | Encephalomyocarditis virus isolate FRA/SIG/1/2013, complete genome | blastn | 1124 | 520 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Cardiovirus | Cardiovirus rueckerti | ||
| 10380239 | 10380239 | PRJNA1059246_P_NODE_27989_length_417_cov_1.790698_g27364_i0 | PRJNA1059246 | 27989 | 417 | 1.790698 | 7.46721066 | Cardiovirus rueckerti | 3427730 | Viruses | Viruses | 771 | 0 | NTclustered | gi|1943777380|gb|MT250508.1| | 12104 | g27364 | i0 | 100 | 43.0023980815348 | 417 | 0 | 100 | 0 | 1 | 417 | 2408 | 1992 | Encephalomyocarditis virus isolate FRA/SIG/1/2013, complete genome | blastn | 17932 | 771 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Cardiovirus | Cardiovirus rueckerti | ||
| 11655243 | 11655243 | PRJNA1059246_P_NODE_12310_length_678_cov_1.365289_g11731_i0 | PRJNA1059246 | 12310 | 678 | 1.365289 | 9.25665942 | Cardiovirus rueckerti | 3427730 | Viruses | Viruses | 1253 | 0 | NTclustered | gi|1943777380|gb|MT250508.1| | 12104 | g11731 | i0 | 100 | 65.1799410029498 | 678 | 0 | 100 | 0 | 1 | 678 | 4338 | 3661 | Encephalomyocarditis virus isolate FRA/SIG/1/2013, complete genome | blastn | 44192 | 1253 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Cardiovirus | Cardiovirus rueckerti | ||
| 14205450 | 14205450 | PRJNA1059246_P_NODE_16372_length_574_cov_1.834331_g15762_i0 | PRJNA1059246 | 16372 | 574 | 1.834331 | 10.52905994 | Cardiovirus rueckerti | 3427730 | Viruses | Viruses | 1061 | 0 | NTclustered | gi|1943777380|gb|MT250508.1| | 12104 | g15762 | i0 | 100 | 42.5087108013937 | 574 | 0 | 100 | 0 | 1 | 574 | 5111 | 5684 | Encephalomyocarditis virus isolate FRA/SIG/1/2013, complete genome | blastn | 24400 | 1061 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Cardiovirus | Cardiovirus rueckerti | ||
| 14205813 | 14205813 | PRJNA1059246_P_NODE_45592_length_309_cov_1.711864_g44966_i0 | PRJNA1059246 | 45592 | 309 | 1.711864 | 5.28965976 | Cardiovirus rueckerti | 3427730 | Viruses | Viruses | 560 | 3.88e-155 | NTclustered | gi|1943777380|gb|MT250508.1| | 12104 | g44966 | i0 | 99.353 | 93.326860841424 | 309 | 2 | 100 | 0 | 1 | 309 | 961 | 653 | Encephalomyocarditis virus isolate FRA/SIG/1/2013, complete genome | blastn | 28838 | 560 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Cardiovirus | Cardiovirus rueckerti | ||
| 19302552 | 19302552 | PRJNA1059246_P_NODE_20176_length_506_cov_3.173210_g19558_i0 | PRJNA1059246 | 20176 | 506 | 3.17321 | 16.0564426 | Cardiovirus rueckerti | 3427730 | Viruses | Viruses | 935 | 0 | NTclustered | gi|1943777380|gb|MT250508.1| | 12104 | g19558 | i0 | 100 | 79.7529644268775 | 506 | 0 | 100 | 0 | 1 | 506 | 7277 | 7782 | Encephalomyocarditis virus isolate FRA/SIG/1/2013, complete genome | blastn | 40355 | 935 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Cardiovirus | Cardiovirus rueckerti | ||
| 26718404 | 26718404 | PRJNA1059246_P_NODE_21101_length_493_cov_1.976190_g20482_i0 | PRJNA1059246 | 21101 | 493 | 1.97619 | 9.7426167 | Sclerotinia sclerotiorum narnavirus 1 | 2822897 | Viruses | Viruses | 47 | 0.00951 | NR | QZE12035.1 | 2822897 | g20482 | i0 | 29.2 | 0.979716024340771 | 161 | 85 | 95.5 | 5 | 477 | 7 | 75 | 210 | QZE12035.1 MAG: hypothetical protein [Sclerotinia sclerotiorum narnavirus 1] | diamond | 483 | 47 | 1 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Wolframvirales | Narnaviridae | Narnavirus | Sclerotinia sclerotiorum narnavirus 1 | ||
| 26741923 | 26741923 | PRJNA1059246_P_NODE_55901_length_271_cov_1.151515_g55275_i0 | PRJNA1059246 | 55901 | 271 | 1.151515 | 3.12060565 | Narnavirus | 186767 | Viruses | Viruses | 70.9 | 6.42e-12 | NR | QED22729.1 | 2601606 | g55275 | i0 | 43.1 | 5.00369003690037 | 72 | 41 | 79.7 | 0 | 9 | 224 | 264 | 335 | QED22729.1 RNA-dependent RNA polymerase, partial [Botryosphaeria dothidea narnavirus 1] | diamond | 1356 | 71.2 | 0.995786516853933 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Wolframvirales | Narnaviridae | Botryosphaeria dothidea narnavirus 1 | |||
| 27066900 | 27066900 | PRJNA1059246_P_NODE_47902_length_298_cov_1.720000_g47276_i0 | PRJNA1059246 | 47902 | 298 | 1.72 | 5.1256 | Soybean thrips partiti-like virus 1 | 2801003 | Viruses | Viruses | 54.7 | 4.49e-6 | NR | QQO81406.1 | 2801004 | g47276 | i0 | 33.3 | 0.724832214765101 | 72 | 48 | 72.5 | 0 | 249 | 34 | 398 | 469 | QQO81406.1 RNA-dependent RNA polymerase, partial [Soybean thrips partiti-like virus 10] | diamond | 216 | 54.7 | 1 | Viruses | Orthornavirae | Pisuviricota | Duplopiviricetes | Durnavirales | Partitiviridae | Soybean thrips partiti-like virus 10 | |||
| 27280171 | 27280171 | PRJNA1059246_P_NODE_45043_length_312_cov_0.966527_g44417_i0 | PRJNA1059246 | 45043 | 312 | 0.966527 | 3.01556424 | Wolframvirales | 2732502 | Viruses | Viruses | 70.1 | 2.13e-11 | NR | WNA22212.1 | 2719525 | g44417 | i0 | 34.9 | 3.02884615384615 | 106 | 66 | 99 | 2 | 4 | 312 | 479 | 584 | WNA22212.1 MAG: RdRp [Downy mildew lesion associated splipalmivirus 4] | diamond | 945 | 70.5 | 0.994326241134752 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Wolframvirales | Splipalmiviridae | Jakapalmivirus | Jakapalmivirus italiense | ||
| 27414907 | 27414907 | PRJNA1059246_P_NODE_24103_length_457_cov_1.234375_g23479_i0 | PRJNA1059246 | 24103 | 457 | 1.234375 | 5.64109375 | Abutilon theophrasti picorna-like virus | 2739846 | Viruses | Viruses | 130 | 9.31e-32 | NR | QKK82958.1 | 2739846 | g23479 | i0 | 47.3 | 0.971553610503282 | 148 | 74 | 96.5 | 2 | 454 | 14 | 1700 | 1844 | QKK82958.1 hypothetical protein, partial [Abutilon theophrasti picorna-like virus] | diamond | 444 | 130 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Abutilon theophrasti picorna-like virus | ||||
| 27635806 | 27635806 | PRJNA1059246_P_NODE_41224_length_330_cov_1.684825_g40598_i0 | PRJNA1059246 | 41224 | 330 | 1.684825 | 5.5599225 | Abutilon theophrasti picorna-like virus | 2739846 | Viruses | Viruses | 55.1 | 5.04e-6 | NR | QKK82958.1 | 2739846 | g40598 | i0 | 32.4 | 0.954545454545455 | 105 | 63 | 94.5 | 2 | 3 | 314 | 1461 | 1558 | QKK82958.1 hypothetical protein, partial [Abutilon theophrasti picorna-like virus] | diamond | 315 | 55.1 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Abutilon theophrasti picorna-like virus | ||||
| 28614555 | 28614555 | PRJNA1059246_P_NODE_6767_length_947_cov_3.512586_g6296_i0 | PRJNA1059246 | 6767 | 947 | 3.512586 | 33.26418942 | Dicistroviridae sp. | 1955144 | Viruses | Viruses | 52.4 | 0.00231 | NR | XCO49393.1 | 1955144 | g6296 | i0 | 40.5 | 0.26610348468849 | 84 | 49 | 26.3 | 1 | 844 | 596 | 1418 | 1501 | XCO49393.1 MAG: putative ORF1 protein [Dicistroviridae sp.] | diamond | 252 | 52.4 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Dicistroviridae | Dicistroviridae sp. | |||
| 28677713 | 28677713 | PRJNA1059246_P_NODE_30507_length_396_cov_1.068111_g29881_i0 | PRJNA1059246 | 30507 | 396 | 1.068111 | 4.22971956 | Partitiviridae sp. | 1955170 | Viruses | Viruses | 126 | 1.17e-32 | NR | QDH88920.1 | 1955170 | g29881 | i0 | 48.1 | 0.992424242424242 | 131 | 66 | 99.2 | 2 | 394 | 2 | 65 | 193 | QDH88920.1 MAG: RNA-dependent RNA polymerase, partial [Partitiviridae sp.] | diamond | 393 | 126 | 1 | Viruses | Orthornavirae | Pisuviricota | Duplopiviricetes | Durnavirales | Partitiviridae | Partitiviridae sp. | |||
| 31078217 | 31078217 | PRJNA1059246_P_NODE_42755_length_322_cov_2.626506_g42129_i0 | PRJNA1059246 | 42755 | 322 | 2.626506 | 8.45734932 | Hebei narnavirus 5 | 3371271 | Viruses | Viruses | 67 | 2.76e-10 | NR | XHY85189.1 | 3371271 | g42129 | i0 | 44.1 | 0.549689440993789 | 59 | 33 | 55 | 0 | 182 | 6 | 66 | 124 | XHY85189.1 MAG: RNA-dependent RNA polymerase [Hebei narnavirus 5] | diamond | 177 | 67 | 1 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Wolframvirales | Narnaviridae | Narnavirus | Hebei narnavirus 5 | ||
| 32658913 | 32658913 | PRJNA1059246_P_NODE_2400_length_1587_cov_2.013210_g2169_i0 | PRJNA1059246 | 2400 | 1587 | 2.01321 | 31.9496427 | Abutilon theophrasti picorna-like virus | 2739846 | Viruses | Viruses | 223 | 5.7e-59 | NR | QKK82958.1 | 2739846 | g2169 | i0 | 32.1 | 0.958412098298677 | 507 | 259 | 87.9 | 14 | 128 | 1522 | 2498 | 2961 | QKK82958.1 hypothetical protein, partial [Abutilon theophrasti picorna-like virus] | diamond | 1521 | 223 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Abutilon theophrasti picorna-like virus |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE contig_metadata(query VARCHAR, bioproject VARCHAR, node VARCHAR, length VARCHAR, coverage VARCHAR, rel_abundance VARCHAR, taxname_lca VARCHAR, taxid_lca VARCHAR, taxoncategory VARCHAR, taxoncategorysimple VARCHAR, bits VARCHAR, evalue VARCHAR, lowcoverage_flag VARCHAR, analysis_used VARCHAR, "target" VARCHAR, taxid VARCHAR, gene VARCHAR, allele VARCHAR, pident VARCHAR, sumperc_cov VARCHAR, alnlen VARCHAR, mismatch VARCHAR, qcov VARCHAR, gapopen VARCHAR, qstart VARCHAR, qend VARCHAR, tstart VARCHAR, tend VARCHAR, target_title VARCHAR, analysis VARCHAR, sumalnlen VARCHAR, maxbits VARCHAR, bits_percmax VARCHAR, tax_superkingdom VARCHAR, tax_clade VARCHAR, tax_kingdom VARCHAR, tax_phylum VARCHAR, tax_class VARCHAR, tax_order VARCHAR, tax_family VARCHAR, tax_genus VARCHAR, tax_species VARCHAR);;