Most photosynthetic organisms and certainly all types of macro and micro algae are net sinks for N and P as they build tissue and don't eat a lot of food. Hi
But many organisms that eat chunks of food will be sources, whether those chunks are flakes of fish food or phytoplankton.
I show the math for that issue here:
Foods are by far the most important source of phosphate in most aquariums. In considering whether sources of phosphate other than foods are important, one must carefully look to the actual amounts involved to determine whether other sources are even worth trying to minimize.
reefs.com
Impact of Foods on the Aquarium Phosphate Balance
Now we come to the heart of the issue. The actual amount of phosphorus present in foods and what it means. In order to understand the effects of foods, we need to understand what happens to them when added to an aquarium. Some aquarists are under the misconception that eaten foods do not contribute to the free phosphate in the water. Many aquarists are told the mantra of feeding only as much as is eaten, and they confound this idea with the assumption that when doing so, one minimizes the phosphate release. That idea is simply untrue.
A fish or other organism that eats foods takes in substantial phosphate, as shown above. But what happens to it?
If the organism is not actually expanding in size (such as an adult green chromis, or a person), the phosphate that is taken in is almost entirely excreted back into the water. The only exception to that process is the very small amount of phosphorus that goes into eggs or sperm, and since in most aquaria those items are rapidly consumed by other organisms, the phosphorus will ultimately get into the water.
Growing organisms do take up a small amount of phosphorus from the diet and retain it in their growing tissues, but the emphasis is on small.
A study of a fish farm with rapidly growing rainbow trout in the ocean showed that 78-82% of the phosphorus feed to the fish was lost to the environment. A second aquaculture study using normal fish foods showed that 62% of the fed phosphate was released to the environment, with 35% being released as soluble phosphate available directly to algae, and 27% as phosphorus in fecal pellets (which if not removed, will break down in an aquarium releasing the phosphate again). Another study showed that 81.5% of commercial diet phosphate was released to the environment, but that with a “special” diet with low phosphate and low fish meal this could be reduced to 64% lost. A fourth study showed that growing fish fed slightly less phosphate than they need (to optimize theoretical uptake) take up and retain different phosphate sources differently. Using a purified protein diet, they observed retention of 72% of the phosphorus, 51% retention of phosphorus from added fish bone meal, and higher levels of uptake and retention for inorganic phosphate supplements (such as sodium phosphate).
This sort of study is of concern in aquaculture settings due to environmental contamination due to the released phosphorus and nitrogen. To my knowledge, however, it has never been done in a reef aquarium. Such phosphorus balance studies have also been performed in people for many years. In adults it is clear that nearly all phosphate taken up is excreted, mostly in the urine and some in the feces.
Even in young growing children, the amount of phosphorus retained from the diet is only 5-20% of that consumed, with 80-95% excreted in the urine and feces. While such studies are fairly far removed from reef aquaria, they do supporting the idea that organisms take in a lot more phosphorus than they retain, even when growing.
Consequently,
reef aquarists should expect that much of the phosphorus added to a reef aquarium in the form of foods ultimately ends up in the water as phosphate. Whether that portion getting into the water is 95% or 35% won’t substantially impact the conclusions below that foods add a very large amount of phosphate.