contig_metadata
17 rows where bioproject = "PRJNA438111", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5538518 | 5538518 | PRJNA438111_P_NODE_89245_length_151_cov_2.877049_g88620_i0 | PRJNA438111 | 89245 | 151 | 2.877049 | 4.34434399 | Candidatus Binatia bacterium | 2838779 | Bacteria | Bacteria | 102 | 1.21e-17 | NTclustered | gi|2814788387|emb|OY762897.2| | 2838779 | g88620 | i0 | 89.024 | 0.543046357615894 | 82 | 9 | 54 | 0 | 14 | 95 | 3316815 | 3316896 | MAG: Candidatus Binatia bacterium isolate 08c4157d-86a7-49cc-8b26-f3076a3ae996 genome assembly, chromosome: 1 | blastn | 82 | 102 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Binatota | Candidatus Binatia | Candidatus Binatia bacterium | |||||
| 17668109 | 17668109 | PRJNA438111_P_NODE_23214_length_224_cov_4.615385_g22589_i0 | PRJNA438111 | 23214 | 224 | 4.615385 | 10.3384624 | Candidatus Binatia bacterium | 2838779 | Bacteria | Bacteria | 92.4 | 6.66e-20 | NR | MFN8544047.1 | 2838779 | g22589 | i0 | 54.1 | 2.97321428571429 | 74 | 34 | 99.1 | 0 | 1 | 222 | 98 | 171 | MFN8544047.1 acetyl-CoA hydrolase/transferase C-terminal domain-containing protein [Candidatus Binatia bacterium] | diamond | 666 | 92.4 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Binatota | Candidatus Binatia | Candidatus Binatia bacterium | |||||
| 27455340 | 27455340 | PRJNA438111_P_NODE_30443_length_210_cov_4.176796_g29818_i0 | PRJNA438111 | 30443 | 210 | 4.176796 | 8.7712716 | Candidatus Binatia bacterium | 2838779 | Bacteria | Bacteria | 56.6 | 3.02e-7 | NR | HEY7316695.1 | 2838779 | g29818 | i0 | 75.8 | 0.928571428571429 | 33 | 8 | 47.1 | 0 | 3 | 101 | 206 | 238 | HEY7316695.1 FAD-dependent oxidoreductase [Candidatus Binatia bacterium] | diamond | 195 | 56.6 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Binatota | Candidatus Binatia | Candidatus Binatia bacterium | |||||
| 28023612 | 28023612 | PRJNA438111_P_NODE_89125_length_151_cov_3.213115_g88500_i0 | PRJNA438111 | 89125 | 151 | 3.213115 | 4.85180365 | Candidatus Binatia bacterium | 2838779 | Bacteria | Bacteria | 75.1 | 3.46e-14 | NR | HEY5542222.1 | 2838779 | g88500 | i0 | 72 | 0.993377483443709 | 50 | 14 | 99.3 | 0 | 151 | 2 | 92 | 141 | HEY5542222.1 class I SAM-dependent methyltransferase [Candidatus Binatia bacterium] | diamond | 150 | 75.1 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Binatota | Candidatus Binatia | Candidatus Binatia bacterium | |||||
| 28054948 | 28054948 | PRJNA438111_P_NODE_31745_length_210_cov_3.635359_g31120_i0 | PRJNA438111 | 31745 | 210 | 3.635359 | 7.6342539 | Candidatus Binatia bacterium | 2838779 | Bacteria | Bacteria | 45.1 | 0.00238 | NR | HYD72575.1 | 2838779 | g31120 | i0 | 56.8 | 0.985714285714286 | 37 | 12 | 47.1 | 1 | 2 | 100 | 125 | 161 | HYD72575.1 transposase [Candidatus Binatia bacterium] | diamond | 207 | 45.1 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Binatota | Candidatus Binatia | Candidatus Binatia bacterium | |||||
| 28149940 | 28149940 | PRJNA438111_P_NODE_62425_length_169_cov_6.392857_g61800_i0 | PRJNA438111 | 62425 | 169 | 6.392857 | 10.80392833 | Candidatus Binatia bacterium | 2838779 | Bacteria | Bacteria | 46.6 | 6.02e-4 | NR | MDZ4342285.1 | 2838779 | g61800 | i0 | 41.8 | 0.976331360946746 | 55 | 32 | 97.6 | 0 | 165 | 1 | 55 | 109 | MDZ4342285.1 type ISP restriction/modification enzyme [Candidatus Binatia bacterium] | diamond | 165 | 46.6 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Binatota | Candidatus Binatia | Candidatus Binatia bacterium | |||||
| 28244318 | 28244318 | PRJNA438111_P_NODE_3066_length_556_cov_4.165085_g2582_i0 | PRJNA438111 | 3066 | 556 | 4.165085 | 23.1578726 | Candidatus Binatia bacterium | 2838779 | Bacteria | Bacteria | 288 | 6.65e-94 | NR | HEX7409794.1 | 2838779 | g2582 | i0 | 74.7 | 9.03237410071942 | 186 | 46 | 99.8 | 1 | 556 | 2 | 171 | 356 | HEX7409794.1 lipid-transfer protein [Candidatus Binatia bacterium] | diamond | 5022 | 288 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Binatota | Candidatus Binatia | Candidatus Binatia bacterium | |||||
| 28591954 | 28591954 | PRJNA438111_P_NODE_53027_length_178_cov_3.758389_g52402_i0 | PRJNA438111 | 53027 | 178 | 3.758389 | 6.68993242 | Candidatus Binatia bacterium | 2838779 | Bacteria | Bacteria | 120 | 1.33e-30 | NR | MET0691959.1 | 2838779 | g52402 | i0 | 98.3 | 1.95505617977528 | 58 | 1 | 97.8 | 0 | 176 | 3 | 17 | 74 | MET0691959.1 UbiD family decarboxylase [Candidatus Binatia bacterium] | diamond | 348 | 120 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Binatota | Candidatus Binatia | Candidatus Binatia bacterium | |||||
| 29034109 | 29034109 | PRJNA438111_P_NODE_39768_length_194_cov_5.745455_g39143_i0 | PRJNA438111 | 39768 | 194 | 5.745455 | 11.1461827 | Candidatus Binatia bacterium | 2838779 | Bacteria | Bacteria | 82 | 2.76e-16 | NR | HYS19367.1 | 2838779 | g39143 | i0 | 65.6 | 2.96907216494845 | 64 | 21 | 99 | 1 | 192 | 1 | 247 | 309 | HYS19367.1 asparagine synthase (glutamine-hydrolyzing) [Candidatus Binatia bacterium] | diamond | 576 | 82 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Binatota | Candidatus Binatia | Candidatus Binatia bacterium | |||||
| 29223482 | 29223482 | PRJNA438111_P_NODE_42049_length_191_cov_3.419753_g41424_i0 | PRJNA438111 | 42049 | 191 | 3.419753 | 6.53172823 | Candidatus Binatia bacterium | 2838779 | Bacteria | Bacteria | 82.4 | 1.55e-16 | NR | HZR79482.1 | 2838779 | g41424 | i0 | 60.3 | 1.97905759162304 | 63 | 25 | 99 | 0 | 189 | 1 | 24 | 86 | HZR79482.1 amidohydrolase family protein [Candidatus Binatia bacterium] | diamond | 378 | 82.4 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Binatota | Candidatus Binatia | Candidatus Binatia bacterium | |||||
| 29728265 | 29728265 | PRJNA438111_P_NODE_88190_length_152_cov_2.089431_g87565_i0 | PRJNA438111 | 88190 | 152 | 2.089431 | 3.17593512 | Candidatus Binatia bacterium | 2838779 | Bacteria | Bacteria | 80.9 | 3.85e-16 | NR | MFN2427010.1 | 2838779 | g87565 | i0 | 80 | 0.986842105263158 | 50 | 10 | 98.7 | 0 | 3 | 152 | 680 | 729 | MFN2427010.1 M16 family metallopeptidase [Candidatus Binatia bacterium] | diamond | 150 | 80.9 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Binatota | Candidatus Binatia | Candidatus Binatia bacterium | |||||
| 29822979 | 29822979 | PRJNA438111_P_NODE_38451_length_196_cov_4.970060_g37826_i0 | PRJNA438111 | 38451 | 196 | 4.97006 | 9.7413176 | Candidatus Binatia bacterium | 2838779 | Bacteria | Bacteria | 52.8 | 5.82e-6 | NR | HEV8715547.1 | 2838779 | g37826 | i0 | 40.6 | 1.05612244897959 | 69 | 23 | 78.1 | 1 | 2 | 154 | 149 | 217 | HEV8715547.1 fatty acid desaturase [Candidatus Binatia bacterium] | diamond | 207 | 52.8 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Binatota | Candidatus Binatia | Candidatus Binatia bacterium | |||||
| 30012898 | 30012898 | PRJNA438111_P_NODE_50691_length_181_cov_1.868421_g50066_i0 | PRJNA438111 | 50691 | 181 | 1.868421 | 3.38184201 | Candidatus Binatia bacterium | 2838779 | Bacteria | Bacteria | 41.6 | 0.0424 | NR | HEY5541911.1 | 2838779 | g50066 | i0 | 50 | 0.662983425414365 | 40 | 18 | 66.3 | 1 | 139 | 20 | 140 | 177 | HEY5541911.1 SUMF1/EgtB/PvdO family nonheme iron enzyme [Candidatus Binatia bacterium] | diamond | 120 | 41.6 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Binatota | Candidatus Binatia | Candidatus Binatia bacterium | |||||
| 31023880 | 31023880 | PRJNA438111_P_NODE_71635_length_163_cov_3.888060_g71010_i0 | PRJNA438111 | 71635 | 163 | 3.88806 | 6.3375378 | Candidatus Binatia bacterium | 2838779 | Bacteria | Bacteria | 51.6 | 9.15e-6 | NR | MBY0276920.1 | 2838779 | g71010 | i0 | 55.8 | 0.957055214723926 | 52 | 23 | 95.7 | 0 | 7 | 162 | 122 | 173 | MBY0276920.1 hypothetical protein [Candidatus Binatia bacterium] | diamond | 156 | 51.6 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Binatota | Candidatus Binatia | Candidatus Binatia bacterium | |||||
| 31055688 | 31055688 | PRJNA438111_P_NODE_29175_length_210_cov_4.906077_g28550_i0 | PRJNA438111 | 29175 | 210 | 4.906077 | 10.3027617 | Candidatus Binatia bacterium | 2838779 | Bacteria | Bacteria | 45.1 | 0.00359 | NR | HEY1233237.1 | 2838779 | g28550 | i0 | 60.6 | 0.928571428571429 | 33 | 13 | 47.1 | 0 | 99 | 1 | 34 | 66 | HEY1233237.1 ADP-polyphosphate phosphotransferase [Candidatus Binatia bacterium] | diamond | 195 | 45.1 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Binatota | Candidatus Binatia | Candidatus Binatia bacterium | |||||
| 31339868 | 31339868 | PRJNA438111_P_NODE_54516_length_177_cov_1.891892_g53891_i0 | PRJNA438111 | 54516 | 177 | 1.891892 | 3.34864884 | Candidatus Binatia bacterium | 2838779 | Bacteria | Bacteria | 74.3 | 1.02e-13 | NR | HVO86863.1 | 2838779 | g53891 | i0 | 65.5 | 1.96610169491525 | 58 | 20 | 98.3 | 0 | 176 | 3 | 333 | 390 | HVO86863.1 trigger factor [Candidatus Binatia bacterium] | diamond | 348 | 74.3 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Binatota | Candidatus Binatia | Candidatus Binatia bacterium | |||||
| 32210424 | 32210424 | PRJNA438111_P_NODE_31838_length_210_cov_3.607735_g31213_i0 | PRJNA438111 | 31838 | 210 | 3.607735 | 7.5762435 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 45.4 | 0.00151 | NR | HKA54428.1 | 2838779 | g31213 | i0 | 73.1 | 1.2 | 26 | 7 | 37.1 | 0 | 189 | 112 | 2 | 27 | HKA54428.1 VOC family protein [Candidatus Binatia bacterium] | diamond | 252 | 45.8 | 0.991266375545852 | 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);;