Difference between revisions of "Genotype"

From WormBaseWiki
Jump to navigationJump to search
Line 45: Line 45:
 
== Genotype OA ==
 
== Genotype OA ==
 
*pgid - the postgres ID - NOT DUMPED
 
*pgid - the postgres ID - NOT DUMPED
*ID - gen_identifier - Genotype primary ID #Note: This is automatically assigned  
+
*ID - gno_identifier - Genotype primary ID #Note: This is automatically assigned  
*Curator - gen_curator - NOT DUMPED - Curator (Dropdown)
+
*Curator - gno_curator - NOT DUMPED - Curator (Dropdown)
*Name - gen_name - Name - Big text
+
*Name - gno_name - Name - Big text
*Gene - gen_gene - Gene - ?Gene (Multi-ontology)
+
*Gene - gno_gene - Gene - ?Gene (Multi-ontology)
*Variation (Unknown Zygosity) - gen_variation - Variation - ?Variation  (Multi-ontology)
+
*Variation - gno_variation - Variation - ?Variation  (Multi-ontology)
*Homozygous Variation - gen_homo_variation - Variation - ?Variation  Homozygous  (Multi-ontology)
+
*Rearrangement - gno_rearrangement - Rearrangement - ?Rearrangement  (Multi-ontology)
*Heterozygous (w/WT) Variation - gen_hetwt_variation - Variation - ?Variation  Heterozygous_with_wildtype  (Multi-ontology)
+
*Transgene - gno_transgene - Transgene - ?Transgene  (Multi-ontology)
*Heteroallelic Variation - gen_hetal_variation - Variation - ?Variation Heteroallelic_combination  (Multi-ontology)
+
*Other Component - gno_othercomp - Other_component - Big text
*Rearrangement (Unknown Zygosity) - gen_rearrangement - Rearrangement - ?Rearrangement  (Multi-ontology)
+
*Species - gno_species - Species - ?Species (Dropdown)
*Homozygous Rearrangement - gen_homo_rearrangement - Rearrangement - ?Rearrangement  Homozygous (Multi-ontology)
+
*Remark - gno_remark - Remark - Big text
*Heterozygous (w/WT) Rearrangement - gen_hetwt_rearrangement - Rearrangement - ?Rearrangement Heterozygous_with_wildtype  (Multi-ontology)
+
*Paper - gno_paper - Reference - ?Paper (Ontology)
*Heteroallelic Rearrangement - gen_hetal_rearrangement - Rearrangement - ?Rearrangement  Heteroallelic_combination  (Multi-ontology)
+
*NO DUMP - gno_nodump - NOT DUMPED - toggle
*Transgene (Unknown Zygosity) - gen_transgene - Transgene - ?Transgene (Multi-ontology)
 
*Homozygous Transgene - gen_homo_transgene - Transgene - ?Transgene Homozygous  (Multi-ontology)
 
*Heterozygous (w/WT) Transgene - gen_hetwt_transgene - Transgene - ?Transgene  Heterozygous_with_wildtype  (Multi-ontology)
 
*Heteroallelic Transgene - gen_hetal_transgene - Transgene - ?Transgene  Heteroallelic_combination (Multi-ontology)
 
*Other Component - gen_othercomp - Other_component - Big text
 
*Species - gen_species - Species - ?Species (Dropdown)
 
*Remark - gen_remark - Remark - Big text
 
*Paper - gen_paper - Reference - ?Paper (Ontology)
 
*NO DUMP - gen_nodump - NOT DUMPED - toggle
 

Revision as of 16:11, 20 February 2020

Rationale

To enable curators (disease curators and then maybe phenotype curators) to annotate directly to entire genotypes, the ?Genotype class has been proposed. The decision was made that any ?Genotype object should reflect the entire genotype of a particular worm or strain of worms, to the extent that it is known, rather than partial genotypes. The initial data model allows for direct associations to disease model annotations (curated in the disease OA), whereby genotype associations to diseases (DO terms) would then be made during the Postgres curation database dump.

Issues

Action items

?Genotype model

Initial proposal:

?Genotype	Genotype_name  UNIQUE  ?Text		//  e.g. “unc-1(e103);unc-2(e234)”
                Genotype_component	Gene	?Gene	  XREF  Component_of_genotype  #Evidence
                                        Variation ?Variation	XREF	Component_of_genotype
		                        Rearrangement	?Rearrangement  XREF	Component_of_genotype
		                        Transgene	?Transgene  XREF  Component_of_genotype
		                        Other_component	UNIQUE  ?Text  // Free text components including RNAi
		Disease_info  Models_disease  ?DO_term  XREF  Disease_model_genotype	
			      Modifies_disease  ?DO_term  XREF  Disease_modifier_genotype
			      Disease_model_annotation  Model_genotype  ?Disease_model_annotation  XREF  Genotype
    			  				Modifier_genotype  ?Disease_model_annotation  XREF  Modifier_genotype
		Species	UNIQUE ?Species
		Remark	?Text	                           
		Reference	?Paper	XREF	Genotype

Genotype Postgres Tables

  • gno_identifier
  • gno_curator
  • gno_name
  • gno_gene
  • gno_variation
  • gno_rearrangement
  • gno_transgene
  • gno_othercomp
  • gno_species
  • gno_remark
  • gno_paper
  • gno_nodump

Genotype OA

  • pgid - the postgres ID - NOT DUMPED
  • ID - gno_identifier - Genotype primary ID #Note: This is automatically assigned
  • Curator - gno_curator - NOT DUMPED - Curator (Dropdown)
  • Name - gno_name - Name - Big text
  • Gene - gno_gene - Gene - ?Gene (Multi-ontology)
  • Variation - gno_variation - Variation - ?Variation (Multi-ontology)
  • Rearrangement - gno_rearrangement - Rearrangement - ?Rearrangement (Multi-ontology)
  • Transgene - gno_transgene - Transgene - ?Transgene (Multi-ontology)
  • Other Component - gno_othercomp - Other_component - Big text
  • Species - gno_species - Species - ?Species (Dropdown)
  • Remark - gno_remark - Remark - Big text
  • Paper - gno_paper - Reference - ?Paper (Ontology)
  • NO DUMP - gno_nodump - NOT DUMPED - toggle