contig_metadata
2 rows where bioproject = "PRJNA911178", tax_clade = "FCB group" and tax_phylum = "Candidatus Cloacimonadota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5996208 | 5996208 | PRJNA911178_P_NODE_303405_length_229_cov_2.711538_g300931_i0 | PRJNA911178 | 303405 | 229 | 2.711538 | 6.20942202 | Candidatus Cloacimonadota bacterium | 2030808 | Bacteria | Bacteria | 112 | 9.12e-27 | NR | NLK49190.1 | 2030808 | g300931 | i0 | 72.4 | 2.98689956331878 | 76 | 21 | 99.6 | 0 | 229 | 2 | 83 | 158 | NLK49190.1 L-glutamate gamma-semialdehyde dehydrogenase [Candidatus Cloacimonadota bacterium] | diamond | 684 | 112 | 1 | Bacteria | FCB group | Pseudomonadati | Candidatus Cloacimonadota | Candidatus Cloacimonadota bacterium | |||||
| 27940616 | 27940616 | PRJNA911178_P_NODE_244765_length_250_cov_1.548023_g242291_i0 | PRJNA911178 | 244765 | 250 | 1.548023 | 3.8700575 | Candidatus Cloacimonas sp. SDB | 1732214 | Bacteria | Bacteria | 134 | 3.23e-35 | NR | KQC06462.1 | 1732214 | g242291 | i0 | 64.6 | 1.944 | 82 | 29 | 98.4 | 0 | 3 | 248 | 371 | 452 | KQC06462.1 MAG: hypothetical protein APR54_07205, partial [Candidatus Cloacimonas sp. SDB] | diamond | 486 | 134 | 1 | Bacteria | FCB group | Pseudomonadati | Candidatus Cloacimonadota | Candidatus Cloacimonadia | Candidatus Cloacimonadales | Candidatus Cloacimonadaceae | Candidatus Cloacimonas | Candidatus Cloacimonas sp. SDB |
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);;