contig_metadata
6 rows where bioproject = "PRJNA751877" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 28600375 | 28600375 | PRJNA751877_P_NODE_23567_length_250_cov_0.870056_g23445_i0 | PRJNA751877 | 23567 | 250 | 0.870056 | 2.17514 | Dehalococcoidales bacterium | 2026733 | Bacteria | Bacteria | 50.1 | 1.07e-4 | NR | MDO9332954.1 | 2026733 | g23445 | i0 | 36.8 | 0.816 | 68 | 41 | 81.6 | 1 | 46 | 249 | 405 | 470 | MDO9332954.1 hypothetical protein [Dehalococcoidales bacterium] | diamond | 204 | 50.1 | 1 | Bacteria | Bacillati | Chloroflexota | Dehalococcoidia | Dehalococcoidales | Dehalococcoidales bacterium | ||||
| 28820964 | 28820964 | PRJNA751877_P_NODE_14268_length_305_cov_0.995690_g14146_i0 | PRJNA751877 | 14268 | 305 | 0.99569 | 3.0368545 | Dehalococcoidia bacterium | 2026734 | Bacteria | Bacteria | 45.1 | 0.0124 | NR | MFA5379264.1 | 2026734 | g14146 | i0 | 30.5 | 3.55081967213115 | 105 | 48 | 90.5 | 3 | 13 | 288 | 1728 | 1820 | MFA5379264.1 PKD domain-containing protein [Dehalococcoidia bacterium] | diamond | 1083 | 45.1 | 1 | Bacteria | Bacillati | Chloroflexota | Dehalococcoidia | Dehalococcoidia bacterium | |||||
| 29989633 | 29989633 | PRJNA751877_P_NODE_26591_length_246_cov_0.890173_g26469_i0 | PRJNA751877 | 26591 | 246 | 0.890173 | 2.18982558 | Bellilinea sp. | 2838785 | Bacteria | Bacteria | 108 | 7.36e-26 | NR | HMN14775.1 | 2838785 | g26469 | i0 | 84.7 | 0.719512195121951 | 59 | 9 | 72 | 0 | 70 | 246 | 278 | 336 | HMN14775.1 IS256 family transposase [Bellilinea sp.] | diamond | 177 | 108 | 1 | Bacteria | Bacillati | Chloroflexota | Anaerolineae | Anaerolineales | Anaerolineaceae | Bellilinea | Bellilinea sp. | ||
| 30147292 | 30147292 | PRJNA751877_P_NODE_26972_length_245_cov_0.895349_g26850_i0 | PRJNA751877 | 26972 | 245 | 0.895349 | 2.19360505 | Dehalococcoidales bacterium | 2026733 | Bacteria | Bacteria | 49.3 | 1.85e-4 | NR | MDO9332954.1 | 2026733 | g26850 | i0 | 32.5 | 0.979591836734694 | 80 | 52 | 98 | 1 | 1 | 240 | 405 | 482 | MDO9332954.1 hypothetical protein [Dehalococcoidales bacterium] | diamond | 240 | 49.3 | 1 | Bacteria | Bacillati | Chloroflexota | Dehalococcoidia | Dehalococcoidales | Dehalococcoidales bacterium | ||||
| 30210540 | 30210540 | PRJNA751877_P_NODE_5152_length_431_cov_1.656425_g5030_i0 | PRJNA751877 | 5152 | 431 | 1.656425 | 7.13919175 | Anaerolineae bacterium | 2052143 | Bacteria | Bacteria | 87 | 6.84e-19 | NR | MCW5848612.1 | 2052143 | g5030 | i0 | 43.2 | 0.918793503480278 | 132 | 66 | 91.2 | 4 | 406 | 14 | 1 | 124 | MCW5848612.1 profilin [Anaerolineae bacterium] | diamond | 396 | 87 | 1 | Bacteria | Bacillati | Chloroflexota | Anaerolineae | Anaerolineae bacterium | |||||
| 31189850 | 31189850 | PRJNA751877_P_NODE_28475_length_243_cov_0.905882_g28353_i0 | PRJNA751877 | 28475 | 243 | 0.905882 | 2.20129326 | Chloroflexota bacterium | 2026724 | Bacteria | Bacteria | 99 | 2.26e-22 | NR | MEP7286046.1 | 2026724 | g28353 | i0 | 62.5 | 4.8641975308642 | 80 | 30 | 98.8 | 0 | 241 | 2 | 140 | 219 | MEP7286046.1 5-(carboxyamino)imidazole ribonucleotide synthase [Chloroflexota bacterium] | diamond | 1182 | 99 | 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);;