d96751b9e97f16417a020a9f6356432e6d102bc1 kate Wed Apr 29 10:21:59 2020 -0700 Correct tissue description, as per GTEx portal page for V8. refs #25130 diff --git src/hg/makeDb/doc/gtex/V6.txt src/hg/makeDb/doc/gtex/V6.txt index b7d5aca..3755d14 100644 --- src/hg/makeDb/doc/gtex/V6.txt +++ src/hg/makeDb/doc/gtex/V6.txt @@ -114,16 +114,30 @@ hgLoadSqlTab hgFixed gtexTissueMedianV6 ~kate/kent/src/hg/lib/gtexTissueMedian.sql \ $dir/gtex4V6TissueMedianAll.tab ############ # Add GTEX consortium abbreviation column to tissue table (e.g. for ASE) cd /hive/data/outside/gtex/V6/metadata hgsql hgFixed -e 'select * from gtexTissue' > gtexTissue.old.tab awk -F"\t" 'NR>1 {print $2}' gtex_tissue_colors.txt | paste gtexTissue.old.tab - > gtexTissue.new.tab hgLoadSqlTab hgFixed gtexTissueNew ~kate/kent/src/hg/lib/gtexTissue.sql $dir/gtexTissue.new.tab hgsql hgFixed -e 'alter table gtexTissueV6 rename to gtexTissueV6Old; alter table gtexTissueNew rename to gtexTissueV6' # Test GTEx track on hgwdev still works with new table +############ +# Correct cell type description, as per V8 portal page +# 4/29/20 KRR + + [hgFixed]> select * from gtexTissue where name like '%fibro%'; ++----+--------------------+---------------------------------+-------+----------+---------+ +| id | name | description | organ | color | abbrev | ++----+--------------------+---------------------------------+-------+----------+---------+ +| 22 | xformedfibroblasts | Cells - Transformed fibroblasts | Skin | 10141901 | FIBRBLS | ++----+--------------------+---------------------------------+-------+----------+---------+ +1 row in set (0.00 sec) + +MariaDB [hgFixed]> update gtexTissue set description="Cells - Cultured fibroblasts" where id=22; +