contig_metadata
6 rows where analysis = "blastn", bioproject = "PRJNA340009" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2943098 | 2943098 | PRJNA340009_P_NODE_64403_length_166_cov_0.871795_g64096_i0 | PRJNA340009 | 64403 | 166 | 0.871795 | 1.4471797 | Candidatus Saccharimonadota bacterium | 2026720 | Bacteria | Bacteria | 93.5 | 8.19e-15 | NTclustered | gi|1958118994|gb|CP065013.1| | 2026720 | g64096 | i0 | 86.747 | 5.06024096385542 | 83 | 11 | 50 | 0 | 51 | 133 | 252270 | 252352 | Candidatus Saccharibacteria bacterium isolate Ribe_18-Q3-R11-54_BATAC.540_fly chromosome, complete genome | blastn | 840 | 93.5 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadota bacterium | ||||||
| 6770124 | 6770124 | PRJNA340009_P_NODE_69826_length_164_cov_0.886957_g69519_i0 | PRJNA340009 | 69826 | 164 | 0.886957 | 1.45460948 | Candidatus Saccharibacteria bacterium GW2011_GWC2_44_17 | 1619070 | Bacteria | Bacteria | 202 | 1.28e-47 | NTclustered | gi|837350690|gb|CP011211.1| | 1619070 | g69519 | i0 | 93.382 | 8.35975609756098 | 136 | 9 | 83 | 0 | 18 | 153 | 851544 | 851409 | Candidatus Saccharibacteria bacterium GW2011_GWC2_44_17, complete genome | blastn | 1371 | 202 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharibacteria bacterium GW2011_GWC2_44_17 | ||||||
| 9320003 | 9320003 | PRJNA340009_P_NODE_23588_length_251_cov_5.792079_g23281_i0 | PRJNA340009 | 23588 | 251 | 5.792079 | 14.53811829 | uncultured Candidatus Saccharibacteria bacterium | 179883 | Bacteria | Bacteria | 65.8 | 2.92e-6 | NTclustered | gi|2874253997|emb|OY970322.1| | 179883 | g23281 | i0 | 95.122 | 0.334661354581673 | 41 | 2 | 16 | 0 | 61 | 101 | 529085 | 529125 | MAG: uncultured Candidatus Saccharibacteria bacterium isolate MFD05512.bin.c.2 genome assembly, chromosome: 1 | blastn | 84 | 65.8 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | uncultured Candidatus Saccharibacteria bacterium | ||||||
| 15695016 | 15695016 | PRJNA340009_P_NODE_58273_length_171_cov_4.180328_g57966_i0 | PRJNA340009 | 58273 | 171 | 4.180328 | 7.14836088 | Candidatus Saccharibacteria genomosp. TM7-H1 | 2080739 | Bacteria | Bacteria | 278 | 2.17e-70 | NTclustered | gi|1566427536|gb|CP026537.1| | 2080739 | g57966 | i0 | 95.906 | 1 | 171 | 7 | 100 | 0 | 1 | 171 | 262173 | 262003 | Candidatus Saccharibacteria genomosp. TM7-H1 isolate E1 chromosome | blastn | 171 | 278 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharibacteria genomosp. TM7-H1 | ||||||
| 22068876 | 22068876 | PRJNA340009_P_NODE_59258_length_170_cov_1.685950_g58951_i0 | PRJNA340009 | 59258 | 170 | 1.68595 | 2.866115 | Candidatus Saccharimonadota bacterium | 2026720 | Bacteria | Bacteria | 128 | 2.3e-25 | NTclustered | gi|1950821269|gb|CP066696.1| | 2026720 | g58951 | i0 | 80.357 | 0.988235294117647 | 168 | 33 | 99 | 0 | 3 | 170 | 735444 | 735277 | Candidatus Saccharibacteria bacterium isolate NC_groundwater_1927_Pr3_S-0.2um_48_6 chromosome | blastn | 168 | 128 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadota bacterium | ||||||
| 23344385 | 23344385 | PRJNA340009_P_NODE_64699_length_166_cov_0.871795_g64392_i0 | PRJNA340009 | 64699 | 166 | 0.871795 | 1.4471797 | Candidatus Saccharimonadota bacterium | 2026720 | Bacteria | Bacteria | 119 | 1.35e-22 | NTclustered | gi|1958071672|gb|CP064992.1| | 2026720 | g64392 | i0 | 83.465 | 0.765060240963855 | 127 | 21 | 77 | 0 | 10 | 136 | 315032 | 315158 | Candidatus Saccharibacteria bacterium isolate Hirt_18-Q3-R61-65_BATAC.98_uni chromosome, complete genome | blastn | 127 | 119 | 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);;