I am very new to Houdini , after looking at https://vimeo.com/145607570, [vimeo.com] I successfully created the lava with colour change using pyro black body. However, I wish to export this into Maya because I want to render it using V-ray (I am running out of time to learn Houdini). Is there a way to export the mesh with the colour change from Houdini into Maya? Does pyro black body only work with Mantra?

Hello.
You can use Houdini Engine to do that.
there are lots of tutorials in internet to how to do that.