contig_metadata
9 rows where bioproject = "PRJEB8827", tax_kingdom = "Pseudomonadati" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 25801807 | 25801807 | PRJEB8827e_S_NODE_3963_length_229_cov_7.592784_g3935_i0 | PRJEB8827 | 3963 | 229 | 7.592784 | 17.38747536 | uncultured Acidobacteriota bacterium | 171953 | Bacteria | Bacteria | 235 | 1.89e-57 | NTclustered | gi|217038907|gb|EU810998.1| | 171953 | g3935 | i0 | 87.143 | 128.013100436681 | 210 | 24 | 91 | 3 | 1 | 208 | 80 | 288 | Uncultured Acidobacteria bacterium clone 01QCK 23S ribosomal RNA gene, partial sequence | blastn | 29315 | 235 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | uncultured Acidobacteriota bacterium | ||||||
| 25937943 | 25937943 | PRJEB8827e_S_NODE_2164_length_281_cov_2.439024_g2136_i0 | PRJEB8827 | 2164 | 281 | 2.439024 | 6.85365744 | Acidobacteriota bacterium | 1978231 | Bacteria | Bacteria | 327 | 3.84e-85 | NTclustered | gi|1958085512|gb|CP065000.1| | 1978231 | g2136 | i0 | 88.087 | 208.683274021352 | 277 | 32 | 98 | 1 | 6 | 281 | 3298437 | 3298161 | Acidobacteria bacterium isolate Kalu_18-Q3-R12-55_MAXAC.078_cln chromosome, complete genome | blastn | 58640 | 327 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 32913902 | 32913902 | PRJEB8827e_S_NODE_22345_length_176_cov_2.624113_g22317_i0 | PRJEB8827 | 22345 | 176 | 2.624113 | 4.61843888 | Candidatus Solibacter sp. | 2068625 | Bacteria | Bacteria | 54.3 | 1.23e-6 | NR | HEY1496220.1 | 2068625 | g22317 | i0 | 47.4 | 0.971590909090909 | 57 | 30 | 97.2 | 0 | 176 | 6 | 298 | 354 | HEY1496220.1 tetratricopeptide repeat protein [Candidatus Solibacter sp.] | diamond | 171 | 54.3 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Bryobacterales | Solibacteraceae | Candidatus Solibacter | Candidatus Solibacter sp. | ||
| 32948547 | 32948547 | PRJEB8827i_S_NODE_266_length_315_cov_3.928571_g261_i0 | PRJEB8827 | 266 | 315 | 3.928571 | 12.37499865 | Acidobacteriota bacterium | 1978231 | Bacteria | Bacteria | 51.2 | 4.95e-5 | NR | MEM7351477.1 | 1978231 | g261 | i0 | 45.2 | 0.59047619047619 | 62 | 24 | 49.5 | 1 | 314 | 159 | 136 | 197 | MEM7351477.1 hypothetical protein [Acidobacteriota bacterium] | diamond | 186 | 51.2 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 33067650 | 33067650 | PRJEB8827e_S_NODE_36429_length_162_cov_1.314961_g36401_i0 | PRJEB8827 | 36429 | 162 | 1.314961 | 2.13023682 | Thermoanaerobaculia bacterium | 2651171 | Bacteria | Bacteria | 39.7 | 0.0414 | NR | MBP7677414.1 | 2651171 | g36401 | i0 | 45.9 | 0.685185185185185 | 37 | 20 | 68.5 | 0 | 5 | 115 | 12 | 48 | MBP7677414.1 hypothetical protein [Thermoanaerobaculia bacterium] | diamond | 111 | 39.7 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Thermoanaerobaculia | Thermoanaerobaculia bacterium | |||||
| 33084984 | 33084984 | PRJEB8827h_S_NODE_12662_length_188_cov_2.967320_g12643_i0 | PRJEB8827 | 12662 | 188 | 2.96732 | 5.5785616 | Acidobacteriota bacterium | 1978231 | Bacteria | Bacteria | 52 | 9.63e-6 | NR | MBX3265733.1 | 1978231 | g12643 | i0 | 51.4 | 1.11702127659574 | 35 | 17 | 55.9 | 0 | 184 | 80 | 197 | 231 | MBX3265733.1 hypothetical protein [Acidobacteriota bacterium] | diamond | 210 | 52 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 33102028 | 33102028 | PRJEB8827g_S_NODE_12374_length_155_cov_4.366667_g12353_i0 | PRJEB8827 | 12374 | 155 | 4.366667 | 6.76833385 | Acidobacteriota bacterium | 1978231 | Bacteria | Bacteria | 53.9 | 1.26e-6 | NR | MDP3717109.1 | 1978231 | g12353 | i0 | 66.7 | 1.23870967741935 | 33 | 11 | 63.9 | 0 | 132 | 34 | 4 | 36 | MDP3717109.1 DUF4055 domain-containing protein [Acidobacteriota bacterium] | diamond | 192 | 53.9 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 33118805 | 33118805 | PRJEB8827e_S_NODE_27391_length_170_cov_2.481481_g27363_i0 | PRJEB8827 | 27391 | 170 | 2.481481 | 4.2185177 | Pyrinomonadaceae bacterium | 2283092 | Bacteria | Bacteria | 94 | 1.16e-23 | NR | HEX8287547.1 | 2283092 | g27363 | i0 | 85.7 | 0.988235294117647 | 56 | 8 | 98.8 | 0 | 170 | 3 | 4 | 59 | HEX8287547.1 DUF2945 domain-containing protein [Pyrinomonadaceae bacterium] | diamond | 168 | 94 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Blastocatellia | Blastocatellales | Pyrinomonadaceae | Pyrinomonadaceae bacterium | |||
| 33170049 | 33170049 | PRJEB8827e_S_NODE_31560_length_166_cov_2.030534_g31532_i0 | PRJEB8827 | 31560 | 166 | 2.030534 | 3.37068644 | Acidobacteriota bacterium | 1978231 | Bacteria | Bacteria | 73.6 | 8.76e-14 | NR | MDQ3180805.1 | 1978231 | g31532 | i0 | 67.3 | 1.64457831325301 | 49 | 16 | 88.6 | 0 | 166 | 20 | 241 | 289 | MDQ3180805.1 fatty acid desaturase [Acidobacteriota bacterium] | diamond | 273 | 73.6 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota 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);;