contig_metadata
19 rows where bioproject = "PRJNA980585" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2545091 | 2545091 | PRJNA980585_P_NODE_53662_length_245_cov_0.883721_g53408_i0 | PRJNA980585 | 53662 | 245 | 0.883721 | 2.16511645 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 90.9 | 4.29e-19 | NR | MCA9350454.1 | 2026720 | g53408 | i0 | 67.2 | 6.28163265306122 | 64 | 21 | 78.4 | 0 | 1 | 192 | 440 | 503 | MCA9350454.1 molecular chaperone DnaK [Candidatus Saccharibacteria bacterium] | diamond | 1539 | 90.9 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadota bacterium | ||||||
| 9882993 | 9882993 | PRJNA980585_P_NODE_39848_length_252_cov_1.709497_g39594_i0 | PRJNA980585 | 39848 | 252 | 1.709497 | 4.30793244 | Candidatus Mycosynbacter amalyticus | 2665156 | Bacteria | Bacteria | 394 | 3.3e-105 | NTclustered | gi|1799615131|gb|CP045921.1| | 2665156 | g39594 | i0 | 95.2 | 133.503968253968 | 250 | 10 | 99 | 2 | 3 | 251 | 220673 | 220921 | Candidatus Mycosynbacter amalyticus isolate JR1 chromosome, complete genome | blastn | 33643 | 394 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Mycosynbacter | Candidatus Mycosynbacter amalyticus | |||||
| 9883061 | 9883061 | PRJNA980585_P_NODE_44288_length_249_cov_1.267045_g44034_i0 | PRJNA980585 | 44288 | 249 | 1.267045 | 3.15494205 | Candidatus Saccharimonadota bacterium | 2026720 | Bacteria | Bacteria | 412 | 8.97e-111 | NTclustered | gi|1950821269|gb|CP066696.1| | 2026720 | g44034 | i0 | 96.761 | 83.3855421686747 | 247 | 8 | 99 | 0 | 3 | 249 | 799835 | 800081 | Candidatus Saccharibacteria bacterium isolate NC_groundwater_1927_Pr3_S-0.2um_48_6 chromosome | blastn | 20763 | 412 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadota bacterium | ||||||
| 9883271 | 9883271 | PRJNA980585_P_NODE_58628_length_242_cov_0.911243_g58374_i0 | PRJNA980585 | 58628 | 242 | 0.911243 | 2.20520806 | Candidatus Saccharimonadales bacterium | 2973664 | Bacteria | Bacteria | 146 | 1.13e-39 | NR | HWZ43658.1 | 2973664 | g58374 | i0 | 83.8 | 2.97520661157025 | 80 | 12 | 99.2 | 1 | 2 | 241 | 389 | 467 | HWZ43658.1 glycoside hydrolase family 130 protein [Candidatus Saccharimonadales bacterium] | diamond | 720 | 146 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadia | Candidatus Saccharimonadales | Candidatus Saccharimonadales bacterium | ||||
| 19120806 | 19120806 | PRJNA980585_P_NODE_61135_length_241_cov_0.916667_g60881_i0 | PRJNA980585 | 61135 | 241 | 0.916667 | 2.20916747 | root | 1 | Root_unresolved | Root_unresolved | 424 | 3.99e-114 | NTclustered | gi|2028829559|gb|CP072328.1| | 713051 | g60881 | i0 | 98.34 | 2.96680497925311 | 241 | 4 | 100 | 0 | 1 | 241 | 786976 | 787216 | TM7 phylum sp. oral taxon 349 strain PM007 chromosome, complete genome | blastn | 715 | 424 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | TM7 phylum sp. oral taxon 349 | ||||||
| 25181083 | 25181083 | PRJNA980585_P_NODE_45060_length_249_cov_0.875000_g44806_i0 | PRJNA980585 | 45060 | 249 | 0.875 | 2.17875 | Candidatus Southlakia epibionticum | 3043284 | Bacteria | Bacteria | 399 | 6.989999999999999e-107 | NTclustered | gi|2516687873|gb|CP124550.1| | 3043284 | g44806 | i0 | 95.582 | 370.722891566265 | 249 | 11 | 100 | 0 | 1 | 249 | 151077 | 151325 | Candidatus Southlakia epibionticum strain ML1 chromosome, complete genome | blastn | 92310 | 399 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadia | Candidatus Saccharimonadales | Candidatus Saccharimonadaceae | Candidatus Southlakia | Candidatus Southlakia epibionticum | ||
| 27152173 | 27152173 | PRJNA980585_P_NODE_59522_length_241_cov_1.833333_g59268_i0 | PRJNA980585 | 59522 | 241 | 1.833333 | 4.41833253 | Candidatus Nanosynbacter sp. HMT-348_TM7c-JB | 2933970 | Bacteria | Bacteria | 97.8 | 1.1e-21 | NR | UJD06821.1 | 2933970 | g59268 | i0 | 59 | 0.970954356846473 | 78 | 32 | 97.1 | 0 | 235 | 2 | 209 | 286 | UJD06821.1 MAG: pyridoxal-phosphate dependent enzyme [Candidatus Nanosynbacter sp. HMT-348_TM7c-JB] | diamond | 234 | 97.8 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadia | Candidatus Nanosynbacterales | Candidatus Nanosynbacteraceae | Candidatus Nanosynbacter | Candidatus Nanosynbacter sp. HMT-348_TM7c-JB | ||
| 27316964 | 27316964 | PRJNA980585_P_NODE_8863_length_444_cov_1.646900_g8609_i0 | PRJNA980585 | 8863 | 444 | 1.6469 | 7.312236 | Bacteria | 2 | Bacteria | Bacteria | 75.5 | 1.6e-14 | NR | OJU87557.1 | 1895829 | g8609 | i0 | 48.2 | 4.07432432432432 | 85 | 43 | 56.8 | 1 | 442 | 191 | 5 | 89 | OJU87557.1 MAG: RNA-binding protein [Candidatus Saccharibacteria bacterium 49-20] | diamond | 1809 | 75.5 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharibacteria bacterium 49-20 | ||||||
| 28422112 | 28422112 | PRJNA980585_P_NODE_55426_length_244_cov_0.900585_g55172_i0 | PRJNA980585 | 55426 | 244 | 0.900585 | 2.1974274 | Bacteria | 2 | Bacteria | Bacteria | 161 | 7.869999999999999e-45 | NR | KKW01789.1 | 1619071 | g55172 | i0 | 91.4 | 1.99180327868852 | 81 | 7 | 99.6 | 0 | 244 | 2 | 333 | 413 | KKW01789.1 MAG: Secretory lipase family protein [Candidatus Saccharibacteria bacterium GW2011_GWC2_48_9] | diamond | 486 | 161 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharibacteria bacterium GW2011_GWC2_48_9 | ||||||
| 28769154 | 28769154 | PRJNA980585_P_NODE_31127_length_276_cov_3.019704_g30873_i0 | PRJNA980585 | 31127 | 276 | 3.019704 | 8.33438304 | Bacteria | 2 | Bacteria | Bacteria | 90.5 | 3.47e-21 | NR | MDB5170562.1 | 2026720 | g30873 | i0 | 60 | 10.945652173913 | 75 | 30 | 81.5 | 0 | 275 | 51 | 2 | 76 | MDB5170562.1 RNA-binding protein [Candidatus Saccharibacteria bacterium] | diamond | 3021 | 91.3 | 0.991237677984666 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadota bacterium | ||||||
| 28958914 | 28958914 | PRJNA980585_P_NODE_50768_length_246_cov_0.890173_g50514_i0 | PRJNA980585 | 50768 | 246 | 0.890173 | 2.18982558 | Bacteria | 2 | Bacteria | Bacteria | 82.8 | 2.97e-16 | NR | OYX53368.1 | 1970481 | g50514 | i0 | 79.6 | 1.19512195121951 | 49 | 10 | 59.8 | 0 | 147 | 1 | 1 | 49 | OYX53368.1 MAG: magnesium chelatase [Candidatus Saccharibacteria bacterium 32-50-13] | diamond | 294 | 82.8 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharibacteria bacterium 32-50-13 | ||||||
| 29047411 | 29047411 | PRJNA980585_P_NODE_54868_length_244_cov_0.900585_g54614_i0 | PRJNA980585 | 54868 | 244 | 0.900585 | 2.1974274 | Candidatus Saccharimonadota bacterium | 2026720 | Bacteria | Bacteria | 74.7 | 4.75e-15 | NR | MBC7564757.1 | 2026720 | g54614 | i0 | 86.8 | 2.88934426229508 | 38 | 5 | 46.7 | 0 | 1 | 114 | 84 | 121 | MBC7564757.1 hypothetical protein [Candidatus Saccharibacteria bacterium] | diamond | 705 | 74.7 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadota bacterium | ||||||
| 29363116 | 29363116 | PRJNA980585_P_NODE_52349_length_245_cov_0.895349_g52095_i0 | PRJNA980585 | 52349 | 245 | 0.895349 | 2.19360505 | Candidatus Saccharibacteria bacterium 49-2 | 1895829 | Bacteria | Bacteria | 155 | 3.6e-43 | NR | OJU87685.1 | 1895829 | g52095 | i0 | 97.5 | 5.93877551020408 | 81 | 2 | 99.2 | 0 | 245 | 3 | 41 | 121 | OJU87685.1 MAG: preprotein translocase subunit SecY [Candidatus Saccharibacteria bacterium 49-20] | diamond | 1455 | 155 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharibacteria bacterium 49-20 | ||||||
| 29779596 | 29779596 | PRJNA980585_P_NODE_29111_length_282_cov_1.339713_g28857_i0 | PRJNA980585 | 29111 | 282 | 1.339713 | 3.77799066 | Bacteria | 2 | Bacteria | Bacteria | 43.9 | 0.0227 | NR | HSI62636.1 | 2890869 | g28857 | i0 | 39.4 | 1.40425531914894 | 66 | 39 | 70.2 | 1 | 206 | 9 | 71 | 135 | HSI62636.1 ATP-binding cassette domain-containing protein [Candidatus Saccharimonadia bacterium] | diamond | 396 | 43.9 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadia | Candidatus Saccharimonadia bacterium | |||||
| 30311040 | 30311040 | PRJNA980585_P_NODE_29812_length_280_cov_1.483092_g29558_i0 | PRJNA980585 | 29812 | 280 | 1.483092 | 4.1526576 | Candidatus Microsaccharimonas sp. | 3069365 | Bacteria | Bacteria | 55.5 | 2e-6 | NR | HEY8886466.1 | 3069365 | g29558 | i0 | 45.1 | 1.75714285714286 | 82 | 42 | 86.8 | 2 | 244 | 2 | 543 | 622 | HEY8886466.1 DEAD/DEAH box helicase family protein [Candidatus Microsaccharimonas sp.] | diamond | 492 | 55.5 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadia | Candidatus Saccharimonadales | Candidatus Saccharimonadaceae | Candidatus Microsaccharimonas | Candidatus Microsaccharimonas sp. | ||
| 30405750 | 30405750 | PRJNA980585_P_NODE_49253_length_247_cov_0.885057_g48999_i0 | PRJNA980585 | 49253 | 247 | 0.885057 | 2.18609079 | Candidatus Nanosynbacter sp. | 2725945 | Bacteria | Bacteria | 150 | 1.37e-41 | NR | MBF1032130.1 | 2725945 | g48999 | i0 | 92.7 | 0.995951417004049 | 82 | 6 | 99.6 | 0 | 2 | 247 | 58 | 139 | MBF1032130.1 hypothetical protein [Candidatus Nanosynbacter sp.] | diamond | 246 | 150 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadia | Candidatus Nanosynbacterales | Candidatus Nanosynbacteraceae | Candidatus Nanosynbacter | Candidatus Nanosynbacter sp. | ||
| 30531649 | 30531649 | PRJNA980585_P_NODE_52873_length_245_cov_0.895349_g52619_i0 | PRJNA980585 | 52873 | 245 | 0.895349 | 2.19360505 | Candidatus Saccharimonadales bacterium | 2973664 | Bacteria | Bacteria | 78.2 | 1.96e-16 | NR | HWZ43869.1 | 2973664 | g52619 | i0 | 69.2 | 0.636734693877551 | 52 | 16 | 63.7 | 0 | 158 | 3 | 1 | 52 | HWZ43869.1 DUF5615 family PIN-like protein [Candidatus Saccharimonadales bacterium] | diamond | 156 | 78.2 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadia | Candidatus Saccharimonadales | Candidatus Saccharimonadales bacterium | ||||
| 31296153 | 31296153 | PRJNA980585_P_NODE_44355_length_249_cov_0.875000_g44101_i0 | PRJNA980585 | 44355 | 249 | 0.875 | 2.17875 | Bacteria | 2 | Bacteria | Bacteria | 148 | 2.08e-39 | NR | KKW03689.1 | 1619071 | g44101 | i0 | 92.7 | 2.96385542168675 | 82 | 6 | 98.8 | 0 | 2 | 247 | 241 | 322 | KKW03689.1 MAG: ATPase AAA-2 domain protein [Candidatus Saccharibacteria bacterium GW2011_GWC2_48_9] | diamond | 738 | 148 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharibacteria bacterium GW2011_GWC2_48_9 | ||||||
| 32080835 | 32080835 | PRJNA980585_P_NODE_36358_length_262_cov_1.375661_g36104_i0 | PRJNA980585 | 36358 | 262 | 1.375661 | 3.60423182 | Candidatus Saccharimonadales bacterium | 2973664 | Bacteria | Bacteria | 92.4 | 1.55e-19 | NR | HWZ46409.1 | 2973664 | g36104 | i0 | 61.2 | 0.973282442748092 | 85 | 33 | 97.3 | 0 | 3 | 257 | 37 | 121 | HWZ46409.1 Ig-like domain-containing protein [Candidatus Saccharimonadales bacterium] | diamond | 255 | 92.4 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadia | Candidatus Saccharimonadales | Candidatus Saccharimonadales 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);;