contig_metadata
23 rows where bioproject = "PRJNA758088", tax_kingdom = "Pseudomonadati" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2013900 | 2013900 | PRJNA758088_P_NODE_356042_length_242_cov_0.911243_g349071_i0 | PRJNA758088 | 356042 | 242 | 0.911243 | 2.20520806 | uncultured Acidobacteriota bacterium | 171953 | Bacteria | Bacteria | 414 | 2.41e-111 | NTclustered | gi|31789464|gb|AY281356.1| | 171953 | g349071 | i0 | 97.521 | 99.7479338842975 | 242 | 6 | 100 | 0 | 1 | 242 | 11460 | 11219 | Uncultured Acidobacteria bacterium clone 41b15 genomic sequence | blastn | 24139 | 414 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | uncultured Acidobacteriota bacterium | ||||||
| 14764544 | 14764544 | PRJNA758088_P_NODE_201932_length_299_cov_1.792035_g194961_i0 | PRJNA758088 | 201932 | 299 | 1.792035 | 5.35818465 | Edaphobacter paludis | 3035702 | Bacteria | Bacteria | 501 | 2.3e-137 | NTclustered | gi|2737763816|gb|CP121194.1| | 3035702 | g194961 | i0 | 96.99 | 264.234113712375 | 299 | 8 | 100 | 1 | 1 | 299 | 662671 | 662374 | Edaphobacter paludis strain DSM 109919 chromosome, complete genome | blastn | 79006 | 501 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Terriglobales | Acidobacteriaceae | Edaphobacter | Edaphobacter paludis | ||
| 15232583 | 15232583 | PRJNA758088_P_NODE_51912_length_615_cov_1.900369_g45166_i0 | PRJNA758088 | 51912 | 615 | 1.900369 | 11.68726935 | Tunturiibacter | 3154218 | Bacteria | Bacteria | 1020 | 0 | NTclustered | gi|2304905231|gb|CP073696.1| | 2051959 | g45166 | i0 | 96.585 | 103.547967479675 | 615 | 21 | 100 | 0 | 1 | 615 | 3200376 | 3199762 | Tunturiibacter lichenicola strain DSM 104462 chromosome, complete genome | blastn | 63682 | 1020 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Terriglobales | Acidobacteriaceae | Tunturiibacter | Tunturiibacter lichenicola | ||
| 16038319 | 16038319 | PRJNA758088_P_NODE_206013_length_296_cov_4.757848_g199042_i0 | PRJNA758088 | 206013 | 296 | 4.757848 | 14.08323008 | Edaphobacter paludis | 3035702 | Bacteria | Bacteria | 542 | 1.34e-149 | NTclustered | gi|2737763816|gb|CP121194.1| | 3035702 | g199042 | i0 | 99.662 | 107.449324324324 | 296 | 1 | 100 | 0 | 1 | 296 | 663004 | 663299 | Edaphobacter paludis strain DSM 109919 chromosome, complete genome | blastn | 31805 | 542 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Terriglobales | Acidobacteriaceae | Edaphobacter | Edaphobacter paludis | ||
| 16040152 | 16040152 | PRJNA758088_P_NODE_328673_length_245_cov_0.895349_g321702_i0 | PRJNA758088 | 328673 | 245 | 0.895349 | 2.19360505 | Thermoanaerobaculia bacterium | 2651171 | Bacteria | Bacteria | 132 | 1.56e-33 | NR | HVG10073.1 | 2651171 | g321702 | i0 | 84 | 1.98367346938776 | 81 | 13 | 99.2 | 0 | 243 | 1 | 1755 | 1835 | HVG10073.1 amino acid adenylation domain-containing protein [Thermoanaerobaculia bacterium] | diamond | 486 | 132 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Thermoanaerobaculia | Thermoanaerobaculia bacterium | |||||
| 26714261 | 26714261 | PRJNA758088_P_NODE_288401_length_250_cov_0.870056_g281430_i0 | PRJNA758088 | 288401 | 250 | 0.870056 | 2.17514 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 77 | 3.34e-14 | NR | MDQ3010428.1 | 1978231 | g281430 | i0 | 47.9 | 2.604 | 71 | 37 | 85.2 | 0 | 227 | 15 | 92 | 162 | MDQ3010428.1 DUF87 domain-containing protein [Acidobacteriota bacterium] | diamond | 651 | 77 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 27021378 | 27021378 | PRJNA758088_P_NODE_295222_length_249_cov_1.511364_g288251_i0 | PRJNA758088 | 295222 | 249 | 1.511364 | 3.76329636 | Candidatus Acidiferrales bacterium | 2952895 | Bacteria | Bacteria | 62.4 | 2.14e-9 | NR | HKO05849.1 | 2952895 | g288251 | i0 | 40.2 | 0.987951807228916 | 82 | 48 | 97.6 | 1 | 249 | 7 | 64 | 145 | HKO05849.1 MIP family channel protein [Candidatus Acidiferrales bacterium] | diamond | 246 | 62.4 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Candidatus Acidiferrales | Candidatus Acidiferrales bacterium | ||||
| 27306014 | 27306014 | PRJNA758088_P_NODE_314603_length_247_cov_0.885057_g307632_i0 | PRJNA758088 | 314603 | 247 | 0.885057 | 2.18609079 | Edaphobacter paludis | 3035702 | Bacteria | Bacteria | 97.8 | 1.67e-21 | NR | WP_348266976.1 | 3035702 | g307632 | i0 | 60.4 | 1.28744939271255 | 106 | 18 | 99.6 | 2 | 246 | 1 | 126 | 231 | WP_348266976.1 sensor histidine kinase [Edaphobacter paludis] | diamond | 318 | 97.8 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Terriglobales | Acidobacteriaceae | Edaphobacter | Edaphobacter paludis | ||
| 28189761 | 28189761 | PRJNA758088_P_NODE_285386_length_251_cov_0.865169_g278415_i0 | PRJNA758088 | 285386 | 251 | 0.865169 | 2.17157419 | Bryobacteraceae bacterium | 2212468 | Bacteria | Bacteria | 92.4 | 9.85e-20 | NR | GIU75024.1 | 2212468 | g278415 | i0 | 97.9 | 0.573705179282869 | 48 | 1 | 57.4 | 0 | 107 | 250 | 1 | 48 | GIU75024.1 MAG: acetoacetate metabolism regulatory protein AtoC [Bryobacteraceae bacterium] | diamond | 144 | 92.4 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Bryobacterales | Bryobacteraceae | Bryobacteraceae bacterium | |||
| 28821152 | 28821152 | PRJNA758088_P_NODE_115148_length_390_cov_3.283912_g108178_i0 | PRJNA758088 | 115148 | 390 | 3.283912 | 12.8072568 | Candidatus Sulfotelmatobacter sp. | 2771375 | Bacteria | Bacteria | 51.2 | 9.05e-5 | NR | HTS14375.1 | 2771375 | g108178 | i0 | 39.3 | 0.646153846153846 | 84 | 44 | 63.8 | 4 | 16 | 264 | 106 | 183 | HTS14375.1 hypothetical protein [Candidatus Sulfotelmatobacter sp.] | diamond | 252 | 51.2 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Terriglobales | Candidatus Korobacteraceae | Candidatus Sulfotelmatobacter | Candidatus Sulfotelmatobacter sp. | ||
| 28979513 | 28979513 | PRJNA758088_P_NODE_286008_length_251_cov_0.865169_g279037_i0 | PRJNA758088 | 286008 | 251 | 0.865169 | 2.17157419 | Vicinamibacterales bacterium | 2910147 | Bacteria | Bacteria | 131 | 1.6299999999999998e-35 | NR | HEU4691948.1 | 2910147 | g279037 | i0 | 84 | 0.968127490039841 | 81 | 13 | 96.8 | 0 | 250 | 8 | 187 | 267 | HEU4691948.1 hypothetical protein [Vicinamibacterales bacterium] | diamond | 243 | 131 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Vicinamibacteria | Vicinamibacterales | Vicinamibacterales bacterium | ||||
| 29358316 | 29358316 | PRJNA758088_P_NODE_274849_length_254_cov_1.248619_g267878_i0 | PRJNA758088 | 274849 | 254 | 1.248619 | 3.17149226 | Terracidiphilus sp. | 1964191 | Bacteria | Bacteria | 59.7 | 2.14e-8 | NR | HEY6848938.1 | 1964191 | g267878 | i0 | 44.2 | 0.909448818897638 | 77 | 42 | 89.8 | 1 | 253 | 26 | 142 | 218 | HEY6848938.1 ankyrin repeat domain-containing protein [Terracidiphilus sp.] | diamond | 231 | 59.7 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Terriglobales | Acidobacteriaceae | Terracidiphilus | Terracidiphilus sp. | ||
| 29462426 | 29462426 | PRJNA758088_P_NODE_307250_length_248_cov_0.880000_g300279_i0 | PRJNA758088 | 307250 | 248 | 0.88 | 2.1824 | Bacteria | 2 | Bacteria | Bacteria | 143 | 9.62e-39 | NR | MCU1295494.1 | 2026791 | g300279 | i0 | 77.8 | 17.6733870967742 | 81 | 18 | 98 | 0 | 4 | 246 | 256 | 336 | MCU1295494.1 hypothetical protein [Bryobacterales bacterium] | diamond | 4383 | 144 | 0.993055555555556 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Bryobacterales | Bryobacterales bacterium | ||||
| 29926751 | 29926751 | PRJNA758088_P_NODE_220791_length_287_cov_0.985981_g213820_i0 | PRJNA758088 | 220791 | 287 | 0.985981 | 2.82976547 | Bryobacteraceae bacterium | 2212468 | Bacteria | Bacteria | 45.4 | 0.00568 | NR | MFN0172054.1 | 2212468 | g213820 | i0 | 39.5 | 0.794425087108014 | 76 | 42 | 76.3 | 2 | 15 | 233 | 139 | 213 | MFN0172054.1 PEP-CTERM sorting domain-containing protein [Bryobacteraceae bacterium] | diamond | 228 | 45.4 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Bryobacterales | Bryobacteraceae | Bryobacteraceae bacterium | |||
| 30116062 | 30116062 | PRJNA758088_P_NODE_269092_length_257_cov_1.494565_g262121_i0 | PRJNA758088 | 269092 | 257 | 1.494565 | 3.84103205 | Pyrinomonadaceae bacterium | 2283092 | Bacteria | Bacteria | 94 | 5.48e-22 | NR | HEX8150060.1 | 2283092 | g262121 | i0 | 90.2 | 2.38132295719844 | 51 | 5 | 59.5 | 0 | 1 | 153 | 120 | 170 | HEX8150060.1 alpha/beta fold hydrolase [Pyrinomonadaceae bacterium] | diamond | 612 | 94 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Blastocatellia | Blastocatellales | Pyrinomonadaceae | Pyrinomonadaceae bacterium | |||
| 30621569 | 30621569 | PRJNA758088_P_NODE_270253_length_256_cov_2.229508_g263282_i0 | PRJNA758088 | 270253 | 256 | 2.229508 | 5.70754048 | Pyrinomonadaceae bacterium | 2283092 | Bacteria | Bacteria | 161 | 7.47e-44 | NR | HUE84360.1 | 2283092 | g263282 | i0 | 94.1 | 6.9609375 | 85 | 5 | 99.6 | 0 | 2 | 256 | 45 | 129 | HUE84360.1 hypothetical protein [Pyrinomonadaceae bacterium] | diamond | 1782 | 161 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Blastocatellia | Blastocatellales | Pyrinomonadaceae | Pyrinomonadaceae bacterium | |||
| 30874455 | 30874455 | PRJNA758088_P_NODE_304914_length_248_cov_0.880000_g297943_i0 | PRJNA758088 | 304914 | 248 | 0.88 | 2.1824 | Luteitalea sp. | 2004800 | Bacteria | Bacteria | 42.7 | 0.0401 | NR | WP_396624986.1 | 2004800 | g297943 | i0 | 39.7 | 0.701612903225806 | 58 | 32 | 66.5 | 1 | 214 | 50 | 161 | 218 | WP_396624986.1 hypothetical protein [Luteitalea sp.] | diamond | 174 | 42.7 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Vicinamibacteria | Vicinamibacterales | Vicinamibacteraceae | Luteitalea | Luteitalea sp. | ||
| 31664709 | 31664709 | PRJNA758088_P_NODE_282577_length_251_cov_0.865169_g275606_i0 | PRJNA758088 | 282577 | 251 | 0.865169 | 2.17157419 | Acidobacteriota bacterium | 1978231 | Bacteria | Bacteria | 65.9 | 2.13e-10 | NR | NBO66762.1 | 1978231 | g275606 | i0 | 45.5 | 0.920318725099602 | 77 | 41 | 90.8 | 1 | 24 | 251 | 178 | 254 | NBO66762.1 hypothetical protein [Acidobacteriota bacterium] | diamond | 231 | 65.9 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 31664728 | 31664728 | PRJNA758088_P_NODE_347817_length_243_cov_0.905882_g340846_i0 | PRJNA758088 | 347817 | 243 | 0.905882 | 2.20129326 | Blastocatellia bacterium | 2052146 | Bacteria | Bacteria | 154 | 3.769999999999999e-46 | NR | HVF92611.1 | 2052146 | g340846 | i0 | 93.8 | 2.98765432098765 | 80 | 5 | 98.8 | 0 | 1 | 240 | 49 | 128 | HVF92611.1 peroxiredoxin [Blastocatellia bacterium] | diamond | 726 | 154 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Blastocatellia | Blastocatellia bacterium | |||||
| 31674509 | 31674509 | PRJNA758088_P_NODE_255597_length_265_cov_1.541667_g248626_i0 | PRJNA758088 | 255597 | 265 | 1.541667 | 4.08541755 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 116 | 1.06e-30 | NR | MDR3742231.1 | 1964191 | g248626 | i0 | 58.6 | 2.92075471698113 | 87 | 35 | 98.5 | 1 | 3 | 263 | 25 | 110 | MDR3742231.1 hypothetical protein [Terracidiphilus sp.] | diamond | 774 | 117 | 0.991452991452991 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Terriglobales | Acidobacteriaceae | Terracidiphilus | Terracidiphilus sp. | ||
| 32266220 | 32266220 | PRJNA758088_P_NODE_231318_length_280_cov_1.260870_g224347_i0 | PRJNA758088 | 231318 | 280 | 1.26087 | 3.530436 | Acidobacteriota bacterium | 1978231 | Bacteria | Bacteria | 80.9 | 1.35e-15 | NR | MFM2124719.1 | 1978231 | g224347 | i0 | 45.6 | 0.964285714285714 | 90 | 49 | 96.4 | 0 | 279 | 10 | 252 | 341 | MFM2124719.1 hypothetical protein [Acidobacteriota bacterium] | diamond | 270 | 80.9 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 32297982 | 32297982 | PRJNA758088_P_NODE_288999_length_250_cov_0.870056_g282028_i0 | PRJNA758088 | 288999 | 250 | 0.870056 | 2.17514 | Vicinamibacterales bacterium | 2910147 | Bacteria | Bacteria | 152 | 5.9899999999999996e-43 | NR | HUK37149.1 | 2910147 | g282028 | i0 | 88 | 3.984 | 83 | 10 | 99.6 | 0 | 250 | 2 | 199 | 281 | HUK37149.1 hypothetical protein [Vicinamibacterales bacterium] | diamond | 996 | 152 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Vicinamibacteria | Vicinamibacterales | Vicinamibacterales bacterium | ||||
| 32708196 | 32708196 | PRJNA758088_P_NODE_337480_length_244_cov_0.900585_g330509_i0 | PRJNA758088 | 337480 | 244 | 0.900585 | 2.1974274 | Acidobacteriota bacterium | 1978231 | Bacteria | Bacteria | 78.6 | 9.43e-15 | NR | MBS1768271.1 | 1978231 | g330509 | i0 | 66.7 | 1.40163934426229 | 57 | 19 | 70.1 | 0 | 172 | 2 | 1194 | 1250 | MBS1768271.1 hypothetical protein [Acidobacteriota bacterium] | diamond | 342 | 78.6 | 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);;