Schema for oregannoLink
  Database: mm10    Primary Table: oregannoLink    Row Count: 1,090,603   Data last updated: 2015-10-23
Format description: links for ORegAnno regulatory region
On download server: MariaDB table dump directory
fieldexampleSQL type description
id OREG0000240varchar(48) key into the oreganno table
attribute SrcLinkvarchar(48) name of attribute being listed
raKey ORegAnnovarchar(48) key into RA file, tells how to link
attrAcc OREG0000240varchar(255) accession used by link

Connected Tables and Joining Fields
        mm10.oreganno.id (via oregannoLink.id)
      mm10.oregannoAttr.id (via oregannoLink.id)

Sample Rows
 
idattributeraKeyattrAcc
OREG0000240SrcLinkORegAnnoOREG0000240
OREG0000240GeneEnsemblIdENSMUSG00000017950
OREG0000240ExtLinkPubMed11522818
OREG0000241SrcLinkORegAnnoOREG0000241
OREG0000241GeneEnsemblIdENSMUSG00000029368
OREG0000241ExtLinkPubMed15933209
OREG0000241TFbsEnsemblIdENSMUSG00000029556
OREG0000242SrcLinkORegAnnoOREG0000242
OREG0000242GeneEnsemblIdENSMUSG00000018893
OREG0000242ExtLinkPubMed15933209

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