placing the OMIM database locally

Jeroen Van Goey peak_freak at yahoo.com
Thu Sep 18 19:24:28 EST 2003


Hi,
I want to put the OMIM databse locally on my computer. I downloaded
the
file genemap from ftp://ftp.ncbi.nih.gov/repository/OMIM/ It contains
a
list of fields, separated by the '|' character. An example is:

1.1|9|11|95|1pter-p36.13|CCV|P|Cataract, congenital, Volkmann
type||115665|Fd|linked to Rh in Scottish family||Cataract, congenital,
Volkmann type (2)| | ||
1.2|9|25|01|1pter-p36.13|ENO1, PPH, MPB1|C|Enolase-1, alpha||172430|S,
F, R, REa|||Enolase deficiency (1)| | |4(Eno1)|
1.3|10|23|87|1pter-p36.13|GDH|C|Glucose dehydrogenase||138090|S, F||||
| ||
...

The fields are, in order :

1  - Numbering system, in the format  Chromosome.Map_Entry_Number
2  - Month entered
3  - Day     "
4  - Year    "
5  - Location
6  - Gene Symbol(s)
7  - Gene Status (see below for codes)
8  - Title
9  - 
10 - MIM Number
11 - Method (see below for codes)
12 - Comments
13 -
14 - Disorders
15 - Disorders, cont.
16 - Disorders, cont
17 - Mouse correlate
18 - Reference

I now want make a relational database in MySQL, but with the statement
"CREATE TABLE genemap", I'm a bit unsure as of which
parameters to use (VARCHAR, INTEGER,...), and what the values are of
these
parameters.

So, has anybody done this before, or can you point me to a place where
I can find this information? 

Thanks in advance, Jeroen




More information about the Comp-bio mailing list