contig_metadata
8 rows where bioproject = "PRJNA1253303" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5462819 | 5462819 | PRJNA1253303_P_NODE_6565_length_248_cov_0.891429_g6543_i0 | PRJNA1253303 | 6565 | 248 | 0.891429 | 2.21074392 | Chloroflexota bacterium | 2026724 | Bacteria | Bacteria | 105 | 2.9e-25 | NR | MDQ3695428.1 | 2026724 | g6543 | i0 | 72 | 1.98387096774194 | 82 | 23 | 99.2 | 0 | 2 | 247 | 187 | 268 | MDQ3695428.1 ketopantoate reductase family protein [Chloroflexota bacterium] | diamond | 492 | 105 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 10563604 | 10563604 | PRJNA1253303_P_NODE_7829_length_244_cov_0.912281_g7807_i0 | PRJNA1253303 | 7829 | 244 | 0.912281 | 2.22596564 | Chloroflexia bacterium | 2448782 | Bacteria | Bacteria | 158 | 7.989999999999998e-47 | NR | HKP52369.1 | 2448782 | g7807 | i0 | 97.5 | 0.995901639344262 | 81 | 2 | 99.6 | 0 | 2 | 244 | 62 | 142 | HKP52369.1 50S ribosomal protein L3 [Chloroflexia bacterium] | diamond | 243 | 158 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexia | Chloroflexia bacterium | |||||
| 15662414 | 15662414 | PRJNA1253303_P_NODE_8333_length_242_cov_0.923077_g8311_i0 | PRJNA1253303 | 8333 | 242 | 0.923077 | 2.23384634 | Bacteria | 2 | Bacteria | Bacteria | 117 | 4.91e-31 | NR | MDQ3547476.1 | 2026724 | g8311 | i0 | 76.3 | 2.97520661157025 | 80 | 19 | 99.2 | 0 | 3 | 242 | 81 | 160 | MDQ3547476.1 zinc metallopeptidase [Chloroflexota bacterium] | diamond | 720 | 118 | 0.991525423728814 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 27042212 | 27042212 | PRJNA1253303_P_NODE_8462_length_242_cov_0.923077_g8440_i0 | PRJNA1253303 | 8462 | 242 | 0.923077 | 2.23384634 | Roseiflexaceae bacterium | 2762507 | Bacteria | Bacteria | 78.6 | 8.78e-15 | NR | MDW8145706.1 | 2762507 | g8440 | i0 | 55.4 | 0.91735537190082606 | 74 | 32 | 91.7 | 1 | 240 | 19 | 470 | 542 | MDW8145706.1 ATP-binding protein [Roseiflexaceae bacterium] | diamond | 222 | 78.6 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexia | Chloroflexales | Roseiflexaceae | Roseiflexaceae bacterium | |||
| 27073769 | 27073769 | PRJNA1253303_P_NODE_8222_length_243_cov_0.917647_g8200_i0 | PRJNA1253303 | 8222 | 243 | 0.917647 | 2.22988221 | Candidatus Limnocylindria bacterium | 3047546 | Bacteria | Bacteria | 58.9 | 3.04e-8 | NR | HUG47167.1 | 3047546 | g8200 | i0 | 54.2 | 0.888888888888889 | 72 | 29 | 86.4 | 3 | 212 | 3 | 2 | 71 | HUG47167.1 CHRD domain-containing protein [Candidatus Limnocylindria bacterium] | diamond | 216 | 58.9 | 1 | Bacteria | Bacillati | Chloroflexota | Candidatus Limnocylindria | Candidatus Limnocylindria bacterium | |||||
| 28368580 | 28368580 | PRJNA1253303_P_NODE_5586_length_251_cov_0.876404_g5564_i0 | PRJNA1253303 | 5586 | 251 | 0.876404 | 2.19977404 | Chloroflexota bacterium | 2026724 | Bacteria | Bacteria | 97.4 | 1.47e-21 | NR | HEY7063531.1 | 2026724 | g5564 | i0 | 59 | 0.99203187250996006 | 83 | 34 | 99.2 | 0 | 250 | 2 | 99 | 181 | HEY7063531.1 SEC-C domain-containing protein [Chloroflexota bacterium] | diamond | 249 | 97.4 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 29505233 | 29505233 | PRJNA1253303_P_NODE_5130_length_253_cov_0.866667_g5108_i0 | PRJNA1253303 | 5130 | 253 | 0.866667 | 2.19266751 | Chloroflexia bacterium | 2448782 | Bacteria | Bacteria | 74.7 | 8.92e-14 | NR | HEX8231172.1 | 2448782 | g5108 | i0 | 65.6 | 0.758893280632411 | 64 | 22 | 75.9 | 0 | 196 | 5 | 1 | 64 | HEX8231172.1 NERD domain-containing protein [Chloroflexia bacterium] | diamond | 192 | 74.7 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexia | Chloroflexia bacterium | |||||
| 32431365 | 32431365 | PRJNA1253303_P_NODE_6579_length_248_cov_0.891429_g6557_i0 | PRJNA1253303 | 6579 | 248 | 0.891429 | 2.21074392 | Chloroflexota | 200795 | Bacteria | Bacteria | 53.5 | 5.93e-6 | NR | MDE3228633.1 | 2026724 | g6557 | i0 | 37 | 6.7741935483871 | 81 | 45 | 98 | 2 | 247 | 5 | 183 | 257 | MDE3228633.1 cobalamin B12-binding domain-containing protein [Chloroflexota bacterium] | diamond | 1680 | 53.9 | 0.992578849721707 | 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);;