SGD Schema Specifications


This page contains links to current table specifications, schema diagrams, and download files (Excel format) for the SGD schema.
Click on a group to view the schema diagram.

Create and download a file with ALL SGD table information.

Group diagramTable namesDownload group information
Admin DBUSER, DELETE_LOG, UPDATE_LOG, TAB_RULE, COL_RULE, CODE, ARCHIVE, REF_CURATION, FEAT_CURATION Admin file
Colleague COLLEAGUE, COLLEAGUE_REMARK, COLL_RELATIONSHIP, KEYWORD, COLL_FEAT, COLL_URL, COLL_KW, COLL_GENERES Colleague file
CV CV, CV_TERM, CVTERM_GROUP, CVTERM_SYNONYM, CVTERM_RELATIONSHIP, CVTERM_DBXREF CV file
Expression DATASET, DATASET_DISPLAY, DATASET_SAMPLE, SAMPLE_VALUE, DATASET_GROUP, REGULATOR, DG_FEAT, DS_REG Expression file
Feature ALIAS, FEATURE, FEAT_RELATIONSHIP, FEAT_PROPERTY, FEAT_ANNOTATION, GENE_RESERVATION, TWO_POINT, PARAGRAPH, FEAT_TWOPT, FEAT_ALIAS, FEAT_URL, FEAT_PARA Feature file
General NOTE, NOTE_LINK, DBXREF, DBXREF_FEAT, DBXREF_REF, DBXREF_URL, URL, WEB_DISPLAY, WEB_METADATA General file
Genomics HOMOLOG, HOMOLOG_ALIGNMENT, PDB_SEQUENCE, PDB_ALIGNMENT, ALIGNMENT_SEQUENCE Genomics file
GO GO, GO_SYNONYM, GO_PATH, GO_SET, GO_ANNOTATION, GO_REF, GO_QUALIFIER, GO_GOSYN, GOREF_DBXREF GO file
Gus GUS_FEATURE, GUS_SCAFFOLD, GUS_CONTIG, GUS_SEQ, GUS_ALIGNMENT, GUS_FEAT_CONTIG Gus file
Phenotype INTERACTION, PHENOTYPE, PHENO_ANNOTATION, EXPERIMENT, EXPT_PROPERTY, EXPT_EXPTPROP, INTERACT_PHENO, INTERACT_REF, FEAT_INTERACT Phenotype file
Reference ABSTRACT, AUTHOR, AUTHOR_EDITOR, BOOK, JOURNAL, REFERENCE, REF_RELATIONSHIP, REF_TYPE, LIT_GUIDE, REF_LINK, REF_BAD, REF_UNLINK, REF_TEMP, REF_REFTYPE, REF_URL, LITGUIDE_FEAT Reference file
SAGE SAGE_EXPRESSION, SAGE_TAG, SAGE_TAG_LOCATION SAGE file
Sequence SEQ, SEQ_CHANGE_ARCHIVE, FEAT_LOCATION, PROTEIN_INFO, PROTEIN_DETAIL, ORGANISM, RELEASE, SEQ_REL, FEATLOC_REL Sequence file
Taxonomy TAXONOMY, TAX_SYNONYM, TAX_RELATIONSHIP Taxonomy file