In Prometheus, the black goo appears to affect life forms in five different ways.
At the very beginning of the movie, the Space Jockey drinks the black-goo, and it kills him and makes the body decompose very quickly.So it creates human life on earth.
While watching the worm attack, the black-goo mutates into a "cobra-hugger" and it attacked on Milburn's throat.
When Fifield falls into the goo, he later returns as a mutated monster version of himself.
When David spikes Holloway’s drink with a tiny amount of black goo, Holloway appears to follow the same pattern of cell breakdown as the sacrificial Engineer, only at a slower rate.
Also, Shaw impregnate because of black-goo infected Holloway.
Did the black goo affect the different people in different ways? If so, why?