contig_metadata
4 rows where analysis = "diamond", bioproject = "PRJNA1059246" and tax_phylum = "Candidatus Saccharimonadota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 29308986 | 29308986 | PRJNA1059246_P_NODE_26669_length_430_cov_1.282913_g26044_i0 | PRJNA1059246 | 26669 | 430 | 1.282913 | 5.5165259 | Candidatus Saccharibacteria bacterium | 2026720 | Bacteria | Bacteria | 50.4 | 4.34e-4 | NR | QQS70163.1 | 2026720 | g26044 | i0 | 60.8 | 1.47209302325581 | 51 | 14 | 35.6 | 2 | 189 | 341 | 260 | 304 | QQS70163.1 MAG: SHOCT domain-containing protein [Candidatus Saccharibacteria bacterium] | diamond | 633 | 50.4 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadota bacterium | ||||||
| 29561553 | 29561553 | PRJNA1059246_P_NODE_54530_length_275_cov_1.524752_g53904_i0 | PRJNA1059246 | 54530 | 275 | 1.524752 | 4.193068 | Candidatus Saccharimonadota bacterium | 2026720 | Bacteria | Bacteria | 135 | 3.65e-38 | NR | MCA9328072.1 | 2026720 | g53904 | i0 | 71.8 | 0.927272727272727 | 85 | 24 | 92.7 | 0 | 273 | 19 | 32 | 116 | MCA9328072.1 hypothetical protein [Candidatus Saccharibacteria bacterium] | diamond | 255 | 135 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadota bacterium | ||||||
| 30153357 | 30153357 | PRJNA1059246_P_NODE_55532_length_272_cov_1.195980_g54906_i0 | PRJNA1059246 | 55532 | 272 | 1.19598 | 3.2530656 | Bacteria | 2 | Bacteria | Bacteria | 109 | 1.19e-25 | NR | MBC7764264.1 | 2026720 | g54906 | i0 | 64.4 | 9.92647058823529 | 90 | 32 | 99.3 | 0 | 3 | 272 | 74 | 163 | MBC7764264.1 cation:proton antiporter [Candidatus Saccharibacteria bacterium] | diamond | 2700 | 109 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadota bacterium | ||||||
| 32280158 | 32280158 | PRJNA1059246_P_NODE_17579_length_550_cov_0.974843_g16968_i0 | PRJNA1059246 | 17579 | 550 | 0.974843 | 5.3616365 | Candidatus Saccharimonadota bacterium | 2026720 | Bacteria | Bacteria | 109 | 6.6999999999999985e-25 | NR | MCA9334040.1 | 2026720 | g16968 | i0 | 52.3 | 0.583636363636364 | 107 | 51 | 58.4 | 0 | 228 | 548 | 56 | 162 | MCA9334040.1 endonuclease/exonuclease/phosphatase family protein [Candidatus Saccharibacteria bacterium] | diamond | 321 | 109 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadota 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);;