contig_metadata
14 rows where bioproject = "PRJNA758088", tax_kingdom = "Orthornavirae" and tax_phylum = "Kitrinoviricota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5842492 | 5842492 | PRJNA758088_P_NODE_74645_length_494_cov_0.912114_g67682_i0 | PRJNA758088 | 74645 | 494 | 0.912114 | 4.50584316 | Bombyx mori Macula-like virus | 288456 | Viruses | Viruses | 880 | 0 | NTclustered | gi|612507560|gb|KJ433990.1| | 288456 | g67682 | i0 | 98.785 | 3.98785425101215 | 494 | 6 | 100 | 0 | 1 | 494 | 1700 | 1207 | Bombyx mori Macula-like virus strain SZ, complete genome | blastn | 1970 | 880 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Tymoviridae | Maculavirus | Bombyx mori Macula-like virus | ||
| 10131673 | 10131673 | PRJNA758088_P_NODE_135328_length_361_cov_1.604167_g128357_i0 | PRJNA758088 | 135328 | 361 | 1.604167 | 5.79104287 | root | 1 | Root_unresolved | Root_unresolved | 662 | 0 | NTclustered | gi|388240129|emb|HE818411.1| | 12242 | g128357 | i0 | 99.723 | 100 | 361 | 1 | 100 | 0 | 1 | 361 | 1851 | 1491 | Tobacco mosaic virus isolate Changle-9, complete genome | blastn | 36100 | 662 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Virgaviridae | Tobamovirus | Tobamovirus tabaci | ||
| 10132339 | 10132339 | PRJNA758088_P_NODE_29908_length_876_cov_1.952677_g24295_i0 | PRJNA758088 | 29908 | 876 | 1.952677 | 17.10545052 | Tobamovirus | 12234 | Viruses | Viruses | 1541 | 0 | NTclustered | gi|823962666|gb|KR537870.1| | 12253 | g24295 | i0 | 98.402 | 98.8002283105023 | 876 | 14 | 100 | 0 | 1 | 876 | 3770 | 2895 | Tomato mosaic virus isolate 99-1, complete genome | blastn | 86549 | 1541 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Virgaviridae | Tobamovirus | Tobamovirus tomatotessellati | ||
| 10939497 | 10939497 | PRJNA758088_P_NODE_193949_length_305_cov_1.655172_g186978_i0 | PRJNA758088 | 193949 | 305 | 1.655172 | 5.0482746 | Bombyx mori latent virus | 2065033 | Viruses | Viruses | 514 | 3.02e-141 | NTclustered | gi|1464307034|ref|NC_038331.1| | 2065033 | g186978 | i0 | 97.049 | 5.70819672131148 | 305 | 9 | 100 | 0 | 1 | 305 | 22 | 326 | Bombyx mori latent virus genomic RNA, complete genome | blastn | 1741 | 514 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Tymoviridae | Bombyx mori latent virus | |||
| 15232768 | 15232768 | PRJNA758088_P_NODE_94192_length_433_cov_1.955556_g87222_i0 | PRJNA758088 | 94192 | 433 | 1.955556 | 8.46755748 | root | 1 | Root_unresolved | Root_unresolved | 773 | 0 | NTclustered | gi|388240245|emb|HE818440.1| | 12242 | g87222 | i0 | 98.845 | 100 | 433 | 5 | 100 | 0 | 1 | 433 | 3007 | 2575 | Tobacco mosaic virus isolate Shaoxing, complete genome | blastn | 43300 | 773 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Virgaviridae | Tobamovirus | Tobamovirus tabaci | ||
| 19054753 | 19054753 | PRJNA758088_P_NODE_128635_length_370_cov_1.676768_g121664_i0 | PRJNA758088 | 128635 | 370 | 1.676768 | 6.2040416 | root | 1 | Root_unresolved | Root_unresolved | 684 | 0 | NTclustered | gi|388240277|emb|HE818448.1| | 12242 | g121664 | i0 | 100 | 99.9864864864865 | 370 | 0 | 100 | 0 | 1 | 370 | 1061 | 692 | Tobacco mosaic virus isolate Xifeng, complete genome | blastn | 36995 | 684 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Virgaviridae | Tobamovirus | Tobamovirus tabaci | ||
| 19055089 | 19055089 | PRJNA758088_P_NODE_204755_length_297_cov_1.928571_g197784_i0 | PRJNA758088 | 204755 | 297 | 1.928571 | 5.72785587 | Maculavirus | 249185 | Viruses | Viruses | 531 | 2.9099999999999992e-146 | NTclustered | gi|612507560|gb|KJ433990.1| | 288456 | g197784 | i0 | 98.986 | 4.16835016835017 | 296 | 3 | 99 | 0 | 1 | 296 | 6215 | 6510 | Bombyx mori Macula-like virus strain SZ, complete genome | blastn | 1238 | 536 | 0.990671641791045 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Tymoviridae | Maculavirus | Bombyx mori Macula-like virus | ||
| 20329905 | 20329905 | PRJNA758088_P_NODE_237016_length_276_cov_2.655172_g230045_i0 | PRJNA758088 | 237016 | 276 | 2.655172 | 7.32827472 | root | 1 | Root_unresolved | Root_unresolved | 510 | 3.48e-140 | NTclustered | gi|388240277|emb|HE818448.1| | 12242 | g230045 | i0 | 100 | 99.9891304347826 | 276 | 0 | 100 | 0 | 1 | 276 | 1463 | 1188 | Tobacco mosaic virus isolate Xifeng, complete genome | blastn | 27597 | 510 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Virgaviridae | Tobamovirus | Tobamovirus tabaci | ||
| 21605058 | 21605058 | PRJNA758088_P_NODE_109597_length_400_cov_1.770642_g102627_i0 | PRJNA758088 | 109597 | 400 | 1.770642 | 7.082568 | Tobamovirus | 12234 | Viruses | Viruses | 734 | 0 | NTclustered | gi|226235018|dbj|AB355139.1| | 12253 | g102627 | i0 | 100 | 99.2375 | 397 | 0 | 99 | 0 | 1 | 397 | 5226 | 4830 | Tomato mosaic virus genomic RNA, complete genome, strain: L11Y | blastn | 39695 | 734 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Virgaviridae | Tobamovirus | Tobamovirus tomatotessellati | ||
| 21605599 | 21605599 | PRJNA758088_P_NODE_234857_length_278_cov_1.126829_g227886_i0 | PRJNA758088 | 234857 | 278 | 1.126829 | 3.13258462 | Maculavirus | 249185 | Viruses | Viruses | 486 | 5.919999999999998e-133 | NTclustered | gi|612507560|gb|KJ433990.1| | 288456 | g227886 | i0 | 98.201 | 4 | 278 | 5 | 100 | 0 | 1 | 278 | 3435 | 3158 | Bombyx mori Macula-like virus strain SZ, complete genome | blastn | 1112 | 486 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Tymoviridae | Maculavirus | Bombyx mori Macula-like virus | ||
| 22880484 | 22880484 | PRJNA758088_P_NODE_116678_length_388_cov_1.314286_g109708_i0 | PRJNA758088 | 116678 | 388 | 1.314286 | 5.09942968 | Tobamovirus | 12234 | Viruses | Viruses | 712 | 0 | NTclustered | gi|2201440261|gb|OL652662.1| | 12253 | g109708 | i0 | 99.742 | 98.7731958762887 | 388 | 1 | 100 | 0 | 1 | 388 | 2912 | 2525 | Tomato mosaic virus isolate NVWA36783860, complete genome | blastn | 38324 | 712 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Virgaviridae | Tobamovirus | Tobamovirus tomatotessellati | ||
| 25429548 | 25429548 | PRJNA758088_P_NODE_117840_length_386_cov_1.629393_g110870_i0 | PRJNA758088 | 117840 | 386 | 1.629393 | 6.28945698 | root | 1 | Root_unresolved | Root_unresolved | 713 | 0 | NTclustered | gi|388240277|emb|HE818448.1| | 12242 | g110870 | i0 | 100 | 99.7849740932643 | 386 | 0 | 100 | 0 | 1 | 386 | 2036 | 2421 | Tobacco mosaic virus isolate Xifeng, complete genome | blastn | 38517 | 713 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Virgaviridae | Tobamovirus | Tobamovirus tabaci | ||
| 25430237 | 25430237 | PRJNA758088_P_NODE_271740_length_256_cov_0.939891_g264769_i0 | PRJNA758088 | 271740 | 256 | 0.939891 | 2.40612096 | root | 1 | Root_unresolved | Root_unresolved | 457 | 4.22e-124 | NTclustered | gi|1590853303|gb|MH595921.1| | 12242 | g264769 | i0 | 98.828 | 99.89453125 | 256 | 3 | 100 | 0 | 1 | 256 | 3146 | 3401 | Tobacco mosaic virus isolate Mudanjiang, complete genome | blastn | 25573 | 457 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Virgaviridae | Tobamovirus | Tobamovirus tabaci | ||
| 29273110 | 29273110 | PRJNA758088_P_NODE_342629_length_244_cov_0.900585_g335658_i0 | PRJNA758088 | 342629 | 244 | 0.900585 | 2.1974274 | Prunevirus | 1914295 | Viruses | Viruses | 85.9 | 2.54e-17 | NR | UIW14227.1 | 2560282 | g335658 | i0 | 80 | 1.22950819672131 | 50 | 10 | 61.5 | 0 | 150 | 1 | 1 | 50 | UIW14227.1 MAG: replicase [Actinidia seed borne latent virus] | diamond | 300 | 86.7 | 0.990772779700115 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Betaflexiviridae | Prunevirus | Prunevirus actinidiae |
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);;