contig_metadata
24 rows where bioproject = "PRJNA222400", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 12535117 | 12535117 | PRJNA222400_P_NODE_1990_length_358_cov_1.200647_g1957_i0 | PRJNA222400 | 1990 | 358 | 1.200647 | 4.29831626 | Chloroflexota bacterium | 2026724 | Bacteria | Bacteria | 122 | 5.62e-30 | NR | HAJ35901.1 | 2026724 | g1957 | i0 | 69.9 | 2.03631284916201 | 83 | 25 | 69.6 | 0 | 354 | 106 | 366 | 448 | HAJ35901.1 aspartate aminotransferase family protein [Chloroflexota bacterium] | diamond | 729 | 122 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 26630850 | 26630850 | PRJNA222400_P_NODE_3661_length_236_cov_1.112299_g3628_i0 | PRJNA222400 | 3661 | 236 | 1.112299 | 2.62502564 | Chloroflexota bacterium | 2026724 | Bacteria | Bacteria | 42.7 | 0.0331 | NR | NDJ85518.1 | 2026724 | g3628 | i0 | 35.4 | 1.04237288135593 | 82 | 47 | 96.6 | 1 | 235 | 8 | 91 | 172 | NDJ85518.1 AAA family ATPase [Chloroflexota bacterium] | diamond | 246 | 42.7 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 26694067 | 26694067 | PRJNA222400_P_NODE_841_length_561_cov_1.722656_g810_i0 | PRJNA222400 | 841 | 561 | 1.722656 | 9.66410016 | Anaerolineae bacterium | 2052143 | Bacteria | Bacteria | 65.1 | 1.43e-8 | NR | MFN2250783.1 | 2052143 | g810 | i0 | 34.5 | 0.775401069518717 | 145 | 90 | 76.5 | 2 | 431 | 3 | 317 | 458 | MFN2250783.1 Ig-like domain-containing protein [Anaerolineae bacterium] | diamond | 435 | 65.1 | 1 | Bacteria | Bacillati | Chloroflexota | Anaerolineae | Anaerolineae bacterium | |||||
| 26915757 | 26915757 | PRJNA222400_P_NODE_3082_length_267_cov_0.981651_g3049_i0 | PRJNA222400 | 3082 | 267 | 0.981651 | 2.62100817 | Anaerolineae bacterium | 2052143 | Bacteria | Bacteria | 125 | 5.699999999999999e-32 | NR | MCC6804901.1 | 2052143 | g3049 | i0 | 69 | 1.95505617977528 | 87 | 27 | 97.8 | 0 | 6 | 266 | 266 | 352 | MCC6804901.1 aspartate aminotransferase family protein [Anaerolineae bacterium] | diamond | 522 | 125 | 1 | Bacteria | Bacillati | Chloroflexota | Anaerolineae | Anaerolineae bacterium | |||||
| 27390237 | 27390237 | PRJNA222400_P_NODE_2603_length_300_cov_1.402390_g2570_i0 | PRJNA222400 | 2603 | 300 | 1.40239 | 4.20717 | Caldilineae bacterium | 2420332 | Bacteria | Bacteria | 117 | 1.03e-29 | NR | RME59500.1 | 2420332 | g2570 | i0 | 61.6 | 0.99 | 99 | 38 | 99 | 0 | 299 | 3 | 133 | 231 | RME59500.1 MAG: molybdopterin molybdenumtransferase MoeA, partial [Caldilineae bacterium] | diamond | 297 | 117 | 1 | Bacteria | Bacillati | Chloroflexota | Caldilineae | Caldilineae bacterium | |||||
| 27421852 | 27421852 | PRJNA222400_P_NODE_3343_length_252_cov_1.192118_g3310_i0 | PRJNA222400 | 3343 | 252 | 1.192118 | 3.00413736 | Chloroflexota bacterium | 2026724 | Bacteria | Bacteria | 42.7 | 0.00992 | NR | MBI3953777.1 | 2026724 | g3310 | i0 | 48.8 | 0.488095238095238 | 41 | 21 | 48.8 | 0 | 8 | 130 | 59 | 99 | MBI3953777.1 spermidine synthase [Chloroflexota bacterium] | diamond | 123 | 42.7 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 27692264 | 27692264 | PRJNA222400_P_NODE_2284_length_327_cov_1.172662_g2251_i0 | PRJNA222400 | 2284 | 327 | 1.172662 | 3.83460474 | Bacteria | 2 | Bacteria | Bacteria | 103 | 4.989999999999999e-24 | NR | MFO7683302.1 | 2026724 | g2251 | i0 | 63.5 | 6.86238532110092 | 74 | 27 | 67.9 | 0 | 1 | 222 | 216 | 289 | MFO7683302.1 MaoC/PaaZ C-terminal domain-containing protein [Chloroflexota bacterium] | diamond | 2244 | 103 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 28337298 | 28337298 | PRJNA222400_P_NODE_4206_length_217_cov_1.238095_g4173_i0 | PRJNA222400 | 4206 | 217 | 1.238095 | 2.68666615 | Chloroflexota bacterium | 2026724 | Bacteria | Bacteria | 77.8 | 1.85e-16 | NR | MFC2035475.1 | 2026724 | g4173 | i0 | 58 | 0.953917050691244 | 69 | 29 | 95.4 | 0 | 208 | 2 | 48 | 116 | MFC2035475.1 50S ribosomal protein L17 [Chloroflexota bacterium] | diamond | 207 | 77.8 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 28481364 | 28481364 | PRJNA222400_P_NODE_7186_length_169_cov_0.866667_g7153_i0 | PRJNA222400 | 7186 | 169 | 0.866667 | 1.46466723 | Bacteria | 2 | Bacteria | Bacteria | 63.5 | 4.77e-10 | NR | MBM3188481.1 | 2026724 | g7153 | i0 | 53.8 | 3.60355029585799 | 52 | 21 | 92.3 | 1 | 157 | 2 | 83 | 131 | MBM3188481.1 ribokinase [Chloroflexota bacterium] | diamond | 609 | 63.5 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 29158385 | 29158385 | PRJNA222400_P_NODE_1889_length_368_cov_1.724138_g1856_i0 | PRJNA222400 | 1889 | 368 | 1.724138 | 6.34482784 | Herpetosiphonaceae bacterium | 2720503 | Bacteria | Bacteria | 105 | 3.01e-24 | NR | GIV97552.1 | 2720503 | g1856 | i0 | 53.1 | 1.85869565217391 | 113 | 50 | 92.1 | 2 | 13 | 351 | 251 | 360 | GIV97552.1 MAG: N-acetylmuramoyl-L-alanine amidase [Herpetosiphonaceae bacterium] | diamond | 684 | 105 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexia | Herpetosiphonales | Herpetosiphonaceae | Herpetosiphonaceae bacterium | |||
| 29379237 | 29379237 | PRJNA222400_P_NODE_4409_length_211_cov_1.635802_g4376_i0 | PRJNA222400 | 4409 | 211 | 1.635802 | 3.45154222 | Chloroflexota bacterium | 2026724 | Bacteria | Bacteria | 42 | 0.0361 | NR | MBE3037687.1 | 2026724 | g4376 | i0 | 81 | 0.298578199052133 | 21 | 4 | 29.9 | 0 | 3 | 65 | 180 | 200 | MBE3037687.1 IMP dehydrogenase [Chloroflexota bacterium] | diamond | 63 | 42 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 29379239 | 29379239 | PRJNA222400_P_NODE_4829_length_202_cov_2.196078_g4796_i0 | PRJNA222400 | 4829 | 202 | 2.196078 | 4.43607756 | Chloroflexota bacterium | 2026724 | Bacteria | Bacteria | 41.6 | 0.0204 | NR | MFO7540512.1 | 2026724 | g4796 | i0 | 39.6 | 0.787128712871287 | 53 | 30 | 75.7 | 1 | 33 | 185 | 14 | 66 | MFO7540512.1 hypothetical protein [Chloroflexota bacterium] | diamond | 159 | 41.6 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 29554661 | 29554661 | PRJNA222400_P_NODE_5490_length_191_cov_1.316901_g5457_i0 | PRJNA222400 | 5490 | 191 | 1.316901 | 2.51528091 | PVC group | 1783257 | Bacteria | Bacteria | 43.5 | 0.00986 | NR | OGO58076.1 | 1797663 | g5457 | i0 | 55.3 | 3.3455497382199 | 38 | 15 | 56.5 | 1 | 190 | 83 | 322 | 359 | OGO58076.1 MAG: hypothetical protein A2V85_13190 [Chloroflexi bacterium RBG_16_72_14] | diamond | 639 | 43.5 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexi bacterium RBG_16_72_14 | ||||||
| 29979206 | 29979206 | PRJNA222400_P_NODE_811_length_573_cov_2.055344_g780_i0 | PRJNA222400 | 811 | 573 | 2.055344 | 11.77712112 | Chloroflexota bacterium | 2026724 | Bacteria | Bacteria | 115 | 4.29e-26 | NR | MDQ2809526.1 | 2026724 | g780 | i0 | 37.8 | 0.74869109947644 | 143 | 89 | 74.9 | 0 | 569 | 141 | 1041 | 1183 | MDQ2809526.1 choice-of-anchor A family protein [Chloroflexota bacterium] | diamond | 429 | 115 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 30484787 | 30484787 | PRJNA222400_P_NODE_8713_length_164_cov_0.904348_g8680_i0 | PRJNA222400 | 8713 | 164 | 0.904348 | 1.48313072 | Dehalococcoidales bacterium | 2026733 | Bacteria | Bacteria | 63.9 | 2.23e-11 | NR | MDD2251818.1 | 2026733 | g8680 | i0 | 55.6 | 0.98780487804878 | 54 | 24 | 98.8 | 0 | 2 | 163 | 5 | 58 | MDD2251818.1 DUF4870 domain-containing protein [Dehalococcoidales bacterium] | diamond | 162 | 63.9 | 1 | Bacteria | Bacillati | Chloroflexota | Dehalococcoidia | Dehalococcoidales | Dehalococcoidales bacterium | ||||
| 31210937 | 31210937 | PRJNA222400_P_NODE_2675_length_294_cov_1.644898_g2642_i0 | PRJNA222400 | 2675 | 294 | 1.644898 | 4.83600012 | Herpetosiphon aurantiacus DSM 785 | 316274 | Bacteria | Bacteria | 80.1 | 2.35e-15 | NR | ABX07819.1 | 316274 | g2642 | i0 | 51.6 | 1.93877551020408 | 95 | 38 | 96.9 | 1 | 290 | 6 | 174 | 260 | ABX07819.1 Peptidoglycan-binding domain 1 protein [Herpetosiphon aurantiacus DSM 785] | diamond | 570 | 80.1 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexia | Herpetosiphonales | Herpetosiphonaceae | Herpetosiphon | Herpetosiphon aurantiacus | ||
| 31228972 | 31228972 | PRJNA222400_P_NODE_5135_length_197_cov_1.385135_g5102_i0 | PRJNA222400 | 5135 | 197 | 1.385135 | 2.72871595 | Bacteria | 2 | Bacteria | Bacteria | 84.3 | 4.98e-18 | NR | MBE2195791.1 | 1872519 | g5102 | i0 | 58.5 | 2.96954314720812 | 65 | 27 | 99 | 0 | 2 | 196 | 102 | 166 | MBE2195791.1 SDR family oxidoreductase [Anaerolinea sp.] | diamond | 585 | 84.7 | 0.995277449822904 | Bacteria | Bacillati | Chloroflexota | Anaerolineae | Anaerolineales | Anaerolineaceae | Anaerolinea | Anaerolinea sp. | ||
| 31401399 | 31401399 | PRJNA222400_P_NODE_2256_length_330_cov_1.480427_g2223_i0 | PRJNA222400 | 2256 | 330 | 1.480427 | 4.8854091 | Flexilinea flocculi | 1678840 | Bacteria | Bacteria | 45.8 | 0.00786 | NR | WP_062278703.1 | 1678840 | g2223 | i0 | 39 | 0.7 | 77 | 43 | 70 | 3 | 261 | 31 | 38 | 110 | WP_062278703.1 substrate-binding domain-containing protein [Flexilinea flocculi] | diamond | 231 | 45.8 | 1 | Bacteria | Bacillati | Chloroflexota | Anaerolineae | Anaerolineales | Anaerolineaceae | Flexilinea | Flexilinea flocculi | ||
| 31559552 | 31559552 | PRJNA222400_P_NODE_3856_length_227_cov_2.308989_g3823_i0 | PRJNA222400 | 3856 | 227 | 2.308989 | 5.24140503 | Herpetosiphonaceae bacterium | 2720503 | Bacteria | Bacteria | 95.1 | 3.79e-22 | NR | MBA3943841.1 | 2720503 | g3823 | i0 | 59.4 | 2.82819383259912 | 69 | 28 | 91.2 | 0 | 208 | 2 | 121 | 189 | MBA3943841.1 sulfotransferase family protein [Herpetosiphonaceae bacterium] | diamond | 642 | 95.1 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexia | Herpetosiphonales | Herpetosiphonaceae | Herpetosiphonaceae bacterium | |||
| 31717478 | 31717478 | PRJNA222400_P_NODE_197_length_1059_cov_3.517822_g181_i0 | PRJNA222400 | 197 | 1059 | 3.517822 | 37.25373498 | Chloroflexota bacterium | 2026724 | Bacteria | Bacteria | 53.1 | 0.00161 | NR | MBM3118724.1 | 2026724 | g181 | i0 | 35.7 | 1.35410764872521 | 115 | 63 | 31.2 | 7 | 995 | 666 | 299 | 407 | MBM3118724.1 hypothetical protein [Chloroflexota bacterium] | diamond | 1434 | 53.1 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 31812389 | 31812389 | PRJNA222400_P_NODE_3137_length_263_cov_1.700935_g3104_i0 | PRJNA222400 | 3137 | 263 | 1.700935 | 4.47345905 | Dehalococcoidia bacterium | 2026734 | Bacteria | Bacteria | 78.2 | 8.2e-15 | NR | HEY8173535.1 | 2026734 | g3104 | i0 | 49.4 | 3.96958174904943 | 87 | 41 | 99.2 | 1 | 2 | 262 | 33 | 116 | HEY8173535.1 oxidoreductase [Dehalococcoidia bacterium] | diamond | 1044 | 78.2 | 1 | Bacteria | Bacillati | Chloroflexota | Dehalococcoidia | Dehalococcoidia bacterium | |||||
| 32287298 | 32287298 | PRJNA222400_P_NODE_9299_length_162_cov_0.920354_g9266_i0 | PRJNA222400 | 9299 | 162 | 0.920354 | 1.49097348 | Chloroflexota bacterium | 2026724 | Bacteria | Bacteria | 50.4 | 2.3e-5 | NR | TMC50903.1 | 2026724 | g9266 | i0 | 46.2 | 0.962962962962963 | 52 | 28 | 96.3 | 0 | 3 | 158 | 245 | 296 | TMC50903.1 MAG: MFS transporter, partial [Chloroflexota bacterium] | diamond | 156 | 50.4 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 32413650 | 32413650 | PRJNA222400_P_NODE_5539_length_190_cov_1.475177_g5506_i0 | PRJNA222400 | 5539 | 190 | 1.475177 | 2.8028363 | Candidatus Limnocylindrales bacterium | 2952938 | Bacteria | Bacteria | 50.4 | 3.57e-5 | NR | HUQ85469.1 | 2952938 | g5506 | i0 | 42.4 | 1.86315789473684 | 59 | 34 | 93.2 | 0 | 1 | 177 | 594 | 652 | HUQ85469.1 M1 family metallopeptidase [Candidatus Limnocylindrales bacterium] | diamond | 354 | 50.4 | 1 | Bacteria | Bacillati | Chloroflexota | Candidatus Limnocylindria | Candidatus Limnocylindrales | Candidatus Limnocylindrales bacterium | ||||
| 32477001 | 32477001 | PRJNA222400_P_NODE_959_length_529_cov_1.362500_g928_i0 | PRJNA222400 | 959 | 529 | 1.3625 | 7.207625 | Chloroflexia bacterium | 2448782 | Bacteria | Bacteria | 91.7 | 7.67e-18 | NR | HET7077369.1 | 2448782 | g928 | i0 | 30.7 | 0.998109640831758 | 176 | 121 | 99.8 | 1 | 528 | 1 | 1308 | 1482 | HET7077369.1 choice-of-anchor A family protein [Chloroflexia bacterium] | diamond | 528 | 91.7 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexia | Chloroflexia 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);;