No scientist will claim that nitrates are safe for aquatic animals. The only questions are what level, how long, what contributing factors, which species, and what ages. In other words, it's somewhat like aspirin, which is sometimes safe for healthy adults in limited amounts, but still dangerous and lethal in smaller amounts for children or infants, some adults, and in sufficient quantities, almost anyone under certain conditions.
The level that's lethal for nitrate depends on many factors such as age, species, duration, current health, etc. Levels as low as 2-3 ppm will kill eggs. Fry from some species can be impacted at below 10 ppm over time causing death. Amphibians and crustaceans can be impacted at levels that low.
It's important to note that controlled studies are not done on juvenile or adult fish exposed to levels such as 50 - 200 ppm for any extended periods of time, especially with any other contributing factors. E.g., studies don't look at what happens at say 100 ppm exposure for 30 days or longer.
Arguably, fish die indirectly for other reasons at these lower levels as nitrate exposure will reduce the effectiveness of the immune system and appetite. Long term survival or life span might also be reduced at levels that are even lower, but again, no studies have tested that.
Keeping aquatic animals in water with high nitrates is normally avoidable, so it's well worth targeting levels well below 40 ppm, and far lower for sensitive, long-lived, or rare species, and extremely low levels (below 5 ppm) for eggs and fry.