contig_metadata
13 rows where bioproject = "PRJNA674048" and tax_phylum = "Lenarviricota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4471083 | 4471083 | PRJNA674048_P_NODE_26944_length_169_cov_0.866667_g26741_i0 | PRJNA674048 | 26944 | 169 | 0.866667 | 1.46466723 | Leviviridae sp. | 2027243 | Viruses | Viruses | 296 | 5.9e-76 | NTclustered | gi|2245488662|gb|ON163447.1| | 2027243 | g26741 | i0 | 98.225 | 1 | 169 | 3 | 100 | 0 | 1 | 169 | 198 | 366 | MAG: Leviviridae sp. isolate 147b-k141_250028 RNA dependent RNA polymerase gene, partial cds | blastn | 169 | 296 | 1 | Viruses | Orthornavirae | Lenarviricota | Leviviricetes | Norzivirales | Fiersviridae | Leviviridae sp. | |||
| 7544034 | 7544034 | PRJNA674048_P_NODE_34306_length_150_cov_42846.019802_g34103_i0 | PRJNA674048 | 34306 | 150 | 42846.019802 | 64269.029703 | Orthornavirae | 2732396 | Viruses | Viruses | 106 | 9.25e-19 | NTclustered | gi|2183423903|gb|MZ679790.1| | 2027243 | g34103 | i0 | 96.825 | 44.3066666666667 | 63 | 2 | 93 | 0 | 88 | 150 | 3157 | 3219 | MAG: Leviviridae sp. isolate R28-k141_67620 genomic sequence | blastn | 6646 | 106 | 1 | Viruses | Orthornavirae | Lenarviricota | Leviviricetes | Norzivirales | Fiersviridae | Leviviridae sp. | |||
| 10847120 | 10847120 | PRJNA674048_P_NODE_14449_length_236_cov_2.828877_g14246_i0 | PRJNA674048 | 14449 | 236 | 2.828877 | 6.67614972 | Botourmiaviridae | 2560063 | Viruses | Viruses | 107 | 7.79e-25 | NR | YP_010800225.1 | 2686493 | g14246 | i0 | 82.8 | 1.47457627118644 | 58 | 10 | 73.7 | 0 | 176 | 3 | 305 | 362 | YP_010800225.1 RNA dependent RNA polymerase [Plasmopara viticola lesion associated ourmia-like virus 25] | diamond | 348 | 107 | 1 | Viruses | Orthornavirae | Lenarviricota | Miaviricetes | Ourlivirales | Botourmiaviridae | Magoulivirus | Magoulivirus fiplasmoparae | ||
| 15945702 | 15945702 | PRJNA674048_P_NODE_13153_length_250_cov_71821.771144_g12950_i0 | PRJNA674048 | 13153 | 250 | 71821.771144 | 179554.42786 | Leviviridae sp. | 2027243 | Viruses | Viruses | 110 | 1.32e-19 | NTclustered | gi|2183423903|gb|MZ679790.1| | 2027243 | g12950 | i0 | 96.97 | 24.168 | 66 | 1 | 49 | 1 | 136 | 201 | 3154 | 3090 | MAG: Leviviridae sp. isolate R28-k141_67620 genomic sequence | blastn | 6042 | 110 | 1 | Viruses | Orthornavirae | Lenarviricota | Leviviricetes | Norzivirales | Fiersviridae | Leviviridae sp. | |||
| 26903986 | 26903986 | PRJNA674048_P_NODE_2421_length_742_cov_4.105339_g2268_i0 | PRJNA674048 | 2421 | 742 | 4.105339 | 30.46161538 | Viruses | 10239 | Viruses | Viruses | 84.3 | 1.61e-14 | NR | UJQ92443.1 | 2809572 | g2268 | i0 | 30.4 | 1.85579514824798 | 237 | 146 | 93 | 8 | 691 | 2 | 18 | 242 | UJQ92443.1 MAG: putative RNA-dependent RNA polymerase [Mitoviridae sp.] | diamond | 1377 | 84.3 | 1 | Viruses | Orthornavirae | Lenarviricota | Howeltoviricetes | Cryppavirales | Mitoviridae | Mitoviridae sp. | |||
| 28029426 | 28029426 | PRJNA674048_P_NODE_4085_length_539_cov_2.561224_g3886_i0 | PRJNA674048 | 4085 | 539 | 2.561224 | 13.80499736 | Baoding Narna tick virus 1 | 2972227 | Viruses | Viruses | 155 | 5.42e-40 | NR | UYL95373.1 | 2972227 | g3886 | i0 | 45.8 | 2.88311688311688 | 168 | 87 | 91.3 | 1 | 42 | 533 | 389 | 556 | UYL95373.1 MAG: RNA-dependent RNA polymerase, partial [Baoding Narna tick virus 1] | diamond | 1554 | 155 | 1 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Wolframvirales | Narnaviridae | Baoding Narna tick virus 1 | |||
| 28893581 | 28893581 | PRJNA674048_P_NODE_10968_length_281_cov_3.275862_g10765_i0 | PRJNA674048 | 10968 | 281 | 3.275862 | 9.20517222 | Botourmiaviridae | 2560063 | Viruses | Viruses | 137 | 2.08e-35 | NR | YP_010800214.1 | 2686481 | g10765 | i0 | 69.6 | 2.94661921708185 | 92 | 28 | 98.2 | 0 | 276 | 1 | 161 | 252 | YP_010800214.1 RNA dependent RNA polymerase [Plasmopara viticola lesion associated ourmia-like virus 14] | diamond | 828 | 138 | 0.992753623188406 | Viruses | Orthornavirae | Lenarviricota | Miaviricetes | Ourlivirales | Botourmiaviridae | Magoulivirus | Magoulivirus kappaplasmoparae | ||
| 29923902 | 29923902 | PRJNA674048_P_NODE_2731_length_690_cov_4.550702_g2567_i0 | PRJNA674048 | 2731 | 690 | 4.550702 | 31.3998438 | Botourmiaviridae sp. | 2808997 | Viruses | Viruses | 240 | 9.519999999999998e-72 | NR | WAK77825.1 | 2808997 | g2567 | i0 | 54.8 | 0.991304347826087 | 228 | 102 | 99.1 | 1 | 2 | 685 | 386 | 612 | WAK77825.1 MAG: RNA-dependent RNA polymerase [Botourmiaviridae sp.] | diamond | 684 | 240 | 1 | Viruses | Orthornavirae | Lenarviricota | Miaviricetes | Ourlivirales | Botourmiaviridae | Botourmiaviridae sp. | |||
| 30618805 | 30618805 | PRJNA674048_P_NODE_10113_length_296_cov_3.514170_g9910_i0 | PRJNA674048 | 10113 | 296 | 3.51417 | 10.4019432 | Annperkins narna-like virus | 2716639 | Viruses | Viruses | 98.6 | 1.7e-21 | NR | QIJ70066.1 | 2716639 | g9910 | i0 | 49 | 1.96621621621622 | 96 | 48 | 96.3 | 1 | 1 | 285 | 341 | 436 | QIJ70066.1 RNA-dependent RNA polymerase [Annperkins narna-like virus] | diamond | 582 | 98.6 | 1 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Wolframvirales | Narnaviridae | Annperkins narna-like virus | |||
| 31693599 | 31693599 | PRJNA674048_P_NODE_297_length_1835_cov_4.662374_g252_i0 | PRJNA674048 | 297 | 1835 | 4.662374 | 85.5545629 | Chronapork virus | 3129915 | Viruses | Viruses | 125 | 1.14e-25 | NR | WZH58962.1 | 3129915 | g252 | i0 | 34.1 | 1.09863760217984 | 343 | 181 | 53.5 | 11 | 1278 | 298 | 546 | 859 | WZH58962.1 MAG: RNA-dependent RNA polymerase, partial [Chronapork virus] | diamond | 2016 | 125 | 1 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Wolframvirales | Narnaviridae | Chronapork virus | |||
| 31693601 | 31693601 | PRJNA674048_P_NODE_5637_length_434_cov_3.657143_g5434_i0 | PRJNA674048 | 5637 | 434 | 3.657143 | 15.87200062 | Erysiphe necator associated ourmia-like virus 86 | 2741866 | Viruses | Viruses | 117 | 2.0900000000000003e-27 | NR | QKI79916.1 | 2741866 | g5434 | i0 | 50.4 | 0.960829493087558 | 139 | 63 | 93.3 | 4 | 27 | 431 | 4 | 140 | QKI79916.1 RNA-dependent RNA polymerase [Erysiphe necator associated ourmia-like virus 86] | diamond | 417 | 117 | 1 | Viruses | Orthornavirae | Lenarviricota | Miaviricetes | Ourlivirales | Botourmiaviridae | Ourmiavirus | Erysiphe necator associated ourmia-like virus 86 | ||
| 32199910 | 32199910 | PRJNA674048_P_NODE_21418_length_190_cov_1.475177_g21215_i0 | PRJNA674048 | 21418 | 190 | 1.475177 | 2.8028363 | Lwood associated botourmia-like virus 3 | 3066577 | Viruses | Viruses | 52.8 | 5.41e-6 | NR | WPR16789.1 | 3066577 | g21215 | i0 | 65.8 | 2.02105263157895 | 38 | 13 | 60 | 0 | 189 | 76 | 263 | 300 | WPR16789.1 MAG: RNA-dependent RNA polymerase [Lwood associated botourmia-like virus 3] | diamond | 384 | 52.8 | 1 | Viruses | Orthornavirae | Lenarviricota | Miaviricetes | Ourlivirales | Botourmiaviridae | Lwood associated botourmia-like virus 3 | |||
| 32231740 | 32231740 | PRJNA674048_P_NODE_2638_length_706_cov_2.928463_g2477_i0 | PRJNA674048 | 2638 | 706 | 2.928463 | 20.67494878 | Mitovirus AEF-2 | 1437189 | Viruses | Viruses | 112 | 1.73e-24 | NR | AGW51760.1 | 1437189 | g2477 | i0 | 47.5 | 1.19405099150142 | 122 | 60 | 51.8 | 1 | 706 | 341 | 352 | 469 | AGW51760.1 RNA-dependent RNA polymerase-like protein [Mitovirus AEF-2013] | diamond | 843 | 112 | 1 | Viruses | Orthornavirae | Lenarviricota | Howeltoviricetes | Cryppavirales | Mitoviridae | Mitovirus | Mitovirus AEF-2013 |
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);;