Resistive drift wave turbulence and anomalous transport of multi-species plasma