contig_metadata
13 rows where bioproject = "PRJNA1240804" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5450812 | 5450812 | PRJNA1240804_P_NODE_136045_length_164_cov_0.904348_g135679_i0 | PRJNA1240804 | 136045 | 164 | 0.904348 | 1.48313072 | Candidatus Binatia bacterium | 2838779 | Bacteria | Bacteria | 98.2 | 2.15e-22 | NR | MFN8604010.1 | 2838779 | g135679 | i0 | 94.1 | 1.86585365853659 | 51 | 3 | 93.3 | 0 | 154 | 2 | 274 | 324 | MFN8604010.1 2-oxoglutarate dehydrogenase complex dihydrolipoyllysine-residue succinyltransferase [Candidatus Binatia bacterium] | diamond | 306 | 98.2 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Binatota | Candidatus Binatia | Candidatus Binatia bacterium | |||||
| 24573629 | 24573629 | PRJNA1240804_P_NODE_136880_length_164_cov_0.904348_g136514_i0 | PRJNA1240804 | 136880 | 164 | 0.904348 | 1.48313072 | Candidatus Binatia bacterium | 2838779 | Bacteria | Bacteria | 73.2 | 2.33e-13 | NR | MBY0276671.1 | 2838779 | g136514 | i0 | 87.8 | 0.75 | 41 | 5 | 75 | 0 | 124 | 2 | 7 | 47 | MBY0276671.1 NAD(P)/FAD-dependent oxidoreductase [Candidatus Binatia bacterium] | diamond | 123 | 73.2 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Binatota | Candidatus Binatia | Candidatus Binatia bacterium | |||||
| 27294728 | 27294728 | PRJNA1240804_P_NODE_144683_length_163_cov_0.912281_g144317_i0 | PRJNA1240804 | 144683 | 163 | 0.912281 | 1.48701803 | Candidatus Binatia bacterium | 2838779 | Bacteria | Bacteria | 60.8 | 5.13e-9 | NR | HXU47517.1 | 2838779 | g144317 | i0 | 82.9 | 0.644171779141104 | 35 | 6 | 64.4 | 0 | 10 | 114 | 424 | 458 | HXU47517.1 fucose isomerase [Candidatus Binatia bacterium] | diamond | 105 | 60.8 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Binatota | Candidatus Binatia | Candidatus Binatia bacterium | |||||
| 27421434 | 27421434 | PRJNA1240804_P_NODE_86023_length_182_cov_1.819549_g85657_i0 | PRJNA1240804 | 86023 | 182 | 1.819549 | 3.31157918 | Candidatus Binatia bacterium | 2838779 | Bacteria | Bacteria | 77.8 | 3.96e-15 | NR | HUS25175.1 | 2838779 | g85657 | i0 | 92.9 | 16.1208791208791 | 42 | 3 | 69.2 | 0 | 127 | 2 | 1 | 42 | HUS25175.1 hydrogen peroxide-inducible genes activator [Candidatus Binatia bacterium] | diamond | 2934 | 77.8 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Binatota | Candidatus Binatia | Candidatus Binatia bacterium | |||||
| 27421444 | 27421444 | PRJNA1240804_P_NODE_97363_length_175_cov_1.357143_g96997_i0 | PRJNA1240804 | 97363 | 175 | 1.357143 | 2.37500025 | Candidatus Binatia bacterium | 2838779 | Bacteria | Bacteria | 84 | 4.5e-17 | NR | MBY0274021.1 | 2838779 | g96997 | i0 | 80.8 | 1.78285714285714 | 52 | 10 | 89.1 | 0 | 17 | 172 | 386 | 437 | MBY0274021.1 hypothetical protein [Candidatus Binatia bacterium] | diamond | 312 | 84 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Binatota | Candidatus Binatia | Candidatus Binatia bacterium | |||||
| 28021197 | 28021197 | PRJNA1240804_P_NODE_153225_length_156_cov_2.299065_g152859_i0 | PRJNA1240804 | 153225 | 156 | 2.299065 | 3.5865414 | Candidatus Binatia bacterium | 2838779 | Bacteria | Bacteria | 54.7 | 6.74e-7 | NR | MBY0275680.1 | 2838779 | g152859 | i0 | 89.7 | 0.557692307692308 | 29 | 3 | 55.8 | 0 | 152 | 66 | 414 | 442 | MBY0275680.1 ATP-dependent protease ATPase subunit HslU [Candidatus Binatia bacterium] | diamond | 87 | 54.7 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Binatota | Candidatus Binatia | Candidatus Binatia bacterium | |||||
| 29157964 | 29157964 | PRJNA1240804_P_NODE_98109_length_174_cov_2.392000_g97743_i0 | PRJNA1240804 | 98109 | 174 | 2.392 | 4.16208 | Candidatus Binatia bacterium | 2838779 | Bacteria | Bacteria | 108 | 9.99e-26 | NR | MFN8599541.1 | 2838779 | g97743 | i0 | 98.1 | 0.913793103448276 | 53 | 1 | 91.4 | 0 | 16 | 174 | 1741 | 1793 | MFN8599541.1 right-handed parallel beta-helix repeat-containing protein [Candidatus Binatia bacterium] | diamond | 159 | 108 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Binatota | Candidatus Binatia | Candidatus Binatia bacterium | |||||
| 29441542 | 29441542 | PRJNA1240804_P_NODE_101050_length_173_cov_0.903226_g100684_i0 | PRJNA1240804 | 101050 | 173 | 0.903226 | 1.56258098 | Candidatus Binatia bacterium | 2838779 | Bacteria | Bacteria | 42 | 0.0273 | NR | MFN8542840.1 | 2838779 | g100684 | i0 | 40 | 0.953757225433526 | 55 | 26 | 83.2 | 1 | 155 | 12 | 4 | 58 | MFN8542840.1 glycosyltransferase family 39 protein [Candidatus Binatia bacterium] | diamond | 165 | 42 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Binatota | Candidatus Binatia | Candidatus Binatia bacterium | |||||
| 29694151 | 29694151 | PRJNA1240804_P_NODE_58070_length_207_cov_2.829114_g57704_i0 | PRJNA1240804 | 58070 | 207 | 2.829114 | 5.85626598 | Candidatus Binatia bacterium | 2838779 | Bacteria | Bacteria | 80.5 | 2.86e-16 | NR | HUS24191.1 | 2838779 | g57704 | i0 | 59.4 | 0.927536231884058 | 64 | 26 | 92.8 | 0 | 194 | 3 | 64 | 127 | HUS24191.1 sulfite exporter TauE/SafE family protein [Candidatus Binatia bacterium] | diamond | 192 | 80.5 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Binatota | Candidatus Binatia | Candidatus Binatia bacterium | |||||
| 29852384 | 29852384 | PRJNA1240804_P_NODE_108651_length_169_cov_0.866667_g108285_i0 | PRJNA1240804 | 108651 | 169 | 0.866667 | 1.46466723 | Candidatus Binatia bacterium | 2838779 | Bacteria | Bacteria | 62 | 2.21e-9 | NR | HEX9264405.1 | 2838779 | g108285 | i0 | 61.2 | 3.74556213017751 | 49 | 19 | 87 | 0 | 160 | 14 | 48 | 96 | HEX9264405.1 ATP-binding protein [Candidatus Binatia bacterium] | diamond | 633 | 62 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Binatota | Candidatus Binatia | Candidatus Binatia bacterium | |||||
| 32001673 | 32001673 | PRJNA1240804_P_NODE_124698_length_166_cov_0.888889_g124332_i0 | PRJNA1240804 | 124698 | 166 | 0.888889 | 1.47555574 | Candidatus Binatia bacterium | 2838779 | Bacteria | Bacteria | 91.7 | 7.78e-20 | NR | MFN8601612.1 | 2838779 | g124332 | i0 | 88.7 | 0.957831325301205 | 53 | 5 | 94 | 1 | 8 | 163 | 37 | 89 | MFN8601612.1 hypothetical protein [Candidatus Binatia bacterium] | diamond | 159 | 91.7 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Binatota | Candidatus Binatia | Candidatus Binatia bacterium | |||||
| 32413119 | 32413119 | PRJNA1240804_P_NODE_103539_length_171_cov_1.385246_g103173_i0 | PRJNA1240804 | 103539 | 171 | 1.385246 | 2.36877066 | Candidatus Binatia bacterium | 2838779 | Bacteria | Bacteria | 48.1 | 1.72e-4 | NR | MFN8602942.1 | 2838779 | g103173 | i0 | 95.8 | 0.421052631578947 | 24 | 1 | 42.1 | 0 | 15 | 86 | 266 | 289 | MFN8602942.1 hypothetical protein [Candidatus Binatia bacterium] | diamond | 72 | 48.1 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Binatota | Candidatus Binatia | Candidatus Binatia bacterium | |||||
| 32665544 | 32665544 | PRJNA1240804_P_NODE_124580_length_166_cov_0.888889_g124214_i0 | PRJNA1240804 | 124580 | 166 | 0.888889 | 1.47555574 | Candidatus Binatia bacterium | 2838779 | Bacteria | Bacteria | 70.5 | 2.1e-12 | NR | MFN8599383.1 | 2838779 | g124214 | i0 | 77.6 | 0.885542168674699 | 49 | 6 | 79.5 | 1 | 133 | 2 | 1 | 49 | MFN8599383.1 outer membrane beta-barrel protein [Candidatus Binatia bacterium] | diamond | 147 | 70.5 | 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);;