contig_metadata
14 rows where bioproject = "PRJNA689790", tax_clade = "Bacteria candidate phyla" and tax_superkingdom = "Bacteria"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 24894916 | 24894916 | PRJNA689790_S_NODE_1620_length_519_cov_3.479253_g1514_i0 | PRJNA689790 | 1620 | 519 | 3.479253 | 18.05732307 | Candidatus Saccharimonadota bacterium | 2026720 | Bacteria | Bacteria | 119 | 1.6100000000000002e-27 | NR | MDO4986881.1 | 2026720 | g1514 | i0 | 43.5 | 2.65895953757225 | 161 | 91 | 93.1 | 0 | 519 | 37 | 474 | 634 | MDO4986881.1 molecular chaperone DnaK [Candidatus Saccharibacteria bacterium] | diamond | 1380 | 119 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadota bacterium | ||||||
| 26987308 | 26987308 | PRJNA689790_S_NODE_4382_length_290_cov_1.988142_g4267_i0 | PRJNA689790 | 4382 | 290 | 1.988142 | 5.7656118 | Candidatus Ozemobacter sibiricus | 2268124 | Bacteria | Bacteria | 58.2 | 2.58e-7 | NR | RCK81145.1 | 2268124 | g4267 | i0 | 40.8 | 2.36896551724138 | 76 | 43 | 78.6 | 2 | 23 | 250 | 1775 | 1848 | RCK81145.1 MAG: hypothetical protein OZSIB_2522 [Candidatus Ozemobacter sibiricus] | diamond | 687 | 58.2 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Ozemobacteria | Candidatus Ozemobacteraceae | Candidatus Ozemobacter | Candidatus Ozemobacter sibiricus | ||||
| 27113761 | 27113761 | PRJNA689790_S_NODE_9822_length_189_cov_1.282895_g9707_i0 | PRJNA689790 | 9822 | 189 | 1.282895 | 2.42467155 | Candidatus Muiribacterium halophilum | 2053465 | Bacteria | Bacteria | 78.2 | 1.9e-15 | NR | MCK9476910.1 | 2053465 | g9707 | i0 | 58.1 | 3.93650793650794 | 62 | 25 | 98.4 | 1 | 188 | 3 | 69 | 129 | MCK9476910.1 3-deoxy-8-phosphooctulonate synthase [Candidatus Muiribacterium halophilum] | diamond | 744 | 78.2 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Muiribacteriota | Candidatus Muiribacteriia | Candidatus Muiribacteriaceae | Candidatus Muiribacterium | Candidatus Muiribacterium halophilum | |||
| 28187526 | 28187526 | PRJNA689790_S_NODE_986_length_669_cov_6.696203_g903_i0 | PRJNA689790 | 986 | 669 | 6.696203 | 44.79759807 | Candidatus Kaiserbacteria bacterium | 2030810 | Bacteria | Bacteria | 60.1 | 1.53e-6 | NR | PCI89930.1 | 2030810 | g903 | i0 | 38.7 | 0.336322869955157 | 75 | 44 | 32.7 | 2 | 497 | 279 | 197 | 271 | PCI89930.1 MAG: hypothetical protein COB18_02290 [Candidatus Kaiserbacteria bacterium] | diamond | 225 | 60.1 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Kaiseribacteriota | Candidatus Kaiserbacteria bacterium | ||||||
| 28408809 | 28408809 | PRJNA689790_S_NODE_1486_length_542_cov_3.914851_g1385_i0 | PRJNA689790 | 1486 | 542 | 3.914851 | 21.21849242 | Candidatus Binatia bacterium | 2838779 | Bacteria | Bacteria | 64.7 | 3.57e-9 | NR | HEY8517423.1 | 2838779 | g1385 | i0 | 39.8 | 0.542435424354244 | 98 | 49 | 51.5 | 4 | 50 | 328 | 37 | 129 | HEY8517423.1 hypothetical protein [Candidatus Binatia bacterium] | diamond | 294 | 64.7 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Binatota | Candidatus Binatia | Candidatus Binatia bacterium | |||||
| 28945792 | 28945792 | PRJNA689790_S_NODE_2188_length_440_cov_3.478908_g2076_i0 | PRJNA689790 | 2188 | 440 | 3.478908 | 15.3071952 | Patescibacteria group bacterium | 2052139 | Bacteria | Bacteria | 58.5 | 7e-7 | NR | MEA3323148.1 | 2052139 | g2076 | i0 | 36.4 | 0.75 | 110 | 57 | 66.1 | 5 | 393 | 103 | 3 | 112 | MEA3323148.1 hypothetical protein [Patescibacteria group bacterium] | diamond | 330 | 58.5 | 1 | Bacteria | Bacteria candidate phyla | Patescibacteria group bacterium | |||||||
| 30050601 | 30050601 | PRJNA689790_S_NODE_14511_length_159_cov_1.278689_g14396_i0 | PRJNA689790 | 14511 | 159 | 1.278689 | 2.03311551 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 46.6 | 5.15e-4 | NR | MEZ0208986.1 | 2053589 | g14396 | i0 | 60.6 | 0.622641509433962 | 33 | 13 | 62.3 | 0 | 60 | 158 | 1346 | 1378 | MEZ0208986.1 hypothetical protein [Candidatus Paceibacterota bacterium] | diamond | 99 | 46.6 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 30208436 | 30208436 | PRJNA689790_S_NODE_12652_length_168_cov_2.083969_g12537_i0 | PRJNA689790 | 12652 | 168 | 2.083969 | 3.50106792 | Candidatus Nealsonbacteria bacterium | 2093793 | Bacteria | Bacteria | 41.2 | 0.0491 | NR | NQU21024.1 | 2093793 | g12537 | i0 | 38.5 | 0.928571428571429 | 52 | 29 | 92.9 | 2 | 7 | 162 | 155 | 203 | NQU21024.1 hypothetical protein [Candidatus Nealsonbacteria bacterium] | diamond | 156 | 41.2 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Nealsoniibacteriota | Candidatus Nealsonbacteria bacterium | ||||||
| 30461935 | 30461935 | PRJNA689790_S_NODE_6773_length_228_cov_2.068063_g6658_i0 | PRJNA689790 | 6773 | 228 | 2.068063 | 4.71518364 | Patescibacteria group bacterium | 2052139 | Bacteria | Bacteria | 42.4 | 0.0431 | NR | MEK7176827.1 | 2052139 | g6658 | i0 | 42.2 | 0.592105263157895 | 45 | 26 | 59.2 | 0 | 92 | 226 | 803 | 847 | MEK7176827.1 glucoamylase family protein [Patescibacteria group bacterium] | diamond | 135 | 42.4 | 1 | Bacteria | Bacteria candidate phyla | Patescibacteria group bacterium | |||||||
| 30745863 | 30745863 | PRJNA689790_S_NODE_4714_length_279_cov_2.190083_g4599_i0 | PRJNA689790 | 4714 | 279 | 2.190083 | 6.11033157 | Candidatus Rokuibacteriota bacterium | 2053607 | Bacteria | Bacteria | 52.4 | 2.88e-6 | NR | PYM77976.1 | 2053607 | g4599 | i0 | 45.5 | 1.54838709677419 | 66 | 35 | 71 | 1 | 228 | 31 | 18 | 82 | PYM77976.1 MAG: hypothetical protein DME03_02090 [Candidatus Rokuibacteriota bacterium] | diamond | 432 | 52.4 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Rokuibacteriota | Candidatus Rokuibacteriota bacterium | ||||||
| 31314672 | 31314672 | PRJNA689790_S_NODE_4335_length_291_cov_2.956693_g4220_i0 | PRJNA689790 | 4335 | 291 | 2.956693 | 8.60397663 | Candidatus Babeliaceae bacterium | 2545253 | Bacteria | Bacteria | 58.2 | 2.66e-7 | NR | HVX00783.1 | 2545253 | g4220 | i0 | 41.3 | 0.77319587628866 | 75 | 44 | 77.3 | 0 | 67 | 291 | 671 | 745 | HVX00783.1 reverse transcriptase domain-containing protein [Candidatus Babeliaceae bacterium] | diamond | 225 | 58.2 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Babeliae | Candidatus Babeliales | Candidatus Babeliaceae | Candidatus Babeliaceae bacterium | ||||
| 31441125 | 31441125 | PRJNA689790_S_NODE_13276_length_165_cov_1.085938_g13161_i0 | PRJNA689790 | 13276 | 165 | 1.085938 | 1.7917977 | Candidatus Roizmanbacteria bacterium | 2282149 | Bacteria | Bacteria | 70.5 | 9.83e-14 | NR | MFS8159965.1 | 2282149 | g13161 | i0 | 67.9 | 0.963636363636364 | 53 | 15 | 96.4 | 1 | 6 | 164 | 61 | 111 | MFS8159965.1 DnaJ domain-containing protein [Candidatus Roizmanbacteria bacterium] | diamond | 159 | 70.5 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Roizmaniibacteriota | Candidatus Roizmanbacteria bacterium | ||||||
| 32232327 | 32232327 | PRJNA689790_S_NODE_13178_length_165_cov_2.109375_g13063_i0 | PRJNA689790 | 13178 | 165 | 2.109375 | 3.48046875 | Candidatus Parcubacteria bacterium | 2762014 | Bacteria | Bacteria | 68.6 | 9.96e-12 | NR | RMD63071.1 | 2762014 | g13063 | i0 | 62 | 1.81818181818182 | 50 | 19 | 90.9 | 0 | 6 | 155 | 325 | 374 | RMD63071.1 MAG: hypothetical protein D6833_06050, partial [Candidatus Parcubacteria bacterium] | diamond | 300 | 68.6 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Parcubacteria | Candidatus Parcubacteria bacterium | ||||||
| 32327383 | 32327383 | PRJNA689790_S_NODE_15459_length_155_cov_1.500000_g15344_i0 | PRJNA689790 | 15459 | 155 | 1.5 | 2.325 | Candidatus Altimarinota bacterium | 2044595 | Bacteria | Bacteria | 43.1 | 0.00832 | NR | MBP7819280.1 | 2044595 | g15344 | i0 | 48.6 | 2.28387096774194 | 37 | 19 | 71.6 | 0 | 8 | 118 | 826 | 862 | MBP7819280.1 DNA polymerase III subunit alpha [Candidatus Altimarinota bacterium] | diamond | 354 | 43.1 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Altimarinota | Candidatus Altimarinota 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);;