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 Integer asvw_Column_ICPMS_Peak_Data ICPMS_Peak_Code_FKey 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