contig_metadata
25 rows where analysis = "diamond", bioproject = "PRJNA688931" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 21070966 | 21070966 | PRJNA688931_P_NODE_33657_length_173_cov_1.669355_g33444_i0 | PRJNA688931 | 33657 | 173 | 1.669355 | 2.88798415 | Bacillati | 1783272 | Bacteria | Bacteria | 118 | 3.78e-29 | NR | HET7007126.1 | 2838779 | g33444 | i0 | 94.7 | 2.94797687861272 | 57 | 3 | 98.8 | 0 | 2 | 172 | 473 | 529 | HET7007126.1 prolyl oligopeptidase family serine peptidase [Candidatus Binatia bacterium] | diamond | 510 | 119 | 0.991596638655462 | Bacteria | Bacteria candidate phyla | Candidatus Binatota | Candidatus Binatia | Candidatus Binatia bacterium | |||||
| 26955587 | 26955587 | PRJNA688931_P_NODE_28842_length_189_cov_1.728571_g28629_i0 | PRJNA688931 | 28842 | 189 | 1.728571 | 3.26699919 | candidate division WWE3 bacterium CG | 422282 | Bacteria | Bacteria | 47.8 | 3.84e-5 | NR | PIS21116.1 | 1975087 | g28629 | i0 | 67.7 | 0.888888888888889 | 31 | 10 | 49.2 | 0 | 179 | 87 | 21 | 51 | PIS21116.1 MAG: hypothetical protein COT52_00280 [candidate division WWE3 bacterium CG08_land_8_20_14_0_20_43_13] | diamond | 168 | 47.8 | 1 | Bacteria | Bacteria candidate phyla | candidate division WWE3 | candidate division WWE3 bacterium CG08_land_8_20_14_0_20_43_13 | ||||||
| 28061369 | 28061369 | PRJNA688931_P_NODE_925_length_1123_cov_2.231844_g833_i0 | PRJNA688931 | 925 | 1123 | 2.231844 | 25.06360812 | Candidatus Roizmanbacteria bacterium | 2282149 | Bacteria | Bacteria | 104 | 3.5400000000000006e-21 | NR | MFS8160610.1 | 2282149 | g833 | i0 | 30.1 | 1.43989314336598 | 266 | 179 | 70 | 3 | 55 | 840 | 64 | 326 | MFS8160610.1 hypothetical protein [Candidatus Roizmanbacteria bacterium] | diamond | 1617 | 104 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Roizmaniibacteriota | Candidatus Roizmanbacteria bacterium | ||||||
| 28282211 | 28282211 | PRJNA688931_P_NODE_24086_length_208_cov_2.251572_g23873_i0 | PRJNA688931 | 24086 | 208 | 2.251572 | 4.68326976 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 58.2 | 8.52e-8 | NR | MDR3582248.1 | 2053589 | g23873 | i0 | 47.1 | 1.00961538461538 | 70 | 36 | 99.5 | 1 | 2 | 208 | 182 | 251 | MDR3582248.1 clusterin-associated protein 1 [Candidatus Paceibacterota bacterium] | diamond | 210 | 58.2 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 28472031 | 28472031 | PRJNA688931_P_NODE_6506_length_428_cov_4.121372_g6293_i0 | PRJNA688931 | 6506 | 428 | 4.121372 | 17.63947216 | Candidatus Bipolaricaulota bacterium | 2306012 | Bacteria | Bacteria | 118 | 3.6799999999999997e-31 | NR | MBS3812417.1 | 2306012 | g6293 | i0 | 52.9 | 2.50233644859813 | 119 | 54 | 82 | 2 | 351 | 1 | 3 | 121 | MBS3812417.1 30S ribosomal protein S12 [Candidatus Bipolaricaulota bacterium] | diamond | 1071 | 118 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Bipolaricaulota | Candidatus Bipolaricaulota bacterium | ||||||
| 28693102 | 28693102 | PRJNA688931_P_NODE_40527_length_164_cov_1.069565_g40314_i0 | PRJNA688931 | 40527 | 164 | 1.069565 | 1.7540866 | Candidatus Poribacteria bacterium | 2026781 | Bacteria | Bacteria | 43.9 | 0.00503 | NR | MCY4402064.1 | 2026781 | g40314 | i0 | 44.7 | 0.859756097560976 | 47 | 26 | 86 | 0 | 10 | 150 | 451 | 497 | MCY4402064.1 WD40 repeat domain-containing protein [Candidatus Poribacteria bacterium] | diamond | 141 | 43.9 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Poribacteria | Candidatus Poribacteria bacterium | ||||||
| 28988863 | 28988863 | PRJNA688931_P_NODE_38728_length_166_cov_0.880342_g38515_i0 | PRJNA688931 | 38728 | 166 | 0.880342 | 1.46136772 | Bacteria candidate phyla | 1783234 | Bacteria | Bacteria | 51.2 | 1.35e-5 | NR | MBD3183395.1 | 2026781 | g38515 | i0 | 42 | 6.30722891566265 | 50 | 29 | 90.4 | 0 | 2 | 151 | 601 | 650 | MBD3183395.1 prolyl oligopeptidase family serine peptidase [Candidatus Poribacteria bacterium] | diamond | 1047 | 51.2 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Poribacteria | Candidatus Poribacteria bacterium | ||||||
| 29198271 | 29198271 | PRJNA688931_P_NODE_8829_length_359_cov_1.977419_g8616_i0 | PRJNA688931 | 8829 | 359 | 1.977419 | 7.09893421 | Candidatus Magasanikbacteria bacterium GW2 | 2026717 | Bacteria | Bacteria | 45.1 | 0.0197 | NR | KKS53982.1 | 1619039 | g8616 | i0 | 34.3 | 0.584958217270195 | 70 | 38 | 58.5 | 1 | 29 | 238 | 361 | 422 | KKS53982.1 MAG: hypothetical protein UV20_C0043G0004 [Candidatus Magasanikbacteria bacterium GW2011_GWA2_42_32] | diamond | 210 | 45.1 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Magasanikiibacteriota | Candidatus Magasanikbacteria bacterium GW2011_GWA2_42_32 | ||||||
| 29387650 | 29387650 | PRJNA688931_P_NODE_13949_length_278_cov_0.895197_g13736_i0 | PRJNA688931 | 13949 | 278 | 0.895197 | 2.48864766 | Candidatus Peribacteria bacterium | 2053688 | Bacteria | Bacteria | 42 | 0.0184 | NR | MDR3168375.1 | 2053688 | g13736 | i0 | 34.9 | 0.89568345323741 | 83 | 42 | 76.6 | 2 | 62 | 274 | 1 | 83 | MDR3168375.1 hypothetical protein [Candidatus Peribacteria bacterium] | diamond | 249 | 42 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Peregrinibacteriota | Candidatus Peribacteria | Candidatus Peribacteria bacterium | |||||
| 30019304 | 30019304 | PRJNA688931_P_NODE_36211_length_168_cov_0.873950_g35998_i0 | PRJNA688931 | 36211 | 168 | 0.87395 | 1.468236 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 45.1 | 5.87e-4 | NR | MDR3570671.1 | 2053589 | g35998 | i0 | 88.5 | 0.464285714285714 | 26 | 3 | 46.4 | 0 | 1 | 78 | 82 | 107 | MDR3570671.1 hypothetical protein [Candidatus Paceibacterota bacterium] | diamond | 78 | 45.1 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 30240319 | 30240319 | PRJNA688931_P_NODE_28852_length_189_cov_1.564286_g28639_i0 | PRJNA688931 | 28852 | 189 | 1.564286 | 2.95650054 | Candidatus Rifleibacterium sp. | 3022866 | Bacteria | Bacteria | 59.3 | 2.53e-8 | NR | HNW12646.1 | 3022866 | g28639 | i0 | 46.7 | 1.82539682539683 | 60 | 32 | 95.2 | 0 | 185 | 6 | 230 | 289 | HNW12646.1 ankyrin repeat domain-containing protein [Candidatus Rifleibacterium sp.] | diamond | 345 | 59.3 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Rifleibacteriota | Candidatus Rifleibacterium | Candidatus Rifleibacterium sp. | |||||
| 30335488 | 30335488 | PRJNA688931_P_NODE_35812_length_168_cov_1.285714_g35599_i0 | PRJNA688931 | 35812 | 168 | 1.285714 | 2.15999952 | Candidatus Saccharimonadota bacterium | 2026720 | Bacteria | Bacteria | 52.8 | 3.78e-6 | NR | MDB5187311.1 | 2026720 | g35599 | i0 | 46.2 | 0.928571428571429 | 52 | 28 | 92.9 | 0 | 2 | 157 | 62 | 113 | MDB5187311.1 ADP-ribosylglycohydrolase [Candidatus Saccharibacteria bacterium] | diamond | 156 | 52.8 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadota bacterium | ||||||
| 30367066 | 30367066 | PRJNA688931_P_NODE_17072_length_248_cov_2.376884_g16859_i0 | PRJNA688931 | 17072 | 248 | 2.376884 | 5.89467232 | Candidatus Binataceae bacterium | 2785449 | Bacteria | Bacteria | 78.6 | 3.04e-15 | NR | HEY6418718.1 | 2785449 | g16859 | i0 | 58.1 | 3.31451612903226 | 74 | 29 | 89.5 | 2 | 224 | 3 | 61 | 132 | HEY6418718.1 glutathione S-transferase family protein [Candidatus Binataceae bacterium] | diamond | 822 | 78.6 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Binatota | Candidatus Binatia | Candidatus Binatales | Candidatus Binataceae | Candidatus Binataceae bacterium | |||
| 30493095 | 30493095 | PRJNA688931_P_NODE_2193_length_768_cov_2.692629_g2032_i0 | PRJNA688931 | 2193 | 768 | 2.692629 | 20.67939072 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 141 | 5.4299999999999997e-39 | NR | MDR3549538.1 | 2053589 | g2032 | i0 | 66.3 | 0.3828125 | 98 | 33 | 38.3 | 0 | 732 | 439 | 8 | 105 | MDR3549538.1 small nuclear ribonucleoprotein Sm D2 [Candidatus Paceibacterota bacterium] | diamond | 294 | 141 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 30650764 | 30650764 | PRJNA688931_P_NODE_2813_length_681_cov_4.131329_g2630_i0 | PRJNA688931 | 2813 | 681 | 4.131329 | 28.13435049 | Candidatus Curtissbacteria bacterium | 2750075 | Bacteria | Bacteria | 86.7 | 1.12e-16 | NR | MBI2327029.1 | 2750075 | g2630 | i0 | 30.6 | 0.920704845814978 | 209 | 131 | 89.9 | 3 | 614 | 3 | 13 | 212 | MBI2327029.1 aquaporin [Candidatus Curtissbacteria bacterium] | diamond | 627 | 86.7 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Curtissiibacteriota | Candidatus Curtissbacteria bacterium | ||||||
| 30967108 | 30967108 | PRJNA688931_P_NODE_23054_length_213_cov_1.268293_g22841_i0 | PRJNA688931 | 23054 | 213 | 1.268293 | 2.70146409 | Candidatus Saccharimonadota bacterium | 2026720 | Bacteria | Bacteria | 44.3 | 0.00678 | NR | MCA9324640.1 | 2026720 | g22841 | i0 | 39.3 | 0.859154929577465 | 61 | 34 | 81.7 | 2 | 7 | 180 | 67 | 127 | MCA9324640.1 hypothetical protein [Candidatus Saccharibacteria bacterium] | diamond | 183 | 44.3 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadota bacterium | ||||||
| 31251327 | 31251327 | PRJNA688931_P_NODE_43295_length_162_cov_0.920354_g43082_i0 | PRJNA688931 | 43295 | 162 | 0.920354 | 1.49097348 | Candidatus Collierbacteria bacterium GW2 | 2053540 | Bacteria | Bacteria | 86.7 | 8.880000000000001e-21 | NR | KKT87633.1 | 1618398 | g43082 | i0 | 97.6 | 1.53703703703704 | 42 | 1 | 77.8 | 0 | 1 | 126 | 1 | 42 | KKT87633.1 MAG: hypothetical protein UW88_C0025G0001, partial [Candidatus Collierbacteria bacterium GW2011_GWD2_45_10] | diamond | 249 | 86.7 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Collieribacteriota | Candidatus Collierbacteria bacterium GW2011_GWD2_45_10 | ||||||
| 31282929 | 31282929 | PRJNA688931_P_NODE_5055_length_494_cov_2.734831_g4843_i0 | PRJNA688931 | 5055 | 494 | 2.734831 | 13.51006514 | Patescibacteria group bacterium | 2052139 | Bacteria | Bacteria | 50.1 | 4.6e-4 | NR | MBY0473190.1 | 2052139 | g4843 | i0 | 42.5 | 0.242914979757085 | 40 | 23 | 24.3 | 0 | 346 | 465 | 4 | 43 | MBY0473190.1 hypothetical protein [Patescibacteria group bacterium] | diamond | 120 | 50.1 | 1 | Bacteria | Bacteria candidate phyla | Patescibacteria group bacterium | |||||||
| 31346370 | 31346370 | PRJNA688931_P_NODE_27196_length_195_cov_2.547945_g26983_i0 | PRJNA688931 | 27196 | 195 | 2.547945 | 4.96849275 | Candidatus Shapirobacteria bacterium | 2053613 | Bacteria | Bacteria | 42 | 0.0364 | NR | MBP6866770.1 | 2053613 | g26983 | i0 | 35.1 | 0.876923076923077 | 57 | 37 | 87.7 | 0 | 173 | 3 | 280 | 336 | MBP6866770.1 UDP-glucose/GDP-mannose dehydrogenase family protein [Candidatus Shapirobacteria bacterium] | diamond | 171 | 42 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Shapironibacteriota | Candidatus Shapirobacteria bacterium | ||||||
| 31599487 | 31599487 | PRJNA688931_P_NODE_6336_length_435_cov_0.984456_g6123_i0 | PRJNA688931 | 6336 | 435 | 0.984456 | 4.2823836 | Candidatus Eiseniibacteriota bacterium | 2212470 | Bacteria | Bacteria | 58.5 | 8.31e-7 | NR | MFH0777526.1 | 2212470 | g6123 | i0 | 50.7 | 2.15862068965517 | 67 | 31 | 44.8 | 1 | 343 | 149 | 291 | 357 | MFH0777526.1 ankyrin repeat domain-containing protein [Candidatus Eiseniibacteriota bacterium] | diamond | 939 | 58.5 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Eiseniibacteriota | Candidatus Eiseniibacteriota bacterium | ||||||
| 31947086 | 31947086 | PRJNA688931_P_NODE_38937_length_166_cov_0.871795_g38724_i0 | PRJNA688931 | 38937 | 166 | 0.871795 | 1.4471797 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 41.2 | 0.00731 | NR | MDR3581786.1 | 2053589 | g38724 | i0 | 47.5 | 0.72289156626506 | 40 | 21 | 72.3 | 0 | 164 | 45 | 28 | 67 | MDR3581786.1 hypothetical protein [Candidatus Paceibacterota bacterium] | diamond | 120 | 41.2 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 32295657 | 32295657 | PRJNA688931_P_NODE_16059_length_257_cov_0.966346_g15846_i0 | PRJNA688931 | 16059 | 257 | 0.966346 | 2.48350922 | Candidatus Poribacteria bacterium | 2026781 | Bacteria | Bacteria | 45.4 | 0.00468 | NR | MEK7400269.1 | 2026781 | g15846 | i0 | 31.6 | 0.922178988326848 | 79 | 51 | 89.9 | 2 | 247 | 17 | 174 | 251 | MEK7400269.1 tetratricopeptide repeat protein [Candidatus Poribacteria bacterium] | diamond | 237 | 45.4 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Poribacteria | Candidatus Poribacteria bacterium | ||||||
| 32327336 | 32327336 | PRJNA688931_P_NODE_24039_length_209_cov_0.950000_g23826_i0 | PRJNA688931 | 24039 | 209 | 0.95 | 1.9855 | Candidatus Woesebacteria bacterium | 2026804 | Bacteria | Bacteria | 58.2 | 8.66e-8 | NR | MCA9372610.1 | 2026804 | g23826 | i0 | 59 | 0.559808612440191 | 39 | 16 | 56 | 0 | 208 | 92 | 572 | 610 | MCA9372610.1 ATP-dependent DNA ligase [Candidatus Woesebacteria bacterium] | diamond | 117 | 58.2 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Woeseibacteriota | Candidatus Woesebacteria bacterium | ||||||
| 32642673 | 32642673 | PRJNA688931_P_NODE_10760_length_321_cov_1.363971_g10547_i0 | PRJNA688931 | 10760 | 321 | 1.363971 | 4.37834691 | candidate division WOR-3 bacterium | 2052148 | Bacteria | Bacteria | 51.2 | 2.09e-5 | NR | MEO0070123.1 | 2052148 | g10547 | i0 | 62.9 | 0.981308411214953 | 35 | 13 | 32.7 | 0 | 1 | 105 | 1 | 35 | MEO0070123.1 ankyrin repeat domain-containing protein [candidate division WOR-3 bacterium] | diamond | 315 | 51.2 | 1 | Bacteria | Bacteria candidate phyla | candidate division WOR-3 | candidate division WOR-3 bacterium | ||||||
| 32685826 | 32685826 | PRJNA688931_P_NODE_40240_length_164_cov_2.582609_g40027_i0 | PRJNA688931 | 40240 | 164 | 2.582609 | 4.23547876 | Bacteria | 2 | Bacteria | Bacteria | 45.4 | 1.25e-4 | NR | OGY66919.1 | 1798408 | g40027 | i0 | 59.5 | 1.33536585365854 | 37 | 15 | 67.7 | 0 | 146 | 36 | 22 | 58 | OGY66919.1 MAG: hypothetical protein A3I89_00795 [Candidatus Harrisonbacteria bacterium RIFCSPLOWO2_02_FULL_41_11] | diamond | 219 | 45.4 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Harrisoniibacteriota | Candidatus Harrisonbacteria bacterium RIFCSPLOWO2_02_FULL_41_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);;