-
Notifications
You must be signed in to change notification settings - Fork 0
/
schema.txt
99 lines (89 loc) · 1.99 KB
/
schema.txt
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
CREATE TABLE SearchDatabase (
pkid INTEGER PRIMARY KEY ASC AUTOINCREMENT,
name TEXT,
format TEXT,
numDatabaseSequences INTEGER,
numResidues INTEGER,
releaseDate TEXT,
version TEXT,
location TEXT
);
CREATE TABLE DBSequence (
pkid INTEGER PRIMARY KEY,
id INTEGER,
SearchDatabase_pkid INTEGER REFERENCES SearchDatabase(pkid);,
accession TEXT,
description TEXT,
length INTEGER,
sequence TEXT
);
CREATE TABLE Peptide (
pkid INTEGER PRIMARY KEY,
sequence TEXT,
modNum INTEGER
);
CREATE TABLE Modification (
pkid INTEGER PRIMARY KEY,
Peptide_pkid INTEGER REFERENCES Peptide(pkid);,
location INTEGER,
residues TEXT,
replacementResidue TEXT,
name TEXT,
avgMassDelta REAL,
monoisotopicMassDelta REAL
);
CREATE TABLE SpectrumIdentification (
pkid INTEGER PRIMARY KEY,
Spectrum_pkid TEXT,
spectrum_id TEXT,
acquisitionNum INTEGER,
chargeState INTEGER,
retentionTime REAL,
rank INTEGER,
passThreshold INTEGER,
experimentalMassToCharge REAL,
calculatedMassToCharge REAL
);
CREATE TABLE Score (
pkid INTEGER PRIMARY KEY,
SpectrumIdentification_pkid INTEGER REFERENCES SpectrumIdentification(pkid);,
spectrum_identification_id TEXT
);
CREATE TABLE PeptideEvidence (
pkid INTEGER PRIMARY KEY,
SpectrumIdentification_pkid INTEGER REFERENCES SpectrumIdentification(pkid);,
Peptide_pkid INTEGER REFERENCES Peptide(pkid);,
DBSequence_pkid INTEGER REFERENCES DBSequence(pkid);,
isDecoy INTEGER,
pre TEXT,
post TEXT,
start INTEGER,
end INTEGER
);
CREATE TABLE Spectrum (
pkid INTEGER PRIMARY KEY,
id TEXT,
acquisitionNum INTEGER,
msLevel INTEGER,
polarity INTEGER,
peaksCount INTEGER,
totIonCurrent REAL,
retentionTime REAL,
basePeakMZ REAL,
basePeakIntensity REAL,
collisionEnergy REAL,
ionisationEnergy REAL,
lowMZ REAL,
highMZ REAL,
precursorScanNum INTEGER,
precursorMZ REAL,
precursorCharge INTEGER,
precursorIntensity REAL
);
CREATE TABLE Peaks (
pkid INTEGER PRIMARY KEY,
Spectrum_pkid INTEGER REFERENCES Spectrum(pkid);,
acquisitionNum INTEGER,
moz TEXT,
intensity TEXT
);