contig_metadata
11 rows where bioproject = "PRJNA911178", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26739153 | 26739153 | PRJNA911178_P_NODE_57861_length_458_cov_4.192208_g55418_i0 | PRJNA911178 | 57861 | 458 | 4.192208 | 19.20031264 | Candidatus Binatia bacterium | 2838779 | Bacteria | Bacteria | 68.6 | 3.28e-10 | NR | MFN2374985.1 | 2838779 | g55418 | i0 | 31 | 1.37554585152838 | 158 | 48 | 99.6 | 4 | 2 | 457 | 331 | 433 | MFN2374985.1 ice-binding family protein [Candidatus Binatia bacterium] | diamond | 630 | 68.6 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Binatota | Candidatus Binatia | Candidatus Binatia bacterium | |||||
| 26771274 | 26771274 | PRJNA911178_P_NODE_229541_length_256_cov_1.612022_g227067_i0 | PRJNA911178 | 229541 | 256 | 1.612022 | 4.12677632 | Candidatus Binatia bacterium | 2838779 | Bacteria | Bacteria | 108 | 4.18e-25 | NR | HKA54473.1 | 2838779 | g227067 | i0 | 67.1 | 1.921875 | 82 | 27 | 96.1 | 0 | 11 | 256 | 133 | 214 | HKA54473.1 hypothetical protein [Candidatus Binatia bacterium] | diamond | 492 | 108 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Binatota | Candidatus Binatia | Candidatus Binatia bacterium | |||||
| 27277490 | 27277490 | PRJNA911178_P_NODE_35103_length_577_cov_1.559524_g32728_i0 | PRJNA911178 | 35103 | 577 | 1.559524 | 8.99845348 | Candidatus Binatia bacterium | 2838779 | Bacteria | Bacteria | 94.4 | 1.39e-18 | NR | HEY2773809.1 | 2838779 | g32728 | i0 | 35.7 | 1.07625649913345 | 207 | 75 | 92.5 | 6 | 4 | 537 | 256 | 433 | HEY2773809.1 hypothetical protein [Candidatus Binatia bacterium] | diamond | 621 | 94.4 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Binatota | Candidatus Binatia | Candidatus Binatia bacterium | |||||
| 27435560 | 27435560 | PRJNA911178_P_NODE_116643_length_339_cov_1.127820_g114171_i0 | PRJNA911178 | 116643 | 339 | 1.12782 | 3.8233098 | Candidatus Binatia bacterium | 2838779 | Bacteria | Bacteria | 112 | 4.38e-28 | NR | MBY0279688.1 | 2838779 | g114171 | i0 | 51.8 | 0.991150442477876 | 112 | 52 | 98.2 | 2 | 7 | 339 | 78 | 188 | MBY0279688.1 phytanoyl-CoA dioxygenase family protein [Candidatus Binatia bacterium] | diamond | 336 | 112 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Binatota | Candidatus Binatia | Candidatus Binatia bacterium | |||||
| 28635368 | 28635368 | PRJNA911178_P_NODE_123587_length_331_cov_1.116279_g121115_i0 | PRJNA911178 | 123587 | 331 | 1.116279 | 3.69488349 | Candidatus Binataceae bacterium | 2785449 | Bacteria | Bacteria | 53.9 | 1.06e-5 | NR | HLW69475.1 | 2785449 | g121115 | i0 | 59.2 | 0.851963746223565 | 49 | 12 | 44.4 | 1 | 184 | 330 | 2 | 42 | HLW69475.1 glucose-1-phosphate thymidylyltransferase RfbA [Candidatus Binataceae bacterium] | diamond | 282 | 53.9 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Binatota | Candidatus Binatia | Candidatus Binatales | Candidatus Binataceae | Candidatus Binataceae bacterium | |||
| 28792842 | 28792842 | PRJNA911178_P_NODE_256007_length_248_cov_0.880000_g253533_i0 | PRJNA911178 | 256007 | 248 | 0.88 | 2.1824 | Candidatus Binatia bacterium | 2838779 | Bacteria | Bacteria | 137 | 1.58e-36 | NR | HMJ66496.1 | 2838779 | g253533 | i0 | 82.3 | 0.955645161290323 | 79 | 14 | 95.6 | 0 | 10 | 246 | 75 | 153 | HMJ66496.1 DUF4175 family protein [Candidatus Binatia bacterium] | diamond | 237 | 137 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Binatota | Candidatus Binatia | Candidatus Binatia bacterium | |||||
| 30213933 | 30213933 | PRJNA911178_P_NODE_294532_length_241_cov_0.916667_g292058_i0 | PRJNA911178 | 294532 | 241 | 0.916667 | 2.20916747 | Candidatus Binatia bacterium | 2838779 | Bacteria | Bacteria | 86.3 | 1.74e-17 | NR | HLK12504.1 | 2838779 | g292058 | i0 | 60 | 1.89211618257261 | 75 | 30 | 93.4 | 0 | 232 | 8 | 477 | 551 | HLK12504.1 asparagine synthase (glutamine-hydrolyzing) [Candidatus Binatia bacterium] | diamond | 456 | 86.3 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Binatota | Candidatus Binatia | Candidatus Binatia bacterium | |||||
| 30404070 | 30404070 | PRJNA911178_P_NODE_185193_length_280_cov_1.371981_g182720_i0 | PRJNA911178 | 185193 | 280 | 1.371981 | 3.8415468 | Candidatus Binatia bacterium | 2838779 | Bacteria | Bacteria | 44.7 | 0.0104 | NR | MDP6559722.1 | 2838779 | g182720 | i0 | 34.8 | 0.707142857142857 | 66 | 37 | 68.6 | 2 | 206 | 15 | 5 | 66 | MDP6559722.1 ATP-binding cassette domain-containing protein [Candidatus Binatia bacterium] | diamond | 198 | 44.7 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Binatota | Candidatus Binatia | Candidatus Binatia bacterium | |||||
| 30404103 | 30404103 | PRJNA911178_P_NODE_296073_length_239_cov_6.415663_g293599_i0 | PRJNA911178 | 296073 | 239 | 6.415663 | 15.33343457 | Candidatus Binatia bacterium | 2838779 | Bacteria | Bacteria | 46.2 | 3.48e-4 | NR | HTD85300.1 | 2838779 | g293599 | i0 | 85.2 | 0.338912133891213 | 27 | 4 | 33.9 | 0 | 52 | 132 | 64 | 90 | HTD85300.1 hypothetical protein [Candidatus Binatia bacterium] | diamond | 81 | 46.2 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Binatota | Candidatus Binatia | Candidatus Binatia bacterium | |||||
| 31952592 | 31952592 | PRJNA911178_P_NODE_282377_length_243_cov_0.905882_g279903_i0 | PRJNA911178 | 282377 | 243 | 0.905882 | 2.20129326 | Candidatus Binatus sp. | 2811406 | Bacteria | Bacteria | 119 | 5.76e-29 | NR | HZV89347.1 | 2811406 | g279903 | i0 | 76.9 | 0.962962962962963 | 78 | 18 | 96.3 | 0 | 236 | 3 | 473 | 550 | HZV89347.1 TonB-dependent receptor [Candidatus Binatus sp.] | diamond | 234 | 119 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Binatota | Candidatus Binatia | Candidatus Binatales | Candidatus Binataceae | Candidatus Binatus | Candidatus Binatus sp. | ||
| 32616904 | 32616904 | PRJNA911178_P_NODE_35080_length_577_cov_1.886905_g32705_i0 | PRJNA911178 | 35080 | 577 | 1.886905 | 10.88744185 | Candidatus Binatia bacterium | 2838779 | Bacteria | Bacteria | 113 | 2.97e-25 | NR | HYC53676.1 | 2838779 | g32705 | i0 | 37.7 | 2.04332755632582 | 199 | 114 | 98.8 | 7 | 7 | 576 | 859 | 1056 | HYC53676.1 hypothetical protein [Candidatus Binatia bacterium] | diamond | 1179 | 113 | 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);;