contig_metadata
12 rows where bioproject = "PRJNA814235", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 27054482 | 27054482 | PRJNA814235_P_NODE_199902_length_150_cov_3.026549_g198507_i0 | PRJNA814235 | 199902 | 150 | 3.026549 | 4.5398235 | Candidatus Binatia bacterium | 2838779 | Bacteria | Bacteria | 44.3 | 0.00293 | NR | MBY0277883.1 | 2838779 | g198507 | i0 | 63.4 | 0.82 | 41 | 15 | 82 | 0 | 21 | 143 | 206 | 246 | MBY0277883.1 M14 family metallopeptidase [Candidatus Binatia bacterium] | diamond | 123 | 44.3 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Binatota | Candidatus Binatia | Candidatus Binatia bacterium | |||||
| 27781050 | 27781050 | PRJNA814235_P_NODE_187704_length_151_cov_3.359649_g186309_i0 | PRJNA814235 | 187704 | 151 | 3.359649 | 5.07306999 | Candidatus Binatia bacterium | 2838779 | Bacteria | Bacteria | 54.7 | 6.45e-7 | NR | HEY8515892.1 | 2838779 | g186309 | i0 | 100 | 0.95364238410596 | 24 | 0 | 47.7 | 0 | 75 | 4 | 171 | 194 | HEY8515892.1 pitrilysin family protein [Candidatus Binatia bacterium] | diamond | 144 | 54.7 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Binatota | Candidatus Binatia | Candidatus Binatia bacterium | |||||
| 27970335 | 27970335 | PRJNA814235_P_NODE_182665_length_151_cov_5.517544_g181270_i0 | PRJNA814235 | 182665 | 151 | 5.517544 | 8.33149144 | Candidatus Binatota bacterium | 2528255 | Bacteria | Bacteria | 47 | 3.42e-4 | NR | MEA2624623.1 | 2528255 | g181270 | i0 | 45 | 1.19205298013245 | 60 | 22 | 97.4 | 1 | 5 | 151 | 67 | 126 | MEA2624623.1 urea transport system permease protein [Candidatus Binatota bacterium] | diamond | 180 | 47 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Binatota | Candidatus Binatota bacterium | ||||||
| 28349239 | 28349239 | PRJNA814235_P_NODE_200566_length_150_cov_2.884956_g199171_i0 | PRJNA814235 | 200566 | 150 | 2.884956 | 4.327434 | Candidatus Binatia bacterium | 2838779 | Bacteria | Bacteria | 79 | 1.69e-15 | NR | MBY0273957.1 | 2838779 | g199171 | i0 | 83 | 2.12 | 53 | 4 | 96 | 1 | 146 | 3 | 137 | 189 | MBY0273957.1 S1 RNA-binding domain-containing protein [Candidatus Binatia bacterium] | diamond | 318 | 79 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Binatota | Candidatus Binatia | Candidatus Binatia bacterium | |||||
| 28759734 | 28759734 | PRJNA814235_P_NODE_92047_length_203_cov_3.060241_g90652_i0 | PRJNA814235 | 92047 | 203 | 3.060241 | 6.21228923 | Candidatus Binatia bacterium | 2838779 | Bacteria | Bacteria | 82.4 | 1.78e-16 | NR | HZD10517.1 | 2838779 | g90652 | i0 | 62.7 | 0.990147783251232 | 67 | 12 | 99 | 1 | 203 | 3 | 127 | 180 | HZD10517.1 MFS transporter [Candidatus Binatia bacterium] | diamond | 201 | 82.4 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Binatota | Candidatus Binatia | Candidatus Binatia bacterium | |||||
| 30117432 | 30117432 | PRJNA814235_P_NODE_110292_length_203_cov_2.060241_g108897_i0 | PRJNA814235 | 110292 | 203 | 2.060241 | 4.18228923 | Candidatus Binatia bacterium | 2838779 | Bacteria | Bacteria | 51.2 | 2.22e-5 | NR | MFN2376304.1 | 2838779 | g108897 | i0 | 92 | 0.369458128078818 | 25 | 2 | 36.9 | 0 | 1 | 75 | 95 | 119 | MFN2376304.1 D-alanyl-D-alanine carboxypeptidase family protein [Candidatus Binatia bacterium] | diamond | 75 | 51.2 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Binatota | Candidatus Binatia | Candidatus Binatia bacterium | |||||
| 30307690 | 30307690 | PRJNA814235_P_NODE_37832_length_311_cov_1.434307_g36442_i0 | PRJNA814235 | 37832 | 311 | 1.434307 | 4.46069477 | Candidatus Binatia bacterium | 2838779 | Bacteria | Bacteria | 79.7 | 8.5e-15 | NR | HEY2920619.1 | 2838779 | g36442 | i0 | 44.7 | 3.16398713826367 | 94 | 52 | 90.7 | 0 | 290 | 9 | 330 | 423 | HEY2920619.1 hypothetical protein [Candidatus Binatia bacterium] | diamond | 984 | 79.7 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Binatota | Candidatus Binatia | Candidatus Binatia bacterium | |||||
| 30433919 | 30433919 | PRJNA814235_P_NODE_191813_length_151_cov_2.859649_g190418_i0 | PRJNA814235 | 191813 | 151 | 2.859649 | 4.31806999 | Candidatus Binatia bacterium | 2838779 | Bacteria | Bacteria | 46.2 | 6.37e-4 | NR | HEY8515145.1 | 2838779 | g190418 | i0 | 83.3 | 1.0728476821192101 | 24 | 4 | 47.7 | 0 | 147 | 76 | 67 | 90 | HEY8515145.1 glycosyltransferase [Candidatus Binatia bacterium] | diamond | 162 | 46.2 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Binatota | Candidatus Binatia | Candidatus Binatia bacterium | |||||
| 31928003 | 31928003 | PRJNA814235_P_NODE_122117_length_202_cov_2.939394_g120722_i0 | PRJNA814235 | 122117 | 202 | 2.939394 | 5.93757588 | Bacillati | 1783272 | Bacteria | Bacteria | 79.7 | 1.95e-15 | NR | HEV7733300.1 | 2838779 | g120722 | i0 | 63.6 | 1.99009900990099 | 66 | 24 | 98 | 0 | 3 | 200 | 374 | 439 | HEV7733300.1 FAD-dependent oxidoreductase [Candidatus Binatia bacterium] | diamond | 402 | 79.7 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Binatota | Candidatus Binatia | Candidatus Binatia bacterium | |||||
| 32172680 | 32172680 | PRJNA814235_P_NODE_65838_length_234_cov_4.233503_g64443_i0 | PRJNA814235 | 65838 | 234 | 4.233503 | 9.90639702 | Candidatus Binataceae bacterium | 2785449 | Bacteria | Bacteria | 54.7 | 3.79e-7 | NR | HEV3114345.1 | 2785449 | g64443 | i0 | 44.3 | 1.37179487179487 | 61 | 34 | 78.2 | 0 | 186 | 4 | 9 | 69 | HEV3114345.1 hypothetical protein [Candidatus Binataceae bacterium] | diamond | 321 | 54.7 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Binatota | Candidatus Binatia | Candidatus Binatales | Candidatus Binataceae | Candidatus Binataceae bacterium | |||
| 32236056 | 32236056 | PRJNA814235_P_NODE_119658_length_203_cov_1.753012_g118263_i0 | PRJNA814235 | 119658 | 203 | 1.753012 | 3.55861436 | Candidatus Binatia bacterium | 2838779 | Bacteria | Bacteria | 43.9 | 0.00723 | NR | MFN8604292.1 | 2838779 | g118263 | i0 | 72 | 0.369458128078818 | 25 | 7 | 36.9 | 0 | 1 | 75 | 188 | 212 | MFN8604292.1 hypothetical protein [Candidatus Binatia bacterium] | diamond | 75 | 43.9 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Binatota | Candidatus Binatia | Candidatus Binatia bacterium | |||||
| 32529422 | 32529422 | PRJNA814235_P_NODE_144859_length_179_cov_2.373239_g143464_i0 | PRJNA814235 | 144859 | 179 | 2.373239 | 4.24809781 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 113 | 9.91e-29 | NR | MET0501061.1 | 2838779 | g143464 | i0 | 96.5 | 1.91061452513966 | 57 | 2 | 95.5 | 0 | 173 | 3 | 156 | 212 | MET0501061.1 tyrosine-type recombinase/integrase [Candidatus Binatia bacterium] | diamond | 342 | 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);;