############ 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)