Difference between revisions of "Talk:Bklein7 Week 14"
From LMU BioDB 2015
(added sql query for reference) |
(made the query able to be copied easily) |
||
| Line 1: | Line 1: | ||
| − | select propertytype.value from propertytype inner join dbreferencetype on | + | 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; | |
Revision as of 23:37, 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;