contig_metadata
25 rows where analysis = "diamond", bioproject = "PRJNA1160211" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4137162 | 4137162 | PRJNA1160211_S_NODE_287504_length_235_cov_3.604938_g286271_i0 | PRJNA1160211 | 287504 | 235 | 3.604938 | 8.4716043 | Candidatus Gracilibacteria bacterium GN | 2044595 | Bacteria | Bacteria | 144 | 1.97e-41 | NR | RAL56550.1 | 1914866 | g286271 | i0 | 98.6 | 0.94468085106383 | 74 | 1 | 94.5 | 0 | 2 | 223 | 41 | 114 | RAL56550.1 ATP-dependent Clp protease proteolytic subunit [Candidatus Gracilibacteria bacterium GN02-873] | diamond | 222 | 144 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Altimarinota | Candidatus Gracilibacteria bacterium GN02-873 | ||||||
| 26819019 | 26819019 | PRJNA1160211_S_NODE_169461_length_348_cov_2.240000_g168228_i0 | PRJNA1160211 | 169461 | 348 | 2.24 | 7.7952 | candidate division SR1 bacterium | 2044938 | Bacteria | Bacteria | 107 | 2.07e-26 | NR | PZM85710.1 | 2044938 | g168228 | i0 | 82.8 | 0.551724137931034 | 64 | 11 | 55.2 | 0 | 346 | 155 | 125 | 188 | PZM85710.1 MAG: 16S rRNA (guanine(527)-N(7))-methyltransferase RsmG [candidate division SR1 bacterium] | diamond | 192 | 107 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Absconditibacteriota | candidate division SR1 bacterium | ||||||
| 27071958 | 27071958 | PRJNA1160211_S_NODE_145902_length_380_cov_14.136808_g144669_i0 | PRJNA1160211 | 145902 | 380 | 14.136808 | 53.7198704 | Candidatus Saccharimonadales bacterium | 2973664 | Bacteria | Bacteria | 72 | 9.41e-12 | NR | HEY5668337.1 | 2973664 | g144669 | i0 | 40 | 0.907894736842105 | 115 | 63 | 89.2 | 4 | 41 | 379 | 286 | 396 | HEY5668337.1 hypothetical protein [Candidatus Saccharimonadales bacterium] | diamond | 345 | 72 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadia | Candidatus Saccharimonadales | Candidatus Saccharimonadales bacterium | ||||
| 27103484 | 27103484 | PRJNA1160211_S_NODE_117882_length_425_cov_2.363636_g116653_i0 | PRJNA1160211 | 117882 | 425 | 2.363636 | 10.045453 | Patescibacteria group bacterium | 2052139 | Bacteria | Bacteria | 61.2 | 7.12e-8 | NR | MCL4419288.1 | 2052139 | g116653 | i0 | 45 | 0.423529411764706 | 60 | 31 | 40.9 | 1 | 14 | 187 | 265 | 324 | MCL4419288.1 hypothetical protein [Patescibacteria group bacterium] | diamond | 180 | 61.2 | 1 | Bacteria | Bacteria candidate phyla | Patescibacteria group bacterium | |||||||
| 27640844 | 27640844 | PRJNA1160211_S_NODE_134424_length_398_cov_3.196923_g133192_i0 | PRJNA1160211 | 134424 | 398 | 3.196923 | 12.72375354 | Patescibacteria group bacterium | 2052139 | Bacteria | Bacteria | 235 | 1.39e-74 | NR | MDQ5982026.1 | 2052139 | g133192 | i0 | 92.3 | 1.91457286432161 | 130 | 10 | 98 | 0 | 390 | 1 | 109 | 238 | MDQ5982026.1 hypothetical protein [Patescibacteria group bacterium] | diamond | 762 | 235 | 1 | Bacteria | Bacteria candidate phyla | Patescibacteria group bacterium | |||||||
| 27956485 | 27956485 | PRJNA1160211_S_NODE_283885_length_240_cov_4.724551_g282652_i0 | PRJNA1160211 | 283885 | 240 | 4.724551 | 11.3389224 | Candidatus Babelota bacterium | 2030827 | Bacteria | Bacteria | 89.4 | 4.01e-20 | NR | MCA9770424.1 | 2030827 | g282652 | i0 | 68.8 | 3.2 | 64 | 20 | 80 | 0 | 31 | 222 | 1 | 64 | MCA9770424.1 glycerol-3-phosphate 1-O-acyltransferase PlsY [Candidatus Dependentiae bacterium] | diamond | 768 | 89.4 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Babelota bacterium | |||||||
| 28240407 | 28240407 | PRJNA1160211_S_NODE_251646_length_260_cov_4.197861_g250413_i0 | PRJNA1160211 | 251646 | 260 | 4.197861 | 10.9144386 | Candidatus Binatia bacterium | 2838779 | Bacteria | Bacteria | 43.1 | 0.0148 | NR | HZP42555.1 | 2838779 | g250413 | i0 | 43.3 | 0.692307692307692 | 60 | 30 | 64.6 | 1 | 44 | 211 | 34 | 93 | HZP42555.1 hypothetical protein [Candidatus Binatia bacterium] | diamond | 180 | 43.1 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Binatota | Candidatus Binatia | Candidatus Binatia bacterium | |||||
| 28366740 | 28366740 | PRJNA1160211_S_NODE_248066_length_263_cov_4.505263_g246833_i0 | PRJNA1160211 | 248066 | 263 | 4.505263 | 11.84884169 | Candidatus Rokubacteria bacterium 13_1_4 | 1805364 | Bacteria | Bacteria | 42.7 | 0.0488 | NR | OLC37889.1 | 1805364 | g246833 | i0 | 29.8 | 0.958174904942966 | 84 | 55 | 91.3 | 1 | 23 | 262 | 71 | 154 | OLC37889.1 MAG: hypothetical protein AUH81_05385 [Candidatus Rokubacteria bacterium 13_1_40CM_4_69_5] | diamond | 252 | 42.7 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Rokuibacteriota | Candidatus Rokubacteria bacterium 13_1_40CM_4_69_5 | ||||||
| 28417955 | 28417955 | PRJNA1160211_S_NODE_108746_length_441_cov_2.076087_g107518_i0 | PRJNA1160211 | 108746 | 441 | 2.076087 | 9.15554367 | Bacteria | 2 | Bacteria | Bacteria | 182 | 1.79e-50 | NR | MCH8518297.1 | 2044595 | g107518 | i0 | 67.9 | 11.6598639455782 | 134 | 40 | 91.2 | 2 | 3 | 404 | 429 | 559 | MCH8518297.1 DEAD/DEAH box helicase family protein [Candidatus Altimarinota bacterium] | diamond | 5142 | 183 | 0.994535519125683 | Bacteria | Bacteria candidate phyla | Candidatus Altimarinota | Candidatus Altimarinota bacterium | ||||||
| 28493269 | 28493269 | PRJNA1160211_S_NODE_224067_length_285_cov_3.981132_g222834_i0 | PRJNA1160211 | 224067 | 285 | 3.981132 | 11.3462262 | Candidatus Moranbacteria bacterium RIFCSPHIGHO2_ | 1801637 | Bacteria | Bacteria | 140 | 2.3699999999999998e-40 | NR | OGI16210.1 | 1801637 | g222834 | i0 | 76.3 | 0.978947368421053 | 93 | 22 | 97.9 | 0 | 283 | 5 | 7 | 99 | OGI16210.1 MAG: hypothetical protein A2878_02500 [Candidatus Moranbacteria bacterium RIFCSPHIGHO2_01_FULL_54_31] | diamond | 279 | 140 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Moraniibacteriota | Candidatus Moranbacteria bacterium RIFCSPHIGHO2_01_FULL_54_31 | ||||||
| 28556525 | 28556525 | PRJNA1160211_S_NODE_8447_length_846_cov_3.507115_g7733_i0 | PRJNA1160211 | 8447 | 846 | 3.507115 | 29.6701929 | Candidatus Hydrothermia bacterium | 3014280 | Bacteria | Bacteria | 65.1 | 8.26e-8 | NR | HOL24546.1 | 3014280 | g7733 | i0 | 53.3 | 0.212765957446809 | 60 | 28 | 21.3 | 0 | 842 | 663 | 30 | 89 | HOL24546.1 tetratricopeptide repeat protein [Candidatus Hydrothermia bacterium] | diamond | 180 | 65.1 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Hydrothermota | Candidatus Hydrothermia | Candidatus Hydrothermia bacterium | |||||
| 29503398 | 29503398 | PRJNA1160211_S_NODE_13870_length_763_cov_8.531884_g12992_i0 | PRJNA1160211 | 13870 | 763 | 8.531884 | 65.09827492 | Candidatus Staskawiczbacteria bacterium | 2053617 | Bacteria | Bacteria | 62.4 | 3.78e-7 | NR | MBM3206812.1 | 2053617 | g12992 | i0 | 31.2 | 0.73132372214941 | 186 | 113 | 69.6 | 6 | 119 | 649 | 212 | 391 | MBM3206812.1 hypothetical protein [Candidatus Staskawiczbacteria bacterium] | diamond | 558 | 62.4 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Staskawicziibacteriota | Candidatus Staskawiczbacteria bacterium | ||||||
| 29522825 | 29522825 | PRJNA1160211_S_NODE_8530_length_844_cov_13.630350_g7811_i0 | PRJNA1160211 | 8530 | 844 | 13.63035 | 115.040154 | Candidatus Saccharimonadota | 95818 | Bacteria | Bacteria | 310 | 8.219999999999999e-95 | NR | WP_129693651.1 | 1986206 | g7811 | i0 | 99.4 | 1.09478672985782 | 154 | 1 | 54.7 | 0 | 3 | 464 | 319 | 472 | WP_129693651.1 TraM recognition domain-containing protein [Candidatus Nanosynsacchari sp. TM7_ANC_38.39_G1_1] | diamond | 924 | 310 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadia | Candidatus Saccharimonadales | Candidatus Saccharimonadaceae | Candidatus Nanosynsacchari | Candidatus Nanosynsacchari sp. TM7_ANC_38.39_G1_1 | ||
| 29629499 | 29629499 | PRJNA1160211_S_NODE_84510_length_488_cov_67.865060_g83291_i0 | PRJNA1160211 | 84510 | 488 | 67.86506 | 331.1814928 | Candidatus Altimarinota bacterium | 2044595 | Bacteria | Bacteria | 129 | 3.2099999999999996e-31 | NR | RKW24136.1 | 2044595 | g83291 | i0 | 100 | 0.418032786885246 | 68 | 0 | 41.8 | 0 | 101 | 304 | 709 | 776 | RKW24136.1 MAG: DUF5011 domain-containing protein [Candidatus Altimarinota bacterium] | diamond | 204 | 129 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Altimarinota | Candidatus Altimarinota bacterium | ||||||
| 30545964 | 30545964 | PRJNA1160211_S_NODE_80413_length_497_cov_11.655660_g79196_i0 | PRJNA1160211 | 80413 | 497 | 11.65566 | 57.9286302 | Candidatus Altimarinota bacterium | 2044595 | Bacteria | Bacteria | 140 | 7.199999999999999e-38 | NR | MBP7806433.1 | 2044595 | g79196 | i0 | 57.6 | 0.796780684104628 | 132 | 56 | 79.7 | 0 | 474 | 79 | 15 | 146 | MBP7806433.1 hypothetical protein [Candidatus Altimarinota bacterium] | diamond | 396 | 140 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Altimarinota | Candidatus Altimarinota bacterium | ||||||
| 30577287 | 30577287 | PRJNA1160211_S_NODE_205253_length_305_cov_1.495690_g204020_i0 | PRJNA1160211 | 205253 | 305 | 1.49569 | 4.5618545 | Candidatus Levyibacteriota bacterium | 2052151 | Bacteria | Bacteria | 105 | 1.97e-26 | NR | MBI4098013.1 | 2052151 | g204020 | i0 | 70.7 | 1.61311475409836 | 82 | 24 | 80.7 | 0 | 246 | 1 | 1 | 82 | MBI4098013.1 50S ribosomal protein L22 [Candidatus Levyibacteriota bacterium] | diamond | 492 | 105 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Levyibacteriota | Candidatus Levyibacteriota bacterium | ||||||
| 30956886 | 30956886 | PRJNA1160211_S_NODE_75934_length_507_cov_21.481567_g74720_i0 | PRJNA1160211 | 75934 | 507 | 21.481567 | 108.91154469 | Candidatus Altimarinota bacterium | 2044595 | Bacteria | Bacteria | 218 | 1.05e-63 | NR | MFN7160311.1 | 2044595 | g74720 | i0 | 75.2 | 1.63905325443787 | 137 | 34 | 81.1 | 0 | 493 | 83 | 62 | 198 | MFN7160311.1 ATP-binding cassette domain-containing protein [Candidatus Altimarinota bacterium] | diamond | 831 | 218 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Altimarinota | Candidatus Altimarinota bacterium | ||||||
| 31145798 | 31145798 | PRJNA1160211_S_NODE_185735_length_327_cov_5.291339_g184502_i0 | PRJNA1160211 | 185735 | 327 | 5.291339 | 17.30267853 | Candidatus Dojkabacteria bacterium | 2099670 | Bacteria | Bacteria | 118 | 3.0199999999999997e-32 | NR | HRN86952.1 | 2099670 | g184502 | i0 | 98.2 | 0.513761467889908 | 56 | 1 | 51.4 | 0 | 23 | 190 | 38 | 93 | HRN86952.1 hypothetical protein [Candidatus Dojkabacteria bacterium] | diamond | 168 | 118 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Dojkabacteria bacterium | |||||||
| 31335843 | 31335843 | PRJNA1160211_S_NODE_166496_length_352_cov_2.444444_g165263_i0 | PRJNA1160211 | 166496 | 352 | 2.444444 | 8.60444288 | Candidatus Shapirobacteria bacterium CG11_big_fil_rev_8_21_14_ | 2053613 | Bacteria | Bacteria | 74.7 | 6.23e-13 | NR | PIQ70456.1 | 1974889 | g165263 | i0 | 50 | 3.60511363636364 | 76 | 38 | 64.8 | 0 | 15 | 242 | 300 | 375 | PIQ70456.1 MAG: RNA polymerase sigma factor RpoD [Candidatus Shapirobacteria bacterium CG11_big_fil_rev_8_21_14_0_20_40_12] | diamond | 1269 | 74.7 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Shapironibacteriota | Candidatus Shapirobacteria bacterium CG11_big_fil_rev_8_21_14_0_20_40_12 | ||||||
| 31367813 | 31367813 | PRJNA1160211_S_NODE_274976_length_245_cov_1.343023_g273743_i0 | PRJNA1160211 | 274976 | 245 | 1.343023 | 3.29040635 | Minisyncoccales bacterium | 3122025 | Bacteria | Bacteria | 87.8 | 5.22e-19 | NR | MFI5205698.1 | 3122025 | g273743 | i0 | 56.1 | 0.808163265306122 | 66 | 29 | 80.8 | 0 | 209 | 12 | 79 | 144 | MFI5205698.1 hypothetical protein [Minisyncoccales bacterium] | diamond | 198 | 87.8 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccia | Minisyncoccales | Minisyncoccales bacterium | ||||
| 31557632 | 31557632 | PRJNA1160211_S_NODE_97036_length_463_cov_3.592308_g95811_i0 | PRJNA1160211 | 97036 | 463 | 3.592308 | 16.63238604 | Patescibacteria group bacterium | 2052139 | Bacteria | Bacteria | 92 | 1.54e-18 | NR | MEK7617840.1 | 2052139 | g95811 | i0 | 83.3 | 0.719222462203024 | 54 | 9 | 35 | 0 | 300 | 461 | 319 | 372 | MEK7617840.1 pilin [Patescibacteria group bacterium] | diamond | 333 | 92 | 1 | Bacteria | Bacteria candidate phyla | Patescibacteria group bacterium | |||||||
| 31892952 | 31892952 | PRJNA1160211_S_NODE_179797_length_334_cov_13.977011_g178564_i0 | PRJNA1160211 | 179797 | 334 | 13.977011 | 46.68321674 | Candidatus Saccharimonadaceae | 2171986 | Bacteria | Bacteria | 58.2 | 2.93e-8 | NR | MFC2602170.1 | 1917697 | g178564 | i0 | 40.5 | 1.31137724550898 | 84 | 46 | 72.8 | 3 | 77 | 319 | 1 | 83 | MFC2602170.1 hypothetical protein [Candidatus Saccharimonas sp.] | diamond | 438 | 58.2 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadia | Candidatus Saccharimonadales | Candidatus Saccharimonadaceae | Candidatus Saccharimonas | Candidatus Saccharimonas sp. | ||
| 32348517 | 32348517 | PRJNA1160211_S_NODE_112439_length_434_cov_5.900277_g111210_i0 | PRJNA1160211 | 112439 | 434 | 5.900277 | 25.60720218 | Candidatus Babelota bacterium | 2030827 | Bacteria | Bacteria | 145 | 7.61e-38 | NR | MCX5922360.1 | 2030827 | g111210 | i0 | 53.3 | 0.933179723502304 | 135 | 63 | 93.3 | 0 | 3 | 407 | 104 | 238 | MCX5922360.1 AAA family ATPase [Candidatus Dependentiae bacterium] | diamond | 405 | 145 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Babelota bacterium | |||||||
| 32506688 | 32506688 | PRJNA1160211_S_NODE_182719_length_331_cov_2.410853_g181486_i0 | PRJNA1160211 | 182719 | 331 | 2.410853 | 7.97992343 | Candidatus Saccharimonadota bacterium | 2026720 | Bacteria | Bacteria | 63.2 | 4.91e-9 | NR | HMM62033.1 | 2026720 | g181486 | i0 | 31.2 | 0.987915407854985 | 109 | 72 | 97 | 2 | 9 | 329 | 191 | 298 | HMM62033.1 hypothetical protein [Candidatus Saccharibacteria bacterium] | diamond | 327 | 63.2 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadota bacterium | ||||||
| 32746469 | 32746469 | PRJNA1160211_S_NODE_25620_length_675_cov_2.214286_g24549_i0 | PRJNA1160211 | 25620 | 675 | 2.214286 | 14.9464305 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 54.3 | 1.44e-4 | NR | HEX3409069.1 | 2785449 | g24549 | i0 | 71.9 | 1.04 | 32 | 9 | 14.2 | 0 | 2 | 97 | 527 | 558 | HEX3409069.1 multicopper oxidase domain-containing protein [Candidatus Binataceae bacterium] | diamond | 702 | 54.3 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Binatota | Candidatus Binatia | Candidatus Binatales | Candidatus Binataceae | Candidatus Binataceae 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);;