contig_metadata
16 rows where bioproject = "PRJNA670521" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 8291316 | 8291316 | PRJNA670521_P_NODE_27_length_5661_cov_8.548318_g18_i0 | PRJNA670521 | 27 | 5661 | 8.548318 | 483.92028198 | Potexvirus marmormanihotis | 3433851 | Viruses | Viruses | 8421 | 0 | NTclustered | gi|1847771809|gb|KT002435.2| | 39046 | g18 | i0 | 93.52 | 20.0823176117294 | 5664 | 361 | 100 | 6 | 1 | 5661 | 705 | 6365 | Cassava common mosaic virus isolate Mcol22_1, complete genome | blastn | 113686 | 8421 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Alphaflexiviridae | Potexvirus | Potexvirus marmormanihotis | ||
| 8291606 | 8291606 | PRJNA670521_P_NODE_8007_length_628_cov_4.540541_g7282_i0 | PRJNA670521 | 8007 | 628 | 4.540541 | 28.51459748 | Potexvirus marmormanihotis | 3433851 | Viruses | Viruses | 1022 | 0 | NTclustered | gi|1847771809|gb|KT002435.2| | 39046 | g7282 | i0 | 96.019 | 14.937898089172 | 628 | 25 | 100 | 0 | 1 | 628 | 652 | 25 | Cassava common mosaic virus isolate Mcol22_1, complete genome | blastn | 9381 | 1022 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Alphaflexiviridae | Potexvirus | Potexvirus marmormanihotis | ||
| 14667023 | 14667023 | PRJNA670521_P_NODE_12_length_7224_cov_32.693609_g8_i0 | PRJNA670521 | 12 | 7224 | 32.693609 | 2361.78631416 | Danio blood picornavirus/Zebrafish picornavirus 2 | 3063761 | Viruses | Viruses | 2926 | 0 | NTclustered | gi|2551699335|gb|OK619588.1| | 3063761 | g8 | i0 | 96.298 | 0.666112956810631 | 1783 | 61 | 67 | 5 | 13 | 1793 | 7108 | 5329 | Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds | blastn | 4812 | 2926 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Danio blood picornavirus/Zebrafish picornavirus 2 | |||
| 15940838 | 15940838 | PRJNA670521_P_NODE_13_length_7224_cov_29.761851_g8_i1 | PRJNA670521 | 13 | 7224 | 29.761851 | 2149.99611624 | Danio blood picornavirus/Zebrafish picornavirus 2 | 3063761 | Viruses | Viruses | 2915 | 0 | NTclustered | gi|2551699335|gb|OK619588.1| | 3063761 | g8 | i1 | 96.186 | 0.66625138427464 | 1783 | 63 | 67 | 5 | 5432 | 7212 | 5329 | 7108 | Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds | blastn | 4813 | 2915 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Danio blood picornavirus/Zebrafish picornavirus 2 | |||
| 22315417 | 22315417 | PRJNA670521_P_NODE_18_length_6376_cov_44.189116_g12_i0 | PRJNA670521 | 18 | 6376 | 44.189116 | 2817.49803616 | Potexvirus marmormanihotis | 3433851 | Viruses | Viruses | 10008 | 0 | NTclustered | gi|2851473175|gb|PQ497977.1| | 39046 | g12 | i0 | 94.997 | 20.7964240903388 | 6376 | 319 | 100 | 0 | 1 | 6376 | 17 | 6392 | Cassava common mosaic virus isolate BR-21GS-C3-251-6, complete genome | blastn | 132598 | 10008 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Alphaflexiviridae | Potexvirus | Potexvirus marmormanihotis | ||
| 23590907 | 23590907 | PRJNA670521_P_NODE_19_length_6373_cov_16.364127_g12_i1 | PRJNA670521 | 19 | 6373 | 16.364127 | 1042.88581371 | Potexvirus marmormanihotis | 3433851 | Viruses | Viruses | 9915 | 0 | NTclustered | gi|2018315478|gb|MT279196.1| | 39046 | g12 | i1 | 94.771 | 19.8562686332967 | 6368 | 333 | 99 | 0 | 6 | 6373 | 1 | 6368 | Cassava common mosaic virus isolate BR, complete genome | blastn | 126544 | 9915 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Alphaflexiviridae | Potexvirus | Potexvirus marmormanihotis | ||
| 24864208 | 24864208 | PRJNA670521_P_NODE_20_length_6357_cov_38.469446_g12_i2 | PRJNA670521 | 20 | 6357 | 38.469446 | 2445.50268222 | Potexvirus marmormanihotis | 3433851 | Viruses | Viruses | 9718 | 0 | NTclustered | gi|2851473175|gb|PQ497977.1| | 39046 | g12 | i2 | 94.258 | 20.6005977662419 | 6357 | 365 | 100 | 0 | 1 | 6357 | 17 | 6373 | Cassava common mosaic virus isolate BR-21GS-C3-251-6, complete genome | blastn | 130958 | 9718 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Alphaflexiviridae | Potexvirus | Potexvirus marmormanihotis | ||
| 24864244 | 24864244 | PRJNA670521_P_NODE_27640_length_372_cov_1.030100_g26896_i0 | PRJNA670521 | 27640 | 372 | 1.0301 | 3.831972 | Zebrafish picornavirus 1 | 2304617 | Viruses | Viruses | 569 | 7.899999999999997e-158 | NTclustered | gi|2500378199|ref|NC_076245.1| | 2304617 | g26896 | i0 | 94.34 | 2.98387096774194 | 371 | 21 | 99 | 0 | 2 | 372 | 5563 | 5193 | Zebrafish picornavirus 1 strain IDEXX/ZfPV-1/2017/USA, complete genome | blastn | 1110 | 569 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Zebrafish picornavirus 1 | |||
| 27050206 | 27050206 | PRJNA670521_P_NODE_77162_length_248_cov_0.880000_g76417_i0 | PRJNA670521 | 77162 | 248 | 0.88 | 2.1824 | Rocky Mountain birnavirus | 3077841 | Viruses | Viruses | 157 | 1.2499999999999997e-42 | NR | WNN64190.1 | 3077841 | g76417 | i0 | 93.9 | 0.991935483870968 | 82 | 5 | 99.2 | 0 | 248 | 3 | 517 | 598 | WNN64190.1 VP1 [Rocky Mountain birnavirus] | diamond | 246 | 157 | 1 | Viruses | Orthornavirae | Birnaviridae | Rocky Mountain birnavirus | ||||||
| 28041305 | 28041305 | PRJNA670521_P_NODE_5_length_8668_cov_14.621640_g3_i0 | PRJNA670521 | 5 | 8668 | 14.62164 | 1267.4037552 | Zebrafish jaw picornavirus | RQ13 | Viruses | Viruses | 545 | 2.539999999999999e-153 | NR | ULF99604.1 | RQ13 | g3 | i0 | 26.6 | 4.82741116751269 | 2338 | 1251 | 75.3 | 76 | 6913 | 386 | 310 | 2335 | ULF99604.1 MAG: polyprotein, partial [Kobuvirus sp.] | diamond | 41844 | 548 | 0.994525547445255 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Kobuvirus | Zebrafish jaw picornavirus | ||
| 28660799 | 28660799 | PRJNA670521_P_NODE_387_length_2347_cov_3.346526_g256_i0 | PRJNA670521 | 387 | 2347 | 3.346526 | 78.54296522 | Fish-associated picorna-like virus 3 | 3003959 | Viruses | Viruses | 141 | 9.89e-31 | NR | UNY42191.1 | 3003959 | g256 | i0 | 27.9 | 0.521516829995739 | 408 | 245 | 48.7 | 11 | 500 | 1642 | 90 | 475 | UNY42191.1 MAG: polyprotein, partial [Picornavirales sp.] | diamond | 1224 | 141 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Fish-associated picorna-like virus 3 | ||||
| 28723913 | 28723913 | PRJNA670521_P_NODE_76007_length_249_cov_0.875000_g75262_i0 | PRJNA670521 | 76007 | 249 | 0.875 | 2.17875 | Leviviridae sp. | 2027243 | Viruses | Viruses | 71.2 | 3.58e-12 | NR | UJQ85965.1 | 2027243 | g75262 | i0 | 75 | 0.530120481927711 | 44 | 11 | 53 | 0 | 248 | 117 | 275 | 318 | UJQ85965.1 MAG: putative replicase protein [Leviviridae sp.] | diamond | 132 | 71.2 | 1 | Viruses | Orthornavirae | Lenarviricota | Leviviricetes | Norzivirales | Fiersviridae | Leviviridae sp. | |||
| 29177998 | 29177998 | PRJNA670521_P_NODE_11729_length_526_cov_1.019868_g10994_i0 | PRJNA670521 | 11729 | 526 | 1.019868 | 5.36450568 | Viruses | 10239 | Viruses | Viruses | 72 | 4.63e-11 | NR | UNY42007.1 | 1955153 | g10994 | i0 | 43 | 2.23574144486692 | 93 | 50 | 52.5 | 2 | 2 | 277 | 804 | 894 | UNY42007.1 MAG: polyprotein 2 [Picornavirales sp.] | diamond | 1176 | 72 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornavirales sp. | ||||
| 29418354 | 29418354 | PRJNA670521_P_NODE_289_length_2640_cov_2.918582_g189_i0 | PRJNA670521 | 289 | 2640 | 2.918582 | 77.0505648 | Chemarfal virus 127 | 3062889 | Viruses | Viruses | 107 | 1.61e-19 | NR | WPR17966.1 | 3062889 | g189 | i0 | 27.3 | 0.390909090909091 | 344 | 219 | 38.4 | 9 | 2249 | 1236 | 1548 | 1866 | WPR17966.1 MAG: hypothetical protein [Chemarfal virus 127] | diamond | 1032 | 107 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Chemarfal virus 127 | ||||
| 30219983 | 30219983 | PRJNA670521_P_NODE_46172_length_306_cov_0.935622_g45427_i0 | PRJNA670521 | 46172 | 306 | 0.935622 | 2.86300332 | Ghabrivirales | 2732540 | Viruses | Viruses | 104 | 1.34e-23 | NR | UHS72436.1 | 1955172 | g45427 | i0 | 53.5 | 2.91176470588235 | 99 | 45 | 96.1 | 1 | 296 | 3 | 404 | 502 | UHS72436.1 MAG: putative RNA-dependent RNA polymerase [Totiviridae sp.] | diamond | 891 | 104 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Totiviridae | Totiviridae sp. | |||
| 32116931 | 32116931 | PRJNA670521_P_NODE_17858_length_442_cov_1.252033_g17116_i0 | PRJNA670521 | 17858 | 442 | 1.252033 | 5.53398586 | Ghabrivirales | 2732540 | Viruses | Viruses | 60.5 | 2.03e-7 | NR | UCD53720.1 | 1955172 | g17116 | i0 | 32.1 | 1.85972850678733 | 140 | 75 | 91 | 5 | 1 | 402 | 393 | 518 | UCD53720.1 MAG: RNA-dependent RNA polymerase, partial [Totiviridae sp.] | diamond | 822 | 60.8 | 0.995065789473684 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Totiviridae | Totiviridae sp. |
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);;