After pulling ID mapping table from UniProt database, we found that for each UniProtKB, there exists multiple PDB IDs; and for each PDB ID, there are sometimes multiple UniProtKBs.
In this case, PDB ID and UniProtKB are many-to-many relationship, which complicates the problem when we are trying to join structural data to kinetics data based on their PDB ID, UniProtKB, and EC numbers.
After pulling ID mapping table from UniProt database, we found that for each UniProtKB, there exists multiple PDB IDs; and for each PDB ID, there are sometimes multiple UniProtKBs.
In this case, PDB ID and UniProtKB are many-to-many relationship, which complicates the problem when we are trying to join structural data to kinetics data based on their PDB ID, UniProtKB, and EC numbers.