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 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 ________________________________________________________________________ Want to chat instantly with your online friends? Get the FREE Yahoo! Messenger http://mail.messenger.yahoo.co.uk -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
