contig_metadata
27 rows where bioproject = "PRJNA896554", tax_kingdom = "Bacillati" and tax_phylum = "Chloroflexota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2146238 | 2146238 | PRJNA896554_P_NODE_165502_length_245_cov_0.895349_g157962_i0 | PRJNA896554 | 165502 | 245 | 0.895349 | 2.19360505 | Chloroflexota bacterium | 2026724 | Bacteria | Bacteria | 62.1 | 3.67e-5 | NTclustered | gi|2621706018|emb|OY764080.1| | 2026724 | g157962 | i0 | 89.583 | 0.783673469387755 | 48 | 5 | 20 | 0 | 59 | 106 | 694236 | 694189 | MAG: Chloroflexota bacterium isolate a04a8705-9522-4335-bb9c-b9bb47e5c42e genome assembly, chromosome: 1 | blastn | 192 | 62.1 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 11447589 | 11447589 | PRJNA896554_P_NODE_47369_length_717_cov_2.993789_g40028_i0 | PRJNA896554 | 47369 | 717 | 2.993789 | 21.46546713 | Litorilinea | 1215913 | Bacteria | Bacteria | 267 | 6.07e-86 | NR | WP_141612290.1 | 1204385 | g40028 | i0 | 82 | 21.1589958158996 | 172 | 30 | 72 | 1 | 202 | 717 | 11 | 181 | WP_141612290.1 pyridoxal 5'-phosphate synthase lyase subunit PdxS [Litorilinea aerophila] | diamond | 15171 | 269 | 0.992565055762082 | Bacteria | Bacillati | Chloroflexota | Caldilineae | Caldilineales | Caldilineaceae | Litorilinea | Litorilinea aerophila | ||
| 25470491 | 25470491 | PRJNA896554_P_NODE_161500_length_246_cov_1.560694_g153960_i0 | PRJNA896554 | 161500 | 246 | 1.560694 | 3.83930724 | Chloroflexota bacterium | 2026724 | Bacteria | Bacteria | 114 | 4.14e-28 | NR | MBI3973559.1 | 2026724 | g153960 | i0 | 72.5 | 0.975609756097561 | 80 | 22 | 97.6 | 0 | 244 | 5 | 27 | 106 | MBI3973559.1 AAA family ATPase [Chloroflexota bacterium] | diamond | 240 | 114 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 26612318 | 26612318 | PRJNA896554_P_NODE_155161_length_249_cov_0.875000_g147621_i0 | PRJNA896554 | 155161 | 249 | 0.875 | 2.17875 | Leptolinea sp. | 2699749 | Bacteria | Bacteria | 77.4 | 1.72e-14 | NR | NLF50878.1 | 2699749 | g147621 | i0 | 41 | 1.98795180722892 | 83 | 46 | 100 | 1 | 249 | 1 | 230 | 309 | NLF50878.1 alpha/beta hydrolase [Leptolinea sp.] | diamond | 495 | 77.4 | 1 | Bacteria | Bacillati | Chloroflexota | Anaerolineae | Anaerolineales | Anaerolineaceae | Leptolinea | Leptolinea sp. | ||
| 27087349 | 27087349 | PRJNA896554_P_NODE_62882_length_511_cov_1.219178_g55351_i0 | PRJNA896554 | 62882 | 511 | 1.219178 | 6.22999958 | Chloroflexota bacterium | 2026724 | Bacteria | Bacteria | 84 | 1.53e-15 | NR | NOZ72577.1 | 2026724 | g55351 | i0 | 34.7 | 0.880626223091976 | 150 | 81 | 79.3 | 3 | 438 | 34 | 63 | 210 | NOZ72577.1 phosphate ABC transporter substrate-binding protein PstS [Chloroflexota bacterium] | diamond | 450 | 84 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 27372056 | 27372056 | PRJNA896554_P_NODE_139203_length_264_cov_1.209424_g131663_i0 | PRJNA896554 | 139203 | 264 | 1.209424 | 3.19287936 | Chloroflexota bacterium | 2026724 | Bacteria | Bacteria | 43.9 | 0.0179 | NR | MEM7344253.1 | 2026724 | g131663 | i0 | 33.9 | 0.704545454545455 | 62 | 38 | 70.5 | 1 | 209 | 24 | 203 | 261 | MEM7344253.1 tetratricopeptide repeat protein [Chloroflexota bacterium] | diamond | 186 | 43.9 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 27372070 | 27372070 | PRJNA896554_P_NODE_172523_length_242_cov_0.911243_g164983_i0 | PRJNA896554 | 172523 | 242 | 0.911243 | 2.20520806 | Anaerolineae bacterium | 2052143 | Bacteria | Bacteria | 92.4 | 3.26e-20 | NR | MBN8583441.1 | 2052143 | g164983 | i0 | 70.2 | 0.706611570247934 | 57 | 17 | 70.7 | 0 | 71 | 241 | 57 | 113 | MBN8583441.1 PAS domain S-box protein [Anaerolineae bacterium] | diamond | 171 | 92.4 | 1 | Bacteria | Bacillati | Chloroflexota | Anaerolineae | Anaerolineae bacterium | |||||
| 27442919 | 27442919 | PRJNA896554_P_NODE_98263_length_336_cov_2.456274_g90723_i0 | PRJNA896554 | 98263 | 336 | 2.456274 | 8.25308064 | Caldilinea | 233191 | Bacteria | Bacteria | 152 | 2.8299999999999993e-42 | NR | WP_374711254.1 | 2293560 | g90723 | i0 | 72 | 7.67857142857143 | 107 | 30 | 95.5 | 0 | 5 | 325 | 246 | 352 | WP_374711254.1 S-methyl-5-thioribose-1-phosphate isomerase [Caldilinea sp.] | diamond | 2580 | 153 | 0.993464052287582 | Bacteria | Bacillati | Chloroflexota | Caldilineae | Caldilineales | Caldilineaceae | Caldilinea | Caldilinea sp. | ||
| 27814029 | 27814029 | PRJNA896554_P_NODE_58924_length_549_cov_1.579832_g51416_i0 | PRJNA896554 | 58924 | 549 | 1.579832 | 8.67327768 | Chloroflexota bacterium | 2026724 | Bacteria | Bacteria | 47.8 | 0.00974 | NR | MEA1958187.1 | 2026724 | g51416 | i0 | 32.4 | 0.743169398907104 | 136 | 74 | 73.2 | 4 | 453 | 52 | 101 | 220 | MEA1958187.1 PKD domain-containing protein [Chloroflexota bacterium] | diamond | 408 | 47.8 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 28255696 | 28255696 | PRJNA896554_P_NODE_169586_length_243_cov_0.905882_g162046_i0 | PRJNA896554 | 169586 | 243 | 0.905882 | 2.20129326 | Chloroflexota bacterium | 2026724 | Bacteria | Bacteria | 105 | 6.09e-25 | NR | MDQ6671975.1 | 2026724 | g162046 | i0 | 70 | 0.987654320987654 | 80 | 24 | 98.8 | 0 | 3 | 242 | 7 | 86 | MDQ6671975.1 glycosyltransferase family 4 protein [Chloroflexota bacterium] | diamond | 240 | 105 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 28413797 | 28413797 | PRJNA896554_P_NODE_58826_length_550_cov_1.538784_g51318_i0 | PRJNA896554 | 58826 | 550 | 1.538784 | 8.463312 | Chloroflexota bacterium | 2026724 | Bacteria | Bacteria | 357 | 1.0299999999999999e-121 | NR | HXI15985.1 | 2026724 | g51318 | i0 | 100 | 0.992727272727273 | 182 | 0 | 99.3 | 0 | 4 | 549 | 32 | 213 | HXI15985.1 IS630 family transposase [Chloroflexota bacterium] | diamond | 546 | 357 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 28571470 | 28571470 | PRJNA896554_P_NODE_126007_length_282_cov_1.234450_g118467_i0 | PRJNA896554 | 126007 | 282 | 1.23445 | 3.481149 | Chloroflexota bacterium | 2026724 | Bacteria | Bacteria | 84 | 1.97e-16 | NR | MDQ6673652.1 | 2026724 | g118467 | i0 | 70.7 | 3.27659574468085 | 58 | 17 | 61.7 | 0 | 281 | 108 | 1318 | 1375 | MDQ6673652.1 SDR family NAD(P)-dependent oxidoreductase [Chloroflexota bacterium] | diamond | 924 | 84 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 28792386 | 28792386 | PRJNA896554_P_NODE_116507_length_297_cov_1.352679_g108967_i0 | PRJNA896554 | 116507 | 297 | 1.352679 | 4.01745663 | Chloroflexota bacterium | 2026724 | Bacteria | Bacteria | 159 | 6.419999999999998e-43 | NR | MDQ6673653.1 | 2026724 | g108967 | i0 | 73.7 | 1 | 99 | 26 | 100 | 0 | 297 | 1 | 881 | 979 | MDQ6673653.1 LLM class flavin-dependent oxidoreductase [Chloroflexota bacterium] | diamond | 297 | 159 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 28855538 | 28855538 | PRJNA896554_P_NODE_122188_length_288_cov_1.009302_g114648_i0 | PRJNA896554 | 122188 | 288 | 1.009302 | 2.90678976 | Chloroflexia bacterium | 2448782 | Bacteria | Bacteria | 87.8 | 1.3e-19 | NR | MEO5951389.1 | 2448782 | g114648 | i0 | 62.3 | 0.71875 | 69 | 26 | 71.9 | 0 | 63 | 269 | 2 | 70 | MEO5951389.1 hypothetical protein [Chloroflexia bacterium] | diamond | 207 | 87.8 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexia | Chloroflexia bacterium | |||||
| 28887182 | 28887182 | PRJNA896554_P_NODE_147968_length_253_cov_1.283333_g140428_i0 | PRJNA896554 | 147968 | 253 | 1.283333 | 3.24683249 | Anaerolineae bacterium | 2052143 | Bacteria | Bacteria | 59.7 | 2.21e-8 | NR | MBN1995587.1 | 2052143 | g140428 | i0 | 88.6 | 0.8300395256917 | 35 | 4 | 41.5 | 0 | 252 | 148 | 190 | 224 | MBN1995587.1 O-methyltransferase [Anaerolineae bacterium] | diamond | 210 | 59.7 | 1 | Bacteria | Bacillati | Chloroflexota | Anaerolineae | Anaerolineae bacterium | |||||
| 29140135 | 29140135 | PRJNA896554_P_NODE_171869_length_242_cov_0.911243_g164329_i0 | PRJNA896554 | 171869 | 242 | 0.911243 | 2.20520806 | Ktedonobacteraceae bacterium | 2740538 | Bacteria | Bacteria | 63.9 | 2.38e-10 | NR | HLG78514.1 | 2740538 | g164329 | i0 | 47.6 | 0.78099173553719 | 63 | 33 | 78.1 | 0 | 229 | 41 | 113 | 175 | HLG78514.1 PAS domain-containing protein [Ktedonobacteraceae bacterium] | diamond | 189 | 63.9 | 1 | Bacteria | Bacillati | Chloroflexota | Ktedonobacteria | Ktedonobacterales | Ktedonobacteraceae | Ktedonobacteraceae bacterium | |||
| 30024242 | 30024242 | PRJNA896554_P_NODE_129211_length_277_cov_1.524510_g121671_i0 | PRJNA896554 | 129211 | 277 | 1.52451 | 4.2228927 | Chloroflexota bacterium | 2026724 | Bacteria | Bacteria | 46.6 | 0.00245 | NR | MCL4541237.1 | 2026724 | g121671 | i0 | 46.7 | 0.649819494584838 | 60 | 29 | 61.7 | 1 | 187 | 17 | 354 | 413 | MCL4541237.1 NAD-dependent epimerase/dehydratase family protein [Chloroflexota bacterium] | diamond | 180 | 46.6 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 30181954 | 30181954 | PRJNA896554_P_NODE_171772_length_242_cov_0.911243_g164232_i0 | PRJNA896554 | 171772 | 242 | 0.911243 | 2.20520806 | Chloroflexia bacterium | 2448782 | Bacteria | Bacteria | 49.7 | 1.3e-4 | NR | HMA37095.1 | 2448782 | g164232 | i0 | 39.7 | 0.71900826446281 | 58 | 35 | 71.9 | 0 | 241 | 68 | 242 | 299 | HMA37095.1 hypothetical protein [Chloroflexia bacterium] | diamond | 174 | 49.7 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexia | Chloroflexia bacterium | |||||
| 30687470 | 30687470 | PRJNA896554_P_NODE_158453_length_248_cov_0.880000_g150913_i0 | PRJNA896554 | 158453 | 248 | 0.88 | 2.1824 | Candidatus Limnocylindrales bacterium | 2952938 | Bacteria | Bacteria | 171 | 1.6199999999999998e-48 | NR | HEY4190782.1 | 2952938 | g150913 | i0 | 96.3 | 0.991935483870968 | 82 | 3 | 99.2 | 0 | 247 | 2 | 315 | 396 | HEY4190782.1 DUF885 domain-containing protein [Candidatus Limnocylindrales bacterium] | diamond | 246 | 171 | 1 | Bacteria | Bacillati | Chloroflexota | Candidatus Limnocylindria | Candidatus Limnocylindrales | Candidatus Limnocylindrales bacterium | ||||
| 31105918 | 31105918 | PRJNA896554_P_NODE_64295_length_498_cov_4.458824_g56760_i0 | PRJNA896554 | 64295 | 498 | 4.458824 | 22.20494352 | Bacteria | 2 | Bacteria | Bacteria | 98.2 | 1.13e-23 | NR | MEO0563457.1 | 2026724 | g56760 | i0 | 73.8 | 2.67469879518072 | 61 | 16 | 36.7 | 0 | 129 | 311 | 3 | 63 | MEO0563457.1 cold-shock protein [Chloroflexota bacterium] | diamond | 1332 | 98.2 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 31414489 | 31414489 | PRJNA896554_P_NODE_127676_length_279_cov_2.334951_g120136_i0 | PRJNA896554 | 127676 | 279 | 2.334951 | 6.51451329 | Dehalococcoidia bacterium | 2026734 | Bacteria | Bacteria | 98.6 | 1.58e-24 | NR | HZQ34631.1 | 2026734 | g120136 | i0 | 69 | 2.74193548387097 | 71 | 16 | 69.9 | 2 | 5 | 199 | 29 | 99 | HZQ34631.1 hypothetical protein [Dehalococcoidia bacterium] | diamond | 765 | 98.6 | 1 | Bacteria | Bacillati | Chloroflexota | Dehalococcoidia | Dehalococcoidia bacterium | |||||
| 31541087 | 31541087 | PRJNA896554_P_NODE_101756_length_328_cov_0.905882_g94216_i0 | PRJNA896554 | 101756 | 328 | 0.905882 | 2.97129296 | Chloroflexia bacterium | 2448782 | Bacteria | Bacteria | 175 | 1.42e-50 | NR | HET6263190.1 | 2448782 | g94216 | i0 | 74.1 | 2.96341463414634 | 108 | 27 | 97.9 | 1 | 1 | 321 | 295 | 402 | HET6263190.1 FAD-dependent oxidoreductase [Chloroflexia bacterium] | diamond | 972 | 175 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexia | Chloroflexia bacterium | |||||
| 32078730 | 32078730 | PRJNA896554_P_NODE_116098_length_298_cov_1.026667_g108558_i0 | PRJNA896554 | 116098 | 298 | 1.026667 | 3.05946766 | Dehalococcoidales bacterium | 2026733 | Bacteria | Bacteria | 162 | 2.4599999999999993e-46 | NR | MDO9334216.1 | 2026733 | g108558 | i0 | 83.8 | 0.996644295302013 | 99 | 16 | 99.7 | 0 | 1 | 297 | 185 | 283 | MDO9334216.1 hypothetical protein [Dehalococcoidales bacterium] | diamond | 297 | 162 | 1 | Bacteria | Bacillati | Chloroflexota | Dehalococcoidia | Dehalococcoidales | Dehalococcoidales bacterium | ||||
| 32110467 | 32110467 | PRJNA896554_P_NODE_160138_length_247_cov_0.885057_g152598_i0 | PRJNA896554 | 160138 | 247 | 0.885057 | 2.18609079 | Chloroflexi bacterium ADurb.Bin18 | 1852857 | Bacteria | Bacteria | 50.8 | 5.77e-5 | NR | OQB28039.1 | 1852857 | g152598 | i0 | 64.9 | 0.449392712550607 | 37 | 13 | 44.9 | 0 | 119 | 229 | 2392 | 2428 | OQB28039.1 MAG: Serine-aspartate repeat-containing protein D precursor [Chloroflexi bacterium ADurb.Bin180] | diamond | 111 | 50.8 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexi bacterium ADurb.Bin180 | ||||||
| 32142127 | 32142127 | PRJNA896554_P_NODE_56038_length_583_cov_8.049020_g48554_i0 | PRJNA896554 | 56038 | 583 | 8.04902 | 46.9257866 | Anaerolineae bacterium | 2052143 | Bacteria | Bacteria | 80.9 | 7.27e-16 | NR | MCW5848612.1 | 2052143 | g48554 | i0 | 43.5 | 0.67409948542024 | 131 | 67 | 67.4 | 3 | 42 | 434 | 1 | 124 | MCW5848612.1 profilin [Anaerolineae bacterium] | diamond | 393 | 80.9 | 1 | Bacteria | Bacillati | Chloroflexota | Anaerolineae | Anaerolineae bacterium | |||||
| 32363783 | 32363783 | PRJNA896554_P_NODE_161559_length_246_cov_1.445087_g154019_i0 | PRJNA896554 | 161559 | 246 | 1.445087 | 3.55491402 | Caldilineaceae bacterium | 2614250 | Bacteria | Bacteria | 48.9 | 2.52e-4 | NR | MFN8441452.1 | 2614250 | g154019 | i0 | 37.3 | 0.719512195121951 | 59 | 36 | 70.7 | 1 | 59 | 232 | 459 | 517 | MFN8441452.1 hypothetical protein [Caldilineaceae bacterium] | diamond | 177 | 48.9 | 1 | Bacteria | Bacillati | Chloroflexota | Caldilineae | Caldilineales | Caldilineaceae | Caldilineaceae bacterium | |||
| 32458620 | 32458620 | PRJNA896554_P_NODE_110739_length_308_cov_1.170213_g103199_i0 | PRJNA896554 | 110739 | 308 | 1.170213 | 3.60425604 | Dehalococcoidales bacterium | 2026733 | Bacteria | Bacteria | 56.6 | 7.39e-7 | NR | MDO9332953.1 | 2026733 | g103199 | i0 | 35.3 | 0.662337662337662 | 68 | 44 | 66.2 | 0 | 300 | 97 | 194 | 261 | MDO9332953.1 hypothetical protein [Dehalococcoidales bacterium] | diamond | 204 | 56.6 | 1 | Bacteria | Bacillati | Chloroflexota | Dehalococcoidia | Dehalococcoidales | Dehalococcoidales 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);;