Schema for geneName
  Database: hgFixed    Primary Table: geneName    Row Count: 474,796   Data last updated: 2020-08-17
Format description: The gene name of a genbank sequence
On download server: MariaDB table dump directory
fieldexampleSQL type info description
id 0int(11) range Unique numerical id
name n/alongtext values Associated text
crc 2299int(10) unsigned range Checksum of name, which is used to speedup the update of this table

Connected Tables and Joining Fields
        hgFixed.gbCdnaInfo.geneName (via geneName.id)
      hgFixed.refLink.geneName (via geneName.id)

Sample Rows
 
idnamecrc
0n/a2299
1thrB10010
2argA8888
3sam-pr151442
423S rRNA1130820
5pufL9931
6hacA9034
7nifH9589
8azr2487
9enolA35664

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