contig_metadata
21 rows where analysis = "diamond", bioproject = "PRJEB17675" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 16598445 | 16598445 | PRJEB17675_P_NODE_13094_length_230_cov_1.641026_g12790_i0 | PRJEB17675 | 13094 | 230 | 1.641026 | 3.7743598 | Chloroflexota bacterium | 2026724 | Bacteria | Bacteria | 86.3 | 1.48e-17 | NR | MBH52274.1 | 2026724 | g12790 | i0 | 52.6 | 2.04782608695652 | 76 | 36 | 99.1 | 0 | 230 | 3 | 227 | 302 | MBH52274.1 sodium-translocating pyrophosphatase [Chloroflexota bacterium] | diamond | 471 | 86.3 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 26615027 | 26615027 | PRJEB17675_P_NODE_13621_length_224_cov_1.269841_g13317_i0 | PRJEB17675 | 13621 | 224 | 1.269841 | 2.84444384 | Bacillati | 1783272 | Bacteria | Bacteria | 90.1 | 5.29e-19 | NR | MEM6283183.1 | 2026724 | g13317 | i0 | 63.4 | 5.69196428571429 | 71 | 26 | 95.1 | 0 | 221 | 9 | 352 | 422 | MEM6283183.1 CRTAC1 family protein [Chloroflexota bacterium] | diamond | 1275 | 90.1 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 26906589 | 26906589 | PRJEB17675_P_NODE_14522_length_214_cov_1.787709_g14218_i0 | PRJEB17675 | 14522 | 214 | 1.787709 | 3.82569726 | Chloroflexota bacterium | 2026724 | Bacteria | Bacteria | 57.4 | 1.31e-7 | NR | RMG93555.1 | 2026724 | g14218 | i0 | 49.3 | 1.99065420560748 | 71 | 32 | 99.5 | 1 | 213 | 1 | 79 | 145 | RMG93555.1 MAG: mechanosensitive ion channel family protein [Chloroflexota bacterium] | diamond | 426 | 57.4 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 27406217 | 27406217 | PRJEB17675_P_NODE_15043_length_209_cov_1.816092_g14739_i0 | PRJEB17675 | 15043 | 209 | 1.816092 | 3.79563228 | Chloroflexota | 200795 | Bacteria | Bacteria | 46.2 | 0.00141 | NR | MDW8148173.1 | 2762507 | g14739 | i0 | 41.5 | 1.80861244019139 | 65 | 35 | 93.3 | 1 | 197 | 3 | 30 | 91 | MDW8148173.1 VWA domain-containing protein [Roseiflexaceae bacterium] | diamond | 378 | 46.6 | 0.991416309012876 | Bacteria | Bacillati | Chloroflexota | Chloroflexia | Chloroflexales | Roseiflexaceae | Roseiflexaceae bacterium | |||
| 27538807 | 27538807 | PRJEB17675_P_NODE_15824_length_202_cov_1.766467_g15520_i0 | PRJEB17675 | 15824 | 202 | 1.766467 | 3.56826334 | Chloroflexota bacterium | 2026724 | Bacteria | Bacteria | 69.7 | 6.45e-12 | NR | MCH7737098.1 | 2026724 | g15520 | i0 | 58.8 | 1.48514851485149 | 51 | 21 | 75.7 | 0 | 41 | 193 | 267 | 317 | MCH7737098.1 FAD-dependent oxidoreductase [Chloroflexota bacterium] | diamond | 300 | 69.7 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 27949179 | 27949179 | PRJEB17675_P_NODE_15465_length_205_cov_2.200000_g15161_i0 | PRJEB17675 | 15465 | 205 | 2.2 | 4.51 | Chloroflexota bacterium | 2026724 | Bacteria | Bacteria | 49.7 | 3.71e-5 | NR | NBD35337.1 | 2026724 | g15161 | i0 | 41.4 | 0.848780487804878 | 58 | 31 | 84.9 | 2 | 19 | 192 | 39 | 93 | NBD35337.1 Hsp20 family protein [Chloroflexota bacterium] | diamond | 174 | 49.7 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 27949185 | 27949185 | PRJEB17675_P_NODE_22885_length_160_cov_0.960000_g22581_i0 | PRJEB17675 | 22885 | 160 | 0.96 | 1.536 | Dehalococcoidales bacterium | 2026733 | Bacteria | Bacteria | 97.8 | 1.92e-24 | NR | MDO9333994.1 | 2026733 | g22581 | i0 | 94.3 | 0.99375 | 53 | 2 | 97.5 | 1 | 3 | 158 | 78 | 130 | MDO9333994.1 30S ribosomal protein S4 [Dehalococcoidales bacterium] | diamond | 159 | 97.8 | 1 | Bacteria | Bacillati | Chloroflexota | Dehalococcoidia | Dehalococcoidales | Dehalococcoidales bacterium | ||||
| 28106952 | 28106952 | PRJEB17675_P_NODE_5065_length_430_cov_2.225316_g4766_i0 | PRJEB17675 | 5065 | 430 | 2.225316 | 9.5688588 | Chloroflexota bacterium | 2026724 | Bacteria | Bacteria | 46.6 | 0.012 | NR | MBM4444747.1 | 2026724 | g4766 | i0 | 30.9 | 0.565116279069767 | 81 | 51 | 55.1 | 2 | 376 | 140 | 765 | 842 | MBM4444747.1 hypothetical protein [Chloroflexota bacterium] | diamond | 243 | 46.6 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 28195151 | 28195151 | PRJEB17675_P_NODE_20526_length_171_cov_1.139706_g20222_i0 | PRJEB17675 | 20526 | 171 | 1.139706 | 1.94889726 | FCB group | 1783270 | Bacteria | Bacteria | 52 | 7.59e-6 | NR | MDE3089474.1 | 2026724 | g20222 | i0 | 47.2 | 11.9824561403509 | 53 | 27 | 91.2 | 1 | 14 | 169 | 494 | 546 | MDE3089474.1 PQQ-binding-like beta-propeller repeat protein [Chloroflexota bacterium] | diamond | 2049 | 52 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 28707067 | 28707067 | PRJEB17675_P_NODE_16307_length_199_cov_0.969512_g16003_i0 | PRJEB17675 | 16307 | 199 | 0.969512 | 1.92932888 | Chloroflexota bacterium | 2026724 | Bacteria | Bacteria | 51.6 | 1.57e-5 | NR | MEA2621218.1 | 2026724 | g16003 | i0 | 58.3 | 1.04020100502513 | 36 | 15 | 54.3 | 0 | 123 | 16 | 367 | 402 | MEA2621218.1 hypothetical protein [Chloroflexota bacterium] | diamond | 207 | 51.6 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 28833211 | 28833211 | PRJEB17675_P_NODE_24928_length_152_cov_1.025641_g24624_i0 | PRJEB17675 | 24928 | 152 | 1.025641 | 1.55897432 | Anaerolinea sp. | 1872519 | Bacteria | Bacteria | 70.9 | 1.28e-12 | NR | MCA1954537.1 | 1872519 | g24624 | i0 | 65.3 | 0.967105263157895 | 49 | 17 | 96.7 | 0 | 152 | 6 | 156 | 204 | MCA1954537.1 methionine--tRNA ligase [Anaerolinea sp.] | diamond | 147 | 70.9 | 1 | Bacteria | Bacillati | Chloroflexota | Anaerolineae | Anaerolineales | Anaerolineaceae | Anaerolinea | Anaerolinea sp. | ||
| 29243761 | 29243761 | PRJEB17675_P_NODE_13329_length_227_cov_2.156250_g13025_i0 | PRJEB17675 | 13329 | 227 | 2.15625 | 4.8946875 | Candidatus Promineifilaceae bacterium | 3085104 | Bacteria | Bacteria | 68.2 | 1.01e-11 | NR | MDX1617130.1 | 3085104 | g13025 | i0 | 45.9 | 0.977973568281938 | 74 | 39 | 96.5 | 1 | 6 | 224 | 143 | 216 | MDX1617130.1 mechanosensitive ion channel [Candidatus Promineifilaceae bacterium] | diamond | 222 | 68.2 | 1 | Bacteria | Bacillati | Chloroflexota | Ardenticatenia | Candidatus Promineifilales | Candidatus Promineifilaceae | Candidatus Promineifilaceae bacterium | |||
| 29338528 | 29338528 | PRJEB17675_P_NODE_6329_length_374_cov_2.769912_g6028_i0 | PRJEB17675 | 6329 | 374 | 2.769912 | 10.35947088 | Anaerolineae bacterium | 2052143 | Bacteria | Bacteria | 63.2 | 5.64e-9 | NR | MBN1401244.1 | 2052143 | g6028 | i0 | 31.1 | 3.9144385026738 | 122 | 81 | 97.9 | 1 | 4 | 369 | 37 | 155 | MBN1401244.1 tryptophan-rich sensory protein [Anaerolineae bacterium] | diamond | 1464 | 63.2 | 1 | Bacteria | Bacillati | Chloroflexota | Anaerolineae | Anaerolineae bacterium | |||||
| 29464320 | 29464320 | PRJEB17675_P_NODE_18490_length_183_cov_1.459459_g18186_i0 | PRJEB17675 | 18490 | 183 | 1.459459 | 2.67080997 | Chloroflexota bacterium | 2026724 | Bacteria | Bacteria | 44.3 | 0.00473 | NR | MEL7234270.1 | 2026724 | g18186 | i0 | 55.8 | 2.04918032786885 | 43 | 17 | 67.2 | 1 | 8 | 130 | 334 | 376 | MEL7234270.1 SDR family NAD(P)-dependent oxidoreductase [Chloroflexota bacterium] | diamond | 375 | 44.3 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 29559317 | 29559317 | PRJEB17675_P_NODE_1250_length_869_cov_2.139089_g1075_i0 | PRJEB17675 | 1250 | 869 | 2.139089 | 18.58868341 | Ktedonobacteraceae bacterium | 2740538 | Bacteria | Bacteria | 115 | 6.260000000000001e-26 | NR | HYB01461.1 | 2740538 | g1075 | i0 | 33.3 | 2.6409666283084 | 255 | 135 | 82.9 | 10 | 1 | 720 | 123 | 357 | HYB01461.1 hypothetical protein [Ktedonobacteraceae bacterium] | diamond | 2295 | 115 | 1 | Bacteria | Bacillati | Chloroflexota | Ktedonobacteria | Ktedonobacterales | Ktedonobacteraceae | Ktedonobacteraceae bacterium | |||
| 29742230 | 29742230 | PRJEB17675_P_NODE_2970_length_572_cov_1.882682_g2703_i0 | PRJEB17675 | 2970 | 572 | 1.882682 | 10.76894104 | Candidatus Trichofilum | 3140595 | Bacteria | Bacteria | 198 | 1.3e-57 | NR | MDX1688361.1 | 3085104 | g2703 | i0 | 52.9 | 1.97202797202797 | 189 | 89 | 99.1 | 0 | 569 | 3 | 63 | 251 | MDX1688361.1 thiamine pyrophosphate-binding protein [Candidatus Promineifilaceae bacterium] | diamond | 1128 | 198 | 1 | Bacteria | Bacillati | Chloroflexota | Ardenticatenia | Candidatus Promineifilales | Candidatus Promineifilaceae | Candidatus Promineifilaceae bacterium | |||
| 29875294 | 29875294 | PRJEB17675_P_NODE_20691_length_170_cov_1.185185_g20387_i0 | PRJEB17675 | 20691 | 170 | 1.185185 | 2.0148145 | Chloroflexota bacterium | 2026724 | Bacteria | Bacteria | 55.8 | 1.46e-8 | NR | HAL62141.1 | 2026724 | g20387 | i0 | 54.5 | 0.776470588235294 | 44 | 20 | 77.6 | 0 | 39 | 170 | 1 | 44 | HAL62141.1 cold-shock protein [Chloroflexota bacterium] | diamond | 132 | 55.8 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 31227243 | 31227243 | PRJEB17675_P_NODE_9235_length_291_cov_1.683594_g8931_i0 | PRJEB17675 | 9235 | 291 | 1.683594 | 4.89925854 | Bacteria | 2 | Bacteria | Bacteria | 115 | 8.62e-29 | NR | NPA26530.1 | 2026724 | g8931 | i0 | 56.4 | 3.90721649484536 | 94 | 33 | 94.8 | 3 | 279 | 4 | 166 | 253 | NPA26530.1 alkaline phosphatase [Chloroflexota bacterium] | diamond | 1137 | 116 | 0.991379310344828 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 31518605 | 31518605 | PRJEB17675_P_NODE_10896_length_261_cov_1.380531_g10592_i0 | PRJEB17675 | 10896 | 261 | 1.380531 | 3.60318591 | Chloroflexota bacterium | 2026724 | Bacteria | Bacteria | 55.5 | 1.46e-7 | NR | MDA0734831.1 | 2026724 | g10592 | i0 | 32.9 | 0.977011494252874 | 85 | 54 | 97.7 | 1 | 2 | 256 | 7 | 88 | MDA0734831.1 RNA-binding protein [Chloroflexota bacterium] | diamond | 255 | 55.5 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 32119698 | 32119698 | PRJEB17675_P_NODE_8158_length_317_cov_2.411348_g7854_i0 | PRJEB17675 | 8158 | 317 | 2.411348 | 7.64397316 | Dehalococcoidia bacterium | 2026734 | Bacteria | Bacteria | 79.3 | 1.27e-14 | NR | MFL2783575.1 | 2026734 | g7854 | i0 | 35.6 | 1.76971608832808 | 101 | 65 | 95.6 | 0 | 305 | 3 | 455 | 555 | MFL2783575.1 beta-propeller fold lactonase family protein [Dehalococcoidia bacterium] | diamond | 561 | 79.3 | 1 | Bacteria | Bacillati | Chloroflexota | Dehalococcoidia | Dehalococcoidia bacterium | |||||
| 32713507 | 32713507 | PRJEB17675_P_NODE_8360_length_312_cov_1.588448_g8056_i0 | PRJEB17675 | 8360 | 312 | 1.588448 | 4.95595776 | Bacillati | 1783272 | Bacteria | Bacteria | 84.7 | 1.06e-16 | NR | MEM7803132.1 | 2026724 | g8056 | i0 | 40.8 | 4.59615384615385 | 98 | 57 | 93.3 | 1 | 303 | 13 | 283 | 380 | MEM7803132.1 MFS transporter [Chloroflexota bacterium] | diamond | 1434 | 85.5 | 0.990643274853801 | 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);;