contig_metadata
20 rows where bioproject = "PRJNA505329" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1758766 | 1758766 | PRJNA505329_P_NODE_7122_length_274_cov_5.942222_g6651_i0 | PRJNA505329 | 7122 | 274 | 5.942222 | 16.28168828 | Leptosphaeria biglobosa narnavirus 2 | 2985677 | Viruses | Viruses | 66.2 | 2.94e-10 | NR | UYL94517.1 | 2985677 | g6651 | i0 | 66 | 1.08394160583942 | 50 | 16 | 53.6 | 1 | 271 | 125 | 655 | 704 | UYL94517.1 MAG: hypothetical protein [Leptosphaeria biglobosa narnavirus 2] | diamond | 297 | 66.2 | 1 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Wolframvirales | Narnaviridae | Narnavirus | Leptosphaeria biglobosa narnavirus 2 | ||
| 2385881 | 2385881 | PRJNA505329_P_NODE_37302_length_176_cov_1.629921_g36831_i0 | PRJNA505329 | 37302 | 176 | 1.629921 | 2.86866096 | Tobamovirus | 12234 | Viruses | Viruses | 307 | 2.87e-79 | NTclustered | gi|139866184|dbj|AB276030.1| | 12239 | g36831 | i0 | 98.844 | 92.5909090909091 | 173 | 1 | 98 | 1 | 4 | 175 | 4990 | 5162 | Pepper mild mottle virus genomic RNA, complete genome, strain: L4BV | blastn | 16296 | 307 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Virgaviridae | Tobamovirus | Tobamovirus capsici | ||
| 3034725 | 3034725 | PRJNA505329_P_NODE_52663_length_151_cov_5.480392_g52192_i0 | PRJNA505329 | 52663 | 151 | 5.480392 | 8.27539192 | Alphanodavirus flockense | 3426214 | Viruses | Viruses | 279 | 5.19e-71 | NTclustered | gi|2775959247|dbj|LC831259.1| | 12287 | g52192 | i0 | 100 | 4.98675496688742 | 151 | 0 | 100 | 0 | 1 | 151 | 891 | 741 | Flock House virus TNCL gene for capsid precursor protein alpha, segment RNA2, complete cds | blastn | 753 | 279 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Magsaviricetes | Nodamuvirales | Nodaviridae | Alphanodavirus | Alphanodavirus flockense | ||
| 7488434 | 7488434 | PRJNA505329_P_NODE_34586_length_180_cov_2.343511_g34115_i0 | PRJNA505329 | 34586 | 180 | 2.343511 | 4.2183198 | Wolframvirales | 2732502 | Viruses | Viruses | 248 | 1.81e-61 | NTclustered | gi|2577295406|gb|OQ980198.1| | 2719503 | g34115 | i0 | 92.045 | 1.95 | 176 | 14 | 98 | 0 | 4 | 179 | 409 | 234 | MAG: Downy mildew lesion associated splipalmivirus 2 isolate DMG-E segment RNA3, partial sequence | blastn | 351 | 248 | 1 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Wolframvirales | Narnaviridae | Narnavirus | Downy mildew lesion associated splipalmivirus 2 | ||
| 8136487 | 8136487 | PRJNA505329_P_NODE_28867_length_189_cov_1.464286_g28396_i0 | PRJNA505329 | 28867 | 189 | 1.464286 | 2.76750054 | Malassezia restricta virus MrV40L | 2727863 | Viruses | Viruses | 315 | 1.8699999999999998e-81 | NTclustered | gi|1832308141|gb|MN603497.1| | 2727863 | g28396 | i0 | 97.297 | 1.35449735449735 | 185 | 5 | 98 | 0 | 2 | 186 | 2844 | 3028 | Malassezia restricta virus MrV40L, complete genome | blastn | 256 | 315 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Totiviridae | Malassezia restricta virus MrV40L | |||
| 9411756 | 9411756 | PRJNA505329_P_NODE_7548_length_265_cov_3.606481_g7077_i0 | PRJNA505329 | 7548 | 265 | 3.606481 | 9.55717465 | Chemarfal virus 260 | 3063286 | Viruses | Viruses | 224 | 4.8499999999999997e-54 | NTclustered | gi|2626079958|gb|OR270550.1| | 3063286 | g7077 | i0 | 94.483 | 0.916981132075472 | 145 | 8 | 92 | 0 | 3 | 147 | 7 | 151 | MAG: Chemarfal virus 260 isolate ML188 genomic sequence | blastn | 243 | 224 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Chemarfal virus 260 | ||||
| 13237000 | 13237000 | PRJNA505329_P_NODE_111_length_3140_cov_101.013911_g87_i0 | PRJNA505329 | 111 | 3140 | 101.013911 | 3171.8368054 | Alphanodavirus flockense | 3426214 | Viruses | Viruses | 5655 | 0 | NTclustered | gi|2775959219|dbj|LC831249.1| | 12287 | g87 | i0 | 99.518 | 45.5630573248408 | 3109 | 12 | 99 | 3 | 5 | 3112 | 1 | 3107 | Flock House virus TNCL gene for Protein A and Protein B2, segment RNA1, complete cds | blastn | 143068 | 5655 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Magsaviricetes | Nodamuvirales | Nodaviridae | Alphanodavirus | Alphanodavirus flockense | ||
| 13237454 | 13237454 | PRJNA505329_P_NODE_46091_length_165_cov_1.784483_g45620_i0 | PRJNA505329 | 46091 | 165 | 1.784483 | 2.94439695 | Chemarfal virus 260 | 3063286 | Viruses | Viruses | 300 | 4.46e-77 | NTclustered | gi|2626079958|gb|OR270550.1| | 3063286 | g45620 | i0 | 99.398 | 1.00606060606061 | 166 | 0 | 100 | 1 | 1 | 165 | 779 | 944 | MAG: Chemarfal virus 260 isolate ML188 genomic sequence | blastn | 166 | 300 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Chemarfal virus 260 | ||||
| 15786336 | 15786336 | PRJNA505329_P_NODE_5273_length_334_cov_3.210526_g4803_i0 | PRJNA505329 | 5273 | 334 | 3.210526 | 10.72315684 | Alphanodavirus flockense | 3426214 | Viruses | Viruses | 603 | 6.929999999999998e-168 | NTclustered | gi|2775959247|dbj|LC831259.1| | 12287 | g4803 | i0 | 100 | 6.82035928143713 | 326 | 0 | 98 | 0 | 3 | 328 | 887 | 1212 | Flock House virus TNCL gene for capsid precursor protein alpha, segment RNA2, complete cds | blastn | 2278 | 603 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Magsaviricetes | Nodamuvirales | Nodaviridae | Alphanodavirus | Alphanodavirus flockense | ||
| 19609378 | 19609378 | PRJNA505329_P_NODE_2996_length_524_cov_48.745263_g2559_i0 | PRJNA505329 | 2996 | 524 | 48.745263 | 255.42517812 | Alphanodavirus flockense | 3426214 | Viruses | Viruses | 387 | 1.24e-102 | NTclustered | gi|152143030|gb|EF690538.1| | 12287 | g2559 | i0 | 99.528 | 6.66221374045802 | 212 | 1 | 94 | 0 | 4 | 215 | 42 | 253 | Flock house virus isolate TNCL segment RNA2 protein alpha mRNA, complete cds | blastn | 3491 | 387 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Magsaviricetes | Nodamuvirales | Nodaviridae | Alphanodavirus | Alphanodavirus flockense | ||
| 26760469 | 26760469 | PRJNA505329_P_NODE_10001_length_233_cov_4.967391_g9530_i0 | PRJNA505329 | 10001 | 233 | 4.967391 | 11.57402103 | Bangxi Parti tick virus 1 | 2972278 | Viruses | Viruses | 115 | 3.61e-28 | NR | UYL95500.1 | 2972278 | g9530 | i0 | 73.7 | 2.93562231759657 | 76 | 11 | 97.9 | 1 | 6 | 233 | 430 | 496 | UYL95500.1 MAG: RNA-dependent RNA polymerase [Bangxi Parti tick virus 1] | diamond | 684 | 115 | 1 | Viruses | Orthornavirae | Pisuviricota | Duplopiviricetes | Durnavirales | Partitiviridae | Bangxi Parti tick virus 1 | |||
| 27993166 | 27993166 | PRJNA505329_P_NODE_18665_length_206_cov_3.254777_g18194_i0 | PRJNA505329 | 18665 | 206 | 3.254777 | 6.70484062 | Botourmiaviridae sp. | 2808997 | Viruses | Viruses | 48.1 | 2.87e-4 | NR | UJQ91980.1 | 2808997 | g18194 | i0 | 40.3 | 0.975728155339806 | 67 | 35 | 90.3 | 2 | 197 | 12 | 596 | 662 | UJQ91980.1 MAG: putative RNA-dependent RNA polymerase, partial [Botourmiaviridae sp.] | diamond | 201 | 48.1 | 1 | Viruses | Orthornavirae | Lenarviricota | Miaviricetes | Ourlivirales | Botourmiaviridae | Botourmiaviridae sp. | |||
| 28561534 | 28561534 | PRJNA505329_P_NODE_45247_length_166_cov_1.461538_g44776_i0 | PRJNA505329 | 45247 | 166 | 1.461538 | 2.42615308 | Totivirus sp. | 2776824 | Viruses | Viruses | 92.4 | 3.11e-20 | NR | QOQ37362.1 | 2776824 | g44776 | i0 | 72.7 | 1.98795180722892 | 55 | 15 | 99.4 | 0 | 165 | 1 | 320 | 374 | QOQ37362.1 RNA-dependent RNA polymerase, partial [Totivirus sp.] | diamond | 330 | 92.4 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Orthototiviridae | Totivirus | Totivirus sp. | ||
| 29334644 | 29334644 | PRJNA505329_P_NODE_1949_length_746_cov_5.152080_g1573_i0 | PRJNA505329 | 1949 | 746 | 5.15208 | 38.4345168 | Viruses | 10239 | Viruses | Viruses | 130 | 5.28e-33 | NR | QKN84405.1 | 2735226 | g1573 | i0 | 43.1 | 2.83109919571046 | 181 | 94 | 71.6 | 3 | 211 | 744 | 39 | 213 | QKN84405.1 hypothetical protein [Rice Tombus-like virus 3] | diamond | 2112 | 130 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Tolucaviricetes | Tolivirales | Tombusviridae | Rice Tombus-like virus 3 | |||
| 29413789 | 29413789 | PRJNA505329_P_NODE_16549_length_233_cov_0.983696_g16078_i0 | PRJNA505329 | 16549 | 233 | 0.983696 | 2.29201168 | Malassezia restricta associated totivirus 1 | 3048757 | Viruses | Viruses | 139 | 1.87e-36 | NR | CAI9858976.1 | 3048757 | g16078 | i0 | 94.7 | 0.978540772532189 | 76 | 4 | 97.9 | 0 | 228 | 1 | 536 | 611 | CAI9858976.1 polyprotein, partial [Malassezia restricta associated totivirus 1] | diamond | 228 | 139 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Orthototiviridae | Totivirus | Malassezia restricta associated totivirus 1 | ||
| 29919256 | 29919256 | PRJNA505329_P_NODE_11311_length_233_cov_3.521739_g10840_i0 | PRJNA505329 | 11311 | 233 | 3.521739 | 8.20565187 | Malassezia globosa associated totivirus 1 | 3048756 | Viruses | Viruses | 44.7 | 0.00687 | NR | CAI9858974.1 | 3048756 | g10840 | i0 | 64.5 | 1.19742489270386 | 31 | 11 | 39.9 | 0 | 4 | 96 | 49 | 79 | CAI9858974.1 capsid protein [Malassezia globosa associated totivirus 1] | diamond | 279 | 44.7 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Orthototiviridae | Totivirus | Malassezia globosa associated totivirus 1 | ||
| 30060786 | 30060786 | PRJNA505329_P_NODE_13391_length_233_cov_2.788043_g12920_i0 | PRJNA505329 | 13391 | 233 | 2.788043 | 6.49614019 | Ghabrivirales | 2732540 | Viruses | Viruses | 52.8 | 9.61e-6 | NR | WAK77685.1 | 1955172 | g12920 | i0 | 59.4 | 2.47210300429185 | 32 | 13 | 41.2 | 0 | 137 | 232 | 316 | 347 | WAK77685.1 MAG: polyprotein [Totiviridae sp.] | diamond | 576 | 52.8 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Totiviridae | Totiviridae sp. | |||
| 30692777 | 30692777 | PRJNA505329_P_NODE_8693_length_245_cov_3.760204_g8222_i0 | PRJNA505329 | 8693 | 245 | 3.760204 | 9.2124998 | Magoulivirus | 2560172 | Viruses | Viruses | 131 | 1.73e-33 | NR | YP_010797622.1 | 2485924 | g8222 | i0 | 75 | 4.93469387755102 | 80 | 20 | 98 | 0 | 243 | 4 | 266 | 345 | YP_010797622.1 RNA-dependent RNA polymerase [Penicillium citrinum ourmia-like virus 1] | diamond | 1209 | 131 | 1 | Viruses | Orthornavirae | Lenarviricota | Miaviricetes | Ourlivirales | Botourmiaviridae | Magoulivirus | Magoulivirus penicillii | ||
| 32052418 | 32052418 | PRJNA505329_P_NODE_25818_length_193_cov_2.812500_g25347_i0 | PRJNA505329 | 25818 | 193 | 2.8125 | 5.428125 | Ghabrivirales | 2732540 | Viruses | Viruses | 112 | 4.7100000000000006e-27 | NR | WAK77449.1 | 1955172 | g25347 | i0 | 77.8 | 8.81347150259067 | 63 | 14 | 97.9 | 0 | 3 | 191 | 311 | 373 | WAK77449.1 MAG: polyprotein, partial [Totiviridae sp.] | diamond | 1701 | 112 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Totiviridae | Totiviridae sp. | |||
| 32543419 | 32543419 | PRJNA505329_P_NODE_33879_length_181_cov_2.340909_g33408_i0 | PRJNA505329 | 33879 | 181 | 2.340909 | 4.23704529 | Malassezia globosa associated totivirus 1 | 3048756 | Viruses | Viruses | 113 | 1.89e-27 | NR | CAI9858973.1 | 3048756 | g33408 | i0 | 91.5 | 0.977900552486188 | 59 | 5 | 97.8 | 0 | 180 | 4 | 85 | 143 | CAI9858973.1 RNA-dependent RNA polymerase [Malassezia globosa associated totivirus 1] | diamond | 177 | 113 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Orthototiviridae | Totivirus | Malassezia globosa associated totivirus 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);;