contig_metadata
15 rows where bioproject = "PRJNA1186363", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 23272003 | 23272003 | PRJNA1186363_P_NODE_40279_length_249_cov_0.886364_g39391_i0 | PRJNA1186363 | 40279 | 249 | 0.886364 | 2.20704636 | Bryobacterales bacterium | 2026791 | Bacteria | Bacteria | 448 | 2.46e-121 | NTclustered | gi|2874253826|emb|OY969810.1| | 2026791 | g39391 | i0 | 99.194 | 108.116465863454 | 248 | 2 | 99 | 0 | 1 | 248 | 6660216 | 6659969 | MAG: Bryobacterales bacterium isolate MFD04967.bin.c.1 genome assembly, chromosome: 1 | blastn | 26921 | 448 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Bryobacterales | Bryobacterales bacterium | ||||
| 26692387 | 26692387 | PRJNA1186363_P_NODE_21461_length_404_cov_1.673716_g20573_i0 | PRJNA1186363 | 21461 | 404 | 1.673716 | 6.76181264 | Blastocatellia bacterium | 2052146 | Bacteria | Bacteria | 60.1 | 1.77e-7 | NR | MDX6385578.1 | 2052146 | g20573 | i0 | 64 | 2.61386138613861 | 50 | 15 | 34.9 | 1 | 8 | 148 | 292 | 341 | MDX6385578.1 hypothetical protein [Blastocatellia bacterium] | diamond | 1056 | 60.1 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Blastocatellia | Blastocatellia bacterium | |||||
| 27565097 | 27565097 | PRJNA1186363_P_NODE_11484_length_604_cov_5.740113_g10602_i0 | PRJNA1186363 | 11484 | 604 | 5.740113 | 34.67028252 | Acidobacteriota | 57723 | Bacteria | Bacteria | 124 | 2.2299999999999998e-32 | NR | PYX50408.1 | 1978231 | g10602 | i0 | 44.6 | 4.17715231788079 | 139 | 76 | 69 | 1 | 481 | 65 | 5 | 142 | PYX50408.1 MAG: DUF1772 domain-containing protein [Acidobacteriota bacterium] | diamond | 2523 | 125 | 0.992 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 27767463 | 27767463 | PRJNA1186363_P_NODE_24324_length_371_cov_1.046980_g23436_i0 | PRJNA1186363 | 24324 | 371 | 1.04698 | 3.8842958 | Bryobacteraceae bacterium | 2212468 | Bacteria | Bacteria | 51.6 | 1.25e-4 | NR | HTS31414.1 | 2212468 | g23436 | i0 | 30.6 | 1.81940700808625 | 111 | 49 | 75.2 | 2 | 350 | 72 | 99 | 199 | HTS31414.1 SMP-30/gluconolactonase/LRE family protein [Bryobacteraceae bacterium] | diamond | 675 | 51.6 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Bryobacterales | Bryobacteraceae | Bryobacteraceae bacterium | |||
| 28146360 | 28146360 | PRJNA1186363_P_NODE_29665_length_319_cov_1.662602_g28777_i0 | PRJNA1186363 | 29665 | 319 | 1.662602 | 5.30370038 | Blastocatellia bacterium | 2052146 | Bacteria | Bacteria | 49.7 | 3.26e-4 | NR | HXU39527.1 | 2052146 | g28777 | i0 | 41 | 1.64576802507837 | 61 | 35 | 57.4 | 1 | 245 | 63 | 12 | 71 | HXU39527.1 AAA-like domain-containing protein [Blastocatellia bacterium] | diamond | 525 | 49.7 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Blastocatellia | Blastocatellia bacterium | |||||
| 28291384 | 28291384 | PRJNA1186363_P_NODE_37906_length_255_cov_1.285714_g37018_i0 | PRJNA1186363 | 37906 | 255 | 1.285714 | 3.2785707 | root | 1 | Root_unresolved | Root_unresolved | 56.2 | 7.8e-7 | NR | HKQ72567.1 | 2052146 | g37018 | i0 | 57.8 | 3.16470588235294 | 45 | 19 | 52.9 | 0 | 241 | 107 | 465 | 509 | HKQ72567.1 kelch repeat-containing protein [Blastocatellia bacterium] | diamond | 807 | 56.2 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Blastocatellia | Blastocatellia bacterium | |||||
| 28493564 | 28493564 | PRJNA1186363_P_NODE_29107_length_324_cov_1.537849_g28219_i0 | PRJNA1186363 | 29107 | 324 | 1.537849 | 4.98263076 | Bryobacteraceae bacterium | 2212468 | Bacteria | Bacteria | 47.8 | 6.18e-4 | NR | HLI83363.1 | 2212468 | g28219 | i0 | 41.1 | 1.08333333333333 | 56 | 33 | 51.9 | 0 | 227 | 60 | 58 | 113 | HLI83363.1 peptidoglycan-binding domain-containing protein [Bryobacteraceae bacterium] | diamond | 351 | 47.8 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Bryobacterales | Bryobacteraceae | Bryobacteraceae bacterium | |||
| 28872286 | 28872286 | PRJNA1186363_P_NODE_34468_length_281_cov_1.379808_g33580_i0 | PRJNA1186363 | 34468 | 281 | 1.379808 | 3.87726048 | Blastocatellia bacterium | 2052146 | Bacteria | Bacteria | 113 | 1.95e-28 | NR | HVF90501.1 | 2052146 | g33580 | i0 | 55.9 | 16.9003558718861 | 93 | 37 | 99.3 | 1 | 3 | 281 | 133 | 221 | HVF90501.1 MIP family channel protein [Blastocatellia bacterium] | diamond | 4749 | 113 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Blastocatellia | Blastocatellia bacterium | |||||
| 29188321 | 29188321 | PRJNA1186363_P_NODE_38629_length_253_cov_0.866667_g37741_i0 | PRJNA1186363 | 38629 | 253 | 0.866667 | 2.19266751 | Bryobacterales bacterium | 2026791 | Bacteria | Bacteria | 75.5 | 1.23e-13 | NR | MCU1275463.1 | 2026791 | g37741 | i0 | 46.7 | 2.64426877470356 | 75 | 40 | 88.9 | 0 | 28 | 252 | 27 | 101 | MCU1275463.1 fatty-acid--CoA ligase [Bryobacterales bacterium] | diamond | 669 | 75.5 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Bryobacterales | Bryobacterales bacterium | ||||
| 30135156 | 30135156 | PRJNA1186363_P_NODE_34932_length_278_cov_0.897561_g34044_i0 | PRJNA1186363 | 34932 | 278 | 0.897561 | 2.49521958 | Thermoanaerobaculia bacterium | 2651171 | Bacteria | Bacteria | 82.8 | 1.38e-16 | NR | HEX6179045.1 | 2651171 | g34044 | i0 | 47.9 | 1.99640287769784 | 94 | 46 | 98.2 | 2 | 4 | 276 | 70 | 163 | HEX6179045.1 zinc metalloprotease [Thermoanaerobaculia bacterium] | diamond | 555 | 82.8 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Thermoanaerobaculia | Thermoanaerobaculia bacterium | |||||
| 30198465 | 30198465 | PRJNA1186363_P_NODE_37072_length_262_cov_0.730159_g36184_i0 | PRJNA1186363 | 37072 | 262 | 0.730159 | 1.91301658 | Holophagaceae bacterium | 2052165 | Bacteria | Bacteria | 43.9 | 0.00547 | NR | MFM8233882.1 | 2052165 | g36184 | i0 | 30.7 | 1.80916030534351 | 75 | 47 | 80.2 | 1 | 35 | 244 | 15 | 89 | MFM8233882.1 DUF2752 domain-containing protein [Holophagaceae bacterium] | diamond | 474 | 43.9 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Holophagae | Holophagales | Holophagaceae | Holophagaceae bacterium | |||
| 30502135 | 30502135 | PRJNA1186363_P_NODE_36713_length_264_cov_1.225131_g35825_i0 | PRJNA1186363 | 36713 | 264 | 1.225131 | 3.23434584 | Bacteria | 2 | Bacteria | Bacteria | 102 | 1.37e-24 | NR | PYT00922.1 | 1978231 | g35825 | i0 | 58.8 | 3.79545454545455 | 80 | 33 | 90.9 | 0 | 23 | 262 | 102 | 181 | PYT00922.1 MAG: hypothetical protein DMF63_04445 [Acidobacteriota bacterium] | diamond | 1002 | 103 | 0.990291262135922 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 31545262 | 31545262 | PRJNA1186363_P_NODE_42116_length_245_cov_1.738372_g41228_i0 | PRJNA1186363 | 42116 | 245 | 1.738372 | 4.2590114 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 73.9 | 3.89e-13 | NR | HYJ47225.1 | 2283092 | g41228 | i0 | 47 | 4.77551020408163 | 83 | 40 | 96.7 | 2 | 244 | 8 | 48 | 130 | HYJ47225.1 YHYH protein [Pyrinomonadaceae bacterium] | diamond | 1170 | 74.3 | 0.994616419919246 | Bacteria | Pseudomonadati | Acidobacteriota | Blastocatellia | Blastocatellales | Pyrinomonadaceae | Pyrinomonadaceae bacterium | |||
| 32443764 | 32443764 | PRJNA1186363_P_NODE_21759_length_400_cov_1.431193_g20871_i0 | PRJNA1186363 | 21759 | 400 | 1.431193 | 5.724772 | Acidobacteriota bacterium | 1978231 | Bacteria | Bacteria | 134 | 1.38e-37 | NR | MBX3281627.1 | 1978231 | g20871 | i0 | 45.5 | 1.005 | 134 | 71 | 99 | 1 | 398 | 3 | 8 | 141 | MBX3281627.1 hypothetical protein [Acidobacteriota bacterium] | diamond | 402 | 134 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 32475319 | 32475319 | PRJNA1186363_P_NODE_28439_length_330_cov_1.626459_g27551_i0 | PRJNA1186363 | 28439 | 330 | 1.626459 | 5.3673147 | Thermoanaerobaculia bacterium | 2651171 | Bacteria | Bacteria | 68.2 | 1.17e-10 | NR | HXH94315.1 | 2651171 | g27551 | i0 | 42.7 | 0.809090909090909 | 89 | 39 | 77.3 | 4 | 267 | 13 | 293 | 373 | HXH94315.1 LamG domain-containing protein [Thermoanaerobaculia bacterium] | diamond | 267 | 68.2 | 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);;