1 / 12

Loading annotated spreadsheets into maxdLoad2

Loading annotated spreadsheets into maxdLoad2. The maxdLoad2 database. Load. Edit. Browse. Worksheets with experiment data in maxdLoad2 format. Spreadsheet overview. Worksheet layout. Name of table within maxdLoad2. maxdLoad2 attribute name.

adanna
Télécharger la présentation

Loading annotated spreadsheets into maxdLoad2

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Loading annotated spreadsheets into maxdLoad2

  2. The maxdLoad2 database Load Edit Browse

  3. Worksheets with experiment data in maxdLoad2 format

  4. Spreadsheet overview

  5. Worksheet layout Name of table within maxdLoad2 maxdLoad2 attribute name Field Data Requirement describes the format of the data and if it is a compulsory field within maxdLoad2 The number with dollar prefix is used to match the data to the table fields within maxdLoad2 Comment boxes are available on each worksheet to display help text

  6. Using “presets” to load spreadsheets into maxdLoad2 • Data can be entered into maxdLoad2 by one of two methods . • Entering data directly into • the database using the • “Create” option. • Loading data from a text • file or Excel spreadsheet • using the “Load” option.

  7. The Load option allows data from worksheets and text files to be entered in a batch format. The preset file adds a dollar prefixed number into each attribute field of the maxdLoad2 table that corresponds to a column of data in the worksheet.

  8. A single worksheet can be selected from a spreadsheet and loaded into the database. The data from the worksheet can be previewed prior to upload to ensure the data is correct.

  9. Browsing the loaded data After loading the worksheet, the data can be viewed using the Browse function. In this example, only the Name and Title have been loaded from the worksheet.

  10. Order of loading We recommend that the data tables are loaded in the following order:- SourceSampling ProtocolTreatment ProtocolExtraction ProtocolLabelling ProtocolHybridisation ProtocolScanning ProtocolImage Analysis Protocol SampleTreated SampleExtractLabelled ExtractArray Hybridisation Image MeasurementSubmitterExperiment

  11. Benefits of using the spreadsheet • Fast to annotate experiments • Annotate to MIAME or MIAME/Env standards • Simple auto-naming generation of samples (making the • experiment and relationships of samples easy to follow) • Incorporates data fields for lab-specific id's • Easy to up-load into maxdLoad2 • Easy to customize

  12. Acknowledgements NEBC Oxford Dawn Field Bela Tiwari Tim Booth Stewart Houten Ashley Morley NEBC Manchester Andy Brass Dave Hancock Norman Morrison University of Cardiff Pete Kille University of Manchester Kevin Garwood Giles Velarde

More Related