#Letter#
#NUCACID_LOCAL_IDS (LOCAL_1)#
#NAId#
#Institution = 1#
#LocalId (LocalId_1)#
#NAId#
#NUCACID_LOCAL_IDS (LOCAL_2)#
#Institution = 2#
#LocalId (LocalId_2)#
#NAId#
# LAST_QUANTS** (NANODROP)#
#Conc_Method = 2#
# Last_Pg_ul / 1000 (Nanodrop_Ng_ul)#
# LastDate (Nanodrop_LastDate)#
#NAId#
# LAST_QUANTS** (QPCR)#
#Conc_Method = 1#
# LastDate (QPCR_LastDate)#
# Last_Pg_ul (QPCR_Pg_ul)#
#NAId#
# LAST_QUANTS** (QUBIT)#
#Conc_Method = 3#
# LastDate (Qubit_LastDate)#
# Last_Pg_ul / 1000 (Qubit_Ng_ul)#
# Last_Pg_ul / 1000 (Bioanalyzer_Ng_ul)#
#Conc_Method = 4#
#NAId#
# LAST_QUANTS** (BIOANALYZER)#
# LastDate (Bioanalyzer_LastDate)#
#NAId#
# LAST_QUANTS** (QUANTIT)#
#Conc_Method = 5#
# Last_Pg_ul / 1000 (Quantit_Ng_ul)#
# LastDate (Quantit_LastDate)#
# ** LAST_QUANTS is a subquery from
NUCACID_CONC_DATA, in which the
Conc_Date and Pg_ul of the most-recent
quantification is determined for each
distinct NAId-Conc_Method dyad. It does
not exist anywhere as an independent
entity.#
# LAST_VALUE(Pg_ul)
OVER (PARTITION BY NAId, Conc_Method
ORDER BY Conc_Date
RANGE BETWEEN UNBOUNDED PRECEDING
AND UNBOUNDED FOLLOWING)
(Last_Pg_ul)#
# LAST_VALUE(Conc_Date)
OVER (PARTITION BY NAId, Conc_Method
ORDER BY Conc_Date
RANGE BETWEEN UNBOUNDED PRECEDING
AND UNBOUNDED FOLLOWING)
(LastDate)#
#Conc_Method (Conc_Method)#
#NAId (NAId)#
#NUCACID_CONC_DATA (LAST_QUANTS) **#
#Location (Location)#
#Institution* (Institution)#
#LOCATIONS#
#LocId#
#* CONCAT_CREATORS is a subquery
from NUCACID_CREATORS, in which
all Creator rows for an NAId are
concatenated (but separated by a
"/") into a single string. It does not
appear anywhere as an independent
entity.#
#CONCAT_CREATORS*#
#NAId#
#NUCACID_CREATORS#
#STRING_AGG(Creator, '/'
ORDER BY nacrid)
(Created_By)#
#Creation_Method (Creation_Method)#
#Actual_Vol_Date (Actual_Vol_Date)#
#NUCACID_DATA#
#NAId (NAId)#
#TId (TId)#
#Name_on_Tube (Name_on_Tube)#
#NucAcid_Type (NucAcid_Type)#
#Creation_Date (Creation_Date)#
#Initial_Vol_ul (Initial_Vol_ul)#
#Actual_Vol_ul (Actual_Vol_ul)#
#Notes (Notes)#
#LocId (LocId)#
#TISSUE_DATA#
#TId#
#UIId (UIId)#
#Tissue_Type (Tissue_Type)#
#UNIQUE_INDIVS#
#UIId#
#IndivId (IndivId)#
#PopId (PopId)#
#Sname (Sname)#
#Bioid#
#BIOGRAPH#
#Source_NA_Relationship (Relationship)#
#Source_NAId (Source_NA)#
#NAId#
#NUCACID_SOURCES#