contig_metadata
8 rows where bioproject = "PRJNA640350" and tax_phylum = "Acidobacteriota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 10814770 | 10814770 | PRJNA640350_P_NODE_38829_length_154_cov_1.392000_g38668_i0 | PRJNA640350 | 38829 | 154 | 1.392 | 2.14368 | uncultured Acidobacteriota bacterium | 171953 | Bacteria | Bacteria | 121 | 3.4199999999999996e-23 | NTclustered | gi|2874254167|emb|OY970399.1| | 171953 | g38668 | i0 | 83.088 | 25.0714285714286 | 136 | 19 | 87 | 4 | 19 | 152 | 1972736 | 1972603 | MAG: uncultured Acidobacteriota bacterium isolate MFD01916.bin.c.6 genome assembly, chromosome: 1 | blastn | 3861 | 121 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | uncultured Acidobacteriota bacterium | ||||||
| 14639289 | 14639289 | PRJNA640350_P_NODE_24392_length_193_cov_2.445122_g24231_i0 | PRJNA640350 | 24392 | 193 | 2.445122 | 4.71908546 | Thermoanaerobaculia bacterium | 2651171 | Bacteria | Bacteria | 156 | 1.23e-33 | NTclustered | gi|2874254056|emb|OY970380.1| | 2651171 | g24231 | i0 | 82.258 | 2.38860103626943 | 186 | 27 | 95 | 6 | 8 | 191 | 629044 | 629225 | MAG: Thermoanaerobaculia bacterium isolate MFD05537.bin.c.2 genome assembly, chromosome: 1 | blastn | 461 | 156 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Thermoanaerobaculia | Thermoanaerobaculia bacterium | |||||
| 26713388 | 26713388 | PRJNA640350_P_NODE_32761_length_165_cov_2.845588_g32600_i0 | PRJNA640350 | 32761 | 165 | 2.845588 | 4.6952202 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 96.7 | 1.3e-21 | NR | HTG15699.1 | 2052146 | g32600 | i0 | 88.9 | 2.94545454545455 | 54 | 6 | 98.2 | 0 | 2 | 163 | 49 | 102 | HTG15699.1 AAA family ATPase [Blastocatellia bacterium] | diamond | 486 | 96.7 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Blastocatellia | Blastocatellia bacterium | |||||
| 28217770 | 28217770 | PRJNA640350_P_NODE_40126_length_152_cov_0.918699_g39965_i0 | PRJNA640350 | 40126 | 152 | 0.918699 | 1.39642248 | Geothrix sp. | 1962974 | Bacteria | Bacteria | 41.6 | 0.0278 | NR | MCC6512416.1 | 1962974 | g39965 | i0 | 46.3 | 1.61842105263158 | 41 | 21 | 80.9 | 1 | 137 | 15 | 11 | 50 | MCC6512416.1 hypothetical protein [Geothrix sp.] | diamond | 246 | 41.6 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Holophagae | Holophagales | Holophagaceae | Geothrix | Geothrix sp. | ||
| 29323004 | 29323004 | PRJNA640350_P_NODE_40109_length_152_cov_1.097561_g39948_i0 | PRJNA640350 | 40109 | 152 | 1.097561 | 1.66829272 | Candidatus Acidiferrum sp. | 3069120 | Bacteria | Bacteria | 55.8 | 2.53e-7 | NR | HWO34008.1 | 3069120 | g39948 | i0 | 67.5 | 0.789473684210526 | 40 | 12 | 77 | 1 | 2 | 118 | 79 | 118 | HWO34008.1 GumC family protein [Candidatus Acidiferrum sp.] | diamond | 120 | 55.8 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Candidatus Acidiferrales | Candidatus Acidiferrum | Candidatus Acidiferrum sp. | |||
| 30870891 | 30870891 | PRJNA640350_P_NODE_38794_length_154_cov_1.448000_g38633_i0 | PRJNA640350 | 38794 | 154 | 1.448 | 2.22992 | Acidobacteriota bacterium | 1978231 | Bacteria | Bacteria | 59.7 | 1.05e-8 | NR | PYS45357.1 | 1978231 | g38633 | i0 | 56.8 | 1.73376623376623 | 44 | 19 | 85.7 | 0 | 152 | 21 | 225 | 268 | PYS45357.1 MAG: hypothetical protein DMG13_32345, partial [Acidobacteriota bacterium] | diamond | 267 | 59.7 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 31882594 | 31882594 | PRJNA640350_P_NODE_39397_length_153_cov_1.443548_g39236_i0 | PRJNA640350 | 39397 | 153 | 1.443548 | 2.20862844 | Candidatus Acidiferrum sp. | 3069120 | Bacteria | Bacteria | 60.8 | 4.52e-9 | NR | HWO34008.1 | 3069120 | g39236 | i0 | 60 | 0.980392156862745 | 50 | 20 | 98 | 0 | 153 | 4 | 167 | 216 | HWO34008.1 GumC family protein [Candidatus Acidiferrum sp.] | diamond | 150 | 60.8 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Candidatus Acidiferrales | Candidatus Acidiferrum | Candidatus Acidiferrum sp. | |||
| 32104164 | 32104164 | PRJNA640350_P_NODE_41418_length_150_cov_1.140496_g41257_i0 | PRJNA640350 | 41418 | 150 | 1.140496 | 1.710744 | Bryobacteraceae bacterium | 2212468 | Bacteria | Bacteria | 54.7 | 6.07e-7 | NR | HEY3837980.1 | 2212468 | g41257 | i0 | 62.5 | 2.92 | 48 | 18 | 96 | 0 | 5 | 148 | 89 | 136 | HEY3837980.1 acyltransferase [Bryobacteraceae bacterium] | diamond | 438 | 54.7 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Bryobacterales | Bryobacteraceae | Bryobacteraceae 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);;