contig_metadata
24 rows where bioproject = "PRJNA993416", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3526362 | 3526362 | PRJNA993416_P_NODE_13163_length_249_cov_0.875000_g13058_i0 | PRJNA993416 | 13163 | 249 | 0.875 | 2.17875 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 120 | 3.2699999999999996e-32 | NR | MBX3288189.1 | 1978231 | g13058 | i0 | 67.1 | 2.97590361445783 | 82 | 27 | 98.8 | 0 | 248 | 3 | 52 | 133 | MBX3288189.1 glutathione peroxidase [Acidobacteriota bacterium] | diamond | 741 | 120 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 27247719 | 27247719 | PRJNA993416_P_NODE_10723_length_267_cov_1.953608_g10618_i0 | PRJNA993416 | 10723 | 267 | 1.953608 | 5.21613336 | Acidobacteriaceae bacterium | 2052142 | Bacteria | Bacteria | 150 | 1.7299999999999996e-41 | NR | MBV8831644.1 | 2052142 | g10618 | i0 | 84.1 | 1.97752808988764 | 88 | 14 | 98.9 | 0 | 266 | 3 | 219 | 306 | MBV8831644.1 CoA transferase [Acidobacteriaceae bacterium] | diamond | 528 | 150 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Terriglobales | Acidobacteriaceae | Acidobacteriaceae bacterium | |||
| 27411874 | 27411874 | PRJNA993416_P_NODE_15903_length_242_cov_0.911243_g15798_i0 | PRJNA993416 | 15903 | 242 | 0.911243 | 2.20520806 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 121 | 5.88e-30 | NR | WP_015895763.1 | 33973 | g15798 | i0 | 73.8 | 18.2727272727273 | 80 | 21 | 99.2 | 0 | 2 | 241 | 36 | 115 | WP_015895763.1 MULTISPECIES: thiamine pyrophosphate-binding protein [Acidobacterium] | diamond | 4422 | 121 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Terriglobales | Acidobacteriaceae | Acidobacterium | |||
| 27690294 | 27690294 | PRJNA993416_P_NODE_4264_length_407_cov_1.353293_g4159_i0 | PRJNA993416 | 4264 | 407 | 1.353293 | 5.50790251 | Acidobacteriota bacterium | 1978231 | Bacteria | Bacteria | 117 | 3.199999999999999e-29 | NR | MEW5983269.1 | 1978231 | g4159 | i0 | 45.9 | 1.95331695331695 | 133 | 69 | 98 | 2 | 2 | 400 | 40 | 169 | MEW5983269.1 MBL fold metallo-hydrolase [Acidobacteriota bacterium] | diamond | 795 | 117 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 27847646 | 27847646 | PRJNA993416_P_NODE_7024_length_312_cov_1.560669_g6919_i0 | PRJNA993416 | 7024 | 312 | 1.560669 | 4.86928728 | Acidobacteriota bacterium | 1978231 | Bacteria | Bacteria | 63.2 | 1.93e-10 | NR | PYT54585.1 | 1978231 | g6919 | i0 | 52.2 | 0.442307692307692 | 46 | 22 | 44.2 | 0 | 149 | 12 | 22 | 67 | PYT54585.1 MAG: hypothetical protein DMG46_21760 [Acidobacteriota bacterium] | diamond | 138 | 63.2 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 28074593 | 28074593 | PRJNA993416_P_NODE_8745_length_285_cov_1.278302_g8640_i0 | PRJNA993416 | 8745 | 285 | 1.278302 | 3.6431607 | Bacteria | 2 | Bacteria | Bacteria | 141 | 1.1199999999999999e-38 | NR | PWT94126.1 | 1978231 | g8640 | i0 | 75.3 | 4.92631578947368 | 93 | 23 | 97.9 | 0 | 5 | 283 | 9 | 101 | PWT94126.1 MAG: transaldolase, partial [Acidobacteriota bacterium] | diamond | 1404 | 141 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 28226385 | 28226385 | PRJNA993416_P_NODE_11106_length_264_cov_1.146597_g11001_i0 | PRJNA993416 | 11106 | 264 | 1.146597 | 3.02701608 | Thermoanaerobaculia bacterium | 2651171 | Bacteria | Bacteria | 43.9 | 0.0195 | NR | HEX6178304.1 | 2651171 | g11001 | i0 | 48.7 | 0.443181818181818 | 39 | 20 | 44.3 | 0 | 192 | 76 | 380 | 418 | HEX6178304.1 alkaline phosphatase family protein [Thermoanaerobaculia bacterium] | diamond | 117 | 43.9 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Thermoanaerobaculia | Thermoanaerobaculia bacterium | |||||
| 28226392 | 28226392 | PRJNA993416_P_NODE_8426_length_287_cov_2.023364_g8321_i0 | PRJNA993416 | 8426 | 287 | 2.023364 | 5.80705468 | Thermoanaerobaculia bacterium | 2651171 | Bacteria | Bacteria | 91.7 | 3.05e-19 | NR | HXH38704.1 | 2651171 | g8321 | i0 | 53.2 | 0.982578397212544 | 94 | 44 | 98.3 | 0 | 283 | 2 | 291 | 384 | HXH38704.1 phospholipase D-like domain-containing protein [Thermoanaerobaculia bacterium] | diamond | 282 | 91.7 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Thermoanaerobaculia | Thermoanaerobaculia bacterium | |||||
| 28479315 | 28479315 | PRJNA993416_P_NODE_10506_length_269_cov_1.571429_g10401_i0 | PRJNA993416 | 10506 | 269 | 1.571429 | 4.22714401 | Candidatus Acidiferrales bacterium | 2952895 | Bacteria | Bacteria | 68.2 | 2.72e-11 | NR | MEE9235328.1 | 2952895 | g10401 | i0 | 54 | 2.69888475836431 | 50 | 22 | 54.6 | 1 | 11 | 157 | 216 | 265 | MEE9235328.1 sulfotransferase domain-containing protein [Candidatus Acidiferrales bacterium] | diamond | 726 | 68.2 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Candidatus Acidiferrales | Candidatus Acidiferrales bacterium | ||||
| 28605563 | 28605563 | PRJNA993416_P_NODE_7587_length_299_cov_2.380531_g7482_i0 | PRJNA993416 | 7587 | 299 | 2.380531 | 7.11778769 | Acidobacteriota bacterium | 1978231 | Bacteria | Bacteria | 83.2 | 2.21e-17 | NR | MCC7043187.1 | 1978231 | g7482 | i0 | 66 | 1.00334448160535 | 50 | 17 | 50.2 | 0 | 150 | 299 | 15 | 64 | MCC7043187.1 DUF1684 domain-containing protein [Acidobacteriota bacterium] | diamond | 300 | 83.2 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 28794783 | 28794783 | PRJNA993416_P_NODE_10347_length_271_cov_1.267677_g10242_i0 | PRJNA993416 | 10347 | 271 | 1.267677 | 3.43540467 | Thermoanaerobaculia bacterium | 2651171 | Bacteria | Bacteria | 57 | 5.08e-7 | NR | HYR28759.1 | 2651171 | g10242 | i0 | 44.1 | 0.752767527675277 | 68 | 32 | 70.8 | 3 | 53 | 244 | 307 | 372 | HYR28759.1 PKD domain-containing protein [Thermoanaerobaculia bacterium] | diamond | 204 | 57 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Thermoanaerobaculia | Thermoanaerobaculia bacterium | |||||
| 28826349 | 28826349 | PRJNA993416_P_NODE_11488_length_260_cov_1.395722_g11383_i0 | PRJNA993416 | 11488 | 260 | 1.395722 | 3.6288772 | Candidatus Acidiferrum sp. | 3069120 | Bacteria | Bacteria | 43.1 | 0.0319 | NR | HUI73376.1 | 3069120 | g11383 | i0 | 41.9 | 0.496153846153846 | 43 | 25 | 49.6 | 0 | 111 | 239 | 285 | 327 | HUI73376.1 glycosyltransferase [Candidatus Acidiferrum sp.] | diamond | 129 | 43.1 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Candidatus Acidiferrales | Candidatus Acidiferrum | Candidatus Acidiferrum sp. | |||
| 29110852 | 29110852 | PRJNA993416_P_NODE_1468_length_698_cov_1.755200_g1371_i0 | PRJNA993416 | 1468 | 698 | 1.7552 | 12.251296 | Pyrinomonadaceae bacterium | 2283092 | Bacteria | Bacteria | 96.3 | 1.55e-20 | NR | MBD0370316.1 | 2283092 | g1371 | i0 | 43 | 0.812320916905444 | 100 | 55 | 42.1 | 1 | 432 | 139 | 95 | 194 | MBD0370316.1 hypothetical protein [Pyrinomonadaceae bacterium] | diamond | 567 | 96.3 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Blastocatellia | Blastocatellales | Pyrinomonadaceae | Pyrinomonadaceae bacterium | |||
| 29142571 | 29142571 | PRJNA993416_P_NODE_15529_length_243_cov_0.905882_g15424_i0 | PRJNA993416 | 15529 | 243 | 0.905882 | 2.20129326 | Thermoanaerobaculia bacterium | 2651171 | Bacteria | Bacteria | 72.4 | 5.01e-13 | NR | HEX8411575.1 | 2651171 | g15424 | i0 | 45.8 | 1.77777777777778 | 72 | 39 | 88.9 | 0 | 227 | 12 | 3 | 74 | HEX8411575.1 thymidylate synthase [Thermoanaerobaculia bacterium] | diamond | 432 | 72.4 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Thermoanaerobaculia | Thermoanaerobaculia bacterium | |||||
| 29205662 | 29205662 | PRJNA993416_P_NODE_11569_length_259_cov_1.564516_g11464_i0 | PRJNA993416 | 11569 | 259 | 1.564516 | 4.05209644 | Bryobacteraceae bacterium | 2212468 | Bacteria | Bacteria | 79 | 8.18e-15 | NR | HTS76659.1 | 2212468 | g11464 | i0 | 61.2 | 2.45559845559846 | 49 | 19 | 56.8 | 0 | 1 | 147 | 534 | 582 | HTS76659.1 lipase maturation factor family protein [Bryobacteraceae bacterium] | diamond | 636 | 79 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Bryobacterales | Bryobacteraceae | Bryobacteraceae bacterium | |||
| 29779654 | 29779654 | PRJNA993416_P_NODE_1231_length_750_cov_3.308715_g1136_i0 | PRJNA993416 | 1231 | 750 | 3.308715 | 24.8153625 | Paludibaculum | 1649475 | Bacteria | Bacteria | 63.9 | 4.89e-8 | NR | WP_267239330.1 | 1473598 | g1136 | i0 | 47.8 | 1.904 | 69 | 36 | 27.6 | 0 | 540 | 746 | 13 | 81 | WP_267239330.1 sigma-70 family RNA polymerase sigma factor [Paludibaculum fermentans] | diamond | 1428 | 63.9 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Bryobacterales | Bryobacteraceae | Paludibaculum | Paludibaculum fermentans | ||
| 30632515 | 30632515 | PRJNA993416_P_NODE_4453_length_397_cov_1.604938_g4348_i0 | PRJNA993416 | 4453 | 397 | 1.604938 | 6.37160386 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 69.3 | 1.09e-10 | NR | HEY6329107.1 | 2052146 | g4348 | i0 | 41.2 | 2.03274559193955 | 136 | 66 | 92.2 | 5 | 2 | 367 | 800 | 935 | HEY6329107.1 glycosyltransferase [Blastocatellia bacterium] | diamond | 807 | 69.7 | 0.994261119081779 | Bacteria | Pseudomonadati | Acidobacteriota | Blastocatellia | Blastocatellia bacterium | |||||
| 30784768 | 30784768 | PRJNA993416_P_NODE_13514_length_248_cov_0.880000_g13409_i0 | PRJNA993416 | 13514 | 248 | 0.88 | 2.1824 | Thermoanaerobaculia bacterium | 2651171 | Bacteria | Bacteria | 137 | 2.2e-37 | NR | MFP5288964.1 | 2651171 | g13409 | i0 | 92.7 | 0.991935483870968 | 82 | 6 | 99.2 | 0 | 246 | 1 | 55 | 136 | MFP5288964.1 collagen binding domain-containing protein [Thermoanaerobaculia bacterium] | diamond | 246 | 137 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Thermoanaerobaculia | Thermoanaerobaculia bacterium | |||||
| 31321959 | 31321959 | PRJNA993416_P_NODE_7295_length_306_cov_2.287554_g7190_i0 | PRJNA993416 | 7295 | 306 | 2.287554 | 6.99991524 | Pyrinomonadaceae bacterium | 2283092 | Bacteria | Bacteria | 99.8 | 2.08e-24 | NR | HZT58036.1 | 2283092 | g7190 | i0 | 47.8 | 1.80392156862745 | 92 | 48 | 90.2 | 0 | 27 | 302 | 1 | 92 | HZT58036.1 hypothetical protein [Pyrinomonadaceae bacterium] | diamond | 552 | 99.8 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Blastocatellia | Blastocatellales | Pyrinomonadaceae | Pyrinomonadaceae bacterium | |||
| 31517820 | 31517820 | PRJNA993416_P_NODE_4256_length_407_cov_2.269461_g4151_i0 | PRJNA993416 | 4256 | 407 | 2.269461 | 9.2367062700000009 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 99 | 3.87e-22 | NR | MYF77635.1 | 1978231 | g4151 | i0 | 50 | 1.97542997542998 | 96 | 46 | 69.3 | 1 | 125 | 406 | 11 | 106 | MYF77635.1 aminotransferase class III-fold pyridoxal phosphate-dependent enzyme [Acidobacteriota bacterium] | diamond | 804 | 100 | 0.99 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 31575241 | 31575241 | PRJNA993416_P_NODE_10856_length_266_cov_1.595855_g10751_i0 | PRJNA993416 | 10856 | 266 | 1.595855 | 4.2449743 | Acidobacteriota bacterium | 1978231 | Bacteria | Bacteria | 51.2 | 4.84e-5 | NR | MCB1055898.1 | 1978231 | g10751 | i0 | 74.3 | 0.394736842105263 | 35 | 9 | 39.5 | 0 | 150 | 46 | 244 | 278 | MCB1055898.1 NAD(P)/FAD-dependent oxidoreductase [Acidobacteriota bacterium] | diamond | 105 | 51.2 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 31859609 | 31859609 | PRJNA993416_P_NODE_8757_length_285_cov_1.165094_g8652_i0 | PRJNA993416 | 8757 | 285 | 1.165094 | 3.3205179 | Bryobacteraceae bacterium | 2212468 | Bacteria | Bacteria | 44.3 | 0.0166 | NR | HEV2199939.1 | 2212468 | g8652 | i0 | 40.3 | 0.757894736842105 | 72 | 40 | 73.7 | 2 | 224 | 15 | 39 | 109 | HEV2199939.1 alanine--glyoxylate aminotransferase family protein [Bryobacteraceae bacterium] | diamond | 216 | 44.3 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Bryobacterales | Bryobacteraceae | Bryobacteraceae bacterium | |||
| 32245632 | 32245632 | PRJNA993416_P_NODE_10418_length_270_cov_1.472081_g10313_i0 | PRJNA993416 | 10418 | 270 | 1.472081 | 3.9746187 | Bacteria | 2 | Bacteria | Bacteria | 110 | 5.51e-26 | NR | MDT5270757.1 | 1978231 | g10313 | i0 | 63.9 | 8.38888888888889 | 83 | 30 | 92.2 | 0 | 2 | 250 | 65 | 147 | MDT5270757.1 hypothetical protein [Acidobacteriota bacterium] | diamond | 2265 | 110 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 32744917 | 32744917 | PRJNA993416_P_NODE_4500_length_395_cov_1.580745_g4395_i0 | PRJNA993416 | 4500 | 395 | 1.580745 | 6.24394275 | Acidobacteriota bacterium | 1978231 | Bacteria | Bacteria | 107 | 7.66e-25 | NR | MEW6368887.1 | 1978231 | g4395 | i0 | 47.9 | 0.888607594936709 | 117 | 60 | 88.9 | 1 | 357 | 7 | 1 | 116 | MEW6368887.1 hypothetical protein [Acidobacteriota bacterium] | diamond | 351 | 107 | 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);;