Schema for seqNcbiRefSeq
  Database: geoFor1    Primary Table: seqNcbiRefSeq    Row Count: 22,226   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_001291648.1varchar(128) values Accession of sequence
size 2169int(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 2213int(10) unsigned range byte size of sequence in file

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

Sample Rows
 
idaccsizegb_dateextFilefile_offsetfile_size
1NM_001291648.121690000-00-00102213
2NM_001293048.118670000-00-00122131907
3NM_001293751.115670000-00-00141201603
4XM_005415411.262430000-00-00157236338
5XM_005415412.226710000-00-001120612721
6XM_005415414.218970000-00-001147821937
7XM_005415418.223490000-00-001167192395
8XM_005415419.210460000-00-001191141076
9XM_005415420.27710000-00-00120190797
10XM_005415421.212760000-00-001209871308

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