contig_metadata
16 rows where analysis = "diamond", bioproject = "PRJNA432257" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1704577 | 1704577 | PRJNA432257_S_NODE_44902_length_240_cov_35.192118_g44521_i0 | PRJNA432257 | 44902 | 240 | 35.192118 | 84.4610832 | Candidatus Saccharimonadia | 2093818 | Bacteria | Bacteria | 99.4 | 1.1200000000000001e-22 | NR | PKL31715.1 | 2013831 | g44521 | i0 | 88.7 | 7.9875 | 53 | 6 | 66.3 | 0 | 160 | 2 | 155 | 207 | PKL31715.1 MAG: peptide chain release factor 1 [Candidatus Saccharibacteria bacterium HGW-Saccharibacteria-1] | diamond | 1917 | 100 | 0.994 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharibacteria bacterium HGW-Saccharibacteria-1 | ||||||
| 26791061 | 26791061 | PRJNA432257_S_NODE_28781_length_283_cov_12.430894_g28400_i0 | PRJNA432257 | 28781 | 283 | 12.430894 | 35.17943002 | Candidatus Saccharimonadota bacterium | 2026720 | Bacteria | Bacteria | 74.7 | 3.5e-13 | NR | MCA9341841.1 | 2026720 | g28400 | i0 | 42 | 4.49469964664311 | 81 | 46 | 85.9 | 1 | 246 | 4 | 532 | 611 | MCA9341841.1 ribonucleoside-diphosphate reductase subunit alpha [Candidatus Saccharibacteria bacterium] | diamond | 1272 | 74.7 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadota bacterium | ||||||
| 27265513 | 27265513 | PRJNA432257_S_NODE_112883_length_163_cov_2.341270_g112502_i0 | PRJNA432257 | 112883 | 163 | 2.34127 | 3.8162701 | Candidatus Nanogingivalaceae bacterium | 2725942 | Bacteria | Bacteria | 103 | 4.42e-25 | NR | MBF1024824.1 | 2725942 | g112502 | i0 | 96.2 | 0.975460122699387 | 53 | 2 | 97.5 | 0 | 3 | 161 | 61 | 113 | MBF1024824.1 type II restriction endonuclease [Candidatus Nanogingivalaceae bacterium] | diamond | 159 | 103 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Nanosyncoccalia | Candidatus Nanogingivales | Candidatus Nanogingivalaceae | Candidatus Nanogingivalaceae bacterium | |||
| 27644695 | 27644695 | PRJNA432257_S_NODE_27444_length_288_cov_7.553785_g27063_i0 | PRJNA432257 | 27444 | 288 | 7.553785 | 21.7549008 | Candidatus Saccharimonadales bacterium | 2973664 | Bacteria | Bacteria | 101 | 1.69e-22 | NR | HSW76347.1 | 2973664 | g27063 | i0 | 59.5 | 0.875 | 84 | 32 | 85.4 | 1 | 8 | 253 | 346 | 429 | HSW76347.1 hypothetical protein [Candidatus Saccharimonadales bacterium] | diamond | 252 | 101 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadia | Candidatus Saccharimonadales | Candidatus Saccharimonadales bacterium | ||||
| 27644707 | 27644707 | PRJNA432257_S_NODE_44764_length_240_cov_1745.980296_g44383_i0 | PRJNA432257 | 44764 | 240 | 1745.980296 | 4190.3527104 | Candidatus Saccharimonadota bacterium | 2026720 | Bacteria | Bacteria | 92 | 1.89e-21 | NR | MBB1552150.1 | 2026720 | g44383 | i0 | 75 | 0.85 | 68 | 17 | 85 | 0 | 34 | 237 | 92 | 159 | MBB1552150.1 hypothetical protein [Candidatus Saccharibacteria bacterium] | diamond | 204 | 92 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadota bacterium | ||||||
| 27771002 | 27771002 | PRJNA432257_S_NODE_72144_length_201_cov_2.390244_g71763_i0 | PRJNA432257 | 72144 | 201 | 2.390244 | 4.80439044 | Candidatus Saccharimonadota bacterium | 2026720 | Bacteria | Bacteria | 55.1 | 7.91e-7 | NR | HAC56089.1 | 2026720 | g71763 | i0 | 83.9 | 0.462686567164179 | 31 | 5 | 46.3 | 0 | 109 | 201 | 1 | 31 | HAC56089.1 ROK family protein [Candidatus Saccharibacteria bacterium] | diamond | 93 | 55.1 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadota bacterium | ||||||
| 28054813 | 28054813 | PRJNA432257_S_NODE_116185_length_160_cov_1.853659_g115804_i0 | PRJNA432257 | 116185 | 160 | 1.853659 | 2.9658544 | Candidatus Saccharimonadales bacterium | 2973664 | Bacteria | Bacteria | 64.7 | 4.03e-11 | NR | MFO0971469.1 | 2973664 | g115804 | i0 | 88.2 | 0.6375 | 34 | 4 | 63.8 | 0 | 59 | 160 | 1 | 34 | MFO0971469.1 inorganic diphosphatase [Candidatus Saccharimonadales bacterium] | diamond | 102 | 64.7 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadia | Candidatus Saccharimonadales | Candidatus Saccharimonadales bacterium | ||||
| 28180978 | 28180978 | PRJNA432257_S_NODE_58826_length_217_cov_77.405556_g58445_i0 | PRJNA432257 | 58826 | 217 | 77.405556 | 167.97005652000001 | Candidatus Saccharimonadales bacterium | 2973664 | Bacteria | Bacteria | 61.2 | 3.17e-9 | NR | HSW76590.1 | 2973664 | g58445 | i0 | 46.9 | 0.884792626728111 | 64 | 32 | 88.5 | 1 | 192 | 1 | 102 | 163 | HSW76590.1 hypothetical protein [Candidatus Saccharimonadales bacterium] | diamond | 192 | 61.2 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadia | Candidatus Saccharimonadales | Candidatus Saccharimonadales bacterium | ||||
| 28749587 | 28749587 | PRJNA432257_S_NODE_91767_length_182_cov_410.131034_g91386_i0 | PRJNA432257 | 91767 | 182 | 410.131034 | 746.43848188 | Candidatus Saccharimonadales bacterium | 2973664 | Bacteria | Bacteria | 69.7 | 3.78e-13 | NR | HSX40735.1 | 2973664 | g91386 | i0 | 72.5 | 0.840659340659341 | 51 | 14 | 84.1 | 0 | 153 | 1 | 77 | 127 | HSX40735.1 GatB/YqeY domain-containing protein [Candidatus Saccharimonadales bacterium] | diamond | 153 | 69.7 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadia | Candidatus Saccharimonadales | Candidatus Saccharimonadales bacterium | ||||
| 28829024 | 28829024 | PRJNA432257_S_NODE_110488_length_166_cov_1.271318_g110107_i0 | PRJNA432257 | 110488 | 166 | 1.271318 | 2.11038788 | Bacteria | 2 | Bacteria | Bacteria | 78.6 | 2.67e-15 | NR | MCA9345630.1 | 2026720 | g110107 | i0 | 80 | 9.19879518072289 | 50 | 10 | 90.4 | 0 | 16 | 165 | 284 | 333 | MCA9345630.1 ABC transporter permease [Candidatus Saccharibacteria bacterium] | diamond | 1527 | 78.6 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadota bacterium | ||||||
| 28939115 | 28939115 | PRJNA432257_S_NODE_121488_length_155_cov_3.644068_g121107_i0 | PRJNA432257 | 121488 | 155 | 3.644068 | 5.6483054 | Candidatus Saccharimonadales bacterium | 2973664 | Bacteria | Bacteria | 48.5 | 1.63e-5 | NR | HSW75497.1 | 2973664 | g121107 | i0 | 44.2 | 1.66451612903226 | 43 | 24 | 83.2 | 0 | 23 | 151 | 3 | 45 | HSW75497.1 gp7 family phage scaffolding protein [Candidatus Saccharimonadales bacterium] | diamond | 258 | 48.5 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadia | Candidatus Saccharimonadales | Candidatus Saccharimonadales bacterium | ||||
| 29807860 | 29807860 | PRJNA432257_S_NODE_90251_length_184_cov_1.727891_g89870_i0 | PRJNA432257 | 90251 | 184 | 1.727891 | 3.17931944 | Bacillati | 1783272 | Bacteria | Bacteria | 75.5 | 4.33e-14 | NR | MDB5176751.1 | 2026720 | g89870 | i0 | 87 | 3.09782608695652 | 46 | 6 | 75 | 0 | 24 | 161 | 311 | 356 | MDB5176751.1 rane protein of unknown function [Candidatus Saccharibacteria bacterium] | diamond | 570 | 75.5 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadota bacterium | ||||||
| 30265644 | 30265644 | PRJNA432257_S_NODE_111232_length_165_cov_1.757812_g110851_i0 | PRJNA432257 | 111232 | 165 | 1.757812 | 2.9003898 | Candidatus Saccharimonadia bacterium | 2890869 | Bacteria | Bacteria | 45.4 | 0.00115 | NR | HUD11127.1 | 2890869 | g110851 | i0 | 54.5 | 1.09090909090909 | 33 | 15 | 60 | 0 | 9 | 107 | 179 | 211 | HUD11127.1 hypothetical protein [Candidatus Saccharimonadia bacterium] | diamond | 180 | 45.4 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadia | Candidatus Saccharimonadia bacterium | |||||
| 30439987 | 30439987 | PRJNA432257_S_NODE_70413_length_203_cov_2.096386_g70032_i0 | PRJNA432257 | 70413 | 203 | 2.096386 | 4.25566358 | Bacteria | 2 | Bacteria | Bacteria | 44.7 | 0.00458 | NR | PKL31608.1 | 2013831 | g70032 | i0 | 34.3 | 2.76354679802956 | 67 | 44 | 99 | 0 | 2 | 202 | 219 | 285 | PKL31608.1 MAG: DNA polymerase III, subunit gamma and tau [Candidatus Saccharibacteria bacterium HGW-Saccharibacteria-1] | diamond | 561 | 44.7 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharibacteria bacterium HGW-Saccharibacteria-1 | ||||||
| 31118194 | 31118194 | PRJNA432257_S_NODE_58355_length_218_cov_3.337017_g57974_i0 | PRJNA432257 | 58355 | 218 | 3.337017 | 7.27469706 | Candidatus Saccharimonadota bacterium | 2026720 | Bacteria | Bacteria | 129 | 2.85e-34 | NR | MBR0430925.1 | 2026720 | g57974 | i0 | 91.4 | 7.69266055045872 | 70 | 6 | 96.3 | 0 | 2 | 211 | 298 | 367 | MBR0430925.1 AI-2E family transporter [Candidatus Saccharibacteria bacterium] | diamond | 1677 | 129 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadota bacterium | ||||||
| 32667915 | 32667915 | PRJNA432257_S_NODE_69720_length_204_cov_1.107784_g69339_i0 | PRJNA432257 | 69720 | 204 | 1.107784 | 2.25987936 | Candidatus Saccharimonadota bacterium | 2026720 | Bacteria | Bacteria | 70.1 | 4.88e-12 | NR | HRQ98278.1 | 2026720 | g69339 | i0 | 71.4 | 4.82352941176471 | 42 | 12 | 61.8 | 0 | 78 | 203 | 75 | 116 | HRQ98278.1 hypothetical protein [Candidatus Saccharibacteria bacterium] | diamond | 984 | 70.1 | 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);;