I thought the fish was still there, based on this dialogue from Q in All Good Things: "The anomaly. My ship. My crew. I suppose you're worried about your fish too."