📊 Table: im_dep_raw_secondary_dose_curve

This table contains raw dose-response parameters for compounds tested on various cancer cell lines.

🗂 Source: The data was imported directly from the secondary-screen-dose-response-curve-parameters.csv file.
It includes pharmacological metrics such as ec50, ic50, auc, as well as contextual compound annotations like moa, target, and disease_area.

Column Name	Data Type	Nullable	Description
broad_id	varchar(255)	YES	ID used to identify drug-batch combinations
depmap_id	varchar(255)	YES	ID to identify a cell line
ccle_name	varchar(1000)	YES	ID to identify a cell line composed of the cell line name and the tissue of origin
screen_id	varchar(50)	YES	ID to identify a screen
upper_limit	integer	YES	Limit of the concentration-response curve as it approaches infinity, normalized to 1
lower_limit	double precision	YES	Limit of the concentration-response curve as concentration approaches zero
slope	double precision	YES	Refers to the steepness of the concentration-response curve
r2	double precision	YES	Goodness of fit measure between concentration-response curve and replicate viability data
auc	double precision	YES	Area under the concentration-response curve
ec50	double precision	YES	Concentration of inflection point of the concentration-response curve, EC50 stands for 'half maximal effective concentration"
ic50	double precision	YES	Concentration that corresponds to a viability of 50% on the concentration-response curve, IC50 stands for "half maximal inhibitory concentration"
name	varchar(255)	YES	Name of drug or compound
moa	varchar(1000)	YES	Broad Repurposing Hub mechanism of action annotation, see https://repo-hub.broadinstitute.org/repurposing-app
target	varchar(1000)	YES	Broad Repurposing Hub gene target annotation, see https://repo-hub.broadinstitute.org/repurposing-app
disease_area	varchar(1000)	YES	Broad Repurposing Hub disease area annotation, see https://repo-hub.broadinstitute.org/repurposing-app
indication	varchar(1000)	YES	Broad Repurposing Hub indication annotation: for drug labeling indication refers to the specific disease, condition, or symptom for which the drug is approved by the FDA
smiles	varchar(1500)	YES	Simplified molecular-input line-entry system molecular identifier
phase	varchar(255)	YES	Broad Repurposing Hub latest-clinical phase annotation, refers to the stage of (regulatory) development, see https://repo-hub.broadinstitute.org/repurposing-app
passed_str_profiling	boolean	YES	Indicator for problems identified by STR profiling, a type of data QC (epMap), note use only values with TRUE
row_name	varchar(255)	YES	ID used to identify cell line or control barcode in data matrices