17a0041ba1ccccb438ab59855538e53d0f78e0f9 kate Wed May 15 14:17:06 2019 -0700 Final polish: 1. Set default on tracks. 2. Fix some uniqueness problems with shortLabels and colors. diff --git src/hg/makeDb/doc/encode3/tfbs.txt src/hg/makeDb/doc/encode3/tfbs.txt index f60f3ec..3cfd472 100644 --- src/hg/makeDb/doc/encode3/tfbs.txt +++ src/hg/makeDb/doc/encode3/tfbs.txt @@ -347,30 +347,32 @@ cd peaks awk '{print $1}' ../fileCellAbTarget.tab | sed 's/peaks\///' | \ xargs -L 1 ../../scorePeaks.csh hg19 >&! ../scorePeaks.log & cd .. perl ../makeTrackDb.pl < clusters.inputs.tab > trackDb.ra # trim shortLabels: grep shortLabel trackDb.ra | sed 's/shortLabel //' | sort > shortLabels.orig.txt sort | awk -F'\n' '{print $1, "\t", $1}' shortLabels.orig.txt > \ shortLabels.twocol.txt # 2. import to google sheet # 3. trim 2nd column to 17 chars # 4. export as tab-sep +# NOTE: double check they are unique + tdbRename trackDb.ra shortLabel encode3TfChipShortLabels.hg19.txt trackDb.new.ra # Fix up subGroup members w/ punctuation and initial numbers: # Peyer's_patch -> Peyers_patch # NT2/D1 -> NT2_D1 # 22Rv1 -> X22Rv1 # MM.1S -> MM_1S # rename tables (encode3Tfbs -> encTfChipPk) hgsql hg19 -e 'show tables like "encode3TfbsPk%"' > tables.old.txt sed -e 's/^/alter table /' -e 's/$/ rename to /' tables.old.txt > rename.1.sql sed -e 's/encode3TfbsPk/encTfChipPk/' tables.old.txt | paste rename.1.sql - | \ sed 's/$/;/' > rename.sql hgsql hg19 < rename.sql