The downward rush of water creates a negative vacuum on the python hose which causes the water in your tank to get siphoned out into the sink.
Actually, if you want to look at this part again, it is not creating a "negative vacum", its creating a pressure difference between the contents inside the tube coming from the tank and the fluid coming out of the faucet. It is created by the fact that there is a fluid with a high velocity moving next to one with a low velocity. The higher velocity fluid has a lower pressure than the fluid with a lower velocity (velocity and pressure are inversely related per Bernouli's principle) this presure differents creates a "pushing" action by the contents in the first mentioned hoes (high pressure seeks low pressure) which draws water from the tank (because now the vluid in the hose has a lower pressure than in the tank). it is similar to a carburator in and engine where the air flowing past a gap creates pressure that draws gas into the carborator.
also, its not nessisarily negative pressure. that part is relative to what pressure you take to be your frame of reference. From the tank hose side, the pressure is lower, so it could be consider negative, although this is not recomended. another reference would be to take the faucet side, then the pressure would not really be seen, because you wohld be suberge in it. or, you could take the atmospheric presure side, wher 0 ATM is the relative reference. then no, it would not be negative, just a difference that creates a force on a fluid.
if you take an absolute vacum to be the absolute lowest pressure, then I don't know how you would get a negative pressure with out getting into quantum physics and wierdstuff with vanishing partical pairs. but beside the point if you know of how to generate a vacume that has lower pressure than 0 ATM, let me know
Sorry for any spelling errors.