First-principles studies of spin-orbital physics in pyrochlore oxides