Cloverdale planet
From The Stargate Omnipedia
Planet in a distant galaxy, visited by Destiny's crew and host to a species of virulently aggressive creatures.
The lifeforms -- which appear to have characteristics of both plant and animal life -- attacked the team sent from Destiny and infected Lt. Matthew Scott with their spores, causing him to fall into a dream about another life back home in the small town of Cloverdale.
The last of the away team barely made it off the planet with their lives.
DETAILS
HOME TO - Cloverdale creatures
FIRST APPEARED - Cloverdale
KEY EPISODE
Cloverdale - A team from Destiny visits a planet where Lt. Scott is infected by the indigenous alien creatures.