contig_metadata
13 rows where bioproject = "PRJEB58983", tax_phylum = "Lenarviricota" and tax_superkingdom = "Viruses"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 21801559 | 21801559 | PRJEB58983_P_NODE_20578_length_286_cov_5.159624_g20163_i0 | PRJEB58983 | 20578 | 286 | 5.159624 | 14.75652464 | Chrocagosk virus | 3129397 | Viruses | Viruses | 337 | 6.52e-88 | NTclustered | gi|2717317479|gb|PP171845.1| | 3129397 | g20163 | i0 | 92.405 | 20.506993006993 | 237 | 16 | 83 | 2 | 1 | 237 | 235 | 1 | MAG: Chrocagosk virus isolate CC1A_k141_83719 genomic sequence | blastn | 5865 | 337 | 1 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Chrocagosk virus | |||||
| 24350546 | 24350546 | PRJEB58983_P_NODE_14920_length_330_cov_2.428016_g14505_i0 | PRJEB58983 | 14920 | 330 | 2.428016 | 8.0124528 | Chrocagosk virus | 3129397 | Viruses | Viruses | 69.4 | 3.08e-7 | NTclustered | gi|2717317479|gb|PP171845.1| | 3129397 | g14505 | i0 | 100 | 0.112121212121212 | 37 | 0 | 11 | 0 | 105 | 141 | 519 | 555 | MAG: Chrocagosk virus isolate CC1A_k141_83719 genomic sequence | blastn | 37 | 69.4 | 1 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Chrocagosk virus | |||||
| 27033570 | 27033570 | PRJEB58983_P_NODE_4722_length_563_cov_5.477551_g4312_i0 | PRJEB58983 | 4722 | 563 | 5.477551 | 30.83861213 | Soldier fly associated narna-like virus | 3133261 | Viruses | Viruses | 193 | 1.9e-53 | NR | WXG23068.1 | 3133261 | g4312 | i0 | 49.2 | 1.99289520426288 | 187 | 95 | 99.6 | 0 | 3 | 563 | 580 | 766 | WXG23068.1 MAG: RNA-dependent RNA polymerase [Soldier fly associated narna-like virus] | diamond | 1122 | 193 | 1 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Wolframvirales | Narnaviridae | Soldier fly associated narna-like virus | |||
| 27318234 | 27318234 | PRJEB58983_P_NODE_9303_length_408_cov_3.844776_g8889_i0 | PRJEB58983 | 9303 | 408 | 3.844776 | 15.68668608 | Soybean thrips narna-like virus 1 | 2800851 | Viruses | Viruses | 129 | 1.16e-31 | NR | QQP18719.1 | 2800851 | g8889 | i0 | 51.2 | 0.919117647058823 | 125 | 60 | 91.2 | 1 | 380 | 9 | 403 | 527 | QQP18719.1 RNA-dependent RNA polymerase, partial [Soybean thrips narna-like virus 1] | diamond | 375 | 129 | 1 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Wolframvirales | Narnaviridae | Soybean thrips narna-like virus 1 | |||
| 27444721 | 27444721 | PRJEB58983_P_NODE_2223_length_845_cov_4.291451_g1860_i0 | PRJEB58983 | 2223 | 845 | 4.291451 | 36.26276095 | Narnaviridae sp. | 2583949 | Viruses | Viruses | 379 | 4.25e-122 | NR | UJQ92726.1 | 2583949 | g1860 | i0 | 71.4 | 1.00473372781065 | 283 | 79 | 99.8 | 2 | 843 | 1 | 574 | 856 | UJQ92726.1 MAG: putative RNA-dependent RNA polymerase, partial [Narnaviridae sp.] | diamond | 849 | 379 | 1 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Wolframvirales | Narnaviridae | Narnaviridae sp. | |||
| 27854847 | 27854847 | PRJEB58983_P_NODE_165_length_2622_cov_47.775991_g123_i0 | PRJEB58983 | 165 | 2622 | 47.775991 | 1252.68648402 | Narnaviridae sp. | 2583949 | Viruses | Viruses | 597 | 5.8400000000000005e-198 | NR | UJQ92801.1 | 2583949 | g123 | i0 | 42.5 | 2.83752860411899 | 835 | 459 | 94.1 | 8 | 132 | 2597 | 13 | 839 | UJQ92801.1 MAG: putative RNA-dependent RNA polymerase, partial [Narnaviridae sp.] | diamond | 7440 | 597 | 1 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Wolframvirales | Narnaviridae | Narnaviridae sp. | |||
| 28044310 | 28044310 | PRJEB58983_P_NODE_25385_length_263_cov_1.878947_g24970_i0 | PRJEB58983 | 25385 | 263 | 1.878947 | 4.94163061 | Leviviridae sp. | 2027243 | Viruses | Viruses | 106 | 1.22e-24 | NR | URG15349.1 | 2027243 | g24970 | i0 | 62.1 | 1.98479087452471 | 87 | 31 | 99.2 | 1 | 2 | 262 | 205 | 289 | URG15349.1 MAG: RNA dependent RNA polymerase, partial [Leviviridae sp.] | diamond | 522 | 106 | 1 | Viruses | Orthornavirae | Lenarviricota | Leviviricetes | Norzivirales | Fiersviridae | Leviviridae sp. | |||
| 28107342 | 28107342 | PRJEB58983_P_NODE_27865_length_253_cov_1.311111_g27450_i0 | PRJEB58983 | 27865 | 253 | 1.311111 | 3.31711083 | Hangzhou mito-like virus 9 | 3028986 | Viruses | Viruses | 77.8 | 1.93e-14 | NR | WEU70947.1 | 3028986 | g27450 | i0 | 49.4 | 0.91304347826087 | 77 | 39 | 91.3 | 0 | 231 | 1 | 25 | 101 | WEU70947.1 MAG: RNA-dependent RNA polymerase, partial [Hangzhou mito-like virus 9] | diamond | 231 | 77.8 | 1 | Viruses | Orthornavirae | Lenarviricota | Howeltoviricetes | Cryppavirales | Mitoviridae | Hangzhou mito-like virus 9 | |||
| 28359946 | 28359946 | PRJEB58983_P_NODE_566_length_1702_cov_8.300184_g405_i0 | PRJEB58983 | 566 | 1702 | 8.300184 | 141.26913168 | Narnaviridae sp. | 2583949 | Viruses | Viruses | 898 | 0 | NR | UJQ92726.1 | 2583949 | g405 | i0 | 78.6 | 0.987074030552291 | 560 | 120 | 98.7 | 0 | 12 | 1691 | 2 | 561 | UJQ92726.1 MAG: putative RNA-dependent RNA polymerase, partial [Narnaviridae sp.] | diamond | 1680 | 898 | 1 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Wolframvirales | Narnaviridae | Narnaviridae sp. | |||
| 29332109 | 29332109 | PRJEB58983_P_NODE_31169_length_245_cov_0.906977_g30754_i0 | PRJEB58983 | 31169 | 245 | 0.906977 | 2.22209365 | Narnavirus | 186767 | Viruses | Viruses | 94 | 3.6e-20 | NR | QJT93782.1 | 2736407 | g30754 | i0 | 51.9 | 1.98367346938776 | 81 | 39 | 99.2 | 0 | 245 | 3 | 431 | 511 | QJT93782.1 RNA-dependent RNA polymerase [Erysiphe necator associated narnavirus 50] | diamond | 486 | 94 | 1 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Wolframvirales | Narnaviridae | Narnavirus | Erysiphe necator associated narnavirus 50 | ||
| 29402047 | 29402047 | PRJEB58983_P_NODE_5209_length_538_cov_1.827957_g4796_i0 | PRJEB58983 | 5209 | 538 | 1.827957 | 9.83440866 | Mitoviridae sp. | 2809572 | Viruses | Viruses | 173 | 3.36e-47 | NR | UJQ92580.1 | 2809572 | g4796 | i0 | 48.9 | 0.981412639405205 | 176 | 84 | 98.1 | 1 | 529 | 2 | 355 | 524 | UJQ92580.1 MAG: putative RNA-dependent RNA polymerase, partial [Mitoviridae sp.] | diamond | 528 | 173 | 1 | Viruses | Orthornavirae | Lenarviricota | Howeltoviricetes | Cryppavirales | Mitoviridae | Mitoviridae sp. | |||
| 31107701 | 31107701 | PRJEB58983_P_NODE_17635_length_306_cov_3.497854_g17220_i0 | PRJEB58983 | 17635 | 306 | 3.497854 | 10.70343324 | Hangzhou nephotettix cincticeps narnavirus 1 | 2905330 | Viruses | Viruses | 61.6 | 1.83e-8 | NR | UHK03296.1 | 2905330 | g17220 | i0 | 37.9 | 0.852941176470588 | 87 | 52 | 85.3 | 2 | 3 | 263 | 761 | 845 | UHK03296.1 MAG: RNA-dependent DNA polymerase, partial [Hangzhou nephotettix cincticeps narnavirus 1] | diamond | 261 | 61.6 | 1 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Wolframvirales | Narnaviridae | Narnavirus | Hangzhou nephotettix cincticeps narnavirus 1 | ||
| 32341680 | 32341680 | PRJEB58983_P_NODE_2539_length_788_cov_5.328671_g2163_i0 | PRJEB58983 | 2539 | 788 | 5.328671 | 41.98992748 | Hangzhou nephotettix cincticeps narnavirus 1 | 2905330 | Viruses | Viruses | 183 | 8.38e-49 | NR | UHK03296.1 | 2905330 | g2163 | i0 | 42.5 | 0.993654822335025 | 261 | 132 | 97.8 | 6 | 2 | 772 | 148 | 394 | UHK03296.1 MAG: RNA-dependent DNA polymerase, partial [Hangzhou nephotettix cincticeps narnavirus 1] | diamond | 783 | 183 | 1 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Wolframvirales | Narnaviridae | Narnavirus | Hangzhou nephotettix cincticeps narnavirus 1 |
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);;