Function:
Narrow down the data in your worksheet, allowing you to view only the information you need.
Input:
Upload a tab-delimited file with or without headers.
You can filter the table by designated columns and type which values to be picked out in the box, or upload a filter list in the “filter list” section.
,
文件内容只含有一列
Parameters:
①With header or without header:If the input file contains header, please select “with header”, if not, select “without header”.
②Exact match search: Only filter values exactly the same as your input key words.
③Fuzzy search: Any values containing the key words will be picked out.
Output:
A table with designated rows containing key words.
Example: Test file (click to download): Input table file Filter list file
If you are only looking for 50 genes relative to hyperlipemia from a SNP annotation table of all genes of this patient, you can use this tool to select the genes that you are interested in.
Table 1:
gene | ExonicFunc | 1000G_freq | dbSNP135 |
---|---|---|---|
ATP8B1 | synonymous SNV | 0.99 | rs319438 |
ABCB11 | nonsynonymous SNV | 0.59 | rs2297622 |
TJP2 | synonymous SNV | 0.28 | rs2095876 |
VPS33B | nonsynonymous SNV | 0.77 | rs11073964 |
AMACR | nonsynonymous SNV | 0.29 | rs3195676 |
HSD3B7 | synonymous SNV | 0.49 | rs2305880 |
HSD17B4 | nonsynonymous SNV | 0.40 | rs11205 |
SLC25A13 | synonymous SNV | 0.41 | rs2301629 |
Screening results:
gene | ExonicFunc | 1000G_freq | dbSNP135 |
---|---|---|---|
ATP8B1 | synonymous SNV | 0.99 | rs319438 |
VPS33B | nonsynonymous SNV | 0.77 | rs11073964 |
HSD3B7 | synonymous SNV | 0.49 | rs2305880 |