there has been a fair amount of research published on what spectrum is "best" for growing plants. it is
not the normal solar spectrum, which peaks in the green, because most terrestrial plant chlorophyll can't use yellow through green light. plant leaves are green to reflect away that part of the spectrum which they can't use and which would only add waste heat to the leaves.
the LED systems sold specifically for "indoor plant growth" do not have a significant amount of green light, and instead use a mix of red, IR and blue LEDs -- usually ~3/4 red and 1/4 blue as a base -- which look like they would make the room and tank be a pretty ugly magenta. for example:
http://www.ebay.com/itm/E27-38LED-1...hash=item1c53f34a1f:m:mPlSsggrOJvqXitTm-UPl2A
some add a few white LEDs to make working less unpleasant:
http://www.ebay.com/itm/SunSpect-30...715881?hash=item419e3dab29:g:Kw0AAOSwhcJWKEtw
you could probably get much the same effect by using stripes of the appropriate color, and adding a couple of stripes of white LEDs so you can actually enjoy looking at your setup.
for the OP, they have LED arrays set in a standard E27 edison screw-in bulb -- the first link goes to one such -- although those are as wide or wider than a conventional incandescent bulb and would definitely not fit into a hood designed for the long "hot dog" type bulbs.