contig_metadata
9 rows where analysis = "blastn", bioproject = "PRJNA493827" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 8123164 | 8123164 | PRJNA493827_P_NODE_128467_length_301_cov_3.127193_g126269_i0 | PRJNA493827 | 128467 | 301 | 3.127193 | 9.41285093 | Candidatus Saccharimonadota bacterium | 2026720 | Bacteria | Bacteria | 551 | 2.2699999999999992e-152 | NTclustered | gi|1950821269|gb|CP066696.1| | 2026720 | g126269 | i0 | 99.668 | 131.614617940199 | 301 | 1 | 100 | 0 | 1 | 301 | 799028 | 799328 | Candidatus Saccharibacteria bacterium isolate NC_groundwater_1927_Pr3_S-0.2um_48_6 chromosome | blastn | 39616 | 551 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadota bacterium | ||||||
| 8123739 | 8123739 | PRJNA493827_P_NODE_15467_length_1019_cov_1.784355_g13868_i0 | PRJNA493827 | 15467 | 1019 | 1.784355 | 18.18257745 | Candidatus Saccharibacteria bacterium GW2011_GWC2_44_17 | 1619070 | Bacteria | Bacteria | 1772 | 0 | NTclustered | gi|837350690|gb|CP011211.1| | 1619070 | g13868 | i0 | 98.041 | 353.62806673209 | 1021 | 17 | 100 | 3 | 1 | 1019 | 851479 | 850460 | Candidatus Saccharibacteria bacterium GW2011_GWC2_44_17, complete genome | blastn | 360347 | 1772 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharibacteria bacterium GW2011_GWC2_44_17 | ||||||
| 9399700 | 9399700 | PRJNA493827_P_NODE_200428_length_248_cov_0.880000_g198230_i0 | PRJNA493827 | 200428 | 248 | 0.88 | 2.1824 | Candidatus Saccharibacteria bacterium GW2011_GWC2_44_17 | 1619070 | Bacteria | Bacteria | 442 | 1.1399999999999995e-119 | NTclustered | gi|837350690|gb|CP011211.1| | 1619070 | g198230 | i0 | 98.79 | 1 | 248 | 3 | 100 | 0 | 1 | 248 | 343569 | 343816 | Candidatus Saccharibacteria bacterium GW2011_GWC2_44_17, complete genome | blastn | 248 | 442 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharibacteria bacterium GW2011_GWC2_44_17 | ||||||
| 11951161 | 11951161 | PRJNA493827_P_NODE_239050_length_226_cov_2.013072_g236851_i0 | PRJNA493827 | 239050 | 226 | 2.013072 | 4.54954272 | Candidatus Mycosynbacter amalyticus | 2665156 | Bacteria | Bacteria | 355 | 1.37e-93 | NTclustered | gi|1799615131|gb|CP045921.1| | 2665156 | g236851 | i0 | 95.197 | 264.62389380531 | 229 | 4 | 99 | 5 | 1 | 225 | 221234 | 221009 | Candidatus Mycosynbacter amalyticus isolate JR1 chromosome, complete genome | blastn | 59805 | 355 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Mycosynbacter | Candidatus Mycosynbacter amalyticus | |||||
| 11952626 | 11952626 | PRJNA493827_P_NODE_79990_length_385_cov_1.480769_g77792_i0 | PRJNA493827 | 79990 | 385 | 1.480769 | 5.70096065 | Candidatus Saccharibacteria bacterium TM7i | 2980174 | Bacteria | Bacteria | 381 | 4.129999999999999e-101 | NTclustered | gi|2306681518|gb|CP075337.1| | 2980174 | g77792 | i0 | 85.106 | 1.23896103896104 | 376 | 53 | 98 | 2 | 1 | 376 | 156589 | 156217 | Candidatus Saccharibacteria bacterium TM7i chromosome, complete genome | blastn | 477 | 381 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharibacteria bacterium TM7i | ||||||
| 13225425 | 13225425 | PRJNA493827_P_NODE_199071_length_248_cov_0.880000_g196873_i0 | PRJNA493827 | 199071 | 248 | 0.88 | 2.1824 | Candidatus Saccharibacteria bacterium GW2011_GWC2_44_17 | 1619070 | Bacteria | Bacteria | 436 | 5.3e-118 | NTclustered | gi|837350690|gb|CP011211.1| | 1619070 | g196873 | i0 | 98.387 | 1 | 248 | 4 | 100 | 0 | 1 | 248 | 633720 | 633967 | Candidatus Saccharibacteria bacterium GW2011_GWC2_44_17, complete genome | blastn | 248 | 436 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharibacteria bacterium GW2011_GWC2_44_17 | ||||||
| 13858737 | 13858737 | PRJNA493827_P_NODE_171931_length_261_cov_1.196809_g169733_i0 | PRJNA493827 | 171931 | 261 | 1.196809 | 3.12367149 | Candidatus Saccharimonas | 1331051 | Bacteria | Bacteria | 333 | 7.589999999999999e-87 | NTclustered | gi|499052612|gb|CP005957.1| | 1332188 | g169733 | i0 | 89.734 | 53.911877394636 | 263 | 23 | 100 | 4 | 1 | 261 | 696231 | 696491 | Candidatus Saccharimonas aalborgensis isolate TM71 chromosome, complete genome | blastn | 14071 | 333 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadia | Candidatus Saccharimonadales | Candidatus Saccharimonadaceae | Candidatus Saccharimonas | Candidatus Saccharimonas aalborgensis | ||
| 15773938 | 15773938 | PRJNA493827_P_NODE_184993_length_251_cov_0.865169_g182795_i0 | PRJNA493827 | 184993 | 251 | 0.865169 | 2.17157419 | Candidatus Saccharibacteria bacterium TM7i | 2980174 | Bacteria | Bacteria | 110 | 1.33e-19 | NTclustered | gi|2306681518|gb|CP075337.1| | 2980174 | g182795 | i0 | 92.208 | 0.306772908366534 | 77 | 6 | 31 | 0 | 84 | 160 | 562367 | 562443 | Candidatus Saccharibacteria bacterium TM7i chromosome, complete genome | blastn | 77 | 110 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharibacteria bacterium TM7i | ||||||
| 18957931 | 18957931 | PRJNA493827_P_NODE_98775_length_345_cov_1.000000_g96577_i0 | PRJNA493827 | 98775 | 345 | 1 | 3.45 | Bacteria | 2 | Bacteria | Bacteria | 429 | 1.29e-115 | NTclustered | gi|2874253997|emb|OY970322.1| | 179883 | g96577 | i0 | 89.565 | 361.017391304348 | 345 | 26 | 99 | 6 | 1 | 344 | 418116 | 418451 | MAG: uncultured Candidatus Saccharibacteria bacterium isolate MFD05512.bin.c.2 genome assembly, chromosome: 1 | blastn | 124551 | 429 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | uncultured Candidatus Saccharibacteria 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);;