Q: Is there a metabolite localization database for a model organism?
How: literature mining, MALDI imaging, Raman-spectroscopy based methods such as Coherent Anti-Stokes Raman Scattering,..
Links, input and feedback of the biostar commmunity is as always dearly appreciated.
I think you could indeed assume that proteins will generally be near the site of the metabolites they interact with, but if the metabolite is formed by an enzyme reaction it might move away fast. Biotransformation (drug metabolizing) enzymes are a classic example. They catch lipophilic metabolites which are getting more hydrophilic and move away.
It seems the cellular location information is missing from the HMDB 3.5 XML export :(