contig_metadata
4 rows where bioproject = "PRJNA704949", tax_clade = "Pithoviruses" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 27410368 | 27410368 | PRJNA704949_P_NODE_388403_length_436_cov_1.478036_g373319_i0 | PRJNA704949 | 388403 | 436 | 1.478036 | 6.44423696 | root | 1 | Root_unresolved | Root_unresolved | 110 | 6.53e-26 | NR | QBK89626.1 | 2506585 | g373319 | i0 | 43.7 | 1.73394495412844 | 126 | 69 | 85.3 | 1 | 435 | 64 | 163 | 288 | QBK89626.1 MAG: DNA repair exonuclease [Pithovirus LCPAC001] | diamond | 756 | 110 | 1 | Viruses | Pithoviruses | Pithovirus LCPAC001 | |||||||
| 29010106 | 29010106 | PRJNA704949_P_NODE_645368_length_337_cov_1.444444_g630042_i0 | PRJNA704949 | 645368 | 337 | 1.444444 | 4.86777628 | Pithovirus LCPAC4 | 2506597 | Viruses | Viruses | 124 | 3.53e-32 | NR | QBK93439.1 | 2506597 | g630042 | i0 | 51.5 | 1.72700296735905 | 97 | 47 | 86.4 | 0 | 320 | 30 | 141 | 237 | QBK93439.1 MAG: 2OG-Fe(II) oxygenase superfamily protein [Pithovirus LCPAC404] | diamond | 582 | 124 | 1 | Viruses | Pithoviruses | Pithovirus LCPAC404 | |||||||
| 29041192 | 29041192 | PRJNA704949_P_NODE_1599788_length_193_cov_1.027778_g1584449_i0 | PRJNA704949 | 1599788 | 193 | 1.027778 | 1.98361154 | Pithovirus LCPAC4 | 2506595 | Viruses | Viruses | 54.7 | 1.11e-6 | NR | QBK92445.1 | 2506595 | g1584449 | i0 | 42.1 | 1.75647668393782 | 57 | 31 | 88.6 | 2 | 191 | 21 | 282 | 336 | QBK92445.1 MAG: DNA primase [Pithovirus LCPAC401] | diamond | 339 | 54.7 | 1 | Viruses | Pithoviruses | Pithovirus LCPAC401 | |||||||
| 29482783 | 29482783 | PRJNA704949_P_NODE_1687670_length_186_cov_1.138686_g1672331_i0 | PRJNA704949 | 1687670 | 186 | 1.138686 | 2.11795596 | Solumvirus sp. | 2487773 | Viruses | Viruses | 42.7 | 0.0179 | NR | AYV86312.1 | 2487773 | g1672331 | i0 | 38.6 | 0.709677419354839 | 44 | 27 | 71 | 0 | 31 | 162 | 260 | 303 | AYV86312.1 MAG: hypothetical protein Solumvirus4_10 [Solumvirus sp.] | diamond | 132 | 42.7 | 1 | Viruses | Pithoviruses | Solumvirus 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);;