The great majority of those songs aren't using any effects (other than some dirt from a tube amp). Here are a couple that are:
Sabotage - old vintage Univox SuperFuzz
Head Like a Hole - actually a synth, I've used the Behringer BSY-600 to cover it in the past
Both POTUSA songs - neither of them are strictly playing bass, actually both played on a guitar through guitar amps. Any sort of overdrive pedal would do.
Know Your Enemy - he kicks on a heavier drive at the end, either the Marshall Guvnor, or some other unknown overdrive pedal.
In the Meantime - I don't think he uses any effects on it at all, but I personally like to click on a subtle chorus during the verse to make the higher notes shimmer a bit. Really fun song to play on the bass.