In [1]:
from om import base, settings
from om.data import *
from om.components import *
from IPython.display import HTML
from matplotlib import pylab as plt
from math import log
import pandas as pd
ome = base.Session()
genome_data = omics_database.genome_data
%matplotlib inline
/usr/local/Cellar/python/2.7.6/Frameworks/Python.framework/Versions/2.7/lib/python2.7/site-packages/pandas/io/excel.py:626: UserWarning: Installed openpyxl is not supported at this time. Use >=1.6.1 and <2.0.0.
.format(openpyxl_compat.start_ver, openpyxl_compat.stop_ver))
In [2]:
ome.query(DataSet).all()
Out[2]:
[ChIPExperiment (#1, ChIPExo-RpoD_wt_fructose_NH4Cl_O2_1_anti-rpod): ChIPExo RpoD 1,
ChIPExperiment (#2, ChIPExo-RpoD_wt_fructose_NH4Cl_O2_2_anti-rpod): ChIPExo RpoD 2,
ChIPExperiment (#3, ChIPExo-RpoD_wt_fructose_NH4Cl_O2_3_anti-rpod): ChIPExo RpoD 3,
ChIPExperiment (#4, ChIPExo-RpoD_wt_glucose_NH4Cl_O2_1_anti-rpod): ChIPExo RpoD 1,
ChIPExperiment (#5, ChIPExo-RpoD_wt_glucose_NH4Cl_O2_2_anti-rpod): ChIPExo RpoD 2,
ChIPExperiment (#6, ChIPExo-RpoD_wt_glycerol_NH4Cl_O2_1_anti-rpod): ChIPExo RpoD 1,
ChIPExperiment (#7, ChIPExo-RpoD_wt_glycerol_NH4Cl_O2_2_anti-rpod): ChIPExo RpoD 2,
ChIPExperiment (#8, ChIPExo-RpoD_wt_glycerol_NH4Cl_O2_3_anti-rpod): ChIPExo RpoD 3,
ChIPExperiment (#9, ChIPExo-ArcA_ArcA8myc_glucose_NH4Cl_anaerobic_2_anti-myc): ChIPExo ArcA 2,
ChIPExperiment (#10, ChIPExo-ArcA_ArcA8myc_glucose_NH4Cl_anaerobic_3_anti-myc): ChIPExo ArcA 3,
ChIPExperiment (#11, ChIPExo-Crp_Ar3_glycerol_NH4Cl_O2_1_anti-crp): ChIPExo Crp 1,
ChIPExperiment (#12, ChIPExo-Crp_Ar3_glycerol_NH4Cl_O2_2_anti-crp): ChIPExo Crp 2,
ChIPExperiment (#13, ChIPExo-Crp_Ar3_glycerol_NH4Cl_O2_3_anti-crp): ChIPExo Crp 3,
ChIPExperiment (#14, ChIPExo-Crp_Crp8myc_fructose_NH4Cl_O2_2_anti-crp): ChIPExo Crp 2,
ChIPExperiment (#15, ChIPExo-Crp_Crp8myc_fructose_NH4Cl_O2_3_anti-crp): ChIPExo Crp 3,
ChIPExperiment (#16, ChIPExo-Crp_Crp8myc_glucose_NH4Cl_O2_1_anti-myc): ChIPExo Crp 1,
ChIPExperiment (#17, ChIPExo-Crp_Crp8myc_glucose_NH4Cl_O2_2_anti-myc): ChIPExo Crp 2,
ChIPExperiment (#18, ChIPExo-Crp_Crp8myc_glycerol_NH4Cl_O2_1_anti-myc): ChIPExo Crp 1,
ChIPExperiment (#19, ChIPExo-Crp_Crp8myc_glycerol_NH4Cl_O2_2_anti-crp): ChIPExo Crp 2,
ChIPExperiment (#20, ChIPExo-Crp_Crp8myc_glycerol_NH4Cl_O2_2_anti-myc): ChIPExo Crp 2,
ChIPExperiment (#21, ChIPExo-Crp_Crp8myc_glycerol_NH4Cl_O2_3_anti-crp): ChIPExo Crp 3,
ChIPExperiment (#22, ChIPExo-Crp_delAr1_glycerol_NH4Cl_O2_1_anti-crp): ChIPExo Crp 1,
ChIPExperiment (#23, ChIPExo-Crp_delAr1_glycerol_NH4Cl_O2_2_anti-crp): ChIPExo Crp 2,
ChIPExperiment (#24, ChIPExo-Crp_delAr1_glycerol_NH4Cl_O2_3_anti-crp): ChIPExo Crp 3,
ChIPExperiment (#25, ChIPExo-Crp_delAr1delAr2_glycerol_NH4Cl_O2_1_anti-crp): ChIPExo Crp 1,
ChIPExperiment (#26, ChIPExo-Crp_delAr1delAr2_glycerol_NH4Cl_O2_2_anti-crp): ChIPExo Crp 2,
ChIPExperiment (#27, ChIPExo-Crp_delAr1delAr2_glycerol_NH4Cl_O2_3_anti-crp): ChIPExo Crp 3,
ChIPExperiment (#28, ChIPExo-Crp_delAr2_glycerol_NH4Cl_O2_1_anti-crp): ChIPExo Crp 1,
ChIPExperiment (#29, ChIPExo-Crp_delAr2_glycerol_NH4Cl_O2_2_anti-crp): ChIPExo Crp 2,
ChIPExperiment (#30, ChIPExo-Crp_delAr2_glycerol_NH4Cl_O2_3_anti-crp): ChIPExo Crp 3,
ChIPExperiment (#31, ChIPExo-Crp_delta-crp_glycerol_NH4Cl_O2_1_anti-crp): ChIPExo Crp 1,
ChIPExperiment (#32, ChIPExo-Crp_delta-crp_glycerol_NH4Cl_O2_2_anti-crp): ChIPExo Crp 2,
ChIPExperiment (#33, ChIPExo-Crp_delta-crp_glycerol_NH4Cl_O2_3_anti-crp): ChIPExo Crp 3,
ChIPExperiment (#34, ChIPExo-Crp_wt_fructose_NH4Cl_O2_1_anti-crp): ChIPExo Crp 1,
ChIPExperiment (#35, ChIPExo-Crp_wt_fructose_NH4Cl_O2_2_anti-crp): ChIPExo Crp 2,
ChIPExperiment (#36, ChIPExo-Crp_wt_fructose_NH4Cl_O2_3_anti-crp): ChIPExo Crp 3,
ChIPExperiment (#37, ChIPExo-Crp_wt_fructose_NH4Cl_O2_4_anti-crp): ChIPExo Crp 4,
ChIPExperiment (#38, ChIPExo-Crp_wt_fructose_NH4Cl_O2_5_anti-crp): ChIPExo Crp 5,
ChIPExperiment (#39, ChIPExo-Crp_wt_glucose_NH4Cl_O2_1_anti-crp): ChIPExo Crp 1,
ChIPExperiment (#40, ChIPExo-Crp_wt_glucose_NH4Cl_O2_2_anti-crp): ChIPExo Crp 2,
ChIPExperiment (#41, ChIPExo-Crp_wt_glycerol_NH4Cl_O2_1_anti-crp): ChIPExo Crp 1,
ChIPExperiment (#42, ChIPExo-Crp_wt_glycerol_NH4Cl_O2_1_anti-crp_rif): ChIPExo Crp 1,
ChIPExperiment (#43, ChIPExo-Crp_wt_glycerol_NH4Cl_O2_2_anti-crp): ChIPExo Crp 2,
ChIPExperiment (#44, ChIPExo-Crp_wt_glycerol_NH4Cl_O2_2_anti-crp_rif): ChIPExo Crp 2,
ChIPExperiment (#45, ChIPExo-Crp_wt_glycerol_NH4Cl_O2_3_anti-crp): ChIPExo Crp 3,
ChIPExperiment (#46, ChIPExo-Crp_wt_glycerol_NH4Cl_O2_3_anti-crp_rif): ChIPExo Crp 3,
ChIPExperiment (#47, ChIPExo-Crp_wt_glycerol_NH4Cl_O2_4_anti-crp): ChIPExo Crp 4,
ChIPExperiment (#48, ChIPExo-Crp_wt_glycerol_NH4Cl_O2_5_anti-crp): ChIPExo Crp 5,
ChIPExperiment (#49, ChIPExo-Crp_wt_glycerol_NH4Cl_O2_6_anti-crp): ChIPExo Crp 6,
ChIPExperiment (#50, ChIPExo-Fnr_Fnr8myc_glucose_NH4Cl_anaerobic_2_anti-myc): ChIPExo Fnr 2,
ChIPExperiment (#51, ChIPExo-Fnr_Fnr8myc_glucose_NH4Cl_anaerobic_3_anti-myc): ChIPExo Fnr 3,
ChIPExperiment (#52, ChIPExo-RpoA_wt_glucose_NH4Cl_O2_1_anti-rpoA): ChIPExo RpoA 1,
ChIPExperiment (#53, ChIPExo-RpoA_wt_glucose_NH4Cl_O2_2_anti-rpoA): ChIPExo RpoA 2,
ChIPExperiment (#54, ChIPExo-Fur_Fur8myc_glucose_NH4Cl_O2_1_anti-myc_dpd): ChIPExo Fur 1,
ChIPExperiment (#55, ChIPExo-Fur_Fur8myc_glucose_NH4Cl_O2_1_anti-myc_FeCl2): ChIPExo Fur 1,
ChIPExperiment (#56, ChIPExo-Fur_Fur8myc_glucose_NH4Cl_O2_2_anti-myc_dpd): ChIPExo Fur 2,
ChIPExperiment (#57, ChIPExo-Fur_Fur8myc_glucose_NH4Cl_O2_2_anti-myc_FeCl2): ChIPExo Fur 2,
ChIPExperiment (#58, ChIPExo-Nac_Nac8myc_glucose_cytidine_O2_1_anti-myc): ChIPExo Nac 1,
ChIPExperiment (#59, ChIPExo-Nac_Nac8myc_glucose_cytidine_O2_2_anti-myc): ChIPExo Nac 2,
ChIPExperiment (#60, ChIPExo-Nac_Nac8myc_glucose_cytosine_O2_1_anti-myc): ChIPExo Nac 1,
ChIPExperiment (#61, ChIPExo-Nac_Nac8myc_glucose_cytosine_O2_2_anti-myc): ChIPExo Nac 2,
ChIPExperiment (#62, ChIPExo-Nac_Nac8myc_glucose_glutamine_O2_1_anti-myc): ChIPExo Nac 1,
ChIPExperiment (#63, ChIPExo-Nac_Nac8myc_glucose_glutamine_O2_2_anti-myc): ChIPExo Nac 2,
ChIPExperiment (#64, ChIPExo-Nac_Nac8myc_glucose_NH4Cl_O2_1_anti-myc): ChIPExo Nac 1,
ChIPExperiment (#65, ChIPExo-Nac_Nac8myc_glucose_NH4Cl_O2_2_anti-myc): ChIPExo Nac 2,
ChIPExperiment (#66, ChIPExo-NtrC_NtrC8myc_glucose_cytidine_O2_1_anti-myc): ChIPExo NtrC 1,
ChIPExperiment (#67, ChIPExo-NtrC_NtrC8myc_glucose_cytidine_O2_2_anti-myc): ChIPExo NtrC 2,
ChIPExperiment (#68, ChIPExo-NtrC_NtrC8myc_glucose_cytosine_O2_1_anti-myc): ChIPExo NtrC 1,
ChIPExperiment (#69, ChIPExo-NtrC_NtrC8myc_glucose_cytosine_O2_2_anti-myc): ChIPExo NtrC 2,
ChIPExperiment (#70, ChIPExo-NtrC_NtrC8myc_glucose_glutamine_O2_1_anti-myc): ChIPExo NtrC 1,
ChIPExperiment (#71, ChIPExo-NtrC_NtrC8myc_glucose_glutamine_O2_2_anti-myc): ChIPExo NtrC 2,
ChIPExperiment (#72, ChIPExo-NtrC_NtrC8myc_glucose_NH4Cl_O2_1_anti-myc): ChIPExo NtrC 1,
ChIPExperiment (#73, ChIPExo-NtrC_NtrC8myc_glucose_NH4Cl_O2_2_anti-myc): ChIPExo NtrC 2,
ChIPExperiment (#74, ChIPExo-RpoD_wt_glucose_cytidine_O2_1_anti-rpod): ChIPExo RpoD 1,
ChIPExperiment (#75, ChIPExo-RpoD_wt_glucose_cytidine_O2_2_anti-rpod): ChIPExo RpoD 2,
ChIPExperiment (#76, ChIPExo-RpoD_wt_glucose_cytosine_O2_1_anti-rpod): ChIPExo RpoD 1,
ChIPExperiment (#77, ChIPExo-RpoD_wt_glucose_cytosine_O2_2_anti-rpod): ChIPExo RpoD 2,
ChIPExperiment (#78, ChIPExo-RpoD_wt_glucose_glutamine_O2_1_anti-rpod): ChIPExo RpoD 1,
ChIPExperiment (#79, ChIPExo-RpoD_wt_glucose_glutamine_O2_2_anti-rpod): ChIPExo RpoD 2,
ChIPExperiment (#80, ChIPExo-RpoD_wt_glucose_NH4Cl_O2_1_anti-rpod_nitrogenstudy): ChIPExo RpoD 1,
ChIPExperiment (#81, ChIPExo-RpoD_wt_glucose_NH4Cl_O2_2_anti-rpod_nitrogenstudy): ChIPExo RpoD 2,
ChIPExperiment (#82, ChIPExo-RpoN_wt_glucose_cytidine_O2_1_anti-rpon): ChIPExo RpoN 1,
ChIPExperiment (#83, ChIPExo-RpoN_wt_glucose_cytidine_O2_2_anti-rpon): ChIPExo RpoN 2,
ChIPExperiment (#84, ChIPExo-RpoN_wt_glucose_cytosine_O2_1_anti-rpon): ChIPExo RpoN 1,
ChIPExperiment (#85, ChIPExo-RpoN_wt_glucose_cytosine_O2_2_anti-rpon): ChIPExo RpoN 2,
ChIPExperiment (#86, ChIPExo-RpoN_wt_glucose_glutamine_O2_1_anti-rpon): ChIPExo RpoN 1,
ChIPExperiment (#87, ChIPExo-RpoN_wt_glucose_glutamine_O2_2_anti-rpon): ChIPExo RpoN 2,
ChIPExperiment (#88, ChIPExo-RpoN_wt_glucose_NH4Cl_O2_1_anti-rpon): ChIPExo RpoN 1,
ChIPExperiment (#89, ChIPExo-RpoN_wt_glucose_NH4Cl_O2_1_anti-rpon_nitrogenstudy): ChIPExo RpoN 1,
ChIPExperiment (#90, ChIPExo-RpoN_wt_glucose_NH4Cl_O2_2_anti-rpon): ChIPExo RpoN 2,
ChIPExperiment (#91, ChIPExo-RpoN_wt_glucose_NH4Cl_O2_2_anti-rpon_nitrogenstudy): ChIPExo RpoN 2,
ChIPExperiment (#92, ChIPExo-RpoS_wt_glucose_NH4Cl_O2_1_anti-rpos): ChIPExo RpoS 1,
ChIPExperiment (#93, ChIPExo-RpoS_wt_glucose_NH4Cl_O2_2_anti-rpos): ChIPExo RpoS 2,
RNASeqExperiment (#94, RNAseq_Ar3_glycerol_NH4Cl_O2_1): 1,
RNASeqExperiment (#95, RNAseq_Ar3_glycerol_NH4Cl_O2_2): 2,
RNASeqExperiment (#96, RNAseq_Ar3_glycerol_NH4Cl_O2_3): 3,
RNASeqExperiment (#97, RNAseq_delAr1_glycerol_NH4Cl_O2_1): 1,
RNASeqExperiment (#98, RNAseq_delAr1_glycerol_NH4Cl_O2_2): 2,
RNASeqExperiment (#99, RNAseq_delAr1_glycerol_NH4Cl_O2_3): 3,
RNASeqExperiment (#100, RNAseq_delAr1delAr2_glycerol_NH4Cl_O2_1): 1,
RNASeqExperiment (#101, RNAseq_delAr1delAr2_glycerol_NH4Cl_O2_2): 2,
RNASeqExperiment (#102, RNAseq_delAr1delAr2_glycerol_NH4Cl_O2_3): 3,
RNASeqExperiment (#103, RNAseq_delAr2_glycerol_NH4Cl_O2_1): 1,
RNASeqExperiment (#104, RNAseq_delAr2_glycerol_NH4Cl_O2_3): 3,
RNASeqExperiment (#105, RNAseq_delta-crp_fructose_NH4Cl_O2_1): 1,
RNASeqExperiment (#106, RNAseq_delta-crp_fructose_NH4Cl_O2_2): 2,
RNASeqExperiment (#107, RNAseq_delta-crp_fructose_NH4Cl_O2_3): 3,
RNASeqExperiment (#108, RNAseq_delta-crp_glucose_NH4Cl_O2_1): 1,
RNASeqExperiment (#109, RNAseq_delta-crp_glucose_NH4Cl_O2_2): 2,
RNASeqExperiment (#110, RNAseq_delta-crp_glucose_NH4Cl_O2_3): 3,
RNASeqExperiment (#111, RNAseq_delta-crp_glycerol_NH4Cl_O2_1): 1,
RNASeqExperiment (#112, RNAseq_delta-crp_glycerol_NH4Cl_O2_2): 2,
RNASeqExperiment (#113, RNAseq_delta-crp_glycerol_NH4Cl_O2_3): 3,
RNASeqExperiment (#114, RNAseq_wt_fructose_NH4Cl_O2_1): 1,
RNASeqExperiment (#115, RNAseq_wt_fructose_NH4Cl_O2_2): 2,
RNASeqExperiment (#116, RNAseq_wt_glucose_NH4Cl_O2_1): 1,
RNASeqExperiment (#117, RNAseq_wt_glucose_NH4Cl_O2_2): 2,
RNASeqExperiment (#118, RNAseq_wt_glycerol_NH4Cl_O2_1): 1,
RNASeqExperiment (#119, RNAseq_wt_glycerol_NH4Cl_O2_2): 2,
RNASeqExperiment (#120, RNAseq_delAr2_glycerol_NH4Cl_O2_2): 2,
RNASeqExperiment (#121, RNAseq_bw25113_acetate_NH4Cl_O2_1_thiamine): 1,
RNASeqExperiment (#122, RNAseq_bw25113_acetate_NH4Cl_O2_2_thiamine): 2,
RNASeqExperiment (#123, RNAseq_bw25113_fumarate_NH4Cl_O2_1_thiamine): 1,
RNASeqExperiment (#124, RNAseq_bw25113_fumarate_NH4Cl_O2_2_thiamine): 2,
RNASeqExperiment (#125, RNAseq_bw25113_glucose_NH4Cl_O2_1_thiamine): 1,
RNASeqExperiment (#126, RNAseq_bw25113_glucose_NH4Cl_O2_2_thiamine): 2,
RNASeqExperiment (#127, RNAseq_bw25113_pyruvate_NH4Cl_O2_1_thiamine): 1,
RNASeqExperiment (#128, RNAseq_bw25113_pyruvate_NH4Cl_O2_2_thiamine): 2,
RNASeqExperiment (#129, RNAseq_delta-fur_glucose_NH4Cl_O2_1_dpd): 1,
RNASeqExperiment (#130, RNAseq_delta-fur_glucose_NH4Cl_O2_1_FeCl2): 1,
RNASeqExperiment (#131, RNAseq_delta-fur_glucose_NH4Cl_O2_2_dpd): 2,
RNASeqExperiment (#132, RNAseq_delta-fur_glucose_NH4Cl_O2_2_FeCl2): 2,
RNASeqExperiment (#133, RNAseq_wt_glucose_cytidine_O2_1): 1,
RNASeqExperiment (#134, RNAseq_wt_glucose_cytidine_O2_2): 2,
RNASeqExperiment (#135, RNAseq_wt_glucose_cytosine_O2_1): 1,
RNASeqExperiment (#136, RNAseq_wt_glucose_cytosine_O2_2): 2,
RNASeqExperiment (#137, RNAseq_wt_glucose_glutamine_O2_1): 1,
RNASeqExperiment (#138, RNAseq_wt_glucose_glutamine_O2_2): 2,
RNASeqExperiment (#139, RNAseq_wt_glucose_NH4Cl_O2_1_dpd): 1,
RNASeqExperiment (#140, RNAseq_wt_glucose_NH4Cl_O2_1_FeCl2): 1,
RNASeqExperiment (#141, RNAseq_wt_glucose_NH4Cl_O2_2_dpd): 2,
RNASeqExperiment (#142, RNAseq_wt_glucose_NH4Cl_O2_2_FeCl2): 2,
RNASeqExperiment (#143, RNAseq_wt_glucose_NH4Cl_O2_3): 3,
RNASeqExperiment (#144, RNAseq_wt_glucose_NH4Cl_O2_4): 4,
Array Experiment (#145, affyexp_delta-arcA_glucose_NH4Cl_anaerobic_1_asv2): asv2 1,
Array Experiment (#146, affyexp_delta-arcA_glucose_NH4Cl_anaerobic_2_asv2): asv2 2,
Array Experiment (#147, affyexp_delta-arcA_glucose_NH4Cl_anaerobic_3_asv2): asv2 3,
Array Experiment (#148, affyexp_delta-arcA_glucose_NH4Cl_O2_1_asv2): asv2 1,
Array Experiment (#149, affyexp_delta-arcA_glucose_NH4Cl_O2_2_asv2): asv2 2,
Array Experiment (#150, affyexp_delta-arcA_glucose_NH4Cl_O2_3_asv2): asv2 3,
Array Experiment (#151, affyexp_delta-arcAfnr_glucose_NH4Cl_anaerobic_1_asv2): asv2 1,
Array Experiment (#152, affyexp_delta-arcAfnr_glucose_NH4Cl_anaerobic_2_asv2): asv2 2,
Array Experiment (#153, affyexp_delta-arcAfnr_glucose_NH4Cl_anaerobic_3_asv2): asv2 3,
Array Experiment (#154, affyexp_delta-arcAfnr_glucose_NH4Cl_O2_1_asv2): asv2 1,
Array Experiment (#155, affyexp_delta-arcAfnr_glucose_NH4Cl_O2_2_asv2): asv2 2,
Array Experiment (#156, affyexp_delta-arcAfnr_glucose_NH4Cl_O2_3_asv2): asv2 3,
Array Experiment (#157, affyexp_delta-fnr_glucose_NH4Cl_anaerobic_1_asv2): asv2 1,
Array Experiment (#158, affyexp_delta-fnr_glucose_NH4Cl_anaerobic_2_asv2): asv2 2,
Array Experiment (#159, affyexp_delta-fnr_glucose_NH4Cl_anaerobic_3_asv2): asv2 3,
Array Experiment (#160, affyexp_delta-fnr_glucose_NH4Cl_O2_1_asv2): asv2 1,
Array Experiment (#161, affyexp_delta-fnr_glucose_NH4Cl_O2_2_asv2): asv2 2,
Array Experiment (#162, affyexp_delta-fnr_glucose_NH4Cl_O2_3_asv2): asv2 3,
Array Experiment (#163, affyexp_delta-narL_glucose_NH4Cl_anaerobic_1_asv2): asv2 1,
Array Experiment (#164, affyexp_delta-narL_glucose_NH4Cl_anaerobic_2_asv2): asv2 2,
Array Experiment (#165, affyexp_delta-narL_glucose_NH4Cl_anaerobic_3_asv2): asv2 3,
Array Experiment (#166, affyexp_delta-narL_glucose_NH4Cl_NO3_1_asv2): asv2 1,
Array Experiment (#167, affyexp_delta-narL_glucose_NH4Cl_NO3_2_asv2): asv2 2,
Array Experiment (#168, affyexp_delta-narL_glucose_NH4Cl_NO3_3_asv2): asv2 3,
Array Experiment (#169, affyexp_delta-narLnarP_glucose_NH4Cl_anaerobic_1_asv2): asv2 1,
Array Experiment (#170, affyexp_delta-narLnarP_glucose_NH4Cl_anaerobic_2_asv2): asv2 2,
Array Experiment (#171, affyexp_delta-narLnarP_glucose_NH4Cl_anaerobic_3_asv2): asv2 3,
Array Experiment (#172, affyexp_delta-narLnarP_glucose_NH4Cl_NO3_1_asv2): asv2 1,
Array Experiment (#173, affyexp_delta-narLnarP_glucose_NH4Cl_NO3_2_asv2): asv2 2,
Array Experiment (#174, affyexp_delta-narLnarP_glucose_NH4Cl_NO3_3_asv2): asv2 3,
Array Experiment (#175, affyexp_delta-narP_glucose_NH4Cl_anaerobic_1_asv2): asv2 1,
Array Experiment (#176, affyexp_delta-narP_glucose_NH4Cl_anaerobic_2_asv2): asv2 2,
Array Experiment (#177, affyexp_delta-narP_glucose_NH4Cl_anaerobic_3_asv2): asv2 3,
Array Experiment (#178, affyexp_delta-narP_glucose_NH4Cl_NO3_2_asv2): asv2 2,
Array Experiment (#179, affyexp_delta-narP_glucose_NH4Cl_NO3_3_asv2): asv2 3,
Array Experiment (#180, affyexp_wt_glucose_NH4Cl_anaerobic_1_asv2): asv2 1,
Array Experiment (#181, affyexp_wt_glucose_NH4Cl_anaerobic_2_asv2): asv2 2,
Array Experiment (#182, affyexp_wt_glucose_NH4Cl_anaerobic_3_asv2): asv2 3,
Array Experiment (#183, affyexp_wt_glucose_NH4Cl_anaerobic_4_asv2): asv2 4,
Array Experiment (#184, affyexp_wt_glucose_NH4Cl_anaerobic_5_asv2): asv2 5,
Array Experiment (#185, affyexp_wt_glucose_NH4Cl_anaerobic_6_asv2): asv2 6,
Array Experiment (#186, affyexp_wt_glucose_NH4Cl_NO3_1_asv2): asv2 1,
Array Experiment (#187, affyexp_wt_glucose_NH4Cl_NO3_2_asv2): asv2 2,
Array Experiment (#188, affyexp_wt_glucose_NH4Cl_NO3_3_asv2): asv2 3,
Array Experiment (#189, affyexp_wt_glucose_NH4Cl_O2_1_asv2): asv2 1,
Array Experiment (#190, affyexp_wt_glucose_NH4Cl_O2_2_asv2): asv2 2,
Array Experiment (#191, affyexp_wt_glucose_NH4Cl_O2_3_asv2): asv2 3,
Array Experiment (#192, affyexp_delta-arcA_glucose_NH4Cl_NO3_1_ec2): ec2 1,
Array Experiment (#193, affyexp_delta-arcA_glucose_NH4Cl_NO3_2_ec2): ec2 2,
Array Experiment (#194, affyexp_delta-arcA_glucose_NH4Cl_NO3_3_ec2): ec2 3,
Array Experiment (#195, affyexp_delta-cra_acetate_NH4Cl_O2_1_ec2): ec2 1,
Array Experiment (#196, affyexp_delta-cra_acetate_NH4Cl_O2_2_ec2): ec2 2,
Array Experiment (#197, affyexp_delta-cra_acetate_NH4Cl_O2_3_ec2): ec2 3,
Array Experiment (#198, affyexp_delta-cra_glucose_NH4Cl_anaerobic_1_ec2): ec2 1,
Array Experiment (#199, affyexp_delta-cra_glucose_NH4Cl_anaerobic_2_ec2): ec2 2,
Array Experiment (#200, affyexp_delta-cra_glucose_NH4Cl_anaerobic_3_ec2): ec2 3,
Array Experiment (#201, affyexp_delta-cra_glucose_NH4Cl_O2_1_ec2): ec2 1,
Array Experiment (#202, affyexp_delta-cra_glucose_NH4Cl_O2_2_ec2): ec2 2,
Array Experiment (#203, affyexp_delta-cra_glucose_NH4Cl_O2_3_ec2): ec2 3,
Array Experiment (#204, affyexp_delta-crp_fructose_NH4Cl_O2_1_ec2): ec2 1,
Array Experiment (#205, affyexp_delta-crp_fructose_NH4Cl_O2_2_ec2): ec2 2,
Array Experiment (#206, affyexp_delta-crp_fructose_NH4Cl_O2_3_ec2): ec2 3,
Array Experiment (#207, affyexp_delta-crp_glucose_NH4Cl_O2_1_ec2): ec2 1,
Array Experiment (#208, affyexp_delta-crp_glucose_NH4Cl_O2_2_ec2): ec2 2,
Array Experiment (#209, affyexp_delta-crp_glucose_NH4Cl_O2_3_ec2): ec2 3,
Array Experiment (#210, affyexp_delta-fnr_glucose_NH4Cl_NO3_1_ec2): ec2 1,
Array Experiment (#211, affyexp_delta-fnr_glucose_NH4Cl_NO3_2_ec2): ec2 2,
Array Experiment (#212, affyexp_delta-fnr_glucose_NH4Cl_NO3_3_ec2): ec2 3,
Array Experiment (#213, affyexp_delta-lrp_glucose_leucine_O2_1_ec2): ec2 1,
Array Experiment (#214, affyexp_delta-lrp_glucose_leucine_O2_2_ec2): ec2 2,
Array Experiment (#215, affyexp_delta-lrp_glucose_leucine_O2_3_ec2): ec2 3,
Array Experiment (#216, affyexp_delta-lrp_glucose_NH4Cl_O2_1_ec2): ec2 1,
Array Experiment (#217, affyexp_delta-lrp_glucose_NH4Cl_O2_2_ec2): ec2 2,
Array Experiment (#218, affyexp_delta-lrp_glucose_NH4Cl_O2_3_ec2): ec2 3,
Array Experiment (#219, affyexp_delta-purR_glucose_adenine_O2_1_ec2): ec2 1,
Array Experiment (#220, affyexp_delta-purR_glucose_adenine_O2_2_ec2): ec2 2,
Array Experiment (#221, affyexp_delta-purR_glucose_NH4Cl_O2_1_ec2): ec2 1,
Array Experiment (#222, affyexp_delta-purR_glucose_NH4Cl_O2_2_ec2): ec2 2,
Array Experiment (#223, affyexp_wt_acetate_NH4Cl_O2_1_ec2): ec2 1,
Array Experiment (#224, affyexp_wt_acetate_NH4Cl_O2_2_ec2): ec2 2,
Array Experiment (#225, affyexp_wt_acetate_NH4Cl_O2_3_ec2): ec2 3,
Array Experiment (#226, affyexp_wt_fructose_NH4Cl_O2_1_ec2): ec2 1,
Array Experiment (#227, affyexp_wt_fructose_NH4Cl_O2_2_ec2): ec2 2,
Array Experiment (#228, affyexp_wt_fructose_NH4Cl_O2_3_ec2): ec2 3,
Array Experiment (#229, affyexp_wt_glucose_adenine_O2_1_ec2): ec2 1,
Array Experiment (#230, affyexp_wt_glucose_adenine_O2_2_ec2): ec2 2,
Array Experiment (#231, affyexp_wt_glucose_leucine_O2_1_ec2): ec2 1,
Array Experiment (#232, affyexp_wt_glucose_leucine_O2_2_ec2): ec2 2,
Array Experiment (#233, affyexp_wt_glucose_leucine_O2_3_ec2): ec2 3,
Array Experiment (#234, affyexp_wt_glucose_NH4Cl_anaerobic_1_ec2): ec2 1,
Array Experiment (#235, affyexp_wt_glucose_NH4Cl_anaerobic_2_ec2): ec2 2,
Array Experiment (#236, affyexp_wt_glucose_NH4Cl_anaerobic_3_ec2): ec2 3,
Array Experiment (#237, affyexp_wt_glucose_NH4Cl_NO3_1_ec2): ec2 1,
Array Experiment (#238, affyexp_wt_glucose_NH4Cl_NO3_2_ec2): ec2 2,
Array Experiment (#239, affyexp_wt_glucose_NH4Cl_NO3_3_ec2): ec2 3,
Array Experiment (#240, affyexp_wt_glucose_NH4Cl_O2_1_ec2): ec2 1,
Array Experiment (#241, affyexp_wt_glucose_NH4Cl_O2_2_ec2): ec2 2,
Array Experiment (#242, affyexp_wt_glucose_NH4Cl_O2_3_ec2): ec2 3,
Expression Data (#243): RNAseq_bw25113_fumarate_NH4Cl_O2_thiamine,
Expression Data (#244): RNAseq_delAr2_glycerol_NH4Cl_O2,
Expression Data (#245): RNAseq_wt_glucose_cytidine_O2,
Expression Data (#246): RNAseq_wt_glucose_glutamine_O2,
Expression Data (#247): RNAseq_wt_fructose_NH4Cl_O2,
Expression Data (#248): RNAseq_delAr1_glycerol_NH4Cl_O2,
Expression Data (#249): RNAseq_delta-crp_fructose_NH4Cl_O2,
Expression Data (#250): RNAseq_wt_glucose_NH4Cl_O2_FeCl2,
Expression Data (#251): RNAseq_delta-fur_glucose_NH4Cl_O2_dpd,
Expression Data (#252): RNAseq_wt_glucose_cytosine_O2,
Expression Data (#253): RNAseq_delAr1delAr2_glycerol_NH4Cl_O2,
Expression Data (#254): RNAseq_Ar3_glycerol_NH4Cl_O2,
Expression Data (#255): RNAseq_bw25113_glucose_NH4Cl_O2_thiamine,
Expression Data (#256): RNAseq_wt_glycerol_NH4Cl_O2,
Expression Data (#257): RNAseq_wt_glucose_NH4Cl_O2,
Expression Data (#258): RNAseq_delta-fur_glucose_NH4Cl_O2_FeCl2,
Expression Data (#259): RNAseq_bw25113_acetate_NH4Cl_O2_thiamine,
Expression Data (#260): RNAseq_wt_glucose_NH4Cl_O2_dpd,
Expression Data (#261): RNAseq_delta-crp_glycerol_NH4Cl_O2,
Expression Data (#262): RNAseq_bw25113_pyruvate_NH4Cl_O2_thiamine,
Expression Data (#263): RNAseq_delta-crp_glucose_NH4Cl_O2,
Expression Data (#264): affyexp_wt_glucose_NH4Cl_anaerobic,
Expression Data (#265): affyexp_wt_glucose_NH4Cl_O2,
Expression Data (#266): affyexp_wt_glucose_NH4Cl_NO3,
Expression Data (#267): affyexp_wt_acetate_NH4Cl_O2,
Expression Data (#268): affyexp_wt_fructose_NH4Cl_O2,
Expression Data (#269): affyexp_wt_glucose_leucine_O2,
Expression Data (#270): affyexp_wt_glucose_adenine_O2,
Expression Data (#271): affyexp_delta-crp_glucose_NH4Cl_O2,
Expression Data (#272): affyexp_delta-crp_fructose_NH4Cl_O2,
Expression Data (#273): affyexp_delta-arcA_glucose_NH4Cl_anaerobic,
Expression Data (#274): affyexp_delta-arcA_glucose_NH4Cl_O2,
Expression Data (#275): affyexp_delta-arcA_glucose_NH4Cl_NO3,
Expression Data (#276): affyexp_delta-arcAfnr_glucose_NH4Cl_anaerobic,
Expression Data (#277): affyexp_delta-arcAfnr_glucose_NH4Cl_O2,
Expression Data (#278): affyexp_delta-fnr_glucose_NH4Cl_anaerobic,
Expression Data (#279): affyexp_delta-fnr_glucose_NH4Cl_O2,
Expression Data (#280): affyexp_delta-fnr_glucose_NH4Cl_NO3,
Expression Data (#281): affyexp_delta-narL_glucose_NH4Cl_anaerobic,
Expression Data (#282): affyexp_delta-narL_glucose_NH4Cl_NO3,
Expression Data (#283): affyexp_delta-narLnarP_glucose_NH4Cl_anaerobic,
Expression Data (#284): affyexp_delta-narLnarP_glucose_NH4Cl_NO3,
Expression Data (#285): affyexp_delta-narP_glucose_NH4Cl_anaerobic,
Expression Data (#286): affyexp_delta-narP_glucose_NH4Cl_NO3,
Expression Data (#287): affyexp_delta-cra_acetate_NH4Cl_O2,
Expression Data (#288): affyexp_delta-cra_glucose_NH4Cl_anaerobic,
Expression Data (#289): affyexp_delta-cra_glucose_NH4Cl_O2,
Expression Data (#290): affyexp_delta-lrp_glucose_NH4Cl_O2,
Expression Data (#291): affyexp_delta-lrp_glucose_leucine_O2,
Expression Data (#292): affyexp_delta-purR_glucose_NH4Cl_O2,
Expression Data (#293): affyexp_delta-purR_glucose_adenine_O2,
ChIP Peak Analysis (#294, ChIPExo-Crp_wt_glucose_NH4Cl_O2_anti-crp_default_peaks): Environment: C:glucose, N:NH4Cl, e:O2 ,
ChIP Peak Analysis (#296, ChIPExo-Nac_Nac8myc_glucose_glutamine_O2_anti-myc_default_peaks): Environment: C:glucose, N:glutamine, e:O2 ,
ChIP Peak Analysis (#299, ChIPExo-Crp_wt_glycerol_NH4Cl_O2_anti-crp_default_peaks): Environment: C:glycerol, N:NH4Cl, e:O2 ,
ChIP Peak Analysis (#301, ChIPExo-ArcA_ArcA8myc_glucose_NH4Cl_anaerobic_anti-myc_default_peaks): Environment: C:glucose, N:NH4Cl, e:anaerobic ,
ChIP Peak Analysis (#304, ChIPExo-RpoD_wt_glycerol_NH4Cl_O2_anti-rpod_default_peaks): Environment: C:glycerol, N:NH4Cl, e:O2 ,
ChIP Peak Analysis (#305, ChIPExo-Crp_delAr2_glycerol_NH4Cl_O2_anti-crp_default_peaks): Environment: C:glycerol, N:NH4Cl, e:O2 ,
ChIP Peak Analysis (#306, ChIPExo-Crp_Ar3_glycerol_NH4Cl_O2_anti-crp_default_peaks): Environment: C:glycerol, N:NH4Cl, e:O2 ,
ChIP Peak Analysis (#307, ChIPExo-RpoD_wt_glucose_glutamine_O2_anti-rpod_default_peaks): Environment: C:glucose, N:glutamine, e:O2 ,
ChIP Peak Analysis (#309, ChIPExo-RpoN_wt_glucose_NH4Cl_O2_anti-rpon_default_peaks): Environment: C:glucose, N:NH4Cl, e:O2 ,
ChIP Peak Analysis (#311, ChIPExo-Crp_delta-crp_glycerol_NH4Cl_O2_anti-crp_default_peaks): Environment: C:glycerol, N:NH4Cl, e:O2 ,
ChIP Peak Analysis (#312, ChIPExo-Crp_delAr1_glycerol_NH4Cl_O2_anti-crp_default_peaks): Environment: C:glycerol, N:NH4Cl, e:O2 ,
ChIP Peak Analysis (#313, ChIPExo-RpoN_wt_glucose_cytidine_O2_anti-rpon_default_peaks): Environment: C:glucose, N:cytidine, e:O2 ,
ChIP Peak Analysis (#315, ChIPExo-Fnr_Fnr8myc_glucose_NH4Cl_anaerobic_anti-myc_default_peaks): Environment: C:glucose, N:NH4Cl, e:anaerobic ,
ChIP Peak Analysis (#317, ChIPExo-RpoA_wt_glucose_NH4Cl_O2_anti-rpoA_default_peaks): Environment: C:glucose, N:NH4Cl, e:O2 ,
ChIP Peak Analysis (#319, ChIPExo-Fur_Fur8myc_glucose_NH4Cl_O2_anti-myc_dpd_default_peaks): Environment: C:glucose, N:NH4Cl, e:O2 dpd,
ChIP Peak Analysis (#321, ChIPExo-RpoS_wt_glucose_NH4Cl_O2_anti-rpos_default_peaks): Environment: C:glucose, N:NH4Cl, e:O2 ,
ChIP Peak Analysis (#323, ChIPExo-RpoD_wt_glucose_cytosine_O2_anti-rpod_default_peaks): Environment: C:glucose, N:cytosine, e:O2 ,
ChIP Peak Analysis (#326, ChIPExo-NtrC_NtrC8myc_glucose_cytidine_O2_anti-myc_default_peaks): Environment: C:glucose, N:cytidine, e:O2 ,
ChIP Peak Analysis (#328, ChIPExo-Crp_Crp8myc_glucose_NH4Cl_O2_anti-myc_default_peaks): Environment: C:glucose, N:NH4Cl, e:O2 ,
ChIP Peak Analysis (#330, ChIPExo-Crp_delAr1delAr2_glycerol_NH4Cl_O2_anti-crp_default_peaks): Environment: C:glycerol, N:NH4Cl, e:O2 ,
ChIP Peak Analysis (#331, ChIPExo-RpoD_wt_glucose_NH4Cl_O2_anti-rpod_nitrogenstudy_default_peaks): Environment: C:glucose, N:NH4Cl, e:O2 nitrogenstudy,
ChIP Peak Analysis (#295, ChIPExo-RpoD_wt_glucose_cytidine_O2_anti-rpod_default_peaks): Environment: C:glucose, N:cytidine, e:O2 ,
ChIP Peak Analysis (#297, ChIPExo-Crp_wt_fructose_NH4Cl_O2_anti-crp_default_peaks): Environment: C:fructose, N:NH4Cl, e:O2 ,
ChIP Peak Analysis (#298, ChIPExo-Nac_Nac8myc_glucose_NH4Cl_O2_anti-myc_default_peaks): Environment: C:glucose, N:NH4Cl, e:O2 ,
ChIP Peak Analysis (#300, ChIPExo-NtrC_NtrC8myc_glucose_cytosine_O2_anti-myc_default_peaks): Environment: C:glucose, N:cytosine, e:O2 ,
ChIP Peak Analysis (#302, ChIPExo-RpoD_wt_fructose_NH4Cl_O2_anti-rpod_default_peaks): Environment: C:fructose, N:NH4Cl, e:O2 ,
ChIP Peak Analysis (#303, ChIPExo-RpoD_wt_glucose_NH4Cl_O2_anti-rpod_default_peaks): Environment: C:glucose, N:NH4Cl, e:O2 ,
ChIP Peak Analysis (#308, ChIPExo-Nac_Nac8myc_glucose_cytidine_O2_anti-myc_default_peaks): Environment: C:glucose, N:cytidine, e:O2 ,
ChIP Peak Analysis (#310, ChIPExo-RpoN_wt_glucose_glutamine_O2_anti-rpon_default_peaks): Environment: C:glucose, N:glutamine, e:O2 ,
ChIP Peak Analysis (#314, ChIPExo-Fur_Fur8myc_glucose_NH4Cl_O2_anti-myc_FeCl2_default_peaks): Environment: C:glucose, N:NH4Cl, e:O2 FeCl2,
ChIP Peak Analysis (#316, ChIPExo-NtrC_NtrC8myc_glucose_glutamine_O2_anti-myc_default_peaks): Environment: C:glucose, N:glutamine, e:O2 ,
ChIP Peak Analysis (#318, ChIPExo-Nac_Nac8myc_glucose_cytosine_O2_anti-myc_default_peaks): Environment: C:glucose, N:cytosine, e:O2 ,
ChIP Peak Analysis (#320, ChIPExo-NtrC_NtrC8myc_glucose_NH4Cl_O2_anti-myc_default_peaks): Environment: C:glucose, N:NH4Cl, e:O2 ,
ChIP Peak Analysis (#322, ChIPExo-Crp_Crp8myc_fructose_NH4Cl_O2_anti-crp_default_peaks): Environment: C:fructose, N:NH4Cl, e:O2 ,
ChIP Peak Analysis (#324, ChIPExo-Crp_wt_glycerol_NH4Cl_O2_anti-crp_rif_default_peaks): Environment: C:glycerol, N:NH4Cl, e:O2 rif,
ChIP Peak Analysis (#325, ChIPExo-Crp_Crp8myc_glycerol_NH4Cl_O2_anti-crp_default_peaks): Environment: C:glycerol, N:NH4Cl, e:O2 ,
ChIP Peak Analysis (#327, ChIPExo-RpoN_wt_glucose_NH4Cl_O2_anti-rpon_nitrogenstudy_default_peaks): Environment: C:glucose, N:NH4Cl, e:O2 nitrogenstudy,
ChIP Peak Analysis (#329, ChIPExo-RpoN_wt_glucose_cytosine_O2_anti-rpon_default_peaks): Environment: C:glucose, N:cytosine, e:O2 ,
ChIP Peak Analysis (#332, ChIPExo-Crp_Crp8myc_glycerol_NH4Cl_O2_anti-myc_default_peaks): Environment: C:glycerol, N:NH4Cl, e:O2 ,
Differential Expression (#333): RNAseq_bw25113_acetate/fumarate_NH4Cl_O2_thiamine,
Differential Expression (#334): RNAseq_wt_glucose_NH4Cl/cytidine_O2,
Differential Expression (#335): RNAseq_wt_glucose_cytidine/glutamine_O2,
Differential Expression (#336): RNAseq_wt_glucose_cytosine/glutamine_O2,
Differential Expression (#337): RNAseq_wt_glucose_NH4Cl/glutamine_O2,
Differential Expression (#338): RNAseq_delta-crp/wt_fructose_NH4Cl_O2,
Differential Expression (#339): RNAseq_wt_glucose_NH4Cl_O2_supp/FeCl2,
Differential Expression (#340): RNAseq_delta-fur/wt_glucose_NH4Cl_O2_FeCl2,
Differential Expression (#341): RNAseq_delta-fur_glucose_NH4Cl_O2_FeCl2/dpd,
Differential Expression (#342): RNAseq_wt_glucose_cytidine/cytosine_O2,
Differential Expression (#343): RNAseq_wt_glucose_NH4Cl/cytosine_O2,
Differential Expression (#344): RNAseq_bw25113_fumarate/glucose_NH4Cl_O2_thiamine,
Differential Expression (#345): RNAseq_bw25113_acetate/glucose_NH4Cl_O2_thiamine,
Differential Expression (#346): RNAseq_delAr2/wt_glycerol_NH4Cl_O2,
Differential Expression (#347): RNAseq_wt_fructose/glycerol_NH4Cl_O2,
Differential Expression (#348): RNAseq_delAr1/wt_glycerol_NH4Cl_O2,
Differential Expression (#349): RNAseq_delAr1delAr2/wt_glycerol_NH4Cl_O2,
Differential Expression (#350): RNAseq_Ar3/wt_glycerol_NH4Cl_O2,
Differential Expression (#351): RNAseq_wt_glucose/glycerol_NH4Cl_O2,
Differential Expression (#352): RNAseq_delta-crp/wt_glycerol_NH4Cl_O2,
Differential Expression (#353): RNAseq_wt_fructose/glucose_NH4Cl_O2,
Differential Expression (#354): RNAseq_delta-crp/wt_glucose_NH4Cl_O2,
Differential Expression (#355): RNAseq_wt_glucose_NH4Cl_O2_FeCl2/dpd,
Differential Expression (#356): RNAseq_delta-fur/wt_glucose_NH4Cl_O2_dpd,
Differential Expression (#357): RNAseq_wt_glucose_NH4Cl_O2_supp/dpd,
Differential Expression (#358): RNAseq_delta-crp_fructose/glycerol_NH4Cl_O2,
Differential Expression (#359): RNAseq_delta-crp_glucose/glycerol_NH4Cl_O2,
Differential Expression (#360): RNAseq_bw25113_fumarate/pyruvate_NH4Cl_O2_thiamine,
Differential Expression (#361): RNAseq_bw25113_glucose/pyruvate_NH4Cl_O2_thiamine,
Differential Expression (#362): RNAseq_bw25113_acetate/pyruvate_NH4Cl_O2_thiamine,
Differential Expression (#363): RNAseq_delta-crp_fructose/glucose_NH4Cl_O2]
In [3]:
ome.query(Gene).filter(Gene.name == 'sucA').one()
Out[3]:
Gene: (b0726, sucA) 757928-760730 (+)
In [4]:
ome.query(Gene).filter(Gene.name == 'sucA').one().data
Out[4]:
[Gene: (b0726, sucA) 757928-760730 (+): 2036.29 -- RNAseq_wt_glucose_NH4Cl_O2_1_FeCl2,
Gene: (b0726, sucA) 757928-760730 (+): 438.39 -- RNAseq_delta-fur_glucose_NH4Cl_O2_1_dpd,
Gene: (b0726, sucA) 757928-760730 (+): 581.44 -- RNAseq_wt_glucose_cytosine_O2_1,
Gene: (b0726, sucA) 757928-760730 (+): 558.48 -- RNAseq_bw25113_fumarate_NH4Cl_O2_2_thiamine,
Gene: (b0726, sucA) 757928-760730 (+): 505.57 -- RNAseq_delAr1delAr2_glycerol_NH4Cl_O2_1,
Gene: (b0726, sucA) 757928-760730 (+): 187.37 -- RNAseq_delAr2_glycerol_NH4Cl_O2_3,
Gene: (b0726, sucA) 757928-760730 (+): 177.62 -- RNAseq_delAr2_glycerol_NH4Cl_O2_1,
Gene: (b0726, sucA) 757928-760730 (+): 679.02 -- RNAseq_Ar3_glycerol_NH4Cl_O2_2,
Gene: (b0726, sucA) 757928-760730 (+): 606.66 -- RNAseq_bw25113_glucose_NH4Cl_O2_2_thiamine,
Gene: (b0726, sucA) 757928-760730 (+): 903.34 -- RNAseq_wt_glucose_cytidine_O2_1,
Gene: (b0726, sucA) 757928-760730 (+): 0.00 -- RNAseq_wt_glycerol_NH4Cl_O2_1,
Gene: (b0726, sucA) 757928-760730 (+): 363.30 -- RNAseq_wt_glucose_glutamine_O2_1,
Gene: (b0726, sucA) 757928-760730 (+): 1317.65 -- RNAseq_wt_fructose_NH4Cl_O2_2,
Gene: (b0726, sucA) 757928-760730 (+): 61.20 -- RNAseq_wt_glucose_NH4Cl_O2_2,
Gene: (b0726, sucA) 757928-760730 (+): 1021.08 -- RNAseq_wt_glucose_NH4Cl_O2_3,
Gene: (b0726, sucA) 757928-760730 (+): 1001.50 -- RNAseq_delta-fur_glucose_NH4Cl_O2_2_FeCl2,
Gene: (b0726, sucA) 757928-760730 (+): 2459.38 -- RNAseq_bw25113_acetate_NH4Cl_O2_2_thiamine,
Gene: (b0726, sucA) 757928-760730 (+): 422.37 -- RNAseq_wt_glucose_NH4Cl_O2_1_dpd,
Gene: (b0726, sucA) 757928-760730 (+): 274.30 -- RNAseq_delta-crp_glycerol_NH4Cl_O2_1,
Gene: (b0726, sucA) 757928-760730 (+): 251.18 -- RNAseq_delta-crp_glycerol_NH4Cl_O2_2,
Gene: (b0726, sucA) 757928-760730 (+): 1631.39 -- RNAseq_bw25113_pyruvate_NH4Cl_O2_2_thiamine,
Gene: (b0726, sucA) 757928-760730 (+): 862.22 -- RNAseq_delAr1_glycerol_NH4Cl_O2_1,
Gene: (b0726, sucA) 757928-760730 (+): 341.47 -- RNAseq_delta-crp_fructose_NH4Cl_O2_1,
Gene: (b0726, sucA) 757928-760730 (+): 317.56 -- RNAseq_delta-crp_fructose_NH4Cl_O2_3,
Gene: (b0726, sucA) 757928-760730 (+): 593.61 -- RNAseq_delta-crp_glucose_NH4Cl_O2_2,
Gene: (b0726, sucA) 757928-760730 (+): 1653.07 -- RNAseq_wt_glucose_NH4Cl_O2_2_FeCl2,
Gene: (b0726, sucA) 757928-760730 (+): 501.42 -- RNAseq_delta-fur_glucose_NH4Cl_O2_2_dpd,
Gene: (b0726, sucA) 757928-760730 (+): 547.11 -- RNAseq_wt_glucose_cytosine_O2_2,
Gene: (b0726, sucA) 757928-760730 (+): 1450.11 -- RNAseq_bw25113_fumarate_NH4Cl_O2_1_thiamine,
Gene: (b0726, sucA) 757928-760730 (+): 545.22 -- RNAseq_delAr1delAr2_glycerol_NH4Cl_O2_2,
Gene: (b0726, sucA) 757928-760730 (+): 524.24 -- RNAseq_delAr1delAr2_glycerol_NH4Cl_O2_3,
Gene: (b0726, sucA) 757928-760730 (+): 146.62 -- RNAseq_delAr2_glycerol_NH4Cl_O2_2,
Gene: (b0726, sucA) 757928-760730 (+): 557.93 -- RNAseq_Ar3_glycerol_NH4Cl_O2_3,
Gene: (b0726, sucA) 757928-760730 (+): 752.66 -- RNAseq_Ar3_glycerol_NH4Cl_O2_1,
Gene: (b0726, sucA) 757928-760730 (+): 515.82 -- RNAseq_bw25113_glucose_NH4Cl_O2_1_thiamine,
Gene: (b0726, sucA) 757928-760730 (+): 1216.93 -- RNAseq_wt_glucose_cytidine_O2_2,
Gene: (b0726, sucA) 757928-760730 (+): 1925.88 -- RNAseq_wt_glycerol_NH4Cl_O2_2,
Gene: (b0726, sucA) 757928-760730 (+): 623.57 -- RNAseq_wt_glucose_glutamine_O2_2,
Gene: (b0726, sucA) 757928-760730 (+): 2120.49 -- RNAseq_wt_fructose_NH4Cl_O2_1,
Gene: (b0726, sucA) 757928-760730 (+): 67.29 -- RNAseq_wt_glucose_NH4Cl_O2_1,
Gene: (b0726, sucA) 757928-760730 (+): 856.81 -- RNAseq_wt_glucose_NH4Cl_O2_4,
Gene: (b0726, sucA) 757928-760730 (+): 1111.03 -- RNAseq_delta-fur_glucose_NH4Cl_O2_1_FeCl2,
Gene: (b0726, sucA) 757928-760730 (+): 1718.76 -- RNAseq_bw25113_acetate_NH4Cl_O2_1_thiamine,
Gene: (b0726, sucA) 757928-760730 (+): 346.27 -- RNAseq_wt_glucose_NH4Cl_O2_2_dpd,
Gene: (b0726, sucA) 757928-760730 (+): 264.45 -- RNAseq_delta-crp_glycerol_NH4Cl_O2_3,
Gene: (b0726, sucA) 757928-760730 (+): 1393.81 -- RNAseq_bw25113_pyruvate_NH4Cl_O2_1_thiamine,
Gene: (b0726, sucA) 757928-760730 (+): 349.87 -- RNAseq_delAr1_glycerol_NH4Cl_O2_2,
Gene: (b0726, sucA) 757928-760730 (+): 424.07 -- RNAseq_delAr1_glycerol_NH4Cl_O2_3,
Gene: (b0726, sucA) 757928-760730 (+): 274.32 -- RNAseq_delta-crp_fructose_NH4Cl_O2_2,
Gene: (b0726, sucA) 757928-760730 (+): 400.17 -- RNAseq_delta-crp_glucose_NH4Cl_O2_3,
Gene: (b0726, sucA) 757928-760730 (+): 495.88 -- RNAseq_delta-crp_glucose_NH4Cl_O2_1,
Diff Exp Data: Gene: (b0726, sucA) 757928-760730 (+) -1.06 0.11 RNAseq_bw25113_acetate/fumarate_NH4Cl_O2_thiamine,
Diff Exp Data: Gene: (b0726, sucA) 757928-760730 (+) 1.08 0.15 RNAseq_wt_glucose_NH4Cl/cytidine_O2,
Diff Exp Data: Gene: (b0726, sucA) 757928-760730 (+) -1.10 0.12 RNAseq_wt_glucose_cytidine/glutamine_O2,
Diff Exp Data: Gene: (b0726, sucA) 757928-760730 (+) 2.47 0.00 RNAseq_delta-crp/wt_fructose_NH4Cl_O2,
Diff Exp Data: Gene: (b0726, sucA) 757928-760730 (+) 1.88 0.02 RNAseq_wt_glucose_NH4Cl_O2_supp/FeCl2,
Diff Exp Data: Gene: (b0726, sucA) 757928-760730 (+) -1.17 0.08 RNAseq_delta-fur_glucose_NH4Cl_O2_FeCl2/dpd,
Diff Exp Data: Gene: (b0726, sucA) 757928-760730 (+) -0.91 0.17 RNAseq_wt_glucose_cytidine/cytosine_O2,
Diff Exp Data: Gene: (b0726, sucA) 757928-760730 (+) -0.84 0.17 RNAseq_bw25113_fumarate/glucose_NH4Cl_O2_thiamine,
Diff Exp Data: Gene: (b0726, sucA) 757928-760730 (+) -1.90 0.00 RNAseq_bw25113_acetate/glucose_NH4Cl_O2_thiamine,
Diff Exp Data: Gene: (b0726, sucA) 757928-760730 (+) 2.50 0.00 RNAseq_delAr2/wt_glycerol_NH4Cl_O2,
Diff Exp Data: Gene: (b0726, sucA) 757928-760730 (+) 0.88 0.20 RNAseq_delAr1delAr2/wt_glycerol_NH4Cl_O2,
Diff Exp Data: Gene: (b0726, sucA) 757928-760730 (+) 1.87 0.02 RNAseq_delta-crp/wt_glycerol_NH4Cl_O2,
Diff Exp Data: Gene: (b0726, sucA) 757928-760730 (+) -1.78 0.03 RNAseq_wt_fructose/glucose_NH4Cl_O2,
Diff Exp Data: Gene: (b0726, sucA) 757928-760730 (+) -2.26 0.00 RNAseq_wt_glucose_NH4Cl_O2_FeCl2/dpd,
Diff Exp Data: Gene: (b0726, sucA) 757928-760730 (+) -0.92 0.09 RNAseq_delta-crp_glucose/glycerol_NH4Cl_O2,
Diff Exp Data: Gene: (b0726, sucA) 757928-760730 (+) 1.43 0.03 RNAseq_bw25113_glucose/pyruvate_NH4Cl_O2_thiamine,
Diff Exp Data: Gene: (b0726, sucA) 757928-760730 (+) 0.67 0.20 RNAseq_delta-crp_fructose/glucose_NH4Cl_O2,
Gene: (b0726, sucA) 757928-760730 (+): 13.70 -- affyexp_delta-arcA_glucose_NH4Cl_O2_2_asv2,
Gene: (b0726, sucA) 757928-760730 (+): 13.66 -- affyexp_delta-arcA_glucose_NH4Cl_anaerobic_1_asv2,
Gene: (b0726, sucA) 757928-760730 (+): 13.65 -- affyexp_delta-arcA_glucose_NH4Cl_anaerobic_3_asv2,
Gene: (b0726, sucA) 757928-760730 (+): 13.24 -- affyexp_delta-arcAfnr_glucose_NH4Cl_O2_2_asv2,
Gene: (b0726, sucA) 757928-760730 (+): 13.12 -- affyexp_delta-arcAfnr_glucose_NH4Cl_anaerobic_1_asv2,
Gene: (b0726, sucA) 757928-760730 (+): 13.26 -- affyexp_delta-arcAfnr_glucose_NH4Cl_anaerobic_3_asv2,
Gene: (b0726, sucA) 757928-760730 (+): 12.65 -- affyexp_delta-fnr_glucose_NH4Cl_O2_2_asv2,
Gene: (b0726, sucA) 757928-760730 (+): 8.92 -- affyexp_delta-fnr_glucose_NH4Cl_anaerobic_1_asv2,
Gene: (b0726, sucA) 757928-760730 (+): 10.30 -- affyexp_delta-fnr_glucose_NH4Cl_anaerobic_3_asv2,
Gene: (b0726, sucA) 757928-760730 (+): 8.57 -- affyexp_delta-narL_glucose_NH4Cl_anaerobic_2_asv2,
Gene: (b0726, sucA) 757928-760730 (+): 9.20 -- affyexp_delta-narL_glucose_NH4Cl_NO3_1_asv2,
Gene: (b0726, sucA) 757928-760730 (+): 9.12 -- affyexp_delta-narL_glucose_NH4Cl_NO3_3_asv2,
Gene: (b0726, sucA) 757928-760730 (+): 8.92 -- affyexp_delta-narLnarP_glucose_NH4Cl_anaerobic_2_asv2,
Gene: (b0726, sucA) 757928-760730 (+): 8.05 -- affyexp_delta-narLnarP_glucose_NH4Cl_NO3_1_asv2,
Gene: (b0726, sucA) 757928-760730 (+): 8.92 -- affyexp_delta-narLnarP_glucose_NH4Cl_NO3_3_asv2,
Gene: (b0726, sucA) 757928-760730 (+): 8.89 -- affyexp_delta-narP_glucose_NH4Cl_anaerobic_2_asv2,
Gene: (b0726, sucA) 757928-760730 (+): 9.44 -- affyexp_delta-narP_glucose_NH4Cl_NO3_2_asv2,
Gene: (b0726, sucA) 757928-760730 (+): 9.05 -- affyexp_wt_glucose_NH4Cl_NO3_1_asv2,
Gene: (b0726, sucA) 757928-760730 (+): 9.18 -- affyexp_wt_glucose_NH4Cl_NO3_3_asv2,
Gene: (b0726, sucA) 757928-760730 (+): 12.95 -- affyexp_wt_glucose_NH4Cl_O2_2_asv2,
Gene: (b0726, sucA) 757928-760730 (+): 13.40 -- affyexp_delta-arcA_glucose_NH4Cl_O2_1_asv2,
Gene: (b0726, sucA) 757928-760730 (+): 13.51 -- affyexp_delta-arcA_glucose_NH4Cl_O2_3_asv2,
Gene: (b0726, sucA) 757928-760730 (+): 13.70 -- affyexp_delta-arcA_glucose_NH4Cl_anaerobic_2_asv2,
Gene: (b0726, sucA) 757928-760730 (+): 13.26 -- affyexp_delta-arcAfnr_glucose_NH4Cl_O2_1_asv2,
Gene: (b0726, sucA) 757928-760730 (+): 13.19 -- affyexp_delta-arcAfnr_glucose_NH4Cl_O2_3_asv2,
Gene: (b0726, sucA) 757928-760730 (+): 13.47 -- affyexp_delta-arcAfnr_glucose_NH4Cl_anaerobic_2_asv2,
Gene: (b0726, sucA) 757928-760730 (+): 12.87 -- affyexp_delta-fnr_glucose_NH4Cl_O2_1_asv2,
Gene: (b0726, sucA) 757928-760730 (+): 12.82 -- affyexp_delta-fnr_glucose_NH4Cl_O2_3_asv2,
Gene: (b0726, sucA) 757928-760730 (+): 10.69 -- affyexp_delta-fnr_glucose_NH4Cl_anaerobic_2_asv2,
Gene: (b0726, sucA) 757928-760730 (+): 8.36 -- affyexp_delta-narL_glucose_NH4Cl_anaerobic_1_asv2,
Gene: (b0726, sucA) 757928-760730 (+): 8.54 -- affyexp_delta-narL_glucose_NH4Cl_anaerobic_3_asv2,
Gene: (b0726, sucA) 757928-760730 (+): 9.01 -- affyexp_delta-narL_glucose_NH4Cl_NO3_2_asv2,
Gene: (b0726, sucA) 757928-760730 (+): 8.62 -- affyexp_delta-narLnarP_glucose_NH4Cl_anaerobic_1_asv2,
Gene: (b0726, sucA) 757928-760730 (+): 8.54 -- affyexp_delta-narLnarP_glucose_NH4Cl_anaerobic_3_asv2,
Gene: (b0726, sucA) 757928-760730 (+): 8.41 -- affyexp_delta-narLnarP_glucose_NH4Cl_NO3_2_asv2,
Gene: (b0726, sucA) 757928-760730 (+): 8.92 -- affyexp_delta-narP_glucose_NH4Cl_anaerobic_1_asv2,
Gene: (b0726, sucA) 757928-760730 (+): 8.41 -- affyexp_delta-narP_glucose_NH4Cl_anaerobic_3_asv2,
Gene: (b0726, sucA) 757928-760730 (+): 9.15 -- affyexp_delta-narP_glucose_NH4Cl_NO3_3_asv2,
Gene: (b0726, sucA) 757928-760730 (+): 9.56 -- affyexp_wt_glucose_NH4Cl_NO3_2_asv2,
Gene: (b0726, sucA) 757928-760730 (+): 13.43 -- affyexp_wt_glucose_NH4Cl_O2_1_asv2,
Gene: (b0726, sucA) 757928-760730 (+): 13.12 -- affyexp_wt_glucose_NH4Cl_O2_3_asv2,
Gene: (b0726, sucA) 757928-760730 (+): 8.66 -- affyexp_wt_glucose_NH4Cl_anaerobic_1_asv2,
Gene: (b0726, sucA) 757928-760730 (+): 8.78 -- affyexp_wt_glucose_NH4Cl_anaerobic_3_asv2,
Gene: (b0726, sucA) 757928-760730 (+): 8.97 -- affyexp_wt_glucose_NH4Cl_anaerobic_5_asv2,
Gene: (b0726, sucA) 757928-760730 (+): 8.78 -- affyexp_wt_glucose_NH4Cl_anaerobic_2_asv2,
Gene: (b0726, sucA) 757928-760730 (+): 9.28 -- affyexp_wt_glucose_NH4Cl_anaerobic_4_asv2,
Gene: (b0726, sucA) 757928-760730 (+): 8.77 -- affyexp_wt_glucose_NH4Cl_anaerobic_6_asv2,
Gene: (b0726, sucA) 757928-760730 (+): 14.55 -- affyexp_delta-cra_acetate_NH4Cl_O2_2_ec2,
Gene: (b0726, sucA) 757928-760730 (+): 12.96 -- affyexp_delta-cra_glucose_NH4Cl_O2_1_ec2,
Gene: (b0726, sucA) 757928-760730 (+): 12.83 -- affyexp_delta-cra_glucose_NH4Cl_O2_3_ec2,
Gene: (b0726, sucA) 757928-760730 (+): 11.78 -- affyexp_delta-crp_fructose_NH4Cl_O2_2_ec2,
Gene: (b0726, sucA) 757928-760730 (+): 12.95 -- affyexp_delta-crp_glucose_NH4Cl_O2_1_ec2,
Gene: (b0726, sucA) 757928-760730 (+): 12.81 -- affyexp_delta-crp_glucose_NH4Cl_O2_3_ec2,
Gene: (b0726, sucA) 757928-760730 (+): 13.46 -- affyexp_delta-lrp_glucose_NH4Cl_O2_2_ec2,
Gene: (b0726, sucA) 757928-760730 (+): 13.24 -- affyexp_delta-lrp_glucose_leucine_O2_1_ec2,
Gene: (b0726, sucA) 757928-760730 (+): 13.14 -- affyexp_delta-lrp_glucose_leucine_O2_3_ec2,
Gene: (b0726, sucA) 757928-760730 (+): 12.43 -- affyexp_delta-purR_glucose_NH4Cl_O2_2_ec2,
Gene: (b0726, sucA) 757928-760730 (+): 10.71 -- affyexp_delta-purR_glucose_adenine_O2_2_ec2,
Gene: (b0726, sucA) 757928-760730 (+): 14.39 -- affyexp_wt_acetate_NH4Cl_O2_2_ec2,
Gene: (b0726, sucA) 757928-760730 (+): 13.69 -- affyexp_wt_fructose_NH4Cl_O2_1_ec2,
Gene: (b0726, sucA) 757928-760730 (+): 13.57 -- affyexp_wt_fructose_NH4Cl_O2_3_ec2,
Gene: (b0726, sucA) 757928-760730 (+): 13.28 -- affyexp_wt_glucose_NH4Cl_O2_2_ec2,
Gene: (b0726, sucA) 757928-760730 (+): 11.53 -- affyexp_wt_glucose_adenine_O2_2_ec2,
Gene: (b0726, sucA) 757928-760730 (+): 13.51 -- affyexp_wt_glucose_leucine_O2_2_ec2,
Gene: (b0726, sucA) 757928-760730 (+): 14.50 -- affyexp_delta-cra_acetate_NH4Cl_O2_1_ec2,
Gene: (b0726, sucA) 757928-760730 (+): 14.55 -- affyexp_delta-cra_acetate_NH4Cl_O2_3_ec2,
Gene: (b0726, sucA) 757928-760730 (+): 12.88 -- affyexp_delta-cra_glucose_NH4Cl_O2_2_ec2,
Gene: (b0726, sucA) 757928-760730 (+): 12.00 -- affyexp_delta-crp_fructose_NH4Cl_O2_1_ec2,
Gene: (b0726, sucA) 757928-760730 (+): 11.82 -- affyexp_delta-crp_fructose_NH4Cl_O2_3_ec2,
Gene: (b0726, sucA) 757928-760730 (+): 12.88 -- affyexp_delta-crp_glucose_NH4Cl_O2_2_ec2,
Gene: (b0726, sucA) 757928-760730 (+): 13.57 -- affyexp_delta-lrp_glucose_NH4Cl_O2_1_ec2,
Gene: (b0726, sucA) 757928-760730 (+): 13.44 -- affyexp_delta-lrp_glucose_NH4Cl_O2_3_ec2,
Gene: (b0726, sucA) 757928-760730 (+): 13.31 -- affyexp_delta-lrp_glucose_leucine_O2_2_ec2,
Gene: (b0726, sucA) 757928-760730 (+): 11.91 -- affyexp_delta-purR_glucose_NH4Cl_O2_1_ec2,
Gene: (b0726, sucA) 757928-760730 (+): 12.19 -- affyexp_delta-purR_glucose_adenine_O2_1_ec2,
Gene: (b0726, sucA) 757928-760730 (+): 14.38 -- affyexp_wt_acetate_NH4Cl_O2_1_ec2,
Gene: (b0726, sucA) 757928-760730 (+): 14.28 -- affyexp_wt_acetate_NH4Cl_O2_3_ec2,
Gene: (b0726, sucA) 757928-760730 (+): 13.76 -- affyexp_wt_fructose_NH4Cl_O2_2_ec2,
Gene: (b0726, sucA) 757928-760730 (+): 13.38 -- affyexp_wt_glucose_NH4Cl_O2_1_ec2,
Gene: (b0726, sucA) 757928-760730 (+): 11.20 -- affyexp_wt_glucose_adenine_O2_1_ec2,
Gene: (b0726, sucA) 757928-760730 (+): 13.53 -- affyexp_wt_glucose_leucine_O2_1_ec2,
Gene: (b0726, sucA) 757928-760730 (+): 13.58 -- affyexp_wt_glucose_leucine_O2_3_ec2]
In [5]:
ged = GeneExpressionData
dged = DifferentialGeneExpressionData
cpge = ChIPPeakGeneExpression
In [8]:
ome.query(ged).filter(and_(ged.gene_name == 'frdC',
ged.electron_acceptor == 'anaerobic')).all()
Out[8]:
[Gene: (b4152, frdC), Value: 4.63, std: 0.45, Condition: glucose, NH4Cl, anaerobic, Strain: wt, array_experiment,
Gene: (b4152, frdC), Value: 3.66, std: 0.66, Condition: glucose, NH4Cl, anaerobic, Strain: delta-arcA, array_experiment,
Gene: (b4152, frdC), Value: 2.58, std: 0.06, Condition: glucose, NH4Cl, anaerobic, Strain: delta-arcAfnr, array_experiment,
Gene: (b4152, frdC), Value: 2.36, std: 0.09, Condition: glucose, NH4Cl, anaerobic, Strain: delta-fnr, array_experiment,
Gene: (b4152, frdC), Value: 5.23, std: 0.28, Condition: glucose, NH4Cl, anaerobic, Strain: delta-narL, array_experiment,
Gene: (b4152, frdC), Value: 4.75, std: 0.21, Condition: glucose, NH4Cl, anaerobic, Strain: delta-narLnarP, array_experiment,
Gene: (b4152, frdC), Value: 5.11, std: 0.26, Condition: glucose, NH4Cl, anaerobic, Strain: delta-narP, array_experiment]
In [11]:
ome.query(dged).filter(and_(dged.gene_name == 'frdC')).all()
Out[11]:
[Gene: (b4152, frdC), bw25113, fumarate/acetate, NH4Cl, O2, Fold Change: 1.31, FDR: 0.05,
Gene: (b4152, frdC), wt/delta-fur, glucose, NH4Cl, O2, Fold Change: 1.08, FDR: 0.09,
Gene: (b4152, frdC), delta-fur, glucose, NH4Cl, O2, Fold Change: 1.63, FDR: 0.01,
Gene: (b4152, frdC), bw25113, fumarate/glucose, NH4Cl, O2, Fold Change: -2.70, FDR: 0.00,
Gene: (b4152, frdC), bw25113, glucose/acetate, NH4Cl, O2, Fold Change: -1.39, FDR: 0.03,
Gene: (b4152, frdC), delAr2/wt, glycerol, NH4Cl, O2, Fold Change: -3.47, FDR: 0.00,
Gene: (b4152, frdC), delAr1/wt, glycerol, NH4Cl, O2, Fold Change: -1.88, FDR: 0.01,
Gene: (b4152, frdC), Ar3/wt, glycerol, NH4Cl, O2, Fold Change: -1.97, FDR: 0.01,
Gene: (b4152, frdC), delta-crp, fructose/glycerol, NH4Cl, O2, Fold Change: -1.35, FDR: 0.02,
Gene: (b4152, frdC), delta-crp, glycerol/glucose, NH4Cl, O2, Fold Change: -1.51, FDR: 0.02,
Gene: (b4152, frdC), bw25113, fumarate/pyruvate, NH4Cl, O2, Fold Change: -1.50, FDR: 0.03,
Gene: (b4152, frdC), bw25113, glucose/pyruvate, NH4Cl, O2, Fold Change: 1.20, FDR: 0.06]
In [20]:
ome.query(cpge).filter(and_(cpge.gene_name.ilike('rpo%'))).all()
Out[20]:
[TF: Crp, Gene: rpoB, b3987, -1.10, 0.17 Condition: glycerol, NH4Cl, O2 Peak: 4187817-4188018 value:5568.00,
TF: Crp, Gene: rpoB, b3987, -1.01, 0.17 Condition: glycerol, NH4Cl, O2 Peak: 4187817-4188018 value:5568.00,
TF: Crp, Gene: rpoB, b3987, -1.10, 0.13 Condition: glycerol, NH4Cl, O2 Peak: 4187817-4188018 value:5568.00,
TF: Crp, Gene: rpoH, b3461, -0.90, 0.22 Condition: glycerol, NH4Cl, O2 Peak: 3598786-3598987 value:9612.90,
TF: Crp, Gene: rpoH, b3461, -0.90, 0.22 Condition: glycerol, NH4Cl, O2 Peak: 3598760-3598961 value:8663.10,
TF: Crp, Gene: rpoH, b3461, -1.73, 0.03 Condition: glycerol, NH4Cl, O2 Peak: 3598786-3598987 value:9612.90,
TF: Crp, Gene: rpoH, b3461, -1.73, 0.03 Condition: glycerol, NH4Cl, O2 Peak: 3598760-3598961 value:8663.10,
TF: Crp, Gene: rpoH, b3461, -0.94, 0.20 Condition: glycerol, NH4Cl, O2 Peak: 3598786-3598987 value:9612.90,
TF: Crp, Gene: rpoH, b3461, -0.94, 0.20 Condition: glycerol, NH4Cl, O2 Peak: 3598760-3598961 value:8663.10,
TF: Crp, Gene: rpoH, b3461, -1.31, 0.09 Condition: glycerol, NH4Cl, O2 Peak: 3598786-3598987 value:9612.90,
TF: Crp, Gene: rpoH, b3461, -1.31, 0.09 Condition: glycerol, NH4Cl, O2 Peak: 3598760-3598961 value:8663.10,
TF: Crp, Gene: rpoC, b3988, -1.33, 0.06 Condition: glycerol, NH4Cl, O2 Peak: 4187817-4188018 value:5568.00,
TF: Crp, Gene: rpoC, b3988, -0.88, 0.23 Condition: glycerol, NH4Cl, O2 Peak: 4187817-4188018 value:5568.00,
TF: Crp, Gene: rpoC, b3988, -1.15, 0.12 Condition: glycerol, NH4Cl, O2 Peak: 4187817-4188018 value:5568.00]
In [ ]:
Content source: steve-federowicz/om
Similar notebooks: