A freshwater ecosystem in which communities of organisms rely on each other and the water environment for their nutrients and survival.