diff options
| -rwxr-xr-x | wqflask/maintenance/gen_select_dataset.py | 52 | ||||
| -rwxr-xr-x | wqflask/wqflask/static/new/javascript/dataset_menu_structure.json | 696 | ||||
| -rwxr-xr-x | wqflask/wqflask/templates/index_page.html | 12 | ||||
| -rwxr-xr-x | wqflask/wqflask/templates/show_trait_mapping_tools.html | 118 |
4 files changed, 214 insertions, 664 deletions
diff --git a/wqflask/maintenance/gen_select_dataset.py b/wqflask/maintenance/gen_select_dataset.py index 694efeca..a2ad8c91 100755 --- a/wqflask/maintenance/gen_select_dataset.py +++ b/wqflask/maintenance/gen_select_dataset.py @@ -35,7 +35,9 @@ from __future__ import print_function, division #config = config.Config(cdict).from_envvar('WQFLASK_SETTINGS') #print("cdict is:", cdict) -import our_settings +import sys +sys.path.append("/home/zas1024/") +import zach_settings import MySQLdb @@ -47,7 +49,7 @@ import urlparse from pprint import pformat as pf -#Engine = sa.create_engine(our_settings.SQLALCHEMY_DATABASE_URI) +#Engine = sa.create_engine(zach_settings.SQLALCHEMY_DATABASE_URI) # build MySql database connection @@ -60,7 +62,7 @@ from pprint import pformat as pf def parse_db_uri(db_uri): """Converts a database URI to the db name, host name, user name, and password""" - parsed_uri = urlparse.urlparse(our_settings.DB_URI) + parsed_uri = urlparse.urlparse(zach_settings.DB_URI) db_conn_info = dict( db = parsed_uri.path[1:], @@ -104,12 +106,48 @@ def get_types(groups): types[species] = {} for group_name, _group_full_name in group_dict: # make group an alias to shorten the code - types[species][group_name] = [("Phenotypes", "Phenotypes"), ("Genotypes", "Genotypes")] - types[species][group_name] += build_types(species, group_name) + #types[species][group_name] = [("Phenotypes", "Phenotypes"), ("Genotypes", "Genotypes")] + if phenotypes_exist(group_name): + types[species][group_name] = [("Phenotypes", "Phenotypes")] + if genotypes_exist(group_name): + if group_name in types[species]: + types[species][group_name] += [("Genotypes", "Genotypes")] + else: + types[species][group_name] = [("Genotypes", "Genotypes")] + if group_name in types[species]: + types[species][group_name] += build_types(species, group_name) + else: + types[species][group_name] = build_types(species, group_name) return types +def phenotypes_exist(group_name): + print("group_name:", group_name) + Cursor.execute("""select Name from PublishFreeze + where PublishFreeze.Name = %s""", (group_name+"Publish")) + + results = Cursor.fetchone() + print("RESULTS:", results) + + if results != None: + return True + else: + return False + +def genotypes_exist(group_name): + print("group_name:", group_name) + Cursor.execute("""select Name from GenoFreeze + where GenoFreeze.Name = %s""", (group_name+"Geno")) + + results = Cursor.fetchone() + print("RESULTS:", results) + + if results != None: + return True + else: + return False + def build_types(species, group): """Fetches tissues @@ -196,7 +234,7 @@ def build_datasets(species, group, type_name): def main(): """Generates and outputs (as json file) the data for the main dropdown menus on the home page""" - parse_db_uri(our_settings.DB_URI) + parse_db_uri(zach_settings.DB_URI) species = get_species() groups = get_groups(species) @@ -236,6 +274,6 @@ def _test_it(): #print("build_datasets:", pf(datasets)) if __name__ == '__main__': - Conn = MySQLdb.Connect(**parse_db_uri(our_settings.DB_URI)) + Conn = MySQLdb.Connect(**parse_db_uri(zach_settings.DB_URI)) Cursor = Conn.cursor() main() diff --git a/wqflask/wqflask/static/new/javascript/dataset_menu_structure.json b/wqflask/wqflask/static/new/javascript/dataset_menu_structure.json index fabf3998..e790c9c0 100755 --- a/wqflask/wqflask/static/new/javascript/dataset_menu_structure.json +++ b/wqflask/wqflask/static/new/javascript/dataset_menu_structure.json @@ -56,12 +56,6 @@ }, "barley": { "QSM": { - "Genotypes": [ - [ - "QSMGeno", - "QSM Genotypes" - ] - ], "Leaf mRNA": [ [ "B1LI0809R", @@ -79,12 +73,6 @@ "B1MI0809R", "Barley1 Leaf MOCK TTKS (Aug09) RMA" ] - ], - "Phenotypes": [ - [ - "QSMPublish", - "QSM Published Phenotypes" - ] ] }, "SXM": { @@ -114,12 +102,12 @@ "Barley1 Leaf MAS 5.0 SCRI (Dec06)" ], [ - "B30_K_1206_Rn", - "Barley1 Leaf gcRMAn SCRI (Dec06)" - ], - [ "B30_K_1206_R", "Barley1 Leaf gcRMA SCRI (Dec06)" + ], + [ + "B30_K_1206_Rn", + "Barley1 Leaf gcRMAn SCRI (Dec06)" ] ], "Phenotypes": [ @@ -132,18 +120,6 @@ }, "drosophila": { "DGRP": { - "Genotypes": [ - [ - "DGRPGeno", - "DGRP Genotypes" - ] - ], - "Phenotypes": [ - [ - "DGRPPublish", - "DGRP Published Phenotypes" - ] - ], "Whole Body mRNA": [ [ "NCSU_DrosWB_LC_RMA_0111", @@ -152,18 +128,6 @@ ] }, "Oregon-R_x_2b3": { - "Genotypes": [ - [ - "Oregon-R_x_2b3Geno", - "Oregon-R_x_2b3 Genotypes" - ] - ], - "Phenotypes": [ - [ - "Oregon-R_x_2b3Publish", - "Oregon-R_x_2b3 Published Phenotypes" - ] - ], "Whole Body mRNA": [ [ "UAB_DrosWB_LC_RMA_1009", @@ -195,18 +159,6 @@ "GSE5281_RMA0709", "GSE5281 Human Brain Best 102 Liang (Jul09) RMA" ] - ], - "Genotypes": [ - [ - "AD-cases-controlsGeno", - "AD-cases-controls Genotypes" - ] - ], - "Phenotypes": [ - [ - "AD-cases-controlsPublish", - "AD-cases-controls Published Phenotypes" - ] ] }, "AD-cases-controls-Myers": { @@ -229,12 +181,6 @@ "AD-cases-controls-MyersGeno", "AD-cases-controls-Myers Genotypes" ] - ], - "Phenotypes": [ - [ - "AD-cases-controls-MyersPublish", - "AD-cases-controls-Myers Published Phenotypes" - ] ] }, "Aging-Brain-UCI": { @@ -244,24 +190,12 @@ "GSE11882 UCI Human Entorhinal Cortex Affy U133 Plus2 (Sep13) RMA" ] ], - "Genotypes": [ - [ - "Aging-Brain-UCIGeno", - "Aging-Brain-UCI Genotypes" - ] - ], "Hippocampus mRNA": [ [ "UCI_HC_0913", "GSE11882 UCI Human Hippocampus Affy U133 Plus2 (Sep13) RMA" ] ], - "Phenotypes": [ - [ - "Aging-Brain-UCIPublish", - "Aging-Brain-UCI Published Phenotypes" - ] - ], "Postcentral Gyrus mRNA": [ [ "UCI_PCG_0913", @@ -282,18 +216,6 @@ "GSE15745 NIH Human Brain Cerebellum ILM humanRef-8 v2.0 (May10) RankInv" ] ], - "Genotypes": [ - [ - "Brain-Normal-NIH-GibbsGeno", - "Brain-Normal-NIH-Gibbs Genotypes" - ] - ], - "Phenotypes": [ - [ - "Brain-Normal-NIH-GibbsPublish", - "Brain-Normal-NIH-Gibbs Published Phenotypes" - ] - ], "Pons mRNA": [ [ "GSE15745-GPL6104_Po0510", @@ -314,12 +236,6 @@ ] }, "CANDLE": { - "Genotypes": [ - [ - "CANDLEGeno", - "CANDLE Genotypes" - ] - ], "Methylation": [ [ "CANDLE_Meth27_0313", @@ -344,12 +260,6 @@ ] }, "CEPH-2004": { - "Genotypes": [ - [ - "CEPH-2004Geno", - "CEPH-2004 Genotypes" - ] - ], "Lymphoblast B-cell mRNA": [ [ "UT_CEPH_RankInv0909", @@ -359,12 +269,6 @@ "Human_1008", "Monks CEPH B-cells Agilent (Dec04) Log10Ratio" ] - ], - "Phenotypes": [ - [ - "CEPH-2004Publish", - "CEPH-2004 Published Phenotypes" - ] ] }, "GTEx": { @@ -558,12 +462,6 @@ "GTEx Human Frontal Cortex (Apr14) RPKM" ] ], - "Genotypes": [ - [ - "GTExGeno", - "GTEx Genotypes" - ] - ], "Heart - Atrial Appendage mRNA": [ [ "GTEx_log2_HeartAt_0314", @@ -684,12 +582,6 @@ "GTEx Human Pancreas (Apr14) RPKM" ] ], - "Phenotypes": [ - [ - "GTExPublish", - "GTEx Published Phenotypes" - ] - ], "Pituitary Gland mRNA": [ [ "GTEx_log2_Pitui_0314", @@ -870,18 +762,6 @@ "HBTRC-MLC Human Cerebellum Agilent HD (Jun11) mlratio" ] ], - "Genotypes": [ - [ - "HBGeno", - "HB Genotypes" - ] - ], - "Phenotypes": [ - [ - "HBPublish", - "HB Published Phenotypes" - ] - ], "Prefrontal Cortex mRNA": [ [ "HBTRC-MLPFC_0611", @@ -920,12 +800,6 @@ ] }, "HCP": { - "Genotypes": [ - [ - "HCPGeno", - "HCP Genotypes" - ] - ], "Phenotypes": [ [ "HCPPublish", @@ -934,12 +808,6 @@ ] }, "HLC": { - "Genotypes": [ - [ - "HLCGeno", - "HLC Genotypes" - ] - ], "Liver mRNA": [ [ "HLC_0311", @@ -962,12 +830,6 @@ ] }, "HLT": { - "Genotypes": [ - [ - "HLTGeno", - "HLT Genotypes" - ] - ], "Lung mRNA": [ [ "GSE23546HLT0613", @@ -985,12 +847,6 @@ "GRNG-GSE23545HLT0613", "GRNG/GSE23545 Whole-Genome GXD Non-Tumorous Human Lung Tissues Affy HuRSTA array (Jun11) RMA" ] - ], - "Phenotypes": [ - [ - "HLTPublish", - "HLT Published Phenotypes" - ] ] }, "HSB": { @@ -1012,12 +868,6 @@ "Human Dorsolateral Prefrontal Cortex Affy Hu-Exon 1.0 ST (Jul11) Quantile" ] ], - "Genotypes": [ - [ - "HSBGeno", - "HSB Genotypes" - ] - ], "Hippocampus mRNA": [ [ "KIN_YSM_HIP_0711", @@ -1048,12 +898,6 @@ "Human Orbital Prefrontal Cortex Affy Hu-Exon 1.0 ST (Jul11) Quantile" ] ], - "Phenotypes": [ - [ - "HSBPublish", - "HSB Published Phenotypes" - ] - ], "Posterior Inferior Parietal Cortex mRNA": [ [ "KIN_YSM_IPC_0711", @@ -1118,12 +962,6 @@ "INIA Macaca fasicularis Brain (Jan10) RMA **" ] ], - "Genotypes": [ - [ - "Macaca-fasicularisGeno", - "Macaca-fasicularis Genotypes" - ] - ], "Hippocampus mRNA": [ [ "INIA_MacFas_Hc_RMA_0110", @@ -1136,12 +974,6 @@ "INIA Macaca fasicularis Nucleus Accumbens (Jan10) RMA **" ] ], - "Phenotypes": [ - [ - "Macaca-fasicularisPublish", - "Macaca-fasicularis Published Phenotypes" - ] - ], "Prefrontal Cortex mRNA": [ [ "INIA_MacFas_Pf_RMA_0110", @@ -1164,18 +996,12 @@ "NCI Mammary LMT miRNA v2 (Apr09) RMA" ], [ - "MA_M_0704_R", - "NCI Mammary mRNA M430 (July04) RMA" - ], - [ "MA_M_0704_M", "NCI Mammary mRNA M430 (July04) MAS5" - ] - ], - "Phenotypes": [ + ], [ - "AKXDPublish", - "AKXD Published Phenotypes" + "MA_M_0704_R", + "NCI Mammary mRNA M430 (July04) RMA" ] ] }, @@ -1226,12 +1052,12 @@ ], "Liver mRNA": [ [ - "LVF2_M_0704_R", - "(B6 x BTBR)F2-ob/ob Liver mRNA M430 (Jul04) RMA" - ], - [ "LVF2_M_0704_M", "(B6 x BTBR)F2-ob/ob Liver mRNA M430 (Jul04) MAS5" + ], + [ + "LVF2_M_0704_R", + "(B6 x BTBR)F2-ob/ob Liver mRNA M430 (Jul04) RMA" ] ], "Phenotypes": [ @@ -1244,10 +1070,6 @@ "B6D2F2": { "Brain mRNA": [ [ - "BRF2_M_0805_M", - "OHSU/VA B6D2F2 Brain mRNA M430 (Aug05) MAS5" - ], - [ "BRF2_M_0805_P", "OHSU/VA B6D2F2 Brain mRNA M430 (Aug05) PDNN" ], @@ -1256,16 +1078,20 @@ "OHSU/VA B6D2F2 Brain mRNA M430 (Aug05) RMA" ], [ - "BRF2_M_0304_P", - "OHSU/VA B6D2F2 Brain mRNA M430A (Mar04) PDNN" + "BRF2_M_0805_M", + "OHSU/VA B6D2F2 Brain mRNA M430 (Aug05) MAS5" ], [ - "BRF2_M_0304_R", - "OHSU/VA B6D2F2 Brain mRNA M430A (Mar04) RMA" + "BRF2_M_0304_P", + "OHSU/VA B6D2F2 Brain mRNA M430A (Mar04) PDNN" ], [ "BRF2_M_0304_M", "OHSU/VA B6D2F2 Brain mRNA M430A (Mar04) MAS5" + ], + [ + "BRF2_M_0304_R", + "OHSU/VA B6D2F2 Brain mRNA M430A (Mar04) RMA" ] ], "Genotypes": [ @@ -1273,12 +1099,6 @@ "B6D2F2Geno", "B6D2F2 Genotypes" ] - ], - "Phenotypes": [ - [ - "B6D2F2Publish", - "B6D2F2 Published Phenotypes" - ] ] }, "B6D2F2-PSU": { @@ -1305,32 +1125,14 @@ "PSU-B6D2F2_M2000812", "PSU B6D2F2 Muscle Affy Mouse Genome 430 2.0 (Aug12) RMA Males Aged 200 **" ] - ], - "Phenotypes": [ - [ - "B6D2F2-PSUPublish", - "B6D2F2-PSU Published Phenotypes" - ] ] }, "B6D2RI": { - "Genotypes": [ - [ - "B6D2RIGeno", - "B6D2RI Genotypes" - ] - ], "Hippocampus mRNA": [ [ "UTHSC_B6D2RI_H_0912", "UTHSC B6D2RI Aged Hippocampus Affy Mouse Gene 1.0 ST (Sep12) RMA **" ] - ], - "Phenotypes": [ - [ - "B6D2RIPublish", - "B6D2RI Published Phenotypes" - ] ] }, "BDF2-1999": { @@ -1345,12 +1147,6 @@ "UCLA_BDF2_LIVER_1999", "UCLA BDF2 Liver (1999) mlratio" ] - ], - "Phenotypes": [ - [ - "BDF2-1999Publish", - "BDF2-1999 Published Phenotypes" - ] ] }, "BDF2-2005": { @@ -1360,52 +1156,46 @@ "BDF2-2005 Genotypes" ] ], - "Phenotypes": [ - [ - "BDF2-2005Publish", - "BDF2-2005 Published Phenotypes" - ] - ], "Striatum mRNA": [ [ - "SA_M2_0905_R", - "OHSU/VA B6D2F2 Striatum M430v2 (Sep05) RMA" - ], - [ "SA_M2_0905_M", "OHSU/VA B6D2F2 Striatum M430v2 (Sep05) MAS5" ], [ "SA_M2_0905_P", "OHSU/VA B6D2F2 Striatum M430v2 (Sep05) PDNN" + ], + [ + "SA_M2_0905_R", + "OHSU/VA B6D2F2 Striatum M430v2 (Sep05) RMA" ] ] }, "BHF2": { "Adipose mRNA": [ [ - "UCLA_BHF2_ADIPOSE_MALE", - "UCLA BHF2 Adipose Male mlratio" - ], - [ "UCLA_BHF2_ADIPOSE_FEMALE", "UCLA BHF2 Adipose Female mlratio" ], [ + "UCLA_BHF2_ADIPOSE_MALE", + "UCLA BHF2 Adipose Male mlratio" + ], + [ "UCLA_BHF2_ADIPOSE_0605", "UCLA BHF2 Adipose (June05) mlratio" ] ], "Brain mRNA": [ [ - "UCLA_BHF2_BRAIN_MALE", - "UCLA BHF2 Brain Male mlratio" - ], - [ "UCLA_BHF2_BRAIN_FEMALE", "UCLA BHF2 Brain Female mlratio" ], [ + "UCLA_BHF2_BRAIN_MALE", + "UCLA BHF2 Brain Male mlratio" + ], + [ "UCLA_BHF2_BRAIN_0605", "UCLA BHF2 Brain (June05) mlratio" ] @@ -1418,37 +1208,31 @@ ], "Liver mRNA": [ [ - "UCLA_BHF2_LIVER_MALE", - "UCLA BHF2 Liver Male mlratio" - ], - [ "UCLA_BHF2_LIVER_FEMALE", "UCLA BHF2 Liver Female mlratio" ], [ + "UCLA_BHF2_LIVER_MALE", + "UCLA BHF2 Liver Male mlratio" + ], + [ "UCLA_BHF2_LIVER_0605", "UCLA BHF2 Liver (June05) mlratio" ] ], "Muscle mRNA": [ [ - "UCLA_BHF2_MUSCLE_MALE", - "UCLA BHF2 Muscle Male mlratio **" - ], - [ "UCLA_BHF2_MUSCLE_FEMALE", "UCLA BHF2 Muscle Female mlratio **" ], [ + "UCLA_BHF2_MUSCLE_MALE", + "UCLA BHF2 Muscle Male mlratio **" + ], + [ "UCLA_BHF2_MUSCLE_0605", "UCLA BHF2 Muscle (June05) mlratio **" ] - ], - "Phenotypes": [ - [ - "BHF2Publish", - "BHF2 Published Phenotypes" - ] ] }, "BHHBF2": { @@ -1513,12 +1297,6 @@ "UCLA_BHHBF2_MUSCLE_FEMALE", "UCLA BHHBF2 Muscle Female Only" ] - ], - "Phenotypes": [ - [ - "BHHBF2Publish", - "BHHBF2 Published Phenotypes" - ] ] }, "BXD": { @@ -1604,14 +1382,14 @@ "UTHSC Mouse BXD Whole Brain RNA Sequence (Nov12) RPKM Trimmed 2.0" ], [ - "UTHSC_BXD_WB_RNASeq1112", - "UTHSC Mouse BXD Whole Brain RNA Sequence (Nov12) RPKM Untrimmed" - ], - [ "UTHSC_BXD_WB_RNASeqtrim1_1112", "UTHSC Mouse BXD Whole Brain RNA Sequence (Nov12) RPKM Trimmed 1.0" ], [ + "UTHSC_BXD_WB_RNASeq1112", + "UTHSC Mouse BXD Whole Brain RNA Sequence (Nov12) RPKM Untrimmed" + ], + [ "UTHSC_BXD_WB_RNASeqEx1112", "UTHSC Mouse BXD Whole Brain RNA Sequence Exon Level (Nov12) RPKM" ], @@ -1624,6 +1402,10 @@ "UTHSC Brain mRNA U74Av2 (Nov05) PDNN" ], [ + "BR_U_0805_P", + "UTHSC Brain mRNA U74Av2 (Aug05) PDNN" + ], + [ "BR_U_0805_M", "UTHSC Brain mRNA U74Av2 (Aug05) MAS5" ], @@ -1632,10 +1414,6 @@ "UTHSC Brain mRNA U74Av2 (Aug05) RMA" ], [ - "BR_U_0805_P", - "UTHSC Brain mRNA U74Av2 (Aug05) PDNN" - ], - [ "CB_M_0204_P", "INIA Brain mRNA M430 (Feb04) PDNN" ] @@ -1746,10 +1524,6 @@ "Eye M430v2 WT Gpnmb (Sep08) RMA **" ], [ - "Eye_M2_0908_R_MT", - "Eye M430v2 Mutant Tyrp1 (Sep08) RMA **" - ], - [ "Eye_M2_0908_WTWT", "Eye M430v2 WT WT (Sep08) RMA **" ], @@ -1758,6 +1532,10 @@ "Eye M430v2 WT Tyrp1 (Sep08) RMA **" ], [ + "Eye_M2_0908_R_MT", + "Eye M430v2 Mutant Tyrp1 (Sep08) RMA **" + ], + [ "DBA2J-ONH-1212", "Howell et al. 2011, DBA/2J Glaucoma Optic Nerve Head M430 2.0 (Dec12) RMA" ], @@ -1962,12 +1740,12 @@ "Mouse Kidney M430v2 Sex Balanced (Aug06) PDNN" ], [ - "MA_M2_0706_P", - "Mouse Kidney M430v2 (Jul06) PDNN" - ], - [ "MA_M2_0706_R", "Mouse Kidney M430v2 (Jul06) RMA" + ], + [ + "MA_M2_0706_P", + "Mouse Kidney M430v2 (Jul06) PDNN" ] ], "Leucocytes mRNA": [ @@ -1988,14 +1766,14 @@ ], "Liver Proteome": [ [ - "EPFLETHZBXDprotHFD0514", - "EPFL/ETHZ BXD Liver, Soluble Proteins HFD (May14) SWATH **" - ], - [ "EPFLETHZBXDprotCD0514", "EPFL/ETHZ BXD Liver, Soluble Proteins CD (May14) SWATH **" ], [ + "EPFLETHZBXDprotHFD0514", + "EPFL/ETHZ BXD Liver, Soluble Proteins HFD (May14) SWATH **" + ], + [ "EPFLBXDprotHFDRPN0214", "EPFL/LISP BXD Liver, Soluble Proteins HFD (Feb14) SRM **" ], @@ -2132,14 +1910,14 @@ ], "Neocortex mRNA": [ [ - "DevNeocortex_ILM6.2P14RInv_1111", - "BIDMC/UTHSC Dev Neocortex P14 ILMv6.2 (Nov11) RankInv" - ], - [ "DevNeocortex_ILM6.2P3RInv_1111", "BIDMC/UTHSC Dev Neocortex P3 ILMv6.2 (Nov11) RankInv" ], [ + "DevNeocortex_ILM6.2P14RInv_1111", + "BIDMC/UTHSC Dev Neocortex P14 ILMv6.2 (Nov11) RankInv" + ], + [ "HQFNeoc_1210v2_RankInv", "HQF BXD Neocortex ILM6v1.1 (Dec10v2) RankInv" ], @@ -2152,12 +1930,12 @@ "HQF BXD Neocortex ILM6v1.1 (Feb08) RankInv" ], [ - "DevNeocortex_ILM6.2P3RInv_1110", - "BIDMC/UTHSC Dev Neocortex P3 ILMv6.2 (Nov10) RankInv" - ], - [ "DevNeocortex_ILM6.2P14RInv_1110", "BIDMC/UTHSC Dev Neocortex P14 ILMv6.2 (Nov10) RankInv" + ], + [ + "DevNeocortex_ILM6.2P3RInv_1110", + "BIDMC/UTHSC Dev Neocortex P3 ILMv6.2 (Nov10) RankInv" ] ], "Nucleus Accumbens mRNA": [ @@ -2256,14 +2034,14 @@ "ONC HEI Retina (April 2012) RankInv" ], [ - "DoDTATRCRetMoGene2_1313", - "DoD TATRC Retina Affy MoGene 2.0 ST (Dec13) RMA" - ], - [ "DoDTATRCRetExMoGene2_1313", "DoD TATRC Retina Affy MoGene 2.0 ST (Dec13) RMA Exon Level" ], [ + "DoDTATRCRetMoGene2_1313", + "DoD TATRC Retina Affy MoGene 2.0 ST (Dec13) RMA" + ], + [ "ONCRetMoGene2_0413", "DoD TATRC Retina Affy MoGene 2.0 ST (Oct13) RMA **" ], @@ -2284,12 +2062,12 @@ "B6D2 ONC Retina (April 2012) RankInv **" ], [ - "HEIONCvsCRetILM6_0911", - "HEI ONC vs Control Retina Illumina V6.2 (Sep11) RankInv **" - ], - [ "G2HEIONCRetILM6_0911", "G2 HEI ONC Retina Illumina V6.2 (Sep11) RankInv **" + ], + [ + "HEIONCvsCRetILM6_0911", + "HEI ONC vs Control Retina Illumina V6.2 (Sep11) RankInv **" ] ], "Spleen mRNA": [ @@ -2376,12 +2154,12 @@ "BIDMC/UTHSC Dev Striatum P14 ILMv6.2 (Nov11) RankInv **" ], [ - "DevStriatum_ILM6.2P14RInv_1110", - "BIDMC/UTHSC Dev Striatum P14 ILMv6.2 (Nov10) RankInv **" - ], - [ "DevStriatum_ILM6.2P3RInv_1110", "BIDMC/UTHSC Dev Striatum P3 ILMv6.2 (Nov10) RankInv **" + ], + [ + "DevStriatum_ILM6.2P14RInv_1110", + "BIDMC/UTHSC Dev Striatum P14 ILMv6.2 (Nov10) RankInv **" ] ], "T Cell (helper) mRNA": [ @@ -2404,16 +2182,16 @@ ], "Ventral Tegmental Area mRNA": [ [ - "VCUEtOH_0609_R", - "VCU BXD VTA EtOH M430 2.0 (Jun09) RMA **" - ], - [ "VCUSal_0609_R", "VCU BXD VTA Sal M430 2.0 (Jun09) RMA **" ], [ "VCUEtvsSal_0609_R", "VCU BXD VTA Et vs Sal M430 2.0 (Jun09) Sscore **" + ], + [ + "VCUEtOH_0609_R", + "VCU BXD VTA EtOH M430 2.0 (Jun09) RMA **" ] ] }, @@ -2550,12 +2328,12 @@ ], "Hippocampus mRNA": [ [ - "HC_M2CB_1205_R", - "Hippocampus Consortium M430v2 CXB (Dec05) RMA" - ], - [ "HC_M2CB_1205_P", "Hippocampus Consortium M430v2 CXB (Dec05) PDNN" + ], + [ + "HC_M2CB_1205_R", + "Hippocampus Consortium M430v2 CXB (Dec05) RMA" ] ], "Phenotypes": [ @@ -2572,12 +2350,6 @@ ] }, "HS": { - "Genotypes": [ - [ - "HSGeno", - "HS Genotypes" - ] - ], "Hippocampus mRNA": [ [ "OXUKHS_ILMHipp_RI0510", @@ -2604,18 +2376,6 @@ ] }, "HS-CC": { - "Genotypes": [ - [ - "HS-CCGeno", - "HS-CC Genotypes" - ] - ], - "Phenotypes": [ - [ - "HS-CCPublish", - "HS-CC Published Phenotypes" - ] - ], "Striatum mRNA": [ [ "OHSU_HS-CC_ILMStr_0211", @@ -2660,14 +2420,6 @@ "Hippocampus Illumina (May07) RankInv" ], [ - "Illum_LXS_Hipp_NON_1008", - "Hippocampus Illumina NON (Oct08) RankInv beta" - ], - [ - "Illum_LXS_Hipp_RSE_1008", - "Hippocampus Illumina RSE (Oct08) RankInv beta" - ], - [ "Illum_LXS_Hipp_NOE_1008", "Hippocampus Illumina NOE (Oct08) RankInv beta" ], @@ -2678,6 +2430,14 @@ [ "Illum_LXS_Hipp_NOS_1008", "Hippocampus Illumina NOS (Oct08) RankInv beta" + ], + [ + "Illum_LXS_Hipp_NON_1008", + "Hippocampus Illumina NON (Oct08) RankInv beta" + ], + [ + "Illum_LXS_Hipp_RSE_1008", + "Hippocampus Illumina RSE (Oct08) RankInv beta" ] ], "Phenotypes": [ @@ -2688,16 +2448,16 @@ ], "Prefrontal Cortex mRNA": [ [ - "VCUEtOH_0806_R", - "VCU LXS PFC EtOH M430A 2.0 (Aug06) RMA **" - ], - [ "VCUSal_0806_R", "VCU LXS PFC Sal M430A 2.0 (Aug06) RMA" ], [ "VCUEt_vs_Sal_0806_R", "VCU LXS PFC Et vs Sal M430A 2.0 (Aug06) Sscore **" + ], + [ + "VCUEtOH_0806_R", + "VCU LXS PFC EtOH M430A 2.0 (Aug06) RMA **" ] ] }, @@ -2736,12 +2496,12 @@ ], "Hippocampus mRNA": [ [ - "UMUTAffyExon_0209_RMA_MDP", - "UMUTAffy Hippocampus Exon (Feb09) RMA MDP" - ], - [ "HC_M2_0606_MDP", "Hippocampus Consortium M430v2 (Jun06) RMA MDP" + ], + [ + "UMUTAffyExon_0209_RMA_MDP", + "UMUTAffy Hippocampus Exon (Feb09) RMA MDP" ] ], "Liver mRNA": [ @@ -2774,12 +2534,6 @@ ] }, "NZBXFVB-N2": { - "Genotypes": [ - [ - "NZBXFVB-N2Geno", - "NZBXFVB-N2 Genotypes" - ] - ], "Mammary Tumors mRNA": [ [ "NCI_Mam_Tum_RMA_0409", @@ -2799,12 +2553,6 @@ "SOTNOT-OHSUGeno", "SOTNOT-OHSU Genotypes" ] - ], - "Phenotypes": [ - [ - "SOTNOT-OHSUPublish", - "SOTNOT-OHSU Published Phenotypes" - ] ] }, "Scripps-2013": { @@ -2817,29 +2565,11 @@ "ScrBXDACC4GEx0513", "Scripps BXD ACC 4 Groups Affy Mouse Gene 1.0 ST (May13) RMA Exon Level **" ] - ], - "Genotypes": [ - [ - "Scripps-2013Geno", - "Scripps-2013 Genotypes" - ] - ], - "Phenotypes": [ - [ - "Scripps-2013Publish", - "Scripps-2013 Published Phenotypes" - ] ] } }, "rat": { "HSNIH": { - "Genotypes": [ - [ - "HSNIHGeno", - "HSNIH Genotypes" - ] - ], "Phenotypes": [ [ "HSNIHPublish", @@ -2915,18 +2645,6 @@ "UIOWA_Eye_RMA_0906", "UIOWA Eye mRNA RAE230v2 (Sep06) RMA" ] - ], - "Genotypes": [ - [ - "SRxSHRSPF2Geno", - "SRxSHRSPF2 Genotypes" - ] - ], - "Phenotypes": [ - [ - "SRxSHRSPF2Publish", - "SRxSHRSPF2 Published Phenotypes" - ] ] } }, @@ -2946,12 +2664,6 @@ ] }, "J12XJ58F2": { - "Genotypes": [ - [ - "J12XJ58F2Geno", - "J12XJ58F2 Genotypes" - ] - ], "Phenotypes": [ [ "J12XJ58F2Publish", @@ -2962,12 +2674,6 @@ }, "tomato": { "LXP": { - "Genotypes": [ - [ - "LXPGeno", - "LXP Genotypes" - ] - ], "Phenotypes": [ [ "LXPPublish", @@ -3285,14 +2991,6 @@ "barley": { "QSM": [ [ - "Phenotypes", - "Phenotypes" - ], - [ - "Genotypes", - "Genotypes" - ], - [ "Leaf mRNA", "Leaf mRNA" ] @@ -3319,28 +3017,12 @@ "drosophila": { "DGRP": [ [ - "Phenotypes", - "Phenotypes" - ], - [ - "Genotypes", - "Genotypes" - ], - [ "Whole Body mRNA", "Whole Body mRNA" ] ], "Oregon-R_x_2b3": [ [ - "Phenotypes", - "Phenotypes" - ], - [ - "Genotypes", - "Genotypes" - ], - [ "Whole Body mRNA", "Whole Body mRNA" ] @@ -3349,24 +3031,12 @@ "human": { "AD-cases-controls": [ [ - "Phenotypes", - "Phenotypes" - ], - [ - "Genotypes", - "Genotypes" - ], - [ "Brain mRNA", "Brain mRNA" ] ], "AD-cases-controls-Myers": [ [ - "Phenotypes", - "Phenotypes" - ], - [ "Genotypes", "Genotypes" ], @@ -3377,14 +3047,6 @@ ], "Aging-Brain-UCI": [ [ - "Phenotypes", - "Phenotypes" - ], - [ - "Genotypes", - "Genotypes" - ], - [ "Entorhinal Cortex mRNA", "Entorhinal Cortex mRNA" ], @@ -3403,14 +3065,6 @@ ], "Brain-Normal-NIH-Gibbs": [ [ - "Phenotypes", - "Phenotypes" - ], - [ - "Genotypes", - "Genotypes" - ], - [ "Cerebellum mRNA", "Cerebellum mRNA" ], @@ -3433,10 +3087,6 @@ "Phenotypes" ], [ - "Genotypes", - "Genotypes" - ], - [ "Methylation", "Methylation" ], @@ -3447,28 +3097,12 @@ ], "CEPH-2004": [ [ - "Phenotypes", - "Phenotypes" - ], - [ - "Genotypes", - "Genotypes" - ], - [ "Lymphoblast B-cell mRNA", "Lymphoblast B-cell mRNA" ] ], "GTEx": [ [ - "Phenotypes", - "Phenotypes" - ], - [ - "Genotypes", - "Genotypes" - ], - [ "Adrenal Gland mRNA", "Adrenal Gland mRNA" ], @@ -3659,14 +3293,6 @@ ], "HB": [ [ - "Phenotypes", - "Phenotypes" - ], - [ - "Genotypes", - "Genotypes" - ], - [ "Cerebellum mRNA", "Cerebellum mRNA" ], @@ -3683,10 +3309,6 @@ [ "Phenotypes", "Phenotypes" - ], - [ - "Genotypes", - "Genotypes" ] ], "HLC": [ @@ -3695,38 +3317,18 @@ "Phenotypes" ], [ - "Genotypes", - "Genotypes" - ], - [ "Liver mRNA", "Liver mRNA" ] ], "HLT": [ [ - "Phenotypes", - "Phenotypes" - ], - [ - "Genotypes", - "Genotypes" - ], - [ "Lung mRNA", "Lung mRNA" ] ], "HSB": [ [ - "Phenotypes", - "Phenotypes" - ], - [ - "Genotypes", - "Genotypes" - ], - [ "Amygdala mRNA", "Amygdala mRNA" ], @@ -3795,14 +3397,6 @@ "macaque monkey": { "Macaca-fasicularis": [ [ - "Phenotypes", - "Phenotypes" - ], - [ - "Genotypes", - "Genotypes" - ], - [ "Amygdala mRNA", "Amygdala mRNA" ], @@ -3827,10 +3421,6 @@ "mouse": { "AKXD": [ [ - "Phenotypes", - "Phenotypes" - ], - [ "Genotypes", "Genotypes" ], @@ -3881,10 +3471,6 @@ ], "B6D2F2": [ [ - "Phenotypes", - "Phenotypes" - ], - [ "Genotypes", "Genotypes" ], @@ -3895,10 +3481,6 @@ ], "B6D2F2-PSU": [ [ - "Phenotypes", - "Phenotypes" - ], - [ "Genotypes", "Genotypes" ], @@ -3909,24 +3491,12 @@ ], "B6D2RI": [ [ - "Phenotypes", - "Phenotypes" - ], - [ - "Genotypes", - "Genotypes" - ], - [ "Hippocampus mRNA", "Hippocampus mRNA" ] ], "BDF2-1999": [ [ - "Phenotypes", - "Phenotypes" - ], - [ "Genotypes", "Genotypes" ], @@ -3937,10 +3507,6 @@ ], "BDF2-2005": [ [ - "Phenotypes", - "Phenotypes" - ], - [ "Genotypes", "Genotypes" ], @@ -3951,10 +3517,6 @@ ], "BHF2": [ [ - "Phenotypes", - "Phenotypes" - ], - [ "Genotypes", "Genotypes" ], @@ -3977,10 +3539,6 @@ ], "BHHBF2": [ [ - "Phenotypes", - "Phenotypes" - ], - [ "Genotypes", "Genotypes" ], @@ -4233,10 +3791,6 @@ "Phenotypes" ], [ - "Genotypes", - "Genotypes" - ], - [ "Hippocampus mRNA", "Hippocampus mRNA" ], @@ -4251,14 +3805,6 @@ ], "HS-CC": [ [ - "Phenotypes", - "Phenotypes" - ], - [ - "Genotypes", - "Genotypes" - ], - [ "Striatum mRNA", "Striatum mRNA" ] @@ -4323,34 +3869,18 @@ "Phenotypes" ], [ - "Genotypes", - "Genotypes" - ], - [ "Mammary Tumors mRNA", "Mammary Tumors mRNA" ] ], "SOTNOT-OHSU": [ [ - "Phenotypes", - "Phenotypes" - ], - [ "Genotypes", "Genotypes" ] ], "Scripps-2013": [ [ - "Phenotypes", - "Phenotypes" - ], - [ - "Genotypes", - "Genotypes" - ], - [ "Anterior Cingulate Cortex mRNA", "Anterior Cingulate Cortex mRNA" ] @@ -4361,10 +3891,6 @@ [ "Phenotypes", "Phenotypes" - ], - [ - "Genotypes", - "Genotypes" ] ], "HXBBXH": [ @@ -4403,14 +3929,6 @@ ], "SRxSHRSPF2": [ [ - "Phenotypes", - "Phenotypes" - ], - [ - "Genotypes", - "Genotypes" - ], - [ "Eye mRNA", "Eye mRNA" ] @@ -4431,10 +3949,6 @@ [ "Phenotypes", "Phenotypes" - ], - [ - "Genotypes", - "Genotypes" ] ] }, @@ -4443,10 +3957,6 @@ [ "Phenotypes", "Phenotypes" - ], - [ - "Genotypes", - "Genotypes" ] ] } diff --git a/wqflask/wqflask/templates/index_page.html b/wqflask/wqflask/templates/index_page.html index 5e0a92e3..cb29a07c 100755 --- a/wqflask/wqflask/templates/index_page.html +++ b/wqflask/wqflask/templates/index_page.html @@ -206,12 +206,12 @@ <h3>GN1 Mirror and development sites</h3> <ul> - <li><a href="http://www.genenetwork.org/" target="_blank" style="font-size:12px;font-family:verdana;color:blue">Main GN1 site at UTHSC</a> (main site)</li> - <li><a href="http://www.genenetwork.waimr.uwa.edu.au/" target="_blank" style="font-size:12px;font-family:verdana;color:blue">Australia at the UWA</a></li> - <li><a href="http://gn.genetics.ucla.edu/" target="_blank" style="font-size:12px;font-family:verdana;color:blue">California at UCLA</a></li> - <li><a href="http://genenetwork.helmholtz-hzi.de/" target="_blank" style="font-size:12px;font-family:verdana;color:blue">Germany at the HZI</a></li> - <li><a href="http://genenetwork.memphis.edu/" target="_blank" style="font-size:12px;font-family:verdana;color:blue">Memphis at the U of M</a></li> - <li><a href="http://genenetwork.epfl.ch/" target="_blank" style="font-size:12px;font-family:verdana;color:blue">Switzerland at the EPFL</a></li> + <li><a href="http://www.genenetwork.org/" target="_blank">Main GN1 site at UTHSC</a> (main site)</li> + <li><a href="http://www.genenetwork.waimr.uwa.edu.au/" target="_blank">Australia at the UWA</a></li> + <li><a href="http://gn.genetics.ucla.edu/" target="_blank">California at UCLA</a></li> + <li><a href="http://genenetwork.helmholtz-hzi.de/" target="_blank">Germany at the HZI</a></li> + <li><a href="http://genenetwork.memphis.edu/" target="_blank">Memphis at the U of M</a></li> + <li><a href="http://genenetwork.epfl.ch/" target="_blank">Switzerland at the EPFL</a></li> </ul> </section> diff --git a/wqflask/wqflask/templates/show_trait_mapping_tools.html b/wqflask/wqflask/templates/show_trait_mapping_tools.html index 27504e51..bd1e6f1e 100755 --- a/wqflask/wqflask/templates/show_trait_mapping_tools.html +++ b/wqflask/wqflask/templates/show_trait_mapping_tools.html @@ -4,14 +4,16 @@ <ul class="nav nav-pills"> <li class="active"> - <a href="#interval_mapping" data-toggle="tab">Interval Mapping</a> - </li> - <li> <a href="#pylmm" data-toggle="tab">pyLMM</a> </li> <li> <a href="#rqtl_geno" data-toggle="tab">rqtl</a> </li> + {% if dataset.group.species != 'human' %} + <li> + <a href="#interval_mapping" data-toggle="tab">Interval Mapping</a> + </li> + {% endif %} {% if dataset.group.species == 'human' %} <li> <a href="#plink" data-toggle="tab">PLINK</a> @@ -26,60 +28,7 @@ </ul> <div class="tab-content"> - <div class="tab-pane active" id="interval_mapping"> - <div style="padding: 20px" class="form-horizontal"> - <div class="mapping_method_fields form-group"> - <label for="mapping_permutations" class="col-xs-2 control-label">Permutations</label> - <div style="margin-left: 20px;" class="col-xs-4 controls"> - <input name="num_perm_reaper" value="2000" type="text" class="form-control"> - </div> - </div> - - <div class="mapping_method_fields form-group"> - <label for="mapping_bootstraps" class="col-xs-2 control-label" title="Bootstrapping Resamples">Bootstrap</label> - <div style="margin-left: 20px;" class="col-xs-4 controls"> - <input name="mapping_bootstraps" value="2000" type="text" class="form-control"> - </div> - </div> - - <div class="mapping_method_fields form-group"> - <label style="text-align:left;" class="col-xs-12 control-label">Display Additive Effect</label> - <div class="col-xs-12 controls" id="display_additive_effect"> - <label class="radio-inline"> - <input type="radio" name="display_additive" id="display_additive" value="yes" checked=""> - Yes - </label> - <label class="radio-inline"> - <input type="radio" name="display_additive" id="display_additive" value="no"> - No - </label> - </div> - </div> - - <div class="mapping_method_fields form-group"> - <label style="text-align:left;" class="col-xs-12 control-label">Manhattan Plot</label> - <div class="col-xs-12 controls"> - <label class="radio-inline"> - <input type="radio" name="manhattan_plot_reaper" value="true"> - Yes - </label> - <label class="radio-inline"> - <input type="radio" name="manhattan_plot_reaper" value="false" checked=""> - No - </label> - </div> - </div> - <div class="form-group"> - <div style="padding-left:15px;" class="controls"> - <button id="interval_mapping_compute" class="btn submit_special btn-primary" data-url="/interval_mapping" title="Compute Interval Mapping"> - <i class="icon-ok-circle icon-white"></i> Open Mapping Tool - </button> - </div> - </div> - </div> - </div> - - <div class="tab-pane" id="pylmm"> + <div class="tab-pane active" id="pylmm"> <div style="padding: 20px" class="form-horizontal"> <div class="mapping_method_fields form-group"> @@ -211,7 +160,60 @@ </div> </div> </div> - + {% if dataset.group.species != 'human' %} + <div class="tab-pane" id="interval_mapping"> + <div style="padding: 20px" class="form-horizontal"> + <div class="mapping_method_fields form-group"> + <label for="mapping_permutations" class="col-xs-2 control-label">Permutations</label> + <div style="margin-left: 20px;" class="col-xs-4 controls"> + <input name="num_perm_reaper" value="2000" type="text" class="form-control"> + </div> + </div> + + <div class="mapping_method_fields form-group"> + <label for="mapping_bootstraps" class="col-xs-2 control-label" title="Bootstrapping Resamples">Bootstrap</label> + <div style="margin-left: 20px;" class="col-xs-4 controls"> + <input name="mapping_bootstraps" value="2000" type="text" class="form-control"> + </div> + </div> + + <div class="mapping_method_fields form-group"> + <label style="text-align:left;" class="col-xs-12 control-label">Display Additive Effect</label> + <div class="col-xs-12 controls" id="display_additive_effect"> + <label class="radio-inline"> + <input type="radio" name="display_additive" id="display_additive" value="yes" checked=""> + Yes + </label> + <label class="radio-inline"> + <input type="radio" name="display_additive" id="display_additive" value="no"> + No + </label> + </div> + </div> + + <div class="mapping_method_fields form-group"> + <label style="text-align:left;" class="col-xs-12 control-label">Manhattan Plot</label> + <div class="col-xs-12 controls"> + <label class="radio-inline"> + <input type="radio" name="manhattan_plot_reaper" value="true"> + Yes + </label> + <label class="radio-inline"> + <input type="radio" name="manhattan_plot_reaper" value="false" checked=""> + No + </label> + </div> + </div> + <div class="form-group"> + <div style="padding-left:15px;" class="controls"> + <button id="interval_mapping_compute" class="btn submit_special btn-primary" data-url="/interval_mapping" title="Compute Interval Mapping"> + <i class="icon-ok-circle icon-white"></i> Open Mapping Tool + </button> + </div> + </div> + </div> + </div> + {% endif %} {% if dataset.group.species == 'human' %} <div class="tab-pane" id="plink"> <div style="padding: 20px" class="form-horizontal"> |