contig_metadata
5 rows where bioproject = "PRJNA741997" and tax_phylum = "Candidatus Omnitrophota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 28189336 | 28189336 | PRJNA741997_P_NODE_79706_length_247_cov_0.885057_g78586_i0 | PRJNA741997 | 79706 | 247 | 0.885057 | 2.18609079 | Candidatus Omnitrophota bacterium | 2035772 | Bacteria | Bacteria | 92.4 | 1.25e-19 | NR | MBF0569577.1 | 2035772 | g78586 | i0 | 65.6 | 2.33198380566802 | 64 | 22 | 77.7 | 0 | 245 | 54 | 629 | 692 | MBF0569577.1 phosphoenolpyruvate carboxykinase (ATP) [Candidatus Omnitrophota bacterium] | diamond | 576 | 92.4 | 1 | Bacteria | PVC group | Pseudomonadati | Candidatus Omnitrophota | Candidatus Omnitrophota bacterium | |||||
| 29073830 | 29073830 | PRJNA741997_P_NODE_71848_length_251_cov_0.865169_g70728_i0 | PRJNA741997 | 71848 | 251 | 0.865169 | 2.17157419 | Candidatus Omnitrophota bacterium | 2035772 | Bacteria | Bacteria | 41.2 | 0.0216 | NR | MCA9414572.1 | 2035772 | g70728 | i0 | 38.3 | 0.561752988047809 | 47 | 29 | 56.2 | 0 | 50 | 190 | 8 | 54 | MCA9414572.1 hypothetical protein [Candidatus Omnitrophota bacterium] | diamond | 141 | 41.2 | 1 | Bacteria | PVC group | Pseudomonadati | Candidatus Omnitrophota | Candidatus Omnitrophota bacterium | |||||
| 30757833 | 30757833 | PRJNA741997_P_NODE_76134_length_249_cov_0.875000_g75014_i0 | PRJNA741997 | 76134 | 249 | 0.875 | 2.17875 | Bacteria | 2 | Bacteria | Bacteria | 49.3 | 1.94e-4 | NR | HOW42448.1 | 2035772 | g75014 | i0 | 41.5 | 1.66265060240964 | 65 | 37 | 78.3 | 1 | 218 | 24 | 443 | 506 | HOW42448.1 ATP-binding protein [Candidatus Omnitrophota bacterium] | diamond | 414 | 49.7 | 0.991951710261569 | Bacteria | PVC group | Pseudomonadati | Candidatus Omnitrophota | Candidatus Omnitrophota bacterium | |||||
| 30905758 | 30905758 | PRJNA741997_P_NODE_53174_length_294_cov_1.936652_g52054_i0 | PRJNA741997 | 53174 | 294 | 1.936652 | 5.69375688 | Candidatus Omnitrophota bacterium | 2035772 | Bacteria | Bacteria | 89.4 | 1.11e-19 | NR | MCK5306904.1 | 2035772 | g52054 | i0 | 52.3 | 2.63265306122449 | 88 | 41 | 88.8 | 1 | 293 | 33 | 15 | 102 | MCK5306904.1 translation elongation factor Ts [Candidatus Omnitrophota bacterium] | diamond | 774 | 89.4 | 1 | Bacteria | PVC group | Pseudomonadati | Candidatus Omnitrophota | Candidatus Omnitrophota bacterium | |||||
| 31063845 | 31063845 | PRJNA741997_P_NODE_63875_length_269_cov_1.270408_g62755_i0 | PRJNA741997 | 63875 | 269 | 1.270408 | 3.41739752 | Candidatus Omnitrophota bacterium | 2035772 | Bacteria | Bacteria | 47.8 | 8.52e-4 | NR | NUN94855.1 | 2035772 | g62755 | i0 | 35.7 | 0.780669144981413 | 70 | 43 | 78.1 | 1 | 24 | 233 | 248 | 315 | NUN94855.1 family 43 glycosylhydrolase [Candidatus Omnitrophota bacterium] | diamond | 210 | 47.8 | 1 | Bacteria | PVC group | Pseudomonadati | Candidatus Omnitrophota | Candidatus Omnitrophota 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);;