contig_metadata
4 rows where bioproject = "PRJNA911178", tax_phylum = "Phixviricota" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 20018783 | 20018783 | PRJNA911178_P_NODE_210756_length_266_cov_1.253886_g208282_i0 | PRJNA911178 | 210756 | 266 | 1.253886 | 3.33533676 | uncultured marine Microviridae | 1385659 | Viruses | Viruses | 268 | 2.22e-67 | NTclustered | gi|530695295|gb|KC130997.1| | 1385659 | g208282 | i0 | 85.771 | 0.951127819548872 | 253 | 36 | 95 | 0 | 8 | 260 | 599 | 347 | Uncultured marine Microviridae clone SI-16 major capsid protein gene, partial cds | blastn | 253 | 268 | 1 | Viruses | Sangervirae | Phixviricota | Malgrandaviricetes | Petitvirales | Microviridae | uncultured marine Microviridae | |||
| 26644373 | 26644373 | PRJNA911178_P_NODE_187221_length_279_cov_1.179612_g184748_i0 | PRJNA911178 | 187221 | 279 | 1.179612 | 3.29111748 | Microviridae sp. | 2202644 | Viruses | Viruses | 42.4 | 0.0282 | NR | AXH74273.1 | 2202644 | g184748 | i0 | 53.7 | 0.440860215053763 | 41 | 18 | 43 | 1 | 11 | 130 | 42 | 82 | AXH74273.1 MAG: hypothetical protein [Microviridae sp.] | diamond | 123 | 42.4 | 1 | Viruses | Sangervirae | Phixviricota | Malgrandaviricetes | Petitvirales | Microviridae | Microviridae sp. | |||
| 29613570 | 29613570 | PRJNA911178_P_NODE_54750_length_470_cov_1.390428_g52314_i0 | PRJNA911178 | 54750 | 470 | 1.390428 | 6.5350116 | Ariapismic virus 126 | 3376355 | Viruses | Viruses | 161 | 5.2999999999999994e-46 | NR | XJW04970.1 | 3376355 | g52314 | i0 | 50 | 1.03404255319149 | 162 | 69 | 98.3 | 5 | 1 | 462 | 17 | 174 | XJW04970.1 MAG: replication initiator protein [Ariapismic virus 126] | diamond | 486 | 161 | 1 | Viruses | Sangervirae | Phixviricota | Malgrandaviricetes | Petitvirales | Microviridae | Ariapismic virus 126 | |||
| 32301082 | 32301082 | PRJNA911178_P_NODE_82579_length_392_cov_0.918495_g80112_i0 | PRJNA911178 | 82579 | 392 | 0.918495 | 3.6005004 | Microvirus sp. | 2202559 | Viruses | Viruses | 107 | 1.27e-26 | NR | UXQ88076.1 | 2202559 | g80112 | i0 | 54.1 | 0.849489795918367 | 111 | 42 | 84.2 | 3 | 384 | 55 | 48 | 150 | UXQ88076.1 MAG: hypothetical protein [Microvirus sp.] | diamond | 333 | 107 | 1 | Viruses | Sangervirae | Phixviricota | Malgrandaviricetes | Petitvirales | Microviridae | Microvirus 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);;