Guillaume Berthommier ¹ , Dominique Santiard-Baron ², Olivier Poch¹ and Raymond Ripp ¹

1. Clinical Data Patient data are available through connection to the different centres. Level 1 querying is centralized. Login to the Genoret Database and give your password. Now you are recognised by the system. This allows ownership of data and access rights. Browse and Search through the Genoret website links and query tools, within the centralised information or connect to external databases. Contact easily any sub-group of Genoret members, copy-paste their mail addresses. If you need to have access to protected data send a mail to the owner and get authorisation. Upload your own data. For this, go to the right Gallery and open the UploadForm  select your file, choose a visibility group and fill in title and description. Submit. Annotate your images, diagrams or any other kind of stuctured informationwith the standardised annotion tool ImAnno. Query within Genoret and all related databases through complex and elaborated querying tools. Create yourself new queries and share them with the genoret community. Display through well formatted pages or graphical visualisation tools the results of your query. Retrieve it easily in Excel format. Mutations The retinal related mutations are stored and analysed in our database. Genoret Genes Transcriptomics and proteomics Genes are central, ………………………….… links are established ……………………. to almost all other ……………… kind of information integrated in the database. The EVI-Genoret Database – WP16 http://www-genoret.u-strasbg.fr/genoret Guillaume Berthommier¹, Dominique Santiard-Baron², Olivier Poch¹ and Raymond Ripp¹ ¹ Laboratoire de BioInformatique et Génomique Intégratives IGBMC (CNRS – UMR 7104), 1 rue Laurent Fries, Illkirch 67404, Strasbourg France ² Laboratoire de Physiopathologie Cellulaire et Moléculaire de la Rétine Inserm U592 184 rue du Faubourg Saint-Antoine 75571 PARIS Cedex 12 The aim of the Genoret Database is to centralise phenotypic, genomic and proteomic data concerning retinal diseases as well as data concerning patients. This should allow implementation of standards and permit the establishment of common information networking systems. The Genoret Database is a Relational Database whose advantage is to store heterogeneous data in a standard format. It provides an easy manual or automatic access, allowing direct deposits focused on workpackages and workpackage deliverables. 120 People – 24 Centres - 4693 patient data – 25 transcriptomics experiments – 3699 Genoret Genes – 434 raw datafiles – 50 SOPs 902 annotated ISH images – 28 Publications – 22 Importants Documents – 40 000 lines of PHP, Javascript, Tcl – 1720 emails People Database Results Genomics : OMIM, Mutations, Genetic linkage, SNPs, MiRNA, … Uploading Mail Reporting Online Who’s who Phenotyping Database RetScope protocols Transcriptomics, Proteomics, RetChip External Clinical Data WebSphere … your own database WPs & Components A Phenotyping B Development C Genetics D Therapy E Functional Genomics T Transversal WebSphere Information Integrator Genoret Database Centres are directly queried through secure connections using SSL and WebSphere. Groups of members can be defined to allow precise access rights. A group can be a WP, a set of users or a set of other groups. The hierachical tree organisation of SOPs and raw datafiles is used to store the user uploaded datafiles and offers an interactive tool for uploading and retrieval for various domains such as : SOPs, Meetings, Training, Reports, Publications, … ImAnno Eye Fundus and ISH annotation EVI-GENORET Integrated Project LSHG-CT-2005-512036