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