Schema for seqNcbiRefSeq
  Database: droPer1    Primary Table: seqNcbiRefSeq    Row Count: 17,352   Data last updated: 2018-02-09
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 XM_002012702.1varchar(128) values Accession of sequence
size 348int(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 369int(10) unsigned range byte size of sequence in file

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

Sample Rows
 
idaccsizegb_dateextFilefile_offsetfile_size
1XM_002012702.13480000-00-0010369
2XM_002012703.152890000-00-0013695372
3XM_002012704.112660000-00-00157411298
4XM_002012705.13810000-00-0017039402
5XM_002012706.120580000-00-00174412100
6XM_002012707.120790000-00-00195412121
7XM_002012708.123010000-00-001116622346
8XM_002012709.112300000-00-001140081262
9XM_002012710.112600000-00-001152701292
10XM_002012711.11890000-00-00116562208

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