The N-mount style that comes on your antenna will work fine with this cable
http://www.universal-radio.com/catalog/hamantm/5719.html
It comes with the mount installed, which is made for a 5/8" hole... The SBB-25 is a great antenna for that location because they're pretty ground neutral. I would still meter it to make sure you're getting a low SWR, but it should be fine. I would be wary of putting other antennas that aren't tuned for the mount and require better ground planes.
The only thing that concerns me about that antenna is the Comet's tend to have masts that are more stout than others, and having it in a location where it can find branches or other trail hazards could cause it to bend. They're not as forgiving as whip antennas, but they solve problems that are inherent to whips, such as ground plane issues.