contig_metadata
11 rows where analysis = "diamond", 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 | ||
| 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);;