Using batch creator script: Difference between revisions

From EcoliWiki
Jump to navigation Jump to search
Table edited by Amandasupak via TableEdit
No edit summary
Line 9: Line 9:
**The name of the experimenter will be the same for every row in the final batch column. You only need to write the name of the experimenter in second row even if the final batch file will contain more than 2 rows.  
**The name of the experimenter will be the same for every row in the final batch column. You only need to write the name of the experimenter in second row even if the final batch file will contain more than 2 rows.  


<b>Rows included in my template for ASv2 arrays:</b>
<center>
<protect><!--box uid=63ce1649aab8b3180235b0af7618f667.176084.C4c86982d8b6ef-->
<protect><!--box uid=63ce1649aab8b3180235b0af7618f667.176084.C4c86982d8b6ef-->
<!--
<!--
Line 73: Line 75:
|}
|}
<!--box uid=63ce1649aab8b3180235b0af7618f667.176084.C4c86982d8b6ef--></protect>
<!--box uid=63ce1649aab8b3180235b0af7618f667.176084.C4c86982d8b6ef--></protect>
 
</center>
Rows included in my template for ASv2 arrays:
:<b>Coulmn D</b>: Print Name
::Affymetrix Ecoli_ASv2
:<b>Column H</b>: Exp File Location
::affy2_generic.EXP
:<b>Column K</b>: SINGLE SCAN FILE LOCATION
::noimage.DAT
:<b>Column N</b>: Normalization Type
::Computed
:<b>Column P</b>: Experimenter
::DSIEGELE
:<b>Column T</b>: Individual User
::DSIEGELE
:<b>Column U</b>: PROBE_SET_ALGORITHM
::Affymetrix MAS 5


==Data File==
==Data File==

Revision as of 19:57, 7 September 2010

This is a tutorial for the Batch Creator Script which makes annotating and creating batch files for microarray data much faster.

How the script works

You have 3 files total. One is called a template, one the data file, and the final is the completed batch file.

Template file

The template file contains only 2 rows. The first is the headings for each column (from "Result_Set_Name" to "PROBE_SET_ALGORITHM"). The second row will contain any "template" information. The second row should have data in any column that includes information that will never change for that template type. If you have multiple array types that you are loading you can make different templates.

  • An example of this is the "Experimenter" column.
    • The name of the experimenter will be the same for every row in the final batch column. You only need to write the name of the experimenter in second row even if the final batch file will contain more than 2 rows.

Rows included in my template for ASv2 arrays:

Column Heading Name Template Value

D

Print Name

Affymetrix Ecoli_ASv2

H

Exp File Location

affy2_generic.EXP

K

SINGLE SCAN FILE LOCATION

noimage.DAT

N

Normalization Type

Computed

P

Experimenter

DSIEGELE

T

Individual User

DSIEGELE

U

PROBE_SET_ALGORITHM

Affymetrix MAS 5

Data File

The data file will contain any information that changes from batch file to batch file. This file will contain the as many rows as needed, but the first row will always contain the headings (Result_Set_Name" to "PROBE_SET_ALGORITHM").


Where to find the script

Tetramer: ul/SMD/Batchcreator/