Figure 7

Cross-platform analysis of pancreatic cancer data in the database. The goal of this example was to investigate pancreatic expression profiling data obtained using cDNA and oligo arrays and to retrieve the common set of de-regulated genes. One can proceed as follows: 1. Filters: restrict the query by clicking on the "Filters" node on the left. Choose the cancer subtype, for example by expanding the filter section "GENES DIFFERENTIALLY EXPRESSED IN:" and selecting for genes differentially expressed in "Pancreatic adenocarcinoma (PDAC) vs normal pancreas NP (bulk tissue)", expanding the filter section "PLATFORM TECHNOLOGY:" and selecting both "Oligo array" and "cDNA array". 2. Attributes: select attributes by clicking on the "Attributes" node on the left, choosing the "General Gene Features" attribute page, expanding the attribute section "PANCREATIC EXPRESSION" to remove "Gene Symbol", "Differential Expression Analysis" and "Direction of Regulation" default options, expanding the attribute section "GENE" and selecting "Description" under "Ensembl Attributes". 3. Results: hitting the "Count" button retrieves 141 de-regulated genes in cancer when using both oligo and cDNA platforms. One can proceed to saving the whole result set by choosing the appropriate action(s) at the top of the page, for example in an Excel format, and clicking the "Go" button to export the results.