Schema for ucscRetroExtFile5
  Database: hg19    Primary Table: ucscRetroExtFile5    Row Count: 2   Data last updated: 2013-03-01
Format description: External (i.e. not in database) data file info
On download server: MariaDB table dump directory
fieldexampleSQL type info description
id 1int(10) unsigned range ID/index
name mrna.favarchar(64) values File name (without path)
path /gbdb/hg19/blastzRetro5/mrn...varchar(255) values Full path of file
size 525565824bigint(20) unsigned range byte size of file

Connected Tables and Joining Fields
        hg19.ucscRetroSeq5.extFile (via ucscRetroExtFile5.id)

Sample Rows
 
idnamepathsize
1mrna.fa/gbdb/hg19/blastzRetro5/mrna.fa525565824
2refseq.fa/gbdb/hg19/blastzRetro5/refseq.fa129678113

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