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;