Progress on MA3 Project

RT103
The order of the probes in both the flash and the chart display were put in
order of the start position of the probe and all the associated data
correspond to each other on the display.

RT113
Sept 10 -
Server is being moved from kiran.homelinex.net to biobase.ist.unomaha.edu server which has
much higher bandwidth available.
new location:
http://biobase.ist.unomaha.edu/KLAB/projects/transcriptomics/MArray/
tasks:
-- back up current microarray database from kiran.homelinux.net
-- download the file to local machine.
-- upload to biobase
-- install psql package for php in biobase
-- setup database and dump the file to the database
-- setup users and adjust permissions to the database
-- copy the source files to biobase
-- added the source files to the new svn server.

RT15
purpose:
enancement to the MA3 tool. Capability to upload .cel files generated from the lab and
automate the process of adding its data to the MA3 database for multiple organisms.
Update:
Developing a model on how the entire process is going to work.
(.cel files are files containing data form an experiment for a given organism.)
1) the .cel (version 4) needs to be converted to .cel (version 3) using a windows program.
the version 3 .cel file is plain text (sample) and version 4 .cell file is binary (sample).
2) the converted file is then parsed by a .pl script and the data is moved to the psql
database.
3) Since the cel file converter is a windows binary application which requires user
interaction, we are developing a windows application in C# which automates the interaction
when a new cel file that needs to be converted is detected.
4)The dev upload site at:
http://biobase.ist.unomaha.edu/KLAB/projects/transcriptomics/MArray/uploader/
5)The CelFileConversionEngine for the Windows server is (CelFileConversionEngine.exe)

can you please replace 'you will be redirected to status page in 7s' with the followoing: Please do not exit, you will be automatically redirected to the the "Status Page"

6) New updates :
----> The windows system and the linux system are connecting via ftp
----> The complete system has been successfully tested.
----> The complete cel file upload system takes 25-30 mins to complete.
----> If new organism is detected, the organism info update process takes
. about 10-20 mins.
----> Made modifications to the query page to be able to select organisms to query on.
----> Created new table organisms which keeps track of the organisms and its record_id.
7) The new organism handler is complete - takes 3 files for the organism to parse into the
---probeinfo table.
---sample files :s_aureus_probe_tab(Probe table file) , s_aureus_target (Target Seq file),
s_aureus_annot.csv(Probeinfo file)

Flow diagram for the cel file upload/conversion/update System

Entity Relation diagram of the microarray query system

Note: Currently the tables being used are matrixinfo_test2, organisminfo_test2, probeinfo_test2.
(for testing and debugging purposes).