What kind of expression correlation occurs in physical type interacting gene pairs and what percentage of these are negatively correlated?
If the Expression_Corr value is negative then it's negatively correlated. Percentage of Negative Correlation = count(negative Expression_Corr physical type) / count(Expression_Corr physical type) * 100%
SELECT Expression_Corr FROM Interactions WHERE Type = 'Physical' UNION ALL SELECT CAST(SUM(Expression_Corr < 0) AS REAL) * 100 / COUNT(*) FROM Interactions WHERE Type = 'Physical'
database name:db_id genes
Classification table Classification Cols: gene id dtype text, Localization dtype text, 
Genes table Genes Cols: gene id dtype text, Essential dtype text, Class dtype text, Complex dtype text, Phenotype dtype text, Motif dtype text, Chromosome dtype integer, Function dtype text, Localization dtype text, 
Interactions table Interactions Cols: gene id 1 dtype text, gene id 2 dtype text, Type dtype text, Expression correlation score dtype real, 
