This is the Cobra Destroyer from Games Workshops Battlefleet Gothic tabletop wargame.
The model was produced by a freind of mine called Mechmaster who gave me permission to use the model. (I will eventually build my own as I don't often like using other peoples models for actual release.
I used photoshop to produce the special effects for the scene though 3dsMax was used to produce the plasma bolt effects before I merged them onto the Cobra herself.
This image was produced for the Battlefleet Gothic modification for Dawn of War as a gift background for the "fans" though we haven't released the mod yet. (Lotsa work going on to remedy this)
Website here: [link]
PS: Yes the name is corny, we jokingly used it in an MSN session and liked it too much to not use it.