Is a dog an adjective

As a prepositional phrase, it can be either, but more properly an adverb phrase.

He studied the digestive process in dogs. (adjective, meaning of dogs)

The disease is often found in dogs. (adverb)