Schema for seqNcbiRefSeq
  Database: ailMel1    Primary Table: seqNcbiRefSeq    Row Count: 40,431   Data last updated: 2020-04-01
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_001278922.1varchar(128) values Accession of sequence
size 945int(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 973int(10) unsigned range byte size of sequence in file

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

Sample Rows
 
idaccsizegb_dateextFilefile_offsetfile_size
1NM_001278922.19450000-00-0010973
2NM_001281868.16630000-00-001973688
3NM_001282046.115060000-00-00116611541
4NM_001285939.111060000-00-00132021136
5NM_001291458.142210000-00-00143384290
6NM_001291460.116600000-00-00186281697
7NM_001291461.18700000-00-00110325897
8NM_001293700.116680000-00-001112221705
9NM_001304841.14180000-00-00112927440
10NM_001304842.18140000-00-00113367841

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