contig_metadata
8 rows where bioproject = "PRJNA529241", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1774772 | 1774772 | PRJNA529241_P_NODE_2602_length_2569_cov_72713.891390_g2206_i0 | PRJNA529241 | 2602 | 2569 | 72713.89139 | 1868019.8698091 | Narnavirus saccharominor | 3431059 | Viruses | Viruses | 4566 | 0 | NTclustered | gi|21557564|ref|NC_004051.1| | 186772 | g2206 | i0 | 99.443 | 4.84935772674192 | 2514 | 14 | 99 | 0 | 24 | 2537 | 1 | 2514 | Saccharomyces 20S RNA narnavirus, complete genome | blastn | 12458 | 4566 | 1 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Wolframvirales | Narnaviridae | Narnavirus | Narnavirus saccharominor | ||
| 4329635 | 4329635 | PRJNA529241_P_NODE_91624_length_226_cov_1.153439_g89302_i0 | PRJNA529241 | 91624 | 226 | 1.153439 | 2.60677214 | Scleroulivirus epsilonplasmoparae | 2956408 | Viruses | Viruses | 368 | 1.76e-97 | NTclustered | gi|2396039921|gb|ON812983.1| | 2686535 | g89302 | i0 | 96.018 | 3.95575221238938 | 226 | 9 | 100 | 0 | 1 | 226 | 1252 | 1477 | MAG: Plasmopara viticola lesion associated ourmia-like virus 63 isolate TIGMIC_1, complete genome | blastn | 894 | 368 | 1 | Viruses | Orthornavirae | Lenarviricota | Miaviricetes | Ourlivirales | Botourmiaviridae | Scleroulivirus | Scleroulivirus epsilonplasmoparae | ||
| 10706293 | 10706293 | PRJNA529241_P_NODE_63689_length_262_cov_1.386667_g61367_i0 | PRJNA529241 | 63689 | 262 | 1.386667 | 3.63306754 | Scleroulivirus epsilonplasmoparae | 2956408 | Viruses | Viruses | 462 | 9.319999999999999e-126 | NTclustered | gi|2396039921|gb|ON812983.1| | 2686535 | g61367 | i0 | 98.473 | 2.00381679389313 | 262 | 4 | 100 | 0 | 1 | 262 | 2403 | 2142 | MAG: Plasmopara viticola lesion associated ourmia-like virus 63 isolate TIGMIC_1, complete genome | blastn | 525 | 462 | 1 | Viruses | Orthornavirae | Lenarviricota | Miaviricetes | Ourlivirales | Botourmiaviridae | Scleroulivirus | Scleroulivirus epsilonplasmoparae | ||
| 13252211 | 13252211 | PRJNA529241_P_NODE_12551_length_711_cov_4.876855_g10734_i0 | PRJNA529241 | 12551 | 711 | 4.876855 | 34.67443905 | Scleroulivirus epsilonplasmoparae | 2956408 | Viruses | Viruses | 93.5 | 4.19e-14 | NTclustered | gi|2396039976|gb|ON813000.1| | 2686535 | g10734 | i0 | 98.113 | 0.115330520393812 | 53 | 1 | 7 | 0 | 1 | 53 | 5 | 57 | MAG: Plasmopara viticola lesion associated ourmia-like virus 63 isolate TIGMIC_2, complete genome | blastn | 82 | 93.5 | 1 | Viruses | Orthornavirae | Lenarviricota | Miaviricetes | Ourlivirales | Botourmiaviridae | Scleroulivirus | Scleroulivirus epsilonplasmoparae | ||
| 13252609 | 13252609 | PRJNA529241_P_NODE_158251_length_182_cov_1.000000_g155929_i0 | PRJNA529241 | 158251 | 182 | 1 | 1.82 | Andihavirus borborohabitans | 2843692 | Viruses | Viruses | 189 | 1.13e-43 | NTclustered | gi|2497515024|ref|NC_074146.1| | 2786658 | g155929 | i0 | 95.726 | 148.082417582418 | 117 | 5 | 64 | 0 | 1 | 117 | 3871 | 3987 | SsRNA phage SRR7976300_9 genomic sequence | blastn | 26951 | 189 | 1 | Viruses | Orthornavirae | Lenarviricota | Leviviricetes | Norzivirales | Solspiviridae | Andihavirus | Andihavirus borborohabitans | ||
| 15803367 | 15803367 | PRJNA529241_P_NODE_412173_length_171_cov_1.164179_g409851_i0 | PRJNA529241 | 412173 | 171 | 1.164179 | 1.99074609 | Erysiphe necator associated ourmia-like virus 117 | 2741777 | Viruses | Viruses | 244 | 2.2e-60 | NTclustered | gi|1848976765|gb|MN611644.1| | 2741777 | g409851 | i0 | 92.941 | 3.50877192982456 | 170 | 9 | 98 | 3 | 1 | 168 | 1959 | 2127 | Erysiphe necator associated ourmia-like virus 117 isolate PMS8_103 RNA-dependent RNA polymerase gene, complete cds | blastn | 600 | 244 | 1 | Viruses | Orthornavirae | Lenarviricota | Miaviricetes | Ourlivirales | Botourmiaviridae | Ourmiavirus | Erysiphe necator associated ourmia-like virus 117 | ||
| 19624157 | 19624157 | PRJNA529241_P_NODE_109836_length_210_cov_1.057803_g107514_i0 | PRJNA529241 | 109836 | 210 | 1.057803 | 2.2213863 | Scleroulivirus epsilonplasmoparae | 2956408 | Viruses | Viruses | 355 | 1.25e-93 | NTclustered | gi|2396039976|gb|ON813000.1| | 2686535 | g107514 | i0 | 97.143 | 9.14761904761905 | 210 | 6 | 100 | 0 | 1 | 210 | 1794 | 1585 | MAG: Plasmopara viticola lesion associated ourmia-like virus 63 isolate TIGMIC_2, complete genome | blastn | 1921 | 355 | 1 | Viruses | Orthornavirae | Lenarviricota | Miaviricetes | Ourlivirales | Botourmiaviridae | Scleroulivirus | Scleroulivirus epsilonplasmoparae | ||
| 24724438 | 24724438 | PRJNA529241_P_NODE_130700_length_196_cov_1.471698_g128378_i0 | PRJNA529241 | 130700 | 196 | 1.471698 | 2.88452808 | Scleroulivirus epsilonplasmoparae | 2956408 | Viruses | Viruses | 331 | 1.94e-86 | NTclustered | gi|2396039921|gb|ON812983.1| | 2686535 | g128378 | i0 | 97.423 | 1.97959183673469 | 194 | 5 | 99 | 0 | 1 | 194 | 1975 | 2168 | MAG: Plasmopara viticola lesion associated ourmia-like virus 63 isolate TIGMIC_1, complete genome | blastn | 388 | 331 | 1 | Viruses | Orthornavirae | Lenarviricota | Miaviricetes | Ourlivirales | Botourmiaviridae | Scleroulivirus | Scleroulivirus epsilonplasmoparae |
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);;