📊 Table: im_sprime_solved_s_prime

This table builds upon the raw dose-response data by adding computed efficacy metrics and a derived S' (S-prime) score, indicating a measure of drug effect strength or selectivity.

Column Name	Data Type	Description
id	integer (Primary Key)	Auto-incremented id
broad_id	varchar(255)	ID used to identify drug-batch combinations
depmap_id	varchar(255)	ID to identify a cell line
ccle_name	varchar(1000)	ID to identify a cell line composed of the cell line name and the tissue of origin
screen_id	varchar(50)	ID to identify a screen
upper_limit	integer	Limit of the concentration-response curve as it approaches infinity, normalized to 1
lower_limit	double precision	Limit of the concentration-response curve as concentration approaches zero
slope	double precision	*Refers to the steepness of the concentration-response curve *
r2	double precision	Goodness of fit measure between concentration-response curve and replicate viability data
auc	double precision	Area under the concentration-response curve
ec50	double precision	Concentration of inflection point of the concentration-response curve, EC50 stands for 'half maximal effective concentration"
ic50	double precision	Concentration that corresponds to a viability of 50% on the concentration-response curve, IC50 stands for "half maximal inhibitory concentration"
name	varchar(255)	Name of drug or compound
moa	varchar(1000)	Broad Repurposing Hub mechanism of action annotation, see https://repo-hub.broadinstitute.org/repurposing-app
target	varchar(1000)	Broad Repurposing Hub gene target annotation, see https://repo-hub.broadinstitute.org/repurposing-app
disease_area	varchar(1000)	Broad Repurposing Hub disease area annotation, see https://repo-hub.broadinstitute.org/repurposing-app
indication	varchar(1000)	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)	Simplified molecular-input line-entry system molecular identifier
phase	varchar(255)	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	Indicator for problems identified by STR profiling, a type of data QC (epMap), note use only values with TRUE
row_name	varchar(255)	ID used to identify cell line or control barcode in data matrices
eff	double precision	The difference between concentration-response curve asymptotes (upper_limit - lower_limit), effetiveness maximum
eff_100	double precision	EFF (effective maximum) times 100%, EFF as a percent
eff_ec50	double precision	EFF as a percent divided by the EC50 in μM
s_prime	double precision	asinh transformation of EFF/EC%), asinh is a natural log-like transformation