Previous Query
Next Query
CA distance with a 10 angstrom cutoff
SELECT i2.residue_number
, i.residue_number
, SQRT(((POWER(c1.x_coord - c.x_coord , 2))
+ (POWER(c1.y_coord - c.y_coord , 2))
+ (POWER(c1.z_coord - c.z_coord , 2))))
FROM dbo.[coord_678] AS c
JOIN dbo.[coord_678] AS c1
ON ( c1.struct_id = c.struct_id
AND c1.step = c.step
AND c.atom_number > c1.atom_number )
JOIN dbo.ID AS i
ON ( i.struct_id = c.struct_id
AND i.atom_number = c.atom_number )
JOIN dbo.ID AS i2
ON ( i2.struct_id = c1.struct_id
AND i2.atom_number = c1.atom_number )
WHERE i.atom_name = 'CA'
AND i2.atom_name = 'CA'
AND c1.step=1
AND (((POWER(c1.x_coord - c.x_coord , 2))
+ (POWER(c1.y_coord - c.y_coord , 2))
+ (POWER(c1.z_coord - c.z_coord , 2)))) < 100
ORDER BY i2.[residue_number];