############ wgEncodeUw... Dgf, Dnase, Histone, Tfbs composites' hg19 submissions ###############

2010-06-08 Mini-freeze
======================
cd {t19}/metaDb/alpha/testing
~/bin/x86_64/mdbPrint hg18 -table=metaDb -vars="composite=wgEncodeUwChIPSeq" -updDb=hg19 -updMdb=metaDb_tdreszer -updExp="grant,cell,treatment,antibody,control,replicate,view" -updVars="dateSubmitted,dateUnrestricted" > uwHistHg18.txt
objects:561  vars:11673

1280	   	hg19	   	UwChIPSeq-GM12874-DS10992-CTCF-2 jun10	   	 loaded 	   	John Stam	   	UwStam	   	2010-06-07 23:35  	    	about 17 hours ago
1281	  	hg19	  	UwChIPSeq-GM12874-DS11503-CTCF-1 jun10	  	loaded 	  	John Stam	  	UwStam	  	2010-06-07 23:49 	   	about 17 hours ago
1277	  	hg19	  	UwChIPSeq-GM12872-DS10989-CTCF-1 jun10	  	loaded 	  	John Stam	  	UwStam	  	2010-06-07 21:57 	   	about 19 hours ago
1278	  	hg19	  	UwChIPSeq-GM12872-DS11500-CTCF-2 jun10	  	loaded 	  	John Stam	  	UwStam	  	2010-06-07 22:32 	   	about 18 hours ago
1275	  	hg19	  	UwChIPSeq-GM12865-DS11502-CTCF-1 jun10	  	loaded 	  	John Stam	  	UwStam	  	2010-06-07 21:51 	   	about 19 hours ago
1274	  	hg19	  	UwChIPSeq-GM12865-DS10991-CTCF-2 jun10	  	loaded 	  	John Stam	  	UwStam	  	2010-06-07 20:51 	   	about 20 hours ago
1273	  	hg19	  	UwChIPSeq-GM12864-DS11499-CTCF-2 jun10	  	loaded 	  	John Stam	  	UwStam	  	2010-06-07 20:50 	   	about 20 hours ago
1272	  	hg19	  	UwChIPSeq-GM12864-DS10988-CTCF-1 jun10	  	loaded 	  	John Stam	  	UwStam	  	2010-06-07 20:11 	   	about 21 hours ago
1271	  	hg19	  	UwChIPSeq-GM06990-DS11520-CTCF-2 jun10	  	loaded 	  	John Stam	  	UwStam	  	2010-06-07 19:32 	   	about 21 hours ago
1268	  	hg19	  	UwChIPSeq-GM06990-DS11518-CTCF-1 jun10	  	loaded 	  	John Stam	  	UwStam	  	2010-06-07 18:30 	   	about 22 hours ago
1269	  	hg19	  	UwChIPSeq-Caco-2-DS11675-CTCF-1 jun10	  	loaded 	  	John Stam	  	UwStam	  	2010-06-07 18:46 	   	about 22 hours ago
1267	  	hg19	  	UwChIPSeq-Caco-2-DS11674-CTCF-2 jun10	  	loaded 	  	John Stam	  	UwStam	  	2010-06-07 18:24 	   	about 22 hours ago
1266	  	hg19	  	UwChIPSeq-K562-DS11247-CTCF-1 jun10	  	loaded 	  	John Stam	  	UwStam	  	2010-06-07 17:10 	   	about 24 hours ago
1264	  	hg19	  	UwChIPSeq-K562-DS11508-CTCF-2 jun10	  	loaded 	  	John Stam	  	UwStam	  	2010-06-07 16:44 	   	1 day ago
1265	  	hg19	  	UwChIPSeq-GM12878-DS11165-CTCF-2 jun10	  	loaded 	  	John Stam	  	UwStam	  	2010-06-07 17:00 	   	about 24 hours ago
1263	  	hg19	  	UwChIPSeq-GM12878-DS11510-CTCF-1 jun10	  	loaded 	  	John Stam	  	UwStam	  	2010-06-07 17:44 	   	about 23 hours ago

1257	   	hg19	   	UwDnaseSeq-AG04449-DS12319-1 jun10	   	 loaded 	   	John Stam	   	UwStam	   	2010-06-07 12:55  	    	1 day ago
1249	  	hg19	  	UwDnaseSeq-BJ-DS10018-2 jun10	  	loaded 	  	John Stam	  	UwStam	  	2010-06-06 09:58 	   	2 days ago

rm tmp.txt
~/bin/x86_64/mdbPrint hg18 -table=metaDb -vars="composite=wgEncodeUwChIPSeq cell=GM12874 antibody=CTCF" -updDb=hg19 -updMdb=metaDb_tdreszer -updExp="grant,cell,treatment,antibody,control,replicate,view" -updVars="dateSubmitted,dateUnrestricted" >> tmp.txt
~/bin/x86_64/mdbPrint hg18 -table=metaDb -vars="composite=wgEncodeUwChIPSeq cell=GM12872 antibody=CTCF" -updDb=hg19 -updMdb=metaDb_tdreszer -updExp="grant,cell,treatment,antibody,control,replicate,view" -updVars="dateSubmitted,dateUnrestricted" >> tmp.txt
~/bin/x86_64/mdbPrint hg18 -table=metaDb -vars="composite=wgEncodeUwChIPSeq cell=GM12865 antibody=CTCF" -updDb=hg19 -updMdb=metaDb_tdreszer -updExp="grant,cell,treatment,antibody,control,replicate,view" -updVars="dateSubmitted,dateUnrestricted" >> tmp.txt
~/bin/x86_64/mdbPrint hg18 -table=metaDb -vars="composite=wgEncodeUwChIPSeq cell=GM12864 antibody=CTCF" -updDb=hg19 -updMdb=metaDb_tdreszer -updExp="grant,cell,treatment,antibody,control,replicate,view" -updVars="dateSubmitted,dateUnrestricted" >> tmp.txt
~/bin/x86_64/mdbPrint hg18 -table=metaDb -vars="composite=wgEncodeUwChIPSeq cell=GM06990 antibody=CTCF" -updDb=hg19 -updMdb=metaDb_tdreszer -updExp="grant,cell,treatment,antibody,control,replicate,view" -updVars="dateSubmitted,dateUnrestricted" >> tmp.txt
~/bin/x86_64/mdbPrint hg18 -table=metaDb -vars="composite=wgEncodeUwChIPSeq cell=K562 antibody=CTCF" -updDb=hg19 -updMdb=metaDb_tdreszer -updExp="grant,cell,treatment,antibody,control,replicate,view" -updVars="dateSubmitted,dateUnrestricted" >> tmp.txt
~/bin/x86_64/mdbPrint hg18 -table=metaDb -vars="composite=wgEncodeUwChIPSeq cell=GM12878 antibody=CTCF" -updDb=hg19 -updMdb=metaDb_tdreszer -updExp="grant,cell,treatment,antibody,control,replicate,view" -updVars="dateSubmitted,dateUnrestricted" >> tmp.txt
e tmp.txt # to add dateResubmitted and origAssembly
chmod 755 tmp.txt
./tmp.txt
Command would affected 0 row(s) in hg19.metaDb
mdbPrint hg18 -table=metaDb -vars="composite=wgEncodeUwHistone" -countObjs
0 objects
mdbUpdate hg19 -table=metaDb wgEncodeUwHistone.ra 
Read 73 metadata objects from hg19
Affected 1678 row(s) in hg19.metaDb
./tmp.txt
Affected 3 row(s) in hg19.metaDb
...
mdbPrint hg19 -table=metaDb -vars="composite=wgEncodeUwHistone" > wgEncodeUwHistone.ra

# missed
1255	  	hg19	  	UwChIPSeq-BJ-DS11560-CTCF-1 jun10	  	loaded 	  	John Stam	  	UwStam	  	2010-06-07 10:10 	   	1 day ago
1262	  	hg19	  	UwChIPSeq-BJ-DS11562-CTCF-2 jun10	  	loaded 	  	John Stam	  	UwStam	  	2010-06-07 14:58 	   	1 day ago
rm tmp.txt
~/bin/x86_64/mdbPrint hg18 -table=metaDb -vars="composite=wgEncodeUwChIPSeq cell=BJ antibody=CTCF" -updDb=hg19 -updMdb=metaDb_tdreszer -updExp="grant,cell,treatment,antibody,control,replicate,view" -updVars="dateSubmitted,dateUnrestricted" >> tmp.txt
e tmp.txt # to add dateResubmitted and origAssembly
chmod 755 tmp.txt
./tmp.txt
Affected 1 row(s) in hg19.metaDb
mdbPrint hg19 -table=metaDb -vars="composite=wgEncodeUwHistone" > wgEncodeUwHistone.ra

2010-06-21 DNase is all submitted
=================================
select id,name,status,user_id from projects where name like "%UwDnaseSeq%" and id > 1000 order by id;
+------+--------------------------------------+--------+---------+
| id   | name                                 | status | user_id |
+------+--------------------------------------+--------+---------+
| 1249 | UwDnaseSeq-BJ-DS10018-2 jun10        | loaded |      21 | 
| 1257 | UwDnaseSeq-AG04449-DS12319-1 jun10   | loaded |      21 | 
| 1548 | UwDnaseSeq-AG04449-DS12329-2 jun10   | loaded |      21 | 
| 1549 | UwDnaseSeq-AG04450-DS12255-2 jun10   | loaded |      21 | 
| 1550 | UwDnaseSeq-AG04450-DS12270-1 jun10   | loaded |      21 | 
| 1551 | UwDnaseSeq-AG09309-DS12352-1 jun10   | loaded |      21 | 
| 1552 | UwDnaseSeq-AG09309-DS12357-2 jun10   | loaded |      21 | 
| 1553 | UwDnaseSeq-AG09319-DS12286-2 jun10   | loaded |      21 | 
| 1554 | UwDnaseSeq-AG09319-DS12291-1 jun10   | loaded |      21 | 
| 1555 | UwDnaseSeq-AG10803-DS12374-2 jun10   | loaded |      21 | 
| 1556 | UwDnaseSeq-SAEC-DS10514-2 jun10      | loaded |      21 | 
| 1557 | UwDnaseSeq-SAEC-DS10518-1 jun10      | loaded |      21 | 
| 1558 | UwDnaseSeq-NB4-DS12538-2 jun10       | loaded |      21 | 
| 1559 | UwDnaseSeq-NB4-DS12543-1 jun10       | loaded |      21 | 
| 1560 | UwDnaseSeq-NHLF-DS12829-1 jun10      | loaded |      21 | 
| 1561 | UwDnaseSeq-NHLF-DS12834-2 jun10      | loaded |      21 | 
| 1562 | UwDnaseSeq-MCF-7-DS12619-2 jun10     | loaded |      21 | 
| 1563 | UwDnaseSeq-HGF-DS11752-1 jun10       | loaded |      21 | 
| 1564 | UwDnaseSeq-GM12865-DS12436-1 jun10   | loaded |      21 | 
| 1565 | UwDnaseSeq-HAEpiC-DS12663-1 jun10    | loaded |      21 | 
| 1566 | UwDnaseSeq-HRCEpiC-DS10662-2 jun10   | loaded |      21 | 
| 1567 | UwDnaseSeq-HRE-DS10631-2 jun10       | loaded |      21 | 
| 1568 | UwDnaseSeq-NHDF-neo-DS11918-2 jun10  | loaded |      21 | 
| 1569 | UwDnaseSeq-PANC-1-DS9873-2 jun10     | loaded |      21 | 
| 1570 | UwDnaseSeq-HL-60-DS11733-2 jun10     | loaded |      21 | 
| 1571 | UwDnaseSeq-HL-60-DS11809-1 jun10     | loaded |      21 | 
| 1572 | UwDnaseSeq-HMEC-DS8680-1 jun10       | loaded |      21 | 
| 1573 | UwDnaseSeq-SKMC-DS11949-1 jun10      | loaded |      21 | 
| 1576 | UwDnaseSeq-AG10803-DS12384-1 jun10   | loaded |      21 | 
| 1577 | UwDnaseSeq-HRCEpiC-DS10666-1 jun10   | loaded |      21 | 
| 1578 | UwDnaseSeq-HRE-DS10641-1 jun10       | loaded |      21 | 
| 1579 | UwDnaseSeq-HAEpiC-DS12673-2 jun10    | loaded |      21 | 
| 1586 | UwDnaseSeq-CMK-DS12393-1 jun10       | loaded |      21 | 
| 1587 | UwDnaseSeq-GM12878-DS10671-1 jun10   | loaded |      21 | 
| 1588 | UwDnaseSeq-H1-hESC-DS10167-1 jun10   | loaded |      21 | 
| 1589 | UwDnaseSeq-GM12865-DS12442-2 jun10   | loaded |      21 | 
| 1590 | UwDnaseSeq-Caco-2-DS8416-2 jun10     | loaded |      21 | 
| 1591 | UwDnaseSeq-HCF-DS12501-1 jun10       | loaded |      21 | 
| 1592 | UwDnaseSeq-H7-hESC-DS11909-1 jun10   | loaded |      21 | 
| 1593 | UwDnaseSeq-HCF-DS12491-2 jun10       | loaded |      21 | 
| 1595 | UwDnaseSeq-HCM-DS12589-2 jun10       | loaded |      21 | 
| 1598 | UwDnaseSeq-HCPEpiC-DS12447-1 jun10   | loaded |      21 | 
| 1599 | UwDnaseSeq-HCPEpiC-DS12457-2 jun10   | loaded |      21 | 
| 1600 | UwDnaseSeq-HCM-DS12599-1 jun10       | loaded |      21 | 
| 1601 | UwDnaseSeq-HEEpiC-DS12763-1 jun10    | loaded |      21 | 
| 1602 | UwDnaseSeq-HEEpiC-DS12768-2 jun10    | loaded |      21 | 
| 1603 | UwDnaseSeq-HGF-DS11738-2 jun10       | loaded |      21 | 
| 1604 | UwDnaseSeq-HeLa-S3-DS8200-2 jun10    | loaded |      21 | 
| 1605 | UwDnaseSeq-HeLa-S3-DS10011-1 jun10   | loaded |      21 | 
| 1614 | UwDnaseSeq-GM06990-DS7784-2 jun10    | loaded |      21 | 
| 1615 | UwDnaseSeq-HepG2-DS7768-2 jun10      | loaded |      21 | 
| 1616 |  UwDnaseSeq-GM06990-DS7748-1 jun10   | loaded |      21 | 
| 1617 | UwDnaseSeq-HepG2-DS7764-1 jun10      | loaded |      21 | 
| 1619 | UwDnaseSeq-HNPCEpiC-DS12467-1 jun10  | loaded |      21 | 
| 1620 | UwDnaseSeq-HNPCEpiC-DS12471-2 jun10  | loaded |      21 | 
| 1621 | UwDnaseSeq-HRPEpiC-DS12568-2 jun10   | loaded |      21 | 
| 1622 | UwDnaseSeq-HRPEpiC-DS12583-1 jun10   | loaded |      21 | 
| 1624 | UwDnaseSeq-HUVEC-DS10060-1 jun10     | loaded |      21 | 
| 1627 | UwDnaseSeq-PANC-1-DS9955-1 jun10     | loaded |      21 | 
| 1628 | UwDnaseSeq-MCF-7-DS9445-1 jun10      | loaded |      21 | 
| 1629 | UwDnaseSeq-NHDF-neo-DS11923-1 jun10  | loaded |      21 | 
| 1630 | UwDnaseSeq-NHEK-DS11474-1 jun10      | loaded |      21 | 
| 1640 | UwDnaseSeq-SK-N-SH_RA-DS8482-1 jun10 | loaded |      21 | 
| 1641 | UwDnaseSeq-Th1-DS7840-1 jun10        | loaded |      21 | 
| 1642 | UwDnaseSeq-SKMC-DS11939-2 jun10      | loaded |      21 | 
| 1643 | UwDnaseSeq-SK-N-SH_RA-DS8476-2 jun10 | loaded |      21 | 
| 1644 | UwDnaseSeq-Caco-2-DS8235-1 jun10     | loaded |      21 | 
| 1648 | UwDnaseSeq-BJ-DS10081-1 jun10        | loaded |      21 | 
| 1649 | UwDnaseSeq-GM12878-DS9432-2 jun10    | loaded |      21 | 
| 1675 | UwDnaseSeq-K562-DS9764-2 jun10       | loaded |      21 | 
| 1676 | UwDnaseSeq-K562-DS9767-1 jun10       | loaded |      21 | 
| 1677 | UwDnaseSeq-Th2-DS7842-1 jun10        | loaded |      21 | 
+------+--------------------------------------+--------+---------+
72 rows in set (0.01 sec)

rm /cluster/home/tdreszer/kent/src/hg/makeDb/trackDb/human/hg19/testing/tmp.ra
cat 1249/out/trackDb.ra >> /cluster/home/tdreszer/kent/src/hg/makeDb/trackDb/human/hg19/testing/tmp.ra
cat 1257/out/trackDb.ra >> /cluster/home/tdreszer/kent/src/hg/makeDb/trackDb/human/hg19/testing/tmp.ra
cat 1548/out/trackDb.ra >> /cluster/home/tdreszer/kent/src/hg/makeDb/trackDb/human/hg19/testing/tmp.ra
cat 1549/out/trackDb.ra >> /cluster/home/tdreszer/kent/src/hg/makeDb/trackDb/human/hg19/testing/tmp.ra
cat 1550/out/trackDb.ra >> /cluster/home/tdreszer/kent/src/hg/makeDb/trackDb/human/hg19/testing/tmp.ra
cat 1551/out/trackDb.ra >> /cluster/home/tdreszer/kent/src/hg/makeDb/trackDb/human/hg19/testing/tmp.ra
cat 1552/out/trackDb.ra >> /cluster/home/tdreszer/kent/src/hg/makeDb/trackDb/human/hg19/testing/tmp.ra
cat 1553/out/trackDb.ra >> /cluster/home/tdreszer/kent/src/hg/makeDb/trackDb/human/hg19/testing/tmp.ra
cat 1554/out/trackDb.ra >> /cluster/home/tdreszer/kent/src/hg/makeDb/trackDb/human/hg19/testing/tmp.ra
cat 1555/out/trackDb.ra >> /cluster/home/tdreszer/kent/src/hg/makeDb/trackDb/human/hg19/testing/tmp.ra
cat 1556/out/trackDb.ra >> /cluster/home/tdreszer/kent/src/hg/makeDb/trackDb/human/hg19/testing/tmp.ra
cat 1557/out/trackDb.ra >> /cluster/home/tdreszer/kent/src/hg/makeDb/trackDb/human/hg19/testing/tmp.ra
cat 1558/out/trackDb.ra >> /cluster/home/tdreszer/kent/src/hg/makeDb/trackDb/human/hg19/testing/tmp.ra
cat 1559/out/trackDb.ra >> /cluster/home/tdreszer/kent/src/hg/makeDb/trackDb/human/hg19/testing/tmp.ra
cat 1560/out/trackDb.ra >> /cluster/home/tdreszer/kent/src/hg/makeDb/trackDb/human/hg19/testing/tmp.ra
cat 1561/out/trackDb.ra >> /cluster/home/tdreszer/kent/src/hg/makeDb/trackDb/human/hg19/testing/tmp.ra
cat 1562/out/trackDb.ra >> /cluster/home/tdreszer/kent/src/hg/makeDb/trackDb/human/hg19/testing/tmp.ra
cat 1563/out/trackDb.ra >> /cluster/home/tdreszer/kent/src/hg/makeDb/trackDb/human/hg19/testing/tmp.ra
cat 1564/out/trackDb.ra >> /cluster/home/tdreszer/kent/src/hg/makeDb/trackDb/human/hg19/testing/tmp.ra
cat 1565/out/trackDb.ra >> /cluster/home/tdreszer/kent/src/hg/makeDb/trackDb/human/hg19/testing/tmp.ra
cat 1566/out/trackDb.ra >> /cluster/home/tdreszer/kent/src/hg/makeDb/trackDb/human/hg19/testing/tmp.ra
cat 1567/out/trackDb.ra >> /cluster/home/tdreszer/kent/src/hg/makeDb/trackDb/human/hg19/testing/tmp.ra
cat 1568/out/trackDb.ra >> /cluster/home/tdreszer/kent/src/hg/makeDb/trackDb/human/hg19/testing/tmp.ra
cat 1569/out/trackDb.ra >> /cluster/home/tdreszer/kent/src/hg/makeDb/trackDb/human/hg19/testing/tmp.ra
cat 1570/out/trackDb.ra >> /cluster/home/tdreszer/kent/src/hg/makeDb/trackDb/human/hg19/testing/tmp.ra
cat 1571/out/trackDb.ra >> /cluster/home/tdreszer/kent/src/hg/makeDb/trackDb/human/hg19/testing/tmp.ra
cat 1572/out/trackDb.ra >> /cluster/home/tdreszer/kent/src/hg/makeDb/trackDb/human/hg19/testing/tmp.ra
cat 1573/out/trackDb.ra >> /cluster/home/tdreszer/kent/src/hg/makeDb/trackDb/human/hg19/testing/tmp.ra
cat 1576/out/trackDb.ra >> /cluster/home/tdreszer/kent/src/hg/makeDb/trackDb/human/hg19/testing/tmp.ra
cat 1577/out/trackDb.ra >> /cluster/home/tdreszer/kent/src/hg/makeDb/trackDb/human/hg19/testing/tmp.ra
cat 1578/out/trackDb.ra >> /cluster/home/tdreszer/kent/src/hg/makeDb/trackDb/human/hg19/testing/tmp.ra
cat 1579/out/trackDb.ra >> /cluster/home/tdreszer/kent/src/hg/makeDb/trackDb/human/hg19/testing/tmp.ra
cat 1586/out/trackDb.ra >> /cluster/home/tdreszer/kent/src/hg/makeDb/trackDb/human/hg19/testing/tmp.ra
cat 1587/out/trackDb.ra >> /cluster/home/tdreszer/kent/src/hg/makeDb/trackDb/human/hg19/testing/tmp.ra
cat 1588/out/trackDb.ra >> /cluster/home/tdreszer/kent/src/hg/makeDb/trackDb/human/hg19/testing/tmp.ra
cat 1589/out/trackDb.ra >> /cluster/home/tdreszer/kent/src/hg/makeDb/trackDb/human/hg19/testing/tmp.ra
cat 1590/out/trackDb.ra >> /cluster/home/tdreszer/kent/src/hg/makeDb/trackDb/human/hg19/testing/tmp.ra
cat 1591/out/trackDb.ra >> /cluster/home/tdreszer/kent/src/hg/makeDb/trackDb/human/hg19/testing/tmp.ra
cat 1592/out/trackDb.ra >> /cluster/home/tdreszer/kent/src/hg/makeDb/trackDb/human/hg19/testing/tmp.ra
cat 1593/out/trackDb.ra >> /cluster/home/tdreszer/kent/src/hg/makeDb/trackDb/human/hg19/testing/tmp.ra
cat 1595/out/trackDb.ra >> /cluster/home/tdreszer/kent/src/hg/makeDb/trackDb/human/hg19/testing/tmp.ra
cat 1598/out/trackDb.ra >> /cluster/home/tdreszer/kent/src/hg/makeDb/trackDb/human/hg19/testing/tmp.ra
cat 1599/out/trackDb.ra >> /cluster/home/tdreszer/kent/src/hg/makeDb/trackDb/human/hg19/testing/tmp.ra
cat 1600/out/trackDb.ra >> /cluster/home/tdreszer/kent/src/hg/makeDb/trackDb/human/hg19/testing/tmp.ra
cat 1601/out/trackDb.ra >> /cluster/home/tdreszer/kent/src/hg/makeDb/trackDb/human/hg19/testing/tmp.ra
cat 1602/out/trackDb.ra >> /cluster/home/tdreszer/kent/src/hg/makeDb/trackDb/human/hg19/testing/tmp.ra
cat 1603/out/trackDb.ra >> /cluster/home/tdreszer/kent/src/hg/makeDb/trackDb/human/hg19/testing/tmp.ra
cat 1604/out/trackDb.ra >> /cluster/home/tdreszer/kent/src/hg/makeDb/trackDb/human/hg19/testing/tmp.ra
cat 1605/out/trackDb.ra >> /cluster/home/tdreszer/kent/src/hg/makeDb/trackDb/human/hg19/testing/tmp.ra
cat 1614/out/trackDb.ra >> /cluster/home/tdreszer/kent/src/hg/makeDb/trackDb/human/hg19/testing/tmp.ra
cat 1615/out/trackDb.ra >> /cluster/home/tdreszer/kent/src/hg/makeDb/trackDb/human/hg19/testing/tmp.ra
cat 1616/out/trackDb.ra >> /cluster/home/tdreszer/kent/src/hg/makeDb/trackDb/human/hg19/testing/tmp.ra
cat 1617/out/trackDb.ra >> /cluster/home/tdreszer/kent/src/hg/makeDb/trackDb/human/hg19/testing/tmp.ra
cat 1619/out/trackDb.ra >> /cluster/home/tdreszer/kent/src/hg/makeDb/trackDb/human/hg19/testing/tmp.ra
cat 1620/out/trackDb.ra >> /cluster/home/tdreszer/kent/src/hg/makeDb/trackDb/human/hg19/testing/tmp.ra
cat 1621/out/trackDb.ra >> /cluster/home/tdreszer/kent/src/hg/makeDb/trackDb/human/hg19/testing/tmp.ra
cat 1622/out/trackDb.ra >> /cluster/home/tdreszer/kent/src/hg/makeDb/trackDb/human/hg19/testing/tmp.ra
cat 1624/out/trackDb.ra >> /cluster/home/tdreszer/kent/src/hg/makeDb/trackDb/human/hg19/testing/tmp.ra
cat 1627/out/trackDb.ra >> /cluster/home/tdreszer/kent/src/hg/makeDb/trackDb/human/hg19/testing/tmp.ra
cat 1628/out/trackDb.ra >> /cluster/home/tdreszer/kent/src/hg/makeDb/trackDb/human/hg19/testing/tmp.ra
cat 1629/out/trackDb.ra >> /cluster/home/tdreszer/kent/src/hg/makeDb/trackDb/human/hg19/testing/tmp.ra
cat 1630/out/trackDb.ra >> /cluster/home/tdreszer/kent/src/hg/makeDb/trackDb/human/hg19/testing/tmp.ra
cat 1640/out/trackDb.ra >> /cluster/home/tdreszer/kent/src/hg/makeDb/trackDb/human/hg19/testing/tmp.ra
cat 1641/out/trackDb.ra >> /cluster/home/tdreszer/kent/src/hg/makeDb/trackDb/human/hg19/testing/tmp.ra
cat 1642/out/trackDb.ra >> /cluster/home/tdreszer/kent/src/hg/makeDb/trackDb/human/hg19/testing/tmp.ra
cat 1643/out/trackDb.ra >> /cluster/home/tdreszer/kent/src/hg/makeDb/trackDb/human/hg19/testing/tmp.ra
cat 1644/out/trackDb.ra >> /cluster/home/tdreszer/kent/src/hg/makeDb/trackDb/human/hg19/testing/tmp.ra
cat 1648/out/trackDb.ra >> /cluster/home/tdreszer/kent/src/hg/makeDb/trackDb/human/hg19/testing/tmp.ra
cat 1649/out/trackDb.ra >> /cluster/home/tdreszer/kent/src/hg/makeDb/trackDb/human/hg19/testing/tmp.ra
cat 1675/out/trackDb.ra >> /cluster/home/tdreszer/kent/src/hg/makeDb/trackDb/human/hg19/testing/tmp.ra
cat 1676/out/trackDb.ra >> /cluster/home/tdreszer/kent/src/hg/makeDb/trackDb/human/hg19/testing/tmp.ra
cat 1677/out/trackDb.ra >> /cluster/home/tdreszer/kent/src/hg/makeDb/trackDb/human/hg19/testing/tmp.ra

cd /cluster/home/tdreszer/kent/src/hg/makeDb/trackDb/human/hg19/testing/
raToLines tmp.ra tmp.txt
grep compositeTrack tmp.txt > tmpC.txt
grep view=Peaks tmp.txt > tmpP.txt
grep view=Hotspots tmp.txt > tmpH.txt
grep view=RawSignal tmp.txt > tmpR.txt
wl tmp?.txt
    72 tmpC.txt
    72 tmpH.txt
    72 tmpP.txt
    72 tmpR.txt
   288 total
wl tmp.txt
288 tmp.txt

grep rep1 tmpP.txt > tmpP1.txt
grep rep2 tmpP.txt > tmpP2.txt
grep rep1 tmpH.txt > tmpH1.txt
grep rep2 tmpH.txt > tmpH2.txt
grep rep1 tmpR.txt > tmpR1.txt
grep rep2 tmpR.txt > tmpR2.txt
grep -v rep1 tmpP.txt | grep -v rep2 >  tmpC0.txt
grep -v rep1 tmpR.txt | grep -v rep2 >> tmpC0.txt
grep -v rep1 tmpH.txt | grep -v rep2 >> tmpC0.txt
wl tmp??.txt
6 tmpC0.txt
   39 tmpH1.txt
   31 tmpH2.txt
   39 tmpP1.txt
   31 tmpP2.txt
   39 tmpR1.txt
   31 tmpR2.txt
  216 total
grep -v compositeTrack tmp.txt | wl
216
e tmp??.txt # Change a lot of formatting isues 
linesToRa tmpP1.txt tmpP1.ra
linesToRa tmpH1.txt tmpH1.ra
linesToRa tmpR1.txt tmpR1.ra
e tmp?1.ra

# create wgEncodeUwDnase.ra, add all the subtracks
make DBS=hg19

mdbUpdate hg19 1249/out/mdb.txt
mdbUpdate hg19 1257/out/mdb.txt
mdbUpdate hg19 1548/out/mdb.txt
mdbUpdate hg19 1549/out/mdb.txt
mdbUpdate hg19 1550/out/mdb.txt
mdbUpdate hg19 1551/out/mdb.txt
mdbUpdate hg19 1552/out/mdb.txt
mdbUpdate hg19 1553/out/mdb.txt
mdbUpdate hg19 1554/out/mdb.txt
mdbUpdate hg19 1555/out/mdb.txt
mdbUpdate hg19 1556/out/mdb.txt
mdbUpdate hg19 1557/out/mdb.txt
mdbUpdate hg19 1558/out/mdb.txt
mdbUpdate hg19 1559/out/mdb.txt
mdbUpdate hg19 1560/out/mdb.txt
mdbUpdate hg19 1561/out/mdb.txt
mdbUpdate hg19 1562/out/mdb.txt
mdbUpdate hg19 1563/out/mdb.txt
mdbUpdate hg19 1564/out/mdb.txt
mdbUpdate hg19 1565/out/mdb.txt
mdbUpdate hg19 1566/out/mdb.txt
mdbUpdate hg19 1567/out/mdb.txt
mdbUpdate hg19 1568/out/mdb.txt
mdbUpdate hg19 1569/out/mdb.txt
mdbUpdate hg19 1570/out/mdb.txt
mdbUpdate hg19 1571/out/mdb.txt
mdbUpdate hg19 1572/out/mdb.txt
mdbUpdate hg19 1573/out/mdb.txt
mdbUpdate hg19 1576/out/mdb.txt
mdbUpdate hg19 1577/out/mdb.txt
mdbUpdate hg19 1578/out/mdb.txt
mdbUpdate hg19 1579/out/mdb.txt
mdbUpdate hg19 1586/out/mdb.txt
mdbUpdate hg19 1587/out/mdb.txt
mdbUpdate hg19 1588/out/mdb.txt
mdbUpdate hg19 1589/out/mdb.txt
mdbUpdate hg19 1590/out/mdb.txt
mdbUpdate hg19 1591/out/mdb.txt
mdbUpdate hg19 1592/out/mdb.txt
mdbUpdate hg19 1593/out/mdb.txt
mdbUpdate hg19 1595/out/mdb.txt
mdbUpdate hg19 1598/out/mdb.txt
mdbUpdate hg19 1599/out/mdb.txt
mdbUpdate hg19 1600/out/mdb.txt
mdbUpdate hg19 1601/out/mdb.txt
mdbUpdate hg19 1602/out/mdb.txt
mdbUpdate hg19 1603/out/mdb.txt
mdbUpdate hg19 1604/out/mdb.txt
mdbUpdate hg19 1605/out/mdb.txt
mdbUpdate hg19 1614/out/mdb.txt
mdbUpdate hg19 1615/out/mdb.txt
mdbUpdate hg19 1616/out/mdb.txt
mdbUpdate hg19 1617/out/mdb.txt
mdbUpdate hg19 1619/out/mdb.txt
mdbUpdate hg19 1620/out/mdb.txt
mdbUpdate hg19 1621/out/mdb.txt
mdbUpdate hg19 1622/out/mdb.txt
mdbUpdate hg19 1624/out/mdb.txt
mdbUpdate hg19 1627/out/mdb.txt
mdbUpdate hg19 1628/out/mdb.txt
mdbUpdate hg19 1629/out/mdb.txt
mdbUpdate hg19 1630/out/mdb.txt
mdbUpdate hg19 1640/out/mdb.txt
mdbUpdate hg19 1641/out/mdb.txt
mdbUpdate hg19 1642/out/mdb.txt
mdbUpdate hg19 1643/out/mdb.txt
mdbUpdate hg19 1644/out/mdb.txt
mdbUpdate hg19 1648/out/mdb.txt
mdbUpdate hg19 1649/out/mdb.txt
mdbUpdate hg19 1675/out/mdb.txt
mdbUpdate hg19 1676/out/mdb.txt
mdbUpdate hg19 1677/out/mdb.txt
Using table named 'hg19.metaDb_tdreszer'.
Read 4 metadata objects from hg19
Affected 68 row(s) in hg19.metaDb_tdreszer
...

# Now update dates
cd /cluster/home/tdreszer/kent/src/hg/makeDb/trackDb/human/hg19/metaDb/alpha/testing
~/bin/x86_64/mdbPrint hg18 -table=metaDb -vars="composite=wgEncodeUwDnaseSeq" -updDb=hg19 -updMdb=metaDb_tdreszer -updSelect="grant,dataType,cell,replicate,view" -updVars="dateSubmitted,dateUnrestricted" > uwDnaseDates.txt
objects:402  vars:6803
~/bin/x86_64/mdbPrint hg19 -vars="composite=wgEncodeUwDnase" -updDb=hg19 -updMdb=metaDb_tdreszer -updSelect="subId" -updVars="dateSubmitted" > uwDnaseResub.txt
objects:289  vars:4912
e uwDnaseDates.txt # Add origAssembly=hg18
chmod 755 uwDnase*.txt
./uwDnaseDates.txt
Affected 2 row(s) in hg19.metaDb_tdreszer
Affected 0 row(s) in hg19.metaDb_tdreszer
...

e uwDnaseResub.txt # Add select origAssembly=hg18, change dateSubmitted to dateResubmitted
./uwDnaseResub.txt
Affected 4 row(s) in hg19.metaDb_tdreszer
Affected 4 row(s) in hg19.metaDb_tdreszer
...

cd /usr/local/apache/htdocs-hgdownload/goldenPath/hg19/encodeDCC/wgEncodeUwDnase
e preamble.html # Add link to hg18 for remapped data
encodeDownloadsPage.pl -db=hg19 -mdb=metaDb_tdreszer index.html .

# looks okay so check in mdb
cd /cluster/home/tdreszer/kent/src/hg/makeDb/trackDb/human/hg19/metaDb/alpha
mdbPrint hg19 -vars="composite=wgEncodeUwDnase" > wgEncodeUwDnase.ra
objects:289  vars:5201
mdbUpdate hg19 -table=metaDb wgEncodeUwDnase.ra
Read 289 metadata objects from hg19
Affected 5201 row(s) in hg19.metaDb
git add,commit,pull,push
cd /cluster/home/tdreszer/kent/src/hg/makeDb/trackDb
make alpha DBS=hg19

/cluster/data/encode/pipeline/bin/encodeStatus.pl 1249 displayed
/cluster/data/encode/pipeline/bin/encodeStatus.pl 1257 displayed
/cluster/data/encode/pipeline/bin/encodeStatus.pl 1548 displayed
/cluster/data/encode/pipeline/bin/encodeStatus.pl 1549 displayed
/cluster/data/encode/pipeline/bin/encodeStatus.pl 1550 displayed
/cluster/data/encode/pipeline/bin/encodeStatus.pl 1551 displayed
/cluster/data/encode/pipeline/bin/encodeStatus.pl 1552 displayed
/cluster/data/encode/pipeline/bin/encodeStatus.pl 1553 displayed
/cluster/data/encode/pipeline/bin/encodeStatus.pl 1554 displayed
/cluster/data/encode/pipeline/bin/encodeStatus.pl 1555 displayed
/cluster/data/encode/pipeline/bin/encodeStatus.pl 1556 displayed
/cluster/data/encode/pipeline/bin/encodeStatus.pl 1557 displayed
/cluster/data/encode/pipeline/bin/encodeStatus.pl 1558 displayed
/cluster/data/encode/pipeline/bin/encodeStatus.pl 1559 displayed
/cluster/data/encode/pipeline/bin/encodeStatus.pl 1560 displayed
/cluster/data/encode/pipeline/bin/encodeStatus.pl 1561 displayed
/cluster/data/encode/pipeline/bin/encodeStatus.pl 1562 displayed
/cluster/data/encode/pipeline/bin/encodeStatus.pl 1563 displayed
/cluster/data/encode/pipeline/bin/encodeStatus.pl 1564 displayed
/cluster/data/encode/pipeline/bin/encodeStatus.pl 1565 displayed
/cluster/data/encode/pipeline/bin/encodeStatus.pl 1566 displayed
/cluster/data/encode/pipeline/bin/encodeStatus.pl 1567 displayed
/cluster/data/encode/pipeline/bin/encodeStatus.pl 1568 displayed
/cluster/data/encode/pipeline/bin/encodeStatus.pl 1569 displayed
/cluster/data/encode/pipeline/bin/encodeStatus.pl 1570 displayed
/cluster/data/encode/pipeline/bin/encodeStatus.pl 1571 displayed
/cluster/data/encode/pipeline/bin/encodeStatus.pl 1572 displayed
/cluster/data/encode/pipeline/bin/encodeStatus.pl 1573 displayed
/cluster/data/encode/pipeline/bin/encodeStatus.pl 1576 displayed
/cluster/data/encode/pipeline/bin/encodeStatus.pl 1577 displayed
/cluster/data/encode/pipeline/bin/encodeStatus.pl 1578 displayed
/cluster/data/encode/pipeline/bin/encodeStatus.pl 1579 displayed
/cluster/data/encode/pipeline/bin/encodeStatus.pl 1586 displayed
/cluster/data/encode/pipeline/bin/encodeStatus.pl 1587 displayed
/cluster/data/encode/pipeline/bin/encodeStatus.pl 1588 displayed
/cluster/data/encode/pipeline/bin/encodeStatus.pl 1589 displayed
/cluster/data/encode/pipeline/bin/encodeStatus.pl 1590 displayed
/cluster/data/encode/pipeline/bin/encodeStatus.pl 1591 displayed
/cluster/data/encode/pipeline/bin/encodeStatus.pl 1592 displayed
/cluster/data/encode/pipeline/bin/encodeStatus.pl 1593 displayed
/cluster/data/encode/pipeline/bin/encodeStatus.pl 1595 displayed
/cluster/data/encode/pipeline/bin/encodeStatus.pl 1598 displayed
/cluster/data/encode/pipeline/bin/encodeStatus.pl 1599 displayed
/cluster/data/encode/pipeline/bin/encodeStatus.pl 1600 displayed
/cluster/data/encode/pipeline/bin/encodeStatus.pl 1601 displayed
/cluster/data/encode/pipeline/bin/encodeStatus.pl 1602 displayed
/cluster/data/encode/pipeline/bin/encodeStatus.pl 1603 displayed
/cluster/data/encode/pipeline/bin/encodeStatus.pl 1604 displayed
/cluster/data/encode/pipeline/bin/encodeStatus.pl 1605 displayed
/cluster/data/encode/pipeline/bin/encodeStatus.pl 1614 displayed
/cluster/data/encode/pipeline/bin/encodeStatus.pl 1615 displayed
/cluster/data/encode/pipeline/bin/encodeStatus.pl 1616 displayed
/cluster/data/encode/pipeline/bin/encodeStatus.pl 1617 displayed
/cluster/data/encode/pipeline/bin/encodeStatus.pl 1619 displayed
/cluster/data/encode/pipeline/bin/encodeStatus.pl 1620 displayed
/cluster/data/encode/pipeline/bin/encodeStatus.pl 1621 displayed
/cluster/data/encode/pipeline/bin/encodeStatus.pl 1622 displayed
/cluster/data/encode/pipeline/bin/encodeStatus.pl 1624 displayed
/cluster/data/encode/pipeline/bin/encodeStatus.pl 1627 displayed
/cluster/data/encode/pipeline/bin/encodeStatus.pl 1628 displayed
/cluster/data/encode/pipeline/bin/encodeStatus.pl 1629 displayed
/cluster/data/encode/pipeline/bin/encodeStatus.pl 1630 displayed
/cluster/data/encode/pipeline/bin/encodeStatus.pl 1640 displayed
/cluster/data/encode/pipeline/bin/encodeStatus.pl 1641 displayed
/cluster/data/encode/pipeline/bin/encodeStatus.pl 1642 displayed
/cluster/data/encode/pipeline/bin/encodeStatus.pl 1643 displayed
/cluster/data/encode/pipeline/bin/encodeStatus.pl 1644 displayed
/cluster/data/encode/pipeline/bin/encodeStatus.pl 1648 displayed
/cluster/data/encode/pipeline/bin/encodeStatus.pl 1649 displayed
/cluster/data/encode/pipeline/bin/encodeStatus.pl 1675 displayed
/cluster/data/encode/pipeline/bin/encodeStatus.pl 1676 displayed
/cluster/data/encode/pipeline/bin/encodeStatus.pl 1677 displayed

select id,name,status,user_id from projects where name like "%UwDnaseSeq%" and status = "loaded";
Empty set (0.00 sec)

2010-06-21 forgot to update status when tracks were released
============================================================
select id,name,status,user_id from projects where user_id = 21 and status = "reviewing";
+------+----------------------------+-----------+---------+
| id   | name                       | status    | user_id |
+------+----------------------------+-----------+---------+
|  631 | UwDgf-SKNSH sep09          | reviewing |      21 | 
|  632 | UwDgf-HepG2 sep09          | reviewing |      21 | 
|  637 | UwDgf-Th1 sep09            | reviewing |      21 | 
| 1054 | UwDgf-GM06990-DS7748 jan10 | reviewing |      21 | 
| 1027 | UwDgf-K562-DS9767 jan10    | reviewing |      21 | 
+------+----------------------------+-----------+---------+
5 rows in set (0.00 sec)
/cluster/data/encode/pipeline/bin/encodeStatus.pl  631 released
/cluster/data/encode/pipeline/bin/encodeStatus.pl  632 released
/cluster/data/encode/pipeline/bin/encodeStatus.pl  637 released
/cluster/data/encode/pipeline/bin/encodeStatus.pl 1054 released
/cluster/data/encode/pipeline/bin/encodeStatus.pl 1027 released
select id,name,status,user_id from projects where user_id = 21 and status = "reviewing";
Empty set (0.01 sec)


2010-06-21 DGF for June Freeze
==============================
select id,name,status,user_id from projects where user_id = 21 and status = "loaded";
+------+--------------------------------------+--------+---------+
| id   | name                                 | status | user_id |
+------+--------------------------------------+--------+---------+
| 1682 | UwDnaseDgf-GM06990-DS7748 jun10      | loaded |      21 | 
| 1795 | UwDnaseDgf-SK-N-SH_RA-DS8482 jun10   | loaded |      21 | 
| 1814 | UwDnaseDgf-HepG2-DS7764 jun10        | loaded |      21 | 
| 1815 | UwDnaseDgf-K562-DS9767 jun10         | loaded |      21 | 
| 1816 | UwDnaseDgf-Th1-DS7840 jun10          | loaded |      21 | 
| 1012 | DNaseI Southern validation jan10 (2) | loaded |      21 | 
+------+--------------------------------------+--------+---------+
6 rows in set (0.00 sec)

rm /cluster/home/tdreszer/kent/src/hg/makeDb/trackDb/human/hg19/testing/tmp.ra
cat 1682/out/trackDb.ra >> /cluster/home/tdreszer/kent/src/hg/makeDb/trackDb/human/hg19/testing/tmp.ra
cat 1795/out/trackDb.ra >> /cluster/home/tdreszer/kent/src/hg/makeDb/trackDb/human/hg19/testing/tmp.ra
cat 1814/out/trackDb.ra >> /cluster/home/tdreszer/kent/src/hg/makeDb/trackDb/human/hg19/testing/tmp.ra
cat 1815/out/trackDb.ra >> /cluster/home/tdreszer/kent/src/hg/makeDb/trackDb/human/hg19/testing/tmp.ra
cat 1816/out/trackDb.ra >> /cluster/home/tdreszer/kent/src/hg/makeDb/trackDb/human/hg19/testing/tmp.ra

cd /cluster/home/tdreszer/kent/src/hg/makeDb/trackDb/human/hg19/testing/
raToLines tmp.ra tmp.txt
grep compositeTrack tmp.txt > tmpC.txt
grep view=Peaks tmp.txt > tmpP.txt
grep view=Hotspots tmp.txt > tmpH.txt
grep view=RawSignal tmp.txt > tmpR.txt
grep view=Signal tmp.txt > tmpS.txt
wl tmp?.txt
   5 tmpC.txt
   5 tmpH.txt
   5 tmpP.txt
   5 tmpR.txt
   5 tmpS.txt
  25 total
wl tmp.txt
25 tmp.txt

linesToRa tmpP.txt tmpP.ra
linesToRa tmpH.txt tmpH.ra
linesToRa tmpR.txt tmpR.ra
linesToRa tmpS.txt tmpS.ra
e tmp?.ra

# create wgEncodeUwDgf.ra, add all the subtracks
make DBS=hg19

mdbUpdate hg19 1682/out/mdb.txt
mdbUpdate hg19 1795/out/mdb.txt
mdbUpdate hg19 1814/out/mdb.txt
mdbUpdate hg19 1815/out/mdb.txt
mdbUpdate hg19 1816/out/mdb.txt
Using table named 'hg19.metaDb_tdreszer'.
Read 5 metadata objects from hg19
Affected 79 row(s) in hg19.metaDb_tdreszer
...

# Now update dates
cd /cluster/home/tdreszer/kent/src/hg/makeDb/trackDb/human/hg19/metaDb/alpha/testing
~/bin/x86_64/mdbPrint hg18 -table=metaDb -vars="composite=wgEncodeUwDGF" -updDb=hg19 -updMdb=metaDb_tdreszer -updSelect="grant,dataType,cell,view" -updVars="dateSubmitted,dateUnrestricted" > uwDgfDates.txt
objects:28  vars:412
~/bin/x86_64/mdbPrint hg19 -vars="composite=wgEncodeUwDgf" -updDb=hg19 -updMdb=metaDb_tdreszer -updSelect="subId" -updVars="dateSubmitted" > uwDgfResub.txt
objects:25  vars:395
e uwDgfDates.txt # Add origAssembly=hg18
chmod 755 uwDgf*.txt
./uwDgfDates.txt
Affected 2 row(s) in hg19.metaDb_tdreszer
Affected 0 row(s) in hg19.metaDb_tdreszer
...

e uwDgfResub.txt # Add select origAssembly=hg18, change dateSubmitted to dateResubmitted
./uwDgfResub.txt
Affected 5 row(s) in hg19.metaDb_tdreszer
...

cd /usr/local/apache/htdocs-hgdownload/goldenPath/hg19/encodeDCC/wgEncodeUwDfg
e preamble.html # Add link to hg18 for remapped data
encodeDownloadsPage.pl -db=hg19 -mdb=metaDb_tdreszer index.html .

# looks okay so check in mdb
cd /cluster/home/tdreszer/kent/src/hg/makeDb/trackDb/human/hg19/metaDb/alpha
mdbPrint hg19 -vars="composite=wgEncodeUwDgf" > wgEncodeUwDgf.ra
objects:25  vars:420
mdbUpdate hg19 -table=metaDb wgEncodeUwDgf.ra
Read 25 metadata objects from hg19
Affected 420 row(s) in hg19.metaDb
git add,commit,pull,push
cd /cluster/home/tdreszer/kent/src/hg/makeDb/trackDb
make alpha DBS=hg19

/cluster/data/encode/pipeline/bin/encodeStatus.pl 1682 displayed
/cluster/data/encode/pipeline/bin/encodeStatus.pl 1795 displayed
/cluster/data/encode/pipeline/bin/encodeStatus.pl 1814 displayed
/cluster/data/encode/pipeline/bin/encodeStatus.pl 1815 displayed
/cluster/data/encode/pipeline/bin/encodeStatus.pl 1816 displayed
select id,name,status,user_id from projects where user_id = 21 and status = "loaded";
+------+--------------------------------------+--------+---------+
| id   | name                                 | status | user_id |
+------+--------------------------------------+--------+---------+
| 1012 | DNaseI Southern validation jan10 (2) | loaded |      21 | 
+------+--------------------------------------+--------+---------+
1 row in set (0.01 sec)
