Schema for gtexSampleV8
  Database: hgFixed    Primary Table: gtexSampleV8    Row Count: 17,382   Data last updated: 2020-04-28
Format description: GTEx sample description
fieldexampleSQL type info description
sampleId GTEX-1117F-0226-SM-5GZZ7varchar(255) values GTEx sample identifier
tissue adiposeSubcutvarchar(255) values Tissue name. Links to tissue table
donor GTEX-1117Fvarchar(255) values GTEx subject identifier. Links to donor table
autolysisScore 0int(11) range Level of tissue self-digestion (0-3; none,mild,moderate,severe, -1 if unknown)
ischemicTime n/avarchar(255) values Time from tissue removal to preservation, in 4hr intervals
rin 6.8float range RNA Integrity Number
collectionSites B1varchar(255) values GTEx Biospecimen Source Site list
batchId BP-43693varchar(255) values Nucleic acid isolation batch ID
isolationType RNA_Extraction_from_Paxgene...varchar(255) values Type of nucleic acid isolation
isolationDate 09/17/2013varchar(255) values Date of nucleic acid isolation
pathNotes 2 pieces, ~15% vessel strom...varchar(1024) values Pathology report notes

Connected Tables and Joining Fields
        hgFixed.gtexDonorV8.name (via gtexSampleV8.donor)
      hgFixed.gtexSampleDataV8.sample (via gtexSampleV8.sampleId)

Sample Rows
 
sampleIdtissuedonorautolysisScoreischemicTimerincollectionSitesbatchIdisolationTypeisolationDatepathNotes
GTEX-1117F-0226-SM-5GZZ7adiposeSubcutGTEX-1117F0n/a6.8B1BP-43693RNA_Extraction_from_Paxgene-derived_Lysate_Plate_Based09/17/20132 pieces, ~15% vessel stroma, rep delineated
GTEX-1117F-0426-SM-5EGHImuscleSkeletalGTEX-1117F0n/a7.1B1BP-43495RNA_Extraction_from_Paxgene-derived_Lysate_Plate_Based09/12/20132 pieces, !5% fibrous connective tissue, delineated (rep)
GTEX-1117F-0526-SM-5EGHJarteryTibialGTEX-1117F0n/a8B1BP-43495RNA_Extraction_from_Paxgene-derived_Lysate_Plate_Based09/12/20132 pieces, clean, Monckebeg medial sclerosis, rep delineated
GTEX-1117F-0626-SM-5N9CSarteryCoronaryGTEX-1117F1n/a6.9B1BP-43956RNA_Extraction_from_Paxgene-derived_Lysate_Plate_Based09/25/20132 pieces, up to 4mm aderent fat/nerve/vessel, delineated
GTEX-1117F-0726-SM-5GIENheartAtrialAppendGTEX-1117F1n/a6.3B1BP-44261RNA_Extraction_from_Paxgene-derived_Lysate_Plate_Based10/03/20132 pieces, no abnormalities
GTEX-1117F-1326-SM-5EGHHadiposeVisceralGTEX-1117F1n/a5.9B1BP-43495RNA_Extraction_from_Paxgene-derived_Lysate_Plate_Based09/12/20132 pieces, diffuse mesothelial hyperplasia; ~10% vessel/fibrous tissue (delineated)
GTEX-1117F-2426-SM-5EGGHuterusGTEX-1117F1n/a6.3B1BP-44460RNA_Extraction_from_Paxgene-derived_Lysate_Plate_Based10/08/20131 piece mymetrial smooth muscle as in corresonding -25 block
GTEX-1117F-2526-SM-5GZY6vaginaGTEX-1117F2n/a6.5B1BP-43693RNA_Extraction_from_Paxgene-derived_Lysate_Plate_Based09/17/20136  pieces, squamous epithelium is ~ 2-3% thickness, partially sloughing
GTEX-1117F-2826-SM-5GZXLbreastMamTissueGTEX-1117F1n/a5.8B1BP-43507RNA_Extraction_from_Paxgene-derived_Lysate_Plate_Based09/12/20132 pieces, fibrocystic changes, rep ductal/lobular elements delineated
GTEX-1117F-2926-SM-5GZYIskinNotExposedGTEX-1117F0n/a7.7B1BP-43693RNA_Extraction_from_Paxgene-derived_Lysate_Plate_Based09/17/20136 pieces, minimal fat, squamous epithelium is ~50 microns, ~3% thickness

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