contig_metadata
19 rows where bioproject = "PRJNA685607" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 13420248 | 13420248 | PRJNA685607_P_NODE_35371_length_313_cov_1.129167_g35012_i0 | PRJNA685607 | 35371 | 313 | 1.129167 | 3.53429271 | Bacteria | 2 | Bacteria | Bacteria | 169 | 5.369999999999999e-47 | NR | OGB74329.1 | 1798535 | g35012 | i0 | 84.6 | 270.134185303514 | 104 | 16 | 99.7 | 0 | 312 | 1 | 324 | 427 | OGB74329.1 MAG: molecular chaperone DnaK [candidate division Kazan bacterium RBG_13_50_9] | diamond | 84552 | 170 | 0.994117647058824 | Bacteria | Bacteria candidate phyla | candidate division Kazan bacterium RBG_13_50_9 | |||||||
| 13420397 | 13420397 | PRJNA685607_P_NODE_80871_length_246_cov_0.890173_g80512_i0 | PRJNA685607 | 80871 | 246 | 0.890173 | 2.18982558 | Patescibacteria group bacterium | 2052139 | Bacteria | Bacteria | 80.9 | 1.32e-15 | NR | MCL4420005.1 | 2052139 | g80512 | i0 | 59.5 | 0.963414634146341 | 79 | 29 | 96.3 | 2 | 5 | 241 | 320 | 395 | MCL4420005.1 SHNi-TPR domain-containing protein [Patescibacteria group bacterium] | diamond | 237 | 80.9 | 1 | Bacteria | Bacteria candidate phyla | Patescibacteria group bacterium | |||||||
| 27018950 | 27018950 | PRJNA685607_P_NODE_36982_length_308_cov_1.557447_g36623_i0 | PRJNA685607 | 36982 | 308 | 1.557447 | 4.79693676 | Candidatus Parcubacteria bacterium | 2762014 | Bacteria | Bacteria | 119 | 6.1899999999999995e-30 | NR | RMD61734.1 | 2762014 | g36623 | i0 | 75.7 | 0.681818181818182 | 70 | 17 | 68.2 | 0 | 1 | 210 | 276 | 345 | RMD61734.1 MAG: N4-gp56 family major capsid protein [Candidatus Parcubacteria bacterium] | diamond | 210 | 119 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Parcubacteria | Candidatus Parcubacteria bacterium | ||||||
| 27651022 | 27651022 | PRJNA685607_P_NODE_71884_length_249_cov_0.875000_g71525_i0 | PRJNA685607 | 71884 | 249 | 0.875 | 2.17875 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 52.8 | 1.17e-5 | NR | HEY1041389.1 | 2053589 | g71525 | i0 | 41.3 | 1.4578313253012 | 46 | 27 | 55.4 | 0 | 220 | 83 | 224 | 269 | HEY1041389.1 Ig-like domain-containing protein [Candidatus Paceibacterota bacterium] | diamond | 363 | 52.8 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 27871852 | 27871852 | PRJNA685607_P_NODE_3485_length_840_cov_1.585398_g3186_i0 | PRJNA685607 | 3485 | 840 | 1.585398 | 13.3173432 | Candidatus Binatia bacterium | 2838779 | Bacteria | Bacteria | 175 | 2.07e-45 | NR | HWX21912.1 | 2838779 | g3186 | i0 | 43.2 | 0.917857142857143 | 257 | 130 | 87.9 | 6 | 838 | 101 | 448 | 699 | HWX21912.1 HYR domain-containing protein [Candidatus Binatia bacterium] | diamond | 771 | 175 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Binatota | Candidatus Binatia | Candidatus Binatia bacterium | |||||
| 28187405 | 28187405 | PRJNA685607_P_NODE_54786_length_269_cov_1.219388_g54427_i0 | PRJNA685607 | 54786 | 269 | 1.219388 | 3.28015372 | candidate division TM6 bacterium Zodletone_IIa | 1511133 | Bacteria | Bacteria | 123 | 1.91e-33 | NR | KHD90208.1 | 1511133 | g54427 | i0 | 64 | 0.992565055762082 | 89 | 32 | 99.3 | 0 | 3 | 269 | 21 | 109 | KHD90208.1 hypothetical protein AH06_00615 [candidate division TM6 bacterium Zodletone_IIa] | diamond | 267 | 123 | 1 | Bacteria | Bacteria candidate phyla | candidate division TM6 bacterium Zodletone_IIa | |||||||
| 28440360 | 28440360 | PRJNA685607_P_NODE_31346_length_325_cov_1.507937_g30987_i0 | PRJNA685607 | 31346 | 325 | 1.507937 | 4.90079525 | Candidatus Altimarinota bacterium | 2044595 | Bacteria | Bacteria | 88.6 | 7.59e-18 | NR | NJM08034.1 | 2044595 | g30987 | i0 | 43.1 | 1.00615384615385 | 109 | 57 | 96 | 2 | 12 | 323 | 468 | 576 | NJM08034.1 dynamin [Candidatus Altimarinota bacterium] | diamond | 327 | 88.6 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Altimarinota | Candidatus Altimarinota bacterium | ||||||
| 29135111 | 29135111 | PRJNA685607_P_NODE_52449_length_273_cov_1.540000_g52090_i0 | PRJNA685607 | 52449 | 273 | 1.54 | 4.2042 | Patescibacteria group bacterium | 2052139 | Bacteria | Bacteria | 43.5 | 0.0293 | NR | MBU0577631.1 | 2052139 | g52090 | i0 | 43.1 | 0.56043956043956 | 51 | 29 | 56 | 0 | 36 | 188 | 749 | 799 | MBU0577631.1 hypothetical protein [Patescibacteria group bacterium] | diamond | 153 | 43.5 | 1 | Bacteria | Bacteria candidate phyla | Patescibacteria group bacterium | |||||||
| 30903789 | 30903789 | PRJNA685607_P_NODE_5234_length_675_cov_2.149502_g4895_i0 | PRJNA685607 | 5234 | 675 | 2.149502 | 14.5091385 | Candidatus Binatia bacterium | 2838779 | Bacteria | Bacteria | 131 | 6.0000000000000005e-31 | NR | HWX21912.1 | 2838779 | g4895 | i0 | 44 | 2.53777777777778 | 191 | 96 | 80.9 | 5 | 553 | 8 | 503 | 691 | HWX21912.1 HYR domain-containing protein [Candidatus Binatia bacterium] | diamond | 1713 | 131 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Binatota | Candidatus Binatia | Candidatus Binatia bacterium | |||||
| 31061947 | 31061947 | PRJNA685607_P_NODE_6255_length_615_cov_1.418819_g5909_i0 | PRJNA685607 | 6255 | 615 | 1.418819 | 8.72573685 | Candidatus Saccharimonadales bacterium | 2973664 | Bacteria | Bacteria | 68.9 | 2.64e-10 | NR | HSW76902.1 | 2973664 | g5909 | i0 | 48.1 | 0.385365853658537 | 79 | 37 | 38.5 | 2 | 184 | 420 | 136 | 210 | HSW76902.1 histone H1/H5 family protein [Candidatus Saccharimonadales bacterium] | diamond | 237 | 68.9 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadia | Candidatus Saccharimonadales | Candidatus Saccharimonadales bacterium | ||||
| 31294461 | 31294461 | PRJNA685607_P_NODE_45675_length_287_cov_1.144860_g45316_i0 | PRJNA685607 | 45675 | 287 | 1.14486 | 3.2857482 | Candidatus Saccharimonas | 1331051 | Bacteria | Bacteria | 121 | 1.66e-29 | NR | MBP6037787.1 | 1917697 | g45316 | i0 | 60 | 1.90243902439024 | 95 | 38 | 99.3 | 0 | 1 | 285 | 338 | 432 | MBP6037787.1 hypothetical protein [Candidatus Saccharimonas sp.] | diamond | 546 | 122 | 0.991803278688525 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadia | Candidatus Saccharimonadales | Candidatus Saccharimonadaceae | Candidatus Saccharimonas | Candidatus Saccharimonas sp. | ||
| 31567845 | 31567845 | PRJNA685607_P_NODE_70216_length_249_cov_1.312500_g69857_i0 | PRJNA685607 | 70216 | 249 | 1.3125 | 3.268125 | Patescibacteria group bacterium | 2052139 | Bacteria | Bacteria | 66.2 | 2.11e-10 | NR | TAN57279.1 | 2052139 | g69857 | i0 | 48 | 3.62650602409639 | 75 | 33 | 85.5 | 3 | 1 | 213 | 126 | 198 | TAN57279.1 MAG: hypothetical protein EPN15_04850, partial [Patescibacteria group bacterium] | diamond | 903 | 66.2 | 1 | Bacteria | Bacteria candidate phyla | Patescibacteria group bacterium | |||||||
| 31567849 | 31567849 | PRJNA685607_P_NODE_93796_length_242_cov_0.911243_g93437_i0 | PRJNA685607 | 93796 | 242 | 0.911243 | 2.20520806 | Parcubacteria group bacterium ADurb.Bin216 | 1852939 | Bacteria | Bacteria | 42.7 | 0.0351 | NR | OQB09269.1 | 1852939 | g93437 | i0 | 44.2 | 0.644628099173554 | 52 | 27 | 63.2 | 2 | 163 | 11 | 220 | 270 | OQB09269.1 MAG: hypothetical protein BWY21_00843 [Parcubacteria group bacterium ADurb.Bin216] | diamond | 156 | 42.7 | 1 | Bacteria | Bacteria candidate phyla | Parcubacteria group bacterium ADurb.Bin216 | |||||||
| 31662321 | 31662321 | PRJNA685607_P_NODE_62577_length_255_cov_1.093407_g62218_i0 | PRJNA685607 | 62577 | 255 | 1.093407 | 2.78818785 | Candidatus Schekmanbacteria bacterium | 2419984 | Bacteria | Bacteria | 68.9 | 4.54e-12 | NR | MBI2571365.1 | 2419984 | g62218 | i0 | 45.8 | 0.976470588235294 | 83 | 40 | 97.6 | 2 | 255 | 7 | 64 | 141 | MBI2571365.1 TerD family protein [Candidatus Schekmanbacteria bacterium] | diamond | 249 | 68.9 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Schekmaniibacteriota | Candidatus Schekmanbacteria bacterium | ||||||
| 31788788 | 31788788 | PRJNA685607_P_NODE_49677_length_279_cov_1.121359_g49318_i0 | PRJNA685607 | 49677 | 279 | 1.121359 | 3.12859161 | Candidatus Methylomirabilota bacterium | 2072417 | Bacteria | Bacteria | 82.4 | 6.34e-16 | NR | MDH7500311.1 | 2072417 | g49318 | i0 | 45.5 | 1.93548387096774 | 88 | 47 | 93.5 | 1 | 3 | 263 | 198 | 285 | MDH7500311.1 ATP-dependent RecD-like DNA helicase [Candidatus Methylomirabilota bacterium] | diamond | 540 | 82.4 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Methylomirabilota | Candidatus Methylomirabilota bacterium | ||||||
| 31788794 | 31788794 | PRJNA685607_P_NODE_92977_length_242_cov_0.911243_g92618_i0 | PRJNA685607 | 92977 | 242 | 0.911243 | 2.20520806 | Patescibacteria group bacterium | 2052139 | Bacteria | Bacteria | 53.5 | 2.2e-7 | NR | MCL4419456.1 | 2052139 | g92618 | i0 | 61.1 | 0.669421487603306 | 54 | 19 | 66.9 | 2 | 3 | 164 | 9 | 60 | MCL4419456.1 hypothetical protein [Patescibacteria group bacterium] | diamond | 162 | 53.5 | 1 | Bacteria | Bacteria candidate phyla | Patescibacteria group bacterium | |||||||
| 32580156 | 32580156 | PRJNA685607_P_NODE_84639_length_245_cov_0.895349_g84280_i0 | PRJNA685607 | 84639 | 245 | 0.895349 | 2.19360505 | Candidatus Saccharibacteria bacterium RIFCSPHIGHO2_ | 1802133 | Bacteria | Bacteria | 87.4 | 6.96e-18 | NR | OGL23466.1 | 1802133 | g84280 | i0 | 51.3 | 0.955102040816327 | 78 | 38 | 95.5 | 0 | 4 | 237 | 325 | 402 | OGL23466.1 MAG: hypothetical protein A2791_01295 [Candidatus Saccharibacteria bacterium RIFCSPHIGHO2_01_FULL_46_30] | diamond | 234 | 87.4 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharibacteria bacterium RIFCSPHIGHO2_01_FULL_46_30 | ||||||
| 32705764 | 32705764 | PRJNA685607_P_NODE_81180_length_246_cov_0.890173_g80821_i0 | PRJNA685607 | 81180 | 246 | 0.890173 | 2.18982558 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 57 | 3.68e-7 | NR | MEZ0208986.1 | 2053589 | g80821 | i0 | 40.5 | 1.02439024390244 | 84 | 46 | 98.8 | 3 | 2 | 244 | 1167 | 1249 | MEZ0208986.1 hypothetical protein [Candidatus Paceibacterota bacterium] | diamond | 252 | 57 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 32894664 | 32894664 | PRJNA685607_P_NODE_4200_length_761_cov_1.680233_g3881_i0 | PRJNA685607 | 4200 | 761 | 1.680233 | 12.78657313 | Candidatus Binatia bacterium | 2838779 | Bacteria | Bacteria | 120 | 5.8700000000000005e-27 | NR | HWX21912.1 | 2838779 | g3881 | i0 | 44.3 | 0.729303547963206 | 185 | 94 | 70.2 | 4 | 551 | 18 | 517 | 699 | HWX21912.1 HYR domain-containing protein [Candidatus Binatia bacterium] | diamond | 555 | 120 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Binatota | Candidatus Binatia | Candidatus Binatia 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);;