The 1-1337481-0: The 4 GHz max frequency is the point where the insertion loss hits 0.6 dB — above that the signal degrades faster than the interface can hold. For a 50 Ohm system, the right-angle launch introduces a small impedance discontinuity at the pin-to-trace transition, so keep the microstrip or coplanar waveguide width matched to the centre pin diameter. The 500-cycle rating tells you the gold-on-gold contact pair is thick enough to survive repeated snap-on engagements without the centre pin losing spring force — a common failure in cheaper SMBs that use flash plating.
The shield termination is solder.