Schema for gene
  Database: visiGene    Primary Table: gene    Row Count: 20,413   Data last updated: 2007-02-10
Format description: Info on a gene
On download server: MariaDB table dump directory
fieldexampleSQL type info description
id 1int(11) range ID of gene
name Nkx2-6varchar(255) values Gene symbol (HUGO Gene Nomenclature Committee, if available)
locusLink  varchar(255) values NCBI LocusLink ID, or blank if none
refSeq  varchar(255) values RefSeq ID, or blank if none
genbank XM_127732varchar(255) values GenBank/EMBL accession, or blank if none
uniProt  varchar(255) values SwissProt/Uniprot accession, or blank if none
taxon 10090int(11) range NCBI taxon ID of organism

Connected Tables and Joining Fields
        visiGene.allele.gene (via gene.id)
      visiGene.geneSynonym.gene (via gene.id)
      visiGene.probe.gene (via gene.id)
      hg16.atlasOncoGene.locusSymbol (via gene.name)
      hg16.jaxOrtholog.humanSymbol (via gene.name)
      hg16.jaxOrtholog.mouseSymbol (via gene.name)
      hg16.kgAlias.alias (via gene.name)
      hg16.kgXref.geneSymbol (via gene.name)
      hg16.refFlat.geneName (via gene.name)
      hg17.kgAlias.alias (via gene.name)
      hg17.kgSpAlias.alias (via gene.name)
      hg17.kgXref.geneSymbol (via gene.name)
      hg17.refFlat.geneName (via gene.name)
      hg18.kgAlias.alias (via gene.name)
      hg18.kgSpAlias.alias (via gene.name)
      hg18.kgXref.geneSymbol (via gene.name)
      hg18.refFlat.geneName (via gene.name)
      hg19.kgAlias.alias (via gene.name)
      hg19.kgSpAlias.alias (via gene.name)
      hg19.kgXref.geneSymbol (via gene.name)
      hg19.refFlat.geneName (via gene.name)
      hg38.kgAlias.alias (via gene.name)
      hg38.kgSpAlias.alias (via gene.name)
      hg38.kgXref.geneSymbol (via gene.name)
      hg38.refFlat.geneName (via gene.name)
      hgFixed.refLink.name (via gene.name)
      uniProt.accToTaxon.taxon (via gene.taxon)
      uniProt.commonName.taxon (via gene.taxon)
      uniProt.taxon.id (via gene.taxon)
      visiGene.antibody.taxon (via gene.taxon)
      visiGene.genotype.taxon (via gene.taxon)
      visiGene.lifeStageScheme.taxon (via gene.taxon)
      visiGene.lifeTime.taxon (via gene.taxon)
      visiGene.specimen.taxon (via gene.taxon)
      visiGene.strain.taxon (via gene.taxon)
      ce2.sangerCanonical.protein (via gene.uniProt)
      ce2.sangerGene.proteinID (via gene.uniProt)
      ce2.sangerLinks.protName (via gene.uniProt)
      ce4.sangerCanonical.protein (via gene.uniProt)
      ce4.sangerGene.proteinID (via gene.uniProt)
      ce4.sangerLinks.protName (via gene.uniProt)
      ce6.sangerCanonical.protein (via gene.uniProt)
      ce6.sangerGene.proteinID (via gene.uniProt)
      ce6.sangerLinks.protName (via gene.uniProt)
      dm1.bdgpCanonical.protein (via gene.uniProt)
      dm1.bdgpGene.proteinID (via gene.uniProt)
      dm1.bdgpSwissProt.swissProtId (via gene.uniProt)
      dm1.flyBaseSwissProt.swissProtId (via gene.uniProt)
      go.goaPart.dbObjectId (via gene.uniProt)
      hg16.kgProtAlias.alias (via gene.uniProt)
      hg16.kgProtMap.qName (via gene.uniProt)
      hg16.kgXref.spID (via gene.uniProt)
      hg17.kgProtAlias.alias (via gene.uniProt)
      hg17.kgProtMap.qName (via gene.uniProt)
      hg17.kgSpAlias.spID (via gene.uniProt)
      hg17.kgXref.spID (via gene.uniProt)
      hg18.kgSpAlias.spID (via gene.uniProt)
      hg18.kgXref.spID (via gene.uniProt)
      hg19.kgSpAlias.spID (via gene.uniProt)
      hg19.kgXref.spID (via gene.uniProt)
      hg38.kgSpAlias.spID (via gene.uniProt)
      hg38.kgXref.spID (via gene.uniProt)
      knownGeneV39.kgProtAlias.alias (via gene.uniProt)
      knownGeneV39.kgSpAlias.spID (via gene.uniProt)
      knownGeneV39.kgXref.spID (via gene.uniProt)
      mm10.kgSpAlias.spID (via gene.uniProt)
      mm10.kgXref.spID (via gene.uniProt)
      mm7.kgProtAlias.alias (via gene.uniProt)
      mm7.kgProtMap.qName (via gene.uniProt)
      mm7.kgSpAlias.spID (via gene.uniProt)
      mm7.kgXref.spID (via gene.uniProt)
      mm8.kgProtAlias.alias (via gene.uniProt)
      mm8.kgProtMap.qName (via gene.uniProt)
      mm8.kgSpAlias.spID (via gene.uniProt)
      mm8.kgXref.spID (via gene.uniProt)
      mm9.kgSpAlias.spID (via gene.uniProt)
      mm9.kgXref.spID (via gene.uniProt)
      proteome.spOldNew.acc (via gene.uniProt)
      proteome.spReactomeEvent.spID (via gene.uniProt)
      proteome.spReactomeId.spID (via gene.uniProt)
      rn3.kgProtAlias.alias (via gene.uniProt)
      rn3.kgProtMap.qName (via gene.uniProt)
      rn3.kgSpAlias.spID (via gene.uniProt)
      rn3.kgXref.spID (via gene.uniProt)
      rn4.rgdGene2ToUniProt.value (via gene.uniProt)
      sacCer1.sgdCanonical.protein (via gene.uniProt)
      sacCer1.sgdGene.proteinID (via gene.uniProt)
      sacCer1.sgdToSwissProt.value (via gene.uniProt)
      sacCer2.sgdCanonical.protein (via gene.uniProt)
      sacCer2.sgdGene.proteinID (via gene.uniProt)
      sacCer2.sgdToSwissProt.value (via gene.uniProt)
      sacCer3.sgdCanonical.protein (via gene.uniProt)
      sacCer3.sgdGene.proteinID (via gene.uniProt)
      sacCer3.sgdToSwissProt.value (via gene.uniProt)
      uniProt.accToKeyword.acc (via gene.uniProt)
      uniProt.accToTaxon.acc (via gene.uniProt)
      uniProt.citation.acc (via gene.uniProt)
      uniProt.comment.acc (via gene.uniProt)
      uniProt.description.acc (via gene.uniProt)
      uniProt.displayId.acc (via gene.uniProt)
      uniProt.extDbRef.acc (via gene.uniProt)
      uniProt.feature.acc (via gene.uniProt)
      uniProt.gene.acc (via gene.uniProt)
      uniProt.geneLogic.acc (via gene.uniProt)
      uniProt.info.acc (via gene.uniProt)
      uniProt.otherAcc.acc (via gene.uniProt)
      uniProt.protein.acc (via gene.uniProt)

Sample Rows
 
idnamelocusLinkrefSeqgenbankuniProttaxon
1Nkx2-6XM_12773210090
2Nkx2-218088NM_010919U3156610090
3Nkx2-918094NM_008701NM_00870110090
4Hmx115371NM_010445NM_01044510090
5Foxo156458NM_019739NM_01973910090
6Foxg115228NM_008241NM_00824110090
7Foxa115375NM_008259NM_00825910090
8Foxa215376NM_010446NM_01044610090
9Foxb164290NM_022378NM_02237810090
10Foxc117300NM_008592NM_00859210090

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