contig_metadata
6 rows where bioproject = "PRJNA724011", tax_clade = "FCB group" and tax_phylum = "Chlorobiota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 24937383 | 24937383 | PRJNA724011_P_NODE_800_length_2756_cov_7.703317_g664_i0 | PRJNA724011 | 800 | 2756 | 7.703317 | 212.30341652 | Prosthecochloris | 1101 | Bacteria | Bacteria | 1295 | 0 | NR | WP_012506171.1 | 1102 | g664 | i0 | 75.1 | 11.0986937590711 | 783 | 193 | 85 | 2 | 2599 | 257 | 14 | 796 | WP_012506171.1 phosphoketolase [Prosthecochloris aestuarii] | diamond | 30588 | 1301 | 0.995388162951576 | Bacteria | FCB group | Pseudomonadati | Chlorobiota | Chlorobiia | Chlorobiales | Chlorobiaceae | Prosthecochloris | Prosthecochloris aestuarii | |
| 27052319 | 27052319 | PRJNA724011_P_NODE_98002_length_248_cov_1.405714_g96979_i0 | PRJNA724011 | 98002 | 248 | 1.405714 | 3.48617072 | Chlorobiales bacterium | 2723030 | Bacteria | Bacteria | 46.6 | 0.00154 | NR | MCX6179188.1 | 2723030 | g96979 | i0 | 35 | 0.725806451612903 | 60 | 38 | 72.6 | 1 | 18 | 197 | 45 | 103 | MCX6179188.1 tetratricopeptide repeat protein [Chlorobiales bacterium] | diamond | 180 | 46.6 | 1 | Bacteria | FCB group | Pseudomonadati | Chlorobiota | Chlorobiia | Chlorobiales | Chlorobiales bacterium | |||
| 27305081 | 27305081 | PRJNA724011_P_NODE_24223_length_578_cov_2.940594_g23207_i0 | PRJNA724011 | 24223 | 578 | 2.940594 | 16.99663332 | Chlorobaculum sp. | 2053530 | Bacteria | Bacteria | 167 | 1.15e-46 | NR | NTW53782.1 | 2053530 | g23207 | i0 | 54.1 | 1.5363321799308 | 148 | 68 | 76.8 | 0 | 2 | 445 | 245 | 392 | NTW53782.1 acetate/propionate family kinase [Chlorobaculum sp.] | diamond | 888 | 167 | 1 | Bacteria | FCB group | Pseudomonadati | Chlorobiota | Chlorobiia | Chlorobiales | Chlorobiaceae | Chlorobaculum | Chlorobaculum sp. | |
| 28094404 | 28094404 | PRJNA724011_P_NODE_26945_length_540_cov_3.299786_g25929_i0 | PRJNA724011 | 26945 | 540 | 3.299786 | 17.8188444 | Chlorobiaceae bacterium | 2067991 | Bacteria | Bacteria | 137 | 4.979999999999998e-35 | NR | MEI7824811.1 | 2067991 | g25929 | i0 | 50.4 | 2.85 | 129 | 63 | 71.7 | 1 | 153 | 539 | 7 | 134 | MEI7824811.1 acetate/propionate family kinase [Chlorobiaceae bacterium] | diamond | 1539 | 137 | 1 | Bacteria | FCB group | Pseudomonadati | Chlorobiota | Chlorobiia | Chlorobiales | Chlorobiaceae | Chlorobiaceae bacterium | ||
| 28441908 | 28441908 | PRJNA724011_P_NODE_37066_length_443_cov_1.402703_g36043_i0 | PRJNA724011 | 37066 | 443 | 1.402703 | 6.21397429 | Chloroherpetonaceae bacterium | 2969135 | Bacteria | Bacteria | 137 | 1.39e-34 | NR | MDW8465497.1 | 2969135 | g36043 | i0 | 49.3 | 4.01580135440181 | 148 | 72 | 98.9 | 2 | 2 | 439 | 462 | 608 | MDW8465497.1 glutamine synthetase III [Chloroherpetonaceae bacterium] | diamond | 1779 | 137 | 1 | Bacteria | FCB group | Pseudomonadati | Chlorobiota | Chlorobiia | Chlorobiales | Chloroherpetonaceae | Chloroherpetonaceae bacterium | ||
| 30410490 | 30410490 | PRJNA724011_P_NODE_57813_length_336_cov_2.300380_g56790_i0 | PRJNA724011 | 57813 | 336 | 2.30038 | 7.7292768 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 82 | 2.33e-16 | NR | RFM23943.1 | 1868324 | g56790 | i0 | 42.6 | 6.78571428571429 | 108 | 60 | 95.5 | 2 | 16 | 336 | 22 | 128 | RFM23943.1 MAG: hypothetical protein D0433_08460 [Candidatus Thermochlorobacter aerophilum] | diamond | 2280 | 82.4 | 0.995145631067961 | Bacteria | FCB group | Pseudomonadati | Chlorobiota | Chlorobiia | Chlorobiales | Candidatus Thermochlorobacteriaceae | Candidatus Thermochlorobacter | Candidatus Thermochlorobacter aerophilus |
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);;