contig_metadata
4 rows where bioproject = "PRJEB12296", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 25772649 | 25772649 | PRJEB12296_S_NODE_10675_length_170_cov_3.703704_g10643_i0 | PRJEB12296 | 10675 | 170 | 3.703704 | 6.2962968 | Candidatus Melainabacteria bacterium | 2052166 | Bacteria | Bacteria | 163 | 6.29e-36 | NTclustered | gi|1958007833|gb|CP064963.1| | 2052166 | g10643 | i0 | 90.909 | 3.70588235294118 | 121 | 11 | 71 | 0 | 33 | 153 | 3679474 | 3679594 | MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome | blastn | 630 | 163 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Melainabacteria bacterium | |||||
| 25772856 | 25772856 | PRJEB12296_S_NODE_683_length_408_cov_5.211796_g652_i0 | PRJEB12296 | 683 | 408 | 5.211796 | 21.26412768 | Candidatus Melainabacteria bacterium | 2052166 | Bacteria | Bacteria | 364 | 4.429999999999999e-96 | NTclustered | gi|1958007833|gb|CP064963.1| | 2052166 | g652 | i0 | 84.433 | 33.6372549019608 | 379 | 50 | 92 | 8 | 6 | 380 | 3681251 | 3680878 | MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome | blastn | 13724 | 364 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Melainabacteria bacterium | |||||
| 25908895 | 25908895 | PRJEB12296_S_NODE_2228_length_285_cov_7580.336000_g2196_i0 | PRJEB12296 | 2228 | 285 | 7580.336 | 21603.9576 | Candidatus Melainabacteria bacterium | 2052166 | Bacteria | Bacteria | 278 | 3.9900000000000005e-70 | NTclustered | gi|1958007833|gb|CP064963.1| | 2052166 | g2196 | i0 | 87.815 | 49.3017543859649 | 238 | 28 | 83 | 1 | 1 | 237 | 3679989 | 3679752 | MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome | blastn | 14051 | 278 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Melainabacteria bacterium | |||||
| 26316902 | 26316902 | PRJEB12296_S_NODE_263_length_546_cov_45.600783_g240_i0 | PRJEB12296 | 263 | 546 | 45.600783 | 248.98027518 | Candidatus Melainabacteria bacterium | 2052166 | Bacteria | Bacteria | 520 | 1.22e-142 | NTclustered | gi|1958007833|gb|CP064963.1| | 2052166 | g240 | i0 | 85.573 | 236.227106227106 | 506 | 61 | 92 | 11 | 31 | 530 | 3682681 | 3682182 | MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome | blastn | 128980 | 520 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Melainabacteria bacterium |
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);;