contig_metadata
24 rows where bioproject = "PRJNA1150539", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4128632 | 4128632 | PRJNA1150539_S_NODE_82644_length_262_cov_3.507937_g82048_i0 | PRJNA1150539 | 82644 | 262 | 3.507937 | 9.19079494 | Bryobacteraceae bacterium | 2212468 | Bacteria | Bacteria | 326 | 1.2799999999999999e-84 | NTclustered | gi|2621707050|emb|OY764903.1| | 2212468 | g82048 | i0 | 89.057 | 107.977099236641 | 265 | 25 | 99 | 3 | 1 | 261 | 3557904 | 3558168 | MAG: Bryobacteraceae bacterium isolate d7944118-f527-4ba8-a886-cdd3ae4bc3f8 genome assembly, chromosome: 1 | blastn | 28290 | 326 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Bryobacterales | Bryobacteraceae | Bryobacteraceae bacterium | |||
| 11780409 | 11780409 | PRJNA1150539_S_NODE_92110_length_251_cov_1.646067_g91514_i0 | PRJNA1150539 | 92110 | 251 | 1.646067 | 4.13162817 | uncultured Acidobacteriota bacterium | 171953 | Bacteria | Bacteria | 54.7 | 0.006 | NTclustered | gi|2874253836|emb|OY969886.1| | 171953 | g91514 | i0 | 96.875 | 0.127490039840637 | 32 | 1 | 13 | 0 | 216 | 247 | 2338574 | 2338543 | MAG: uncultured Acidobacteriota bacterium isolate MFD10007.bin.c.1 genome assembly, chromosome: 1 | blastn | 32 | 54.7 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | uncultured Acidobacteriota bacterium | ||||||
| 26628700 | 26628700 | PRJNA1150539_S_NODE_58261_length_297_cov_2.214286_g57665_i0 | PRJNA1150539 | 58261 | 297 | 2.214286 | 6.57642942 | Acidobacteriota bacterium | 1978231 | Bacteria | Bacteria | 44.7 | 0.0139 | NR | MBK9064932.1 | 1978231 | g57665 | i0 | 39.3 | 1.6969696969697 | 84 | 36 | 84.8 | 2 | 20 | 271 | 15 | 83 | MBK9064932.1 FAD-dependent oxidoreductase [Acidobacteriota bacterium] | diamond | 504 | 44.7 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 26647972 | 26647972 | PRJNA1150539_S_NODE_59261_length_295_cov_4.585586_g58665_i0 | PRJNA1150539 | 59261 | 295 | 4.585586 | 13.5274787 | Bacteria | 2 | Bacteria | Bacteria | 47.4 | 0.00146 | NR | HOQ47985.1 | 2212468 | g58665 | i0 | 44.6 | 1.32203389830508 | 65 | 29 | 63.1 | 2 | 281 | 96 | 76 | 136 | HOQ47985.1 hypothetical protein [Bryobacteraceae bacterium] | diamond | 390 | 47.4 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Bryobacterales | Bryobacteraceae | Bryobacteraceae bacterium | |||
| 27008465 | 27008465 | PRJNA1150539_S_NODE_91942_length_251_cov_2.044944_g91346_i0 | PRJNA1150539 | 91942 | 251 | 2.044944 | 5.13280944 | Candidatus Acidiferrum sp. | 3069120 | Bacteria | Bacteria | 44.7 | 0.00871 | NR | HLZ50741.1 | 3069120 | g91346 | i0 | 37.5 | 0.860557768924303 | 72 | 34 | 80.1 | 3 | 16 | 216 | 12 | 77 | HLZ50741.1 DNA internalization-related competence protein ComEC/Rec2 [Candidatus Acidiferrum sp.] | diamond | 216 | 44.7 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Candidatus Acidiferrales | Candidatus Acidiferrum | Candidatus Acidiferrum sp. | |||
| 27071847 | 27071847 | PRJNA1150539_S_NODE_83222_length_262_cov_0.862434_g82626_i0 | PRJNA1150539 | 83222 | 262 | 0.862434 | 2.25957708 | Terriglobales bacterium | 2282142 | Bacteria | Bacteria | 42.7 | 0.0475 | NR | MFL6299362.1 | 2282142 | g82626 | i0 | 40.3 | 0.824427480916031 | 72 | 37 | 81.3 | 4 | 23 | 235 | 241 | 307 | MFL6299362.1 chloride channel protein [Terriglobales bacterium] | diamond | 216 | 42.7 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Terriglobales | Terriglobales bacterium | ||||
| 27735578 | 27735578 | PRJNA1150539_S_NODE_96304_length_247_cov_1.327586_g95708_i0 | PRJNA1150539 | 96304 | 247 | 1.327586 | 3.27913742 | Acidobacteriota bacterium | 1978231 | Bacteria | Bacteria | 45.8 | 0.00313 | NR | HUU47070.1 | 1978231 | g95708 | i0 | 38 | 0.607287449392713 | 50 | 30 | 60.7 | 1 | 87 | 236 | 543 | 591 | HUU47070.1 glycosyltransferase family 39 protein [Acidobacteriota bacterium] | diamond | 150 | 45.8 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 28619536 | 28619536 | PRJNA1150539_S_NODE_71707_length_277_cov_2.250000_g71111_i0 | PRJNA1150539 | 71707 | 277 | 2.25 | 6.2325 | Thermoanaerobaculia bacterium | 2651171 | Bacteria | Bacteria | 43.1 | 0.0209 | NR | HSK75308.1 | 2651171 | g71111 | i0 | 50 | 0.541516245487365 | 50 | 25 | 54.2 | 0 | 253 | 104 | 50 | 99 | HSK75308.1 hypothetical protein [Thermoanaerobaculia bacterium] | diamond | 150 | 43.1 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Thermoanaerobaculia | Thermoanaerobaculia bacterium | |||||
| 28777126 | 28777126 | PRJNA1150539_S_NODE_64647_length_287_cov_2.878505_g64051_i0 | PRJNA1150539 | 64647 | 287 | 2.878505 | 8.26130935 | Terriglobia bacterium | 2081523 | Bacteria | Bacteria | 43.5 | 0.0339 | NR | MFQ5663260.1 | 2081523 | g64051 | i0 | 38 | 0.742160278745645 | 71 | 37 | 70 | 3 | 14 | 214 | 341 | 408 | MFQ5663260.1 LPS export ABC transporter permease LptF [Terriglobia bacterium] | diamond | 213 | 43.5 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Terriglobia bacterium | |||||
| 29061540 | 29061540 | PRJNA1150539_S_NODE_74388_length_273_cov_2.920000_g73792_i0 | PRJNA1150539 | 74388 | 273 | 2.92 | 7.9716 | Acidobacteriota bacterium | 1978231 | Bacteria | Bacteria | 43.1 | 0.0314 | NR | MBX3299453.1 | 1978231 | g73792 | i0 | 34.3 | 0.769230769230769 | 70 | 39 | 76.9 | 1 | 3 | 212 | 146 | 208 | MBX3299453.1 hemolysin III family protein [Acidobacteriota bacterium] | diamond | 210 | 43.1 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 29093133 | 29093133 | PRJNA1150539_S_NODE_86908_length_257_cov_2.130435_g86312_i0 | PRJNA1150539 | 86908 | 257 | 2.130435 | 5.47521795 | Edaphobacter sp. | 1934404 | Bacteria | Bacteria | 42.7 | 0.0446 | NR | HTF69929.1 | 1934404 | g86312 | i0 | 40 | 0.642023346303502 | 55 | 33 | 64.2 | 0 | 11 | 175 | 549 | 603 | HTF69929.1 polysaccharide biosynthesis tyrosine autokinase [Edaphobacter sp.] | diamond | 165 | 42.7 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Terriglobales | Acidobacteriaceae | Edaphobacter | Edaphobacter sp. | ||
| 29282213 | 29282213 | PRJNA1150539_S_NODE_16049_length_398_cov_6.572308_g15454_i0 | PRJNA1150539 | 16049 | 398 | 6.572308 | 26.15778584 | Blastocatellia bacterium | 2052146 | Bacteria | Bacteria | 165 | 2.17e-50 | NR | HEX4951128.1 | 2052146 | g15454 | i0 | 94 | 0.633165829145729 | 84 | 5 | 63.3 | 0 | 344 | 93 | 1 | 84 | HEX4951128.1 type II toxin-antitoxin system MqsA family antitoxin [Blastocatellia bacterium] | diamond | 252 | 165 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Blastocatellia | Blastocatellia bacterium | |||||
| 29692533 | 29692533 | PRJNA1150539_S_NODE_60790_length_293_cov_2.768182_g60194_i0 | PRJNA1150539 | 60790 | 293 | 2.768182 | 8.11077326 | Candidatus Acidiferrales bacterium | 2952895 | Bacteria | Bacteria | 45.8 | 0.00516 | NR | MFB3140414.1 | 2952895 | g60194 | i0 | 41.5 | 0.665529010238908 | 65 | 35 | 66.6 | 1 | 38 | 232 | 158 | 219 | MFB3140414.1 PDZ domain-containing protein [Candidatus Acidiferrales bacterium] | diamond | 195 | 45.8 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Candidatus Acidiferrales | Candidatus Acidiferrales bacterium | ||||
| 29724137 | 29724137 | PRJNA1150539_S_NODE_10410_length_435_cov_5.138122_g9815_i0 | PRJNA1150539 | 10410 | 435 | 5.138122 | 22.3508307 | Vicinamibacterales bacterium | 2910147 | Bacteria | Bacteria | 45.4 | 0.0263 | NR | HZM58924.1 | 2910147 | g9815 | i0 | 39.7 | 0.468965517241379 | 68 | 39 | 46.2 | 2 | 349 | 149 | 108 | 174 | HZM58924.1 heparan-alpha-glucosaminide N-acetyltransferase domain-containing protein [Vicinamibacterales bacterium] | diamond | 204 | 45.4 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Vicinamibacteria | Vicinamibacterales | Vicinamibacterales bacterium | ||||
| 29850852 | 29850852 | PRJNA1150539_S_NODE_106411_length_233_cov_3.875000_g105815_i0 | PRJNA1150539 | 106411 | 233 | 3.875 | 9.02875 | Blastocatellia bacterium | 2052146 | Bacteria | Bacteria | 45.1 | 0.00499 | NR | HKC84589.1 | 2052146 | g105815 | i0 | 47.5 | 1.57081545064378 | 61 | 31 | 77.3 | 1 | 218 | 39 | 337 | 397 | HKC84589.1 hypothetical protein [Blastocatellia bacterium] | diamond | 366 | 45.1 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Blastocatellia | Blastocatellia bacterium | |||||
| 29977049 | 29977049 | PRJNA1150539_S_NODE_109931_length_225_cov_4.736842_g109335_i0 | PRJNA1150539 | 109931 | 225 | 4.736842 | 10.6578945 | Acidobacteriaceae bacterium | 2052142 | Bacteria | Bacteria | 42.4 | 0.0246 | NR | HEX6496486.1 | 2052142 | g109335 | i0 | 43.6 | 0.733333333333333 | 55 | 19 | 57.3 | 2 | 25 | 153 | 103 | 157 | HEX6496486.1 cytochrome c-type biogenesis protein CcmH [Acidobacteriaceae bacterium] | diamond | 165 | 42.4 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Terriglobales | Acidobacteriaceae | Acidobacteriaceae bacterium | |||
| 30356772 | 30356772 | PRJNA1150539_S_NODE_71992_length_277_cov_1.122549_g71396_i0 | PRJNA1150539 | 71992 | 277 | 1.122549 | 3.10946073 | Candidatus Acidiferrum sp. | 3069120 | Bacteria | Bacteria | 42.4 | 0.045 | NR | HLZ11862.1 | 3069120 | g71396 | i0 | 32.9 | 0.790613718411552 | 73 | 41 | 70.4 | 2 | 24 | 218 | 26 | 98 | HLZ11862.1 DinB family protein [Candidatus Acidiferrum sp.] | diamond | 219 | 42.4 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Candidatus Acidiferrales | Candidatus Acidiferrum | Candidatus Acidiferrum sp. | |||
| 30356778 | 30356778 | PRJNA1150539_S_NODE_98292_length_245_cov_1.505814_g97696_i0 | PRJNA1150539 | 98292 | 245 | 1.505814 | 3.6892443 | Candidatus Solibacter sp. | 2068625 | Bacteria | Bacteria | 43.1 | 0.0138 | NR | MCX6632675.1 | 2068625 | g97696 | i0 | 26.9 | 0.955102040816327 | 78 | 54 | 91.8 | 1 | 243 | 19 | 6 | 83 | MCX6632675.1 hypothetical protein [Candidatus Solibacter sp.] | diamond | 234 | 43.1 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Bryobacterales | Solibacteraceae | Candidatus Solibacter | Candidatus Solibacter sp. | ||
| 30577170 | 30577170 | PRJNA1150539_S_NODE_92933_length_250_cov_2.056497_g92337_i0 | PRJNA1150539 | 92933 | 250 | 2.056497 | 5.1412425 | Acidobacteriota bacterium | 1978231 | Bacteria | Bacteria | 44.3 | 0.0108 | NR | MBM3765365.1 | 1978231 | g92337 | i0 | 37.1 | 0.84 | 70 | 40 | 84 | 1 | 41 | 250 | 143 | 208 | MBM3765365.1 hypothetical protein [Acidobacteriota bacterium] | diamond | 210 | 44.3 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 30596675 | 30596675 | PRJNA1150539_S_NODE_65693_length_286_cov_1.084507_g65097_i0 | PRJNA1150539 | 65693 | 286 | 1.084507 | 3.10169002 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 46.2 | 0.00371 | NR | MBI1748781.1 | 1978231 | g65097 | i0 | 30.3 | 1.42657342657343 | 76 | 51 | 77.6 | 1 | 49 | 270 | 163 | 238 | MBI1748781.1 lipopolysaccharide biosynthesis protein [Acidobacteriota bacterium] | diamond | 408 | 46.2 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 30640460 | 30640460 | PRJNA1150539_S_NODE_102473_length_241_cov_2.017857_g101877_i0 | PRJNA1150539 | 102473 | 241 | 2.017857 | 4.86303537 | Bryobacteraceae bacterium | 2212468 | Bacteria | Bacteria | 43.9 | 0.0142 | NR | HME07450.1 | 2212468 | g101877 | i0 | 35.7 | 0.697095435684647 | 56 | 36 | 69.7 | 0 | 177 | 10 | 61 | 116 | HME07450.1 hypothetical protein [Bryobacteraceae bacterium] | diamond | 168 | 43.9 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Bryobacterales | Bryobacteraceae | Bryobacteraceae bacterium | |||
| 31683591 | 31683591 | PRJNA1150539_S_NODE_82977_length_262_cov_1.629630_g82381_i0 | PRJNA1150539 | 82977 | 262 | 1.62963 | 4.2696306 | Vicinamibacterales bacterium | 2910147 | Bacteria | Bacteria | 57.8 | 2.28e-7 | NR | HEY7501598.1 | 2910147 | g82381 | i0 | 86.7 | 0.343511450381679 | 30 | 4 | 34.4 | 0 | 162 | 251 | 63 | 92 | HEY7501598.1 IlvD/Edd family dehydratase [Vicinamibacterales bacterium] | diamond | 90 | 57.8 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Vicinamibacteria | Vicinamibacterales | Vicinamibacterales bacterium | ||||
| 32000113 | 32000113 | PRJNA1150539_S_NODE_111718_length_213_cov_4.071429_g111122_i0 | PRJNA1150539 | 111718 | 213 | 4.071429 | 8.67214377 | Pyrinomonadaceae bacterium | 2283092 | Bacteria | Bacteria | 43.9 | 0.00943 | NR | HEY0428600.1 | 2283092 | g111122 | i0 | 45.2 | 0.591549295774648 | 42 | 22 | 57.7 | 1 | 38 | 160 | 63 | 104 | HEY0428600.1 NAD(P)-dependent alcohol dehydrogenase [Pyrinomonadaceae bacterium] | diamond | 126 | 43.9 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Blastocatellia | Blastocatellales | Pyrinomonadaceae | Pyrinomonadaceae bacterium | |||
| 32663919 | 32663919 | PRJNA1150539_S_NODE_108020_length_230_cov_2.044586_g107424_i0 | PRJNA1150539 | 108020 | 230 | 2.044586 | 4.7025478 | Acidobacteriota bacterium | 1978231 | Bacteria | Bacteria | 42.7 | 0.0297 | NR | MBM3765365.1 | 1978231 | g107424 | i0 | 35.7 | 0.91304347826087 | 70 | 41 | 91.3 | 1 | 217 | 8 | 143 | 208 | MBM3765365.1 hypothetical protein [Acidobacteriota bacterium] | diamond | 210 | 42.7 | 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);;