Quality RG6 will do the job fine in terms of electrical performance, but you’ll want SMA on one end and Type-N on the other.
If you use RG6, you’ll use Type -F connectors and then you’ll need adapters.
I’d use a quality 50Ω cable intended for GHz. LL195 or LMR200 are two common low loss cables available in convenient (RG58) form factor. This will allow you to use the correct connectors direct to the cable.
(don’t use rg58)