contig_metadata
21 rows where tax_clade = "Bacteria candidate phyla" and tax_phylum = "Candidatus Beckwithiibacteriota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5705192 | 5705192 | PRJNA630162_P_NODE_129285_length_170_cov_1.123967_g127762_i0 | PRJNA630162 | 129285 | 170 | 1.123967 | 1.9107439 | Candidatus Beckwithbacteria bacterium GW2011_GWC1_49_16 | 1618372 | Bacteria | Bacteria | 106 | 1.08e-18 | NTclustered | gi|837349576|gb|CP011210.1| | 1618372 | g127762 | i0 | 86.735 | 118.352941176471 | 98 | 10 | 56 | 2 | 33 | 127 | 159342 | 159245 | MAG: Candidatus Beckwithbacteria bacterium GW2011_GWC1_49_16 chromosome, complete genome | blastn | 20120 | 106 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Beckwithiibacteriota | Candidatus Beckwithbacteria bacterium GW2011_GWC1_49_16 | ||||||
| 14155661 | 14155661 | PRJEB64798_P_NODE_160172_length_183_cov_5.194030_g158406_i0 | PRJEB64798 | 160172 | 183 | 5.19403 | 9.5050749 | Candidatus Beckwithbacteria bacterium GW2011_GWC1_49_16 | 1618372 | Bacteria | Bacteria | 145 | 2.5e-30 | NTclustered | gi|837349576|gb|CP011210.1| | 1618372 | g158406 | i0 | 82.53 | 104.431693989071 | 166 | 27 | 90 | 2 | 12 | 176 | 161670 | 161834 | MAG: Candidatus Beckwithbacteria bacterium GW2011_GWC1_49_16 chromosome, complete genome | blastn | 19111 | 145 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Beckwithiibacteriota | Candidatus Beckwithbacteria bacterium GW2011_GWC1_49_16 | ||||||
| 19818837 | 19818837 | PRJNA704949_P_NODE_1745336_length_181_cov_2.363636_g1729997_i0 | PRJNA704949 | 1745336 | 181 | 2.363636 | 4.27818116 | Bacillati | 1783272 | Bacteria | Bacteria | 93.2 | 6.890000000000001e-21 | NR | PIP52920.1 | 1974497 | g1729997 | i0 | 76.4 | 10.1933701657459 | 55 | 13 | 91.2 | 0 | 180 | 16 | 196 | 250 | PIP52920.1 MAG: GDP-mannose 4,6-dehydratase [Candidatus Beckwithbacteria bacterium CG23_combo_of_CG06-09_8_20_14_all_34_8] | diamond | 1845 | 93.2 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Beckwithiibacteriota | Candidatus Beckwithbacteria bacterium CG23_combo_of_CG06-09_8_20_14_all_34_8 | ||||||
| 23971782 | 23971782 | PRJNA1095825_P_NODE_246339_length_249_cov_1.750000_g243276_i0 | PRJNA1095825 | 246339 | 249 | 1.75 | 4.3575 | Candidatus Beckwithbacteria bacterium | 2053519 | Bacteria | Bacteria | 66.6 | 1.47e-10 | NR | NMB56310.1 | 2053519 | g243276 | i0 | 52.1 | 0.578313253012048 | 48 | 23 | 57.8 | 0 | 248 | 105 | 403 | 450 | NMB56310.1 hypothetical protein [Candidatus Beckwithbacteria bacterium] | diamond | 144 | 66.6 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Beckwithiibacteriota | Candidatus Beckwithbacteria bacterium | ||||||
| 26742524 | 26742524 | PRJNA1144090_P_NODE_32781_length_457_cov_2.614583_g32246_i0 | PRJNA1144090 | 32781 | 457 | 2.614583 | 11.94864431 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 79.7 | 4.62e-14 | NR | PIS09315.1 | 1974495 | g32246 | i0 | 35.7 | 5.63238512035011 | 143 | 91 | 93.2 | 1 | 457 | 32 | 467 | 609 | PIS09315.1 MAG: molecular chaperone DnaK [Candidatus Beckwithbacteria bacterium CG10_big_fil_rev_8_21_14_0_10_34_10] | diamond | 2574 | 79.7 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Beckwithiibacteriota | Candidatus Beckwithbacteria bacterium CG10_big_fil_rev_8_21_14_0_10_34_10 | ||||||
| 26829226 | 26829226 | PRJNA688655_P_NODE_4981_length_295_cov_1.427928_g4916_i0 | PRJNA688655 | 4981 | 295 | 1.427928 | 4.2123876 | Candidatus Beckwithbacteria bacterium CG23_combo_of_CG | 2053519 | Bacteria | Bacteria | 53.5 | 9.08e-6 | NR | PIP52731.1 | 1974497 | g4916 | i0 | 40.6 | 0.701694915254237 | 69 | 41 | 70.2 | 0 | 77 | 283 | 1 | 69 | PIP52731.1 MAG: hypothetical protein COX08_04830 [Candidatus Beckwithbacteria bacterium CG23_combo_of_CG06-09_8_20_14_all_34_8] | diamond | 207 | 53.5 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Beckwithiibacteriota | Candidatus Beckwithbacteria bacterium CG23_combo_of_CG06-09_8_20_14_all_34_8 | ||||||
| 28041913 | 28041913 | PRJNA743294_P_NODE_41145_length_265_cov_3.890625_g40689_i0 | PRJNA743294 | 41145 | 265 | 3.890625 | 10.31015625 | Bacteria | 2 | Bacteria | Bacteria | 85.9 | 1.52e-17 | NR | NMC36426.1 | 2053519 | g40689 | i0 | 47 | 1.84528301886792 | 83 | 42 | 91.7 | 1 | 261 | 19 | 243 | 325 | NMC36426.1 hypothetical protein [Candidatus Beckwithbacteria bacterium] | diamond | 489 | 86.7 | 0.990772779700115 | Bacteria | Bacteria candidate phyla | Candidatus Beckwithiibacteriota | Candidatus Beckwithbacteria bacterium | ||||||
| 28562044 | 28562044 | PRJNA533114_P_NODE_110467_length_245_cov_0.895349_g110215_i0 | PRJNA533114 | 110467 | 245 | 0.895349 | 2.19360505 | Candidatus Beckwithbacteria bacterium CG2_3 | 2053519 | Bacteria | Bacteria | 70.9 | 3.11e-12 | NR | OIP03273.1 | 1805035 | g110215 | i0 | 46.8 | 3.68571428571429 | 79 | 36 | 96.7 | 2 | 7 | 243 | 119 | 191 | OIP03273.1 MAG: hypothetical protein AUK18_02295 [Candidatus Beckwithbacteria bacterium CG2_30_44_31] | diamond | 903 | 70.9 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Beckwithiibacteriota | Candidatus Beckwithbacteria bacterium CG2_30_44_31 | ||||||
| 28986417 | 28986417 | PRJNA1195374_P_NODE_14368_length_595_cov_1.224138_g14030_i0 | PRJNA1195374 | 14368 | 595 | 1.224138 | 7.2836211 | Bacteria | 2 | Bacteria | Bacteria | 65.5 | 1.47e-8 | NR | AKM78923.1 | 1618372 | g14030 | i0 | 32.7 | 6.9781512605042 | 171 | 103 | 81.7 | 5 | 575 | 90 | 68 | 235 | AKM78923.1 MAG: P-type ATPase, translocating [Candidatus Beckwithbacteria bacterium GW2011_GWC1_49_16] | diamond | 4152 | 65.5 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Beckwithiibacteriota | Candidatus Beckwithbacteria bacterium GW2011_GWC1_49_16 | ||||||
| 29347714 | 29347714 | PRJNA217180_P_NODE_15449_length_161_cov_0.910714_g15349_i0 | PRJNA217180 | 15449 | 161 | 0.910714 | 1.46624954 | Candidatus Beckwithbacteria bacterium RBG_13_35_6 | 1797456 | Bacteria | Bacteria | 83.6 | 5.83e-19 | NR | OGD52714.1 | 1797456 | g15349 | i0 | 70.6 | 0.950310559006211 | 51 | 15 | 95 | 0 | 153 | 1 | 71 | 121 | OGD52714.1 MAG: cupin [Candidatus Beckwithbacteria bacterium RBG_13_35_6] | diamond | 153 | 83.6 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Beckwithiibacteriota | Candidatus Beckwithbacteria bacterium RBG_13_35_6 | ||||||
| 29502050 | 29502050 | PRJNA1148190_P_NODE_126610_length_468_cov_3.000000_g115447_i0 | PRJNA1148190 | 126610 | 468 | 3 | 14.04 | Candidatus Beckwithbacteria bacterium | 2053519 | Bacteria | Bacteria | 87 | 3.69e-17 | NR | NMC36624.1 | 2053519 | g115447 | i0 | 53.1 | 0.519230769230769 | 81 | 38 | 51.9 | 0 | 3 | 245 | 203 | 283 | NMC36624.1 glycosyltransferase family 2 protein [Candidatus Beckwithbacteria bacterium] | diamond | 243 | 87 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Beckwithiibacteriota | Candidatus Beckwithbacteria bacterium | ||||||
| 29534904 | 29534904 | PRJNA1148190_P_NODE_7630_length_4057_cov_4.899096_g3333_i1 | PRJNA1148190 | 7630 | 4057 | 4.899096 | 198.75632472 | Candidatus Beckwithbacteria bacterium CG1 | 2053519 | Bacteria | Bacteria | 80.5 | 4.21e-11 | NR | PIS09646.1 | 1974495 | g3333 | i1 | 42.2 | 0.255854079368992 | 147 | 72 | 10.3 | 8 | 3617 | 3201 | 114 | 255 | PIS09646.1 MAG: hypothetical protein COT75_00405 [Candidatus Beckwithbacteria bacterium CG10_big_fil_rev_8_21_14_0_10_34_10] | diamond | 1038 | 80.5 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Beckwithiibacteriota | Candidatus Beckwithbacteria bacterium CG10_big_fil_rev_8_21_14_0_10_34_10 | ||||||
| 29634516 | 29634516 | PRJNA505329_P_NODE_45010_length_166_cov_1.760684_g44539_i0 | PRJNA505329 | 45010 | 166 | 1.760684 | 2.92273544 | Candidatus Beckwithbacteria bacterium CG23_combo_of_CG | 2053519 | Bacteria | Bacteria | 42.7 | 0.0129 | NR | PIP53016.1 | 1974497 | g44539 | i0 | 45.8 | 0.867469879518072 | 48 | 25 | 86.7 | 1 | 21 | 164 | 202 | 248 | PIP53016.1 MAG: chaperonin GroEL, partial [Candidatus Beckwithbacteria bacterium CG23_combo_of_CG06-09_8_20_14_all_34_8] | diamond | 144 | 42.7 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Beckwithiibacteriota | Candidatus Beckwithbacteria bacterium CG23_combo_of_CG06-09_8_20_14_all_34_8 | ||||||
| 29850418 | 29850418 | PRJNA1148190_P_NODE_588171_length_251_cov_0.865169_g576998_i0 | PRJNA1148190 | 588171 | 251 | 0.865169 | 2.17157419 | Candidatus Beckwithbacteria bacterium | 2053519 | Bacteria | Bacteria | 103 | 1.3299999999999999e-24 | NR | NMB56414.1 | 2053519 | g576998 | i0 | 59.5 | 1.00398406374502 | 84 | 33 | 99.2 | 1 | 3 | 251 | 24 | 107 | NMB56414.1 hypothetical protein [Candidatus Beckwithbacteria bacterium] | diamond | 252 | 103 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Beckwithiibacteriota | Candidatus Beckwithbacteria bacterium | ||||||
| 30028867 | 30028867 | PRJNA340009_P_NODE_58711_length_171_cov_1.639344_g58404_i0 | PRJNA340009 | 58711 | 171 | 1.639344 | 2.80327824 | root | 1 | Root_unresolved | Root_unresolved | 82.4 | 1.5e-16 | NR | PIS08688.1 | 1974495 | g58404 | i0 | 62 | 1.75438596491228 | 50 | 19 | 87.7 | 0 | 150 | 1 | 672 | 721 | PIS08688.1 MAG: penicillin-binding protein [Candidatus Beckwithbacteria bacterium CG10_big_fil_rev_8_21_14_0_10_34_10] | diamond | 300 | 82.4 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Beckwithiibacteriota | Candidatus Beckwithbacteria bacterium CG10_big_fil_rev_8_21_14_0_10_34_10 | ||||||
| 30641306 | 30641306 | PRJNA1226487_P_NODE_50293_length_272_cov_1.547739_g50191_i0 | PRJNA1226487 | 50293 | 272 | 1.547739 | 4.20985008 | Candidatus Beckwithbacteria bacterium CG1 | 2053519 | Bacteria | Bacteria | 42.7 | 0.0498 | NR | PIS09142.1 | 1974495 | g50191 | i0 | 46.2 | 0.430147058823529 | 39 | 21 | 43 | 0 | 216 | 100 | 285 | 323 | PIS09142.1 MAG: hypothetical protein COT75_02680 [Candidatus Beckwithbacteria bacterium CG10_big_fil_rev_8_21_14_0_10_34_10] | diamond | 117 | 42.7 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Beckwithiibacteriota | Candidatus Beckwithbacteria bacterium CG10_big_fil_rev_8_21_14_0_10_34_10 | ||||||
| 30766287 | 30766287 | PRJNA1148190_P_NODE_421134_length_282_cov_1.368421_g409961_i0 | PRJNA1148190 | 421134 | 282 | 1.368421 | 3.85894722 | Candidatus Beckwithbacteria bacterium CG23_combo_of_CG | 2053519 | Bacteria | Bacteria | 110 | 5.9000000000000005e-27 | NR | PIP51780.1 | 1974498 | g409961 | i0 | 60.2 | 0.936170212765957 | 88 | 34 | 92.6 | 1 | 282 | 22 | 161 | 248 | PIP51780.1 MAG: hypothetical protein COX09_05225 [Candidatus Beckwithbacteria bacterium CG23_combo_of_CG06-09_8_20_14_all_47_9] | diamond | 264 | 110 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Beckwithiibacteriota | Candidatus Beckwithbacteria bacterium CG23_combo_of_CG06-09_8_20_14_all_47_9 | ||||||
| 31631385 | 31631385 | PRJNA703759_P_NODE_48616_length_243_cov_1.576471_g48140_i0 | PRJNA703759 | 48616 | 243 | 1.576471 | 3.83082453 | Candidatus Beckwithbacteria bacterium | 2053519 | Bacteria | Bacteria | 109 | 1.84e-26 | NR | NMC36392.1 | 2053519 | g48140 | i0 | 67.5 | 1.02469135802469 | 83 | 25 | 100 | 1 | 243 | 1 | 252 | 334 | NMC36392.1 DegT/DnrJ/EryC1/StrS family aminotransferase [Candidatus Beckwithbacteria bacterium] | diamond | 249 | 109 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Beckwithiibacteriota | Candidatus Beckwithbacteria bacterium | ||||||
| 32094078 | 32094078 | PRJNA1148190_P_NODE_302178_length_319_cov_1.170732_g291005_i0 | PRJNA1148190 | 302178 | 319 | 1.170732 | 3.73463508 | Candidatus Beckwithbacteria bacterium | 2053519 | Bacteria | Bacteria | 72.8 | 2.57e-12 | NR | NMC36625.1 | 2053519 | g291005 | i0 | 42 | 0.940438871473354 | 100 | 57 | 93.1 | 1 | 305 | 9 | 339 | 438 | NMC36625.1 hypothetical protein [Candidatus Beckwithbacteria bacterium] | diamond | 300 | 72.8 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Beckwithiibacteriota | Candidatus Beckwithbacteria bacterium | ||||||
| 32131267 | 32131267 | PRJNA482207_P_NODE_17278_length_266_cov_1.492228_g17168_i0 | PRJNA482207 | 17278 | 266 | 1.492228 | 3.96932648 | Candidatus Beckwithbacteria bacterium | 2053519 | Bacteria | Bacteria | 65.1 | 2.21e-11 | NR | NMC36244.1 | 2053519 | g17168 | i0 | 58.7 | 3.40601503759398 | 63 | 25 | 69.9 | 1 | 187 | 2 | 1 | 63 | NMC36244.1 Asp-tRNA(Asn)/Glu-tRNA(Gln) amidotransferase subunit GatC [Candidatus Beckwithbacteria bacterium] | diamond | 906 | 65.1 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Beckwithiibacteriota | Candidatus Beckwithbacteria bacterium | ||||||
| 33099046 | 33099046 | PRJEB20058_P_NODE_25462_length_827_cov_8.232376_g23197_i0 | PRJEB20058 | 25462 | 827 | 8.232376 | 68.08174952 | Candidatus Beckwithbacteria bacterium | 2053519 | Bacteria | Bacteria | 65.9 | 1.43e-8 | NR | MFH2062283.1 | 2053519 | g23197 | i0 | 34.4 | 0.453446191051995 | 125 | 74 | 45.3 | 3 | 796 | 422 | 135 | 251 | MFH2062283.1 hypothetical protein [Candidatus Beckwithbacteria bacterium] | diamond | 375 | 65.9 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Beckwithiibacteriota | Candidatus Beckwithbacteria 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);;