contig_metadata
20 rows where bioproject = "PRJNA939415" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26898567 | 26898567 | PRJNA939415_P_NODE_13581_length_420_cov_3.080692_g13162_i0 | PRJNA939415 | 13581 | 420 | 3.080692 | 12.9389064 | Candidatus Binataceae bacterium | 2785449 | Bacteria | Bacteria | 213 | 8e-65 | NR | HVB81135.1 | 2785449 | g13162 | i0 | 74.3 | 8 | 140 | 36 | 100 | 0 | 1 | 420 | 76 | 215 | HVB81135.1 radical SAM protein [Candidatus Binataceae bacterium] | diamond | 3360 | 213 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Binatota | Candidatus Binatia | Candidatus Binatales | Candidatus Binataceae | Candidatus Binataceae bacterium | |||
| 27593908 | 27593908 | PRJNA939415_P_NODE_23764_length_317_cov_3.750000_g23343_i0 | PRJNA939415 | 23764 | 317 | 3.75 | 11.8875 | Candidatus Binataceae bacterium | 2785449 | Bacteria | Bacteria | 73.9 | 4.27e-13 | NR | HVB81134.1 | 2785449 | g23343 | i0 | 67.3 | 1.85488958990536 | 49 | 16 | 46.4 | 0 | 170 | 316 | 172 | 220 | HVB81134.1 DUF547 domain-containing protein [Candidatus Binataceae bacterium] | diamond | 588 | 73.9 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Binatota | Candidatus Binatia | Candidatus Binatales | Candidatus Binataceae | Candidatus Binataceae bacterium | |||
| 27625478 | 27625478 | PRJNA939415_P_NODE_20964_length_340_cov_4.711610_g20544_i0 | PRJNA939415 | 20964 | 340 | 4.71161 | 16.019474 | Candidatus Binatia bacterium | 2838779 | Bacteria | Bacteria | 88.2 | 8.61e-18 | NR | MFN8602964.1 | 2838779 | g20544 | i0 | 43.8 | 0.988235294117647 | 112 | 62 | 98.8 | 1 | 5 | 340 | 3 | 113 | MFN8602964.1 glycosyltransferase family 4 protein [Candidatus Binatia bacterium] | diamond | 336 | 88.2 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Binatota | Candidatus Binatia | Candidatus Binatia bacterium | |||||
| 27625587 | 27625587 | PRJNA939415_P_NODE_92724_length_243_cov_2.552941_g92302_i0 | PRJNA939415 | 92724 | 243 | 2.552941 | 6.20364663 | Candidatus Binataceae bacterium | 2785449 | Bacteria | Bacteria | 136 | 4.39e-37 | NR | HVB79258.1 | 2785449 | g92302 | i0 | 76.3 | 0.987654320987654 | 80 | 19 | 98.8 | 0 | 3 | 242 | 66 | 145 | HVB79258.1 hypothetical protein [Candidatus Binataceae bacterium] | diamond | 240 | 136 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Binatota | Candidatus Binatia | Candidatus Binatales | Candidatus Binataceae | Candidatus Binataceae bacterium | |||
| 28162282 | 28162282 | PRJNA939415_P_NODE_61345_length_272_cov_3.376884_g60923_i0 | PRJNA939415 | 61345 | 272 | 3.376884 | 9.18512448 | Candidatus Binatia bacterium | 2838779 | Bacteria | Bacteria | 79.7 | 4.49e-15 | NR | HUS24720.1 | 2838779 | g60923 | i0 | 91.3 | 1.52205882352941 | 46 | 4 | 50.7 | 0 | 2 | 139 | 386 | 431 | HUS24720.1 histidinol dehydrogenase [Candidatus Binatia bacterium] | diamond | 414 | 79.7 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Binatota | Candidatus Binatia | Candidatus Binatia bacterium | |||||
| 28699125 | 28699125 | PRJNA939415_P_NODE_96667_length_239_cov_5.084337_g96245_i0 | PRJNA939415 | 96667 | 239 | 5.084337 | 12.15156543 | Candidatus Binataceae bacterium | 2785449 | Bacteria | Bacteria | 125 | 1.96e-31 | NR | MEA2679134.1 | 2785449 | g96245 | i0 | 67.5 | 1.94560669456067 | 77 | 25 | 96.7 | 0 | 6 | 236 | 423 | 499 | MEA2679134.1 hypothetical protein [Candidatus Binataceae bacterium] | diamond | 465 | 125 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Binatota | Candidatus Binatia | Candidatus Binatales | Candidatus Binataceae | Candidatus Binataceae bacterium | |||
| 29747501 | 29747501 | PRJNA939415_P_NODE_83490_length_250_cov_7.327684_g83068_i0 | PRJNA939415 | 83490 | 250 | 7.327684 | 18.319210000000002 | Candidatus Binatus | 2767079 | Bacteria | Bacteria | 92.8 | 6.33e-20 | NR | MBF6571405.1 | 2785449 | g83068 | i0 | 70.1 | 4.14 | 67 | 20 | 80.4 | 0 | 237 | 37 | 358 | 424 | MBF6571405.1 TolC family protein [Candidatus Binataceae bacterium] | diamond | 1035 | 92.8 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Binatota | Candidatus Binatia | Candidatus Binatales | Candidatus Binataceae | Candidatus Binataceae bacterium | |||
| 30568877 | 30568877 | PRJNA939415_P_NODE_60613_length_273_cov_2.270000_g60191_i0 | PRJNA939415 | 60613 | 273 | 2.27 | 6.1971 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 136 | 4.55e-39 | NR | HTY55813.1 | 2785449 | g60191 | i0 | 64.4 | 6.92307692307692 | 90 | 32 | 98.9 | 0 | 3 | 272 | 22 | 111 | HTY55813.1 VOC family protein [Candidatus Binataceae bacterium] | diamond | 1890 | 137 | 0.992700729927007 | Bacteria | Bacteria candidate phyla | Candidatus Binatota | Candidatus Binatia | Candidatus Binatales | Candidatus Binataceae | Candidatus Binataceae bacterium | |||
| 30878164 | 30878164 | PRJNA939415_P_NODE_67834_length_266_cov_1.595855_g67412_i0 | PRJNA939415 | 67834 | 266 | 1.595855 | 4.2449743 | Candidatus Binatus sp. | 2811406 | Bacteria | Bacteria | 110 | 5.3e-26 | NR | WP_304828478.1 | 2811406 | g67412 | i0 | 61.7 | 1.8609022556391 | 81 | 31 | 91.4 | 0 | 253 | 11 | 83 | 163 | WP_304828478.1 glycoside hydrolase family 44 protein [Candidatus Binatus sp.] | diamond | 495 | 110 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Binatota | Candidatus Binatia | Candidatus Binatales | Candidatus Binataceae | Candidatus Binatus | Candidatus Binatus sp. | ||
| 31036400 | 31036400 | PRJNA939415_P_NODE_20695_length_342_cov_10.237918_g20275_i0 | PRJNA939415 | 20695 | 342 | 10.237918 | 35.01367956 | Candidatus Binataceae bacterium | 2785449 | Bacteria | Bacteria | 87 | 1.06e-17 | NR | HVB79258.1 | 2785449 | g20275 | i0 | 53.4 | 0.640350877192982 | 73 | 34 | 64 | 0 | 120 | 338 | 1 | 73 | HVB79258.1 hypothetical protein [Candidatus Binataceae bacterium] | diamond | 219 | 87 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Binatota | Candidatus Binatia | Candidatus Binatales | Candidatus Binataceae | Candidatus Binataceae bacterium | |||
| 31106174 | 31106174 | PRJNA939415_P_NODE_95935_length_240_cov_5.568862_g95513_i0 | PRJNA939415 | 95935 | 240 | 5.568862 | 13.3652688 | Bacillati | 1783272 | Bacteria | Bacteria | 90.1 | 4.57e-20 | NR | HVR47953.1 | 2838779 | g95513 | i0 | 58.4 | 3.8875 | 77 | 32 | 96.3 | 0 | 233 | 3 | 123 | 199 | HVR47953.1 alpha/beta hydrolase [Candidatus Binatia bacterium] | diamond | 933 | 90.1 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Binatota | Candidatus Binatia | Candidatus Binatia bacterium | |||||
| 31510542 | 31510542 | PRJNA939415_P_NODE_25416_length_310_cov_5.708861_g24994_i0 | PRJNA939415 | 25416 | 310 | 5.708861 | 17.6974691 | Candidatus Binatia bacterium | 2838779 | Bacteria | Bacteria | 84 | 7.46e-17 | NR | HEV7733968.1 | 2838779 | g24994 | i0 | 71.4 | 0.474193548387097 | 49 | 14 | 47.4 | 0 | 149 | 3 | 140 | 188 | HEV7733968.1 oxygenase MpaB family protein [Candidatus Binatia bacterium] | diamond | 147 | 84 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Binatota | Candidatus Binatia | Candidatus Binatia bacterium | |||||
| 31510575 | 31510575 | PRJNA939415_P_NODE_50916_length_283_cov_1.242857_g50494_i0 | PRJNA939415 | 50916 | 283 | 1.242857 | 3.51728531 | Candidatus Binatia bacterium | 2838779 | Bacteria | Bacteria | 77 | 1.49e-16 | NR | MET0644652.1 | 2838779 | g50494 | i0 | 89.5 | 1.75971731448763 | 38 | 4 | 40.3 | 0 | 153 | 266 | 13 | 50 | MET0644652.1 DUF3309 family protein [Candidatus Binatia bacterium] | diamond | 498 | 77 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Binatota | Candidatus Binatia | Candidatus Binatia bacterium | |||||
| 31953097 | 31953097 | PRJNA939415_P_NODE_101477_length_232_cov_4.603774_g101055_i0 | PRJNA939415 | 101477 | 232 | 4.603774 | 10.68075568 | Candidatus Binatia bacterium | 2838779 | Bacteria | Bacteria | 94.4 | 2.26e-20 | NR | MFI5395887.1 | 2838779 | g101055 | i0 | 66.7 | 0.931034482758621 | 72 | 22 | 90.5 | 1 | 214 | 5 | 717 | 788 | MFI5395887.1 exodeoxyribonuclease V subunit beta [Candidatus Binatia bacterium] | diamond | 216 | 94.4 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Binatota | Candidatus Binatia | Candidatus Binatia bacterium | |||||
| 32048175 | 32048175 | PRJNA939415_P_NODE_18258_length_365_cov_1.184932_g17838_i0 | PRJNA939415 | 18258 | 365 | 1.184932 | 4.3250018 | Candidatus Binatia bacterium | 2838779 | Bacteria | Bacteria | 182 | 5.22e-53 | NR | HVN84295.1 | 2838779 | g17838 | i0 | 72.7 | 0.994520547945206 | 121 | 33 | 99.5 | 0 | 365 | 3 | 301 | 421 | HVN84295.1 OprD family outer membrane porin [Candidatus Binatia bacterium] | diamond | 363 | 182 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Binatota | Candidatus Binatia | Candidatus Binatia bacterium | |||||
| 32048236 | 32048236 | PRJNA939415_P_NODE_62798_length_271_cov_1.904040_g62376_i0 | PRJNA939415 | 62798 | 271 | 1.90404 | 5.1599484 | Candidatus Binatia bacterium | 2838779 | Bacteria | Bacteria | 75.1 | 1.87e-13 | NR | MEO6026918.1 | 2838779 | g62376 | i0 | 46.6 | 2.35793357933579 | 73 | 39 | 80.8 | 0 | 3 | 221 | 347 | 419 | MEO6026918.1 DUF1302 family protein [Candidatus Binatia bacterium] | diamond | 639 | 75.1 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Binatota | Candidatus Binatia | Candidatus Binatia bacterium | |||||
| 32079742 | 32079742 | PRJNA939415_P_NODE_35918_length_302_cov_3.331878_g35496_i0 | PRJNA939415 | 35918 | 302 | 3.331878 | 10.06227156 | Candidatus Binatia bacterium | 2838779 | Bacteria | Bacteria | 94.4 | 5.7e-20 | NR | HJY80704.1 | 2838779 | g35496 | i0 | 52.5 | 0.983443708609272 | 99 | 45 | 98.3 | 1 | 297 | 1 | 520 | 616 | HJY80704.1 bifunctional YncE family protein/alkaline phosphatase family protein [Candidatus Binatia bacterium] | diamond | 297 | 94.4 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Binatota | Candidatus Binatia | Candidatus Binatia bacterium | |||||
| 32143123 | 32143123 | PRJNA939415_P_NODE_24158_length_314_cov_3.070539_g23737_i0 | PRJNA939415 | 24158 | 314 | 3.070539 | 9.64149246 | Candidatus Binataceae bacterium | 2785449 | Bacteria | Bacteria | 89.4 | 3.67e-18 | NR | HVB79420.1 | 2785449 | g23737 | i0 | 72.9 | 1.13694267515924 | 59 | 16 | 56.4 | 0 | 2 | 178 | 541 | 599 | HVB79420.1 ATP-binding protein [Candidatus Binataceae bacterium] | diamond | 357 | 89.4 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Binatota | Candidatus Binatia | Candidatus Binatales | Candidatus Binataceae | Candidatus Binataceae bacterium | |||
| 32174893 | 32174893 | PRJNA939415_P_NODE_13238_length_426_cov_1.560907_g12819_i0 | PRJNA939415 | 13238 | 426 | 1.560907 | 6.64946382 | Candidatus Binataceae bacterium | 2785449 | Bacteria | Bacteria | 75.1 | 1.36e-12 | NR | HUO04889.1 | 2785449 | g12819 | i0 | 49.4 | 1.16197183098592 | 83 | 24 | 50 | 3 | 125 | 337 | 39 | 115 | HUO04889.1 choice-of-anchor D domain-containing protein [Candidatus Binataceae bacterium] | diamond | 495 | 75.1 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Binatota | Candidatus Binatia | Candidatus Binatales | Candidatus Binataceae | Candidatus Binataceae bacterium | |||
| 32617408 | 32617408 | PRJNA939415_P_NODE_10320_length_488_cov_2.310843_g9902_i0 | PRJNA939415 | 10320 | 488 | 2.310843 | 11.27691384 | Candidatus Binatia bacterium | 2838779 | Bacteria | Bacteria | 102 | 5.31e-23 | NR | MEX0805729.1 | 2838779 | g9902 | i0 | 61.4 | 0.540983606557377 | 88 | 34 | 54.1 | 0 | 3 | 266 | 216 | 303 | MEX0805729.1 TIR domain-containing protein [Candidatus Binatia bacterium] | diamond | 264 | 102 | 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);;