contig_metadata
17 rows where bioproject = "PRJNA906294", tax_clade = "Bacteria candidate phyla" and tax_superkingdom = "Bacteria"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 25475149 | 25475149 | PRJNA906294_P_NODE_198020_length_257_cov_1.554348_g193904_i0 | PRJNA906294 | 198020 | 257 | 1.554348 | 3.99467436 | Candidatus Nanosynbacteraceae | 2093822 | Bacteria | Bacteria | 464 | 2.5299999999999998e-126 | NTclustered | gi|1842054184|gb|CP039999.1| | 713059 | g193904 | i0 | 99.222 | 72.704280155642 | 257 | 2 | 100 | 0 | 1 | 257 | 143863 | 143607 | Candidatus Saccharibacteria bacterium oral taxon 488 strain CM001 chromosome, complete genome | blastn | 18685 | 464 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharibacteria bacterium oral taxon 488 | ||||||
| 26612593 | 26612593 | PRJNA906294_P_NODE_125701_length_352_cov_1.017921_g121585_i0 | PRJNA906294 | 125701 | 352 | 1.017921 | 3.58308192 | Candidatus Rokuibacteriota bacterium | 2053607 | Bacteria | Bacteria | 47.4 | 0.00297 | NR | PWU25070.1 | 2053607 | g121585 | i0 | 31.8 | 0.5625 | 66 | 41 | 56.3 | 1 | 241 | 44 | 131 | 192 | PWU25070.1 MAG: hypothetical protein C5B48_03195, partial [Candidatus Rokuibacteriota bacterium] | diamond | 198 | 47.4 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Rokuibacteriota | Candidatus Rokuibacteriota bacterium | ||||||
| 26675849 | 26675849 | PRJNA906294_P_NODE_234721_length_208_cov_5.977778_g230605_i0 | PRJNA906294 | 234721 | 208 | 5.977778 | 12.43377824 | Candidatus Aminicenantes bacterium | 2052149 | Bacteria | Bacteria | 41.2 | 0.0488 | NR | MCJ7588736.1 | 2052149 | g230605 | i0 | 59.5 | 0.533653846153846 | 37 | 12 | 53.4 | 1 | 180 | 70 | 4 | 37 | MCJ7588736.1 tetratricopeptide repeat protein [Candidatus Aminicenantes bacterium] | diamond | 111 | 41.2 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Aminicenantota | Candidatus Aminicenantes bacterium | ||||||
| 27309009 | 27309009 | PRJNA906294_P_NODE_189363_length_266_cov_1.181347_g185247_i0 | PRJNA906294 | 189363 | 266 | 1.181347 | 3.14238302 | Candidatus Dependentiae bacterium | 2030827 | Bacteria | Bacteria | 43.1 | 0.00616 | NR | RTL06915.1 | 2030827 | g185247 | i0 | 63 | 0.304511278195489 | 27 | 10 | 30.5 | 0 | 82 | 2 | 36 | 62 | RTL06915.1 MAG: hypothetical protein EKK58_03725 [Candidatus Dependentiae bacterium] | diamond | 81 | 43.1 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Babelota bacterium | |||||||
| 27561231 | 27561231 | PRJNA906294_P_NODE_135404_length_334_cov_1.452107_g131288_i0 | PRJNA906294 | 135404 | 334 | 1.452107 | 4.85003738 | Candidatus Babeliales bacterium | 2803731 | Bacteria | Bacteria | 55.8 | 2.3e-6 | NR | HLB93969.1 | 2803731 | g131288 | i0 | 41.3 | 0.565868263473054 | 63 | 35 | 54.8 | 1 | 115 | 297 | 131 | 193 | HLB93969.1 hypothetical protein [Candidatus Babeliales bacterium] | diamond | 189 | 55.8 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Babeliae | Candidatus Babeliales | Candidatus Babeliales bacterium | |||||
| 27656396 | 27656396 | PRJNA906294_P_NODE_82404_length_482_cov_0.929095_g78290_i0 | PRJNA906294 | 82404 | 482 | 0.929095 | 4.4782379 | Candidatus Methylomirabilota bacterium | 2072417 | Bacteria | Bacteria | 46.2 | 0.0236 | NR | HXG20725.1 | 2072417 | g78290 | i0 | 51.1 | 0.280082987551867 | 45 | 22 | 28 | 0 | 25 | 159 | 566 | 610 | HXG20725.1 recombinase family protein [Candidatus Methylomirabilota bacterium] | diamond | 135 | 46.2 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Methylomirabilota | Candidatus Methylomirabilota bacterium | ||||||
| 29014201 | 29014201 | PRJNA906294_P_NODE_196368_length_259_cov_1.225806_g192252_i0 | PRJNA906294 | 196368 | 259 | 1.225806 | 3.17483754 | Candidatus Nomurabacteria bacterium | 2052152 | Bacteria | Bacteria | 40.8 | 0.043 | NR | MCX6752098.1 | 2052152 | g192252 | i0 | 37.3 | 0.590733590733591 | 51 | 32 | 59.1 | 0 | 58 | 210 | 32 | 82 | MCX6752098.1 YdeI/OmpD-associated family protein [Candidatus Nomurabacteria bacterium] | diamond | 153 | 40.8 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Nomuraibacteriota | Candidatus Nomurabacteria bacterium | ||||||
| 29266291 | 29266291 | PRJNA906294_P_NODE_230489_length_241_cov_0.904762_g226373_i0 | PRJNA906294 | 230489 | 241 | 0.904762 | 2.18047642 | SCandidatus Aminicenantes bacterium Aminicenantia_JdfR_composite | 2950077 | Bacteria | Bacteria | 42 | 0.0426 | NR | MCP2521087.1 | 2950077 | g226373 | i0 | 36.4 | 0.821576763485477 | 66 | 40 | 79.7 | 1 | 212 | 21 | 84 | 149 | MCP2521087.1 hypothetical protein [SCandidatus Aminicenantes bacterium Aminicenantia_JdfR_composite] | diamond | 198 | 42 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Aminicenantota | SCandidatus Aminicenantes bacterium Aminicenantia_JdfR_composite | ||||||
| 29581869 | 29581869 | PRJNA906294_P_NODE_185090_length_270_cov_1.512690_g180974_i0 | PRJNA906294 | 185090 | 270 | 1.51269 | 4.084263 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 60.1 | 2.85e-9 | NR | MDR3570671.1 | 2053589 | g180974 | i0 | 48.8 | 0.888888888888889 | 80 | 34 | 81.1 | 2 | 2 | 220 | 29 | 108 | MDR3570671.1 hypothetical protein [Candidatus Paceibacterota bacterium] | diamond | 240 | 60.1 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 29708116 | 29708116 | PRJNA906294_P_NODE_219770_length_245_cov_0.883721_g215654_i0 | PRJNA906294 | 219770 | 245 | 0.883721 | 2.16511645 | Candidatus Acetothermia bacterium | 2053493 | Bacteria | Bacteria | 70.9 | 4.64e-12 | NR | MBI1730412.1 | 2053493 | g215654 | i0 | 51.4 | 0.857142857142857 | 70 | 27 | 85.7 | 2 | 35 | 244 | 305 | 367 | MBI1730412.1 choline dehydrogenase [Candidatus Acetothermia bacterium] | diamond | 210 | 70.9 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Bipolaricaulota | Candidatus Acetothermia bacterium | ||||||
| 29834748 | 29834748 | PRJNA906294_P_NODE_122131_length_359_cov_1.230769_g118015_i0 | PRJNA906294 | 122131 | 359 | 1.230769 | 4.41846071 | Candidatus Methylomirabilota bacterium | 2072417 | Bacteria | Bacteria | 43.9 | 0.0435 | NR | HEV8473074.1 | 2072417 | g118015 | i0 | 44 | 0.417827298050139 | 50 | 22 | 40.1 | 2 | 47 | 190 | 202 | 247 | HEV8473074.1 alpha/beta fold hydrolase [Candidatus Methylomirabilota bacterium] | diamond | 150 | 43.9 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Methylomirabilota | Candidatus Methylomirabilota bacterium | ||||||
| 30150511 | 30150511 | PRJNA906294_P_NODE_210932_length_248_cov_0.868571_g206816_i0 | PRJNA906294 | 210932 | 248 | 0.868571 | 2.15405608 | Candidatus Wildermuthbacteria bacterium | 2053642 | Bacteria | Bacteria | 65.9 | 8.2e-12 | NR | MBI2644537.1 | 2053642 | g206816 | i0 | 53.2 | 3.18145161290323 | 62 | 29 | 75 | 0 | 199 | 14 | 4 | 65 | MBI2644537.1 RNA-binding protein [Candidatus Wildermuthbacteria bacterium] | diamond | 789 | 65.9 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Wildermuthiibacteriota | Candidatus Wildermuthbacteria bacterium | ||||||
| 30245732 | 30245732 | PRJNA906294_P_NODE_225132_length_243_cov_0.894118_g221016_i0 | PRJNA906294 | 225132 | 243 | 0.894118 | 2.17270674 | Candidatus Schekmanbacteria bacterium GWA2_38_9 | 1817877 | Bacteria | Bacteria | 43.1 | 0.0271 | NR | OGL42178.1 | 1817877 | g221016 | i0 | 31 | 0.876543209876543 | 71 | 48 | 86.4 | 1 | 240 | 31 | 25 | 95 | OGL42178.1 MAG: threonine synthase [Candidatus Schekmanbacteria bacterium GWA2_38_9] | diamond | 213 | 43.1 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Schekmaniibacteriota | Candidatus Schekmanbacteria bacterium GWA2_38_9 | ||||||
| 30372279 | 30372279 | PRJNA906294_P_NODE_161632_length_296_cov_1.551570_g157516_i0 | PRJNA906294 | 161632 | 296 | 1.55157 | 4.5926472 | Candidatus Yanofskybacteria bacterium RIFCSPHIGHO2_ | 2052154 | Bacteria | Bacteria | 41.2 | 0.0274 | NR | OGN09284.1 | 1802674 | g157516 | i0 | 38.6 | 0.445945945945946 | 44 | 24 | 41.6 | 1 | 130 | 252 | 5 | 48 | OGN09284.1 MAG: hypothetical protein A3C61_02855 [Candidatus Yanofskybacteria bacterium RIFCSPHIGHO2_02_FULL_39_10] | diamond | 132 | 41.2 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Yanofskyibacteriota | Candidatus Yanofskybacteria bacterium RIFCSPHIGHO2_02_FULL_39_10 | ||||||
| 30751094 | 30751094 | PRJNA906294_P_NODE_151974_length_309_cov_1.139831_g147858_i0 | PRJNA906294 | 151974 | 309 | 1.139831 | 3.52207779 | Candidatus Sumerlaeia bacterium | 2715255 | Bacteria | Bacteria | 44.7 | 0.0179 | NR | MDX2177298.1 | 2715255 | g147858 | i0 | 37.3 | 0.650485436893204 | 67 | 40 | 65 | 2 | 309 | 109 | 1247 | 1311 | MDX2177298.1 C25 family cysteine peptidase [Candidatus Sumerlaeia bacterium] | diamond | 201 | 44.7 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Sumerlaeota | Candidatus Sumerlaeia | Candidatus Sumerlaeia bacterium | |||||
| 32498154 | 32498154 | PRJNA906294_P_NODE_155419_length_304_cov_1.350649_g151303_i0 | PRJNA906294 | 155419 | 304 | 1.350649 | 4.10597296 | Bacillati | 1783272 | Bacteria | Bacteria | 45.4 | 0.00908 | NR | MBT5711163.1 | 2026781 | g151303 | i0 | 33 | 5.84210526315789 | 97 | 60 | 93.8 | 3 | 298 | 14 | 494 | 587 | MBT5711163.1 tandem-95 repeat protein [Candidatus Poribacteria bacterium] | diamond | 1776 | 45.8 | 0.991266375545852 | Bacteria | Bacteria candidate phyla | Candidatus Poribacteria | Candidatus Poribacteria bacterium | ||||||
| 32868580 | 32868580 | PRJNA906294_P_NODE_222140_length_244_cov_0.888889_g218024_i0 | PRJNA906294 | 222140 | 244 | 0.888889 | 2.16888916 | Patescibacteria group bacterium | 2052139 | Bacteria | Bacteria | 53.1 | 3.99e-6 | NR | HEX8974144.1 | 2052139 | g218024 | i0 | 35.6 | 0.897540983606557 | 73 | 45 | 89.8 | 1 | 221 | 3 | 128 | 198 | HEX8974144.1 CYTH domain-containing protein [Patescibacteria group bacterium] | diamond | 219 | 53.1 | 1 | Bacteria | Bacteria candidate phyla | Patescibacteria group 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);;