Schema for ucscRetroOrtho9
  Database: hg38    Primary Table: ucscRetroOrtho9    Row Count: 46,473   Data last updated: 2015-01-15
Format description: Orthlogy of retrogenes based on chains/nets with other species.
On download server: MariaDB table dump directory
fieldexampleSQL type info description
name A22930.1-6varchar(255) values Unique name of retrogene
db netCanFam3varchar(255) values database of other species
overlap 0int(11) range percent of retro that breaks net relative to other species

Connected Tables and Joining Fields
        hg38.ucscRetroAli9.qName (via ucscRetroOrtho9.name)
      hg38.ucscRetroInfo9.name (via ucscRetroOrtho9.name)

Sample Rows
 
namedboverlap
A22930.1-6netCanFam30
A22930.1-6netMm100
A22930.1-6netRheMac30
A22938.1-11netCanFam30
A22938.1-11netMm100
A22938.1-11netRheMac316
A22938.1-14netCanFam30
A22938.1-14netMm100
A22938.1-14netRheMac30
A22938.1-21netCanFam399

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