contig_metadata
11 rows where bioproject = "PRJEB66218" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 16707581 | 16707581 | PRJEB66218_P_NODE_125714_length_267_cov_1.674757_g123285_i0 | PRJEB66218 | 125714 | 267 | 1.674757 | 4.47160119 | uncultured Candidatus Binatia bacterium | 3036252 | Bacteria | Bacteria | 171 | 6.46e-38 | NTclustered | gi|2891481979|emb|OZ219754.1| | 3036252 | g123285 | i0 | 79.026 | 79.6554307116105 | 267 | 43 | 97 | 12 | 8 | 267 | 2068925 | 2068665 | MAG: uncultured Candidatus Binatia bacterium isolate 58a26a4a-5c73-4e1d-804e-87f8126ae6b7 genome assembly, chromosome: 1 | blastn | 21268 | 171 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Binatota | Candidatus Binatia | uncultured Candidatus Binatia bacterium | |||||
| 20535381 | 20535381 | PRJEB66218_P_NODE_83717_length_343_cov_1.843972_g81290_i0 | PRJEB66218 | 83717 | 343 | 1.843972 | 6.32482396 | Candidatus Binatia bacterium | 2838779 | Bacteria | Bacteria | 60.8 | 5.44e-8 | NR | HUS23649.1 | 2838779 | g81290 | i0 | 38 | 0.944606413994169 | 108 | 53 | 94.5 | 1 | 2 | 325 | 941 | 1034 | HUS23649.1 PKD domain-containing protein [Candidatus Binatia bacterium] | diamond | 324 | 60.8 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Binatota | Candidatus Binatia | Candidatus Binatia bacterium | |||||
| 26844307 | 26844307 | PRJEB66218_P_NODE_135901_length_255_cov_1.829897_g133472_i0 | PRJEB66218 | 135901 | 255 | 1.829897 | 4.66623735 | Candidatus Binatia bacterium | 2838779 | Bacteria | Bacteria | 51.2 | 4.43e-5 | NR | HVI09177.1 | 2838779 | g133472 | i0 | 36.9 | 1.97647058823529 | 84 | 29 | 98.8 | 3 | 2 | 253 | 748 | 807 | HVI09177.1 bifunctional acetate--CoA ligase family protein/GNAT family N-acetyltransferase [Candidatus Binatia bacterium] | diamond | 504 | 51.2 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Binatota | Candidatus Binatia | Candidatus Binatia bacterium | |||||
| 27058549 | 27058549 | PRJEB66218_P_NODE_62902_length_412_cov_2.116809_g60480_i0 | PRJEB66218 | 62902 | 412 | 2.116809 | 8.72125308 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 48.9 | 0.00127 | NR | MFN2427511.1 | 2838779 | g60480 | i0 | 36 | 1.99514563106796 | 136 | 77 | 98.3 | 6 | 410 | 6 | 17 | 143 | MFN2427511.1 IPT/TIG domain-containing protein [Candidatus Binatia bacterium] | diamond | 822 | 48.9 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Binatota | Candidatus Binatia | Candidatus Binatia bacterium | |||||
| 27128461 | 27128461 | PRJEB66218_P_NODE_5982_length_1885_cov_4.104167_g5012_i0 | PRJEB66218 | 5982 | 1885 | 4.104167 | 77.36354795 | Candidatus Binatia bacterium | 2838779 | Bacteria | Bacteria | 50.4 | 0.0192 | NR | HEY2772704.1 | 2838779 | g5012 | i0 | 33.3 | 0.157559681697613 | 99 | 65 | 15.8 | 1 | 3 | 299 | 160 | 257 | HEY2772704.1 IPT/TIG domain-containing protein [Candidatus Binatia bacterium] | diamond | 297 | 50.4 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Binatota | Candidatus Binatia | Candidatus Binatia bacterium | |||||
| 29024017 | 29024017 | PRJEB66218_P_NODE_80848_length_351_cov_1.548276_g78421_i0 | PRJEB66218 | 80848 | 351 | 1.548276 | 5.43444876 | Candidatus Binatia bacterium | 2838779 | Bacteria | Bacteria | 139 | 1.2799999999999998e-35 | NR | HUS23408.1 | 2838779 | g78421 | i0 | 61.1 | 0.965811965811966 | 113 | 43 | 96.6 | 1 | 2 | 340 | 416 | 527 | HUS23408.1 pitrilysin family protein [Candidatus Binatia bacterium] | diamond | 339 | 139 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Binatota | Candidatus Binatia | Candidatus Binatia bacterium | |||||
| 29907839 | 29907839 | PRJEB66218_P_NODE_235471_length_203_cov_0.915493_g233040_i0 | PRJEB66218 | 235471 | 203 | 0.915493 | 1.85845079 | Candidatus Binatia bacterium | 2838779 | Bacteria | Bacteria | 42 | 0.0415 | NR | MFQ5917626.1 | 2838779 | g233040 | i0 | 45.5 | 0.487684729064039 | 33 | 18 | 48.8 | 0 | 202 | 104 | 525 | 557 | MFQ5917626.1 tetratricopeptide repeat protein [Candidatus Binatia bacterium] | diamond | 99 | 42 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Binatota | Candidatus Binatia | Candidatus Binatia bacterium | |||||
| 30223588 | 30223588 | PRJEB66218_P_NODE_59212_length_429_cov_1.320652_g56792_i0 | PRJEB66218 | 59212 | 429 | 1.320652 | 5.66559708 | Candidatus Binatia bacterium | 2838779 | Bacteria | Bacteria | 211 | 2.15e-60 | NR | HUS23649.1 | 2838779 | g56792 | i0 | 62 | 1.95804195804196 | 142 | 54 | 99.3 | 0 | 3 | 428 | 435 | 576 | HUS23649.1 PKD domain-containing protein [Candidatus Binatia bacterium] | diamond | 840 | 211 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Binatota | Candidatus Binatia | Candidatus Binatia bacterium | |||||
| 30381976 | 30381976 | PRJEB66218_P_NODE_163793_length_231_cov_2.800000_g161363_i0 | PRJEB66218 | 163793 | 231 | 2.8 | 6.468 | Candidatus Binatia bacterium | 2838779 | Bacteria | Bacteria | 91.7 | 1.91e-19 | NR | HUS23649.1 | 2838779 | g161363 | i0 | 57.9 | 1.93506493506494 | 76 | 32 | 98.7 | 0 | 3 | 230 | 605 | 680 | HUS23649.1 PKD domain-containing protein [Candidatus Binatia bacterium] | diamond | 447 | 91.7 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Binatota | Candidatus Binatia | Candidatus Binatia bacterium | |||||
| 30381990 | 30381990 | PRJEB66218_P_NODE_182993_length_219_cov_1.639241_g180563_i0 | PRJEB66218 | 182993 | 219 | 1.639241 | 3.58993779 | Candidatus Binatia bacterium | 2838779 | Bacteria | Bacteria | 83.6 | 1.12e-16 | NR | HUS23408.1 | 2838779 | g180563 | i0 | 59.7 | 1.97260273972603 | 72 | 29 | 98.6 | 0 | 218 | 3 | 343 | 414 | HUS23408.1 pitrilysin family protein [Candidatus Binatia bacterium] | diamond | 432 | 83.6 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Binatota | Candidatus Binatia | Candidatus Binatia bacterium | |||||
| 32057180 | 32057180 | PRJEB66218_P_NODE_97798_length_311_cov_1.040000_g95370_i0 | PRJEB66218 | 97798 | 311 | 1.04 | 3.2344 | Candidatus Binatia bacterium | 2838779 | Bacteria | Bacteria | 159 | 1.6699999999999998e-45 | NR | MFN8600075.1 | 2838779 | g95370 | i0 | 72 | 0.964630225080386 | 100 | 27 | 96.5 | 1 | 11 | 310 | 174 | 272 | MFN8600075.1 2-oxoglutarate and iron-dependent oxygenase domain-containing protein [Candidatus Binatia bacterium] | diamond | 300 | 159 | 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);;