Schema for seqNcbiRefSeq
  Database: calJac4    Primary Table: seqNcbiRefSeq    Row Count: 107,273   Data last updated: 2020-10-27
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_001185034.1varchar(128) values Accession of sequence
size 2547int(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 2595int(10) unsigned range byte size of sequence in file

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

Sample Rows
 
idaccsizegb_dateextFilefile_offsetfile_size
1NM_001185034.125470000-00-00102595
2NM_001185037.114610000-00-00125951496
3NM_001185038.129190000-00-00140912972
4NM_001185041.110680000-00-00170631098
5NM_001185042.18250000-00-0018161852
6NM_001185043.113490000-00-00190131382
7NM_001185044.132150000-00-001103953272
8NM_001185045.117680000-00-001136671807
9NM_001199361.28360000-00-00115474863
10NM_001199901.112870000-00-001163371320

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