contig_metadata
15 rows where analysis = "diamond", bioproject = "PRJNA627467" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 10803285 | 10803285 | PRJNA627467_P_NODE_12369_length_179_cov_6.615385_g12300_i0 | PRJNA627467 | 12369 | 179 | 6.615385 | 11.84153915 | Candidatus Nanosynsacchari | 2789662 | Bacteria | Bacteria | 115 | 1.98e-29 | NR | WP_129693373.1 | 1986206 | g12300 | i0 | 94.8 | 6.80446927374302 | 58 | 3 | 97.2 | 0 | 1 | 174 | 184 | 241 | WP_129693373.1 UDP-glucose 4-epimerase GalE [Candidatus Nanosynsacchari sp. TM7_ANC_38.39_G1_1] | diamond | 1218 | 116 | 0.991379310344828 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadia | Candidatus Saccharimonadales | Candidatus Saccharimonadaceae | Candidatus Nanosynsacchari | Candidatus Nanosynsacchari sp. TM7_ANC_38.39_G1_1 | ||
| 22276354 | 22276354 | PRJNA627467_P_NODE_4238_length_316_cov_1.794007_g4170_i0 | PRJNA627467 | 4238 | 316 | 1.794007 | 5.66906212 | Candidatus Saccharimonas | 1331051 | Bacteria | Bacteria | 70.1 | 1.76e-11 | NR | RKW04394.1 | 1917697 | g4170 | i0 | 100 | 0.626582278481013 | 33 | 0 | 31.3 | 0 | 315 | 217 | 250 | 282 | RKW04394.1 MAG: glycosyltransferase family 4 protein, partial [Candidatus Saccharimonas sp.] | diamond | 198 | 70.1 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadia | Candidatus Saccharimonadales | Candidatus Saccharimonadaceae | Candidatus Saccharimonas | Candidatus Saccharimonas sp. | ||
| 26637358 | 26637358 | PRJNA627467_P_NODE_12381_length_179_cov_5.184615_g12312_i0 | PRJNA627467 | 12381 | 179 | 5.184615 | 9.28046085 | Candidatus Saccharimonas sp. | 1917697 | Bacteria | Bacteria | 121 | 4.08e-34 | NR | RKW00892.1 | 1917697 | g12312 | i0 | 96.5 | 1.89385474860335 | 57 | 2 | 95.5 | 0 | 173 | 3 | 45 | 101 | RKW00892.1 MAG: hypothetical protein D8B38_05110, partial [Candidatus Saccharimonas sp.] | diamond | 339 | 121 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadia | Candidatus Saccharimonadales | Candidatus Saccharimonadaceae | Candidatus Saccharimonas | Candidatus Saccharimonas sp. | ||
| 27396826 | 27396826 | PRJNA627467_P_NODE_16563_length_166_cov_3.282051_g16494_i0 | PRJNA627467 | 16563 | 166 | 3.282051 | 5.44820466 | Candidatus Saccharimonadota bacterium | 2026720 | Bacteria | Bacteria | 108 | 2.7e-26 | NR | MBB1567060.1 | 2026720 | g16494 | i0 | 100 | 0.975903614457831 | 54 | 0 | 97.6 | 0 | 5 | 166 | 23 | 76 | MBB1567060.1 arginine deiminase [Candidatus Saccharibacteria bacterium] | diamond | 162 | 108 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadota bacterium | ||||||
| 27820083 | 27820083 | PRJNA627467_P_NODE_13204_length_177_cov_1.429688_g13135_i0 | PRJNA627467 | 13204 | 177 | 1.429688 | 2.53054776 | Candidatus Saccharimonadia | 2093818 | Bacteria | Bacteria | 111 | 1.6e-28 | NR | RKW04014.1 | 1917697 | g13135 | i0 | 96.5 | 1.93220338983051 | 57 | 2 | 96.6 | 0 | 5 | 175 | 113 | 169 | RKW04014.1 MAG: glutamate--tRNA ligase, partial [Candidatus Saccharimonas sp.] | diamond | 342 | 111 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadia | Candidatus Saccharimonadales | Candidatus Saccharimonadaceae | Candidatus Saccharimonas | Candidatus Saccharimonas sp. | ||
| 27996703 | 27996703 | PRJNA627467_P_NODE_3725_length_316_cov_1.951311_g3657_i0 | PRJNA627467 | 3725 | 316 | 1.951311 | 6.16614276 | Candidatus Saccharimonadota bacterium | 2026720 | Bacteria | Bacteria | 114 | 9.62e-30 | NR | MBB1567514.1 | 2026720 | g3657 | i0 | 59.6 | 0.987341772151899 | 104 | 12 | 98.7 | 1 | 2 | 313 | 86 | 159 | MBB1567514.1 hypothetical protein [Candidatus Saccharibacteria bacterium] | diamond | 312 | 114 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadota bacterium | ||||||
| 28122892 | 28122892 | PRJNA627467_P_NODE_17045_length_165_cov_3.594828_g16976_i0 | PRJNA627467 | 17045 | 165 | 3.594828 | 5.9314662 | Candidatus Saccharimonadota bacterium | 2026720 | Bacteria | Bacteria | 78.6 | 2.98e-15 | NR | MBN9397727.1 | 2026720 | g16976 | i0 | 75.5 | 0.963636363636364 | 53 | 13 | 96.4 | 0 | 161 | 3 | 457 | 509 | MBN9397727.1 ATP-dependent Clp protease ATP-binding subunit [Candidatus Saccharibacteria bacterium] | diamond | 159 | 78.6 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadota bacterium | ||||||
| 28501839 | 28501839 | PRJNA627467_P_NODE_3647_length_316_cov_1.981273_g3579_i0 | PRJNA627467 | 3647 | 316 | 1.981273 | 6.26082268 | Candidatus Saccharimonadota bacterium | 2026720 | Bacteria | Bacteria | 109 | 4.82e-26 | NR | MBB1567730.1 | 2026720 | g3579 | i0 | 60 | 0.996835443037975 | 105 | 8 | 99.7 | 1 | 1 | 315 | 149 | 219 | MBB1567730.1 glycosyltransferase [Candidatus Saccharibacteria bacterium] | diamond | 315 | 109 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadota bacterium | ||||||
| 29954262 | 29954262 | PRJNA627467_P_NODE_13271_length_176_cov_4.590551_g13202_i0 | PRJNA627467 | 13271 | 176 | 4.590551 | 8.07936976 | Candidatus Saccharimonadota bacterium | 2026720 | Bacteria | Bacteria | 122 | 1.56e-33 | NR | MBB1567684.1 | 2026720 | g13202 | i0 | 100 | 0.971590909090909 | 57 | 0 | 97.2 | 0 | 3 | 173 | 50 | 106 | MBB1567684.1 queuine tRNA-ribosyltransferase family protein [Candidatus Saccharibacteria bacterium] | diamond | 171 | 122 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadota bacterium | ||||||
| 30491396 | 30491396 | PRJNA627467_P_NODE_13893_length_174_cov_3.688000_g13824_i0 | PRJNA627467 | 13893 | 174 | 3.688 | 6.41712 | Candidatus Saccharimonadia bacterium | 2890869 | Bacteria | Bacteria | 44.7 | 0.00306 | NR | HUC95541.1 | 2890869 | g13824 | i0 | 60.6 | 0.568965517241379 | 33 | 13 | 56.9 | 0 | 104 | 6 | 390 | 422 | HUC95541.1 DUF2206 domain-containing protein [Candidatus Saccharimonadia bacterium] | diamond | 99 | 44.7 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadia | Candidatus Saccharimonadia bacterium | |||||
| 31122873 | 31122873 | PRJNA627467_P_NODE_20475_length_156_cov_3.168224_g20406_i0 | PRJNA627467 | 20475 | 156 | 3.168224 | 4.94242944 | Candidatus Saccharimonadota bacterium | 2026720 | Bacteria | Bacteria | 94.7 | 1.8000000000000001e-22 | NR | MBB1557924.1 | 2026720 | g20406 | i0 | 96.1 | 0.980769230769231 | 51 | 2 | 98.1 | 0 | 154 | 2 | 60 | 110 | MBB1557924.1 30S ribosomal protein S3 [Candidatus Saccharibacteria bacterium] | diamond | 153 | 94.7 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadota bacterium | ||||||
| 31186169 | 31186169 | PRJNA627467_P_NODE_17615_length_164_cov_2.582609_g17546_i0 | PRJNA627467 | 17615 | 164 | 2.582609 | 4.23547876 | Candidatus Saccharibacteria bacterium 49-2 | 1895829 | Bacteria | Bacteria | 41.2 | 0.0438 | NR | OJU88105.1 | 1895829 | g17546 | i0 | 61.1 | 0.658536585365854 | 36 | 14 | 65.9 | 0 | 2 | 109 | 224 | 259 | OJU88105.1 MAG: hypothetical protein BGO17_03985 [Candidatus Saccharibacteria bacterium 49-20] | diamond | 108 | 41.2 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharibacteria bacterium 49-20 | ||||||
| 31217631 | 31217631 | PRJNA627467_P_NODE_10875_length_184_cov_6.585185_g10806_i0 | PRJNA627467 | 10875 | 184 | 6.585185 | 12.1167404 | Candidatus Nanosynbacter sp. | 2725945 | Bacteria | Bacteria | 130 | 9.329999999999999e-34 | NR | MBF1032634.1 | 2725945 | g10806 | i0 | 100 | 0.978260869565217 | 60 | 0 | 97.8 | 0 | 5 | 184 | 492 | 551 | MBF1032634.1 aspartate--tRNA ligase [Candidatus Nanosynbacter sp.] | diamond | 180 | 130 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadia | Candidatus Nanosynbacterales | Candidatus Nanosynbacteraceae | Candidatus Nanosynbacter | Candidatus Nanosynbacter sp. | ||
| 31439360 | 31439360 | PRJNA627467_P_NODE_17616_length_164_cov_2.573913_g17547_i0 | PRJNA627467 | 17616 | 164 | 2.573913 | 4.22121732 | Candidatus Nanosynbacter sp. | 2725945 | Bacteria | Bacteria | 111 | 6.79e-27 | NR | MBF1033033.1 | 2725945 | g17547 | i0 | 100 | 0.969512195121951 | 53 | 0 | 97 | 0 | 3 | 161 | 169 | 221 | MBF1033033.1 CTP synthase [Candidatus Nanosynbacter sp.] | diamond | 159 | 111 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadia | Candidatus Nanosynbacterales | Candidatus Nanosynbacteraceae | Candidatus Nanosynbacter | Candidatus Nanosynbacter sp. | ||
| 32008881 | 32008881 | PRJNA627467_P_NODE_4298_length_316_cov_1.779026_g4230_i0 | PRJNA627467 | 4298 | 316 | 1.779026 | 5.62172216 | TM7 phylum sp. oral taxon 346 | 713049 | Bacteria | Bacteria | 65.1 | 1.22e-9 | NR | TWP22153.1 | 713049 | g4230 | i0 | 96.9 | 0.30379746835443 | 32 | 1 | 30.4 | 0 | 218 | 313 | 130 | 161 | TWP22153.1 hypothetical protein EUA61_00190 [TM7 phylum sp. oral taxon 346] | diamond | 96 | 65.1 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | TM7 phylum sp. oral taxon 346 |
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);;