contig_metadata
4 rows where bioproject = "PRJNA493827", tax_clade = "FCB group" and tax_phylum = "Candidatus Zixiibacteriota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26743898 | 26743898 | PRJNA493827_P_NODE_126641_length_304_cov_1.000000_g124443_i0 | PRJNA493827 | 126641 | 304 | 1 | 3.04 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 69.3 | 8.61e-12 | NR | MCK4632374.1 | 2053527 | g124443 | i0 | 52.6 | 1.47039473684211 | 57 | 27 | 56.3 | 0 | 173 | 3 | 26 | 82 | MCK4632374.1 GNAT family N-acetyltransferase [Candidatus Zixiibacteriota bacterium] | diamond | 447 | 69.3 | 1 | Bacteria | FCB group | Pseudomonadati | Candidatus Zixiibacteriota | Candidatus Zixiibacteriota bacterium | |||||
| 28971619 | 28971619 | PRJNA493827_P_NODE_169408_length_263_cov_1.215789_g167210_i0 | PRJNA493827 | 169408 | 263 | 1.215789 | 3.19752507 | candidate division Zixibacteria bacterium RBG-1 | 1379698 | Bacteria | Bacteria | 70.1 | 1.12e-11 | NR | EQB62699.1 | 1379698 | g167210 | i0 | 44.8 | 3.9467680608365 | 87 | 48 | 99.2 | 0 | 261 | 1 | 400 | 486 | EQB62699.1 MAG: DNA gyrase subunit A [candidate division Zixibacteria bacterium RBG-1] | diamond | 1038 | 70.1 | 1 | Bacteria | FCB group | Pseudomonadati | Candidatus Zixiibacteriota | candidate division Zixibacteria bacterium RBG-1 | |||||
| 29003540 | 29003540 | PRJNA493827_P_NODE_123288_length_308_cov_1.102128_g121090_i0 | PRJNA493827 | 123288 | 308 | 1.102128 | 3.39455424 | Candidatus Zixiibacteriota bacterium | 2053527 | Bacteria | Bacteria | 50.1 | 7.16e-6 | NR | HOP06122.1 | 2053527 | g121090 | i0 | 69 | 0.282467532467532 | 29 | 9 | 28.2 | 0 | 123 | 37 | 13 | 41 | HOP06122.1 hypothetical protein [Candidatus Zixiibacteriota bacterium] | diamond | 87 | 50.1 | 1 | Bacteria | FCB group | Pseudomonadati | Candidatus Zixiibacteriota | Candidatus Zixiibacteriota bacterium | |||||
| 31087863 | 31087863 | PRJNA493827_P_NODE_214035_length_245_cov_0.895349_g211837_i0 | PRJNA493827 | 214035 | 245 | 0.895349 | 2.19360505 | Candidatus Zixiibacteriota bacterium | 2053527 | Bacteria | Bacteria | 51.6 | 1.69e-5 | NR | HEX7401516.1 | 2053527 | g211837 | i0 | 34.6 | 1.8734693877551 | 78 | 51 | 95.5 | 0 | 245 | 12 | 131 | 208 | HEX7401516.1 50S ribosomal protein L4 [Candidatus Zixiibacteriota bacterium] | diamond | 459 | 51.6 | 1 | Bacteria | FCB group | Pseudomonadati | Candidatus Zixiibacteriota | Candidatus Zixiibacteriota 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);;