South Africa's ruling party the African National Congress (ANC) has lost the metropolitan area which includes the capital in its biggest election setback since it took power 22 years ago.