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/>.