contig_metadata
16 rows where bioproject = "PRJNA315399", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26694515 | 26694515 | PRJNA315399_S_NODE_179521_length_154_cov_1.649573_g179320_i0 | PRJNA315399 | 179521 | 154 | 1.649573 | 2.54034242 | Candidatus Binatia bacterium | 2838779 | Bacteria | Bacteria | 92.4 | 2.26e-22 | NR | HEX4989145.1 | 2838779 | g179320 | i0 | 92.2 | 0.993506493506494 | 51 | 4 | 99.4 | 0 | 1 | 153 | 53 | 103 | HEX4989145.1 heme-binding protein [Candidatus Binatia bacterium] | diamond | 153 | 92.4 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Binatota | Candidatus Binatia | Candidatus Binatia bacterium | |||||
| 26757725 | 26757725 | PRJNA315399_P_NODE_142161_length_190_cov_2.660131_g141713_i0 | PRJNA315399 | 142161 | 190 | 2.660131 | 5.0542489 | Candidatus Binatia bacterium | 2838779 | Bacteria | Bacteria | 45.4 | 0.00197 | NR | HEY7220627.1 | 2838779 | g141713 | i0 | 79.2 | 0.378947368421053 | 24 | 5 | 37.9 | 0 | 101 | 30 | 349 | 372 | HEY7220627.1 aromatic ring-hydroxylating dioxygenase subunit alpha [Candidatus Binatia bacterium] | diamond | 72 | 45.4 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Binatota | Candidatus Binatia | Candidatus Binatia bacterium | |||||
| 26916208 | 26916208 | PRJNA315399_P_NODE_427702_length_158_cov_9.479339_g427254_i0 | PRJNA315399 | 427702 | 158 | 9.479339 | 14.97735562 | Candidatus Binatia bacterium | 2838779 | Bacteria | Bacteria | 50.1 | 3.05e-5 | NR | MBY0274726.1 | 2838779 | g427254 | i0 | 52.1 | 0.911392405063291 | 48 | 21 | 91.1 | 1 | 9 | 152 | 712 | 757 | MBY0274726.1 phage portal protein [Candidatus Binatia bacterium] | diamond | 144 | 50.1 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Binatota | Candidatus Binatia | Candidatus Binatia bacterium | |||||
| 26979408 | 26979408 | PRJNA315399_P_NODE_190482_length_185_cov_7.182432_g190034_i0 | PRJNA315399 | 190482 | 185 | 7.182432 | 13.2874992 | Candidatus Binatia bacterium | 2838779 | Bacteria | Bacteria | 53.1 | 3.65e-6 | NR | HJY82559.1 | 2838779 | g190034 | i0 | 60.5 | 0.616216216216216 | 38 | 12 | 61.6 | 1 | 166 | 53 | 582 | 616 | HJY82559.1 hypothetical protein [Candidatus Binatia bacterium] | diamond | 114 | 53.1 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Binatota | Candidatus Binatia | Candidatus Binatia bacterium | |||||
| 28558935 | 28558935 | PRJNA315399_S_NODE_118107_length_171_cov_2.358209_g117906_i0 | PRJNA315399 | 118107 | 171 | 2.358209 | 4.03253739 | Candidatus Binatia bacterium | 2838779 | Bacteria | Bacteria | 84 | 9.91e-19 | NR | HEX4988700.1 | 2838779 | g117906 | i0 | 81.5 | 1.89473684210526 | 54 | 10 | 94.7 | 0 | 3 | 164 | 23 | 76 | HEX4988700.1 CBS domain-containing protein [Candidatus Binatia bacterium] | diamond | 324 | 84 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Binatota | Candidatus Binatia | Candidatus Binatia bacterium | |||||
| 29537492 | 29537492 | PRJNA315399_S_NODE_110910_length_174_cov_1.335766_g110709_i0 | PRJNA315399 | 110910 | 174 | 1.335766 | 2.32423284 | Candidatus Binatia bacterium | 2838779 | Bacteria | Bacteria | 121 | 2.5399999999999996e-31 | NR | HEX9273767.1 | 2838779 | g110709 | i0 | 98.2 | 2.94827586206897 | 57 | 1 | 98.3 | 0 | 1 | 171 | 191 | 247 | HEX9273767.1 amidohydrolase family protein [Candidatus Binatia bacterium] | diamond | 513 | 121 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Binatota | Candidatus Binatia | Candidatus Binatia bacterium | |||||
| 29916586 | 29916586 | PRJNA315399_P_NODE_267111_length_180_cov_9.090909_g266663_i0 | PRJNA315399 | 267111 | 180 | 9.090909 | 16.3636362 | Candidatus Binatus sp. | 2811406 | Bacteria | Bacteria | 41.6 | 0.00945 | NR | HEV2170186.1 | 2811406 | g266663 | i0 | 59.3 | 0.9 | 27 | 11 | 45 | 0 | 5 | 85 | 29 | 55 | HEV2170186.1 helix-turn-helix domain-containing protein [Candidatus Binatus sp.] | diamond | 162 | 41.6 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Binatota | Candidatus Binatia | Candidatus Binatales | Candidatus Binataceae | Candidatus Binatus | Candidatus Binatus sp. | ||
| 30927686 | 30927686 | PRJNA315399_P_NODE_89714_length_206_cov_3.372781_g89266_i0 | PRJNA315399 | 89714 | 206 | 3.372781 | 6.94792886 | Candidatus Binatia bacterium | 2838779 | Bacteria | Bacteria | 82.4 | 1.46e-16 | NR | MET0501416.1 | 2838779 | g89266 | i0 | 97.7 | 0.62621359223301 | 43 | 1 | 62.6 | 0 | 6 | 134 | 306 | 348 | MET0501416.1 LacI family DNA-binding transcriptional regulator [Candidatus Binatia bacterium] | diamond | 129 | 82.4 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Binatota | Candidatus Binatia | Candidatus Binatia bacterium | |||||
| 31116788 | 31116788 | PRJNA315399_P_NODE_338135_length_173_cov_2.139706_g337687_i0 | PRJNA315399 | 338135 | 173 | 2.139706 | 3.70169138 | Candidatus Binataceae bacterium | 2785449 | Bacteria | Bacteria | 46.2 | 8.55e-4 | NR | HVA84202.1 | 2785449 | g337687 | i0 | 38.5 | 2.67052023121387 | 52 | 31 | 88.4 | 1 | 157 | 5 | 24 | 75 | HVA84202.1 GNAT family N-acetyltransferase [Candidatus Binataceae bacterium] | diamond | 462 | 46.2 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Binatota | Candidatus Binatia | Candidatus Binatales | Candidatus Binataceae | Candidatus Binataceae bacterium | |||
| 31370271 | 31370271 | PRJNA315399_S_NODE_184596_length_153_cov_1.327586_g184395_i0 | PRJNA315399 | 184596 | 153 | 1.327586 | 2.03120658 | Candidatus Binatia bacterium | 2838779 | Bacteria | Bacteria | 61.6 | 5.22e-10 | NR | HME60511.1 | 2838779 | g184395 | i0 | 47.1 | 1 | 51 | 27 | 100 | 0 | 1 | 153 | 41 | 91 | HME60511.1 hypothetical protein [Candidatus Binatia bacterium] | diamond | 153 | 61.6 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Binatota | Candidatus Binatia | Candidatus Binatia bacterium | |||||
| 31401885 | 31401885 | PRJNA315399_S_NODE_44076_length_222_cov_5.427027_g43875_i0 | PRJNA315399 | 44076 | 222 | 5.427027 | 12.04799994 | Candidatus Binatia bacterium | 2838779 | Bacteria | Bacteria | 136 | 4.3e-37 | NR | HEX4988158.1 | 2838779 | g43875 | i0 | 91.5 | 0.959459459459459 | 71 | 6 | 95.9 | 0 | 214 | 2 | 18 | 88 | HEX4988158.1 ABC transporter substrate-binding protein [Candidatus Binatia bacterium] | diamond | 213 | 136 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Binatota | Candidatus Binatia | Candidatus Binatia bacterium | |||||
| 32097565 | 32097565 | PRJNA315399_S_NODE_74078_length_193_cov_3.641026_g73877_i0 | PRJNA315399 | 74078 | 193 | 3.641026 | 7.02718018 | Candidatus Binatia bacterium | 2838779 | Bacteria | Bacteria | 98.2 | 4.35e-22 | NR | HEX4987220.1 | 2838779 | g73877 | i0 | 81.3 | 2.98445595854922 | 64 | 12 | 99.5 | 0 | 2 | 193 | 407 | 470 | HEX4987220.1 FtsX-like permease family protein [Candidatus Binatia bacterium] | diamond | 576 | 98.2 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Binatota | Candidatus Binatia | Candidatus Binatia bacterium | |||||
| 32256218 | 32256218 | PRJNA315399_S_NODE_71198_length_195_cov_4.354430_g70997_i0 | PRJNA315399 | 71198 | 195 | 4.35443 | 8.4911385 | Candidatus Binatia bacterium | 2838779 | Bacteria | Bacteria | 114 | 3.3799999999999993e-28 | NR | HVN83330.1 | 2838779 | g70997 | i0 | 81.3 | 3.93846153846154 | 64 | 12 | 98.5 | 0 | 3 | 194 | 254 | 317 | HVN83330.1 hypothetical protein [Candidatus Binatia bacterium] | diamond | 768 | 114 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Binatota | Candidatus Binatia | Candidatus Binatia bacterium | |||||
| 32287779 | 32287779 | PRJNA315399_P_NODE_66739_length_220_cov_8.994536_g66291_i0 | PRJNA315399 | 66739 | 220 | 8.994536 | 19.7879792 | Candidatus Binatia bacterium | 2838779 | Bacteria | Bacteria | 53.5 | 4.27e-6 | NR | HJY83004.1 | 2838779 | g66291 | i0 | 55 | 0.818181818181818 | 60 | 24 | 77.7 | 3 | 207 | 37 | 248 | 307 | HJY83004.1 hypothetical protein [Candidatus Binatia bacterium] | diamond | 180 | 53.5 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Binatota | Candidatus Binatia | Candidatus Binatia bacterium | |||||
| 32382377 | 32382377 | PRJNA315399_P_NODE_65959_length_221_cov_4.739130_g65511_i0 | PRJNA315399 | 65959 | 221 | 4.73913 | 10.4734773 | Candidatus Binatia bacterium | 2838779 | Bacteria | Bacteria | 99 | 1.48e-22 | NR | HEX9265481.1 | 2838779 | g65511 | i0 | 95.3 | 3 | 43 | 2 | 58.4 | 0 | 217 | 89 | 268 | 310 | HEX9265481.1 amidohydrolase family protein [Candidatus Binatia bacterium] | diamond | 663 | 99 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Binatota | Candidatus Binatia | Candidatus Binatia bacterium | |||||
| 32855470 | 32855470 | PRJNA315399_S_NODE_151860_length_160_cov_4.886179_g151659_i0 | PRJNA315399 | 151860 | 160 | 4.886179 | 7.8178864 | Candidatus Binatia bacterium | 2838779 | Bacteria | Bacteria | 92 | 4.93e-20 | NR | HEX4989716.1 | 2838779 | g151659 | i0 | 95.8 | 0.9 | 48 | 2 | 90 | 0 | 17 | 160 | 300 | 347 | HEX4989716.1 ATP-binding protein [Candidatus Binatia bacterium] | diamond | 144 | 92 | 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);;