Skip to main content

Type 2 diabetes genetic association database manually curated for the study design and odds ratio



The prevalence of type 2 diabetes has reached epidemic proportions worldwide, and the incidence of life-threatening complications of diabetes through continued exposure of tissues to high glucose levels is increasing. Advances in genotyping technology have increased the scale and accuracy of the genotype data so that an association genetic study has expanded enormously. Consequently, it is difficult to search the published association data efficiently, and several databases on the association results have been constructed, but these databases have their limitations to researchers: some providing only genome-wide association data, some not focused on the association but more on the integrative data, and some are not user-friendly. In this study, a user-friend database of type 2 diabetes genetic association of manually curated information was constructed.


The list of publications used in this study was collected from the HuGE Navigator, which is an online database of published genome epidemiology literature. Because type 2 diabetes genetic association database (T2DGADB) aims to provide specialized information on the genetic risk factors involved in the development of type 2 diabetes, 701 of the 1,771 publications in the type 2 Diabetes case-control study for the development of the disease were extracted.


In the database, the association results were grouped as either positive or negative. The gene and SNP names were replaced with gene symbols and rsSNP numbers, the association p-values were determined manually, and the results are displayed by graphs and tables. In addition, the study design in publications, such as the population type and size are described. This database can be used for research purposes, such as an association and functional study of type 2 diabetes related genes, and as a primary genetic resource to construct a diabetes risk test in the preparation of personalized medicine in the future.

Peer Review reports


The prevalence of type 2 diabetes has reached epidemic proportions worldwide with the largest increase in Asia, Africa and South America [1]. The incidence of life-threatening complications of diabetes, such as retinopathy, nephropathy and lower-limb amputation, caused by the continued exposure of tissue to the high glucose has increased [2]. Since hyperglycemia can be prevented and reversed significantly by lifestyle changes, including the exercise and nutrition, diabetes risk tests, such as one provided by the American Diabetes Association, have been used to alarm various high risk groups. However, an increase in the incidence of diabetes has not been stopped over the last decade, highlighting the need for new approaches. According to the World Health Organization (WHO), the number of people with type 2 diabetes worldwide was approximately 170 million and 280 million in 2000 and 2010, respectively, which is expected to increase to 430 million by 2030 [1, 3]

Following the growth of genomics, the disease susceptibility of human genetic variations has been examined to provide a better understanding of the pathophysiology of diabetes. The advances in genotyping technologies have increased the scale and accuracy of genotype data, thereby expanding enormously the number of genetic studies demonstrating a relationship between diseases and genetic variations. Consequently, it is difficult to search the massive number of publications from the text files in PubMed, which researchers normally access to obtain information. Moreover, a systematic comparison of published data is not possible without considerable effort. Since association studies may have false positives or true negatives, it is important to compare one study with another before drawing a conclusion as to whether the association is true or not. Furthermore, the genetic effect size expressed by the odds ratio in association analysis is not always easy to find from text files.

With these problems in this field, considerable effort has been made to implement public genetic association databases. There are several genetic association databases, such as Genetic Association Database, dbGAP[4] from NCBI and Catalog of Published Genome-Wide Association Studies[5] from NHGRI. The last two databases focus on the GWAS data, providing a list of genes and their association data as tables. Therefore, its value to researchers who want to examine the association studies carried out using the candidate gene approach has been reduced. Moreover, specific to diabetes, there are several databases, such as T2D-Db[6] and T1Dbase[7]. These databases deal with genetic association studies as well as more integration resources involving gene expression, pathway and protein-protein interaction.

To provide focused information on a T2D association study, this study designed the T2D Genetic Association Database (T2DGADB). T2DGADB using 701 publications of the T2D study provides genetic association data that was manually curated and searchable. The web-based application displays comprehensive summaries of the published T2D genetic association results for browsing, visualization and mining. In addition, the data was displayed graphically adding convenience to understanding them.

Construction and content

Data collection

The list of publications used in this study was collected from the HuGE Navigator (version 1.3, [8, 9], which is an online database of published genome epidemiology literature. The Type 2 Diabetes Mellitus related articles were searched using the HuGE Navigator Phenopedia [10], which was developed to search gene-disease association summaries using the disease name as the search item. 1,771 published studies beginning from 2001 to October 5, 2009 were obtained from the search. Among them, only case-control study articles for Type 2 Diabetes (T2D) development were selected in order to exclude the articles relevant to diabetes complications (e.g., nephropathy, retinopathy), haplotype analysis and drug treatment (e.g., sulphonylurea, troglitazone, metformin). T2DGADB aims to provide specialized information on the genetic risk factors involved in the development of Type 2 diabetes. The articles on diabetes complications normally deal with the prognostic process of diabetes, and the articles on drug treatments deal with the pharmacogenetic aspects of diabetes patients. The decisions as to how the data on haplotype analysis would be collected are difficult because T2DGADB focused on information regarding each SNP association including the populations used, odds ratio etc. In this point, haplotype analysis could not be well fitted in the format. The final dataset was 701 publications in the Type 2 Diabetes case-control study for the development of the disease.

To select the 701 T2D development papers, the abstracts of 1,771 articles were downloaded through PubMed to be classified into T2D case-control articles or others. This information along with the title, authors, abstract, journal, online or in print publication date and PubMed ID to hyperlink to PubMed Abstract plus were deposited in the T2D Genetic Association Database. In addition, the full text of the 701 articles were downloaded, if accessible, to obtain all available text, tables, figures and supplemental data from the original articles. 625 of the 701 articles could be accessed but 76 articles could not be downloaded or were not written in English.

Data incorporation

Since dbSNP builds and human genome builds were updated frequently from 2001 to 2009, it was important to change the Gene names, SNP positions and SNP rs number. Some articles reported only the SNP position and nucleotide change information (e.g., -4034A > C) instead of SNP ID (rs number), and in a few cases, they used their own SNP ID (e.g., SNP1, UCSNP-44). Old gene names and gene aliases were replaced with the Entrez gene official symbol (e.g., sAC→ADCY10, PC-1→ENPP1, last updated Aug 20, 2009).

The author's own SNP ID or SNP position information was replaced with the rs number using the HuGE Navigator Variant Name Mapper, which is an online tool to map the common variation names and rs numbers of genetic variants. However, it was too limited to find all the SNPs missing their own rs number because only 1,159 genes and 5,646 variants were deposited in the database (Aug 20, 2009). An alternative method was to use other databases, NCBI dbSNP, USCS Genome Browser and UCSC In-Silico PCR tool, based on the information provided by the articles. Some papers reported amino acid change information instead of the SNP ID. In this case, they were changed into rs numbers using SNP GeneView of NCBI dbSNP (e.g., PPARG, Pro12Ala→rs1801282). In some cases, a pair of PCR primer sequences was provided for the SNP. The UCSC In-Silico PCR tool can obtain a PCR product sequence with the primer sequences reported in the paper. The UCSC Genome Browser could confirm whether the locations of the PCR product sequences match the genes or chromosome locations described by the author, and the SNPs within the sequences were selected.

Summary of the Data

T2DGADB contains information on the study design and SNP association result (Figure 1). The study design information summarizes the case and control sample size, sample population (e.g., Korean, Indian, American), age and gender of the subjects and study cohort data (e.g., Finland-U.S. Investigation of NIDDM Genetics (FUSION), Nurses' Health Study), if available.

Figure 1
figure 1

Workflow through T2DGADB.

SNP association information summarizes the results of an association study for each SNP or variant. It contains variation information, such as position information, common name of SNP as reported by the authors, dbSNP rs number, gene name, allele frequency of the reported allele, which is minor allele or risk allele, odds ratio and 95% confidence interval (CI) and p-value. Information on the covariants was added if the authors reported an adjusted p-value for the confounding factors. The association result was determined to be "associated" if the p-value was <0.05 or the odds ratio and 95% CI were in a suitable range. In some cases, the range of odds ratio and 95% CI was suitable but the association result was not associated because the adjusted p-value was not <0.05. In the case where both results were provided in the article, the adjusted p-value was used to determine the association.

Web implementation and Database design

T2DGADB web interface was implemented in JSP, HTML and Javascript and run on CentOS (version 4.7) with the Apache-Tomcat (version 6.0.18) web server. MySQL (version 4.1.18) was used as the DBMS (Database Management System).

Figure 1 described the data workflow through T2DGADB. T2DGADB includes three local databases such as T2D genetic association database that summarise 701 publications, gene information database that is obtained from NCBI Entrez Gene database, and T2D related publication abstract database that is obtained from NCBI PubMed database. T2DGADB contains three main web pages such as total T2D gene list page, gene information page summarizing distribution of association results of gene and SNPs, and SNP information page summarizing study design and association results of SNPs. Figure 1 also illustrates that user can get the information from T2D related gene list page to SNP information page, sequentially. Each gene, SNP and publication is hyperlinked to NCBI Entrez gene, dbSNP and PubMed, respectively.


Common features

T2DGADB provides a list of T2D associated genes, graphical views of their associations, variations that have been studied, links to the PubMed abstracts and more. Five hundred and thirty T2D gene lists, the full name of each gene and the number of published papers were found from the front page of the web site (Figure 2). The flags of "GWAS" and "META" in the publication column represent that the gene flagged includes the data from GWAS or meta-analysis. Search results in T2DGADB such as gene list, SNP rs number list and publication list are downloadable. The gene symbol, Entrez gene ID and official gene full name were referred to the Entrez gene record in GenBank. The location of chromosome band was presented instead of the gene name if the associated SNP was located between the gene and the gene in the intergenic region. However, the gene name for the SNP was used if the authors reported the genes that were nearest to the SNP. T2DGADB is a searchable web-based application that researchers can search using keywords such as the gene name, SNP rs number and chromosome.

Figure 2
figure 2

Main page of the database. Display of the genes that have been reported with Type 2 Diabetes and the number of publications.

T2D gene information features

Searching by the gene name or clicking an interested gene in the front page leads to a T2D gene information page, offering the SNP and literature information of the gene. This page provides a bar graph of the association results as to whether the publication results are positive or negative in addition to the number of articles involved (Figure 3). A positive and negative result data is represented in red and blue color, respectively. One article might have more than one SNP analyzed in the study, and in some cases, each SNP may be examined with various samples in the paper. Therefore, the sum of the publication number for the positive and negative result might be higher than the total number of publications. For example, if one article deals with 2 SNPs of which one SNP is negative in the association result and the other is positive, it displays one negative and one positive result in the gene information page, even though there is only one publication. To prevent confusion, a list of articles containing the title, author and journal name, which appears by clicking the total articles, are also offered and the articles are hyperlinked to PubMed (Figure 4). The bar graph of each gene was drawn to scale according to the ratio of the number of positive to negative results. In the lower panel of the T2D gene information page, there are more bar graphs dedicated to the respective SNPs, which describe the positive and negative results by number. The gene symbol is linked to the Entrez Gene in NCBI, and clicking the rs number in the lower panel leads to the association results of the SNPs.

Figure 3
figure 3

Display of the distribution of the association result for HHEX and each SNP (Gene information features).

Figure 4
figure 4

Article list for HHEX as an example(Gene information features).

SNP association result features

The SNP association result page provides T2D association-related information graphically, such as the OR, 95% CI and p-value (Figure 5). Each entry is displayed as a box plot. The red and blue color of the PubMed ID column and box of the box plot indicates a positive or negative association result, respectively. The box represents the OR and the horizontal bar indicates the boundary of the 95% CI. The association results were not presented in the graph when authors did not provide an OR or 95% CI. The SNP association result table shows detailed information on each article which includes the population, sample size, OR, p-value and more (Figure 6). It shows the best result of each SNP. Although the author reported a model-based OR and p-value, such as the additive, dominant, recessive, codominant model or logistic regression results, the most significant value among them is shown. If the p-value was obtained by adjusting the confounding factors in the article, they are marked with "(a)" and the list of confounding factors are provided. The adjusted p-value is selected if the article showed both the adjusted and crude p-value. For this reason, some data is represented as "no association" even when there is a proper OR and 95% CI. In the table, PubMed ID is linked to the article information data, which provides the title, abstract, authors and journal name.

Figure 5
figure 5

Box plot (SNP association result features). The box plot graphs that include OR, 95% CI and p-value of rs1111875 as an example.

Figure 6
figure 6

Results table (SNP association result features). The table that includes the population, sample size, OR, 95% CI and p-value of rs1111875 as an example.

Analysis of T2DGADB data

Several statistical analyses were performed using these databases to characterize the published T2D association results. First, Figure 7 shows the distribution of the study ethnic populations used for the association with T2D. Mostly European and Asian populations were investigated with relatively few studies being carried out on Middle-East residents, American Indians, Africans and Latin Americans. Second, most of the genes listed in the database were published once and only 28.11% (149 genes from the total 530 genes) of genes were published more than twice (Figure 8). Figure 9 shows the distribution of a case sample size. More than 50% of publications used 100 ~ 500 participants as case samples. Most of the OR was distributed in the 0.5 ~ 2 range (Figure 10).

Figure 7
figure 7

Number of publications according to ethnic group.

Figure 8
figure 8

Number of genes according to number of publications.

Figure 9
figure 9

Number of publications according to case sample size.

Figure 10
figure 10

Distribution of the OR for the association with T2D.


With the advances in technology for genetic studies, the amount of genetic information has increased over the last decade so that publications on the relationship between the disease and genetic variations have also increased explosively [8, 9, 11]. However, it might be difficult to summarize the huge data results in a systemic manner because information, such as the name of the SNP, gene and association result, was described differently in the papers. Several databases have been established to collect and present data to the user [47, 12]. Nevertheless, it is difficult to find information of interest to the researchers because most databases are only archives. Researchers can search for informative data in public databases, for example, a literature search through a PubMed search, find disease-related genes using HuGE Navigator, and obtain GWAS publication data from the online GWAS summaries in NHGRI. However it is still difficult to compare all the data at a glance because the data is provided in text format only (refer table 1 for comparison).

Table 1 Comparison of T2D related DB with T2DGADB

This study implemented a database that stores the results of type 2 diabetes association study and detailed information on the study design, and provided graphs that represent the association results. The goal in developing T2DGADB was to provide researchers with quick and easy access to published T2D genetic association information. Moreover, the data in the database was manually curated by adding accuracy to it in order to help researchers evaluate the T2D association study results that have been published from 2001 to 2009. To use the data in T2DGADB, a scientist can begin with a gene with a published association with T2D, then find positive or negative results of all SNPs studied within the gene, discover OR, 95% CI and the p-value of each SNP through a box plot graph, and finally understand the study design information (e.g., study population, sample size) (Figure 1). This is a unique resource to show both study data on the candidate gene approach and GWAS data graphically for T2D researchers. The data can provide a starting point for a genetic study design, systematic review or reference search as well as produce primary genetic data for constructing a diabetes risk test in the preparation of personalized medicine.

This study is a small step in the preparation of a personalized diagnosis system. Using this data, T2D candidate genes can be selected and their risk be estimated. Eventually, the diabetes genetic association database can be utilized to make a computer program that provides health care providers with the individual susceptibility to diabetes for personalized medicine, and can be expanded to the selection of high risk groups for preventive medicine.


In this study, a user-friend database of T2D genetic association of manually curated information was constructed. This database can be used for research purposes, such as an association and functional study of T2D related genes, and as a primary genetic resource to construct a diabetes risk test in the preparation of personalized medicine in the future.

Availability and requirements

T2DGADB is freely available for academic and commercial users at


  1. Shaw JE, Sicree RA, Zimmet PZ: Global estimates of the prevalence of diabetes for 2010 and 2030. Diabetes Res Clin Pract. 2010, 87 (1): 4-14. 10.1016/j.diabres.2009.10.007.

    CAS  Article  PubMed  Google Scholar 

  2. Campbell RK: Type 2 diabetes: where we are today: an overview of disease burden, current treatments, and treatment strategies. J Am Pharm Assoc (2003). 2009, 49 (Suppl 1): S3-9. 10.1331/JAPhA.2009.09077.

    Article  Google Scholar 

  3. Wild S, Roglic G, Green A, Sicree R, King H: Global prevalence of diabetes: estimates for the year 2000 and projections for 2030. Diabetes Care. 2004, 27 (5): 1047-1053. 10.2337/diacare.27.5.1047.

    Article  PubMed  Google Scholar 

  4. Mailman MD, Feolo M, Jin Y, Kimura M, Tryka K, Bagoutdinov R, Hao L, Kiang A, Paschall J, Phan L: The NCBI dbGaP database of genotypes and phenotypes. Nat Genet. 2007, 39 (10): 1181-1186. 10.1038/ng1007-1181.

    CAS  Article  PubMed  PubMed Central  Google Scholar 

  5. Hindorff LA, Sethupathy P, Junkins HA, Ramos EM, Mehta JP, Collins FS, Manolio TA: Potential etiologic and functional implications of genome-wide association loci for human diseases and traits. Proc Natl Acad Sci USA. 2009, 106 (23): 9362-9367. 10.1073/pnas.0903103106.

    CAS  Article  PubMed  PubMed Central  Google Scholar 

  6. Agrawal S, Dimitrova N, Nathan P, Udayakumar K, Lakshmi SS, Sriram S, Manjusha N, Sengupta U: T2D-Db: an integrated platform to study the molecular basis of Type 2 diabetes. BMC Genomics. 2008, 9: 320-10.1186/1471-2164-9-320.

    Article  PubMed  PubMed Central  Google Scholar 

  7. Hulbert EM, Smink LJ, Adlem EC, Allen JE, Burdick DB, Burren OS, Cassen VM, Cavnor CC, Dolman GE, Flamez D: T1DBase: integration and presentation of complex data for type 1 diabetes research. Nucleic Acids Res. 2007, D742-746. 10.1093/nar/gkl933. 35 Database

  8. Yu W, Gwinn M, Clyne M, Yesupriya A, Khoury MJ: A navigator for human genome epidemiology. Nat Genet. 2008, 40 (2): 124-125. 10.1038/ng0208-124.

    CAS  Article  PubMed  Google Scholar 

  9. Yu W, Yesupriya A, Wulf A, Qu J, Khoury MJ, Gwinn M: An open source infrastructure for managing knowledge and finding potential collaborators in a domain-specific subset of PubMed, with an example from human genome epidemiology. BMC Bioinformatics. 2007, 8: 436-10.1186/1471-2105-8-436.

    Article  PubMed  PubMed Central  Google Scholar 

  10. Yu W, Clyne M, Khoury MJ, Gwinn M: Phenopedia and Genopedia: disease-centered and gene-centered views of the evolving knowledge of human genetic associations. Bioinformatics. 2010, 26 (1): 145-146. 10.1093/bioinformatics/btp618.

    CAS  Article  PubMed  Google Scholar 

  11. Kim S, Misra A: SNP genotyping: technologies and biomedical applications. Annu Rev Biomed Eng. 2007, 9: 289-320. 10.1146/annurev.bioeng.9.060906.152037.

    CAS  Article  PubMed  Google Scholar 

  12. Johnson AD, O'Donnell CJ: An open access database of genome-wide association results. BMC Med Genet. 2009, 10: 6-10.1186/1471-2350-10-6.

    Article  PubMed  PubMed Central  Google Scholar 

Pre-publication history

Download references


This work was supported by a grant from the Graduate Research Scholarship, Kyung Hee University Graduate School, Seoul, Republic of Korea.

Author information

Authors and Affiliations


Corresponding authors

Correspondence to Hun Kuk Park or Bermseok Oh.

Additional information

Competing interests

The authors declare that they have no competing interests.

Authors' contributions

JEL, KWH, HKP and BO conceptualised and designed the project. JEL, KWH, HSJ and YSK designed database scheme, input data structure and data curation condition. JEL and BO drafted the manuscript. YSK, HKP and BO contributed to the intellectual content of the manuscript. All authors read and approved the final manuscript.

Authors’ original submitted files for images

Rights and permissions

Open Access This article is published under license to BioMed Central Ltd. This is an Open Access article is distributed under the terms of the Creative Commons Attribution License ( ), which permits unrestricted use, distribution, and reproduction in any medium, provided the original work is properly cited.

Reprints and Permissions

About this article

Cite this article

Lim, J.E., Hong, KW., Jin, HS. et al. Type 2 diabetes genetic association database manually curated for the study design and odds ratio. BMC Med Inform Decis Mak 10, 76 (2010).

Download citation

  • Received:

  • Accepted:

  • Published:

  • DOI:


  • Association Result
  • Genetic Association Database
  • HuGE Navigator
  • NCBI Entrez Gene Database
  • Entrez Gene Record