Bclab

Tables (13)

Ensembl_HGNC (Untitled3)

  • HGNC (Field4) — VARCHAR(20) — Primary key
  • ENST (Field2) — VARCHAR(20) — NOT NULL
  • ENSP (Field3) — VARCHAR(20)
  • symbol (Field5) — VARCHAR(10)
  • ENSG (Field6) — VARCHAR(20) — Foreign key → Ensembl_human_GRCh38_p13.ENSG — NOT NULL

Ensembl_UniProtKB (Untitled2)

  • name (Field5) — VARCHAR(20) — Primary key — NOT NULL
  • UniProtKB (Field6) — VARCHAR(20) — Primary key
  • ENSP (Field2) — VARCHAR(20) — NOT NULL
  • ENST (Field3) — VARCHAR(20) — NOT NULL
  • symbol (Field4) — VARCHAR(20)
  • ENSG (Field) — VARCHAR(20) — Foreign key → Ensembl_human_GRCh38_p13.ENSG — NOT NULL

Ensembl_human_GRCh38_p13 (Untitled)

  • ENSG (Field) — VARCHAR(20) — Primary key — NOT NULL
  • ENSGv (Field2) — VARCHAR(20) — NOT NULL
  • ENSP (Field3) — VARCHAR(20)
  • ENSPv (Field4) — VARCHAR(20)
  • ENST (Field5) — VARCHAR(20) — NOT NULL
  • ENSTv (Field6) — VARCHAR(20) — NOT NULL
  • chr (Field7) — VARCHAR(50) — NOT NULL
  • start (Field8) — INTEGER(8) — NOT NULL
  • end (Field9) — INTEGER(8) — NOT NULL
  • strand (Field10) — INTEGER(2) — NOT NULL
  • name (Field11) — VARCHAR(10)
  • type (Field12) — VARCHAR(10) — NOT NULL

HINT_human_binary_hq_2021 (Untitled9)

  • Uniprot_A (Field) — VARCHAR(20)
  • Uniprot_B (Field2) — VARCHAR(20)
  • Gene_A (Field3) — VARCHAR(20)
  • Gene_B (Field4) — VARCHAR(20)
  • ORF_A (Field5) — VARCHAR(20)
  • ORF_B (Field6) — VARCHAR(20)
  • Alias_A (Field7) — VARCHAR(20)
  • Alias_B (Field8) — VARCHAR(20)
  • pmid_method_quality (Field9) — VARCHAR(500)
  • name (Field52) — VARCHAR(20) — Foreign key → Ensembl_UniProtKB.name — NOT NULL
  • UniProtKB (Field62) — VARCHAR(20) — Foreign key → Ensembl_UniProtKB.UniProtKB
  • HGNC (Field42) — VARCHAR(20) — Foreign key → Ensembl_HGNC.HGNC

HuRI-HI-union_202308 (Untitled13)

  • unique_identifier_A (Field) — VARCHAR(50)
  • unique_identifier_B (Field2) — VARCHAR(50)
  • alt_identifier_A (Field3) — VARCHAR(50)
  • alt_identifier_B (Field4) — VARCHAR(50)
  • alias_A (Field5) — VARCHAR(500)
  • alias_B (Field6) — VARCHAR(500)
  • interaction_detection_method (Field7) — VARCHAR(50)
  • author (Field8) — VARCHAR(20)
  • pmid (Field9) — VARCHAR(20)
  • ncbi_taxid_A (Field10) — VARCHAR(20)
  • ncbi_taxid_B (Field11) — VARCHAR(20)
  • interaction_type (Field12) — VARCHAR(50)
  • source_database (Field13) — VARCHAR(20)
  • idinteraction_in_source_db (Field14) — VARCHAR(20)
  • confidence_score (Field15) — VARCHAR(20)
  • expansion_method (Field16) — VARCHAR(10)
  • biological_role_A (Field17) — VARCHAR(20)
  • biological_role_B (Field18) — VARCHAR(20)
  • exp_role_A (Field19) — VARCHAR(20)
  • exp_role_B (Field20) — VARCHAR(20)
  • interactor_type_A (Field21) — VARCHAR(20)
  • interactor_type_B (Field22) — VARCHAR(20)
  • xrefs_A (Field23) — VARCHAR(10)
  • xrefs_B (Field24) — VARCHAR(10)
  • xrefs_interaction (Field25) — VARCHAR(10)
  • annotations_A (Field26) — VARCHAR(10)
  • annotations_B (Field27) — VARCHAR(10)
  • annotations_interaction (Field28) — VARCHAR(10)
  • ncbi_taxid_host_organism (Field29) — VARCHAR(10)
  • parameters_interaction (Field30) — VARCHAR(10)
  • creation_date (Field31) — DATE
  • update_date (Field32) — DATE
  • checksum_A (Field33) — VARCHAR(10)
  • checksum_B (Field34) — VARCHAR(10)
  • checksum_interaction (Field35) — VARCHAR(10)
  • negative (Field36) — VARCHAR(10)
  • features_A (Field37) — VARCHAR(10)
  • features_B (Field38) — VARCHAR(10)
  • stoichiometry_A (Field39) — VARCHAR(10)
  • stoichiometry_B (Field40) — VARCHAR(10)
  • participant_identification_method_A (Field41) — VARCHAR(10)
  • participant_identification_method_B (Field42) — VARCHAR(50)
  • name (Field52) — VARCHAR(20) — Foreign key → Ensembl_UniProtKB.name — NOT NULL
  • UniProtKB (Field62) — VARCHAR(20) — Foreign key → Ensembl_UniProtKB.UniProtKB

InnateDB_Curated_PPI_202308 (Untitled10)

  • unique_identifier_A (Field) — VARCHAR(50)
  • unique_identifier_B (Field2) — VARCHAR(50)
  • alt_identifier_A (Field3) — VARCHAR(50)
  • alt_identifier_B (Field4) — VARCHAR(50)
  • alias_A (Field5) — VARCHAR(500)
  • alias_B (Field6) — VARCHAR(500)
  • interaction_detection_method (Field7) — VARCHAR(50)
  • author (Field8) — VARCHAR(20)
  • pmid (Field9) — VARCHAR(20)
  • ncbi_taxid_A (Field10) — VARCHAR(20)
  • ncbi_taxid_B (Field11) — VARCHAR(20)
  • interaction_type (Field12) — VARCHAR(50)
  • source_database (Field13) — VARCHAR(20)
  • idinteraction_in_source_db (Field14) — VARCHAR(20)
  • confidence_score (Field15) — VARCHAR(20)
  • expansion_method (Field16) — VARCHAR(10)
  • biological_role_A (Field17) — VARCHAR(20)
  • biological_role_B (Field18) — VARCHAR(20)
  • exp_role_A (Field19) — VARCHAR(20)
  • exp_role_B (Field20) — VARCHAR(20)
  • interactor_type_A (Field21) — VARCHAR(20)
  • interactor_type_B (Field22) — VARCHAR(20)
  • xrefs_A (Field23) — VARCHAR(10)
  • xrefs_B (Field24) — VARCHAR(10)
  • xrefs_interaction (Field25) — VARCHAR(10)
  • annotations_A (Field26) — VARCHAR(10)
  • annotations_B (Field27) — VARCHAR(10)
  • annotations_interaction (Field28) — VARCHAR(10)
  • ncbi_taxid_host_organism (Field29) — VARCHAR(10)
  • parameters_interaction (Field30) — VARCHAR(10)
  • creation_date (Field31) — DATE
  • update_date (Field32) — DATE
  • checksum_A (Field33) — VARCHAR(10)
  • checksum_B (Field34) — VARCHAR(10)
  • checksum_interaction (Field35) — VARCHAR(10)
  • negative (Field36) — VARCHAR(10)
  • features_A (Field37) — VARCHAR(10)
  • features_B (Field38) — VARCHAR(10)
  • stoichiometry_A (Field39) — VARCHAR(10)
  • stoichiometry_B (Field40) — VARCHAR(10)
  • participant_identification_method_A (Field41) — VARCHAR(10)
  • participant_identification_method_B (Field42) — VARCHAR(50)
  • name (Field52) — VARCHAR(20) — Foreign key → Ensembl_UniProtKB.name — NOT NULL
  • UniProtKB (Field62) — VARCHAR(20) — Foreign key → Ensembl_UniProtKB.UniProtKB

IntAct_positive (Untitled12)

  • unique_identifier_A (Field) — VARCHAR(50)
  • unique_identifier_B (Field2) — VARCHAR(50)
  • alt_identifier_A (Field3) — VARCHAR(50)
  • alt_identifier_B (Field4) — VARCHAR(50)
  • alias_A (Field5) — VARCHAR(500)
  • alias_B (Field6) — VARCHAR(500)
  • interaction_detection_method (Field7) — VARCHAR(50)
  • author (Field8) — VARCHAR(20)
  • pmid (Field9) — VARCHAR(20)
  • ncbi_taxid_A (Field10) — VARCHAR(20)
  • ncbi_taxid_B (Field11) — VARCHAR(20)
  • interaction_type (Field12) — VARCHAR(50)
  • source_database (Field13) — VARCHAR(20)
  • idinteraction_in_source_db (Field14) — VARCHAR(20)
  • confidence_score (Field15) — VARCHAR(20)
  • expansion_method (Field16) — VARCHAR(10)
  • biological_role_A (Field17) — VARCHAR(20)
  • biological_role_B (Field18) — VARCHAR(20)
  • exp_role_A (Field19) — VARCHAR(20)
  • exp_role_B (Field20) — VARCHAR(20)
  • interactor_type_A (Field21) — VARCHAR(20)
  • interactor_type_B (Field22) — VARCHAR(20)
  • xrefs_A (Field23) — VARCHAR(10)
  • xrefs_B (Field24) — VARCHAR(10)
  • xrefs_interaction (Field25) — VARCHAR(10)
  • annotations_A (Field26) — VARCHAR(10)
  • annotations_B (Field27) — VARCHAR(10)
  • annotations_interaction (Field28) — VARCHAR(10)
  • ncbi_taxid_host_organism (Field29) — VARCHAR(10)
  • parameters_interaction (Field30) — VARCHAR(10)
  • creation_date (Field31) — DATE
  • update_date (Field32) — DATE
  • checksum_A (Field33) — VARCHAR(10)
  • checksum_B (Field34) — VARCHAR(10)
  • checksum_interaction (Field35) — VARCHAR(10)
  • negative (Field36) — VARCHAR(10)
  • features_A (Field37) — VARCHAR(10)
  • features_B (Field38) — VARCHAR(10)
  • stoichiometry_A (Field39) — VARCHAR(10)
  • stoichiometry_B (Field40) — VARCHAR(10)
  • participant_identification_method_A (Field41) — VARCHAR(10)
  • participant_identification_method_B (Field42) — VARCHAR(50)
  • name (Field52) — VARCHAR(20) — Foreign key → Ensembl_UniProtKB.name — NOT NULL
  • UniProtKB (Field62) — VARCHAR(20) — Foreign key → Ensembl_UniProtKB.UniProtKB

MINT_202308 (Untitled11)

  • unique_identifier_A (Field) — VARCHAR(20)
  • unique_identifier_B (Field2) — VARCHAR(20)
  • alt_identifier_A (Field3) — VARCHAR(500)
  • alt_identifier_B (Field4) — VARCHAR(500)
  • alias_A (Field5) — VARCHAR(500)
  • alias_B (Field6) — VARCHAR(500)
  • interaction_detection_method (Field7) — VARCHAR(50)
  • author (Field8) — VARCHAR(50)
  • pmid (Field9) — VARCHAR(20)
  • ncbi_taxid_A (Field10) — VARCHAR(40)
  • ncbi_taxid_B (Field11) — VARCHAR(40)
  • interaction_type (Field12) — VARCHAR(40)
  • source_database (Field13) — VARCHAR(20)
  • idinteraction_in_source_db (Field14) — VARCHAR(40)
  • confidence_score (Field15) — VARCHAR(20)
  • name (Field52) — VARCHAR(20) — Foreign key → Ensembl_UniProtKB.name — NOT NULL
  • UniProtKB (Field62) — VARCHAR(20) — Foreign key → Ensembl_UniProtKB.UniProtKB

PhosphoNetworks_comKSI_202308 (Untitled4)

  • Kinase (Field) — VARCHAR(10) — NOT NULL
  • Substrate (Field2) — VARCHAR(10)
  • Score (Field3) — FLOAT — NOT NULL
  • name (Field5) — VARCHAR(20) — Foreign key → Ensembl_UniProtKB.name — NOT NULL
  • UniProtKB (Field6) — VARCHAR(20) — Foreign key → Ensembl_UniProtKB.UniProtKB

PhosphoSitePlus_v6_202308 (Untitled7)

  • GENE (Field) — VARCHAR(10)
  • KINASE (Field2) — VARCHAR(10)
  • KIN_ACC_ID (Field3) — VARCHAR(10)
  • KIN_ORGANISM (Field4) — VARCHAR(10)
  • SUBSTRATE (Field5) — VARCHAR(20)
  • SUB_GENE_ID (Field6) — INT(10)
  • SUB_ACC_ID (Field7) — VARCHAR(20)
  • SUB_GENE (Field8) — VARCHAR(20)
  • SUB_ORGANISM (Field9) — VARCHAR(10)
  • SUB_MOD_RSD (Field10) — VARCHAR(10)
  • SITE_GRP_ID (Field11) — INT(10)
  • SITE____7_AA (Field12) — VARCHAR(20)
  • DOMAIN (Field13) — VARCHAR(10)
  • IN_VIVO_RXN (Field14) — VARCHAR(2)
  • IN_VITRO_RXN (Field15) — VARCHAR(2)
  • CST_CAT_ (Field16) — FLOAT
  • name (Field52) — VARCHAR(20) — Foreign key → Ensembl_UniProtKB.name — NOT NULL
  • UniProtKB (Field62) — VARCHAR(20) — Foreign key → Ensembl_UniProtKB.UniProtKB

SignaLinkV3 (Untitled6)

  • source_name (Field) — VARCHAR(10)
  • source_uniprotAC (Field2) — VARCHAR(10)
  • source_speciesID (Field3) — FLOAT
  • source_species (Field4) — VARCHAR(10)
  • source_topology (Field5) — VARCHAR(10)
  • source_pathways (Field6) — VARCHAR(10)
  • target_name (Field7) — VARCHAR(10)
  • target_uniprotAC (Field8) — VARCHAR(10)
  • target_speciesID (Field9) — FLOAT
  • target_species (Field10) — VARCHAR(20)
  • target_topology (Field11) — VARCHAR(10)
  • target_pathways (Field12) — VARCHAR(10)
  • layer (Field13) — INT(2)
  • interaction_type (Field14) — VARCHAR(30)
  • directness (Field15) — VARCHAR(10)
  • references (Field16) — VARCHAR(50)
  • source (Field17) — VARCHAR(10)
  • confidence_score (Field18) — VARCHAR(500)
  • tissues (Field19) — VARCHAR(500)
  • score_from_the_source (Field20) — VARCHAR(50)
  • name (Field52) — VARCHAR(20) — Foreign key → Ensembl_UniProtKB.name — NOT NULL
  • UniProtKB (Field62) — VARCHAR(20) — Foreign key → Ensembl_UniProtKB.UniProtKB

Untitled8HINT_human_complex_hq_2021 (Untitled8)

  • Uniprot_B (Field2) — VARCHAR(20)
  • Gene_A (Field3) — VARCHAR(20)
  • Gene_B (Field4) — VARCHAR(20)
  • ORF_A (Field5) — VARCHAR(20)
  • ORF_B (Field6) — VARCHAR(20)
  • Alias_A (Field7) — VARCHAR(20)
  • Alias_B (Field8) — VARCHAR(20)
  • pmid_method_quality (Field9) — VARCHAR(500)
  • name (Field52) — VARCHAR(20) — Foreign key → Ensembl_UniProtKB.name — NOT NULL
  • UniProtKB (Field62) — VARCHAR(20) — Foreign key → Ensembl_UniProtKB.UniProtKB
  • HGNC (Field42) — VARCHAR(20) — Foreign key → Ensembl_HGNC.HGNC
  • Uniprot_A (Field) — VARCHAR(20)

bioGRID_0 (Untitled5)

  • confidence_score (Field) — VARCHAR(10)
  • interaction_type (Field2) — VARCHAR(50)
  • idinteraction_in_source_db (Field3) — VARCHAR(20)
  • pmid (Field4) — VARCHAR(50)
  • interaction_detection_method (Field5) — VARCHAR(50)
  • ncbi_taxid_B (Field6) — VARCHAR(50)
  • alias_B (Field7) — VARCHAR(50)
  • source_database (Field8) — VARCHAR(50)
  • alias_A (Field9) — VARCHAR(50)
  • alt_identifier_B (Field10) — VARCHAR(50)
  • unique_identifier_B (Field11) — VARCHAR(50)
  • ncbi_taxid_A (Field12) — VARCHAR(50)
  • alt_identifier_A (Field13) — VARCHAR(50)
  • unique_identifier_A (Field14) — VARCHAR(50)
  • name (Field52) — VARCHAR(20) — Foreign key → Ensembl_UniProtKB.name — NOT NULL
  • UniProtKB (Field62) — VARCHAR(20) — Foreign key → Ensembl_UniProtKB.UniProtKB