Schema for gtexSampleDataV8
  Database: hgFixed    Primary Table: gtexSampleDataV8    Row Count: 976,868,400   Data last updated: 2020-04-23
Format description: GTEX Expression data (RPKM levels, unmapped)
fieldexampleSQL type description
geneId ENSG00000223972.5varchar(255) Gene identifier (ensembl)
sample GTEX-1117F-0226-SM-5GZZ7varchar(255) GTEX sample identifier
tissue adiposeSubcutvarchar(255) Tissue short name
score 0float Expression level (RPKM)

Connected Tables and Joining Fields
        hg19.gtexGeneModelV8.name (via gtexSampleDataV8.geneId)
      hg19.gtexGeneV8.geneId (via gtexSampleDataV8.geneId)
      hg38.gtexGeneModelV8.name (via gtexSampleDataV8.geneId)
      hg38.gtexGeneV8.geneId (via gtexSampleDataV8.geneId)
      hgFixed.gtexSampleV8.sampleId (via gtexSampleDataV8.sample)
      hgFixed.gtexTissueV8.name (via gtexSampleDataV8.tissue)

Sample Rows
 
geneIdsampletissuescore
ENSG00000223972.5GTEX-1117F-0226-SM-5GZZ7adiposeSubcut0
ENSG00000223972.5GTEX-ZZPU-2726-SM-5NQ8OadiposeSubcut0.025
ENSG00000223972.5GTEX-ZZ64-1626-SM-5E43WadiposeSubcut0
ENSG00000223972.5GTEX-ZYY3-0226-SM-5E45MadiposeSubcut0
ENSG00000223972.5GTEX-ZYW4-0226-SM-5E44MadiposeSubcut0
ENSG00000223972.5GTEX-ZYVF-0226-SM-5GIEGadiposeSubcut0
ENSG00000223972.5GTEX-ZYT6-0326-SM-7LG5RadiposeSubcut0
ENSG00000223972.5GTEX-ZYFD-0226-SM-5NQ86adiposeSubcut0
ENSG00000223972.5GTEX-ZYFC-0326-SM-5NQ7HadiposeSubcut0
ENSG00000223972.5GTEX-ZXG5-0226-SM-59HJIadiposeSubcut0

Note: all start coordinates in our database are 0-based, not 1-based. See explanation here.