contig_metadata
7 rows where analysis = "blastn", bioproject = "PRJNA1137393" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5387923 | 5387923 | PRJNA1137393_P_NODE_37545_length_171_cov_1.344262_g37029_i0 | PRJNA1137393 | 37545 | 171 | 1.344262 | 2.29868802 | Candidatus Saccharibacteria bacterium GW2011_GWC2_44_17 | 1619070 | Bacteria | Bacteria | 255 | 1.02e-63 | NTclustered | gi|837350690|gb|CP011211.1| | 1619070 | g37029 | i0 | 93.567 | 5.62573099415205 | 171 | 11 | 100 | 0 | 1 | 171 | 849915 | 850085 | Candidatus Saccharibacteria bacterium GW2011_GWC2_44_17, complete genome | blastn | 962 | 255 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharibacteria bacterium GW2011_GWC2_44_17 | ||||||
| 5388013 | 5388013 | PRJNA1137393_P_NODE_60705_length_164_cov_1.504348_g60189_i0 | PRJNA1137393 | 60705 | 164 | 1.504348 | 2.46713072 | Candidatus Saccharimonadota bacterium | 2026720 | Bacteria | Bacteria | 270 | 3.4699999999999992e-68 | NTclustered | gi|1958123529|gb|CP065016.1| | 2026720 | g60189 | i0 | 96.341 | 37.859756097561 | 164 | 6 | 100 | 0 | 1 | 164 | 636081 | 636244 | Candidatus Saccharibacteria bacterium isolate Vibo_18-Q3-R45-57_BAT3C.117_fly chromosome, complete genome | blastn | 6209 | 270 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadota bacterium | ||||||
| 6134925 | 6134925 | PRJNA1137393_P_NODE_38705_length_170_cov_0.809917_g38189_i0 | PRJNA1137393 | 38705 | 170 | 0.809917 | 1.3768589 | Candidatus Saccharimonas | 1331051 | Bacteria | Bacteria | 259 | 7.8e-65 | NTclustered | gi|499052612|gb|CP005957.1| | 1332188 | g38189 | i0 | 95.679 | 61.6764705882353 | 162 | 6 | 95 | 1 | 1 | 161 | 694875 | 694714 | Candidatus Saccharimonas aalborgensis isolate TM71 chromosome, complete genome | blastn | 10485 | 259 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadia | Candidatus Saccharimonadales | Candidatus Saccharimonadaceae | Candidatus Saccharimonas | Candidatus Saccharimonas aalborgensis | ||
| 8685114 | 8685114 | PRJNA1137393_P_NODE_12367_length_238_cov_3.079365_g11851_i0 | PRJNA1137393 | 12367 | 238 | 3.079365 | 7.3288887 | Bacteria | 2 | Bacteria | Bacteria | 401 | 1.8399999999999994e-107 | NTclustered | gi|1950821269|gb|CP066696.1| | 2026720 | g11851 | i0 | 97.083 | 283.457983193277 | 240 | 3 | 100 | 3 | 1 | 238 | 800134 | 800371 | Candidatus Saccharibacteria bacterium isolate NC_groundwater_1927_Pr3_S-0.2um_48_6 chromosome | blastn | 67463 | 401 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadota bacterium | ||||||
| 14313631 | 14313631 | PRJNA1137393_P_NODE_28732_length_183_cov_2.373134_g28216_i0 | PRJNA1137393 | 28732 | 183 | 2.373134 | 4.34283522 | Candidatus Saccharimonadota bacterium | 2026720 | Bacteria | Bacteria | 270 | 3.949999999999999e-68 | NTclustered | gi|1950821269|gb|CP066696.1| | 2026720 | g28216 | i0 | 93.443 | 60.4590163934426 | 183 | 10 | 99 | 2 | 2 | 183 | 799953 | 800134 | Candidatus Saccharibacteria bacterium isolate NC_groundwater_1927_Pr3_S-0.2um_48_6 chromosome | blastn | 11064 | 270 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadota bacterium | ||||||
| 22708900 | 22708900 | PRJNA1137393_P_NODE_12658_length_236_cov_1.358289_g12142_i0 | PRJNA1137393 | 12658 | 236 | 1.358289 | 3.20556204 | Bacteria | 2 | Bacteria | Bacteria | 387 | 5.11e-103 | NTclustered | gi|837350690|gb|CP011211.1| | 1619070 | g12142 | i0 | 96.186 | 187.525423728814 | 236 | 9 | 100 | 0 | 1 | 236 | 850590 | 850825 | Candidatus Saccharibacteria bacterium GW2011_GWC2_44_17, complete genome | blastn | 44256 | 387 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharibacteria bacterium GW2011_GWC2_44_17 | ||||||
| 23237004 | 23237004 | PRJNA1137393_P_NODE_34159_length_175_cov_1.706349_g33643_i0 | PRJNA1137393 | 34159 | 175 | 1.706349 | 2.98611075 | uncultured Candidatus Saccharibacteria bacterium | 179883 | Bacteria | Bacteria | 313 | 6.13e-81 | NTclustered | gi|2874254031|emb|OY970356.1| | 179883 | g33643 | i0 | 99.419 | 272.811428571429 | 172 | 1 | 98 | 0 | 4 | 175 | 599004 | 598833 | MAG: uncultured Candidatus Saccharibacteria bacterium isolate MFD05684.bin.c.4 genome assembly, chromosome: 1 | blastn | 47742 | 313 | 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);;