contig_metadata
22 rows where bioproject = "PRJNA393181", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1685261 | 1685261 | PRJNA393181_S_NODE_25962_length_224_cov_2.620321_g25856_i0 | PRJNA393181 | 25962 | 224 | 2.620321 | 5.86951904 | Candidatus Binatia bacterium | 2838779 | Bacteria | Bacteria | 91.7 | 1.58e-19 | NR | MCK6556122.1 | 2838779 | g25856 | i0 | 66.2 | 0.910714285714286 | 68 | 23 | 91.1 | 0 | 223 | 20 | 205 | 272 | MCK6556122.1 glucan biosynthesis protein G [Candidatus Binatia bacterium] | diamond | 204 | 91.7 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Binatota | Candidatus Binatia | Candidatus Binatia bacterium | |||||
| 4238017 | 4238017 | PRJNA393181_S_NODE_4784_length_520_cov_2.643892_g4679_i0 | PRJNA393181 | 4784 | 520 | 2.643892 | 13.7482384 | Candidatus Binatia bacterium | 2838779 | Bacteria | Bacteria | 112 | 1.13e-26 | NR | MET0152385.1 | 2838779 | g4679 | i0 | 44.7 | 0.709615384615385 | 123 | 68 | 71 | 0 | 3 | 371 | 163 | 285 | MET0152385.1 alpha/beta hydrolase [Candidatus Binatia bacterium] | diamond | 369 | 112 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Binatota | Candidatus Binatia | Candidatus Binatia bacterium | |||||
| 8063288 | 8063288 | PRJNA393181_S_NODE_10207_length_378_cov_2.181818_g10101_i0 | PRJNA393181 | 10207 | 378 | 2.181818 | 8.24727204 | Candidatus Binatia bacterium | 2838779 | Bacteria | Bacteria | 174 | 3.68e-48 | NR | HKA31489.1 | 2838779 | g10101 | i0 | 66.7 | 1.96031746031746 | 123 | 35 | 97.6 | 1 | 371 | 3 | 246 | 362 | HKA31489.1 malto-oligosyltrehalose synthase [Candidatus Binatia bacterium] | diamond | 741 | 174 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Binatota | Candidatus Binatia | Candidatus Binatia bacterium | |||||
| 8064364 | 8064364 | PRJNA393181_S_NODE_8787_length_405_cov_2.209239_g8681_i0 | PRJNA393181 | 8787 | 405 | 2.209239 | 8.94741795 | Candidatus Binatota bacterium | 2528255 | Bacteria | Bacteria | 83.6 | 1.17e-15 | NR | MEA2657968.1 | 2528255 | g8681 | i0 | 46.8 | 2.56296296296296 | 111 | 55 | 80.7 | 3 | 8 | 334 | 600 | 708 | MEA2657968.1 hypothetical protein [Candidatus Binatota bacterium] | diamond | 1038 | 83.6 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Binatota | Candidatus Binatota bacterium | ||||||
| 12557112 | 12557112 | PRJNA393181_S_NODE_25150_length_229_cov_1.734375_g25044_i0 | PRJNA393181 | 25150 | 229 | 1.734375 | 3.97171875 | Candidatus Binataceae bacterium | 2785449 | Bacteria | Bacteria | 99.8 | 7.249999999999999e-24 | NR | HLH76134.1 | 2785449 | g25044 | i0 | 64 | 2.94759825327511 | 75 | 27 | 98.3 | 0 | 227 | 3 | 50 | 124 | HLH76134.1 SDR family oxidoreductase [Candidatus Binataceae bacterium] | diamond | 675 | 99.8 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Binatota | Candidatus Binatia | Candidatus Binatales | Candidatus Binataceae | Candidatus Binataceae bacterium | |||
| 14439759 | 14439759 | PRJNA393181_S_NODE_46732_length_152_cov_2.330435_g46626_i0 | PRJNA393181 | 46732 | 152 | 2.330435 | 3.5422612 | Candidatus Binataceae bacterium | 2785449 | Bacteria | Bacteria | 82 | 1.51e-16 | NR | HUA36688.1 | 2785449 | g46626 | i0 | 70 | 0.986842105263158 | 50 | 15 | 98.7 | 0 | 3 | 152 | 104 | 153 | HUA36688.1 radical SAM protein [Candidatus Binataceae bacterium] | diamond | 150 | 82 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Binatota | Candidatus Binatia | Candidatus Binatales | Candidatus Binataceae | Candidatus Binataceae bacterium | |||
| 15713386 | 15713386 | PRJNA393181_S_NODE_37893_length_175_cov_2.666667_g37787_i0 | PRJNA393181 | 37893 | 175 | 2.666667 | 4.66666725 | Candidatus Binatia bacterium | 2838779 | Bacteria | Bacteria | 128 | 2.38e-25 | NTclustered | gi|2621703606|emb|OY761465.1| | 2838779 | g37787 | i0 | 82.781 | 13.3542857142857 | 151 | 18 | 83 | 6 | 30 | 175 | 2403868 | 2404015 | MAG: Candidatus Binatia bacterium isolate d3e24e22-6b5b-4867-8422-75782eed2520 genome assembly, chromosome: 1 | blastn | 2337 | 128 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Binatota | Candidatus Binatia | Candidatus Binatia bacterium | |||||
| 15713760 | 15713760 | PRJNA393181_S_NODE_9053_length_399_cov_3.541436_g8947_i0 | PRJNA393181 | 9053 | 399 | 3.541436 | 14.13032964 | Candidatus Binatia bacterium | 2838779 | Bacteria | Bacteria | 191 | 1.0499999999999995e-55 | NR | HVQ76205.1 | 2838779 | g8947 | i0 | 73.2 | 0.954887218045113 | 127 | 34 | 95.5 | 0 | 381 | 1 | 6 | 132 | HVQ76205.1 amidohydrolase family protein [Candidatus Binatia bacterium] | diamond | 381 | 191 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Binatota | Candidatus Binatia | Candidatus Binatia bacterium | |||||
| 18929822 | 18929822 | PRJNA393181_S_NODE_18435_length_276_cov_2.623431_g18329_i0 | PRJNA393181 | 18435 | 276 | 2.623431 | 7.24066956 | Candidatus Binatia bacterium | 2838779 | Bacteria | Bacteria | 141 | 1.24e-37 | NR | HEY7323064.1 | 2838779 | g18329 | i0 | 78.5 | 2.02173913043478 | 93 | 18 | 98.9 | 1 | 2 | 274 | 352 | 444 | HEY7323064.1 basic amino acid/polyamine antiporter [Candidatus Binatia bacterium] | diamond | 558 | 141 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Binatota | Candidatus Binatia | Candidatus Binatia bacterium | |||||
| 23362802 | 23362802 | PRJNA393181_S_NODE_37439_length_177_cov_1.564286_g37333_i0 | PRJNA393181 | 37439 | 177 | 1.564286 | 2.76878622 | Candidatus Binatia bacterium | 2838779 | Bacteria | Bacteria | 77 | 4.88e-15 | NR | HXP94320.1 | 2838779 | g37333 | i0 | 62.7 | 2 | 59 | 22 | 100 | 0 | 1 | 177 | 80 | 138 | HXP94320.1 DUF1932 domain-containing protein [Candidatus Binatia bacterium] | diamond | 354 | 77 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Binatota | Candidatus Binatia | Candidatus Binatia bacterium | |||||
| 26600162 | 26600162 | PRJNA393181_S_NODE_12321_length_344_cov_2.472313_g12215_i0 | PRJNA393181 | 12321 | 344 | 2.472313 | 8.50475672 | Candidatus Binatia bacterium | 2838779 | Bacteria | Bacteria | 81.6 | 1.04e-16 | NR | HVM84239.1 | 2838779 | g12215 | i0 | 65.5 | 1.55232558139535 | 58 | 20 | 50.6 | 0 | 163 | 336 | 1 | 58 | HVM84239.1 histidine phosphatase family protein [Candidatus Binatia bacterium] | diamond | 534 | 81.6 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Binatota | Candidatus Binatia | Candidatus Binatia bacterium | |||||
| 27833330 | 27833330 | PRJNA393181_S_NODE_6684_length_457_cov_2.840476_g6578_i0 | PRJNA393181 | 6684 | 457 | 2.840476 | 12.98097532 | Candidatus Binatia bacterium | 2838779 | Bacteria | Bacteria | 270 | 2.55e-86 | NR | HVQ76205.1 | 2838779 | g6578 | i0 | 82.1 | 0.991247264770241 | 151 | 27 | 99.1 | 0 | 4 | 456 | 195 | 345 | HVQ76205.1 amidohydrolase family protein [Candidatus Binatia bacterium] | diamond | 453 | 270 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Binatota | Candidatus Binatia | Candidatus Binatia bacterium | |||||
| 28212066 | 28212066 | PRJNA393181_S_NODE_5706_length_486_cov_3.472160_g5600_i0 | PRJNA393181 | 5706 | 486 | 3.47216 | 16.8746976 | Candidatus Binataceae bacterium | 2785449 | Bacteria | Bacteria | 102 | 1.08e-21 | NR | HTR63460.1 | 2785449 | g5600 | i0 | 36.8 | 2.94444444444444 | 155 | 98 | 95.7 | 0 | 18 | 482 | 442 | 596 | HTR63460.1 adenylate/guanylate cyclase domain-containing protein [Candidatus Binataceae bacterium] | diamond | 1431 | 102 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Binatota | Candidatus Binatia | Candidatus Binatales | Candidatus Binataceae | Candidatus Binataceae bacterium | |||
| 28843601 | 28843601 | PRJNA393181_S_NODE_18768_length_273_cov_2.953390_g18662_i0 | PRJNA393181 | 18768 | 273 | 2.95339 | 8.0627547 | Candidatus Binatia bacterium | 2838779 | Bacteria | Bacteria | 69.3 | 1.23e-11 | NR | HKA28224.1 | 2838779 | g18662 | i0 | 40.9 | 0.967032967032967 | 88 | 49 | 93.4 | 1 | 18 | 272 | 142 | 229 | HKA28224.1 M91 family zinc metallopeptidase [Candidatus Binatia bacterium] | diamond | 264 | 69.3 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Binatota | Candidatus Binatia | Candidatus Binatia bacterium | |||||
| 29064904 | 29064904 | PRJNA393181_S_NODE_25028_length_229_cov_4.484375_g24922_i0 | PRJNA393181 | 25028 | 229 | 4.484375 | 10.26921875 | Candidatus Binatus sp. | 2811406 | Bacteria | Bacteria | 93.6 | 3.850000000000001e-21 | NR | HMD04746.1 | 2811406 | g24922 | i0 | 69.7 | 2.98689956331878 | 76 | 23 | 99.6 | 0 | 229 | 2 | 25 | 100 | HMD04746.1 SDR family oxidoreductase [Candidatus Binatus sp.] | diamond | 684 | 93.6 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Binatota | Candidatus Binatia | Candidatus Binatales | Candidatus Binataceae | Candidatus Binatus | Candidatus Binatus sp. | ||
| 29285694 | 29285694 | PRJNA393181_S_NODE_4069_length_552_cov_3.623301_g3968_i0 | PRJNA393181 | 4069 | 552 | 3.623301 | 20.00062152 | Candidatus Binatia bacterium | 2838779 | Bacteria | Bacteria | 137 | 6.7e-36 | NR | MFQ5665439.1 | 2838779 | g3968 | i0 | 55.2 | 1.48369565217391 | 134 | 60 | 72.8 | 0 | 542 | 141 | 176 | 309 | MFQ5665439.1 alpha/beta hydrolase [Candidatus Binatia bacterium] | diamond | 819 | 137 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Binatota | Candidatus Binatia | Candidatus Binatia bacterium | |||||
| 29695888 | 29695888 | PRJNA393181_S_NODE_38970_length_172_cov_2.096296_g38864_i0 | PRJNA393181 | 38970 | 172 | 2.096296 | 3.60562912 | Candidatus Binatus sp. | 2811406 | Bacteria | Bacteria | 72 | 5.97e-13 | NR | HSV05542.1 | 2811406 | g38864 | i0 | 60.4 | 1.77906976744186 | 53 | 21 | 92.4 | 0 | 12 | 170 | 26 | 78 | HSV05542.1 M23 family metallopeptidase [Candidatus Binatus sp.] | diamond | 306 | 72 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Binatota | Candidatus Binatia | Candidatus Binatales | Candidatus Binataceae | Candidatus Binatus | Candidatus Binatus sp. | ||
| 30296943 | 30296943 | PRJNA393181_S_NODE_25372_length_227_cov_3.952632_g25266_i0 | PRJNA393181 | 25372 | 227 | 3.952632 | 8.97247464 | Candidatus Binataceae bacterium | 2785449 | Bacteria | Bacteria | 136 | 6.5399999999999996e-40 | NR | HVA40312.1 | 2785449 | g25266 | i0 | 92 | 0.991189427312775 | 75 | 6 | 99.1 | 0 | 227 | 3 | 1 | 75 | HVA40312.1 DUF2285 domain-containing protein [Candidatus Binataceae bacterium] | diamond | 225 | 136 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Binatota | Candidatus Binatia | Candidatus Binatales | Candidatus Binataceae | Candidatus Binataceae bacterium | |||
| 30707115 | 30707115 | PRJNA393181_S_NODE_11134_length_362_cov_2.036923_g11028_i0 | PRJNA393181 | 11134 | 362 | 2.036923 | 7.37366126 | Candidatus Binatia bacterium | 2838779 | Bacteria | Bacteria | 103 | 1.0399999999999997e-23 | NR | HVQ76878.1 | 2838779 | g11028 | i0 | 55.6 | 2.61049723756906 | 108 | 47 | 89.5 | 1 | 36 | 359 | 147 | 253 | HVQ76878.1 ATP-binding SpoIIE family protein phosphatase [Candidatus Binatia bacterium] | diamond | 945 | 103 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Binatota | Candidatus Binatia | Candidatus Binatia bacterium | |||||
| 31275955 | 31275955 | PRJNA393181_S_NODE_30895_length_201_cov_1.463415_g30789_i0 | PRJNA393181 | 30895 | 201 | 1.463415 | 2.94146415 | Candidatus Binatia bacterium | 2838779 | Bacteria | Bacteria | 50.4 | 3.03e-5 | NR | HTO11535.1 | 2838779 | g30789 | i0 | 46.8 | 0.925373134328358 | 62 | 32 | 92.5 | 1 | 189 | 4 | 1 | 61 | HTO11535.1 iron ABC transporter substrate-binding protein [Candidatus Binatia bacterium] | diamond | 186 | 50.4 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Binatota | Candidatus Binatia | Candidatus Binatia bacterium | |||||
| 31687130 | 31687130 | PRJNA393181_S_NODE_797_length_909_cov_2.811927_g742_i0 | PRJNA393181 | 797 | 909 | 2.811927 | 25.56041643 | Candidatus Binatia bacterium | 2838779 | Bacteria | Bacteria | 102 | 8.37e-23 | NR | HEX9265454.1 | 2838779 | g742 | i0 | 47.4 | 0.735973597359736 | 116 | 58 | 38.3 | 2 | 907 | 560 | 10 | 122 | HEX9265454.1 hypothetical protein [Candidatus Binatia bacterium] | diamond | 669 | 102 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Binatota | Candidatus Binatia | Candidatus Binatia bacterium | |||||
| 32003592 | 32003592 | PRJNA393181_S_NODE_28118_length_213_cov_2.880682_g28012_i0 | PRJNA393181 | 28118 | 213 | 2.880682 | 6.13585266 | Candidatus Binataceae bacterium | 2785449 | Bacteria | Bacteria | 114 | 3.14e-29 | NR | HTW87068.1 | 2785449 | g28012 | i0 | 75.4 | 0.971830985915493 | 69 | 17 | 97.2 | 0 | 211 | 5 | 143 | 211 | HTW87068.1 iron-containing redox enzyme family protein [Candidatus Binataceae bacterium] | diamond | 207 | 114 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Binatota | Candidatus Binatia | Candidatus Binatales | Candidatus Binataceae | Candidatus Binataceae 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);;