# SCHEMA hgd DATABASE: hgd DESCRIPTION: "Human Genome Database (Version 6.2) " PROPERTIES: "OB_AdminGroupID" "-5" FOREIGN_DATABASES { ( "registry", "Genome Registry Data Base" ) } CONTROLLED VALUE CLASS AdminAnnotationTypeDict { ( "Include in Annual Report", IncludeInReport ), ( "Checked by CC", checkedByCC ) } CODE_TYPE: VARCHAR(20) CONTROLLED VALUE CLASS AliasTypeDict { ( "PrimaryName", 0 ), ( "Alias", 1 ), ( "DNA Segment Number", 2), ( "DNA Segment Number - Obsolete", 3) } DEFAULT: "Alias" CODE_TYPE: SMALLINT DESCRIPTION: "Specifies alias type (primary or alias name)" CONTROLLED VALUE CLASS AminoAcidDict { ( "Alanine", ala ), ( "Arginine", arg ), ( "Asparagine", asn ), ( "Aspartic acid", asp ), ( "Cysteine", cys ), ( "Glutamine", gln ), ( "Glutamic acid", glu ), ( "Glycine", gly ), ( "Histidine", his ), ( "Isoleucine", ile ), ( "Leucine", leu ), ( "Lysine", lys ), ( "Methionine", met ), ( "Phenylalanine", phe ), ( "Proline", pro ), ( "Serine", ser ), ( "Threonine", thr ), ( "Tryptophan", trp ), ( "Tyrosine", tyr ), ( "Valine", val ) } CODE_TYPE: VARCHAR(3) DESCRIPTION: "Amino acid dictionary" CONTROLLED VALUE CLASS AnnotationTypeDict { ( "Comment", Comment ) , ( "Data Change Request", ChangeRequest ), ( "GDB 5.x history", GDB5.x ), ( "Deletion Request", DeleteRequest ), ( "Cascade Deleted", CascadeDeleted ), ( "Request Owner Change", ChangeOwner) } DEFAULT: "Comment" CODE_TYPE: VARCHAR(20) CONTROLLED VALUE CLASS ASOTypeDict { ( "Wild Type", WildType ), ( "Mutant", Mutant ), ( "Unknown", Unknown ) } CODE_TYPE: VARCHAR(20) CONTROLLED VALUE CLASS AvailabilityDict { ( "Unknown", Unknown ) , ( "Freely available", FreelyAvailable ), ( "For collaborators", Collaborators ), ( "In the future", Future ), ( "Not available", Unavailable ), ( "With restrictions", Restrictions ) } DEFAULT: "Unknown" CODE_TYPE: VARCHAR(20) CONTROLLED VALUE CLASS BreakpointCauseDict { ( "Unknown", Unknown ), ( "Natural", Natural ), ( "Experimental", Experimental ) } DEFAULT: "Unknown" CODE_TYPE: VARCHAR(20) DESCRIPTION: "Breakpoint cause type description" CONTROLLED VALUE CLASS CellLineTypeDict { ( "Unknown", Unknown ), ( "Somatic Cell Hybrid", SCH ), ( "Lymphoblast", Lymphoblast ), ( "Lymphocyte", Lymphocyte ), ( "Fibroblast", Fibroblast ), ( "Tumor cell line", Tumor ), ( "Radiation Hybrid", RH ), ( "Other", Other ) } DEFAULT: "Unknown" CODE_TYPE: VARCHAR(20) CONTROLLED VALUE CLASS ChimerismBasisDict { ( "Fluorescence In Situ Hybridization (FISH)", FISH ), ( "PCR with somatic cell hybrids", Hybrids ), ( "Restriction mapping", RestrictionMapping ), ( "Inferred from map position and insert size", Inferred ) } CODE_TYPE: VARCHAR(20) CONTROLLED VALUE CLASS CompartmentDict { ( "Nucleus", Nucleus ), ( "Mitochondrion", Mitochondrion ) } DEFAULT: "Nucleus" CODE_TYPE: VARCHAR(20) DESCRIPTION: "Organelle compartment dictionary" CONTROLLED VALUE CLASS CytogeneticBandDict { ( "R-Band", RBand ), ( "G-Band", GBand ), ( "Satellite", Satellite ), ( "Telomere", Telomere ), ( "Centromere", Centromere ) } CODE_TYPE: VARCHAR(20) DESCRIPTION: "Cytogenetic band dictionary" CONTROLLED VALUE CLASS CytogeneticResolutionDict { ( "400", 400 ), ( "550", 550 ), ( "850", 850 ) } CODE_TYPE: VARCHAR(10) CONTROLLED VALUE CLASS DBObjectStatusDict { ( "Active", Active, "Active" ), ( "Merged", Merged, "Merged" ), ( "Split", Split, "Split" ), ( "Ambiguous", Ambig, "Ambiguous" ), ( "Conflict", Conflict, "Conflict" ), ( "Deactivated", Deactivated, "Deactivated" ) } DEFAULT: "Active" CODE_TYPE: VARCHAR(20) DESCRIPTION: "Description of the status of an object with respect to splits and merges" CONTROLLED VALUE CLASS DNATypeDict { ( "Unknown", Unknown, "Unknown" ), ( "Genomic DNA", Genomic, "Genomic DNA" ), ( "Synthetic DNA", Synthetic, "Synthetic DNA" ), ( "Viral DNA", Viral, "Viral DNA" ), ( "cDNA", cDNA, "cDNA" ) } DEFAULT: "Unknown" CODE_TYPE: VARCHAR(20) DESCRIPTION: "DNA type dictionary" CONTROLLED VALUE CLASS EndpointDict { ( "Entire", Entire ), ( "Start", Start ), ( "End", End ) } DEFAULT: "Entire" CODE_TYPE: VARCHAR(20) DESCRIPTION: "Specifies end of GenomicSegment that constraint applies to. Start and end are relative to the frame of reference in which the term appears." CONTROLLED VALUE CLASS EnzymeUseDict { ( "Single Digest", SingleDigest ), ( "Double Digest", DoubleDigest ), ( "Alternate Digest", AlternateDigest ) } CODE_TYPE: VARCHAR(20) CONTROLLED VALUE CLASS ErrorTypeDict { ( "Standard error", StdErr ), ( "LOD", LOD ) } DEFAULT: "Standard error" CODE_TYPE: VARCHAR(20) CONTROLLED VALUE CLASS FragileSiteAgentDict { ( "Unclassified", Unclassified ), ( "5-Azacytidine type", Azacytidine5 ), ( "BrdU type", BrdU ), ( "Aphidicolin type", Aphidicolin ), ( "Distamycin A type", DistamycinA ), ( "Folic acid type", FolicAcid ) } DEFAULT: "Unclassified" CODE_TYPE: VARCHAR(20) DESCRIPTION: "Chemical agents that produces a fragile site" CONTROLLED VALUE CLASS FontStyleDict { ( "Normal", Normal ), ( "Bold", Bold ), ( "Italic", Italic ), ( "Underlined", Underlined ) } DEFAULT: "Normal" CODE_TYPE: VARCHAR(20) CONTROLLED VALUE CLASS GeneElementTypeDict { ( "Other", Other ), ( "Intron", Intron ), ( "Exon", Exon ), ( "Transcription Start Site", TranscriptionStart ), ( "Polyadenylation site", Polyadenylation ) } DEFAULT: "Other" CODE_TYPE: VARCHAR(20) CONTROLLED VALUE CLASS GeneEvidenceDict { ( "Resolved phenotype", Phenotype, "Resolved phenotype -- genetic mapping of a factor influencing a heritable phenotype" ), ( "Computational Analysis", CompAnalysis, "Predicted based on computational analysis with gene finding algorithm e.g., GRAIL" ), ( "DNA sequence-based similarity", SeqSimilarity, "DNA sequence-based similarity" ), ( "Peptide sequence-based homology", PeptideHomology, "Peptide sequence-based homology" ), ( "Structure homology", StructHomology, "Structure homology" ), ( "Exon trapping", ExonTrapping, "Clone isolated by in vitro trapping of splice sites or other sequence motifs" ), ( "Mutations associated with phenotype", Mutation, "Putative gene contains mutations found only in individuals expressing a phenotype" ), ( "Association with a cDNA", cDNAAssoc, "Association with a cDNA" ), ( "Cross-species conservation", CrossSpeciesCons, "Cross-species conservation" ) } CODE_TYPE: VARCHAR(20) DESCRIPTION: "Justifications for calling this genomic segment a gene." CONTROLLED VALUE CLASS GrowthStageDict { ( "Unknown", Unknown, "Unknown" ), ( "Fetal", Fetal, "Fetal" ), ( "Adult", Adult, "Adult" ), ( "Infant", Infant, "Infant" ), ( "Child", Child, "Child" ) } DEFAULT: "Unknown" CODE_TYPE: VARCHAR(20) CONTROLLED VALUE CLASS IsolationMethodDict { ( "Flow Sorted", Flowsorted ), ( "Other", Other ) } DEFAULT: "Flow Sorted" CODE_TYPE: VARCHAR(20) DESCRIPTION: "Methods of isolating chromosomal reagents." CONTROLLED VALUE CLASS LibLocationTypeDict { ( "Original", Original, "Original library location" ), ( "Replated", Replated, "Replated library location" ) } DEFAULT: "Original" CODE_TYPE: VARCHAR(20) DESCRIPTION: "Valid library location type for clones" CONTROLLED VALUE CLASS LineStyleDict { ( "Solid", Solid ), ( "Dashed", Dashed ), ( "Dotted", Dotted ) } DEFAULT: "Solid" CODE_TYPE: VARCHAR(20) CONTROLLED VALUE CLASS MapSexDict { ( "Unknown", Unknown, "Unknown" ) , ( "Male", Male, "Male" ), ( "Female", Female, "Female" ), ( "Sex-averaged", SexAveraged, "Sex-averaged" ) } DEFAULT: "Unknown" CODE_TYPE: VARCHAR(20) DESCRIPTION: "Gender dictionary" CONTROLLED VALUE CLASS ObservationTypeDict { ( "Unknown", Unknown ), ( "Amplifies from", Amplifies ), ( "Hybridizes with", Hybridizes ), ( "Subcloned from end of", EndClone ), ( "Subcloned from", Subclone ), ( "Sequenced from end of", EndSeq ), ( "Sequenced from", Seq ), ( "Shares sequence identity with", SeqIdent ), ( "Copied from", Copy ), ( "Shares Fingerprint with", Fingerprint ) } DEFAULT: "Unknown" CODE_TYPE: VARCHAR(20) CONTROLLED VALUE CLASS ObservationTypePlusDict { ( "Unknown", Unknown ), ( "Amplifies from", Amplifies ), ( "Is template for", TemplateFor ), ( "Hybridizes with", Hybridizes ), ( "Subcloned from end of", EndClone ), ( "Has end clone", HasEndClone ), ( "Subcloned from", Subclone ), ( "Has subclone", HasSubclone ), ( "Sequenced from end of", EndSeq ), ( "Source of end sequence for", SourceEndSeq ), ( "Sequenced from", Seq ), ( "Source of sequence for", SourceSeq ), ( "Shares sequence identity with", SeqIdent ), ( "Copied from", Copy ), ( "Has copy", HasCopy ), ( "Shares Fingerprint with", Fingerprint ) } DEFAULT: "Unknown" CODE_TYPE: VARCHAR(20) CONTROLLED VALUE CLASS OccurrenceFreqDict { ( "Common", Common, "Common" ), ( "Rare", Rare, "Rare" ) } CODE_TYPE: VARCHAR(20) DESCRIPTION: "Fragile Site Type dictionary" CONTROLLED VALUE CLASS OrderLikelihoodTypeDict { ( "LOD", LOD ), ( "P-Value", Pvalue), ( "Likelihood", Like ) } DEFAULT: "LOD" CODE_TYPE: VARCHAR(20) CONTROLLED VALUE CLASS OrderRelationshipDict { ( "Overlaps", Overlaps ), ( "No Overlap", Gap ), ( "Inconsistent", Inconsistent ), ( "First Overhangs Left", OverlapLeft ), ( "Both Overhang", OverlapBoth ), ( "Before", Before ), ( "Abuts", Abuts ), ( "Contained In", ContainedIn ), ( "Contained Left", ContainedLeft ), ( "Contained Right", ContainedRight ), ( "Identical", Identical ) } DEFAULT: "Overlaps" CODE_TYPE: VARCHAR(20) CONTROLLED VALUE CLASS OrderRelationshipPlusDict { ( "Overlaps", Overlaps ), ( "No Overlap", Gap ), ( "Inconsistent", Inconsistent ), ( "First Overhangs Left", OverlapLeft ), ( "First Overhangs Right", OverlapRight ), ( "Both Overhang", OverlapBoth ), ( "Before", Before ), ( "After", After ), ( "Abuts", Abuts ), ( "Contained In", ContainedIn ), ( "Contains", Contains ), ( "Contained Left", ContainedLeft ), ( "Contains Left", ContainsLeft ), ( "Contained Right", ContainedRight ), ( "Contains Right", ContainsRight ), ( "Identical", Identical ) } DEFAULT: "Overlaps" CODE_TYPE: VARCHAR(20) CONTROLLED VALUE CLASS PloidyDict { ( "Haploid", Haploid, "Haploid" ), ( "Diploid", Diploid, "Diploid" ), ( "Unknown", Unknown, "Unknown" ) } CODE_TYPE: VARCHAR(20) DESCRIPTION: "Cell ploidy dictionary" CONTROLLED VALUE CLASS PopulationSpecDict { ( "Race", 0, "Race" ), ( "Subgeographic region", 1, "Continental subregion" ), ( "Directional", 2, "Compass directions" ), ( "Relatedness", 3, "Familial relationships" ), ( "Disease", 4, "Clinical phenotype" ), ( "Sex", 5, "Gender" ), ( "Study Group", 6, "Reference individuals from a research project" ), ( "Ethnic isolate", 7, "Ethnic group" ), ( "Continent", 8, "Continent" ), ( "Country", 9, "Country" ), ( "State", 10, "State" ), ( "City", 11, "City" ) } CODE_TYPE: INTEGER DESCRIPTION: "Population specification description" CONTROLLED VALUE CLASS RNATypeDict { ( "Transfer", tRNA ), ( "Ribosomal", rRNA ), ( "Small nuclear", snRNA ), ( "Messenger", mRNA ), ( "Heterogenous nuclear", hnRNA ) } CODE_TYPE: VARCHAR(20) CONTROLLED VALUE CLASS RearrangementTypeDict { ( "Unknown", Unknown ), ( "Deletion", Deletion ), ( "Duplication", Duplication ), ( "Translocation", Translocation ), ( "Inversion", Inversion ), ( "Recurrent", Recurrent ), ( "Fragment", Fragment ), ( "Complex", Complex ), ( "Spontaneous", Spontaneous ) } DEFAULT: "Unknown" CODE_TYPE: VARCHAR(20) DESCRIPTION: "Rearrangement types" CONTROLLED VALUE CLASS RegulatoryEffectDict { ( "Unknown", Unknown ) , ( "Promoter", Promoter ), ( "Enhancer", Enhancer ), ( "Repressor", Repressor ), ( "Silencer", Silencer ) } DEFAULT: "Unknown" CODE_TYPE: VARCHAR(20) DESCRIPTION: "Regulatory effect dictionary" CONTROLLED VALUE CLASS RelativeOrientationDict { ( "Unknown", Unknown ) , ( "Same", Same ), ( "Reverse", Reverse ) } DEFAULT: "Unknown" CODE_TYPE: VARCHAR(20) DESCRIPTION: "Describes relative orientation of two ordering frames of reference." CONTROLLED VALUE CLASS RepeatTypeDict { ( "ALU short interspersed element", ALU ), ( "L1 long interspersed element", L1 ), ( "SINE - other short interspersed elements, not ALU", SINE ), ( "LINE - other long interspersed elements, not L1", LINE ), ( "TELO - telomeric repeat", TELO ), ( "SUBTELO - subtelomeric repeat", SUBTELO ), ( "MINISAT - minisatellite repeats", MINISAT ), ( "ALPHA - alpha satellite repeats", ALPHA ), ( "Other", OTHER ) } CODE_TYPE: VARCHAR(20) CONTROLLED VALUE CLASS SepMethodDict { ( "Unknown", Unknown ) , ( "Polyacrylamide gel electrophoresis", Polyacralamide ), ( "Agarose gel electrophoresis", Agarose ), ( "Denaturation", Denaturation ), ( "Denaturing gradient polyacralamide gel", Gradient ), ( "Pulse-Field gel electrophoresis", PFGE ), ( "Other", Other ) } DEFAULT: "Unknown" CODE_TYPE: VARCHAR(20) CONTROLLED VALUE CLASS ShapeDict { ( "Rectangle", Rectangle ), ( "Round start rectangle", RoundStartRect ), ( "Round end rectangle", RoundEndRect ), ( "Circle", Circle ), ( "Square", Square ), ( "Triangle", Triangle ) } DEFAULT: "Rectangle" CODE_TYPE: VARCHAR(20) CONTROLLED VALUE CLASS UnitsDict { ( "Haldane centiMorgans", HcM, "Haldane centiMorgans" ), ( "Kosambi centiMorgans", KcM, "Kosambi centiMorgans" ), ( "CentiRays", cR, "centiRays" ), ( "Fractional length from pter", ln, "Fractional Length from pter" ), ( "Recombination fraction", rf, "Recombination fraction" ), ( "Percent overlap", ov, "Percent overlap" ), ( "Ordinal", ord, "Arbitrary order-only units" ), ( "Dustin units", du, "Coordinates for cytogenetic maps." ), ( "Kilobases", kb, "Kilo base pairs" ) } CODE_TYPE: VARCHAR(5) DESCRIPTION: "Map distance units dictionary" CONTROLLED VALUE CLASS VectorTypeDict { ( "Unknown", UNKNOWN, "Unknown" ), ( "YAC", YAC, "Yeast Artificial Chromosome" ), ( "BAC", BAC, "Bacterial Artificial Chromosome" ), ( "PAC", PAC, "P1 Artificial Chromosome" ), ( "Cosmid", COSMID, "Cosmid" ), ( "Plasmid", PLASMID, "Plasmid" ), ( "Phagemid", PHAGEMID, "Phagemid" ), ( "M13", M13, "M13" ), ( "P1", P1, "P1" ), ( "Phage", PHAGE, "Phage" ) } DEFAULT: "Unknown" CODE_TYPE: VARCHAR(20) DESCRIPTION: "Vector type dictionary" CONTROLLED VALUE CLASS VisualMethodDict { ( "Unknown", Unknown ) , ( "Radioactive Labelling", Radiolabelling ), ( "DNA Staining", DNAStaining ), ( "Allele Specific Oligonucleotide", ASO ), ( "Direct Sequencing", Sequencing ), ( "Locus Specific Probe", LSP ), ( "Repeat Specific Probe", RSP ) } DEFAULT: "Unknown" CODE_TYPE: VARCHAR(20) CONTROLLED VALUE CLASS YesNoUnknown_UnkDict { ( "Unknown", Unknown ) , ( "No", No ), ( "Yes", Yes ) } DEFAULT: "Unknown" CODE_TYPE: VARCHAR(30) CONTROLLED VALUE CLASS YesNoUnknown_YesDict { ( "Yes", Yes ), ( "No", No ), ( "Unknown", Unknown ) } DEFAULT: "Yes" CODE_TYPE: VARCHAR(20) CONTROLLED VALUE CLASS YesUnknown_UnkDict { ( "Unknown", Unknown ), ( "Yes", Yes ) } DEFAULT: "Unknown" CODE_TYPE: VARCHAR(20) CONTROLLED VALUE CLASS YesNo_NoDict { ( "No", No ), ( "Yes", Yes ) } DEFAULT: "No" CODE_TYPE: VARCHAR(5) DESCRIPTION: "Controlled vocabulary for boolean values YES and NO" CONTROLLED VALUE CLASS YesNo_YesDict { ( "Yes", Yes ) , ( "No", No ) } DEFAULT: "Yes" CODE_TYPE: VARCHAR(5) DESCRIPTION: "Controlled vocabulary for boolean values YES and NO" OBJECT CLASS AdminAnnotation isa* AnnotationObject DESCRIPTION: "Annotation used by GDB data curation staff to mark objects in various ways. Only administrative staff can create or view AdminAnnotations." PROPERTIES: "FE_Editable" "No", "Admin/FE_Editable" "Yes", "FE_Visible" "No", "Admin/FE_Visible" "Yes", "Admin/FE_EditOption" "Edit", "Admin/FE_ObjectMenu" "{{parentmenu}}", "GDB_Rule" "only editable by the admin group [ implemented in GDBI_AdminAnnotation]" ATTRIBUTE client: [0,1] Contact DELETE NULLIFIES DESCRIPTION: "Person for whom this annotation was created. E.g. submitter." PROPERTIES: "GDB_Rule" "not modifiable on updates" ATTRIBUTE dBObjects: set-of [1,] DBObject ORDER BY dBObjects.displayName ASC, dBObjects.modDate DESC DELETE CASCADES DESCRIPTION: "The object(s) being annotated." PROPERTIES: "GDB_Rule" "dBObjects must be unique within the AdminAnnotation" ATTRIBUTE annotation: list-of [1,] VARCHAR(255) PROPERTIES: "OB_Pack" "Yes", "FE_Preformatted" "Yes" ATTRIBUTE annoTypes: set-of [1,] AdminAnnotationTypeDict PROPERTIES: "GDB_Rule" "
If the family is known by several different names, these additional names can be added as "aliases" after the original entry is created. See Add Alias also.", "FE_InsertHelp:owner" "If you are not a member of a group you will not see this option, as ownership will automatically be assigned to you.
A pull-down menu is displayed with your name and the names of any groups to which you belong. Select either your name or a group name to assign ownership to the gene family. ", "FE_InsertHelp:comment" "Please reserve comments for information that does not fit into 'Definition', 'Annotation' or other fields in the database", "FE_InsertHelp:releaseDate" "Leave this field empty or simply enter "today" to have your data publicly visible as soon as possible. A future release date of up to 6 months can be specified by entering month, day and year. An appropriate date format is March 20 1996.", "GDB_Rule.displayName" "User defined", ATTRIBUTE definition: list-of [1,] VARCHAR(255) DESCRIPTION: "Defining characteristics of the family." PROPERTIES: "FE_Preformatted" "Yes", "OB_Pack" "Yes", "FE_InsertHelp" "Provide the evidence for grouping these genes into a family and any other useful information. A group of genes can be classified as a family based on sequence similarity, functional analysis or other acceptable classifications. For example, the definition for the PAX gene family states that "protein products of these genes contain a 124 amino acid conserved domain known as the 'paired box' which contains the consensus pattern R-P-C-x(11)-C-V-S at positions 35-51".
Other useful information could include the functions of gene family members or inclusion in other families or sub-families. For example, 'the PAX gene family members are believed to act as transcription factors' and 'several members of this family also contain homeoboxes and are members of the homeobox gene family (e.g. PAX3, PAX4, PAX6, PAX7)'." ATTRIBUTE genes: set-of [1,] Gene ORDER BY genes.displayName ASC DELETE CASCADES DESCRIPTION: "Genes in this family. A gene may be a member of more than one family." PROPERTIES: "FE_EmptyRows" "15", "FE_InsertHelp" "Enter the name (or GDB accession ID, e.g. GDB:123456) for each member of the family. Be sure to use the name specified in GDB as these names are actually the symbols which have been approved by the nomenclature committee. For example, the members of the PAX gene family are PAX1, PAX2, PAX3, PAX4, PAX5, PAX6, PAX7, PAX8 and PAX9.
These fields are NOT case-sensitive, the names can also be entered as pax1, pax2, etc. The names will be changed to the appropriate case when submitted.
Accepted aliases can also be entered as the gene name; these will be converted to the appropriate name upon entry. For example, if WS1 is entered instead of PAX3, this alias will be accepted and "PAX3" will be displayed after the completed entry has been submitted.
This form contains 15 fields to enter the genes in a family. If the family contains more than 15 members they can be added by editing the entry afterward. Submit the family as is, then choose "Edit". A new form containing 15 additional fields will be provided; continue as needed until all gene family members are added."
"GDB_Rule" "genes should be unique within the GeneFamily. the releaseDate of the GeneFamily cannot be any earlier than the max releaseDate of its gene components"
OBJECT CLASS GeneProduct
isa* BiologicalObject
DESCRIPTION: "Proteins or RNAs resulting from the transcription of this gene."
PROPERTIES:
"FE_Editable" "No",
"SRW/FE_ObjectMenu" "{{parentmenu}} | Add Nucleic Acid Sequence Link | Add Structure Link"
"PRW/FE_ObjectMenu" "{{parentmenu}} | Add Nucleic Acid Sequence Link | Add Structure Link"
ATTRIBUTE nucleicAcidSequences
DERIVATION: ! dBObject [ NucleicAcidSequenceLink ]
ORDER BY nucleicAcidSequences [ NucleicAcidSequenceLink ] displayName ASC
DESCRIPTION: "External links to nucleic acid sequence databases."
ATTRIBUTE structures
DERIVATION: ! geneProduct [ StructureLink ]
ORDER BY structures [ StructureLink ] displayName ASC
DESCRIPTION: "External links to structure databases."
ATTRIBUTE genes (gene, subunit, nCopies):
set-of [1,] ([1,1] Gene, [0,1] VARCHAR(20), [0,1] SMALLINT)
DELETE NULLIFIES
DESCRIPTION: "List genes coding for this product. If product has multiple distinct subunits, label them using subunit field (eg alpha, beta, 70S, etc.) nCopies is number of copies of each subunit in the product."
PROPERTIES:
"OB_Key" "gene",
"GDB_Rule" the releasedate of the GeneProduct cannot be any earlier than the max release date of the genes"
OBJECT CLASS GenericLink
isa* ExternalLink
DESCRIPTION: "Generic link from a DBObject to an external object."
PROPERTIES:
"GDB_Rule" "if displayName is NULL, default to = externalDB : ExternalLink.accessionID"
ATTRIBUTE dBObjects: set-of [1,] DBObject
ORDER BY dBObjects.displayName ASC
DELETE CASCADES
DESCRIPTION: "The object in this database that is being linked to."
PROPERTIES:
"GDB_Rule" "dBObjects must be unique within the GenericLink"
OBJECT CLASS GenomicSegment
isa* MappingObject
DESCRIPTION: "Any named region or set of regions of a genome, including chromosome, gene, breakpoint, etc."
PROPERTIES:
"FE_Editable" "No",
"FE_Order" "1",
"FE_DefaultSummary" "objectClass, accessionID*, displayName, alias, LFM, RFM",
"FE_QueryMenu" "{{parentmenu}} | Query By Position ",
"SRW/FE_QueryMenu" "{{parentmenu}} | Query By Position ",
"FE_ObjectMenu" "{{parentmenu}} | View Maps Containing this Segment ",
"PRW/FE_ObjectMenu" "{{parentmenu}} | Add Nucleic Acid Sequence Link | View Maps Containing this Segment ",
"SRW/FE_ObjectMenu" "{{parentmenu}} | Add Nucleic Acid Sequence Link | View Maps Containing this Segment ",
"WAIS_Class" "Yes"
ATTRIBUTE genome: [0,1] Organism
DELETE NULLIFIES
DESCRIPTION: "The genome from which the segment is derived. Useful for reagents derived from non-human genomes, and in future if more than one genome is described in the database.
If no value is entered, the default value is 'Human'."
PROPERTIES:
"GDB_Rule" "Default value should be 'human', but this should be overridable for non-human clones, etc."
ATTRIBUTE mapsOf
DERIVATION: ! mapOf [ Map ]
ORDER BY mapsOf [ Map ] displayName ASC
DESCRIPTION: "Maps of this segment of the genome."
PROPERTIES:
"FE_Queryable" "No"
ATTRIBUTE cytoLocations (chromosome_, LFM, RFM, mapElement_, cytoMap):
set-of [0,] ([1,1] Chromosome, [1,1] VARCHAR(200), [1,1] VARCHAR(200), [1,1] VARCHAR(50), [1,1] Map)
DESCRIPTION: "Localizations of this segment in Cytogenetic maps."
PROPERTIES:
"FE_PrintName" "Cytogenetic Localization",
"FE_Editable" "No",
"FE_QueryHelp" "Use this group to retrieve segments at a specified cytogentic location, details here",
"opm_derive" "user SQL",
"GDB_View" "create view GenomicSegment_cytoLocations
as select _oid = E.segment, /* MapElement.segemnt */
chromosome_ = M.chromosome, /* chromomsome displayName */
LFM = DL.displayName, /* LFM.segment.displayName */
RFM = DR.displayName, /* RFM.segement.displayName */
mapElement_ = DE.accessionID, /* E.accessionID */
cytoMap = E.map , /* GS.element.map.displayName */
owner = G.owner, /* GS.owner */
isReleased = G.isReleased /* GS.isReleased */
from GenomicSegment G, MapElement E,
DBObject DE,
Map M, DBObject DM,
MapElement ELFM, MapElement ERFM,
DBObject DL, DBObject DR
where G._oid = E.segment
and E._oid = DE._oid
and E.map = M._oid
and M._oid = DM._oid
and DM.objectClass = 'CytogeneticMap'
and E.LFM = ELFM._oid
and ELFM.segment = DL._oid
and E.RFM = ERFM._oid
and ERFM.segment = DR._oid"
COMPONENT chromosome_
PROPERTIES:
"FE_PrintName" "Chromosome",
"opm_derive" "user SQL"
COMPONENT LFM
PROPERTIES:
"FE_PrintName" "Left Marker",
"FE_Queryable" "Yes",
"FE_URL" "{{uptodb}}/CytogeneticMarker?!action=query&displayName={{value}}",
"opm_derive" "user SQL"
COMPONENT RFM
PROPERTIES:
"FE_PrintName" "Right Marker",
"FE_Queryable" "Yes",
"FE_URL" "{{uptodb}}/CytogeneticMarker?!action=query&displayName={{value}}",
"opm_derive" "user SQL"
COMPONENT mapElement_
PROPERTIES:
"FE_Queryable" "No",
"FE_URL" "{{uptodb}}/MapElement?!key={{value}}",
"FE_PrintName" "Map Element ID",
"opm_derive" "user SQL"
COMPONENT cytoMap
PROPERTIES:
"FE_PrintName" "Map",
"FE_Queryable" "No",
"opm_derive" "user SQL"
ATTRIBUTE otherLocations (chromosome_2, mapElement_2, map, coordinate, units_):
set-of [0,] ([1,1] Chromosome, [1,1] VARCHAR(50), [1,1] Map, [1,1] FLOAT, [1,1] UnitsDict)
DESCRIPTION: "Localizations of this segment in maps other than Cytogenetic maps."
PROPERTIES:
"FE_PrintName" "Other Localization",
"FE_Editable" "No",
"opm_derive" "user SQL",
"GDB_View" "create view GenomicSegment_otherLocations
as select _oid = E.segment, /* MapElement.segment */
chromosome_2 = M.chromosome, /* Chromosome.displayName */
mapElement_2 = DE.accessionID, /* MapElement.accessionID */
map = E.map, /* MapElement.map */
coordinate = E.coordinate, /* MapElement.coordinate */
units_ = M.units, /* Map.units */
owner = G.owner, /* GennomicSegment.owner */
isReleased = G.isReleased /* GenomicSegment.isReleased */
from MapElement E, GenomicSegment G,
DBObject DE, Map M, DBObject DM
where E.segment = G._oid
and E._oid = DE._oid
and E.map = M._oid
and M._oid = DM._oid
and DM.objectClass != 'CytogeneticMap'"
COMPONENT chromosome_2
PROPERTIES:
"FE_PrintName" "Chromosome",
"opm_derive" "user SQL"
COMPONENT mapElement_2
PROPERTIES:
"FE_Queryable" "No",
"FE_URL" "{{uptodb}}/MapElement?!key={{value}}",
"FE_PrintName" "Map Element ID",
"opm_derive" "user SQL"
COMPONENT map
PROPERTIES:
"FE_Queryable" "No",
"FE_PrintName" "Map",
"opm_derive" "user SQL"
COMPONENT coordinate
PROPERTIES:
"FE_PrintName" "Coordinate",
"opm_derive" "user SQL"
COMPONENT units_
PROPERTIES:
"FE_PrintName" "Units",
"opm_derive" "user SQL"
ATTRIBUTE orderData (marker_1, relationship, marker_2, observationType, position, orderID):
set-of [0,] ([1,1] VARCHAR(200), [1,1] OrderRelationshipPlusDict, [1,1] GenomicSegment, [1,1] ObservationTypePlusDict, [1,1] VARCHAR(255), [1,1] VARCHAR(50))
DESCRIPTION: "Participation of this segment in pairwise order relationships with other segments."
PROPERTIES:
"FE_PrintName" "Order Data",
"FE_Editable" "No",
"opm_derive" "user SQL",
"GDB_View" "create view GenomicSegment_orderData (_oid, marker_1, relationship,
marker_2, observationType, orderID, owner, isReleased )
as select _oid = Os1.segments, /* Order.segments(1) */
marker_1 = Ds1.displayName, /* Order.segments(1).displayName */
relationship = RI.inverseRelation, /* Order. relationship */
marker_2 = Os2.segments, /* Order.segments(2) */
observationType = OI.inverseObservation, /* Order. observation */
position = O.position /* Order.position */
orderID = Do.accessionID, /* Order_.accessionID */
owner = G.owner, /* GS.owner */
isReleased = G.isReleased /* GS.isReleased */
from GenomicSegment G, Order_ O,
Order__segments Os1, Order__segments Os2,
DBObject Ds1, DBObject Do,
RelationshipInverse RI, ObservationInverse OI
where G._oid = Os1.segments
and Os1._oid = O._oid
and Os1.segments = Ds1._oid
and Os2._oid = O._oid
and Os2.segments != Os1.segments
and O._oid = Do._oid
and O.relationship = RI.relation
and Os2._order = RI._order
and O.observationType = OI.observation
and Os2._order = OI._order"
COMPONENT marker_1
PROPERTIES:
"FE_PrintName" "Marker 1",
"FE_Visible" "No",
"opm_derive" "user SQL"
COMPONENT relationship
PROPERTIES:
"FE_PrintName" "Relationship",
"opm_derive" "user SQL"
COMPONENT marker_2
PROPERTIES:
"FE_PrintName" "Marker",
"opm_derive" "user SQL"
COMPONENT observationType
PROPERTIES:
"FE_PrintName" "Observation",
"opm_derive" "user SQL"
COMPONENT position
PROPERTIES:
"FE_PrintName" "Position",
"opm_derive" "user SQL"
COMPONENT orderID
PROPERTIES:
"FE_Queryable" "No",
"FE_PrintName" "Order ID",
"FE_URL" "{{uptodb}}/Order_?!key={{value}}",
"opm_derive" "user SQL"
ATTRIBUTE distanceData (segment_1, endPoint_1, segment_2, endPoint_2, distance, units, distanceID):
set-of [0,] ([1,1] GenomicSegment, [1,1] EndpointDict, [1,1] VARCHAR(200), [1,1] EndpointDict, [1,1] FlOAT, [0,1] UnitsDict, [1,1] VARCHAR(50))
DESCRIPTION: "Mapping distances known between this segment and other segments."
PROPERTIES:
"FE_PrintName" "Distance Data",
"FE_Editable" "No",
"opm_derive" "user SQL",
"GDB_View" "create view GenomicSegment_distanceInfo
as select _oid = Ds1.segment, /* DIstance.segments(1) */
segment_1 = Ds2.segment, /* Distance.segments(2) */
endPoint_1 = Ds2.endPoint, /* Distance.endPoint(2) */
segment_2 = DS1.displayName, /* Distance.segments(1).displayName */
endPoint_2 = Ds1.endPoint, /* Distance.endPoint(1) */
distance = D.distance, /* Distance.distance */
units = D.units, /* Distance.units */
distanceID = DD.accessionID, /* Distance.accessionID */
owner = G.owner, /* GS.owner */
isReleased = G.isReleased /* GS.isReleased */
from GenomicSegment G, Distance D,
Distance_segments Ds1, Distance_segments Ds2,
DBObject DS1, DBObject DD
where G._oid = Ds1.segment
and Ds1._oid = D._oid
and Ds1.segment = DS1._oid
and Ds2._oid = D._oid
and Ds2.segment != Ds1.segment
and D._oid = DD._oid"
COMPONENT segment_1
PROPERTIES:
"FE_PrintName" "Segment 1",
"opm_derive" "user SQL"
COMPONENT endPoint_1
PROPERTIES:
"FE_Queryable" "No",
"FE_PrintName" "End Point 1",
"opm_derive" "user SQL"
COMPONENT segment_2
PROPERTIES:
"FE_Queryable" "No",
"FE_PrintName" "Segment 2",
"opm_derive" "user SQL"
COMPONENT endPoint_2
PROPERTIES:
"FE_Queryable" "No",
"FE_PrintName" "End Point 2",
"opm_derive" "user SQL"
COMPONENT distance
PROPERTIES:
"FE_PrintName" "Distance",
"opm_derive" "user SQL"
COMPONENT units
PROPERTIES:
"FE_PrintName" "Units",
"opm_derive" "user SQL"
COMPONENT distanceID
PROPERTIES:
"FE_Queryable" "No",
"FE_PrintName" "Distance ID",
"FE_URL" "{{uptodb}}/Distance?!key={{value}}",
"opm_derive" "user SQL"
ATTRIBUTE nucleicAcidSequences
DERIVATION: ! dBObject [ NucleicAcidSequenceLink ]
ORDER BY nucleicAcidSequences [ NucleicAcidSequenceLink ] displayName ASC
DESCRIPTION: "Pointers to external database entries describing the nucleic acid sequence of this region."
ATTRIBUTE polymorphisms (polymorphism, position_, maxHet):
set-of [0,] ([1,1] Polymorphism, [1,1] VARCHAR(255), [0,1] FLOAT)
ORDER BY maxHet DESC
DESCRIPTION: "Used for searching when synonym matching is required. Includes both primary names and aliases."
PROPERTIES:
"FE_Editable" "No",
"opm_derive" "user SQL",
"GDB_View" "create view GenomicSegment_polymorphisms as select _oid = Pl.segment, polymorphism = Pl._oid, position_ = Pl.position, maxHet = P.maxHet, owner = G.owner, isReleased = G.isReleased from Polymorphism_locations Pl, Polymorphism P, GenomicSegment G where G._oid = Pl.segment and Pl._oid = P._oid",
"GDB_Note" "This is a computed tuple achieved by a view. No sybase table need to be created",
COMPONENT polymorphism
PROPERTIES:
"opm_derive" "user SQL"
COMPONENT position_
PROPERTIES:
"FE_PrintName" "Position"
"opm_derive" "user SQL"
COMPONENT maxHet
PROPERTIES:
"opm_derive" "user SQL"
ATTRIBUTE mayCoords ( minMay, maxMay, chromMay ):
set-of [0,] ([0,1] FLOAT, [0,1] FLOAT, [0,1] NUMERIC)
PROPERTIES:
"FE_Visible" "No"
ATTRIBUTE maySearchCoords ( minMaySearch, maxMaySearch, chromMaySearch ):
set-of [0,] ([0,1] FLOAT, [0,1] FLOAT, [0,1] NUMERIC)
PROPERTIES:
"FE_Visible" "No"
OBJECT CLASS GenomicSegmentType
DESCRIPTION: "User-extensible taxonomy for new types of genomic segments."
PROPERTIES:
"OB_Key" "_oid",
"OB_SearchKey" "searchName",
"Admin/FE_Editable" "Yes",
"FE_DisplayAttr" "displayName",
"Admin/FE_EditOption" "Edit",
"FE_ObjectMenu" "View History",
"Admin/FE_ObjectMenu" "{{Edit}} | View History",
"OB_NonOPMCV" "Yes",
"GDB_Rule" "insertable by all legitimate users; only updatable/deletable by adminGroup; notify admin group when non-adminGroup user inserts"
ID: displayName
REP: displayName
ATTRIBUTE modDate: [1,1] DATETIME
DESCRIPTION: "Date last modified"
PROPERTIES:
"FE_IncludeInDetail" "No",
"Admin/FE_IncludeInDetail" "Yes",
"FE_Editable" "No",
"GDB_Rule" "Set by insert/update procedures"
ATTRIBUTE version: [1,1] INTEGER
DESCRIPTION: "Current vesion number"
PROPERTIES:
"FE_IncludeInDetail" "No",
"Admin/FE_IncludeInDetail" "Yes",
"FE_Editable" "No",
"GDB_Rule" "Set to 1 on inserts [implemented in GDBI_GenomicSegmentType]. increase by 1 on updates [implemented in GDBU_GenomicSegmentType]"
ATTRIBUTE displayName: [1,1] VARCHAR(200)
PROPERTIES:
"FE_Order" "1",
"FE_Search" "searchName",
"FE_PrintName" "Name"
ATTRIBUTE searchName: [1,1] VARCHAR(200)
DESCRIPTION: "Corresponds to lower(displayName). Denormalized to aid searching"
PROPERTIES:
"FE_Editable" "No",
"FE_Visible" "No",
"FE_MatchCase" "Lower",
"GDB_Rule" "Always set to lower(displayName) on insert/update"
OBJECT CLASS HomologyLink
isa* ExternalLink
DESCRIPTION: "Link from a GenomicSegment to a homologous region in an external DB."
PROPERTIES:
"GDB_Rule" "if displayName is NULL, default to ExternalLink.externalDB : ExternalLink.accessionID",
ATTRIBUTE segment: [1,1] GenomicSegment
DELETE CASCADES
DESCRIPTION: "The segment of the genome that is being linked to."
OBJECT CLASS IntegratedMap
isa* Map
DESCRIPTION: "A map constructed from more than one set of experimental data"
OBJECT CLASS IsChimeric
isa* Observation
DESCRIPTION: "Chimerism determination for a genomic segment."
PROPERTIES:
"FE_Queryable" "No",
"FE_Visible:alias" "No",
"FE_Visible:source_" "No",
"FE_DefaultSummary" "accessionID*, displayName",
"Admin/FE_Queryable" "Yes",
"FE_Editable:displayName" "No",
"Admin/FE_EditOption" "Edit",
"Admin/FE_ObjectMenu" "{{parentmenu}}",
"PRW/FE_ObjectMenu" "| Link Citation",
"SRW/FE_ObjectMenu" "{{Edit}} | Link Citation",
"GDB_Rule.displayName" "set displayName = value + ' - (' + owner + ')'"
ATTRIBUTE segment: [1,1] GenomicSegment
DELETE CASCADES
PROPERTIES:
ATTRIBUTE value: [1,1] YesNo_YesDict
PROPERTIES:
ATTRIBUTE basis: [0,1] ChimerismBasisDict
DESCRIPTION: "Method by which it was observed that a genomic segment is chimeric."
OBJECT CLASS Library
isa* GenomicSegment
DESCRIPTION: "A collection of cloned GenomicSegments maintained within a culture of the host organism."
PROPERTIES:
"FE_Visible:distanceData" "No",
"FE_Visible:polymorphisms" "No",
"FE_DefaultSummary" "accessionID*, displayName, alias, LFM, RFM, DNAType,vectorType",
"PRW/FE_ObjectMenu" "{{parentmenu}} | Add Reagent Source",
"SRW/FE_ObjectMenu" "{{parentmenu}} | Add Reagent Source | Add Cytogenetic Location",
"GDB_Rule.displayName" "User defined",
ATTRIBUTE availableFrom
DERIVATION: ! reagent [ ReagentSource ]
ORDER BY availableFrom [ ReagentSource ] displayName ASC
DESCRIPTION: "List of sources from which this library can be obtained."
ATTRIBUTE DNAType: [1,1] DNATypeDict
DESCRIPTION: "DNA type (genomic, cDNA etc.)"
PROPERTIES:
"GDB_Rule" "on insert, if not supplied, set to 'Unknown'"
ATTRIBUTE hostOrganism: [0,1] Organism
DELETE NULLIFIES
DESCRIPTION: "Organism in which this library is maintained."
ATTRIBUTE vectorType: [1,1] VectorTypeDict
DESCRIPTION: "Type of vector used to clone the inserted DNA fragments (YAC, BAC, PAC etc.)."
PROPERTIES:
"FE_AllowNULL" "Yes",
"GDB_Rule" "on insert, if not supplied, set to 'Unknown'"
ATTRIBUTE vectorName: [0,1] VARCHAR(255)
DESCRIPTION: "Name of vector used to clone the inserted DNA fragments."
ATTRIBUTE genomeExcisionEnzymes: set-of [0,2] RestrictionEnzyme
ORDER BY genomeExcisionEnzymes.displayName ASC
DELETE CASCADES
DESCRIPTION: "Restriction enzyme (or pair of enzymes) used to excise the cloned inserts from the source DNA.
Query and Edit notes: This is a large dictionary. Use the Restriction Enzyme Query form to search for the names of specific restriction enzymes."
ATTRIBUTE vectorInsertionEnzymes: set-of [0,2] RestrictionEnzyme
ORDER BY vectorInsertionEnzymes.displayName ASC
DELETE CASCADES
DESCRIPTION: "Restriction enzyme (or pair of enzymes) used to cut the cloning vector, in preparation for integration of the cloned insert.
Query and Edit notes: This is a large dictionary. Use the Restriction Enzyme Query form to search for the names of specific restriction enzymes."
PROPERTIES:
"GDB_Rule" "none"
ATTRIBUTE vectorExcisionEnzymes: set-of [0,2] RestrictionEnzyme
ORDER BY vectorExcisionEnzymes.displayName ASC
DELETE CASCADES
DESCRIPTION: "Restriction enzyme (or pair of enzymes) used to excise the cloned inserts from the cloning vector.
Query and Edit notes: This is a large dictionary. Use the Restriction Enzyme Query form to search for the names of specific restriction enzymes."
ATTRIBUTE source: [0,1] GenomicSegment
DELETE NULLIFIES
DESCRIPTION: "Genomic material from which the library was created. The source must be either a Cell Line or a Chromosome Reagent."
PROPERTIES:
"OB_Union" "CellLine ChromosomeReagent"
OBJECT CLASS LinkageMap
isa* Map
DESCRIPTION: "A map based upon frequency of recombination between genomic segments, resulting in the ordering of markers along a chromosome backbone, usually measured in centiMorgans (cM)."
ATTRIBUTE gender: [1,1] MapSexDict
DESCRIPTION: "Gender (male, female, sex-averaged)"
PROPERTIES:
"GDB_Rule" "on insert, if not supplied, set to 'Unknown'"
OBJECT CLASS Map
isa* MappingObject
DESCRIPTION: "A map represents order and distance among markers along a chromosome."
PROPERTIES:
"FE_Editable" "No",
"FE_Order" "1",
"FE_DefaultSummary" "accessionID*, displayName, owner",
"FE_QueryMenu" "{{parentmenu}} | Query By Position ",
"FE_ObjectMenu" "{{parentmenu}} | View Map ",
"SRW/FE_ObjectMenu" "{{parentmenu}} | View Map ",
"WAIS_Class" "Yes",
"GDB_Note" "We need a derived attribute 'numberOfElements' -> count of all elements in this map. OPM aggregate derivation do not allow this on derived inverse path ' count of ! map [ MapElement ]'. Post 6.0, perhaps through a view we can achieve this. We also need a derived attribute 'elements' -> all elements in this map. OPM inverse derivation '! map [ MapElement ]', query performance is so slow that we had to loose this attribute. Post 6.0, perhaps through a view we can achieve this"
ATTRIBUTE publiclyEditable: [1,1] YesNo_NoDict
DESCRIPTION: "Can third parties assign new elements to this map?"
PROPERTIES:
"FE_Visible" "No",
"GDB_Note" "Initially only GDB staff will be able to create publicly editable maps, such as the summary cytogenetic map",
"GDB_Rule" "Once publiclyEditable is set to 'Yes', it can only be reset to 'No' if all MapElements pointing to the map have the same owner as the map itself"
ATTRIBUTE copiedFrom: [0,1] Map
DELETE NULLIFIES
DESCRIPTION: "If this object was created by copying another Map object in the DB, the other object will automatically be listed here."
PROPERTIES:
"FE_Editable" "No",
"GDB_Note" "Set by copy operation. GDBCopy stored proc."
ATTRIBUTE mapOf: [1,1] GenomicSegment
DELETE CASCADES
DESCRIPTION: "Region of the genome described by the map."
ATTRIBUTE chromosome: [1,1] Chromosome
DELETE CASCADES
DESCRIPTION: "Which chromosome has been mapped here? While this information can be indirectly obtained from the mapOf value, its explicit presences here simplifies map queries."
ATTRIBUTE includesMap (map, orientation):
set-of [0,] ([0,1] Map, [0,1] RelativeOrientationDict)
DELETE NULLIFIES
DESCRIPTION: "Other maps that were used to help construct this map. Orientation indicates how those maps are oriented in this one."
ATTRIBUTE units: [1,1] UnitsDict
DESCRIPTION: "Units of measure for the mapping coordinates e.g., kb, cM, etc."
ATTRIBUTE minCoord: [1,1] FLOAT
DESCRIPTION: "Minimum coordinate of elements in the map."
PROPERTIES:
"FE_Editable" "No",
"GDB_Rule" "Minimum value of MapElement.coordinate for all elements associated with the map.",
"GDB_Note" "Map slices can be detected if the minimum coordinate in the returned elements is greater than minCoord."
ATTRIBUTE maxCoord: [1,1] FLOAT
DESCRIPTION: "Maximum coordinate of elements in the map"
PROPERTIES:
"FE_Editable" "No",
"GDB_Rule" "Maximum value of MapElement.coordinate for all elements associated with the map.",
"GDB_Note" "Map slices can be detected if the maximum coordinate in the returned elements is less than maxCoord."
ATTRIBUTE orderLikelihood: [0,1] FLOAT
DESCRIPTION: "Order likelihood for the map as a whole."
PROPERTIES:
"GDB_Rule" "if supplied: if likelihoodType is 'LOD' then orderLikelihood should be positive, if Type is 'Like' then orderLikelihood should be >= 0 and <= 1"
ATTRIBUTE likelihoodType: [0,1] OrderLikelihoodTypeDict
PROPERTIES:
"GDB_Rule" "Cannot be null if orderLikelihood is not NULL"
ATTRIBUTE style: [0,1] Style
DESCRIPTION: "Default drawing style for all elements of the map. Can be overridden at the level of individual elements."
ATTRIBUTE a: [0,1] FLOAT
DESCRIPTION: "Coefficient of searchCoord = a*mapCoord + b, used for default conversion of map coords to search coords."
PROPERTIES:
"GDB_Rule" "Need to specify?",
"FE_Visible" "No"
ATTRIBUTE b: [0,1] FLOAT
DESCRIPTION: "Coefficient of searchCoord = a*mapCoord + b, used for default conversion of map coords to search coords."
PROPERTIES:
"GDB_Rule" "Need to specify?",
"FE_Visible" "No"
OBJECT CLASS MapElement
isa* MappingObject
DESCRIPTION: "Location information for genomic segments in specific maps."
PROPERTIES:
"FE_Order" "2",
"FE_Visible:alias" "No",
"FE_Visible:source_" "No",
"FE_DefaultSummary" "accessionID*, displayName, tier, coordinate, LFM, RFM",
"FE_DefaultSort" "tier, coordinate, LFM_coord",
"FE_Editable:displayName" "No",
"FE_ObjectMenu" "View History",
"SRW/FE_QueryMenu" "{{parentmenu}} | Change Owner Group",
"SRW/FE_EditOption" "Edit",
"SRW/FE_DeleteOption" "Delete",
"SRW/FE_ObjectMenu" "{{Edit}} | {{Delete}} | Request Owner Change | Add Annotation | Link Citation | Add Generic Link | View History",
"PRW/FE_ObjectMenu" "| Add Annotation | Link Citation | Add Generic Link | View History",
"Admin/FE_QueryMenu" "{{parentmenu}} | Change Owner Group",
"Admin/FE_EditOption" "Edit",
"Admin/FE_DeleteOption" "Delete",
"Admin/FE_ObjectMenu" "{{Edit}} | {{Delete}} | Request Owner Change | Add Annotation | Link Citation | Add Generic Link | View History",
"GDB_Rule" "[sp] Change Business Rule: Eliminate everything after segspec from computed displayName. (Not important to correct existing names immediately.)",
"GDB_Rule" "Let segspec = `{segment.displayName} [ # {instance} ] [ ? ] [ {PointSpec}]'.
Include '?' if ambiguous is yes; include instance if non null; include pointspec if not whole.
Let ownerspec = Map.Owner.displayName
If it contains a comma, lose everything after comma, inclusive, if convenient.
Let mapspec = ` in Chr {Map.Chromosome} {Map.objectClass} ({ownerspec})'.
if LFM and RFM are not NULL,
name is '{segspec} between {LFM.segspec} and {RFM.segspec} {mapspec}'
else if LFM is not NULL
name is '{segspec} after {LFM.segspec} {mapspec}'
else if RFM is not NULL
name is '{segspec} before {RFM.segspec} {mapspec}'
else
name is '{segspec} at {Coord} {Map.units} {mapspec}'
If a map element is inserted/updated/deleted on an *existing* map, increment Map.version.
If this is an element of an integrated map and coordinate, LFM, and RFM are NULL, then LFM_coord and RFM_coord can not be NULL.
the release date of the MapElement cannot be any earlier than the max release date of the segment, LFM, RFM and observations"
ATTRIBUTE originalName: [0,1] VARCHAR(200)
DESCRIPTION: "Segment name used by author of map"
PROPERTIES:
"GDB_Rule" "default insert: MapElement's Segment's displayName. If segment = NULL, originalName must be NOT NULL. If segment = NOT NULL, originalName must be an alias of th e segment, else raiserro."
ATTRIBUTE dSegmentNumber: set-of [0,] VARCHAR(20)
DESCRIPTION: "DNA Segment name generated for the segment. /* MapElement's segment's ObjectName's displayName ** that is owned by HUGO_DNA"
PROPERTIES:
"FE_Editable" "No",
"opm_derive" "user SQL",
"GDB_View" "create view MapElement_dSegmentNumber
as select _oid = m._oid,
dSegmentNumber = o.displayName,
owner = m.owner,
isReleased = m.isReleased
from MapElement m, ObjectName o, Contact c
where m.segment = o.dBObject
and o.owner = c._oid
and c.searchName = 'hugo_dna'"
ATTRIBUTE segment: [0,1] GenomicSegment
DELETE NULLIFIES
DESCRIPTION: "The genomic region being placed on the map."
PROPERTIES:
"GDB_Rule" "if the segment is of type 'Breakpoint', if first map - reset displayName to B#PXXXX where # is the Map.chromosome. if the segment is of type 'Breakpoint' and is currently in other Maps, then the Map.chromsome's must be the same. If segment = NULL, originalName must be NOT NULL. If segment = NOT NULL, originalName must be an alias of the segment, else raiserror."
ATTRIBUTE map: [1,1] Map
DELETE CASCADES
DESCRIPTION: "The map that this element has been positioned on."
PROPERTIES:
"GDB_Rule" "Reject this element if the map pointed to here is not owned by the same person inserting the map element, or is not marked as publicly editable."
ATTRIBUTE point: [1,1] EndpointDict
DESCRIPTION: "Specifies which endpoint of the GenomicSegment is being positioned."
ATTRIBUTE coordinate: [0,1] FLOAT
DESCRIPTION: "Coordinate of the element on the map. Can be NULL only if LFM or RFM are supplied."
PROPERTIES:
"GDB_Rule" "If NULL, LFM or RFM must be not NULL. if coordinate is modified, all other MapElements that reference this element as LFM or RFM must have their LFM_coord/RFM_coord updated"
ATTRIBUTE arbitraryCoord: [1,1] YesNo_NoDict
DESCRIPTION: "Relevant to framework markers only. Set to 'Yes' to indicate that the coordinate assigned to this marker is arbitrary; i.e., the distance between this marker and the previous framework marker is not known"
ATTRIBUTE minSearchCoord: [0,1] FLOAT
DESCRIPTION: "Min search coordinate."
PROPERTIES:
"FE_Visible" "No",
"GDB_Note" "(Any need for a midpoint coord in search coordinates?). Populating these fields is a bit tricky and probably will need a cron job to do well. However, if there are linear coefficients associated with a map, the search coords can be initialized by applying them to the LFM_ and RFM_coords"
ATTRIBUTE maxSearchCoord: [0,1] FLOAT
DESCRIPTION: "Max search coordinate."
PROPERTIES:
"FE_Visible" "No",
"GDB_Note" "(Any need for a midpoint coord in search coordinates?). Populating these fields is a bit tricky and probably will need a cron job to do well. However, if there are linear coefficients associated with a map, the search coords can be initialized by applying them to the LFM_ and RFM_coords"
ATTRIBUTE zoomPriority: [0,1] FLOAT
DESCRIPTION: "Largest searchCoord interval width in which this marker should be included. To be populated by cron job."
PROPERTIES:
"FE_Visible" "No",
"GDB_Note" "To be populated by cron job."
ATTRIBUTE LFM: [0,1] MapElement
DELETE NULLIFIES
DESCRIPTION: "Framework element in this map that defines the 'left' bound of this element's position."
PROPERTIES:
"GDB_Rule" "If NULL, Coordinate or RFM must be NOT NULL. MapElements whose coordinate is null cannot be an LFM"
ATTRIBUTE RFM: [0,1] MapElement
DELETE NULLIFIES
DESCRIPTION: "Framework element in this map that defines the 'right' bound of this element's position."
PROPERTIES:
"GDB_Rule" "If NULL, Coordinate or LFM must be NOT NULL. MapElements whose coordinate is null cannot be an RFM"
ATTRIBUTE observations (Observation, Orientation):
set-of [0,] ([0,1] Observation, [0,1] RelativeOrientationDict)
DELETE NULLIFIES
DESCRIPTION: "Experimental observations associated with placing this segment in this position on this map. Orientation indicates relationship between any directional aspect of the observation (use of `left` or `before') agrees with map direction."
PROPERTIES:
"GDB_Note" "attribute naming convention violtated, fix in 6.1"
ATTRIBUTE uncertainty: [0,1] FLOAT
DESCRIPTION: "Quantitative measure of positional uncertainty, defined as the standard error of the marker position when all other marker positions are held constant."
ATTRIBUTE ambiguous: [0,1] YesNo_NoDict
DESCRIPTION: "Specifies whether the marker has been placed in more than one position on the map. This is automatically set by the database. Only point markers can be placed in more than position."
PROPERTIES:
"FE_Editable" "No",
"GDB_Rule" "Ambiguous can be yes only if point is 'entire', else we have problems connecting up the endpoints. Set this automatically. Needs to be adjusted across all map elements that refer to the same segment in the same map, even if they have different owners. Autonotify all owners when this happens."
ATTRIBUTE tier: [1,1] INTEGER
DESCRIPTION: "Which display group should this element be drawn in?"
PROPERTIES:
"FE_AllowNULL" "Yes",
"GDB_Rule" "Defaults to 0 if coord NOT NULL and LFM and RFM are NULL, 1 if LFM or RFM NOT NULL.
If 0, coordinate must be NOT NULL.
If > 0 and element does not belong to an integrated map, then LFM or RFM must be NOT NULL"
ATTRIBUTE draw: [1,1] YesNo_YesDict
DESCRIPTION: "Whether to draw this marker in the Map. If 'No', it's hidden."
ATTRIBUTE instance: [0,1] INTEGER
DESCRIPTION: "Integer subscript used to distinguish different occurences of the same genomic segment in a single map. If a segment occurs only once, leave NULL."
ATTRIBUTE style: [0,1] Style
DESCRIPTION: "Specifies a user-defined rendering style for the map element. The style controls its preferred appearance on map diagrams."
ATTRIBUTE LFM_coord: [0,1] FLOAT
DESCRIPTION: "Coordinate of this element's left flanking marker."
PROPERTIES:
"FE_Visible" "No",
"GDB_Rule" "Set automatically from MapElement.coordinate for this element's LFM or set by EDS for integrated Maps.
If coord is not NULL, and LFM and RFM are both null (i.e. this is a framework/backbone element), then LFM_coord = RFM_coord = coord."
ATTRIBUTE RFM_coord: [0,1] FLOAT
DESCRIPTION: "Coordinate of this element's right flanking marker."
PROPERTIES:
"FE_Visible" "No",
"GDB_Rule" "Set automatically from MapElement.coordinate for this element's RFM or set by EDS for integrated Maps.
If coord is not NULL, and LFM and RFM are both null (i.e. this is a framework/backbone element), then LFM_coord = RFM_coord = coord."
ATTRIBUTE sortCoord: [1,1] FLOAT
DESCRIPTION: "Coordinate used for sorting rows of map elements."
PROPERTIES:
"FE_Visible" "No",
"GDB_Rule" "Set automatically from Coordinate if not null, else midpoint of LFM_coord and RFM_coord ."
OBJECT CLASS MappingObject
isa* DBObject
DESCRIPTION: "Groups all objects involved in representing genomic maps."
PROPERTIES:
"FE_Editable" "No",
"FE_Order" "2"
OBJECT CLASS MappingPanel
isa* GenomicSegment
DESCRIPTION: "A collection of cell lines or clones used to position genomic segments on a chromosome, or with respect to each other"
PROPERTIES:
"FE_DefaultSummary" "accessionID*, displayName, alias, LFM, RFM",
"FE_Visible:distanceData" "No",
"FE_Visible:polymorphisms" "No",
"PRW/FE_ObjectMenu" "{{parentmenu}} | Add Reagent Source",
"SRW/FE_ObjectMenu" "{{parentmenu}} | Add Reagent Source | Add Cytogenetic Location",
"GDB_Rule.displayName" "User defined"
ATTRIBUTE availableFrom
DERIVATION: ! reagent [ ReagentSource ]
ORDER BY availableFrom [ ReagentSource ] displayName ASC
DESCRIPTION: "List of sources from which this panel can be obtained."
ATTRIBUTE members: set-of [1,] GenomicSegment
ORDER BY members.displayName ASC
DELETE CASCADES
DESCRIPTION: "Cell lines or clones included in the panel."
PROPERTIES:
"OB_Union" "CellLine Clone",
"GDB_Rule" "must be unique within the MappingPanel. the release date of the MappingPanel cannot be any earlier than the releaseDate of it member components"
ATTRIBUTE panelSize
DERIVATION: count of members
DESCRIPTION: "Number of elements in panel."
ATTRIBUTE source: [1,1] VARCHAR(255)
DESCRIPTION: "Describes whether the panel is from one or multiple chromosomes, or genome-wide."
ATTRIBUTE sourcePloidy: [1,1] PloidyDict
ATTRIBUTE radDose: [0,1] INTEGER
DESCRIPTION: "For radiation hybrids, radiation dose in rads."
PROPERTIES:
"GDB_Rule" "Must be null if members.cellLineType is not RH. if supplied, must be >= 0"
ATTRIBUTE rhMaps
DERIVATION: ! mappingPanel [ RadiationHybridMap ]
DESCRIPTION: "Radiation hybrid maps based on this panel."
PROPERTIES:
"FE_PrintName" "RH Maps"
OBJECT CLASS Mutation
isa* Variation
DESCRIPTION: "A variation which occurs spontaneously or rarely, usually resulting in a phenotypic change."
PROPERTIES:
"FE_Order" "1",
"FE_DefaultSummary" "accessionID*, displayName",
"GDB_Rule.displayName" "User defined",
OBJECT CLASS ObjectHistory
DESCRIPTION: "Object history"
PROPERTIES:
"OB_DBRoot" "Yes",
"FE_Visible" "No",
"FE_Editable" "No",
"Admin/FE_Visible" "Yes",
"FE_ObjectMenu" "",
"FE_DisplayAttr" "modDate"
REP: version, modDate
ATTRIBUTE object: [1,1] NUMERIC(10,0)
DESCRIPTION: "Object instance ID for which history is being kept"
ATTRIBUTE objectClass: [1,1] VARCHAR(30)
DESCRIPTION: "Object Class name of the instance"
ATTRIBUTE changes (attributeName, elementID, changedFrom, changedTo):
set-of [0,] ([1,1] VARCHAR(255), [0,1] INTEGER, [0,1] VARCHAR(255), [0,1] VARCHAR(255))
DESCRIPTION: "Change log of all the attributes of this object instance"
COMPONENT attributeName
PROPERTIES:
"DESCRIPTION" "Attribute Name, if tuple attribute, only component attibute name is needed"
COMPONENT elementID
PROPERTIES:
"DESCRIPTION" "'aid' of mva/lva attribute; null for others"
COMPONENT changedFrom
PROPERTIES:
"DESCRIPTION" "Old value of the attribute"
COMPONENT changedTo
PROPERTIES:
"DESCRIPTION" "New value of the attribute"
ATTRIBUTE lastModifiedBy: [1,1] Contact
DESCRIPTION: "Person who last modified the object."
PROPERTIES:
"FE_Editable" "No",
"GDB_Rule" "set to @_currentUser on Insert/Update/Delete"
ATTRIBUTE modDate: [1,1] DATETIME
DESCRIPTION: "Date when the object was last modified."
PROPERTIES:
"FE_Editable" "No",
"GDB_Rule" "on insert, modDate set to addDate; on update,delete set to getdate()"
ATTRIBUTE version: [1,1] INTEGER
DESCRIPTION:"Version of the object instance."
OBJECT CLASS ObjectName
DESCRIPTION: "Combines primary names and third-party editable aliases in a common class to allow primary names and aliases to be searched simultaneously."
PROPERTIES:
"FE_Order" "-1",
"FE_ClassAttr" "objectClass",
"FE_DisplayAttr" "displayName",
"FE_ObjectMenu" "View History",
"FE_DefaultSummary" "displayName*, aliasType,dBObject",
"PRW/FE_ObjectMenu" "{{parentmenu}} | View History",
"SRW/FE_ObjectMenu" "{{parentmenu}} | View History",
"Admin/FE_ObjectMenu" "{{parentmenu}} | {{Edit}} | View History",
"OB_Key" "_oid",
"OB_Restrict" "Yes",
"OB_DBRoot" "Yes",
"OB_SearchKey" "searchName"
REP: displayName
ATTRIBUTE modDate: [1,1] DATETIME
DESCRIPTION: "Date when the annotation was last modified."
PROPERTIES:
"FE_IncludeInDetail" "No",
"Admin/FE_IncludeInDetail" "Yes",
"FE_Editable" "No",
"GDB_Rule" "Set by insert/update procs"
ATTRIBUTE displayName: [1,1] VARCHAR(200)
DESCRIPTION: "Value displayed when referring to this annotation in query results or in detail displays of objects linked to it. The name is automatically derived from the owner, mod date, and text."
PROPERTIES:
"FE_Order" "1",
"FE_Queryable" "Yes",
"FE_Search" "searchName",
"FE_PrintName" "Name"
ATTRIBUTE searchName: [1,1] VARCHAR(200)
DESCRIPTION: "Corresponds to lower(displayName). Denormalized to aid searching"
PROPERTIES:
"FE_Editable" "No",
"FE_Order" "1",
"FE_Visible" "No",
"FE_MatchCase" "Lower",
"GDB_Rule" "Always set to lower(displayName) on insert/update"
ATTRIBUTE owner: [1,1] Contact
DELETE CASCADES
DESCRIPTION: "The single Person or group of Persons (Edit Group) responsible for the content of the annotation. This person or group has editing access to the annotation and can view it before release to the public. Only GDB staff can change the ownership of an annotation."
PROPERTIES:
"FE_Editable" "No",
"FE_Order" "2"
ATTRIBUTE isReleased: [1,1] YesNo_YesDict
DESCRIPTION: "Released status."
PROPERTIES:
"FE_Editable" "No",
"FE_Order" "-3",
"GDB_Rule" "The releasedness of the ExternalLink is dictated by the DBObjects linked to this"
ATTRIBUTE releaseDate: [1,1] DATETIME
DESCRIPTION: "Date the annotation became or will become publicly available. Annotations can be unpublished for up to 6 months after submission. Once a release date has been assigned, it can be changed to an earlier date within that six-month period, but not earlier than the current date."
PROPERTIES:
"FE_IncludeInDetail" "No",
"Admin/FE_IncludeInDetail" "Yes",
"FE_Order" "-4",
"FE_Editable" "No",
"GDB_Rule" "