MAGGIE_8_8_2008
Express M3
Express M3
http://schemas.microsoft.com/DataWarehouse/Designer/1.0:DiagramLayout
http://schemas.microsoft.com/DataWarehouse/Designer/1.0:ShowFriendlyNames
true
http://schemas.microsoft.com/DataWarehouse/Designer/1.0:ShowRelationshipNames
false
http://schemas.microsoft.com/DataWarehouse/Designer/1.0:UseDiagramDefaultLayout
true
http://schemas.microsoft.com/DataWarehouse/Designer/1.0:DiagramViewPortLeft
-2359
http://schemas.microsoft.com/DataWarehouse/Designer/1.0:DiagramViewPortTop
-785
http://schemas.microsoft.com/DataWarehouse/Designer/1.0:DiagramBoundingLeft
-4438
http://schemas.microsoft.com/DataWarehouse/Designer/1.0:DiagramBoundingTop
-785
http://schemas.microsoft.com/DataWarehouse/Designer/1.0:DiagramZoom
100
1033
Latin1_General_CI_AS
Tb Column Separation Hierarchy
Tb Column Separation Hierarchy
Tb Column Separation Hierarchy
Tb Column Separation Hierarchy
Separation Hierarchy Code P Key
Local Metal
Local Pool
Local Separation Type
Local Separation Initial
Local Level
Local Name
Column Pool Key
Column Parent Key
Node Parent
Column Local Name
Full Hierarchy Name
Column Hierarchy Name
Fraction Code F Key
Fraction Code F Key 1
Tb Column Fractions
Tb Column Fractions
Tb Column Fractions
Tb Column Fractions
Fraction ID
Growth Code F Key
Separation Code F Key
Fraction Type
Location Code F Key
Gradient Code F Key
Fraction Number
Fraction Position
Label Line 1
Label Line 2
Label Line 3
Fraction Volume m L
Fraction Mass Mg
Fraction Description
Fraction Contact
Fraction Active
Node Left
Node Right
Node Depth
Node Ordinal
Node Index
Column Parent
Column Pool
Acid Washed Vessel
Node Parent
false
Fraction Code P Key
Fraction Pos Id
Tb Column Samples
Tb Column Samples
Tb Column Samples
Tb Column Samples
Sample ID
Sample Number
Sample Volume m L
Sample Type
Sample Date
Buffer Type
Buffer Conc m M
Buffer Additions
Location Code F Key
Comment Code F Key
Sampled By
Acid Washed Vessel
Fraction Code F Key
false
Tb Column Mascot Header
Tb Column Mascot Header
Tb Column Mascot Header
Tb Column Mascot Header
XML File Name
Mass Spec Type
Plate Code F Key
Well Name
Plate Well Name
Gel Band ID
Load Sequence
COM
Date
USERNAME
USEREMAIL
URI
FILENAME
FORMAT
SEARCH
Mascot Ver
DB
Fasta Ver
Num Seqs
Num Residues
Num Seqs After Tax
Error Tolerant Num
Num Queries
File Comment
Sample Code F Key
false
Tb Column Mascot Hit
Tb Column Mascot Hit
Tb Column Mascot Hit
Tb Column Mascot Hit
Number
Mascot Header Code F Key
false
Tb ICPMS Metal
Tb ICPMS Metal
Tb ICPMS Metal
Tb ICPMS Metal
Metal ID
Atomic Number
Isotopic Mass
Metal Symbol
Metal Name
Default Data Public
Default Collision Mode
Tb ICPMS Peak
Tb ICPMS Peak
Tb ICPMS Peak
Tb ICPMS Peak
ICPMS Dataset Code F Key
ICPMS Metal Code F Key
ICPMS Peak Name
ICPMS Peak Letter
ICPMS Peak Ordinal
ICPMS Peak Comments
Tb Column Mascot Protein P Fid
Tb Column Mascot Protein PFid
Tb Column Mascot Protein P Fid
Tb Column Mascot Protein P Fid
Prot Desc
Prot Score
Prot Thresh
Prot Expect
Prot Mass
Prot Matches
Prot Cover
Prot Len
Prot Pi
Prot Tax Str
Prot Tax Id
Accession
Gi
P Fid
Mascot Hit Code F Key
false
p I
Tb Column ICPMS Dataset
Tb Column ICPMS Dataset
Tb Column ICPMS Dataset
Tb Column ICPMS Dataset
ICPMS Dataset Name
ICPMS Dataset Comments
Column Fraction Code F Key
false
Pruned Tree Name
Asvw ICPMS Peak Overlap
Asvw ICPMS Peak Overlap
Asvw ICPMS Peak Overlap
Asvw ICPMS Peak Overlap
ICPMS Dataset Code F Key
ICPMS Peak Name
ICPMS Peak Letter
ICPMS Peak Ordinal
ICPMS Peak Comments
ICPMS Metal Code F Key
false
Asvw ICPMS Metal Overlap
Asvw ICPMS Metal Overlap
Asvw ICPMS Metal Overlap
Asvw ICPMS Metal Overlap
Metal ID
Atomic Number
Isotopic Mass
Metal Symbol
Metal Name
Default Data Public
Default Collision Mode
Asvw P Fids
Asvw P Fids
Asvw P Fids
Asvw P Fids
Gi
Tb Cube Procedure Tree
Tb Cube Procedure Tree
Tb Cube Procedure Tree
Tb Cube Procedure Tree
Procedure Tree Code P Key
Input ID
Separation Type
Separation Initial
Local Level
Node Name
Node Parent
Pruned Parent Key
Pruned Input ID Key
Full Tree Name
Pruned Tree Name
Pruned Local Name
Tb Column ICPMS Run
Tb Column ICPMS Run
Tb Column ICPMS Run 1
Tb Column ICPMS Run
ICPMS Run Number
ICPMS Acid
ICPMS Cone
ICPMS Acquisition Mode
ICPMS Run By
ICPMS Run Date
ICPMS Run File Name
ICPMS Data Upload Date
ICPMS Run Comments
ICPMS Run ID
Tb Column ICPMS Dataset
ICPMS Dataset Name
ICPMS Dataset Comments
Pruned Tree Name
Column Fraction Code F Key
Pruned Parent Key - Tb Cube Procedure Tree - Tb Column ICPMS Dataset
Hierarchy
Hierarchy 1
Tb IPMD LF
Tb IPMD LF
Tb IPMD LF
Tb IPMD LF
NCBI Gene Code F Key
Orf Num
Ipr Num
Match Type
Pattern
Keyword
Left Match
Hit Match
Right Match
Min Ac Score
Max Ac Score
Ipr Name
Hscore
Tb IPR Entry List
Tb IPR Entry List - IPR Num
Run Date
Tb IPR Entry List - IPR Name
Entry Type
Gm Num
false
Tb Element
Atomic Number
Name
Symbol
Period
Group
Tb Element Series
Tb Element Series - Name
Tb GPA Pvalue
Tb GPA Pvalue
Tb GPA Pvalue
Tb GPA Pvalue
P Fid
Pvalue
Tb Element Isotope
Isotopic Mass
Isotope ID
Element F Key
false
Tb Element Isotope
Tb Element Isotope
Tb Element Isotope
Tb Element Isotope
Isotopic Mass
Isotope ID
Tb Element
Atomic Number
Name
Symbol
Period
Group
Tb Element Series
Tb Element Series - Name
Tb Element Series - Tb Element
Asvw Column ICPMS Peak Data
Asvw Column ICPMS Peak Data
Asvw Column ICPMS Peak Data Count
peaks
DistinctCount
Integer
Molap
Regular
Tb Column Fractions
Tb Column Fractions
Integer
asvw_Column_ICPMS_Peak_Data
Fraction_Code_FKey
Granularity
Fraction ID
WChar
50
Growth Code F Key
Integer
Separation Code F Key
Integer
Fraction Type
Integer
Location Code F Key
Integer
Gradient Code F Key
Integer
Fraction Number
Integer
Fraction Position
Integer
Label Line 1
WChar
20
Label Line 2
WChar
20
Label Line 3
WChar
20
Fraction Volume m L
Double
Fraction Mass Mg
Integer
Fraction Description
WChar
100
Fraction Contact
WChar
50
Fraction Active
Integer
Node Left
Integer
Node Right
Integer
Node Depth
Integer
Node Ordinal
Integer
Node Index
WChar
50
Column Parent
Integer
Column Pool
Integer
Acid Washed Vessel
Integer
Node Parent
Integer
Fraction Code P Key
Integer
Fraction Pos Id
WChar
63
Tb ICPMS Metal
Tb ICPMS Metal
Integer
Granularity
Metal ID
WChar
50
Atomic Number
Integer
Isotopic Mass
Integer
Metal Symbol
WChar
3
Metal Name
WChar
20
Default Data Public
Integer
Default Collision Mode
Integer
Tb ICPMS Peak
ICPMS Metal Code F Key
Regular
Tb Column Mascot Protein P Fid
Tb Column Mascot Protein P Fid
Tb Cube Procedure Tree
Tb Cube Procedure Tree
Integer
Granularity
Procedure Tree Code P Key
Integer
Input ID
WChar
12
Separation Type
Integer
Separation Initial
WChar
3
Local Level
Integer
Node Name
WChar
18
Node Parent
Integer
Pruned Parent Key
Integer
Pruned Input ID Key
Integer
Full Tree Name
WChar
1000
Pruned Tree Name
WChar
1000
Pruned Local Name
WChar
17
Tb Column Fractions
Node Parent
Regular
Tb ICPMS Peak
Tb ICPMS Peak
UnknownMember
Integer
asvw_Column_ICPMS_Peak_Data
ICPMS_Peak_Code_FKey
Granularity
ICPMS Dataset Code F Key
Integer
ICPMS Metal Code F Key
Integer
ICPMS Peak Name
WChar
20
ICPMS Peak Letter
WChar
5
ICPMS Peak Ordinal
Integer
ICPMS Peak Comments
WChar
Asvw Column ICPMS Peak Data
Asvw Column ICPMS Peak Data
Express M3
asvw_Column_ICPMS_Peak_Data
Molap
Regular
-PT1S
-PT1S
-PT1S
-PT1S
-PT1S
-PT1S
-PT1S
-PT1S
Tb Column Fractions
Tb Column Fractions
Fraction Number
Fraction Number
Integer
Integer
dbo_tb_Column_Fractions
Fraction_Number
Fraction Position
Fraction Position
Integer
Integer
dbo_tb_Column_Fractions
Fraction_Position
Fraction Volume m L
Volume ml
Double
Double
dbo_tb_Column_Fractions
Fraction_Volume_mL
Fraction Mass Mg
Fraction Mass Mg
Integer
Integer
dbo_tb_Column_Fractions
Fraction_Mass_mg
Column Parent
Column Parent
Integer
Integer
dbo_tb_Column_Fractions
Column_Parent
Column Pool
Column Pool
Integer
Integer
dbo_tb_Column_Fractions
Column_Pool
Tb Column Fractions Count
Tb Column Fractions Count
Count
Integer
Integer
4
dbo_tb_Column_Fractions
Molap
Regular
Tb Column Fractions
Tb Column Fractions
Integer
dbo_tb_Column_Fractions
Fraction_Code_PKey
Granularity
Fraction ID
WChar
50
Growth Code F Key
Integer
Separation Code F Key
Integer
Fraction Type
Integer
Location Code F Key
Integer
Gradient Code F Key
Integer
Fraction Number
Integer
Fraction Position
Integer
Label Line 1
WChar
20
Label Line 2
WChar
20
Label Line 3
WChar
20
Fraction Volume m L
Double
Fraction Mass Mg
Integer
Fraction Description
WChar
100
Fraction Contact
WChar
50
Fraction Active
Integer
Node Left
Integer
Node Right
Integer
Node Depth
Integer
Node Ordinal
Integer
Node Index
WChar
50
Column Parent
Integer
Column Pool
Integer
Acid Washed Vessel
Integer
Node Parent
Integer
Fraction Code P Key
Integer
Fraction Pos Id
WChar
63
Tb ICPMS Peak
Asvw Column ICPMS Peak Data
Tb Column Mascot Protein P Fid
Asvw Column ICPMS Peak Data
Tb Cube Procedure Tree
Tb Cube Procedure Tree
Integer
Granularity
Procedure Tree Code P Key
Integer
Input ID
WChar
12
Separation Type
Integer
Separation Initial
WChar
3
Local Level
Integer
Node Name
WChar
18
Node Parent
Integer
Pruned Parent Key
Integer
Pruned Input ID Key
Integer
Full Tree Name
WChar
1000
Pruned Tree Name
WChar
1000
Pruned Local Name
WChar
17
Tb Column Fractions
Node Parent
Regular
Tb Column Fractions
Tb Column Fractions
Express M3
dbo_tb_Column_Fractions
Molap
Regular
-PT1S
-PT1S
-PT1S
-PT1S
-PT1S
-PT1S
-PT1S
-PT1S
Tb Column Mascot Protein
Tb Column Mascot Protein
Prot Score
Prot Score
Double
Double
dbo_tb_Column_Mascot_Protein
prot_score
Prot Thresh
Prot Thresh
Double
Double
dbo_tb_Column_Mascot_Protein
prot_thresh
Prot Expect
Prot Expect
Double
Double
dbo_tb_Column_Mascot_Protein
prot_expect
Prot Mass
Prot Mass
Double
Double
dbo_tb_Column_Mascot_Protein
prot_mass
Prot Matches
Prot Matches
BigInt
BigInt
dbo_tb_Column_Mascot_Protein
prot_matches
Prot Cover
Prot Cover
Double
Double
dbo_tb_Column_Mascot_Protein
prot_cover
Prot Len
Prot Len
BigInt
BigInt
dbo_tb_Column_Mascot_Protein
prot_len
Prot Pi
Prot Pi
Double
Double
dbo_tb_Column_Mascot_Protein
prot_pi
Gi
Gi
Integer
Integer
dbo_tb_Column_Mascot_Protein
gi
Tb Column Mascot Protein Count
Tb Column Mascot Protein Count
Count
Integer
Integer
4
dbo_tb_Column_Mascot_Protein
Tb Column Mascot Protein Count 1
Prot Hits
DistinctCount
Integer
Integer
dbo_tb_Column_Mascot_Protein
gi
Molap
Regular
Tb Column Mascot Hit
Tb Column Mascot Hit
Integer
dbo_tb_Column_Mascot_Protein
Mascot_Hit_Code_FKey
Granularity
Number
Integer
Mascot Header Code F Key
Integer
Tb Column Mascot Header
Tb Column Mascot Header
Integer
Granularity
XML File Name
WChar
255
Mass Spec Type
Integer
Plate Code F Key
Integer
Well Name
WChar
50
Plate Well Name
WChar
50
Gel Band ID
WChar
50
Load Sequence
UnsignedTinyInt
COM
WChar
255
Date
WChar
255
USERNAME
WChar
255
USEREMAIL
WChar
255
URI
WChar
255
FILENAME
WChar
255
FORMAT
WChar
255
SEARCH
WChar
255
Mascot Ver
WChar
255
DB
WChar
255
Fasta Ver
WChar
255
Num Seqs
BigInt
Num Residues
BigInt
Num Seqs After Tax
BigInt
Error Tolerant Num
BigInt
Num Queries
BigInt
File Comment
WChar
1024
Sample Code F Key
Integer
Tb Column Mascot Hit
Mascot Header Code F Key
Regular
Tb Column Samples
Tb Column Samples
Integer
Granularity
Sample ID
WChar
50
Sample Number
Integer
Sample Volume m L
Double
Sample Type
Integer
Sample Date
Date
Buffer Type
Integer
Buffer Conc m M
Double
Buffer Additions
WChar
20
Location Code F Key
Integer
Comment Code F Key
Integer
Sampled By
WChar
50
Acid Washed Vessel
Integer
Fraction Code F Key
Integer
Tb Column Mascot Header
Sample Code F Key
Regular
Tb Column Fractions
Tb Column Fractions
Integer
Granularity
Fraction ID
WChar
50
Growth Code F Key
Integer
Separation Code F Key
Integer
Fraction Type
Integer
Location Code F Key
Integer
Gradient Code F Key
Integer
Fraction Number
Integer
Fraction Position
Integer
Label Line 1
WChar
20
Label Line 2
WChar
20
Label Line 3
WChar
20
Fraction Volume m L
Double
Fraction Mass Mg
Integer
Fraction Description
WChar
100
Fraction Contact
WChar
50
Fraction Active
Integer
Node Left
Integer
Node Right
Integer
Node Depth
Integer
Node Ordinal
Integer
Node Index
WChar
50
Column Parent
Integer
Column Pool
Integer
Acid Washed Vessel
Integer
Node Parent
Integer
Fraction Code P Key
Integer
Fraction Pos Id
WChar
63
Tb Column Samples
Fraction Code F Key
Regular
Tb ICPMS Peak
Asvw Column ICPMS Peak Data
Tb Cube Procedure Tree
Tb Cube Procedure Tree
Integer
Granularity
Procedure Tree Code P Key
Integer
Input ID
WChar
12
Separation Type
Integer
Separation Initial
WChar
3
Local Level
Integer
Node Name
WChar
18
Node Parent
Integer
Pruned Parent Key
Integer
Pruned Input ID Key
Integer
Full Tree Name
WChar
1000
Pruned Tree Name
WChar
1000
Pruned Local Name
WChar
17
Tb Column Fractions
Node Parent
Regular
Tb Column ICPMS Run
Tb Column ICPMS Data u M
Tb Column Mascot Protein
Tb Column Mascot Protein
Express M3
dbo_tb_Column_Mascot_Protein
Molap
Regular
-PT1S
-PT1S
-PT1S
-PT1S
-PT1S
-PT1S
-PT1S
-PT1S
Tb Column ICPMS Data u M All
Tb Column ICPMS Data u M All
ICPMS Run Count
ICPMS Run Count
Integer
Integer
dbo_tb_Column_ICPMS_Data_uM_All
ICPMS_Run_Count
ICPMS Data Value u M Avg
ICPMS Data Value uM Avg
Double
Double
dbo_tb_Column_ICPMS_Data_uM_All
ICPMS_Data_Value_uM_Avg
ICPMS Data Value u M Min
ICPMS Data Value u M Min
Single
Single
dbo_tb_Column_ICPMS_Data_uM_All
ICPMS_Data_Value_uM_Min
ICPMS Data Value u M Max
ICPMS Data Value u M Max
Single
Single
dbo_tb_Column_ICPMS_Data_uM_All
ICPMS_Data_Value_uM_Max
ICPMS Data Value u M SD
ICPMS Data Value u M SD
Double
Double
dbo_tb_Column_ICPMS_Data_uM_All
ICPMS_Data_Value_uM_SD
Tb Column ICPMS Data u M All Count
Tb Column ICPMS Data u M All Count
Count
Integer
Integer
4
dbo_tb_Column_ICPMS_Data_uM_All
ICPMS Data Value u M Avg - Tb Column ICPMS Data u M All
Total Metal nmoles
Double
Double
dbo_tb_Column_ICPMS_Data_uM_All
ICPMS_Data_Value_uM_Avg
ICPMS Data Value u M Avg - Tb Column ICPMS Data u M All 1
Metal Peak Max nmoles_ml
Max
Double
Double
dbo_tb_Column_ICPMS_Data_uM_All
ICPMS_Data_Value_uM_Avg
Molap
Regular
Tb Column Fractions
Tb Column Fractions
Integer
dbo_tb_Column_ICPMS_Data_uM_All
Fraction_Code_FKey
Granularity
Fraction ID
WChar
50
Growth Code F Key
Integer
Separation Code F Key
Integer
Fraction Type
Integer
Location Code F Key
Integer
Gradient Code F Key
Integer
Fraction Number
Integer
Fraction Position
Integer
Label Line 1
WChar
20
Label Line 2
WChar
20
Label Line 3
WChar
20
Fraction Volume m L
Double
Fraction Mass Mg
Integer
Fraction Description
WChar
100
Fraction Contact
WChar
50
Fraction Active
Integer
Node Left
Integer
Node Right
Integer
Node Depth
Integer
Node Ordinal
Integer
Node Index
WChar
50
Column Parent
Integer
Column Pool
Integer
Acid Washed Vessel
Integer
Node Parent
Integer
Fraction Code P Key
Integer
Fraction Pos Id
WChar
63
Tb ICPMS Metal
Tb ICPMS Metal
Integer
dbo_tb_Column_ICPMS_Data_uM_All
ICPMS_Metal_Code_FKey
Granularity
Metal ID
WChar
50
Atomic Number
Integer
Isotopic Mass
Integer
Metal Symbol
WChar
3
Metal Name
WChar
20
Default Data Public
Integer
Default Collision Mode
Integer
Tb ICPMS Peak
Asvw Column ICPMS Peak Data
Tb Cube Procedure Tree
Tb Cube Procedure Tree
Integer
Granularity
Procedure Tree Code P Key
Integer
Input ID
WChar
12
Separation Type
Integer
Separation Initial
WChar
3
Local Level
Integer
Node Name
WChar
18
Node Parent
Integer
Pruned Parent Key
Integer
Pruned Input ID Key
Integer
Full Tree Name
WChar
1000
Pruned Tree Name
WChar
1000
Pruned Local Name
WChar
17
Tb Column Fractions
Node Parent
Regular
Tb Column ICPMS Data u M All
Tb Column ICPMS Data u M All
Express M3
dbo_tb_Column_ICPMS_Data_uM_All
Molap
Regular
-PT1S
-PT1S
-PT1S
-PT1S
-PT1S
-PT1S
-PT1S
-PT1S
Tb Column Mascot Protein P Fid
Tb Column Mascot Protein P Fid
Prot Score - Tb Column Mascot Protein P Fid
Prot Score - Tb Column Mascot Protein P Fid
Double
Double
dbo_tb_Column_Mascot_Protein_PFid
prot_score
Prot Thresh - Tb Column Mascot Protein P Fid
Prot Thresh - Tb Column Mascot Protein P Fid
Double
Double
dbo_tb_Column_Mascot_Protein_PFid
prot_thresh
Prot Expect - Tb Column Mascot Protein P Fid
Prot Expect - Tb Column Mascot Protein P Fid
Double
Double
dbo_tb_Column_Mascot_Protein_PFid
prot_expect
Prot Mass - Tb Column Mascot Protein P Fid
Prot Mass - Tb Column Mascot Protein P Fid
Double
Double
dbo_tb_Column_Mascot_Protein_PFid
prot_mass
Prot Matches - Tb Column Mascot Protein P Fid
Prot Matches - Tb Column Mascot Protein P Fid
BigInt
BigInt
dbo_tb_Column_Mascot_Protein_PFid
prot_matches
Prot Cover - Tb Column Mascot Protein P Fid
Prot Cover - Tb Column Mascot Protein P Fid
Double
Double
dbo_tb_Column_Mascot_Protein_PFid
prot_cover
Prot Len - Tb Column Mascot Protein P Fid
Prot Len - Tb Column Mascot Protein P Fid
BigInt
BigInt
dbo_tb_Column_Mascot_Protein_PFid
prot_len
Prot Pi - Tb Column Mascot Protein P Fid
Prot Pi - Tb Column Mascot Protein P Fid
Double
Double
dbo_tb_Column_Mascot_Protein_PFid
prot_pi
Gi - Tb Column Mascot Protein P Fid
Gi - Tb Column Mascot Protein P Fid
Integer
Integer
dbo_tb_Column_Mascot_Protein_PFid
gi
Tb Column Mascot Protein P Fid Count
Tb Column Mascot Protein P Fid Count
Count
Integer
Integer
4
dbo_tb_Column_Mascot_Protein_PFid
Gi - Tb Column Mascot Protein P Fid 1
Prot Hits -pfid-
DistinctCount
Integer
Integer
dbo_tb_Column_Mascot_Protein_PFid
gi
Molap
Regular
Tb Column Mascot Protein P Fid
Tb Column Mascot Protein P Fid
Integer
dbo_tb_Column_Mascot_Protein_PFid
Mascot_Protein_Code_PKey
Granularity
Prot Desc
WChar
255
Prot Score
Double
Prot Thresh
Double
Prot Expect
Double
Prot Mass
Double
Prot Matches
BigInt
Prot Cover
Double
Prot Len
BigInt
Prot Pi
Double
Prot Tax Str
WChar
255
Prot Tax Id
BigInt
Accession
WChar
255
Gi
Integer
P Fid
WChar
15
Mascot Hit Code F Key
Integer
p I
Double
Tb Column Mascot Hit
Tb Column Mascot Hit
Integer
Granularity
Number
Integer
Mascot Header Code F Key
Integer
Tb Column Mascot Protein P Fid
Mascot Hit Code F Key
Regular
Tb Column Mascot Header
Tb Column Mascot Header
Integer
Granularity
XML File Name
WChar
255
Mass Spec Type
Integer
Plate Code F Key
Integer
Well Name
WChar
50
Plate Well Name
WChar
50
Gel Band ID
WChar
50
Load Sequence
UnsignedTinyInt
COM
WChar
255
Date
WChar
255
USERNAME
WChar
255
USEREMAIL
WChar
255
URI
WChar
255
FILENAME
WChar
255
FORMAT
WChar
255
SEARCH
WChar
255
Mascot Ver
WChar
255
DB
WChar
255
Fasta Ver
WChar
255
Num Seqs
BigInt
Num Residues
BigInt
Num Seqs After Tax
BigInt
Error Tolerant Num
BigInt
Num Queries
BigInt
File Comment
WChar
1024
Sample Code F Key
Integer
Tb Column Mascot Hit
Mascot Header Code F Key
Regular
Tb Column Samples
Tb Column Samples
Integer
Granularity
Sample ID
WChar
50
Sample Number
Integer
Sample Volume m L
Double
Sample Type
Integer
Sample Date
Date
Buffer Type
Integer
Buffer Conc m M
Double
Buffer Additions
WChar
20
Location Code F Key
Integer
Comment Code F Key
Integer
Sampled By
WChar
50
Acid Washed Vessel
Integer
Fraction Code F Key
Integer
Tb Column Mascot Header
Sample Code F Key
Regular
Tb Column Fractions
Tb Column Fractions
Integer
Granularity
Fraction ID
WChar
50
Growth Code F Key
Integer
Separation Code F Key
Integer
Fraction Type
Integer
Location Code F Key
Integer
Gradient Code F Key
Integer
Fraction Number
Integer
Fraction Position
Integer
Label Line 1
WChar
20
Label Line 2
WChar
20
Label Line 3
WChar
20
Fraction Volume m L
Double
Fraction Mass Mg
Integer
Fraction Description
WChar
100
Fraction Contact
WChar
50
Fraction Active
Integer
Node Left
Integer
Node Right
Integer
Node Depth
Integer
Node Ordinal
Integer
Node Index
WChar
50
Column Parent
Integer
Column Pool
Integer
Acid Washed Vessel
Integer
Node Parent
Integer
Fraction Code P Key
Integer
Fraction Pos Id
WChar
63
Tb Column Samples
Fraction Code F Key
Regular
Asvw P Fids
Asvw P Fids
WChar
15
dbo_tb_Column_Mascot_Protein_PFid
PFid
Granularity
Gi
Integer
Tb ICPMS Peak
Tb Column Fractions
Tb Cube Procedure Tree
Tb Cube Procedure Tree
Integer
Granularity
Procedure Tree Code P Key
Integer
Input ID
WChar
12
Separation Type
Integer
Separation Initial
WChar
3
Local Level
Integer
Node Name
WChar
18
Node Parent
Integer
Pruned Parent Key
Integer
Pruned Input ID Key
Integer
Full Tree Name
WChar
1000
Pruned Tree Name
WChar
1000
Pruned Local Name
WChar
17
Tb Column Fractions
Node Parent
Regular
Tb IPMD LF
Asvw IPMD LF
Tb Column Mascot Protein P Fid
Tb Column Mascot Protein P Fid
Express M3
dbo_tb_Column_Mascot_Protein_PFid
Molap
Regular
-PT1S
-PT1S
-PT1S
-PT1S
-PT1S
-PT1S
-PT1S
-PT1S
Tb Column Fractions 1
Tb Column Fractions nonpeak
Fraction Code P Key Distinct Count
FRs cnt
DistinctCount
Integer
Integer
dbo_tb_Column_Fractions
Fraction_Code_PKey
Molap
Regular
Tb Column Fractions
Tb Column Fractions
Integer
dbo_tb_Column_Fractions
Fraction_Code_PKey
Granularity
Fraction ID
WChar
50
Growth Code F Key
Integer
Separation Code F Key
Integer
Fraction Type
Integer
Location Code F Key
Integer
Gradient Code F Key
Integer
Fraction Number
Integer
Fraction Position
Integer
Label Line 1
WChar
20
Label Line 2
WChar
20
Label Line 3
WChar
20
Fraction Volume m L
Double
Fraction Mass Mg
Integer
Fraction Description
WChar
100
Fraction Contact
WChar
50
Fraction Active
Integer
Node Left
Integer
Node Right
Integer
Node Depth
Integer
Node Ordinal
Integer
Node Index
WChar
50
Column Parent
Integer
Column Pool
Integer
Acid Washed Vessel
Integer
Node Parent
Integer
Fraction Code P Key
Integer
Fraction Pos Id
WChar
63
Tb Column Mascot Protein P Fid
Tb Column Mascot Protein P Fid
Tb Cube Procedure Tree
Tb Cube Procedure Tree
Integer
Granularity
Procedure Tree Code P Key
Integer
Input ID
WChar
12
Separation Type
Integer
Separation Initial
WChar
3
Local Level
Integer
Node Name
WChar
18
Node Parent
Integer
Pruned Parent Key
Integer
Pruned Input ID Key
Integer
Full Tree Name
WChar
1000
Pruned Tree Name
WChar
1000
Pruned Local Name
WChar
17
Tb Column Fractions
Node Parent
Regular
Tb Column Fractions
Tb Column Fractions
Express M3
dbo_tb_Column_Fractions
Molap
Regular
-PT1S
-PT1S
-PT1S
-PT1S
-PT1S
-PT1S
-PT1S
-PT1S
Tb Column Fractions 2
Tb Column Fractions peak
Fraction Code P Key Distinct Count 1
in pks FRs
DistinctCount
Integer
Integer
dbo_tb_Column_Fractions
Fraction_Code_PKey
Molap
Regular
Tb Column Fractions
Tb Column Fractions
Integer
dbo_tb_Column_Fractions
Fraction_Code_PKey
Granularity
Fraction ID
WChar
50
Growth Code F Key
Integer
Separation Code F Key
Integer
Fraction Type
Integer
Location Code F Key
Integer
Gradient Code F Key
Integer
Fraction Number
Integer
Fraction Position
Integer
Label Line 1
WChar
20
Label Line 2
WChar
20
Label Line 3
WChar
20
Fraction Volume m L
Double
Fraction Mass Mg
Integer
Fraction Description
WChar
100
Fraction Contact
WChar
50
Fraction Active
Integer
Node Left
Integer
Node Right
Integer
Node Depth
Integer
Node Ordinal
Integer
Node Index
WChar
50
Column Parent
Integer
Column Pool
Integer
Acid Washed Vessel
Integer
Node Parent
Integer
Fraction Code P Key
Integer
Fraction Pos Id
WChar
63
Tb ICPMS Peak
Asvw Column ICPMS Peak Data
Tb Column Mascot Protein P Fid
Asvw Column ICPMS Peak Data
Tb ICPMS Metal
Asvw Column ICPMS Peak Data
Asvw ICPMS Peak Overlap
Asvw Column ICPMS Peak Data Overlap
Asvw ICPMS Metal Overlap
Asvw Column ICPMS Peak Data Overlap
Tb Cube Procedure Tree
Tb Cube Procedure Tree
Integer
Granularity
Procedure Tree Code P Key
Integer
Input ID
WChar
12
Separation Type
Integer
Separation Initial
WChar
3
Local Level
Integer
Node Name
WChar
18
Node Parent
Integer
Pruned Parent Key
Integer
Pruned Input ID Key
Integer
Full Tree Name
WChar
1000
Pruned Tree Name
WChar
1000
Pruned Local Name
WChar
17
Tb Column Fractions
Node Parent
Regular
Tb Column Fractions
Tb Column Fractions
Express M3
dbo_tb_Column_Fractions
Molap
Regular
-PT1S
-PT1S
-PT1S
-PT1S
-PT1S
-PT1S
-PT1S
-PT1S
Tb Column Protein Conc Data
Tb Column Protein Conc Data
Protein Conc Mg Ml 2
Prot mg_ml
Double
Double
dbo_tb_Column_Protein_Conc_Data
Protein_Conc_mg_ml
Tb Column Protein Conc Data Count
Tb Column Protein Conc Data Count
Count
Integer
Integer
4
dbo_tb_Column_Protein_Conc_Data
Protein Conc Mg Ml 3
Total Prot mg
Double
Double
dbo_tb_Column_Protein_Conc_Data
Protein_Conc_mg_ml
Molap
Regular
Tb Column Samples
Tb Column Samples
Integer
dbo_tb_Column_Protein_Conc_Data
Sample_Code_FKey
Granularity
Sample ID
WChar
50
Sample Number
Integer
Sample Volume m L
Double
Sample Type
Integer
Sample Date
Date
Buffer Type
Integer
Buffer Conc m M
Double
Buffer Additions
WChar
20
Location Code F Key
Integer
Comment Code F Key
Integer
Sampled By
WChar
50
Acid Washed Vessel
Integer
Fraction Code F Key
Integer
Tb Column Fractions
Tb Column Fractions
Integer
Granularity
Fraction ID
WChar
50
Growth Code F Key
Integer
Separation Code F Key
Integer
Fraction Type
Integer
Location Code F Key
Integer
Gradient Code F Key
Integer
Fraction Number
Integer
Fraction Position
Integer
Label Line 1
WChar
20
Label Line 2
WChar
20
Label Line 3
WChar
20
Fraction Volume m L
Double
Fraction Mass Mg
Integer
Fraction Description
WChar
100
Fraction Contact
WChar
50
Fraction Active
Integer
Node Left
Integer
Node Right
Integer
Node Depth
Integer
Node Ordinal
Integer
Node Index
WChar
50
Column Parent
Integer
Column Pool
Integer
Acid Washed Vessel
Integer
Node Parent
Integer
Fraction Code P Key
Integer
Fraction Pos Id
WChar
63
Tb Column Samples
Fraction Code F Key
Regular
Tb ICPMS Peak
Asvw Column ICPMS Peak Data
Tb Cube Procedure Tree
Tb Cube Procedure Tree
Integer
Granularity
Procedure Tree Code P Key
Integer
Input ID
WChar
12
Separation Type
Integer
Separation Initial
WChar
3
Local Level
Integer
Node Name
WChar
18
Node Parent
Integer
Pruned Parent Key
Integer
Pruned Input ID Key
Integer
Full Tree Name
WChar
1000
Pruned Tree Name
WChar
1000
Pruned Local Name
WChar
17
Tb Column Fractions
Node Parent
Regular
Tb Column ICPMS Run
Tb Column ICPMS Data u M
Tb Column Protein Conc Data
Tb Column Protein Conc Data
Express M3
dbo_tb_Column_Protein_Conc_Data
Molap
Regular
-PT1S
-PT1S
-PT1S
-PT1S
-PT1S
-PT1S
-PT1S
-PT1S
Tb Column ICPMS Data u M
Tb Column ICPMS Data u M
ICPMS Dilution Factor
ICPMS Dilution Factor
Double
Double
dbo_tb_Column_ICPMS_Data_uM
ICPMS_Dilution_Factor
ICPMS Data Value Ppb
ICPMS Data Value Ppb
Single
Single
dbo_tb_Column_ICPMS_Data_uM
ICPMS_Data_Value_ppb
ICPMS Data Value u M
ICPMS Data Value u M
Single
Single
dbo_tb_Column_ICPMS_Data_uM
ICPMS_Data_Value_uM
Tb Column ICPMS Data u M Count
Tb Column ICPMS Data u M Count
Count
Integer
Integer
4
dbo_tb_Column_ICPMS_Data_uM
Molap
55301
Regular
Tb ICPMS Metal
Tb ICPMS Metal
Integer
dbo_tb_Column_ICPMS_Data_uM
ICPMS_Metal_Code_FKey
Granularity
Metal ID
WChar
50
Atomic Number
Integer
Isotopic Mass
Integer
Metal Symbol
WChar
3
Metal Name
WChar
20
Default Data Public
Integer
Default Collision Mode
Integer
Tb Column Fractions
Tb Column Fractions
Integer
dbo_tb_Column_ICPMS_Data_uM
Fraction_Code_FKey
Granularity
Fraction ID
WChar
50
Growth Code F Key
Integer
Separation Code F Key
Integer
Fraction Type
Integer
Location Code F Key
Integer
Gradient Code F Key
Integer
Fraction Number
Integer
Fraction Position
Integer
Label Line 1
WChar
20
Label Line 2
WChar
20
Label Line 3
WChar
20
Fraction Volume m L
Double
Fraction Mass Mg
Integer
Fraction Description
WChar
100
Fraction Contact
WChar
50
Fraction Active
Integer
Node Left
Integer
Node Right
Integer
Node Depth
Integer
Node Ordinal
Integer
Node Index
WChar
50
Column Parent
Integer
Column Pool
Integer
Acid Washed Vessel
Integer
Node Parent
Integer
Fraction Code P Key
Integer
Fraction Pos Id
WChar
63
Tb ICPMS Peak
Asvw Column ICPMS Peak Data
Tb Cube Procedure Tree
Tb Cube Procedure Tree
Integer
Granularity
Procedure Tree Code P Key
Integer
Input ID
WChar
12
Separation Type
Integer
Separation Initial
WChar
3
Local Level
Integer
Node Name
WChar
18
Node Parent
Integer
Pruned Parent Key
Integer
Pruned Input ID Key
Integer
Full Tree Name
WChar
1000
Pruned Tree Name
WChar
1000
Pruned Local Name
WChar
17
Tb Column Fractions
Node Parent
Regular
Tb Column ICPMS Run
Tb Column ICPMS Run
Integer
dbo_tb_Column_ICPMS_Data_uM
ICPMS_Run_Code_FKey
Granularity
ICPMS Run Number
Integer
ICPMS Acid
Integer
ICPMS Cone
Integer
ICPMS Acquisition Mode
Integer
ICPMS Run By
WChar
50
ICPMS Run Date
Date
ICPMS Run File Name
WChar
500
ICPMS Data Upload Date
Date
ICPMS Run Comments
WChar
ICPMS Run ID
WChar
17
Tb Column ICPMS Dataset
Integer
ICPMS Dataset Name
WChar
50
ICPMS Dataset Comments
WChar
Pruned Tree Name
WChar
1000
Column Fraction Code F Key
Integer
Tb Column ICPMS Data u M
Tb Column ICPMS Data u M
AggregationPercent
70
Express M3
dbo_tb_Column_ICPMS_Data_uM
Molap
Regular
-PT1S
-PT1S
-PT1S
-PT1S
MolapOnly
Server
55301
AggregationDesign
AggregationDesign
AggregationDesign
55301
Tb ICPMS Metal
Tb ICPMS Metal
95
Metal ID
95
Atomic Number
66
Isotopic Mass
93
Metal Symbol
66
Metal Name
66
Default Data Public
2
Default Collision Mode
2
Tb Column Fractions
Tb Column Fractions
1715
Fraction ID
1715
Growth Code F Key
1
Separation Code F Key
35
Fraction Type
9
Location Code F Key
1
Gradient Code F Key
68
Fraction Number
120
Fraction Position
127
Label Line 1
818
Label Line 2
462
Label Line 3
602
Fraction Volume m L
90
Fraction Mass Mg
1
Fraction Description
20
Fraction Contact
1
Fraction Active
1
Node Left
1715
Node Right
1715
Node Depth
8
Node Ordinal
70
Node Index
1628
Column Parent
27
Column Pool
44
Acid Washed Vessel
2
Node Parent
36
Fraction Code P Key
Fraction Pos Id
Tb ICPMS Peak
Tb ICPMS Peak
739
ICPMS Dataset Code F Key
39
ICPMS Metal Code F Key
25
ICPMS Peak Name
119
ICPMS Peak Letter
15
ICPMS Peak Ordinal
15
ICPMS Peak Comments
24
Tb Cube Procedure Tree
Tb Cube Procedure Tree
66
Procedure Tree Code P Key
66
Input ID
23
Separation Type
2
Separation Initial
2
Local Level
6
Node Name
29
Node Parent
52
Pruned Parent Key
Pruned Input ID Key
66
Full Tree Name
66
Pruned Tree Name
66
Pruned Local Name
51
Tb Column ICPMS Run
Tb Column ICPMS Run
119
ICPMS Run Number
5
ICPMS Acid
3
ICPMS Cone
3
ICPMS Acquisition Mode
4
ICPMS Run By
5
ICPMS Run Date
85
ICPMS Run File Name
119
ICPMS Data Upload Date
119
ICPMS Run Comments
1
ICPMS Run ID
119
Tb Column ICPMS Dataset
62
ICPMS Dataset Name
61
ICPMS Dataset Comments
27
Pruned Tree Name
62
Column Fraction Code F Key
Aggregation 0
Aggregation 0
Tb ICPMS Metal
Tb Column Fractions
Tb ICPMS Peak
Tb Cube Procedure Tree
Tb Column ICPMS Run
Aggregation 1
Aggregation 1
Tb ICPMS Metal
Tb Column Fractions
Tb ICPMS Peak
Tb Cube Procedure Tree
Tb Column ICPMS Run
Aggregation 2
Aggregation 2
Tb ICPMS Metal
Tb Column Fractions
Tb Column Fractions
Tb ICPMS Peak
Tb Cube Procedure Tree
Tb Column ICPMS Run
Aggregation 3
Aggregation 3
Tb ICPMS Metal
Tb ICPMS Metal
Tb Column Fractions
Tb ICPMS Peak
Tb Cube Procedure Tree
Tb Column ICPMS Run
Aggregation 4
Aggregation 4
Tb ICPMS Metal
Tb ICPMS Metal
Tb Column Fractions
Tb ICPMS Peak
Tb Cube Procedure Tree
Tb Column ICPMS Run
Aggregation 5
Aggregation 5
Tb ICPMS Metal
Tb Column Fractions
Tb ICPMS Peak
Tb Cube Procedure Tree
Tb Column ICPMS Run
Aggregation 6
Aggregation 6
Tb ICPMS Metal
Tb Column Fractions
Tb ICPMS Peak
Tb Cube Procedure Tree
Tb Column ICPMS Run
Aggregation 7
Aggregation 7
Tb ICPMS Metal
Tb ICPMS Metal
Tb Column Fractions
Tb ICPMS Peak
Tb Cube Procedure Tree
Tb Column ICPMS Run
Aggregation 8
Aggregation 8
Tb ICPMS Metal
Tb Column Fractions
Tb ICPMS Peak
Tb Cube Procedure Tree
Tb Column ICPMS Run
Aggregation 9
Aggregation 9
Tb ICPMS Metal
Tb Column Fractions
Tb ICPMS Peak
Tb Cube Procedure Tree
Tb Column ICPMS Run
Aggregation a
Aggregation a
Tb ICPMS Metal
Tb Column Fractions
Tb ICPMS Peak
Tb Cube Procedure Tree
Tb Column ICPMS Run
Aggregation b
Aggregation b
Tb ICPMS Metal
Tb Column Fractions
Tb ICPMS Peak
Tb Cube Procedure Tree
Tb Column ICPMS Run
Aggregation c
Aggregation c
Tb ICPMS Metal
Tb ICPMS Metal
Tb Column Fractions
Tb ICPMS Peak
Tb Cube Procedure Tree
Tb Column ICPMS Run
Aggregation d
Aggregation d
Tb ICPMS Metal
Tb ICPMS Metal
Tb Column Fractions
Tb ICPMS Peak
Tb Cube Procedure Tree
Tb Column ICPMS Run
Aggregation e
Aggregation e
Tb ICPMS Metal
Tb ICPMS Metal
Tb Column Fractions
Tb ICPMS Peak
Tb Cube Procedure Tree
Tb Column ICPMS Run
Aggregation f
Aggregation f
Tb ICPMS Metal
Tb Column Fractions
Tb ICPMS Peak
Tb Cube Procedure Tree
Tb Column ICPMS Run
Aggregation 10
Aggregation 10
Tb ICPMS Metal
Tb Column Fractions
Tb ICPMS Peak
Tb Cube Procedure Tree
Tb Column ICPMS Run
-PT1S
-PT1S
-PT1S
-PT1S
Tb Column Mascot Peptide
Tb Column Mascot Peptide
Pep Score
Pep Score
Double
Double
dbo_tb_Column_Mascot_Peptide
pep_score
Pep Expect
Pep Expect
Double
Double
dbo_tb_Column_Mascot_Peptide
pep_expect
Pep Rank
Pep Rank
Integer
Integer
dbo_tb_Column_Mascot_Peptide
pep_rank
Tb Column Mascot Peptide Count
Uniq Peps
DistinctCount
Double
Double
dbo_tb_Column_Mascot_Peptide
pep_calc_mr
Tb Column Mascot Peptide Count 1
Peps
Integer
Integer
dbo_tb_Column_Mascot_Peptide
Mascot_Peptide_Code_PKey
Tb Column Mascot Peptide Count 2
Total Peps
Count
Integer
Integer
4
dbo_tb_Column_Mascot_Peptide
Molap
169222
Regular
Tb Column Mascot Protein P Fid
Tb Column Mascot Protein P Fid
Integer
dbo_tb_Column_Mascot_Peptide
Mascot_Protein_Code_FKey
Granularity
Prot Desc
WChar
255
Prot Score
Double
Prot Thresh
Double
Prot Expect
Double
Prot Mass
Double
Prot Matches
BigInt
Prot Cover
Double
Prot Len
BigInt
Prot Pi
Double
Prot Tax Str
WChar
255
Prot Tax Id
BigInt
Accession
WChar
255
Gi
Integer
P Fid
WChar
15
Mascot Hit Code F Key
Integer
p I
Double
Tb Column Mascot Hit
Tb Column Mascot Hit
Integer
Granularity
Number
Integer
Mascot Header Code F Key
Integer
Tb Column Mascot Protein P Fid
Mascot Hit Code F Key
Regular
Tb Column Mascot Header
Tb Column Mascot Header
Integer
Granularity
XML File Name
WChar
255
Mass Spec Type
Integer
Plate Code F Key
Integer
Well Name
WChar
50
Plate Well Name
WChar
50
Gel Band ID
WChar
50
Load Sequence
UnsignedTinyInt
COM
WChar
255
Date
WChar
255
USERNAME
WChar
255
USEREMAIL
WChar
255
URI
WChar
255
FILENAME
WChar
255
FORMAT
WChar
255
SEARCH
WChar
255
Mascot Ver
WChar
255
DB
WChar
255
Fasta Ver
WChar
255
Num Seqs
BigInt
Num Residues
BigInt
Num Seqs After Tax
BigInt
Error Tolerant Num
BigInt
Num Queries
BigInt
File Comment
WChar
1024
Sample Code F Key
Integer
Tb Column Mascot Hit
Mascot Header Code F Key
Regular
Tb Column Samples
Tb Column Samples
Integer
Granularity
Sample ID
WChar
50
Sample Number
Integer
Sample Volume m L
Double
Sample Type
Integer
Sample Date
Date
Buffer Type
Integer
Buffer Conc m M
Double
Buffer Additions
WChar
20
Location Code F Key
Integer
Comment Code F Key
Integer
Sampled By
WChar
50
Acid Washed Vessel
Integer
Fraction Code F Key
Integer
Tb Column Mascot Header
Sample Code F Key
Regular
Tb Column Fractions
Tb Column Fractions
Integer
Granularity
Fraction ID
WChar
50
Growth Code F Key
Integer
Separation Code F Key
Integer
Fraction Type
Integer
Location Code F Key
Integer
Gradient Code F Key
Integer
Fraction Number
Integer
Fraction Position
Integer
Label Line 1
WChar
20
Label Line 2
WChar
20
Label Line 3
WChar
20
Fraction Volume m L
Double
Fraction Mass Mg
Integer
Fraction Description
WChar
100
Fraction Contact
WChar
50
Fraction Active
Integer
Node Left
Integer
Node Right
Integer
Node Depth
Integer
Node Ordinal
Integer
Node Index
WChar
50
Column Parent
Integer
Column Pool
Integer
Acid Washed Vessel
Integer
Node Parent
Integer
Fraction Code P Key
Integer
Fraction Pos Id
WChar
63
Tb Column Samples
Fraction Code F Key
Regular
Tb ICPMS Peak
Asvw Column ICPMS Peak Data
Tb Cube Procedure Tree
Tb Cube Procedure Tree
Integer
Granularity
Procedure Tree Code P Key
Integer
Input ID
WChar
12
Separation Type
Integer
Separation Initial
WChar
3
Local Level
Integer
Node Name
WChar
18
Node Parent
Integer
Pruned Parent Key
Integer
Pruned Input ID Key
Integer
Full Tree Name
WChar
1000
Pruned Tree Name
WChar
1000
Pruned Local Name
WChar
17
Tb Column Fractions
Node Parent
Regular
Tb IPMD LF
Tb Column Mascot Protein P Fid
Tb Column ICPMS Run
Tb Column ICPMS Data u M
Tb Column Mascot Peptide
Tb Column Mascot Peptide
AggregationPercent
90
Express M3
dbo_tb_Column_Mascot_Peptide
Molap
Regular
-PT1S
-PT1S
-PT1S
-PT1S
MolapOnly
Server
169222
AggregationDesign
AggregationDesign
AggregationDesign
169222
Tb Column Mascot Protein P Fid
Tb Column Mascot Protein P Fid
18249
Prot Desc
Prot Score
Prot Thresh
1
Prot Expect
1
Prot Mass
Prot Matches
Prot Cover
1
Prot Len
1
Prot Pi
1
Prot Tax Str
1
Prot Tax Id
1
Accession
Gi
P Fid
Mascot Hit Code F Key
p I
Tb Column Mascot Hit
Tb Column Mascot Hit
18035
Number
156
Mascot Header Code F Key
Tb Column Mascot Header
Tb Column Mascot Header
1595
XML File Name
1595
Mass Spec Type
3
Plate Code F Key
22
Well Name
97
Plate Well Name
1531
Gel Band ID
48
Load Sequence
108
COM
1526
Date
1594
USERNAME
3
USEREMAIL
1
URI
1594
FILENAME
1594
FORMAT
1
SEARCH
1
Mascot Ver
1
DB
2
Fasta Ver
2
Num Seqs
1
Num Residues
3
Num Seqs After Tax
1
Error Tolerant Num
1
Num Queries
1362
File Comment
9
Sample Code F Key
1526
Tb Column Samples
Tb Column Samples
8562
Sample ID
8562
Sample Number
12
Sample Volume m L
12
Sample Type
6
Sample Date
18
Buffer Type
1
Buffer Conc m M
1
Buffer Additions
2
Location Code F Key
1
Comment Code F Key
4
Sampled By
8
Acid Washed Vessel
2
Fraction Code F Key
1709
Tb Column Fractions
Tb Column Fractions
1715
Fraction ID
1715
Growth Code F Key
1
Separation Code F Key
35
Fraction Type
9
Location Code F Key
1
Gradient Code F Key
68
Fraction Number
120
Fraction Position
127
Label Line 1
818
Label Line 2
462
Label Line 3
602
Fraction Volume m L
90
Fraction Mass Mg
1
Fraction Description
20
Fraction Contact
1
Fraction Active
1
Node Left
1715
Node Right
1715
Node Depth
8
Node Ordinal
70
Node Index
1628
Column Parent
27
Column Pool
44
Acid Washed Vessel
2
Node Parent
36
Fraction Code P Key
Fraction Pos Id
Tb ICPMS Peak
Tb ICPMS Peak
739
ICPMS Dataset Code F Key
39
ICPMS Metal Code F Key
25
ICPMS Peak Name
119
ICPMS Peak Letter
15
ICPMS Peak Ordinal
15
ICPMS Peak Comments
24
Tb Cube Procedure Tree
Tb Cube Procedure Tree
66
Procedure Tree Code P Key
66
Input ID
23
Separation Type
2
Separation Initial
2
Local Level
6
Node Name
29
Node Parent
52
Pruned Parent Key
Pruned Input ID Key
66
Full Tree Name
66
Pruned Tree Name
66
Pruned Local Name
51
Tb IPMD LF
Tb IPMD LF
4554
NCBI Gene Code F Key
487
Orf Num
487
Ipr Num
325
Match Type
8
Pattern
44
Keyword
17
Left Match
580
Hit Match
100
Right Match
625
Min Ac Score
1
Max Ac Score
1
Ipr Name
533
Hscore
5
Tb IPR Entry List
325
Tb IPR Entry List - IPR Num
Run Date
1
Tb IPR Entry List - IPR Name
Entry Type
8
Gm Num
487
Tb Element
118
Atomic Number
118
Name
118
Symbol
118
Period
7
Group
19
Tb Element Series
10
Tb Element Series - Name
10
Tb Column ICPMS Run
Tb Column ICPMS Run
119
ICPMS Run Number
5
ICPMS Acid
3
ICPMS Cone
3
ICPMS Acquisition Mode
4
ICPMS Run By
5
ICPMS Run Date
85
ICPMS Run File Name
119
ICPMS Data Upload Date
119
ICPMS Run Comments
1
ICPMS Run ID
119
Tb Column ICPMS Dataset
62
ICPMS Dataset Name
61
ICPMS Dataset Comments
27
Pruned Tree Name
62
Column Fraction Code F Key
Aggregation 0
Aggregation 0
Tb Column Mascot Protein P Fid
Tb Column Mascot Hit
Tb Column Mascot Header
Tb Column Samples
Tb Column Fractions
Tb ICPMS Peak
Tb Cube Procedure Tree
Tb IPMD LF
Tb Column ICPMS Run
Aggregation 1
Aggregation 1
Tb Column Mascot Protein P Fid
Tb Column Mascot Hit
Tb Column Mascot Header
Tb Column Samples
Tb Column Fractions
Tb ICPMS Peak
Tb Cube Procedure Tree
Tb IPMD LF
Tb Column ICPMS Run
Aggregation 2
Aggregation 2
Tb Column Mascot Protein P Fid
Tb Column Mascot Hit
Tb Column Mascot Header
Tb Column Samples
Tb Column Samples
Tb Column Fractions
Tb ICPMS Peak
Tb Cube Procedure Tree
Tb IPMD LF
Tb Column ICPMS Run
Aggregation 3
Aggregation 3
Tb Column Mascot Protein P Fid
Tb Column Mascot Hit
Tb Column Mascot Header
Tb Column Samples
Tb Column Fractions
Tb ICPMS Peak
Tb Cube Procedure Tree
Tb IPMD LF
Tb Column ICPMS Run
Aggregation 4
Aggregation 4
Tb Column Mascot Protein P Fid
Tb Column Mascot Hit
Tb Column Mascot Header
Tb Column Samples
Tb Column Fractions
Tb ICPMS Peak
Tb Cube Procedure Tree
Tb IPMD LF
Tb Column ICPMS Run
Aggregation 5
Aggregation 5
Tb Column Mascot Protein P Fid
Tb Column Mascot Hit
Tb Column Mascot Header
Tb Column Mascot Header
Tb Column Samples
Tb Column Fractions
Tb ICPMS Peak
Tb Cube Procedure Tree
Tb IPMD LF
Tb Column ICPMS Run
Aggregation 6
Aggregation 6
Tb Column Mascot Protein P Fid
Tb Column Mascot Hit
Tb Column Mascot Header
Tb Column Samples
Tb Column Fractions
Tb Column Fractions
Tb ICPMS Peak
Tb Cube Procedure Tree
Tb IPMD LF
Tb Column ICPMS Run
Aggregation 7
Aggregation 7
Tb Column Mascot Protein P Fid
Tb Column Mascot Hit
Tb Column Mascot Hit
Tb Column Mascot Header
Tb Column Samples
Tb Column Fractions
Tb ICPMS Peak
Tb Cube Procedure Tree
Tb IPMD LF
Tb Column ICPMS Run
Aggregation 8
Aggregation 8
Tb Column Mascot Protein P Fid
Tb Column Mascot Protein P Fid
Tb Column Mascot Hit
Tb Column Mascot Header
Tb Column Samples
Tb Column Fractions
Tb ICPMS Peak
Tb Cube Procedure Tree
Tb IPMD LF
Tb Column ICPMS Run
Aggregation 9
Aggregation 9
Tb Column Mascot Protein P Fid
Tb Column Mascot Hit
Tb Column Mascot Header
Tb Column Mascot Header
Tb Column Samples
Tb Column Fractions
Tb ICPMS Peak
Tb Cube Procedure Tree
Tb IPMD LF
Tb Column ICPMS Run
Aggregation a
Aggregation a
Tb Column Mascot Protein P Fid
Tb Column Mascot Hit
Tb Column Mascot Header
Tb Column Samples
Tb Column Fractions
Tb Column Fractions
Tb ICPMS Peak
Tb Cube Procedure Tree
Tb IPMD LF
Tb Column ICPMS Run
Aggregation b
Aggregation b
Tb Column Mascot Protein P Fid
Tb Column Mascot Hit
Tb Column Mascot Header
Tb Column Mascot Header
Tb Column Samples
Tb Column Fractions
Tb ICPMS Peak
Tb Cube Procedure Tree
Tb IPMD LF
Tb Column ICPMS Run
-PT1S
-PT1S
-PT1S
-PT1S
Tb Metal Protein Potential Peak
Tb Metal Protein Potential Peak
Correlation
peak corr
Double
Double
dbo_tb_Metal_Protein_Potential_Peak
Correlation
Correlation 2
peak peps corr sum
Double
Double
dbo_tb_Metal_Protein_Potential_Peak
Correlation
Molap
Regular
Tb ICPMS Peak
Tb ICPMS Peak
Integer
dbo_tb_Metal_Protein_Potential_Peak
ICPMS_Peak_Code_FKey
Granularity
ICPMS Dataset Code F Key
Integer
ICPMS Metal Code F Key
Integer
ICPMS Peak Name
WChar
20
ICPMS Peak Letter
WChar
5
ICPMS Peak Ordinal
Integer
ICPMS Peak Comments
WChar
Tb ICPMS Metal
Tb ICPMS Metal
Integer
Granularity
Metal ID
WChar
50
Atomic Number
Integer
Isotopic Mass
Integer
Metal Symbol
WChar
3
Metal Name
WChar
20
Default Data Public
Integer
Default Collision Mode
Integer
Tb ICPMS Peak
ICPMS Metal Code F Key
Regular
Tb Column ICPMS Dataset
Tb Column ICPMS Dataset
Integer
Granularity
ICPMS Dataset Name
WChar
50
ICPMS Dataset Comments
WChar
Column Fraction Code F Key
Integer
Pruned Tree Name
WChar
1000
Tb ICPMS Peak
ICPMS Dataset Code F Key
Regular
Tb Column Separation Hierarchy
Tb Column Separation Hierarchy
Integer
Granularity
Separation Hierarchy Code P Key
Integer
Local Metal
WChar
2
Local Pool
WChar
1
Local Separation Type
Integer
Local Separation Initial
WChar
3
Local Level
Integer
Local Name
WChar
8
Column Pool Key
Integer
Column Parent Key
Integer
Node Parent
Integer
Column Local Name
WChar
8
Full Hierarchy Name
WChar
1000
Column Hierarchy Name
WChar
1000
Fraction Code F Key
Integer
Fraction Code F Key 1
Integer
Tb Column ICPMS Dataset
Column Fraction Code F Key
Regular
Tb Metal Protein Potential Peak
Tb Metal Protein Potential Peak
Express M3
dbo_tb_Metal_Protein_Potential_Peak
Molap
Regular
-PT1S
-PT1S
-PT1S
-PT1S
-PT1S
-PT1S
-PT1S
-PT1S
Tb Metal Protein Potential Col
Tb Metal Protein Potential Col
Correlation - Tb Metal Protein Potential Col
col corr
Double
Double
dbo_tb_Metal_Protein_Potential_Col
Correlation
Correlation 1
weighted col subscore
Double
Double
dbo_tb_Metal_Protein_Potential_Col
Correlation
Molap
Regular
Tb ICPMS Metal
Tb ICPMS Metal
Integer
dbo_tb_Metal_Protein_Potential_Col
ICPMS_Metal_Code_FKey
Granularity
Metal ID
WChar
50
Atomic Number
Integer
Isotopic Mass
Integer
Metal Symbol
WChar
3
Metal Name
WChar
20
Default Data Public
Integer
Default Collision Mode
Integer
Tb Column Separation Hierarchy
Tb Column Separation Hierarchy
Integer
dbo_tb_Metal_Protein_Potential_Col
Column_Fraction_Code_FKey
Granularity
Separation Hierarchy Code P Key
Integer
Local Metal
WChar
2
Local Pool
WChar
1
Local Separation Type
Integer
Local Separation Initial
WChar
3
Local Level
Integer
Local Name
WChar
8
Column Pool Key
Integer
Column Parent Key
Integer
Node Parent
Integer
Column Local Name
WChar
8
Full Hierarchy Name
WChar
1000
Column Hierarchy Name
WChar
1000
Fraction Code F Key
Integer
Fraction Code F Key 1
Integer
Tb Metal Protein Potential Col
Tb Metal Protein Potential Col
Express M3
dbo_tb_Metal_Protein_Potential_Col
Molap
Regular
-PT1S
-PT1S
-PT1S
-PT1S
-PT1S
-PT1S
-PT1S
-PT1S
Tb Column Mascot Peptide 1
Tb Column Mascot Peptide 1
Pep Calc Mr Distinct Count
Peak Uniq Peps
DistinctCount
Integer
Double
dbo_tb_Column_Mascot_Peptide
pep_calc_mr
Molap
169222
Regular
Tb Column Mascot Protein P Fid
Tb Column Mascot Protein P Fid
Integer
dbo_tb_Column_Mascot_Peptide
Mascot_Protein_Code_FKey
Granularity
Prot Desc
WChar
255
Prot Score
Double
Prot Thresh
Double
Prot Expect
Double
Prot Mass
Double
Prot Matches
BigInt
Prot Cover
Double
Prot Len
BigInt
Prot Pi
Double
Prot Tax Str
WChar
255
Prot Tax Id
BigInt
Accession
WChar
255
Gi
Integer
P Fid
WChar
15
Mascot Hit Code F Key
Integer
p I
Double
Tb Column Mascot Hit
Tb Column Mascot Hit
Integer
Granularity
Number
Integer
Mascot Header Code F Key
Integer
Tb Column Mascot Protein P Fid
Mascot Hit Code F Key
Regular
Tb Column Mascot Header
Tb Column Mascot Header
Integer
Granularity
XML File Name
WChar
255
Mass Spec Type
Integer
Plate Code F Key
Integer
Well Name
WChar
50
Plate Well Name
WChar
50
Gel Band ID
WChar
50
Load Sequence
UnsignedTinyInt
COM
WChar
255
Date
WChar
255
USERNAME
WChar
255
USEREMAIL
WChar
255
URI
WChar
255
FILENAME
WChar
255
FORMAT
WChar
255
SEARCH
WChar
255
Mascot Ver
WChar
255
DB
WChar
255
Fasta Ver
WChar
255
Num Seqs
BigInt
Num Residues
BigInt
Num Seqs After Tax
BigInt
Error Tolerant Num
BigInt
Num Queries
BigInt
File Comment
WChar
1024
Sample Code F Key
Integer
Tb Column Mascot Hit
Mascot Header Code F Key
Regular
Tb Column Samples
Tb Column Samples
Integer
Granularity
Sample ID
WChar
50
Sample Number
Integer
Sample Volume m L
Double
Sample Type
Integer
Sample Date
Date
Buffer Type
Integer
Buffer Conc m M
Double
Buffer Additions
WChar
20
Location Code F Key
Integer
Comment Code F Key
Integer
Sampled By
WChar
50
Acid Washed Vessel
Integer
Fraction Code F Key
Integer
Tb Column Mascot Header
Sample Code F Key
Regular
Tb Column Fractions
Tb Column Fractions
Integer
Granularity
Fraction ID
WChar
50
Growth Code F Key
Integer
Separation Code F Key
Integer
Fraction Type
Integer
Location Code F Key
Integer
Gradient Code F Key
Integer
Fraction Number
Integer
Fraction Position
Integer
Label Line 1
WChar
20
Label Line 2
WChar
20
Label Line 3
WChar
20
Fraction Volume m L
Double
Fraction Mass Mg
Integer
Fraction Description
WChar
100
Fraction Contact
WChar
50
Fraction Active
Integer
Node Left
Integer
Node Right
Integer
Node Depth
Integer
Node Ordinal
Integer
Node Index
WChar
50
Column Parent
Integer
Column Pool
Integer
Acid Washed Vessel
Integer
Node Parent
Integer
Fraction Code P Key
Integer
Fraction Pos Id
WChar
63
Tb Column Samples
Fraction Code F Key
Regular
Tb ICPMS Peak
Asvw Column ICPMS Peak Data
Tb ICPMS Metal
Asvw Column ICPMS Peak Data
Tb Cube Procedure Tree
Tb Cube Procedure Tree
Integer
Granularity
Procedure Tree Code P Key
Integer
Input ID
WChar
12
Separation Type
Integer
Separation Initial
WChar
3
Local Level
Integer
Node Name
WChar
18
Node Parent
Integer
Pruned Parent Key
Integer
Pruned Input ID Key
Integer
Full Tree Name
WChar
1000
Pruned Tree Name
WChar
1000
Pruned Local Name
WChar
17
Tb Column Fractions
Node Parent
Regular
Tb IPMD LF
Tb Column Mascot Protein P Fid
Tb Column ICPMS Run
Tb Column ICPMS Data u M
Tb Column Mascot Peptide
Tb Column Mascot Peptide
AggregationPercent
90
Express M3
dbo_tb_Column_Mascot_Peptide
Molap
Regular
-PT1S
-PT1S
-PT1S
-PT1S
MolapOnly
Server
169222
AggregationDesign
AggregationDesign
AggregationDesign
169222
Tb Column Mascot Protein P Fid
Tb Column Mascot Protein P Fid
18249
Prot Desc
Prot Score
Prot Thresh
1
Prot Expect
1
Prot Mass
Prot Matches
Prot Cover
1
Prot Len
1
Prot Pi
1
Prot Tax Str
1
Prot Tax Id
1
Accession
Gi
P Fid
Mascot Hit Code F Key
p I
Tb Column Mascot Hit
Tb Column Mascot Hit
18035
Number
156
Mascot Header Code F Key
Tb Column Mascot Header
Tb Column Mascot Header
1595
XML File Name
1595
Mass Spec Type
3
Plate Code F Key
22
Well Name
97
Plate Well Name
1531
Gel Band ID
48
Load Sequence
108
COM
1526
Date
1594
USERNAME
3
USEREMAIL
1
URI
1594
FILENAME
1594
FORMAT
1
SEARCH
1
Mascot Ver
1
DB
2
Fasta Ver
2
Num Seqs
1
Num Residues
3
Num Seqs After Tax
1
Error Tolerant Num
1
Num Queries
1362
File Comment
9
Sample Code F Key
1526
Tb Column Samples
Tb Column Samples
8562
Sample ID
8562
Sample Number
12
Sample Volume m L
12
Sample Type
6
Sample Date
18
Buffer Type
1
Buffer Conc m M
1
Buffer Additions
2
Location Code F Key
1
Comment Code F Key
4
Sampled By
8
Acid Washed Vessel
2
Fraction Code F Key
1709
Tb Column Fractions
Tb Column Fractions
1715
Fraction ID
1715
Growth Code F Key
1
Separation Code F Key
35
Fraction Type
9
Location Code F Key
1
Gradient Code F Key
68
Fraction Number
120
Fraction Position
127
Label Line 1
818
Label Line 2
462
Label Line 3
602
Fraction Volume m L
90
Fraction Mass Mg
1
Fraction Description
20
Fraction Contact
1
Fraction Active
1
Node Left
1715
Node Right
1715
Node Depth
8
Node Ordinal
70
Node Index
1628
Column Parent
27
Column Pool
44
Acid Washed Vessel
2
Node Parent
36
Fraction Code P Key
Fraction Pos Id
Tb ICPMS Peak
Tb ICPMS Peak
739
ICPMS Dataset Code F Key
39
ICPMS Metal Code F Key
25
ICPMS Peak Name
119
ICPMS Peak Letter
15
ICPMS Peak Ordinal
15
ICPMS Peak Comments
24
Tb ICPMS Metal
Tb ICPMS Metal
95
Metal ID
95
Atomic Number
66
Isotopic Mass
93
Metal Symbol
66
Metal Name
66
Default Data Public
2
Default Collision Mode
2
Tb Cube Procedure Tree
Tb Cube Procedure Tree
66
Procedure Tree Code P Key
66
Input ID
23
Separation Type
2
Separation Initial
2
Local Level
6
Node Name
29
Node Parent
52
Pruned Parent Key
Pruned Input ID Key
66
Full Tree Name
66
Pruned Tree Name
66
Pruned Local Name
51
Tb IPMD LF
Tb IPMD LF
4554
NCBI Gene Code F Key
487
Orf Num
487
Ipr Num
325
Match Type
8
Pattern
44
Keyword
17
Left Match
580
Hit Match
100
Right Match
625
Min Ac Score
1
Max Ac Score
1
Ipr Name
533
Hscore
5
Tb IPR Entry List
325
Tb IPR Entry List - IPR Num
Run Date
1
Tb IPR Entry List - IPR Name
Entry Type
8
Gm Num
487
Tb Element
118
Atomic Number
118
Name
118
Symbol
118
Period
7
Group
19
Tb Element Series
10
Tb Element Series - Name
10
Tb Column ICPMS Run
Tb Column ICPMS Run
119
ICPMS Run Number
5
ICPMS Acid
3
ICPMS Cone
3
ICPMS Acquisition Mode
4
ICPMS Run By
5
ICPMS Run Date
85
ICPMS Run File Name
119
ICPMS Data Upload Date
119
ICPMS Run Comments
1
ICPMS Run ID
119
Tb Column ICPMS Dataset
62
ICPMS Dataset Name
61
ICPMS Dataset Comments
27
Pruned Tree Name
62
Column Fraction Code F Key
Aggregation 0
Aggregation 0
Tb Column Mascot Protein P Fid
Tb Column Mascot Hit
Tb Column Mascot Header
Tb Column Samples
Tb Column Fractions
Tb ICPMS Peak
Tb ICPMS Metal
Tb Cube Procedure Tree
Tb IPMD LF
Tb Column ICPMS Run
Aggregation 1
Aggregation 1
Tb Column Mascot Protein P Fid
Tb Column Mascot Hit
Tb Column Mascot Header
Tb Column Samples
Tb Column Fractions
Tb ICPMS Peak
Tb ICPMS Metal
Tb Cube Procedure Tree
Tb IPMD LF
Tb Column ICPMS Run
Aggregation 2
Aggregation 2
Tb Column Mascot Protein P Fid
Tb Column Mascot Hit
Tb Column Mascot Header
Tb Column Samples
Tb Column Samples
Tb Column Fractions
Tb ICPMS Peak
Tb ICPMS Metal
Tb Cube Procedure Tree
Tb IPMD LF
Tb Column ICPMS Run
Aggregation 3
Aggregation 3
Tb Column Mascot Protein P Fid
Tb Column Mascot Hit
Tb Column Mascot Header
Tb Column Samples
Tb Column Fractions
Tb ICPMS Peak
Tb ICPMS Metal
Tb Cube Procedure Tree
Tb IPMD LF
Tb Column ICPMS Run
Aggregation 4
Aggregation 4
Tb Column Mascot Protein P Fid
Tb Column Mascot Hit
Tb Column Mascot Header
Tb Column Samples
Tb Column Fractions
Tb ICPMS Peak
Tb ICPMS Metal
Tb Cube Procedure Tree
Tb IPMD LF
Tb Column ICPMS Run
Aggregation 5
Aggregation 5
Tb Column Mascot Protein P Fid
Tb Column Mascot Hit
Tb Column Mascot Header
Tb Column Mascot Header
Tb Column Samples
Tb Column Fractions
Tb ICPMS Peak
Tb ICPMS Metal
Tb Cube Procedure Tree
Tb IPMD LF
Tb Column ICPMS Run
Aggregation 6
Aggregation 6
Tb Column Mascot Protein P Fid
Tb Column Mascot Hit
Tb Column Mascot Header
Tb Column Samples
Tb Column Fractions
Tb Column Fractions
Tb ICPMS Peak
Tb ICPMS Metal
Tb Cube Procedure Tree
Tb IPMD LF
Tb Column ICPMS Run
Aggregation 7
Aggregation 7
Tb Column Mascot Protein P Fid
Tb Column Mascot Hit
Tb Column Mascot Hit
Tb Column Mascot Header
Tb Column Samples
Tb Column Fractions
Tb ICPMS Peak
Tb ICPMS Metal
Tb Cube Procedure Tree
Tb IPMD LF
Tb Column ICPMS Run
Aggregation 8
Aggregation 8
Tb Column Mascot Protein P Fid
Tb Column Mascot Protein P Fid
Tb Column Mascot Hit
Tb Column Mascot Header
Tb Column Samples
Tb Column Fractions
Tb ICPMS Peak
Tb ICPMS Metal
Tb Cube Procedure Tree
Tb IPMD LF
Tb Column ICPMS Run
Aggregation 9
Aggregation 9
Tb Column Mascot Protein P Fid
Tb Column Mascot Hit
Tb Column Mascot Header
Tb Column Mascot Header
Tb Column Samples
Tb Column Fractions
Tb ICPMS Peak
Tb ICPMS Metal
Tb Cube Procedure Tree
Tb IPMD LF
Tb Column ICPMS Run
Aggregation a
Aggregation a
Tb Column Mascot Protein P Fid
Tb Column Mascot Hit
Tb Column Mascot Header
Tb Column Samples
Tb Column Fractions
Tb Column Fractions
Tb ICPMS Peak
Tb ICPMS Metal
Tb Cube Procedure Tree
Tb IPMD LF
Tb Column ICPMS Run
Aggregation b
Aggregation b
Tb Column Mascot Protein P Fid
Tb Column Mascot Hit
Tb Column Mascot Header
Tb Column Mascot Header
Tb Column Samples
Tb Column Fractions
Tb ICPMS Peak
Tb ICPMS Metal
Tb Cube Procedure Tree
Tb IPMD LF
Tb Column ICPMS Run
-PT1S
-PT1S
-PT1S
-PT1S
Tb Column Mascot Peptide 2
Tb Column Mascot Peptide 2
Mascot Protein Code F Key Distinct Count
Peak Peps
Integer
Integer
dbo_tb_Column_Mascot_Peptide
Mascot_Protein_Code_FKey
Molap
169222
Regular
Tb Column Mascot Protein P Fid
Tb Column Mascot Protein P Fid
Integer
dbo_tb_Column_Mascot_Peptide
Mascot_Protein_Code_FKey
Granularity
Prot Desc
WChar
255
Prot Score
Double
Prot Thresh
Double
Prot Expect
Double
Prot Mass
Double
Prot Matches
BigInt
Prot Cover
Double
Prot Len
BigInt
Prot Pi
Double
Prot Tax Str
WChar
255
Prot Tax Id
BigInt
Accession
WChar
255
Gi
Integer
P Fid
WChar
15
Mascot Hit Code F Key
Integer
p I
Double
Tb Column Mascot Hit
Tb Column Mascot Hit
Integer
Granularity
Number
Integer
Mascot Header Code F Key
Integer
Tb Column Mascot Protein P Fid
Mascot Hit Code F Key
Regular
Tb Column Mascot Header
Tb Column Mascot Header
Integer
Granularity
XML File Name
WChar
255
Mass Spec Type
Integer
Plate Code F Key
Integer
Well Name
WChar
50
Plate Well Name
WChar
50
Gel Band ID
WChar
50
Load Sequence
UnsignedTinyInt
COM
WChar
255
Date
WChar
255
USERNAME
WChar
255
USEREMAIL
WChar
255
URI
WChar
255
FILENAME
WChar
255
FORMAT
WChar
255
SEARCH
WChar
255
Mascot Ver
WChar
255
DB
WChar
255
Fasta Ver
WChar
255
Num Seqs
BigInt
Num Residues
BigInt
Num Seqs After Tax
BigInt
Error Tolerant Num
BigInt
Num Queries
BigInt
File Comment
WChar
1024
Sample Code F Key
Integer
Tb Column Mascot Hit
Mascot Header Code F Key
Regular
Tb Column Samples
Tb Column Samples
Integer
Granularity
Sample ID
WChar
50
Sample Number
Integer
Sample Volume m L
Double
Sample Type
Integer
Sample Date
Date
Buffer Type
Integer
Buffer Conc m M
Double
Buffer Additions
WChar
20
Location Code F Key
Integer
Comment Code F Key
Integer
Sampled By
WChar
50
Acid Washed Vessel
Integer
Fraction Code F Key
Integer
Tb Column Mascot Header
Sample Code F Key
Regular
Tb Column Fractions
Tb Column Fractions
Integer
Granularity
Fraction ID
WChar
50
Growth Code F Key
Integer
Separation Code F Key
Integer
Fraction Type
Integer
Location Code F Key
Integer
Gradient Code F Key
Integer
Fraction Number
Integer
Fraction Position
Integer
Label Line 1
WChar
20
Label Line 2
WChar
20
Label Line 3
WChar
20
Fraction Volume m L
Double
Fraction Mass Mg
Integer
Fraction Description
WChar
100
Fraction Contact
WChar
50
Fraction Active
Integer
Node Left
Integer
Node Right
Integer
Node Depth
Integer
Node Ordinal
Integer
Node Index
WChar
50
Column Parent
Integer
Column Pool
Integer
Acid Washed Vessel
Integer
Node Parent
Integer
Fraction Code P Key
Integer
Fraction Pos Id
WChar
63
Tb Column Samples
Fraction Code F Key
Regular
Tb ICPMS Peak
Asvw Column ICPMS Peak Data
Tb ICPMS Metal
Asvw Column ICPMS Peak Data
Tb Cube Procedure Tree
Tb Cube Procedure Tree
Integer
Granularity
Procedure Tree Code P Key
Integer
Input ID
WChar
12
Separation Type
Integer
Separation Initial
WChar
3
Local Level
Integer
Node Name
WChar
18
Node Parent
Integer
Pruned Parent Key
Integer
Pruned Input ID Key
Integer
Full Tree Name
WChar
1000
Pruned Tree Name
WChar
1000
Pruned Local Name
WChar
17
Tb Column Fractions
Node Parent
Regular
Tb IPMD LF
Tb Column Mascot Protein P Fid
Tb Column ICPMS Run
Tb Column ICPMS Data u M
Tb Column Mascot Peptide
Tb Column Mascot Peptide
AggregationPercent
90
Express M3
dbo_tb_Column_Mascot_Peptide
Molap
Regular
-PT1S
-PT1S
-PT1S
-PT1S
MolapOnly
Server
169222
AggregationDesign
AggregationDesign
AggregationDesign
169222
Tb Column Mascot Protein P Fid
Tb Column Mascot Protein P Fid
18249
Prot Desc
Prot Score
Prot Thresh
1
Prot Expect
1
Prot Mass
Prot Matches
Prot Cover
1
Prot Len
1
Prot Pi
1
Prot Tax Str
1
Prot Tax Id
1
Accession
Gi
P Fid
Mascot Hit Code F Key
p I
Tb Column Mascot Hit
Tb Column Mascot Hit
18035
Number
156
Mascot Header Code F Key
Tb Column Mascot Header
Tb Column Mascot Header
1595
XML File Name
1595
Mass Spec Type
3
Plate Code F Key
22
Well Name
97
Plate Well Name
1531
Gel Band ID
48
Load Sequence
108
COM
1526
Date
1594
USERNAME
3
USEREMAIL
1
URI
1594
FILENAME
1594
FORMAT
1
SEARCH
1
Mascot Ver
1
DB
2
Fasta Ver
2
Num Seqs
1
Num Residues
3
Num Seqs After Tax
1
Error Tolerant Num
1
Num Queries
1362
File Comment
9
Sample Code F Key
1526
Tb Column Samples
Tb Column Samples
8562
Sample ID
8562
Sample Number
12
Sample Volume m L
12
Sample Type
6
Sample Date
18
Buffer Type
1
Buffer Conc m M
1
Buffer Additions
2
Location Code F Key
1
Comment Code F Key
4
Sampled By
8
Acid Washed Vessel
2
Fraction Code F Key
1709
Tb Column Fractions
Tb Column Fractions
1715
Fraction ID
1715
Growth Code F Key
1
Separation Code F Key
35
Fraction Type
9
Location Code F Key
1
Gradient Code F Key
68
Fraction Number
120
Fraction Position
127
Label Line 1
818
Label Line 2
462
Label Line 3
602
Fraction Volume m L
90
Fraction Mass Mg
1
Fraction Description
20
Fraction Contact
1
Fraction Active
1
Node Left
1715
Node Right
1715
Node Depth
8
Node Ordinal
70
Node Index
1628
Column Parent
27
Column Pool
44
Acid Washed Vessel
2
Node Parent
36
Fraction Code P Key
Fraction Pos Id
Tb ICPMS Peak
Tb ICPMS Peak
739
ICPMS Dataset Code F Key
39
ICPMS Metal Code F Key
25
ICPMS Peak Name
119
ICPMS Peak Letter
15
ICPMS Peak Ordinal
15
ICPMS Peak Comments
24
Tb ICPMS Metal
Tb ICPMS Metal
95
Metal ID
95
Atomic Number
66
Isotopic Mass
93
Metal Symbol
66
Metal Name
66
Default Data Public
2
Default Collision Mode
2
Tb Cube Procedure Tree
Tb Cube Procedure Tree
66
Procedure Tree Code P Key
66
Input ID
23
Separation Type
2
Separation Initial
2
Local Level
6
Node Name
29
Node Parent
52
Pruned Parent Key
Pruned Input ID Key
66
Full Tree Name
66
Pruned Tree Name
66
Pruned Local Name
51
Tb IPMD LF
Tb IPMD LF
4554
NCBI Gene Code F Key
487
Orf Num
487
Ipr Num
325
Match Type
8
Pattern
44
Keyword
17
Left Match
580
Hit Match
100
Right Match
625
Min Ac Score
1
Max Ac Score
1
Ipr Name
533
Hscore
5
Tb IPR Entry List
325
Tb IPR Entry List - IPR Num
Run Date
1
Tb IPR Entry List - IPR Name
Entry Type
8
Gm Num
487
Tb Element
118
Atomic Number
118
Name
118
Symbol
118
Period
7
Group
19
Tb Element Series
10
Tb Element Series - Name
10
Tb Column ICPMS Run
Tb Column ICPMS Run
119
ICPMS Run Number
5
ICPMS Acid
3
ICPMS Cone
3
ICPMS Acquisition Mode
4
ICPMS Run By
5
ICPMS Run Date
85
ICPMS Run File Name
119
ICPMS Data Upload Date
119
ICPMS Run Comments
1
ICPMS Run ID
119
Tb Column ICPMS Dataset
62
ICPMS Dataset Name
61
ICPMS Dataset Comments
27
Pruned Tree Name
62
Column Fraction Code F Key
Aggregation 0
Aggregation 0
Tb Column Mascot Protein P Fid
Tb Column Mascot Hit
Tb Column Mascot Header
Tb Column Samples
Tb Column Fractions
Tb ICPMS Peak
Tb ICPMS Metal
Tb Cube Procedure Tree
Tb IPMD LF
Tb Column ICPMS Run
Aggregation 1
Aggregation 1
Tb Column Mascot Protein P Fid
Tb Column Mascot Hit
Tb Column Mascot Header
Tb Column Samples
Tb Column Fractions
Tb ICPMS Peak
Tb ICPMS Metal
Tb Cube Procedure Tree
Tb IPMD LF
Tb Column ICPMS Run
Aggregation 2
Aggregation 2
Tb Column Mascot Protein P Fid
Tb Column Mascot Hit
Tb Column Mascot Header
Tb Column Samples
Tb Column Samples
Tb Column Fractions
Tb ICPMS Peak
Tb ICPMS Metal
Tb Cube Procedure Tree
Tb IPMD LF
Tb Column ICPMS Run
Aggregation 3
Aggregation 3
Tb Column Mascot Protein P Fid
Tb Column Mascot Hit
Tb Column Mascot Header
Tb Column Samples
Tb Column Fractions
Tb ICPMS Peak
Tb ICPMS Metal
Tb Cube Procedure Tree
Tb IPMD LF
Tb Column ICPMS Run
Aggregation 4
Aggregation 4
Tb Column Mascot Protein P Fid
Tb Column Mascot Hit
Tb Column Mascot Header
Tb Column Samples
Tb Column Fractions
Tb ICPMS Peak
Tb ICPMS Metal
Tb Cube Procedure Tree
Tb IPMD LF
Tb Column ICPMS Run
Aggregation 5
Aggregation 5
Tb Column Mascot Protein P Fid
Tb Column Mascot Hit
Tb Column Mascot Header
Tb Column Mascot Header
Tb Column Samples
Tb Column Fractions
Tb ICPMS Peak
Tb ICPMS Metal
Tb Cube Procedure Tree
Tb IPMD LF
Tb Column ICPMS Run
Aggregation 6
Aggregation 6
Tb Column Mascot Protein P Fid
Tb Column Mascot Hit
Tb Column Mascot Header
Tb Column Samples
Tb Column Fractions
Tb Column Fractions
Tb ICPMS Peak
Tb ICPMS Metal
Tb Cube Procedure Tree
Tb IPMD LF
Tb Column ICPMS Run
Aggregation 7
Aggregation 7
Tb Column Mascot Protein P Fid
Tb Column Mascot Hit
Tb Column Mascot Hit
Tb Column Mascot Header
Tb Column Samples
Tb Column Fractions
Tb ICPMS Peak
Tb ICPMS Metal
Tb Cube Procedure Tree
Tb IPMD LF
Tb Column ICPMS Run
Aggregation 8
Aggregation 8
Tb Column Mascot Protein P Fid
Tb Column Mascot Protein P Fid
Tb Column Mascot Hit
Tb Column Mascot Header
Tb Column Samples
Tb Column Fractions
Tb ICPMS Peak
Tb ICPMS Metal
Tb Cube Procedure Tree
Tb IPMD LF
Tb Column ICPMS Run
Aggregation 9
Aggregation 9
Tb Column Mascot Protein P Fid
Tb Column Mascot Hit
Tb Column Mascot Header
Tb Column Mascot Header
Tb Column Samples
Tb Column Fractions
Tb ICPMS Peak
Tb ICPMS Metal
Tb Cube Procedure Tree
Tb IPMD LF
Tb Column ICPMS Run
Aggregation a
Aggregation a
Tb Column Mascot Protein P Fid
Tb Column Mascot Hit
Tb Column Mascot Header
Tb Column Samples
Tb Column Fractions
Tb Column Fractions
Tb ICPMS Peak
Tb ICPMS Metal
Tb Cube Procedure Tree
Tb IPMD LF
Tb Column ICPMS Run
Aggregation b
Aggregation b
Tb Column Mascot Protein P Fid
Tb Column Mascot Hit
Tb Column Mascot Header
Tb Column Mascot Header
Tb Column Samples
Tb Column Fractions
Tb ICPMS Peak
Tb ICPMS Metal
Tb Cube Procedure Tree
Tb IPMD LF
Tb Column ICPMS Run
-PT1S
-PT1S
-PT1S
-PT1S
Tb Column Separation Hierarchy
Tb Column Separation Hierarchy
Local Level
Local Level
Integer
Integer
dbo_tb_Column_Separation_Hierarchy
Local_Level
Molap
Regular
Tb Column Separation Hierarchy
Tb Column Separation Hierarchy
Integer
dbo_tb_Column_Separation_Hierarchy
Fraction_Code_FKey
Granularity
Separation Hierarchy Code P Key
Integer
Local Metal
WChar
2
Local Pool
WChar
1
Local Separation Type
Integer
Local Separation Initial
WChar
3
Local Level
Integer
Local Name
WChar
8
Column Pool Key
Integer
Column Parent Key
Integer
Node Parent
Integer
Column Local Name
WChar
8
Full Hierarchy Name
WChar
1000
Column Hierarchy Name
WChar
1000
Fraction Code F Key
Integer
Fraction Code F Key 1
Integer
Tb Column Separation Hierarchy
Tb Column Separation Hierarchy
Express M3
dbo_tb_Column_Separation_Hierarchy
Molap
Regular
-PT1S
-PT1S
-PT1S
-PT1S
-PT1S
-PT1S
-PT1S
-PT1S
Tb Metal Protein Potential Overall
Tb Metal Protein Potential Overall
Score - Tb Metal Protein Potential Overall
overall score
Double
Double
dbo_tb_Metal_Protein_Potential_Overall
score
Molap
Regular
Tb ICPMS Metal
Tb ICPMS Metal
Integer
dbo_tb_Metal_Protein_Potential_Overall
ICPMS_Metal_Code_FKey
Granularity
Metal ID
WChar
50
Atomic Number
Integer
Isotopic Mass
Integer
Metal Symbol
WChar
3
Metal Name
WChar
20
Default Data Public
Integer
Default Collision Mode
Integer
Tb Metal Protein Potential Overall
Tb Metal Protein Potential Overall
Express M3
dbo_tb_Metal_Protein_Potential_Overall
Molap
Regular
-PT1S
-PT1S
-PT1S
-PT1S
-PT1S
-PT1S
-PT1S
-PT1S
Asvw Column ICPMS Peak Data Overlap
Asvw Column ICPMS Peak Data Overlap
Asvw Column ICPMS Peak Data Overlap Count
Asvw Column ICPMS Peak Data Overlap Count
Count
Integer
Integer
4
asvw_Column_ICPMS_Peak_Data_Overlap
Molap
Regular
Tb Column Fractions
Tb Column Fractions
Integer
asvw_Column_ICPMS_Peak_Data_Overlap
Fraction_Code_FKey
Granularity
Fraction ID
WChar
50
Growth Code F Key
Integer
Separation Code F Key
Integer
Fraction Type
Integer
Location Code F Key
Integer
Gradient Code F Key
Integer
Fraction Number
Integer
Fraction Position
Integer
Label Line 1
WChar
20
Label Line 2
WChar
20
Label Line 3
WChar
20
Fraction Volume m L
Double
Fraction Mass Mg
Integer
Fraction Description
WChar
100
Fraction Contact
WChar
50
Fraction Active
Integer
Node Left
Integer
Node Right
Integer
Node Depth
Integer
Node Ordinal
Integer
Node Index
WChar
50
Column Parent
Integer
Column Pool
Integer
Acid Washed Vessel
Integer
Node Parent
Integer
Fraction Code P Key
Integer
Fraction Pos Id
WChar
63
Asvw ICPMS Metal Overlap
Asvw ICPMS Metal Overlap
Integer
Granularity
Metal ID
WChar
50
Atomic Number
Integer
Isotopic Mass
Integer
Metal Symbol
WChar
3
Metal Name
WChar
20
Default Data Public
Integer
Default Collision Mode
Integer
Asvw ICPMS Peak Overlap
ICPMS Metal Code F Key
Regular
Asvw ICPMS Peak Overlap
Asvw ICPMS Peak Overlap
UnknownMember
Integer
asvw_Column_ICPMS_Peak_Data_Overlap
ICPMS_Peak_Code_FKey
Granularity
ICPMS Dataset Code F Key
Integer
ICPMS Peak Name
WChar
20
ICPMS Peak Letter
WChar
5
ICPMS Peak Ordinal
Integer
ICPMS Peak Comments
WChar
ICPMS Metal Code F Key
Integer
Asvw Column ICPMS Peak Data Overlap
Asvw Column ICPMS Peak Data Overlap
Express M3
asvw_Column_ICPMS_Peak_Data_Overlap
Molap
Regular
-PT1S
-PT1S
-PT1S
-PT1S
-PT1S
-PT1S
-PT1S
-PT1S
Tb Column Mascot Peptide 3
Tb Column Mascot Peptide 3
Pep Calc Mr Distinct Count 1
Total Uniq Peps
DistinctCount
Integer
Double
dbo_tb_Column_Mascot_Peptide
pep_calc_mr
Molap
169222
Regular
Tb Column Mascot Protein P Fid
Tb Column Mascot Protein P Fid
Integer
dbo_tb_Column_Mascot_Peptide
Mascot_Protein_Code_FKey
Granularity
Prot Desc
WChar
255
Prot Score
Double
Prot Thresh
Double
Prot Expect
Double
Prot Mass
Double
Prot Matches
BigInt
Prot Cover
Double
Prot Len
BigInt
Prot Pi
Double
Prot Tax Str
WChar
255
Prot Tax Id
BigInt
Accession
WChar
255
Gi
Integer
P Fid
WChar
15
Mascot Hit Code F Key
Integer
p I
Double
Tb Column Mascot Hit
Tb Column Mascot Hit
Integer
Granularity
Number
Integer
Mascot Header Code F Key
Integer
Tb Column Mascot Protein P Fid
Mascot Hit Code F Key
Regular
Tb Column Mascot Header
Tb Column Mascot Header
Integer
Granularity
XML File Name
WChar
255
Mass Spec Type
Integer
Plate Code F Key
Integer
Well Name
WChar
50
Plate Well Name
WChar
50
Gel Band ID
WChar
50
Load Sequence
UnsignedTinyInt
COM
WChar
255
Date
WChar
255
USERNAME
WChar
255
USEREMAIL
WChar
255
URI
WChar
255
FILENAME
WChar
255
FORMAT
WChar
255
SEARCH
WChar
255
Mascot Ver
WChar
255
DB
WChar
255
Fasta Ver
WChar
255
Num Seqs
BigInt
Num Residues
BigInt
Num Seqs After Tax
BigInt
Error Tolerant Num
BigInt
Num Queries
BigInt
File Comment
WChar
1024
Sample Code F Key
Integer
Tb Column Mascot Hit
Mascot Header Code F Key
Regular
Tb Column Samples
Tb Column Samples
Integer
Granularity
Sample ID
WChar
50
Sample Number
Integer
Sample Volume m L
Double
Sample Type
Integer
Sample Date
Date
Buffer Type
Integer
Buffer Conc m M
Double
Buffer Additions
WChar
20
Location Code F Key
Integer
Comment Code F Key
Integer
Sampled By
WChar
50
Acid Washed Vessel
Integer
Fraction Code F Key
Integer
Tb Column Mascot Header
Sample Code F Key
Regular
Tb Column Fractions
Tb Column Fractions
Integer
Granularity
Fraction ID
WChar
50
Growth Code F Key
Integer
Separation Code F Key
Integer
Fraction Type
Integer
Location Code F Key
Integer
Gradient Code F Key
Integer
Fraction Number
Integer
Fraction Position
Integer
Label Line 1
WChar
20
Label Line 2
WChar
20
Label Line 3
WChar
20
Fraction Volume m L
Double
Fraction Mass Mg
Integer
Fraction Description
WChar
100
Fraction Contact
WChar
50
Fraction Active
Integer
Node Left
Integer
Node Right
Integer
Node Depth
Integer
Node Ordinal
Integer
Node Index
WChar
50
Column Parent
Integer
Column Pool
Integer
Acid Washed Vessel
Integer
Node Parent
Integer
Fraction Code P Key
Integer
Fraction Pos Id
WChar
63
Tb Column Samples
Fraction Code F Key
Regular
Tb ICPMS Peak
Asvw Column ICPMS Peak Data
Tb Cube Procedure Tree
Tb Cube Procedure Tree
Integer
Granularity
Procedure Tree Code P Key
Integer
Input ID
WChar
12
Separation Type
Integer
Separation Initial
WChar
3
Local Level
Integer
Node Name
WChar
18
Node Parent
Integer
Pruned Parent Key
Integer
Pruned Input ID Key
Integer
Full Tree Name
WChar
1000
Pruned Tree Name
WChar
1000
Pruned Local Name
WChar
17
Tb Column Fractions
Node Parent
Regular
Tb Column ICPMS Run
Tb Column ICPMS Data u M
Tb Column Mascot Peptide
Tb Column Mascot Peptide
AggregationPercent
90
Express M3
dbo_tb_Column_Mascot_Peptide
Molap
Regular
-PT1S
-PT1S
-PT1S
-PT1S
MolapOnly
Server
169222
AggregationDesign
AggregationDesign
AggregationDesign
169222
Tb Column Mascot Protein P Fid
Tb Column Mascot Protein P Fid
18249
Prot Desc
Prot Score
Prot Thresh
1
Prot Expect
1
Prot Mass
Prot Matches
Prot Cover
1
Prot Len
1
Prot Pi
1
Prot Tax Str
1
Prot Tax Id
1
Accession
Gi
P Fid
Mascot Hit Code F Key
p I
Tb Column Mascot Hit
Tb Column Mascot Hit
18035
Number
156
Mascot Header Code F Key
Tb Column Mascot Header
Tb Column Mascot Header
1595
XML File Name
1595
Mass Spec Type
3
Plate Code F Key
22
Well Name
97
Plate Well Name
1531
Gel Band ID
48
Load Sequence
108
COM
1526
Date
1594
USERNAME
3
USEREMAIL
1
URI
1594
FILENAME
1594
FORMAT
1
SEARCH
1
Mascot Ver
1
DB
2
Fasta Ver
2
Num Seqs
1
Num Residues
3
Num Seqs After Tax
1
Error Tolerant Num
1
Num Queries
1362
File Comment
9
Sample Code F Key
1526
Tb Column Samples
Tb Column Samples
8562
Sample ID
8562
Sample Number
12
Sample Volume m L
12
Sample Type
6
Sample Date
18
Buffer Type
1
Buffer Conc m M
1
Buffer Additions
2
Location Code F Key
1
Comment Code F Key
4
Sampled By
8
Acid Washed Vessel
2
Fraction Code F Key
1709
Tb Column Fractions
Tb Column Fractions
1715
Fraction ID
1715
Growth Code F Key
1
Separation Code F Key
35
Fraction Type
9
Location Code F Key
1
Gradient Code F Key
68
Fraction Number
120
Fraction Position
127
Label Line 1
818
Label Line 2
462
Label Line 3
602
Fraction Volume m L
90
Fraction Mass Mg
1
Fraction Description
20
Fraction Contact
1
Fraction Active
1
Node Left
1715
Node Right
1715
Node Depth
8
Node Ordinal
70
Node Index
1628
Column Parent
27
Column Pool
44
Acid Washed Vessel
2
Node Parent
36
Fraction Code P Key
Fraction Pos Id
Tb ICPMS Peak
Tb ICPMS Peak
739
ICPMS Dataset Code F Key
39
ICPMS Metal Code F Key
25
ICPMS Peak Name
119
ICPMS Peak Letter
15
ICPMS Peak Ordinal
15
ICPMS Peak Comments
24
Tb Cube Procedure Tree
Tb Cube Procedure Tree
66
Procedure Tree Code P Key
66
Input ID
23
Separation Type
2
Separation Initial
2
Local Level
6
Node Name
29
Node Parent
52
Pruned Parent Key
Pruned Input ID Key
66
Full Tree Name
66
Pruned Tree Name
66
Pruned Local Name
51
Tb Column ICPMS Run
Tb Column ICPMS Run
119
ICPMS Run Number
5
ICPMS Acid
3
ICPMS Cone
3
ICPMS Acquisition Mode
4
ICPMS Run By
5
ICPMS Run Date
85
ICPMS Run File Name
119
ICPMS Data Upload Date
119
ICPMS Run Comments
1
ICPMS Run ID
119
Tb Column ICPMS Dataset
62
ICPMS Dataset Name
61
ICPMS Dataset Comments
27
Pruned Tree Name
62
Column Fraction Code F Key
Aggregation 0
Aggregation 0
Tb Column Mascot Protein P Fid
Tb Column Mascot Hit
Tb Column Mascot Header
Tb Column Samples
Tb Column Fractions
Tb ICPMS Peak
Tb Cube Procedure Tree
Tb Column ICPMS Run
Aggregation 1
Aggregation 1
Tb Column Mascot Protein P Fid
Tb Column Mascot Hit
Tb Column Mascot Header
Tb Column Samples
Tb Column Fractions
Tb ICPMS Peak
Tb Cube Procedure Tree
Tb Column ICPMS Run
Aggregation 2
Aggregation 2
Tb Column Mascot Protein P Fid
Tb Column Mascot Hit
Tb Column Mascot Header
Tb Column Samples
Tb Column Samples
Tb Column Fractions
Tb ICPMS Peak
Tb Cube Procedure Tree
Tb Column ICPMS Run
Aggregation 3
Aggregation 3
Tb Column Mascot Protein P Fid
Tb Column Mascot Hit
Tb Column Mascot Header
Tb Column Samples
Tb Column Fractions
Tb ICPMS Peak
Tb Cube Procedure Tree
Tb Column ICPMS Run
Aggregation 4
Aggregation 4
Tb Column Mascot Protein P Fid
Tb Column Mascot Hit
Tb Column Mascot Header
Tb Column Samples
Tb Column Fractions
Tb ICPMS Peak
Tb Cube Procedure Tree
Tb Column ICPMS Run
Aggregation 5
Aggregation 5
Tb Column Mascot Protein P Fid
Tb Column Mascot Hit
Tb Column Mascot Header
Tb Column Mascot Header
Tb Column Samples
Tb Column Fractions
Tb ICPMS Peak
Tb Cube Procedure Tree
Tb Column ICPMS Run
Aggregation 6
Aggregation 6
Tb Column Mascot Protein P Fid
Tb Column Mascot Hit
Tb Column Mascot Header
Tb Column Samples
Tb Column Fractions
Tb Column Fractions
Tb ICPMS Peak
Tb Cube Procedure Tree
Tb Column ICPMS Run
Aggregation 7
Aggregation 7
Tb Column Mascot Protein P Fid
Tb Column Mascot Hit
Tb Column Mascot Hit
Tb Column Mascot Header
Tb Column Samples
Tb Column Fractions
Tb ICPMS Peak
Tb Cube Procedure Tree
Tb Column ICPMS Run
Aggregation 8
Aggregation 8
Tb Column Mascot Protein P Fid
Tb Column Mascot Protein P Fid
Tb Column Mascot Hit
Tb Column Mascot Header
Tb Column Samples
Tb Column Fractions
Tb ICPMS Peak
Tb Cube Procedure Tree
Tb Column ICPMS Run
Aggregation 9
Aggregation 9
Tb Column Mascot Protein P Fid
Tb Column Mascot Hit
Tb Column Mascot Header
Tb Column Mascot Header
Tb Column Samples
Tb Column Fractions
Tb ICPMS Peak
Tb Cube Procedure Tree
Tb Column ICPMS Run
Aggregation a
Aggregation a
Tb Column Mascot Protein P Fid
Tb Column Mascot Hit
Tb Column Mascot Header
Tb Column Samples
Tb Column Fractions
Tb Column Fractions
Tb ICPMS Peak
Tb Cube Procedure Tree
Tb Column ICPMS Run
Aggregation b
Aggregation b
Tb Column Mascot Protein P Fid
Tb Column Mascot Hit
Tb Column Mascot Header
Tb Column Mascot Header
Tb Column Samples
Tb Column Fractions
Tb ICPMS Peak
Tb Cube Procedure Tree
Tb Column ICPMS Run
-PT1S
-PT1S
-PT1S
-PT1S
Tb Column Fractions 3
Tb Column Fractions peak 2
Fraction Code P Key Distinct Count 2
in pks FRs 2
DistinctCount
Integer
Integer
dbo_tb_Column_Fractions
Fraction_Code_PKey
Molap
Regular
Tb Column Fractions
Tb Column Fractions
Integer
dbo_tb_Column_Fractions
Fraction_Code_PKey
Granularity
Fraction ID
WChar
50
Growth Code F Key
Integer
Separation Code F Key
Integer
Fraction Type
Integer
Location Code F Key
Integer
Gradient Code F Key
Integer
Fraction Number
Integer
Fraction Position
Integer
Label Line 1
WChar
20
Label Line 2
WChar
20
Label Line 3
WChar
20
Fraction Volume m L
Double
Fraction Mass Mg
Integer
Fraction Description
WChar
100
Fraction Contact
WChar
50
Fraction Active
Integer
Node Left
Integer
Node Right
Integer
Node Depth
Integer
Node Ordinal
Integer
Node Index
WChar
50
Column Parent
Integer
Column Pool
Integer
Acid Washed Vessel
Integer
Node Parent
Integer
Fraction Code P Key
Integer
Fraction Pos Id
WChar
63
Tb ICPMS Peak
Asvw Column ICPMS Peak Data
Tb Cube Procedure Tree
Tb Cube Procedure Tree
Integer
Granularity
Procedure Tree Code P Key
Integer
Input ID
WChar
12
Separation Type
Integer
Separation Initial
WChar
3
Local Level
Integer
Node Name
WChar
18
Node Parent
Integer
Pruned Parent Key
Integer
Pruned Input ID Key
Integer
Full Tree Name
WChar
1000
Pruned Tree Name
WChar
1000
Pruned Local Name
WChar
17
Tb Column Fractions
Node Parent
Regular
Tb Column Fractions
Tb Column Fractions
Express M3
dbo_tb_Column_Fractions
Molap
Regular
-PT1S
-PT1S
-PT1S
-PT1S
-PT1S
-PT1S
-PT1S
-PT1S
Asvw IPMD LF
Asvw IPMD LF
NCBI Gene Code F Key
NCBI Gene Code F Key
Integer
Integer
asvw_IPMD_LF
NCBI_Gene_Code_FKey
IPR Entry List F Key
IPR Entry List F Key
Integer
Integer
asvw_IPMD_LF
IPR_Entry_List_FKey
Element F Key
Element F Key
Integer
Integer
asvw_IPMD_LF
Element_FKey
Orf Num
Orf Num
Integer
Integer
asvw_IPMD_LF
orf_num
Min Ac Score
Min Ac Score
Integer
Integer
asvw_IPMD_LF
min_ac_score
Max Ac Score
Max Ac Score
Integer
Integer
asvw_IPMD_LF
max_ac_score
Hscore
Hscore
Integer
Integer
asvw_IPMD_LF
hscore
Asvw IPMD LF Count
Asvw IPMD LF Count
Count
Integer
Integer
4
asvw_IPMD_LF
Molap
Regular
Tb IPMD LF
Tb IPMD LF
UnknownMember
Integer
asvw_IPMD_LF
IPMD_LF_PKey
Granularity
NCBI Gene Code F Key
Integer
Orf Num
Integer
Ipr Num
WChar
10
Match Type
WChar
50
Pattern
WChar
50
Keyword
WChar
Left Match
WChar
256
Hit Match
WChar
50
Right Match
WChar
256
Min Ac Score
Integer
Max Ac Score
Integer
Ipr Name
WChar
256
Hscore
Integer
Tb IPR Entry List
Integer
Tb IPR Entry List - IPR Num
WChar
15
Run Date
Date
Tb IPR Entry List - IPR Name
WChar
250
Entry Type
WChar
15
Gm Num
WChar
15
Tb Element
UnknownMember
Integer
Atomic Number
Integer
Name
WChar
50
Symbol
WChar
3
Period
Integer
Group
Integer
Tb Element Series
Integer
Tb Element Series - Name
WChar
80
Tb Column Mascot Protein P Fid
Tb Column Mascot Protein P Fid
Integer
Prot Desc
WChar
255
Prot Score
Double
Prot Thresh
Double
Prot Expect
Double
Prot Mass
Double
Prot Matches
BigInt
Prot Cover
Double
Prot Len
BigInt
Prot Pi
Double
Prot Tax Str
WChar
255
Prot Tax Id
BigInt
Accession
WChar
255
Gi
Integer
P Fid
WChar
15
Granularity
Mascot Hit Code F Key
Integer
p I
Double
Tb IPMD LF
Gm Num
Regular
Asvw IPMD LF
Asvw IPMD LF
Express M3
asvw_IPMD_LF
Molap
Regular
-PT1S
-PT1S
-PT1S
-PT1S
-PT1S
-PT1S
-PT1S
-PT1S
Tb GPA Pvalue
Tb GPA Pvalue
Pvalue
Pvalue
Double
Double
dbo_tb_GPA_Pvalue
pvalue
Tb GPA Pvalue Count
Tb GPA Pvalue Count
Count
Integer
Integer
4
dbo_tb_GPA_Pvalue
Molap
Regular
Tb GPA Pvalue
Tb GPA Pvalue
Integer
dbo_tb_GPA_Pvalue
GPA_pvalue_PKey
Granularity
P Fid
WChar
10
Pvalue
Double
Tb Element Isotope
Integer
Isotopic Mass
Integer
Isotope ID
WChar
14
Element F Key
Integer
Tb Column Mascot Protein P Fid
Tb Column Mascot Protein P Fid
Integer
Prot Desc
WChar
255
Prot Score
Double
Prot Thresh
Double
Prot Expect
Double
Prot Mass
Double
Prot Matches
BigInt
Prot Cover
Double
Prot Len
BigInt
Prot Pi
Double
Prot Tax Str
WChar
255
Prot Tax Id
BigInt
Accession
WChar
255
Gi
Integer
P Fid
WChar
15
Granularity
Mascot Hit Code F Key
Integer
p I
Double
Tb GPA Pvalue
P Fid
Regular
Tb Element Isotope
Tb Element Isotope
Integer
dbo_tb_GPA_Pvalue
Element_Isotope_FKey
Granularity
Isotopic Mass
Integer
Isotope ID
WChar
14
Tb Element
Integer
Atomic Number
Integer
Name
WChar
50
Symbol
WChar
3
Period
Integer
Group
Integer
Tb Element Series
Integer
Tb Element Series - Name
WChar
80
Tb GPA Pvalue
Tb GPA Pvalue
Express M3
dbo_tb_GPA_Pvalue
Molap
Regular
-PT1S
-PT1S
-PT1S
-PT1S
-PT1S
-PT1S
-PT1S
-PT1S
Express M3
MdxScript
MdxScript
/*
The CALCULATE command controls the aggregation of leaf cells in the cube.
If the CALCULATE command is deleted or modified, the data within the cube is affected.
You should edit this command only if you manually specify how the cube is aggregated.
*/
CALCULATE; ([Measures].[Total Prot mg], Leaves([Tb Column Fractions])) =
[Measures].[Prot mg_ml] * [Measures].[Volume ml]; ([Measures].[Peps], Leaves([Tb Column Fractions])) =
[Measures].[Uniq Peps];
CREATE MEMBER CURRENTCUBE.[MEASURES].[Peps Nonpeak]
AS ([Measures].[Peps] - [Measures].[Peak Peps]),
NON_EMPTY_BEHAVIOR = { [Peps] },
VISIBLE = 1;
CREATE MEMBER CURRENTCUBE.[MEASURES].[col subscore]
AS iif(([col corr] < 0.55 and [col corr] > -0.4) or [FRs cnt] < 4, null, [col peps corr] - [Peps Nonpeak]),
VISIBLE = 1; ([Measures].[weighted col subscore], Leaves([Tb Column Separation Hierarchy])) =
[Measures].[col subscore] * [Measures].[Local Level]; ([Measures].[peak peps corr sum], Leaves([Tb ICPMS Peak])) =
[Measures].[peak peps corr]; ([Measures].[Peak Peps], Leaves([Tb Column Fractions])) =
[Measures].[Peak Uniq Peps];
CREATE MEMBER CURRENTCUBE.[MEASURES].[col peps corr]
AS [col corr] * [Peps],
NON_EMPTY_BEHAVIOR = { [Peps] },
VISIBLE = 1;
CREATE MEMBER CURRENTCUBE.[MEASURES].[peak peps corr]
AS [peak corr] * [Peak Peps],
NON_EMPTY_BEHAVIOR = { [Peak Peps] },
VISIBLE = 1;
CREATE MEMBER CURRENTCUBE.[MEASURES].[Ratiometric Prot Conc]
AS ([Measures].[Uniq Peps]/[Measures].[Total Uniq Peps])*[Measures].[Prot mg_ml],
NON_EMPTY_BEHAVIOR = { [Uniq Peps] },
VISIBLE = 1;
CREATE MEMBER CURRENTCUBE.[MEASURES].[Prot mg_ml PFID]
AS [Measures].[Prot mg_ml],
NON_EMPTY_BEHAVIOR = { [Uniq Peps] },
VISIBLE = 1;
CREATE MEMBER CURRENTCUBE.[MEASURES].[Ratiometric Proportion]
AS [Measures].[Uniq Peps]/[Measures].[Total Uniq Peps],
NON_EMPTY_BEHAVIOR = { [Uniq Peps] },
VISIBLE = 1;
CREATE MEMBER CURRENTCUBE.[MEASURES].[pct of peak]
AS [in pks FRs] / [in pks FRs 2],
NON_EMPTY_BEHAVIOR = { [in pks FRs] },
VISIBLE = 1 ;
CREATE MEMBER CURRENTCUBE.[MEASURES].[Metal uM]
AS Avg(Descendants([Tb Column ICPMS Run].[Column - Run].CurrentMember, [Tb Column ICPMS Run].[Column - Run].[ICPMS Run ID]), [Measures].[ICPMS Data Value u M]),
NON_EMPTY_BEHAVIOR = { [ICPMS Data Value u M] },
VISIBLE = 1;
CREATE MEMBER CURRENTCUBE.[MEASURES].[Metal uM PFID]
AS Avg(Descendants([Tb Column ICPMS Run].[Column - Run].CurrentMember, [Tb Column ICPMS Run].[Column - Run].[ICPMS Run ID]), [Measures].[ICPMS Data Value u M]),
NON_EMPTY_BEHAVIOR = { [Uniq Peps] },
VISIBLE = 1; ([Measures].[Total Metal nmoles], Leaves([Tb Column Fractions])) =
([Measures].[ICPMS Data Value uM Avg]*1000) * ([Measures].[Volume ml]/1000);
CREATE MEMBER CURRENTCUBE.[MEASURES].[pct FRs]
AS ([Measures].[in pks FRs] / [Measures].[FRs cnt]),
FORMAT_STRING = "Percent",
NON_EMPTY_BEHAVIOR = { [in pks FRs] },
VISIBLE = 1; ([Measures].[Metal Peak Max nmoles_ml], Leaves([Tb Column Fractions])) =
[Measures].[Total Metal nmoles] / [Measures].[Volume ml];
CREATE SET CURRENTCUBE.[Non Peak]
AS Extract(NonEmpty(([Tb Column Separation Hierarchy].[Column Hierarchy Name].currentmember,
-Extract(NonEmpty({([Tb Column Separation Hierarchy].[Column Hierarchy Name].currentmember,
[Tb ICPMS Metal].[Metal ID].currentmember,
[Tb ICPMS Peak].[Tb ICPMS Peak].defaultmember, [Tb Column Fractions].[Tb Column Fractions].Children)}),
[Tb Column Fractions].[Tb Column Fractions])), {[Measures].[Tb Column Fractions Count]}), [Tb Column Fractions].[Tb Column Fractions]);
CREATE MEMBER CURRENTCUBE.[MEASURES].[Metal:Protein ratio]
AS [Measures].[Total Metal nmoles]/[Measures].[Total Prot mg],
VISIBLE = 1;
-PT1S
-PT1S
-PT1S
-PT1S