I believe that most, if not all rivers that do not flow through a reservation have fishing open to both sport and Tribal commercial at the same time, except where specific treaty issues come into play. In the Columbia river for example, the sport fishing as you know usually happens below Bonneville dam (springer season) and the Tribes net the river above. I don't think that any of the Columbia river treaty tribes offer guided sportfishing in areas where it's not legal for non-Tribals to fish anyway?

I'm not familiar with any situation where a river was closed to sport harvest completely, but was open to Tribal guiding. Except of course the Quinault, or maybe the Sooes, or any river where fisheries decisions for that river are made exclusively by a particular tribe, and the State has no jurisdiction.