MORGAM Manual

Data transfer format - MORGAM polymorphisms Form: 51 Version: 6 Date: 2011-01-14

© National Institute for Health and Welfare and the MORGAM Project investigators Last updated: 2011-01-14 For more information, please contact Päivi Laiho (firstname.lastname@thl.fi), Ari Haukijärvi (ari.haukijarvi@thl.fi) or Kari Kuulasmaa (kari.kuulasmaa@thl.fi)

The purpose of this transfer format is to provide an exact and common format for the MORGAM Genotyping Laboratories (GLAB) to transfer data on MORGAM polymorphisms to the MORGAM Data centre (MDC)  at National Institute for Health and Welfare (THL). The data should be sent through e-mail.

Contents

• Format specification
• General instructions
• Specific instructions for each item
• Data transfer instructions
• Updates

Format specification

General Instructions

The item NAME on the document is a computer variable name used for the item by the MDC.

The item FORMAT specifies the format in which the value should be presented in the transfer data set:

Instructions for making corrections to data that have already been sent to the MDC are given in Section Data communication between the Participating Centres and the MDC.

Please contact the MDC for instructions if you can not provide information as specified in this document or if you have any problems with the interpretation of the coding for any specific items.

Specific instructions for each item

Follow these instructions carefully when creating a computer file for the data transfer from the GLAB to the MDC.

Number 51 indicates the "Data transfer format: MORGAM polymorphisms".

Current version of this data transfer format. If the version number of the data transfer format which you are using is not "2", these instructions do not correspond to the format you are using. Version number changes if some major changes are introduced in the form, for example adding / deleting some variables.

Enter appropriate code of your MORGAM Genotyping Laboratory from the list of MORGAM Genotyping Laboratories:

• 911=Genotyping laboratory in KTL, Helsinki
• 912=Genotyping laboratory in INSERM, Paris
• 913=Genotyping laboratory in RSCI (Royal College of Surgeons in Ireland), Dublin
• 914=Genotyping laboratory in QUB (Queen's University), Belfast

This is shipment number from genotyping laboratory to MDC. Usually it is a sequential number of shipments to MDC. If you do nof use it, enter
number of shipment to MDC on that particular day.

The date of the shipment (the date when you completed this data form). Format is yyyymmdd (date ANSI, 8 characters, year day month).

Enter the SNP / polymorphism name (abbreviation) as used in local database.

Enter the gene name (abbreviation) as defined in NCBI Entrez Gene database. The Form 50 "Data transfer format - MORGAM genes" should be sent to MDC containing data on this gene.

Enter here alleles in capital letters: A, C, T, G, from both chromosomes separated by slash (/). Deletions are marked as D, not genotyped data as N; for example:

• C/T
• A/C
• G/T
• A/G/D
• I/D

Enter here allele codes for deletion and insertion separated by slash (/), for example:

• +G/-G

Enter here the 5' flanking sequence, 30 characters.

Enter here the 3' flanking sequence, 25 characters.

Enter here the ID of this polymorphism in the RS database (if exists), for example: rs153311

The name of the original project in which this polymorphism was first used. See the available project codes at ???. If you have any uncertainty about the project, please contact the MCL for instructions.

Enter here Comments by the laboratory regarging the SNP (if any), for example if the SNP is a proxy for another SNP.

Data transfer Instructions

The data should be prepared in ASCII comma-delimited format using semicolon (;) as delimiter, with the names of the variables in the first row. If the value of a variable contains text with delimiter used inside the text then the value should be surrounded by double quotes ("). A dot (.) shold be used as a decimal point.

To simplify the tracing of data transfers between the MPC and the MDC, the files should be named as follows:

F51_GLAB_YYYYMMDD_N.CSV, where:

• F51 - identifies the data are from Form 51
• GLAB - MORGAM Laboratory code from the list of MORGAM Genotyping Laboratories
• YYYYMMDD - the year, month and date when this file was created (e.g. 20090205)
• N - sequence number of the transfer from the MPC. The number is generated by the appropriate Genotyping Laboratory, and should also be used for logging the data transfers locally.

To avoid possible errors in variable naming use the first row from the example below containing variable names. Example of Form 51 ASCII comma-delimited data file:

The data files should be archived (ZIP format) before sending them to the MDC. The archive names should be the same as the file names. MORGAM data Error checking program will be used to prepare data (will be available later). The data should be sent to MDC (ari.haukijarvi@thl.fi) as an attachment to an e-mail message. Please make sure to save a copy of the transferred files in the sending MPC or laboratory.

When the data are received in the MDC, an acknowledgement will be sent to the sender. The data will then be checked for consistency and quality, and after any problems have been resolved, they will be entered into the MORGAM database.

Updates