Previous Query
Next Query
Fraction of native contacts vs RMSD
SELECT
c.native/n.native AS Fract_nat_cont,
c1.rmsd
FROM dbo.[contact_678] as c
JOIN dbo.[RMSD_678] as c1
ON (c.step = c1.step)
JOIN ( SELECT CAST(d.native AS REAL) AS native
FROM dbo.[contact_678] as d
WHERE d.step=0 ) AS n
ON 1=1
ORDER BY c1.step;