By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,481 Members | 3,078 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,481 IT Pros & Developers. It's quick & easy.

OMIM databse locally

P: n/a
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
Jul 19 '05 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.