contig_metadata
19 rows where analysis = "diamond", bioproject = "PRJNA641707" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1890092 | 1890092 | PRJNA641707_P_NODE_235482_length_188_cov_5.201439_g232819_i0 | PRJNA641707 | 235482 | 188 | 5.201439 | 9.77870532 | Candidatus Saccharimonadia bacterium | 2890869 | Bacteria | Bacteria | 134 | 1.5e-35 | NR | HSX83418.1 | 2890869 | g232819 | i0 | 96.7 | 7.65957446808511 | 60 | 2 | 95.7 | 0 | 183 | 4 | 55 | 114 | HSX83418.1 AMP-binding protein [Candidatus Saccharimonadia bacterium] | diamond | 1440 | 134 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadia | Candidatus Saccharimonadia bacterium | |||||
| 26891567 | 26891567 | PRJNA641707_P_NODE_288381_length_167_cov_8.211864_g285718_i0 | PRJNA641707 | 288381 | 167 | 8.211864 | 13.71381288 | Candidatus Saccharimonadales bacterium | 2973664 | Bacteria | Bacteria | 88.6 | 4.09e-19 | NR | HEX8390139.1 | 2973664 | g285718 | i0 | 73.6 | 3.84431137724551 | 53 | 14 | 95.2 | 0 | 159 | 1 | 21 | 73 | HEX8390139.1 S1 RNA-binding domain-containing protein [Candidatus Saccharimonadales bacterium] | diamond | 642 | 88.6 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadia | Candidatus Saccharimonadales | Candidatus Saccharimonadales bacterium | ||||
| 27081027 | 27081027 | PRJNA641707_P_NODE_140802_length_241_cov_10.635417_g138139_i0 | PRJNA641707 | 140802 | 241 | 10.635417 | 25.63135497 | Candidatus Saccharimonadota bacterium | 2026720 | Bacteria | Bacteria | 55.5 | 1.18e-6 | NR | MCA9334474.1 | 2026720 | g138139 | i0 | 40.7 | 1.07053941908714 | 86 | 44 | 98.3 | 1 | 238 | 2 | 155 | 240 | MCA9334474.1 immunoglobulin domain-containing protein [Candidatus Saccharibacteria bacterium] | diamond | 258 | 55.5 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadota bacterium | ||||||
| 27081067 | 27081067 | PRJNA641707_P_NODE_198222_length_197_cov_16.472973_g195559_i0 | PRJNA641707 | 198222 | 197 | 16.472973 | 32.45175681 | Candidatus Saccharimonadota bacterium | 2026720 | Bacteria | Bacteria | 92 | 5.83e-20 | NR | MEI6169415.1 | 2026720 | g195559 | i0 | 75.4 | 1.9492385786802 | 65 | 16 | 99 | 0 | 3 | 197 | 302 | 366 | MEI6169415.1 trigger factor [Candidatus Saccharibacteria bacterium] | diamond | 384 | 92 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadota bacterium | ||||||
| 27112637 | 27112637 | PRJNA641707_P_NODE_303642_length_163_cov_4.833333_g300979_i0 | PRJNA641707 | 303642 | 163 | 4.833333 | 7.87833279 | Candidatus Saccharimonadia bacterium | 2890869 | Bacteria | Bacteria | 69.3 | 3.61e-12 | NR | HSI62988.1 | 2890869 | g300979 | i0 | 70.7 | 1.50920245398773 | 41 | 12 | 75.5 | 0 | 3 | 125 | 275 | 315 | HSI62988.1 DUF3482 domain-containing protein [Candidatus Saccharimonadia bacterium] | diamond | 246 | 69.3 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadia | Candidatus Saccharimonadia bacterium | |||||
| 27175683 | 27175683 | PRJNA641707_P_NODE_159902_length_214_cov_19.939394_g157239_i0 | PRJNA641707 | 159902 | 214 | 19.939394 | 42.67030316 | Candidatus Saccharimonadales bacterium | 2973664 | Bacteria | Bacteria | 58.2 | 9.49e-8 | NR | MFO0971571.1 | 2973664 | g157239 | i0 | 62.2 | 1.27570093457944 | 37 | 14 | 51.9 | 0 | 112 | 2 | 220 | 256 | MFO0971571.1 M1 family metallopeptidase [Candidatus Saccharimonadales bacterium] | diamond | 273 | 58.2 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadia | Candidatus Saccharimonadales | Candidatus Saccharimonadales bacterium | ||||
| 27397460 | 27397460 | PRJNA641707_P_NODE_75943_length_246_cov_12.223350_g73280_i0 | PRJNA641707 | 75943 | 246 | 12.22335 | 30.069441 | Candidatus Saccharimonadia bacterium | 2890869 | Bacteria | Bacteria | 51.2 | 1.9e-5 | NR | HSX79196.1 | 2890869 | g73280 | i0 | 71.9 | 1.17073170731707 | 32 | 9 | 39 | 0 | 149 | 244 | 102 | 133 | HSX79196.1 amidohydrolase family protein [Candidatus Saccharimonadia bacterium] | diamond | 288 | 51.2 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadia | Candidatus Saccharimonadia bacterium | |||||
| 28344389 | 28344389 | PRJNA641707_P_NODE_229966_length_190_cov_5.609929_g227303_i0 | PRJNA641707 | 229966 | 190 | 5.609929 | 10.6588651 | Candidatus Nanogingivalaceae bacterium | 2725942 | Bacteria | Bacteria | 121 | 2.9299999999999997e-30 | NR | MBF1003169.1 | 2725942 | g227303 | i0 | 75.9 | 2.49473684210526 | 79 | 3 | 99.5 | 1 | 189 | 1 | 195 | 273 | MBF1003169.1 ribonuclease J [Candidatus Nanogingivalaceae bacterium] | diamond | 474 | 121 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Nanosyncoccalia | Candidatus Nanogingivales | Candidatus Nanogingivalaceae | Candidatus Nanogingivalaceae bacterium | |||
| 28439388 | 28439388 | PRJNA641707_P_NODE_94506_length_246_cov_5.010152_g91843_i0 | PRJNA641707 | 94506 | 246 | 5.010152 | 12.32497392 | Candidatus Saccharimonadia bacterium | 2890869 | Bacteria | Bacteria | 58.5 | 1.13e-8 | NR | HSX82011.1 | 2890869 | g91843 | i0 | 93.9 | 0.402439024390244 | 33 | 2 | 40.2 | 0 | 100 | 2 | 15 | 47 | HSX82011.1 50S ribosomal protein L7/L12 [Candidatus Saccharimonadia bacterium] | diamond | 99 | 58.5 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadia | Candidatus Saccharimonadia bacterium | |||||
| 28597050 | 28597050 | PRJNA641707_P_NODE_128007_length_244_cov_8.733333_g125344_i0 | PRJNA641707 | 128007 | 244 | 8.733333 | 21.30933252 | Candidatus Saccharimonadota bacterium | 2026720 | Bacteria | Bacteria | 65.5 | 7.65e-11 | NR | MSR68194.1 | 2026720 | g125344 | i0 | 87.9 | 0.405737704918033 | 33 | 4 | 40.6 | 0 | 100 | 2 | 112 | 144 | MSR68194.1 peptide deformylase [Candidatus Saccharibacteria bacterium] | diamond | 99 | 65.5 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadota bacterium | ||||||
| 28723388 | 28723388 | PRJNA641707_P_NODE_261247_length_177_cov_13.234375_g258584_i0 | PRJNA641707 | 261247 | 177 | 13.234375 | 23.42484375 | Candidatus Saccharimonadota bacterium | 2026720 | Bacteria | Bacteria | 75.5 | 2.42e-15 | NR | MBI3889213.1 | 2026720 | g258584 | i0 | 75 | 0.949152542372881 | 56 | 14 | 94.9 | 0 | 5 | 172 | 65 | 120 | MBI3889213.1 hypothetical protein [Candidatus Saccharibacteria bacterium] | diamond | 168 | 75.5 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadota bacterium | ||||||
| 29070735 | 29070735 | PRJNA641707_P_NODE_118908_length_245_cov_9.403061_g116245_i0 | PRJNA641707 | 118908 | 245 | 9.403061 | 23.03749945 | Candidatus Saccharimonadota bacterium | 2026720 | Bacteria | Bacteria | 66.6 | 8.87e-12 | NR | MDO4773870.1 | 2026720 | g116245 | i0 | 49.4 | 0.942857142857143 | 77 | 27 | 94.3 | 1 | 231 | 1 | 1 | 65 | MDO4773870.1 hypothetical protein [Candidatus Saccharibacteria bacterium] | diamond | 231 | 66.6 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadota bacterium | ||||||
| 29146502 | 29146502 | PRJNA641707_P_NODE_171869_length_201_cov_5.625000_g169206_i0 | PRJNA641707 | 171869 | 201 | 5.625 | 11.30625 | Bacteria | 2 | Bacteria | Bacteria | 72.4 | 9.34e-14 | NR | HSX83743.1 | 2890869 | g169206 | i0 | 96.9 | 5.37313432835821 | 32 | 1 | 47.8 | 0 | 5 | 100 | 110 | 141 | HSX83743.1 hypothetical protein [Candidatus Saccharimonadia bacterium] | diamond | 1080 | 72.4 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadia | Candidatus Saccharimonadia bacterium | |||||
| 30175826 | 30175826 | PRJNA641707_P_NODE_257132_length_179_cov_5.746154_g254469_i0 | PRJNA641707 | 257132 | 179 | 5.746154 | 10.28561566 | Candidatus Saccharimonadales bacterium | 2973664 | Bacteria | Bacteria | 79.7 | 1.26e-15 | NR | HXI51184.1 | 2973664 | g254469 | i0 | 63.6 | 1.91061452513966 | 55 | 20 | 92.2 | 0 | 13 | 177 | 256 | 310 | HXI51184.1 fibronectin type III domain-containing protein [Candidatus Saccharimonadales bacterium] | diamond | 342 | 79.7 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadia | Candidatus Saccharimonadales | Candidatus Saccharimonadales bacterium | ||||
| 30504322 | 30504322 | PRJNA641707_P_NODE_295773_length_165_cov_6.750000_g293110_i0 | PRJNA641707 | 295773 | 165 | 6.75 | 11.1375 | Bacteria | 2 | Bacteria | Bacteria | 77 | 7.94e-15 | NR | MBP9852930.1 | 2026720 | g293110 | i0 | 84.2 | 2.10909090909091 | 38 | 6 | 69.1 | 0 | 11 | 124 | 332 | 369 | MBP9852930.1 beta-galactosidase [Candidatus Saccharibacteria bacterium] | diamond | 348 | 77 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadota bacterium | ||||||
| 31281645 | 31281645 | PRJNA641707_P_NODE_101415_length_246_cov_4.030457_g98752_i0 | PRJNA641707 | 101415 | 246 | 4.030457 | 9.91492422 | Candidatus Saccharimonadota bacterium | 2026720 | Bacteria | Bacteria | 69.3 | 2.05e-13 | NR | MBB1563613.1 | 2026720 | g98752 | i0 | 96.9 | 0.390243902439024 | 32 | 1 | 39 | 0 | 100 | 5 | 28 | 59 | MBB1563613.1 hypothetical protein [Candidatus Saccharibacteria bacterium] | diamond | 96 | 69.3 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadota bacterium | ||||||
| 31281696 | 31281696 | PRJNA641707_P_NODE_178795_length_200_cov_6.271523_g176132_i0 | PRJNA641707 | 178795 | 200 | 6.271523 | 12.543046 | Candidatus Saccharimonadales bacterium | 2973664 | Bacteria | Bacteria | 60.8 | 8.41e-9 | NR | HEX7484486.1 | 2973664 | g176132 | i0 | 87.9 | 0.495 | 33 | 4 | 49.5 | 0 | 100 | 198 | 122 | 154 | HEX7484486.1 isopeptide-forming domain-containing fimbrial protein [Candidatus Saccharimonadales bacterium] | diamond | 99 | 60.8 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadia | Candidatus Saccharimonadales | Candidatus Saccharimonadales bacterium | ||||
| 31503317 | 31503317 | PRJNA641707_P_NODE_1016_length_1681_cov_100.367647_g656_i0 | PRJNA641707 | 1016 | 1681 | 100.367647 | 1687.18014607 | Candidatus Saccharimonadota bacterium | 2026720 | Bacteria | Bacteria | 506 | 8.169999999999999e-173 | NR | MCA9334474.1 | 2026720 | g656 | i0 | 72.3 | 0.617489589530042 | 346 | 96 | 61.7 | 0 | 1044 | 7 | 1 | 346 | MCA9334474.1 immunoglobulin domain-containing protein [Candidatus Saccharibacteria bacterium] | diamond | 1038 | 506 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadota bacterium | ||||||
| 31673651 | 31673651 | PRJNA641707_P_NODE_211017_length_195_cov_7.369863_g208354_i0 | PRJNA641707 | 211017 | 195 | 7.369863 | 14.37123285 | Bacteria | 2 | Bacteria | Bacteria | 101 | 4.449999999999999e-24 | NR | HRJ06460.1 | 2026720 | g208354 | i0 | 79 | 2.86153846153846 | 62 | 13 | 95.4 | 0 | 6 | 191 | 113 | 174 | HRJ06460.1 ATP synthase F1 subunit gamma [Candidatus Saccharibacteria bacterium] | diamond | 558 | 101 | 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);;