src/hg/makeDb/doc/sacCer2.txt 1.12

Index: src/hg/makeDb/doc/sacCer2.txt
===================================================================
RCS file: /projects/compbio/cvsroot/kent/src/hg/makeDb/doc/sacCer2.txt,v
retrieving revision 1.11
retrieving revision 1.12
diff -b -B -U 4 -r1.11 -r1.12
--- src/hg/makeDb/doc/sacCer2.txt	10 Jul 2009 19:30:37 -0000	1.11
+++ src/hg/makeDb/doc/sacCer2.txt	10 Jul 2009 20:27:40 -0000	1.12
@@ -1329,5 +1329,22 @@
     hgsql sacCer2 \
 	-e 'load data local infile "addSgdGeneNames.tab" into table sgdToName;'
     hgsql -e "select count(*) from sgdToName;" sacCer2
     #	6726
+
+# Removed extraneous records from sgdToName (DONE - 2009-07-10 - Katrina)
+	#sgdGene has 6717 records (all of which have a distinct value in the
+	#name field) and sgdToName has 6726 (all of which have a distinct value
+	#in the name field).I searched for these 9 gene names in the SGD web
+	#site (yeastgenome.org). Most are alias' of another gene or something
+	#that was originally characterized as a separate gene but later found
+	#to be a part of another gene.
+	mysql> delete  from sgdToName where name= "YBL039W-A";
+	mysql> delete from sgdToName where name= "YBL101W-A";
+	mysql> delete from sgdToName where name= "YBL101W-C";
+	mysql> delete from sgdToName where name= "YDL038C";
+	mysql> delete from sgdToName where name= "YDR524W-A";
+	mysql> delete from sgdToName where name= "YGR272C";
+	mysql> delete from sgdToName where name= "YLR157W-A";
+	mysql> delete from sgdToName where name= "YLR157W-C";
+	mysql> delete from sgdToName where name= "YNL097C-A";
 ############################################################################