contig_metadata
4 rows where bioproject = "PRJNA400391", tax_clade = "Bacteria candidate phyla" and tax_phylum = "Candidatus Saccharimonadota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 10618011 | 10618011 | PRJNA400391_S_NODE_4749_length_183_cov_1.986486_g4688_i0 | PRJNA400391 | 4749 | 183 | 1.986486 | 3.63526938 | Candidatus Saccharimonadota bacterium | 2026720 | Bacteria | Bacteria | 255 | 1.11e-63 | NTclustered | gi|1958073143|gb|CP064993.1| | 2026720 | g4688 | i0 | 92.697 | 123.16393442623 | 178 | 12 | 97 | 1 | 1 | 178 | 595610 | 595434 | Candidatus Saccharibacteria bacterium isolate Hirt_18-Q3-R61-65_MAXAC.330_cln chromosome, complete genome | blastn | 22539 | 255 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadota bacterium | ||||||
| 10618014 | 10618014 | PRJNA400391_S_NODE_4849_length_181_cov_1.897260_g4788_i0 | PRJNA400391 | 4849 | 181 | 1.89726 | 3.4340406 | Candidatus Saccharimonadota bacterium | 2026720 | Bacteria | Bacteria | 230 | 6.62e-56 | NTclustered | gi|1474570736|gb|CP023991.1| | 2026720 | g4788 | i0 | 92.5 | 74.6077348066298 | 160 | 12 | 88 | 0 | 22 | 181 | 883927 | 884086 | Candidatus Saccharibacteria bacterium isolate CG19_WC_8_21_14_NA_150_51_44 chromosome, complete genome | blastn | 13504 | 230 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadota bacterium | ||||||
| 14443045 | 14443045 | PRJNA400391_S_NODE_5232_length_173_cov_1.224638_g5171_i0 | PRJNA400391 | 5232 | 173 | 1.224638 | 2.11862374 | Candidatus Saccharimonadia bacterium | 2890869 | Bacteria | Bacteria | 150 | 5.009999999999999e-32 | NTclustered | gi|2874254002|emb|OY970327.1| | 2890869 | g5171 | i0 | 87.218 | 123.947976878613 | 133 | 16 | 77 | 1 | 28 | 160 | 680293 | 680162 | MAG: Candidatus Saccharimonadia bacterium isolate MFD01275.bin.c.7 genome assembly, chromosome: 1 | blastn | 21443 | 150 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadia | Candidatus Saccharimonadia bacterium | |||||
| 20207261 | 20207261 | PRJNA400391_S_NODE_6056_length_159_cov_2.282258_g5995_i0 | PRJNA400391 | 6056 | 159 | 2.282258 | 3.62879022 | Bacteria | 2 | Bacteria | Bacteria | 270 | 3.3399999999999992e-68 | NTclustered | gi|2874253997|emb|OY970322.1| | 179883 | g5995 | i0 | 97.468 | 20.9811320754717 | 158 | 4 | 99 | 0 | 2 | 159 | 419203 | 419046 | MAG: uncultured Candidatus Saccharibacteria bacterium isolate MFD05512.bin.c.2 genome assembly, chromosome: 1 | blastn | 3336 | 272 | 0.992647058823529 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | uncultured Candidatus Saccharibacteria 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);;