contig_metadata
12 rows where bioproject = "PRJNA760976" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 742370 | 742370 | PRJNA760976_P_NODE_36421_length_281_cov_7.504808_g36100_i0 | PRJNA760976 | 36421 | 281 | 7.504808 | 21.08851048 | uncultured Acidobacteriota bacterium | 171953 | Bacteria | Bacteria | 313 | 1.08e-80 | NTclustered | gi|2874253692|emb|OY969418.1| | 171953 | g36100 | i0 | 86.667 | 134.391459074733 | 285 | 34 | 100 | 3 | 1 | 281 | 4233952 | 4233668 | MAG: uncultured Acidobacteriota bacterium isolate MFD09212.bin.c.1 genome assembly, chromosome: 1 | blastn | 37764 | 313 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | uncultured Acidobacteriota bacterium | ||||||
| 8395710 | 8395710 | PRJNA760976_P_NODE_53327_length_244_cov_0.859649_g53006_i0 | PRJNA760976 | 53327 | 244 | 0.859649 | 2.09754356 | FCB group | 1783270 | Bacteria | Bacteria | 131 | 8.09e-34 | NR | MFM8439716.1 | 1978231 | g53006 | i0 | 72.2 | 51.6270491803279 | 79 | 22 | 97.1 | 0 | 242 | 6 | 9 | 87 | MFM8439716.1 phosphoenolpyruvate carboxykinase (GTP) [Acidobacteriota bacterium] | diamond | 12597 | 132 | 0.992424242424242 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 27369520 | 27369520 | PRJNA760976_P_NODE_17643_length_364_cov_1.460481_g17322_i0 | PRJNA760976 | 17643 | 364 | 1.460481 | 5.31615084 | Blastocatellia bacterium | 2052146 | Bacteria | Bacteria | 201 | 4.7999999999999995e-61 | NR | HYE75320.1 | 2052146 | g17322 | i0 | 80.2 | 0.997252747252747 | 121 | 24 | 99.7 | 0 | 364 | 2 | 197 | 317 | HYE75320.1 nicotinate phosphoribosyltransferase [Blastocatellia bacterium] | diamond | 363 | 201 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Blastocatellia | Blastocatellia bacterium | |||||
| 28042046 | 28042046 | PRJNA760976_P_NODE_47425_length_252_cov_1.497207_g47104_i0 | PRJNA760976 | 47425 | 252 | 1.497207 | 3.77296164 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 51.6 | 3.16e-5 | NR | OLC48113.1 | 1803459 | g47104 | i0 | 43.2 | 1.95238095238095 | 88 | 40 | 97.6 | 3 | 2 | 247 | 537 | 620 | OLC48113.1 MAG: hypothetical protein AUH43_10200 [Acidobacteria bacterium 13_1_40CM_65_14] | diamond | 492 | 52 | 0.992307692307692 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteria bacterium 13_1_40CM_65_14 | ||||||
| 28073441 | 28073441 | PRJNA760976_P_NODE_54485_length_243_cov_0.864706_g54164_i0 | PRJNA760976 | 54485 | 243 | 0.864706 | 2.10123558 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 100 | 3.039999999999999e-23 | NR | WP_038050098.1 | 1312852 | g54164 | i0 | 58.8 | 6.88888888888889 | 80 | 30 | 98.8 | 2 | 242 | 3 | 249 | 325 | WP_038050098.1 M35 family metallo-endopeptidase [Thermoanaerobaculum aquaticum] | diamond | 1674 | 100 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Thermoanaerobaculia | Thermoanaerobaculales | Thermoanaerobaculaceae | Thermoanaerobaculum | Thermoanaerobaculum aquaticum | ||
| 28695501 | 28695501 | PRJNA760976_P_NODE_10727_length_437_cov_2.829670_g10408_i0 | PRJNA760976 | 10727 | 437 | 2.82967 | 12.3656579 | Acidobacteriota bacterium | 1978231 | Bacteria | Bacteria | 108 | 1.7700000000000002e-27 | NR | NOT44842.1 | 1978231 | g10408 | i0 | 62.4 | 0.583524027459954 | 85 | 31 | 58.4 | 1 | 257 | 3 | 5 | 88 | NOT44842.1 group 1 truncated hemoglobin [Acidobacteriota bacterium] | diamond | 255 | 108 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 28695508 | 28695508 | PRJNA760976_P_NODE_43707_length_261_cov_2.404255_g43386_i0 | PRJNA760976 | 43707 | 261 | 2.404255 | 6.27510555 | Thermoanaerobaculia bacterium | 2651171 | Bacteria | Bacteria | 43.1 | 0.0321 | NR | HLX08171.1 | 2651171 | g43386 | i0 | 47.8 | 0.528735632183908 | 46 | 24 | 52.9 | 0 | 23 | 160 | 325 | 370 | HLX08171.1 Hpt domain-containing protein [Thermoanaerobaculia bacterium] | diamond | 138 | 43.1 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Thermoanaerobaculia | Thermoanaerobaculia bacterium | |||||
| 28789928 | 28789928 | PRJNA760976_P_NODE_44067_length_261_cov_0.776596_g43746_i0 | PRJNA760976 | 44067 | 261 | 0.776596 | 2.02691556 | Terriglobales bacterium | 2282142 | Bacteria | Bacteria | 124 | 1.2699999999999998e-31 | NR | HYD49944.1 | 2282142 | g43746 | i0 | 67.9 | 0.96551724137931 | 84 | 27 | 96.6 | 0 | 255 | 4 | 275 | 358 | HYD49944.1 DUF4360 domain-containing protein [Terriglobales bacterium] | diamond | 252 | 124 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Terriglobales | Terriglobales bacterium | ||||
| 29651835 | 29651835 | PRJNA760976_P_NODE_54710_length_242_cov_1.775148_g54389_i0 | PRJNA760976 | 54710 | 242 | 1.775148 | 4.29585816 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 57.4 | 1.75e-7 | NR | MCU1306090.1 | 2052142 | g54389 | i0 | 48.6 | 2.62809917355372 | 70 | 32 | 86.8 | 1 | 239 | 30 | 28 | 93 | MCU1306090.1 regulator of chromosome condensation [Acidobacteriaceae bacterium] | diamond | 636 | 57.8 | 0.993079584775087 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Terriglobales | Acidobacteriaceae | Acidobacteriaceae bacterium | |||
| 30716510 | 30716510 | PRJNA760976_P_NODE_1914_length_915_cov_3.249406_g1655_i0 | PRJNA760976 | 1914 | 915 | 3.249406 | 29.7320649 | Bryobacterales bacterium | 2026791 | Bacteria | Bacteria | 413 | 1.28e-142 | NR | MSV28683.1 | 2026791 | g1655 | i0 | 71.5 | 18.3114754098361 | 281 | 80 | 92.1 | 0 | 858 | 16 | 1 | 281 | MSV28683.1 hypothetical protein [Bryobacterales bacterium] | diamond | 16755 | 413 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Bryobacterales | Bryobacterales bacterium | ||||
| 30843122 | 30843122 | PRJNA760976_P_NODE_14394_length_392_cov_0.934169_g14074_i0 | PRJNA760976 | 14394 | 392 | 0.934169 | 3.66194248 | Thermoanaerobaculia bacterium | 2651171 | Bacteria | Bacteria | 45.4 | 0.0199 | NR | MEO7793186.1 | 2651171 | g14074 | i0 | 34.2 | 0.604591836734694 | 79 | 45 | 55.9 | 2 | 384 | 166 | 119 | 196 | MEO7793186.1 apolipoprotein N-acyltransferase [Thermoanaerobaculia bacterium] | diamond | 237 | 45.4 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Thermoanaerobaculia | Thermoanaerobaculia bacterium | |||||
| 31095691 | 31095691 | PRJNA760976_P_NODE_3215_length_723_cov_6.938462_g2919_i0 | PRJNA760976 | 3215 | 723 | 6.938462 | 50.16508026 | Terriglobales bacterium | 2282142 | Bacteria | Bacteria | 240 | 6.259999999999998e-74 | NR | HYD49944.1 | 2282142 | g2919 | i0 | 63.4 | 0.759336099585062 | 183 | 67 | 75.9 | 0 | 175 | 723 | 232 | 414 | HYD49944.1 DUF4360 domain-containing protein [Terriglobales bacterium] | diamond | 549 | 240 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Terriglobales | Terriglobales 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);;