contig_metadata
7 rows where bioproject = "PRJNA688352" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 8320056 | 8320056 | PRJNA688352_P_NODE_7567_length_250_cov_0.870056_g7464_i0 | PRJNA688352 | 7567 | 250 | 0.870056 | 2.17514 | Candidatus Zixiibacteriota bacterium | 2053527 | Bacteria | Bacteria | 151 | 9.74e-43 | NR | UCG63316.1 | 2053527 | g7464 | i0 | 90.4 | 7.968 | 83 | 8 | 99.6 | 0 | 2 | 250 | 205 | 287 | UCG63316.1 MAG: recombinase RecA [Candidatus Zixiibacteriota bacterium] | diamond | 1992 | 151 | 1 | Bacteria | FCB group | Pseudomonadati | Candidatus Zixiibacteriota | Candidatus Zixiibacteriota bacterium | |||||
| 26702200 | 26702200 | PRJNA688352_P_NODE_11781_length_242_cov_0.911243_g11678_i0 | PRJNA688352 | 11781 | 242 | 0.911243 | 2.20520806 | Candidatus Zixiibacteriota bacterium | 2053527 | Bacteria | Bacteria | 141 | 1.33e-37 | NR | HBC46104.1 | 2053527 | g11678 | i0 | 80 | 3.96694214876033 | 80 | 16 | 99.2 | 0 | 240 | 1 | 388 | 467 | HBC46104.1 GNAT family N-acetyltransferase [Candidatus Zixiibacteriota bacterium] | diamond | 960 | 141 | 1 | Bacteria | FCB group | Pseudomonadati | Candidatus Zixiibacteriota | Candidatus Zixiibacteriota bacterium | |||||
| 27113652 | 27113652 | PRJNA688352_P_NODE_7582_length_250_cov_0.870056_g7479_i0 | PRJNA688352 | 7582 | 250 | 0.870056 | 2.17514 | Candidatus Zixiibacteriota bacterium | 2053527 | Bacteria | Bacteria | 87.4 | 4.93e-18 | NR | SYZ72904.1 | 2053527 | g7479 | i0 | 59.8 | 1.968 | 82 | 33 | 98.4 | 0 | 249 | 4 | 47 | 128 | SYZ72904.1 RmuC-domain protein [Candidatus Zixiibacteriota bacterium] | diamond | 492 | 87.4 | 1 | Bacteria | FCB group | Pseudomonadati | Candidatus Zixiibacteriota | Candidatus Zixiibacteriota bacterium | |||||
| 30555981 | 30555981 | PRJNA688352_P_NODE_7573_length_250_cov_0.870056_g7470_i0 | PRJNA688352 | 7573 | 250 | 0.870056 | 2.17514 | Candidatus Zixiibacteriota bacterium | 2053527 | Bacteria | Bacteria | 125 | 1.65e-33 | NR | MCX6831612.1 | 2053527 | g7470 | i0 | 74.7 | 0.996 | 83 | 21 | 99.6 | 0 | 250 | 2 | 3 | 85 | MCX6831612.1 DNA repair protein RecO [Candidatus Zixiibacteriota bacterium] | diamond | 249 | 125 | 1 | Bacteria | FCB group | Pseudomonadati | Candidatus Zixiibacteriota | Candidatus Zixiibacteriota bacterium | |||||
| 30808945 | 30808945 | PRJNA688352_P_NODE_8914_length_248_cov_0.880000_g8811_i0 | PRJNA688352 | 8914 | 248 | 0.88 | 2.1824 | Candidatus Zixiibacteriota bacterium | 2053527 | Bacteria | Bacteria | 138 | 3.6599999999999997e-38 | NR | MFH1891862.1 | 2053527 | g8811 | i0 | 78 | 10.8991935483871 | 82 | 18 | 99.2 | 0 | 246 | 1 | 204 | 285 | MFH1891862.1 GIY-YIG nuclease family protein [Candidatus Zixiibacteriota bacterium] | diamond | 2703 | 138 | 1 | Bacteria | FCB group | Pseudomonadati | Candidatus Zixiibacteriota | Candidatus Zixiibacteriota bacterium | |||||
| 30903801 | 30903801 | PRJNA688352_P_NODE_10774_length_244_cov_0.900585_g10671_i0 | PRJNA688352 | 10774 | 244 | 0.900585 | 2.1974274 | Candidatus Zixiibacteriota bacterium | 2053527 | Bacteria | Bacteria | 70.9 | 4.85e-12 | NR | MEW5875882.1 | 2053527 | g10671 | i0 | 45.7 | 0.860655737704918 | 70 | 38 | 86.1 | 0 | 4 | 213 | 677 | 746 | MEW5875882.1 FlgD immunoglobulin-like domain containing protein [Candidatus Zixiibacteriota bacterium] | diamond | 210 | 70.9 | 1 | Bacteria | FCB group | Pseudomonadati | Candidatus Zixiibacteriota | Candidatus Zixiibacteriota bacterium | |||||
| 32053660 | 32053660 | PRJNA688352_P_NODE_8698_length_248_cov_0.880000_g8595_i0 | PRJNA688352 | 8698 | 248 | 0.88 | 2.1824 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 55.1 | 3.8e-7 | NR | MDM7974273.1 | 2053527 | g8595 | i0 | 48.3 | 3.56854838709677 | 60 | 31 | 72.6 | 0 | 69 | 248 | 1 | 60 | MDM7974273.1 hypothetical protein [Candidatus Zixiibacteriota bacterium] | diamond | 885 | 55.5 | 0.992792792792793 | 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);;