Mercurial > repos > eschen42 > mqppep_preproc

comparison search_ppep.py @ 17:ba5f14c2a4af draft

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
"planemo upload for repository https://github.com/galaxyproteomics/tools-galaxyp/tree/master/tools/mqppep commit aea9ac5a98069c3c993bd7903eda732f8ae2109d"
author eschen42
date Wed, 06 Apr 2022 05:47:34 +0000
parents 42daf70d4ed4
children 29775869faba
comparison
equal deleted inserted replaced
16:d9906288cc6a 17:ba5f14c2a4af
101 , Organism_ID 101 , Organism_ID
102 , Gene_Name 102 , Gene_Name
103 , PE 103 , PE
104 , SV 104 , SV
105 , Sequence 105 , Sequence
106 , Description || ' OS=' || 106 , Description ||
107 Organism_Name || ' OX=' || Organism_ID || 107 CASE WHEN Organism_Name = 'N/A'
108 CASE WHEN Gene_Name = 'N/A' THEN '' ELSE ' GN='|| Gene_Name END || 108 THEN ''
109 CASE WHEN PE = 'N/A' THEN '' ELSE ' PE='|| PE END || 109 ELSE ' OS='|| Organism_Name
110 CASE WHEN SV = 'N/A' THEN '' ELSE ' SV='|| SV END 110 END ||
111 AS long_description 111 CASE WHEN Organism_ID = -1
112 THEN ''
113 ELSE ' OX='|| Organism_ID
114 END ||
115 CASE WHEN Gene_Name = 'N/A'
116 THEN ''
117 ELSE ' GN='|| Gene_Name
118 END ||
119 CASE WHEN PE = 'N/A'
120 THEN ''
121 ELSE ' PE='|| PE
122 END ||
123 CASE WHEN SV = 'N/A'
124 THEN ''
125 ELSE ' SV='|| SV
126 END AS long_description
112 , Database 127 , Database
113 FROM UniProtKB 128 FROM UniProtKB
114 ; 129 ;
115 CREATE VIEW uniprotkb_pep_ppep_view AS 130 CREATE VIEW uniprotkb_pep_ppep_view AS
116 SELECT deppep_UniProtKB.UniprotKB_ID AS accession 131 SELECT deppep_UniProtKB.UniprotKB_ID AS accession