Skip to content

Instantly share code, notes, and snippets.

@edraizen

edraizen/IBIS_CDD.sql

Last active June 8, 2018 22:11
Show Gist options
  • Save edraizen/03b8ed4ac630e9f24e8699bcd6cdd51e to your computer and use it in GitHub Desktop.
Save edraizen/03b8ed4ac630e9f24e8699bcd6cdd51e to your computer and use it in GitHub Desktop.
Download ZIP
Raw
IBIS_CDD.sql
SELECT
i.mol_sdi_id,
i.nbr_sdi_id,
i.nbr_score,
i.nbr_taxid,
i.nbr_superfam_id,
i.int_superfam_id,
i.nbr_obs_int_id,
i.face_seq as resn,
f.seqloc as resi
FROM
Intrac1.dbo.Inferred1 i,
Intrac1.dbo.InferredFace1 f
WHERE
i.inf_id = f.inf_id AND
i.nbr_superfam_id={cdd} AND
i.nbr_type=3 AND
i.is_nr=1
UNION ALL
SELECT
i.mol_sdi_id,
i.nbr_sdi_id,
i.nbr_score,
i.nbr_taxid,
i.nbr_superfam_id,
i.int_superfam_id,
i.nbr_obs_int_id,
i.face_seq as resn,
f.seqloc as resi
FROM
Intrac1.dbo.Inferred2 i,
Intrac1.dbo.InferredFace2 f
WHERE
i.inf_id = f.inf_id AND
i.nbr_superfam_id={cdd} AND
i.nbr_type=3 AND
i.is_nr=1
UNION ALL
SELECT
i.mol_sdi_id,
i.nbr_sdi_id,
i.nbr_score,
i.nbr_taxid,
i.nbr_superfam_id,
i.int_superfam_id,
i.nbr_obs_int_id,
i.face_seq as resn,
f.seqloc as resi
FROM
Intrac1.dbo.Inferred3 i,
Intrac1.dbo.InferredFace3 f
WHERE
i.inf_id = f.inf_id AND
i.nbr_superfam_id={cdd} AND
i.nbr_type=3 AND
i.is_nr=1
UNION ALL
SELECT
i.mol_sdi_id,
i.nbr_sdi_id,
i.nbr_score,
i.nbr_taxid,
i.nbr_superfam_id,
i.int_superfam_id,
i.nbr_obs_int_id,
i.face_seq as resn,
f.seqloc as resi
FROM
Intrac1.dbo.Inferred4 i,
Intrac1.dbo.InferredFace4 f
WHERE
i.inf_id = f.inf_id AND
i.nbr_superfam_id={cdd} AND
i.nbr_type=3 AND
i.is_nr=1
UNION ALL
SELECT
i.mol_sdi_id,
i.nbr_sdi_id,
i.nbr_score,
i.nbr_taxid,
i.nbr_superfam_id,
i.int_superfam_id,
i.nbr_obs_int_id,
i.face_seq as resn,
f.seqloc as resi
FROM
Intrac1.dbo.Inferred5 i,
Intrac1.dbo.InferredFace5 f
WHERE
i.inf_id = f.inf_id AND
i.nbr_superfam_id={cdd} AND
i.nbr_type=3 AND
i.is_nr=1
UNION ALL
SELECT
i.mol_sdi_id,
i.nbr_sdi_id,
i.nbr_score,
i.nbr_taxid,
i.nbr_superfam_id,
i.int_superfam_id,
i.nbr_obs_int_id,
i.face_seq as resn,
f.seqloc as resi
FROM
Intrac2.dbo.Inferred6 i,
Intrac2.dbo.InferredFace6 f
WHERE
i.inf_id = f.inf_id AND
i.nbr_superfam_id={cdd} AND
i.nbr_type=3 AND
i.is_nr=1
UNION ALL
SELECT
i.mol_sdi_id,
i.nbr_sdi_id,
i.nbr_score,
i.nbr_taxid,
i.nbr_superfam_id,
i.int_superfam_id,
i.nbr_obs_int_id,
i.face_seq as resn,
f.seqloc as resi
FROM
Intrac2.dbo.Inferred7 i,
Intrac2.dbo.InferredFace7 f
WHERE
i.inf_id = f.inf_id AND
i.nbr_superfam_id={cdd} AND
i.nbr_type=3 AND
i.is_nr=1
UNION ALL
SELECT
i.mol_sdi_id,
i.nbr_sdi_id,
i.nbr_score,
i.nbr_taxid,
i.nbr_superfam_id,
i.int_superfam_id,
i.nbr_obs_int_id,
i.face_seq as resn,
f.seqloc as resi
FROM
Intrac2.dbo.Inferred8 i,
Intrac2.dbo.InferredFace8 f
WHERE
i.inf_id = f.inf_id AND
i.nbr_superfam_id={cdd} AND
i.nbr_type=3 AND
i.is_nr=1
UNION ALL
SELECT
i.mol_sdi_id,
i.nbr_sdi_id,
i.nbr_score,
i.nbr_taxid,
i.nbr_superfam_id,
i.int_superfam_id,
i.nbr_obs_int_id,
i.face_seq as resn,
f.seqloc as resi
FROM
Intrac2.dbo.Inferred9 i,
Intrac2.dbo.InferredFace9 f
WHERE
i.inf_id = f.inf_id AND
i.nbr_superfam_id={cdd} AND
i.nbr_type=3 AND
i.is_nr=1
UNION ALL
SELECT
i.mol_sdi_id,
i.nbr_sdi_id,
i.nbr_score,
i.nbr_taxid,
i.nbr_superfam_id,
i.int_superfam_id,
i.nbr_obs_int_id,
i.face_seq as resn,
f.seqloc as resi
FROM
Intrac2.dbo.Inferred10 i,
Intrac2.dbo.InferredFace10 f
WHERE
i.inf_id = f.inf_id AND
i.nbr_superfam_id={cdd} AND
i.nbr_type=3 AND
i.is_nr=1
UNION ALL
SELECT
i.mol_sdi_id,
i.nbr_sdi_id,
i.nbr_score,
i.nbr_taxid,
i.nbr_superfam_id,
i.int_superfam_id,
i.nbr_obs_int_id,
i.face_seq as resn,
f.seqloc as resi
FROM
Intrac3.dbo.Inferred11 i,
Intrac3.dbo.InferredFace11 f
WHERE
i.inf_id = f.inf_id AND
i.nbr_superfam_id={cdd} AND
i.nbr_type=3 AND
i.is_nr=1
UNION ALL
SELECT
i.mol_sdi_id,
i.nbr_sdi_id,
i.nbr_score,
i.nbr_taxid,
i.nbr_superfam_id,
i.int_superfam_id,
i.nbr_obs_int_id,
i.face_seq as resn,
f.seqloc as resi
FROM
Intrac3.dbo.Inferred12 i,
Intrac3.dbo.InferredFace12 f
WHERE
i.inf_id = f.inf_id AND
i.nbr_superfam_id={cdd} AND
i.nbr_type=3 AND
i.is_nr=1
UNION ALL
SELECT
i.mol_sdi_id,
i.nbr_sdi_id,
i.nbr_score,
i.nbr_taxid,
i.nbr_superfam_id,
i.int_superfam_id,
i.nbr_obs_int_id,
i.face_seq as resn,
f.seqloc as resi
FROM
Intrac3.dbo.Inferred13 i,
Intrac3.dbo.InferredFace13 f
WHERE
i.inf_id = f.inf_id AND
i.nbr_superfam_id={cdd} AND
i.nbr_type=3 AND
i.is_nr=1
UNION ALL
SELECT
i.mol_sdi_id,
i.nbr_sdi_id,
i.nbr_score,
i.nbr_taxid,
i.nbr_superfam_id,
i.int_superfam_id,
i.nbr_obs_int_id,
i.face_seq as resn,
f.seqloc as resi
FROM
Intrac3.dbo.Inferred14 i,
Intrac3.dbo.InferredFace14 f
WHERE
i.inf_id = f.inf_id AND
i.nbr_superfam_id={cdd} AND
i.nbr_type=3 AND
i.is_nr=1
UNION ALL
SELECT
i.mol_sdi_id,
i.nbr_sdi_id,
i.nbr_score,
i.nbr_taxid,
i.nbr_superfam_id,
i.int_superfam_id,
i.nbr_obs_int_id,
i.face_seq as resn,
f.seqloc as resi
FROM
Intrac3.dbo.Inferred15 i,
Intrac3.dbo.InferredFace15 f
WHERE
i.inf_id = f.inf_id AND
i.nbr_superfam_id={cdd} AND
i.nbr_type=3 AND
i.is_nr=1
UNION ALL
SELECT
i.mol_sdi_id,
i.nbr_sdi_id,
i.nbr_score,
i.nbr_taxid,
i.nbr_superfam_id,
i.int_superfam_id,
i.nbr_obs_int_id,
i.face_seq as resn,
f.seqloc as resi
FROM
Intrac4.dbo.Inferred16 i,
Intrac4.dbo.InferredFace16 f
WHERE
i.inf_id = f.inf_id AND
i.nbr_superfam_id={cdd} AND
i.nbr_type=3 AND
i.is_nr=1
UNION ALL
SELECT
i.mol_sdi_id,
i.nbr_sdi_id,
i.nbr_score,
i.nbr_taxid,
i.nbr_superfam_id,
i.int_superfam_id,
i.nbr_obs_int_id,
i.face_seq as resn,
f.seqloc as resi
FROM
Intrac4.dbo.Inferred17 i,
Intrac4.dbo.InferredFace17 f
WHERE
i.inf_id = f.inf_id AND
i.nbr_superfam_id={cdd} AND
i.nbr_type=3 AND
i.is_nr=1
UNION ALL
SELECT
i.mol_sdi_id,
i.nbr_sdi_id,
i.nbr_score,
i.nbr_taxid,
i.nbr_superfam_id,
i.int_superfam_id,
i.nbr_obs_int_id,
i.face_seq as resn,
f.seqloc as resi
FROM
Intrac4.dbo.Inferred18 i,
Intrac4.dbo.InferredFace18 f
WHERE
i.inf_id = f.inf_id AND
i.nbr_superfam_id={cdd} AND
i.nbr_type=3 AND
i.is_nr=1
UNION ALL
SELECT
i.mol_sdi_id,
i.nbr_sdi_id,
i.nbr_score,
i.nbr_taxid,
i.nbr_superfam_id,
i.int_superfam_id,
i.nbr_obs_int_id,
i.face_seq as resn,
f.seqloc as resi
FROM
Intrac4.dbo.Inferred19 i,
Intrac4.dbo.InferredFace19 f
WHERE
i.inf_id = f.inf_id AND
i.nbr_superfam_id={cdd} AND
i.nbr_type=3 AND
i.is_nr=1
UNION ALL
SELECT
i.mol_sdi_id,
i.nbr_sdi_id,
i.nbr_score,
i.nbr_taxid,
i.nbr_superfam_id,
i.int_superfam_id,
i.nbr_obs_int_id,
i.face_seq as resn,
f.seqloc as resi
FROM
Intrac4.dbo.Inferred20 i,
Intrac4.dbo.InferredFace20 f
WHERE
i.inf_id = f.inf_id AND
i.nbr_superfam_id={cdd} AND
i.nbr_type=3 AND
i.is_nr=1
UNION ALL
SELECT
i.mol_sdi_id,
i.nbr_sdi_id,
i.nbr_score,
i.nbr_taxid,
i.nbr_superfam_id,
i.int_superfam_id,
i.nbr_obs_int_id,
i.face_seq as resn,
f.seqloc as resi
FROM
Intrac5.dbo.Inferred21 i,
Intrac5.dbo.InferredFace21 f
WHERE
i.inf_id = f.inf_id AND
i.nbr_superfam_id={cdd} AND
i.nbr_type=3 AND
i.is_nr=1
UNION ALL
SELECT
i.mol_sdi_id,
i.nbr_sdi_id,
i.nbr_score,
i.nbr_taxid,
i.nbr_superfam_id,
i.int_superfam_id,
i.nbr_obs_int_id,
i.face_seq as resn,
f.seqloc as resi
FROM
Intrac5.dbo.Inferred22 i,
Intrac5.dbo.InferredFace22 f
WHERE
i.inf_id = f.inf_id AND
i.nbr_superfam_id={cdd} AND
i.nbr_type=3 AND
i.is_nr=1
UNION ALL
SELECT
i.mol_sdi_id,
i.nbr_sdi_id,
i.nbr_score,
i.nbr_taxid,
i.nbr_superfam_id,
i.int_superfam_id,
i.nbr_obs_int_id,
i.face_seq as resn,
f.seqloc as resi
FROM
Intrac5.dbo.Inferred23 i,
Intrac5.dbo.InferredFace23 f
WHERE
i.inf_id = f.inf_id AND
i.nbr_superfam_id={cdd} AND
i.nbr_type=3 AND
i.is_nr=1
UNION ALL
SELECT
i.mol_sdi_id,
i.nbr_sdi_id,
i.nbr_score,
i.nbr_taxid,
i.nbr_superfam_id,
i.int_superfam_id,
i.nbr_obs_int_id,
i.face_seq as resn,
f.seqloc as resi
FROM
Intrac5.dbo.Inferred24 i,
Intrac5.dbo.InferredFace24 f
WHERE
i.inf_id = f.inf_id AND
i.nbr_superfam_id={cdd} AND
i.nbr_type=3 AND
i.is_nr=1
UNION ALL
SELECT
i.mol_sdi_id,
i.nbr_sdi_id,
i.nbr_score,
i.nbr_taxid,
i.nbr_superfam_id,
i.int_superfam_id,
i.nbr_obs_int_id,
i.face_seq as resn,
f.seqloc as resi
FROM
Intrac5.dbo.Inferred25 i,
Intrac5.dbo.InferredFace25 f
WHERE
i.inf_id = f.inf_id AND
i.nbr_superfam_id={cdd} AND
i.nbr_type=3 AND
i.is_nr=1
UNION ALL
SELECT
i.mol_sdi_id,
i.nbr_sdi_id,
i.nbr_score,
i.nbr_taxid,
i.nbr_superfam_id,
i.int_superfam_id,
i.nbr_obs_int_id,
i.face_seq as resn,
f.seqloc as resi
FROM
Intrac6.dbo.Inferred26 i,
Intrac6.dbo.InferredFace26 f
WHERE
i.inf_id = f.inf_id AND
i.nbr_superfam_id={cdd} AND
i.nbr_type=3 AND
i.is_nr=1
UNION ALL
SELECT
i.mol_sdi_id,
i.nbr_sdi_id,
i.nbr_score,
i.nbr_taxid,
i.nbr_superfam_id,
i.int_superfam_id,
i.nbr_obs_int_id,
i.face_seq as resn,
f.seqloc as resi
FROM
Intrac6.dbo.Inferred27 i,
Intrac6.dbo.InferredFace27 f
WHERE
i.inf_id = f.inf_id AND
i.nbr_superfam_id={cdd} AND
i.nbr_type=3 AND
i.is_nr=1
UNION ALL
SELECT
i.mol_sdi_id,
i.nbr_sdi_id,
i.nbr_score,
i.nbr_taxid,
i.nbr_superfam_id,
i.int_superfam_id,
i.nbr_obs_int_id,
i.face_seq as resn,
f.seqloc as resi
FROM
Intrac6.dbo.Inferred28 i,
Intrac6.dbo.InferredFace28 f
WHERE
i.inf_id = f.inf_id AND
i.nbr_superfam_id={cdd} AND
i.nbr_type=3 AND
i.is_nr=1
UNION ALL
SELECT
i.mol_sdi_id,
i.nbr_sdi_id,
i.nbr_score,
i.nbr_taxid,
i.nbr_superfam_id,
i.int_superfam_id,
i.nbr_obs_int_id,
i.face_seq as resn,
f.seqloc as resi
FROM
Intrac6.dbo.Inferred29 i,
Intrac6.dbo.InferredFace29 f
WHERE
i.inf_id = f.inf_id AND
i.nbr_superfam_id={cdd} AND
i.nbr_type=3 AND
i.is_nr=1
UNION ALL
SELECT
i.mol_sdi_id,
i.nbr_sdi_id,
i.nbr_score,
i.nbr_taxid,
i.nbr_superfam_id,
i.int_superfam_id,
i.nbr_obs_int_id,
i.face_seq as resn,
f.seqloc as resi
FROM
Intrac6.dbo.Inferred30 i,
Intrac6.dbo.InferredFace30 f
WHERE
i.inf_id = f.inf_id AND
i.nbr_superfam_id={cdd} AND
i.nbr_type=3 AND
i.is_nr=1
UNION ALL
SELECT
i.mol_sdi_id,
i.nbr_sdi_id,
i.nbr_score,
i.nbr_taxid,
i.nbr_superfam_id,
i.int_superfam_id,
i.nbr_obs_int_id,
i.face_seq as resn,
f.seqloc as resi
FROM
Intrac7.dbo.Inferred31 i,
Intrac7.dbo.InferredFace31 f
WHERE
i.inf_id = f.inf_id AND
i.nbr_superfam_id={cdd} AND
i.nbr_type=3 AND
i.is_nr=1
UNION ALL
SELECT
i.mol_sdi_id,
i.nbr_sdi_id,
i.nbr_score,
i.nbr_taxid,
i.nbr_superfam_id,
i.int_superfam_id,
i.nbr_obs_int_id,
i.face_seq as resn,
f.seqloc as resi
FROM
Intrac7.dbo.Inferred32 i,
Intrac7.dbo.InferredFace32 f
WHERE
i.inf_id = f.inf_id AND
i.nbr_superfam_id={cdd} AND
i.nbr_type=3 AND
i.is_nr=1
UNION ALL
SELECT
i.mol_sdi_id,
i.nbr_sdi_id,
i.nbr_score,
i.nbr_taxid,
i.nbr_superfam_id,
i.int_superfam_id,
i.nbr_obs_int_id,
i.face_seq as resn,
f.seqloc as resi
FROM
Intrac7.dbo.Inferred33 i,
Intrac7.dbo.InferredFace33 f
WHERE
i.inf_id = f.inf_id AND
i.nbr_superfam_id={cdd} AND
i.nbr_type=3 AND
i.is_nr=1
UNION ALL
SELECT
i.mol_sdi_id,
i.nbr_sdi_id,
i.nbr_score,
i.nbr_taxid,
i.nbr_superfam_id,
i.int_superfam_id,
i.nbr_obs_int_id,
i.face_seq as resn,
f.seqloc as resi
FROM
Intrac7.dbo.Inferred34 i,
Intrac7.dbo.InferredFace34 f
WHERE
i.inf_id = f.inf_id AND
i.nbr_superfam_id={cdd} AND
i.nbr_type=3 AND
i.is_nr=1
UNION ALL
SELECT
i.mol_sdi_id,
i.nbr_sdi_id,
i.nbr_score,
i.nbr_taxid,
i.nbr_superfam_id,
i.int_superfam_id,
i.nbr_obs_int_id,
i.face_seq as resn,
f.seqloc as resi
FROM
Intrac7.dbo.Inferred35 i,
Intrac7.dbo.InferredFace35 f
WHERE
i.inf_id = f.inf_id AND
i.nbr_superfam_id={cdd} AND
i.nbr_type=3 AND
i.is_nr=1
UNION ALL
SELECT
i.mol_sdi_id,
i.nbr_sdi_id,
i.nbr_score,
i.nbr_taxid,
i.nbr_superfam_id,
i.int_superfam_id,
i.nbr_obs_int_id,
i.face_seq as resn,
f.seqloc as resi
FROM
Intrac8.dbo.Inferred36 i,
Intrac8.dbo.InferredFace36 f
WHERE
i.inf_id = f.inf_id AND
i.nbr_superfam_id={cdd} AND
i.nbr_type=3 AND
i.is_nr=1
UNION ALL
SELECT
i.mol_sdi_id,
i.nbr_sdi_id,
i.nbr_score,
i.nbr_taxid,
i.nbr_superfam_id,
i.int_superfam_id,
i.nbr_obs_int_id,
i.face_seq as resn,
f.seqloc as resi
FROM
Intrac8.dbo.Inferred37 i,
Intrac8.dbo.InferredFace37 f
WHERE
i.inf_id = f.inf_id AND
i.nbr_superfam_id={cdd} AND
i.nbr_type=3 AND
i.is_nr=1
UNION ALL
SELECT
i.mol_sdi_id,
i.nbr_sdi_id,
i.nbr_score,
i.nbr_taxid,
i.nbr_superfam_id,
i.int_superfam_id,
i.nbr_obs_int_id,
i.face_seq as resn,
f.seqloc as resi
FROM
Intrac8.dbo.Inferred38 i,
Intrac8.dbo.InferredFace38 f
WHERE
i.inf_id = f.inf_id AND
i.nbr_superfam_id={cdd} AND
i.nbr_type=3 AND
i.is_nr=1
UNION ALL
SELECT
i.mol_sdi_id,
i.nbr_sdi_id,
i.nbr_score,
i.nbr_taxid,
i.nbr_superfam_id,
i.int_superfam_id,
i.nbr_obs_int_id,
i.face_seq as resn,
f.seqloc as resi
FROM
Intrac8.dbo.Inferred39 i,
Intrac8.dbo.InferredFace39 f
WHERE
i.inf_id = f.inf_id AND
i.nbr_superfam_id={cdd} AND
i.nbr_type=3 AND
i.is_nr=1
UNION ALL
SELECT
i.mol_sdi_id,
i.nbr_sdi_id,
i.nbr_score,
i.nbr_taxid,
i.nbr_superfam_id,
i.int_superfam_id,
i.nbr_obs_int_id,
i.face_seq as resn,
f.seqloc as resi
FROM
Intrac8.dbo.Inferred40 i,
Intrac8.dbo.InferredFace40 f
WHERE
i.inf_id = f.inf_id AND
i.nbr_superfam_id={cdd} AND
i.nbr_type=3 AND
i.is_nr=1
UNION ALL
SELECT
i.mol_sdi_id,
i.nbr_sdi_id,
i.nbr_score,
i.nbr_taxid,
i.nbr_superfam_id,
i.int_superfam_id,
i.nbr_obs_int_id,
i.face_seq as resn,
f.seqloc as resi
FROM
Intrac9.dbo.Inferred41 i,
Intrac9.dbo.InferredFace41 f
WHERE
i.inf_id = f.inf_id AND
i.nbr_superfam_id={cdd} AND
i.nbr_type=3 AND
i.is_nr=1
UNION ALL
SELECT
i.mol_sdi_id,
i.nbr_sdi_id,
i.nbr_score,
i.nbr_taxid,
i.nbr_superfam_id,
i.int_superfam_id,
i.nbr_obs_int_id,
i.face_seq as resn,
f.seqloc as resi
FROM
Intrac9.dbo.Inferred42 i,
Intrac9.dbo.InferredFace42 f
WHERE
i.inf_id = f.inf_id AND
i.nbr_superfam_id={cdd} AND
i.nbr_type=3 AND
i.is_nr=1
UNION ALL
SELECT
i.mol_sdi_id,
i.nbr_sdi_id,
i.nbr_score,
i.nbr_taxid,
i.nbr_superfam_id,
i.int_superfam_id,
i.nbr_obs_int_id,
i.face_seq as resn,
f.seqloc as resi
FROM
Intrac9.dbo.Inferred43 i,
Intrac9.dbo.InferredFace43 f
WHERE
i.inf_id = f.inf_id AND
i.nbr_superfam_id={cdd} AND
i.nbr_type=3 AND
i.is_nr=1
UNION ALL
SELECT
i.mol_sdi_id,
i.nbr_sdi_id,
i.nbr_score,
i.nbr_taxid,
i.nbr_superfam_id,
i.int_superfam_id,
i.nbr_obs_int_id,
i.face_seq as resn,
f.seqloc as resi
FROM
Intrac9.dbo.Inferred44 i,
Intrac9.dbo.InferredFace44 f
WHERE
i.inf_id = f.inf_id AND
i.nbr_superfam_id={cdd} AND
i.nbr_type=3 AND
i.is_nr=1
UNION ALL
SELECT
i.mol_sdi_id,
i.nbr_sdi_id,
i.nbr_score,
i.nbr_taxid,
i.nbr_superfam_id,
i.int_superfam_id,
i.nbr_obs_int_id,
i.face_seq as resn,
f.seqloc as resi
FROM
Intrac9.dbo.Inferred45 i,
Intrac9.dbo.InferredFace45 f
WHERE
i.inf_id = f.inf_id AND
i.nbr_superfam_id={cdd} AND
i.nbr_type=3 AND
i.is_nr=1
UNION ALL
SELECT
i.mol_sdi_id,
i.nbr_sdi_id,
i.nbr_score,
i.nbr_taxid,
i.nbr_superfam_id,
i.int_superfam_id,
i.nbr_obs_int_id,
i.face_seq as resn,
f.seqloc as resi
FROM
Intrac10.dbo.Inferred46 i,
Intrac10.dbo.InferredFace46 f
WHERE
i.inf_id = f.inf_id AND
i.nbr_superfam_id={cdd} AND
i.nbr_type=3 AND
i.is_nr=1
UNION ALL
SELECT
i.mol_sdi_id,
i.nbr_sdi_id,
i.nbr_score,
i.nbr_taxid,
i.nbr_superfam_id,
i.int_superfam_id,
i.nbr_obs_int_id,
i.face_seq as resn,
f.seqloc as resi
FROM
Intrac10.dbo.Inferred47 i,
Intrac10.dbo.InferredFace47 f
WHERE
i.inf_id = f.inf_id AND
i.nbr_superfam_id={cdd} AND
i.nbr_type=3 AND
i.is_nr=1
UNION ALL
SELECT
i.mol_sdi_id,
i.nbr_sdi_id,
i.nbr_score,
i.nbr_taxid,
i.nbr_superfam_id,
i.int_superfam_id,
i.nbr_obs_int_id,
i.face_seq as resn,
f.seqloc as resi
FROM
Intrac10.dbo.Inferred48 i,
Intrac10.dbo.InferredFace48 f
WHERE
i.inf_id = f.inf_id AND
i.nbr_superfam_id={cdd} AND
i.nbr_type=3 AND
i.is_nr=1
UNION ALL
SELECT
i.mol_sdi_id,
i.nbr_sdi_id,
i.nbr_score,
i.nbr_taxid,
i.nbr_superfam_id,
i.int_superfam_id,
i.nbr_obs_int_id,
i.face_seq as resn,
f.seqloc as resi
FROM
Intrac10.dbo.Inferred49 i,
Intrac10.dbo.InferredFace49 f
WHERE
i.inf_id = f.inf_id AND
i.nbr_superfam_id={cdd} AND
i.nbr_type=3 AND
i.is_nr=1
UNION ALL
SELECT
i.mol_sdi_id,
i.nbr_sdi_id,
i.nbr_score,
i.nbr_taxid,
i.nbr_superfam_id,
i.int_superfam_id,
i.nbr_obs_int_id,
i.face_seq as resn,
f.seqloc as resi
FROM
Intrac10.dbo.Inferred50 i,
Intrac10.dbo.InferredFace50 f
WHERE
i.inf_id = f.inf_id AND
i.nbr_superfam_id={cdd} AND
i.nbr_type=3 AND
i.is_nr=1
UNION ALL
SELECT
i.mol_sdi_id,
i.nbr_sdi_id,
i.nbr_score,
i.nbr_taxid,
i.nbr_superfam_id,
i.int_superfam_id,
i.nbr_obs_int_id,
i.face_seq as resn,
f.seqloc as resi
FROM
Intrac11.dbo.Inferred51 i,
Intrac11.dbo.InferredFace51 f
WHERE
i.inf_id = f.inf_id AND
i.nbr_superfam_id={cdd} AND
i.nbr_type=3 AND
i.is_nr=1
UNION ALL
SELECT
i.mol_sdi_id,
i.nbr_sdi_id,
i.nbr_score,
i.nbr_taxid,
i.nbr_superfam_id,
i.int_superfam_id,
i.nbr_obs_int_id,
i.face_seq as resn,
f.seqloc as resi
FROM
Intrac11.dbo.Inferred52 i,
Intrac11.dbo.InferredFace52 f
WHERE
i.inf_id = f.inf_id AND
i.nbr_superfam_id={cdd} AND
i.nbr_type=3 AND
i.is_nr=1
UNION ALL
SELECT
i.mol_sdi_id,
i.nbr_sdi_id,
i.nbr_score,
i.nbr_taxid,
i.nbr_superfam_id,
i.int_superfam_id,
i.nbr_obs_int_id,
i.face_seq as resn,
f.seqloc as resi
FROM
Intrac11.dbo.Inferred53 i,
Intrac11.dbo.InferredFace53 f
WHERE
i.inf_id = f.inf_id AND
i.nbr_superfam_id={cdd} AND
i.nbr_type=3 AND
i.is_nr=1
UNION ALL
SELECT
i.mol_sdi_id,
i.nbr_sdi_id,
i.nbr_score,
i.nbr_taxid,
i.nbr_superfam_id,
i.int_superfam_id,
i.nbr_obs_int_id,
i.face_seq as resn,
f.seqloc as resi
FROM
Intrac11.dbo.Inferred54 i,
Intrac11.dbo.InferredFace54 f
WHERE
i.inf_id = f.inf_id AND
i.nbr_superfam_id={cdd} AND
i.nbr_type=3 AND
i.is_nr=1
UNION ALL
SELECT
i.mol_sdi_id,
i.nbr_sdi_id,
i.nbr_score,
i.nbr_taxid,
i.nbr_superfam_id,
i.int_superfam_id,
i.nbr_obs_int_id,
i.face_seq as resn,
f.seqloc as resi
FROM
Intrac11.dbo.Inferred55 i,
Intrac11.dbo.InferredFace55 f
WHERE
i.inf_id = f.inf_id AND
i.nbr_superfam_id={cdd} AND
i.nbr_type=3 AND
i.is_nr=1
UNION ALL
SELECT
i.mol_sdi_id,
i.nbr_sdi_id,
i.nbr_score,
i.nbr_taxid,
i.nbr_superfam_id,
i.int_superfam_id,
i.nbr_obs_int_id,
i.face_seq as resn,
f.seqloc as resi
FROM
Intrac12.dbo.Inferred56 i,
Intrac12.dbo.InferredFace56 f
WHERE
i.inf_id = f.inf_id AND
i.nbr_superfam_id={cdd} AND
i.nbr_type=3 AND
i.is_nr=1
UNION ALL
SELECT
i.mol_sdi_id,
i.nbr_sdi_id,
i.nbr_score,
i.nbr_taxid,
i.nbr_superfam_id,
i.int_superfam_id,
i.nbr_obs_int_id,
i.face_seq as resn,
f.seqloc as resi
FROM
Intrac12.dbo.Inferred57 i,
Intrac12.dbo.InferredFace57 f
WHERE
i.inf_id = f.inf_id AND
i.nbr_superfam_id={cdd} AND
i.nbr_type=3 AND
i.is_nr=1
UNION ALL
SELECT
i.mol_sdi_id,
i.nbr_sdi_id,
i.nbr_score,
i.nbr_taxid,
i.nbr_superfam_id,
i.int_superfam_id,
i.nbr_obs_int_id,
i.face_seq as resn,
f.seqloc as resi
FROM
Intrac12.dbo.Inferred58 i,
Intrac12.dbo.InferredFace58 f
WHERE
i.inf_id = f.inf_id AND
i.nbr_superfam_id={cdd} AND
i.nbr_type=3 AND
i.is_nr=1
UNION ALL
SELECT
i.mol_sdi_id,
i.nbr_sdi_id,
i.nbr_score,
i.nbr_taxid,
i.nbr_superfam_id,
i.int_superfam_id,
i.nbr_obs_int_id,
i.face_seq as resn,
f.seqloc as resi
FROM
Intrac12.dbo.Inferred59 i,
Intrac12.dbo.InferredFace59 f
WHERE
i.inf_id = f.inf_id AND
i.nbr_superfam_id={cdd} AND
i.nbr_type=3 AND
i.is_nr=1
UNION ALL
SELECT
i.mol_sdi_id,
i.nbr_sdi_id,
i.nbr_score,
i.nbr_taxid,
i.nbr_superfam_id,
i.int_superfam_id,
i.nbr_obs_int_id,
i.face_seq as resn,
f.seqloc as resi
FROM
Intrac12.dbo.Inferred60 i,
Intrac12.dbo.InferredFace60 f
WHERE
i.inf_id = f.inf_id AND
i.nbr_superfam_id={cdd} AND
i.nbr_type=3 AND
i.is_nr=1
UNION ALL
SELECT
i.mol_sdi_id,
i.nbr_sdi_id,
i.nbr_score,
i.nbr_taxid,
i.nbr_superfam_id,
i.int_superfam_id,
i.nbr_obs_int_id,
i.face_seq as resn,
f.seqloc as resi
FROM
Intrac13.dbo.Inferred61 i,
Intrac13.dbo.InferredFace61 f
WHERE
i.inf_id = f.inf_id AND
i.nbr_superfam_id={cdd} AND
i.nbr_type=3 AND
i.is_nr=1
UNION ALL
SELECT
i.mol_sdi_id,
i.nbr_sdi_id,
i.nbr_score,
i.nbr_taxid,
i.nbr_superfam_id,
i.int_superfam_id,
i.nbr_obs_int_id,
i.face_seq as resn,
f.seqloc as resi
FROM
Intrac13.dbo.Inferred62 i,
Intrac13.dbo.InferredFace62 f
WHERE
i.inf_id = f.inf_id AND
i.nbr_superfam_id={cdd} AND
i.nbr_type=3 AND
i.is_nr=1
UNION ALL
SELECT
i.mol_sdi_id,
i.nbr_sdi_id,
i.nbr_score,
i.nbr_taxid,
i.nbr_superfam_id,
i.int_superfam_id,
i.nbr_obs_int_id,
i.face_seq as resn,
f.seqloc as resi
FROM
Intrac13.dbo.Inferred63 i,
Intrac13.dbo.InferredFace63 f
WHERE
i.inf_id = f.inf_id AND
i.nbr_superfam_id={cdd} AND
i.nbr_type=3 AND
i.is_nr=1
UNION ALL
SELECT
i.mol_sdi_id,
i.nbr_sdi_id,
i.nbr_score,
i.nbr_taxid,
i.nbr_superfam_id,
i.int_superfam_id,
i.nbr_obs_int_id,
i.face_seq as resn,
f.seqloc as resi
FROM
Intrac13.dbo.Inferred64 i,
Intrac13.dbo.InferredFace64 f
WHERE
i.inf_id = f.inf_id AND
i.nbr_superfam_id={cdd} AND
i.nbr_type=3 AND
i.is_nr=1
UNION ALL
SELECT
i.mol_sdi_id,
i.nbr_sdi_id,
i.nbr_score,
i.nbr_taxid,
i.nbr_superfam_id,
i.int_superfam_id,
i.nbr_obs_int_id,
i.face_seq as resn,
f.seqloc as resi
FROM
Intrac13.dbo.Inferred65 i,
Intrac13.dbo.InferredFace65 f
WHERE
i.inf_id = f.inf_id AND
i.nbr_superfam_id={cdd} AND
i.nbr_type=3 AND
i.is_nr=1
UNION ALL
SELECT
i.mol_sdi_id,
i.nbr_sdi_id,
i.nbr_score,
i.nbr_taxid,
i.nbr_superfam_id,
i.int_superfam_id,
i.nbr_obs_int_id,
i.face_seq as resn,
f.seqloc as resi
FROM
Intrac14.dbo.Inferred66 i,
Intrac14.dbo.InferredFace66 f
WHERE
i.inf_id = f.inf_id AND
i.nbr_superfam_id={cdd} AND
i.nbr_type=3 AND
i.is_nr=1
UNION ALL
SELECT
i.mol_sdi_id,
i.nbr_sdi_id,
i.nbr_score,
i.nbr_taxid,
i.nbr_superfam_id,
i.int_superfam_id,
i.nbr_obs_int_id,
i.face_seq as resn,
f.seqloc as resi
FROM
Intrac14.dbo.Inferred67 i,
Intrac14.dbo.InferredFace67 f
WHERE
i.inf_id = f.inf_id AND
i.nbr_superfam_id={cdd} AND
i.nbr_type=3 AND
i.is_nr=1
UNION ALL
SELECT
i.mol_sdi_id,
i.nbr_sdi_id,
i.nbr_score,
i.nbr_taxid,
i.nbr_superfam_id,
i.int_superfam_id,
i.nbr_obs_int_id,
i.face_seq as resn,
f.seqloc as resi
FROM
Intrac14.dbo.Inferred68 i,
Intrac14.dbo.InferredFace68 f
WHERE
i.inf_id = f.inf_id AND
i.nbr_superfam_id={cdd} AND
i.nbr_type=3 AND
i.is_nr=1
UNION ALL
SELECT
i.mol_sdi_id,
i.nbr_sdi_id,
i.nbr_score,
i.nbr_taxid,
i.nbr_superfam_id,
i.int_superfam_id,
i.nbr_obs_int_id,
i.face_seq as resn,
f.seqloc as resi
FROM
Intrac14.dbo.Inferred69 i,
Intrac14.dbo.InferredFace69 f
WHERE
i.inf_id = f.inf_id AND
i.nbr_superfam_id={cdd} AND
i.nbr_type=3 AND
i.is_nr=1
UNION ALL
SELECT
i.mol_sdi_id,
i.nbr_sdi_id,
i.nbr_score,
i.nbr_taxid,
i.nbr_superfam_id,
i.int_superfam_id,
i.nbr_obs_int_id,
i.face_seq as resn,
f.seqloc as resi
FROM
Intrac14.dbo.Inferred70 i,
Intrac14.dbo.InferredFace70 f
WHERE
i.inf_id = f.inf_id AND
i.nbr_superfam_id={cdd} AND
i.nbr_type=3 AND
i.is_nr=1
UNION ALL
SELECT
i.mol_sdi_id,
i.nbr_sdi_id,
i.nbr_score,
i.nbr_taxid,
i.nbr_superfam_id,
i.int_superfam_id,
i.nbr_obs_int_id,
i.face_seq as resn,
f.seqloc as resi
FROM
Intrac15.dbo.Inferred71 i,
Intrac15.dbo.InferredFace71 f
WHERE
i.inf_id = f.inf_id AND
i.nbr_superfam_id={cdd} AND
i.nbr_type=3 AND
i.is_nr=1
UNION ALL
SELECT
i.mol_sdi_id,
i.nbr_sdi_id,
i.nbr_score,
i.nbr_taxid,
i.nbr_superfam_id,
i.int_superfam_id,
i.nbr_obs_int_id,
i.face_seq as resn,
f.seqloc as resi
FROM
Intrac15.dbo.Inferred72 i,
Intrac15.dbo.InferredFace72 f
WHERE
i.inf_id = f.inf_id AND
i.nbr_superfam_id={cdd} AND
i.nbr_type=3 AND
i.is_nr=1
UNION ALL
SELECT
i.mol_sdi_id,
i.nbr_sdi_id,
i.nbr_score,
i.nbr_taxid,
i.nbr_superfam_id,
i.int_superfam_id,
i.nbr_obs_int_id,
i.face_seq as resn,
f.seqloc as resi
FROM
Intrac15.dbo.Inferred73 i,
Intrac15.dbo.InferredFace73 f
WHERE
i.inf_id = f.inf_id AND
i.nbr_superfam_id={cdd} AND
i.nbr_type=3 AND
i.is_nr=1
UNION ALL
SELECT
i.mol_sdi_id,
i.nbr_sdi_id,
i.nbr_score,
i.nbr_taxid,
i.nbr_superfam_id,
i.int_superfam_id,
i.nbr_obs_int_id,
i.face_seq as resn,
f.seqloc as resi
FROM
Intrac15.dbo.Inferred74 i,
Intrac15.dbo.InferredFace74 f
WHERE
i.inf_id = f.inf_id AND
i.nbr_superfam_id={cdd} AND
i.nbr_type=3 AND
i.is_nr=1
UNION ALL
SELECT
i.mol_sdi_id,
i.nbr_sdi_id,
i.nbr_score,
i.nbr_taxid,
i.nbr_superfam_id,
i.int_superfam_id,
i.nbr_obs_int_id,
i.face_seq as resn,
f.seqloc as resi
FROM
Intrac15.dbo.Inferred75 i,
Intrac15.dbo.InferredFace75 f
WHERE
i.inf_id = f.inf_id AND
i.nbr_superfam_id={cdd} AND
i.nbr_type=3 AND
i.is_nr=1
UNION ALL
SELECT
i.mol_sdi_id,
i.nbr_sdi_id,
i.nbr_score,
i.nbr_taxid,
i.nbr_superfam_id,
i.int_superfam_id,
i.nbr_obs_int_id,
i.face_seq as resn,
f.seqloc as resi
FROM
Intrac16.dbo.Inferred76 i,
Intrac16.dbo.InferredFace76 f
WHERE
i.inf_id = f.inf_id AND
i.nbr_superfam_id={cdd} AND
i.nbr_type=3 AND
i.is_nr=1
UNION ALL
SELECT
i.mol_sdi_id,
i.nbr_sdi_id,
i.nbr_score,
i.nbr_taxid,
i.nbr_superfam_id,
i.int_superfam_id,
i.nbr_obs_int_id,
i.face_seq as resn,
f.seqloc as resi
FROM
Intrac16.dbo.Inferred77 i,
Intrac16.dbo.InferredFace77 f
WHERE
i.inf_id = f.inf_id AND
i.nbr_superfam_id={cdd} AND
i.nbr_type=3 AND
i.is_nr=1
UNION ALL
SELECT
i.mol_sdi_id,
i.nbr_sdi_id,
i.nbr_score,
i.nbr_taxid,
i.nbr_superfam_id,
i.int_superfam_id,
i.nbr_obs_int_id,
i.face_seq as resn,
f.seqloc as resi
FROM
Intrac16.dbo.Inferred78 i,
Intrac16.dbo.InferredFace78 f
WHERE
i.inf_id = f.inf_id AND
i.nbr_superfam_id={cdd} AND
i.nbr_type=3 AND
i.is_nr=1
UNION ALL
SELECT
i.mol_sdi_id,
i.nbr_sdi_id,
i.nbr_score,
i.nbr_taxid,
i.nbr_superfam_id,
i.int_superfam_id,
i.nbr_obs_int_id,
i.face_seq as resn,
f.seqloc as resi
FROM
Intrac16.dbo.Inferred79 i,
Intrac16.dbo.InferredFace79 f
WHERE
i.inf_id = f.inf_id AND
i.nbr_superfam_id={cdd} AND
i.nbr_type=3 AND
i.is_nr=1
UNION ALL
SELECT
i.mol_sdi_id,
i.nbr_sdi_id,
i.nbr_score,
i.nbr_taxid,
i.nbr_superfam_id,
i.int_superfam_id,
i.nbr_obs_int_id,
i.face_seq as resn,
f.seqloc as resi
FROM
Intrac16.dbo.Inferred80 i,
Intrac16.dbo.InferredFace80 f
WHERE
i.inf_id = f.inf_id AND
i.nbr_superfam_id={cdd} AND
i.nbr_type=3 AND
i.is_nr=1
UNION ALL
SELECT
i.mol_sdi_id,
i.nbr_sdi_id,
i.nbr_score,
i.nbr_taxid,
i.nbr_superfam_id,
i.int_superfam_id,
i.nbr_obs_int_id,
i.face_seq as resn,
f.seqloc as resi
FROM
Intrac17.dbo.Inferred81 i,
Intrac17.dbo.InferredFace81 f
WHERE
i.inf_id = f.inf_id AND
i.nbr_superfam_id={cdd} AND
i.nbr_type=3 AND
i.is_nr=1
UNION ALL
SELECT
i.mol_sdi_id,
i.nbr_sdi_id,
i.nbr_score,
i.nbr_taxid,
i.nbr_superfam_id,
i.int_superfam_id,
i.nbr_obs_int_id,
i.face_seq as resn,
f.seqloc as resi
FROM
Intrac17.dbo.Inferred82 i,
Intrac17.dbo.InferredFace82 f
WHERE
i.inf_id = f.inf_id AND
i.nbr_superfam_id={cdd} AND
i.nbr_type=3 AND
i.is_nr=1
UNION ALL
SELECT
i.mol_sdi_id,
i.nbr_sdi_id,
i.nbr_score,
i.nbr_taxid,
i.nbr_superfam_id,
i.int_superfam_id,
i.nbr_obs_int_id,
i.face_seq as resn,
f.seqloc as resi
FROM
Intrac17.dbo.Inferred83 i,
Intrac17.dbo.InferredFace83 f
WHERE
i.inf_id = f.inf_id AND
i.nbr_superfam_id={cdd} AND
i.nbr_type=3 AND
i.is_nr=1
UNION ALL
SELECT
i.mol_sdi_id,
i.nbr_sdi_id,
i.nbr_score,
i.nbr_taxid,
i.nbr_superfam_id,
i.int_superfam_id,
i.nbr_obs_int_id,
i.face_seq as resn,
f.seqloc as resi
FROM
Intrac17.dbo.Inferred84 i,
Intrac17.dbo.InferredFace84 f
WHERE
i.inf_id = f.inf_id AND
i.nbr_superfam_id={cdd} AND
i.nbr_type=3 AND
i.is_nr=1
UNION ALL
SELECT
i.mol_sdi_id,
i.nbr_sdi_id,
i.nbr_score,
i.nbr_taxid,
i.nbr_superfam_id,
i.int_superfam_id,
i.nbr_obs_int_id,
i.face_seq as resn,
f.seqloc as resi
FROM
Intrac17.dbo.Inferred85 i,
Intrac17.dbo.InferredFace85 f
WHERE
i.inf_id = f.inf_id AND
i.nbr_superfam_id={cdd} AND
i.nbr_type=3 AND
i.is_nr=1
UNION ALL
SELECT
i.mol_sdi_id,
i.nbr_sdi_id,
i.nbr_score,
i.nbr_taxid,
i.nbr_superfam_id,
i.int_superfam_id,
i.nbr_obs_int_id,
i.face_seq as resn,
f.seqloc as resi
FROM
Intrac18.dbo.Inferred86 i,
Intrac18.dbo.InferredFace86 f
WHERE
i.inf_id = f.inf_id AND
i.nbr_superfam_id={cdd} AND
i.nbr_type=3 AND
i.is_nr=1
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment