contig_metadata
28 rows where analysis = "diamond", bioproject = "PRJNA772154" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26736338 | 26736338 | PRJNA772154_P_NODE_20301_length_247_cov_0.896552_g20116_i0 | PRJNA772154 | 20301 | 247 | 0.896552 | 2.21448344 | Dehalococcoidia bacterium | 2026734 | Bacteria | Bacteria | 152 | 2.2199999999999998e-42 | NR | MCC6235947.1 | 2026734 | g20116 | i0 | 93.9 | 0.995951417004049 | 82 | 5 | 99.6 | 0 | 2 | 247 | 156 | 237 | MCC6235947.1 bifunctional glutamate N-acetyltransferase/amino-acid acetyltransferase ArgJ [Dehalococcoidia bacterium] | diamond | 246 | 152 | 1 | Bacteria | Bacillati | Chloroflexota | Dehalococcoidia | Dehalococcoidia bacterium | |||||
| 26831840 | 26831840 | PRJNA772154_P_NODE_18061_length_252_cov_0.871508_g17876_i0 | PRJNA772154 | 18061 | 252 | 0.871508 | 2.19620016 | Candidatus Amarobacillus elongatus | 3140700 | Bacteria | Bacteria | 64.3 | 9.26e-10 | NR | MBK6661519.1 | 3140700 | g17876 | i0 | 94.6 | 0.880952380952381 | 74 | 4 | 88.1 | 0 | 1 | 222 | 211 | 284 | MBK6661519.1 hypothetical protein [Candidatus Amarobacillus elongatus] | diamond | 222 | 64.3 | 1 | Bacteria | Bacillati | Chloroflexota | Tepidiformia | Tepidiformales | Tepidiformaceae | Candidatus Amarobacillus | Candidatus Amarobacillus elongatus | ||
| 27053368 | 27053368 | PRJNA772154_P_NODE_20302_length_247_cov_0.896552_g20117_i0 | PRJNA772154 | 20302 | 247 | 0.896552 | 2.21448344 | Candidatus Limnocylindrales bacterium | 2952938 | Bacteria | Bacteria | 69.3 | 1.29e-11 | NR | HEU5205034.1 | 2952938 | g20117 | i0 | 66.7 | 1.10526315789474 | 42 | 14 | 51 | 0 | 141 | 16 | 23 | 64 | HEU5205034.1 deoxyribodipyrimidine photo-lyase [Candidatus Limnocylindrales bacterium] | diamond | 273 | 69.3 | 1 | Bacteria | Bacillati | Chloroflexota | Candidatus Limnocylindria | Candidatus Limnocylindrales | Candidatus Limnocylindrales bacterium | ||||
| 27874530 | 27874530 | PRJNA772154_P_NODE_18605_length_251_cov_0.876404_g18420_i0 | PRJNA772154 | 18605 | 251 | 0.876404 | 2.19977404 | Chloroflexota bacterium | 2026724 | Bacteria | Bacteria | 142 | 5.269999999999999e-37 | NR | MEZ4513863.1 | 2026724 | g18420 | i0 | 79.5 | 0.99203187250996006 | 83 | 16 | 98 | 1 | 3 | 248 | 2800 | 2882 | MEZ4513863.1 FtsK/SpoIIIE domain-containing protein [Chloroflexota bacterium] | diamond | 249 | 142 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 28600886 | 28600886 | PRJNA772154_P_NODE_21287_length_245_cov_0.906977_g21102_i0 | PRJNA772154 | 21287 | 245 | 0.906977 | 2.22209365 | Caldilineaceae bacterium | 2614250 | Bacteria | Bacteria | 137 | 3.28e-36 | NR | MEZ4727654.1 | 2614250 | g21102 | i0 | 83.1 | 1.91020408163265 | 77 | 13 | 94.3 | 0 | 233 | 3 | 321 | 397 | MEZ4727654.1 sulfatase-like hydrolase/transferase [Caldilineaceae bacterium] | diamond | 468 | 137 | 1 | Bacteria | Bacillati | Chloroflexota | Caldilineae | Caldilineales | Caldilineaceae | Caldilineaceae bacterium | |||
| 28790100 | 28790100 | PRJNA772154_P_NODE_14507_length_286_cov_1.291080_g14322_i0 | PRJNA772154 | 14507 | 286 | 1.29108 | 3.6924888 | Anaerolineales bacterium | 2073117 | Bacteria | Bacteria | 156 | 4.87e-45 | NR | MCB0037718.1 | 2073117 | g14322 | i0 | 85.7 | 0.954545454545455 | 91 | 13 | 95.5 | 0 | 285 | 13 | 186 | 276 | MCB0037718.1 aminotransferase class IV [Anaerolineales bacterium] | diamond | 273 | 156 | 1 | Bacteria | Bacillati | Chloroflexota | Anaerolineae | Anaerolineales | Anaerolineales bacterium | ||||
| 28916276 | 28916276 | PRJNA772154_P_NODE_20088_length_248_cov_0.891429_g19903_i0 | PRJNA772154 | 20088 | 248 | 0.891429 | 2.21074392 | Anaerolineae bacterium | 2052143 | Bacteria | Bacteria | 45.1 | 0.00597 | NR | MCB0195277.1 | 2052143 | g19903 | i0 | 39 | 1.42741935483871 | 59 | 35 | 70.2 | 1 | 75 | 248 | 403 | 461 | MCB0195277.1 mechanosensitive ion channel family protein [Anaerolineae bacterium] | diamond | 354 | 45.1 | 1 | Bacteria | Bacillati | Chloroflexota | Anaerolineae | Anaerolineae bacterium | |||||
| 29011580 | 29011580 | PRJNA772154_P_NODE_18028_length_252_cov_0.871508_g17843_i0 | PRJNA772154 | 18028 | 252 | 0.871508 | 2.19620016 | Promineifilum sp. | 2664178 | Bacteria | Bacteria | 150 | 5.629999999999999e-45 | NR | HRN68645.1 | 2664178 | g17843 | i0 | 98.7 | 0.904761904761905 | 76 | 1 | 90.5 | 0 | 229 | 2 | 1 | 76 | HRN68645.1 hypothetical protein [Promineifilum sp.] | diamond | 228 | 150 | 1 | Bacteria | Bacillati | Chloroflexota | Ardenticatenia | Candidatus Promineifilales | Candidatus Promineifilaceae | Candidatus Promineifilum | Promineifilum sp. | ||
| 29115604 | 29115604 | PRJNA772154_P_NODE_18908_length_250_cov_0.881356_g18723_i0 | PRJNA772154 | 18908 | 250 | 0.881356 | 2.20339 | Candidatus Trichofilum | 3140595 | Bacteria | Bacteria | 127 | 9.98e-33 | NR | MEI2610240.1 | 3085104 | g18723 | i0 | 80.2 | 1.944 | 81 | 16 | 97.2 | 0 | 249 | 7 | 258 | 338 | MEI2610240.1 hypothetical protein [Candidatus Promineifilaceae bacterium] | diamond | 486 | 127 | 1 | Bacteria | Bacillati | Chloroflexota | Ardenticatenia | Candidatus Promineifilales | Candidatus Promineifilaceae | Candidatus Promineifilaceae bacterium | |||
| 29304866 | 29304866 | PRJNA772154_P_NODE_19049_length_250_cov_0.881356_g18864_i0 | PRJNA772154 | 19049 | 250 | 0.881356 | 2.20339 | Candidatus Hadersleviella | 3140594 | Bacteria | Bacteria | 136 | 1.09e-35 | NR | MCP4417234.1 | 2026724 | g18864 | i0 | 78 | 6.108 | 91 | 12 | 99.6 | 1 | 2 | 250 | 246 | 336 | MCP4417234.1 PAS domain S-box protein [Chloroflexota bacterium] | diamond | 1527 | 136 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 29358612 | 29358612 | PRJNA772154_P_NODE_19889_length_248_cov_0.891429_g19704_i0 | PRJNA772154 | 19889 | 248 | 0.891429 | 2.21074392 | Ktedonobacteraceae bacterium | 2740538 | Bacteria | Bacteria | 63.2 | 2.46e-9 | NR | HEV2663080.1 | 2740538 | g19704 | i0 | 45.7 | 0.979838709677419 | 81 | 44 | 98 | 0 | 247 | 5 | 11 | 91 | HEV2663080.1 ATP-binding protein [Ktedonobacteraceae bacterium] | diamond | 243 | 63.2 | 1 | Bacteria | Bacillati | Chloroflexota | Ktedonobacteria | Ktedonobacterales | Ktedonobacteraceae | Ktedonobacteraceae bacterium | |||
| 29390262 | 29390262 | PRJNA772154_P_NODE_18569_length_251_cov_0.876404_g18384_i0 | PRJNA772154 | 18569 | 251 | 0.876404 | 2.19977404 | Caldilineaceae bacterium | 2614250 | Bacteria | Bacteria | 140 | 3.62e-38 | NR | HRW07865.1 | 2614250 | g18384 | i0 | 79.5 | 1.9840637450199201 | 83 | 17 | 99.2 | 0 | 2 | 250 | 141 | 223 | HRW07865.1 sulfite oxidase [Caldilineaceae bacterium] | diamond | 498 | 140 | 1 | Bacteria | Bacillati | Chloroflexota | Caldilineae | Caldilineales | Caldilineaceae | Caldilineaceae bacterium | |||
| 29494407 | 29494407 | PRJNA772154_P_NODE_20850_length_246_cov_0.901734_g20665_i0 | PRJNA772154 | 20850 | 246 | 0.901734 | 2.21826564 | Chloroflexota | 200795 | Bacteria | Bacteria | 116 | 2.8699999999999997e-31 | NR | HZA22594.1 | 2026734 | g20665 | i0 | 73.8 | 1.96341463414634 | 80 | 21 | 97.6 | 0 | 3 | 242 | 21 | 100 | HZA22594.1 integrase core domain-containing protein [Dehalococcoidia bacterium] | diamond | 483 | 117 | 0.991452991452991 | Bacteria | Bacillati | Chloroflexota | Dehalococcoidia | Dehalococcoidia bacterium | |||||
| 29673969 | 29673969 | PRJNA772154_P_NODE_21530_length_245_cov_0.866279_g21345_i0 | PRJNA772154 | 21530 | 245 | 0.866279 | 2.12238355 | Chloroflexota bacterium | 2026724 | Bacteria | Bacteria | 84.3 | 6.71e-17 | NR | MEM7343728.1 | 2026724 | g21345 | i0 | 58.4 | 1.93469387755102 | 77 | 32 | 94.3 | 0 | 2 | 232 | 330 | 406 | MEM7343728.1 phage portal protein [Chloroflexota bacterium] | diamond | 474 | 84.3 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 29778476 | 29778476 | PRJNA772154_P_NODE_18471_length_251_cov_0.876404_g18286_i0 | PRJNA772154 | 18471 | 251 | 0.876404 | 2.19977404 | Bacteria | 2 | Bacteria | Bacteria | 101 | 1.19e-23 | NR | MCY3945410.1 | 2024896 | g18286 | i0 | 66.3 | 6.94422310756972 | 83 | 28 | 99.2 | 0 | 2 | 250 | 99 | 181 | MCY3945410.1 ABC transporter permease [Anaerolineaceae bacterium] | diamond | 1743 | 102 | 0.990196078431373 | Bacteria | Bacillati | Chloroflexota | Anaerolineae | Anaerolineales | Anaerolineaceae | Anaerolineaceae bacterium | |||
| 29800495 | 29800495 | PRJNA772154_P_NODE_21651_length_244_cov_0.912281_g21466_i0 | PRJNA772154 | 21651 | 244 | 0.912281 | 2.22596564 | Caldilineaceae bacterium | 2614250 | Bacteria | Bacteria | 141 | 1.26e-37 | NR | MCB0189527.1 | 2614250 | g21466 | i0 | 88.9 | 1.99180327868852 | 81 | 9 | 99.6 | 0 | 244 | 2 | 363 | 443 | MCB0189527.1 ABC transporter ATP-binding protein [Caldilineaceae bacterium] | diamond | 486 | 141 | 1 | Bacteria | Bacillati | Chloroflexota | Caldilineae | Caldilineales | Caldilineaceae | Caldilineaceae bacterium | |||
| 29927090 | 29927090 | PRJNA772154_P_NODE_19811_length_248_cov_0.891429_g19626_i0 | PRJNA772154 | 19811 | 248 | 0.891429 | 2.21074392 | Chloroflexota bacterium | 2026724 | Bacteria | Bacteria | 152 | 4.43e-44 | NR | MBM4411267.1 | 2026724 | g19626 | i0 | 97.6 | 0.991935483870968 | 82 | 2 | 99.2 | 0 | 3 | 248 | 81 | 162 | MBM4411267.1 hypothetical protein [Chloroflexota bacterium] | diamond | 246 | 152 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 29958472 | 29958472 | PRJNA772154_P_NODE_21051_length_246_cov_0.901734_g20866_i0 | PRJNA772154 | 21051 | 246 | 0.901734 | 2.21826564 | Caldilineaceae bacterium | 2614250 | Bacteria | Bacteria | 143 | 8.899999999999999e-38 | NR | MEZ4737303.1 | 2614250 | g20866 | i0 | 90.1 | 0.98780487804878 | 81 | 8 | 98.8 | 0 | 244 | 2 | 138 | 218 | MEZ4737303.1 hypothetical protein [Caldilineaceae bacterium] | diamond | 243 | 143 | 1 | Bacteria | Bacillati | Chloroflexota | Caldilineae | Caldilineales | Caldilineaceae | Caldilineaceae bacterium | |||
| 30685082 | 30685082 | PRJNA772154_P_NODE_18213_length_252_cov_0.871508_g18028_i0 | PRJNA772154 | 18213 | 252 | 0.871508 | 2.19620016 | Thermoflexales bacterium | 2497639 | Bacteria | Bacteria | 177 | 6.1299999999999984e-55 | NR | MBP7599860.1 | 2497639 | g18028 | i0 | 96.4 | 1 | 84 | 3 | 100 | 0 | 1 | 252 | 30 | 113 | MBP7599860.1 DinB family protein [Thermoflexales bacterium] | diamond | 252 | 177 | 1 | Bacteria | Bacillati | Chloroflexota | Thermoflexia | Thermoflexales | Thermoflexales bacterium | ||||
| 30748431 | 30748431 | PRJNA772154_P_NODE_17814_length_253_cov_0.866667_g17629_i0 | PRJNA772154 | 17814 | 253 | 0.866667 | 2.19266751 | Chloroflexota bacterium | 2026724 | Bacteria | Bacteria | 166 | 7e-46 | NR | MEZ4514986.1 | 2026724 | g17629 | i0 | 95.2 | 1.99209486166008 | 84 | 4 | 99.6 | 0 | 253 | 2 | 517 | 600 | MEZ4514986.1 alkaline phosphatase D family protein [Chloroflexota bacterium] | diamond | 504 | 166 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 30906572 | 30906572 | PRJNA772154_P_NODE_17394_length_254_cov_0.861878_g17209_i0 | PRJNA772154 | 17394 | 254 | 0.861878 | 2.18917012 | Chloroflexota bacterium | 2026724 | Bacteria | Bacteria | 114 | 1.25e-30 | NR | RIK33469.1 | 2026724 | g17209 | i0 | 79.1 | 0.791338582677165 | 67 | 14 | 79.1 | 0 | 253 | 53 | 42 | 108 | RIK33469.1 MAG: hypothetical protein DCC55_34875 [Chloroflexota bacterium] | diamond | 201 | 114 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 31158792 | 31158792 | PRJNA772154_P_NODE_19155_length_250_cov_0.881356_g18970_i0 | PRJNA772154 | 19155 | 250 | 0.881356 | 2.20339 | Anaerolineales bacterium | 2073117 | Bacteria | Bacteria | 127 | 6.699999999999999e-32 | NR | MCB0032475.1 | 2073117 | g18970 | i0 | 80.5 | 0.984 | 82 | 16 | 98.4 | 0 | 3 | 248 | 218 | 299 | MCB0032475.1 AAA family ATPase [Anaerolineales bacterium] | diamond | 246 | 127 | 1 | Bacteria | Bacillati | Chloroflexota | Anaerolineae | Anaerolineales | Anaerolineales bacterium | ||||
| 31823162 | 31823162 | PRJNA772154_P_NODE_18597_length_251_cov_0.876404_g18412_i0 | PRJNA772154 | 18597 | 251 | 0.876404 | 2.19977404 | Anaerolineae bacterium | 2052143 | Bacteria | Bacteria | 75.1 | 1.73e-14 | NR | MCC6603897.1 | 2052143 | g18412 | i0 | 56.5 | 0.824701195219124 | 69 | 30 | 82.5 | 0 | 2 | 208 | 104 | 172 | MCC6603897.1 purine-binding chemotaxis protein CheW [Anaerolineae bacterium] | diamond | 207 | 75.1 | 1 | Bacteria | Bacillati | Chloroflexota | Anaerolineae | Anaerolineae bacterium | |||||
| 31990967 | 31990967 | PRJNA772154_P_NODE_22778_length_242_cov_0.923077_g22593_i0 | PRJNA772154 | 22778 | 242 | 0.923077 | 2.23384634 | Bacteria | 2 | Bacteria | Bacteria | 140 | 5.21e-37 | NR | MCB9456520.1 | 2024896 | g22593 | i0 | 85 | 1.98347107438017 | 80 | 12 | 99.2 | 0 | 240 | 1 | 414 | 493 | MCB9456520.1 ABC transporter ATP-binding protein [Anaerolineaceae bacterium] | diamond | 480 | 140 | 1 | Bacteria | Bacillati | Chloroflexota | Anaerolineae | Anaerolineales | Anaerolineaceae | Anaerolineaceae bacterium | |||
| 32108041 | 32108041 | PRJNA772154_P_NODE_19458_length_249_cov_0.886364_g19273_i0 | PRJNA772154 | 19458 | 249 | 0.886364 | 2.20704636 | Caldilineaceae bacterium | 2614250 | Bacteria | Bacteria | 131 | 3.3899999999999995e-35 | NR | MFN8465676.1 | 2614250 | g19273 | i0 | 74.4 | 0.987951807228916 | 82 | 21 | 98.8 | 0 | 4 | 249 | 46 | 127 | MFN8465676.1 ROK family protein [Caldilineaceae bacterium] | diamond | 246 | 131 | 1 | Bacteria | Bacillati | Chloroflexota | Caldilineae | Caldilineales | Caldilineaceae | Caldilineaceae bacterium | |||
| 32329872 | 32329872 | PRJNA772154_P_NODE_20059_length_248_cov_0.891429_g19874_i0 | PRJNA772154 | 20059 | 248 | 0.891429 | 2.21074392 | Chloroflexota bacterium | 2026724 | Bacteria | Bacteria | 132 | 6.37e-35 | NR | MFN8622710.1 | 2026724 | g19874 | i0 | 81.5 | 0.979838709677419 | 81 | 15 | 98 | 0 | 6 | 248 | 289 | 369 | MFN8622710.1 ABC transporter substrate-binding protein [Chloroflexota bacterium] | diamond | 243 | 132 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 32456318 | 32456318 | PRJNA772154_P_NODE_21499_length_245_cov_0.906977_g21314_i0 | PRJNA772154 | 21499 | 245 | 0.906977 | 2.22209365 | Chloroflexi bacterium TSY | 2834438 | Bacteria | Bacteria | 61.2 | 1.17e-8 | NR | MBV7334334.1 | 2834438 | g21314 | i0 | 46.3 | 0.979591836734694 | 80 | 42 | 96.7 | 1 | 244 | 8 | 701 | 780 | MBV7334334.1 tetratricopeptide repeat protein [Chloroflexi bacterium TSY] | diamond | 240 | 61.2 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexi bacterium TSY | ||||||
| 32834421 | 32834421 | PRJNA772154_P_NODE_18180_length_252_cov_0.871508_g17995_i0 | PRJNA772154 | 18180 | 252 | 0.871508 | 2.19620016 | Anaerolineales bacterium | 2073117 | Bacteria | Bacteria | 149 | 3.09e-41 | NR | MCA9981689.1 | 2073117 | g17995 | i0 | 84.1 | 0.976190476190476 | 82 | 13 | 97.6 | 0 | 5 | 250 | 256 | 337 | MCA9981689.1 hypothetical protein [Anaerolineales bacterium] | diamond | 246 | 149 | 1 | Bacteria | Bacillati | Chloroflexota | Anaerolineae | Anaerolineales | Anaerolineales 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);;