contig_metadata
12 rows where bioproject = "PRJNA1095825", tax_clade = "Bacteria candidate phyla" and tax_phylum = "Candidatus Binatota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 14229775 | 14229775 | PRJNA1095825_P_NODE_280272_length_244_cov_0.900585_g277209_i0 | PRJNA1095825 | 280272 | 244 | 0.900585 | 2.1974274 | Candidatus Binatia bacterium | 2838779 | Bacteria | Bacteria | 147 | 5.77e-40 | NR | HEY7319792.1 | 2838779 | g277209 | i0 | 85 | 0.983606557377049 | 80 | 12 | 98.4 | 0 | 1 | 240 | 225 | 304 | HEY7319792.1 DUF1254 domain-containing protein [Candidatus Binatia bacterium] | diamond | 240 | 147 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Binatota | Candidatus Binatia | Candidatus Binatia bacterium | |||||
| 24426900 | 24426900 | PRJNA1095825_P_NODE_273780_length_245_cov_0.895349_g270717_i0 | PRJNA1095825 | 273780 | 245 | 0.895349 | 2.19360505 | Candidatus Binatia bacterium | 2838779 | Bacteria | Bacteria | 134 | 9.169999999999999e-35 | NR | MEO6028898.1 | 2838779 | g270717 | i0 | 83.8 | 0.979591836734694 | 80 | 13 | 98 | 0 | 240 | 1 | 299 | 378 | MEO6028898.1 ABC-F family ATP-binding cassette domain-containing protein [Candidatus Binatia bacterium] | diamond | 240 | 134 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Binatota | Candidatus Binatia | Candidatus Binatia bacterium | |||||
| 27004241 | 27004241 | PRJNA1095825_P_NODE_247562_length_249_cov_0.875000_g244499_i0 | PRJNA1095825 | 247562 | 249 | 0.875 | 2.17875 | Candidatus Binatia bacterium | 2838779 | Bacteria | Bacteria | 143 | 5.66e-38 | NR | MFN2425450.1 | 2838779 | g244499 | i0 | 85.2 | 0.975903614457831 | 81 | 12 | 97.6 | 0 | 244 | 2 | 175 | 255 | MFN2425450.1 FAD-dependent monooxygenase [Candidatus Binatia bacterium] | diamond | 243 | 143 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Binatota | Candidatus Binatia | Candidatus Binatia bacterium | |||||
| 28425772 | 28425772 | PRJNA1095825_P_NODE_268346_length_246_cov_0.890173_g265283_i0 | PRJNA1095825 | 268346 | 246 | 0.890173 | 2.18982558 | Candidatus Binatia bacterium | 2838779 | Bacteria | Bacteria | 121 | 7.91e-30 | NR | MFN2377681.1 | 2838779 | g265283 | i0 | 77.8 | 0.98780487804878 | 81 | 18 | 98.8 | 0 | 245 | 3 | 252 | 332 | MFN2377681.1 PAS domain S-box protein [Candidatus Binatia bacterium] | diamond | 243 | 121 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Binatota | Candidatus Binatia | Candidatus Binatia bacterium | |||||
| 28583675 | 28583675 | PRJNA1095825_P_NODE_189647_length_284_cov_1.369668_g186584_i0 | PRJNA1095825 | 189647 | 284 | 1.369668 | 3.88985712 | Candidatus Binatia bacterium | 2838779 | Bacteria | Bacteria | 168 | 3.47e-48 | NR | HJW71118.1 | 2838779 | g186584 | i0 | 80.9 | 1.98591549295775 | 94 | 18 | 99.3 | 0 | 2 | 283 | 242 | 335 | HJW71118.1 alpha-L-fucosidase [Candidatus Binatia bacterium] | diamond | 564 | 168 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Binatota | Candidatus Binatia | Candidatus Binatia bacterium | |||||
| 29025866 | 29025866 | PRJNA1095825_P_NODE_231028_length_254_cov_1.701657_g227965_i0 | PRJNA1095825 | 231028 | 254 | 1.701657 | 4.32220878 | Candidatus Binatia bacterium | 2838779 | Bacteria | Bacteria | 49.7 | 8.52e-6 | NR | HSF57008.1 | 2838779 | g227965 | i0 | 73.3 | 0.354330708661417 | 30 | 8 | 35.4 | 0 | 91 | 2 | 2 | 31 | HSF57008.1 hypothetical protein [Candidatus Binatia bacterium] | diamond | 90 | 49.7 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Binatota | Candidatus Binatia | Candidatus Binatia bacterium | |||||
| 30446956 | 30446956 | PRJNA1095825_P_NODE_245773_length_250_cov_0.870056_g242710_i0 | PRJNA1095825 | 245773 | 250 | 0.870056 | 2.17514 | Candidatus Binatia bacterium | 2838779 | Bacteria | Bacteria | 171 | 5.84e-50 | NR | MBY0278083.1 | 2838779 | g242710 | i0 | 94 | 1.992 | 83 | 5 | 99.6 | 0 | 2 | 250 | 196 | 278 | MBY0278083.1 glutathione S-transferase family protein [Candidatus Binatia bacterium] | diamond | 498 | 171 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Binatota | Candidatus Binatia | Candidatus Binatia bacterium | |||||
| 31047373 | 31047373 | PRJNA1095825_P_NODE_191115_length_283_cov_1.247619_g188052_i0 | PRJNA1095825 | 191115 | 283 | 1.247619 | 3.53076177 | Candidatus Binatia bacterium | 2838779 | Bacteria | Bacteria | 155 | 1.8e-43 | NR | HXV81782.1 | 2838779 | g188052 | i0 | 88 | 0.975265017667845 | 92 | 11 | 97.5 | 0 | 4 | 279 | 31 | 122 | HXV81782.1 LPS export ABC transporter permease LptF [Candidatus Binatia bacterium] | diamond | 276 | 155 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Binatota | Candidatus Binatia | Candidatus Binatia bacterium | |||||
| 31521487 | 31521487 | PRJNA1095825_P_NODE_238396_length_251_cov_0.865169_g235333_i0 | PRJNA1095825 | 238396 | 251 | 0.865169 | 2.17157419 | Candidatus Binatia bacterium | 2838779 | Bacteria | Bacteria | 110 | 6.3700000000000005e-27 | NR | HKY09694.1 | 2838779 | g235333 | i0 | 81.5 | 0.776892430278884 | 65 | 12 | 77.7 | 0 | 55 | 249 | 3 | 67 | HKY09694.1 ABC transporter substrate-binding protein [Candidatus Binatia bacterium] | diamond | 195 | 110 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Binatota | Candidatus Binatia | Candidatus Binatia bacterium | |||||
| 32280847 | 32280847 | PRJNA1095825_P_NODE_260339_length_247_cov_0.885057_g257276_i0 | PRJNA1095825 | 260339 | 247 | 0.885057 | 2.18609079 | Candidatus Binatia bacterium | 2838779 | Bacteria | Bacteria | 138 | 1.13e-37 | NR | MET0644523.1 | 2838779 | g257276 | i0 | 88 | 5.46558704453441 | 75 | 9 | 91.1 | 0 | 9 | 233 | 197 | 271 | MET0644523.1 membrane dipeptidase [Candidatus Binatia bacterium] | diamond | 1350 | 138 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Binatota | Candidatus Binatia | Candidatus Binatia bacterium | |||||
| 32470680 | 32470680 | PRJNA1095825_P_NODE_248039_length_249_cov_0.875000_g244976_i0 | PRJNA1095825 | 248039 | 249 | 0.875 | 2.17875 | Candidatus Binatia bacterium | 2838779 | Bacteria | Bacteria | 97.8 | 1.2e-23 | NR | HEY6199997.1 | 2838779 | g244976 | i0 | 55.8 | 4.14457831325301 | 86 | 24 | 97.6 | 3 | 5 | 247 | 55 | 131 | HEY6199997.1 urea carboxylase-associated family protein [Candidatus Binatia bacterium] | diamond | 1032 | 97.8 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Binatota | Candidatus Binatia | Candidatus Binatia bacterium | |||||
| 32880219 | 32880219 | PRJNA1095825_P_NODE_279980_length_244_cov_0.900585_g276917_i0 | PRJNA1095825 | 279980 | 244 | 0.900585 | 2.1974274 | Candidatus Binatia bacterium | 2838779 | Bacteria | Bacteria | 152 | 5.43e-44 | NR | HEX5019663.1 | 2838779 | g276917 | i0 | 90.1 | 0.995901639344262 | 81 | 8 | 99.6 | 0 | 2 | 244 | 87 | 167 | HEX5019663.1 cytidylate kinase family protein [Candidatus Binatia bacterium] | diamond | 243 | 152 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Binatota | Candidatus Binatia | Candidatus Binatia 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);;