gistfile1.txt

select map.value, a.ns, count(i.id) from annotation as a 
join annotation_mapvalue as map on a.id=map.annotation_id
join imageannotationlink as ial on ial.child=a.id
join image as i on i.id=ial.parent
where
    map.name in ('Gene Symbol', 'Gene Identifier', 'Phenotype', 'siRNA Identifier', 'siRNA Pool Identifier', 'Organism')
    and a.ns like 'openmicroscopy.org/mapr/%'
group by map.value, a.ns
order by 3 DESC
limit 100


# demo3 - prod

-----------------------------------------------------------------------------------------+-----------------------------------+---------
 Homo sapiens                                                                            | openmicroscopy.org/mapr/organism  | 1724691
 Saccharomyces cerevisiae                                                                | openmicroscopy.org/mapr/organism  |  109534
 Schizosaccharomyces pombe                                                               | openmicroscopy.org/mapr/organism  |  102789
 Drosophila melanogaster                                                                 | openmicroscopy.org/mapr/organism  |   90330
 GFP localization: cytosol                                                               | openmicroscopy.org/mapr/phenotype |   39375
 Low total YAP/TAZ in nuclear and ring regions normalised to nuclear area                | openmicroscopy.org/mapr/phenotype |   21252
 abnormal microtubule cytoskeleton morphology during mitotic interphase                  | openmicroscopy.org/mapr/phenotype |   16821
 GFP localization: below threshold                                                       | openmicroscopy.org/mapr/phenotype |   13581
 Low nuclear YAP/TAZ                                                                     | openmicroscopy.org/mapr/phenotype |   12292
 viable vegetative cell with abnormal cell shape                                         | openmicroscopy.org/mapr/phenotype |   12241
 High nuclear YAP/TAZ                                                                    | openmicroscopy.org/mapr/phenotype |   11396
 GFP localization: nucleus                                                               | openmicroscopy.org/mapr/phenotype |   10959
 Triangular                                                                              | openmicroscopy.org/mapr/phenotype |    9884
 Large, spread                                                                           | openmicroscopy.org/mapr/phenotype |    9688
 Spindly                                                                                 | openmicroscopy.org/mapr/phenotype |    9688
 Fan                                                                                     | openmicroscopy.org/mapr/phenotype |    7616
 defective cell-cell aggregation                                                         | openmicroscopy.org/mapr/phenotype |    6030
 strong inhibition of secretion                                                          | openmicroscopy.org/mapr/phenotype |    5867
 GFP localization: mitochondria                                                          | openmicroscopy.org/mapr/phenotype |    5295
 GFP localization: punctate                                                              | openmicroscopy.org/mapr/phenotype |    5193
 Round, small                                                                            | openmicroscopy.org/mapr/phenotype |    4424
 High total YAP/TAZ in nuclear and ring regions normalised to nuclear area               | openmicroscopy.org/mapr/phenotype |    3808
 scramble                                                                                | openmicroscopy.org/mapr/sirna     |    3398
 INCENP                                                                                  | openmicroscopy.org/mapr/gene      |    3279
 KIF11                                                                                   | openmicroscopy.org/mapr/gene      |    3116
 cellular response to chemical stimulus                                                  | openmicroscopy.org/mapr/phenotype |    2808
 ENSG00000149503                                                                         | openmicroscopy.org/mapr/gene      |    2793
 viable elongated vegetative cell                                                        | openmicroscopy.org/mapr/phenotype |    2788
 short cytoplasmic microtubules                                                          | openmicroscopy.org/mapr/phenotype |    2682
 tea1                                                                                    | openmicroscopy.org/mapr/gene      |    2676
 SPCC1223.06                                                                             | openmicroscopy.org/mapr/gene      |    2676
 cell death (automatic)                                                                  | openmicroscopy.org/mapr/phenotype |    2625
 ENSG00000138160                                                                         | openmicroscopy.org/mapr/gene      |    2624
 28431                                                                                   | openmicroscopy.org/mapr/sirna     |    2614
 strange nuclear shape (manual)                                                          | openmicroscopy.org/mapr/phenotype |    2605
 14851                                                                                   | openmicroscopy.org/mapr/sirna     |    2558
 GFP localization: ER                                                                    | openmicroscopy.org/mapr/phenotype |    2499
 dynamic changes (automatic)                                                             | openmicroscopy.org/mapr/phenotype |    2491
 IP reduced                                                                              | openmicroscopy.org/mapr/phenotype |    2442


# clone3 - test

"Homo sapiens";"openmicroscopy.org/mapr/organism";1422393
"Saccharomyces cerevisiae";"openmicroscopy.org/mapr/organism";109535
"Schizosaccharomyces pombe";"openmicroscopy.org/mapr/organism";102789
"Drosophila melanogaster";"openmicroscopy.org/mapr/organism";90330
"GFP localization: cytosol";"openmicroscopy.org/mapr/phenotype";39375
"strong inhibition of secretion";"openmicroscopy.org/mapr/phenotype";17104
"abnormal microtubule cytoskeleton morphology during mitotic interphase";"openmicroscopy.org/mapr/phenotype";16821
"mild inhibition of secretion";"openmicroscopy.org/mapr/phenotype";16672
"GFP localization: below threshold";"openmicroscopy.org/mapr/phenotype";13581
"viable vegetative cell with abnormal cell shape";"openmicroscopy.org/mapr/phenotype";12241
"GFP localization: nucleus";"openmicroscopy.org/mapr/phenotype";10959
"103860";"openmicroscopy.org/mapr/sirna";8851
"KIF11";"openmicroscopy.org/mapr/gene";6434
"defective cell-cell aggregation";"openmicroscopy.org/mapr/phenotype";6030
"ENSG00000138160";"openmicroscopy.org/mapr/gene";5940
"14851";"openmicroscopy.org/mapr/sirna";5862
"INCENP";"openmicroscopy.org/mapr/gene";5633
"GFP localization: mitochondria";"openmicroscopy.org/mapr/phenotype";5295
"GFP localization: punctate";"openmicroscopy.org/mapr/phenotype";5193
"ENSG00000149503";"openmicroscopy.org/mapr/gene";5145
"28431";"openmicroscopy.org/mapr/sirna";4869
"24546";"openmicroscopy.org/mapr/sirna";4466
"cellular response to chemical stimulus";"openmicroscopy.org/mapr/phenotype";2808
"viable elongated vegetative cell";"openmicroscopy.org/mapr/phenotype";2788
"short cytoplasmic microtubules";"openmicroscopy.org/mapr/phenotype";2682
"scramble";"openmicroscopy.org/mapr/sirna";2682
"tea1";"openmicroscopy.org/mapr/gene";2676
"SPCC1223.06";"openmicroscopy.org/mapr/gene";2676
"cell death (automatic)";"openmicroscopy.org/mapr/phenotype";2618
"strange nuclear shape (manual)";"openmicroscopy.org/mapr/phenotype";2595
"GFP localization: ER";"openmicroscopy.org/mapr/phenotype";2499
"dynamic changes (automatic)";"openmicroscopy.org/mapr/phenotype";2488
"IP reduced";"openmicroscopy.org/mapr/phenotype";2442
"PAA increased";"openmicroscopy.org/mapr/phenotype";2382
"mal3";"openmicroscopy.org/mapr/gene";2322
"SPAC18G6.15";"openmicroscopy.org/mapr/gene";2322
"protein localized in nucleolus";"openmicroscopy.org/mapr/phenotype";2320
"segregation problems/chromatin bridges/lagging chromosomes/multiple DNA masses (manual)";"openmicroscopy.org/mapr/phenotype";2181
"decreased cell number";"openmicroscopy.org/mapr/phenotype";2011
"loss of cell monolayer";"openmicroscopy.org/mapr/phenotype";1812
"other phenotype";"openmicroscopy.org/mapr/phenotype";1754
"enhancement of ch-TOG multipolar spindle phenotype";"openmicroscopy.org/mapr/phenotype";1740
"IP increased";"openmicroscopy.org/mapr/phenotype";1731
"metaphase alignment problems/including no metaphase (manual)";"openmicroscopy.org/mapr/phenotype";1724
"mitotic delay/arrest (automatic)";"openmicroscopy.org/mapr/phenotype";1639
"binuclear (automatic)";"openmicroscopy.org/mapr/phenotype";1634
"ase1";"openmicroscopy.org/mapr/gene";1632
"SPAPB1A10.09";"openmicroscopy.org/mapr/gene";1632
"altered kinetochore foci";"openmicroscopy.org/mapr/phenotype";1570
"mto1";"openmicroscopy.org/mapr/gene";1560
"SPCC417.07c";"openmicroscopy.org/mapr/gene";1560
"nuclei stay close together (manual)";"openmicroscopy.org/mapr/phenotype";1554
"PAA reduced";"openmicroscopy.org/mapr/phenotype";1552
"increased width of lamellae";"openmicroscopy.org/mapr/phenotype";1470
"cell shape variable";"openmicroscopy.org/mapr/phenotype";1459
"microtubule bundles present in greater numbers";"openmicroscopy.org/mapr/phenotype";1427
"enhanced secretion";"openmicroscopy.org/mapr/phenotype";1424
"COPB1";"openmicroscopy.org/mapr/gene";1407
"ENSG00000129083";"openmicroscopy.org/mapr/gene";1389
"viable stubby vegetative cell";"openmicroscopy.org/mapr/phenotype";1360
"HIS3";"openmicroscopy.org/mapr/gene";1359
"YOR202W";"openmicroscopy.org/mapr/gene";1359
"disorganised peripheral actin";"openmicroscopy.org/mapr/phenotype";1231
"long cytoplasmic microtubules";"openmicroscopy.org/mapr/phenotype";1226
"S-shaped cell";"openmicroscopy.org/mapr/phenotype";1211
"increased number of actin puncta or dots";"openmicroscopy.org/mapr/phenotype";1122
"metaphase delay/arrest (manual)";"openmicroscopy.org/mapr/phenotype";1109
"microtubule processes";"openmicroscopy.org/mapr/phenotype";1099
"cell shape bipolar or elongated";"openmicroscopy.org/mapr/phenotype";1098
"increased cell size";"openmicroscopy.org/mapr/phenotype";1078
"polylobed (automatic)";"openmicroscopy.org/mapr/phenotype";1072
"increased number of multinucleate cells";"openmicroscopy.org/mapr/phenotype";1068
"protein localized in an uncharacterized nuclear subcompartment";"openmicroscopy.org/mapr/phenotype";1024
"suppression of ch-TOG multipolar spindle phenotype";"openmicroscopy.org/mapr/phenotype";1020
"increased number of cortical actin stress fibres";"openmicroscopy.org/mapr/phenotype";996
"cell shape processes or spiky or stretchy";"openmicroscopy.org/mapr/phenotype";964
"Q103860";"openmicroscopy.org/mapr/sirna";944
"GFP localization: bud neck";"openmicroscopy.org/mapr/phenotype";942
"motile lamellae";"openmicroscopy.org/mapr/phenotype";933
"increased peripheral actin";"openmicroscopy.org/mapr/phenotype";904
"Mus musculus";"openmicroscopy.org/mapr/organism";899
"GFP localization: nucleolus";"openmicroscopy.org/mapr/phenotype";897
"GFP localization: cell periphery";"openmicroscopy.org/mapr/phenotype";873
"migration (speed) (automatic)";"openmicroscopy.org/mapr/phenotype";867
"increased number of zigzag actin stress fibres";"openmicroscopy.org/mapr/phenotype";843
"cell shape geometric";"openmicroscopy.org/mapr/phenotype";801
"increased number of transverse actin stress fibres";"openmicroscopy.org/mapr/phenotype";795
"decreased level of actin";"openmicroscopy.org/mapr/phenotype";795
"large (automatic)";"openmicroscopy.org/mapr/phenotype";780
"increased number of filopodia";"openmicroscopy.org/mapr/phenotype";753
"misshapen DNA";"openmicroscopy.org/mapr/phenotype";721
"GFP localization: nuclear periphery";"openmicroscopy.org/mapr/phenotype";693
"increased number of actin stress fibres";"openmicroscopy.org/mapr/phenotype";668
"11004";"openmicroscopy.org/mapr/gene";634
"GFP localization: vacuole";"openmicroscopy.org/mapr/phenotype";633
"GFP localization: vacuole membrane";"openmicroscopy.org/mapr/phenotype";630
"viable pear-shaped vegetative cell";"openmicroscopy.org/mapr/phenotype";619
"protein localized in PML bodies ";"openmicroscopy.org/mapr/phenotype";608
"GFP localization: technical problem";"openmicroscopy.org/mapr/phenotype";603
"protein localized in nuclear pore";"openmicroscopy.org/mapr/phenotype";524