At least six people have been killed after an atmospheric river storm brought destructive wind gusts and torrential rain and flooding to California this week.