The magnetoelectric effect in transition metal oxides: Insights and the rational design of new materials from first principles