Duality spectral sequences for Weierstrass fibrations and applications