Data filter





Select a file *  Example

With header Without header

生物云平台


Filter by which column (put column number here): *


Preserve row order same as input file Customize row order same as filter list

Input list of value to filter (filter list):



Select a file tips:文件只能包含一列

  Email me when task completed.

 The number of coins consumed at one time is 1



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