contig_metadata
22 rows where analysis = "diamond", bioproject = "PRJNA513467" and tax_clade = "Bacteria candidate phyla"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26617732 | 26617732 | PRJNA513467_S_NODE_1421_length_288_cov_3.661355_g1398_i0 | PRJNA513467 | 1421 | 288 | 3.661355 | 10.5447024 | Bacteria | 2 | Bacteria | Bacteria | 152 | 3.759999999999999e-42 | NR | KKP72965.1 | 1618740 | g1398 | i0 | 86.5 | 3.70833333333333 | 89 | 12 | 92.7 | 0 | 20 | 286 | 25 | 113 | KKP72965.1 MAG: Ribonucleoside-triphosphate reductase, partial [Candidatus Nomurabacteria bacterium GW2011_GWB1_35_20] | diamond | 1068 | 152 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Nomuraibacteriota | Candidatus Nomurabacteria bacterium GW2011_GWB1_35_20 | ||||||
| 27235179 | 27235179 | PRJNA513467_S_NODE_1763_length_265_cov_1.539474_g1740_i0 | PRJNA513467 | 1763 | 265 | 1.539474 | 4.0796061 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 150 | 1.13e-42 | NR | MEX0598106.1 | 2053589 | g1740 | i0 | 76.8 | 1.07547169811321 | 95 | 15 | 99.6 | 1 | 265 | 2 | 44 | 138 | MEX0598106.1 hypothetical protein [Candidatus Paceibacterota bacterium] | diamond | 285 | 150 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 27425055 | 27425055 | PRJNA513467_S_NODE_5303_length_177_cov_1.671429_g5280_i0 | PRJNA513467 | 5303 | 177 | 1.671429 | 2.95842933 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 92 | 6.53e-20 | NR | HEY4505456.1 | 2053589 | g5280 | i0 | 84.7 | 5.93220338983051 | 59 | 9 | 100 | 0 | 177 | 1 | 131 | 189 | HEY4505456.1 lipid II flippase MurJ [Candidatus Paceibacterota bacterium] | diamond | 1050 | 92 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 27614415 | 27614415 | PRJNA513467_S_NODE_2304_length_239_cov_1.252475_g2281_i0 | PRJNA513467 | 2304 | 239 | 1.252475 | 2.99341525 | Microgenomates group bacterium GW2 | 2461418 | Bacteria | Bacteria | 106 | 2.07e-26 | NR | KKU25464.1 | 1618501 | g2281 | i0 | 71.4 | 0.878661087866109 | 70 | 20 | 87.9 | 0 | 3 | 212 | 157 | 226 | KKU25464.1 MAG: methylase N-4/N-6 domain protein [Microgenomates group bacterium GW2011_GWA2_46_16] | diamond | 210 | 106 | 1 | Bacteria | Bacteria candidate phyla | Microgenomates group bacterium GW2011_GWA2_46_16 | |||||||
| 27677701 | 27677701 | PRJNA513467_S_NODE_5524_length_174_cov_2.291971_g5501_i0 | PRJNA513467 | 5524 | 174 | 2.291971 | 3.98802954 | Candidatus Tayloriibacteriota bacterium | 2052153 | Bacteria | Bacteria | 96.7 | 5.62e-23 | NR | MDP3697774.1 | 2052153 | g5501 | i0 | 79.6 | 0.931034482758621 | 54 | 11 | 93.1 | 0 | 3 | 164 | 39 | 92 | MDP3697774.1 DedA family protein [Candidatus Taylorbacteria bacterium] | diamond | 162 | 96.7 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Tayloriibacteriota | Candidatus Tayloriibacteriota bacterium | ||||||
| 27961552 | 27961552 | PRJNA513467_S_NODE_1885_length_258_cov_3.212670_g1862_i0 | PRJNA513467 | 1885 | 258 | 3.21267 | 8.2886886 | Candidatus Magasanikiibacteriota bacterium | 2026717 | Bacteria | Bacteria | 149 | 1.34e-41 | NR | MBI2037977.1 | 2026717 | g1862 | i0 | 81.4 | 4 | 86 | 16 | 100 | 0 | 1 | 258 | 55 | 140 | MBI2037977.1 rod shape-determining protein RodA [Candidatus Magasanikiibacteriota bacterium] | diamond | 1032 | 149 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Magasanikiibacteriota | Candidatus Magasanikiibacteriota bacterium | ||||||
| 28340442 | 28340442 | PRJNA513467_S_NODE_7846_length_154_cov_1.333333_g7823_i0 | PRJNA513467 | 7846 | 154 | 1.333333 | 2.05333282 | Candidatus Berkelbacteria bacterium | 2053521 | Bacteria | Bacteria | 99.8 | 9.43e-23 | NR | MDH4358797.1 | 2053521 | g7823 | i0 | 88.2 | 1.96753246753247 | 51 | 6 | 99.4 | 0 | 2 | 154 | 227 | 277 | MDH4358797.1 valine--tRNA ligase [Candidatus Berkelbacteria bacterium] | diamond | 303 | 99.8 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Berkelbacteria | Candidatus Berkelbacteria bacterium | ||||||
| 29019200 | 29019200 | PRJNA513467_S_NODE_2588_length_228_cov_2.612565_g2565_i0 | PRJNA513467 | 2588 | 228 | 2.612565 | 5.9566482 | Bacteria | 2 | Bacteria | Bacteria | 87 | 7.46e-18 | NR | KKS96225.1 | 1618521 | g2565 | i0 | 70.8 | 1.89473684210526 | 72 | 20 | 94.7 | 1 | 227 | 12 | 210 | 280 | KKS96225.1 MAG: hypothetical protein UV71_C0001G0099 [Microgenomates group bacterium GW2011_GWC1_43_13] | diamond | 432 | 87 | 1 | Bacteria | Bacteria candidate phyla | Microgenomates group bacterium GW2011_GWC1_43_13 | |||||||
| 29161618 | 29161618 | PRJNA513467_S_NODE_5969_length_170_cov_1.052632_g5946_i0 | PRJNA513467 | 5969 | 170 | 1.052632 | 1.7894744 | Candidatus Levyibacteriota bacterium | 2052151 | Bacteria | Bacteria | 60.8 | 5.6e-9 | NR | MDO8658572.1 | 2052151 | g5946 | i0 | 58.7 | 0.811764705882353 | 46 | 19 | 81.2 | 0 | 141 | 4 | 192 | 237 | MDO8658572.1 glycosyltransferase family 39 protein [Candidatus Levyibacteriota bacterium] | diamond | 138 | 60.8 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Levyibacteriota | Candidatus Levyibacteriota bacterium | ||||||
| 29193122 | 29193122 | PRJNA513467_S_NODE_7909_length_153_cov_2.612069_g7886_i0 | PRJNA513467 | 7909 | 153 | 2.612069 | 3.99646557 | Candidatus Levybacteria bacterium RBG_16_35_11 | 1798584 | Bacteria | Bacteria | 66.6 | 1.81e-11 | NR | OGH05949.1 | 1798584 | g7886 | i0 | 59.2 | 0.96078431372549 | 49 | 20 | 96.1 | 0 | 5 | 151 | 35 | 83 | OGH05949.1 MAG: hypothetical protein A2W22_03405 [Candidatus Levybacteria bacterium RBG_16_35_11] | diamond | 147 | 66.6 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Levyibacteriota | Candidatus Levybacteria bacterium RBG_16_35_11 | ||||||
| 29271281 | 29271281 | PRJNA513467_S_NODE_1729_length_267_cov_2.034783_g1706_i0 | PRJNA513467 | 1729 | 267 | 2.034783 | 5.43287061 | Bacillati | 1783272 | Bacteria | Bacteria | 70.1 | 1.1e-11 | NR | NDK07858.1 | 2044595 | g1706 | i0 | 45.1 | 1.91011235955056 | 82 | 30 | 92.1 | 1 | 247 | 2 | 150 | 216 | NDK07858.1 DUF1073 domain-containing protein [Candidatus Altimarinota bacterium] | diamond | 510 | 70.1 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Altimarinota | Candidatus Altimarinota bacterium | ||||||
| 29634587 | 29634587 | PRJNA513467_S_NODE_1950_length_255_cov_1.724771_g1927_i0 | PRJNA513467 | 1950 | 255 | 1.724771 | 4.39816605 | Patescibacteria group bacterium | 2052139 | Bacteria | Bacteria | 124 | 2.24e-31 | NR | MEK7570658.1 | 2052139 | g1927 | i0 | 77.2 | 0.929411764705882 | 79 | 18 | 92.9 | 0 | 10 | 246 | 92 | 170 | MEK7570658.1 glycosyltransferase family 39 protein [Patescibacteria group bacterium] | diamond | 237 | 124 | 1 | Bacteria | Bacteria candidate phyla | Patescibacteria group bacterium | |||||||
| 29697711 | 29697711 | PRJNA513467_S_NODE_1130_length_314_cov_2.805054_g1107_i0 | PRJNA513467 | 1130 | 314 | 2.805054 | 8.80786956 | Candidatus Curtissbacteria bacterium | 2750075 | Bacteria | Bacteria | 181 | 3.04e-53 | NR | MDP2632354.1 | 2750075 | g1107 | i0 | 82.7 | 0.993630573248408 | 104 | 18 | 99.4 | 0 | 1 | 312 | 129 | 232 | MDP2632354.1 glycosyltransferase family 4 protein [Candidatus Curtissbacteria bacterium] | diamond | 312 | 181 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Curtissiibacteriota | Candidatus Curtissbacteria bacterium | ||||||
| 30503367 | 30503367 | PRJNA513467_S_NODE_1993_length_253_cov_2.962963_g1970_i0 | PRJNA513467 | 1993 | 253 | 2.962963 | 7.49629639 | Bacteria | 2 | Bacteria | Bacteria | 114 | 1.69e-29 | NR | MEK7635454.1 | 2052139 | g1970 | i0 | 74.7 | 5.300395256917 | 75 | 19 | 88.9 | 0 | 3 | 227 | 129 | 203 | MEK7635454.1 site-2 protease family protein [Patescibacteria group bacterium] | diamond | 1341 | 114 | 1 | Bacteria | Bacteria candidate phyla | Patescibacteria group bacterium | |||||||
| 30614154 | 30614154 | PRJNA513467_S_NODE_3093_length_214_cov_2.401130_g3070_i0 | PRJNA513467 | 3093 | 214 | 2.40113 | 5.1384182 | Candidatus Taylorbacteria bacterium RIFCSPHIGHO2_ | 1802301 | Bacteria | Bacteria | 105 | 6.97e-25 | NR | OHA17896.1 | 1802301 | g3070 | i0 | 74.6 | 0.995327102803738 | 71 | 18 | 99.5 | 0 | 214 | 2 | 219 | 289 | OHA17896.1 MAG: hypothetical protein A2664_00215 [Candidatus Taylorbacteria bacterium RIFCSPHIGHO2_01_FULL_46_22b] | diamond | 213 | 105 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Tayloriibacteriota | Candidatus Taylorbacteria bacterium RIFCSPHIGHO2_01_FULL_46_22b | ||||||
| 31356661 | 31356661 | PRJNA513467_S_NODE_6216_length_167_cov_1.907692_g6193_i0 | PRJNA513467 | 6216 | 167 | 1.907692 | 3.18584564 | Bacteria | 2 | Bacteria | Bacteria | 79.7 | 1.22e-15 | NR | KKP80530.1 | 1618861 | g6193 | i0 | 65.5 | 1.97604790419162 | 55 | 19 | 98.8 | 0 | 166 | 2 | 80 | 134 | KKP80530.1 MAG: FAD dependent oxidoreductase, partial [Parcubacteria group bacterium GW2011_GWB1_35_5] | diamond | 330 | 79.7 | 1 | Bacteria | Bacteria candidate phyla | Parcubacteria group bacterium GW2011_GWB1_35_5 | |||||||
| 31388318 | 31388318 | PRJNA513467_S_NODE_5876_length_171_cov_1.104478_g5853_i0 | PRJNA513467 | 5876 | 171 | 1.104478 | 1.88865738 | Bacteria | 2 | Bacteria | Bacteria | 107 | 9.32e-26 | NR | KKS03999.1 | 1618736 | g5853 | i0 | 94.6 | 7.85964912280702 | 56 | 3 | 98.2 | 0 | 2 | 169 | 123 | 178 | KKS03999.1 MAG: Histidine-tRNA ligase [Candidatus Nomurabacteria bacterium GW2011_GWA2_41_25] | diamond | 1344 | 108 | 0.990740740740741 | Bacteria | Bacteria candidate phyla | Candidatus Nomuraibacteriota | Candidatus Nomurabacteria bacterium GW2011_GWA2_41_25 | ||||||
| 32132128 | 32132128 | PRJNA513467_S_NODE_2818_length_221_cov_1.951087_g2795_i0 | PRJNA513467 | 2818 | 221 | 1.951087 | 4.31190227 | Candidatus Saccharimonadota bacterium | 2026720 | Bacteria | Bacteria | 114 | 3.18e-28 | NR | MDB5183494.1 | 2026720 | g2795 | i0 | 78.6 | 1.91402714932127 | 70 | 15 | 95 | 0 | 211 | 2 | 33 | 102 | MDB5183494.1 exported protein of unknown function [Candidatus Saccharibacteria bacterium] | diamond | 423 | 114 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadota bacterium | ||||||
| 32147433 | 32147433 | PRJNA513467_S_NODE_4738_length_184_cov_1.945578_g4715_i0 | PRJNA513467 | 4738 | 184 | 1.945578 | 3.57986352 | Bacteria | 2 | Bacteria | Bacteria | 110 | 1.89e-26 | NR | KND46766.1 | 1659200 | g4715 | i0 | 93.4 | 3.97826086956522 | 61 | 4 | 99.5 | 0 | 2 | 184 | 247 | 307 | KND46766.1 MAG: virulence factor [Parcubacteria bacterium C7867-006] | diamond | 732 | 110 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Parcubacteria | Parcubacteria bacterium C7867-006 | ||||||
| 32700679 | 32700679 | PRJNA513467_S_NODE_4300_length_191_cov_1.012987_g4277_i0 | PRJNA513467 | 4300 | 191 | 1.012987 | 1.93480517 | Patescibacteria group bacterium | 2052139 | Bacteria | Bacteria | 82.4 | 3.24e-17 | NR | MCL6096485.1 | 2052139 | g4277 | i0 | 60.3 | 3.94240837696335 | 63 | 25 | 99 | 0 | 189 | 1 | 75 | 137 | MCL6096485.1 NTP transferase domain-containing protein [Patescibacteria group bacterium] | diamond | 753 | 82.4 | 1 | Bacteria | Bacteria candidate phyla | Patescibacteria group bacterium | |||||||
| 32700680 | 32700680 | PRJNA513467_S_NODE_7000_length_160_cov_1.585366_g6977_i0 | PRJNA513467 | 7000 | 160 | 1.585366 | 2.5365856 | Candidatus Niyogibacteria bacterium | 2750078 | Bacteria | Bacteria | 43.9 | 0.00206 | NR | MBI2038746.1 | 2750078 | g6977 | i0 | 69.4 | 0.675 | 36 | 10 | 67.5 | 1 | 3 | 110 | 104 | 138 | MBI2038746.1 30S ribosomal protein S6 [Candidatus Niyogibacteria bacterium] | diamond | 108 | 43.9 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Niyogiibacteriota | Candidatus Niyogibacteria bacterium | ||||||
| 32732450 | 32732450 | PRJNA513467_S_NODE_1900_length_257_cov_3.081818_g1877_i0 | PRJNA513467 | 1900 | 257 | 3.081818 | 7.92027226 | Candidatus Jorgensenbacteria bacterium GW2 | 2268185 | Bacteria | Bacteria | 109 | 3.73e-26 | NR | KKU91415.1 | 1618660 | g1877 | i0 | 61 | 0.957198443579767 | 82 | 31 | 95.7 | 1 | 257 | 12 | 99 | 179 | KKU91415.1 MAG: PDK repeat-containing protein [Candidatus Jorgensenbacteria bacterium GW2011_GWA1_48_11] | diamond | 246 | 109 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Joergenseniibacteriota | Candidatus Jorgensenbacteria bacterium GW2011_GWA1_48_11 |
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);;