contig_metadata
10 rows where analysis = "blastn", bioproject = "PRJNA312107" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 377532 | 377532 | PRJNA312107_P_NODE_17221_length_176_cov_1.236220_g17055_i0 | PRJNA312107 | 17221 | 176 | 1.23622 | 2.1757472 | Candidatus Saccharimonadota bacterium | 2026720 | Bacteria | Bacteria | 313 | 6.1699999999999985e-81 | NTclustered | gi|1950821269|gb|CP066696.1| | 2026720 | g17055 | i0 | 98.857 | 172.346590909091 | 175 | 2 | 99 | 0 | 1 | 175 | 798979 | 799153 | Candidatus Saccharibacteria bacterium isolate NC_groundwater_1927_Pr3_S-0.2um_48_6 chromosome | blastn | 30333 | 313 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadota bacterium | ||||||
| 377539 | 377539 | PRJNA312107_P_NODE_18341_length_170_cov_1.388430_g18175_i0 | PRJNA312107 | 18341 | 170 | 1.38843 | 2.360331 | Candidatus Saccharimonadota bacterium | 2026720 | Bacteria | Bacteria | 287 | 3.58e-73 | NTclustered | gi|1950821269|gb|CP066696.1| | 2026720 | g18175 | i0 | 97.059 | 74.5823529411765 | 170 | 5 | 100 | 0 | 1 | 170 | 799800 | 799969 | Candidatus Saccharibacteria bacterium isolate NC_groundwater_1927_Pr3_S-0.2um_48_6 chromosome | blastn | 12679 | 287 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadota bacterium | ||||||
| 5481038 | 5481038 | PRJNA312107_P_NODE_18885_length_169_cov_0.866667_g18719_i0 | PRJNA312107 | 18885 | 169 | 0.866667 | 1.46466723 | Candidatus Saccharimonadia bacterium | 2890869 | Bacteria | Bacteria | 97.1 | 6.43e-16 | NTclustered | gi|2874254002|emb|OY970327.1| | 2890869 | g18719 | i0 | 85.106 | 0.556213017751479 | 94 | 14 | 56 | 0 | 8 | 101 | 143337 | 143244 | MAG: Candidatus Saccharimonadia bacterium isolate MFD01275.bin.c.7 genome assembly, chromosome: 1 | blastn | 94 | 97.1 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadia | Candidatus Saccharimonadia bacterium | |||||
| 9991799 | 9991799 | PRJNA312107_P_NODE_24248_length_164_cov_0.860870_g24082_i0 | PRJNA312107 | 24248 | 164 | 0.86087 | 1.4118268 | Candidatus Saccharimonas | 1331051 | Bacteria | Bacteria | 265 | 1.6199999999999998e-66 | NTclustered | gi|499052612|gb|CP005957.1| | 1332188 | g24082 | i0 | 95.732 | 125.359756097561 | 164 | 7 | 100 | 0 | 1 | 164 | 696963 | 696800 | Candidatus Saccharimonas aalborgensis isolate TM71 chromosome, complete genome | blastn | 20559 | 265 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadia | Candidatus Saccharimonadales | Candidatus Saccharimonadaceae | Candidatus Saccharimonas | Candidatus Saccharimonas aalborgensis | ||
| 11856209 | 11856209 | PRJNA312107_P_NODE_18310_length_170_cov_1.619835_g18144_i0 | PRJNA312107 | 18310 | 170 | 1.619835 | 2.7537195 | Candidatus Saccharibacteria bacterium oral taxon 955 | 2572087 | Bacteria | Bacteria | 226 | 7.919999999999998e-55 | NTclustered | gi|1663049602|gb|CP040008.1| | 2572087 | g18144 | i0 | 90.643 | 26.3823529411765 | 171 | 14 | 100 | 2 | 1 | 170 | 139108 | 139277 | Candidatus Saccharibacteria bacterium oral taxon 955 strain PM004 chromosome, complete genome | blastn | 4485 | 226 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharibacteria bacterium oral taxon 955 | ||||||
| 13131317 | 13131317 | PRJNA312107_P_NODE_16351_length_181_cov_1.265152_g16185_i0 | PRJNA312107 | 16351 | 181 | 1.265152 | 2.28992512 | uncultured Candidatus Saccharibacteria bacterium | 179883 | Bacteria | Bacteria | 263 | 6.519999999999999e-66 | NTclustered | gi|619533766|dbj|AB862054.1| | 179883 | g16185 | i0 | 93.296 | 99.7348066298343 | 179 | 11 | 98 | 1 | 1 | 178 | 707 | 885 | Uncultured Candidatus Saccharibacteria bacterium gene for 16S ribosomal RNA, partial sequence, clone: EBM-E9 | blastn | 18052 | 263 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | uncultured Candidatus Saccharibacteria bacterium | ||||||
| 16954906 | 16954906 | PRJNA312107_P_NODE_16674_length_179_cov_1.323077_g16508_i0 | PRJNA312107 | 16674 | 179 | 1.323077 | 2.36830783 | Candidatus Saccharibacteria bacterium GW2011_GWC2_44_17 | 1619070 | Bacteria | Bacteria | 246 | 6.48e-61 | NTclustered | gi|837350690|gb|CP011211.1| | 1619070 | g16508 | i0 | 92.529 | 236.173184357542 | 174 | 9 | 97 | 4 | 1 | 174 | 851032 | 851201 | Candidatus Saccharibacteria bacterium GW2011_GWC2_44_17, complete genome | blastn | 42275 | 246 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharibacteria bacterium GW2011_GWC2_44_17 | ||||||
| 18229339 | 18229339 | PRJNA312107_P_NODE_26095_length_162_cov_0.920354_g25929_i0 | PRJNA312107 | 26095 | 162 | 0.920354 | 1.49097348 | Candidatus Saccharibacteria bacterium GW2011_GWC2_44_17 | 1619070 | Bacteria | Bacteria | 185 | 1.2699999999999999e-42 | NTclustered | gi|837350690|gb|CP011211.1| | 1619070 | g25929 | i0 | 87.975 | 12.3827160493827 | 158 | 17 | 97 | 2 | 6 | 162 | 850101 | 849945 | Candidatus Saccharibacteria bacterium GW2011_GWC2_44_17, complete genome | blastn | 2006 | 185 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharibacteria bacterium GW2011_GWC2_44_17 | ||||||
| 18914979 | 18914979 | PRJNA312107_P_NODE_24575_length_163_cov_0.912281_g24409_i0 | PRJNA312107 | 24575 | 163 | 0.912281 | 1.48701803 | Candidatus Nanosynbacteraceae | 2093822 | Bacteria | Bacteria | 93.5 | 8.01e-15 | NTclustered | gi|2306607015|emb|OX335598.1| | 2026720 | g24409 | i0 | 92.308 | 10.5705521472393 | 65 | 5 | 40 | 0 | 8 | 72 | 563565 | 563501 | Candidatus Saccharibacteria bacterium isolate PRJEB56001 genome assembly, chromosome: contig00001 | blastn | 1723 | 93.5 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadota bacterium | ||||||
| 22054091 | 22054091 | PRJNA312107_P_NODE_15698_length_185_cov_0.764706_g15532_i0 | PRJNA312107 | 15698 | 185 | 0.764706 | 1.4147061 | uncultured Candidatus Saccharibacteria bacterium | 179883 | Bacteria | Bacteria | 276 | 8.61e-70 | NTclustered | gi|2874254068|emb|OY970151.1| | 179883 | g15532 | i0 | 93.514 | 33.3351351351351 | 185 | 12 | 100 | 0 | 1 | 185 | 658614 | 658430 | MAG: uncultured Candidatus Saccharibacteria bacterium isolate MFD00082.bin.2.65 genome assembly, chromosome: 1 | blastn | 6167 | 276 | 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);;