 |
Page History
<?xml version="1.0" encoding="utf-8"?>
<html>
{{FAQ
release=2.4.0
entrydate=April 20, 2011 |
topic=Installation and Upgrade |
Qtext=A step-by-step guide to Create MAGE-TAB template specific to RPLA Project |
| Scrollbar | ||
|---|---|---|
|
| Page info | ||||
|---|---|---|---|---|
|
| Composition Setup |
|---|
cloak.toggle.type = text
cloak.toggle.open=[show]
cloak.toggle.close=[hide]
|
| Panel | |||||||||
|---|---|---|---|---|---|---|---|---|---|
| |||||||||
|
Topic:
Release:
Date entered:
Question
Answer
Have a comment?
Please leave your comment in the caArray End User Forum.
| Scrollbar | ||
|---|---|---|
|
Atext= |
Create new provider(s)
Create RPLA providers in the contact table as for other array providers:
...
| Panel |
|---|
Select ID from contact where name ='Zeptosens'; |
Create new Assay Type
Create a new RPLA assay type in the database in the assay_type table:
| Panel |
|---|
insert into assay_type (name) values ('RPLA'); |
Check if caArray a valid Term Source
Since a new technical term: reverse_phase_protein_array_features would be inserted into term_source table under the source of caArray, it is necessary to check if the source of *caArray*has already added in term_source table. During the normal caArray installation, caArray should have been added to the term_source table with a default ID =4. To verify, apply the select statement below:
...
| Panel |
|---|
insert into term_source (name, version, url) values ('caArray','2.0','https://array.nci.nih.gov') |
Add a new terminology term
After source caArray added, use the SELECT statement above to find the ID for the source caArray just created in the term_source table. The id will be used in the insert statement below to add the new terminology reverse_phase_protein_array_features to the term table:
...
| Panel |
|---|
insert into term_categories (term_id, category_id) values (<id of term inserted above>, 224); |
Create a dummy Array Design File for RPLA
Create MAGE-TAB ADF dummy array design files (.ADF files) for the array provider Zeptosens, created in Step 1. The dummy file can be a empty file with a simple header.
Upload the Dummy Array Design file in caArray
Upload new array designs for each ADF using the caArray web application (For more details, please refer to Using caArray: Uploading Array Design File ). The new file will have the final status of "Imported no Parsed".
Update Array_Design Table
After uploading dummy array designs into caArray, update their array_design table entries in the database to lsid_authority to be Zeptosens.com, lsid_namespace to be PhysicalArrayDesign. This SQL statement will work only after the array design file is added to caArray.
| Panel |
|---|
update array_design set lsid_authority = 'Zeptosens.com', |
Create New File Types for RPLA data files
Next step is to create new file types for the RPLA data file formats you have. This modification is not at the database level, but file level. The file is:
...
