network

Tables (9)

drug_interactions (약물 네트워크 (약물간의 반응))

  • id — BIGSERIAL — Primary key — NOT NULL
  • gene_id — INT
  • first — INT
  • second — INT

drugs (약물)

  • id — BIGSERIAL — Primary key — NOT NULL
  • drug_id — VARCHAR(16)
  • db — VARCHAR(16)
  • cb — VARCHAR(32)
  • sid — VARCHAR(16) []
  • cid — VARCHAR(16) []
  • smiles — VARCHAR(4096)
  • mol_wt — VARCHAR(32)
  • num_h_donor — VARCHAR(8)
  • num_h_acceptor — VARCHAR(8)
  • log_p — VARCHAR(32)
  • ro5 — SMALLINT

protein_drug_interactions (단백질-약물 네트워크 (단백질과 약물간의 반응))

  • id — BIGSERIAL — Primary key — NOT NULL
  • drug_id — VARCHAR(16)
  • gene_id — INT
  • is_target — BOOLEAN
  • is_enzyme — BOOLEAN
  • is_carrier — BOOLEAN
  • is_transporter — BOOLEAN
  • action_type — VARCHAR(16)[]
  • description — VARCHAR(256)
  • ref — VARCHAR(256)

protein_interaction_pairs (단백질 네트워크쌍)

  • id — BIGINT — Primary key — NOT NULL
  • first — INT
  • second — INT

protein_interactions (단백질 네트워크 (단백질 간의 반응))

  • id — BIGSERIAL — Primary key — NOT NULL
  • key — BIGINT — Foreign key → protein_interaction_pairs.id — NOT NULL
  • experiment — VARCHAR(128)
  • is_physical — BOOLEAN
  • is_genetic — BOOLEAN
  • is_colocalization — BOOLEAN
  • is_pathway — BOOLEAN
  • paths — VARCHAR(16)[]

protein_names (프로틴네임)

  • id — BIGSERIAL — Primary key — NOT NULL
  • uniprot — VARCHAR(32)
  • names — VARCHAR(4096)

proteins (단백질)

  • id — BIGSERIAL — Primary key — NOT NULL
  • gene_id — INT
  • pdb_id — VARCHAR(16)
  • symbol — VARCHAR(32)
  • synonyms — VARCHAR(32) []
  • uniprots — VARCHAR(32) []
  • ensembles — VARCHAR(32) []

reactomes (리액톰)

  • id — BIGSERIAL — Primary key — NOT NULL
  • path_id — VARCHAR(16)
  • reactome_id — VARCHAR(32)
  • path_name — VARCHAR(256)

wiki_infos (패스웨이 위키정보)

  • id — BIGSERIAL — Primary key — NOT NULL
  • path_id — VARCHAR(16)
  • path_name — VARCHAR(256)
  • url — VARCHAR(256)