add query to retrieve submission by seq_num

This is useful because the UI only displays seq number in the list of submissions instead of the submission ID.