contig_metadata
14 rows where bioproject = "PRJNA543299" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3060559 | 3060559 | PRJNA543299_P_NODE_23143_length_164_cov_0.886957_g22986_i0 | PRJNA543299 | 23143 | 164 | 0.886957 | 1.45460948 | Acidobacteria bacterium SCN 69-37 | 1660160 | Bacteria | Bacteria | 98.2 | 3.74e-22 | NR | ODS52425.1 | 1660160 | g22986 | i0 | 94.4 | 0.98780487804878 | 54 | 3 | 98.8 | 0 | 1 | 162 | 399 | 452 | ODS52425.1 MAG: cation transporter [Acidobacteria bacterium SCN 69-37] | diamond | 162 | 98.2 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteria bacterium SCN 69-37 | ||||||
| 26761277 | 26761277 | PRJNA543299_P_NODE_22401_length_165_cov_0.879310_g22244_i0 | PRJNA543299 | 22401 | 165 | 0.87931 | 1.4508615 | Chloracidobacterium sp. | 2099375 | Bacteria | Bacteria | 66.6 | 3.17e-11 | NR | MBK8467642.1 | 2099375 | g22244 | i0 | 76.5 | 2.47272727272727 | 34 | 8 | 61.8 | 0 | 60 | 161 | 1 | 34 | MBK8467642.1 hypothetical protein [Chloracidobacterium sp.] | diamond | 408 | 66.6 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Terriglobales | Acidobacteriaceae | Chloracidobacterium | Chloracidobacterium sp. | ||
| 26793119 | 26793119 | PRJNA543299_P_NODE_15641_length_190_cov_0.992908_g15484_i0 | PRJNA543299 | 15641 | 190 | 0.992908 | 1.8865252 | Pyrinomonadaceae bacterium | 2283092 | Bacteria | Bacteria | 89.4 | 1.75e-19 | NR | HEX7318726.1 | 2283092 | g15484 | i0 | 66.7 | 0.994736842105263 | 63 | 21 | 99.5 | 0 | 190 | 2 | 105 | 167 | HEX7318726.1 hypothetical protein [Pyrinomonadaceae bacterium] | diamond | 189 | 89.4 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Blastocatellia | Blastocatellales | Pyrinomonadaceae | Pyrinomonadaceae bacterium | |||
| 27345821 | 27345821 | PRJNA543299_P_NODE_22903_length_164_cov_0.886957_g22746_i0 | PRJNA543299 | 22903 | 164 | 0.886957 | 1.45460948 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 84 | 2.35e-17 | NR | OLC37994.1 | 1803458 | g22746 | i0 | 72.2 | 6.3109756097561 | 54 | 14 | 98.8 | 1 | 3 | 164 | 32 | 84 | OLC37994.1 MAG: hypothetical protein AUH28_03160 [Acidobacteria bacterium 13_1_40CM_56_16] | diamond | 1035 | 84 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteria bacterium 13_1_40CM_56_16 | ||||||
| 27472068 | 27472068 | PRJNA543299_P_NODE_22283_length_165_cov_0.879310_g22126_i0 | PRJNA543299 | 22283 | 165 | 0.87931 | 1.4508615 | Bacteria | 2 | Bacteria | Bacteria | 92.4 | 1.83e-20 | NR | MBI2689044.1 | 1978231 | g22126 | i0 | 87 | 1.96363636363636 | 54 | 7 | 98.2 | 0 | 164 | 3 | 309 | 362 | MBI2689044.1 FtsX-like permease family protein [Acidobacteriota bacterium] | diamond | 324 | 93.2 | 0.991416309012876 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 27678437 | 27678437 | PRJNA543299_P_NODE_20624_length_167_cov_0.864407_g20467_i0 | PRJNA543299 | 20624 | 167 | 0.864407 | 1.44355969 | Terriglobia bacterium | 2081523 | Bacteria | Bacteria | 64.3 | 2.77e-10 | NR | MFQ5778705.1 | 2081523 | g20467 | i0 | 54.5 | 0.988023952095808 | 55 | 25 | 98.8 | 0 | 166 | 2 | 180 | 234 | MFQ5778705.1 hypothetical protein [Terriglobia bacterium] | diamond | 165 | 64.3 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Terriglobia bacterium | |||||
| 28909224 | 28909224 | PRJNA543299_P_NODE_6688_length_284_cov_35.055319_g6532_i0 | PRJNA543299 | 6688 | 284 | 35.055319 | 99.55710596 | Thermoanaerobaculia bacterium | 2651171 | Bacteria | Bacteria | 43.5 | 0.0167 | NR | HMB53910.1 | 2651171 | g6532 | i0 | 34.9 | 0.908450704225352 | 86 | 37 | 89.8 | 4 | 255 | 1 | 90 | 157 | HMB53910.1 rhomboid family intramembrane serine protease [Thermoanaerobaculia bacterium] | diamond | 258 | 43.5 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Thermoanaerobaculia | Thermoanaerobaculia bacterium | |||||
| 29177153 | 29177153 | PRJNA543299_P_NODE_22289_length_165_cov_0.879310_g22132_i0 | PRJNA543299 | 22289 | 165 | 0.87931 | 1.4508615 | Bacteria candidate phyla | 1783234 | Bacteria | Bacteria | 72.4 | 2.72e-13 | NR | HUO29086.1 | 2212468 | g22132 | i0 | 66 | 13.5090909090909 | 53 | 18 | 96.4 | 0 | 161 | 3 | 174 | 226 | HUO29086.1 hypothetical protein [Bryobacteraceae bacterium] | diamond | 2229 | 72.4 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Bryobacterales | Bryobacteraceae | Bryobacteraceae bacterium | |||
| 29225526 | 29225526 | PRJNA543299_P_NODE_23229_length_164_cov_0.886957_g23072_i0 | PRJNA543299 | 23229 | 164 | 0.886957 | 1.45460948 | Blastocatellia bacterium | 2052146 | Bacteria | Bacteria | 42.7 | 0.0129 | NR | HEY6329415.1 | 2052146 | g23072 | i0 | 52.4 | 0.768292682926829 | 42 | 20 | 76.8 | 0 | 18 | 143 | 165 | 206 | HEY6329415.1 hypothetical protein [Blastocatellia bacterium] | diamond | 126 | 42.7 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Blastocatellia | Blastocatellia bacterium | |||||
| 29256582 | 29256582 | PRJNA543299_P_NODE_2089_length_485_cov_2.383028_g1945_i0 | PRJNA543299 | 2089 | 485 | 2.383028 | 11.5576858 | Terracidiphilus sp. | 1964191 | Bacteria | Bacteria | 44.3 | 0.0343 | NR | HUA96763.1 | 1964191 | g1945 | i0 | 30.3 | 0.550515463917526 | 89 | 60 | 53.8 | 1 | 388 | 128 | 8 | 96 | HUA96763.1 PIN domain-containing protein [Terracidiphilus sp.] | diamond | 267 | 44.3 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Terriglobales | Acidobacteriaceae | Terracidiphilus | Terracidiphilus sp. | ||
| 29460802 | 29460802 | PRJNA543299_P_NODE_19430_length_170_cov_1.685950_g19273_i0 | PRJNA543299 | 19430 | 170 | 1.68595 | 2.866115 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 76.3 | 9.21e-15 | NR | HLJ13892.1 | 2212468 | g19273 | i0 | 64 | 1.76470588235294 | 50 | 18 | 88.2 | 0 | 16 | 165 | 89 | 138 | HLJ13892.1 Rad52/Rad22 family DNA repair protein [Bryobacteraceae bacterium] | diamond | 300 | 76.3 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Bryobacterales | Bryobacteraceae | Bryobacteraceae bacterium | |||
| 30299483 | 30299483 | PRJNA543299_P_NODE_20512_length_167_cov_0.864407_g20355_i0 | PRJNA543299 | 20512 | 167 | 0.864407 | 1.44355969 | Blastocatellia bacterium | 2052146 | Bacteria | Bacteria | 73.2 | 8.37e-15 | NR | MFP5263733.1 | 2052146 | g20355 | i0 | 70.6 | 0.916167664670659 | 51 | 15 | 91.6 | 0 | 154 | 2 | 32 | 82 | MFP5263733.1 terminase small subunit [Blastocatellia bacterium] | diamond | 153 | 73.2 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Blastocatellia | Blastocatellia bacterium | |||||
| 30362679 | 30362679 | PRJNA543299_P_NODE_21212_length_166_cov_0.871795_g21055_i0 | PRJNA543299 | 21212 | 166 | 0.871795 | 1.4471797 | Blastocatellia bacterium | 2052146 | Bacteria | Bacteria | 44.7 | 0.00276 | NR | HST21261.1 | 2052146 | g21055 | i0 | 40.5 | 2.1144578313253 | 42 | 25 | 75.9 | 0 | 31 | 156 | 155 | 196 | HST21261.1 molecular chaperone DnaJ [Blastocatellia bacterium] | diamond | 351 | 44.7 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Blastocatellia | Blastocatellia bacterium | |||||
| 32385837 | 32385837 | PRJNA543299_P_NODE_24819_length_162_cov_0.902655_g24662_i0 | PRJNA543299 | 24819 | 162 | 0.902655 | 1.4623011 | Thermoanaerobaculia bacterium | 2651171 | Bacteria | Bacteria | 77.8 | 5.33e-15 | NR | MBP7587983.1 | 2651171 | g24662 | i0 | 71.7 | 0.981481481481482 | 53 | 15 | 98.1 | 0 | 160 | 2 | 96 | 148 | MBP7587983.1 serine/threonine protein kinase [Thermoanaerobaculia bacterium] | diamond | 159 | 77.8 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Thermoanaerobaculia | Thermoanaerobaculia 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);;