The weather office issued a red alert for heavy rain and a yellow alert for moderate rain across several districts, with thunderstorms, lightning and winds of 30-40 kmph also expected in parts of the city