contig_metadata
27 rows where bioproject = "PRJNA811237", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5051604 | 5051604 | PRJNA811237_S_NODE_10724_length_236_cov_2.668449_g10484_i0 | PRJNA811237 | 10724 | 236 | 2.668449 | 6.29753964 | Bacteria | 2 | Bacteria | Bacteria | 112 | 4.15e-27 | NR | KKP96059.1 | 1619081 | g10484 | i0 | 60.3 | 5.86016949152542 | 78 | 30 | 99.2 | 1 | 236 | 3 | 368 | 444 | KKP96059.1 MAG: Deoxyribodipyrimidine photo-lyase [candidate division TM6 bacterium GW2011_GWF2_36_131] | diamond | 1383 | 112 | 1 | Bacteria | Bacteria candidate phyla | candidate division TM6 bacterium GW2011_GWF2_36_131 | |||||||
| 26705804 | 26705804 | PRJNA811237_S_NODE_28161_length_167_cov_0.864407_g27921_i0 | PRJNA811237 | 28161 | 167 | 0.864407 | 1.44355969 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 55.8 | 3.16e-7 | NR | MFA6270074.1 | 2053589 | g27921 | i0 | 59.6 | 4.04191616766467 | 47 | 15 | 82.6 | 2 | 162 | 25 | 585 | 628 | MFA6270074.1 carbohydrate-binding protein [Candidatus Paceibacterota bacterium] | diamond | 675 | 55.8 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 26927672 | 26927672 | PRJNA811237_S_NODE_22142_length_182_cov_1.285714_g21902_i0 | PRJNA811237 | 22142 | 182 | 1.285714 | 2.33999948 | Patescibacteria group bacterium | 2052139 | Bacteria | Bacteria | 42 | 0.0315 | NR | TAK05327.1 | 2052139 | g21902 | i0 | 47.8 | 0.758241758241758 | 46 | 24 | 75.8 | 0 | 44 | 181 | 492 | 537 | TAK05327.1 MAG: hypothetical protein EPO33_05175 [Patescibacteria group bacterium] | diamond | 138 | 42 | 1 | Bacteria | Bacteria candidate phyla | Patescibacteria group bacterium | |||||||
| 26927678 | 26927678 | PRJNA811237_S_NODE_28562_length_166_cov_1.307692_g28322_i0 | PRJNA811237 | 28562 | 166 | 1.307692 | 2.17076872 | Candidatus Peribacteraceae bacterium | 2735830 | Bacteria | Bacteria | 48.9 | 8.74e-5 | NR | MCK5016179.1 | 2735830 | g28322 | i0 | 35.7 | 1.01204819277108 | 56 | 34 | 97.6 | 1 | 162 | 1 | 265 | 320 | MCK5016179.1 hypothetical protein [Candidatus Peribacteraceae bacterium] | diamond | 168 | 48.9 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Peregrinibacteriota | Candidatus Peribacteria | Candidatus Peribacterales | Candidatus Peribacteraceae bacterium | ||||
| 27022601 | 27022601 | PRJNA811237_S_NODE_15142_length_209_cov_1.275000_g14902_i0 | PRJNA811237 | 15142 | 209 | 1.275 | 2.66475 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 42 | 0.0111 | NR | MDD2913601.1 | 2053589 | g14902 | i0 | 57.1 | 1.03349282296651 | 28 | 12 | 40.2 | 0 | 200 | 117 | 21 | 48 | MDD2913601.1 thioredoxin domain-containing protein [Candidatus Paceibacterota bacterium] | diamond | 216 | 42 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 27307270 | 27307270 | PRJNA811237_S_NODE_25503_length_172_cov_1.243902_g25263_i0 | PRJNA811237 | 25503 | 172 | 1.243902 | 2.13951144 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 52.8 | 4.2e-6 | NR | MEZ0208671.1 | 2053589 | g25263 | i0 | 45.5 | 0.959302325581395 | 55 | 30 | 95.9 | 0 | 8 | 172 | 220 | 274 | MEZ0208671.1 reverse transcriptase domain-containing protein [Candidatus Paceibacterota bacterium] | diamond | 165 | 52.8 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 27559616 | 27559616 | PRJNA811237_S_NODE_9984_length_243_cov_1.453608_g9744_i0 | PRJNA811237 | 9984 | 243 | 1.453608 | 3.53226744 | Patescibacteria group bacterium | 2052139 | Bacteria | Bacteria | 131 | 1.32e-34 | NR | MCL4419852.1 | 2052139 | g9744 | i0 | 82.5 | 0.987654320987654 | 80 | 14 | 98.8 | 0 | 2 | 241 | 316 | 395 | MCL4419852.1 CoA-acylating methylmalonate-semialdehyde dehydrogenase [Patescibacteria group bacterium] | diamond | 240 | 131 | 1 | Bacteria | Bacteria candidate phyla | Patescibacteria group bacterium | |||||||
| 27591560 | 27591560 | PRJNA811237_S_NODE_34984_length_161_cov_1.223214_g34744_i0 | PRJNA811237 | 34984 | 161 | 1.223214 | 1.96937454 | Candidatus Uhrbacteria bacterium RIFCSPHIGHO2_12_FULL_54_23 | 1802397 | Bacteria | Bacteria | 62 | 1.92e-9 | NR | OGL78705.1 | 1802397 | g34744 | i0 | 50.9 | 0.987577639751553 | 53 | 26 | 98.8 | 0 | 3 | 161 | 61 | 113 | OGL78705.1 MAG: deoxyribodipyrimidine photolyase [Candidatus Uhrbacteria bacterium RIFCSPHIGHO2_12_FULL_54_23] | diamond | 159 | 62 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Uhriibacteriota | Candidatus Uhrbacteria bacterium RIFCSPHIGHO2_12_FULL_54_23 | ||||||
| 27875434 | 27875434 | PRJNA811237_S_NODE_35125_length_161_cov_0.910714_g34885_i0 | PRJNA811237 | 35125 | 161 | 0.910714 | 1.46624954 | Candidatus Spechtbacteria bacterium | 2750079 | Bacteria | Bacteria | 65.1 | 8.72e-11 | NR | MBI2463034.1 | 2750079 | g34885 | i0 | 64.6 | 0.894409937888199 | 48 | 17 | 89.4 | 0 | 18 | 161 | 122 | 169 | MBI2463034.1 NUDIX domain-containing protein [Candidatus Spechtbacteria bacterium] | diamond | 144 | 65.1 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Spechtiibacteriota | Candidatus Spechtbacteria bacterium | ||||||
| 28159881 | 28159881 | PRJNA811237_S_NODE_23945_length_176_cov_2.000000_g23705_i0 | PRJNA811237 | 23945 | 176 | 2 | 3.52 | Candidatus Hydrothermia bacterium | 3014280 | Bacteria | Bacteria | 70.1 | 3.15e-12 | NR | MDT7879665.1 | 3014280 | g23705 | i0 | 56.9 | 4.94318181818182 | 58 | 23 | 98.9 | 1 | 1 | 174 | 289 | 344 | MDT7879665.1 ornithine--oxo-acid transaminase [Candidatus Hydrothermia bacterium] | diamond | 870 | 70.1 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Hydrothermota | Candidatus Hydrothermia | Candidatus Hydrothermia bacterium | |||||
| 28484306 | 28484306 | PRJNA811237_S_NODE_1826_length_533_cov_1.561983_g1587_i0 | PRJNA811237 | 1826 | 533 | 1.561983 | 8.32536939 | Bacillati | 1783272 | Bacteria | Bacteria | 55.5 | 1.05e-5 | NR | MYA58282.1 | 2026781 | g1587 | i0 | 36.8 | 5.24015009380863 | 95 | 57 | 52.9 | 2 | 448 | 167 | 127 | 219 | MYA58282.1 aquaporin [Candidatus Poribacteria bacterium] | diamond | 2793 | 55.5 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Poribacteria | Candidatus Poribacteria bacterium | ||||||
| 28664936 | 28664936 | PRJNA811237_S_NODE_19747_length_190_cov_1.446809_g19507_i0 | PRJNA811237 | 19747 | 190 | 1.446809 | 2.7489371 | Candidatus Babelota bacterium | 2030827 | Bacteria | Bacteria | 41.6 | 0.047 | NR | MFC1841582.1 | 2030827 | g19507 | i0 | 63.3 | 0.473684210526316 | 30 | 11 | 47.4 | 0 | 190 | 101 | 278 | 307 | MFC1841582.1 NAD-dependent epimerase/dehydratase family protein [Candidatus Dependentiae bacterium] | diamond | 90 | 41.6 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Babelota bacterium | |||||||
| 28664938 | 28664938 | PRJNA811237_S_NODE_20767_length_187_cov_0.956522_g20527_i0 | PRJNA811237 | 20767 | 187 | 0.956522 | 1.78869614 | Patescibacteria group bacterium | 2052139 | Bacteria | Bacteria | 44.7 | 0.00376 | NR | MBU0974672.1 | 2052139 | g20527 | i0 | 42.3 | 0.834224598930481 | 52 | 29 | 81.8 | 1 | 175 | 23 | 217 | 268 | MBU0974672.1 hypothetical protein [Patescibacteria group bacterium] | diamond | 156 | 44.7 | 1 | Bacteria | Bacteria candidate phyla | Patescibacteria group bacterium | |||||||
| 28949289 | 28949289 | PRJNA811237_S_NODE_8548_length_258_cov_2.244019_g8308_i0 | PRJNA811237 | 8548 | 258 | 2.244019 | 5.78956902 | Candidatus Methylomirabilota bacterium | 2072417 | Bacteria | Bacteria | 44.7 | 0.00969 | NR | MBI5166485.1 | 2072417 | g8308 | i0 | 37.8 | 0.953488372093023 | 82 | 44 | 93 | 2 | 4 | 243 | 717 | 793 | MBI5166485.1 penicillin acylase family protein [Candidatus Methylomirabilota bacterium] | diamond | 246 | 44.7 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Methylomirabilota | Candidatus Methylomirabilota bacterium | ||||||
| 29738123 | 29738123 | PRJNA811237_S_NODE_34310_length_162_cov_0.902655_g34070_i0 | PRJNA811237 | 34310 | 162 | 0.902655 | 1.4623011 | Candidatus Daviesbacteria bacterium RIFCSPHIGHO2_ | 2053542 | Bacteria | Bacteria | 45.4 | 0.00135 | NR | OGE30245.1 | 1797768 | g34070 | i0 | 41.5 | 0.981481481481482 | 53 | 30 | 96.3 | 1 | 2 | 157 | 246 | 298 | OGE30245.1 MAG: hypothetical protein A3C59_04665 [Candidatus Daviesbacteria bacterium RIFCSPHIGHO2_02_FULL_36_13] | diamond | 159 | 45.4 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Daviesiibacteriota | Candidatus Daviesbacteria bacterium RIFCSPHIGHO2_02_FULL_36_13 | ||||||
| 30054077 | 30054077 | PRJNA811237_S_NODE_27271_length_167_cov_1.516949_g27031_i0 | PRJNA811237 | 27271 | 167 | 1.516949 | 2.53330483 | Candidatus Poribacteria bacterium | 2026781 | Bacteria | Bacteria | 41.2 | 0.0443 | NR | MBI1925016.1 | 2026781 | g27031 | i0 | 37.3 | 0.916167664670659 | 51 | 27 | 82.6 | 1 | 29 | 166 | 160 | 210 | MBI1925016.1 hypothetical protein [Candidatus Poribacteria bacterium] | diamond | 153 | 41.2 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Poribacteria | Candidatus Poribacteria bacterium | ||||||
| 30402269 | 30402269 | PRJNA811237_S_NODE_9153_length_252_cov_1.256158_g8913_i0 | PRJNA811237 | 9153 | 252 | 1.256158 | 3.16551816 | Candidatus Methylomirabilota bacterium | 2072417 | Bacteria | Bacteria | 55.8 | 1.01e-6 | NR | HWN97259.1 | 2072417 | g8913 | i0 | 43.2 | 0.880952380952381 | 74 | 41 | 86.9 | 1 | 17 | 235 | 976 | 1049 | HWN97259.1 serine/threonine-protein kinase [Candidatus Methylomirabilota bacterium] | diamond | 222 | 55.8 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Methylomirabilota | Candidatus Methylomirabilota bacterium | ||||||
| 30433760 | 30433760 | PRJNA811237_S_NODE_30873_length_164_cov_2.156522_g30633_i0 | PRJNA811237 | 30873 | 164 | 2.156522 | 3.53669608 | Candidatus Parcubacteria bacterium | 2762014 | Bacteria | Bacteria | 46.2 | 7.63e-4 | NR | MEN9338437.1 | 2762014 | g30633 | i0 | 46.8 | 0.859756097560976 | 47 | 21 | 78.7 | 1 | 26 | 154 | 376 | 422 | MEN9338437.1 hypothetical protein [Candidatus Parcubacteria bacterium] | diamond | 141 | 46.2 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Parcubacteria | Candidatus Parcubacteria bacterium | ||||||
| 30528102 | 30528102 | PRJNA811237_S_NODE_15873_length_206_cov_0.974522_g15633_i0 | PRJNA811237 | 15873 | 206 | 0.974522 | 2.00751532 | Patescibacteria group bacterium | 2052139 | Bacteria | Bacteria | 42 | 0.043 | NR | MBU1148725.1 | 2052139 | g15633 | i0 | 36 | 0.728155339805825 | 50 | 27 | 72.8 | 1 | 202 | 53 | 346 | 390 | MBU1148725.1 DUF2079 domain-containing protein [Patescibacteria group bacterium] | diamond | 150 | 42 | 1 | Bacteria | Bacteria candidate phyla | Patescibacteria group bacterium | |||||||
| 31349934 | 31349934 | PRJNA811237_S_NODE_32256_length_163_cov_1.342105_g32016_i0 | PRJNA811237 | 32256 | 163 | 1.342105 | 2.18763115 | candidate division WWE3 bacterium | 2053526 | Bacteria | Bacteria | 41.6 | 0.0143 | NR | NTV30820.1 | 2053526 | g32016 | i0 | 47.6 | 0.773006134969325 | 42 | 22 | 77.3 | 0 | 32 | 157 | 15 | 56 | NTV30820.1 hypothetical protein [candidate division WWE3 bacterium] | diamond | 126 | 41.6 | 1 | Bacteria | Bacteria candidate phyla | candidate division WWE3 | candidate division WWE3 bacterium | ||||||
| 31959585 | 31959585 | PRJNA811237_S_NODE_34117_length_162_cov_0.902655_g33877_i0 | PRJNA811237 | 34117 | 162 | 0.902655 | 1.4623011 | root | 1 | Root_unresolved | Root_unresolved | 48.5 | 1e-4 | NR | OHA59211.1 | 1802436 | g33877 | i0 | 46.9 | 8.38888888888889 | 49 | 26 | 90.7 | 0 | 159 | 13 | 74 | 122 | OHA59211.1 MAG: bifunctional methylenetetrahydrofolate dehydrogenase/methenyltetrahydrofolate cyclohydrolase, partial [Candidatus Vogelbacteria bacterium RIFOXYB1_FULL_42_16] | diamond | 1359 | 48.9 | 0.991820040899796 | Bacteria | Bacteria candidate phyla | Candidatus Vogeliibacteriota | Candidatus Vogelbacteria bacterium RIFOXYB1_FULL_42_16 | ||||||
| 31982317 | 31982317 | PRJNA811237_S_NODE_19298_length_192_cov_1.069930_g19058_i0 | PRJNA811237 | 19298 | 192 | 1.06993 | 2.0542656 | Candidatus Uhrbacteria bacterium RIFCSPHIGHO2_12_FULL_54_23 | 1802397 | Bacteria | Bacteria | 71.2 | 1.67e-12 | NR | OGL78705.1 | 1802397 | g19058 | i0 | 50.8 | 0.984375 | 63 | 31 | 98.4 | 0 | 4 | 192 | 59 | 121 | OGL78705.1 MAG: deoxyribodipyrimidine photolyase [Candidatus Uhrbacteria bacterium RIFCSPHIGHO2_12_FULL_54_23] | diamond | 189 | 71.2 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Uhriibacteriota | Candidatus Uhrbacteria bacterium RIFCSPHIGHO2_12_FULL_54_23 | ||||||
| 32014096 | 32014096 | PRJNA811237_S_NODE_27578_length_167_cov_0.864407_g27338_i0 | PRJNA811237 | 27578 | 167 | 0.864407 | 1.44355969 | Candidatus Altimarinota bacterium | 2044595 | Bacteria | Bacteria | 45.8 | 0.00108 | NR | MFA4815524.1 | 2044595 | g27338 | i0 | 48.1 | 2.94610778443114 | 54 | 23 | 97 | 2 | 6 | 167 | 245 | 293 | MFA4815524.1 adenylate/guanylate cyclase domain-containing protein [Candidatus Altimarinota bacterium] | diamond | 492 | 45.8 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Altimarinota | Candidatus Altimarinota bacterium | ||||||
| 32109012 | 32109012 | PRJNA811237_S_NODE_17638_length_198_cov_1.966443_g17398_i0 | PRJNA811237 | 17638 | 198 | 1.966443 | 3.89355714 | Candidatus Eiseniibacteriota bacterium | 2212470 | Bacteria | Bacteria | 83.2 | 1.1e-16 | NR | HEU4334507.1 | 2212470 | g17398 | i0 | 70.2 | 0.863636363636364 | 57 | 17 | 86.4 | 0 | 171 | 1 | 1 | 57 | HEU4334507.1 transketolase [Candidatus Eiseniibacteriota bacterium] | diamond | 171 | 83.2 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Eiseniibacteriota | Candidatus Eiseniibacteriota bacterium | ||||||
| 32552286 | 32552286 | PRJNA811237_S_NODE_34139_length_162_cov_0.902655_g33899_i0 | PRJNA811237 | 34139 | 162 | 0.902655 | 1.4623011 | Patescibacteria group bacterium | 2052139 | Bacteria | Bacteria | 96.3 | 1.6400000000000002e-21 | NR | MCL4419431.1 | 2052139 | g33899 | i0 | 88.9 | 1 | 54 | 5 | 98.1 | 1 | 2 | 160 | 520 | 573 | MCL4419431.1 hypothetical protein [Patescibacteria group bacterium] | diamond | 162 | 96.3 | 1 | Bacteria | Bacteria candidate phyla | Patescibacteria group bacterium | |||||||
| 32741093 | 32741093 | PRJNA811237_S_NODE_10120_length_242_cov_1.056995_g9880_i0 | PRJNA811237 | 10120 | 242 | 1.056995 | 2.5579279 | Patescibacteria group bacterium | 2052139 | Bacteria | Bacteria | 43.1 | 0.0261 | NR | MES2930748.1 | 2052139 | g9880 | i0 | 58.1 | 0.384297520661157 | 31 | 13 | 38.4 | 0 | 242 | 150 | 382 | 412 | MES2930748.1 NADP-dependent isocitrate dehydrogenase [Patescibacteria group bacterium] | diamond | 93 | 43.1 | 1 | Bacteria | Bacteria candidate phyla | Patescibacteria group bacterium | |||||||
| 32875655 | 32875655 | PRJNA811237_S_NODE_33100_length_163_cov_0.894737_g32860_i0 | PRJNA811237 | 33100 | 163 | 0.894737 | 1.45842131 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 79.3 | 9.89e-16 | NR | MBN1224910.1 | 2052149 | g32860 | i0 | 67.3 | 1.89570552147239 | 52 | 17 | 95.7 | 0 | 7 | 162 | 289 | 340 | MBN1224910.1 phosphoserine transaminase [Candidatus Aminicenantes bacterium] | diamond | 309 | 79.3 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Aminicenantota | Candidatus Aminicenantes 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);;