contig_metadata
23 rows where bioproject = "PRJNA934472" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3461771 | 3461771 | PRJNA934472_P_NODE_21323_length_316_cov_1.444444_g20946_i0 | PRJNA934472 | 21323 | 316 | 1.444444 | 4.56444304 | Terriglobia bacterium | 2081523 | Bacteria | Bacteria | 401 | 2.5499999999999992e-107 | NTclustered | gi|2874253792|emb|OY969776.1| | 2081523 | g20946 | i0 | 89.655 | 97.8481012658228 | 319 | 27 | 100 | 5 | 1 | 316 | 34133 | 34448 | MAG: Terriglobia bacterium isolate MFD00008.bin.1.63 genome assembly, chromosome: 1 | blastn | 30920 | 401 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Terriglobia bacterium | |||||
| 3461902 | 3461902 | PRJNA934472_P_NODE_27243_length_283_cov_1.319048_g26865_i0 | PRJNA934472 | 27243 | 283 | 1.319048 | 3.73290584 | Thermoanaerobaculia bacterium | 2651171 | Bacteria | Bacteria | 196 | 1.14e-45 | NTclustered | gi|2874253700|emb|OY969426.1| | 2651171 | g26865 | i0 | 79.298 | 7.58657243816254 | 285 | 55 | 100 | 4 | 1 | 283 | 2322150 | 2321868 | MAG: Thermoanaerobaculia bacterium isolate MFD02979.bin.c.1 genome assembly, chromosome: 1 | blastn | 2147 | 196 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Thermoanaerobaculia | Thermoanaerobaculia bacterium | |||||
| 4739546 | 4739546 | PRJNA934472_P_NODE_35964_length_249_cov_0.875000_g35586_i0 | PRJNA934472 | 35964 | 249 | 0.875 | 2.17875 | Candidatus Acidiferrum sp. | 3069120 | Bacteria | Bacteria | 141 | 1.1199999999999999e-38 | NR | HMH53600.1 | 3069120 | g35586 | i0 | 88.7 | 0.855421686746988 | 71 | 8 | 85.5 | 0 | 1 | 213 | 266 | 336 | HMH53600.1 hypothetical protein [Candidatus Acidiferrum sp.] | diamond | 213 | 141 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Candidatus Acidiferrales | Candidatus Acidiferrum | Candidatus Acidiferrum sp. | |||
| 8564241 | 8564241 | PRJNA934472_P_NODE_40027_length_227_cov_3.500000_g39649_i0 | PRJNA934472 | 40027 | 227 | 3.5 | 7.945 | uncultured Acidobacteriota bacterium | 171953 | Bacteria | Bacteria | 375 | 1.06e-99 | NTclustered | gi|112980855|gb|DQ829659.1| | 171953 | g39649 | i0 | 96.46 | 115.392070484581 | 226 | 8 | 99 | 0 | 2 | 227 | 927 | 702 | Uncultured Acidobacteria bacterium clone DON16 23S ribosomal RNA gene, partial sequence | blastn | 26194 | 375 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | uncultured Acidobacteriota bacterium | ||||||
| 11114638 | 11114638 | PRJNA934472_P_NODE_27169_length_283_cov_2.052381_g26791_i0 | PRJNA934472 | 27169 | 283 | 2.052381 | 5.80823823 | uncultured Acidobacteriota bacterium | 171953 | Bacteria | Bacteria | 110 | 1.53e-19 | NTclustered | gi|2874253709|emb|OY969474.1| | 171953 | g26791 | i0 | 75.686 | 28.9187279151943 | 255 | 43 | 86 | 14 | 1 | 243 | 3918069 | 3917822 | MAG: uncultured Acidobacteriota bacterium isolate MFD05747.bin.1.131 genome assembly, chromosome: 1 | blastn | 8184 | 110 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | uncultured Acidobacteriota bacterium | ||||||
| 11114857 | 11114857 | PRJNA934472_P_NODE_36769_length_246_cov_2.780347_g36391_i0 | PRJNA934472 | 36769 | 246 | 2.780347 | 6.83965362 | Pyrinomonadaceae bacterium | 2283092 | Bacteria | Bacteria | 159 | 1.27e-34 | NTclustered | gi|2874253710|emb|OY969475.1| | 2283092 | g36391 | i0 | 81.443 | 0.788617886178862 | 194 | 36 | 79 | 0 | 52 | 245 | 1816724 | 1816917 | MAG: Pyrinomonadaceae bacterium isolate MFD01916.bin.c.1 genome assembly, chromosome: 1 | blastn | 194 | 159 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Blastocatellia | Blastocatellales | Pyrinomonadaceae | Pyrinomonadaceae bacterium | |||
| 12390285 | 12390285 | PRJNA934472_P_NODE_32870_length_259_cov_3.446237_g32492_i0 | PRJNA934472 | 32870 | 259 | 3.446237 | 8.92575383 | Bacteria | 2 | Bacteria | Bacteria | 169 | 1.07e-46 | NR | MDQ3132639.1 | 1978231 | g32492 | i0 | 95.3 | 1.96911196911197 | 85 | 4 | 98.5 | 0 | 256 | 2 | 235 | 319 | MDQ3132639.1 isoleucine--tRNA ligase [Acidobacteriota bacterium] | diamond | 510 | 169 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 13664701 | 13664701 | PRJNA934472_P_NODE_32791_length_260_cov_1.192513_g32413_i0 | PRJNA934472 | 32791 | 260 | 1.192513 | 3.1005338 | uncultured Acidobacteriota bacterium | 171953 | Bacteria | Bacteria | 436 | 5.600000000000001e-118 | NTclustered | gi|112980860|gb|DQ829664.1| | 171953 | g32413 | i0 | 96.923 | 104.169230769231 | 260 | 8 | 100 | 0 | 1 | 260 | 738 | 997 | Uncultured Acidobacteria bacterium clone DON1 23S ribosomal RNA gene, partial sequence | blastn | 27084 | 436 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | uncultured Acidobacteriota bacterium | ||||||
| 17489398 | 17489398 | PRJNA934472_P_NODE_31754_length_264_cov_1.450262_g31376_i0 | PRJNA934472 | 31754 | 264 | 1.450262 | 3.82869168 | Pyrinomonadaceae bacterium | 2283092 | Bacteria | Bacteria | 173 | 1.13e-50 | NR | MBA2736577.1 | 2283092 | g31376 | i0 | 92 | 16 | 88 | 7 | 100 | 0 | 264 | 1 | 89 | 176 | MBA2736577.1 type IV pilus twitching motility protein PilT [Pyrinomonadaceae bacterium] | diamond | 4224 | 173 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Blastocatellia | Blastocatellales | Pyrinomonadaceae | Pyrinomonadaceae bacterium | |||
| 18762913 | 18762913 | PRJNA934472_P_NODE_38255_length_242_cov_3.278107_g37877_i0 | PRJNA934472 | 38255 | 242 | 3.278107 | 7.93301894 | uncultured Acidobacteriota bacterium | 171953 | Bacteria | Bacteria | 331 | 2.5e-86 | NTclustered | gi|2874253678|emb|OY969112.1| | 171953 | g37877 | i0 | 91.358 | 677.198347107438 | 243 | 20 | 100 | 1 | 1 | 242 | 4733456 | 4733214 | MAG: uncultured Acidobacteriota bacterium isolate MFD04212.bin.1.16 genome assembly, chromosome: 1 | blastn | 163882 | 331 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | uncultured Acidobacteriota bacterium | ||||||
| 20037996 | 20037996 | PRJNA934472_P_NODE_8436_length_486_cov_2.629540_g8059_i0 | PRJNA934472 | 8436 | 486 | 2.62954 | 12.7795644 | uncultured Acidobacteriota bacterium | 171953 | Bacteria | Bacteria | 713 | 0 | NTclustered | gi|31789464|gb|AY281356.1| | 171953 | g8059 | i0 | 93.224 | 133.308641975309 | 487 | 29 | 100 | 4 | 1 | 486 | 11663 | 12146 | Uncultured Acidobacteria bacterium clone 41b15 genomic sequence | blastn | 64788 | 713 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | uncultured Acidobacteriota bacterium | ||||||
| 23863638 | 23863638 | PRJNA934472_P_NODE_6519_length_546_cov_3.319239_g6206_i0 | PRJNA934472 | 6519 | 546 | 3.319239 | 18.12304494 | Bryobacteraceae bacterium | 2212468 | Bacteria | Bacteria | 636 | 1.17e-177 | NTclustered | gi|2621707050|emb|OY764903.1| | 2212468 | g6206 | i0 | 88.598 | 90.3901098901099 | 535 | 45 | 96 | 11 | 21 | 545 | 3557732 | 3558260 | MAG: Bryobacteraceae bacterium isolate d7944118-f527-4ba8-a886-cdd3ae4bc3f8 genome assembly, chromosome: 1 | blastn | 49353 | 636 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Bryobacterales | Bryobacteraceae | Bryobacteraceae bacterium | |||
| 26803328 | 26803328 | PRJNA934472_P_NODE_38521_length_242_cov_0.911243_g38143_i0 | PRJNA934472 | 38521 | 242 | 0.911243 | 2.20520806 | Thermoanaerobaculia bacterium | 2651171 | Bacteria | Bacteria | 116 | 1.58e-28 | NR | HYC62907.1 | 2651171 | g38143 | i0 | 70 | 1.97107438016529 | 80 | 24 | 99.2 | 0 | 1 | 240 | 74 | 153 | HYC62907.1 DUF4097 family beta strand repeat-containing protein [Thermoanaerobaculia bacterium] | diamond | 477 | 116 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Thermoanaerobaculia | Thermoanaerobaculia bacterium | |||||
| 27024958 | 27024958 | PRJNA934472_P_NODE_30662_length_268_cov_1.989744_g30284_i0 | PRJNA934472 | 30662 | 268 | 1.989744 | 5.33251392 | Thermoanaerobaculia bacterium | 2651171 | Bacteria | Bacteria | 97.4 | 2.11e-21 | NR | HYI13064.1 | 2651171 | g30284 | i0 | 93.2 | 2.48507462686567 | 44 | 3 | 49.3 | 0 | 135 | 266 | 1 | 44 | HYI13064.1 benzoyl-CoA 2,3-epoxidase subunit BoxB [Thermoanaerobaculia bacterium] | diamond | 666 | 97.4 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Thermoanaerobaculia | Thermoanaerobaculia bacterium | |||||
| 27182808 | 27182808 | PRJNA934472_P_NODE_34762_length_252_cov_2.061453_g34384_i0 | PRJNA934472 | 34762 | 252 | 2.061453 | 5.19486156 | Thermoanaerobaculia bacterium | 2651171 | Bacteria | Bacteria | 75.1 | 2.92e-15 | NR | HET7436009.1 | 2651171 | g34384 | i0 | 72.9 | 1.10714285714286 | 48 | 13 | 57.1 | 0 | 144 | 1 | 14 | 61 | HET7436009.1 hypothetical protein [Thermoanaerobaculia bacterium] | diamond | 279 | 75.1 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Thermoanaerobaculia | Thermoanaerobaculia bacterium | |||||
| 27214443 | 27214443 | PRJNA934472_P_NODE_34382_length_254_cov_1.276243_g34004_i0 | PRJNA934472 | 34382 | 254 | 1.276243 | 3.24165722 | Acidobacteriota bacterium | 1978231 | Bacteria | Bacteria | 142 | 2.3e-40 | NR | MDQ3132110.1 | 1978231 | g34004 | i0 | 79.8 | 0.992125984251969 | 84 | 17 | 99.2 | 0 | 1 | 252 | 96 | 179 | MDQ3132110.1 YggS family pyridoxal phosphate-dependent enzyme [Acidobacteriota bacterium] | diamond | 252 | 142 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 27569056 | 27569056 | PRJNA934472_P_NODE_33804_length_256_cov_1.420765_g33426_i0 | PRJNA934472 | 33804 | 256 | 1.420765 | 3.6371584 | Bacteria | 2 | Bacteria | Bacteria | 155 | 9.079999999999998e-42 | NR | MBK6725481.1 | 1978231 | g33426 | i0 | 86.9 | 3.9375 | 84 | 11 | 98.4 | 0 | 254 | 3 | 380 | 463 | MBK6725481.1 formate dehydrogenase subunit alpha [Acidobacteriota bacterium] | diamond | 1008 | 155 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 28983192 | 28983192 | PRJNA934472_P_NODE_27728_length_281_cov_1.298077_g27350_i0 | PRJNA934472 | 27728 | 281 | 1.298077 | 3.64759637 | Pyrinomonadaceae bacterium | 2283092 | Bacteria | Bacteria | 143 | 1.5499999999999998e-37 | NR | HEX8197557.1 | 2283092 | g27350 | i0 | 80.9 | 0.950177935943061 | 89 | 17 | 95 | 0 | 1 | 267 | 189 | 277 | HEX8197557.1 amidohydrolase family protein [Pyrinomonadaceae bacterium] | diamond | 267 | 143 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Blastocatellia | Blastocatellales | Pyrinomonadaceae | Pyrinomonadaceae bacterium | |||
| 29014829 | 29014829 | PRJNA934472_P_NODE_27428_length_282_cov_1.770335_g27050_i0 | PRJNA934472 | 27428 | 282 | 1.770335 | 4.9923447 | Vicinamibacterales bacterium | 2910147 | Bacteria | Bacteria | 100 | 8.709999999999999e-23 | NR | HXW08717.1 | 2910147 | g27050 | i0 | 79.3 | 3.45744680851064 | 58 | 12 | 61.7 | 0 | 2 | 175 | 334 | 391 | HXW08717.1 pyridoxal phosphate-dependent aminotransferase [Vicinamibacterales bacterium] | diamond | 975 | 100 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Vicinamibacteria | Vicinamibacterales | Vicinamibacterales bacterium | ||||
| 29519644 | 29519644 | PRJNA934472_P_NODE_31310_length_266_cov_1.243523_g30932_i0 | PRJNA934472 | 31310 | 266 | 1.243523 | 3.30777118 | Pyrinomonadaceae bacterium | 2283092 | Bacteria | Bacteria | 147 | 3.469999999999999e-42 | NR | HLL99710.1 | 2283092 | g30932 | i0 | 77.9 | 0.969924812030075 | 86 | 19 | 97 | 0 | 3 | 260 | 82 | 167 | HLL99710.1 GNAT family N-acetyltransferase [Pyrinomonadaceae bacterium] | diamond | 258 | 147 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Blastocatellia | Blastocatellales | Pyrinomonadaceae | Pyrinomonadaceae bacterium | |||
| 30467643 | 30467643 | PRJNA934472_P_NODE_35493_length_250_cov_1.491525_g35115_i0 | PRJNA934472 | 35493 | 250 | 1.491525 | 3.7288125 | Acidobacteriota bacterium | 1978231 | Bacteria | Bacteria | 137 | 2.82e-35 | NR | MDQ3132612.1 | 1978231 | g35115 | i0 | 87.8 | 1.968 | 82 | 10 | 98.4 | 0 | 3 | 248 | 349 | 430 | MDQ3132612.1 hypothetical protein [Acidobacteriota bacterium] | diamond | 492 | 137 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 31700093 | 31700093 | PRJNA934472_P_NODE_35777_length_249_cov_1.670455_g35399_i0 | PRJNA934472 | 35777 | 249 | 1.670455 | 4.15943295 | Vicinamibacteria bacterium | 2793154 | Bacteria | Bacteria | 155 | 2.91e-43 | NR | HSF14912.1 | 2793154 | g35399 | i0 | 100 | 0.987951807228916 | 82 | 0 | 98.8 | 0 | 247 | 2 | 82 | 163 | HSF14912.1 YMGG-like glycine zipper-containing protein [Vicinamibacteria bacterium] | diamond | 246 | 155 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Vicinamibacteria | Vicinamibacteria bacterium | |||||
| 32774681 | 32774681 | PRJNA934472_P_NODE_26140_length_288_cov_1.739535_g25762_i0 | PRJNA934472 | 26140 | 288 | 1.739535 | 5.0098608 | Acidobacteriota bacterium | 1978231 | Bacteria | Bacteria | 109 | 2.51e-25 | NR | MDQ3130306.1 | 1978231 | g25762 | i0 | 44.6 | 1.91666666666667 | 184 | 13 | 99 | 2 | 286 | 2 | 170 | 353 | MDQ3130306.1 prolyl oligopeptidase family serine peptidase [Acidobacteriota bacterium] | diamond | 552 | 109 | 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);;