contig_metadata
18 rows where analysis = "diamond", bioproject = "PRJNA670521" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 10842290 | 10842290 | PRJNA670521_P_NODE_59369_length_274_cov_1.532338_g58624_i0 | PRJNA670521 | 59369 | 274 | 1.532338 | 4.19860612 | Bacteria | 2 | Bacteria | Bacteria | 134 | 2.64e-34 | NR | HUZ07743.1 | 2053589 | g58624 | i0 | 70.8 | 23.6167883211679 | 89 | 26 | 97.4 | 0 | 267 | 1 | 215 | 303 | HUZ07743.1 aminomethyl-transferring glycine dehydrogenase [Candidatus Paceibacterota bacterium] | diamond | 6471 | 135 | 0.992592592592593 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 21040698 | 21040698 | PRJNA670521_P_NODE_51657_length_292_cov_1.054795_g50912_i0 | PRJNA670521 | 51657 | 292 | 1.054795 | 3.0800014 | root | 1 | Root_unresolved | Root_unresolved | 128 | 1.1e-35 | NR | KKU52863.1 | 1618839 | g50912 | i0 | 77.6 | 29.0650684931507 | 76 | 17 | 78.1 | 0 | 229 | 2 | 3 | 78 | KKU52863.1 MAG: hypothetical protein UX72_C0001G0040 [Parcubacteria group bacterium GW2011_GWA2_47_10] | diamond | 8487 | 129 | 0.992248062015504 | Bacteria | Bacteria candidate phyla | Parcubacteria group bacterium GW2011_GWA2_47_10 | |||||||
| 27176325 | 27176325 | PRJNA670521_P_NODE_56942_length_280_cov_1.115942_g56197_i0 | PRJNA670521 | 56942 | 280 | 1.115942 | 3.1246376 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 57.4 | 4.12e-7 | NR | MEZ0208986.1 | 2053589 | g56197 | i0 | 29.9 | 0.932142857142857 | 87 | 60 | 92.1 | 1 | 260 | 3 | 1357 | 1443 | MEZ0208986.1 hypothetical protein [Candidatus Paceibacterota bacterium] | diamond | 261 | 57.4 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 27934582 | 27934582 | PRJNA670521_P_NODE_44485_length_310_cov_1.299578_g43740_i0 | PRJNA670521 | 44485 | 310 | 1.299578 | 4.0286918 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 58.9 | 1.36e-7 | NR | MEZ0209065.1 | 2053589 | g43740 | i0 | 36.4 | 0.958064516129032 | 99 | 60 | 95.8 | 2 | 299 | 3 | 202 | 297 | MEZ0209065.1 hypothetical protein [Candidatus Paceibacterota bacterium] | diamond | 297 | 58.9 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 28597694 | 28597694 | PRJNA670521_P_NODE_33467_length_346_cov_1.058608_g32722_i0 | PRJNA670521 | 33467 | 346 | 1.058608 | 3.66278368 | Candidatus Magasanikiibacteriota bacterium | 2026717 | Bacteria | Bacteria | 60.5 | 6.71e-8 | NR | MFA7245001.1 | 2026717 | g32722 | i0 | 43.9 | 1.04913294797688 | 66 | 37 | 57.2 | 0 | 338 | 141 | 139 | 204 | MFA7245001.1 hypothetical protein [Candidatus Magasanikiibacteriota bacterium] | diamond | 363 | 60.5 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Magasanikiibacteriota | Candidatus Magasanikiibacteriota bacterium | ||||||
| 29197623 | 29197623 | PRJNA670521_P_NODE_20169_length_420_cov_1.213256_g19426_i0 | PRJNA670521 | 20169 | 420 | 1.213256 | 5.0956752 | Candidatus Altimarinota bacterium | 2044595 | Bacteria | Bacteria | 44.7 | 0.0246 | NR | MFA5917467.1 | 2044595 | g19426 | i0 | 34 | 0.757142857142857 | 106 | 64 | 72.9 | 3 | 46 | 351 | 23 | 126 | MFA5917467.1 NYN domain-containing protein [Candidatus Altimarinota bacterium] | diamond | 318 | 44.7 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Altimarinota | Candidatus Altimarinota bacterium | ||||||
| 29576133 | 29576133 | PRJNA670521_P_NODE_69730_length_251_cov_2.219101_g68985_i0 | PRJNA670521 | 69730 | 251 | 2.219101 | 5.56994351 | Candidatus Poribacteria bacterium | 2026781 | Bacteria | Bacteria | 42.7 | 0.0151 | NR | MDE0556523.1 | 2026781 | g68985 | i0 | 38.9 | 0.860557768924303 | 72 | 38 | 81.3 | 2 | 246 | 43 | 57 | 126 | MDE0556523.1 hypothetical protein [Candidatus Poribacteria bacterium] | diamond | 216 | 42.7 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Poribacteria | Candidatus Poribacteria bacterium | ||||||
| 30018640 | 30018640 | PRJNA670521_P_NODE_13551_length_495_cov_2.552133_g12813_i0 | PRJNA670521 | 13551 | 495 | 2.552133 | 12.63305835 | Candidatus Harrisonbacteria bacterium | 2528272 | Bacteria | Bacteria | 46.2 | 0.0259 | NR | MBI2024506.1 | 2528272 | g12813 | i0 | 25.2 | 0.672727272727273 | 111 | 72 | 60.6 | 2 | 79 | 378 | 368 | 478 | MBI2024506.1 hypothetical protein [Candidatus Harrisonbacteria bacterium] | diamond | 333 | 46.2 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Harrisoniibacteriota | Candidatus Harrisonbacteria bacterium | ||||||
| 30176405 | 30176405 | PRJNA670521_P_NODE_88072_length_243_cov_0.905882_g87327_i0 | PRJNA670521 | 88072 | 243 | 0.905882 | 2.20129326 | Candidatus Levyibacteriota bacterium | 2052151 | Bacteria | Bacteria | 48.9 | 2.51e-4 | NR | MBA3724598.1 | 2052151 | g87327 | i0 | 42.1 | 1.64197530864198 | 57 | 31 | 70.4 | 1 | 14 | 184 | 811 | 865 | MBA3724598.1 RNA-directed DNA polymerase [Candidatus Levyibacteriota bacterium] | diamond | 399 | 48.9 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Levyibacteriota | Candidatus Levyibacteriota bacterium | ||||||
| 30713571 | 30713571 | PRJNA670521_P_NODE_63034_length_266_cov_1.295337_g62289_i0 | PRJNA670521 | 63034 | 266 | 1.295337 | 3.44559642 | Parcubacteria group bacterium | 2026774 | Bacteria | Bacteria | 68.6 | 2.29e-12 | NR | MBI4127537.1 | 2026774 | g62289 | i0 | 61.7 | 3.38345864661654 | 60 | 23 | 67.7 | 0 | 265 | 86 | 77 | 136 | MBI4127537.1 30S ribosomal protein S9 [Parcubacteria group bacterium] | diamond | 900 | 68.6 | 1 | Bacteria | Bacteria candidate phyla | Parcubacteria group bacterium | |||||||
| 30851917 | 30851917 | PRJNA670521_P_NODE_81574_length_246_cov_0.890173_g80829_i0 | PRJNA670521 | 81574 | 246 | 0.890173 | 2.18982558 | Bacteria | 2 | Bacteria | Bacteria | 65.1 | 4.24e-10 | NR | OGD93678.1 | 1797712 | g80829 | i0 | 55.4 | 5.67073170731707 | 56 | 24 | 68.3 | 1 | 195 | 28 | 4 | 58 | OGD93678.1 MAG: hypothetical protein A2697_01680 [Candidatus Curtissbacteria bacterium RIFCSPHIGHO2_01_FULL_41_44] | diamond | 1395 | 65.1 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Curtissiibacteriota | Candidatus Curtissbacteria bacterium RIFCSPHIGHO2_01_FULL_41_44 | ||||||
| 30871541 | 30871541 | PRJNA670521_P_NODE_40954_length_320_cov_5.137652_g40209_i0 | PRJNA670521 | 40954 | 320 | 5.137652 | 16.4404864 | Candidatus Binatus sp. | 2811406 | Bacteria | Bacteria | 43.9 | 0.00486 | NR | WP_304820945.1 | 2811406 | g40209 | i0 | 38.5 | 0.609375 | 65 | 37 | 60.9 | 1 | 39 | 233 | 12 | 73 | WP_304820945.1 Rdx family protein [Candidatus Binatus sp.] | diamond | 195 | 43.9 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Binatota | Candidatus Binatia | Candidatus Binatales | Candidatus Binataceae | Candidatus Binatus | Candidatus Binatus sp. | ||
| 31041874 | 31041874 | PRJNA670521_P_NODE_86315_length_244_cov_0.900585_g85570_i0 | PRJNA670521 | 86315 | 244 | 0.900585 | 2.1974274 | Bacteria | 2 | Bacteria | Bacteria | 87.4 | 6.47e-18 | NR | HUX35538.1 | 2053589 | g85570 | i0 | 58 | 2.92622950819672 | 81 | 34 | 99.6 | 0 | 244 | 2 | 72 | 152 | HUX35538.1 ABC-F family ATP-binding cassette domain-containing protein [Candidatus Paceibacterota bacterium] | diamond | 714 | 87.4 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 31187204 | 31187204 | PRJNA670521_P_NODE_17795_length_443_cov_1.040541_g17053_i0 | PRJNA670521 | 17795 | 443 | 1.040541 | 4.60959663 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 74.3 | 2.93e-12 | NR | MEZ0208921.1 | 2053589 | g17053 | i0 | 41.2 | 1.00225733634312 | 148 | 85 | 99.5 | 2 | 1 | 441 | 330 | 476 | MEZ0208921.1 hypothetical protein [Candidatus Paceibacterota bacterium] | diamond | 444 | 74.3 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 31345729 | 31345729 | PRJNA670521_P_NODE_45696_length_307_cov_1.264957_g44951_i0 | PRJNA670521 | 45696 | 307 | 1.264957 | 3.88341799 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 43.5 | 0.0416 | NR | MFA5715097.1 | 2053589 | g44951 | i0 | 42 | 0.674267100977199 | 69 | 33 | 67.4 | 2 | 80 | 286 | 394 | 455 | MFA5715097.1 hypothetical protein [Candidatus Paceibacterota bacterium] | diamond | 207 | 43.5 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 31819996 | 31819996 | PRJNA670521_P_NODE_71417_length_251_cov_0.865169_g70672_i0 | PRJNA670521 | 71417 | 251 | 0.865169 | 2.17157419 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 149 | 1.88e-39 | NR | MEZ0208791.1 | 2053589 | g70672 | i0 | 81.9 | 0.99203187250996006 | 83 | 15 | 99.2 | 0 | 251 | 3 | 36 | 118 | MEZ0208791.1 glucoamylase family protein [Candidatus Paceibacterota bacterium] | diamond | 249 | 149 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 32295094 | 32295094 | PRJNA670521_P_NODE_62679_length_267_cov_1.190722_g61934_i0 | PRJNA670521 | 62679 | 267 | 1.190722 | 3.17922774 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 82 | 7.35e-16 | NR | MEZ0209064.1 | 2053589 | g61934 | i0 | 51.9 | 0.887640449438202 | 79 | 38 | 88.8 | 0 | 6 | 242 | 363 | 441 | MEZ0209064.1 DNA N-6-adenine-methyltransferase [Candidatus Paceibacterota bacterium] | diamond | 237 | 82 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 32894109 | 32894109 | PRJNA670521_P_NODE_28200_length_369_cov_1.104730_g27455_i0 | PRJNA670521 | 28200 | 369 | 1.10473 | 4.0764537 | Candidatus Nomurabacteria bacterium RIFCSPHIGHO2_ | 2052152 | Bacteria | Bacteria | 75.1 | 7.21e-13 | NR | OGI73429.1 | 1801740 | g27455 | i0 | 37.6 | 5.7479674796748 | 117 | 62 | 95.1 | 2 | 14 | 364 | 540 | 645 | OGI73429.1 MAG: hypothetical protein A2737_01130 [Candidatus Nomurabacteria bacterium RIFCSPHIGHO2_01_FULL_41_71] | diamond | 2121 | 75.1 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Nomuraibacteriota | Candidatus Nomurabacteria bacterium RIFCSPHIGHO2_01_FULL_41_71 |
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);;