Schema for seqNcbiRefSeq
  Database: hg38    Primary Table: seqNcbiRefSeq    Row Count: 185,380   Data last updated: 2024-09-11
Format description: Information about sequences contained in files described in extFile
On download server: MariaDB table dump directory
fieldexampleSQL type info description
id 1int(10) unsigned range ID/index
acc NM_000014.6varchar(128) values Accession of sequence
size 4610int(10) unsigned range Size of sequence (number of bases)
gb_date 0000-00-00date   unused
extFile 1int(10) unsigned range ID/index of file in extFile
file_offset 0bigint(20) range byte offset of sequence in file
file_size 4681int(10) unsigned range byte size of sequence in file

Connected Tables and Joining Fields
        hg38.ncbiRefSeq.name (via seqNcbiRefSeq.acc)
      hg38.ncbiRefSeqCds.id (via seqNcbiRefSeq.acc)
      hg38.ncbiRefSeqCurated.name (via seqNcbiRefSeq.acc)
      hg38.ncbiRefSeqHgmd.name (via seqNcbiRefSeq.acc)
      hg38.ncbiRefSeqLink.id (via seqNcbiRefSeq.acc)
      hg38.ncbiRefSeqPredicted.name (via seqNcbiRefSeq.acc)
      hg38.ncbiRefSeqPsl.qName (via seqNcbiRefSeq.acc)
      hg38.ncbiRefSeqSelect.name (via seqNcbiRefSeq.acc)
      hg38.extNcbiRefSeq.id (via seqNcbiRefSeq.extFile)

Sample Rows
 
idaccsizegb_dateextFilefile_offsetfile_size
1NM_000014.646100000-00-00104681
2NM_000015.312850000-00-00146811315
3NM_000016.622610000-00-00159962303
4NM_000017.418590000-00-00182991896
5NM_000018.421840000-00-001101952225
6NM_000019.415370000-00-001124201570
7NM_000020.341770000-00-001139904243
8NM_000021.460180000-00-001182336107
9NM_000022.414960000-00-001243401528
10NM_000023.414290000-00-001258681460

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