contig_metadata
4 rows where bioproject = "PRJNA680334", tax_clade = "Cyanobacteriota/Melainabacteria group" and tax_phylum = "Candidatus Melainabacteria"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 29639477 | 29639477 | PRJNA680334_S_NODE_51490_length_190_cov_2.910828_g51004_i0 | PRJNA680334 | 51490 | 190 | 2.910828 | 5.5305732 | Candidatus Caenarcanales bacterium | 2729995 | Bacteria | Bacteria | 90.5 | 2.75e-22 | NR | HEY9847579.1 | 2729995 | g51004 | i0 | 81.1 | 3.37894736842105 | 53 | 10 | 83.7 | 0 | 5 | 163 | 8 | 60 | HEY9847579.1 hypothetical protein [Candidatus Caenarcanales bacterium] | diamond | 642 | 90.5 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Vampirovibriophyceae | Candidatus Caenarcanales | Candidatus Caenarcanales bacterium | |||
| 29841033 | 29841033 | PRJNA680334_S_NODE_102571_length_152_cov_3.394958_g102085_i0 | PRJNA680334 | 102571 | 152 | 3.394958 | 5.16033616 | Bacillati | 1783272 | Bacteria | Bacteria | 80.9 | 3.48e-16 | NR | RTL38399.1 | 2052166 | g102085 | i0 | 78.3 | 2.72368421052632 | 46 | 10 | 90.8 | 0 | 6 | 143 | 243 | 288 | RTL38399.1 MAG: MFS transporter [Candidatus Melainabacteria bacterium] | diamond | 414 | 81.6 | 0.991421568627451 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Melainabacteria bacterium | |||||
| 30618996 | 30618996 | PRJNA680334_S_NODE_41133_length_204_cov_2.087719_g40647_i0 | PRJNA680334 | 41133 | 204 | 2.087719 | 4.25894676 | Candidatus Obscuribacter sp. | 2711154 | Bacteria | Bacteria | 71.6 | 1.04e-14 | NR | HMY52145.1 | 2711154 | g40647 | i0 | 77.8 | 0.661764705882353 | 45 | 10 | 66.2 | 0 | 142 | 8 | 1 | 45 | HMY52145.1 hypothetical protein [Candidatus Obscuribacter sp.] | diamond | 135 | 71.6 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Obscuribacterales | Candidatus Obscuribacteraceae | Candidatus Obscuribacter | Candidatus Obscuribacter sp. | ||
| 32611157 | 32611157 | PRJNA680334_S_NODE_13980_length_283_cov_32.416000_g13494_i0 | PRJNA680334 | 13980 | 283 | 32.416 | 91.73728 | Candidatus Melainabacteria bacterium HGW-Melainabacteria-1 | 2013813 | Bacteria | Bacteria | 128 | 7.780000000000001e-33 | NR | PKL79379.1 | 2013813 | g13494 | i0 | 76.2 | 0.890459363957597 | 84 | 20 | 89 | 0 | 279 | 28 | 43 | 126 | PKL79379.1 MAG: hypothetical protein CVV27_01985, partial [Candidatus Melainabacteria bacterium HGW-Melainabacteria-1] | diamond | 252 | 128 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Melainabacteria bacterium HGW-Melainabacteria-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);;