| Orth | Species | Gene | Name | Description | Fitness | %Id | Cov |
| | Pseudomonas fluorescens FW300-N2E2 | Pf6N2E2_759 | | HMP-PP hydrolase (pyridoxal phosphatase) Cof, detected in genetic screen for thiamin metabolic genes (PMID:15292217) | insig. | 100 | 100 |
| o | Pseudomonas sp. RS175 | PFR28_01675 | | Sugar phosphatase YidA | insig. | 93 | 100 |
| o | Pseudomonas fluorescens FW300-N2C3 | AO356_27845 | | hydrolase | insig. | 96 | 100 |
| o | Pseudomonas fluorescens FW300-N1B4 | Pf1N1B4_4727 | | HMP-PP hydrolase (pyridoxal phosphatase) Cof, detected in genetic screen for thiamin metabolic genes (PMID:15292217) | insig. | 81 | 100 |
| o | Pseudomonas sp. DMC3 | GFF3449 | | Sugar phosphatase YidA | insig. | 76 | 100 |
| o | Pseudomonas fluorescens SBW25 | PFLU_RS13145 | | Cof-type HAD-IIB family hydrolase | insig. | 75 | 99 |
| o | Pseudomonas fluorescens SBW25-INTG | PFLU_RS13145 | | Cof-type HAD-IIB family hydrolase | insig. | 75 | 99 |
| o | Pseudomonas lactucae CFBP13502 | GEMAOFIL_02738 | | Pyridoxal phosphate phosphatase YigL | cofit | 75 | 99 |
| o | Pseudomonas simiae WCS417 | PS417_12455 | | hydrolase | insig. | 73 | 99 |
| o | Pseudomonas orientalis W4I3 | QF045_RS17455 | | HAD family hydrolase | cofit | 72 | 99 |
| o | Pseudomonas syringae pv. syringae B728a | Psyr_2987 | | Cof protein:HAD-superfamily hydrolase, subfamily IIB | insig. | 59 | 98 |
| o | Pseudomonas syringae pv. syringae B728a ΔmexB | Psyr_2987 | | Cof protein:HAD-superfamily hydrolase, subfamily IIB | insig. | 59 | 98 |
| o | Rhodopseudomonas palustris CGA009 | TX73_018860 | | Cof-type HAD-IIB family hydrolase | insig. | 37 | 98 |
| o | Bacteroides stercoris CC31F | HMPREF1181_RS02400 | | Cof-type HAD-IIB family hydrolase | insig. | 32 | 99 |
| | Bacteroides stercoris CC31F | HMPREF1181_RS11870 | | Cof-type HAD-IIB family hydrolase | insig. | 28 | 97 |
| | Bacteroides thetaiotaomicron VPI-5482 | BT4699 | | putative hydrolase, haloacid dehalogenase-like hydrolase (NCBI ptt file) | strong | 29 | 97 |
| o | Synechocystis sp000284455 PCC 6803 | SGL_RS11635 | | HAD family hydrolase | strong | 30 | 98 |
| | Bacteroides ovatus ATCC 8483 | BACOVA_05549 | | Cof-like hydrolase | strong | 28 | 97 |
| | Bacteroides ovatus ATCC 8483 | BACOVA_01965 | | Cof-like hydrolase | insig. | 28 | 99 |
| o | Pectobacterium carotovorum WPP14 | HER17_RS01415 | | sugar/pyridoxal phosphate phosphatase YigL | cofit | 30 | 87 |
| | Parabacteroides merdae CL09T00C40 | HMPREF1078_RS08065 | | Cof-type HAD-IIB family hydrolase | cofit | 27 | 97 |
| o | Erwinia tracheiphila HP pepo 2.2 | IJEDHG_08715 | yigL | sugar/pyridoxal phosphate phosphatase YigL | cofit | 30 | 87 |
| o | Erwinia tracheiphila SCR3 | LU632_RS24075 | yigL | sugar/pyridoxal phosphate phosphatase YigL | sig. | 30 | 87 |
| o | Dickeya dianthicola 67-19 | HGI48_RS21005 | | sugar-phosphatase | insig. | 29 | 98 |
| o | Dickeya dianthicola ME23 | DZA65_RS21990 | | sugar-phosphatase | insig. | 29 | 98 |
| o | Klebsiella michiganensis M5al | BWI76_RS27955 | | sugar-phosphatase | insig. | 29 | 98 |
| o | Escherichia coli HS(pFamp)R (ATCC 700891) | OHPLBJKB_00006 | | Sugar phosphatase YidA | insig. | 29 | 98 |
| o | Dickeya dadantii 3937 | DDA3937_RS00365 | | sugar-phosphatase | insig. | 28 | 98 |
| o | Klebsiella pneumoniae MKP103 | KDGMDA_08660 | | sugar-phosphatase | insig. | 30 | 98 |
| o | Rahnella sp. WP5 | EX31_RS05965 | | sugar-phosphatase | insig. | 29 | 98 |
| | Bacteroides thetaiotaomicron VPI-5482 | BT3352 | | haloacid dehalogenase-like hydrolase (NCBI ptt file) | sig. | 27 | 98 |
| o | Pantoea sp. MT58 | IAI47_00025 | | sugar-phosphatase | insig. | 30 | 98 |
| o | Salmonella enterica subsp. enterica serovar Typhimurium str. MS1868 | GFF252 | | Cof protein, HD superfamily hydrolase | insig. | 30 | 87 |
| o | Escherichia coli BL21 | ECD_03580 | | sugar phosphate phosphatase | sig. | 28 | 98 |
| o | Escherichia fergusonii Becca | EFB2_00006 | | Sugar phosphatase YidA | insig. | 28 | 98 |
| o | Escherichia coli ECOR38 | HEPCGN_13750 | yidA | sugar-phosphatase | insig. | 28 | 98 |
| o | Escherichia coli ECRC62 | BNILDI_04345 | yidA | sugar-phosphatase | cofit | 28 | 98 |
| o | Escherichia coli Nissle 1917 | ECOLIN_RS21290 | | sugar-phosphatase | insig. | 28 | 98 |
| o | Escherichia coli BW25113 | b3697 | yidA | predicted hydrolase (NCBI) | insig. | 28 | 98 |
| o | Pontibacter actiniarum KMM 6156, DSM 19842 | CA264_18645 | | haloacid dehalogenase | insig. | 28 | 97 |
| o | Enterobacter asburiae PDN3 | EX28DRAFT_3983 | | HAD-superfamily hydrolase, subfamily IIB | insig. | 28 | 98 |
| o | Serratia liquefaciens MT49 | IAI46_00025 | | sugar-phosphatase | insig. | 27 | 98 |
| | Escherichia coli BL21 | ECD_03705 | | pyridoxal phosphate phosphatase | insig. | 30 | 87 |
| | Escherichia fergusonii Becca | EFB2_04811 | | Pyridoxal phosphate phosphatase YigL | insig. | 30 | 87 |
| | Escherichia coli ECOR38 | HEPCGN_13040 | yigL | sugar/pyridoxal phosphate phosphatase YigL | insig. | 30 | 87 |
| o | Escherichia coli ECRC101 | MCAODC_04845 | yigL | sugar/pyridoxal phosphate phosphatase YigL | insig. | 30 | 87 |
| | Escherichia coli ECRC62 | BNILDI_05060 | yigL | sugar/pyridoxal phosphate phosphatase YigL | insig. | 30 | 87 |
| o | Escherichia coli ECRC98 | JDDGAC_17965 | yigL | sugar/pyridoxal phosphate phosphatase YigL | insig. | 30 | 87 |
| o | Escherichia coli ECRC99 | KEDOAH_13810 | yigL | sugar/pyridoxal phosphate phosphatase YigL | no data | 30 | 87 |
| | Escherichia coli HS(pFamp)R (ATCC 700891) | OHPLBJKB_04225 | | Pyridoxal phosphate phosphatase YigL | insig. | 30 | 87 |
| | Escherichia coli BW25113 | b3826 | yigL | predicted hydrolase (NCBI) | insig. | 30 | 87 |
| | Salmonella enterica subsp. enterica serovar Typhimurium str. MS1868 | GFF1761 | | Promiscuous sugar phosphatase YidA, haloacid dehalogenase-like phosphatase family | insig. | 29 | 98 |
| o | Escherichia coli ECOR27 | NOLOHH_06470 | yigL | sugar/pyridoxal phosphate phosphatase YigL | insig. | 30 | 87 |
| o | Enterobacter sp. TBS_079 | MPMX20_00007 | | Sugar phosphatase YidA | insig. | 27 | 98 |
| | Enterobacter sp. TBS_079 | MPMX20_04454 | | Pyridoxal phosphate phosphatase YigL | insig. | 30 | 87 |
| | Escherichia coli ECOR27 | NOLOHH_07185 | yidA | sugar-phosphatase | insig. | 28 | 98 |
| o | Escherichia coli ECRC100 | OKFHMN_15045 | yidA | sugar-phosphatase | insig. | 28 | 98 |
| | Escherichia coli ECRC101 | MCAODC_05555 | yidA | sugar-phosphatase | insig. | 28 | 98 |
| o | Escherichia coli ECRC102 | NIAGMN_12800 | yidA | sugar-phosphatase | insig. | 28 | 98 |
| | Escherichia coli ECRC98 | JDDGAC_18665 | yidA | sugar-phosphatase | insig. | 28 | 98 |
| | Escherichia coli ECRC99 | KEDOAH_13105 | yidA | sugar-phosphatase | no data | 28 | 98 |
| | Enterobacter asburiae PDN3 | EX28DRAFT_4491 | | HAD-superfamily hydrolase, subfamily IIB | insig. | 30 | 87 |
| | Escherichia coli Nissle 1917 | ECOLIN_RS21965 | | sugar/pyridoxal phosphate phosphatase YigL | no data | 30 | 87 |
| | Escherichia coli ECRC100 | OKFHMN_14340 | yigL | sugar/pyridoxal phosphate phosphatase YigL | cofit | 30 | 87 |
| | Escherichia coli ECRC102 | NIAGMN_12095 | yigL | sugar/pyridoxal phosphate phosphatase YigL | cofit | 30 | 87 |
| o | Pantoea agglomerans CFBP13505 P0401 | PagCFBP13505_RS19290 | | sugar-phosphatase | cofit | 29 | 98 |
| | Serratia liquefaciens MT49 | IAI46_00790 | | sugar/pyridoxal phosphate phosphatase YigL | insig. | 28 | 88 |
| | Pantoea agglomerans CFBP13505 P0401 | PagCFBP13505_RS10585 | | HMP-PP phosphatase | insig. | 30 | 89 |
| | Bacteroides thetaiotaomicron VPI-5482 | BT1666 | | hydrolase, haloacid dehalogenase-like hydrolase (NCBI ptt file) | insig. | 29 | 97 |
| o | Vibrio cholerae E7946 ATCC 55056 | CSW01_00680 | | Cof-type HAD-IIB family hydrolase | insig. | 27 | 90 |
| | Dickeya dianthicola ME23 | DZA65_RS21025 | | sugar/pyridoxal phosphate phosphatase YigL | insig. | 28 | 87 |
| | Klebsiella pneumoniae MKP103 | KDGMDA_14655 | | HMP-PP phosphatase | insig. | 31 | 85 |
| | Dickeya dianthicola 67-19 | HGI48_RS19980 | | sugar/pyridoxal phosphate phosphatase YigL | cofit | 28 | 87 |
| | Escherichia coli ECRC100 | OKFHMN_08285 | cof | HMP-PP phosphatase | cofit | 30 | 87 |
| | Escherichia coli ECRC101 | MCAODC_27510 | cof | HMP-PP phosphatase | insig. | 30 | 87 |
| | Escherichia coli ECRC102 | NIAGMN_06340 | cof | HMP-PP phosphatase | cofit | 30 | 87 |
| | Escherichia coli ECRC98 | JDDGAC_11940 | cof | HMP-PP phosphatase | insig. | 30 | 87 |
| | Escherichia coli ECRC99 | KEDOAH_19680 | cof | HMP-PP phosphatase | no data | 30 | 87 |
| o | Phocaeicola vulgatus CL09T03C04 | HMPREF1058_RS04265 | | Cof-type HAD-IIB family hydrolase | strong | 28 | 99 |
| | Escherichia coli Nissle 1917 | ECOLIN_RS02670 | | HMP-PP phosphatase | insig. | 30 | 87 |
| | Dickeya dadantii 3937 | DDA3937_RS19825 | | sugar/pyridoxal phosphate phosphatase YigL | insig. | 28 | 87 |
| o | Erwinia amylovora T8 | OLJFJH_06460 | | sugar/pyridoxal phosphate phosphatase YigL | insig. | 28 | 88 |
| | Pantoea sp. MT58 | IAI47_14610 | | HMP-PP phosphatase | insig. | 30 | 89 |
| o | Phocaeicola dorei CL03T12C01 | ABI39_RS16940 | | Cof-type HAD-IIB family hydrolase | sig. | 28 | 99 |
| | Klebsiella michiganensis M5al | BWI76_RS01265 | | sugar/pyridoxal phosphate phosphatase YigL | insig. | 28 | 87 |
| | Escherichia coli BL21 | ECD_00398 | | thiamine pyrimidine pyrophosphate hydrolase; HMP-PP phosphatase | insig. | 30 | 87 |
| | Escherichia fergusonii Becca | EFB2_03611 | | HMP-PP phosphatase | insig. | 30 | 87 |
| | Escherichia coli ECOR27 | NOLOHH_01220 | cof | HMP-PP phosphatase | insig. | 30 | 87 |
| | Escherichia coli ECOR38 | HEPCGN_06900 | cof | HMP-PP phosphatase | insig. | 30 | 87 |
| | Escherichia coli ECRC62 | BNILDI_22635 | cof | HMP-PP phosphatase | cofit | 30 | 87 |
| | Escherichia coli HS(pFamp)R (ATCC 700891) | OHPLBJKB_03227 | | HMP-PP phosphatase | insig. | 30 | 87 |
| | Escherichia coli BW25113 | b0446 | cof | orf, hypothetical protein (VIMSS) | insig. | 30 | 87 |
| | Pantoea agglomerans CFBP13505 P0401 | PagCFBP13505_RS15315 | | sugar/pyridoxal phosphate phosphatase YigL | cofit | 28 | 87 |
| | Pectobacterium carotovorum WPP14 | HER17_RS00065 | | sugar-phosphatase | insig. | 27 | 98 |
| | Bacteroides ovatus ATCC 8483 | BACOVA_04941 | | Cof-like hydrolase | insig. | 26 | 96 |
| | Rahnella sp. WP5 | EX31_RS22290 | | HMP-PP phosphatase | insig. | 30 | 88 |
| | Vibrio cholerae E7946 ATCC 55056 | CSW01_06865 | | Cof-type HAD-IIB family hydrolase | cofit | 27 | 97 |
| | Erwinia amylovora T8 | OLJFJH_05140 | | sugar-phosphatase | insig. | 27 | 98 |
| | Enterobacter asburiae PDN3 | EX28DRAFT_2524 | | HAD-superfamily hydrolase, subfamily IIB | insig. | 29 | 85 |
| | Bacteroides ovatus ATCC 8483 | BACOVA_02204 | | Cof-like hydrolase | insig. | 28 | 95 |