Schema for gtexTissueV8
  Database: hgFixed    Primary Table: gtexTissueV8    Row Count: 54   Data last updated: 2020-04-29
Format description: GTEx tissue information
fieldexampleSQL type info description
id 0int(10) unsigned range internal id
name adiposeSubcutvarchar(255) values short UCSC identifier
description Adipose - Subcutaneousvarchar(255) values GTEX tissue type detail
organ Adipose Tissuevarchar(255) values GTEX tissue collection area
color 16753999int(10) unsigned range GTEX assigned color
abbrev ADPSBQvarchar(255) values GTEX tissue abbreviation

Connected Tables and Joining Fields
        hgFixed.gtexSampleDataV8.tissue (via gtexTissueV8.name)

Sample Rows
 
idnamedescriptionorgancolorabbrev
0adiposeSubcutAdipose - SubcutaneousAdipose Tissue16753999ADPSBQ
1adiposeVisceralAdipose - Visceral (Omentum)Adipose Tissue15636992ADPVSC
2adrenalGlandAdrenal GlandAdrenal Gland9419919ADRNLG
3arteryAortaArtery - AortaBlood Vessel9116770ARTAORT
4arteryCoronaryArtery - CoronaryBlood Vessel15624784ARTCRN
5arteryTibialArtery - TibialBlood Vessel16711680ARTTBL
6bladderBladderBladder13481886BLDDER
7brainAmygdalaBrain - AmygdalaBrain15658496BRNAMY
8brainAnCinCortexBrain - Anterior cingulate cortex (BA24)Brain15658496BRNACC
9brainCaudateBrain - Caudate (basal ganglia)Brain15658496BRNCDT

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