Update GENE_SYMBOLS

• rename gene_symbols to gene_symbols_old
• create gene_symbols table
• alter table gene_symbols disable constraint gs_eq;
• Arrange columns in appropriate order
• logon to phenogen as chornbak

cd scripts/eQTL
scp chornbak@stan://Users/chornbak/Downloads/Mouse_GeneSymbols.csv .
scp chornbak@stan://Users/chornbak/Downloads/Rat_GeneSymbols.csv .

Last time, Laura saved them as 'Mac csv', so I had to:

• move them to stan
• open in Excel and click the column headers and set the format to TEXT -- otherwise it thinks they are dates!
• save as Windows csv
• copy them back to phenogen
• remove the ^M with: tr -d '\r' < fileName > newFileName

Next,

• vi gene_symbols_Mm.ctl and gene_symbols_Rn.ctl and change the file names and the field names
• export ORACLE_SID=dev
• ./GeneSymbols_go
• delete extras from the gene_symbols table: delete from gene_symbols where identifier in (select identifier from gene_symbols minus select identifier from expressioN_qtls);
• alter table gene_symbols enable constraint gs_eq;

Go Back to Database Update Procedures