Difference between revisions of "Talk:Bklein7 Week 14"
From LMU BioDB 2015
(made the query able to be copied easily) |
(added new sql query block) |
||
| Line 2: | Line 2: | ||
(propertytype.dbreferencetype_property_hjid = dbreferencetype.hjid) | (propertytype.dbreferencetype_property_hjid = dbreferencetype.hjid) | ||
where dbreferencetype.type = 'EnsemblBacteria' and propertytype.type = 'gene ID' order by propertytype.value; | where dbreferencetype.type = 'EnsemblBacteria' and propertytype.type = 'gene ID' order by propertytype.value; | ||
| + | |||
| + | select propertytype.value from propertytype inner join dbreferencetype on | ||
| + | (propertytype.dbreferencetype_property_hjid = dbreferencetype.hjid) | ||
| + | where dbreferencetype.type = 'EnsemblBacteria' and propertytype.type = 'gene ID' | ||
| + | and propertytype.value ~ 'BP[0-9][0-9][0-9][0-9](A|B)' order by propertytype.value; | ||
Revision as of 23:50, 10 December 2015
select propertytype.value from propertytype inner join dbreferencetype on (propertytype.dbreferencetype_property_hjid = dbreferencetype.hjid) where dbreferencetype.type = 'EnsemblBacteria' and propertytype.type = 'gene ID' order by propertytype.value;
select propertytype.value from propertytype inner join dbreferencetype on (propertytype.dbreferencetype_property_hjid = dbreferencetype.hjid) where dbreferencetype.type = 'EnsemblBacteria' and propertytype.type = 'gene ID' and propertytype.value ~ 'BP[0-9][0-9][0-9][0-9](A|B)' order by propertytype.value;
