contig_metadata
12 rows where analysis = "diamond", bioproject = "PRJNA753112" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 16504553 | 16504553 | PRJNA753112_P_NODE_24733_length_274_cov_1.552239_g24391_i0 | PRJNA753112 | 24733 | 274 | 1.552239 | 4.25313486 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 125 | 2.96e-33 | NR | MCI0406950.1 | 1978231 | g24391 | i0 | 65.6 | 2.87956204379562 | 90 | 31 | 98.5 | 0 | 272 | 3 | 22 | 111 | MCI0406950.1 DUF3050 domain-containing protein [Acidobacteriota bacterium] | diamond | 789 | 125 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 26831430 | 26831430 | PRJNA753112_P_NODE_27101_length_261_cov_1.659574_g26759_i0 | PRJNA753112 | 27101 | 261 | 1.659574 | 4.33148814 | Terriglobales bacterium | 2282142 | Bacteria | Bacteria | 167 | 1.4e-46 | NR | HEV8525821.1 | 2282142 | g26759 | i0 | 100 | 0.977011494252874 | 85 | 0 | 97.7 | 0 | 256 | 2 | 1 | 85 | HEV8525821.1 hypothetical protein [Terriglobales bacterium] | diamond | 255 | 167 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Terriglobales | Terriglobales bacterium | ||||
| 27084554 | 27084554 | PRJNA753112_P_NODE_32042_length_245_cov_2.093023_g31700_i0 | PRJNA753112 | 32042 | 245 | 2.093023 | 5.12790635 | Acidobacteriota bacterium | 1978231 | Bacteria | Bacteria | 98.2 | 7.13e-24 | NR | MBI1752218.1 | 1978231 | g31700 | i0 | 67.6 | 0.83265306122449 | 68 | 22 | 83.3 | 0 | 204 | 1 | 1 | 68 | MBI1752218.1 VOC family protein [Acidobacteriota bacterium] | diamond | 204 | 98.2 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 27558204 | 27558204 | PRJNA753112_P_NODE_11504_length_401_cov_1.414634_g11162_i0 | PRJNA753112 | 11504 | 401 | 1.414634 | 5.67268234 | Vicinamibacterales bacterium | 2910147 | Bacteria | Bacteria | 134 | 7.34e-37 | NR | MFN7982488.1 | 2910147 | g11162 | i0 | 66 | 1.61596009975062 | 106 | 36 | 79.3 | 0 | 80 | 397 | 35 | 140 | MFN7982488.1 ThiF family adenylyltransferase [Vicinamibacterales bacterium] | diamond | 648 | 134 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Vicinamibacteria | Vicinamibacterales | Vicinamibacterales bacterium | ||||
| 28158552 | 28158552 | PRJNA753112_P_NODE_10485_length_419_cov_2.132948_g10143_i0 | PRJNA753112 | 10485 | 419 | 2.132948 | 8.93705212 | Terriglobales bacterium | 2282142 | Bacteria | Bacteria | 280 | 8.95e-86 | NR | HEV8525822.1 | 2282142 | g10143 | i0 | 95.7 | 0.995226730310263 | 139 | 6 | 99.5 | 0 | 417 | 1 | 357 | 495 | HEV8525822.1 helicase-related protein [Terriglobales bacterium] | diamond | 417 | 280 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Terriglobales | Terriglobales bacterium | ||||
| 28189664 | 28189664 | PRJNA753112_P_NODE_23286_length_282_cov_2.765550_g22944_i0 | PRJNA753112 | 23286 | 282 | 2.76555 | 7.798851 | Bryobacterales bacterium | 2026791 | Bacteria | Bacteria | 71.6 | 4.15e-12 | NR | MBV9398022.1 | 2026791 | g22944 | i0 | 37.4 | 3.77659574468085 | 91 | 54 | 93.6 | 2 | 6 | 269 | 406 | 496 | MBV9398022.1 Ig-like domain repeat protein [Bryobacterales bacterium] | diamond | 1065 | 71.6 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Bryobacterales | Bryobacterales bacterium | ||||
| 28411041 | 28411041 | PRJNA753112_P_NODE_9326_length_445_cov_1.204301_g8984_i0 | PRJNA753112 | 9326 | 445 | 1.204301 | 5.35913945 | Terriglobales bacterium | 2282142 | Bacteria | Bacteria | 261 | 7.18e-81 | NR | HEV8525821.1 | 2282142 | g8984 | i0 | 93.2 | 0.991011235955056 | 147 | 10 | 99.1 | 0 | 3 | 443 | 249 | 395 | HEV8525821.1 hypothetical protein [Terriglobales bacterium] | diamond | 441 | 261 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Terriglobales | Terriglobales bacterium | ||||
| 30589918 | 30589918 | PRJNA753112_P_NODE_12773_length_379_cov_1.513072_g12431_i0 | PRJNA753112 | 12773 | 379 | 1.513072 | 5.73454288 | Thermoanaerobaculia bacterium | 2651171 | Bacteria | Bacteria | 82 | 1.22e-15 | NR | MCL4837380.1 | 2651171 | g12431 | i0 | 66.7 | 0.474934036939314 | 60 | 18 | 47.5 | 1 | 181 | 2 | 12 | 69 | MCL4837380.1 serine O-acetyltransferase [Thermoanaerobaculia bacterium] | diamond | 180 | 82 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Thermoanaerobaculia | Thermoanaerobaculia bacterium | |||||
| 30599734 | 30599734 | PRJNA753112_P_NODE_21473_length_293_cov_1.700000_g21131_i0 | PRJNA753112 | 21473 | 293 | 1.7 | 4.981 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 100 | 4.72e-22 | NR | PYQ27636.1 | 1978231 | g21131 | i0 | 47.9 | 1.95563139931741 | 96 | 49 | 98.3 | 1 | 4 | 291 | 65 | 159 | PYQ27636.1 MAG: hypothetical protein DMF57_18220, partial [Acidobacteriota bacterium] | diamond | 573 | 100 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 32329490 | 32329490 | PRJNA753112_P_NODE_30299_length_249_cov_1.721591_g29957_i0 | PRJNA753112 | 30299 | 249 | 1.721591 | 4.28676159 | Geothrix sp. | 1962974 | Bacteria | Bacteria | 43.5 | 0.0224 | NR | WP_291273010.1 | 1962974 | g29957 | i0 | 51.4 | 0.44578313253012 | 37 | 18 | 44.6 | 0 | 91 | 201 | 434 | 470 | WP_291273010.1 sigma-54-dependent transcriptional regulator [Geothrix sp.] | diamond | 111 | 43.5 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Holophagae | Holophagales | Holophagaceae | Geothrix | Geothrix sp. | ||
| 32708116 | 32708116 | PRJNA753112_P_NODE_31520_length_246_cov_2.635838_g31178_i0 | PRJNA753112 | 31520 | 246 | 2.635838 | 6.48416148 | Candidatus Sulfotelmatobacter sp. | 2771375 | Bacteria | Bacteria | 66.6 | 4.94e-11 | NR | HVI52543.1 | 2771375 | g31178 | i0 | 46.2 | 1.58536585365854 | 65 | 35 | 79.3 | 0 | 244 | 50 | 156 | 220 | HVI52543.1 VPLPA-CTERM sorting domain-containing protein [Candidatus Sulfotelmatobacter sp.] | diamond | 390 | 66.6 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Terriglobales | Candidatus Korobacteraceae | Candidatus Sulfotelmatobacter | Candidatus Sulfotelmatobacter sp. | ||
| 32770999 | 32770999 | PRJNA753112_P_NODE_16800_length_331_cov_1.790698_g16458_i0 | PRJNA753112 | 16800 | 331 | 1.790698 | 5.92721038 | Acidobacteriota bacterium | 1978231 | Bacteria | Bacteria | 105 | 1.4000000000000002e-23 | NR | MBA2732119.1 | 1978231 | g16458 | i0 | 66.7 | 0.842900302114804 | 93 | 30 | 84.3 | 1 | 329 | 51 | 3327 | 3418 | MBA2732119.1 lamin tail domain-containing protein [Acidobacteriota bacterium] | diamond | 279 | 105 | 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);;