contig_metadata
7 rows where 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 7829672 | 7829672 | PRJNA1059246_P_NODE_39327_length_340_cov_1.696629_g38701_i0 | PRJNA1059246 | 39327 | 340 | 1.696629 | 5.7685386 | Candidatus Nanosynbacter sp. HMT-348_TM7c-JB | 2933970 | Bacteria | Bacteria | 52.8 | 0.032 | NTclustered | gi|2179907571|gb|CP090820.1| | 2933970 | g38701 | i0 | 100 | 0.0823529411764706 | 28 | 0 | 8 | 0 | 139 | 166 | 565731 | 565704 | MAG: Candidatus Nanosynbacter sp. HMT-348_TM7c-JB isolate JCVI_32_bin.19 chromosome, complete genome | blastn | 28 | 52.8 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadia | Candidatus Nanosynbacterales | Candidatus Nanosynbacteraceae | Candidatus Nanosynbacter | Candidatus Nanosynbacter sp. HMT-348_TM7c-JB | ||
| 12930698 | 12930698 | PRJNA1059246_P_NODE_32851_length_379_cov_1.009804_g32225_i0 | PRJNA1059246 | 32851 | 379 | 1.009804 | 3.82715716 | Candidatus Saccharimonadota bacterium | 2026720 | Bacteria | Bacteria | 475 | 1.8099999999999994e-129 | NTclustered | gi|1950821269|gb|CP066696.1| | 2026720 | g32225 | i0 | 89.6 | 69.7810026385224 | 375 | 37 | 99 | 2 | 1 | 374 | 800138 | 799765 | Candidatus Saccharibacteria bacterium isolate NC_groundwater_1927_Pr3_S-0.2um_48_6 chromosome | blastn | 26447 | 475 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadota bacterium | ||||||
| 16313916 | 16313916 | PRJNA1059246_P_NODE_39573_length_339_cov_1.157895_g38947_i0 | PRJNA1059246 | 39573 | 339 | 1.157895 | 3.92526405 | Candidatus Saccharimonas | 1331051 | Bacteria | Bacteria | 531 | 3.37e-146 | NTclustered | gi|499052612|gb|CP005957.1| | 1332188 | g38947 | i0 | 94.985 | 69.259587020649 | 339 | 15 | 100 | 2 | 1 | 339 | 696176 | 696512 | Candidatus Saccharimonas aalborgensis isolate TM71 chromosome, complete genome | blastn | 23479 | 531 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadia | Candidatus Saccharimonadales | Candidatus Saccharimonadaceae | Candidatus Saccharimonas | Candidatus Saccharimonas aalborgensis | ||
| 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);;