contig_metadata
21 rows where bioproject = "PRJNA1158727", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4130132 | 4130132 | PRJNA1158727_P_NODE_107164_length_283_cov_1.347619_g99703_i0 | PRJNA1158727 | 107164 | 283 | 1.347619 | 3.81376177 | Bacteria | 2 | Bacteria | Bacteria | 193 | 5.55e-58 | NR | NOH02334.1 | 2026724 | g99703 | i0 | 97.8 | 2.88339222614841 | 91 | 2 | 96.5 | 0 | 274 | 2 | 193 | 283 | NOH02334.1 Fe-S cluster assembly protein SufD [Chloroflexota bacterium] | diamond | 816 | 193 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 7956520 | 7956520 | PRJNA1158727_P_NODE_114507_length_274_cov_1.174129_g107046_i0 | PRJNA1158727 | 114507 | 274 | 1.174129 | 3.21711346 | Tepidiforma flava | 3004094 | Bacteria | Bacteria | 178 | 3.98e-40 | NTclustered | gi|2421951025|gb|CP115149.1| | 3004094 | g107046 | i0 | 81.25 | 13.4233576642336 | 224 | 38 | 81 | 4 | 1 | 222 | 1722960 | 1723181 | Tepidiforma flava strain YIM 72310 chromosome, complete genome | blastn | 3678 | 178 | 1 | Bacteria | Bacillati | Chloroflexota | Tepidiformia | Tepidiformales | Tepidiformaceae | Tepidiforma | Tepidiforma flava | ||
| 21980941 | 21980941 | PRJNA1158727_P_NODE_149038_length_246_cov_0.890173_g141576_i0 | PRJNA1158727 | 149038 | 246 | 0.890173 | 2.18982558 | Chloroflexia bacterium | 2448782 | Bacteria | Bacteria | 141 | 2.16e-38 | NR | MBA2247881.1 | 2448782 | g141576 | i0 | 86.6 | 3 | 82 | 11 | 100 | 0 | 246 | 1 | 232 | 313 | MBA2247881.1 aspartate aminotransferase family protein [Chloroflexia bacterium] | diamond | 738 | 141 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexia | Chloroflexia bacterium | |||||
| 27249338 | 27249338 | PRJNA1158727_P_NODE_78863_length_343_cov_1.140741_g71402_i0 | PRJNA1158727 | 78863 | 343 | 1.140741 | 3.91274163 | Bacillati | 1783272 | Bacteria | Bacteria | 163 | 1.23e-45 | NR | HAJ35901.1 | 2026724 | g71402 | i0 | 67.6 | 4.84548104956268 | 111 | 36 | 97.1 | 0 | 342 | 10 | 338 | 448 | HAJ35901.1 aspartate aminotransferase family protein [Chloroflexota bacterium] | diamond | 1662 | 163 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 27356567 | 27356567 | PRJNA1158727_P_NODE_125663_length_261_cov_1.265957_g118202_i0 | PRJNA1158727 | 125663 | 261 | 1.265957 | 3.30414777 | Chloroflexota bacterium | 2026724 | Bacteria | Bacteria | 44.7 | 0.00972 | NR | HHS97230.1 | 2026724 | g118202 | i0 | 37 | 1.67816091954023 | 73 | 32 | 74.7 | 4 | 233 | 39 | 198 | 264 | HHS97230.1 DUF2723 domain-containing protein [Chloroflexota bacterium] | diamond | 438 | 44.7 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 27376083 | 27376083 | PRJNA1158727_P_NODE_133383_length_252_cov_1.888268_g125922_i0 | PRJNA1158727 | 133383 | 252 | 1.888268 | 4.75843536 | Bacillati | 1783272 | Bacteria | Bacteria | 140 | 9.22e-37 | NR | MDF2733594.1 | 2026724 | g125922 | i0 | 82.1 | 3 | 84 | 15 | 100 | 0 | 1 | 252 | 236 | 319 | MDF2733594.1 diguanylate cyclase with sensor [Chloroflexota bacterium] | diamond | 756 | 140 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 27482771 | 27482771 | PRJNA1158727_P_NODE_161723_length_241_cov_1.833333_g154261_i0 | PRJNA1158727 | 161723 | 241 | 1.833333 | 4.41833253 | Dehalococcoidia bacterium | 2026734 | Bacteria | Bacteria | 48.1 | 4.61e-4 | NR | HEY55058.1 | 2026734 | g154261 | i0 | 37.2 | 1.94190871369295 | 78 | 46 | 97.1 | 1 | 234 | 1 | 619 | 693 | HEY55058.1 DEAD/DEAH box helicase [Dehalococcoidia bacterium] | diamond | 468 | 48.1 | 1 | Bacteria | Bacillati | Chloroflexota | Dehalococcoidia | Dehalococcoidia bacterium | |||||
| 27754929 | 27754929 | PRJNA1158727_P_NODE_118484_length_269_cov_1.515306_g111023_i0 | PRJNA1158727 | 118484 | 269 | 1.515306 | 4.07617314 | PVC group | 1783257 | Bacteria | Bacteria | 134 | 3.11e-35 | NR | TME48835.1 | 2026724 | g111023 | i0 | 77 | 1.92936802973978 | 87 | 20 | 97 | 0 | 9 | 269 | 116 | 202 | TME48835.1 MAG: IS110 family transposase [Chloroflexota bacterium] | diamond | 519 | 134 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 28303663 | 28303663 | PRJNA1158727_P_NODE_122006_length_265_cov_1.343750_g114545_i0 | PRJNA1158727 | 122006 | 265 | 1.34375 | 3.5609375 | Chloroflexi bacterium TSY | 2834438 | Bacteria | Bacteria | 42.7 | 0.0494 | NR | MBV7336359.1 | 2834438 | g114545 | i0 | 28.4 | 0.916981132075472 | 81 | 58 | 91.7 | 0 | 23 | 265 | 346 | 426 | MBV7336359.1 PAS domain S-box protein [Chloroflexi bacterium TSY] | diamond | 243 | 42.7 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexi bacterium TSY | ||||||
| 28935225 | 28935225 | PRJNA1158727_P_NODE_162868_length_241_cov_0.916667_g155406_i0 | PRJNA1158727 | 162868 | 241 | 0.916667 | 2.20916747 | Chloroflexota bacterium | 2026724 | Bacteria | Bacteria | 65.5 | 6.63e-11 | NR | MEP7285939.1 | 2026724 | g155406 | i0 | 75 | 1.10788381742739 | 44 | 11 | 54.8 | 0 | 239 | 108 | 140 | 183 | MEP7285939.1 30S ribosomal protein S5 [Chloroflexota bacterium] | diamond | 267 | 65.5 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 30198101 | 30198101 | PRJNA1158727_P_NODE_158032_length_243_cov_0.905882_g150570_i0 | PRJNA1158727 | 158032 | 243 | 0.905882 | 2.20129326 | Dehalococcoidia bacterium | 2026734 | Bacteria | Bacteria | 121 | 4.69e-33 | NR | MFQ5472699.1 | 2026734 | g150570 | i0 | 69.1 | 3 | 81 | 25 | 100 | 0 | 1 | 243 | 24 | 104 | MFQ5472699.1 enoyl-CoA hydratase/isomerase family protein [Dehalococcoidia bacterium] | diamond | 729 | 121 | 1 | Bacteria | Bacillati | Chloroflexota | Dehalococcoidia | Dehalococcoidia bacterium | |||||
| 30229898 | 30229898 | PRJNA1158727_P_NODE_106932_length_283_cov_1.466667_g99471_i0 | PRJNA1158727 | 106932 | 283 | 1.466667 | 4.15066761 | Chloroflexales bacterium | 2725990 | Bacteria | Bacteria | 122 | 3.36e-30 | NR | NTU77786.1 | 2725990 | g99471 | i0 | 66.7 | 0.985865724381625 | 93 | 28 | 98.6 | 2 | 281 | 3 | 103 | 192 | NTU77786.1 hypothetical protein [Chloroflexales bacterium] | diamond | 279 | 122 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexia | Chloroflexales | Chloroflexales bacterium | ||||
| 30325268 | 30325268 | PRJNA1158727_P_NODE_161472_length_241_cov_2.315476_g154010_i0 | PRJNA1158727 | 161472 | 241 | 2.315476 | 5.58029716 | Candidatus Villigracilis affinis | 3140682 | Bacteria | Bacteria | 169 | 1.54e-46 | NR | WP_345300323.1 | 3140682 | g154010 | i0 | 95 | 4.9792531120332 | 80 | 4 | 99.6 | 0 | 240 | 1 | 263 | 342 | WP_345300323.1 excinuclease ABC subunit UvrA [Candidatus Villigracilis affinis] | diamond | 1200 | 169 | 1 | Bacteria | Bacillati | Chloroflexota | Anaerolineae | Anaerolineales | Candidatus Villigracilaceae | Candidatus Villigracilis | Candidatus Villigracilis affinis | ||
| 30388317 | 30388317 | PRJNA1158727_P_NODE_133653_length_252_cov_1.631285_g126192_i0 | PRJNA1158727 | 133653 | 252 | 1.631285 | 4.1108382 | Anaerolineae bacterium | 2052143 | Bacteria | Bacteria | 69.3 | 1.79e-11 | NR | MBL8162699.1 | 2052143 | g126192 | i0 | 39.8 | 2.96428571428571 | 83 | 50 | 98.8 | 0 | 252 | 4 | 61 | 143 | MBL8162699.1 FAD-dependent monooxygenase [Anaerolineae bacterium] | diamond | 747 | 69.3 | 1 | Bacteria | Bacillati | Chloroflexota | Anaerolineae | Anaerolineae bacterium | |||||
| 30419810 | 30419810 | PRJNA1158727_P_NODE_112733_length_276_cov_1.423645_g105272_i0 | PRJNA1158727 | 112733 | 276 | 1.423645 | 3.9292602 | Chloroflexota bacterium | 2026724 | Bacteria | Bacteria | 102 | 1.68e-25 | NR | MEZ4515128.1 | 2026724 | g105272 | i0 | 60.2 | 0.956521739130435 | 88 | 34 | 94.6 | 1 | 261 | 1 | 1 | 88 | MEZ4515128.1 coactosin family protein [Chloroflexota bacterium] | diamond | 264 | 102 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 31462641 | 31462641 | PRJNA1158727_P_NODE_152176_length_245_cov_0.895349_g144714_i0 | PRJNA1158727 | 152176 | 245 | 0.895349 | 2.19360505 | Anaerolineae bacterium | 2052143 | Bacteria | Bacteria | 105 | 1.5499999999999998e-24 | NR | MBC7223209.1 | 2052143 | g144714 | i0 | 58 | 8.57142857142857 | 81 | 33 | 99.2 | 1 | 3 | 245 | 260 | 339 | MBC7223209.1 aminotransferase class III-fold pyridoxal phosphate-dependent enzyme [Anaerolineae bacterium] | diamond | 2100 | 105 | 1 | Bacteria | Bacillati | Chloroflexota | Anaerolineae | Anaerolineae bacterium | |||||
| 31525791 | 31525791 | PRJNA1158727_P_NODE_141356_length_249_cov_0.875000_g133894_i0 | PRJNA1158727 | 141356 | 249 | 0.875 | 2.17875 | Chloroflexota bacterium | 2026724 | Bacteria | Bacteria | 119 | 3e-29 | NR | MBI5825396.1 | 2026724 | g133894 | i0 | 81.3 | 0.903614457831325 | 75 | 14 | 90.4 | 0 | 226 | 2 | 279 | 353 | MBI5825396.1 hypothetical protein [Chloroflexota bacterium] | diamond | 225 | 119 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 31620528 | 31620528 | PRJNA1158727_P_NODE_148616_length_246_cov_0.890173_g141154_i0 | PRJNA1158727 | 148616 | 246 | 0.890173 | 2.18982558 | Caldilineaceae bacterium | 2614250 | Bacteria | Bacteria | 114 | 1.42e-28 | NR | MCB0105376.1 | 2614250 | g141154 | i0 | 61.3 | 0.975609756097561 | 80 | 31 | 97.6 | 0 | 5 | 244 | 13 | 92 | MCB0105376.1 zinc-binding alcohol dehydrogenase family protein [Caldilineaceae bacterium] | diamond | 240 | 114 | 1 | Bacteria | Bacillati | Chloroflexota | Caldilineae | Caldilineales | Caldilineaceae | Caldilineaceae bacterium | |||
| 31652010 | 31652010 | PRJNA1158727_P_NODE_157577_length_243_cov_0.905882_g150115_i0 | PRJNA1158727 | 157577 | 243 | 0.905882 | 2.20129326 | Ktedonobacterales bacterium | 2306968 | Bacteria | Bacteria | 51.2 | 3.75e-5 | NR | HEX6817761.1 | 2306968 | g150115 | i0 | 46.2 | 0.802469135802469 | 65 | 35 | 80.2 | 0 | 197 | 3 | 527 | 591 | HEX6817761.1 DUF5915 domain-containing protein [Ktedonobacterales bacterium] | diamond | 195 | 51.2 | 1 | Bacteria | Bacillati | Chloroflexota | Ktedonobacteria | Ktedonobacterales | Ktedonobacterales bacterium | ||||
| 32253585 | 32253585 | PRJNA1158727_P_NODE_101598_length_290_cov_1.419355_g94137_i0 | PRJNA1158727 | 101598 | 290 | 1.419355 | 4.1161295 | Chloroflexota bacterium | 2026724 | Bacteria | Bacteria | 127 | 4.98e-33 | NR | MFO7320964.1 | 2026724 | g94137 | i0 | 62.6 | 2.05862068965517 | 99 | 34 | 99.3 | 1 | 289 | 2 | 16 | 114 | MFO7320964.1 GNAT family N-acetyltransferase [Chloroflexota bacterium] | diamond | 597 | 127 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 32538262 | 32538262 | PRJNA1158727_P_NODE_132619_length_253_cov_1.711111_g125158_i0 | PRJNA1158727 | 132619 | 253 | 1.711111 | 4.32911083 | Chloroflexota bacterium | 2026724 | Bacteria | Bacteria | 44.3 | 0.0119 | NR | MEP7291060.1 | 2026724 | g125158 | i0 | 61.8 | 0.403162055335968 | 34 | 13 | 40.3 | 0 | 102 | 1 | 1 | 34 | MEP7291060.1 ATP-binding protein [Chloroflexota bacterium] | diamond | 102 | 44.3 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexota 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);;