contig_metadata
21 rows where bioproject = "PRJNA1156092", tax_phylum = "Chloroflexota" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 15605698 | 15605698 | PRJNA1156092_P_NODE_28753_length_245_cov_0.883721_g28623_i0 | PRJNA1156092 | 28753 | 245 | 0.883721 | 2.16511645 | Bacteria candidate phyla | 1783234 | Bacteria | Bacteria | 104 | 2.33e-24 | NR | TET96929.1 | 2026734 | g28623 | i0 | 56.3 | 5.88979591836735 | 80 | 35 | 98 | 0 | 4 | 243 | 226 | 305 | TET96929.1 MAG: anaerobic glycerol-3-phosphate dehydrogenase subunit C [Dehalococcoidia bacterium] | diamond | 1443 | 104 | 1 | Bacteria | Bacillati | Chloroflexota | Dehalococcoidia | Dehalococcoidia bacterium | |||||
| 22714193 | 22714193 | PRJNA1156092_P_NODE_29098_length_244_cov_0.900585_g28968_i0 | PRJNA1156092 | 29098 | 244 | 0.900585 | 2.1974274 | Chloroflexota bacterium | 2026724 | Bacteria | Bacteria | 140 | 1.32e-37 | NR | MBT3363552.1 | 2026724 | g28968 | i0 | 90.1 | 0.995901639344262 | 81 | 8 | 99.6 | 0 | 2 | 244 | 225 | 305 | MBT3363552.1 acetyl-CoA C-acetyltransferase [Chloroflexota bacterium] | diamond | 243 | 140 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 27704070 | 27704070 | PRJNA1156092_P_NODE_27564_length_246_cov_0.890173_g27434_i0 | PRJNA1156092 | 27564 | 246 | 0.890173 | 2.18982558 | Anaerolineales bacterium | 2073117 | Bacteria | Bacteria | 103 | 1.61e-26 | NR | NOQ40409.1 | 2073117 | g27434 | i0 | 83.1 | 1.4390243902439 | 59 | 10 | 72 | 0 | 69 | 245 | 1 | 59 | NOQ40409.1 AzlD domain-containing protein [Anaerolineales bacterium] | diamond | 354 | 103 | 1 | Bacteria | Bacillati | Chloroflexota | Anaerolineae | Anaerolineales | Anaerolineales bacterium | ||||
| 27767095 | 27767095 | PRJNA1156092_P_NODE_26864_length_246_cov_0.890173_g26734_i0 | PRJNA1156092 | 26864 | 246 | 0.890173 | 2.18982558 | Chloroflexota bacterium | 2026724 | Bacteria | Bacteria | 126 | 1.19e-31 | NR | MCP4167279.1 | 2026724 | g26734 | i0 | 75.3 | 0.98780487804878 | 81 | 20 | 98.8 | 0 | 245 | 3 | 857 | 937 | MCP4167279.1 PAS domain-containing protein [Chloroflexota bacterium] | diamond | 243 | 126 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 27829993 | 27829993 | PRJNA1156092_P_NODE_22984_length_250_cov_0.870056_g22854_i0 | PRJNA1156092 | 22984 | 250 | 0.870056 | 2.17514 | Dictyobacter vulcani | 2607529 | Bacteria | Bacteria | 63.2 | 2.62e-9 | NR | WP_198925268.1 | 2607529 | g22854 | i0 | 47.9 | 1.896 | 71 | 36 | 84 | 1 | 38 | 247 | 456 | 526 | WP_198925268.1 beta-galactosidase [Dictyobacter vulcani] | diamond | 474 | 63.2 | 1 | Bacteria | Bacillati | Chloroflexota | Ktedonobacteria | Ktedonobacterales | Dictyobacteraceae | Dictyobacter | Dictyobacter vulcani | ||
| 28145956 | 28145956 | PRJNA1156092_P_NODE_23425_length_250_cov_0.870056_g23295_i0 | PRJNA1156092 | 23425 | 250 | 0.870056 | 2.17514 | Ardenticatenia bacterium | 2099665 | Bacteria | Bacteria | 41.6 | 0.0146 | NR | MBC8254818.1 | 2099665 | g23295 | i0 | 60.6 | 0.396 | 33 | 13 | 39.6 | 0 | 4 | 102 | 37 | 69 | MBC8254818.1 cold shock domain-containing protein [Ardenticatenia bacterium] | diamond | 99 | 41.6 | 1 | Bacteria | Bacillati | Chloroflexota | Ardenticatenia | Ardenticatenia bacterium | |||||
| 28165195 | 28165195 | PRJNA1156092_P_NODE_24405_length_249_cov_0.875000_g24275_i0 | PRJNA1156092 | 24405 | 249 | 0.875 | 2.17875 | Bacteria | 2 | Bacteria | Bacteria | 59.3 | 5.05e-8 | NR | NWF79767.1 | 2026724 | g24275 | i0 | 66.7 | 1.86746987951807 | 39 | 13 | 47 | 0 | 122 | 6 | 1 | 39 | NWF79767.1 hypothetical protein [Chloroflexota bacterium] | diamond | 465 | 59.7 | 0.993299832495812 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 28366618 | 28366618 | PRJNA1156092_P_NODE_23126_length_250_cov_0.870056_g22996_i0 | PRJNA1156092 | 23126 | 250 | 0.870056 | 2.17514 | Anaerolineae bacterium | 2052143 | Bacteria | Bacteria | 45.4 | 0.00436 | NR | HEX6385571.1 | 2052143 | g22996 | i0 | 31.9 | 0.828 | 69 | 47 | 82.8 | 0 | 232 | 26 | 267 | 335 | HEX6385571.1 pyruvate dehydrogenase (acetyl-transferring) E1 component subunit alpha [Anaerolineae bacterium] | diamond | 207 | 45.4 | 1 | Bacteria | Bacillati | Chloroflexota | Anaerolineae | Anaerolineae bacterium | |||||
| 28493162 | 28493162 | PRJNA1156092_P_NODE_32567_length_241_cov_0.916667_g32437_i0 | PRJNA1156092 | 32567 | 241 | 0.916667 | 2.20916747 | Candidatus Caldilinea saccharophila | 3140701 | Bacteria | Bacteria | 47 | 0.00112 | NR | MBK8798554.1 | 3140701 | g32437 | i0 | 50 | 0.771784232365145 | 62 | 24 | 74.7 | 2 | 47 | 226 | 185 | 241 | MBK8798554.1 glycosyltransferase family 39 protein [Candidatus Caldilinea saccharophila] | diamond | 186 | 47 | 1 | Bacteria | Bacillati | Chloroflexota | Caldilineae | Caldilineales | Caldilineaceae | Caldilinea | Candidatus Caldilinea saccharophila | ||
| 28556386 | 28556386 | PRJNA1156092_P_NODE_31167_length_242_cov_0.911243_g31037_i0 | PRJNA1156092 | 31167 | 242 | 0.911243 | 2.20520806 | Candidatus Promineifilaceae bacterium | 3085104 | Bacteria | Bacteria | 77 | 2.71e-14 | NR | MFN2222868.1 | 3085104 | g31037 | i0 | 45 | 0.991735537190083 | 80 | 44 | 99.2 | 0 | 2 | 241 | 117 | 196 | MFN2222868.1 hypothetical protein [Candidatus Promineifilaceae bacterium] | diamond | 240 | 77 | 1 | Bacteria | Bacillati | Chloroflexota | Ardenticatenia | Candidatus Promineifilales | Candidatus Promineifilaceae | Candidatus Promineifilaceae bacterium | |||
| 28702005 | 28702005 | PRJNA1156092_P_NODE_30267_length_243_cov_0.905882_g30137_i0 | PRJNA1156092 | 30267 | 243 | 0.905882 | 2.20129326 | Bacteria | 2 | Bacteria | Bacteria | 112 | 1.7300000000000003e-27 | NR | OGN88373.1 | 1797618 | g30137 | i0 | 87.9 | 1.62962962962963 | 66 | 8 | 81.5 | 0 | 3 | 200 | 285 | 350 | OGN88373.1 MAG: hypothetical protein A2158_01790 [Chloroflexi bacterium RBG_13_46_14] | diamond | 396 | 112 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexi bacterium RBG_13_46_14 | ||||||
| 28745689 | 28745689 | PRJNA1156092_P_NODE_26627_length_247_cov_0.885057_g26497_i0 | PRJNA1156092 | 26627 | 247 | 0.885057 | 2.18609079 | Chloroflexota bacterium | 2026724 | Bacteria | Bacteria | 118 | 5.950000000000001e-29 | NR | MBE9471152.1 | 2026724 | g26497 | i0 | 70.7 | 0.995951417004049 | 82 | 24 | 99.6 | 0 | 2 | 247 | 176 | 257 | MBE9471152.1 S8 family serine peptidase [Chloroflexota bacterium] | diamond | 246 | 118 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 29049329 | 29049329 | PRJNA1156092_P_NODE_18048_length_277_cov_1.200980_g17918_i0 | PRJNA1156092 | 18048 | 277 | 1.20098 | 3.3267146 | Bacteria | 2 | Bacteria | Bacteria | 85.1 | 7.08e-17 | NR | KAA0269738.1 | 2026724 | g17918 | i0 | 58.7 | 7.72202166064982 | 63 | 26 | 68.2 | 0 | 89 | 277 | 141 | 203 | KAA0269738.1 MAG: FAD-binding oxidoreductase [Chloroflexota bacterium] | diamond | 2139 | 85.9 | 0.990686845168801 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 29996681 | 29996681 | PRJNA1156092_P_NODE_22611_length_251_cov_0.865169_g22481_i0 | PRJNA1156092 | 22611 | 251 | 0.865169 | 2.17157419 | Bacteria | 2 | Bacteria | Bacteria | 121 | 4.81e-33 | NR | MCP4358865.1 | 2026724 | g22481 | i0 | 85.5 | 2.96414342629482 | 62 | 9 | 74.1 | 0 | 66 | 251 | 1 | 62 | MCP4358865.1 DinB family protein [Chloroflexota bacterium] | diamond | 744 | 121 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 30198070 | 30198070 | PRJNA1156092_P_NODE_31772_length_242_cov_0.899408_g31642_i0 | PRJNA1156092 | 31772 | 242 | 0.899408 | 2.17656736 | Chloroflexota bacterium | 2026724 | Bacteria | Bacteria | 125 | 9.06e-33 | NR | NCF64802.1 | 2026724 | g31642 | i0 | 75 | 0.991735537190083 | 80 | 20 | 99.2 | 0 | 2 | 241 | 163 | 242 | NCF64802.1 alpha/beta fold hydrolase [Chloroflexota bacterium] | diamond | 240 | 125 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 30608904 | 30608904 | PRJNA1156092_P_NODE_29253_length_244_cov_0.900585_g29123_i0 | PRJNA1156092 | 29253 | 244 | 0.900585 | 2.1974274 | Anaerolineales bacterium | 2073117 | Bacteria | Bacteria | 148 | 4.139999999999999e-43 | NR | MCK4978720.1 | 2073117 | g29123 | i0 | 97.4 | 1.86885245901639 | 76 | 2 | 93.4 | 0 | 229 | 2 | 1 | 76 | MCK4978720.1 hypothetical protein [Anaerolineales bacterium] | diamond | 456 | 148 | 1 | Bacteria | Bacillati | Chloroflexota | Anaerolineae | Anaerolineales | Anaerolineales bacterium | ||||
| 30723114 | 30723114 | PRJNA1156092_P_NODE_30194_length_243_cov_0.905882_g30064_i0 | PRJNA1156092 | 30194 | 243 | 0.905882 | 2.20129326 | Candidatus Villigracilis | 3140593 | Bacteria | Bacteria | 82.8 | 2.93e-16 | NR | TDA65991.1 | 2026724 | g30064 | i0 | 55 | 4.9382716049382704 | 80 | 35 | 98.8 | 1 | 242 | 3 | 473 | 551 | TDA65991.1 MAG: PAS domain S-box protein [Chloroflexota bacterium] | diamond | 1200 | 83.2 | 0.995192307692308 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 31177484 | 31177484 | PRJNA1156092_P_NODE_27995_length_245_cov_0.895349_g27865_i0 | PRJNA1156092 | 27995 | 245 | 0.895349 | 2.19360505 | Caldilineae bacterium | 2420332 | Bacteria | Bacteria | 57.4 | 2.48e-7 | NR | HEY53328.1 | 2420332 | g27865 | i0 | 50.9 | 2.10612244897959 | 55 | 27 | 67.3 | 0 | 5 | 169 | 302 | 356 | HEY53328.1 hypothetical protein [Caldilineae bacterium] | diamond | 516 | 57.4 | 1 | Bacteria | Bacillati | Chloroflexota | Caldilineae | Caldilineae bacterium | |||||
| 31651984 | 31651984 | PRJNA1156092_P_NODE_28377_length_245_cov_0.895349_g28247_i0 | PRJNA1156092 | 28377 | 245 | 0.895349 | 2.19360505 | Anaerolineae bacterium | 2052143 | Bacteria | Bacteria | 149 | 1.38e-42 | NR | NIV29584.1 | 2052143 | g28247 | i0 | 81.5 | 1.98367346938776 | 81 | 15 | 99.2 | 0 | 243 | 1 | 72 | 152 | NIV29584.1 hypothetical protein [Anaerolineae bacterium] | diamond | 486 | 149 | 1 | Bacteria | Bacillati | Chloroflexota | Anaerolineae | Anaerolineae bacterium | |||||
| 31873523 | 31873523 | PRJNA1156092_P_NODE_21897_length_251_cov_0.865169_g21767_i0 | PRJNA1156092 | 21897 | 251 | 0.865169 | 2.17157419 | Anaerolineales bacterium | 2073117 | Bacteria | Bacteria | 60.8 | 1.61e-8 | NR | HLF87485.1 | 2073117 | g21767 | i0 | 67.5 | 0.956175298804781 | 40 | 13 | 47.8 | 0 | 250 | 131 | 344 | 383 | HLF87485.1 aminotransferase class V-fold PLP-dependent enzyme [Anaerolineales bacterium] | diamond | 240 | 60.8 | 1 | Bacteria | Bacillati | Chloroflexota | Anaerolineae | Anaerolineales | Anaerolineales bacterium | ||||
| 32000152 | 32000152 | PRJNA1156092_P_NODE_30018_length_243_cov_0.905882_g29888_i0 | PRJNA1156092 | 30018 | 243 | 0.905882 | 2.20129326 | Chloroflexota bacterium | 2026724 | Bacteria | Bacteria | 103 | 5.099999999999998e-25 | NR | NOZ72671.1 | 2026724 | g29888 | i0 | 76.2 | 1.53086419753086 | 63 | 15 | 77.8 | 0 | 41 | 229 | 16 | 78 | NOZ72671.1 DUF2085 domain-containing protein [Chloroflexota bacterium] | diamond | 372 | 103 | 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);;