Example Queries for Experiment Metadata

 The following query examples demonstrate how to use RESTful Model Access (RMA) to retrieve metadata for experiments. The API utility, RMA Query Builder, can be used to compose RMA queries.

Examples

Mouse Brain ISH experiments:

http://api.brain-map.org/api/v2/data/query.xml?criteria=
model::SectionDataSet,
rma::criteria,[failed$eqfalse],products[abbreviation$eq'Mouse'],treatments[name$eq'ISH'],
rma::include,genes,specimen(donor(age)),plane_of_section,section_images
&num_rows=10&start_row=0

Mouse Brain ISH exeriments in comma delimited format (see following example for Google Chrome):

http://api.brain-map.org/api/v2/data/query.csv?criteria=
model::SectionDataSet,
rma::criteria,[failed$eqfalse],products[abbreviation$eq'Mouse'],treatments[name$eq'ISH'],genes,plane_of_section,
rma::options,
[tabular$eq'plane_of_sections.name as plane','genes.acronym as gene','data_sets.id as section_data_set_id'],
[order$eq'plane_of_sections.name,genes.acronym,data_sets.id']
&num_rows=50&start_row=0

Mouse Brain ISH experiments in comma delimited format with end of line characters removed so that it will work when pasted into the Google Chrome browser:

http://api.brain-map.org/api/v2/data/query.csv?criteria=model::SectionDataSet,rma::criteria,[failed$eqfalse],products[abbreviation$eq'Mouse'],treatments[name$eq'ISH'],genes,plane_of_section,rma::options,[tabular$eq'plane_of_sections.name as plane','genes.acronym as gene','data_sets.id as section_data_set_id'],[order$eq'plane_of_sections.name,genes.acronym,data_sets.id']&num_rows=50&start_row=0

Developing Mouse Brain Atlas ISH experiments with SectionImages:

http://api.brain-map.org/api/v2/data/query.xml?criteria=
model::SectionDataSet,
rma::criteria,[failed$eqfalse],products[abbreviation$eq'DevMouse'],treatments[name$eq'ISH'],
rma::include,genes,specimen(donor(age)),plane_of_section,section_images
&num_rows=10&start_row=0

Sleep Study ISH experiments that include the experimental condition:

http://api.brain-map.org/api/v2/data/query.xml?criteria=
model::SectionDataSet,
rma::criteria,[failed$eqfalse],products[abbreviation$eq'Sleep'],treatments[name$eq'ISH'],
rma::include,probes(gene),plane_of_section,specimen(donor(disease_categories,medical_conditions)),section_images
&num_rows=10

Human Brain ISH Autism Study experiments that include the donor's conditions:

http://api.brain-map.org/api/v2/data/query.xml?criteria=
model::SectionDataSet,
rma::criteria,[failed$eqfalse],products[abbreviation$eq'HumanASD'],treatments[name$eq'ISH'],
rma::include,probes(gene),specimen(donor(age,disease_categories,medical_conditions)),section_images
&num_rows=10

Developing Human Brain ISH experiments:

http://api.brain-map.org/api/v2/data/query.xml?criteria=
model::SectionDataSet,
rma::criteria,[failed$eqfalse],products[abbreviation$eq'DevHumanISH'],treatments[name$eq'ISH'],
rma::include,probes(gene),specimen(donor(age,disease_categories,medical_conditions)),section_images
&num_rows=10

Human Brain Microarray experiments:

http://api.brain-map.org/api/v2/data/query.xml?criteria=
model::MicroarraySlide,
rma::criteria,microarray_data_sets[failed$eqfalse](products[abbreviation$eq'HumanMA']),
rma::include,structures,well_known_files,microarray_data_sets(specimen(donor(age)))

Developing Human Brain Prenatal LMD Microarray experiments:

http://api.brain-map.org/api/v2/data/query.xml?criteria=
model::MicroarraySlide,
rma::criteria,microarray_data_sets[failed$eqfalse](products[abbreviation$eq'DevHumanMA']),
rma::include,structures,well_known_files,microarray_data_sets(specimen(donor(age)))

Developing Human Brain Transcriptome experiments:

http://api.brain-map.org/api/v2/data/query.xml?criteria=
model::Specimen,
rma::criteria,data_sets(products[abbreviation$eq'DevHumanTrans']),
rma::include,structure,donor,well_known_files(well_known_file_type)