Heat trace asymptotics with singular weight functions