search

levitsky / pyteomics

Pyteomics is a collection of lightweight and handy tools for Python that help to handle various sorts of proteomics data. Pyteomics provides a growing set of modules to facilitate the most common tasks in proteomics data analysis.
http://pyteomics.readthedocs.io
Apache License 2.0
120 stars 37 forks source link

Problems with loading Unimod into PostgreSQL #47

Open radusuciu opened 3 years ago

radusuciu commented 3 years ago

Hi, thanks for the great project. I'm attempting to load the latest Unimod XML file into Postgres using pyteomics and have encountered a few errors that I've attempted to solve along the way. I've documented the process I've undertaken as best I could but please let me know if you'd like more information, or if I've made a mistake along the way.

I'm attempting to load data into a PostgreSQL 12 database like so:

from pyteomics.mass import unimod

unimod.load(
    'unimod_tables.xml',
    output_path='postgresql://unimod:unimod@localhost:5432/unimod'
)

This database lives in a docker container, brought up with docker-compose:

version: '3.8'

services:
    postgres:
        image: postgres:12
        environment:
            POSTGRES_PASSWORD: unimod
            POSTGRES_USER: unimod
            POSTGRES_DB: unimod
        volumes:
            - ./pgdata:/var/lib/postgresql/data
        network_mode: host

I initially encountered this error:

postgres_1  | 2021-05-27 20:43:17.685 UTC [83] ERROR:  there is no unique constraint matching given keys for referenced table "Brick"
postgres_1  | 2021-05-27 20:43:17.685 UTC [83] STATEMENT:  
postgres_1  |   CREATE TABLE "ModificationToBrick" (
postgres_1  |           id SERIAL NOT NULL, 
postgres_1  |           brick_string VARCHAR(64), 
postgres_1  |           modification_id INTEGER, 
postgres_1  |           count INTEGER, 
postgres_1  |           PRIMARY KEY (id), 
postgres_1  |           FOREIGN KEY(brick_string) REFERENCES "Brick" (brick), 
postgres_1  |           FOREIGN KEY(modification_id) REFERENCES "Modification" (id)
postgres_1  |   )

I sort of blindly tried to fix this by adding a unique constraint on Brick.brick: https://github.com/radusuciu/pyteomics/commit/364413d361177ff7747ab858b8cdc63b399db6a3#diff-1ade65743552f19d20d8bcc9845a4166aefd0fe563acc01c5716402ff7cbaee7L303-R303

Similar errors then crop up on the Specificity and Element tables: https://github.com/radusuciu/pyteomics/commit/364413d361177ff7747ab858b8cdc63b399db6a3

After adding unique constraints for those other tables, I hit a different error.

postgres_1  | 2021-05-27 21:34:23.830 UTC [189] ERROR:  insert or update on table "ModificationToBrick" violates foreign key constraint "ModificationToBrick_brick_string_fkey"
postgres_1  | 2021-05-27 21:34:23.830 UTC [189] DETAIL:  Key (brick_string)=(O) is not present in table "Brick".
postgres_1  | 2021-05-27 21:34:23.830 UTC [189] STATEMENT:  INSERT INTO "ModificationToBrick" (id, brick_string, modification_id, count) VALUES (20034, 'O', 1, 1),(20033, 'C', 1, 2),(20032, 'H', 1, 2),(11872, 'O', 2,  -1),(11871, 'N', 2, 1),(11870, 'H', 2, 1),(19969, 'S', 3, 1),(19968, 'O', 3, 2),(19967, 'N', 3, 2),(19966, 'C', 3, 10),(19965, 'H', 3, 14),(19964, 'O', 4, 1),(19963, 'N', 4, 1),(19962, 'C', 4, 2),(19961, 'H', 4, 3),(14253, 'O', 5, 1),(14252, 'N', 5, 1),(14251, 'C', 5, 1),(14250, 'H', 5, 1),(18668, 'O', 6, 2),(18667, 'C', 6, 2),(18666, 'H', 6, 2),(20852, 'O', 7, 1),(20851, 'N', 7,  -1),(20850, 'H', 7,  -1),(7009, 'S', 8, 1),(7008, 'O', 8, 6),(7007, 'N', 8, 4),(7006, 'C', 8, 22),(7005, 'H', 8, 38),(7020, 'S', 9, 1),(7019, 'O', 9, 6),(7018, 'N', 9, 4),(7017, 'C', 9, 22),(7016, '2H', 9, 8),(7015, 'H', 9, 30),(5946, 'S', 10,  -1),(5945, 'O', 10, 1),(5944, 'C', 10,  -1),(5943, 'H', 10,  -2),(8388, 'S', 11,  -1),(8387, 'C', 11,  -1),(8386, 'H', 11,  -4),(6983, 'S', 12, 1),(6982, 'O', 12, 5),(6981, 'N', 12, 4),(6980, 'C', 12, 20),(6979, '2H', 12, 8),(6978, 'H', 12, 26),(6977, 'S', 13, 1),(6976, 'O', 13, 5),(6975, 'N', 13, 4),(6974, 'C', 13, 20),(6973, 'H', 13, 34),(8976, 'O', 528, 1),(8975, 'N', 528,  -1),(6415, 'O', 17, 1),(6414, 'N', 17, 1),(6413, 'C', 17, 5),(6412, 'H', 17, 9),(8439, 'S', 20, 1),(8438, 'O', 20, 5),(8437, 'N', 20, 4),(8436, 'C', 20, 18),(8435, 'H', 20, 30),(20741, 'P', 21, 1),(20740, 'O', 21, 3),(20739, 'H', 21, 1),(20075, '18O', 533, 1),(20098, '18O', 532, 1),(20097, 'N', 532, 2),(8362, 'O', 23,  -1),(8361, 'H', 23,  -2),(12179, 'O', 24, 1),(12178, 'N', 24, 1),(12177, 'C', 24, 3),(12176, 'H', 24, 5),(6457, 'O', 25, 1),(6456, 'N', 25, 1),(6455, 'C', 25, 7),(6454, 'H', 25, 5),(8360, 'O', 26, 1),(8359, 'C', 26, 2),(10117, 'O', 27,  -1),(10116, 'H', 27,  -2),(6009, 'N', 28,  -1),(6008, 'H', 28,  -3),(12018, 'O', 29, 2),(12017, 'N', 29, 1),(12016, 'C', 29, 6),(12015, 'H', 29, 9),(6157, 'Na', 30, 1),(6156, 'H', 30,  -1),(6434, 'N', 31, 1),(6433, 'C', 31, 7),(6432, 'H', 31, 7),(18619, 'C', 34, 1),(18618, 'H', 34, 2),(19960, 'O', 35, 1),(15866, 'C', 36, 2),(15865, 'H', 36, 4),(18535, 'C', 37, 3),(18534, 'H', 37, 6),(14404, 'S', 39, 1),(14403, 'C', 39, 1),(14402, 'H', 39, 2),(14689, 'S', 40, 1),(14688, 'O', 40, 3),(20732, 'Hex', 41, 1),(6689, 'S', 42, 2),(6688, 'O', 42, 1),(6687, 'C', 42, 8),(6686, 'H', 42, 12),(19291, 'HexNAc', 43, 1),(6717, 'C', 44, 15),(6716, 'H', 44, 24),(6720, 'O', 45, 1),(6719, 'C', 45, 14),(6718, 'H', 45, 26),(6766, 'P', 46, 1),(6765, 'O', 46, 5),(6764, 'N', 46, 1),(6763, 'C', 46, 8),(6762, 'H', 46, 8),(6780, 'O', 47, 1),(6779, 'C', 47, 16),(6778, 'H', 47, 30),(6803, 'C', 48, 20),(6802, 'H', 48, 32),(6872, 'S', 49, 1),(6871, 'P', 49, 1),(6870, 'O', 49, 6),(6869, 'N', 49, 2),(6868, 'C', 49, 11),(6867, 'H', 49, 21),(7119, 'P', 50, 2),(7118, 'O', 50, 15),(7117, 'N', 50, 9),(7116, 'C', 50, 27),(7115, 'H', 50, 31),(7432, 'O', 51, 5),(7431, 'C', 51, 51),(7430, 'H', 51, 96),(14310, 'N', 52, 2),(14309, 'C', 52, 1),(14308, 'H', 52, 2),(14750, 'O', 53, 2),(14749, 'C', 53, 9),(14748, 'H', 53, 16),(16457, 'Hex', 1428, 1),(16456, 'Pent', 1428, 2),(20111, 'HexA', 54, 1),(6833, 'S', 55, 1),(6832, 'O', 55, 6),(6831, 'N', 55, 3),(6830, 'C', 55, 10),(6829, 'H', 55, 15),(14216, 'O', 56, 1),(14215, 'C', 56, 2),(14214, '2H', 56, 3),(14213, 'H', 56,  -1),(14443, 'O', 58, 1),(14442, 'C', 58, 3),(14441, 'H', 58, 4),(6297, 'O', 59, 1),(6296, '13C', 59, 3),(6295, 'H', 59, 4),(6513, 'O', 60, 1),(6512, 'N', 60, 1),(6511, 'C', 60, 7),(6510, 'H', 60, 13),(6518, 'O', 61, 1),(6517, 'N', 61, 1),(6516, 'C', 61, 7),(6515, '2H', 61, 3),(6514, 'H', 61, 10),(6526, 'O', 62, 1),(6525, 'N', 62, 1),(6524, 'C', 62, 7),(6523, '2H', 62, 6),(6522, 'H', 62, 7),(6535, 'O', 63, 1),(6534, 'N', 63, 1),(6533, 'C', 63, 7),(6532, '2H', 63, 9),(6531, 'H', 63, 4),(6418, 'O', 64, 3),(6417, 'C', 64, 4),(6416, 'H', 64, 4),(6427, 'O', 65, 3),(6426, 'C', 65, 4),(6425, '2H', 65, 4),(6424, 'O', 66, 3),(6423, '13C', 66, 4),(6422, 'H', 66, 4),(7056, 'O', 377, 4),(5935, 'S', 368,  -1),(5934, 'H', 368,  -2),(20039, 'O', 354, 2),(7114, 'S', 281, 1),(13680, 'O', 348, 1),(8506, 'S', 353, 1),(8505, 'O', 353, 2),(13679, 'N', 348,  -1),(13684, 'O', 349, 2),(13683, 'N', 349,  -2),(8504, 'N', 353, 3),(6021, 'O', 352, 1),(6078, 'O', 351, 1),(13682, 'C', 349,  -2),(13681, 'H', 349,  -2),(6411, 'S', 260, 1),(6410, 'P', 260, 1),(6409, 'O', 260, 2),(6408, 'H', 260, 1),(15617, '15N', 259, 2),(15616, 'N', 259,  -2),(15615, '13C', 259, 6),(20038, 'N', 354, 1),(8527, 'O', 344, 1),(8526, 'N', 344,  -3),(8525, 'C', 344,  -1),(8524, 'H', 344,  -5),(13678, 'C', 348,  -2),(13677, 'H', 348,  -1),(6747, 'S', 89, 1),(6746, 'O', 89, 1),(6745, 'N', 89, 3),(6744, 'C', 89, 10),(6743, 'H', 89, 15),(6861, 'S', 90, 1),(6860, 'O', 90, 2),(6859, 'N', 90, 4),(6858, 'C', 90, 16),(6857, 'H', 90, 26),(6902, 'S', 91, 1),(6901, 'O', 91, 2),(6900, 'N', 91, 4),(6899, 'C', 91, 16),(6898, '2H', 91, 10),(6897, 'H', 91, 16),(18515, 'S', 92, 1),(18514, 'O', 92, 3),(18513, 'N', 92, 3),(18512, 'C', 92, 16),(18511, 'H', 92, 25),(8419, 'S', 93, 3),(8418, 'O', 93, 6),(8417, 'N', 93, 5),(8416, 'C', 93, 25),(8415, 'H', 93, 39),(6307, 'N', 94, 2),(6306, 'C', 94, 3),(6305, 'H', 94, 4),(6323, 'N', 95, 2),(6322, 'C', 95, 3),(6321, '2H', 95, 4),(20037, 'H', 354,  -1),(8503, 'C', 353, 10),(6020, 'N', 352,  -1),(6019, 'H', 352,  -3),(6328, 'O', 97, 1),(6327, 'N', 97, 1),(6326, 'C', 97, 3),(6325, '2H', 97, 3),(6324, 'H', 97, 2),(8502, 'H', 353, 15),(6756, 'O', 105, 3),(15614, 'C', 259,  -6),(6056, '18O', 258, 1),(6077, 'C', 351,  -1),(8523, 'O', 350, 2),(8522, 'C', 350,  -1),(8521, 'S', 357, 1),(8520, 'O', 357, 2),(6755, 'N', 105, 3),(6754, 'C', 105, 10),(6753, 'H', 105, 17),(6761, 'O', 106, 3),(6760, 'N', 106, 3),(6759, '13C', 106, 9),(6758, 'C', 106, 1),(6757, 'H', 106, 17),(6634, 'S', 107, 1),(6633, 'O', 107, 2),(6632, 'N', 107, 1),(6631, 'C', 107, 6),(6630, 'H', 107, 9),(6492, 'O', 108, 2),(6491, 'N', 108, 1),(6490, 'C', 108, 6),(6489, 'H', 108, 7),(8476, 'S', 112, 1),(8475, 'O', 112, 3),(8474, 'N', 112, 4),(6841, 'P', 119, 1),(6840, 'C', 119, 22),(6839, 'H', 119, 21),(8473, 'C', 112, 16),(8472, 'H', 112, 26),(8481, 'S', 113, 1),(8480, 'O', 113, 3),(8479, 'N', 113, 4),(8478, 'C', 113, 16),(8477, 'H', 113, 24),(8486, 'S', 114, 1),(8485, 'O', 114, 3),(8484, 'N', 114, 5),(8483, 'C', 114, 16),(8482, 'H', 114, 29),(8491, 'S', 115, 1),(8490, 'O', 115, 3),(8489, 'N', 115, 5),(8488, 'C', 115, 16),(8487, 'H', 115, 27),(13984, 'S', 116, 1),(13983, 'O', 116, 3),(13982, 'N', 116, 2),(13981, 'C', 116, 15),(13980, 'H', 116, 22),(13979, 'S', 117, 1),(13978, 'O', 117, 3),(13977, 'N', 117, 2),(13976, 'C', 117, 15),(13975, 'H', 117, 24),(19204, 'O', 121, 2),(7014, 'S', 118, 3),(7013, 'O', 118, 4),(7012, 'N', 118, 4),(7011, 'C', 118, 20),(7010, 'H', 118, 34),(19203, 'N', 121, 2),(19202, 'C', 121, 4),(19201, 'H', 121, 6),(8447, 'O', 122, 1),(8446, 'C', 122, 1),(6890, 'Cl', 123, 1),(6889, 'O', 123, 6),(6888, 'N', 123, 1),(6887, 'C', 123, 15),(6886, 'H', 123, 20),(6910, 'Cl', 124, 1),(6909, 'O', 124, 6),(6908, 'N', 124, 1),(6907, '13C', 124, 6),(6906, 'C', 124, 9),(6905, 'H', 124, 20),(19763, 'S', 126, 1),(19762, 'O', 126, 1),(19761, 'C', 126, 3),(19760, 'H', 126, 4),(15171, 'F', 127, 1),(15170, 'H', 127,  -1),(20010, 'O', 128, 6),(20009, 'N', 128, 1),(20008, 'C', 128, 22),(20007, 'H', 128, 13),(6502, 'I', 129, 1),(6501, 'H', 129,  -1),(14268, 'I', 130, 2),(14267, 'H', 130,  -2),(6922, 'I', 131, 3),(6921, 'H', 131,  -3),(6715, 'O', 134, 1),(8519, 'N', 357, 4),(8518, 'C', 357, 10),(8517, 'H', 357, 18),(6714, 'C', 134, 14),(6713, 'H', 134, 24),(6712, 'O', 135, 1),(6711, 'C', 135, 14),(6710, 'H', 135, 22),(6421, 'O', 136, 1),(6420, 'C', 136, 7),(6419, 'H', 136, 4),(14752, 'Se', 162, 1),(14751, 'S', 162,  -1),(21265, 'HexNAc', 137, 2),(21264, 'Hex', 137, 5),(6771, 'S', 139, 1),(6770, 'O', 139, 2),(6769, 'N', 139, 1),(6768, 'C', 139, 12),(6767, 'H', 139, 11),(11824, 'O', 140,  -2),(11823, 'C', 140,  -1),(11822, 'H', 140,  -2),(6213, 'N', 141, 1),(6212, 'C', 141, 2),(6211, 'H', 141, 3),(16454, 'HexNAc', 142, 1),(16453, 'dHex', 142, 1),(16455, 'HexNAc', 143, 2),(16474, 'Hex', 144, 3),(16141, 'HexNAc', 145, 1),(16140, 'dHex', 145, 2),(16481, 'HexNAc', 146, 1),(16480, 'Hex', 146, 1),(16479, 'dHex', 146, 1),(16163, 'HexNAc', 147, 2),(16162, 'dHex', 147, 1),(16446, 'HexNAc', 148, 2),(16445, 'Hex', 148, 1),(16177, 'NeuAc', 149, 1),(16176, 'HexNAc', 149, 1),(16175, 'Hex', 149, 1),(16181, 'HexNAc', 150, 2),(16180, 'dHex', 150, 2),(16187, 'HexNAc', 151, 2),(16186, 'Hex', 151, 1),(16185, 'Pent', 151, 1),(17876, 'HexNAc', 152, 2),(17875, 'Hex', 152, 1),(17874, 'dHex', 152, 1),(17880, 'HexNAc', 153, 2),(17879, 'Hex', 153, 2),(16207, 'HexNAc', 154, 1),(16206, 'Hex', 154, 3),(16205, 'Pent', 154, 1),(16215, 'HexNAc', 155, 2),(16214, 'Hex', 155, 1),(16213, 'dHex', 155, 1),(16212, 'Pent', 155, 1),(17886, 'HexNAc', 156, 2),(17885, 'Hex', 156, 1),(17884, 'dHex', 156, 2),(16227, 'HexNAc', 157, 2),(16226, 'Hex', 157, 2),(16225, 'Pent', 157, 1),(17892, 'HexNAc', 158, 2),(17891, 'Hex', 158, 2),(17890, 'dHex', 158, 1),(21267, 'HexNAc', 159, 2),(21266, 'Hex', 159, 3),(20162, 'NeuAc', 160, 2),(20161, 'HexNAc', 160, 1),(20160, 'Hex', 160, 1),(17942, 'HexNAc', 161, 2),(17941, 'Hex', 161, 3),(17940, 'P', 161, 1),(9495, 'S', 171, 1),(9494, 'O', 171, 2),(9493, 'N', 171, 1),(9492, '13C', 171, 6),(9491, 'H', 171, 3),(15602, '18O', 170, 1),(15601, 'N', 170,  -1),(15600, 'H', 170,  -1),(15862, '13C', 330, 2),(6244, 'S', 327, 1),(6243, 'O', 327,  -1),(6242, 'C', 327, 2),(6241, 'H', 327, 4),(15204, 'C', 298, 1),(9490, 'S', 172, 1),(9489, 'O', 172, 2),(9488, 'N', 172, 1),(9487, 'C', 172, 6),(9486, 'H', 172, 3),(6660, 'O', 194, 1),(6659, 'N', 194, 2),(6658, 'C', 194, 10),(6657, 'H', 194, 6),(6728, 'O', 176, 1),(6727, 'C', 176, 15),(6726, 'H', 176, 22),(6386, 'S', 178, 1),(6385, 'O', 178,  -1),(6384, 'N', 178, 1),(6383, 'C', 178, 4),(6382, 'H', 178, 9),(8394, 'O', 369,  -1),(8393, 'C', 369,  -1),(21369, 'O', 378, 2),(21368, 'C', 378, 3),(21367, 'H', 378, 4),(7055, 'C', 377, 37),(9451, '13C', 188, 6),(9450, 'C', 188,  -6),(7113, 'P', 281, 3),(9457, '13C', 184, 9),(9456, 'C', 184,  -9),(6399, 'P', 185, 1),(6398, 'O', 185, 3),(6397, '13C', 185, 9),(6396, 'C', 185,  -9),(6395, 'H', 185, 1),(7232, 'O', 186, 2),(7231, 'C', 186, 8),(7230, 'H', 186, 4),(10954, 'O', 187, 5),(10953, 'C', 187, 16),(10952, 'H', 187, 10),(8445, '18O', 193, 2),(8444, 'O', 193,  -2),(10958, 'O', 195, 1),(10957, 'N', 195, 2),(10956, 'C', 195, 9),(10955, 'H', 195, 19),(6669, 'O', 196, 1),(6668, 'N', 196, 2),(6667, 'C', 196, 9),(6666, '2H', 196, 3),(6665, 'H', 196, 16),(6681, 'O', 197, 1),(6680, 'N', 197, 2),(6679, 'C', 197, 10),(6678, 'H', 197, 20),(6694, 'O', 198, 1),(6693, 'N', 198, 2),(6692, 'C', 198, 10),(6691, '2H', 198, 5),(6690, 'H', 198, 15),(6381, 'O', 371, 2),(15854, 'C', 199, 2),(15853, '2H', 199, 4),(6332, 'S', 200, 2),(6331, 'O', 200,  -1),(6330, 'C', 200, 2),(6329, 'H', 200, 4),(6407, 'O', 205, 1),(6378, 'O', 211, 1),(6377, 'N', 211, 1),(6406, 'C', 205, 6),(6405, 'H', 205, 6),(20043, 'O', 206, 1),(20042, 'C', 206, 3),(20041, 'H', 206, 4),(6208, 'C', 207, 3),(6207, 'H', 207, 2),(6338, 'C', 208, 6),(6337, 'H', 208, 4),(6449, 'O', 209, 2),(6448, 'C', 209, 6),(6447, 'H', 209, 8),(6376, 'C', 211, 4),(6375, 'H', 211, 7),(6404, 'O', 212, 1),(6403, 'N', 212, 1),(6402, 'C', 212, 4),(6401, '2H', 212, 5),(6400, 'H', 212, 2),(20277, 'Pent', 213, 1),(20276, 'P', 213, 2),(20275, 'O', 213, 9),(20274, 'N', 213, 5),(20273, 'C', 213, 10),(20093, 'O', 214, 1),(20092, '15N', 214, 1),(20091, 'N', 214, 1),(20090, '13C', 214, 3),(20089, 'C', 214, 4),(20088, 'H', 214, 12),(6055, 'O', 258,  -1),(6380, 'C', 371, 4),(6379, 'H', 371, 6),(20040, 'O', 345, 3),(8471, 'S', 343, 1),(8470, 'O', 343, 2),(8469, 'N', 343, 1),(8468, 'C', 343, 9),(6133, 'N', 342, 1),(14241, 'Br', 340, 1),(14240, 'H', 340,  -1),(6132, 'H', 342, 1),(6471, 'S', 264, 1),(14377, '15N', 268, 1),(14376, 'N', 268,  -1),(14375, '13C', 268, 5),(14374, 'C', 268,  -5),(15250, '2H', 262, 3),(15249, 'H', 262,  -3),(6742, 'S', 261, 2),(6741, 'O', 261, 3),(6740, 'N', 261, 1),(6739, 'C', 261, 7),(6738, 'H', 261, 5),(11625, 'C', 256, 3),(11624, 'H', 256, 4),(14257, 'C', 255, 2),(14256, 'H', 255, 4),(7505, 'Br', 243, 1),(7504, 'O', 243, 2),(6313, 'O', 253, 1),(6312, 'C', 253, 4),(6311, 'H', 253, 6),(14255, 'C', 254, 2),(14254, 'H', 254, 2),(7503, 'N', 243, 2),(7502, 'C', 243, 12),(7501, 'H', 243, 13),(6470, 'O', 264,  -1),(6469, 'N', 264, 1),(6468, 'C', 264, 7),(6467, 'H', 264, 7),(7112, 'O', 281, 16),(7111, 'N', 281, 7),(6918, 'O', 270, 7),(6917, 'C', 270, 19),(6916, 'H', 270, 22),(6925, 'O', 271, 8),(6924, 'C', 271, 19),(6923, 'H', 271, 24),(7458, '15N', 267, 4),(7457, 'N', 267,  -4),(7456, '13C', 267, 6),(7455, 'C', 267,  -6),(7462, '15N', 269, 1),(7461, 'N', 269,  -1),(7460, '13C', 269, 9),(7459, 'C', 269,  -9),(8672, 'S', 272, 1),(8671, 'O', 272, 4),(8670, 'C', 272, 3),(8669, 'H', 272, 4),(19883, 'O', 1906, 2),(19875, 'O', 1905, 2),(19874, 'C', 1905, 5),(19873, 'H', 1905, 4),(7054, 'H', 377, 68),(6731, 'O', 376, 1),(6730, 'C', 376, 15),(21072, 'O', 275, 1),(21071, 'N', 275, 1),(6677, 'S', 276, 1),(6676, 'O', 276, 2),(6675, 'N', 276, 1),(6674, 'C', 276, 8),(6673, 'H', 276, 9),(19975, 'O', 278, 1),(19974, 'C', 278, 2),(19973, 'H', 278, 4),(18621, 'C', 280, 2),(18620, 'H', 280, 4),(7110, 'C', 281, 21),(7109, 'H', 281, 34),(8974, 'C', 528, 1),(8973, 'H', 528, 1),(6185, 'C', 529, 2),(6184, 'H', 529, 5),(18886, 'C', 284, 1),(18885, '2H', 284, 2),(6616, 'S', 285, 1),(6615, 'O', 285, 2),(6614, 'N', 285, 1),(6613, 'C', 285, 6),(6612, 'H', 285, 5),(6639, 'S', 286, 1),(6638, 'O', 286, 2),(6637, 'N', 286, 1),(6636, '13C', 286, 6),(6635, 'H', 286, 5),(8424, 'S', 289, 1),(6108, 'O', 288, 1),(6107, 'H', 288,  -2),(8423, 'O', 289, 3),(8422, 'N', 289, 4),(8421, 'C', 289, 16),(8420, 'H', 289, 28),(12169, 'S', 290, 2),(12168, 'O', 290, 3),(12167, 'N', 290, 4),(12166, 'C', 290, 19),(12165, 'H', 290, 32),(19127, 'P', 292, 1),(6705, 'Hg', 291, 1),(19126, 'O', 292, 9),(19125, 'N', 292, 2),(19124, 'C', 292, 9),(19123, 'H', 292, 11),(6592, 'S', 293, 1),(6591, 'O', 293, 2),(6590, 'N', 293, 1),(6589, 'C', 293, 5),(6588, 'H', 293, 7),(6851, 'S', 294, 1),(6850, 'O', 294, 3),(6849, 'N', 294, 4),(6848, 'C', 294, 14),(6847, 'H', 294, 22),(6729, 'H', 376, 24),(20252, 'dHex', 295, 1),(18625, 'O', 375, 1),(18624, 'N', 375, 2),(18623, 'C', 375, 7),(18622, 'H', 375, 14),(6022, 'H', 374,  -1),(5933, 'N', 372,  -2),(5932, 'C', 372,  -1),(5931, 'H', 372,  -2),(15203, '2H', 298, 3),(15202, 'H', 298,  -1),(8381, 'O', 299, 2),(8380, 'C', 299, 1),(20074, '15N', 533, 1),(15945, 'Cu', 531, 1),(15944, 'H', 531,  -1),(6698, 'O', 301, 2),(6697, 'N', 301, 2),(6696, 'C', 301, 10),(6695, 'H', 301, 10),(9394, 'O', 302, 2),(9393, 'C', 302, 11),(9392, 'H', 302, 6),(6336, 'S', 303, 1),(6335, 'O', 303, 1),(6334, 'C', 303, 2),(6333, 'H', 303, 4),(6275, 'O', 319, 1),(21244, 'HexNAc', 305, 4),(21243, 'Hex', 305, 3),(21242, 'dHex', 305, 1),(20073, 'N', 533, 1),(20072, '13C', 533, 1),(21270, 'HexNAc', 307, 4),(21269, 'Hex', 307, 4),(21268, 'dHex', 307, 1),(6344, 'C', 316, 6),(21238, 'HexNAc', 308, 4),(21237, 'Hex', 308, 5),(21236, 'dHex', 308, 1),(6274, 'C', 319, 3),(21227, 'HexNAc', 309, 4),(21226, 'Hex', 309, 3),(6304, 'C', 318, 5),(6303, 'H', 318, 2),(21225, 'HexNAc', 310, 4),(21224, 'Hex', 310, 4),(6343, 'H', 316, 6),(21223, 'HexNAc', 311, 4),(21222, 'Hex', 311, 5),(8619, 'S', 312, 1),(8618, 'O', 312, 2),(8617, 'N', 312, 1),(8616, 'C', 312, 3),(8615, 'H', 312, 5),(5917, 'O', 313,  -1),(5916, 'N', 313,  -2),(5915, 'C', 313,  -6),(5914, 'H', 313,  -12),(7203, 'O', 314, 2),(7202, 'N', 314, 1),(7201, 'C', 314, 5),(7200, 'H', 314, 5),(7261, 'O', 476, 1),(7336, 'O', 493, 4),(7335, 'C', 493, 21),(7334, 'H', 493, 24),(17846, 'Hep', 490, 1),(6273, 'H', 319, 2),(7210, 'O', 320, 3),(7209, 'N', 320, 1),(7208, 'C', 320, 6),(7207, 'H', 320, 9),(9510, 'O', 771, 2),(9509, 'C', 771, 16),(15861, '2H', 330, 6),(18889, '13C', 329, 1),(18888, '2H', 329, 3),(18887, 'H', 329,  -1),(19869, 'I', 323, 1),(19868, 'S', 323, 1),(19867, 'O', 323, 6),(19866, 'N', 323, 4),(19865, 'C', 323, 31),(19864, 'H', 323, 30),(19678, 'S', 324, 1),(19677, 'N', 324, 1),(19676, 'C', 324, 3),(19675, 'H', 324, 5),(11604, 'S', 325, 1),(11603, 'P', 325, 1),(11602, 'O', 325, 5),(11601, 'N', 325, 4),(11600, 'C', 325, 27),(11599, 'H', 325, 49),(15860, 'H', 330,  -2),(6618, 'Br', 534, 2),(7038, 'S', 332, 3),(7037, 'P', 332, 1),(7036, 'O', 332, 5),(7035, 'N', 332, 4),(7034, 'C', 332, 19),(7033, 'H', 332, 34),(8467, 'H', 343, 13),(12164, 'S', 333, 1),(12163, 'P', 333, 1),(12162, 'O', 333, 5),(12161, 'N', 333, 3),(12160, 'C', 333, 19),(12159, 'H', 333, 34),(6617, 'H', 534,  -2),(13949, 'O', 335, 2),(13948, 'C', 335, 9),(13947, 'H', 335, 18),(5942, 'O', 360,  -1),(5941, 'C', 360,  -1),(6106, 'O', 359, 1),(6105, 'H', 359,  -2),(6104, 'O', 337,  -1),(6103, 'N', 337, 1),(6102, 'C', 337, 1),(6101, 'H', 337, 3),(8516, 'S', 361, 1),(8515, 'O', 361, 1),(5940, 'H', 360,  -2),(8514, 'N', 361, 4),(8513, 'C', 361, 10),(8512, 'H', 361, 16),(14522, 'P', 362, 1),(14521, 'O', 362, 3),(14520, 'C', 362, 6),(14519, 'H', 362, 13),(8924, 'P', 363, 1),(8923, 'O', 363, 3),(8922, 'C', 363, 3),(8921, 'H', 363, 7),(10348, 'O', 364, 1),(10347, 'N', 364, 1),(10346, '13C', 364, 6),(10345, 'H', 364, 3),(10339, 'O', 365, 1),(10338, 'N', 365, 1),(10337, 'C', 365, 6),(10336, 'H', 365, 3),(6071, '18O', 366, 1),(6070, 'N', 366,  -1),(6069, 'H', 366,  -1),(6390, 'O', 379, 1),(6389, 'N', 379, 1),(6388, 'C', 379, 4),(6387, 'H', 379, 9),(6799, 'C', 380, 20),(6798, 'H', 380, 26),(6127, 'O', 381, 2),(6126, 'N', 381,  -1),(6125, 'H', 381,  -3),(5981, 'S', 382,  -1),(5980, 'O', 382, 1),(5979, 'N', 382,  -1),(5978, 'H', 382,  -3),(9415, 'N', 385,  -1),(9414, 'H', 385,  -3),(20096, '13C', 532, 2),(20095, 'C', 532, 5),(20094, 'H', 532, 12),(7064, 'O', 387, 6),(7063, 'N', 387, 4),(7062, 'C', 387, 33),(7061, 'H', 387, 38),(7068, 'O', 388, 6),(7067, 'N', 388, 4),(7066, 'C', 388, 33),(7065, 'H', 388, 40),(7060, 'O', 389, 6),(7059, 'N', 389, 4),(7058, 'C', 389, 33),(7057, 'H', 389, 36),(7086, 'Fe', 390, 1),(7085, 'O', 390, 4),(7084, 'N', 390, 4),(7083, 'C', 390, 34),(7082, 'H', 390, 32),(7032, 'Mo', 391, 1),(7031, 'S', 391, 2),(7030, 'P', 391, 1),(7029, 'O', 391, 8),(7028, 'N', 391, 5),(7027, 'C', 391, 10),(7026, 'H', 391, 11),(6187, 'O', 392, 2),(6186, 'H', 392,  -2),(16039, 'Hex', 393, 2),(16038, 'O', 393, 1),(8399, 'P', 394, 1),(8398, 'O', 394, 3),(8397, 'N', 394, 1),(8396, 'C', 394, 2),(8395, 'H', 394, 6),(7148, 'S', 395, 1),(7147, 'P', 395, 3),(7146, 'O', 395, 19),(7145, 'N', 395, 7),(7144, 'C', 395, 26),(7143, 'H', 395, 42),(6704, 'P', 396, 1),(6703, 'O', 396, 5),(6702, 'N', 396, 1),(6701, 'C', 396, 5),(6700, 'H', 396, 12),(7003, 'I', 397, 3),(7002, 'O', 397, 1),(7001, 'C', 397, 6),(7000, 'H', 397, 1),(7071, 'I', 398, 4),(7070, 'O', 398, 1),(7069, 'C', 398, 6),(5920, 'O', 400,  -1),(5919, 'C', 400,  -6),(5918, 'H', 400,  -6),(10232, 'H', 401,  -2),(10854, 'S', 402,  -1),(10853, 'O', 402, 1),(10852, 'H', 402,  -2),(6015, 'N', 403,  -1),(6014, 'H', 403,  -1),(7325, 'O', 451, 6),(7324, 'N', 451, 2),(7323, 'C', 451, 10),(7322, 'H', 451, 14),(21489, 'P', 405, 1),(21488, 'O', 405, 6),(21487, 'N', 405, 5),(21486, 'C', 405, 10),(21485, 'H', 405, 12),(7321, 'O', 450, 3),(7320, 'N', 450, 1),(7319, 'C', 450, 5),(7318, 'H', 450, 7),(6595, 'O', 407, 2),(6594, 'C', 407, 9),(6593, 'H', 407, 6),(15989, 'Hex', 408, 1),(15988, 'H', 408,  -2),(15987, 'C', 408,  -1),(6994, 'P', 409, 1),(6993, 'O', 409, 9),(6992, 'N', 409, 4),(6991, 'C', 409, 17),(6990, 'H', 409, 19),(7089, 'O', 410, 2),(7088, 'C', 410, 43),(7087, 'H', 410, 86),(6461, 'O', 411, 1),(6460, 'N', 411, 1),(6459, 'C', 411, 7),(6458, 'H', 411, 5),(6488, 'O', 412, 1),(6487, 'N', 412, 1),(6486, 'C', 412, 7),(6485, '2H', 412, 5),(6885, 'P', 413, 1),(6884, 'O', 413, 7),(6883, 'N', 413, 5),(6882, 'C', 413, 10),(6881, 'H', 413, 12),(21070, 'H', 275,  -1),(6190, 'O', 414, 1),(6189, 'C', 414, 1),(6188, 'H', 414, 2),(7229, 'Mo', 415, 1),(7228, 'Se', 415, 1),(7227, 'S', 415, 3),(7226, 'P', 415, 4),(7225, 'O', 415, 26),(7224, 'N', 415, 20),(7223, 'C', 415, 40),(7222, 'H', 415, 47),(8326, 'O', 416, 8),(8325, 'N', 416, 2),(8324, 'C', 416, 20),(8323, 'H', 416, 22),(6838, 'P', 417, 1),(6837, 'O', 417, 8),(6836, 'N', 417, 2),(6835, 'C', 417, 9),(6834, 'H', 417, 11),(6608, 'P', 419, 1),(6607, 'O', 419, 5),(6606, 'C', 419, 3),(6605, 'H', 419, 7),(6135, 'S', 420, 1),(6134, 'O', 420,  -1),(15173, 'S', 421, 1),(6310, 'O', 422, 2),(6309, 'C', 422, 3),(6308, 'H', 422, 2),(6345, 'Se', 423, 1),(18694, 'Mo', 424, 1),(18693, 'S', 424, 4),(18692, 'P', 424, 4),(18691, 'O', 424, 26),(18690, 'N', 424, 20),(18689, 'C', 424, 40),(18688, 'H', 424, 47),(20027, 'O', 425, 2),(15253, 'O', 426, 1),(15252, 'C', 426, 8),(15251, 'H', 426, 14),(15639, 'O', 535, 4),(16103, 'HexNAc', 428, 1),(16102, 'P', 428, 1),(16101, 'O', 428, 3),(16100, 'H', 428, 1),(16089, 'Hex', 429, 1),(16088, 'P', 429, 1),(16087, 'O', 429, 3),(16086, 'H', 429, 1),(10927, 'O', 431, 1),(10926, 'C', 431, 16)

My best guess at this point was that maybe Brick did not exist. I wiped the slate clean (stop container, remove database folder, and then re-create). I hit another issue with some Crossreference URLs being longer than 128 chars, so I swapped to a TEXT type column from the original VARYING: https://github.com/radusuciu/pyteomics/commit/35ff6dc007f70b83d81772df1d03c2d6fd739b28

Then, I deleted all the postgres data and re-created the container once more, only to hit a new error:

postgres_1  | 2021-05-27 21:58:45.570 UTC [84] ERROR:  insert or update on table "Crossreference" violates foreign key constraint "Crossreference_source_id_fkey"
postgres_1  | 2021-05-27 21:58:45.570 UTC [84] DETAIL:  Key (source_id)=(2) is not present in table "CrossreferenceSource".
postgres_1  | 2021-05-27 21:58:45.570 UTC [84] STATEMENT:  INSERT INTO "Crossreference" (id, source_id, url, modification_id, text) VALUES (4843, 2, '', 53, '11327326'),(4844, 13, '', 53, 'Poli G, Schaur RJ., IUBMB Life 2000 Oct-Nov;50(4-5):315-21'),(2612, 13, '', 17, 'Krutzsch and Inman, Analytical Biochemistry, 209, 109-116, (1993)'),(2849, 2, '', 55, '3083866'),(4654, 2, '', 56, '11857757'),(4655, 2, '', 56, '11999733'),(4656, 2, '', 56, '12175151'),(4657, 13, '', 56, 'Controlling Deuterium isotope effects in comparative proteomics.     Zhang, Roujian; Sioma, Cathy S.; Thompson, Robert A.; Xiong, Li; Regnier, Fred E..    Department of Chemistry,  Purdue University,  West Lafayette,  IN,  USA.    Analytical Chemistry  (2'),(3202, 7, '', 299, 'AA0114'),(3201, 16, '', 299, 'GGLU'),(3200, 7, '', 299, 'AA0363'),(4762, 13, '', 58, 'Comparative proteomics based on stable isotope labeling and affinity selection.     Regnier, Fred E.; Riggs, Larry; Zhang, Roujian; Xiong, Li; Liu, Peiran; Chakraborty, Asish; Seeley, Erin; Sioma, Cathy; Thompson, Robert A.    Department of Chemistry,  Pu'),(2461, 13, '', 59, 'Comparative proteomics based on stable isotope labeling and affinity selection.     Regnier, Fred E.; Riggs, Larry; Zhang, Roujian; Xiong, Li; Liu, Peiran; Chakraborty, Asish; Seeley, Erin; Sioma, Cathy; Thompson, Robert A.    Department of Chemistry,  Pu'),(2616, 13, '', 64, 'Controlling Deuterium isotope effects in comparative proteomics.     Zhang, Roujian; Sioma, Cathy S.; Thompson, Robert A.; Xiong, Li; Regnier, Fred E..    Department of Chemistry,  Purdue University,  West Lafayette,  IN,  USA.    Analytical Chemistry  (2'),(2627, 13, '', 65, 'Controlling Deuterium isotope effects in comparative proteomics.     Zhang, Roujian; Sioma, Cathy S.; Thompson, Robert A.; Xiong, Li; Regnier, Fred E..    Department of Chemistry,  Purdue University,  West Lafayette,  IN,  USA.    Analytical Chemistry  (2'),(2623, 13, '', 66, 'Controlling Deuterium isotope effects in comparative proteomics.     Zhang, Roujian; Sioma, Cathy S.; Thompson, Robert A.; Xiong, Li; Regnier, Fred E..    Department of Chemistry,  Purdue University,  West Lafayette,  IN,  USA.    Analytical Chemistry  (2'),(6061, 2, '', 4, '11510821'),(2788, 14, 'http://www.chemsoc.org/exemplarchem/entries/2002/proteomics/icat.htm', 105, 'ICAT page from the Royal Society of Chemistry'),(2791, 14, 'http://docs.appliedbiosystems.com/pebiodocs/04333373.pdf', 106, 'Cleavable ICAT Reagent Kit for Protein Labeling'),(2702, 7, '', 107, 'AA0021'),(2796, 4, '', 139, 'dansyl chloride [605-65-2]'),(4314, 13, '', 140, 'D. Suckau, A. Resemann, Anal. Chem., 75(21):5817-24 (2003)'),(2406, 15, '', 327, '2005 ASMS poster Presentation TP 527'),(5502, 13, '', 329, 'Identifying and quantifying in vivo methylation sites by heavy methyl SILAC, Shao-En Ong et al., Nature methods 1(2) 2004, 1-8'),(2725, 14, 'http://www2.waters.com/watprod.nsf/newdocs/930494', 194, 'Waters Application Note 930494'),(2607, 2, '', 185, '12716131'),(3637, 13, '', 188, 'Ong, S-E, I. Kratchmarova, and M. Mann (2003). J Proteome Research 2: 173-181'),(4069, 14, 'http://etd.caltech.edu/etd/available/etd-09132005-120123/unrestricted/Chapter2.pdf', 895, 'Page 12 Scheme 1: (1) Structure of azidohomoalanine (2) Biotin-PEO-alkyne in our case PEO n=3 as in this publication'),(1673, 2, '', 368, '11212008'),(1676, 2, '', 360, '9252331'),(3307, 14, '', 353, 'http://www.piercenet.com/Proteomics/browse.cfm?fldID=84EBE112-F871-4CA5-807F-47327153CFCB'),(1773, 7, '', 352, 'AA0121'),(1774, 16, '', 352, 'ALLYS'),(4343, 7, '', 2, 'AA0088'),(6138, 7, '', 1, 'AA0048'),(3317, 13, '', 350, 'Berlett, Barbara S.; Stadtman, Earl R. Journal of Biological Chemistry (1997), 272(33), 20313-20316.'),(2782, 13, '', 261, 'Wang et al. 2004. Rapid Commun Mass Spectrom. 18(1):96-102'),(2468, 2, '', 94, '11746907'),(2478, 13, 'http://dx.doi.org/10.1002/rcm.517', 95, 'Rapid Communications in Mass Spectrometry, Volume 15, Issue 24 , Pages 2387 - 2392'),(5919, 14, 'https://www.thermofisher.com/us/en/home/references/molecular-probes-the-handbook/crosslinking-and-photoactivatable-reagents/chemical-crosslinking-reagents.html#head2', 323, 'The Molecular Probes Handbook'),(3259, 14, 'http://www.piercenet.com/Proteomics/browse.cfm?fldID=84EBE112-F871-4CA5-807F-47327153CFCB', 289, 'Introduction to Protein Labeling'),(2681, 13, '', 293, 'Peirce MJ, Wait R, Begum S, Saklatvala J, Cope AP (2004) Mol Cell Proteomics 3: 56-65'),(3313, 14, '', 357, 'http://www.piercenet.com/Proteomics/browse.cfm?fldID=84EBE112-F871-4CA5-807F-47327153CFCB'),(2984, 13, '', 476, 'J. Mass Spectrom. 2005; 40: 238-249'),(2446, 13, '', 319, 'Uchida K, Sakai K, Itakura K, Osawa T, Toyokuni S. 1977. Protein modification by lipid peroxidation products: formation of malondialdehyde-derived N(epsilon)-(2-propenol)lysine in proteins. Arch Biochem Biophys. 346(1):45-52'),(2694, 15, '', 285, 'ASMS 2005: Panchaud et al. (Poster ThP 509) ''''Combining protein identification and quantitation: C-terminal isotope-coded tagging'''''),(4594, 2, '', 335, '11910026'),(1920, 13, '', 337, 'Rapid Commun. Mass Spectrom. 2002; 16: 999-1001'),(3283, 7, '', 122, 'AA0211'),(3282, 2, '', 122, '15799070'),(1675, 13, '', 360, 'Berlett, Barbara S.; Stadtman, Earl R. Journal of Biological Chemistry (1997), 272(33), 20313-20316.'),(3312, 14, '', 361, 'http://www.piercenet.com/Proteomics/browse.cfm?fldID=84EBE112-F871-4CA5-807F-47327153CFCB'),(3209, 12, '', 11, 'Donald Voet, Judith G. Voet (1995): Biochemistry; p 115'),(3892, 7, '', 27, 'AA0031'),(1772, 2, '', 352, '9252331'),(1771, 2, '', 352, '11120890'),(6809, 2, '', 7, '6838602'),(6808, 7, '', 7, 'AA0214'),(5090, 13, '', 170, 'Anal. Biochem. 1992, 205:151-158'),(4991, 14, 'http://www.pil.sdu.dk/silac_intro.htm', 262, 'Silac introduction'),(1904, 13, '', 351, 'Berlett, Barbara S.; Stadtman, Earl R. Journal of Biological Chemistry (1997), 272(33), 20313-20316.'),(4342, 7, '', 2, 'AA0087'),(3919, 7, '', 401, 'AA0183'),(3920, 13, '', 401, 'Berlett, Barbara S.; Stadtman, Earl R. Journal of Biological Chemistry (1997), 272(33), 20313-20316.'),(3277, 2, '', 193, '11467524'),(4719, 2, '', 268, '12771378'),(3085, 14, 'http://www.pil.sdu.dk/silac_intro.htm', 267, 'Silac introduction'),(1921, 13, '', 359, 'Berlett, Barbara S.; Stadtman, Earl R. Journal of Biological Chemistry (1997), 272(33), 20313-20316.'),(1924, 2, '', 288, '7949339'),(2096, 16, '', 420, 'THIOG'),(3281, 7, '', 122, 'AA0021'),(3280, 16, '', 122, 'FORM'),(3279, 7, '', 122, 'AA0384'),(4970, 2, '', 127, '1093385'),(4684, 2, '', 254, '7744761'),(5177, 16, '', 36, 'DIMETH'),(5176, 7, '', 36, 'AA0311'),(6851, 16, '', 275, 'NTRY'),(5160, 2, '', 199, '14670044'),(6137, 7, '', 1, 'AA0049'),(6136, 7, '', 1, 'AA0041'),(2317, 14, 'http://www.indiana.edu/~reillyjp/ASMS2004/janecki_Ext-Abs%20Amidination.pdf', 141, 'ASMS 2004 abstract'),(2315, 2, '', 141, '12643539'),(2316, 2, '', 141, '6273432'),(5397, 16, '', 37, 'TRIMETH'),(4693, 2, '', 52, '11821862'),(4692, 14, 'http://www.indiana.edu/~reillyjp/ASMS2001posters/beardsley_poster.pdf', 52, 'ASMS 2001 abstract'),(4691, 2, '', 52, '11078590'),(6149, 2, '', 354, '8839040'),(6150, 2, '', 354, '9252331'),(6151, 13, '', 354, 'Berlett, Barbara S.; Stadtman, Earl R. Journal of Biological Chemistry (1997), 272(33), 20313-20316.'),(4659, 13, '', 56, 'Global internal standard technology for comparative proteomics.     Chakraborty, Asish; Regnier, Fred E..    Department of Chemistry,  Purdue University,  West Lafayette,  IN,  USA.    Journal of Chromatography, A  (2002),  949(1-2),  173-184.'),(4658, 13, '', 56, 'Comparative proteomics based on stable isotope labeling and affinity selection.     Regnier, Fred E.; Riggs, Larry; Zhang, Roujian; Xiong, Li; Liu, Peiran; Chakraborty, Asish; Seeley, Erin; Sioma, Cathy; Thompson, Robert A.    Department of Chemistry,  Pu'),(6155, 2, '', 345, '14678012'),(4846, 7, '', 162, 'AA0022'),(6154, 13, '', 345, 'Berlett, Barbara S.; Stadtman, Earl R. Journal of Biological Chemistry (1997), 272(33), 20313-20316.'),(6158, 2, '', 206, '15541752'),(6157, 2, '', 206, '10825247'),(4758, 2, '', 58, '12175151'),(4759, 2, '', 58, '11999733'),(4760, 2, '', 58, '11857757'),(4761, 13, '', 58, 'Global internal standard technology for comparative proteomics.     Chakraborty, Asish; Regnier, Fred E..    Department of Chemistry,  Purdue University,  West Lafayette,  IN,  USA.    Journal of Chromatography, A  (2002),  949(1-2),  173-184.'),(4757, 13, '', 58, 'Controlling Deuterium isotope effects in comparative proteomics.     Zhang, Roujian; Sioma, Cathy S.; Thompson, Robert A.; Xiong, Li; Regnier, Fred E..    Department of Chemistry,  Purdue University,  West Lafayette,  IN,  USA.    Analytical Chemistry  (2'),(6059, 2, '', 4, '12422359'),(6060, 13, '', 4, 'Boja, E. S., Fales, H. M., Anal. Chem. 73 3576-82 (2001)'),(2460, 13, '', 59, 'Global internal standard technology for comparative proteomics.     Chakraborty, Asish; Regnier, Fred E..    Department of Chemistry,  Purdue University,  West Lafayette,  IN,  USA.    Journal of Chromatography, A  (2002),  949(1-2),  173-184.'),(2459, 13, '', 59, 'Controlling Deuterium isotope effects in comparative proteomics.     Zhang, Roujian; Sioma, Cathy S.; Thompson, Robert A.; Xiong, Li; Regnier, Fred E..    Department of Chemistry,  Purdue University,  West Lafayette,  IN,  USA.    Analytical Chemistry  (2'),(2467, 13, 'http://dx.doi.org/10.1002/rcm.517', 94, 'Rapid Communications in Mass Spectrometry, Volume 15, Issue 24 , Pages 2387 - 2392'),(2474, 2, '', 253, '11283024'),(2477, 14, 'http://www.chem.agilent.com/cag/lystag.asp', 95, 'Agilent Lys Tag 4H Reagent Kit'),(2481, 2, '', 200, '11507762'),(2482, 2, '', 303, '12442261'),(2596, 2, '', 211, '12766232'),(2597, 2, '', 371, '11743741'),(2598, 2, '', 178, '12216740'),(5869, 14, 'https://tools.thermofisher.com/content/sfs/manuals/MAN0011280_DTSSP_DSP_UG.pdf', 126, 'ThermoFisher data sheet'),(2606, 13, '', 185, 'Ong, S-E, I. Kratchmarova, and M. Mann (2003). J Proteome Research 2: 173-181'),(2609, 2, '', 212, '12766232'),(2610, 2, '', 260, '12110917'),(2611, 13, '', 17, 'Galvani et.al. (2000) Electrophoresis vol 22 p2046-p2074'),(2615, 13, '', 64, 'Comparative proteomics based on stable isotope labeling and affinity selection.     Regnier, Fred E.; Riggs, Larry; Zhang, Roujian; Xiong, Li; Liu, Peiran; Chakraborty, Asish; Seeley, Erin; Sioma, Cathy; Thompson, Robert A.    Department of Chemistry,  Pu'),(2620, 13, '', 136, 'Julka,S.Regnier,F.E Anal Chem. 2004 Oct 1;76(19):5799-806.'),(2622, 13, '', 66, 'Comparative proteomics based on stable isotope labeling and affinity selection.     Regnier, Fred E.; Riggs, Larry; Zhang, Roujian; Xiong, Li; Liu, Peiran; Chakraborty, Asish; Seeley, Erin; Sioma, Cathy; Thompson, Robert A.    Department of Chemistry,  Pu'),(2626, 13, '', 65, 'Comparative proteomics based on stable isotope labeling and affinity selection.     Regnier, Fred E.; Riggs, Larry; Zhang, Roujian; Xiong, Li; Liu, Peiran; Chakraborty, Asish; Seeley, Erin; Sioma, Cathy; Thompson, Robert A.    Department of Chemistry,  Pu'),(2632, 2, '', 31, '11760118'),(5617, 13, 'http://www.jbc.org/cgi/content/abstract/M800402200v1', 121, 'Grou et al., J Biol Chem. 2008 Mar 22; Epub'),(2638, 2, '', 25, '9276974'),(2639, 12, '', 264, 'Manfredo Quadroni in: ''''Proteome Research: Mass Spectrometry (ed. P.James)'''' pp 187-206'),(2643, 14, 'http://www.chemistry.ucsc.edu/~fink/231/Image118.gif', 108, 'reaction'),(2651, 2, '', 129, '2026710'),(2650, 2, '', 129, '15627961'),(4380, 2, '', 29, '10446193'),(4381, 13, '', 29, 'Sherman, N. E., Yates, N. A., Shabanowitz, J., Hunt, D. F., Jeffery, W. A., Bartlet-Jones, M., and Pappin, D. J. C. (1995) Proceedings of the 43rd ASMS Conference on Mass Spectrometry and Allied Topics, May 21-26, 1995, Atlanta, GA'),(2657, 13, '', 60, 'Comparative proteomics based on stable isotope labeling and affinity selection.     Regnier, Fred E.; Riggs, Larry; Zhang, Roujian; Xiong, Li; Liu, Peiran; Chakraborty, Asish; Seeley, Erin; Sioma, Cathy; Thompson, Robert A.    Department of Chemistry,  Pu'),(2659, 13, '', 61, 'Comparative proteomics based on stable isotope labeling and affinity selection.     Regnier, Fred E.; Riggs, Larry; Zhang, Roujian; Xiong, Li; Liu, Peiran; Chakraborty, Asish; Seeley, Erin; Sioma, Cathy; Thompson, Robert A.    Department of Chemistry,  Pu'),(2976, 2, '', 186, '11698400'),(2975, 2, '', 186, '11914093'),(2663, 13, '', 62, 'Comparative proteomics based on stable isotope labeling and affinity selection.     Regnier, Fred E.; Riggs, Larry; Zhang, Roujian; Xiong, Li; Liu, Peiran; Chakraborty, Asish; Seeley, Erin; Sioma, Cathy; Thompson, Robert A.    Department of Chemistry,  Pu'),(2667, 13, '', 63, 'Comparative proteomics based on stable isotope labeling and affinity selection.     Regnier, Fred E.; Riggs, Larry; Zhang, Roujian; Xiong, Li; Liu, Peiran; Chakraborty, Asish; Seeley, Erin; Sioma, Cathy; Thompson, Robert A.    Department of Chemistry,  Pu'),(2680, 13, '', 293, 'Swaim CL, Smith JB, Smith DL (2004) J Am Soc Mass Spectrom 15:736-749'),(6204, 2, '', 295, '15189151'),(2703, 15, '', 286, 'ASMS 2005: Panchaud et al. (Poster ThP 509) ''''Combining protein identification and quantitation: C-terminal isotope-coded tagging'''''),(6203, 13, '', 295, 'Mormann, M., Macek, B., Gonzalez de Peredo, A., Hofsteenge, J., Peter-Katalinic, J. (2004). ''''Structural studies on protein O-fucosylation by electron capture dissoziation.'''' International Journal of Mass Spectrometry 234:11-21'),(6202, 2, '', 295, '11344537'),(3621, 2, '', 302, '15939799'),(2724, 2, '', 194, '14997490'),(4124, 2, '', 195, '15283597'),(6184, 13, '', 54, 'Lin, T.S. Kolattukudy, P.E., Eur. J. Biochem. 106, 341-351, 1980'),(2727, 2, '', 196, '15283597'),(2732, 13, '', 276, 'Biochim Biophys Acta. 1996 Feb 16; 1299(3):353-7'),(2739, 9, '', 42, 'PDOC00168'),(2740, 7, '', 42, 'AA0118'),(2742, 2, '', 301, '7856876'),(3300, 13, '', 343, 'Yoo, Byoung-Sam; Regnier, Fred E. Electrophoresis (2004), 25(9), 1334-1341.'),(2744, 2, '', 291, '10695144'),(2761, 2, '', 44, '15609361'),(2756, 13, '', 135, 'Neubert TA, Johnson RS, Hurley JB, Walsh KA (1992). The rod transducin alpha subunit amino terminus is heterogeneously fatty acylated. J Biol Chem. 267(26):18274-7.'),(2758, 13, '', 134, 'Neubert TA, Johnson RS, Hurley JB, Walsh KA (1992). The rod transducin alpha subunit amino terminus is heterogeneously fatty acylated. J Biol Chem. 267(26):18274-7.'),(2766, 9, '', 45, 'PDOC00008'),(2765, 7, '', 45, 'AA0059'),(2763, 7, '', 45, 'AA0307'),(2764, 7, '', 45, 'AA0078'),(2781, 13, '', 261, 'Chen et. al. Rapid Commun Mass Spectrom. 2004;18(2):191-8.'),(2780, 14, 'http://www.shimadzu-biotech.net/literature/application_note/202_1.pdf', 261, 'Shimadzu application note'),(2773, 2, '', 176, '9448752'),(2784, 2, '', 89, '9750125'),(2787, 14, 'https://products.appliedbiosystems.com/ab/en/US/adirect/ab?cmd=catNavigate2&catID=600902', 105, 'Applied Biosystems product page'),(2790, 14, 'https://products.appliedbiosystems.com/ab/en/US/adirect/ab?cmd=catNavigate2&catID=600902', 106, 'Applied Biosystems product page'),(2906, 7, '', 442, 'AA0350'),(2807, 7, '', 47, 'AA0080'),(2806, 7, '', 47, 'AA0079'),(2805, 7, '', 47, 'AA0106'),(3311, 13, '', 361, 'Yoo, Byoung-Sam; Regnier, Fred E. Electrophoresis (2004), 25(9), 1334-1341'),(3306, 13, '', 353, 'Yoo, Byoung-Sam; Regnier, Fred E. Electrophoresis (2004), 25(9), 1334-1341'),(4688, 2, '', 130, '15627961'),(3314, 2, '', 357, '15174056'),(2836, 7, '', 48, 'AA0104'),(2835, 2, '', 48, '15609361'),(4123, 2, '', 187, '11698400'),(3104, 14, 'http://www.targetdiscovery.com/index.php?topic=prod.idbe', 243, 'Under construction'),(2848, 2, '', 55, '8344916'),(2847, 7, '', 55, 'AA0229'),(4608, 14, 'http://www.piercenet.com/Proteomics/browse.cfm?fldID=84EBE112-F871-4CA5-807F-47327153CFCB', 116, 'Pierce introduction to biotin'),(4606, 14, 'http://www.piercenet.com/Proteomics/browse.cfm?fldID=84EBE112-F871-4CA5-807F-47327153CFCB', 117, 'Pierce introduction to biotin'),(2852, 13, '', 119, 'J. Biol. Chem 2002 vol277 pp17048-17056'),(5582, 2, '', 292, '11567090'),(5581, 2, '', 292, '11112526'),(5580, 2, '', 292, '6540775'),(2857, 2, '', 294, '10906242'),(2862, 14, 'http://www.wzw.tum.de/proteomik/forum2003/Posters-Abstracts.pdf', 90, 'Poster abstract P-48'),(2871, 13, '', 123, 'Silverman, Harbury,  J. Biol. Chem.  2002, 277, 34, pp. 30968-30975'),(2874, 14, 'http://www.wzw.tum.de/proteomik/forum2003/Posters-Abstracts.pdf', 91, 'Poster abstract P-48'),(2875, 13, '', 124, 'Silverman, Harbury,  J. Biol. Chem.  2002, 277, 34, pp. 30968-30975'),(2878, 2, '', 270, '15549660'),(2882, 2, '', 131, '2026710'),(2881, 2, '', 131, '15627961'),(2883, 2, '', 271, '15549660'),(3273, 2, '', 20, '12038753'),(6082, 13, '', 128, 'Gorman, J. J., Eur. J. Biochem 1987, 168-9'),(3274, 13, 'http://www.jbc.org/cgi/content/full/278/7/4500#F1', 20, 'J. Biol. Chem., Vol. 278, Issue 7, 4500-4509, February 14, 2003'),(4401, 14, 'http://www.piercenet.com/Products/Browse.cfm?fldID=01031002', 290, 'EZ-Link Biotin-HPDP (N-(6-(Biotinamido)hexyl)-3''-(2''-pyridyldithio)-propionamide'),(2909, 14, 'http://www.chemsoc.org/exemplarchem/entries/2002/proteomics/images/icat_reagent.gif', 13, 'Structure'),(2908, 13, 'http://www.mcponline.org/cgi/content/full/2/7/428', 13, 'Molecular & Cellular Proteomics 2:428-442, 2003'),(2911, 14, 'http://www.chemsoc.org/exemplarchem/entries/2002/proteomics/images/icat_reagent.gif', 12, 'Structure'),(2910, 13, 'http://www.mcponline.org/cgi/content/full/2/7/428', 12, 'Molecular & Cellular Proteomics 2:428-442, 2003'),(2921, 2, '', 8, '10504701'),(2922, 13, '', 8, 'Gygi S.P., et. al. Nat Biotechnol. 1999 Oct;17(10):994-9'),(2923, 2, '', 9, '10504701'),(2924, 13, '', 9, 'Gygi S.P., et. al. Nat Biotechnol. 1999 Oct;17(10):994-9'),(3258, 14, 'http://www.piercenet.com/Products/Browse.cfm?fldID=01031005', 93, 'EZ-Link Maleimide PEOn-Biotin (n = 2 and 11)'),(5161, 12, '', 199, 'Jue-Liang Hsu, Sheng-Yu Huang, and Shu-Hui Chen. Stable-Isotope based Multiplex Labeling Coupled with LC-MS/MS, HUPO 3rd ANNUAL WORLD CONGRESS, Bejing (China) 2004'),(1672, 2, '', 372, '15489230'),(2701, 2, '', 107, '10825024'),(2244, 16, '', 529, 'DIMETP'),(6153, 2, '', 345, '9252331'),(1775, 7, '', 374, 'AA0025'),(3389, 7, '', 312, 'AA0025'),(1742, 7, '', 28, 'AA0031'),(3891, 13, '', 27, 'Miller et.al. Arch. Biochem. Biophy. (1993) 301, 41-52.'),(6739, 7, '', 21, 'AA0036'),(6738, 14, 'http://www.ionsource.com/Card/phos/phos.htm', 21, 'IonSource'),(6737, 7, '', 21, 'AA0037'),(6134, 7, '', 1, 'AA0052'),(6135, 7, '', 1, 'AA0364'),(6850, 2, '', 275, '10442087'),(2094, 2, '', 342, '9252331'),(3494, 8, '', 528, 'P02942'),(5175, 7, '', 36, 'AA0068'),(5174, 2, '', 36, '14570711'),(3493, 16, '', 528, 'DEAME'),(5424, 7, '', 34, 'AA0105'),(5423, 2, '', 34, '11875433'),(5422, 7, '', 34, 'AA0072'),(5421, 7, '', 34, 'AA0299'),(5173, 7, '', 36, 'AA0067'),(5420, 7, '', 34, 'AA0337'),(4845, 2, '', 162, '12148805'),(2760, 7, '', 44, 'AA0102'),(2774, 7, '', 376, 'AA0103'),(2936, 7, '', 377, 'AA0107'),(3199, 7, '', 299, 'AA0032'),(2599, 7, '', 379, 'AA0116'),(2741, 16, '', 42, 'LIPY'),(2793, 12, '', 46, 'Biochemistry; D.Voet and J.G.Voet WILEY(p728)'),(2832, 7, '', 380, 'AA0120'),(1770, 13, '', 352, 'Berlett, Barbara S.; Stadtman, Earl R. Journal of Biological Chemistry (1997), 272(33), 20313-20316.'),(2090, 7, '', 381, 'AA0122'),(1704, 7, '', 382, 'AA0127'),(3187, 2, '', 26, '12643538'),(2621, 2, '', 136, '15456300'),(2940, 7, '', 387, 'AA0258'),(2941, 7, '', 388, 'AA0132'),(2938, 7, '', 389, 'AA0133'),(2948, 7, '', 390, 'AA0329'),(2925, 7, '', 391, 'AA0142'),(2956, 7, '', 50, 'AA0143'),(2955, 14, 'http://www.aw-bc.com/mathews/EF/FAD.GIF', 50, 'Structure'),(2954, 7, '', 50, 'AA0144'),(2246, 7, '', 392, 'AA0147'),(2245, 7, '', 392, 'AA0148'),(2865, 7, '', 49, 'AA0150'),(6709, 7, '', 41, 'AA0217'),(5274, 7, '', 393, 'AA0153'),(5632, 13, 'http://dx.doi.org/10.1021/acs.analchem.6b05064', 43, 'Global and Site-Specific Analysis Revealing Unexpected and
postgres_1  |   Extensive Protein S‑GlcNAcylation in Human Cells'),(6706, 7, '', 41, 'AA0152'),(2960, 7, '', 395, 'AA0167'),(2743, 7, '', 396, 'AA0170'),(5524, 13, 'http://dx.doi.org/10.1021/ac902778d', 1322, 'Anal. Chem., 2010, 82 (7), pp 2817–2825'),(4668, 2, '', 340, '9033387'),(4667, 7, '', 340, 'AA0174'),(4666, 7, '', 340, 'AA0175'),(4665, 7, '', 340, 'AA0176'),(4664, 7, '', 340, 'AA0173'),(2919, 7, '', 397, 'AA0177'),(2942, 7, '', 398, 'AA0178'),(4663, 7, '', 340, 'AA0180'),(4662, 7, '', 340, 'AA0179'),(1665, 7, '', 400, 'AA0181'),(4661, 16, '', 340, 'BROM'),(3890, 2, '', 27, '8442665'),(3918, 7, '', 401, 'AA0185'),(1750, 7, '', 403, 'AA0186'),(3025, 2, '', 506, '15650407'),(7029, 7, '', 405, 'AA0371'),(3316, 14, 'http://www.lbqp.unb.br/bioq/htm/aulas2D/deg_aa_ile_leu_trp.htm?reload_coolmenus', 350, 'Degradation of the amino acids Isoleucine, Leucine and Tryptophan'),(2683, 7, '', 407, 'AA0207'),(3278, 7, '', 122, 'AA0057'),(5207, 7, '', 408, 'AA0212'),(6705, 2, '', 41, '15279557'),(2915, 7, '', 409, 'AA0353'),(2953, 7, '', 50, 'AA0145'),(2949, 7, '', 410, 'AA0223'),(7028, 7, '', 405, 'AA0227'),(2870, 7, '', 413, 'AA0325'),(6849, 7, '', 275, 'AA0230'),(4736, 13, '', 39, 'J. A. Kowalak and K. A. Walsh, Protein Science (1996) 5: 1625-1632'),(5419, 7, '', 34, 'AA0317'),(2248, 7, '', 414, 'AA0236'),(2974, 7, '', 415, 'AA0248'),(3164, 7, '', 416, 'AA0252'),(2851, 7, '', 417, 'AA0256'),(2939, 7, '', 387, 'AA0131'),(2690, 7, '', 419, 'AA0264'),(2095, 7, '', 420, 'AA0265'),(7027, 7, '', 405, 'AA0203'),(4973, 7, '', 421, 'AA0269'),(5418, 7, '', 34, 'AA0273'),(5417, 7, '', 34, 'AA0234'),(2473, 7, '', 422, 'AA0287'),(2472, 7, '', 422, 'AA0274'),(2947, 7, '', 390, 'AA0135'),(2498, 7, '', 423, 'AA0277'),(5456, 7, '', 424, 'AA0375'),(6114, 2, '', 425, '9252331'),(2471, 7, '', 422, 'AA0275'),(4993, 7, '', 426, 'AA0290'),(2733, 2, '', 276, '8597590'),(5315, 7, '', 428, 'AA0296'),(5313, 7, '', 429, 'AA0297'),(3194, 16, '', 23, 'DHAS'),(1705, 16, '', 382, 'PYRUC'),(3198, 2, '', 299, '3802193'),(5416, 7, '', 34, 'AA0073'),(2951, 14, 'http://commons.wikimedia.org/wiki/Image:Coenzyme_a.png', 281, 'Structure'),(2879, 7, '', 432, 'AA0309'),(5172, 2, '', 36, '12964758'),(2831, 7, '', 433, 'AA0312'),(2841, 7, '', 434, 'AA0316'),(5415, 7, '', 34, 'AA0070'),(2247, 16, '', 392, 'TOPA'),(2945, 7, '', 436, 'AA0324'),(2869, 7, '', 413, 'AA0228'),(6704, 16, '', 41, 'GLUC'),(2884, 7, '', 437, 'AA0328'),(2946, 7, '', 390, 'AA0276'),(2207, 7, '', 438, 'AA0333'),(2868, 7, '', 439, 'AA0334'),(2375, 7, '', 440, 'AA0335'),(5414, 7, '', 34, 'AA0071'),(5413, 7, '', 34, 'AA0076'),(2842, 16, '', 434, 'CHDH'),(2837, 16, '', 48, 'GERA'),(2905, 7, '', 442, 'AA0349'),(2917, 7, '', 443, 'AA0351'),(2914, 7, '', 409, 'AA0220'),(2913, 7, '', 409, 'AA0352'),(4737, 7, '', 39, 'AA0320'),(4738, 2, '', 39, '8844851'),(2961, 7, '', 444, 'AA0355'),(2465, 7, '', 445, 'AA0359'),(4835, 13, 'http://dx.doi.org/10.1021/ac902778d', 1321, 'Anal. Chem., 2010, 82 (7), pp 2817–2825'),(4834, 7, '', 40, 'AA0172'),(4833, 2, '', 40, '14752058'),(3917, 2, '', 401, '9252331'),(7026, 7, '', 405, 'AA0267'),(1749, 7, '', 447, 'AA0191'),(2959, 7, '', 448, 'AA0374'),(5455, 7, '', 424, 'AA0281'),(5171, 7, '', 36, 'AA0075'),(2692, 7, '', 449, 'AA0387'),(2691, 7, '', 449, 'AA0385'),(6186, 2, '', 54, '7398618'),(5779, 13, '', 455, 'Hand, E.S., and Jencks, W.P. (1962). Mechanism of the reaction of imidoesters with amines. J. Am. Chem. Soc. 84, 3505-3514.'),(3016, 13, '', 451, 'J. Biol. Chem., Vol. 277, Issue 48, 46140-46144, November 29, 2002'),(2093, 13, '', 342, 'Berlett, Barbara S.; Stadtman, Earl R. Journal of Biological Chemistry (1997), 272(33), 20313-20316.'),(3027, 2, '', 452, '12356754'),(3028, 13, '', 452, 'J. Biol. Chem., Vol. 277, Issue 48, 46140-46144, November 29, 2002'),(3033, 13, '', 453, 'J. Biol. Chem., Vol. 277, Issue 48, 46140-46144, November 29, 2002'),(2999, 2, '', 457, '2081203'),(3017, 2, '', 451, '12356754'),(3021, 2, '', 505, '15650407'),(6784, 14, 'https://assets.thermofisher.com/TFS-Assets/LSG/manuals/MAN0011314_ImidoesterCrsLnk_DMA_DMP_DMS_DTBP_UG.pdf', 456, 'Imidoester Cross-linkers'),(6783, 13, '', 456, 'Packman, L.C. and Perhan, R.N. (1982). Quaternary Structures the Pyruvate Dehydrogenase Multienzyme Complex of Bacillus StearothermophilusStudies by a New Reversible Crosslinking Procedure with Bis(imidoesters). Biochem. 21, 5171-5175.'),(5778, 13, '', 455, 'Packman, L.C. and Perhan, R.N. (1982). Quaternary Structures the Pyruvate Dehydrogenase Multienzyme Complex of Bacillus Stearothermophilus Studies by a New Reversible Crosslinking Procedure with Bis(imidoesters). Biochem. 21, 5171-5175.'),(5777, 14, 'http://tools.thermofisher.com/content/sfs/manuals/MAN0011314_ImidoesterCrsLnk_DMA_DMP_DMS_DTBP_UG.pdf', 455, 'Imidoester Cross-linkers'),(2776, 2, '', 464, '16526082'),(2777, 13, '', 464, 'Lee et al, Rapid Commun Mass Spetrom 2004, 18, 3019-3027'),(5169, 2, '', 510, '16335955'),(3684, 13, '', 472, 'Z. A. Knight et al, Nature Biotech., 21(9) 1047-1054 (2003)'),(2985, 13, '', 477, 'J. Mass Spectrom. 2005; 40: 238-249'),(2903, 13, '', 478, 'Ahn, B., Rhee, S.G., and Stadtmann, E. R. (1987) Anal. Biochem.'),(2983, 2, '', 488, '16222722'),(6065, 13, 'http://dx.doi.org/10.1016/j.cell.2011.08.008', 1363, 'Identification of 67 Histone Marks and Histone Lysine Crotonylation as a New Type of Histone Modification, Tan et al., Cell 146(6) 1016–1028 2011'),(3039, 15, '', 495, 'Amersham (GE Healthcare) instruction leaflet 25800983PL Rev-B, 2003'),(3026, 13, '', 493, 'Berger U, Oehme M, Girardin L., Fresenius J Anal Chem. 2001 Jan 2;369(2):115-23.'),(3096, 14, 'http://www.targetdiscovery.com/index.php?topic=prod.idbe', 499, 'Under construction'),(2970, 12, '', 320, 'Chemistry of Protein Conjugation and Crosslinking by Shan S. Wong, 1991, pg.32'),(2988, 12, '', 500, 'Chemistry of Protein Conjugation and Crosslinking by Shan S. Wong, 1991, pg.32'),(3001, 2, '', 498, '16533022'),(3295, 13, '', 503, 'Salomon RG. Antioxid Redox Signal. 2005 Jan-Feb;7(1-2):185-201.'),(3299, 13, '', 504, 'Salomon RG. Antioxid Redox Signal. 2005 Jan-Feb;7(1-2):185-201.'),(3020, 2, '', 505, '15752459'),(3024, 2, '', 506, '15752459'),(5500, 13, '', 284, 'Nature. 2004 Nov 18;432(7015):353-60. Epub 2004 Nov 03'),(3019, 13, '', 505, 'Salomon RG. Chem Phys Lipids. 2005 Mar;134(1):1-20.'),(3018, 13, '', 505, 'Salomon RG. Antioxid Redox Signal. 2005 Jan-Feb;7(1-2):185-201.'),(3023, 13, '', 506, 'Salomon RG. Chem Phys Lipids. 2005 Mar;134(1):1-20.'),(3022, 13, '', 506, 'Salomon RG. Antioxid Redox Signal. 2005 Jan-Feb;7(1-2):185-201.'),(3294, 13, '', 503, 'Salomon RG. Chem Phys Lipids. 2005 Mar;134(1):1-20.'),(3292, 2, '', 503, '15650407'),(3293, 2, '', 503, '15752459'),(3298, 13, '', 504, 'Salomon RG. Chem Phys Lipids. 2005 Mar;134(1):1-20.'),(3296, 2, '', 504, '15650407'),(3297, 2, '', 504, '15752459'),(6208, 13, '', 512, 'BIOCHIMECAL AND BIOPHYSICAL RESEARCH COMMUNICATIONS 236, 413-417 (1997)'),(6207, 13, '', 512, 'ANALYTICAL BIOCHEMISTRY 259, 152-161 (1998)'),(3355, 2, '', 513, '16771548'),(3014, 2, '', 450, '12356754'),(3015, 13, '', 450, 'J. Biol. Chem., Vol. 277, Issue 48, 46140-46144, November 29, 2002'),(5223, 2, '', 514, '15795231'),(3030, 2, '', 515, '9325338'),(3031, 2, '', 515, '11665566'),(3029, 14, 'http://probes.invitrogen.com/media/pis/mp00003.pdf', 515, 'Thiol-Reactive Probes'),(2980, 13, '', 518, 'J. Proteome Res. 2005, 4, 101-108.'),(4852, 13, '', 519, 'Pierce, A., Dewaal, E., Vanremmen, H., Richardson, A. & Chaudhuri, A. (2006). A Novel Approach for Screening the Proteome for Changes in Protein Conformation. Biochemistry 45, 3077-3085.'),(2982, 15, '', 520, 'Jue-Liang Hsu, Sheng-Yu Huang, and Shu-Hui Chen. Stable-Isotope based Multiplex Labeling Coupled with LC-MS/MS, HUPO 3rd ANNUAL WORLD CONGRESS, Bejing (China) 2004'),(2700, 2, '', 107, '8758896'),(4399, 14, 'http://www.piercenet.com/Products/Browse.cfm?fldID=01031005', 522, 'EZ-Link Maleimide PEOn-Biotin'),(5381, 14, 'http://pubs.acs.org/doi/abs/10.1021/bi062142x', 92, 'Patricelli et al. (2007). Functional Interrogation of the Kinome Using Nucleotide Acyl Phosphates. Biochemistry, 46, 350-358.'),(4398, 14, 'http://www.piercenet.com/Products/Browse.cfm?fldID=8D38BA83-EFDC-421A-853F-E96EBA380612', 523, 'EZ-Link Sulfo-NHS-Biotin Reagents'),(1664, 2, '', 313, '16078144'),(1735, 2, '', 526, '9004526'),(3320, 13, '', 344, 'Berlett, Barbara S.; Stadtman, Earl R. Journal of Biological Chemistry (1997), 272(33), 20313-20316.'),(3321, 13, 'http://www.pnas.org/cgi/content/full/98/1/69', 344, 'Jesus Requena, Chien-Chung Chao, Rodney L. Levine, and Earl R. Stadtman, Glutamic and aminoadipic semialdehydes are the main carbonyl products of metal-catalyzed oxidation of proteins, PNAS 98 69-74 (2001)'),(3319, 2, '', 344, '9252331'),(3241, 13, '', 369, 'Berlett, Barbara S.; Stadtman, Earl R. Journal of Biological Chemistry (1997), 272(33), 20313-20316.'),(3193, 7, '', 23, 'AA0303'),(3192, 7, '', 23, 'AA0302'),(3191, 7, '', 23, 'AA0181'),(3631, 7, '', 385, 'AA0127'),(3630, 16, '', 385, 'PYRUS'),(3190, 7, '', 23, 'AA0182'),(3189, 16, '', 23, 'DHB'),(1743, 16, '', 28, 'PYRR'),(1748, 2, '', 447, '14235557'),(1747, 7, '', 447, 'AA0373'),(4341, 7, '', 2, 'AA0086'),(4340, 7, '', 2, 'AA0085'),(4339, 7, '', 2, 'AA0084'),(4338, 7, '', 2, 'AA0083'),(4337, 7, '', 2, 'AA0082'),(4336, 7, '', 2, 'AA0081'),(4335, 7, '', 2, 'AA0089'),(4334, 7, '', 2, 'AA0090'),(4333, 7, '', 2, 'AA0091'),(4332, 7, '', 2, 'AA0092'),(4331, 7, '', 2, 'AA0093'),(4330, 7, '', 2, 'AA0094'),(4329, 7, '', 2, 'AA0095'),(4328, 7, '', 2, 'AA0096'),(4327, 7, '', 2, 'AA0097'),(4326, 7, '', 2, 'AA0098'),(4325, 7, '', 2, 'AA0099'),(1873, 2, '', 258, '11467524'),(4324, 7, '', 2, 'AA0100'),(1905, 2, '', 351, '9252331'),(3642, 13, '', 184, 'Ong, S-E, I. Kratchmarova, and M. Mann (2003). J Proteome Research 2: 173-181'),(3087, 14, 'http://www.pil.sdu.dk/silac_intro.htm', 269, 'Silac introduction'),(1922, 2, '', 359, '9252331'),(1923, 2, '', 359, '10717661'),(5412, 7, '', 34, 'AA0272'),(5411, 7, '', 34, 'AA0305'),(5410, 7, '', 34, 'AA0336'),(5409, 7, '', 34, 'AA0069'),(5408, 7, '', 34, 'AA0065'),(5407, 7, '', 34, 'AA0063'),(5406, 7, '', 34, 'AA0061'),(5405, 7, '', 34, 'AA0064'),(5404, 7, '', 34, 'AA0338'),(5403, 7, '', 34, 'AA0318'),(5402, 16, '', 34, 'METH'),(6055, 7, '', 35, 'AA0027'),(6054, 2, '', 35, '11461766'),(6053, 7, '', 35, 'AA0029'),(6052, 7, '', 35, 'AA0028'),(6051, 7, '', 35, 'AA0030'),(6050, 2, '', 35, '9004526'),(6049, 7, '', 35, 'AA0205'),(6116, 13, '', 425, 'Berlett, Barbara S.; Stadtman, Earl R. Journal of Biological Chemistry (1997), 272(33), 20313-20316.'),(6115, 7, '', 425, 'AA0282'),(6112, 7, '', 425, 'AA0370'),(6111, 16, '', 425, 'DIHYDR'),(6110, 16, '', 425, 'MSONE'),(6109, 16, '', 425, 'CSIA'),(6104, 2, '', 425, '12686488'),(6105, 7, '', 425, 'AA0262'),(6131, 7, '', 1, 'AA0056'),(6132, 7, '', 1, 'AA0046'),(6133, 7, '', 1, 'AA0051'),(6130, 7, '', 1, 'AA0045'),(6129, 7, '', 1, 'AA0354'),(6128, 7, '', 1, 'AA0044'),(6127, 7, '', 1, 'AA0043'),(6126, 2, '', 1, '11999733'),(4735, 14, 'http://www.trc-canada.com/white_papers.lasso', 39, 'TRC data sheet'),(6062, 13, '', 4, 'Creasy, D. M., Cottrell, J. S., Proteomics 2 1426-34 (2002)'),(2462, 2, '', 59, '11857757'),(2463, 2, '', 59, '12175151'),(2464, 2, '', 59, '11999733'),(2466, 16, '', 445, 'TRIMETK'),(2469, 14, 'http://www.chem.agilent.com/cag/lystag.asp', 94, 'Agilent Lys Tag 4H Reagent Kit'),(2470, 14, 'http://www.chem.agilent.com/cag/other/IMTHUPO2003.pdf', 94, 'Poster: Kelly Zhang, Gordon Nicol, Nina Zolotarjova, Cory Szafranski, Jerome Bailey, Liang-Sheng Yang, and Barry Boyes'),(2479, 2, '', 95, '11746907'),(2480, 14, 'http://www.chem.agilent.com/cag/other/IMTHUPO2003.pdf', 95, 'Poster: Kelly Zhang, Gordon Nicol, Nina Zolotarjova, Cory Szafranski, Jerome Bailey, Liang-Sheng Yang, and Barry Boyes'),(6736, 7, '', 21, 'AA0033'),(6735, 7, '', 21, 'AA0038'),(2600, 16, '', 379, 'HYPU'),(5872, 2, '', 126, '322714'),(2608, 14, 'http://www.pil.sdu.dk/silac_intro.htm', 185, 'Silac introduction'),(2613, 2, '', 17, '8465942'),(2614, 2, '', 17, '11465505'),(2617, 2, '', 64, '12175151'),(2618, 2, '', 64, '11857757'),(2619, 7, '', 64, 'AA0130'),(2624, 2, '', 66, '11857757'),(2625, 2, '', 66, '12175151'),(2628, 2, '', 65, '11857757'),(2629, 2, '', 65, '12175151'),(3958, 14, 'http://www.bdal.de/life-science-tools/care-consumables-more/icpl-kit.html', 365, 'Bruker Daltonics order reference'),(3962, 14, 'http://www.bdal.de/life-science-tools/care-consumables-more/icpl-kit.html', 364, 'Bruker Daltonics order reference'),(3251, 7, '', 394, 'AA0158'),(2644, 2, '', 108, '12777388'),(2645, 2, '', 108, '11813307'),(2648, 7, '', 435, 'AA0321'),(2649, 16, '', 435, 'PYRK'),(4992, 7, '', 426, 'AA0386'),(2658, 2, '', 60, '11857757'),(2660, 2, '', 61, '11857757'),(2664, 2, '', 62, '11857757'),(2668, 2, '', 63, '11857757'),(5429, 7, '', 375, 'AA0040'),(6179, 14, 'http://docs.appliedbiosystems.com/pebiodocs/04351918.pdf', 532, 'Applied Biosystems Chemistry Reference Guide'),(6171, 14, 'http://docs.appliedbiosystems.com/pebiodocs/04351918.pdf', 533, 'Applied Biosystems Chemistry Reference Guide'),(2682, 2, '', 293, '15121203'),(3658, 2, '', 172, '12845591'),(2693, 16, '', 449, 'DECA'),(2704, 2, '', 286, '9254591'),(2723, 13, '', 194, 'Hochleitner, E. O. et al, Proteomics 2004, 4, 669-676,'),(2738, 2, '', 42, '3522581'),(2757, 2, '', 135, '1326520'),(2759, 2, '', 134, '1326520'),(2762, 16, '', 44, 'FARN'),(2767, 16, '', 45, 'MYRI'),(2778, 2, '', 261, '14745769'),(2779, 2, '', 261, '14689565'),(2775, 16, '', 376, 'FAR0'),(2783, 2, '', 261, '16526082'),(6063, 7, '', 3, 'AA0117'),(2789, 14, 'http://docs.appliedbiosystems.com/pebiodocs/04333373.pdf', 105, 'Cleavable ICAT Reagent Kit for Protein Labeling'),(2792, 14, 'http://www.chemsoc.org/exemplarchem/entries/2002/proteomics/icat.htm', 106, 'ICAT page from the Royal Society of Chemistry'),(2794, 7, '', 46, 'AA0119'),(2795, 16, '', 46, 'PLP'),(4110, 7, '', 431, 'AA0308'),(2804, 7, '', 47, 'AA0077'),(2808, 16, '', 47, 'PALM'),(2809, 7, '', 47, 'AA0339'),(2810, 7, '', 47, 'AA0060'),(3250, 7, '', 394, 'AA0159'),(3249, 7, '', 394, 'AA0160'),(3248, 7, '', 394, 'AA0161'),(3247, 7, '', 394, 'AA0162'),(3246, 7, '', 394, 'AA0163'),(3245, 7, '', 394, 'AA0164'),(3244, 7, '', 394, 'AA0165'),(3243, 7, '', 394, 'AA0166'),(2850, 16, '', 55, 'GLUT'),(2853, 2, '', 119, '11861642'),(2866, 16, '', 49, 'PPAN'),(2872, 2, '', 123, '12185208'),(2876, 2, '', 124, '12185208'),(2880, 16, '', 432, 'CHOL'),(6081, 2, '', 128, '3578767'),(6080, 4, '', 128, '5-iodoacetamidofluorescein, [63368-54-7]'),(2907, 16, '', 442, 'FMN'),(2916, 16, '', 409, 'FMNH'),(2918, 16, '', 443, 'FMNC'),(2920, 16, '', 397, 'THRN'),(2937, 16, '', 377, 'DIAC'),(2943, 16, '', 398, 'THRX'),(2950, 16, '', 410, 'ARCH'),(2952, 7, '', 281, 'AA0306'),(2957, 7, '', 50, 'AA0221'),(2958, 16, '', 50, 'FAD'),(3034, 2, '', 453, '12356754'),(4953, 2, '', 494, '12872219'),(3040, 2, '', 495, '12872219'),(4397, 14, 'http://www.caymanchem.com/pdfs/10141.pdf', 538, 'Cayman Chemical data sheet'),(4396, 14, 'http://www.caymanchem.com/pdfs/10013.pdf', 539, 'Cayman Chemical data sheet'),(4092, 7, '', 402, 'AA0185'),(4093, 16, '', 402, 'OXOAC'),(4094, 13, '', 402, 'Dierks T, Miech C, Hummerjohann J, Schmidt B, Kertesz MA, von Figura K. Posttranslational formation of formylglycine in prokaryotic sulfatases by modification of either cysteine or serine. J. Biol. Chem. 1998; 273: 25 560'),(3046, 2, '', 51, '10356335'),(5392, 7, '', 37, 'AA0062'),(5393, 7, '', 37, 'AA0074'),(5394, 2, '', 37, '12590383'),(5395, 13, '', 37, 'Zhang, K. et al. 2004. Differentiation between peptides containing acetylated or tri-methylated lysines by mass spectrometry: an application for determining lysine 9 acetylation and methylation of histone H3. Proteomics 4:1-10.'),(5170, 7, '', 36, 'AA0066'),(3636, 14, 'http://www.pil.sdu.dk/silac_intro.htm', 188, 'Silac introduction'),(3641, 14, 'http://www.pil.sdu.dk/silac_intro.htm', 184, 'Silac introduction'),(5093, 2, '', 259, '12716131'),(3086, 2, '', 267, '12716131'),(3088, 2, '', 269, '12771378'),(3103, 15, '', 243, 'Target discovery , Inc. IDBEST IGBP user manual'),(3095, 15, '', 499, 'Target discovery , Inc. IDBEST IGBP user manual'),(3188, 13, '', 26, 'J. Proteome Res. 1, 181-187 (2002)'),(4682, 2, '', 5, '12203680'),(3150, 14, 'http://www.targetdiscovery.com/article.php?topic=crpc.prst&story=20060321132643690', 684, 'Isotope-differentiated binding energy shift tags'),(3151, 13, '', 685, 'JBC 281(29):20450-63; 2006'),(3152, 13, '', 686, 'JBC 281(29):20450-63; 2006'),(3957, 13, '', 365, 'Schmidt A, Kellermann J, Lottspeich F (2005): A novel strategy for quantitative proteomics using isotope-coded protein labels. Proteomics 5: 4-15.'),(3963, 13, '', 364, 'Schmidt A, Kellermann J, Lottspeich F (2005): A novel strategy for quantitative proteomics using isotope-coded protein labels. Proteomics 5: 4-15'),(3629, 7, '', 385, 'AA0129'),(3203, 7, '', 299, 'AA0304'),(6048, 13, '', 35, 'Lagerwerf FM, van de Weert M, Heerma W, Haverkamp J, Rapid Commun Mass Spectrom. 1996;10(15):1905-10'),(6047, 7, '', 35, 'AA0146'),(6042, 16, '', 35, 'DOPA'),(3242, 2, '', 369, '9252331'),(3272, 2, '', 20, '15253424'),(4734, 7, '', 39, 'AA0232'),(3284, 7, '', 122, 'AA0384'),(3960, 14, 'http://www.bdal.de/life-science-tools/care-consumables-more/icpl-kit.html', 687, 'Bruker Daltonics order reference'),(3301, 2, '', 343, '15828771'),(3315, 13, '', 357, 'Yoo, Byoung-Sam; Regnier, Fred E. Electrophoresis (2004), 25(9), 1334-1341'),(3318, 2, '', 350, '9252331'),(3322, 2, '', 344, '1680314'),(6046, 7, '', 35, 'AA0215'),(6043, 16, '', 35, 'CSEA'),(6044, 7, '', 35, 'AA0026'),(6045, 2, '', 35, '14661084'),(3640, 14, 'http://www.pil.sdu.dk/silac_intro.htm', 695, 'Silac introduction'),(3639, 13, '', 695, 'Ong, S-E, I. Kratchmarova, and M. Mann (2003). J Proteome Research 2: 173-181'),(3647, 14, 'http://www.pil.sdu.dk/silac_intro.htm', 696, 'Silac introduction'),(5106, 13, 'http://www.nature.com/nbt/journal/v22/n4/abs/nbt947.html', 697, 'Nature Biotechnology  22, 450 - 454 (2004)'),(5671, 2, '15648052', 735, 'Proteomics. 2005 Feb;5(2):388-98.  Links rnQuantitative analysis of both protein expression and serine / threonine post-translational modifications through stable isotope labeling with dithiothreitol.Vosseller K, Hansen KC, Chalkley RJ, Trinidad JC, Wells L, Hart GW, Burlingame AL.'),(5109, 13, 'http://www.nature.com/nbt/journal/v22/n4/abs/nbt947.html', 698, 'Nature Biotechnology  22, 450 - 454 (2004)'),(3495, 13, '', 528, 'Anal Chem. 2007 Jan 15;79(2):673-81.'),(3445, 13, '', 272, 'Anal.Chem 75(7):156A-165A'),(3446, 2, '', 272, '15732931'),(3447, 2, '', 272, '16046801'),(3490, 13, '', 721, 'Chemico-Biological Interactions 143-144(2003) 93-100.'),(3475, 13, '', 723, 'Fidder, Hulst, Noort, Ruiter, van der Schans, Benschop and Langenberg; Retrospective detection of exposure to organophosphorus anti-cholinesterases:  Mass spectrometric analysis of phosphylated human butyrylcholinestease.  Chem. Res. Toxicol. 15, 582-590 (2002)'),(4400, 13, '', 333, 'Higson, Ferguson and Nikolaev; Synthesis of 6-N-biotinylaminohexyl isopropyl phosphorofluoridate:  A potent tool for the inhibition/isolation of serine esterases and proteases.  Synthesis 3, 407-409 (1999)'),(4792, 13, '', 725, 'Zhang, D. M.; Liu, H. X.; Zhang, S. S.; Chen, X. L.; Li, S. F.; Zhang, C. L.; Hu, X. M.; Bi, K. S.; Chen, X. H.; Jiang, Y. Y. An effective method for de novo peptide sequencing based on phosphorylation strategy and mass spectrometry. Talanta 2011, 84, 614-622.'),(4013, 2, '', 886, '12595094'),(4226, 13, '', 325, 'Liu, Patricelli and Cravatt; Activity-based protein profiling:  The serine hydrolases.  Proc Natl Acad Sci USA 96, 14694-14699 (1999)'),(4287, 13, '', 727, 'Fidder, Hulst, Noort, Ruiter, van der Schans, Benschop and Langenberg; Retrospective detection of exposure to organophosphorus anti-cholinesterases:  Mass spectrometric analysis of phosphylated human butyrylcholinestease.  Chem. Res. Toxicol. 15, 582-590 (2002)'),(3476, 13, '', 729, 'Fidder, Hulst, Noort, Ruiter, van der Schans, Benschop and Langenberg; Retrospective detection of exposure to organophosphorus anti-cholinesterases:  Mass spectrometric analysis of phosphylated human butyrylcholinestease.  Chem. Res. Toxicol. 15, 582-590 (2002)'),(3480, 13, '', 363, 'Main;  Mode of action of anticholnesterases.  Pharmac Ther 6, 579-628 (1979)'),(3487, 13, '', 724, 'Main;  Mode of action of anticholnesterases.  Pharmac Ther 6, 579-628 (1979)'),(3485, 13, '', 728, 'Main;  Mode of action of anticholnesterases.  Pharmac Ther 6, 579-628 (1979)'),(3491, 13, '', 720, 'Liu Z, Minkler P, and Sayre L.  Chem. Res. Toxicology 2003 16 901-911'),(5669, 2, '17116471', 735, 'Methods Enzymol. 2006;415:113-33.  Links rnIdentification of O-GlcNAc sites on proteins.Whelan SA, Hart GW.'),(5670, 2, '12438562', 735, 'Mol Cell Proteomics. 2002 Oct;1(10):791-804.  rnMapping sites of O-GlcNAc modification using affinity tags for serine and threonine post-translational modifications.Wells L, Vosseller K, Cole RN, Cronshaw JM, Matunis MJ, Hart GW.'),(5666, 2, '12438562', 736, 'Mol Cell Proteomics. 2002 Oct;1(10):791-804.  Mapping sites of O-GlcNAc modification using affinity tags for serine and threonine post-translational modifications.Wells L, Vosseller K, Cole RN, Cronshaw JM, Matunis MJ, Hart GW.'),(5664, 2, '17116471', 736, 'Methods Enzymol. 2006;415:113-33.  Links rnIdentification of O-GlcNAc sites on proteins.Whelan SA, Hart GW.'),(5665, 2, '16452088', 736, 'Mol Cell Proteomics. 2006 May;5(5):923-34. Epub 2006 Feb 1.  Links rnO-linked N-acetylglucosamine proteomics of postsynaptic density preparations using lectin weak affinity chromatography and mass spectrometry.Vosseller K, Trinidad JC, Chalkley RJ, Specht CG, Thalhammer A, Lynn AJ, Snedecor JO, Guan S, Medzihradszky KF, Maltby DA, Schoepfer R, Burlingame AL.'),(5139, 15, '', 738, 'Juergen.Schaefer@Proteomics.com'),(4768, 15, '', 739, 'Juergen.Schaefer@Proteomics.com'),(6070, 14, 'http://www.perkinelmer.com/exactag', 740, 'PerkinElmer ExacTag product page'),(6071, 14, 'http://www.perkinelmer.com/exactag', 741, 'PerkinElmer ExacTag product page'),(3569, 13, '', 743, 'Liu. Z., Minkler, P. E., and Sayre, L. M.  Chem. Res. Toxico. 2003, 16, 901-911.'),(3583, 13, '', 744, 'Naisbitt, D. J., O''Neill, P. M., Pirohamed, M., and Park, B. K.  1996.  Bioorganic and Medicinal Chemistry Letters 6(13):1511-1516.'),(3585, 13, '', 745, 'Naisbitt, D. J., O''Neill, P. M., Pirohamed, M., and Park, B. K.  1996.  Bioorganic and Medicinal Chemistry Letters 6(13):1511-1516.'),(3584, 13, '', 746, 'Naisbitt, D. J., O''Neill, P. M., Pirohamed, M., and Park, B. K.  1996.  Bioorganic and Medicinal Chemistry Letters 6(13):1511-1516.'),(3626, 13, '', 762, 'Analytical Chemistry (2000) 72 6 1112-1118'),(5672, 2, '', 763, '15648052'),(5673, 13, '', 763, 'Vosseller K, Hansen KC, Chalkley RJ, Trinidad JC, Wells L, Hart GW, Burlingame AL. Proteomics. 2005 5(2):388-98.  Quantitative analysis of both protein expression and serine / threonine post-translational modifications through stable isotope labeling with dithiothreitol.'),(3625, 13, '', 765, 'Biochemistry (1987) 26 8242-8246'),(5667, 13, '', 764, 'Vosseller K, Hansen KC, Chalkley RJ, Trinidad JC, Wells L, Hart GW, Burlingame AL. Proteomics. 2005 5(2):388-98. Quantitative analysis of both protein expression and serine / threonine post-translational modifications through stable isotope labeling with dithiothreitol.'),(3624, 2, '', 765, '3327521'),(3622, 2, '', 766, '3327521'),(3623, 13, '', 766, 'Biochemistry (1987) 26 8242-8246'),(3627, 2, '', 762, '10740847'),(3628, 2, '', 767, '15939799'),(3632, 16, '', 385, 'OXOB'),(3661, 13, 'http://dx.doi.org/10.1021/bi048228c', 771, 'Biochemistry 2005 vol 44 pp 1833-1845'),(3638, 2, '', 188, '12716131'),(3643, 2, '', 184, '12716131'),(3644, 13, '', 772, 'Ong, S-E, I. Kratchmarova, and M. Mann (2003). J Proteome Research 2: 173-181'),(3645, 14, 'http://www.pil.sdu.dk/silac_intro.htm', 772, 'Silac introduction'),(3646, 2, '', 772, '12716131'),(3648, 14, 'http://www.isotope.com/cil/products/displayproduct.cfm?prod_id=8635', 696, 'CDNLM-6810'),(3660, 13, '', 171, 'Rapid Communications in Mass Spectrometry, 17, 1642-1650 (2003)'),(3659, 2, '', 171, '12845591'),(3657, 13, '', 172, 'Rapid Communications in Mass Spectrometry, 17, 1642-1650 (2003)'),(3686, 14, 'http://www.chemistry.ucsc.edu/~fink/231/Image118.gif', 776, 'reaction'),(3687, 2, '', 776, '12777388'),(3688, 2, '', 776, '11813307'),(4548, 13, '', 348, 'Berlett, Barbara S.; Stadtman, Earl R. Journal of Biological Chemistry (1997), 272(33), 20313-20316.'),(4550, 13, '', 349, 'Berlett, Barbara S.; Stadtman, Earl R. Journal of Biological Chemistry (1997), 272(33), 20313-20316.'),(6125, 12, '', 1, 'Chemical Reagents for Protein Modification 3rd edition, pp 215-221, Roger L. Lundblad, CRC Press, New York, N.Y., 2005'),(4945, 15, 'https://www.gelifesciences.com/gehcls_images/GELS/Related%20Content/Files/1314742967685/litdocPA63100PL_Rev_C_2006_web_20110831004625.pdf', 821, 'GE Life Science data sheet'),(6694, 13, '', 827, 'Sadagopan, N. and Watson, J. T., Journal of the American Society For Mass Spectrometry 11 107-119 (2000)'),(3889, 13, 'http://dx.doi.org/10.1002/jms.1144', 830, 'J. Mass. Spectrom.  2007; 42:89-100.'),(5787, 14, 'http://tools.thermofisher.com/content/sfs/manuals/MAN0011308_Bismaleimide_CrsLnk_BMOE_BMB_BMH_UG.pdf', 824, 'ThermoFisher data sheet'),(5788, 14, 'http://tools.thermofisher.com/content/sfs/manuals/MAN0011313_DFDNB_UG.pdf', 825, 'Pierce data sheet'),(5789, 15, '', 825, 'Chen, X., et al. (1999). Anal. Biochem. 273, 192-203.'),(5790, 15, '', 825, 'Kornblatt, J.A. and Lake, D.F. (1980). Crosslinking of cytochrome oxidase subunits with difluorodinitrobenzene. Can J. Biochem. 58, 219-224.'),(4351, 15, '', 822, 'Richmond, T., Baggerman, G., Vandekerckhove, T., Menschaert, G., Husson, S., Verleyen, P., Schoofs, L., Van Criekinge, W. (2008). Bioinformatic Strategies for More Complete and Accurate Identification of Neuropeptides. . ASMS Conference on Mass Spectrometry. Denver, Colorado, USA, June 1-5 2008.'),(3895, 13, 'http://dx.doi.org/10.1016/j.ijms.2004.06.004', 775, 'B. Schilling, C.B. Yoo, C.J. Collins, B.W. Gibson, Determining Cysteine Oxidation Status Using Differential Alkylation, Int. J. Mass Spectrom., 2004, 236 (1-3), 117-121'),(4394, 14, 'http://www.piercenet.com/products/browse.cfm?fldID=C4FE82D4-DD06-493C-8EC4-9C1D7F83211B', 811, 'Pierce product page'),(3706, 4, '', 774, '4-bromophenacyl bromide [99-73-0]'),(3707, 2, '', 774, '428399'),(6124, 14, 'http://www.ionsource.com/Card/acetylation/acetylation.htm', 1, 'IonSource acetylation tutorial'),(6123, 7, '', 1, 'AA0055'),(6121, 2, '', 1, '14730666'),(6122, 2, '', 1, '15350136'),(6209, 13, '', 793, 'Saito T., Itoh T.; Journal of dairy Science, 75 (1992). p1768.'),(5345, 13, '', 149, 'Saito T., Itoh T.; Journal of dairy Science, 75 (1992). p1768.'),(6201, 13, '', 160, 'Saito T., Itoh T.; Journal of dairy Science, 75 (1992). p1768.'),(5186, 14, 'http://www.piercenet.com/Products/Browse.cfm?fldID=01031206', 800, 'Pierce EZ-Link Pentylamine-Biotin'),(5101, 13, 'http://dx.doi.org/10.1021/pr0255708', 799, 'Ong, S-E, I. Kratchmarova, and M. Mann (2003). J Proteome Research 2: 173-181'),(5100, 13, 'http://dx.doi.org/10.1038/nbt849', 799, 'Peng J, Schwartz D, Elias JE, Thoreen CC, Cheng D, Marsischky G, Roelofs J, Finley D, Gygi SP.
postgres_1  |   Nat Biotechnol. 2003 Aug;21(8):921-6'),(3871, 13, '', 835, 'Ong, S-E, I. Kratchmarova, and M. Mann (2003). J Proteome Research 2: 173-181'),(3870, 14, 'http://www.pil.sdu.dk/silac_intro.htm', 835, 'Silac introduction'),(3868, 14, 'http://www.pil.sdu.dk/silac_intro.htm', 836, 'Silac introduction'),(3869, 2, '', 836, '12716131'),(3872, 2, '', 835, '12716131'),(5616, 13, 'http://www.ncbi.nlm.nih.gov/pubmed/17502423', 121, 'Wang et al., J Cell Biol. 2007 May 21;177(4):613-24'),(5614, 2, '', 121, '12872131'),(5615, 14, 'http://www.nottingham.ac.uk/biochemcourses/students/ub/ubindex.html', 121, 'The Ubiquitin System for Protein Modification and Degradation'),(3881, 13, 'http://www.jbc.org/cgi/reprint/258/1/203.pdf', 837, 'JBC 258(1) 203-207 1983'),(4022, 2, '', 848, '11945751'),(4039, 15, 'http://products.invitrogen.com/ivgn/en/US/adirect/invitrogen?cmd=catProductDetail&entryPoint=adirect&productID=D10253&messageType=catProductDetail&showAddButton=true', 887, 'technical resources at Molecular Probes'),(4742, 14, 'http://www3.appliedbiosystems.com/cms/groups/psm_support/documents/generaldocuments/cms_054141.pdf', 888, 'Applied Biosystems mTRAQ(TM) Reagents'),(4070, 13, 'http://www.sciencedirect.com/science?_ob=ArticleURL&_udi=B6T64-4B6C6T5-D&_user=616146&_rdoc=1&_fmt=&_orig=search&_sort=d&view=c&_acct=C000032323&_version=1&_urlVersion=0&_userid=616146&md5=b526a97bcf2d86ccddd5f602e2bcb53a', 895, 'Drug Discovery Today Volume 8, Issue 24, 15 December 2003, Pages 1128-1137 Figure 4 page 1335'),(6177, 13, 'https://dx.doi.org/10.1021%2Fac100775s', 214, 'Anal Chem. 2011 Feb 1; 83(3): 701–707'),(4745, 14, 'http://www3.appliedbiosystems.com/cms/groups/psm_support/documents/generaldocuments/cms_054141.pdf', 889, 'Applied Biosystems mTRAQ(TM) Reagents'),(3885, 13, 'http://dx.doi.org/10.1021/pr050451o', 846, 'Wohlschlegel, J. A. et al., J Proteome Res. 5 761 2006'),(3893, 16, '', 27, 'PYRE'),(4108, 13, '', 851, 'Nat Chem Biol. 3: 727-735, 2007'),(4107, 2, '', 851, '17906641'),(5104, 2, '', 864, '12716131'),(5105, 14, 'http://www.pil.sdu.dk/silac_intro.htm', 864, 'Silac introduction'),(3930, 2, '', 859, '15377717'),(3981, 13, '', 866, 'Schmidt A, Kellermann J, Lottspeich F (2005): A novel strategy for quantitative proteomics using isotope-coded protein labels. Proteomics 5: 4-15.'),(3931, 2, '', 860, '17143934'),(3921, 7, '', 401, 'AA0365'),(3922, 16, '', 401, 'OXOAS'),(3923, 16, '', 401, 'DHY'),(3924, 2, '', 401, '15705169'),(3983, 14, 'http://www.zdye.com/', 861, 'Created for Commercial use by ZDye.  Being utilized in proteomic and peptidomic research soon to be published'),(3947, 14, 'http://www.pil.sdu.dk/silac_intro.htm', 862, 'Silac introduction'),(3959, 13, '', 687, 'Schmidt A, Kellermann J, Lottspeich F (2005): A novel strategy for quantitative proteomics using isotope-coded protein labels. Proteomics 5: 4-15'),(3961, 2, '', 687, '15602776'),(3982, 14, 'http://probes.invitrogen.com/handbook/sections/0104.html', 878, 'Invitrogen BODIPY Handbook'),(4043, 14, 'http://www.piercenet.com/files/1768dh5.pdf', 891, 'Pierce data sheet'),(4048, 2, 'http://www.ncbi.nlm.nih.gov/pubmed/18653769', 894, '18653769'),(4393, 14, 'http://www.piercenet.com/Products/Browse.cfm?fldID=44B1F9DF-B306-4278-B292-6CDB5B3B9D53', 884, 'Thermo Scientific (Pierce) Product 21325'),(4225, 13, '', 325, 'Schopfer, Champion, Tamblyn, Thompson and Lockridge;  Characteristic mass spectral fragments of the organophosphorus agent FP-biotin and FP-biotinylated peptides from trypsin and bovine albumin (Tyr410).  Anal Biochem 345, 122-132 (2005)'),(4020, 2, '', 848, '11698400'),(4021, 2, '', 848, '5723461'),(3980, 14, 'http://www.bdal.de/life-science-tools/care-consumables-more/icpl-kit.html', 866, 'Bruker Daltonics order reference'),(4044, 14, 'http://www.piercenet.com/files/1964as4.pdf', 890, 'Pierce data sheet'),(4067, 2, '', 896, '16281315'),(4068, 2, '', 896, '11752401'),(4195, 2, '', 898, '17873058'),(4199, 13, 'http://www.biochemj.org/bj/344/0109/bj3440109.htm', 949, 'Biochem. J. (1999) 344  (109–116)'),(4091, 13, 'http://pubs.acs.org/doi/pdf/10.1021/ja992749j', 899, 'DOI: 10.1021/ja992749j
postgres_1  |   Efficient incorporation of unsaturated methionine analogues into proteins in vivo'),(4713, 14, 'http://www.pil.sdu.dk/silac_intro.htm', 897, 'Silac introduction'),(5095, 2, '', 901, '18275052'),(4095, 2, '', 402, '18722427'),(4096, 2, '', 402, '17450134'),(5389, 14, 'http://www.abrf.org/index.cfm/dm.details?DMID=226&AvgMass=all&Margin=0', 907, 'ABRF Delta Mass'),(5912, 14, 'https://assets.thermofisher.com/TFS-Assets/LSG/manuals/MAN0011295_SMCC_SulfoSMCC_UG.pdf', 908, 'ThermoFisher data sheet'),(6693, 13, 'http://dx.doi.org/10.1021/ac061670b', 827, 'Weibin Chen et. al., Anal. Chem.2007, 79,1583-1590'),(5067, 13, '', 849, 'Nat Chem Biol. 3: 727-735, 2007'),(4109, 2, '', 851, '15063129'),(4111, 16, '', 431, 'PALE'),(4112, 2, '', 431, '17141155'),(6222, 2, 'http://www.jbc.org/cgi/content/full/277/45/42530?view=long&pmid=12186869', 910, '12186869'),(5167, 13, '', 330, 'Triplex protein quantification based on stable isotope labeling by peptide dimethylation applied to cell and tissue lysates. Boersema PJ, Aye TT, van Veen TA, Heck AJ, Mohammed S. Proteomics. 2008 Nov;8(22):4624-32'),(4605, 14, 'http://themedicalbiochemistrypage.org/nitrogen-metabolism.html', 117, 'Nitrogen metabolism'),(4131, 2, 'http://www.ncbi.nlm.nih.gov/pubmed/19054759?ordinalpos=2&itool=EntrezSystem2.PEntrez.Pubmed.Pubmed_ResultsPanel.Pubmed_DefaultReportPanel.Pubmed_RVDocSum', 912, '19054759'),(4119, 2, '', 911, '9335564'),(4120, 2, '', 911, '12441112'),(4389, 13, 'http://pubs.acs.org/doi/abs/10.1021/ja9012134', 914, 'Bifunctional Acyltransferase/Decarboxylase LnmK as the Missing Link for beta-Alkylation in Polyketide Biosynthesis, J. Am. Chem. Soc., 2009, 131 (20), pp 6900-6901'),(5102, 2, '', 923, '12716131'),(5103, 14, 'http://www.pil.sdu.dk/silac_intro.htm', 923, 'Silac introduction'),(4171, 15, 'http://www.sigmaaldrich.com/etc/medialib/docs/Sigma/Datasheet/6/41022dat.Par.0001.File.tmp/41022dat.pdf', 935, 'Sigma datasheet'),(4172, 13, 'http://dx.doi.org/10.1016/j.cplett.2007.06.017', 935, 'Fluorescence depletion mechanisms in super-resolving STED microscopy'),(4910, 13, 'http://pubs.acs.org/doi/abs/10.1021/ac0481250', 931, 'Effects of Tryptic peptide esterification in MALDI mass spectrometry Anal. Chem. 2005, 77, 4185-4193'),(5426, 2, '', 280, '9629898'),(5427, 13, 'http://pubs.acs.org/doi/abs/10.1021/ac0481250', 280, 'Effects of tryptic peptide esterification in MALDI mass spectrometry Anal. Chem. 2005, 77, 4185-4193'),(6119, 2, '', 936, '14660678'),(4191, 13, '', 941, 'Fontana A. Methods Enzymol 25 482-494 (1972)'),(4197, 14, 'http://www.piercenet.com/files/1763dh4.pdf', 942, 'Pierce data sheet'),(5089, 2, '', 937, '11733505'),(4192, 13, '', 941, 'Fontana A. Biochemistry. vol 7. 971-979 and 980-986 (1968)'),(4190, 13, '', 941, 'Fontana A. Biochemical and biophysical research communications. vol. 25 (2). 170-174 (1966)'),(4376, 13, 'http://dx.doi.org/10.1074/mcp.M900268-MCP200', 934, 'Enrichment and site-mapping of O-Linked N-Acetylglucosamine by a combination of chemical/enzymatic tagging, photochemical cleavage, and electron transfer dissociation (ETD) mass spectrometry'),(5560, 14, 'http://tools.thermofisher.com/content/sfs/manuals/MAN0011551_GMBS_SulfoGMBS_UG.pdf', 943, 'Pierce data sheet'),(4545, 2, '10413514', 948, 'Boutaud O, Brame CJ, Salomon RG, Roberts LJ 2nd, Oates JA., Characterization of the lysyl adducts formed from prostaglandin H2 via the levuglandin pathway. Biochemistry. 1999 Jul 20;38(29):9389-96.'),(4546, 2, '10413514', 946, 'Boutaud O, Brame CJ, Salomon RG, Roberts LJ 2nd, Oates JA. Characterization of the lysyl adducts formed from prostaglandin H2 via the levuglandin pathway. Biochemistry. 1999 Jul 20;38(29):9389-96.'),(6893, 2, '', 947, '10413514'),(4379, 2, '', 957, '18448829'),(5094, 2, '', 901, '19798718'),(4266, 2, '', 972, '18925771'),(4267, 2, '', 971, '18925771'),(4273, 2, '', 973, '10666460'),(4786, 13, '', 362, 'Main; Mode of action of anticholinesterases.  Pharmac Ther 6, 579-628 (1979)'),(4787, 13, '', 362, 'Grigoryan, Li, Xue, Grigoryan, Schopfer and Lockridge; Mass spectral characterization of organophosphate-labeled lysine in peptides.  Analytical Biochemistry 394, 92-100 (2009)'),(4227, 2, '', 325, '10611275'),(4228, 13, '', 325, 'Grigoryan, Li, Xue, Grigoryan, Schopfer and Lockridge; Mass spectral characterization of organophosphate-labeled lysine in peptides.  Analytical Biochemistry 394, 92-100 (2009)'),(4681, 13, '', 5, 'Stark; Modification of proteins with cyanate. Meth Enz 25B, 579-584 (1972)'),(4680, 7, '', 5, 'AA0343'),(4678, 2, '', 5, '10978403'),(4679, 7, '', 5, 'AA0332'),(4264, 13, '', 977, 'Li, Ricordel, Tong, Schopfer, Baud, Megarbane, Maury, Masson and Lockridge; Carbofuran poisoning detected by mass spectrometry of butyrylcholinesterase adduct in human serum.  J Applied Toxicol 29, 149-155 (2009)'),(4677, 13, '', 5, 'Smyth; Carbamylation of amino and tyrosine hydroxyl groups. J Biol Chem 242, 1579-1591 (1967)'),(5871, 2, '', 126, '3155470'),(5870, 2, '', 126, '957432'),(4263, 13, 'http://pubs.acs.org/doi/full/10.1021/jf9019085', 981, 'glucosone'),(4301, 14, 'http://www.pil.sdu.dk/silac_intro.htm', 987, 'SILAC Introduction'),(4299, 16, '', 986, 'DIMETH'),(4300, 14, 'http://www.pil.sdu.dk/silac_intro.htm', 986, 'SILAC introduction'),(5147, 15, '', 984, 'John.C.Rogers@thermo.com'),(6067, 13, '', 278, 'J Biol Chem. 1995 Apr 28;270(17):10017-26.'),(6068, 13, '', 278, 'A simplified procedure for the reduction and alkylation of cysteine residues in proteins prior to proteolytic digestion and mass spectral analysis. Hale JE, Butler JP, Gelfanova V, You JS, Knierman MD. Anal Biochem. 2004 Oct 1;333(1):174-81'),(6066, 2, '', 278, '15351294'),(4298, 2, 'http://www.ncbi.nlm.nih.gov/pubmed/14670044?dopt=AbstractPlus', 986, 'Stable-isotope dimethyl labeling for quantitative proteomics'),(4302, 16, '', 987, 'DIMETH'),(5396, 14, 'http://pir.georgetown.edu/resid/faq.shtml#q12', 37, 'Explanation of why RESID gives the delta as 43 Da'),(4313, 2, '', 140, '14588022'),(4391, 15, 'http://www.sigmaaldrich.com/catalog/DataSheetPage.do?brandKey=SIGMA&symbol=B1267', 993, 'Datasheet for Sigma Aldrich product.'),(4710, 2, '', 994, '19664813'),(4711, 2, '', 995, '19664813'),(4712, 2, '', 996, '19664813'),(4344, 16, '', 2, 'AMID'),(4345, 2, '', 2, '14588022'),(5388, 2, 'http://www.ncbi.nlm.nih.gov/pubmed/743239?ordinalpos=1&itool=EntrezSystem2.PEntrez.Pubmed.Pubmed_ResultsPanel.Pubmed_DefaultReportPanel.Pubmed_RVDocSum', 907, '743239'),(4352, 13, '', 822, 'Bradbury, A.F. and D.G. Smyth, Peptide amidation. Trends Biochem Sci, 1991. 16(3): p. 112-5.'),(5866, 2, '', 126, '8457554'),(5867, 2, '', 126, '11710128'),(4375, 13, '', 1000, 'Dieterich DC et al., (2007) Labelling, detection and identification of newly synthesized proteomes with bioorthogonal non-canonical amino acid tagging. Nature Protocols 2(3): 532-40'),(4374, 13, '', 1001, 'Dieterich DC et al., (2007) Labeling, detection and identification of newly synthesized proteomes with bioorthogonal non-canonical amino acid tagging. Nature Protocols 2(3): 532-40.'),(4405, 2, '', 1002, '18771724'),(4404, 2, '', 1003, '18771724'),(5446, 2, '', 1008, '18283440'),(4390, 14, 'http://products.invitrogen.com/ivgn/product/M1602?ICID=search-m1602', 1012, 'Invitrogen data sheet'),(4392, 2, '', 993, '15449375'),(4402, 13, 'http://dx.doi.org/10.1016/j.aca.2010.10.042', 24, 'C.-H. Feng, C.-Y. Lu, Analytica Chimica Acta 684 (2011) 80–86'),(4403, 13, 'http://dx.doi.org/10.1016/j.aca.2010.10.042', 1014, 'C.-H. Feng, C.-Y. Lu, Analytica Chimica Acta 684 (2011) 80–86'),(4409, 15, 'http://www.emdchemicals.com/life-science-research/fmoc-epsilon-ahx-oh/EMD_BIO-852053/p_uuid?WT_oss=852053&WT_oss_r=1', 1015, 'Ahx residues were incroporated by Fmoc synthesis, the reagent has a part number of 852053.'),(4472, 2, '', 1017, '18160050'),(4471, 2, '', 1017, '17637042'),(4412, 13, 'http://dx.doi.org/10.1002/anie.201007175', 1018, 'Quantification of Protein Sulfenic Acid Modifications Using Isotope-Coded Dimedone and Iododimedone'),(4413, 13, 'http://dx.doi.org/10.1002/anie.201007175', 1019, 'Quantification of Protein Sulfenic Acid Modifications Using Isotope-Coded Dimedone and Iododimedone'),(5390, 14, 'http://www.cancerci.com/content/1/1/3', 37, 'Role of arginine and its methylated derivatives in cancer biology and treatment'),(5391, 13, '', 37, 'J. Hirota et. al., Rapid Commun. Mass Spectrom., 17 371-6 (2003)'),(5714, 2, 'http://www.ncbi.nlm.nih.gov/pubmed?term=8326953', 1020, '8326953'),(5718, 2, 'http://www.ncbi.nlm.nih.gov/pubmed?term=A%20new%20cleavable%20reagent%20for%20cross-linking%20and%20reversible%20immobilization%20of%20proteins', 1021, '36892'),(5797, 2, 'http://www.ncbi.nlm.nih.gov/pubmed/212103', 1022, '212103'),(5798, 14, 'https://assets.thermofisher.com/TFS-Assets/LSG/manuals/MAN0011282_DST_UG.pdf', 1022, 'ThermoFisher data sheet'),(5809, 14, 'https://tools.thermofisher.com/content/sfs/manuals/MAN0011280_DTSSP_DSP_UG.pdf', 1023, 'ThermoFisher data sheet'),(5808, 2, 'http://www.ncbi.nlm.nih.gov/pubmed/1262347', 1023, '1262347'),(5918, 2, 'http://www.ncbi.nlm.nih.gov/pubmed?term=6490581', 1024, '6490581'),(5454, 2, '', 1034, '18283440'),(6041, 13, '', 35, 'Berlett, Barbara S.; Stadtman, Earl R. Journal of Biological Chemistry (1997), 272(33), 20313-20316.'),(5775, 2, 'http://www.ncbi.nlm.nih.gov/pubmed?term=Macromolecular%20association%20of%20ADP-ribosyltransferase%20and%20its%20correlation%20with%20enzymic%20activity', 1027, '2144419'),(4487, 2, '', 1032, '16548032'),(5450, 14, 'http://www.chemistry.ucsc.edu/~fink/231/Image118.gif', 1033, 'reaction'),(5447, 2, '', 1033, '18283440'),(5776, 2, 'http://www.ncbi.nlm.nih.gov/pubmed?term=Chemical%20cross-linking%20and%20mass%20spectrometry%20for%20mapping%20three-dimensional%20structures%20of%20proteins%20and%20protein%20complexes', 1027, '14696200'),(5720, 2, 'http://www.ncbi.nlm.nih.gov/pubmed?term=a%20new%20cleavable%20reagent%20for%20cross-linking%20and%20reversible%20immobilization', 1028, '36892'),(5448, 2, '', 1033, '12777388'),(5449, 2, '', 1033, '11813307'),(5452, 2, '', 1034, '12777388'),(5453, 14, 'http://www.chemistry.ucsc.edu/~fink/231/Image118.gif', 1034, 'reaction'),(5451, 2, '', 1034, '11813307'),(6221, 13, 'http://dx.doi.org/10.1021/pr301219h', 213, 'Mapping PARP-1 auto-ADP-ribosylation sites by liquid chromatography-tandem mass spectrometry'),(5196, 13, '', 1031, 'Patricelli, M.P., et al. (2007). Functional interrogation of the kinome using nucleotide acyl phosphates. Biochemistry 46:350-8'),(5197, 14, 'http://www.lifetechnologies.com/order/catalog/product/88310', 1031, 'Kinase Enrichment Kits and Probes'),(5198, 14, 'http://www.lifetechnologies.com/order/catalog/product/88314', 1031, 'GTPase Enrichment Kit and Probes'),(4509, 2, 'http://www.ncbi.nlm.nih.gov/pubmed/21432907', 1036, 'PMID: 21432907'),(4510, 13, 'http://www.ripublication.com/ijna/ijnav4n2_12.pdf', 1036, 'Preparation of Withaferin-A loaded PLGA Nanoparticles by Modified Emulsion Diffusion Evaporation Technique'),(5203, 14, 'http://www.lifetechnologies.com/order/catalog/product/88317', 1037, 'Serine Hydrolase Probes'),(5204, 13, '', 1037, 'Liu, Patricelli and Cravatt. (1999) Activity-based protein profiling: The serine hydrolases. Proc Natl Acad Sci USA 96:14694-14699'),(4534, 14, 'http://www.piercenet.com/browse.cfm?fldID=0842EF3A-D867-AEA2-6E77-E84116CAA87C', 1038, 'Serine Hydrolase Probes'),(4533, 13, '', 1038, 'Liu, Patricelli and Cravatt. (1999) Activity-based protein profiling: The serine hydrolases. Proc Natl Acad Sci USA 96:14694-14699'),(4532, 13, '', 1038, 'Okerberg, E.S., et al. (2005). High-resolution functional proteomics by active-site peptide profiling. Proc Natl Acad Sci USA 102(14):4996-5001.'),(6807, 14, 'http://www.ionsource.com/Card/Deamidation/deamidation.htm', 7, 'IonSource tutorial'),(6806, 16, '', 7, 'CITR'),(6805, 7, '', 7, 'AA0128'),(6804, 16, '', 7, 'FLAC'),(4544, 15, 'http://www.piercenet.com/Products/Browse.cfm?fldID=01031005', 1039, 'Lab observation analagous to hydrolysis of N-Ethylmaleimide'),(4549, 2, '', 348, '9252331'),(4551, 2, '', 349, '9252331'),(4996, 15, 'http://www.piercenet.com/browse.cfm?fldID=23A2097D-0154-4B13-9D95-3F08AAD8B2C9', 1251, 'Sulfo-SBED Biotin Label Transfer Reagent and Kit'),(4555, 15, 'http://www.piercenet.com/browse.cfm?fldID=23A2097D-0154-4B13-9D95-3F08AAD8B2C9', 1252, 'Sulfo-SBED Biotin Label Transfer Reagent and Kit'),(4562, 13, '', 1249, 'J Am Chem Soc. 2010 Dec 29;132(51):18351-60. Epub 2010 Dec 8.
postgres_1  |   Cleavable biotin probes for labeling of biomolecules via azide-alkyne cycloaddition.
postgres_1  |   Szychowski J, Mahdavi A, Hodas JJ, Bagert JD, Ngo JT, Landgraf P, Dieterich DC, Schuman EM, Tirrell DA.'),(5182, 2, '', 1041, '20942800'),(5181, 2, '', 1041, '10542236'),(4560, 2, '', 1042, '20942800'),(4561, 2, '', 1043, '20942800'),(4564, 13, '', 1250, 'J Am Chem Soc. 2010 Dec 29;132(51):18351-60. Epub 2010 Dec 8.rnCleavable biotin probes for labeling of biomolecules via azide-alkyne cycloaddition.rnSzychowski J, Mahdavi A, Hodas JJ, Bagert JD, Ngo JT, Landgraf P, Dieterich DC, Schuman EM, Tirrell DA.'),(4572, 13, '', 1255, 'Schopfer, Furlong and Lockridge; Development of diagnostics in the search for an explanation of aerotoxic syndrome; Anal Biochem 404, 64-74 (2010)'),(4573, 13, '', 1256, 'Schopfer, Furlong and Lockridge; Development of diagnostics in the search for an explanation of aerotoxic syndrome; Anal Biochem 404, 64-74 (2010)'),(4587, 14, 'http://www.chemblink.com/products/2756-87-8.htm', 1253, 'Chemical datasheet'),(4578, 14, 'http://www.lifesensors.com/pdf/Ub-VME_datasheet.pdf', 1258, 'LifeSensors data sheet'),(4579, 13, 'http://www.cell.com/chemistry-biology/abstract/S1074-5521%2802%2900248-X', 1258, 'Chemistry and Biology
postgres_1  |   Volume 9, Issue 10, 1 October 2002, Pages 1149-1159   
postgres_1  |   Chemistry-based functional proteomics reveals novel members of the deubiquitinating enzyme family'),(4580, 13, 'http://www.cell.com/chemistry-biology/abstract/S1074-5521%2802%2900248-X', 1257, 'Chemistry and Biology
postgres_1  |   Volume 9, Issue 10, 1 October 2002, Pages 1149-1159   
postgres_1  |   Chemistry-based functional proteomics reveals novel members of the deubiquitinating enzyme family'),(4581, 14, 'http://www.enzolifesciences.com/fileadmin/reports/els_0a605e18ec.pdf', 1257, 'LifeSensors data sheet'),(4586, 13, 'http://brain.oxfordjournals.org/content/134/3/678.short?rss=1', 1253, 'Fumaric acid esters exert neuroprotective effects in neuroinflammation via activation of the Nrf2 antioxidant pathway'),(4585, 2, 'http://pubchem.ncbi.nlm.nih.gov/summary/summary.cgi?cid=637568&loc=ec_rcs', 1262, 'Dimethyl fumarate - Compound Summary'),(4588, 2, 'http://pubchem.ncbi.nlm.nih.gov/summary/summary.cgi?cid=5369209', 1253, 'methyl hydrogen fumarate - Compound Summary (CID 5369209)'),(4609, 2, 'http://www.ncbi.nlm.nih.gov/pubmed/21738222', 1264, '21738222'),(5166, 2, '', 330, '15782174'),(4607, 14, 'http://themedicalbiochemistrypage.org/nitrogen-metabolism.html', 116, 'Nitrogen metabolism'),(4612, 14, 'http://www.pil.sdu.dk/silac_intro.htm', 1267, 'Silac introduction'),(4795, 14, 'http://www.pil.sdu.dk/silac_intro.htm', 1266, 'Silac introduction'),(5178, 13, '', 1270, 'Perla-Kajan J., Twardowski T., Jakubowski H. Amino Acids. 2007. 32(4) 561-572. Jakubowski H. J. Nutr. 2006. 136(6S) Suppl. 1741S-1749S. Jakubowski H. Cell. Mol. Life Sci. 2004. 61(4). 470-487. Jakubowski H. J. Biol. Chem. 2002. 277(34) 30425-30428.'),(5183, 13, 'http://dx.doi.org/10.1007/s00726-014-1879-8', 1041, 'Uncovering protein polyamination by the spermine‑specific
postgres_1  |   antiserum and mass spectrometric analysis'),(4619, 13, '', 1271, 'Perla-Kajan J., Twardowski T., Jakubowski H. Amino Acids. 2007. V. 32. № 4. P. 561–572.
postgres_1  |   Jakubowski H. J. Nutr. 2006. V. 136. 6S Suppl. P. 1741S–1749S.
postgres_1  |   Jakubowski H. J. Biol. Chem. 2002. V. 277.№ 34. P. 30425–30428.
postgres_1  |   Jakubowski H., Zhang L., Bardeguez A., Aviv A. Circ. Res. 2000. V. 87. № 1. P. 45–51.
postgres_1  |   Glushchenko A. V., Jacobsen D. W. Antioxid. Redox Signal. 2007. V. 9. P. 1883–1898.'),(4817, 2, 'http://www.ncbi.nlm.nih.gov/pubmed/11869872', 1281, 'Effects of Mannich bases on cellular glutathione and related enzymes of Jurkat cells in culture conditions'),(6216, 13, 'http://dx.doi.org/10.1021/ja906135d', 213, 'Identification of the ADP-ribosylation sites in the PARP-1 automodification domain: analysis and implications'),(5276, 13, '', 1286, 'Biochemistry, 1976, 15 (18), 3956'),(4660, 13, 'http://dx.doi.org/10.1021/pr8005155', 1289, 'J. Proteome Res., 2009, 8 (2), pp 900–906'),(4683, 14, 'http://www.ionsource.com/Card/carbam/carbam.htm', 5, 'IonSource carbamylation tutorial'),(4694, 2, '', 52, '11085420'),(4695, 13, '', 52, 'Anal. Biochem. 287, p110-117, 2000'),(4715, 14, 'http://www.pil.sdu.dk/silac_intro.htm', 1296, 'Silac introduction'),(6877, 14, 'http://www.pil.sdu.dk/silac_intro.htm', 1297, 'Silac introduction'),(4718, 14, 'http://www.pil.sdu.dk/silac_intro.htm', 1298, 'Silac introduction'),(5092, 14, 'http://www.pil.sdu.dk/silac_intro.htm', 259, 'Silac introduction'),(4722, 14, 'http://www.pil.sdu.dk/silac_intro.htm', 1299, 'Silac introduction'),(4988, 13, '', 1291, 'Triplex protein quantification based on stable isotope labeling by peptide dimethylation applied to cell and tissue lysates. Boersema PJ, Aye TT, van Veen TA, Heck AJ, Mohammed S. Proteomics. 2008 Nov;8(22):4624-32'),(4733, 14, 'http://docs.appliedbiosystems.com/pebiodocs/04351918.pdf', 39, 'Applied Biosystems iTRAQ(TM) Reagents Chemistry Reference Guide Part Number 4351918 Rev. A'),(4739, 7, '', 39, 'AA0101'),(4740, 16, '', 39, 'BMTH'),(4746, 14, 'http://www3.appliedbiosystems.com/cms/groups/psm_support/documents/generaldocuments/cms_054141.pdf', 1302, 'Applied Biosystems mTRAQ(TM) Reagents'),(6733, 7, '', 21, 'AA0039'),(4801, 2, 'http://www.ncbi.nlm.nih.gov/pubmed/11869872', 1310, 'Effects of Mannich bases on cellular glutathione and related enzymes of Jurkat cells in culture conditions'),(4802, 2, '', 1312, '21778411'),(4810, 2, '', 1314, '21704744'),(4811, 2, 'http://www.ncbi.nlm.nih.gov/pubmed/11869872', 1315, 'Effects of Mannich bases on cellular glutathione and related enzymes of Jurkat cells in culture conditions'),(5433, 2, '', 1313, '21778411'),(5432, 2, '', 1313, '9632657'),(4816, 2, 'http://www.ncbi.nlm.nih.gov/pubmed/11869872', 1317, 'Effects of Mannich bases on cellular glutathione and related enzymes of Jurkat cells in culture conditions'),(4820, 15, 'http://www.piercenet.com/browse.cfm?fldID=01031005', 1320, 'Lab observation analagous to hydrolysis of N-Ethylmaleimide'),(4832, 7, '', 40, 'AA0362'),(4828, 13, '', 40, 'Medzihradszky et al., Mol. Cell. Proteomics 2004, 3, 429-440'),(4829, 16, '', 40, 'SULF'),(4830, 7, '', 40, 'AA0171'),(4831, 7, '', 40, 'AA0361'),(4794, 13, '', 726, 'Wang, F.; Fu, H.; Jiang, Y. Y.; Zhao, Y. F. A Picomole-Scale Method for Rapid Peptide Sequencing Through Convenient and Efficient N-Terminal Phosphorylation and Electrospray Ionization Mass Spectrometry. J. Am. Soc. Mass Spectrom. 2006, 17, 995-999.'),(4793, 13, '', 726, 'Main;  Mode of action of anticholnesterases.  Pharmac Ther 6, 579-628 (1979)'),(4790, 13, '', 725, 'Grigoryan, Li, Xue, Grigoryan, Schopfer and Lockridge; Mass spectral characterization of organophosphate-labeled lysine in peptides.  Analytical Biochemistry 394, 92-100 (2009)'),(4791, 13, '', 725, 'Fidder, Hulst, Noort, Ruiter, van der Schans, Benschop and Langenberg; Retrospective detection of exposure to organophosphorus anti-cholinesterases:  Mass spectrometric analysis of phosphylated human butyrylcholinestease.  Chem. Res. Toxicol. 15, 582-590 (2002)'),(4788, 13, '', 362, 'Chen, J.; Chen, Y.; Gong, P.; Jiang, Y.; Li, Y. M.; Zhao, Y. F. Novel Phosphoryl Derivatization Method for Peptide Sequencing by Electrospray Ionization Mass Spectrometry. Rapid Commun. Spectrom. 2002, 16, 531-536.'),(4789, 13, '', 362, 'Gao, X.; Hu, X. M.; Zhu, J.; Zeng, Z. P.; Han, D. X.; Tang, G.; Huang, X. T.; Xu, P. X.; Zhao, Y. F. An isotope (18O, 15N, and 2H) technique to investigate the metal ion interactions between the phosphoryl group and amino acid side chains by electrospray ionization mass spectrometry. J. Am. Soc. Mass Spectrom. 2011, 22, 689-702.'),(4837, 13, 'http://dx.doi.org/10.1021/ac902778d', 1323, 'Anal. Chem., 2010, 82 (7), pp 2817–2825'),(4838, 13, 'http://dx.doi.org/10.1021/ac902778d', 1324, 'Anal. Chem., 2010, 82 (7), pp 2817–2825'),(4848, 2, 'http://www.ncbi.nlm.nih.gov/pubmed/21740851', 1327, 'Sulfur dioxide acts as a novel endogenous gaseous signaling molecule in the cardiovascular system'),(4849, 12, '', 1326, 'Chemistry of Protein Conjugation and Crosslinking by Shan S. Wong, 1991, pg.32'),(4847, 12, '', 1328, 'Chemistry of Protein Conjugation and Crosslinking by Shan S. Wong, 1991, pg.32'),(5026, 2, 'http://www.ncbi.nlm.nih.gov/pubmed/20169556', 1384, '20169556'),(5025, 13, 'http://www.ncbi.nlm.nih.gov/pmc/articles/PMC2935272/', 1384, 'Bern, M; Saladino, J; Sharp J.S. Rapid Communications Mass Spectrometry (2010), 24(6):768-772'),(4862, 11, 'http://www.ncbi.nlm.nih.gov/pubmed/19857600', 1330, 'Improved detection of intact tyrosine sulfate-containing peptides by matrix-assisted laser desorption/ionization time-of-flight mass spectrometry in linear negative ion mode.'),(4906, 13, '', 1331, 'Investigating protein haptenation mechanisms of skin sensitisers using human serum albumin as a model protein, Aleksic et al, Toxicology in vitro, 21 (2007) 723-733'),(4905, 13, '', 1331, 'Mass spectrometric identification of covalent adducts of skin allergen 2,4-dinitro-1-chlorobenzene, Aleksic et al, Toxicology in Vitro, 22 (2008) 1169-1176'),(5200, 15, '', 1341, 'John.C.Rogers@thermo.com'),(5199, 14, 'http://www.lifetechnologies.com/order/catalog/product/90100', 1341, 'Tandem Mass Tag Reagents, Cysteine-Reactive'),(5201, 15, '', 1342, 'John.C.Rogers@thermo.com'),(5202, 14, 'http://www.lifetechnologies.com/order/catalog/product/90102', 1342, 'Tandem Mass Tag Reagents, Cysteine-Reactive'),(4907, 13, 'http://www.ncbi.nlm.nih.gov/pubmed/17317089', 1345, 'Investigating protein haptenation mechanisms of skin sensitisers using human serum albumin as a model protein. Aleksic et al, Toxicol in Vitro 21 (2007) 723-733'),(5715, 2, 'http://www.ncbi.nlm.nih.gov/pubmed?term=8326953', 1789, '8326953'),(5023, 14, 'http://www.abrf.org/index.cfm/dm.details?DMID=275&AvgMass=258&Margin=0', 1344, 'ABRF Delta Mass'),(4888, 14, 'http://www.piercenet.com/browse.cfm?fldID=E3862D31-9A5C-4F0A-9879-F600D33BD926', 1340, 'Pierce EZ-Link Maleimide-PEG11-Biotin'),(5179, 15, 'http://www.gelifesciences.com/webapp/wcs/stores/servlet/productById/en/GELifeSciences-us/25800673', 1348, 'company website'),(5180, 15, 'https://www.gelifesciences.com/gehcls_images/GELS/Related%20Content/Files/1314787424814/litdocPA23031PS%20Rev%20D%202007_20110831133515.pdf', 1348, 'Product Specification Sheet'),(4944, 13, 'http://www.springerlink.com/content/q3u3271467573733/', 821, 'Article describing design of Cy3B'),(4917, 13, '', 1350, 'J. of American Society for Mass Spectrometry,
postgres_1  |   M. Zimnicka, et al.  "Tunable Charge Tags for Electron-Based Methods of Peptide Sequencing: Design and Applications" June 2011 pgs 608 -620'),(4975, 14, 'http://www.nestgrp.com/protocols/bmt/pi3tr.shtml', 421, 'Instruction manual for the Pi3 Tryptophan selective resins'),(4967, 12, '', 1358, 'Chemistry of protein conjugation and crosslinking by Shan S. Wong, 1991'),(4971, 13, '', 127, 'Journal of Drug Targeting (1993), 1(3), 259-67.'),(4966, 2, '', 734, '2'),(4974, 16, '', 421, 'CYSP'),(5205, 13, 'http://www.nature.com/nmeth/journal/v9/n8/full/nmeth.2106.html', 1356, 'Reanalysis of phosphoproteomics data uncovers ADP-ribosylation sites. Matic et al. (2012) Nature Methods 9, 771–772'),(4956, 2, 'http://www.ncbi.nlm.nih.gov/pubmed/15883371', 1355, '15883371'),(4955, 2, 'http://www.ncbi.nlm.nih.gov/pubmed/8895467', 1355, '8895467'),(4954, 2, 'http://www.ncbi.nlm.nih.gov/pubmed/10200165', 1355, '10200165'),(4952, 14, 'https://www.gelifesciences.com/gehcls_images/GELS/Related Content/Files/1314735988470/litdoc28953107AD_20110831002141.pdf', 494, 'GE Life Sciences data sheet'),(4985, 13, '', 1364, 'Carletti, Li, Li, Ekstrom, Nicolet, Loiodice, Gillon, Froment, Lockridge, Schopfer, Masson & Nachon; J Am Chem Soc 130, 16011 (2008)'),(4983, 13, '', 1365, 'Carletti, Li, Li, Ekstrom, Nicolet, Loiodice, Gillon, Froment, Lockridge, Schopfer, Masson & Nachon [J Am Chem Soc 130, 16011 (2008)'),(4994, 16, '', 426, 'OCTA'),(4995, 7, '', 426, 'AA0584'),(5009, 2, 'http://www.ncbi.nlm.nih.gov/pubmed/?term=2475130', 1380, 'Protein reactions with methyl and ethyl vinyl sulfones.'),(4982, 14, 'http://www.sigmaaldrich.com/technical-documents/articles/stable-isotopes/stable-isotope-labeling-by-amino-acids.html', 298, 'SILAC overview'),(4990, 14, 'http://www.pil.sdu.dk/silac_intro.htm', 1370, 'Silac introduction'),(4989, 2, '', 1291, '15782174'),(5005, 2, 'http://www.ncbi.nlm.nih.gov/pubmed/2475130', 1381, 'Protein reactions with methyl and ethyl vinyl sulfones.'),(5004, 2, 'http://www.ncbi.nlm.nih.gov/pubmed/1242713', 1381, 'Reactions of proteins with ethyl vinyl sulfone.'),(5003, 2, 'http://www.ncbi.nlm.nih.gov/pubmed/18528979', 1382, 'Aryl vinyl sulfonates and sulfones as active site-directed and mechanism-based probes for protein tyrosine phosphatases.'),(5001, 2, '', 978, '22835833'),(5002, 2, '', 979, '22835833'),(5010, 15, '', 1383, 'We are currently trying to profile the PLP proteins of various bacteria and locate their binding sites using LC-MS of trypsin treated proteins. Under these condition the PLP imine is cleaved and therefore we need to reduce the imine bond to the chemical stable amine using sodium borohydride'),(5013, 2, '', 1290, '18511913'),(5641, 4, '', 1009, '65126-70-7'),(5642, 13, 'http://dx.doi.org/10.1074/mcp.M600279-MCP200', 1009, 'Formation of E-Formyllysine on Silver-stained Proteins')

Wipe the slate clean once more, and a new error that I think also hints at a table creation order issue:

postgres_1  | 2021-05-27 22:07:22.971 UTC [83] ERROR:  insert or update on table "Fragment" violates foreign key constraint "Fragment_modification_id_fkey"
postgres_1  | 2021-05-27 22:07:22.971 UTC [83] DETAIL:  Key (modification_id)=(12) is not present in table "Modification".
postgres_1  | 2021-05-27 22:07:22.971 UTC [83] STATEMENT:  INSERT INTO "Fragment" (id, modification_id) VALUES (1, 12),(2, 12),(3, 12),(4, 12),(5, 12),(6, 12),(7, 13),(8, 13),(9, 13),(10, 13),(11, 13),(12, 13)

I will continue to investigate a bit, but wanted to report this issue to see if you have any thoughts on whether or not I've identified a real bug, or made a mistake somewhere along the way. I am able to successfully load into a SQLite database, without any of the modifications that are present on my fork, so I might just import those tables into Postgres, or maybe query the SQLite database directly.

Thanks!

mobiusklein commented 3 years ago

Yes, those column constraints were based upon approximations, but SQLite doesn't really care about data types or sizes, and it's not strict about foreign keys. They're merely hints about what the user expects. I haven't experimented with loading it into any other RBMS, but it's fixable. I can investigate the dependency graph and adapt the type modifications from you if that's okay.

What's your use-case for loading this all into Postgres?

radusuciu commented 3 years ago

I'm already using Postgres for other data and would prefer to keep everything under one umbrella to enable joins from the Unimod table to others, but this isn't a strict requirement by any means as it's pretty easy to go from SQLite to Postgres or to accomplish what I want in application code.

I guess if you're not interested in supporting Postgres, maybe you could indicate so in the docs?