I want to put the OMIM databse locally on my computer. I downloaded
file genemap from ftp://ftp.ncbi.nih.gov/repository/OMIM/ It contains
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
10 - MIM Number
11 - Method (see below for codes)
12 - Comments
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
So, has anybody done this before, or can you point me to a place where
I can find this information?
Thanks in advance, Jeroen