contig_metadata
27 rows where analysis = "diamond", bioproject = "PRJNA421571" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 423020 | 423020 | PRJNA421571_P_NODE_41641_length_451_cov_2.275132_g39093_i0 | PRJNA421571 | 41641 | 451 | 2.275132 | 10.26084532 | Bacteria | 2 | Bacteria | Bacteria | 181 | 1.8499999999999996e-55 | NR | HLP77548.1 | 2053589 | g39093 | i0 | 74.5 | 17.5410199556541 | 110 | 27 | 73.2 | 1 | 3 | 332 | 51 | 159 | HLP77548.1 glycosidase [Candidatus Paceibacterota bacterium] | diamond | 7911 | 181 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 4248889 | 4248889 | PRJNA421571_P_NODE_102364_length_244_cov_0.900585_g99815_i0 | PRJNA421571 | 102364 | 244 | 0.900585 | 2.1974274 | candidate division WOR-3 bacterium | 2052148 | Bacteria | Bacteria | 112 | 1.13e-26 | NR | MEO0261614.1 | 2052148 | g99815 | i0 | 68.8 | 3.9344262295082 | 80 | 25 | 98.4 | 0 | 242 | 3 | 293 | 372 | MEO0261614.1 pyruvate, phosphate dikinase [candidate division WOR-3 bacterium] | diamond | 960 | 112 | 1 | Bacteria | Bacteria candidate phyla | candidate division WOR-3 | candidate division WOR-3 bacterium | ||||||
| 26600502 | 26600502 | PRJNA421571_P_NODE_19641_length_807_cov_4.460490_g17392_i0 | PRJNA421571 | 19641 | 807 | 4.46049 | 35.9961543 | Candidatus Altimarinota bacterium | 2044595 | Bacteria | Bacteria | 60.8 | 1.19e-6 | NR | NUJ98053.1 | 2044595 | g17392 | i0 | 47.1 | 0.315985130111524 | 85 | 42 | 30.5 | 2 | 266 | 21 | 236 | 320 | NUJ98053.1 hypothetical protein [Candidatus Altimarinota bacterium] | diamond | 255 | 60.8 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Altimarinota | Candidatus Altimarinota bacterium | ||||||
| 26917468 | 26917468 | PRJNA421571_P_NODE_82742_length_270_cov_2.091371_g80193_i0 | PRJNA421571 | 82742 | 270 | 2.091371 | 5.6467017 | Candidatus Altimarinota bacterium | 2044595 | Bacteria | Bacteria | 79.7 | 4.95e-15 | NR | MBW7954622.1 | 2044595 | g80193 | i0 | 55.8 | 0.855555555555556 | 77 | 34 | 85.6 | 0 | 256 | 26 | 471 | 547 | MBW7954622.1 serine/threonine-protein phosphatase [Candidatus Altimarinota bacterium] | diamond | 231 | 79.7 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Altimarinota | Candidatus Altimarinota bacterium | ||||||
| 27391858 | 27391858 | PRJNA421571_P_NODE_103363_length_243_cov_0.905882_g100814_i0 | PRJNA421571 | 103363 | 243 | 0.905882 | 2.20129326 | Candidatus Eiseniibacteriota bacterium | 2212470 | Bacteria | Bacteria | 66.6 | 1.42e-10 | NR | MBM3317418.1 | 2212470 | g100814 | i0 | 47.1 | 3.51851851851852 | 68 | 36 | 84 | 0 | 36 | 239 | 15 | 82 | MBM3317418.1 histidine kinase [Candidatus Eiseniibacteriota bacterium] | diamond | 855 | 66.6 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Eiseniibacteriota | Candidatus Eiseniibacteriota bacterium | ||||||
| 27644549 | 27644549 | PRJNA421571_P_NODE_70184_length_303_cov_1.339130_g67635_i0 | PRJNA421571 | 70184 | 303 | 1.33913 | 4.0575639 | Candidatus Abawacabacteria bacterium | 2750071 | Bacteria | Bacteria | 47.4 | 0.00168 | NR | MBI4836026.1 | 2750071 | g67635 | i0 | 32.3 | 2.85148514851485 | 96 | 56 | 95 | 3 | 295 | 8 | 185 | 271 | MBI4836026.1 hypothetical protein [Candidatus Abawacabacteria bacterium] | diamond | 864 | 47.4 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Abawacaibacteriota | Candidatus Abawacabacteria bacterium | ||||||
| 27707954 | 27707954 | PRJNA421571_P_NODE_98444_length_247_cov_0.885057_g95895_i0 | PRJNA421571 | 98444 | 247 | 0.885057 | 2.18609079 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 59.3 | 4.96e-8 | NR | HXK31341.1 | 2053589 | g95895 | i0 | 42.9 | 0.935222672064777 | 77 | 44 | 93.5 | 0 | 240 | 10 | 77 | 153 | HXK31341.1 GTPase [Candidatus Paceibacterota bacterium] | diamond | 231 | 59.3 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 27850167 | 27850167 | PRJNA421571_P_NODE_49604_length_392_cov_5.247649_g47056_i0 | PRJNA421571 | 49604 | 392 | 5.247649 | 20.57078408 | Bacteria | 2 | Bacteria | Bacteria | 139 | 4.09e-40 | NR | RAL57832.1 | 1912928 | g47056 | i0 | 87.5 | 1.82142857142857 | 80 | 10 | 61.2 | 0 | 92 | 331 | 1 | 80 | RAL57832.1 50S ribosomal protein L34 [Candidatus Gracilibacteria bacterium GN02-872] | diamond | 714 | 140 | 0.992857142857143 | Bacteria | Bacteria candidate phyla | Candidatus Altimarinota | Candidatus Gracilibacteria bacterium GN02-872 | ||||||
| 27865197 | 27865197 | PRJNA421571_P_NODE_69685_length_305_cov_0.866379_g67136_i0 | PRJNA421571 | 69685 | 305 | 0.866379 | 2.64245595 | Candidatus Saccharimonadales bacterium | 2973664 | Bacteria | Bacteria | 46.6 | 0.00331 | NR | HXI03216.1 | 2973664 | g67136 | i0 | 34.4 | 2.67540983606557 | 96 | 53 | 89.5 | 2 | 273 | 1 | 357 | 447 | HXI03216.1 DUF5700 domain-containing putative Zn-dependent protease [Candidatus Saccharimonadales bacterium] | diamond | 816 | 46.6 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadia | Candidatus Saccharimonadales | Candidatus Saccharimonadales bacterium | ||||
| 28149591 | 28149591 | PRJNA421571_P_NODE_107265_length_239_cov_2.596386_g104716_i0 | PRJNA421571 | 107265 | 239 | 2.596386 | 6.20536254 | Candidatus Altimarinota bacterium | 2044595 | Bacteria | Bacteria | 77.8 | 1.59e-14 | NR | MDD3793364.1 | 2044595 | g104716 | i0 | 62.1 | 0.728033472803347 | 58 | 22 | 72.8 | 0 | 176 | 3 | 595 | 652 | MDD3793364.1 ABC transporter substrate-binding protein [Candidatus Altimarinota bacterium] | diamond | 174 | 77.8 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Altimarinota | Candidatus Altimarinota bacterium | ||||||
| 28418877 | 28418877 | PRJNA421571_P_NODE_93286_length_250_cov_0.870056_g90737_i0 | PRJNA421571 | 93286 | 250 | 0.870056 | 2.17514 | Haliangium | 162027 | Bacteria | Bacteria | 52.8 | 4.59e-6 | NR | MFH1867296.1 | 2052139 | g90737 | i0 | 34.2 | 3.732 | 79 | 46 | 94.8 | 2 | 9 | 245 | 101 | 173 | MFH1867296.1 dihydrofolate reductase [Patescibacteria group bacterium] | diamond | 933 | 53.1 | 0.994350282485876 | Bacteria | Bacteria candidate phyla | Patescibacteria group bacterium | |||||||
| 28528571 | 28528571 | PRJNA421571_P_NODE_43807_length_433_cov_1.325000_g41259_i0 | PRJNA421571 | 43807 | 433 | 1.325 | 5.73725 | Candidatus Altimarinota bacterium | 2044595 | Bacteria | Bacteria | 103 | 1.23e-24 | NR | MCP4522908.1 | 2044595 | g41259 | i0 | 57.3 | 1.48267898383372 | 103 | 43 | 71.4 | 1 | 29 | 337 | 1 | 102 | MCP4522908.1 peptidylprolyl isomerase [Candidatus Altimarinota bacterium] | diamond | 642 | 103 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Altimarinota | Candidatus Altimarinota bacterium | ||||||
| 29286061 | 29286061 | PRJNA421571_P_NODE_90049_length_254_cov_1.701657_g87500_i0 | PRJNA421571 | 90049 | 254 | 1.701657 | 4.32220878 | Candidatus Altimarinota bacterium | 2044595 | Bacteria | Bacteria | 114 | 1.9400000000000003e-27 | NR | MCD5380357.1 | 2044595 | g87500 | i0 | 72 | 0.968503937007874 | 82 | 23 | 96.9 | 0 | 247 | 2 | 48 | 129 | MCD5380357.1 protein translocase subunit SecD [Candidatus Altimarinota bacterium] | diamond | 246 | 114 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Altimarinota | Candidatus Altimarinota bacterium | ||||||
| 29917868 | 29917868 | PRJNA421571_P_NODE_90991_length_252_cov_1.720670_g88442_i0 | PRJNA421571 | 90991 | 252 | 1.72067 | 4.3360884 | Candidatus Curtissbacteria bacterium GW2 | 2750075 | Bacteria | Bacteria | 146 | 3.1199999999999998e-43 | NR | KKS03823.1 | 1618411 | g88442 | i0 | 71.1 | 1.96428571428571 | 83 | 23 | 97.6 | 1 | 5 | 250 | 29 | 111 | KKS03823.1 MAG: Methionine sulfoxide reductase B [Candidatus Curtissbacteria bacterium GW2011_GWA2_41_24] | diamond | 495 | 146 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Curtissiibacteriota | Candidatus Curtissbacteria bacterium GW2011_GWA2_41_24 | ||||||
| 30201807 | 30201807 | PRJNA421571_P_NODE_94852_length_249_cov_0.875000_g92303_i0 | PRJNA421571 | 94852 | 249 | 0.875 | 2.17875 | Candidatus Sumerlaeia bacterium | 2715255 | Bacteria | Bacteria | 98.2 | 1.47e-22 | NR | MBX3728864.1 | 2715255 | g92303 | i0 | 58.1 | 6.96385542168675 | 86 | 32 | 98.8 | 1 | 247 | 2 | 164 | 249 | MBX3728864.1 bifunctional methylenetetrahydrofolate dehydrogenase/methenyltetrahydrofolate cyclohydrolase FolD [Candidatus Sumerlaeia bacterium] | diamond | 1734 | 98.2 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Sumerlaeota | Candidatus Sumerlaeia | Candidatus Sumerlaeia bacterium | |||||
| 30360463 | 30360463 | PRJNA421571_P_NODE_106492_length_241_cov_0.916667_g103943_i0 | PRJNA421571 | 106492 | 241 | 0.916667 | 2.20916747 | Candidatus Nomurabacteria bacterium | 2052152 | Bacteria | Bacteria | 106 | 2.8499999999999997e-25 | NR | MDB5188990.1 | 2052152 | g103943 | i0 | 62 | 1.96680497925311 | 79 | 29 | 98.3 | 1 | 5 | 241 | 27 | 104 | MDB5188990.1 UDP-galactopyranose mutase [Candidatus Nomurabacteria bacterium] | diamond | 474 | 106 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Nomuraibacteriota | Candidatus Nomurabacteria bacterium | ||||||
| 30675814 | 30675814 | PRJNA421571_P_NODE_84613_length_266_cov_1.595855_g82064_i0 | PRJNA421571 | 84613 | 266 | 1.595855 | 4.2449743 | Candidatus Poribacteria bacterium | 2026781 | Bacteria | Bacteria | 119 | 3.54e-30 | NR | HIE27714.1 | 2026781 | g82064 | i0 | 70.1 | 1.73684210526316 | 77 | 22 | 86.8 | 1 | 266 | 36 | 108 | 183 | HIE27714.1 histone deacetylase family protein [Candidatus Poribacteria bacterium] | diamond | 462 | 119 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Poribacteria | Candidatus Poribacteria bacterium | ||||||
| 30707528 | 30707528 | PRJNA421571_P_NODE_81514_length_273_cov_1.540000_g78965_i0 | PRJNA421571 | 81514 | 273 | 1.54 | 4.2042 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 43.5 | 0.0286 | NR | MFA5987375.1 | 2053589 | g78965 | i0 | 47.9 | 0.527472527472527 | 48 | 23 | 50.5 | 1 | 23 | 160 | 299 | 346 | MFA5987375.1 LamG domain-containing protein [Candidatus Paceibacterota bacterium] | diamond | 144 | 43.5 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 30739113 | 30739113 | PRJNA421571_P_NODE_88274_length_258_cov_1.610811_g85725_i0 | PRJNA421571 | 88274 | 258 | 1.610811 | 4.15589238 | Candidatus Altimarinota bacterium | 2044595 | Bacteria | Bacteria | 46.6 | 0.00193 | NR | MDD5769450.1 | 2044595 | g85725 | i0 | 44.4 | 0.627906976744186 | 54 | 29 | 61.6 | 1 | 161 | 3 | 7 | 60 | MDD5769450.1 ATP-dependent zinc metalloprotease FtsH [Candidatus Altimarinota bacterium] | diamond | 162 | 46.6 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Altimarinota | Candidatus Altimarinota bacterium | ||||||
| 30739118 | 30739118 | PRJNA421571_P_NODE_97234_length_247_cov_1.770115_g94685_i0 | PRJNA421571 | 97234 | 247 | 1.770115 | 4.37218405 | Candidatus Altimarinota bacterium | 2044595 | Bacteria | Bacteria | 78.6 | 8.91e-15 | NR | MBW7954726.1 | 2044595 | g94685 | i0 | 53.8 | 1.79757085020243 | 78 | 36 | 94.7 | 0 | 247 | 14 | 132 | 209 | MBW7954726.1 hypothetical protein [Candidatus Altimarinota bacterium] | diamond | 444 | 78.6 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Altimarinota | Candidatus Altimarinota bacterium | ||||||
| 30897318 | 30897318 | PRJNA421571_P_NODE_79994_length_277_cov_1.348039_g77445_i0 | PRJNA421571 | 79994 | 277 | 1.348039 | 3.73406803 | Candidatus Aminicenantes bacterium | 2052149 | Bacteria | Bacteria | 43.9 | 0.0197 | NR | MBD3414519.1 | 2052149 | g77445 | i0 | 36.4 | 0.595667870036101 | 55 | 29 | 56.3 | 2 | 117 | 272 | 17 | 68 | MBD3414519.1 methyltransferase domain-containing protein [Candidatus Aminicenantes bacterium] | diamond | 165 | 43.9 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Aminicenantota | Candidatus Aminicenantes bacterium | ||||||
| 31023557 | 31023557 | PRJNA421571_P_NODE_86215_length_263_cov_0.957895_g83666_i0 | PRJNA421571 | 86215 | 263 | 0.957895 | 2.51926385 | Candidatus Eiseniibacteriota bacterium | 2212470 | Bacteria | Bacteria | 45.4 | 0.00534 | NR | MCK4414305.1 | 2212470 | g83666 | i0 | 43.3 | 0.684410646387833 | 60 | 28 | 61.6 | 2 | 205 | 44 | 320 | 379 | MCK4414305.1 PASTA domain-containing protein [Candidatus Eiseniibacteriota bacterium] | diamond | 180 | 45.4 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Eiseniibacteriota | Candidatus Eiseniibacteriota bacterium | ||||||
| 31055420 | 31055420 | PRJNA421571_P_NODE_82535_length_271_cov_1.222222_g79986_i0 | PRJNA421571 | 82535 | 271 | 1.222222 | 3.31222162 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 45.1 | 0.00754 | NR | HXK31341.1 | 2053589 | g79986 | i0 | 45.5 | 0.487084870848708 | 44 | 24 | 48.7 | 0 | 47 | 178 | 98 | 141 | HXK31341.1 GTPase [Candidatus Paceibacterota bacterium] | diamond | 132 | 45.1 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 31466321 | 31466321 | PRJNA421571_P_NODE_89416_length_255_cov_2.505495_g86867_i0 | PRJNA421571 | 89416 | 255 | 2.505495 | 6.38901225 | Candidatus Altimarinota bacterium | 2044595 | Bacteria | Bacteria | 87.4 | 1.32e-18 | NR | MDD5770450.1 | 2044595 | g86867 | i0 | 55.3 | 1.90588235294118 | 85 | 37 | 98.8 | 1 | 254 | 3 | 129 | 213 | MDD5770450.1 hypothetical protein [Candidatus Altimarinota bacterium] | diamond | 486 | 87.4 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Altimarinota | Candidatus Altimarinota bacterium | ||||||
| 31687477 | 31687477 | PRJNA421571_P_NODE_82957_length_270_cov_1.329949_g80408_i0 | PRJNA421571 | 82957 | 270 | 1.329949 | 3.5908623 | Candidatus Altimarinota bacterium | 2044595 | Bacteria | Bacteria | 105 | 7.59e-26 | NR | NVP17780.1 | 2044595 | g80408 | i0 | 56.7 | 1 | 90 | 38 | 98.9 | 1 | 269 | 3 | 63 | 152 | NVP17780.1 hypothetical protein [Candidatus Altimarinota bacterium] | diamond | 270 | 105 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Altimarinota | Candidatus Altimarinota bacterium | ||||||
| 31877155 | 31877155 | PRJNA421571_P_NODE_61117_length_335_cov_1.461832_g58568_i0 | PRJNA421571 | 61117 | 335 | 1.461832 | 4.8971372 | Patescibacteria group bacterium | 2052139 | Bacteria | Bacteria | 43.1 | 0.0248 | NR | MDP6571626.1 | 2052139 | g58568 | i0 | 31 | 0.895522388059702 | 100 | 61 | 84.2 | 2 | 293 | 12 | 9 | 106 | MDP6571626.1 glycosyltransferase [Patescibacteria group bacterium] | diamond | 300 | 43.1 | 1 | Bacteria | Bacteria candidate phyla | Patescibacteria group bacterium | |||||||
| 32098783 | 32098783 | PRJNA421571_P_NODE_97818_length_247_cov_0.885057_g95269_i0 | PRJNA421571 | 97818 | 247 | 0.885057 | 2.18609079 | Candidatus Schekmanbacteria bacterium | 2419984 | Bacteria | Bacteria | 51.6 | 2.99e-5 | NR | MBI2567769.1 | 2419984 | g95269 | i0 | 42.9 | 0.935222672064777 | 77 | 34 | 93.5 | 4 | 244 | 14 | 416 | 482 | MBI2567769.1 5-histidylcysteine sulfoxide synthase [Candidatus Schekmanbacteria bacterium] | diamond | 231 | 51.6 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Schekmaniibacteriota | Candidatus Schekmanbacteria 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);;