A systematic study of low mass X-ray binaries in the M31 globular cluster system