From reading a DOE website, it looks like the sigma clearance is the one that relates to weapons, whereas Q maybe is less specific and can include energy production.
I had a clearance doing tech support, but never even saw actual classified materials. But because as IT support we also had to support SCIF facilities, high-ranking officials with potentially sloppy OpSec, etc we obviously still needed clearances.
So, no shit you're speculating, and I very well may have been lied to by the person attempting to recruit me to the NSA. I didn't want to live in secrecy; soon thereafter, Thomas Drake's reports confirmed my suspicion that the NSA wasn't as white-hat as I'd been told.