Schema for blastKGRef01
  Database: hg17    Primary Table: blastKGRef01    Row Count: 42,156   Data last updated: 2005-04-12
Format description: Mapping table for tblastn protein tracks
On download server: MariaDB table dump directory
fieldexampleSQL type info description
acc AB000099varchar(255) values accession
geneId DSCR4varchar(255) values gene name
refPos chr21:38348821-38415219varchar(255) values Reference Position
extra1 DSR4_HUMANvarchar(255) values other link 1 (e.g. SwissProt name)
extra2  varchar(255) values other link 2

Connected Tables and Joining Fields
        hg17.blastKGPep01.name (via blastKGRef01.acc)
      hg17.knownGene.name (via blastKGRef01.acc)
      uniProt.displayId.acc (via blastKGRef01.extra1)

Sample Rows
 
accgeneIdrefPosextra1extra2
AB000099DSCR4chr21:38348821-38415219DSR4_HUMAN
AB000114OMDchr9:92256991-92259395OMD_HUMAN
AB000115IFI44Lchr1:78805738-78819512Q99984
AB000220SEMA3Cchr7:80018863-80190748SM3C_HUMAN
AB000277DLGAP1chr18:3489185-3870068DLP1_HUMAN
AB000449VRK1chr14:96369561-96417295VRK1_HUMAN
AB000459C4orf8chr4:2669937-2770798P78311
AB000460C4orf8chr4:2669937-2770798P78312
AB000461C4orf8chr4:2669937-2735315P78313
AB000462SH3BP2chr4:2859349-28725643BP2_HUMAN

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