Example Queries for Experiment Metadata

Examples

Mouse Brain ISH experiments in comma delimited format:

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)