as noetsi said, no. Correlation coefficients (Pearson or Spearman) give you two values: A correlation coefficient (Pearson's R or Spearman's Rho) and the P value.

The correlation coefficient shows the extent and direction of the correlation. For example you can find that R = -0.34 P = 0.008. In this example, there is 34% correlation between distance and infection. Note that the sign is negative. Therefore, there is a negative 34% significant correlation, meaning that the shorter the distance, the higher the chance of infection.

However, please note that you should use a Spearman's coefficient, instead of Pearson's. I don't know if you have SPSS or not. But if you had SPSS you could do the followings to run the Spearman. If you have done Pearson's test in Minitab already, I think you won't have difficulty in doing Spearman in Minitab. However, before that, make sure you are dealing with 250 rows in your spreadsheet file (each row for a single specimen), not with 5 rows (not each row for a site).

In your SPSS file, you have 250 cases, right? (5 sites, each with 50 cases, so a total of 250 cases). In your raw data file (with at least 250 rows), just write the distance value for each site, in a new column, besides each of your 250 cases. So for example you need to write the number 524 (the third distance) for 50 times, besides the corresponding rows. Then make sure your column dealing with "infection status" is all 0 and 1. If not, create a new column which contains the infection status of each of 250 cases as 0 and 1. No you have two columns, each has 250 cases, and each row shows a single snail: its infection status (0 and 1) and its distance. Now go to analysis -> correlate -> bivariate, and select Spearman test and select those two columns. The test is now ready to be run.