You can't relate Fluorescent light or LED light color temperatures to sunlight color temperatures. Sunlight's spectrum is a smooth curve, with a broad peak offset from the middle. Fluorescent light's spectrum is a series of sharp, narrow peaks, superimposed on a relatively smooth curve. LED light's spectrum is a relatively smooth curve, with a additional broad somewhat narrow peak usually in the blue region. Comparing their different color temperatures is like apples to oranges.
You also can't use CRI as a criteria. CRI is actually just a comparison of the light to that from incandescent bulbs, which don't look good at all as aquarium lights. No fluorescent bulb can have a CRI of 100, but most incandescent bulbs have a CRI of 100.
LED production runs produce individual LEDs with a variety of "color temperatures". They are "binned" in numbered groups according to their color and their intensity. You can buy various bin LEDs to get close to the "color temperature" you want, but it isn't normally specified as a color temperature, but as a chromicity rating.