96962227b59e566541cf63670087bbed487a4682
kate
  Mon Apr 27 15:37:26 2020 -0700
Straighten out tables names wrt versioning and add track for GTEx Gene track update to V8 (final). refs #25130

diff --git src/hg/makeDb/doc/gtex/V8.txt src/hg/makeDb/doc/gtex/V8.txt
index 817c0fc..1329f39 100644
--- src/hg/makeDb/doc/gtex/V8.txt
+++ src/hg/makeDb/doc/gtex/V8.txt
@@ -110,32 +110,37 @@
 | gtexV8TissueMedianMale      |
 +-----------------------------+
 
 # merge gtexV8Info into gtexInfo (i.e. add a row for V8)
 hgsql hgFixed -e 'select * from gtexV8Info';
 +---------+-------------+----------+----------------+
 | version | releaseDate | maxScore | maxMedianScore |
 +---------+-------------+----------+----------------+
 | V8      | 0           |        0 |         747400 |
 +---------+-------------+----------+----------------+
 
 # get release date from GTEx portal
 hgsql hgFixed -e "insert into gtexInfo set version='V8', releaseDate='2019-08-26', maxMedianScore=747400"
 
 # Rename tables for use by hgGtexGeneBed
+# TODO: Change hgGtex to name tables as needed by next step!
 
 hgsql hgFixed -e 'alter table gtexV8TissueMedianAll rename to gtexTissueMedianV8';
+hgsql hgFixed -e 'alter table gtexV8Tissue rename to gtexTissueV8';
+hgsql hgFixed -e 'alter table gtexV8Sample rename to gtexSampleV8';
+hgsql hgFixed -e 'alter table gtexV8Donor rename to gtexDonorV8';
+hgsql hgFixed -e 'alter table gtexV8SampleData rename to gtexSampleDataV8';
 
 #######################################
 # Download fine-mapped eQTL's
 
 cd ../
 mkdir eQtl
 cd eQtl
 wget -nd https://storage.googleapis.com/gtex_analysis_v8/single_tissue_qtl_data/README_eQTL_v8.txt
 
 wget -nd https://storage.googleapis.com/gtex_analysis_v8/single_tissue_qtl_data/GTEx_v8_finemapping_CAVIAR.tar
 
 tar vf GTEx_v8_finemapping_CAVIAR.tar
 ln -s GTEx_v8_finemapping_CAVIAR caviar
 cd caviar