Design of pancreatic cancer association studies. The goal of this example was to target SNPs for pancreatic cancer association studies by selecting for coding non-synonymous, validated SNPs with frequency data associated with genes involved in pancreatic cancer. 1. Filter: one can restrict the query by clicking on the "Filters" node on the left and selecting "Up-regulated" from the filter section "PANCREATIC DIFFERENTIAL EXPRESSION INFORMATION:", "Fine needle aspirate vs normal pancreas NP (bulk tissue)" from the filter section "GENES DIFFERENTIALLY EXPRESSED IN:" and "Chromosome 2" from the filter section "GENOMIC REGION". For SNP filters, one can expand the filter section "GENE ASSOCIATED WITH SNP:", select "SNP type" as "coding" from its drop down menu, "Synonymous status" as "Non-synonymous SNPs" from its drop down menu as well as "Associated with validated SNPs" and "Associated with SNPs with frequency data". 2. Attributes: one can click on the "Attributes" node on the left and start choosing attributes on the right from the "Gene SNP associations" attribute page. In this example, one can expand the attribute section "PANCREATIC EXPRESSION" to remove "Differential Expression Analysis" and "Direction of Regulation" default options, expand the attribute section "GENE" to select "Transcript ID" under the "Ensembl Attributes", "Synonymous SNP count" and "Non-synonymous SNP count" under "Gene SNP Attributes", expand the "GENE ASSOCIATED SNPS:" section to select the "Reference ID", "Allele" and "Validation status" under the "SNP Attributes", "Transcript location (bp)", "SNP Chromosome Strand", "Peptide location (aa)" and "Chromosome Location (bp)" under the "SNP Location Attributes:", and finally, "Location in Gene (coding etc)", "Peptide Shift" as well a "Synonymous Status" under the "Gene Location and Effect". 3. Results: one can preview the results by clicking the "Results" button on the toolbar. For particularly intensive queries, which is true in this example, one can use the web file options by entering an email address. An email will then be sent to the given address when the results are ready and one can click on the link in the email to download the results. In this example, results are viewed and filtered with Excel.