contig_metadata
13 rows where bioproject = "PRJNA1123436" and tax_phylum = "Candidatus Bipolaricaulota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 27323124 | 27323124 | PRJNA1123436_P_NODE_120103_length_243_cov_0.905882_g118889_i0 | PRJNA1123436 | 120103 | 243 | 0.905882 | 2.20129326 | Candidatus Acetothermia bacterium | 2053493 | Bacteria | Bacteria | 46.6 | 0.00157 | NR | HHR85382.1 | 2053493 | g118889 | i0 | 43 | 0.975308641975309 | 79 | 40 | 97.5 | 3 | 2 | 238 | 311 | 384 | HHR85382.1 hypothetical protein [Candidatus Acetothermia bacterium] | diamond | 237 | 46.6 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Bipolaricaulota | Candidatus Acetothermia bacterium | ||||||
| 28385809 | 28385809 | PRJNA1123436_P_NODE_108646_length_247_cov_0.885057_g107432_i0 | PRJNA1123436 | 108646 | 247 | 0.885057 | 2.18609079 | Bacteria | 2 | Bacteria | Bacteria | 64.7 | 6.8e-10 | NR | BAL56214.1 | 236499 | g107432 | i0 | 58.2 | 2.06477732793522 | 55 | 23 | 66.8 | 0 | 175 | 11 | 4 | 58 | BAL56214.1 hypothetical conserved protein [uncultured Acetothermia bacterium] | diamond | 510 | 65.1 | 0.993855606758833 | Bacteria | Bacteria candidate phyla | Candidatus Bipolaricaulota | uncultured Acetothermia bacterium | ||||||
| 28586330 | 28586330 | PRJNA1123436_P_NODE_59587_length_323_cov_1.232000_g58373_i0 | PRJNA1123436 | 59587 | 323 | 1.232 | 3.97936 | Candidatus Bipolaricaulota bacterium | 2306012 | Bacteria | Bacteria | 185 | 4.3199999999999985e-56 | NR | MCX6096523.1 | 2306012 | g58373 | i0 | 82.1 | 0.984520123839009 | 106 | 19 | 98.5 | 0 | 2 | 319 | 189 | 294 | MCX6096523.1 cyclase family protein [Candidatus Bipolaricaulota bacterium] | diamond | 318 | 185 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Bipolaricaulota | Candidatus Bipolaricaulota bacterium | ||||||
| 28617864 | 28617864 | PRJNA1123436_P_NODE_91447_length_257_cov_1.179348_g90233_i0 | PRJNA1123436 | 91447 | 257 | 1.179348 | 3.03092436 | Candidatus Bipolaricaulota bacterium | 2306012 | Bacteria | Bacteria | 152 | 5.18e-43 | NR | MCX6099525.1 | 2306012 | g90233 | i0 | 94.1 | 0.992217898832685 | 85 | 5 | 99.2 | 0 | 3 | 257 | 201 | 285 | MCX6099525.1 ABC transporter substrate-binding protein [Candidatus Bipolaricaulota bacterium] | diamond | 255 | 152 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Bipolaricaulota | Candidatus Bipolaricaulota bacterium | ||||||
| 28712495 | 28712495 | PRJNA1123436_P_NODE_116067_length_244_cov_1.614035_g114853_i0 | PRJNA1123436 | 116067 | 244 | 1.614035 | 3.9382454 | Candidatus Acetothermia bacterium | 2053493 | Bacteria | Bacteria | 78.6 | 1.27e-16 | NR | HDJ29907.1 | 2053493 | g114853 | i0 | 53.3 | 1.83196721311475 | 75 | 33 | 89.8 | 1 | 242 | 24 | 43 | 117 | HDJ29907.1 hypothetical protein [Candidatus Acetothermia bacterium] | diamond | 447 | 78.6 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Bipolaricaulota | Candidatus Acetothermia bacterium | ||||||
| 28775502 | 28775502 | PRJNA1123436_P_NODE_98587_length_250_cov_0.870056_g97373_i0 | PRJNA1123436 | 98587 | 250 | 0.870056 | 2.17514 | Candidatus Acetothermia bacterium | 2053493 | Bacteria | Bacteria | 104 | 1.58e-24 | NR | MBI1731064.1 | 2053493 | g97373 | i0 | 61.7 | 0.972 | 81 | 31 | 97.2 | 0 | 8 | 250 | 292 | 372 | MBI1731064.1 hypothetical protein [Candidatus Acetothermia bacterium] | diamond | 243 | 104 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Bipolaricaulota | Candidatus Acetothermia bacterium | ||||||
| 29754210 | 29754210 | PRJNA1123436_P_NODE_122651_length_242_cov_0.911243_g121437_i0 | PRJNA1123436 | 122651 | 242 | 0.911243 | 2.20520806 | Candidatus Bipolaricaulota bacterium | 2306012 | Bacteria | Bacteria | 97.4 | 8.330000000000001e-22 | NR | MEA3239885.1 | 2306012 | g121437 | i0 | 63.4 | 1.83471074380165 | 82 | 28 | 99.2 | 1 | 240 | 1 | 1 | 82 | MEA3239885.1 ABC transporter permease [Candidatus Bipolaricaulota bacterium] | diamond | 444 | 97.4 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Bipolaricaulota | Candidatus Bipolaricaulota bacterium | ||||||
| 30164781 | 30164781 | PRJNA1123436_P_NODE_113652_length_245_cov_0.895349_g112438_i0 | PRJNA1123436 | 113652 | 245 | 0.895349 | 2.19360505 | Candidatus Acetothermia bacterium | 2053493 | Bacteria | Bacteria | 88.2 | 2.66e-18 | NR | HCP32220.1 | 2053493 | g112438 | i0 | 53.8 | 0.979591836734694 | 80 | 37 | 98 | 0 | 3 | 242 | 199 | 278 | HCP32220.1 hypothetical protein [Candidatus Acetothermia bacterium] | diamond | 240 | 88.2 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Bipolaricaulota | Candidatus Acetothermia bacterium | ||||||
| 30638804 | 30638804 | PRJNA1123436_P_NODE_117833_length_244_cov_0.900585_g116619_i0 | PRJNA1123436 | 117833 | 244 | 0.900585 | 2.1974274 | Candidatus Bipolaricaulota bacterium | 2306012 | Bacteria | Bacteria | 143 | 5.95e-38 | NR | MCX6095595.1 | 2306012 | g116619 | i0 | 90 | 0.983606557377049 | 80 | 8 | 98.4 | 0 | 242 | 3 | 279 | 358 | MCX6095595.1 DNA primase [Candidatus Bipolaricaulota bacterium] | diamond | 240 | 143 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Bipolaricaulota | Candidatus Bipolaricaulota bacterium | ||||||
| 30670441 | 30670441 | PRJNA1123436_P_NODE_102213_length_249_cov_0.875000_g100999_i0 | PRJNA1123436 | 102213 | 249 | 0.875 | 2.17875 | Candidatus Bipolaricaulota bacterium | 2306012 | Bacteria | Bacteria | 49.7 | 1.39e-4 | NR | MCX6095619.1 | 2306012 | g100999 | i0 | 53.2 | 0.566265060240964 | 47 | 22 | 56.6 | 0 | 108 | 248 | 1 | 47 | MCX6095619.1 aminotransferase class III-fold pyridoxal phosphate-dependent enzyme [Candidatus Bipolaricaulota bacterium] | diamond | 141 | 49.7 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Bipolaricaulota | Candidatus Bipolaricaulota bacterium | ||||||
| 30733670 | 30733670 | PRJNA1123436_P_NODE_112034_length_246_cov_0.890173_g110820_i0 | PRJNA1123436 | 112034 | 246 | 0.890173 | 2.18982558 | Candidatus Bipolaricaulota bacterium | 2306012 | Bacteria | Bacteria | 116 | 2.33e-28 | NR | MCK4393673.1 | 2306012 | g110820 | i0 | 70 | 0.975609756097561 | 80 | 24 | 97.6 | 0 | 240 | 1 | 253 | 332 | MCK4393673.1 trimethylamine methyltransferase family protein [Candidatus Bipolaricaulota bacterium] | diamond | 240 | 116 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Bipolaricaulota | Candidatus Bipolaricaulota bacterium | ||||||
| 31081377 | 31081377 | PRJNA1123436_P_NODE_119655_length_243_cov_0.905882_g118441_i0 | PRJNA1123436 | 119655 | 243 | 0.905882 | 2.20129326 | Candidatus Bipolaricaulota bacterium | 2306012 | Bacteria | Bacteria | 145 | 5.91e-39 | NR | MCX6095346.1 | 2306012 | g118441 | i0 | 87.3 | 3.92592592592593 | 79 | 10 | 97.5 | 0 | 2 | 238 | 88 | 166 | MCX6095346.1 ABC transporter substrate-binding protein [Candidatus Bipolaricaulota bacterium] | diamond | 954 | 145 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Bipolaricaulota | Candidatus Bipolaricaulota bacterium | ||||||
| 31239143 | 31239143 | PRJNA1123436_P_NODE_121995_length_243_cov_0.888235_g120781_i0 | PRJNA1123436 | 121995 | 243 | 0.888235 | 2.15841105 | Candidatus Bipolaricaulota bacterium | 2306012 | Bacteria | Bacteria | 102 | 1.12e-24 | NR | MEE9541554.1 | 2306012 | g120781 | i0 | 63 | 2 | 81 | 30 | 100 | 0 | 243 | 1 | 168 | 248 | MEE9541554.1 TatD family hydrolase [Candidatus Bipolaricaulota bacterium] | diamond | 486 | 102 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Bipolaricaulota | Candidatus Bipolaricaulota 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);;