Home     Genomes     Genome Browser     Blat     Tables     PCR     Session    FAQ     Help  
  Schema for refLink
  Database: bosTau4    Primary Table: refLink    Row Count: 9,844
Format description: Link together a refseq mRNA and other stuff
fieldexampleSQL type info description
name NAB2varchar(255) values Name displayed in UI
product NGFI-A binding protein 2varchar(255) values Name of protein product
mrnaAcc NM_001045897varchar(255) values mRNA accession
protAcc NP_001039362varchar(255) values protein accession
geneName 38116int unsigned range pointer to geneName table
prodName 158786int unsigned range pointer to prodName table
locusLinkId 504755int unsigned range Locus Link ID
omimId 0int unsigned range OMIM ID

  Connected Tables and Joining Fields
        bosTau4.gbCdnaInfo.geneName (via refLink.geneName)
      bosTau4.geneName.id (via refLink.geneName)
      bosTau4.gbCdnaInfo.acc (via refLink.mrnaAcc)
      bosTau4.gbSeq.acc (via refLink.mrnaAcc)
      bosTau4.gbStatus.acc (via refLink.mrnaAcc)
      bosTau4.imageClone.acc (via refLink.mrnaAcc)
      bosTau4.mrnaOrientInfo.name (via refLink.mrnaAcc)
      bosTau4.refFlat.name (via refLink.mrnaAcc)
      bosTau4.refGene.name (via refLink.mrnaAcc)
      bosTau4.refSeqAli.qName (via refLink.mrnaAcc)
      bosTau4.refSeqStatus.mrnaAcc (via refLink.mrnaAcc)
      bosTau4.refSeqSummary.mrnaAcc (via refLink.mrnaAcc)
      bosTau4.gbCdnaInfo.productName (via refLink.prodName)
      bosTau4.productName.id (via refLink.prodName)

  Sample Rows
 
nameproductmrnaAccprotAccgeneNameprodNamelocusLinkIdomimId
NAB2NGFI-A binding protein 2NM_001045897NP_001039362381161587865047550
POP4processing of precursor 4 isoform 1NM_001113282NP_001106753375742874716148700
PTRFpolymerase I and transcript release factorNM_001111103NP_00110457343095688315384570
MGC138057hypothetical protein LOC787344NM_001083531NP_001077000381622447737873440
CLTAclathrin, light polypeptide ANM_174022NP_776447387552447742810780
TNS4tensin 4NM_001038155NP_00103324436288618525328980
SPAG11Bsperm associated antigen 11BNM_001098154NP_0010916231932962447757830250
NFYAnuclear transcription factor Y, alphaNM_001014956NP_001014956383242198835395840
ACYP2acylphosphatase 2NM_001113230NP_001106701979632824307678890
HDAC2histone deacetylase 2NM_001075146NP_00106861434315594134072230

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