contig_metadata
7 rows where bioproject = "PRJNA358049" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1673414 | 1673414 | PRJNA358049_S_NODE_4202_length_293_cov_2.815574_g4154_i0 | PRJNA358049 | 4202 | 293 | 2.815574 | 8.24963182 | Hulunbuir Botou tick virus 1 | 2972048 | Viruses | Viruses | 135 | 2.6200000000000003e-27 | NTclustered | gi|2319492089|gb|ON746338.1| | 2972048 | g4154 | i0 | 98.684 | 1.33105802047782 | 76 | 1 | 26 | 0 | 195 | 270 | 101 | 26 | MAG: Hulunbuir Botou tick virus 1 isolate TIGMIC 7 genomic sequence | blastn | 390 | 135 | 1 | Viruses | Orthornavirae | Lenarviricota | Miaviricetes | Ourlivirales | Botourmiaviridae | Hulunbuir Botou tick virus 1 | |||
| 4901101 | 4901101 | PRJNA358049_S_NODE_4_length_2870_cov_5.184332_g3_i0 | PRJNA358049 | 4 | 2870 | 5.184332 | 148.7903284 | Viruses | 10239 | Viruses | Viruses | 3345 | 0 | NTclustered | gi|2396039623|gb|ON812886.1| | 2808997 | g3 | i0 | 87.987 | 13.4801393728223 | 2847 | 322 | 99 | 17 | 1 | 2839 | 2835 | 1 | MAG: Botourmiaviridae sp. isolate TIGMIC_3, complete genome | blastn | 38688 | 3345 | 1 | Viruses | Orthornavirae | Lenarviricota | Miaviricetes | Ourlivirales | Botourmiaviridae | Botourmiaviridae sp. | |||
| 10602551 | 10602551 | PRJNA358049_S_NODE_69_length_1389_cov_5.918657_g58_i0 | PRJNA358049 | 69 | 1389 | 5.918657 | 82.21014573 | Erysiphe necator associated ourmia-like virus 36 | 2741816 | Viruses | Viruses | 970 | 0 | NTclustered | gi|1848976605|gb|MN611564.1| | 2741816 | g58 | i0 | 79.458 | 1.66810655147588 | 1402 | 262 | 100 | 24 | 1 | 1389 | 2149 | 761 | Erysiphe necator associated ourmia-like virus 36 isolate PMS12_DN11639, complete genome | blastn | 2317 | 970 | 1 | Viruses | Orthornavirae | Lenarviricota | Miaviricetes | Ourlivirales | Botourmiaviridae | Ourmiavirus | Erysiphe necator associated ourmia-like virus 36 | ||
| 27074833 | 27074833 | PRJNA358049_S_NODE_7102_length_233_cov_2.342391_g7054_i0 | PRJNA358049 | 7102 | 233 | 2.342391 | 5.45777103 | Botourmiaviridae sp. | 2808997 | Viruses | Viruses | 70.5 | 5.47e-12 | NR | WAK77862.1 | 2808997 | g7054 | i0 | 45.9 | 0.952789699570815 | 74 | 38 | 95.3 | 1 | 231 | 10 | 440 | 511 | WAK77862.1 MAG: hypothetical protein [Botourmiaviridae sp.] | diamond | 222 | 70.5 | 1 | Viruses | Orthornavirae | Lenarviricota | Miaviricetes | Ourlivirales | Botourmiaviridae | Botourmiaviridae sp. | |||
| 27801530 | 27801530 | PRJNA358049_S_NODE_13244_length_183_cov_1.156716_g13196_i0 | PRJNA358049 | 13244 | 183 | 1.156716 | 2.11679028 | Erysiphe necator associated ourmia-like virus 36 | 2741816 | Viruses | Viruses | 103 | 8.289999999999999e-24 | NR | QKI79866.1 | 2741816 | g13196 | i0 | 73.3 | 1.95081967213115 | 60 | 16 | 98.4 | 0 | 182 | 3 | 81 | 140 | QKI79866.1 RNA-dependent RNA polymerase [Erysiphe necator associated ourmia-like virus 36] | diamond | 357 | 103 | 1 | Viruses | Orthornavirae | Lenarviricota | Miaviricetes | Ourlivirales | Botourmiaviridae | Ourmiavirus | Erysiphe necator associated ourmia-like virus 36 | ||
| 29127731 | 29127731 | PRJNA358049_S_NODE_2309_length_386_cov_4.899110_g2261_i0 | PRJNA358049 | 2309 | 386 | 4.89911 | 18.9105646 | Erysiphe necator associated ourmia-like virus 36 | 2741816 | Viruses | Viruses | 223 | 5.859999999999999e-67 | NR | QKI79866.1 | 2741816 | g2261 | i0 | 80.5 | 0.994818652849741 | 128 | 25 | 99.5 | 0 | 2 | 385 | 132 | 259 | QKI79866.1 RNA-dependent RNA polymerase [Erysiphe necator associated ourmia-like virus 36] | diamond | 384 | 223 | 1 | Viruses | Orthornavirae | Lenarviricota | Miaviricetes | Ourlivirales | Botourmiaviridae | Ourmiavirus | Erysiphe necator associated ourmia-like virus 36 | ||
| 31988506 | 31988506 | PRJNA358049_S_NODE_3038_length_341_cov_1.989726_g2990_i0 | PRJNA358049 | 3038 | 341 | 1.989726 | 6.78496566 | Viruses | 10239 | Viruses | Viruses | 133 | 1.49e-33 | NR | WAK77979.1 | 2808997 | g2990 | i0 | 61.4 | 8.4633431085044 | 114 | 42 | 99.4 | 2 | 2 | 340 | 339 | 451 | WAK77979.1 MAG: hypothetical protein [Botourmiaviridae sp.] | diamond | 2886 | 133 | 1 | Viruses | Orthornavirae | Lenarviricota | Miaviricetes | Ourlivirales | Botourmiaviridae | Botourmiaviridae sp. |
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);;