Schema for blastKGRef02
  Database: hg17    Primary Table: blastKGRef02    Row Count: 37,365   Data last updated: 2005-06-25
Format description: Mapping table for tblastn protein tracks
On download server: MariaDB table dump directory
fieldexampleSQL type info description
acc AB000409varchar(255) values accession
geneId MKNK1varchar(255) values gene name
refPos chr1:46736269-46771838varchar(255) values Reference Position
extra1 Q9BUB5-2varchar(255) values other link 1 (e.g. SwissProt name)
extra2  varchar(255) values other link 2

Connected Tables and Joining Fields
        hg17.blastKGPep02.name (via blastKGRef02.acc)
      hg17.knownGene.name (via blastKGRef02.acc)

Sample Rows
 
accgeneIdrefPosextra1extra2
AB000409MKNK1chr1:46736269-46771838Q9BUB5-2
AB000460C4orf8chr4:2669937-2770798P78311_HUMAN
AB000461C4orf8chr4:2669937-2735315P78313_HUMAN
AB000463SH3BP2chr4:2859349-2862178P78314-2
AB000781KNDC1chr10:134869858-134927272Q76NI1_HUMAN
AB000815ARNTLchr11:13332431-13344904O00327-3
AB001025RYR3chr15:31390538-31944716Q15413-2
AB001328SLC15A1chr13:98171363-98176520Q9BZ22_HUMAN
AB001535TRPM2chr21:44613525-44686125Q5KTC1_HUMAN
AB002292ARHGEF10chr8:1804768-1892833ARHGA_HUMAN

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