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 to "CREATE TABLE genemap", but I'm a bit unsure as of what
parameters to use (VARCHAR, INTEGER,...), and what values I should use
for these parameters.
So, has anybody done this before, or can yoy point me to a place where
I can find this information?
Thanks in advance, Jeroen