TIP: If your data is not TAB delimited, use Text Manipulation->Convert

Syntax

This tool counts occurrences of unique values in selected column(s).

• If multiple columns are selected, counting is performed on each unique group of all values in the selected columns.
• The first column of the resulting query will be the count of unique values in the selected column(s) and will be followed by each value.

Example

• Input file:

  chr1   10  100  gene1
  chr1  105  200  gene2
  chr1  205  300  gene3
  chr2   10  100  gene4
  chr2 1000 1900  gene5
  chr3   15 1656  gene6
  chr4   10 1765  gene7
  chr4   10 1765  gene8
  

• Counting unique values in column c1 will result in:

  3 chr1
  2 chr2
  1 chr3
  2 chr4
  

• Counting unique values in the grouping of columns c2 and c3 will result in:

  2    10    100
  2    10    1765
  1    1000  1900
  1    105   200
  1    15    1656
  1    205   300