contig_metadata
15 rows where bioproject = "PRJNA849172" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3387062 | 3387062 | PRJNA849172_P_NODE_4383_length_1060_cov_78.398176_g4119_i0 | PRJNA849172 | 4383 | 1060 | 78.398176 | 831.0206656 | Aspergillus creber narnavirus 1 | 2875494 | Viruses | Viruses | 1413 | 0 | NTclustered | gi|2130544298|dbj|LC648936.1| | 2875494 | g4119 | i0 | 90.951 | 1.01132075471698 | 1072 | 65 | 99 | 24 | 8 | 1060 | 1073 | 15 | Aspergillus creber narnavirus 1 J-YC genomic RNA, segment 4, complete sequence | blastn | 1072 | 1413 | 1 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Wolframvirales | Narnaviridae | Aspergillus creber narnavirus 1 | |||
| 4663217 | 4663217 | PRJNA849172_P_NODE_124624_length_228_cov_3.412903_g124264_i0 | PRJNA849172 | 124624 | 228 | 3.412903 | 7.78141884 | Botourmiaviridae sp. | 2808997 | Viruses | Viruses | 355 | 1.38e-93 | NTclustered | gi|2396039473|gb|ON812832.1| | 2808997 | g124264 | i0 | 95.111 | 0.986842105263158 | 225 | 11 | 99 | 0 | 1 | 225 | 1460 | 1684 | MAG: Botourmiaviridae sp. isolate TIGMIC_1, complete genome | blastn | 225 | 355 | 1 | Viruses | Orthornavirae | Lenarviricota | Miaviricetes | Ourlivirales | Botourmiaviridae | Botourmiaviridae sp. | |||
| 4663546 | 4663546 | PRJNA849172_P_NODE_136764_length_211_cov_11.775362_g136404_i0 | PRJNA849172 | 136764 | 211 | 11.775362 | 24.84601382 | Botourmiaviridae sp. | 2808997 | Viruses | Viruses | 372 | 1.25e-98 | NTclustered | gi|2396039473|gb|ON812832.1| | 2808997 | g136404 | i0 | 98.571 | 0.995260663507109 | 210 | 3 | 99 | 0 | 1 | 210 | 2503 | 2294 | MAG: Botourmiaviridae sp. isolate TIGMIC_1, complete genome | blastn | 210 | 372 | 1 | Viruses | Orthornavirae | Lenarviricota | Miaviricetes | Ourlivirales | Botourmiaviridae | Botourmiaviridae sp. | |||
| 4663945 | 4663945 | PRJNA849172_P_NODE_16004_length_521_cov_3.549107_g15645_i0 | PRJNA849172 | 16004 | 521 | 3.549107 | 18.49084747 | Zhangzhou Narna tick virus 5 | 2972251 | Viruses | Viruses | 160 | 1.9e-43 | NR | UYL95400.1 | 2972251 | g15645 | i0 | 58.5 | 0.748560460652591 | 130 | 53 | 74.3 | 1 | 3 | 389 | 350 | 479 | UYL95400.1 MAG: RNA-dependent RNA polymerase [Zhangzhou Narna tick virus 5] | diamond | 390 | 160 | 1 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Wolframvirales | Narnaviridae | Zhangzhou Narna tick virus 5 | |||
| 8488370 | 8488370 | PRJNA849172_P_NODE_1727_length_1649_cov_20.180838_g1594_i0 | PRJNA849172 | 1727 | 1649 | 20.180838 | 332.78201862 | Aspergillus creber narnavirus 1 | 2875494 | Viruses | Viruses | 2320 | 0 | NTclustered | gi|2130544296|dbj|LC648935.1| | 2875494 | g1594 | i0 | 92.266 | 1.63856882959369 | 1642 | 117 | 99 | 9 | 12 | 1649 | 1653 | 18 | Aspergillus creber narnavirus 1 J-YC genomic RNA, segment 3, complete sequence | blastn | 2702 | 2320 | 1 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Wolframvirales | Narnaviridae | Aspergillus creber narnavirus 1 | |||
| 11040139 | 11040139 | PRJNA849172_P_NODE_4669_length_1026_cov_7.237146_g4401_i0 | PRJNA849172 | 4669 | 1026 | 7.237146 | 74.25311796 | Streptophyte associated narna-like virus 19 | 3067063 | Viruses | Viruses | 500 | 2.5199999999999996e-173 | NR | WPR17387.1 | 3067063 | g4401 | i0 | 73.1 | 0.944444444444444 | 323 | 87 | 94.4 | 0 | 56 | 1024 | 32 | 354 | WPR17387.1 MAG: RNA-dependent RNA polymerase, partial [Streptophyte associated narna-like virus 19] | diamond | 969 | 500 | 1 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Wolframvirales | Narnaviridae | Streptophyte associated narna-like virus 19 | |||
| 16138210 | 16138210 | PRJNA849172_P_NODE_1493_length_1739_cov_22.744898_g1376_i0 | PRJNA849172 | 1493 | 1739 | 22.744898 | 395.53377622 | Zhangzhou Narna tick virus 4 | 2972250 | Viruses | Viruses | 805 | 9.86e-289 | NR | UYL95399.1 | 2972250 | g1376 | i0 | 75.9 | 1.76135710178263 | 511 | 122 | 88.2 | 1 | 22 | 1554 | 34 | 543 | UYL95399.1 MAG: RNA-dependent RNA polymerase [Zhangzhou Narna tick virus 4] | diamond | 3063 | 805 | 1 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Wolframvirales | Narnaviridae | Zhangzhou Narna tick virus 4 | |||
| 18685451 | 18685451 | PRJNA849172_P_NODE_10315_length_668_cov_4.347899_g9963_i0 | PRJNA849172 | 10315 | 668 | 4.347899 | 29.04396532 | Aspergillus creber narnavirus 1 | 2875494 | Viruses | Viruses | 802 | 0 | NTclustered | gi|2130544291|dbj|LC648933.1| | 2875494 | g9963 | i0 | 88.358 | 1.00299401197605 | 670 | 74 | 100 | 4 | 1 | 668 | 111 | 778 | Aspergillus creber narnavirus 1 J-YC genomic RNA, segment 1, complete sequence | blastn | 670 | 802 | 1 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Wolframvirales | Narnaviridae | Aspergillus creber narnavirus 1 | |||
| 19961455 | 19961455 | PRJNA849172_P_NODE_1336_length_1818_cov_44.459599_g1230_i0 | PRJNA849172 | 1336 | 1818 | 44.459599 | 808.27550982 | Aspergillus creber narnavirus 1 | 2875494 | Viruses | Viruses | 1070 | 0 | NTclustered | gi|2130544293|dbj|LC648934.1| | 2875494 | g1230 | i0 | 79.2 | 1.12101210121012 | 1601 | 287 | 87 | 39 | 16 | 1599 | 84 | 1655 | Aspergillus creber narnavirus 1 J-YC genomic RNA, segment 2, complete sequence | blastn | 2038 | 1070 | 1 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Wolframvirales | Narnaviridae | Aspergillus creber narnavirus 1 | |||
| 21237866 | 21237866 | PRJNA849172_P_NODE_26437_length_399_cov_16.036810_g26078_i0 | PRJNA849172 | 26437 | 399 | 16.03681 | 63.9868719 | Aspergillus creber narnavirus 1 | 2875494 | Viruses | Viruses | 593 | 5.059999999999998e-165 | NTclustered | gi|2130544291|dbj|LC648933.1| | 2875494 | g26078 | i0 | 93.924 | 0.989974937343358 | 395 | 21 | 98 | 2 | 7 | 398 | 3381 | 2987 | Aspergillus creber narnavirus 1 J-YC genomic RNA, segment 1, complete sequence | blastn | 395 | 593 | 1 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Wolframvirales | Narnaviridae | Aspergillus creber narnavirus 1 | |||
| 25062923 | 25062923 | PRJNA849172_P_NODE_560_length_2444_cov_16.794601_g505_i0 | PRJNA849172 | 560 | 2444 | 16.794601 | 410.46004844 | Hulunbuir Botou tick virus 2 | 2972054 | Viruses | Viruses | 4348 | 0 | NTclustered | gi|2820295211|gb|PQ180957.1| | 2972054 | g505 | i0 | 98.773 | 12.7385433715221 | 2444 | 30 | 100 | 0 | 1 | 2444 | 68 | 2511 | MAG: Hulunbuir Botou tick virus 2 isolate Hebei_107 genomic sequence | blastn | 31133 | 4348 | 1 | Viruses | Orthornavirae | Lenarviricota | Miaviricetes | Ourlivirales | Botourmiaviridae | Hulunbuir Botou tick virus 2 | |||
| 29612356 | 29612356 | PRJNA849172_P_NODE_630_length_2351_cov_42.178665_g569_i0 | PRJNA849172 | 630 | 2351 | 42.178665 | 991.62041415 | Leviviridae sp. | 2027243 | Viruses | Viruses | 336 | 2.43e-102 | NR | URG16464.1 | 2027243 | g569 | i0 | 47.1 | 1.49042960442365 | 401 | 182 | 47.9 | 9 | 1135 | 2259 | 150 | 546 | URG16464.1 MAG: RNA dependent RNA polymerase [Leviviridae sp.] | diamond | 3504 | 336 | 1 | Viruses | Orthornavirae | Lenarviricota | Leviviricetes | Norzivirales | Fiersviridae | Leviviridae sp. | |||
| 29770409 | 29770409 | PRJNA849172_P_NODE_28271_length_385_cov_19.448718_g27912_i0 | PRJNA849172 | 28271 | 385 | 19.448718 | 74.8775643 | ssRNA phage SRR696 | 2845570 | Viruses | Viruses | 119 | 6.899999999999999e-32 | NR | YP_010769504.1 | 2786549 | g27912 | i0 | 43.8 | 0.997402597402597 | 128 | 72 | 99.7 | 0 | 384 | 1 | 2 | 129 | YP_010769504.1 coat protein [ssRNA phage SRR6960551_11] | diamond | 384 | 119 | 1 | Viruses | Orthornavirae | Lenarviricota | Leviviricetes | Norzivirales | Fiersviridae | Manrohovirus | Manrohovirus lutadaptatum | ||
| 29991716 | 29991716 | PRJNA849172_P_NODE_50951_length_293_cov_18.627273_g50591_i0 | PRJNA849172 | 50951 | 293 | 18.627273 | 54.57790989 | Plasmopara viticola lesion associated ourmia-like virus 33 | 2686502 | Viruses | Viruses | 71.2 | 6.38e-12 | NR | QGY72563.1 | 2686502 | g50591 | i0 | 41.5 | 0.839590443686007 | 82 | 48 | 84 | 0 | 247 | 2 | 4 | 85 | QGY72563.1 RNA dependent RNA polymerase [Plasmopara viticola lesion associated ourmia-like virus 33] | diamond | 246 | 71.2 | 1 | Viruses | Orthornavirae | Lenarviricota | Miaviricetes | Ourlivirales | Botourmiaviridae | Magoulivirus | Magoulivirus phaeoacremonii | ||
| 32308110 | 32308110 | PRJNA849172_P_NODE_8559_length_742_cov_66.064275_g8217_i0 | PRJNA849172 | 8559 | 742 | 66.064275 | 490.1969205 | Fiersviridae | 2842319 | Viruses | Viruses | 81.3 | 1.18e-13 | NR | YP_010769358.1 | 2786110 | g8217 | i0 | 38.6 | 0.978436657681941 | 132 | 79 | 53 | 2 | 319 | 711 | 134 | 264 | YP_010769358.1 maturation protein, partial [ssRNA phage Gephyllon.1_11] | diamond | 726 | 82 | 0.991463414634146 | Viruses | Orthornavirae | Lenarviricota | Leviviricetes | Norzivirales | Fiersviridae | Glyciruvirus | Glyciruvirus geovicinum |
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);;