contig_metadata
21 rows where analysis = "diamond", bioproject = "PRJEB41113" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 10261908 | 10261908 | PRJEB41113_S_NODE_13129_length_153_cov_0.965517_g13120_i0 | PRJEB41113 | 13129 | 153 | 0.965517 | 1.47724101 | Candidatus Magasanikbacteria bacterium CG11_big_fil_rev_8_21_14_ | 2026717 | Bacteria | Bacteria | 69.7 | 2.93e-12 | NR | PIR03435.1 | 1974654 | g13120 | i0 | 88.6 | 0.686274509803922 | 35 | 4 | 68.6 | 0 | 153 | 49 | 326 | 360 | PIR03435.1 MAG: redox-regulated ATPase YchF [Candidatus Magasanikbacteria bacterium CG11_big_fil_rev_8_21_14_0_20_43_7] | diamond | 105 | 69.7 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Magasanikiibacteriota | Candidatus Magasanikbacteria bacterium CG11_big_fil_rev_8_21_14_0_20_43_7 | ||||||
| 24284955 | 24284955 | PRJEB41113_S_NODE_4560_length_190_cov_8.614379_g4551_i0 | PRJEB41113 | 4560 | 190 | 8.614379 | 16.3673201 | Bacteria | 2 | Bacteria | Bacteria | 111 | 1.29e-26 | NR | MBU3934885.1 | 2052139 | g4551 | i0 | 85.5 | 7.68947368421053 | 62 | 9 | 97.9 | 0 | 3 | 188 | 153 | 214 | MBU3934885.1 sodium-translocating pyrophosphatase [Patescibacteria group bacterium] | diamond | 1461 | 111 | 1 | Bacteria | Bacteria candidate phyla | Patescibacteria group bacterium | |||||||
| 26646674 | 26646674 | PRJEB41113_S_NODE_4461_length_191_cov_2.266234_g4452_i0 | PRJEB41113 | 4461 | 191 | 2.266234 | 4.32850694 | Bacteria | 2 | Bacteria | Bacteria | 121 | 2.94e-30 | NR | TWP08753.1 | 713052 | g4452 | i0 | 100 | 1.75916230366492 | 56 | 0 | 88 | 0 | 189 | 22 | 213 | 268 | TWP08753.1 hypothetical protein EUA76_00050 [TM7 phylum sp. oral taxon 350] | diamond | 336 | 121 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | TM7 phylum sp. oral taxon 350 | ||||||
| 27381303 | 27381303 | PRJEB41113_S_NODE_923_length_267_cov_2.552174_g914_i0 | PRJEB41113 | 923 | 267 | 2.552174 | 6.81430458 | candidate division Kazan bacterium | 2202143 | Bacteria | Bacteria | 43.1 | 0.0108 | NR | RLC36635.1 | 2202143 | g914 | i0 | 37.3 | 0.573033707865168 | 51 | 29 | 56.2 | 2 | 5 | 154 | 28 | 76 | RLC36635.1 MAG: hypothetical protein DRH29_04175 [candidate division Kazan bacterium] | diamond | 153 | 43.1 | 1 | Bacteria | Bacteria candidate phyla | candidate division Kazan bacterium | |||||||
| 27444587 | 27444587 | PRJEB41113_S_NODE_7723_length_170_cov_2.300752_g7714_i0 | PRJEB41113 | 7723 | 170 | 2.300752 | 3.9112784 | Candidatus Elulimicrobium humile | 2802965 | Bacteria | Bacteria | 48.9 | 9.19e-5 | NR | NBP55078.1 | 2802965 | g7714 | i0 | 53.8 | 0.688235294117647 | 39 | 18 | 68.8 | 0 | 154 | 38 | 408 | 446 | NBP55078.1 hypothetical protein [Candidatus Elulimicrobium humile] | diamond | 117 | 48.9 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Elulimicrobiota | Candidatus Elulimicrobia | Candidatus Elulimicrobiales | Candidatus Elulimicrobiaceae | Candidatus Elulimicrobium | Candidatus Elulimicrobium humile | ||
| 27823361 | 27823361 | PRJEB41113_S_NODE_10624_length_158_cov_2.528926_g10615_i0 | PRJEB41113 | 10624 | 158 | 2.528926 | 3.99570308 | Patescibacteria group bacterium | 2052139 | Bacteria | Bacteria | 83.2 | 4.55e-19 | NR | HKC14642.1 | 2052139 | g10615 | i0 | 80.8 | 0.987341772151899 | 52 | 10 | 98.7 | 0 | 156 | 1 | 49 | 100 | HKC14642.1 oligosaccharide flippase family protein [Patescibacteria group bacterium] | diamond | 156 | 83.2 | 1 | Bacteria | Bacteria candidate phyla | Patescibacteria group bacterium | |||||||
| 27942921 | 27942921 | PRJEB41113_S_NODE_2705_length_212_cov_3.154286_g2696_i0 | PRJEB41113 | 2705 | 212 | 3.154286 | 6.68708632 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 55.8 | 5.27e-7 | NR | OGZ00125.1 | 1798650 | g2696 | i0 | 54.1 | 2.85849056603774 | 61 | 24 | 80.7 | 2 | 176 | 6 | 109 | 169 | OGZ00125.1 MAG: hypothetical protein A2945_00335 [Candidatus Liptonbacteria bacterium RIFCSPLOWO2_01_FULL_52_25] | diamond | 606 | 55.8 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Liptoniibacteriota | Candidatus Liptonbacteria bacterium RIFCSPLOWO2_01_FULL_52_25 | ||||||
| 28265035 | 28265035 | PRJEB41113_S_NODE_11466_length_156_cov_0.932773_g11457_i0 | PRJEB41113 | 11466 | 156 | 0.932773 | 1.45512588 | Patescibacteria group bacterium | 2052139 | Bacteria | Bacteria | 51.6 | 8e-6 | NR | MEK7471990.1 | 2052139 | g11457 | i0 | 83.9 | 0.596153846153846 | 31 | 5 | 59.6 | 0 | 5 | 97 | 285 | 315 | MEK7471990.1 permease-like cell division protein FtsX [Patescibacteria group bacterium] | diamond | 93 | 51.6 | 1 | Bacteria | Bacteria candidate phyla | Patescibacteria group bacterium | |||||||
| 28265036 | 28265036 | PRJEB41113_S_NODE_11686_length_155_cov_4.745763_g11677_i0 | PRJEB41113 | 11686 | 155 | 4.745763 | 7.35593265 | Patescibacteria group bacterium | 2052139 | Bacteria | Bacteria | 79.7 | 6.93e-16 | NR | MEK7060904.1 | 2052139 | g11677 | i0 | 66.7 | 0.987096774193548 | 51 | 17 | 98.7 | 0 | 1 | 153 | 133 | 183 | MEK7060904.1 oligosaccharide flippase family protein [Patescibacteria group bacterium] | diamond | 153 | 79.7 | 1 | Bacteria | Bacteria candidate phyla | Patescibacteria group bacterium | |||||||
| 28296670 | 28296670 | PRJEB41113_S_NODE_8106_length_168_cov_1.992366_g8097_i0 | PRJEB41113 | 8106 | 168 | 1.992366 | 3.34717488 | Patescibacteria group bacterium | 2052139 | Bacteria | Bacteria | 84.7 | 2.05e-18 | NR | MEK7092751.1 | 2052139 | g8097 | i0 | 72.7 | 0.982142857142857 | 55 | 15 | 98.2 | 0 | 167 | 3 | 166 | 220 | MEK7092751.1 ABC transporter permease [Patescibacteria group bacterium] | diamond | 165 | 84.7 | 1 | Bacteria | Bacteria candidate phyla | Patescibacteria group bacterium | |||||||
| 28896564 | 28896564 | PRJEB41113_S_NODE_3128_length_205_cov_14.166667_g3119_i0 | PRJEB41113 | 3128 | 205 | 14.166667 | 29.04166735 | Candidatus Curtissbacteria bacterium | 2750075 | Bacteria | Bacteria | 95.1 | 4.6e-23 | NR | MDZ4209704.1 | 2750075 | g3119 | i0 | 64.7 | 0.995121951219512 | 68 | 24 | 99.5 | 0 | 205 | 2 | 51 | 118 | MDZ4209704.1 class I SAM-dependent methyltransferase [Candidatus Curtissbacteria bacterium] | diamond | 204 | 95.1 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Curtissiibacteriota | Candidatus Curtissbacteria bacterium | ||||||
| 28896566 | 28896566 | PRJEB41113_S_NODE_608_length_292_cov_5.364706_g599_i0 | PRJEB41113 | 608 | 292 | 5.364706 | 15.66494152 | Candidatus Levyibacteriota bacterium | 2052151 | Bacteria | Bacteria | 124 | 1.54e-32 | NR | MBI2032999.1 | 2052151 | g599 | i0 | 58.9 | 0.976027397260274 | 95 | 38 | 96.6 | 1 | 292 | 11 | 117 | 211 | MBI2032999.1 sulfatase-like hydrolase/transferase [Candidatus Levyibacteriota bacterium] | diamond | 285 | 124 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Levyibacteriota | Candidatus Levyibacteriota bacterium | ||||||
| 29528262 | 29528262 | PRJEB41113_S_NODE_6530_length_177_cov_3.142857_g6521_i0 | PRJEB41113 | 6530 | 177 | 3.142857 | 5.56285689 | Patescibacteria group bacterium | 2052139 | Bacteria | Bacteria | 104 | 3.76e-25 | NR | HKC15047.1 | 2052139 | g6521 | i0 | 100 | 0.915254237288136 | 54 | 0 | 91.5 | 0 | 164 | 3 | 70 | 123 | HKC15047.1 DNA recombination protein RmuC [Patescibacteria group bacterium] | diamond | 162 | 104 | 1 | Bacteria | Bacteria candidate phyla | Patescibacteria group bacterium | |||||||
| 30791718 | 30791718 | PRJEB41113_S_NODE_7334_length_172_cov_4.303704_g7325_i0 | PRJEB41113 | 7334 | 172 | 4.303704 | 7.40237088 | bacterium (Candidatus Gribaldobacteria) CG_4_1 | 2798521 | Bacteria | Bacteria | 61.2 | 1.25e-10 | NR | PJA01995.1 | 2014264 | g7325 | i0 | 63 | 0.802325581395349 | 46 | 16 | 80.2 | 1 | 3 | 140 | 29 | 73 | PJA01995.1 MAG: hypothetical protein COX73_03085 [bacterium (Candidatus Gribaldobacteria) CG_4_10_14_0_2_um_filter_36_18] | diamond | 138 | 61.2 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Gribaldobacteria | bacterium (Candidatus Gribaldobacteria) CG_4_10_14_0_2_um_filter_36_18 | ||||||
| 31170650 | 31170650 | PRJEB41113_S_NODE_6915_length_175_cov_1.681159_g6906_i0 | PRJEB41113 | 6915 | 175 | 1.681159 | 2.94202825 | Patescibacteria group bacterium | 2052139 | Bacteria | Bacteria | 103 | 1.14e-25 | NR | MEK7092751.1 | 2052139 | g6906 | i0 | 77.2 | 1.95428571428571 | 57 | 13 | 97.7 | 0 | 172 | 2 | 116 | 172 | MEK7092751.1 ABC transporter permease [Patescibacteria group bacterium] | diamond | 342 | 103 | 1 | Bacteria | Bacteria candidate phyla | Patescibacteria group bacterium | |||||||
| 31392448 | 31392448 | PRJEB41113_S_NODE_13836_length_152_cov_1.895652_g13827_i0 | PRJEB41113 | 13836 | 152 | 1.895652 | 2.88139104 | Candidatus Saccharibacteria bacterium | 2026720 | Bacteria | Bacteria | 89.4 | 1.58e-20 | NR | TAH32389.1 | 2026720 | g13827 | i0 | 78 | 0.986842105263158 | 50 | 11 | 98.7 | 0 | 152 | 3 | 103 | 152 | TAH32389.1 MAG: hypothetical protein EYC59_05965 [Candidatus Saccharibacteria bacterium] | diamond | 150 | 89.4 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadota bacterium | ||||||
| 31392452 | 31392452 | PRJEB41113_S_NODE_6216_length_179_cov_5.225352_g6207_i0 | PRJEB41113 | 6216 | 179 | 5.225352 | 9.35338008 | Candidatus Delongbacteria bacterium | 2044594 | Bacteria | Bacteria | 81.6 | 1.49e-16 | NR | MBN2857782.1 | 2044594 | g6207 | i0 | 67.3 | 1.89385474860335 | 55 | 18 | 92.2 | 0 | 8 | 172 | 79 | 133 | MBN2857782.1 IS30 family transposase [Candidatus Delongbacteria bacterium] | diamond | 339 | 81.6 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Delongiibacteriota | Candidatus Delongbacteria bacterium | ||||||
| 31740021 | 31740021 | PRJEB41113_S_NODE_9537_length_161_cov_5.096774_g9528_i0 | PRJEB41113 | 9537 | 161 | 5.096774 | 8.20580614 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 87 | 1.71e-18 | NR | HEY4484606.1 | 2053589 | g9528 | i0 | 85.1 | 1.73291925465839 | 47 | 7 | 87.6 | 0 | 1 | 141 | 300 | 346 | HEY4484606.1 hypothetical protein [Candidatus Paceibacterota bacterium] | diamond | 279 | 87 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 31961559 | 31961559 | PRJEB41113_S_NODE_10058_length_160_cov_1.544715_g10049_i0 | PRJEB41113 | 10058 | 160 | 1.544715 | 2.471544 | Candidatus Aminicenantales bacterium | 3090891 | Bacteria | Bacteria | 48.9 | 2.18e-5 | NR | MFQ6108474.1 | 3090891 | g10049 | i0 | 50 | 0.9 | 48 | 24 | 90 | 0 | 16 | 159 | 52 | 99 | MFQ6108474.1 RrF2 family transcriptional regulator [Candidatus Aminicenantales bacterium] | diamond | 144 | 48.9 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Aminicenantota | Candidatus Aminicenantia | Candidatus Aminicenantales | Candidatus Aminicenantales bacterium | ||||
| 32214857 | 32214857 | PRJEB41113_S_NODE_12438_length_154_cov_1.094017_g12429_i0 | PRJEB41113 | 12438 | 154 | 1.094017 | 1.68478618 | Patescibacteria group bacterium | 2052139 | Bacteria | Bacteria | 67.4 | 2.13e-11 | NR | HZQ30029.1 | 2052139 | g12429 | i0 | 70.2 | 0.915584415584416 | 47 | 14 | 91.6 | 0 | 6 | 146 | 297 | 343 | HZQ30029.1 MDR family MFS transporter [Patescibacteria group bacterium] | diamond | 141 | 67.4 | 1 | Bacteria | Bacteria candidate phyla | Patescibacteria group bacterium | |||||||
| 32341545 | 32341545 | PRJEB41113_S_NODE_2419_length_217_cov_6.944444_g2410_i0 | PRJEB41113 | 2419 | 217 | 6.944444 | 15.06944348 | Candidatus Shapirobacteria bacterium CG | 2053613 | Bacteria | Bacteria | 104 | 2.24e-27 | NR | PIS14719.1 | 1974885 | g2410 | i0 | 76.5 | 0.940092165898618 | 68 | 16 | 94 | 0 | 206 | 3 | 11 | 78 | PIS14719.1 MAG: hypothetical protein COT64_01135 [Candidatus Shapirobacteria bacterium CG09_land_8_20_14_0_10_39_12] | diamond | 204 | 104 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Shapironibacteriota | Candidatus Shapirobacteria bacterium CG09_land_8_20_14_0_10_39_12 |
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);;