Which is the best high detail macro lens for SONY NEX-5 camera?

Look at the lens line-up for the NEX system. If there's a macro lens there, that should be it. If none, you'll be forced to look elsewhere and use an adaptor.