📊 Table: fnl_sprime_pooled_delta_sprime

This table contains pooled and reference S' (S-prime) metrics along with statistical measures and drug sensitivity information.

Column Name	Data Type	Description
name	character varying(255)	Name of the compound or entity
gene_id	integer	Gene identifier
ref_pooled_s_prime	double precision	Reference pooled S' value
ref_median_s_prime	double precision	Reference median S'
ref_mad	double precision	Reference median absolute deviation (MAD)
ref_pooled_auc	double precision	Reference pooled area under the curve (AUC)
ref_pooled_ec50	double precision	Reference pooled EC50 (half maximal effective concentration)
num_ref_lines	integer	Number of reference cell lines
ref_s_prime_variance	double precision	Variance of reference S' values
test_pooled_s_prime	double precision	Test pooled S' value
test_median_s_prime	double precision	Test median S'
test_mad	double precision	Test median absolute deviation (MAD)
test_pooled_auc	double precision	Test pooled area under the curve (AUC)
test_pooled_ec50	double precision	Test pooled EC50
num_test_lines	integer	Number of test cell lines
test_s_prime_variance	double precision	Variance of test S' values
delta_s_prime	double precision	Difference in S' between test and reference
delta_auc	double precision	Difference in AUC between test and reference
delta_ec50	double precision	Difference in EC50 between test and reference
delta_s_prime_median	double precision	Median difference in S'
p_val_median_man_whit	double precision	P-value from Mann-Whitney test on median values
sensitivity_score	integer	Sensitivity score
sensitivity	character varying(50)	Sensitivity category (e.g. sensitive, resistant)
moa	character varying(1000)	Mechanism of action
target	character varying(1000)	Target molecule or pathway
tissue	character varying(255)	Tissue type