contig_metadata
3 rows where bioproject = "PRJNA270367" and tax_phylum = "Candidatus Eiseniibacteriota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 27642900 | 27642900 | PRJNA270367_P_NODE_24804_length_231_cov_1.439560_g24599_i0 | PRJNA270367 | 24804 | 231 | 1.43956 | 3.3253836 | Candidatus Eiseniibacteriota bacterium | 2212470 | Bacteria | Bacteria | 43.1 | 0.0225 | NR | MEZ4649102.1 | 2212470 | g24599 | i0 | 44.2 | 0.558441558441558 | 43 | 24 | 55.8 | 0 | 96 | 224 | 216 | 258 | MEZ4649102.1 type II secretion system F family protein [Candidatus Eiseniibacteriota bacterium] | diamond | 129 | 43.1 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Eiseniibacteriota | Candidatus Eiseniibacteriota bacterium | ||||||
| 28400497 | 28400497 | PRJNA270367_P_NODE_32546_length_193_cov_1.083333_g32341_i0 | PRJNA270367 | 32546 | 193 | 1.083333 | 2.09083269 | Candidatus Eiseniibacteriota bacterium | 2212470 | Bacteria | Bacteria | 47.8 | 3.29e-4 | NR | HXJ34336.1 | 2212470 | g32341 | i0 | 39.7 | 2.7979274611399 | 58 | 35 | 90.2 | 0 | 177 | 4 | 202 | 259 | HXJ34336.1 M12 family metallopeptidase [Candidatus Eiseniibacteriota bacterium] | diamond | 540 | 47.8 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Eiseniibacteriota | Candidatus Eiseniibacteriota bacterium | ||||||
| 29049819 | 29049819 | PRJNA270367_P_NODE_8128_length_472_cov_1.352246_g7929_i0 | PRJNA270367 | 8128 | 472 | 1.352246 | 6.38260112 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 121 | 7.1e-29 | NR | TMQ73064.1 | 2212470 | g7929 | i0 | 44.2 | 1.97033898305085 | 154 | 78 | 97.9 | 4 | 464 | 3 | 79 | 224 | TMQ73064.1 MAG: hypothetical protein E6K81_05775 [Candidatus Eiseniibacteriota bacterium] | diamond | 930 | 121 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Eiseniibacteriota | Candidatus Eiseniibacteriota 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);;