===Using SQL Queries to Validate the PostgreSQL Database Results from the TallyEngine===
===Using SQL Queries to Validate the PostgreSQL Database Results from the TallyEngine===
−
I ran a SQL query designed to count...:
+
We used the SQL "union" operation to count the number of "ordered locus" gene IDs, which conform to the pattern "BP####", in addition to all gene IDs that matched the patterns "BP####A" & "BP####B" (including 11 "ORF" gene IDs and 1 EnsemblBacteria reference ID):
−
[query goes here]
+
select count(value) from (select value from genenametype where type =
+
'ordered locus' union select 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)') as combined;