contig_metadata
24 rows where analysis = "diamond", tax_clade = "Bacteria candidate phyla" and tax_phylum = "Candidatus Woykeibacteriota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5399230 | 5399230 | PRJNA1148190_P_NODE_467005_length_273_cov_1.350000_g455832_i0 | PRJNA1148190 | 467005 | 273 | 1.35 | 3.6855 | Candidatus Woykebacteria bacterium | 2814276 | Bacteria | Bacteria | 65.9 | 1.3099999999999999e-10 | NR | MEX0616854.1 | 2814276 | g455832 | i0 | 51.5 | 0.725274725274725 | 66 | 32 | 72.5 | 0 | 71 | 268 | 1 | 66 | MEX0616854.1 SDR family oxidoreductase [Candidatus Woykebacteria bacterium] | diamond | 198 | 65.9 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Woykeibacteriota | Candidatus Woykebacteria bacterium | ||||||
| 9220694 | 9220694 | PRJNA1148190_P_NODE_233108_length_353_cov_1.310714_g221938_i0 | PRJNA1148190 | 233108 | 353 | 1.310714 | 4.62682042 | root | 1 | Root_unresolved | Root_unresolved | 87 | 2.99e-17 | NR | OGY25266.1 | 1802595 | g221938 | i0 | 66.7 | 1.03682719546742 | 60 | 20 | 51 | 0 | 352 | 173 | 369 | 428 | OGY25266.1 MAG: replicative DNA helicase [Candidatus Woykebacteria bacterium RBG_16_39_9b] | diamond | 366 | 87.8 | 0.990888382687927 | Bacteria | Bacteria candidate phyla | Candidatus Woykeibacteriota | Candidatus Woykebacteria bacterium RBG_16_39_9b | ||||||
| 24080836 | 24080836 | PRJNA558770_P_NODE_179379_length_234_cov_4.673367_g177374_i0 | PRJNA558770 | 179379 | 234 | 4.673367 | 10.93567878 | Bacteria | 2 | Bacteria | Bacteria | 64.3 | 7.39e-11 | NR | OGY24214.1 | 1802593 | g177374 | i0 | 49.3 | 2.87179487179487 | 75 | 28 | 96.2 | 1 | 5 | 229 | 73 | 137 | OGY24214.1 MAG: hypothetical protein A2172_01530 [Candidatus Woykebacteria bacterium RBG_13_40_15] | diamond | 672 | 64.7 | 0.993817619783617 | Bacteria | Bacteria candidate phyla | Candidatus Woykeibacteriota | Candidatus Woykebacteria bacterium RBG_13_40_15 | ||||||
| 26654884 | 26654884 | PRJNA1028258_P_NODE_112581_length_250_cov_1.569061_g112018_i0 | PRJNA1028258 | 112581 | 250 | 1.569061 | 3.9226525 | Candidatus Woykebacteria bacterium | 2814276 | Bacteria | Bacteria | 43.9 | 0.0155 | NR | MEX0616497.1 | 2814276 | g112018 | i0 | 41 | 0.732 | 61 | 33 | 70.8 | 2 | 186 | 10 | 27 | 86 | MEX0616497.1 glycosyltransferase family 4 protein [Candidatus Woykebacteria bacterium] | diamond | 183 | 43.9 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Woykeibacteriota | Candidatus Woykebacteria bacterium | ||||||
| 26694700 | 26694700 | PRJNA335774_P_NODE_40181_length_250_cov_0.870056_g40029_i0 | PRJNA335774 | 40181 | 250 | 0.870056 | 2.17514 | Candidatus Woykebacteria bacterium RBG_16_43_9 | 1802596 | Bacteria | Bacteria | 125 | 5.61e-32 | NR | OGY25919.1 | 1802596 | g40029 | i0 | 70 | 0.96 | 80 | 24 | 96 | 0 | 6 | 245 | 214 | 293 | OGY25919.1 MAG: hypothetical protein A2Z11_02050 [Candidatus Woykebacteria bacterium RBG_16_43_9] | diamond | 240 | 125 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Woykeibacteriota | Candidatus Woykebacteria bacterium RBG_16_43_9 | ||||||
| 27236823 | 27236823 | PRJNA557436_S_NODE_2263_length_251_cov_2.425926_g2215_i0 | PRJNA557436 | 2263 | 251 | 2.425926 | 6.08907426 | Candidatus Woykebacteria bacterium RBG_13_4 | 2814276 | Bacteria | Bacteria | 43.1 | 0.0286 | NR | OGY24247.1 | 1802594 | g2215 | i0 | 66.7 | 0.322709163346614 | 27 | 9 | 32.3 | 0 | 87 | 7 | 1 | 27 | OGY24247.1 MAG: hypothetical protein A2Y57_04140 [Candidatus Woykebacteria bacterium RBG_13_40_7b] | diamond | 81 | 43.1 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Woykeibacteriota | Candidatus Woykebacteria bacterium RBG_13_40_7b | ||||||
| 27628267 | 27628267 | PRJNA1123436_P_NODE_118084_length_244_cov_0.900585_g116870_i0 | PRJNA1123436 | 118084 | 244 | 0.900585 | 2.1974274 | Bacteria | 2 | Bacteria | Bacteria | 94.4 | 9.12e-21 | NR | OGY24657.1 | 1802594 | g116870 | i0 | 66.7 | 2.58196721311475 | 69 | 23 | 84.8 | 0 | 208 | 2 | 1 | 69 | OGY24657.1 MAG: RNA polymerase sigma factor RpoD [Candidatus Woykebacteria bacterium RBG_13_40_7b] | diamond | 630 | 94.4 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Woykeibacteriota | Candidatus Woykebacteria bacterium RBG_13_40_7b | ||||||
| 28417718 | 28417718 | PRJNA1148190_P_NODE_153646_length_424_cov_1.655271_g142479_i0 | PRJNA1148190 | 153646 | 424 | 1.655271 | 7.01834904 | Bacteria | 2 | Bacteria | Bacteria | 157 | 1.6999999999999998e-44 | NR | OGY24631.1 | 1802593 | g142479 | i0 | 59.4 | 3.9127358490566 | 138 | 55 | 97.6 | 1 | 419 | 6 | 18 | 154 | OGY24631.1 MAG: integrase [Candidatus Woykebacteria bacterium RBG_13_40_15] | diamond | 1659 | 158 | 0.993670886075949 | Bacteria | Bacteria candidate phyla | Candidatus Woykeibacteriota | Candidatus Woykebacteria bacterium RBG_13_40_15 | ||||||
| 28847987 | 28847987 | PRJNA591000_P_NODE_1668_length_963_cov_4.819058_g1203_i0 | PRJNA591000 | 1668 | 963 | 4.819058 | 46.40752854 | Candidatus Woykebacteria bacterium RBG_19FT_COMBO_43_1 | 2814276 | Bacteria | Bacteria | 367 | 2.34e-122 | NR | OGY27566.1 | 1802598 | g1203 | i0 | 67.9 | 1.89719626168224 | 305 | 98 | 95 | 0 | 4 | 918 | 116 | 420 | OGY27566.1 MAG: iron transporter [Candidatus Woykebacteria bacterium RBG_19FT_COMBO_43_10] | diamond | 1827 | 367 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Woykeibacteriota | Candidatus Woykebacteria bacterium RBG_19FT_COMBO_43_10 | ||||||
| 28953400 | 28953400 | PRJEB3181_P_NODE_14168_length_224_cov_2.880829_g13904_i0 | PRJEB3181 | 14168 | 224 | 2.880829 | 6.45305696 | Bacteria | 2 | Bacteria | Bacteria | 42.7 | 0.0285 | NR | OGY24838.1 | 1802595 | g13904 | i0 | 34.7 | 1.92857142857143 | 72 | 45 | 93.8 | 1 | 13 | 222 | 215 | 286 | OGY24838.1 MAG: hypothetical protein A2134_01570 [Candidatus Woykebacteria bacterium RBG_16_39_9b] | diamond | 432 | 42.7 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Woykeibacteriota | Candidatus Woykebacteria bacterium RBG_16_39_9b | ||||||
| 29186534 | 29186534 | PRJNA1144090_P_NODE_79229_length_283_cov_1.866667_g78694_i0 | PRJNA1144090 | 79229 | 283 | 1.866667 | 5.28266761 | Candidatus Woykebacteria bacterium RIFCSPHIGHO2_ | 2814276 | Bacteria | Bacteria | 55.1 | 2.57e-6 | NR | OGY27251.1 | 1802599 | g78694 | i0 | 42 | 0.731448763250883 | 69 | 40 | 73.1 | 0 | 209 | 3 | 324 | 392 | OGY27251.1 MAG: histidine--tRNA ligase [Candidatus Woykebacteria bacterium RIFCSPHIGHO2_01_FULL_39_12] | diamond | 207 | 55.1 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Woykeibacteriota | Candidatus Woykebacteria bacterium RIFCSPHIGHO2_01_FULL_39_12 | ||||||
| 29272084 | 29272084 | PRJNA626640_P_NODE_13469_length_263_cov_1.215789_g13360_i0 | PRJNA626640 | 13469 | 263 | 1.215789 | 3.19752507 | Bacteria | 2 | Bacteria | Bacteria | 57.4 | 2.85e-7 | NR | OGY25190.1 | 1802595 | g13360 | i0 | 60.5 | 2.44106463878327 | 43 | 17 | 49 | 0 | 134 | 262 | 4 | 46 | OGY25190.1 MAG: phosphoribosylpyrophosphate synthetase [Candidatus Woykebacteria bacterium RBG_16_39_9b] | diamond | 642 | 57.8 | 0.993079584775087 | Bacteria | Bacteria candidate phyla | Candidatus Woykeibacteriota | Candidatus Woykebacteria bacterium RBG_16_39_9b | ||||||
| 29278834 | 29278834 | PRJNA1120060_P_NODE_1593749_length_289_cov_2.787037_g1575756_i0 | PRJNA1120060 | 1593749 | 289 | 2.787037 | 8.05453693 | Candidatus Woykebacteria bacterium RBG_16_43_9 | 1802596 | Bacteria | Bacteria | 49.7 | 7e-5 | NR | OGY25547.1 | 1802596 | g1575756 | i0 | 35.9 | 0.664359861591695 | 64 | 41 | 66.4 | 0 | 287 | 96 | 78 | 141 | OGY25547.1 MAG: hypothetical protein A2Z11_03930 [Candidatus Woykebacteria bacterium RBG_16_43_9] | diamond | 192 | 49.7 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Woykeibacteriota | Candidatus Woykebacteria bacterium RBG_16_43_9 | ||||||
| 29316893 | 29316893 | PRJNA352611_P_NODE_13609_length_250_cov_0.870056_g13551_i0 | PRJNA352611 | 13609 | 250 | 0.870056 | 2.17514 | Candidatus Woykebacteria bacterium RBG_16_43_9 | 1802596 | Bacteria | Bacteria | 125 | 5.61e-32 | NR | OGY25919.1 | 1802596 | g13551 | i0 | 70 | 0.96 | 80 | 24 | 96 | 0 | 6 | 245 | 214 | 293 | OGY25919.1 MAG: hypothetical protein A2Z11_02050 [Candidatus Woykebacteria bacterium RBG_16_43_9] | diamond | 240 | 125 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Woykeibacteriota | Candidatus Woykebacteria bacterium RBG_16_43_9 | ||||||
| 29490936 | 29490936 | PRJNA1148190_P_NODE_123250_length_475_cov_1.738806_g112087_i0 | PRJNA1148190 | 123250 | 475 | 1.738806 | 8.2593285 | Bacteria | 2 | Bacteria | Bacteria | 102 | 9.01e-22 | NR | OGY22652.1 | 1802591 | g112087 | i0 | 39 | 1.78105263157895 | 141 | 86 | 89.1 | 0 | 48 | 470 | 177 | 317 | OGY22652.1 MAG: phage portal protein [Candidatus Woykebacteria bacterium GWA1_44_8] | diamond | 846 | 103 | 0.990291262135922 | Bacteria | Bacteria candidate phyla | Candidatus Woykeibacteriota | Candidatus Woykebacteria bacterium GWA1_44_8 | ||||||
| 30572746 | 30572746 | PRJNA1078753_P_NODE_16953_length_292_cov_1.383562_g16757_i0 | PRJNA1078753 | 16953 | 292 | 1.383562 | 4.04000104 | Candidatus Woykebacteria bacterium RBG_16_43_9 | 1802596 | Bacteria | Bacteria | 49.7 | 2.51e-4 | NR | OGY25917.1 | 1802596 | g16757 | i0 | 40 | 0.770547945205479 | 75 | 41 | 72.9 | 1 | 2 | 214 | 281 | 355 | OGY25917.1 MAG: hypothetical protein A2Z11_02040 [Candidatus Woykebacteria bacterium RBG_16_43_9] | diamond | 225 | 49.7 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Woykeibacteriota | Candidatus Woykebacteria bacterium RBG_16_43_9 | ||||||
| 30961392 | 30961392 | PRJNA493632_P_NODE_489454_length_254_cov_1.640884_g486015_i0 | PRJNA493632 | 489454 | 254 | 1.640884 | 4.16784536 | Candidatus Woykebacteria bacterium RBG_13_4 | 2814276 | Bacteria | Bacteria | 43.5 | 0.0226 | NR | OGY23914.1 | 1802593 | g486015 | i0 | 57.9 | 0.850393700787402 | 38 | 14 | 42.5 | 1 | 145 | 252 | 433 | 470 | OGY23914.1 MAG: hypothetical protein A2172_02775 [Candidatus Woykebacteria bacterium RBG_13_40_15] | diamond | 216 | 43.5 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Woykeibacteriota | Candidatus Woykebacteria bacterium RBG_13_40_15 | ||||||
| 31185252 | 31185252 | PRJNA591000_P_NODE_3655_length_746_cov_4.114365_g2845_i0 | PRJNA591000 | 3655 | 746 | 4.114365 | 30.6931629 | Candidatus Woykebacteria bacterium RBG_13_4 | 2814276 | Bacteria | Bacteria | 110 | 8.94e-27 | NR | OGY22762.1 | 1802593 | g2845 | i0 | 56.6 | 0.398123324396783 | 99 | 43 | 39.8 | 0 | 160 | 456 | 9 | 107 | OGY22762.1 MAG: hypothetical protein A2172_03950 [Candidatus Woykebacteria bacterium RBG_13_40_15] | diamond | 297 | 110 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Woykeibacteriota | Candidatus Woykebacteria bacterium RBG_13_40_15 | ||||||
| 31199257 | 31199257 | PRJNA690592_S_NODE_147215_length_279_cov_1.495146_g146201_i0 | PRJNA690592 | 147215 | 279 | 1.495146 | 4.17145734 | Bacteria candidate phyla | 1783234 | Bacteria | Bacteria | 45.1 | 0.00487 | NR | OGY25041.1 | 1802594 | g146201 | i0 | 27.1 | 6.73118279569892 | 85 | 59 | 91.4 | 2 | 263 | 9 | 86 | 167 | OGY25041.1 MAG: hypothetical protein A2Y57_02705 [Candidatus Woykebacteria bacterium RBG_13_40_7b] | diamond | 1878 | 45.1 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Woykeibacteriota | Candidatus Woykebacteria bacterium RBG_13_40_7b | ||||||
| 31501131 | 31501131 | PRJNA557436_S_NODE_7876_length_158_cov_2.073171_g7828_i0 | PRJNA557436 | 7876 | 158 | 2.073171 | 3.27561018 | Candidatus Woykebacteria bacterium RBG_13_4 | 2814276 | Bacteria | Bacteria | 48.1 | 1.44e-4 | NR | OGY24247.1 | 1802594 | g7828 | i0 | 41.2 | 0.968354430379747 | 51 | 30 | 96.8 | 0 | 153 | 1 | 116 | 166 | OGY24247.1 MAG: hypothetical protein A2Y57_04140 [Candidatus Woykebacteria bacterium RBG_13_40_7b] | diamond | 153 | 48.1 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Woykeibacteriota | Candidatus Woykebacteria bacterium RBG_13_40_7b | ||||||
| 31560283 | 31560283 | PRJNA340009_P_NODE_60836_length_168_cov_1.714286_g60529_i0 | PRJNA340009 | 60836 | 168 | 1.714286 | 2.88000048 | Candidatus Woykebacteria bacterium RIFCSPHIGHO2_12_FULL_45_1 | 2814276 | Bacteria | Bacteria | 84.7 | 1.17e-18 | NR | OGY29388.1 | 1802603 | g60529 | i0 | 70.4 | 0.964285714285714 | 54 | 16 | 96.4 | 0 | 165 | 4 | 48 | 101 | OGY29388.1 MAG: hypothetical protein A3F35_01505 [Candidatus Woykebacteria bacterium RIFCSPHIGHO2_12_FULL_45_10] | diamond | 162 | 84.7 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Woykeibacteriota | Candidatus Woykebacteria bacterium RIFCSPHIGHO2_12_FULL_45_10 | ||||||
| 32214561 | 32214561 | PRJEB28062_P_NODE_23458_length_770_cov_12.255380_g21268_i0 | PRJEB28062 | 23458 | 770 | 12.25538 | 94.366426 | Candidatus Woykebacteria bacterium | 2814276 | Bacteria | Bacteria | 47.8 | 0.0398 | NR | MEX0621926.1 | 2814276 | g21268 | i0 | 39.2 | 0.288311688311688 | 74 | 39 | 28.4 | 3 | 752 | 534 | 975 | 1043 | MEX0621926.1 hypothetical protein [Candidatus Woykebacteria bacterium] | diamond | 222 | 47.8 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Woykeibacteriota | Candidatus Woykebacteria bacterium | ||||||
| 32775505 | 32775505 | PRJNA956154_P_NODE_15080_length_246_cov_1.728324_g14999_i0 | PRJNA956154 | 15080 | 246 | 1.728324 | 4.25167704 | Candidatus Woykebacteria bacterium | 2814276 | Bacteria | Bacteria | 94.4 | 4.02e-22 | NR | MEX0617201.1 | 2814276 | g14999 | i0 | 54.3 | 1.90243902439024 | 81 | 36 | 98.8 | 1 | 3 | 245 | 53 | 132 | MEX0617201.1 peptide-methionine (S)-S-oxide reductase MsrA [Candidatus Woykebacteria bacterium] | diamond | 468 | 94.4 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Woykeibacteriota | Candidatus Woykebacteria bacterium | ||||||
| 32784076 | 32784076 | PRJNA1002570_P_NODE_6180_length_444_cov_1.644205_g5986_i0 | PRJNA1002570 | 6180 | 444 | 1.644205 | 7.3002702 | Candidatus Woykebacteria bacterium RBG_19FT_COMBO_43_1 | 2814276 | Bacteria | Bacteria | 103 | 1.07e-22 | NR | OGY27284.1 | 1802598 | g5986 | i0 | 49.5 | 1.77702702702703 | 91 | 46 | 61.5 | 0 | 168 | 440 | 9 | 99 | OGY27284.1 MAG: hypothetical protein A2Z42_01475 [Candidatus Woykebacteria bacterium RBG_19FT_COMBO_43_10] | diamond | 789 | 103 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Woykeibacteriota | Candidatus Woykebacteria bacterium RBG_19FT_COMBO_43_10 |
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);;