Skip to main content
Fig. 2 | Rice

Fig. 2

From: Rice Stress-Resistant SNP Database

Fig. 2

Entity-Relationship Diagram for the RSRS database. The Pheno_SNP table is the table, which connects the phenotype details with the genotype details. In this table the pheno_ID field is used to identify the associated stress with the varieties and the snp_ID is used to identify the associated SNPs with the varieties. The Pheno_SNP table have a 1:N relationship with the Phenotypes and SNP_genotypes tables using pheno_ID and snp_ID keys. The SNP_genotypes table describes the detail of each SNP, which is characterized by its own unique ID, snp_ID, chrom, position, reference allele and genotypes of each accession. A SNP may consist of multiple alleles in which the annotation of each allele is stored in the SNP annotation table. The SNP_annotation table is connected in a 1:N relationship with the Gene_info table, which stores the detail of each gene. The Gene_Info table is connected to the GO_annotation table to characterize the associated genes with each SNP. The variety and phenotype details are stored in Variety_Info, Phenotype_data and Phenotypes table, var_ID and pheno_ID are used to connect these tables. The GWAS_info table stores the associated GWAS record of each SNP with its associated stress. The ER diagram was created by using draw.io at https://www.draw.io/

Back to article page