Schema for mrnaClone
  Database: hgFixed    Primary Table: mrnaClone    Row Count: 44,637,634   Data last updated: 2020-08-17
Format description: The name of the mRNA clone associated with 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.mrnaClone (via mrnaClone.id)

Sample Rows
 
idnamecrc
0n/a2299
1SAM-PR108114
2SAM-PRL431312
339H1118379
4NKNRT11423588
5NKNRT16423598
6NKNRT2-71692974
7NKNRT2-81692976
8NKNRT26423603
9NKNRT23423597

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