for example to search all human alpha/beta hydrolase found in human genome enter this search in the window below:
select a, fam, nam, c from a in class Gene_locus,
spec in a->Species where spec.name like "Homo sapiens",
fam in a->Family,
nam in a->Name,
c in count(select a->Structure)
sort by: fam, :nam

for more examples from esther go to AQL esther
for examples from esther on insecticide resistance go to AQL esther resistance
for more examples from wormbase go to AQL wormbase
AQL for the supplementary material of the Pucon Poster Pucon Poster
 
104 rows returned
Gene_locus int Family
myctu-bpoC 3 6_AlphaBeta_hydrolase
myctu-hpx 3 6_AlphaBeta_hydrolase
myctu-lipJ 3 6_AlphaBeta_hydrolase
myctu-lipv 9 6_AlphaBeta_hydrolase
myctu-MT3441 4 6_AlphaBeta_hydrolase
myctu-RV0045C 3 6_AlphaBeta_hydrolase
myctu-Rv0077c 3 6_AlphaBeta_hydrolase
myctu-Rv0272c 3 6_AlphaBeta_hydrolase
myctu-RV0293C 3 6_AlphaBeta_hydrolase
myctu-RV1123C 3 6_AlphaBeta_hydrolase
myctu-Rv1190 2 6_AlphaBeta_hydrolase
myctu-Rv1191 3 6_AlphaBeta_hydrolase
myctu-RV1192 2 6_AlphaBeta_hydrolase
myctu-RV2627C 3 6_AlphaBeta_hydrolase
myctu-RV2695 3 6_AlphaBeta_hydrolase
myctu-rv3177 3 6_AlphaBeta_hydrolase
myctu-Rv3312c 3 6_AlphaBeta_hydrolase
myctu-RV3473C 3 6_AlphaBeta_hydrolase
myctu-Rv3591c 3 6_AlphaBeta_hydrolase
myctu-RV1639C 2 A85-Est-Putative
myctu-RV0519C 2 A85-Feruloyl-Esterase
myctu-RV0774C 2 A85-Feruloyl-Esterase
myctu-a85a 15 A85-Mycolyl-transferase
myctu-a85b 9 A85-Mycolyl-transferase
myctu-a85c 28 A85-Mycolyl-transferase
myctu-mpt51 5 A85-Mycolyl-transferase
myctu-yc88 3 A85-Mycolyl-transferase
myctu-Y2307 2 ABHD13-BEM46
myctu-Rv1069c 12 Abhydrolase_9
myctu-lipG 3 Aclacinomycin-methylesterase_RdmC
myctu-RV2672 3 AlphaBeta_hydrolase
myctu-Rv0220 2 BD-FAE
myctu-Rv1426c 3 BD-FAE
myctu-Rv2284 11 BD-FAE
myctu-Rv2485c 3 BD-FAE
myctu-Rv3569c 3 Carbon-carbon_bond_hydrolase
myctu-Rv2045c 14 Carb_B_Bacteria
myctu-d5yk66 2 Chlorophyllase
myctu-RV1215C 2 Cocaine_esterase
myctu-RV2800 3 Cocaine_esterase
myctu-y1835 6 Cocaine_esterase
myctu-cut3 5 Cutinase
myctu-cutas1 5 Cutinase
myctu-cutas2 5 Cutinase
myctu-RV1758 4 Cutinase
myctu-RV3452 4 Cutinase
myctu-RV3724 5 Cutinase
myctu-Rv3802c 3 Cutinase
myctu-RV2054 2 Dienelactone_hydrolase
myctu-RV2765 3 Dienelactone_hydrolase
myctu-y0571 3 DLH-S
myctu-p71654 10 Duf_1023
myctu-p95011 3 Duf_1023
myctu-y963 13 Duf_1023
myctu-y2079 11 Duf_1023
myctu-ephA 3 Epoxide_hydrolase
myctu-ephB 3 Epoxide_hydrolase
myctu-ephc 2 Epoxide_hydrolase
myctu-ephd 4 Epoxide_hydrolase
myctu-ephE 2 Epoxide_hydrolase
myctu-ephF 2 Epoxide_hydrolase
myctu-YR15 4 Epoxide_hydrolase
myctu-LPQC 2 Esterase_phb
myctu-LPQP 3 Esterase_phb
myctu-MT1628 4 Fungal-Bact_LIP
myctu-Rv1833c 6 Haloalkane_dehalogenase-HLD1
myctu-RV2296 5 Haloalkane_dehalogenase-HLD1
myctu-linb 8 Haloalkane_dehalogenase-HLD2
myctu-metx 15 Homoserine_transacetylase
myctu-Rv0217c 3 Hormone-sensitive_lipase_like
myctu-Rv1076 3 Hormone-sensitive_lipase_like
myctu-Rv1399c 1 Hormone-sensitive_lipase_like
myctu-Rv1400c 3 Hormone-sensitive_lipase_like
myctu-Rv2385 3 Hormone-sensitive_lipase_like
myctu-Rv2970c 3 Hormone-sensitive_lipase_like
myctu-Rv3084 3 Hormone-sensitive_lipase_like
myctu-Rv3097c 4 Hormone-sensitive_lipase_like
myctu-Rv3487c 3 Hormone-sensitive_lipase_like
myctu-LIPS 3 MEST-like
myctu-Y1834 3 MEST-like
myctu-rv0183 3 Monoglyceridelipase_lysophospholip
myctu-RV2854 3 Monoglyceridelipase_lysophospholip
myctu-RV0421C 1 NLS3-Tex30
myctu-ppe42 3 PE-PPE
myctu-ppe63 3 PE-PPE
myctu-Rv1430 4 PE-PPE
myctu-Rv0151c 3 PE-PPE
myctu-Rv0152c 3 PE-PPE
myctu-Rv0159c 3 PE-PPE
myctu-Rv0160c 3 PE-PPE
myctu-Rv1184c 3 PE-PPE
myctu-Rv1800 3 PE-PPE
myctu-Rv3822 3 PE-PPE
myctu-RV1683 5 PHA_synth_III_C
myctu-CNE19725 PMH_Peptidase_S9
myctu-RV0840C 2 Proline_iminopeptidase
myctu-RV0457C 3 S9N_PPCE_Peptidase_S9
myctu-RV0782 4 S9N_PREPL_Peptidase_S9
myctu-MBTB 4 Thioesterase
myctu-PKS6 3 Thioesterase
myctu-PKS13 3 Thioesterase
myctu-yt28 4 Thioesterase
myctu-ym23 4 Tiancimycin-TnmK-Tripeptidase-HIP
myctu-ym24 4 Tiancimycin-TnmK-Tripeptidase-HIP

Send your questions or comments to :
Mail to: Nicolas Lenfant, Thierry Hotelier, Yves Bourne, Pascale Marchot and Arnaud Chatonnet.
Please cite: Lenfant 2013 Nucleic.Acids.Res. or Marchot Chatonnet 2012 Prot.Pept Lett.
For technical information about these pages see:
ESTHER Home Page and ACEDB Home Page
AcePerl Lincoln Stein Home Page
webmaster

Acknowledgements and disclaimer