I have found that numbers in scientific notation (e.g 9.8E-9) are incorrectly sorted or filtered by Galaxy. Looks like the negative exponent is ignored and so if you sorting something like P values (see example below) then you find these ordered above P=1 instead at the other end of the list where P is near zero. In the example below a KEGG list is ordered on column 5 in asending order by galaxy. If you scroll to the bottom of the list, however, you will see the smallest numbers all of which are in scientific notation. I should note that I can can copy this into excel and excel will properly sort scientific notation. So this seems to be a specific problem with Galaxy. I found this problem with both filtering and sorting functions of Galaxy.Doug Cavener
41 0.53 26 1.0 0.0000025 cfa04146=Peroxisome 39 0.53 25 1.0 0.0000038 cfa04640=Hematopoietic cell lineage 29 0.59 13 1.0 0.0000044 cfa00980=Metabolism of xenobiotics by cytochrome P450 22 0.63 10 1.0 0.000016 cfa00140=Steroid hormone biosynthesis 28 0.56 19 1.0 0.000027 cfa05204=Chemical carcinogenesis 11 0.85 3 1.0 0.000033 cfa00511=Other glycan degradation 25 0.57 16 1.0 0.000052 cfa00600=Sphingolipid metabolism 9 0.90 2 1.0 0.000074 cfa00740=Riboflavin metabolism 23 0.58 14 1.0 0.000079 cfa00380=Tryptophan metabolism 15 0.68 6 1.0 0.000096 cfa04977=Vitamin digestion and absorption 22 0.56 17 1.0 0.00017 cfa00071=Fatty acid metabolism 22 0.56 17 1.0 0.00017 cfa05150=Staphylococcus aureus infection 26 0.53 27 1.0 0.00017 cfa00982=Drug metabolism - cytochrome P450 49 0.44 42 1.0 0.00018 cfa04142=Lysosome 56 0.42 47 1.0 0.00024 cfa04630=Jak-STAT signaling pathway 34 0.48 35 1.0 0.00026 cfa03320=PPAR signaling pathway 13 0.68 5 1.0 0.00027 cfa00531=Glycosaminoglycan degradation 20 0.56 21 1.0 0.00043 cfa04975=Fat digestion and absorption 22 0.54 24 1.0 0.00043 cfa00830=Retinol metabolism 19 0.56 20 1.0 0.00053 cfa00565=Ether lipid metabolism 14 0.61 11 1.0 0.00092 cfa00591=Linoleic acid metabolism 20 0.53 28 1.0 0.0011 cfa02010=ABC transporters 22 0.50 32 1.0 0.0015 cfa00280=Valine, leucine and isoleucine degradation 33 0.44 44 1.0 0.0020 cfa04974=Protein digestion and absorption 15 0.56 21 1.0 0.0022 cfa03440=Homologous recombination 14 0.56 19 1.0 0.0028 cfa00650=Butanoate metabolism 35 0.42 48 1.0 0.0035 cfa05323=Rheumatoid arthritis 16 0.52 31 1.0 0.0043 cfa00350=Tyrosine metabolism 16 0.52 31 1.0 0.0043 cfa05320=Autoimmune thyroid disease 12 0.57 15 1.0 0.0044 cfa00592=alpha-Linolenic acid metabolism 15 0.52 30 1.0 0.0054 cfa00760=Nicotinate and nicotinamide metabolism 21 0.47 39 1.0 0.0054 cfa05144=Malaria 84 0.36 66 1.0 0.0059 cfa04080=Neuroactive ligand-receptor interaction 16 0.48 33 1.0 0.0091 cfa05143=African trypanosomiasis 12 0.52 29 1.0 0.011 cfa00340=Histidine metabolism 14 0.48 34 0.99 0.015 cfa05330=Allograft rejection 9 0.56 18 1.0 0.015 cfa04614=Renin-angiotensin system 3 1.0 1 1.0 0.021 cfa00780=Biotin metabolism 35 0.38 56 0.99 0.021 cfa00240=Pyrimidine metabolism 15 0.44 43 0.99 0.030 cfa04940=Type I diabetes mellitus 11 0.48 36 0.99 0.032 cfa00563=Glycosylphosphatidylinositol(GPI)-anchor biosynthesis 29 0.38 54 0.98 0.032 cfa04512=ECM-receptor interaction 20 0.41 50 0.98 0.034 cfa04622=RIG-I-like receptor signaling pathway 9 0.50 32 0.99 0.037 cfa00100=Steroid biosynthesis 10 0.48 37 0.99 0.042 cfa04950=Maturity onset diabetes of the young 7 0.54 23 0.99 0.042 cfa03450=Non-homologous end-joining 6 0.55 22 0.99 0.055 cfa00430=Taurine and hypotaurine metabolism 6 0.55 22 0.99 0.055 cfa00790=Folate biosynthesis 22 0.38 58 0.97 0.060 cfa05140=Leishmaniasis 12 0.43 46 0.97 0.062 cfa00512=Mucin type O-Glycan biosynthesis 3 0.75 4 0.99 0.068 cfa00061=Fatty acid biosynthesis 3 0.75 4 0.99 0.068 cfa00232=Caffeine metabolism 23 0.37 62 0.96 0.070 cfa04115=p53 signaling pathway 29 0.36 64 0.96 0.071 cfa00564=Glycerophospholipid metabolism 8 0.47 38 0.98 0.071 cfa00120=Primary bile acid biosynthesis 20 0.38 59 0.96 0.074 cfa00561=Glycerolipid metabolism 19 0.38 57 0.96 0.076 cfa04612=Antigen processing and presentation 48 0.34 74 0.95 0.076 cfa05152=Tuberculosis 18 0.38 53 0.96 0.077 cfa00510=N-Glycan biosynthesis 2 1.0 1 1.0 0.077 cfa00290=Valine, leucine and isoleucine biosynthesis 16 0.39 52 0.96 0.079 cfa00500=Starch and sucrose metabolism 16 0.39 52 0.96 0.079 cfa04621=NOD-like receptor signaling pathway 12 0.41 49 0.96 0.080 cfa00410=beta-Alanine metabolism 7 0.47 39 0.97 0.093 cfa00604=Glycosphingolipid biosynthesis - ganglio series 33 0.34 72 0.94 0.094 cfa05146=Amoebiasis 8 0.44 41 0.96 0.097 cfa00900=Terpenoid backbone biosynthesis 4 0.57 15 0.98 0.099 cfa00460=Cyanoamino acid metabolism 4 0.57 15 0.98 0.099 cfa00750=Vitamin B6 metabolism 12 0.40 51 0.95 0.10 cfa00052=Galactose metabolism 12 0.40 51 0.95 0.10 cfa00983=Drug metabolism - other enzymes 9 0.43 46 0.96 0.10 cfa00040=Pentose and glucuronate interconversions 5 0.50 32 0.97 0.11 cfa04122=Sulfur relay system 26 0.35 70 0.93 0.12 cfa04064=NF-kappa B signaling pathway 10 0.40 51 0.94 0.13 cfa05332=Graft-versus-host disease 17 0.36 63 0.92 0.13 cfa00480=Glutathione metabolism 21 0.35 68 0.92 0.13 cfa05133=Pertussis 7 0.44 45 0.95 0.13 cfa00770=Pantothenate and CoA biosynthesis 12 0.38 61 0.92 0.15 cfa03410=Base excision repair 21 0.34 71 0.90 0.15 cfa04976=Bile secretion 15 0.36 65 0.90 0.16 cfa04978=Mineral absorption 4 0.50 32 0.96 0.16 cfa00072=Synthesis and degradation of ketone bodies 50 0.32 78 0.88 0.16 cfa00230=Purine metabolism 8 0.40 51 0.93 0.16 cfa05310=Asthma 6 0.43 46 0.94 0.17 cfa00603=Glycosphingolipid biosynthesis - globo series 2 0.67 8 0.98 0.19 cfa00785=Lipoic acid metabolism 8 0.38 55 0.90 0.20 cfa00062=Fatty acid elongation 8 0.38 55 0.90 0.20 cfa03430=Mismatch repair 11 0.35 67 0.88 0.22 cfa05340=Primary immunodeficiency 12 0.34 73 0.85 0.25 cfa00260=Glycine, serine and threonine metabolism 40 0.31 81 0.81 0.25 cfa04145=Phagosome 42 0.31 82 0.80 0.25 cfa05164=Influenza A 13 0.33 75 0.83 0.27 cfa00970=Aminoacyl-tRNA biosynthesis 1 1.0 1 1.0 0.28 cfa00472=D-Arginine and D-ornithine metabolism 4 0.40 51 0.89 0.29 cfa00130=Ubiquinone and other terpenoid-quinone biosynthesis 4 0.40 51 0.89 0.29 cfa00920=Sulfur metabolism 8 0.35 69 0.84 0.29 cfa00630=Glyoxylate and dicarboxylate metabolism 36 0.30 85 0.76 0.30 cfa04514=Cell adhesion molecules (CAMs) 10 0.33 75 0.81 0.31 cfa00640=Propanoate metabolism 2 0.50 32 0.93 0.31 cfa00730=Thiamine metabolism 7 0.35 68 0.84 0.31 cfa01040=Biosynthesis of unsaturated fatty acids 14 0.32 77 0.78 0.32 cfa05134=Legionellosis 44 0.30 86 0.74 0.32 cfa05168=Herpes simplex infection 11 0.32 76 0.79 0.33 cfa00860=Porphyrin and chlorophyll metabolism 12 0.32 79 0.77 0.36 cfa00620=Pyruvate metabolism 31 0.30 87 0.70 0.38 cfa05145=Toxoplasmosis 6 0.33 75 0.79 0.38 cfa00670=One carbon pool by folate 12 0.31 81 0.73 0.39 cfa04672=Intestinal immune network for IgA production 12 0.31 81 0.73 0.39 cfa04973=Carbohydrate digestion and absorption 14 0.30 84 0.72 0.40 cfa00520=Amino sugar and nucleotide sugar metabolism 11 0.31 83 0.72 0.41 cfa05219=Bladder cancer 23 0.29 88 0.69 0.41 cfa05222=Small cell lung cancer 8 0.31 81 0.72 0.44 cfa00601=Glycosphingolipid biosynthesis - lacto and neolacto series 8 0.31 81 0.72 0.44 cfa04966=Collecting duct acid secretion 5 0.31 80 0.73 0.47 cfa00533=Glycosaminoglycan biosynthesis - keratan sulfate 1 0.50 32 0.92 0.48 cfa00300=Lysine biosynthesis 10 0.29 89 0.67 0.48 cfa03030=DNA replication 12 0.29 90 0.62 0.51 cfa04930=Type II diabetes mellitus 33 0.28 92 0.57 0.51 cfa04110=Cell cycle 16 0.28 91 0.59 0.53 cfa05416=Viral myocarditis 2 0.33 75 0.79 0.53 cfa00400=Phenylalanine, tyrosine and tryptophan biosynthesis 24 0.28 93 0.57 0.53 cfa04972=Pancreatic secretion 5 0.29 89 0.68 0.53 cfa00360=Phenylalanine metabolism 13 0.27 94 0.53 0.59 cfa00310=Lysine degradation 8 0.27 95 0.54 0.62 cfa00250=Alanine, aspartate and glutamate metabolism 8 0.27 95 0.54 0.62 cfa00514=Other types of O-glycan biosynthesis 4 0.27 95 0.59 0.63 cfa00450=Selenocompound metabolism 4 0.27 95 0.59 0.63 cfa01210=2-Oxocarboxylic acid metabolism 11 0.26 97 0.49 0.64 cfa04330=Notch signaling pathway 14 0.26 96 0.49 0.64 cfa00330=Arginine and proline metabolism 4 0.25 100 0.53 0.69 cfa00053=Ascorbate and aldarate metabolism 8 0.25 100 0.45 0.70 cfa00270=Cysteine and methionine metabolism 9 0.25 100 0.44 0.70 cfa04623=Cytosolic DNA-sensing pathway 18 0.25 98 0.39 0.71 cfa04210=Apoptosis 5 0.24 107 0.45 0.73 cfa04140=Regulation of autophagy 14 0.24 104 0.33 0.77 cfa00010=Glycolysis / Gluconeogenesis 7 0.23 111 0.38 0.77 cfa05020=Prion diseases 8 0.24 109 0.37 0.77 cfa00051=Fructose and mannose metabolism 28 0.25 101 0.28 0.79 cfa04380=Osteoclast differentiation 1 0.20 129 0.58 0.80 cfa00524=Butirosin and neomycin biosynthesis 6 0.22 116 0.35 0.80 cfa05216=Thyroid cancer 31 0.25 102 0.25 0.81 cfa05012=Parkinson's disease 15 0.23 110 0.27 0.82 cfa04920=Adipocytokine signaling pathway 16 0.24 109 0.27 0.82 cfa04350=TGF-beta signaling pathway 23 0.24 105 0.24 0.82 cfa05142=Chagas disease (American trypanosomiasis) 9 0.22 114 0.29 0.82 cfa03420=Nucleotide excision repair 17 0.23 112 0.24 0.83 cfa05410=Hypertrophic cardiomyopathy (HCM) 35 0.24 103 0.22 0.83 cfa05202=Transcriptional misregulation in cancer 10 0.22 116 0.26 0.84 cfa05014=Amyotrophic lateral sclerosis (ALS) 13 0.22 115 0.23 0.85 cfa04370=VEGF signaling pathway 26 0.24 108 0.20 0.86 cfa05160=Hepatitis C 31 0.24 106 0.19 0.86 cfa00190=Oxidative phosphorylation 76 0.25 99 0.17 0.86 cfa04151=PI3K-Akt signaling pathway 7 0.21 127 0.24 0.87 cfa04742=Taste transduction 15 0.22 118 0.18 0.88 cfa05218=Melanoma 14 0.22 122 0.17 0.90 cfa05412=Arrhythmogenic right ventricular cardiomyopathy (ARVC) 17 0.22 120 0.15 0.90 cfa05414=Dilated cardiomyopathy 4 0.18 140 0.23 0.90 cfa00534=Glycosaminoglycan biosynthesis - heparan sulfate / heparin 5 0.19 136 0.20 0.90 cfa00030=Pentose phosphate pathway 21 0.22 117 0.13 0.91 cfa04726=Serotonergic synapse 15 0.21 124 0.13 0.92 cfa03008=Ribosome biogenesis in eukaryotes 4 0.17 145 0.19 0.92 cfa04320=Dorso-ventral axis formation 7 0.19 134 0.16 0.92 cfa04960=Aldosterone-regulated sodium reabsorption 22 0.22 121 0.10 0.93 cfa04066=HIF-1 signaling pathway 24 0.22 119 0.11 0.93 cfa04670=Leukocyte transendothelial migration 28 0.22 116 0.10 0.93 cfa05161=Hepatitis B 43 0.23 113 0.095 0.93 cfa04144=Endocytosis 14 0.20 128 0.11 0.94 cfa05220=Chronic myeloid leukemia 5 0.17 146 0.15 0.94 cfa04744=Phototransduction 6 0.18 142 0.13 0.94 cfa04130=SNARE interactions in vesicular transport 12 0.19 133 0.079 0.96 cfa05211=Renal cell carcinoma 23 0.21 125 0.067 0.96 cfa05162=Measles 4 0.15 154 0.11 0.96 cfa03020=RNA polymerase 10 0.18 141 0.063 0.97 cfa00562=Inositol phosphate metabolism 4 0.14 161 0.079 0.97 cfa04710=Circadian rhythm 10 0.17 146 0.047 0.98 cfa05210=Colorectal cancer 15 0.18 139 0.034 0.98 cfa04914=Progesterone-mediated oocyte maturation 20 0.19 133 0.028 0.98 cfa04270=Vascular smooth muscle contraction 40 0.21 123 0.032 0.98 cfa04510=Focal adhesion 8 0.16 150 0.048 0.98 cfa05213=Endometrial cancer 10 0.15 154 0.015 0.99 cfa05212=Pancreatic cancer 10 0.16 149 0.029 0.99 cfa04260=Cardiac muscle contraction 10 0.16 153 0.021 0.99 cfa05214=Glioma 13 0.16 151 0.012 0.99 cfa05215=Prostate cancer 14 0.17 148 0.016 0.99 cfa04012=ErbB signaling pathway 14 0.18 144 0.025 0.99 cfa04620=Toll-like receptor signaling pathway 15 0.17 146 0.017 0.99 cfa04650=Natural killer cell mediated cytotoxicity 17 0.18 143 0.014 0.99 cfa04114=Oocyte meiosis 24 0.18 137 0.010 0.99 cfa04910=Insulin signaling pathway 32 0.20 130 0.015 0.99 cfa05010=Alzheimer's disease 33 0.20 131 0.010 0.99 cfa05016=Huntington's disease 8 0.15 158 0.020 0.99 cfa04730=Long-term depression 9 0.15 157 0.016 0.99 cfa03018=RNA degradation 9 0.15 157 0.016 0.99 cfa04664=Fc epsilon RI signaling pathway 0 0.0 204 0.38 1.0 cfa00471=D-Glutamine and D-glutamate metabolism 1 0.036 201 0.0014 1.0 cfa00020=Citrate cycle (TCA cycle) 1 0.045 198 0.0076 1.0 cfa03060=Protein export 1 0.053 196 0.018 1.0 cfa04964=Proximal tubule bicarbonate reclamation 1 0.059 194 0.030 1.0 cfa00532=Glycosaminoglycan biosynthesis - chondroitin sulfate / dermatan sulfate 10 0.13 171 0.0017 1.0 cfa04912=GnRH signaling pathway 10 0.13 172 0.0014 1.0 cfa04070=Phosphatidylinositol signaling system 10 0.14 163 0.0053 1.0 cfa05100=Bacterial invasion of epithelial cells 11 0.087 186 1.6E-7 1.0 cfa04310=Wnt signaling pathway 11 0.13 170 0.0012 1.0 cfa04666=Fc gamma R-mediated phagocytosis 11 0.15 156 0.0087 1.0 cfa04970=Salivary secretion 13 0.083 187 1.9E-9 1.0 cfa05034=Alcoholism 13 0.13 167 0.00067 1.0 cfa04660=T cell receptor signaling pathway 15 0.12 173 0.000058 1.0 cfa04360=Axon guidance 15 0.12 173 0.000058 1.0 cfa04530=Tight junction 15 0.12 175 0.000010 1.0 cfa04390=Hippo signaling pathway 15 0.14 164 0.00065 1.0 cfa04722=Neurotrophin signaling pathway 18 0.13 169 0.000042 1.0 cfa03010=Ribosome 18 0.14 165 0.00015 1.0 cfa04120=Ubiquitin mediated proteolysis 18 0.16 152 0.0035 1.0 cfa05322=Systemic lupus erythematosus 2 0.016 203 8.1E-15 1.0 cfa03040=Spliceosome 2 0.028 202 3.3E-8 1.0 cfa03015=mRNA surveillance pathway 26 0.19 135 0.0088 1.0 cfa03013=RNA transport 27 0.15 159 0.000019 1.0 cfa05203=Viral carcinogenesis 28 0.17 145 0.0018 1.0 cfa04141=Protein processing in endoplasmic reticulum 28 0.17 148 0.00087 1.0 cfa04062=Chemokine signaling pathway 29 0.17 147 0.00094 1.0 cfa05169=Epstein-Barr virus infection 3 0.038 200 5.6E-8 1.0 cfa04727=GABAergic synapse 3 0.052 197 0.000014 1.0 cfa04720=Long-term potentiation 3 0.067 189 0.00045 1.0 cfa04961=Endocrine and other factor-regulated calcium reabsorption 3 0.070 188 0.00076 1.0 cfa04962=Vasopressin-regulated water reabsorption 3 0.091 184 0.0090 1.0 cfa05033=Nicotine addiction 30 0.15 155 0.000038 1.0 cfa04810=Regulation of actin cytoskeleton 31 0.18 138 0.0040 1.0 cfa04020=Calcium signaling pathway 34 0.14 160 0.0000011 1.0 cfa04010=MAPK signaling pathway 4 0.061 192 0.000010 1.0 cfa04971=Gastric acid secretion 4 0.098 182 0.0050 1.0 cfa03022=Basal transcription factors 46 0.19 132 0.0017 1.0 cfa05166=HTLV-I infection 5 0.043 199 6.9E-11 1.0 cfa04728=Dopaminergic synapse 5 0.056 195 1.4E-7 1.0 cfa04723=Retrograde endocannabinoid signaling 5 0.062 190 0.0000011 1.0 cfa04540=Gap junction 5 0.11 177 0.0082 1.0 cfa05030=Cocaine addiction 5 0.11 180 0.0066 1.0 cfa03050=Proteasome 5 0.12 175 0.010 1.0 cfa04340=Hedgehog signaling pathway 6 0.059 193 3.4E-8 1.0 cfa04725=Cholinergic synapse 6 0.061 191 7.4E-8 1.0 cfa04724=Glutamatergic synapse 6 0.10 181 0.0012 1.0 cfa05031=Amphetamine addiction 6 0.12 174 0.0084 1.0 cfa05217=Basal cell carcinoma 6 0.12 176 0.0045 1.0 cfa05223=Non-small cell lung cancer 62 0.21 126 0.0038 1.0 cfa05200=Pathways in cancer 66 0.14 162 1.1E-11 1.0 cfa04740=Olfactory transduction 7 0.11 178 0.0016 1.0 cfa04520=Adherens junction 7 0.13 166 0.012 1.0 cfa05221=Acute myeloid leukemia 8 0.090 185 0.000014 1.0 cfa04713=Circadian entrainment 8 0.090 185 0.000014 1.0 cfa04916=Melanogenesis 8 0.095 183 0.000044 1.0 cfa05032=Morphine addiction 8 0.11 179 0.00075 1.0 cfa05132=Salmonella infection 8 0.13 168 0.0068 1.0 cfa04150=mTOR signaling pathway 8 0.13 168 0.0068 1.0 cfa04721=Synaptic vesicle cycle 9 0.14 161 0.0095 1.0 cfa04662=B cell receptor signaling pathway 32 0.68 7 1.0 1.2E-8 cfa03460=Fanconi anemia pathway 34 0.64 9 1.0 4.2E-8 cfa00590=Arachidonic acid metabolism 85 0.45 40 1.0 4.9E-7 cfa04060=Cytokine-cytokine receptor interaction 34 0.60 12 1.0 5.3E-7 cfa04610=Complement and coagulation cascades 408 0.38 60 1.0 8.6E-11 cfa01100=Metabolic pathways
___________________________________________________________
The Galaxy User list should be used for the discussion of
Galaxy analysis and other features on the public server
at usegalaxy.org. Please keep all replies on the list by
using "reply all" in your mail client. For discussion of
local Galaxy instances and the Galaxy source code, please
use the Galaxy Development list:
http://lists.bx.psu.edu/listinfo/galaxy-dev
To manage your subscriptions to this and other Galaxy lists,
please use the interface at:
http://lists.bx.psu.edu/
To search Galaxy mailing lists use the unified search at:
http://galaxyproject.org/search/mailinglists/