Figure - PMC

Skip to main content

An official website of the United States government

Here's how you know

Here's how you know

Official websites use .gov
A .gov website belongs to an official government organization in the United States.

Secure .gov websites use HTTPS
A lock ( ) or https:// means you've safely connected to the .gov website. Share sensitive information only on official, secure websites.

View full-text article in PMC

. 2015 Jul 30;2015:bav074. doi: 10.1093/database/bav074

Search in PMC
Search in PubMed
View in NLM Catalog
Add to search

© The Author(s) 2015. Published by Oxford University Press.

This is an Open Access article distributed under the terms of the Creative Commons Attribution License (http://creativecommons.org/licenses/by/4.0/), which permits unrestricted reuse, distribution, and reproduction in any medium, provided the original work is properly cited.

PMC Copyright notice

Figure 2. — Entity-Relationship Diagram for the experimental data tables in the NNTC-DCC database. The central table is the studies table which describes a given study characterized by a study_id (e.g. in the form of S0001.1), principal investigator, year, tissue request ID, measurement, technology, unit and tissue. A study may consist of multiple tissue requests, thus the study_id might be incremented (e.g. S0001.1 to S0001.2). The tables gene_expression, genotype, proteins, endo_exo_chemicals, morphometrics, and other are grouped around the studies table in a 1:N relationship signifying that a single study may study multiple genes, proteins, morphological characteristics, etc. The table gene_annotation contains HGNC ids, gene symbols, synonyms and annotations for genes and proteins, hence their connection to the tables gene_expression, genotype and proteins. The ER diagram was created by using Lucidchart at www.lucidchart.com.