contig_metadata
21 rows where bioproject = "PRJNA799842", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 23746733 | 23746733 | PRJNA799842_P_NODE_171579_length_244_cov_0.900585_g170006_i0 | PRJNA799842 | 171579 | 244 | 0.900585 | 2.1974274 | Candidatus Binatia bacterium | 2838779 | Bacteria | Bacteria | 104 | 3.14e-24 | NR | HEU5463609.1 | 2838779 | g170006 | i0 | 96.2 | 1.91803278688525 | 52 | 2 | 63.9 | 0 | 243 | 88 | 348 | 399 | HEU5463609.1 FAD-linked oxidase C-terminal domain-containing protein [Candidatus Binatia bacterium] | diamond | 468 | 104 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Binatota | Candidatus Binatia | Candidatus Binatia bacterium | |||||
| 26800760 | 26800760 | PRJNA799842_P_NODE_148241_length_249_cov_0.875000_g146668_i0 | PRJNA799842 | 148241 | 249 | 0.875 | 2.17875 | Candidatus Binatia bacterium | 2838779 | Bacteria | Bacteria | 73.2 | 4.64e-13 | NR | MFN8603405.1 | 2838779 | g146668 | i0 | 72.7 | 0.530120481927711 | 44 | 12 | 53 | 0 | 134 | 3 | 20 | 63 | MFN8603405.1 hypothetical protein [Candidatus Binatia bacterium] | diamond | 132 | 73.2 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Binatota | Candidatus Binatia | Candidatus Binatia bacterium | |||||
| 27275336 | 27275336 | PRJNA799842_P_NODE_158683_length_247_cov_0.885057_g157110_i0 | PRJNA799842 | 158683 | 247 | 0.885057 | 2.18609079 | Candidatus Binatia bacterium | 2838779 | Bacteria | Bacteria | 144 | 1.09e-40 | NR | HEY2919531.1 | 2838779 | g157110 | i0 | 84.1 | 1.9919028340081 | 82 | 13 | 99.6 | 0 | 2 | 247 | 71 | 152 | HEY2919531.1 enoyl-ACP reductase [Candidatus Binatia bacterium] | diamond | 492 | 144 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Binatota | Candidatus Binatia | Candidatus Binatia bacterium | |||||
| 27464967 | 27464967 | PRJNA799842_P_NODE_140703_length_250_cov_0.870056_g139130_i0 | PRJNA799842 | 140703 | 250 | 0.870056 | 2.17514 | Candidatus Binatia bacterium | 2838779 | Bacteria | Bacteria | 168 | 1.0999999999999999e-48 | NR | HEX7226231.1 | 2838779 | g139130 | i0 | 93.9 | 0.984 | 82 | 5 | 98.4 | 0 | 248 | 3 | 65 | 146 | HEX7226231.1 glycosyltransferase family 4 protein [Candidatus Binatia bacterium] | diamond | 246 | 168 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Binatota | Candidatus Binatia | Candidatus Binatia bacterium | |||||
| 27749267 | 27749267 | PRJNA799842_P_NODE_173004_length_244_cov_0.900585_g171431_i0 | PRJNA799842 | 173004 | 244 | 0.900585 | 2.1974274 | Candidatus Binatia bacterium | 2838779 | Bacteria | Bacteria | 70.9 | 4.72e-12 | NR | HYV32827.1 | 2838779 | g171431 | i0 | 46.9 | 0.995901639344262 | 81 | 37 | 99.6 | 1 | 243 | 1 | 53 | 127 | HYV32827.1 Ig-like domain-containing protein [Candidatus Binatia bacterium] | diamond | 243 | 70.9 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Binatota | Candidatus Binatia | Candidatus Binatia bacterium | |||||
| 28128002 | 28128002 | PRJNA799842_P_NODE_184245_length_242_cov_0.911243_g182672_i0 | PRJNA799842 | 184245 | 242 | 0.911243 | 2.20520806 | Candidatus Binatia bacterium | 2838779 | Bacteria | Bacteria | 49.3 | 7.78e-5 | NR | HLN88792.1 | 2838779 | g182672 | i0 | 100 | 2.51652892561983 | 29 | 0 | 36 | 0 | 87 | 1 | 1 | 29 | HLN88792.1 hypothetical protein [Candidatus Binatia bacterium] | diamond | 609 | 49.3 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Binatota | Candidatus Binatia | Candidatus Binatia bacterium | |||||
| 28159682 | 28159682 | PRJNA799842_P_NODE_185325_length_242_cov_0.911243_g183752_i0 | PRJNA799842 | 185325 | 242 | 0.911243 | 2.20520806 | Candidatus Binatia bacterium | 2838779 | Bacteria | Bacteria | 152 | 3.05e-41 | NR | MET0644432.1 | 2838779 | g183752 | i0 | 95 | 2.97520661157025 | 80 | 4 | 99.2 | 0 | 242 | 3 | 116 | 195 | MET0644432.1 ribonuclease R [Candidatus Binatia bacterium] | diamond | 720 | 152 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Binatota | Candidatus Binatia | Candidatus Binatia bacterium | |||||
| 28759279 | 28759279 | PRJNA799842_P_NODE_157667_length_247_cov_0.885057_g156094_i0 | PRJNA799842 | 157667 | 247 | 0.885057 | 2.18609079 | Candidatus Binatia bacterium | 2838779 | Bacteria | Bacteria | 122 | 1.7199999999999998e-32 | NR | HEY7322593.1 | 2838779 | g156094 | i0 | 82.4 | 3.57085020242915 | 74 | 13 | 89.9 | 0 | 1 | 222 | 162 | 235 | HEY7322593.1 ZIP family metal transporter [Candidatus Binatia bacterium] | diamond | 882 | 122 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Binatota | Candidatus Binatia | Candidatus Binatia bacterium | |||||
| 29201523 | 29201523 | PRJNA799842_P_NODE_147989_length_249_cov_0.875000_g146416_i0 | PRJNA799842 | 147989 | 249 | 0.875 | 2.17875 | Candidatus Binatia bacterium | 2838779 | Bacteria | Bacteria | 145 | 4.029999999999999e-40 | NR | HEY5543144.1 | 2838779 | g146416 | i0 | 89 | 0.987951807228916 | 82 | 9 | 98.8 | 0 | 2 | 247 | 139 | 220 | HEY5543144.1 FAD-dependent oxidoreductase [Candidatus Binatia bacterium] | diamond | 246 | 145 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Binatota | Candidatus Binatia | Candidatus Binatia bacterium | |||||
| 29359371 | 29359371 | PRJNA799842_P_NODE_188449_length_241_cov_0.916667_g186876_i0 | PRJNA799842 | 188449 | 241 | 0.916667 | 2.20916747 | Candidatus Binatia bacterium | 2838779 | Bacteria | Bacteria | 145 | 4.68e-43 | NR | HEX6768555.1 | 2838779 | g186876 | i0 | 98.8 | 0.995850622406639 | 80 | 1 | 99.6 | 0 | 1 | 240 | 8 | 87 | HEX6768555.1 hypothetical protein [Candidatus Binatia bacterium] | diamond | 240 | 145 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Binatota | Candidatus Binatia | Candidatus Binatia bacterium | |||||
| 29737892 | 29737892 | PRJNA799842_P_NODE_141370_length_250_cov_0.870056_g139797_i0 | PRJNA799842 | 141370 | 250 | 0.870056 | 2.17514 | Candidatus Binatia bacterium | 2838779 | Bacteria | Bacteria | 128 | 3.61e-35 | NR | HLN89470.1 | 2838779 | g139797 | i0 | 82.9 | 1.68 | 70 | 12 | 84 | 0 | 2 | 211 | 128 | 197 | HLN89470.1 methionine biosynthesis protein MetW [Candidatus Binatia bacterium] | diamond | 420 | 128 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Binatota | Candidatus Binatia | Candidatus Binatia bacterium | |||||
| 29737905 | 29737905 | PRJNA799842_P_NODE_157430_length_247_cov_0.885057_g155857_i0 | PRJNA799842 | 157430 | 247 | 0.885057 | 2.18609079 | Candidatus Binatus sp. | 2811406 | Bacteria | Bacteria | 69.7 | 1.19e-11 | NR | WP_333646922.1 | 2811406 | g155857 | i0 | 45.8 | 1.0080971659919 | 83 | 36 | 99.6 | 2 | 1 | 246 | 321 | 395 | WP_333646922.1 pilus assembly protein TadG-related protein [Candidatus Binatus sp.] | diamond | 249 | 69.7 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Binatota | Candidatus Binatia | Candidatus Binatales | Candidatus Binataceae | Candidatus Binatus | Candidatus Binatus sp. | ||
| 29769601 | 29769601 | PRJNA799842_P_NODE_140411_length_250_cov_0.870056_g138838_i0 | PRJNA799842 | 140411 | 250 | 0.870056 | 2.17514 | Candidatus Binatia bacterium | 2838779 | Bacteria | Bacteria | 99.8 | 8.849999999999999e-23 | NR | MFQ5903046.1 | 2838779 | g138838 | i0 | 61 | 0.984 | 82 | 32 | 98.4 | 0 | 247 | 2 | 13 | 94 | MFQ5903046.1 Gfo/Idh/MocA family protein [Candidatus Binatia bacterium] | diamond | 246 | 99.8 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Binatota | Candidatus Binatia | Candidatus Binatia bacterium | |||||
| 30243718 | 30243718 | PRJNA799842_P_NODE_172012_length_244_cov_0.900585_g170439_i0 | PRJNA799842 | 172012 | 244 | 0.900585 | 2.1974274 | Candidatus Binatia bacterium | 2838779 | Bacteria | Bacteria | 150 | 1.35e-44 | NR | HXV84328.1 | 2838779 | g170439 | i0 | 93.8 | 0.995901639344262 | 81 | 5 | 99.6 | 0 | 1 | 243 | 22 | 102 | HXV84328.1 hypothetical protein [Candidatus Binatia bacterium] | diamond | 243 | 150 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Binatota | Candidatus Binatia | Candidatus Binatia bacterium | |||||
| 30402044 | 30402044 | PRJNA799842_P_NODE_167793_length_245_cov_0.895349_g166220_i0 | PRJNA799842 | 167793 | 245 | 0.895349 | 2.19360505 | Candidatus Binatia bacterium | 2838779 | Bacteria | Bacteria | 158 | 3.5699999999999995e-47 | NR | HEX5021187.1 | 2838779 | g166220 | i0 | 98.8 | 0.991836734693878 | 81 | 1 | 99.2 | 0 | 244 | 2 | 84 | 164 | HEX5021187.1 MOSC domain-containing protein [Candidatus Binatia bacterium] | diamond | 243 | 158 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Binatota | Candidatus Binatia | Candidatus Binatia bacterium | |||||
| 30780672 | 30780672 | PRJNA799842_P_NODE_137854_length_251_cov_0.865169_g136281_i0 | PRJNA799842 | 137854 | 251 | 0.865169 | 2.17157419 | Candidatus Binatia bacterium | 2838779 | Bacteria | Bacteria | 166 | 2.36e-49 | NR | HEX5019686.1 | 2838779 | g136281 | i0 | 100 | 0.99203187250996006 | 83 | 0 | 99.2 | 0 | 2 | 250 | 95 | 177 | HEX5019686.1 ABC transporter substrate-binding protein [Candidatus Binatia bacterium] | diamond | 249 | 166 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Binatota | Candidatus Binatia | Candidatus Binatia bacterium | |||||
| 30970432 | 30970432 | PRJNA799842_P_NODE_169794_length_245_cov_0.895349_g168221_i0 | PRJNA799842 | 169794 | 245 | 0.895349 | 2.19360505 | Candidatus Binatia bacterium | 2838779 | Bacteria | Bacteria | 140 | 5.61e-38 | NR | HET7009025.1 | 2838779 | g168221 | i0 | 97.5 | 0.991836734693878 | 81 | 2 | 99.2 | 0 | 2 | 244 | 246 | 326 | HET7009025.1 ABC transporter permease subunit [Candidatus Binatia bacterium] | diamond | 243 | 140 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Binatota | Candidatus Binatia | Candidatus Binatia bacterium | |||||
| 31381392 | 31381392 | PRJNA799842_P_NODE_177856_length_243_cov_0.905882_g176283_i0 | PRJNA799842 | 177856 | 243 | 0.905882 | 2.20129326 | Candidatus Binatia bacterium | 2838779 | Bacteria | Bacteria | 146 | 1.94e-41 | NR | HLN90141.1 | 2838779 | g176283 | i0 | 88.9 | 5 | 81 | 9 | 100 | 0 | 1 | 243 | 45 | 125 | HLN90141.1 ABC transporter substrate-binding protein [Candidatus Binatia bacterium] | diamond | 1215 | 146 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Binatota | Candidatus Binatia | Candidatus Binatia bacterium | |||||
| 31634163 | 31634163 | PRJNA799842_P_NODE_168916_length_245_cov_0.895349_g167343_i0 | PRJNA799842 | 168916 | 245 | 0.895349 | 2.19360505 | Candidatus Binatia bacterium | 2838779 | Bacteria | Bacteria | 70.5 | 4.46e-12 | NR | HEY7219375.1 | 2838779 | g167343 | i0 | 91.2 | 0.416326530612245 | 34 | 3 | 41.6 | 0 | 243 | 142 | 291 | 324 | HEY7219375.1 ABC transporter substrate-binding protein [Candidatus Binatia bacterium] | diamond | 102 | 70.5 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Binatota | Candidatus Binatia | Candidatus Binatia bacterium | |||||
| 32520364 | 32520364 | PRJNA799842_P_NODE_124039_length_263_cov_0.900000_g122466_i0 | PRJNA799842 | 124039 | 263 | 0.9 | 2.367 | Candidatus Binatia bacterium | 2838779 | Bacteria | Bacteria | 43.1 | 0.00425 | NR | HLN89385.1 | 2838779 | g122466 | i0 | 64.7 | 1.12927756653992 | 34 | 12 | 38.8 | 0 | 261 | 160 | 37 | 70 | HLN89385.1 hypothetical protein [Candidatus Binatia bacterium] | diamond | 297 | 43.1 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Binatota | Candidatus Binatia | Candidatus Binatia bacterium | |||||
| 32772112 | 32772112 | PRJNA799842_P_NODE_146120_length_249_cov_0.875000_g144547_i0 | PRJNA799842 | 146120 | 249 | 0.875 | 2.17875 | Candidatus Binatia bacterium | 2838779 | Bacteria | Bacteria | 57.4 | 4.54e-8 | NR | HXV81905.1 | 2838779 | g144547 | i0 | 75 | 1.1566265060241 | 32 | 8 | 38.6 | 0 | 247 | 152 | 110 | 141 | HXV81905.1 hypothetical protein [Candidatus Binatia bacterium] | diamond | 288 | 57.4 | 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);;