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

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

Sample Rows
 
idnamecrc
0n/a2299
1homoserine kinase3784277909
2N-acetylglutamate synthase2455414929
3riboflavin synthase beta chain2488344764
4photosynthetic reaction center L subunit1564318697
5HacA6954
6Heme oxygenase2812721715
7M161Ag96392
8dinitrogenase reductase1294198157
9A-ATPase A-subunit1155912284

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