contig_metadata
6 rows where analysis = "diamond", bioproject = "PRJNA1123436" and tax_phylum = "Candidatus Gottesmaniibacteriota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 6132021 | 6132021 | PRJNA1123436_P_NODE_102585_length_249_cov_0.875000_g101371_i0 | PRJNA1123436 | 102585 | 249 | 0.875 | 2.17875 | Candidatus Gottesmanbacteria bacterium GW2 | 2282145 | Bacteria | Bacteria | 164 | 4.42e-45 | NR | KKU95892.1 | 1618439 | g101371 | i0 | 95.1 | 11.855421686747 | 82 | 4 | 98.8 | 0 | 247 | 2 | 30 | 111 | KKU95892.1 MAG: Elongation factor G [Candidatus Gottesmanbacteria bacterium GW2011_GWA1_48_13] | diamond | 2952 | 164 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Gottesmaniibacteriota | Candidatus Gottesmanbacteria bacterium GW2011_GWA1_48_13 | ||||||
| 27733928 | 27733928 | PRJNA1123436_P_NODE_116704_length_244_cov_0.900585_g115490_i0 | PRJNA1123436 | 116704 | 244 | 0.900585 | 2.1974274 | Candidatus Gottesmanbacteria bacterium GW2 | 2282145 | Bacteria | Bacteria | 126 | 3.5099999999999992e-34 | NR | KKW10902.1 | 1618448 | g115490 | i0 | 72.8 | 0.995901639344262 | 81 | 22 | 99.6 | 0 | 1 | 243 | 137 | 217 | KKW10902.1 MAG: hypothetical protein UY48_C0028G0011 [Candidatus Gottesmanbacteria bacterium GW2011_GWB1_49_7] | diamond | 243 | 126 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Gottesmaniibacteriota | Candidatus Gottesmanbacteria bacterium GW2011_GWB1_49_7 | ||||||
| 28933488 | 28933488 | PRJNA1123436_P_NODE_124828_length_242_cov_0.911243_g123614_i0 | PRJNA1123436 | 124828 | 242 | 0.911243 | 2.20520806 | Candidatus Gottesmanbacteria bacterium GW2 | 2282145 | Bacteria | Bacteria | 97.1 | 1.1099999999999999e-23 | NR | KKW12998.1 | 1618448 | g123614 | i0 | 59.3 | 1.00413223140496 | 81 | 25 | 95.5 | 2 | 3 | 233 | 25 | 101 | KKW12998.1 MAG: hypothetical protein UY48_C0006G0051 [Candidatus Gottesmanbacteria bacterium GW2011_GWB1_49_7] | diamond | 243 | 97.1 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Gottesmaniibacteriota | Candidatus Gottesmanbacteria bacterium GW2011_GWB1_49_7 | ||||||
| 29564848 | 29564848 | PRJNA1123436_P_NODE_118230_length_244_cov_0.900585_g117016_i0 | PRJNA1123436 | 118230 | 244 | 0.900585 | 2.1974274 | Candidatus Gottesmanbacteria bacterium | 2282145 | Bacteria | Bacteria | 134 | 2.35e-36 | NR | MBI5619699.1 | 2282145 | g117016 | i0 | 81.5 | 3.98360655737705 | 81 | 15 | 99.6 | 0 | 2 | 244 | 52 | 132 | MBI5619699.1 ABC transporter permease [Candidatus Gottesmanbacteria bacterium] | diamond | 972 | 134 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Gottesmaniibacteriota | Candidatus Gottesmanbacteria bacterium | ||||||
| 30817700 | 30817700 | PRJNA1123436_P_NODE_79454_length_279_cov_1.276699_g78240_i0 | PRJNA1123436 | 79454 | 279 | 1.276699 | 3.56199021 | Bacteria | 2 | Bacteria | Bacteria | 157 | 2.25e-44 | NR | OIO13937.1 | 1805209 | g78240 | i0 | 76.1 | 1.97849462365591 | 92 | 22 | 98.9 | 0 | 278 | 3 | 92 | 183 | OIO13937.1 MAG: hypothetical protein AUJ73_02905 [Candidatus Gottesmanbacteria bacterium CG1_02_37_22] | diamond | 552 | 157 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Gottesmaniibacteriota | Candidatus Gottesmanbacteria bacterium CG1_02_37_22 | ||||||
| 32788241 | 32788241 | PRJNA1123436_P_NODE_118160_length_244_cov_0.900585_g116946_i0 | PRJNA1123436 | 118160 | 244 | 0.900585 | 2.1974274 | Candidatus Gottesmanbacteria bacterium GW2 | 2282145 | Bacteria | Bacteria | 88.6 | 5.86e-20 | NR | KKW10275.1 | 1618448 | g116946 | i0 | 57.1 | 0.94672131147541 | 77 | 33 | 94.7 | 0 | 4 | 234 | 68 | 144 | KKW10275.1 MAG: hypothetical protein UY48_C0042G0002 [Candidatus Gottesmanbacteria bacterium GW2011_GWB1_49_7] | diamond | 231 | 88.6 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Gottesmaniibacteriota | Candidatus Gottesmanbacteria bacterium GW2011_GWB1_49_7 |
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);;