I'm thinking of upgrading the pickups in my epiphone g-400 some time in the future. They are still the stock pickups and I'm playing through a Roland Cube 40xl. I am looking for good to decent cleans for jazz and blues as well as a good distortion.

Right now I'm thinking a Seymour Duncan Jazz in the neck and a Seymour Duncan Distortion for the bridge.

If anybody has any insight in this or suggestions I'd appreciate it.

A better amp is in call for you than a set of new pups.
Damn it! Disable can't use disable to disable Disable's disable because disable's disable has already been disabled by Disable's disable!
Bareknuckle 'Mules' would be a good option as they're incredibly versatile in mahogany guitars.
Gibson Les Paul Studio with Catswhiskers pickups
PRS SE 'Floyd' Custom 24 with Creamery pickups
Fender Standard Stratocaster with DiMarzio pickups
Takamine GN30
BluGuitar AMP1