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:

Note: Please remove the end of line characters from this example before pasting it into Google Chrome, or [click here|http://api.brain-map.org/api/v2/data/query.csv?criteria=model::SectionDataSet,rma::criteria,failed$eqfalse,productsabbreviation$eq'Mouse',treatmentsname$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].

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)