126. Web Based Quality Reporting of Completed DNA Sequencing 

Robert D. Sutherland 
Los Alamos National Laboratory, Los Alamos, New Mexico 
rds@lanl.gov 

I have created a Web based mechanism to report quality statistics on completed DNA sequencing projects. The motivation for this project was to streamline the processing of sequence and phrap quality data to the Web in automated manner for access by the public. This function crosses over facility boundaries and provides a single point of access for all of the JGI sequencing data. Currently, the JGI is required to (1) run quality codes to create the sequencing statistics, (2) transfer summary statistics to an Excel spreadsheet, (3) convert the spreadsheets to HTML and post to the Web. This is costly in time and effort, and the data from all sites cannot be viewed in a single report. 

This new process automates the above steps in a single Web application that will meet the increased growth of sequencing within the JGI. 

The Web implementation of this project is in three parts. The first part connects Perl scripts to the Web to run quality numbers on sequencing projects. This is all done locally at each facility. Once the quality numbers are acceptable, the Web part gathers more information about the project and posts all the data to one common database. The third Web part is the reporting mechanism which can give standard reports or create limited ad hoc queries to see only a portion of the sequencing projects. 

This application utilizes several integrated technologies including the WWW, CGI, and Database engines using HTML, Perl, SQL, and C-shell. 

The reporting part of the application can be accessed at http://jgi.doe.gov. This work is funded by the United States Department of Energy.