contig_metadata
21 rows where analysis = "diamond", bioproject = "PRJNA681822" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4483093 | 4483093 | PRJNA681822_P_NODE_390104_length_250_cov_1.740113_g388615_i0 | PRJNA681822 | 390104 | 250 | 1.740113 | 4.3502825 | Candidatus Saccharimonadaceae | 2171986 | Bacteria | Bacteria | 158 | 3.75e-44 | NR | TWO86928.1 | 713057 | g388615 | i0 | 100 | 2.952 | 82 | 0 | 98.4 | 0 | 248 | 3 | 219 | 300 | TWO86928.1 PAS domain-containing protein, partial [TM7 phylum sp. oral taxon 356] | diamond | 738 | 158 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | TM7 phylum sp. oral taxon 356 | ||||||
| 9582834 | 9582834 | PRJNA681822_P_NODE_318928_length_269_cov_1.556122_g317439_i0 | PRJNA681822 | 318928 | 269 | 1.556122 | 4.18596818 | Candidatus Saccharibacteria bacterium 49-2 | 1895829 | Bacteria | Bacteria | 166 | 9.93e-46 | NR | OJU88102.1 | 1895829 | g317439 | i0 | 93.2 | 3.92565055762082 | 88 | 6 | 98.1 | 0 | 5 | 268 | 373 | 460 | OJU88102.1 MAG: ribonucleoside-diphosphate reductase subunit alpha [Candidatus Saccharibacteria bacterium 49-20] | diamond | 1056 | 166 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharibacteria bacterium 49-20 | ||||||
| 19780309 | 19780309 | PRJNA681822_P_NODE_246536_length_287_cov_1.495327_g245047_i0 | PRJNA681822 | 246536 | 287 | 1.495327 | 4.29158849 | Candidatus Saccharimonadota bacterium | 2026720 | Bacteria | Bacteria | 178 | 1.05e-50 | NR | MDB5180585.1 | 2026720 | g245047 | i0 | 95.8 | 4.96515679442509 | 95 | 4 | 99.3 | 0 | 286 | 2 | 58 | 152 | MDB5180585.1 lepA [Candidatus Saccharibacteria bacterium] | diamond | 1425 | 178 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadota bacterium | ||||||
| 26733450 | 26733450 | PRJNA681822_P_NODE_328401_length_266_cov_2.279793_g326912_i0 | PRJNA681822 | 328401 | 266 | 2.279793 | 6.06424938 | Candidatus Saccharimonadota bacterium | 2026720 | Bacteria | Bacteria | 53.9 | 5.71e-6 | NR | MBQ3310306.1 | 2026720 | g326912 | i0 | 39.3 | 1.3984962406015 | 84 | 37 | 94.7 | 2 | 253 | 2 | 580 | 649 | MBQ3310306.1 hypothetical protein [Candidatus Saccharibacteria bacterium] | diamond | 372 | 53.9 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadota bacterium | ||||||
| 27082017 | 27082017 | PRJNA681822_P_NODE_372742_length_254_cov_1.143646_g371253_i0 | PRJNA681822 | 372742 | 254 | 1.143646 | 2.90486084 | Candidatus Saccharimonadales bacterium | 2973664 | Bacteria | Bacteria | 42.7 | 0.0402 | NR | HUY25280.1 | 2973664 | g371253 | i0 | 48.9 | 0.55511811023622 | 47 | 21 | 52 | 1 | 228 | 97 | 257 | 303 | HUY25280.1 IS3 family transposase [Candidatus Saccharimonadales bacterium] | diamond | 141 | 42.7 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadia | Candidatus Saccharimonadales | Candidatus Saccharimonadales bacterium | ||||
| 27239971 | 27239971 | PRJNA681822_P_NODE_332923_length_265_cov_1.604167_g331434_i0 | PRJNA681822 | 332923 | 265 | 1.604167 | 4.25104255 | Candidatus Nanogingivalaceae bacterium | 2725942 | Bacteria | Bacteria | 146 | 4.71e-40 | NR | MCD1275964.1 | 2725942 | g331434 | i0 | 98.8 | 0.905660377358491 | 80 | 1 | 90.6 | 0 | 26 | 265 | 11 | 90 | MCD1275964.1 type II secretion system F family protein [Candidatus Nanogingivalaceae bacterium] | diamond | 240 | 146 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Nanosyncoccalia | Candidatus Nanogingivales | Candidatus Nanogingivalaceae | Candidatus Nanogingivalaceae bacterium | |||
| 27366754 | 27366754 | PRJNA681822_P_NODE_331803_length_265_cov_2.411458_g330314_i0 | PRJNA681822 | 331803 | 265 | 2.411458 | 6.3903637 | Candidatus Saccharimonadota bacterium | 2026720 | Bacteria | Bacteria | 153 | 3.7699999999999996e-42 | NR | MCA9332157.1 | 2026720 | g330314 | i0 | 83 | 0.99622641509434 | 88 | 15 | 99.6 | 0 | 265 | 2 | 41 | 128 | MCA9332157.1 sugar transferase [Candidatus Saccharibacteria bacterium] | diamond | 264 | 153 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadota bacterium | ||||||
| 27682595 | 27682595 | PRJNA681822_P_NODE_356544_length_258_cov_2.464865_g355055_i0 | PRJNA681822 | 356544 | 258 | 2.464865 | 6.3593517 | Candidatus Saccharimonadota bacterium | 2026720 | Bacteria | Bacteria | 50.4 | 8.47e-5 | NR | MDB5180874.1 | 2026720 | g355055 | i0 | 50 | 0.534883720930233 | 46 | 23 | 53.5 | 0 | 110 | 247 | 1 | 46 | MDB5180874.1 putative sensor protein [Candidatus Saccharibacteria bacterium] | diamond | 138 | 50.4 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadota bacterium | ||||||
| 28598016 | 28598016 | PRJNA681822_P_NODE_371147_length_254_cov_1.701657_g369658_i0 | PRJNA681822 | 371147 | 254 | 1.701657 | 4.32220878 | Candidatus Nanosynsacchari sp. TM7_ANC_38.39_G1_1 | 1986206 | Bacteria | Bacteria | 166 | 1.01e-45 | NR | WP_129692997.1 | 1986206 | g369658 | i0 | 97.6 | 0.992125984251969 | 84 | 2 | 99.2 | 0 | 253 | 2 | 354 | 437 | WP_129692997.1 cation-translocating P-type ATPase [Candidatus Nanosynsacchari sp. TM7_ANC_38.39_G1_1] | diamond | 252 | 166 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadia | Candidatus Saccharimonadales | Candidatus Saccharimonadaceae | Candidatus Nanosynsacchari | Candidatus Nanosynsacchari sp. TM7_ANC_38.39_G1_1 | ||
| 29260759 | 29260759 | PRJNA681822_P_NODE_432969_length_246_cov_0.890173_g431480_i0 | PRJNA681822 | 432969 | 246 | 0.890173 | 2.18982558 | Candidatus Saccharimonadota bacterium | 2026720 | Bacteria | Bacteria | 77.8 | 1.73e-14 | NR | MBB1562024.1 | 2026720 | g431480 | i0 | 100 | 0.51219512195122 | 42 | 0 | 51.2 | 0 | 126 | 1 | 1 | 42 | MBB1562024.1 sortase [Candidatus Saccharibacteria bacterium] | diamond | 126 | 77.8 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadota bacterium | ||||||
| 30062008 | 30062008 | PRJNA681822_P_NODE_419911_length_247_cov_1.718391_g418422_i0 | PRJNA681822 | 419911 | 247 | 1.718391 | 4.24442577 | Bacteria | 2 | Bacteria | Bacteria | 107 | 2.57e-28 | NR | AHB41883.1 | 1394711 | g418422 | i0 | 89.8 | 2.81781376518219 | 59 | 6 | 71.7 | 0 | 178 | 2 | 2 | 60 | AHB41883.1 RNP-1 like protein RNA-binding protein [Candidatus Saccharibacteria bacterium RAAC3_TM7_1] | diamond | 696 | 107 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharibacteria bacterium RAAC3_TM7_1 | ||||||
| 30555769 | 30555769 | PRJNA681822_P_NODE_444113_length_245_cov_0.895349_g442624_i0 | PRJNA681822 | 444113 | 245 | 0.895349 | 2.19360505 | Candidatus Saccharimonadota bacterium | 2026720 | Bacteria | Bacteria | 172 | 7.54e-53 | NR | MBB1544533.1 | 2026720 | g442624 | i0 | 97.5 | 0.991836734693878 | 81 | 2 | 99.2 | 0 | 244 | 2 | 71 | 151 | MBB1544533.1 anaerobic ribonucleoside-triphosphate reductase activating protein [Candidatus Saccharibacteria bacterium] | diamond | 243 | 172 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadota bacterium | ||||||
| 30745523 | 30745523 | PRJNA681822_P_NODE_403354_length_249_cov_0.875000_g401865_i0 | PRJNA681822 | 403354 | 249 | 0.875 | 2.17875 | Candidatus Saccharimonadota bacterium | 2026720 | Bacteria | Bacteria | 84.3 | 9.11e-17 | NR | NCQ53889.1 | 2026720 | g401865 | i0 | 55.8 | 2.04819277108434 | 86 | 33 | 97.6 | 3 | 244 | 2 | 771 | 856 | NCQ53889.1 ATP-dependent helicase [Candidatus Saccharibacteria bacterium] | diamond | 510 | 84.3 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadota bacterium | ||||||
| 30777190 | 30777190 | PRJNA681822_P_NODE_336854_length_264_cov_1.612565_g335365_i0 | PRJNA681822 | 336854 | 264 | 1.612565 | 4.2571716 | Candidatus Saccharimonadota bacterium | 2026720 | Bacteria | Bacteria | 102 | 4.66e-24 | NR | MDB5180741.1 | 2026720 | g335365 | i0 | 62.8 | 0.977272727272727 | 86 | 31 | 97.7 | 1 | 2 | 259 | 196 | 280 | MDB5180741.1 hypothetical protein [Candidatus Saccharibacteria bacterium] | diamond | 258 | 102 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadota bacterium | ||||||
| 31124309 | 31124309 | PRJNA681822_P_NODE_426855_length_247_cov_0.885057_g425366_i0 | PRJNA681822 | 426855 | 247 | 0.885057 | 2.18609079 | Candidatus Saccharibacteria bacterium 49-2 | 1895829 | Bacteria | Bacteria | 48.9 | 1.59e-4 | NR | OJU87784.1 | 1895829 | g425366 | i0 | 42.9 | 0.850202429149798 | 70 | 40 | 85 | 0 | 235 | 26 | 8 | 77 | OJU87784.1 MAG: hypothetical protein BGO17_02250 [Candidatus Saccharibacteria bacterium 49-20] | diamond | 210 | 48.9 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharibacteria bacterium 49-20 | ||||||
| 31187551 | 31187551 | PRJNA681822_P_NODE_479715_length_241_cov_0.916667_g478225_i0 | PRJNA681822 | 479715 | 241 | 0.916667 | 2.20916747 | Candidatus Saccharimonadota bacterium | 2026720 | Bacteria | Bacteria | 87.8 | 8.84e-20 | NR | HMS92841.1 | 2026720 | g478225 | i0 | 53.9 | 1.89211618257261 | 76 | 35 | 94.6 | 0 | 13 | 240 | 61 | 136 | HMS92841.1 hypothetical protein [Candidatus Saccharibacteria bacterium] | diamond | 456 | 87.8 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadota bacterium | ||||||
| 31262823 | 31262823 | PRJNA681822_P_NODE_484535_length_240_cov_2.670659_g483045_i0 | PRJNA681822 | 484535 | 240 | 2.670659 | 6.4095816 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 130 | 2.7e-35 | NR | TAH32978.1 | 2026720 | g483045 | i0 | 93.2 | 1.825 | 73 | 5 | 91.3 | 0 | 20 | 238 | 1 | 73 | TAH32978.1 MAG: hypothetical protein EYC58_02375 [Candidatus Saccharibacteria bacterium] | diamond | 438 | 130 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadota bacterium | ||||||
| 31314329 | 31314329 | PRJNA681822_P_NODE_328515_length_266_cov_2.160622_g327026_i0 | PRJNA681822 | 328515 | 266 | 2.160622 | 5.74725452 | Candidatus Nanosynbacter sp. | 2725945 | Bacteria | Bacteria | 160 | 1.5e-48 | NR | MBF1042860.1 | 2725945 | g327026 | i0 | 95 | 0.902255639097744 | 80 | 4 | 90.2 | 0 | 2 | 241 | 63 | 142 | MBF1042860.1 hypothetical protein [Candidatus Nanosynbacter sp.] | diamond | 240 | 160 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadia | Candidatus Nanosynbacterales | Candidatus Nanosynbacteraceae | Candidatus Nanosynbacter | Candidatus Nanosynbacter sp. | ||
| 32105139 | 32105139 | PRJNA681822_P_NODE_399238_length_249_cov_2.443182_g397749_i0 | PRJNA681822 | 399238 | 249 | 2.443182 | 6.08352318 | Candidatus Nanosynsacchari sp. TM7_ANC_38.39_G1_1 | 1986206 | Bacteria | Bacteria | 103 | 2.22e-25 | NR | WP_206660707.1 | 1986206 | g397749 | i0 | 98.3 | 1.39759036144578 | 58 | 1 | 69.9 | 0 | 248 | 75 | 154 | 211 | WP_206660707.1 ABC transporter permease, partial [Candidatus Nanosynsacchari sp. TM7_ANC_38.39_G1_1] | diamond | 348 | 103 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadia | Candidatus Saccharimonadales | Candidatus Saccharimonadaceae | Candidatus Nanosynsacchari | Candidatus Nanosynsacchari sp. TM7_ANC_38.39_G1_1 | ||
| 32421609 | 32421609 | PRJNA681822_P_NODE_259719_length_284_cov_1.459716_g258230_i0 | PRJNA681822 | 259719 | 284 | 1.459716 | 4.14559344 | Candidatus Nanosynsacchari sp. TM7_ANC_38.39_G1_1 | 1986206 | Bacteria | Bacteria | 189 | 7.789999999999999e-57 | NR | WP_129693502.1 | 1986206 | g258230 | i0 | 98.9 | 0.992957746478873 | 94 | 1 | 99.3 | 0 | 283 | 2 | 140 | 233 | WP_129693502.1 TRM11 family SAM-dependent methyltransferase [Candidatus Nanosynsacchari sp. TM7_ANC_38.39_G1_1] | diamond | 282 | 189 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadia | Candidatus Saccharimonadales | Candidatus Saccharimonadaceae | Candidatus Nanosynsacchari | Candidatus Nanosynsacchari sp. TM7_ANC_38.39_G1_1 | ||
| 32611238 | 32611238 | PRJNA681822_P_NODE_461760_length_243_cov_0.905882_g460270_i0 | PRJNA681822 | 461760 | 243 | 0.905882 | 2.20129326 | Candidatus Saccharimonadota bacterium | 2026720 | Bacteria | Bacteria | 134 | 1.7999999999999998e-35 | NR | MBR6168710.1 | 2026720 | g460270 | i0 | 83.8 | 1.96296296296296 | 80 | 13 | 98.8 | 0 | 241 | 2 | 166 | 245 | MBR6168710.1 trypsin-like peptidase domain-containing protein [Candidatus Saccharibacteria bacterium] | diamond | 477 | 134 | 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);;