Difference between revisions of "Talk:Bklein7 Week 14"
From LMU BioDB 2015
(added further code) |
(fixed code formatting) |
||
| Line 8: | Line 8: | ||
and propertytype.value ~ 'BP[0-9][0-9][0-9][0-9](A|B)' order by propertytype.value; | and propertytype.value ~ 'BP[0-9][0-9][0-9][0-9](A|B)' order by propertytype.value; | ||
| − | # Bordetella pertussis | + | # Bordetella pertussis |
| − | bordetellapertussis_level_amount=1 | + | bordetellapertussis_level_amount=1 |
| − | + | ||
| − | bordetellapertussis_element_level0=uniprot/entry/gene/name&type&ORF | + | bordetellapertussis_element_level0=uniprot/entry/gene/name&type&ORF |
| − | + | ||
| − | bordetellapertussis_query_level0=select count(*) from genenametype where type = 'ORF'; | + | bordetellapertussis_query_level0=select count(*) from genenametype where type = 'ORF'; |
| − | + | ||
| − | bordetellapertussis_table_name_level0=ORF | + | bordetellapertussis_table_name_level0=ORF |
| − | + | ||
| − | # | + | # |
| − | # wizard.properties | + | # wizard.properties |
| − | # | + | # |
Revision as of 00:41, 14 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;
# Bordetella pertussis bordetellapertussis_level_amount=1 bordetellapertussis_element_level0=uniprot/entry/gene/name&type&ORF bordetellapertussis_query_level0=select count(*) from genenametype where type = 'ORF'; bordetellapertussis_table_name_level0=ORF # # wizard.properties #
