contig_metadata
11 rows where bioproject = "PRJNA613025", tax_phylum = "Acidobacteriota" and tax_superkingdom = "Bacteria"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 9520267 | 9520267 | PRJNA613025_S_NODE_30268_length_167_cov_0.864407_g30114_i0 | PRJNA613025 | 30268 | 167 | 0.864407 | 1.44355969 | uncultured Acidobacteriota bacterium | 171953 | Bacteria | Bacteria | 119 | 1.36e-22 | NTclustered | gi|2874254027|emb|OY970352.1| | 171953 | g30114 | i0 | 88.35 | 143.814371257485 | 103 | 6 | 60 | 5 | 68 | 167 | 2368219 | 2368318 | MAG: uncultured Acidobacteriota bacterium isolate MFD01916.bin.c.5 genome assembly, chromosome: 1 | blastn | 24017 | 119 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | uncultured Acidobacteriota bacterium | ||||||
| 15177142 | 15177142 | PRJNA613025_S_NODE_24672_length_190_cov_1.510638_g24518_i0 | PRJNA613025 | 24672 | 190 | 1.510638 | 2.8702122 | Bacteria | 2 | Bacteria | Bacteria | 254 | 4.17e-63 | NTclustered | gi|2874253677|emb|OY969111.1| | 171953 | g24518 | i0 | 91.758 | 165.426315789474 | 182 | 15 | 96 | 0 | 9 | 190 | 715901 | 715720 | MAG: uncultured Acidobacteriota bacterium isolate MFD01916.bin.c.3 genome assembly, chromosome: 1 | blastn | 31431 | 254 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | uncultured Acidobacteriota bacterium | ||||||
| 18443944 | 18443944 | PRJNA613025_S_NODE_28055_length_174_cov_3.232000_g27901_i0 | PRJNA613025 | 28055 | 174 | 3.232 | 5.62368 | Vicinamibacterales bacterium | 2910147 | Bacteria | Bacteria | 106 | 1.11e-18 | NTclustered | gi|2621701418|emb|OY760136.1| | 2910147 | g27901 | i0 | 85.294 | 24.6494252873563 | 102 | 15 | 59 | 0 | 1 | 102 | 1699451 | 1699552 | MAG: Vicinamibacterales bacterium isolate f9e760c9-8bbe-4e76-9a0a-40d6f1fb97b8 genome assembly, chromosome: 1 | blastn | 4289 | 106 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Vicinamibacteria | Vicinamibacterales | Vicinamibacterales bacterium | ||||
| 19718510 | 19718510 | PRJNA613025_S_NODE_31636_length_164_cov_3.104348_g31482_i0 | PRJNA613025 | 31636 | 164 | 3.104348 | 5.09113072 | uncultured Acidobacteriota bacterium | 171953 | Bacteria | Bacteria | 158 | 2.82e-34 | NTclustered | gi|2874253692|emb|OY969418.1| | 171953 | g31482 | i0 | 85.093 | 31.640243902439 | 161 | 17 | 96 | 4 | 2 | 159 | 4232873 | 4233029 | MAG: uncultured Acidobacteriota bacterium isolate MFD09212.bin.c.1 genome assembly, chromosome: 1 | blastn | 5189 | 158 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | uncultured Acidobacteriota bacterium | ||||||
| 19718545 | 19718545 | PRJNA613025_S_NODE_33276_length_162_cov_0.902655_g33122_i0 | PRJNA613025 | 33276 | 162 | 0.902655 | 1.4623011 | Candidatus Angelobacter sp. | 2976921 | Bacteria | Bacteria | 72.8 | 3.68e-15 | NR | HXT40101.1 | 2976921 | g33122 | i0 | 69.2 | 3.81481481481481 | 52 | 16 | 96.3 | 0 | 161 | 6 | 28 | 79 | HXT40101.1 transaldolase family protein [Candidatus Angelobacter sp.] | diamond | 618 | 72.8 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Candidatus Angelobacter | Candidatus Angelobacter sp. | ||||
| 24817754 | 24817754 | PRJNA613025_S_NODE_11080_length_362_cov_1.763578_g10926_i0 | PRJNA613025 | 11080 | 362 | 1.763578 | 6.38415236 | Acidobacteriota bacterium | 1978231 | Bacteria | Bacteria | 636 | 7.449999999999999e-178 | NTclustered | gi|1958098837|gb|CP065005.1| | 1978231 | g10926 | i0 | 98.343 | 107.759668508287 | 362 | 6 | 100 | 0 | 1 | 362 | 4651360 | 4651721 | Acidobacteria bacterium isolate Kalu_18-Q3-R12-55_MAXAC.198_cln chromosome, complete genome | blastn | 39009 | 636 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 26872149 | 26872149 | PRJNA613025_S_NODE_30781_length_166_cov_0.871795_g30627_i0 | PRJNA613025 | 30781 | 166 | 0.871795 | 1.4471797 | Bacteria | 2 | Bacteria | Bacteria | 115 | 3.0899999999999998e-28 | NR | MDI9583796.1 | 1978231 | g30627 | i0 | 100 | 1.95180722891566 | 54 | 0 | 97.6 | 0 | 3 | 164 | 955 | 1008 | MDI9583796.1 NEW3 domain-containing protein [Acidobacteriota bacterium] | diamond | 324 | 115 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 27725500 | 27725500 | PRJNA613025_S_NODE_32644_length_163_cov_0.894737_g32490_i0 | PRJNA613025 | 32644 | 163 | 0.894737 | 1.45842131 | Acidobacteriota | 57723 | Bacteria | Bacteria | 43.1 | 0.0093 | NR | HEU4521200.1 | 2651171 | g32490 | i0 | 36 | 1.85889570552147 | 50 | 32 | 92 | 0 | 13 | 162 | 285 | 334 | HEU4521200.1 Calx-beta domain-containing protein [Thermoanaerobaculia bacterium] | diamond | 303 | 43.1 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Thermoanaerobaculia | Thermoanaerobaculia bacterium | |||||
| 28943798 | 28943798 | PRJNA613025_S_NODE_27528_length_177_cov_1.054688_g27374_i0 | PRJNA613025 | 27528 | 177 | 1.054688 | 1.86679776 | Candidatus Acidiferrum sp. | 3069120 | Bacteria | Bacteria | 44.3 | 0.00219 | NR | HUO35246.1 | 3069120 | g27374 | i0 | 37.5 | 0.949152542372881 | 56 | 35 | 94.9 | 0 | 7 | 174 | 40 | 95 | HUO35246.1 DUF1772 domain-containing protein [Candidatus Acidiferrum sp.] | diamond | 168 | 44.3 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Candidatus Acidiferrales | Candidatus Acidiferrum | Candidatus Acidiferrum sp. | |||
| 30946553 | 30946553 | PRJNA613025_S_NODE_25454_length_186_cov_1.467153_g25300_i0 | PRJNA613025 | 25454 | 186 | 1.467153 | 2.72890458 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 65.5 | 1.05e-10 | NR | MEO7653584.1 | 2212468 | g25300 | i0 | 100 | 0.935483870967742 | 29 | 0 | 46.8 | 0 | 89 | 3 | 1 | 29 | MEO7653584.1 AAA family ATPase [Bryobacteraceae bacterium] | diamond | 174 | 65.5 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Bryobacterales | Bryobacteraceae | Bryobacteraceae bacterium | |||
| 31389041 | 31389041 | PRJNA613025_S_NODE_31156_length_165_cov_1.318966_g31002_i0 | PRJNA613025 | 31156 | 165 | 1.318966 | 2.1762939 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 113 | 4.38e-29 | NR | MEO7653584.1 | 2212468 | g31002 | i0 | 100 | 1.96363636363636 | 54 | 0 | 98.2 | 0 | 2 | 163 | 23 | 76 | MEO7653584.1 AAA family ATPase [Bryobacteraceae bacterium] | diamond | 324 | 113 | 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);;