contig_metadata
19 rows where bioproject = "PRJEB10140", tax_clade = "Bacteria candidate phyla" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5115045 | 5115045 | PRJEB10140_P_NODE_269005_length_165_cov_0.896552_g251696_i0 | PRJEB10140 | 269005 | 165 | 0.896552 | 1.4793108 | Candidatus Saccharibacteria bacterium TM7i | 2980174 | Bacteria | Bacteria | 69.4 | 1.37e-7 | NTclustered | gi|2306681518|gb|CP075337.1| | 2980174 | g251696 | i0 | 93.617 | 0.284848484848485 | 47 | 2 | 28 | 1 | 26 | 71 | 664951 | 664905 | Candidatus Saccharibacteria bacterium TM7i chromosome, complete genome | blastn | 47 | 69.4 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharibacteria bacterium TM7i | ||||||
| 24237553 | 24237553 | PRJEB10140_P_NODE_140700_length_262_cov_1.436620_g123393_i0 | PRJEB10140 | 140700 | 262 | 1.43662 | 3.7639444 | uncultured Candidatus Saccharibacteria bacterium | 179883 | Bacteria | Bacteria | 52.8 | 0.024 | NTclustered | gi|2874254068|emb|OY970151.1| | 179883 | g123393 | i0 | 100 | 0.106870229007634 | 28 | 0 | 11 | 0 | 206 | 233 | 294597 | 294624 | MAG: uncultured Candidatus Saccharibacteria bacterium isolate MFD00082.bin.2.65 genome assembly, chromosome: 1 | blastn | 28 | 52.8 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | uncultured Candidatus Saccharibacteria bacterium | ||||||
| 27728001 | 27728001 | PRJEB10140_P_NODE_246964_length_169_cov_0.866667_g229655_i0 | PRJEB10140 | 246964 | 169 | 0.866667 | 1.46466723 | Candidatus Saccharimonadota bacterium | 2026720 | Bacteria | Bacteria | 86.3 | 1.64e-18 | NR | HMS93305.1 | 2026720 | g229655 | i0 | 75 | 0.994082840236686 | 56 | 14 | 99.4 | 0 | 1 | 168 | 29 | 84 | HMS93305.1 prepilin peptidase [Candidatus Saccharibacteria bacterium] | diamond | 168 | 86.3 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadota bacterium | ||||||
| 27853974 | 27853974 | PRJEB10140_P_NODE_77885_length_471_cov_1.879147_g60658_i0 | PRJEB10140 | 77885 | 471 | 1.879147 | 8.85078237 | Candidatus Saccharimonadales bacterium | 2973664 | Bacteria | Bacteria | 56.6 | 5.38e-6 | NR | HSX44433.1 | 2973664 | g60658 | i0 | 35.3 | 0.885350318471338 | 139 | 73 | 84.7 | 6 | 470 | 72 | 193 | 320 | HSX44433.1 fibronectin type III domain-containing protein [Candidatus Saccharimonadales bacterium] | diamond | 417 | 56.6 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadia | Candidatus Saccharimonadales | Candidatus Saccharimonadales bacterium | ||||
| 28232577 | 28232577 | PRJEB10140_P_NODE_255906_length_167_cov_0.881356_g238597_i0 | PRJEB10140 | 255906 | 167 | 0.881356 | 1.47186452 | Candidatus Saccharimonadota bacterium | 2026720 | Bacteria | Bacteria | 102 | 2.63e-24 | NR | MBQ1344292.1 | 2026720 | g238597 | i0 | 96.3 | 0.970059880239521 | 54 | 2 | 97 | 0 | 164 | 3 | 160 | 213 | MBQ1344292.1 MMPL family transporter [Candidatus Saccharibacteria bacterium] | diamond | 162 | 102 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadota bacterium | ||||||
| 28390681 | 28390681 | PRJEB10140_P_NODE_279046_length_164_cov_0.869565_g261737_i0 | PRJEB10140 | 279046 | 164 | 0.869565 | 1.4260866 | Candidatus Saccharimonadota bacterium | 2026720 | Bacteria | Bacteria | 100 | 5.8e-23 | NR | MBR0460625.1 | 2026720 | g261737 | i0 | 83.3 | 1.97560975609756 | 54 | 9 | 98.8 | 0 | 3 | 164 | 361 | 414 | MBR0460625.1 IS3 family transposase [Candidatus Saccharibacteria bacterium] | diamond | 324 | 100 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadota bacterium | ||||||
| 29022570 | 29022570 | PRJEB10140_P_NODE_277128_length_164_cov_0.904348_g259819_i0 | PRJEB10140 | 277128 | 164 | 0.904348 | 1.48313072 | Candidatus Saccharimonadaceae bacterium | 2830836 | Bacteria | Bacteria | 93.6 | 1.57e-20 | NR | MEE0887997.1 | 2830836 | g259819 | i0 | 72.2 | 0.98780487804878 | 54 | 13 | 98.8 | 1 | 164 | 3 | 585 | 636 | MEE0887997.1 hypothetical protein [Candidatus Saccharimonadaceae bacterium] | diamond | 162 | 93.6 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadia | Candidatus Saccharimonadales | Candidatus Saccharimonadaceae | Candidatus Saccharimonadaceae bacterium | |||
| 29117076 | 29117076 | PRJEB10140_P_NODE_257609_length_167_cov_0.881356_g240300_i0 | PRJEB10140 | 257609 | 167 | 0.881356 | 1.47186452 | Candidatus Saccharimonadota bacterium | 2026720 | Bacteria | Bacteria | 43.1 | 0.00974 | NR | MCR5700066.1 | 2026720 | g240300 | i0 | 73.1 | 1.22155688622754 | 26 | 7 | 46.7 | 0 | 4 | 81 | 364 | 389 | MCR5700066.1 cell division protein FtsZ [Candidatus Saccharibacteria bacterium] | diamond | 204 | 43.1 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadota bacterium | ||||||
| 29432343 | 29432343 | PRJEB10140_P_NODE_257150_length_167_cov_0.881356_g239841_i0 | PRJEB10140 | 257150 | 167 | 0.881356 | 1.47186452 | Candidatus Saccharibacteria bacterium | 2026720 | Bacteria | Bacteria | 102 | 1.2699999999999999e-23 | NR | TAH33541.1 | 2026720 | g239841 | i0 | 89.1 | 1.97604790419162 | 55 | 6 | 98.8 | 0 | 3 | 167 | 340 | 394 | TAH33541.1 MAG: ATP-dependent Clp protease ATP-binding subunit [Candidatus Saccharibacteria bacterium] | diamond | 330 | 102 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadota bacterium | ||||||
| 29779983 | 29779983 | PRJEB10140_P_NODE_49851_length_731_cov_2.104106_g34101_i0 | PRJEB10140 | 49851 | 731 | 2.104106 | 15.38101486 | Candidatus Saccharimonadales bacterium | 2973664 | Bacteria | Bacteria | 196 | 3.42e-60 | NR | HUC87392.1 | 2973664 | g34101 | i0 | 63.7 | 2.81532147742818 | 135 | 44 | 55.4 | 1 | 627 | 223 | 3 | 132 | HUC87392.1 peptide-methionine (R)-S-oxide reductase MsrB [Candidatus Saccharimonadales bacterium] | diamond | 2058 | 196 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadia | Candidatus Saccharimonadales | Candidatus Saccharimonadales bacterium | ||||
| 30475110 | 30475110 | PRJEB10140_P_NODE_278413_length_164_cov_0.895652_g261104_i0 | PRJEB10140 | 278413 | 164 | 0.895652 | 1.46886928 | Candidatus Saccharimonadota bacterium | 2026720 | Bacteria | Bacteria | 64.7 | 2.26e-10 | NR | MBC7746903.1 | 2026720 | g261104 | i0 | 57.7 | 1.90243902439024 | 52 | 22 | 95.1 | 0 | 6 | 161 | 421 | 472 | MBC7746903.1 single-stranded-DNA-specific exonuclease RecJ [Candidatus Saccharibacteria bacterium] | diamond | 312 | 64.7 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadota bacterium | ||||||
| 30601229 | 30601229 | PRJEB10140_P_NODE_248073_length_169_cov_0.866667_g230764_i0 | PRJEB10140 | 248073 | 169 | 0.866667 | 1.46466723 | Candidatus Saccharibacteria bacterium 32-5 | 1970481 | Bacteria | Bacteria | 89 | 3.01e-19 | NR | OYX53829.1 | 1970481 | g230764 | i0 | 75 | 0.994082840236686 | 56 | 14 | 99.4 | 0 | 2 | 169 | 228 | 283 | OYX53829.1 MAG: hypothetical protein B7Y92_01290 [Candidatus Saccharibacteria bacterium 32-50-13] | diamond | 168 | 89 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharibacteria bacterium 32-50-13 | ||||||
| 30632777 | 30632777 | PRJEB10140_P_NODE_262933_length_166_cov_0.888889_g245624_i0 | PRJEB10140 | 262933 | 166 | 0.888889 | 1.47555574 | Candidatus Saccharimonadota bacterium | 2026720 | Bacteria | Bacteria | 99.8 | 2.06e-23 | NR | MBQ6313677.1 | 2026720 | g245624 | i0 | 88.9 | 0.975903614457831 | 54 | 6 | 97.6 | 0 | 164 | 3 | 49 | 102 | MBQ6313677.1 hypothetical protein [Candidatus Saccharibacteria bacterium] | diamond | 162 | 99.8 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadota bacterium | ||||||
| 31486529 | 31486529 | PRJEB10140_P_NODE_212316_length_187_cov_1.492754_g195007_i0 | PRJEB10140 | 212316 | 187 | 1.492754 | 2.79144998 | Candidatus Saccharibacteria bacterium 49-2 | 1895829 | Bacteria | Bacteria | 130 | 1.04e-34 | NR | OJU87418.1 | 1895829 | g195007 | i0 | 100 | 0.994652406417112 | 62 | 0 | 99.5 | 0 | 186 | 1 | 173 | 234 | OJU87418.1 MAG: hypothetical protein BGO17_00200 [Candidatus Saccharibacteria bacterium 49-20] | diamond | 186 | 130 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharibacteria bacterium 49-20 | ||||||
| 31486562 | 31486562 | PRJEB10140_P_NODE_259936_length_167_cov_0.864407_g242627_i0 | PRJEB10140 | 259936 | 167 | 0.864407 | 1.44355969 | Candidatus Saccharibacteria bacterium 32-49-1 | 1970478 | Bacteria | Bacteria | 77 | 4.46e-15 | NR | OYW85317.1 | 1970478 | g242627 | i0 | 76.4 | 0.988023952095808 | 55 | 13 | 98.8 | 0 | 1 | 165 | 52 | 106 | OYW85317.1 MAG: hypothetical protein B7Z17_02505, partial [Candidatus Saccharibacteria bacterium 32-49-10] | diamond | 165 | 77 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharibacteria bacterium 32-49-10 | ||||||
| 31606822 | 31606822 | PRJEB10140_P_NODE_217636_length_184_cov_1.496296_g200327_i0 | PRJEB10140 | 217636 | 184 | 1.496296 | 2.75318464 | Candidatus Nanosyncoccus | 2171995 | Bacteria | Bacteria | 116 | 6.18e-29 | NR | MDO4399152.1 | 2026720 | g200327 | i0 | 91.8 | 1.98913043478261 | 61 | 5 | 99.5 | 0 | 1 | 183 | 394 | 454 | MDO4399152.1 OB-fold nucleic acid binding domain-containing protein [Candidatus Saccharibacteria bacterium] | diamond | 366 | 116 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadota bacterium | ||||||
| 32214020 | 32214020 | PRJEB10140_P_NODE_253278_length_168_cov_0.865546_g235969_i0 | PRJEB10140 | 253278 | 168 | 0.865546 | 1.45411728 | Candidatus Saccharimonadota bacterium | 2026720 | Bacteria | Bacteria | 67.8 | 1.94e-11 | NR | MBP9738070.1 | 2026720 | g235969 | i0 | 67.2 | 1.03571428571429 | 58 | 16 | 98.2 | 1 | 2 | 166 | 156 | 213 | MBP9738070.1 DNA translocase FtsK 4TM domain-containing protein [Candidatus Saccharibacteria bacterium] | diamond | 174 | 67.8 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadota bacterium | ||||||
| 32435738 | 32435738 | PRJEB10140_P_NODE_264559_length_166_cov_0.888889_g247250_i0 | PRJEB10140 | 264559 | 166 | 0.888889 | 1.47555574 | Candidatus Nanosynbacter sp. | 2725945 | Bacteria | Bacteria | 118 | 4.39e-31 | NR | MBF1032850.1 | 2725945 | g247250 | i0 | 100 | 0.993975903614458 | 55 | 0 | 99.4 | 0 | 166 | 2 | 32 | 86 | MBF1032850.1 endonuclease/exonuclease/phosphatase family protein [Candidatus Nanosynbacter sp.] | diamond | 165 | 118 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadia | Candidatus Nanosynbacterales | Candidatus Nanosynbacteraceae | Candidatus Nanosynbacter | Candidatus Nanosynbacter sp. | ||
| 32839261 | 32839261 | PRJEB10140_P_NODE_278000_length_164_cov_0.895652_g260691_i0 | PRJEB10140 | 278000 | 164 | 0.895652 | 1.46886928 | Bacteria | 2 | Bacteria | Bacteria | 102 | 9.49e-24 | NR | KKW04829.1 | 1619071 | g260691 | i0 | 88.7 | 2.92682926829268 | 53 | 6 | 97 | 0 | 1 | 159 | 343 | 395 | KKW04829.1 MAG: pyridine nucleotide-disulfide oxidoreductase dimerization region, nonfunctional [Candidatus Saccharibacteria bacterium GW2011_GWC2_48_9] | diamond | 480 | 102 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharibacteria bacterium GW2011_GWC2_48_9 |
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);;