… produces a chromosomal ideogram (api_out=ideogram) with gain/loss frequencies, for cancer samples with ICD-O codes 8144/3 and 8140/0 (icdm_m=8144/3,8140/0) selected from the progenetix database (db=progenetix)
This query will produce a histogram of regional gain/loss frequencies in samples matching the loci icdt_m=c18,c20 (e.g. c189 - large intestine …, c181 - appendix & c187 - sigmoid …) and “c20” (rectum) from arrayMap (db=arraymap). Also, the query will return only 100 random samples (randno=100) out of all matches.
Example histogram of cancer genome imbalances in 100 random colorectal carcinomas, directly generated from the API call shown
This query will produce a histogram for the frequency of germline CNVs, based on 1000 random reference arrays from the arrayMap collection. As a simple quality filter, only arrays are considered which lack any single segment >10Mb (which would be pretty much a marker for somatic changes or pathologic germline variants, though we found once a >10MB segment w/o apparent phenotype ourselves.
A geographic map of all publications registered in the Progenetix publication database, with locations derived (mostly) from the corresponding authors’ institutions, and marker sizes corresponding to the number of samples reported from there.
Data/Text
Called CNA segments from selected samples =api_out=segments=
The api_out=segments returns a list of CNA segments from infiltrating duct carcinoma samples (icdm_m=8500/3) with a “metast” word stem match (text_m=metast), e.g. having “metastasis” or “metastasised” somewhere in their annotations. As the list shows, these are only very few out of the expected number of samples …
Tab-delimited data table from selected samples =api_out=samples=
… results in a tab-delimited table with columns representing the comma-concatenated exportk_m parameters, from 200 (randno=200) adenocarcinomas and -adenomas (icdm_m=81) of various histologies
JSON data file from selected samples =api_out=samples&api_doctype=json=
… results in json data structure (api_doctype=json) containing the call information as well as the count of all neoplasias (icdm_m=8,9) with a deletion overlapping the TP53 CDR (locus_m=17:7512444-7531593:-1). Avoiding the json specification will just return the number of hits: