What does % in this WHERE clause do?
It is being used as a Modulo Operator; returning the remainder of a number divided by another. 

In your example, the WHERE clause is limiting the results to only those where the Col1 value divided by 3 leaves a remainder of 1. (e.g. 4,7,10, etc.)