contig_metadata
16 rows where bioproject = "PRJNA1196438" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 23275350 | 23275350 | PRJNA1196438_P_NODE_43739_length_283_cov_1.485714_g43312_i0 | PRJNA1196438 | 43739 | 283 | 1.485714 | 4.20457062 | Candidatus Binatia bacterium | 2838779 | Bacteria | Bacteria | 187 | 3.8399999999999986e-55 | NR | HEX7226885.1 | 2838779 | g43312 | i0 | 98.9 | 5.97879858657244 | 94 | 1 | 99.6 | 0 | 282 | 1 | 224 | 317 | HEX7226885.1 RecQ family ATP-dependent DNA helicase [Candidatus Binatia bacterium] | diamond | 1692 | 187 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Binatota | Candidatus Binatia | Candidatus Binatia bacterium | |||||
| 27198667 | 27198667 | PRJNA1196438_P_NODE_27082_length_301_cov_4.780702_g26656_i0 | PRJNA1196438 | 27082 | 301 | 4.780702 | 14.38991302 | Candidatus Binatia bacterium | 2838779 | Bacteria | Bacteria | 78.2 | 2.17e-14 | NR | MBY0274263.1 | 2838779 | g26656 | i0 | 73.5 | 0.488372093023256 | 49 | 12 | 48.8 | 1 | 300 | 154 | 219 | 266 | MBY0274263.1 sulfatase [Candidatus Binatia bacterium] | diamond | 147 | 78.2 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Binatota | Candidatus Binatia | Candidatus Binatia bacterium | |||||
| 27325395 | 27325395 | PRJNA1196438_P_NODE_74083_length_244_cov_0.912281_g73656_i0 | PRJNA1196438 | 74083 | 244 | 0.912281 | 2.22596564 | Candidatus Binatia bacterium | 2838779 | Bacteria | Bacteria | 142 | 2.3699999999999997e-37 | NR | HEX7227634.1 | 2838779 | g73656 | i0 | 92.5 | 1.95491803278689 | 80 | 6 | 98.4 | 0 | 242 | 3 | 393 | 472 | HEX7227634.1 SurA N-terminal domain-containing protein [Candidatus Binatia bacterium] | diamond | 477 | 142 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Binatota | Candidatus Binatia | Candidatus Binatia bacterium | |||||
| 27799178 | 27799178 | PRJNA1196438_P_NODE_18484_length_312_cov_3.271967_g18058_i0 | PRJNA1196438 | 18484 | 312 | 3.271967 | 10.20853704 | Candidatus Binatia bacterium | 2838779 | Bacteria | Bacteria | 98.6 | 1.82e-21 | NR | MEX0805335.1 | 2838779 | g18058 | i0 | 62.7 | 2.84615384615385 | 75 | 26 | 72.1 | 1 | 310 | 86 | 197 | 269 | MEX0805335.1 glycosyltransferase family 39 protein [Candidatus Binatia bacterium] | diamond | 888 | 98.6 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Binatota | Candidatus Binatia | Candidatus Binatia bacterium | |||||
| 29220023 | 29220023 | PRJNA1196438_P_NODE_66969_length_250_cov_1.661017_g66542_i0 | PRJNA1196438 | 66969 | 250 | 1.661017 | 4.1525425 | Candidatus Binatia bacterium | 2838779 | Bacteria | Bacteria | 48.9 | 2.6e-4 | NR | HEX2930615.1 | 2838779 | g66542 | i0 | 37.8 | 0.984 | 82 | 46 | 98.4 | 1 | 3 | 248 | 378 | 454 | HEX2930615.1 phosphopantetheine-binding protein [Candidatus Binatia bacterium] | diamond | 246 | 48.9 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Binatota | Candidatus Binatia | Candidatus Binatia bacterium | |||||
| 29472174 | 29472174 | PRJNA1196438_P_NODE_67250_length_250_cov_0.881356_g66823_i0 | PRJNA1196438 | 67250 | 250 | 0.881356 | 2.20339 | Candidatus Binatia bacterium | 2838779 | Bacteria | Bacteria | 82 | 2.97e-17 | NR | HEX6176699.1 | 2838779 | g66823 | i0 | 95.1 | 0.984 | 41 | 2 | 49.2 | 0 | 123 | 1 | 1 | 41 | HEX6176699.1 methylenetetrahydrofolate reductase [Candidatus Binatia bacterium] | diamond | 246 | 82 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Binatota | Candidatus Binatia | Candidatus Binatia bacterium | |||||
| 29851464 | 29851464 | PRJNA1196438_P_NODE_56991_length_262_cov_3.904762_g56564_i0 | PRJNA1196438 | 56991 | 262 | 3.904762 | 10.23047644 | Candidatus Binatia bacterium | 2838779 | Bacteria | Bacteria | 122 | 2.43e-30 | NR | MBY0275008.1 | 2838779 | g56564 | i0 | 84.9 | 2.69083969465649 | 73 | 11 | 83.6 | 0 | 44 | 262 | 10 | 82 | MBY0275008.1 right-handed parallel beta-helix repeat-containing protein [Candidatus Binatia bacterium] | diamond | 705 | 122 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Binatota | Candidatus Binatia | Candidatus Binatia bacterium | |||||
| 30103971 | 30103971 | PRJNA1196438_P_NODE_80152_length_233_cov_4.018750_g79725_i0 | PRJNA1196438 | 80152 | 233 | 4.01875 | 9.3636875 | Candidatus Binatia bacterium | 2838779 | Bacteria | Bacteria | 154 | 5.06e-44 | NR | HEX6436163.1 | 2838779 | g79725 | i0 | 97.3 | 0.952789699570815 | 74 | 2 | 95.3 | 0 | 227 | 6 | 221 | 294 | HEX6436163.1 ornithine cyclodeaminase family protein [Candidatus Binatia bacterium] | diamond | 222 | 154 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Binatota | Candidatus Binatia | Candidatus Binatia bacterium | |||||
| 30167107 | 30167107 | PRJNA1196438_P_NODE_53332_length_268_cov_2.071795_g52905_i0 | PRJNA1196438 | 53332 | 268 | 2.071795 | 5.5524106 | Candidatus Binatia bacterium | 2838779 | Bacteria | Bacteria | 70.5 | 4.63e-12 | NR | HEX9144377.1 | 2838779 | g52905 | i0 | 80.6 | 0.805970149253731 | 36 | 7 | 40.3 | 0 | 268 | 161 | 252 | 287 | HEX9144377.1 amino acid ABC transporter substrate-binding protein [Candidatus Binatia bacterium] | diamond | 216 | 70.5 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Binatota | Candidatus Binatia | Candidatus Binatia bacterium | |||||
| 30641053 | 30641053 | PRJNA1196438_P_NODE_62193_length_255_cov_1.708791_g61766_i0 | PRJNA1196438 | 62193 | 255 | 1.708791 | 4.35741705 | Candidatus Binatia bacterium | 2838779 | Bacteria | Bacteria | 155 | 2.7000000000000002e-45 | NR | HET9880795.1 | 2838779 | g61766 | i0 | 95.2 | 0.988235294117647 | 84 | 4 | 98.8 | 0 | 3 | 254 | 102 | 185 | HET9880795.1 response regulator transcription factor [Candidatus Binatia bacterium] | diamond | 252 | 155 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Binatota | Candidatus Binatia | Candidatus Binatia bacterium | |||||
| 30767614 | 30767614 | PRJNA1196438_P_NODE_48154_length_276_cov_1.955665_g47727_i0 | PRJNA1196438 | 48154 | 276 | 1.955665 | 5.3976354 | Candidatus Binatia bacterium | 2838779 | Bacteria | Bacteria | 178 | 4.19e-53 | NR | HET7392901.1 | 2838779 | g47727 | i0 | 98.9 | 1.97826086956522 | 91 | 1 | 98.9 | 0 | 274 | 2 | 204 | 294 | HET7392901.1 MoxR family ATPase [Candidatus Binatia bacterium] | diamond | 546 | 178 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Binatota | Candidatus Binatia | Candidatus Binatia bacterium | |||||
| 31209453 | 31209453 | PRJNA1196438_P_NODE_54515_length_266_cov_2.409326_g54088_i0 | PRJNA1196438 | 54515 | 266 | 2.409326 | 6.40880716 | Candidatus Binatia bacterium | 2838779 | Bacteria | Bacteria | 169 | 3.94e-50 | NR | MET0501076.1 | 2838779 | g54088 | i0 | 92 | 3.96992481203007 | 88 | 7 | 99.2 | 0 | 265 | 2 | 75 | 162 | MET0501076.1 ferritin-like domain-containing protein [Candidatus Binatia bacterium] | diamond | 1056 | 169 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Binatota | Candidatus Binatia | Candidatus Binatia bacterium | |||||
| 31494747 | 31494747 | PRJNA1196438_P_NODE_69476_length_248_cov_0.891429_g69049_i0 | PRJNA1196438 | 69476 | 248 | 0.891429 | 2.21074392 | Candidatus Binatia bacterium | 2838779 | Bacteria | Bacteria | 180 | 6.919999999999998e-54 | NR | HET9885791.1 | 2838779 | g69049 | i0 | 100 | 1.98387096774194 | 82 | 0 | 99.2 | 0 | 247 | 2 | 107 | 188 | HET9885791.1 tripartite tricarboxylate transporter substrate-binding protein [Candidatus Binatia bacterium] | diamond | 492 | 180 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Binatota | Candidatus Binatia | Candidatus Binatia bacterium | |||||
| 31779127 | 31779127 | PRJNA1196438_P_NODE_45957_length_279_cov_2.902913_g45530_i0 | PRJNA1196438 | 45957 | 279 | 2.902913 | 8.09912727 | Candidatus Binataceae bacterium | 2785449 | Bacteria | Bacteria | 99.4 | 4e-23 | NR | HXR36274.1 | 2785449 | g45530 | i0 | 57.1 | 3.24731182795699 | 77 | 33 | 82.8 | 0 | 49 | 279 | 1 | 77 | HXR36274.1 alpha/beta hydrolase [Candidatus Binataceae bacterium] | diamond | 906 | 99.4 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Binatota | Candidatus Binatia | Candidatus Binatales | Candidatus Binataceae | Candidatus Binataceae bacterium | |||
| 31968997 | 31968997 | PRJNA1196438_P_NODE_58198_length_261_cov_1.377660_g57771_i0 | PRJNA1196438 | 58198 | 261 | 1.37766 | 3.5956926 | Candidatus Binatia bacterium | 2838779 | Bacteria | Bacteria | 45.1 | 0.00693 | NR | HZR81837.1 | 2838779 | g57771 | i0 | 37.2 | 0.896551724137931 | 78 | 39 | 79.3 | 4 | 5 | 211 | 9 | 85 | HZR81837.1 thaumatin family protein [Candidatus Binatia bacterium] | diamond | 234 | 45.1 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Binatota | Candidatus Binatia | Candidatus Binatia bacterium | |||||
| 32380531 | 32380531 | PRJNA1196438_P_NODE_81799_length_230_cov_2.745223_g81372_i0 | PRJNA1196438 | 81799 | 230 | 2.745223 | 6.3140129 | Candidatus Binatia bacterium | 2838779 | Bacteria | Bacteria | 53.5 | 3.72e-6 | NR | HEY1233040.1 | 2838779 | g81372 | i0 | 74.2 | 1.61739130434783 | 31 | 8 | 40.4 | 0 | 96 | 4 | 1 | 31 | HEY1233040.1 GntR family transcriptional regulator [Candidatus Binatia bacterium] | diamond | 372 | 53.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);;