Results Viewer MDA Bioinformatics Section 2/29/02 Developers: Mike Ngugen, Cliff Norris and David Gold Copyright 2002 SUMMARY: Result Viewer is an application designed in the Bioinformatics Section at M.D. Anderson, with the help of Biostatistics programmers, for investigators to browse the data analysis results of their microarray experiments. The application works much like a standard data base query tool in a browser. Records in the analysis results may be extracted by relatively 'high' level gene function or cytoband classification. Gene specific searching is also available. This is a self-extracting stand-alone application. INSTALLATION: 1. Click on the link Download the application and save the ResultViewerSetup.ZIP file in the directory you choose. 2. Unzip ResultViewerSetup.ZIP file, and extract the files to a directory. 3. Find the directory in which you extracted the file, double click on the Setup.exe, and follow the instructions in the installation wizard. If difficulty arises contact: David Gold, dgold@odin.mdacc.tmc.edu LOADING NEW RECORDS: 1. In order to view the records for an analysis, a Database (DB) file for the analysis must be saved to the directory in which you installed Result Viewer. Result Viewer is programmed to only recognize DB's of a specific type. You may view these DB's if you have Access 2000 installed, but you do not need it to run the application. FINDING RECORDS WITH RESULTS VIEWER: 1. Choosing a Data Base (DB) file The first window prompts you to choose a DB. As projects expand you may add more DB's to view by simply saving them to the folder in which you installed Results Viewer. To change DB's, click New Database. 2. The Header Display The header lists important information to each project that should correspond with the name of the DB. 3. Extracting Records You have the option of searching for specific sequence information or to extract a list based on a gene class - function or chromosome. 4. Viewing All Records for a Gene Class For a list, 1st select the radio button for a filtered, sorted list search. Choose a class from the drop down box. You do not need to choose a statistic or set criteria to sort on. 5. Specifying Criteria for Statistics To add criteria for a statistic or several statistics, select a statistic, an operator( >, >=, <, <=, =), and a cutoff. You may also choose to sort the results in ascending or descending order of one of the statistics but it is not required. You may also select the absolute value of a statistic by checking the Absolute Value box. If so, you should see abs('statistic') in the criteria text box. 6. Once you have made your selection choose View. The results are displayed. You may export the table for easier viewing from this window clicking Export. The table will be exported to an Excel Spreadsheet. A new search is performed by clicking New Search. 7. Viewing Records for a Specific Sequence or Gene Select the radio button for a Specific Sequence Search. Choose a gene identifier from the drop down box. Input the correct ID, avoiding spaces. Click View. All sequences with the ID for the identifier selected appear. CONTACT INFORMATION: This version of Results Viewer is the first generation demo. We offer no guarantees and accept no liability. If you have any comments or suggestions about how to improve the Result Viewer contact: David Gold, Statistical Analyst, Dep. of Biostatistics dgold@odin.mdacc.tmc.edu