From within Transmit, you can request that a particular file's default action be performed, as if the file had been double-clicked in the Finder. For example, an HTML document will open Safari, or an MP3 will open in iTunes.
To open a file with the Finder, select it, then choose File > Open With FinderOnly local files can be opened with the Finder.