The Magnetoelectric Effect in Transition Metal Oxides: Insights and the Rational Design of New Materials from First Principles