Schema for stsAlias
  Database: hg38    Primary Table: stsAlias    Row Count: 654,210   Data last updated: 2015-08-21
Format description: STS marker aliases and associated identification numbers
On download server: MariaDB table dump directory
fieldexampleSQL type description
alias AFM214YG7varchar(255) STS marker name
identNo 1int(10) unsigned Identification number of STS marker
trueName AFM214YG7varchar(255) Official UCSC name for marker

Connected Tables and Joining Fields
        hg38.stsInfo2.identNo (via stsAlias.identNo)
      hg38.stsMap.identNo (via stsAlias.identNo)
      hg38.fishClones.stsNames (via stsAlias.trueName)
      hg38.stsInfo2.name (via stsAlias.trueName)
      hg38.stsInfo2.otherNames (via stsAlias.trueName)
      hg38.stsMap.name (via stsAlias.trueName)

Sample Rows
 
aliasidentNotrueName
AFM214YG71AFM214YG7
Z169791AFM214YG7
GDB:1883931AFM214YG7
D1S2431AFM214YG7
214YG71AFM214YG7
GC378-D1S2431AFM214YG7
RH152451AFM214YG7
HS214YG71AFM214YG7
AFM280WE52AFM280WE5
Z239942AFM280WE5

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