Skip to main content

Table 8 Transcriptomic Experiment Data Combination Query. Query 2. SeRQL comparison of wildtype samples and mutant samples for the gene with locus tag

From: Francisella tularensis novicida proteomic and transcriptomic data integration and annotation based on semantic web technologies

FTT 0551.
SELECT ftt, Source2, phase, x, Source1, phase2, v FROM
{ftt} ncbi:blastn {ftn},
{ftn} nwrce:OligoID {oligo},
{platform} soft:array_oligo_id {oligo},
{sample} mgla:SpotID {platform},
{sample} soft:sample_value {v},
{sampleID} soft:Sample_data_table_id {sample},
{sampleID} mgla:SampleSource {Source1},
{sampleID} mgla:SampleTimepoint_source {phase},
{sample2} mgla:SpotID {platform},
{sample2} soft:sample_value {x},
{sampleID2} soft:Sample_data_table_id {sample2},
{sampleID2} mgla:SampleSource {Source2},
{sampleID2} mgla:SampleTimepoint_source {phase2}
WHERE ftt = <http://www.genome.jp/dbget-bin/www_bget?ftu+FTT0551>
AND Source1 != Source2
AND Source1 = Mutant
AND phase = phase2
AND phase2 = 1st growth curve
USING namespace
mgla = <http://www.francisella.org/novicida/schema/fnu112/experiments/mgla/>,
soft = <http://www.ncbi.nlm.nih.gov/projects/geo/info/soft2.html#>,
nwrce = <https://tools.nwrce.org/geo/schema/<,
ncbi = <http://ncbi.nlm.nih.gov/>.