Connecting to the database


In [6]:
from ome import base,settings

In [7]:
base.engine


Out[7]:
Engine(postgresql://:@localhost:5432/ome)

In [8]:
settings.data_directory


Out[8]:
'/Users/sfederow/ome_data/'

In [9]:
session = base.Session()

session.query(base.Genome).all()


Out[9]:
[Genome (#1) PRJNA43747 Saccharomyces cerevisiae S288c,
 Genome (#26422) PRJNA57779 Escherichia coli str. K-12 substr. MG1655]

Querying components


In [10]:
from ome import components

#components.

Genes


In [11]:
session.query(components.Gene).filter_by(name = 'gapA').all()


Out[11]:
[Gene: (b1779, gapA) 1860794-1861790 (+)]

In [12]:
gapA = session.query(components.Gene).filter_by(name = 'gapA').one()

In [13]:
gapA.protein


Out[13]:
[Protein (#43313, enzyme; Energy metabolism, carbon: Glycolysis)]

In [14]:
gapA.groups


Out[14]:
[]

Proteins


In [10]:
from om.components import *

session.query(Protein).filter(Protein.long_name.ilike('groE%')).all()


Out[10]:
[Protein (#3904, GroEL, chaperone Hsp60, peptide-dependent ATPase, heat shock protein),
 Protein (#3903, GroES, chaperone binds to Hsp60 in pres. Mg-ATP, suppressing its ATPase activity)]

In [11]:
GroE = session.query(Protein).filter(Protein.long_name.ilike('groE%')).first()

In [12]:
GroE.gene


Out[12]:
Gene: (b4143, groL) 4369047-4370694 (+)

In [13]:
GroE.parent


Out[13]:
[Complex (#4700):  GroEL-GroES chaperonin complex]

In [15]:
GroE.parent[0].children


Out[15]:
[Protein (#3903, GroES, chaperone binds to Hsp60 in pres. Mg-ATP, suppressing its ATPase activity),
 Protein (#3904, GroEL, chaperone Hsp60, peptide-dependent ATPase, heat shock protein)]

In [16]:
PdhR = session.query(Protein).filter(Protein.long_name.ilike('PdhR%')).first()
PdhR.parent


Out[16]:
[Complex (#4894):  PdhR-pyruvate]

In [17]:
PdhR.parent[0].children


Out[17]:
[Protein (#108, PdhR DNA-binding transcriptional dual regulator)]

Complexes


In [18]:
session.query(Complex).limit(20).all()


Out[18]:
[Complex (#4146):  transcription termination factor Rho,
 Complex (#4147):  CcmCDE protoheme IX reservoir complex,
 Complex (#4148):  pyruvate dehydrogenase,
 Complex (#4149):  soluble NADH dehydrogenase fragment,
 Complex (#4150):  <i>N</i>-acetylneuraminate mutarotase,
 Complex (#4151):  fused diaminohydroxyphosphoribosylaminopyrimidine deaminase / 5-amino-6-(5-phosphoribosylamino)uracil reductase,
 Complex (#4152):  branched-chain amino-acid aminotransferase,
 Complex (#4153):  molybdate ABC transporter,
 Complex (#4154):  MazE-MazF antitoxin/toxin complex and DNA-binding transcriptional repressor,
 Complex (#4155):  MazF toxin of the MazF-MazE toxin-antitoxin system that exhibits ribonuclease activity,
 Complex (#4156):  MazE antitoxin of the MazF-MazE toxin-antitoxin system,
 Complex (#4157):  galactofuranose / galactopyranose ABC transporter,
 Complex (#4158):  fused glutathionylspermidine amidase / glutathionylspermidine synthetase,
 Complex (#4159):  aliphatic sulfonate ABC transporter,
 Complex (#4160):  AcrEF-TolC multidrug efflux transport system,
 Complex (#4161):  TolC outer membrane channel,
 Complex (#4162):  23S rRNA m<sup>3</sup>&Psi;1915 methyltransferase,
 Complex (#4163):  predicted rRNA methyltransferase,
 Complex (#4164):  HipAB toxin/antitoxin complex and DNA-binding transcriptional repressor,
 Complex (#4165):  HipB antitoxin and DNA-binding transcriptional repressor]

In [31]:
session.query(Complex).filter(Complex.long_name.ilike('HipAB%')).first().children


Out[31]:
[Protein (#1417, phosphorylated serine/threonine kinase HipA),
 Complex (#4165):  HipB antitoxin and DNA-binding transcriptional repressor]

Transcription Units


In [32]:
session.query(TU).limit(10).all()


Out[32]:
[TU (#10228, sdhCDAB-sucABCD),
 TU (#10229, rcsC),
 TU (#10230, znuCB),
 TU (#10231, yjeFE-amiB-mutL-miaA-hfq-hflXKC),
 TU (#10232, gsk),
 TU (#10233, guaC),
 TU (#10234, fsaA),
 TU (#10235, hdfR),
 TU (#10236, lpp),
 TU (#10237, pdhR-aceEF-lpdA)]

In [33]:
pdhR_aceEF_lpdA = session.query(TU).filter(TU.name.ilike('pdhR%')).first()

In [34]:
pdhR_aceEF_lpdA.genes


Out[34]:
[Gene: (b0113, pdhR) 122091-122856 (+),
 Gene: (b0114, aceE) 123016-125680 (+),
 Gene: (b0115, aceF) 125694-127587 (+),
 Gene: (b0116, lpd) 127911-129336 (+)]

In [35]:
pdhR_aceEF_lpdA.genome_region.leftpos


Out[35]:
122034

In [36]:
session.query(DnaBindingSite).limit(10).all()


Out[36]:
[DNA (#4966, BS0-2550) 786853-786853 +,
 DNA (#4967, BS0-1342) 3681627-3681627 +,
 DNA (#4968, BS00207) 4630726-4630726 +,
 DNA (#4969, BS0-8130) 1102827-1102827 +,
 DNA (#4970, BS0-8133) 2585498-2585514 +,
 DNA (#4971, BS0-8134) 2585468-2585480 +,
 DNA (#4972, BS0-8135) 2585435-2585453 +,
 DNA (#4973, BS0-8136) 2151929-2151943 +,
 DNA (#4974, BS0-8137) 3037213-3037213 +,
 DNA (#4975, BS0-8138) 3865415-3865431 +]

Components

  • Basically everything is a component

In [38]:
from sqlalchemy import func

session.query(func.distinct(components.Component.type)).all()


Out[38]:
[(u'complex'), (u'binding_site'), (u'tu'), (u'protein'), (u'component')]

In [39]:
session.query(Metabolite).all()


Out[39]:
[]

Querying data


In [40]:
from om import data

In [ ]:
data.

Datasets

  • Pretty much everything is a dataset.

  • Every dataset has a strain, an environment, a type, and a datasource.


In [41]:
session.query(data.DataSet).all()


Out[41]:
[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,
 ChIPExperiment (#94, ChIPchip-ArcA_ArcA8myc_glucose_NH4Cl_anaerobic_1_anti-myc): ChIPchip ArcA 1,
 ChIPExperiment (#95, ChIPchip-ArcA_ArcA8myc_glucose_NH4Cl_anaerobic_2_anti-myc): ChIPchip ArcA 2,
 ChIPExperiment (#96, ChIPchip-ArcA_ArcA8myc_glucose_NH4Cl_anaerobic_3_anti-myc): ChIPchip ArcA 3,
 ChIPExperiment (#97, ChIPchip-ArcA_ArcA8myc_glucose_NH4Cl_NO3_1_anti-myc): ChIPchip ArcA 1,
 ChIPExperiment (#98, ChIPchip-ArcA_ArcA8myc_glucose_NH4Cl_NO3_2_anti-myc): ChIPchip ArcA 2,
 ChIPExperiment (#99, ChIPchip-ArcA_ArcA8myc_glucose_NH4Cl_NO3_3_anti-myc): ChIPchip ArcA 3,
 ChIPExperiment (#100, ChIPchip-ArgR_ArgR8myc_glucose_NH4Cl_O2_1_anti-myc): ChIPchip ArgR 1,
 ChIPExperiment (#101, ChIPchip-ArgR_ArgR8myc_glucose_NH4Cl_O2_2_anti-myc): ChIPchip ArgR 2,
 ChIPExperiment (#102, ChIPchip-Cra_Cra8myc_acetate_NH4Cl_O2_1_anti-myc): ChIPchip Cra 1,
 ChIPExperiment (#103, ChIPchip-Cra_Cra8myc_acetate_NH4Cl_O2_2_anti-myc): ChIPchip Cra 2,
 ChIPExperiment (#104, ChIPchip-Cra_Cra8myc_acetate_NH4Cl_O2_3_anti-myc): ChIPchip Cra 3,
 ChIPExperiment (#105, ChIPchip-Cra_Cra8myc_glucose_NH4Cl_anaerobic_1_anti-myc): ChIPchip Cra 1,
 ChIPExperiment (#106, ChIPchip-Cra_Cra8myc_glucose_NH4Cl_anaerobic_2_anti-myc): ChIPchip Cra 2,
 ChIPExperiment (#107, ChIPchip-Cra_Cra8myc_glucose_NH4Cl_anaerobic_3_anti-myc): ChIPchip Cra 3,
 ChIPExperiment (#108, ChIPchip-Cra_Cra8myc_glucose_NH4Cl_O2_1_anti-myc): ChIPchip Cra 1,
 ChIPExperiment (#109, ChIPchip-Cra_Cra8myc_glucose_NH4Cl_O2_2_anti-myc): ChIPchip Cra 2,
 ChIPExperiment (#110, ChIPchip-Cra_Cra8myc_glucose_NH4Cl_O2_3_anti-myc): ChIPchip Cra 3,
 ChIPExperiment (#111, ChIPchip-Crp_Crp8myc_acetate_NH4Cl_O2_2_anti-myc): ChIPchip Crp 2,
 ChIPExperiment (#112, ChIPchip-Crp_Crp8myc_acetate_NH4Cl_O2_3_anti-myc): ChIPchip Crp 3,
 ChIPExperiment (#113, ChIPchip-Crp_Crp8myc_fructose_NH4Cl_O2_1_anti-myc): ChIPchip Crp 1,
 ChIPExperiment (#114, ChIPchip-Crp_Crp8myc_fructose_NH4Cl_O2_2_anti-myc): ChIPchip Crp 2,
 ChIPExperiment (#115, ChIPchip-Fnr_Fnr8myc_glucose_NH4Cl_anaerobic_1_anti-myc): ChIPchip Fnr 1,
 ChIPExperiment (#116, ChIPchip-Fnr_Fnr8myc_glucose_NH4Cl_anaerobic_2_anti-myc): ChIPchip Fnr 2,
 ChIPExperiment (#117, ChIPchip-Fnr_Fnr8myc_glucose_NH4Cl_anaerobic_3_anti-myc): ChIPchip Fnr 3,
 ChIPExperiment (#118, ChIPchip-Fnr_Fnr8myc_glucose_NH4Cl_NO3_1_anti-myc): ChIPchip Fnr 1,
 ChIPExperiment (#119, ChIPchip-Fnr_Fnr8myc_glucose_NH4Cl_NO3_2_anti-myc): ChIPchip Fnr 2,
 ChIPExperiment (#120, ChIPchip-Fnr_Fnr8myc_glucose_NH4Cl_NO3_3_anti-myc): ChIPchip Fnr 3,
 ChIPExperiment (#121, ChIPchip-Lrp_Lrp8myc_glucose_NH4Cl_O2_1_anti-myc): ChIPchip Lrp 1,
 ChIPExperiment (#122, ChIPchip-Lrp_Lrp8myc_glucose_NH4Cl_O2_2_anti-myc): ChIPchip Lrp 2,
 ChIPExperiment (#123, ChIPchip-Lrp_Lrp8myc_glucose_NH4Cl_O2_3_anti-myc): ChIPchip Lrp 3,
 ChIPExperiment (#124, ChIPchip-PurR_PurR8myc_glucose_NH4Cl_O2_1_anti-myc): ChIPchip PurR 1,
 ChIPExperiment (#125, ChIPchip-PurR_PurR8myc_glucose_NH4Cl_O2_2_anti-myc): ChIPchip PurR 2,
 RNASeqExperiment (#126, RNAseq_Ar3_glycerol_NH4Cl_O2_1):  1,
 RNASeqExperiment (#127, RNAseq_Ar3_glycerol_NH4Cl_O2_2):  2,
 RNASeqExperiment (#128, RNAseq_Ar3_glycerol_NH4Cl_O2_3):  3,
 RNASeqExperiment (#129, RNAseq_delAr1_glycerol_NH4Cl_O2_1):  1,
 RNASeqExperiment (#130, RNAseq_delAr1_glycerol_NH4Cl_O2_2):  2,
 RNASeqExperiment (#131, RNAseq_delAr1_glycerol_NH4Cl_O2_3):  3,
 RNASeqExperiment (#132, RNAseq_delAr1delAr2_glycerol_NH4Cl_O2_1):  1,
 RNASeqExperiment (#133, RNAseq_delAr1delAr2_glycerol_NH4Cl_O2_2):  2,
 RNASeqExperiment (#134, RNAseq_delAr1delAr2_glycerol_NH4Cl_O2_3):  3,
 RNASeqExperiment (#135, RNAseq_delAr2_glycerol_NH4Cl_O2_1):  1,
 RNASeqExperiment (#136, RNAseq_delAr2_glycerol_NH4Cl_O2_3):  3,
 RNASeqExperiment (#137, RNAseq_delta-crp_fructose_NH4Cl_O2_1):  1,
 RNASeqExperiment (#138, RNAseq_delta-crp_fructose_NH4Cl_O2_2):  2,
 RNASeqExperiment (#139, RNAseq_delta-crp_fructose_NH4Cl_O2_3):  3,
 RNASeqExperiment (#140, RNAseq_delta-crp_glucose_NH4Cl_O2_1):  1,
 RNASeqExperiment (#141, RNAseq_delta-crp_glucose_NH4Cl_O2_2):  2,
 RNASeqExperiment (#142, RNAseq_delta-crp_glucose_NH4Cl_O2_3):  3,
 RNASeqExperiment (#143, RNAseq_delta-crp_glycerol_NH4Cl_O2_1):  1,
 RNASeqExperiment (#144, RNAseq_delta-crp_glycerol_NH4Cl_O2_2):  2,
 RNASeqExperiment (#145, RNAseq_delta-crp_glycerol_NH4Cl_O2_3):  3,
 RNASeqExperiment (#146, RNAseq_wt_fructose_NH4Cl_O2_1):  1,
 RNASeqExperiment (#147, RNAseq_wt_fructose_NH4Cl_O2_2):  2,
 RNASeqExperiment (#148, RNAseq_wt_glucose_NH4Cl_O2_1):  1,
 RNASeqExperiment (#149, RNAseq_wt_glucose_NH4Cl_O2_2):  2,
 RNASeqExperiment (#150, RNAseq_wt_glycerol_NH4Cl_O2_1):  1,
 RNASeqExperiment (#151, RNAseq_wt_glycerol_NH4Cl_O2_2):  2,
 RNASeqExperiment (#152, RNAseq_delAr2_glycerol_NH4Cl_O2_2):  2,
 RNASeqExperiment (#153, RNAseq_bw25113_acetate_NH4Cl_O2_1_thiamine):  1,
 RNASeqExperiment (#154, RNAseq_bw25113_acetate_NH4Cl_O2_2_thiamine):  2,
 RNASeqExperiment (#155, RNAseq_bw25113_fumarate_NH4Cl_O2_1_thiamine):  1,
 RNASeqExperiment (#156, RNAseq_bw25113_fumarate_NH4Cl_O2_2_thiamine):  2,
 RNASeqExperiment (#157, RNAseq_bw25113_glucose_NH4Cl_O2_1_thiamine):  1,
 RNASeqExperiment (#158, RNAseq_bw25113_glucose_NH4Cl_O2_2_thiamine):  2,
 RNASeqExperiment (#159, RNAseq_bw25113_pyruvate_NH4Cl_O2_1_thiamine):  1,
 RNASeqExperiment (#160, RNAseq_bw25113_pyruvate_NH4Cl_O2_2_thiamine):  2,
 RNASeqExperiment (#161, RNAseq_delta-fur_glucose_NH4Cl_O2_1_dpd):  1,
 RNASeqExperiment (#162, RNAseq_delta-fur_glucose_NH4Cl_O2_1_FeCl2):  1,
 RNASeqExperiment (#163, RNAseq_delta-fur_glucose_NH4Cl_O2_2_dpd):  2,
 RNASeqExperiment (#164, RNAseq_delta-fur_glucose_NH4Cl_O2_2_FeCl2):  2,
 RNASeqExperiment (#165, RNAseq_wt_glucose_cytidine_O2_1):  1,
 RNASeqExperiment (#166, RNAseq_wt_glucose_cytidine_O2_2):  2,
 RNASeqExperiment (#167, RNAseq_wt_glucose_cytosine_O2_1):  1,
 RNASeqExperiment (#168, RNAseq_wt_glucose_cytosine_O2_2):  2,
 RNASeqExperiment (#169, RNAseq_wt_glucose_glutamine_O2_1):  1,
 RNASeqExperiment (#170, RNAseq_wt_glucose_glutamine_O2_2):  2,
 RNASeqExperiment (#171, RNAseq_wt_glucose_NH4Cl_O2_1_dpd):  1,
 RNASeqExperiment (#172, RNAseq_wt_glucose_NH4Cl_O2_1_FeCl2):  1,
 RNASeqExperiment (#173, RNAseq_wt_glucose_NH4Cl_O2_2_dpd):  2,
 RNASeqExperiment (#174, RNAseq_wt_glucose_NH4Cl_O2_2_FeCl2):  2,
 RNASeqExperiment (#175, RNAseq_wt_glucose_NH4Cl_O2_3):  3,
 RNASeqExperiment (#176, RNAseq_wt_glucose_NH4Cl_O2_4):  4,
 Array Experiment (#177, affyexp_delta-arcA_glucose_NH4Cl_anaerobic_1_asv2):  asv2  1,
 Array Experiment (#178, affyexp_delta-arcA_glucose_NH4Cl_anaerobic_2_asv2):  asv2  2,
 Array Experiment (#179, affyexp_delta-arcA_glucose_NH4Cl_anaerobic_3_asv2):  asv2  3,
 Array Experiment (#180, affyexp_delta-arcA_glucose_NH4Cl_O2_1_asv2):  asv2  1,
 Array Experiment (#181, affyexp_delta-arcA_glucose_NH4Cl_O2_2_asv2):  asv2  2,
 Array Experiment (#182, affyexp_delta-arcA_glucose_NH4Cl_O2_3_asv2):  asv2  3,
 Array Experiment (#183, affyexp_delta-arcAfnr_glucose_NH4Cl_anaerobic_1_asv2):  asv2  1,
 Array Experiment (#184, affyexp_delta-arcAfnr_glucose_NH4Cl_anaerobic_2_asv2):  asv2  2,
 Array Experiment (#185, affyexp_delta-arcAfnr_glucose_NH4Cl_anaerobic_3_asv2):  asv2  3,
 Array Experiment (#186, affyexp_delta-arcAfnr_glucose_NH4Cl_O2_1_asv2):  asv2  1,
 Array Experiment (#187, affyexp_delta-arcAfnr_glucose_NH4Cl_O2_2_asv2):  asv2  2,
 Array Experiment (#188, affyexp_delta-arcAfnr_glucose_NH4Cl_O2_3_asv2):  asv2  3,
 Array Experiment (#189, affyexp_delta-fnr_glucose_NH4Cl_anaerobic_1_asv2):  asv2  1,
 Array Experiment (#190, affyexp_delta-fnr_glucose_NH4Cl_anaerobic_2_asv2):  asv2  2,
 Array Experiment (#191, affyexp_delta-fnr_glucose_NH4Cl_anaerobic_3_asv2):  asv2  3,
 Array Experiment (#192, affyexp_delta-fnr_glucose_NH4Cl_O2_1_asv2):  asv2  1,
 Array Experiment (#193, affyexp_delta-fnr_glucose_NH4Cl_O2_2_asv2):  asv2  2,
 Array Experiment (#194, affyexp_delta-fnr_glucose_NH4Cl_O2_3_asv2):  asv2  3,
 Array Experiment (#195, affyexp_delta-narL_glucose_NH4Cl_anaerobic_1_asv2):  asv2  1,
 Array Experiment (#196, affyexp_delta-narL_glucose_NH4Cl_anaerobic_2_asv2):  asv2  2,
 Array Experiment (#197, affyexp_delta-narL_glucose_NH4Cl_anaerobic_3_asv2):  asv2  3,
 Array Experiment (#198, affyexp_delta-narL_glucose_NH4Cl_NO3_1_asv2):  asv2  1,
 Array Experiment (#199, affyexp_delta-narL_glucose_NH4Cl_NO3_2_asv2):  asv2  2,
 Array Experiment (#200, affyexp_delta-narL_glucose_NH4Cl_NO3_3_asv2):  asv2  3,
 Array Experiment (#201, affyexp_delta-narLnarP_glucose_NH4Cl_anaerobic_1_asv2):  asv2  1,
 Array Experiment (#202, affyexp_delta-narLnarP_glucose_NH4Cl_anaerobic_2_asv2):  asv2  2,
 Array Experiment (#203, affyexp_delta-narLnarP_glucose_NH4Cl_anaerobic_3_asv2):  asv2  3,
 Array Experiment (#204, affyexp_delta-narLnarP_glucose_NH4Cl_NO3_1_asv2):  asv2  1,
 Array Experiment (#205, affyexp_delta-narLnarP_glucose_NH4Cl_NO3_2_asv2):  asv2  2,
 Array Experiment (#206, affyexp_delta-narLnarP_glucose_NH4Cl_NO3_3_asv2):  asv2  3,
 Array Experiment (#207, affyexp_delta-narP_glucose_NH4Cl_anaerobic_1_asv2):  asv2  1,
 Array Experiment (#208, affyexp_delta-narP_glucose_NH4Cl_anaerobic_2_asv2):  asv2  2,
 Array Experiment (#209, affyexp_delta-narP_glucose_NH4Cl_anaerobic_3_asv2):  asv2  3,
 Array Experiment (#210, affyexp_delta-narP_glucose_NH4Cl_NO3_2_asv2):  asv2  2,
 Array Experiment (#211, affyexp_delta-narP_glucose_NH4Cl_NO3_3_asv2):  asv2  3,
 Array Experiment (#212, affyexp_wt_glucose_NH4Cl_anaerobic_1_asv2):  asv2  1,
 Array Experiment (#213, affyexp_wt_glucose_NH4Cl_anaerobic_2_asv2):  asv2  2,
 Array Experiment (#214, affyexp_wt_glucose_NH4Cl_anaerobic_3_asv2):  asv2  3,
 Array Experiment (#215, affyexp_wt_glucose_NH4Cl_anaerobic_4_asv2):  asv2  4,
 Array Experiment (#216, affyexp_wt_glucose_NH4Cl_anaerobic_5_asv2):  asv2  5,
 Array Experiment (#217, affyexp_wt_glucose_NH4Cl_anaerobic_6_asv2):  asv2  6,
 Array Experiment (#218, affyexp_wt_glucose_NH4Cl_NO3_1_asv2):  asv2  1,
 Array Experiment (#219, affyexp_wt_glucose_NH4Cl_NO3_2_asv2):  asv2  2,
 Array Experiment (#220, affyexp_wt_glucose_NH4Cl_NO3_3_asv2):  asv2  3,
 Array Experiment (#221, affyexp_wt_glucose_NH4Cl_O2_1_asv2):  asv2  1,
 Array Experiment (#222, affyexp_wt_glucose_NH4Cl_O2_2_asv2):  asv2  2,
 Array Experiment (#223, affyexp_wt_glucose_NH4Cl_O2_3_asv2):  asv2  3,
 Array Experiment (#224, affyexp_delta-arcA_glucose_NH4Cl_NO3_1_ec2):  ec2  1,
 Array Experiment (#225, affyexp_delta-arcA_glucose_NH4Cl_NO3_2_ec2):  ec2  2,
 Array Experiment (#226, affyexp_delta-arcA_glucose_NH4Cl_NO3_3_ec2):  ec2  3,
 Array Experiment (#227, affyexp_delta-cra_acetate_NH4Cl_O2_1_ec2):  ec2  1,
 Array Experiment (#228, affyexp_delta-cra_acetate_NH4Cl_O2_2_ec2):  ec2  2,
 Array Experiment (#229, affyexp_delta-cra_acetate_NH4Cl_O2_3_ec2):  ec2  3,
 Array Experiment (#230, affyexp_delta-cra_glucose_NH4Cl_anaerobic_1_ec2):  ec2  1,
 Array Experiment (#231, affyexp_delta-cra_glucose_NH4Cl_anaerobic_2_ec2):  ec2  2,
 Array Experiment (#232, affyexp_delta-cra_glucose_NH4Cl_anaerobic_3_ec2):  ec2  3,
 Array Experiment (#233, affyexp_delta-cra_glucose_NH4Cl_O2_1_ec2):  ec2  1,
 Array Experiment (#234, affyexp_delta-cra_glucose_NH4Cl_O2_2_ec2):  ec2  2,
 Array Experiment (#235, affyexp_delta-cra_glucose_NH4Cl_O2_3_ec2):  ec2  3,
 Array Experiment (#236, affyexp_delta-crp_fructose_NH4Cl_O2_1_ec2):  ec2  1,
 Array Experiment (#237, affyexp_delta-crp_fructose_NH4Cl_O2_2_ec2):  ec2  2,
 Array Experiment (#238, affyexp_delta-crp_fructose_NH4Cl_O2_3_ec2):  ec2  3,
 Array Experiment (#239, affyexp_delta-crp_glucose_NH4Cl_O2_1_ec2):  ec2  1,
 Array Experiment (#240, affyexp_delta-crp_glucose_NH4Cl_O2_2_ec2):  ec2  2,
 Array Experiment (#241, affyexp_delta-crp_glucose_NH4Cl_O2_3_ec2):  ec2  3,
 Array Experiment (#242, affyexp_delta-fnr_glucose_NH4Cl_NO3_1_ec2):  ec2  1,
 Array Experiment (#243, affyexp_delta-fnr_glucose_NH4Cl_NO3_2_ec2):  ec2  2,
 Array Experiment (#244, affyexp_delta-fnr_glucose_NH4Cl_NO3_3_ec2):  ec2  3,
 Array Experiment (#245, affyexp_delta-lrp_glucose_leucine_O2_1_ec2):  ec2  1,
 Array Experiment (#246, affyexp_delta-lrp_glucose_leucine_O2_2_ec2):  ec2  2,
 Array Experiment (#247, affyexp_delta-lrp_glucose_leucine_O2_3_ec2):  ec2  3,
 Array Experiment (#248, affyexp_delta-lrp_glucose_NH4Cl_O2_1_ec2):  ec2  1,
 Array Experiment (#249, affyexp_delta-lrp_glucose_NH4Cl_O2_2_ec2):  ec2  2,
 Array Experiment (#250, affyexp_delta-lrp_glucose_NH4Cl_O2_3_ec2):  ec2  3,
 Array Experiment (#251, affyexp_delta-purR_glucose_adenine_O2_1_ec2):  ec2  1,
 Array Experiment (#252, affyexp_delta-purR_glucose_adenine_O2_2_ec2):  ec2  2,
 Array Experiment (#253, affyexp_delta-purR_glucose_NH4Cl_O2_1_ec2):  ec2  1,
 Array Experiment (#254, affyexp_delta-purR_glucose_NH4Cl_O2_2_ec2):  ec2  2,
 Array Experiment (#255, affyexp_wt_acetate_NH4Cl_O2_1_ec2):  ec2  1,
 Array Experiment (#256, affyexp_wt_acetate_NH4Cl_O2_2_ec2):  ec2  2,
 Array Experiment (#257, affyexp_wt_acetate_NH4Cl_O2_3_ec2):  ec2  3,
 Array Experiment (#258, affyexp_wt_fructose_NH4Cl_O2_1_ec2):  ec2  1,
 Array Experiment (#259, affyexp_wt_fructose_NH4Cl_O2_2_ec2):  ec2  2,
 Array Experiment (#260, affyexp_wt_fructose_NH4Cl_O2_3_ec2):  ec2  3,
 Array Experiment (#261, affyexp_wt_glucose_adenine_O2_1_ec2):  ec2  1,
 Array Experiment (#262, affyexp_wt_glucose_adenine_O2_2_ec2):  ec2  2,
 Array Experiment (#263, affyexp_wt_glucose_leucine_O2_1_ec2):  ec2  1,
 Array Experiment (#264, affyexp_wt_glucose_leucine_O2_2_ec2):  ec2  2,
 Array Experiment (#265, affyexp_wt_glucose_leucine_O2_3_ec2):  ec2  3,
 Array Experiment (#266, affyexp_wt_glucose_NH4Cl_anaerobic_1_ec2):  ec2  1,
 Array Experiment (#267, affyexp_wt_glucose_NH4Cl_anaerobic_2_ec2):  ec2  2,
 Array Experiment (#268, affyexp_wt_glucose_NH4Cl_anaerobic_3_ec2):  ec2  3,
 Array Experiment (#269, affyexp_wt_glucose_NH4Cl_NO3_1_ec2):  ec2  1,
 Array Experiment (#270, affyexp_wt_glucose_NH4Cl_NO3_2_ec2):  ec2  2,
 Array Experiment (#271, affyexp_wt_glucose_NH4Cl_NO3_3_ec2):  ec2  3,
 Array Experiment (#272, affyexp_wt_glucose_NH4Cl_O2_1_ec2):  ec2  1,
 Array Experiment (#273, affyexp_wt_glucose_NH4Cl_O2_2_ec2):  ec2  2,
 Array Experiment (#274, affyexp_wt_glucose_NH4Cl_O2_3_ec2):  ec2  3,
 Expression Data (#275):  RNAseq_wt_fructose_NH4Cl_O2,
 Expression Data (#276):  RNAseq_wt_glucose_NH4Cl_O2,
 Expression Data (#277):  RNAseq_wt_glycerol_NH4Cl_O2,
 Expression Data (#278):  RNAseq_wt_glucose_NH4Cl_O2_dpd,
 Expression Data (#279):  RNAseq_wt_glucose_NH4Cl_O2_FeCl2,
 Expression Data (#280):  RNAseq_wt_glucose_cytidine_O2,
 Expression Data (#281):  RNAseq_wt_glucose_cytosine_O2,
 Expression Data (#282):  RNAseq_wt_glucose_glutamine_O2,
 Expression Data (#283):  RNAseq_Ar3_glycerol_NH4Cl_O2,
 Expression Data (#284):  RNAseq_delAr1_glycerol_NH4Cl_O2,
 Expression Data (#285):  RNAseq_delAr1delAr2_glycerol_NH4Cl_O2,
 Expression Data (#286):  RNAseq_delAr2_glycerol_NH4Cl_O2,
 Expression Data (#287):  RNAseq_delta-crp_fructose_NH4Cl_O2,
 Expression Data (#288):  RNAseq_delta-crp_glucose_NH4Cl_O2,
 Expression Data (#289):  RNAseq_delta-crp_glycerol_NH4Cl_O2,
 Expression Data (#290):  RNAseq_bw25113_acetate_NH4Cl_O2_thiamine,
 Expression Data (#291):  RNAseq_bw25113_fumarate_NH4Cl_O2_thiamine,
 Expression Data (#293):  RNAseq_bw25113_pyruvate_NH4Cl_O2_thiamine,
 Expression Data (#295):  RNAseq_delta-fur_glucose_NH4Cl_O2_FeCl2,
 Expression Data (#298):  affyexp_wt_glucose_NH4Cl_anaerobic,
 Expression Data (#299):  affyexp_wt_glucose_NH4Cl_NO3,
 Expression Data (#303):  affyexp_delta-crp_fructose_NH4Cl_O2,
 Expression Data (#304):  affyexp_delta-crp_glucose_NH4Cl_O2,
 Expression Data (#305):  affyexp_delta-arcA_glucose_NH4Cl_O2,
 Expression Data (#306):  affyexp_delta-arcA_glucose_NH4Cl_anaerobic,
 Expression Data (#307):  affyexp_delta-arcA_glucose_NH4Cl_NO3,
 Expression Data (#308):  affyexp_delta-arcAfnr_glucose_NH4Cl_O2,
 Expression Data (#309):  affyexp_delta-arcAfnr_glucose_NH4Cl_anaerobic,
 Expression Data (#310):  affyexp_delta-fnr_glucose_NH4Cl_O2,
 Expression Data (#311):  affyexp_delta-fnr_glucose_NH4Cl_anaerobic,
 Expression Data (#312):  affyexp_delta-fnr_glucose_NH4Cl_NO3,
 Expression Data (#313):  affyexp_delta-narL_glucose_NH4Cl_anaerobic,
 Expression Data (#314):  affyexp_delta-narL_glucose_NH4Cl_NO3,
 Expression Data (#315):  affyexp_delta-narLnarP_glucose_NH4Cl_anaerobic,
 Expression Data (#316):  affyexp_delta-narLnarP_glucose_NH4Cl_NO3,
 Expression Data (#317):  affyexp_delta-narP_glucose_NH4Cl_anaerobic,
 Expression Data (#318):  affyexp_delta-narP_glucose_NH4Cl_NO3,
 Expression Data (#325):  affyexp_delta-purR_glucose_adenine_O2,
 ChIP Peak Analysis (#327, ChIPExo-RpoD_wt_glucose_cytidine_O2_anti-rpod_default_peaks): Environment: C:glucose, N:cytidine, e:O2 ,
 ChIP Peak Analysis (#329, ChIPExo-Crp_wt_fructose_NH4Cl_O2_anti-crp_default_peaks): Environment: C:fructose, N:NH4Cl, e:O2 ,
 ChIP Peak Analysis (#330, ChIPExo-Nac_Nac8myc_glucose_NH4Cl_O2_anti-myc_default_peaks): Environment: C:glucose, N:NH4Cl, e:O2 ,
 ChIP Peak Analysis (#332, ChIPExo-NtrC_NtrC8myc_glucose_cytosine_O2_anti-myc_default_peaks): Environment: C:glucose, N:cytosine, e:O2 ,
 ChIP Peak Analysis (#336, ChIPExo-RpoD_wt_fructose_NH4Cl_O2_anti-rpod_default_peaks): Environment: C:fructose, N:NH4Cl, e:O2 ,
 ChIP Peak Analysis (#337, ChIPchip-Crp_Crp8myc_fructose_NH4Cl_O2_anti-myc_default_peaks): Environment: C:fructose, N:NH4Cl, e:O2 ,
 ChIP Peak Analysis (#339, ChIPExo-RpoD_wt_glycerol_NH4Cl_O2_anti-rpod_default_peaks): Environment: C:glycerol, N:NH4Cl, e:O2 ,
 ChIP Peak Analysis (#340, ChIPExo-Crp_delAr2_glycerol_NH4Cl_O2_anti-crp_default_peaks): Environment: C:glycerol, N:NH4Cl, e:O2 ,
 ChIP Peak Analysis (#341, ChIPExo-Crp_Ar3_glycerol_NH4Cl_O2_anti-crp_default_peaks): Environment: C:glycerol, N:NH4Cl, e:O2 ,
 ChIP Peak Analysis (#342, ChIPchip-ArcA_ArcA8myc_glucose_NH4Cl_NO3_anti-myc_default_peaks): Environment: C:glucose, N:NH4Cl, e:NO3 ,
 ChIP Peak Analysis (#343, ChIPExo-RpoD_wt_glucose_glutamine_O2_anti-rpod_default_peaks): Environment: C:glucose, N:glutamine, e:O2 ,
 ChIP Peak Analysis (#345, ChIPExo-RpoN_wt_glucose_NH4Cl_O2_anti-rpon_default_peaks): Environment: C:glucose, N:NH4Cl, e:O2 ,
 ChIP Peak Analysis (#347, ChIPExo-Crp_delta-crp_glycerol_NH4Cl_O2_anti-crp_default_peaks): Environment: C:glycerol, N:NH4Cl, e:O2 ,
 ChIP Peak Analysis (#348, ChIPExo-Crp_delAr1_glycerol_NH4Cl_O2_anti-crp_default_peaks): Environment: C:glycerol, N:NH4Cl, e:O2 ,
 ChIP Peak Analysis (#349, ChIPExo-RpoN_wt_glucose_cytidine_O2_anti-rpon_default_peaks): Environment: C:glucose, N:cytidine, e:O2 ,
 ChIP Peak Analysis (#351, ChIPExo-Fnr_Fnr8myc_glucose_NH4Cl_anaerobic_anti-myc_default_peaks): Environment: C:glucose, N:NH4Cl, e:anaerobic ,
 ChIP Peak Analysis (#355, ChIPchip-Crp_Crp8myc_acetate_NH4Cl_O2_anti-myc_default_peaks): Environment: C:acetate, N:NH4Cl, e:O2 ,
 ChIP Peak Analysis (#357, ChIPchip-ArgR_ArgR8myc_glucose_NH4Cl_O2_anti-myc_default_peaks): Environment: C:glucose, N:NH4Cl, e:O2 ,
 ChIP Peak Analysis (#359, ChIPExo-Fur_Fur8myc_glucose_NH4Cl_O2_anti-myc_dpd_default_peaks): Environment: C:glucose, N:NH4Cl, e:O2 dpd,
 ChIP Peak Analysis (#361, ChIPExo-RpoS_wt_glucose_NH4Cl_O2_anti-rpos_default_peaks): Environment: C:glucose, N:NH4Cl, e:O2 ,
 ChIP Peak Analysis (#363, ChIPExo-RpoD_wt_glucose_cytosine_O2_anti-rpod_default_peaks): Environment: C:glucose, N:cytosine, e:O2 ,
 ChIP Peak Analysis (#366, ChIPExo-NtrC_NtrC8myc_glucose_cytidine_O2_anti-myc_default_peaks): Environment: C:glucose, N:cytidine, e:O2 ,
 ChIP Peak Analysis (#368, ChIPchip-Cra_Cra8myc_acetate_NH4Cl_O2_anti-myc_default_peaks): Environment: C:acetate, N:NH4Cl, e:O2 ,
 ChIP Peak Analysis (#369, ChIPchip-PurR_PurR8myc_glucose_NH4Cl_O2_anti-myc_default_peaks): Environment: C:glucose, N:NH4Cl, e:O2 ,
 ChIP Peak Analysis (#372, ChIPExo-RpoN_wt_glucose_cytosine_O2_anti-rpon_default_peaks): Environment: C:glucose, N:cytosine, e:O2 ,
 ChIP Peak Analysis (#376, ChIPExo-Crp_Crp8myc_glycerol_NH4Cl_O2_anti-myc_default_peaks): Environment: C:glycerol, N:NH4Cl, e:O2 ,
 Expression Data (#292):  RNAseq_bw25113_glucose_NH4Cl_O2_thiamine,
 Expression Data (#294):  RNAseq_delta-fur_glucose_NH4Cl_O2_dpd,
 Expression Data (#296):  affyexp_wt_fructose_NH4Cl_O2,
 Expression Data (#297):  affyexp_wt_glucose_NH4Cl_O2,
 Expression Data (#300):  affyexp_wt_acetate_NH4Cl_O2,
 Expression Data (#301):  affyexp_wt_glucose_leucine_O2,
 Expression Data (#302):  affyexp_wt_glucose_adenine_O2,
 Expression Data (#319):  affyexp_delta-cra_glucose_NH4Cl_O2,
 Expression Data (#320):  affyexp_delta-cra_glucose_NH4Cl_anaerobic,
 Expression Data (#321):  affyexp_delta-cra_acetate_NH4Cl_O2,
 Expression Data (#322):  affyexp_delta-lrp_glucose_NH4Cl_O2,
 Expression Data (#323):  affyexp_delta-lrp_glucose_leucine_O2,
 Expression Data (#324):  affyexp_delta-purR_glucose_NH4Cl_O2,
 ChIP Peak Analysis (#326, ChIPExo-Crp_wt_glucose_NH4Cl_O2_anti-crp_default_peaks): Environment: C:glucose, N:NH4Cl, e:O2 ,
 ChIP Peak Analysis (#328, ChIPExo-Nac_Nac8myc_glucose_glutamine_O2_anti-myc_default_peaks): Environment: C:glucose, N:glutamine, e:O2 ,
 ChIP Peak Analysis (#331, ChIPExo-Crp_wt_glycerol_NH4Cl_O2_anti-crp_default_peaks): Environment: C:glycerol, N:NH4Cl, e:O2 ,
 ChIP Peak Analysis (#333, ChIPchip-Cra_Cra8myc_glucose_NH4Cl_O2_anti-myc_default_peaks): Environment: C:glucose, N:NH4Cl, e:O2 ,
 ChIP Peak Analysis (#334, ChIPchip-Lrp_Lrp8myc_glucose_NH4Cl_O2_anti-myc_default_peaks): Environment: C:glucose, N:NH4Cl, e:O2 ,
 ChIP Peak Analysis (#335, ChIPExo-ArcA_ArcA8myc_glucose_NH4Cl_anaerobic_anti-myc_default_peaks): Environment: C:glucose, N:NH4Cl, e:anaerobic ,
 ChIP Peak Analysis (#338, ChIPExo-RpoD_wt_glucose_NH4Cl_O2_anti-rpod_default_peaks): Environment: C:glucose, N:NH4Cl, e:O2 ,
 ChIP Peak Analysis (#344, ChIPExo-Nac_Nac8myc_glucose_cytidine_O2_anti-myc_default_peaks): Environment: C:glucose, N:cytidine, e:O2 ,
 ChIP Peak Analysis (#346, ChIPExo-RpoN_wt_glucose_glutamine_O2_anti-rpon_default_peaks): Environment: C:glucose, N:glutamine, e:O2 ,
 ChIP Peak Analysis (#350, ChIPExo-Fur_Fur8myc_glucose_NH4Cl_O2_anti-myc_FeCl2_default_peaks): Environment: C:glucose, N:NH4Cl, e:O2 FeCl2,
 ChIP Peak Analysis (#352, ChIPchip-Fnr_Fnr8myc_glucose_NH4Cl_NO3_anti-myc_default_peaks): Environment: C:glucose, N:NH4Cl, e:NO3 ,
 ChIP Peak Analysis (#353, ChIPchip-Fnr_Fnr8myc_glucose_NH4Cl_anaerobic_anti-myc_default_peaks): Environment: C:glucose, N:NH4Cl, e:anaerobic ,
 ChIP Peak Analysis (#354, ChIPExo-NtrC_NtrC8myc_glucose_glutamine_O2_anti-myc_default_peaks): Environment: C:glucose, N:glutamine, e:O2 ,
 ChIP Peak Analysis (#356, ChIPExo-RpoA_wt_glucose_NH4Cl_O2_anti-rpoA_default_peaks): Environment: C:glucose, N:NH4Cl, e:O2 ,
 ChIP Peak Analysis (#358, ChIPExo-Nac_Nac8myc_glucose_cytosine_O2_anti-myc_default_peaks): Environment: C:glucose, N:cytosine, e:O2 ,
 ChIP Peak Analysis (#360, ChIPExo-NtrC_NtrC8myc_glucose_NH4Cl_O2_anti-myc_default_peaks): Environment: C:glucose, N:NH4Cl, e:O2 ,
 ChIP Peak Analysis (#362, ChIPExo-Crp_Crp8myc_fructose_NH4Cl_O2_anti-crp_default_peaks): Environment: C:fructose, N:NH4Cl, e:O2 ,
 ChIP Peak Analysis (#364, ChIPExo-Crp_wt_glycerol_NH4Cl_O2_anti-crp_rif_default_peaks): Environment: C:glycerol, N:NH4Cl, e:O2 rif,
 ChIP Peak Analysis (#365, ChIPExo-Crp_Crp8myc_glycerol_NH4Cl_O2_anti-crp_default_peaks): Environment: C:glycerol, N:NH4Cl, e:O2 ,
 ChIP Peak Analysis (#367, ChIPExo-RpoN_wt_glucose_NH4Cl_O2_anti-rpon_nitrogenstudy_default_peaks): Environment: C:glucose, N:NH4Cl, e:O2 nitrogenstudy,
 ChIP Peak Analysis (#370, ChIPchip-Cra_Cra8myc_glucose_NH4Cl_anaerobic_anti-myc_default_peaks): Environment: C:glucose, N:NH4Cl, e:anaerobic ,
 ChIP Peak Analysis (#371, ChIPExo-Crp_Crp8myc_glucose_NH4Cl_O2_anti-myc_default_peaks): Environment: C:glucose, N:NH4Cl, e:O2 ,
 ChIP Peak Analysis (#373, ChIPExo-Crp_delAr1delAr2_glycerol_NH4Cl_O2_anti-crp_default_peaks): Environment: C:glycerol, N:NH4Cl, e:O2 ,
 ChIP Peak Analysis (#374, ChIPchip-ArcA_ArcA8myc_glucose_NH4Cl_anaerobic_anti-myc_default_peaks): Environment: C:glucose, N:NH4Cl, e:anaerobic ,
 ChIP Peak Analysis (#375, ChIPExo-RpoD_wt_glucose_NH4Cl_O2_anti-rpod_nitrogenstudy_default_peaks): Environment: C:glucose, N:NH4Cl, e:O2 nitrogenstudy,
 Differential Expression (#377): RNAseq_bw25113_acetate/fumarate_NH4Cl_O2_thiamine,
 Differential Expression (#378): RNAseq_wt_glucose_NH4Cl/cytidine_O2,
 Differential Expression (#379): RNAseq_wt_glucose_cytidine/glutamine_O2,
 Differential Expression (#380): RNAseq_wt_glucose_cytosine/glutamine_O2,
 Differential Expression (#381): RNAseq_wt_glucose_NH4Cl/glutamine_O2,
 Differential Expression (#382): RNAseq_delta-crp/wt_fructose_NH4Cl_O2,
 Differential Expression (#383): RNAseq_wt_glucose_NH4Cl_O2_supp/FeCl2,
 Differential Expression (#384): RNAseq_delta-fur/wt_glucose_NH4Cl_O2_FeCl2,
 Differential Expression (#385): RNAseq_delta-fur_glucose_NH4Cl_O2_FeCl2/dpd,
 Differential Expression (#386): RNAseq_wt_glucose_cytidine/cytosine_O2,
 Differential Expression (#387): RNAseq_wt_glucose_NH4Cl/cytosine_O2,
 Differential Expression (#388): RNAseq_bw25113_fumarate/glucose_NH4Cl_O2_thiamine,
 Differential Expression (#389): RNAseq_bw25113_acetate/glucose_NH4Cl_O2_thiamine,
 Differential Expression (#390): RNAseq_delAr2/wt_glycerol_NH4Cl_O2,
 Differential Expression (#391): RNAseq_wt_fructose/glycerol_NH4Cl_O2,
 Differential Expression (#392): RNAseq_delAr1/wt_glycerol_NH4Cl_O2,
 Differential Expression (#393): RNAseq_delAr1delAr2/wt_glycerol_NH4Cl_O2,
 Differential Expression (#394): RNAseq_Ar3/wt_glycerol_NH4Cl_O2,
 Differential Expression (#395): RNAseq_wt_glucose/glycerol_NH4Cl_O2,
 Differential Expression (#396): RNAseq_delta-crp/wt_glycerol_NH4Cl_O2,
 Differential Expression (#397): RNAseq_wt_fructose/glucose_NH4Cl_O2,
 Differential Expression (#398): RNAseq_delta-crp/wt_glucose_NH4Cl_O2,
 Differential Expression (#399): RNAseq_wt_glucose_NH4Cl_O2_FeCl2/dpd,
 Differential Expression (#400): RNAseq_delta-fur/wt_glucose_NH4Cl_O2_dpd,
 Differential Expression (#401): RNAseq_wt_glucose_NH4Cl_O2_supp/dpd,
 Differential Expression (#402): RNAseq_delta-crp_fructose/glycerol_NH4Cl_O2,
 Differential Expression (#403): RNAseq_delta-crp_glucose/glycerol_NH4Cl_O2,
 Differential Expression (#404): RNAseq_bw25113_fumarate/pyruvate_NH4Cl_O2_thiamine,
 Differential Expression (#405): RNAseq_bw25113_glucose/pyruvate_NH4Cl_O2_thiamine,
 Differential Expression (#406): RNAseq_bw25113_acetate/pyruvate_NH4Cl_O2_thiamine,
 Differential Expression (#407): RNAseq_delta-crp_fructose/glucose_NH4Cl_O2,
 Differential Expression (#408): affyexp_delta-narLnarP_glucose_NH4Cl_NO3/anaerobic,
 Differential Expression (#409): affyexp_delta-narLnarP/wt_glucose_NH4Cl_NO3,
 Differential Expression (#410): affyexp_delta-purR_glucose_NH4Cl/adenine_O2,
 Differential Expression (#411): affyexp_delta-purR/wt_glucose_NH4Cl_O2]

In [42]:
from om.data import *

Strains


In [43]:
session.query(Strain).all()


Out[43]:
[Strain: wt,
 Strain: ArcA8myc,
 Strain: Ar3,
 Strain: Crp8myc,
 Strain: delAr1,
 Strain: delAr1delAr2,
 Strain: delAr2,
 Strain: delta-crp,
 Strain: Fnr8myc,
 Strain: Fur8myc,
 Strain: Nac8myc,
 Strain: NtrC8myc,
 Strain: ArgR8myc,
 Strain: Cra8myc,
 Strain: Lrp8myc,
 Strain: PurR8myc,
 Strain: bw25113,
 Strain: delta-fur,
 Strain: delta-arcA,
 Strain: delta-arcAfnr,
 Strain: delta-fnr,
 Strain: delta-narL,
 Strain: delta-narLnarP,
 Strain: delta-narP,
 Strain: delta-cra,
 Strain: delta-lrp,
 Strain: delta-purR,
 Strain: generic]

Environments


In [44]:
session.query(Environment).all()


Out[44]:
[Environment: C:fructose, N:NH4Cl, e:O2 ,
 Environment: C:glucose, N:NH4Cl, e:O2 ,
 Environment: C:glycerol, N:NH4Cl, e:O2 ,
 Environment: C:glucose, N:NH4Cl, e:anaerobic ,
 Environment: C:glycerol, N:NH4Cl, e:O2 rif,
 Environment: C:glucose, N:NH4Cl, e:O2 dpd,
 Environment: C:glucose, N:NH4Cl, e:O2 FeCl2,
 Environment: C:glucose, N:cytidine, e:O2 ,
 Environment: C:glucose, N:cytosine, e:O2 ,
 Environment: C:glucose, N:glutamine, e:O2 ,
 Environment: C:glucose, N:NH4Cl, e:O2 nitrogenstudy,
 Environment: C:glucose, N:NH4Cl, e:NO3 ,
 Environment: C:acetate, N:NH4Cl, e:O2 ,
 Environment: C:acetate, N:NH4Cl, e:O2 thiamine,
 Environment: C:fumarate, N:NH4Cl, e:O2 thiamine,
 Environment: C:glucose, N:NH4Cl, e:O2 thiamine,
 Environment: C:pyruvate, N:NH4Cl, e:O2 thiamine,
 Environment: C:glucose, N:leucine, e:O2 ,
 Environment: C:glucose, N:adenine, e:O2 ,
 Environment: type:environment, name:generic]

ChIP Experiments


In [45]:
session.query(ChIPExperiment).all()


Out[45]:
[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,
 ChIPExperiment (#94, ChIPchip-ArcA_ArcA8myc_glucose_NH4Cl_anaerobic_1_anti-myc): ChIPchip ArcA 1,
 ChIPExperiment (#95, ChIPchip-ArcA_ArcA8myc_glucose_NH4Cl_anaerobic_2_anti-myc): ChIPchip ArcA 2,
 ChIPExperiment (#96, ChIPchip-ArcA_ArcA8myc_glucose_NH4Cl_anaerobic_3_anti-myc): ChIPchip ArcA 3,
 ChIPExperiment (#97, ChIPchip-ArcA_ArcA8myc_glucose_NH4Cl_NO3_1_anti-myc): ChIPchip ArcA 1,
 ChIPExperiment (#98, ChIPchip-ArcA_ArcA8myc_glucose_NH4Cl_NO3_2_anti-myc): ChIPchip ArcA 2,
 ChIPExperiment (#99, ChIPchip-ArcA_ArcA8myc_glucose_NH4Cl_NO3_3_anti-myc): ChIPchip ArcA 3,
 ChIPExperiment (#100, ChIPchip-ArgR_ArgR8myc_glucose_NH4Cl_O2_1_anti-myc): ChIPchip ArgR 1,
 ChIPExperiment (#101, ChIPchip-ArgR_ArgR8myc_glucose_NH4Cl_O2_2_anti-myc): ChIPchip ArgR 2,
 ChIPExperiment (#102, ChIPchip-Cra_Cra8myc_acetate_NH4Cl_O2_1_anti-myc): ChIPchip Cra 1,
 ChIPExperiment (#103, ChIPchip-Cra_Cra8myc_acetate_NH4Cl_O2_2_anti-myc): ChIPchip Cra 2,
 ChIPExperiment (#104, ChIPchip-Cra_Cra8myc_acetate_NH4Cl_O2_3_anti-myc): ChIPchip Cra 3,
 ChIPExperiment (#105, ChIPchip-Cra_Cra8myc_glucose_NH4Cl_anaerobic_1_anti-myc): ChIPchip Cra 1,
 ChIPExperiment (#106, ChIPchip-Cra_Cra8myc_glucose_NH4Cl_anaerobic_2_anti-myc): ChIPchip Cra 2,
 ChIPExperiment (#107, ChIPchip-Cra_Cra8myc_glucose_NH4Cl_anaerobic_3_anti-myc): ChIPchip Cra 3,
 ChIPExperiment (#108, ChIPchip-Cra_Cra8myc_glucose_NH4Cl_O2_1_anti-myc): ChIPchip Cra 1,
 ChIPExperiment (#109, ChIPchip-Cra_Cra8myc_glucose_NH4Cl_O2_2_anti-myc): ChIPchip Cra 2,
 ChIPExperiment (#110, ChIPchip-Cra_Cra8myc_glucose_NH4Cl_O2_3_anti-myc): ChIPchip Cra 3,
 ChIPExperiment (#111, ChIPchip-Crp_Crp8myc_acetate_NH4Cl_O2_2_anti-myc): ChIPchip Crp 2,
 ChIPExperiment (#112, ChIPchip-Crp_Crp8myc_acetate_NH4Cl_O2_3_anti-myc): ChIPchip Crp 3,
 ChIPExperiment (#113, ChIPchip-Crp_Crp8myc_fructose_NH4Cl_O2_1_anti-myc): ChIPchip Crp 1,
 ChIPExperiment (#114, ChIPchip-Crp_Crp8myc_fructose_NH4Cl_O2_2_anti-myc): ChIPchip Crp 2,
 ChIPExperiment (#115, ChIPchip-Fnr_Fnr8myc_glucose_NH4Cl_anaerobic_1_anti-myc): ChIPchip Fnr 1,
 ChIPExperiment (#116, ChIPchip-Fnr_Fnr8myc_glucose_NH4Cl_anaerobic_2_anti-myc): ChIPchip Fnr 2,
 ChIPExperiment (#117, ChIPchip-Fnr_Fnr8myc_glucose_NH4Cl_anaerobic_3_anti-myc): ChIPchip Fnr 3,
 ChIPExperiment (#118, ChIPchip-Fnr_Fnr8myc_glucose_NH4Cl_NO3_1_anti-myc): ChIPchip Fnr 1,
 ChIPExperiment (#119, ChIPchip-Fnr_Fnr8myc_glucose_NH4Cl_NO3_2_anti-myc): ChIPchip Fnr 2,
 ChIPExperiment (#120, ChIPchip-Fnr_Fnr8myc_glucose_NH4Cl_NO3_3_anti-myc): ChIPchip Fnr 3,
 ChIPExperiment (#121, ChIPchip-Lrp_Lrp8myc_glucose_NH4Cl_O2_1_anti-myc): ChIPchip Lrp 1,
 ChIPExperiment (#122, ChIPchip-Lrp_Lrp8myc_glucose_NH4Cl_O2_2_anti-myc): ChIPchip Lrp 2,
 ChIPExperiment (#123, ChIPchip-Lrp_Lrp8myc_glucose_NH4Cl_O2_3_anti-myc): ChIPchip Lrp 3,
 ChIPExperiment (#124, ChIPchip-PurR_PurR8myc_glucose_NH4Cl_O2_1_anti-myc): ChIPchip PurR 1,
 ChIPExperiment (#125, ChIPchip-PurR_PurR8myc_glucose_NH4Cl_O2_2_anti-myc): ChIPchip PurR 2]

In [46]:
print session.query(ChIPExperiment)


SELECT chip_experiment.id AS chip_experiment_id, data_set.id AS data_set_id, data_set.name AS data_set_name, data_set.type AS data_set_type, data_set.replicate AS data_set_replicate, data_set.strain_id AS data_set_strain_id, data_set.environment_id AS data_set_environment_id, data_set.data_source_id AS data_set_data_source_id, chip_experiment.antibody AS chip_experiment_antibody, chip_experiment.protocol_type AS chip_experiment_protocol_type, chip_experiment.target AS chip_experiment_target, chip_experiment.group_name AS chip_experiment_group_name, chip_experiment.normalization_method AS chip_experiment_normalization_method, chip_experiment.normalization_factor AS chip_experiment_normalization_factor 
FROM data_set JOIN chip_experiment ON data_set.id = chip_experiment.id

In [47]:
session.query(ChIPExperiment).filter(ChIPExperiment.protocol_type == 'ChIPExo').all()


Out[47]:
[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]

In [48]:
session.query(ChIPExperiment).filter(and_(ChIPExperiment.protocol_type == 'ChIPExo',
                                          ChIPExperiment.antibody == 'anti-rpod')).all()


Out[48]:
[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 (#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]

ChIP Peaks


In [49]:
session.query(ChIPPeakAnalysis).limit(10).all()


Out[49]:
[ChIP Peak Analysis (#326, ChIPExo-Crp_wt_glucose_NH4Cl_O2_anti-crp_default_peaks): Environment: C:glucose, N:NH4Cl, e:O2 ,
 ChIP Peak Analysis (#327, ChIPExo-RpoD_wt_glucose_cytidine_O2_anti-rpod_default_peaks): Environment: C:glucose, N:cytidine, e:O2 ,
 ChIP Peak Analysis (#328, ChIPExo-Nac_Nac8myc_glucose_glutamine_O2_anti-myc_default_peaks): Environment: C:glucose, N:glutamine, e:O2 ,
 ChIP Peak Analysis (#329, ChIPExo-Crp_wt_fructose_NH4Cl_O2_anti-crp_default_peaks): Environment: C:fructose, N:NH4Cl, e:O2 ,
 ChIP Peak Analysis (#330, ChIPExo-Nac_Nac8myc_glucose_NH4Cl_O2_anti-myc_default_peaks): Environment: C:glucose, N:NH4Cl, e:O2 ,
 ChIP Peak Analysis (#331, ChIPExo-Crp_wt_glycerol_NH4Cl_O2_anti-crp_default_peaks): Environment: C:glycerol, N:NH4Cl, e:O2 ,
 ChIP Peak Analysis (#332, ChIPExo-NtrC_NtrC8myc_glucose_cytosine_O2_anti-myc_default_peaks): Environment: C:glucose, N:cytosine, e:O2 ,
 ChIP Peak Analysis (#333, ChIPchip-Cra_Cra8myc_glucose_NH4Cl_O2_anti-myc_default_peaks): Environment: C:glucose, N:NH4Cl, e:O2 ,
 ChIP Peak Analysis (#334, ChIPchip-Lrp_Lrp8myc_glucose_NH4Cl_O2_anti-myc_default_peaks): Environment: C:glucose, N:NH4Cl, e:O2 ,
 ChIP Peak Analysis (#335, ChIPExo-ArcA_ArcA8myc_glucose_NH4Cl_anaerobic_anti-myc_default_peaks): Environment: C:glucose, N:NH4Cl, e:anaerobic ]

In [50]:
session.query(ChIPPeakAnalysis).first().children


Out[50]:
[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]

In [53]:
session.query(ChIPPeakData).filter(ChIPPeakData.data_set_id == 330).limit(20).all()


Out[53]:
[ChIP Peak: 155-356 4626.10 ChIPExo-Nac_Nac8myc_glucose_NH4Cl_O2_anti-myc_default_peaks,
 ChIP Peak: 209-410 1730.90 ChIPExo-Nac_Nac8myc_glucose_NH4Cl_O2_anti-myc_default_peaks,
 ChIP Peak: 83469-83670 1199.10 ChIPExo-Nac_Nac8myc_glucose_NH4Cl_O2_anti-myc_default_peaks,
 ChIP Peak: 83537-83738 2267.40 ChIPExo-Nac_Nac8myc_glucose_NH4Cl_O2_anti-myc_default_peaks,
 ChIP Peak: 83576-83777 1091.80 ChIPExo-Nac_Nac8myc_glucose_NH4Cl_O2_anti-myc_default_peaks,
 ChIP Peak: 83634-83835 1593.70 ChIPExo-Nac_Nac8myc_glucose_NH4Cl_O2_anti-myc_default_peaks,
 ChIP Peak: 169784-169985 8440.30 ChIPExo-Nac_Nac8myc_glucose_NH4Cl_O2_anti-myc_default_peaks,
 ChIP Peak: 169806-170007 4580.70 ChIPExo-Nac_Nac8myc_glucose_NH4Cl_O2_anti-myc_default_peaks,
 ChIP Peak: 188570-188771 5568.00 ChIPExo-Nac_Nac8myc_glucose_NH4Cl_O2_anti-myc_default_peaks,
 ChIP Peak: 228811-229012 3650.60 ChIPExo-Nac_Nac8myc_glucose_NH4Cl_O2_anti-myc_default_peaks,
 ChIP Peak: 228869-229070 3192.40 ChIPExo-Nac_Nac8myc_glucose_NH4Cl_O2_anti-myc_default_peaks,
 ChIP Peak: 236815-237016 1375.90 ChIPExo-Nac_Nac8myc_glucose_NH4Cl_O2_anti-myc_default_peaks,
 ChIP Peak: 236873-237074 2616.50 ChIPExo-Nac_Nac8myc_glucose_NH4Cl_O2_anti-myc_default_peaks,
 ChIP Peak: 236930-237131 1760.50 ChIPExo-Nac_Nac8myc_glucose_NH4Cl_O2_anti-myc_default_peaks,
 ChIP Peak: 261962-262163 1227.30 ChIPExo-Nac_Nac8myc_glucose_NH4Cl_O2_anti-myc_default_peaks,
 ChIP Peak: 262060-262261 1166.70 ChIPExo-Nac_Nac8myc_glucose_NH4Cl_O2_anti-myc_default_peaks,
 ChIP Peak: 357831-358032 4792.30 ChIPExo-Nac_Nac8myc_glucose_NH4Cl_O2_anti-myc_default_peaks,
 ChIP Peak: 357866-358067 1578.70 ChIPExo-Nac_Nac8myc_glucose_NH4Cl_O2_anti-myc_default_peaks,
 ChIP Peak: 365570-365771 477.00 ChIPExo-Nac_Nac8myc_glucose_NH4Cl_O2_anti-myc_default_peaks,
 ChIP Peak: 606512-606713 8871.00 ChIPExo-Nac_Nac8myc_glucose_NH4Cl_O2_anti-myc_default_peaks]

RNAseq Experiments


In [54]:
session.query(RNASeqExperiment).all()


Out[54]:
[RNASeqExperiment (#126, RNAseq_Ar3_glycerol_NH4Cl_O2_1):  1,
 RNASeqExperiment (#127, RNAseq_Ar3_glycerol_NH4Cl_O2_2):  2,
 RNASeqExperiment (#128, RNAseq_Ar3_glycerol_NH4Cl_O2_3):  3,
 RNASeqExperiment (#129, RNAseq_delAr1_glycerol_NH4Cl_O2_1):  1,
 RNASeqExperiment (#130, RNAseq_delAr1_glycerol_NH4Cl_O2_2):  2,
 RNASeqExperiment (#131, RNAseq_delAr1_glycerol_NH4Cl_O2_3):  3,
 RNASeqExperiment (#132, RNAseq_delAr1delAr2_glycerol_NH4Cl_O2_1):  1,
 RNASeqExperiment (#133, RNAseq_delAr1delAr2_glycerol_NH4Cl_O2_2):  2,
 RNASeqExperiment (#134, RNAseq_delAr1delAr2_glycerol_NH4Cl_O2_3):  3,
 RNASeqExperiment (#135, RNAseq_delAr2_glycerol_NH4Cl_O2_1):  1,
 RNASeqExperiment (#136, RNAseq_delAr2_glycerol_NH4Cl_O2_3):  3,
 RNASeqExperiment (#137, RNAseq_delta-crp_fructose_NH4Cl_O2_1):  1,
 RNASeqExperiment (#138, RNAseq_delta-crp_fructose_NH4Cl_O2_2):  2,
 RNASeqExperiment (#139, RNAseq_delta-crp_fructose_NH4Cl_O2_3):  3,
 RNASeqExperiment (#140, RNAseq_delta-crp_glucose_NH4Cl_O2_1):  1,
 RNASeqExperiment (#141, RNAseq_delta-crp_glucose_NH4Cl_O2_2):  2,
 RNASeqExperiment (#142, RNAseq_delta-crp_glucose_NH4Cl_O2_3):  3,
 RNASeqExperiment (#143, RNAseq_delta-crp_glycerol_NH4Cl_O2_1):  1,
 RNASeqExperiment (#144, RNAseq_delta-crp_glycerol_NH4Cl_O2_2):  2,
 RNASeqExperiment (#145, RNAseq_delta-crp_glycerol_NH4Cl_O2_3):  3,
 RNASeqExperiment (#146, RNAseq_wt_fructose_NH4Cl_O2_1):  1,
 RNASeqExperiment (#147, RNAseq_wt_fructose_NH4Cl_O2_2):  2,
 RNASeqExperiment (#148, RNAseq_wt_glucose_NH4Cl_O2_1):  1,
 RNASeqExperiment (#149, RNAseq_wt_glucose_NH4Cl_O2_2):  2,
 RNASeqExperiment (#150, RNAseq_wt_glycerol_NH4Cl_O2_1):  1,
 RNASeqExperiment (#151, RNAseq_wt_glycerol_NH4Cl_O2_2):  2,
 RNASeqExperiment (#152, RNAseq_delAr2_glycerol_NH4Cl_O2_2):  2,
 RNASeqExperiment (#153, RNAseq_bw25113_acetate_NH4Cl_O2_1_thiamine):  1,
 RNASeqExperiment (#154, RNAseq_bw25113_acetate_NH4Cl_O2_2_thiamine):  2,
 RNASeqExperiment (#155, RNAseq_bw25113_fumarate_NH4Cl_O2_1_thiamine):  1,
 RNASeqExperiment (#156, RNAseq_bw25113_fumarate_NH4Cl_O2_2_thiamine):  2,
 RNASeqExperiment (#157, RNAseq_bw25113_glucose_NH4Cl_O2_1_thiamine):  1,
 RNASeqExperiment (#158, RNAseq_bw25113_glucose_NH4Cl_O2_2_thiamine):  2,
 RNASeqExperiment (#159, RNAseq_bw25113_pyruvate_NH4Cl_O2_1_thiamine):  1,
 RNASeqExperiment (#160, RNAseq_bw25113_pyruvate_NH4Cl_O2_2_thiamine):  2,
 RNASeqExperiment (#161, RNAseq_delta-fur_glucose_NH4Cl_O2_1_dpd):  1,
 RNASeqExperiment (#162, RNAseq_delta-fur_glucose_NH4Cl_O2_1_FeCl2):  1,
 RNASeqExperiment (#163, RNAseq_delta-fur_glucose_NH4Cl_O2_2_dpd):  2,
 RNASeqExperiment (#164, RNAseq_delta-fur_glucose_NH4Cl_O2_2_FeCl2):  2,
 RNASeqExperiment (#165, RNAseq_wt_glucose_cytidine_O2_1):  1,
 RNASeqExperiment (#166, RNAseq_wt_glucose_cytidine_O2_2):  2,
 RNASeqExperiment (#167, RNAseq_wt_glucose_cytosine_O2_1):  1,
 RNASeqExperiment (#168, RNAseq_wt_glucose_cytosine_O2_2):  2,
 RNASeqExperiment (#169, RNAseq_wt_glucose_glutamine_O2_1):  1,
 RNASeqExperiment (#170, RNAseq_wt_glucose_glutamine_O2_2):  2,
 RNASeqExperiment (#171, RNAseq_wt_glucose_NH4Cl_O2_1_dpd):  1,
 RNASeqExperiment (#172, RNAseq_wt_glucose_NH4Cl_O2_1_FeCl2):  1,
 RNASeqExperiment (#173, RNAseq_wt_glucose_NH4Cl_O2_2_dpd):  2,
 RNASeqExperiment (#174, RNAseq_wt_glucose_NH4Cl_O2_2_FeCl2):  2,
 RNASeqExperiment (#175, RNAseq_wt_glucose_NH4Cl_O2_3):  3,
 RNASeqExperiment (#176, RNAseq_wt_glucose_NH4Cl_O2_4):  4]

In [55]:
{x['leftpos']:x['value'] for x in query_genome_data([133,134], leftpos=gapA.leftpos, rightpos=gapA.rightpos)}


Out[55]:
{1860794: 2919.0,
 1860795: 2949.0,
 1860796: 3467.0,
 1860797: 3576.0,
 1860798: 3565.0,
 1860799: 3588.0,
 1860800: 3648.0,
 1860801: 3759.0,
 1860802: 3770.0,
 1860803: 3845.0,
 1860804: 3863.0,
 1860805: 3858.0,
 1860806: 3860.0,
 1860807: 3869.0,
 1860808: 3857.0,
 1860809: 3849.0,
 1860810: 3840.0,
 1860811: 3807.0,
 1860812: 3806.0,
 1860813: 3769.0,
 1860814: 3770.0,
 1860815: 3815.0,
 1860816: 3874.0,
 1860817: 4091.0,
 1860818: 4199.0,
 1860819: 4186.0,
 1860820: 4207.0,
 1860821: 4197.0,
 1860822: 4191.0,
 1860823: 4184.0,
 1860824: 4182.0,
 1860825: 4182.0,
 1860826: 4197.0,
 1860827: 4217.0,
 1860828: 4264.0,
 1860829: 4277.0,
 1860830: 4281.0,
 1860831: 4303.0,
 1860832: 4304.0,
 1860833: 4499.0,
 1860834: 4511.0,
 1860835: 4593.0,
 1860836: 4599.0,
 1860837: 4602.0,
 1860838: 4592.0,
 1860839: 4589.0,
 1860840: 4607.0,
 1860841: 4625.0,
 1860842: 4639.0,
 1860843: 4702.0,
 1860844: 4703.0,
 1860845: 4711.0,
 1860846: 4712.0,
 1860847: 4712.0,
 1860848: 4715.0,
 1860849: 4712.0,
 1860850: 4556.0,
 1860851: 4527.0,
 1860852: 4292.0,
 1860853: 4205.0,
 1860854: 4188.0,
 1860855: 4202.0,
 1860856: 4235.0,
 1860857: 3858.0,
 1860858: 3644.0,
 1860859: 2867.0,
 1860860: 2908.0,
 1860861: 2941.0,
 1860862: 2945.0,
 1860863: 2752.0,
 1860864: 2757.0,
 1860865: 2702.0,
 1860866: 2715.0,
 1860867: 2728.0,
 1860868: 2792.0,
 1860869: 2789.0,
 1860870: 2856.0,
 1860871: 2313.0,
 1860872: 2313.0,
 1860873: 2219.0,
 1860874: 2258.0,
 1860875: 2385.0,
 1860876: 2314.0,
 1860877: 2071.0,
 1860878: 2100.0,
 1860879: 2093.0,
 1860880: 2087.0,
 1860881: 2096.0,
 1860882: 2124.0,
 1860883: 2136.0,
 1860884: 2112.0,
 1860885: 2111.0,
 1860886: 2114.0,
 1860887: 2099.0,
 1860888: 2100.0,
 1860889: 2100.0,
 1860890: 2197.0,
 1860891: 2103.0,
 1860892: 1905.0,
 1860893: 1918.0,
 1860894: 1826.0,
 1860895: 1803.0,
 1860896: 1808.0,
 1860897: 1812.0,
 1860898: 1810.0,
 1860899: 1834.0,
 1860900: 1831.0,
 1860901: 1837.0,
 1860902: 1759.0,
 1860903: 1791.0,
 1860904: 1795.0,
 1860905: 1957.0,
 1860906: 2130.0,
 1860907: 2122.0,
 1860908: 2150.0,
 1860909: 1965.0,
 1860910: 1873.0,
 1860911: 1871.0,
 1860912: 1862.0,
 1860913: 1865.0,
 1860914: 1870.0,
 1860915: 1851.0,
 1860916: 1854.0,
 1860917: 1891.0,
 1860918: 1879.0,
 1860919: 1840.0,
 1860920: 1833.0,
 1860921: 1843.0,
 1860922: 1861.0,
 1860923: 1883.0,
 1860924: 1883.0,
 1860925: 1901.0,
 1860926: 2012.0,
 1860927: 2088.0,
 1860928: 2082.0,
 1860929: 2098.0,
 1860930: 2087.0,
 1860931: 2042.0,
 1860932: 2027.0,
 1860933: 2068.0,
 1860934: 1946.0,
 1860935: 1998.0,
 1860936: 2001.0,
 1860937: 2002.0,
 1860938: 2088.0,
 1860939: 1972.0,
 1860940: 2034.0,
 1860941: 2044.0,
 1860942: 2019.0,
 1860943: 2054.0,
 1860944: 1943.0,
 1860945: 1982.0,
 1860946: 2050.0,
 1860947: 2098.0,
 1860948: 2134.0,
 1860949: 2199.0,
 1860950: 2183.0,
 1860951: 2115.0,
 1860952: 2121.0,
 1860953: 2143.0,
 1860954: 2173.0,
 1860955: 2207.0,
 1860956: 2541.0,
 1860957: 2580.0,
 1860958: 2562.0,
 1860959: 2740.0,
 1860960: 2875.0,
 1860961: 3128.0,
 1860962: 3127.0,
 1860963: 3215.0,
 1860964: 3222.0,
 1860965: 3254.0,
 1860966: 3409.0,
 1860967: 3430.0,
 1860968: 3413.0,
 1860969: 3510.0,
 1860970: 3534.0,
 1860971: 3531.0,
 1860972: 3567.0,
 1860973: 3590.0,
 1860974: 3658.0,
 1860975: 3784.0,
 1860976: 3914.0,
 1860977: 4045.0,
 1860978: 4090.0,
 1860979: 4088.0,
 1860980: 4171.0,
 1860981: 4064.0,
 1860982: 3909.0,
 1860983: 3888.0,
 1860984: 3860.0,
 1860985: 3857.0,
 1860986: 3857.0,
 1860987: 3917.0,
 1860988: 3968.0,
 1860989: 4028.0,
 1860990: 4033.0,
 1860991: 4042.0,
 1860992: 4155.0,
 1860993: 4123.0,
 1860994: 4125.0,
 1860995: 4104.0,
 1860996: 4098.0,
 1860997: 4082.0,
 1860998: 4096.0,
 1860999: 4088.0,
 1861000: 4142.0,
 1861001: 4138.0,
 1861002: 4068.0,
 1861003: 4239.0,
 1861004: 4476.0,
 1861005: 4574.0,
 1861006: 4673.0,
 1861007: 4736.0,
 1861008: 4731.0,
 1861009: 4738.0,
 1861010: 4820.0,
 1861011: 4789.0,
 1861012: 4780.0,
 1861013: 4727.0,
 1861014: 4644.0,
 1861015: 4609.0,
 1861016: 4606.0,
 1861017: 4587.0,
 1861018: 4593.0,
 1861019: 4787.0,
 1861020: 5040.0,
 1861021: 5105.0,
 1861022: 5065.0,
 1861023: 5105.0,
 1861024: 5052.0,
 1861025: 5124.0,
 1861026: 5237.0,
 1861027: 5190.0,
 1861028: 5185.0,
 1861029: 5269.0,
 1861030: 5232.0,
 1861031: 5222.0,
 1861032: 5031.0,
 1861033: 5057.0,
 1861034: 5100.0,
 1861035: 5007.0,
 1861036: 4890.0,
 1861037: 4629.0,
 1861038: 4629.0,
 1861039: 4636.0,
 1861040: 4705.0,
 1861041: 4927.0,
 1861042: 4716.0,
 1861043: 4842.0,
 1861044: 4993.0,
 1861045: 4945.0,
 1861046: 4997.0,
 1861047: 4995.0,
 1861048: 4970.0,
 1861049: 5027.0,
 1861050: 5053.0,
 1861051: 4914.0,
 1861052: 4990.0,
 1861053: 4858.0,
 1861054: 4814.0,
 1861055: 4703.0,
 1861056: 4886.0,
 1861057: 5110.0,
 1861058: 5124.0,
 1861059: 5137.0,
 1861060: 5141.0,
 1861061: 5156.0,
 1861062: 5304.0,
 1861063: 5275.0,
 1861064: 5299.0,
 1861065: 5319.0,
 1861066: 5289.0,
 1861067: 5349.0,
 1861068: 5271.0,
 1861069: 5270.0,
 1861070: 5304.0,
 1861071: 5319.0,
 1861072: 5314.0,
 1861073: 5369.0,
 1861074: 5374.0,
 1861075: 5369.0,
 1861076: 5313.0,
 1861077: 5284.0,
 1861078: 5064.0,
 1861079: 5052.0,
 1861080: 4913.0,
 1861081: 4894.0,
 1861082: 4821.0,
 1861083: 4745.0,
 1861084: 4894.0,
 1861085: 4856.0,
 1861086: 4828.0,
 1861087: 4876.0,
 1861088: 4851.0,
 1861089: 4872.0,
 1861090: 4867.0,
 1861091: 4938.0,
 1861092: 4925.0,
 1861093: 5172.0,
 1861094: 5233.0,
 1861095: 4979.0,
 1861096: 4745.0,
 1861097: 4821.0,
 1861098: 4734.0,
 1861099: 4713.0,
 1861100: 4678.0,
 1861101: 4713.0,
 1861102: 4622.0,
 1861103: 4984.0,
 1861104: 4996.0,
 1861105: 4912.0,
 1861106: 4919.0,
 1861107: 4821.0,
 1861108: 4848.0,
 1861109: 4841.0,
 1861110: 4823.0,
 1861111: 4905.0,
 1861112: 4870.0,
 1861113: 4973.0,
 1861114: 4969.0,
 1861115: 4952.0,
 1861116: 4689.0,
 1861117: 4669.0,
 1861118: 4640.0,
 1861119: 4560.0,
 1861120: 4349.0,
 1861121: 4374.0,
 1861122: 4287.0,
 1861123: 4280.0,
 1861124: 4411.0,
 1861125: 4261.0,
 1861126: 4294.0,
 1861127: 4369.0,
 1861128: 4332.0,
 1861129: 4342.0,
 1861130: 4323.0,
 1861131: 4427.0,
 1861132: 4244.0,
 1861133: 4063.0,
 1861134: 4131.0,
 1861135: 4259.0,
 1861136: 4322.0,
 1861137: 4274.0,
 1861138: 4221.0,
 1861139: 4379.0,
 1861140: 4413.0,
 1861141: 4473.0,
 1861142: 4457.0,
 1861143: 4651.0,
 1861144: 4671.0,
 1861145: 4811.0,
 1861146: 4821.0,
 1861147: 4904.0,
 1861148: 4940.0,
 1861149: 4928.0,
 1861150: 4956.0,
 1861151: 5195.0,
 1861152: 5210.0,
 1861153: 5364.0,
 1861154: 5334.0,
 1861155: 5331.0,
 1861156: 5304.0,
 1861157: 5248.0,
 1861158: 5259.0,
 1861159: 5279.0,
 1861160: 5207.0,
 1861161: 5207.0,
 1861162: 5210.0,
 1861163: 5149.0,
 1861164: 5138.0,
 1861165: 5156.0,
 1861166: 5276.0,
 1861167: 5492.0,
 1861168: 5356.0,
 1861169: 5899.0,
 1861170: 5985.0,
 1861171: 6160.0,
 1861172: 6185.0,
 1861173: 6079.0,
 1861174: 6236.0,
 1861175: 6223.0,
 1861176: 6325.0,
 1861177: 6236.0,
 1861178: 6191.0,
 1861179: 5781.0,
 1861180: 5760.0,
 1861181: 5837.0,
 1861182: 5825.0,
 1861183: 5910.0,
 1861184: 6036.0,
 1861185: 6224.0,
 1861186: 6178.0,
 1861187: 6057.0,
 1861188: 6039.0,
 1861189: 6048.0,
 1861190: 6050.0,
 1861191: 6132.0,
 1861192: 6298.0,
 1861193: 6521.0,
 1861194: 6665.0,
 1861195: 6645.0,
 1861196: 6629.0,
 1861197: 6602.0,
 1861198: 6603.0,
 1861199: 6780.0,
 1861200: 6678.0,
 1861201: 6683.0,
 1861202: 6721.0,
 1861203: 6627.0,
 1861204: 6498.0,
 1861205: 6668.0,
 1861206: 6567.0,
 1861207: 6558.0,
 1861208: 6550.0,
 1861209: 6544.0,
 1861210: 6330.0,
 1861211: 6356.0,
 1861212: 6433.0,
 1861213: 6337.0,
 1861214: 6262.0,
 1861215: 6114.0,
 1861216: 6057.0,
 1861217: 6011.0,
 1861218: 5955.0,
 1861219: 5704.0,
 1861220: 5725.0,
 1861221: 5693.0,
 1861222: 5548.0,
 1861223: 5572.0,
 1861224: 5690.0,
 1861225: 5695.0,
 1861226: 5874.0,
 1861227: 5706.0,
 1861228: 5717.0,
 1861229: 5587.0,
 1861230: 5603.0,
 1861231: 5577.0,
 1861232: 5543.0,
 1861233: 5535.0,
 1861234: 5513.0,
 1861235: 5540.0,
 1861236: 5506.0,
 1861237: 5499.0,
 1861238: 5476.0,
 1861239: 5507.0,
 1861240: 5508.0,
 1861241: 5485.0,
 1861242: 5361.0,
 1861243: 5344.0,
 1861244: 5272.0,
 1861245: 4738.0,
 1861246: 4668.0,
 1861247: 4577.0,
 1861248: 4674.0,
 1861249: 4719.0,
 1861250: 4919.0,
 1861251: 5214.0,
 1861252: 5493.0,
 1861253: 5535.0,
 1861254: 5578.0,
 1861255: 5799.0,
 1861256: 5860.0,
 1861257: 5760.0,
 1861258: 5655.0,
 1861259: 5661.0,
 1861260: 5637.0,
 1861261: 5413.0,
 1861262: 5368.0,
 1861263: 5828.0,
 1861264: 5828.0,
 1861265: 5974.0,
 1861266: 5951.0,
 1861267: 5868.0,
 1861268: 5817.0,
 1861269: 5668.0,
 1861270: 5529.0,
 1861271: 5498.0,
 1861272: 5598.0,
 1861273: 5702.0,
 1861274: 5610.0,
 1861275: 5720.0,
 1861276: 5724.0,
 1861277: 5899.0,
 1861278: 5963.0,
 1861279: 5963.0,
 1861280: 6045.0,
 1861281: 5926.0,
 1861282: 6047.0,
 1861283: 6450.0,
 1861284: 6492.0,
 1861285: 6581.0,
 1861286: 6580.0,
 1861287: 6764.0,
 1861288: 6733.0,
 1861289: 6782.0,
 1861290: 6827.0,
 1861291: 6848.0,
 1861292: 6857.0,
 1861293: 6843.0,
 1861294: 6846.0,
 1861295: 6815.0,
 1861296: 6738.0,
 1861297: 6731.0,
 1861298: 6733.0,
 1861299: 6525.0,
 1861300: 6528.0,
 1861301: 6741.0,
 1861302: 6595.0,
 1861303: 6481.0,
 1861304: 6460.0,
 1861305: 6477.0,
 1861306: 6481.0,
 1861307: 6472.0,
 1861308: 6476.0,
 1861309: 6463.0,
 1861310: 6464.0,
 1861311: 6374.0,
 1861312: 6391.0,
 1861313: 6387.0,
 1861314: 6364.0,
 1861315: 6502.0,
 1861316: 6550.0,
 1861317: 6519.0,
 1861318: 6539.0,
 1861319: 6397.0,
 1861320: 6419.0,
 1861321: 6391.0,
 1861322: 6341.0,
 1861323: 6572.0,
 1861324: 6479.0,
 1861325: 7432.0,
 1861326: 7156.0,
 1861327: 6844.0,
 1861328: 6483.0,
 1861329: 6592.0,
 1861330: 6585.0,
 1861331: 6445.0,
 1861332: 6529.0,
 1861333: 6841.0,
 1861334: 6927.0,
 1861335: 7272.0,
 1861336: 7160.0,
 1861337: 6885.0,
 1861338: 7409.0,
 1861339: 7407.0,
 1861340: 7319.0,
 1861341: 7622.0,
 1861342: 7600.0,
 1861343: 7690.0,
 1861344: 7624.0,
 1861345: 7669.0,
 1861346: 7662.0,
 1861347: 7783.0,
 1861348: 7868.0,
 1861349: 7917.0,
 1861350: 7936.0,
 1861351: 7829.0,
 1861352: 7651.0,
 1861353: 7572.0,
 1861354: 7482.0,
 1861355: 7486.0,
 1861356: 7472.0,
 1861357: 7495.0,
 1861358: 7389.0,
 1861359: 7035.0,
 1861360: 6963.0,
 1861361: 6916.0,
 1861362: 6658.0,
 1861363: 6573.0,
 1861364: 6557.0,
 1861365: 6551.0,
 1861366: 6504.0,
 1861367: 6688.0,
 1861368: 6676.0,
 1861369: 6662.0,
 1861370: 6667.0,
 1861371: 6693.0,
 1861372: 6704.0,
 1861373: 6729.0,
 1861374: 6727.0,
 1861375: 6749.0,
 1861376: 6760.0,
 1861377: 6622.0,
 1861378: 6697.0,
 1861379: 6738.0,
 1861380: 6872.0,
 1861381: 7012.0,
 1861382: 7071.0,
 1861383: 7150.0,
 1861384: 7188.0,
 1861385: 7206.0,
 1861386: 7274.0,
 1861387: 7334.0,
 1861388: 7418.0,
 1861389: 7393.0,
 1861390: 7405.0,
 1861391: 7293.0,
 1861392: 7268.0,
 1861393: 7245.0,
 1861394: 7217.0,
 1861395: 7165.0,
 1861396: 7160.0,
 1861397: 7169.0,
 1861398: 6999.0,
 1861399: 6696.0,
 1861400: 6640.0,
 1861401: 5818.0,
 1861402: 5749.0,
 1861403: 5735.0,
 1861404: 5475.0,
 1861405: 5465.0,
 1861406: 5466.0,
 1861407: 5415.0,
 1861408: 5330.0,
 1861409: 5094.0,
 1861410: 5196.0,
 1861411: 4849.0,
 1861412: 4791.0,
 1861413: 4525.0,
 1861414: 4125.0,
 1861415: 3839.0,
 1861416: 3730.0,
 1861417: 3650.0,
 1861418: 3585.0,
 1861419: 3620.0,
 1861420: 3775.0,
 1861421: 4115.0,
 1861422: 4204.0,
 1861423: 5949.0,
 1861424: 5937.0,
 1861425: 5874.0,
 1861426: 5744.0,
 1861427: 5751.0,
 1861428: 6594.0,
 1861429: 6619.0,
 1861430: 6656.0,
 1861431: 6657.0,
 1861432: 6591.0,
 1861433: 6528.0,
 1861434: 6635.0,
 1861435: 6652.0,
 1861436: 6644.0,
 1861437: 6641.0,
 1861438: 6637.0,
 1861439: 6611.0,
 1861440: 6674.0,
 1861441: 6718.0,
 1861442: 6724.0,
 1861443: 6555.0,
 1861444: 6578.0,
 1861445: 7098.0,
 1861446: 7103.0,
 1861447: 7124.0,
 1861448: 7311.0,
 1861449: 7337.0,
 1861450: 7349.0,
 1861451: 7732.0,
 1861452: 7936.0,
 1861453: 7912.0,
 1861454: 7676.0,
 1861455: 7662.0,
 1861456: 7583.0,
 1861457: 7415.0,
 1861458: 7429.0,
 1861459: 7426.0,
 1861460: 7430.0,
 1861461: 7338.0,
 1861462: 7278.0,
 1861463: 7301.0,
 1861464: 7350.0,
 1861465: 7348.0,
 1861466: 7361.0,
 1861467: 7296.0,
 1861468: 7351.0,
 1861469: 7391.0,
 1861470: 7492.0,
 1861471: 7497.0,
 1861472: 7550.0,
 1861473: 7505.0,
 1861474: 7531.0,
 1861475: 7454.0,
 1861476: 7431.0,
 1861477: 7424.0,
 1861478: 7410.0,
 1861479: 7430.0,
 1861480: 7494.0,
 1861481: 7656.0,
 1861482: 7696.0,
 1861483: 7696.0,
 1861484: 7822.0,
 1861485: 7771.0,
 1861486: 7584.0,
 1861487: 7606.0,
 1861488: 7604.0,
 1861489: 7620.0,
 1861490: 7636.0,
 1861491: 7678.0,
 1861492: 7659.0,
 1861493: 7612.0,
 1861494: 7641.0,
 1861495: 7619.0,
 1861496: 7425.0,
 1861497: 6969.0,
 1861498: 6889.0,
 1861499: 5156.0,
 1861500: 5057.0,
 1861501: 5124.0,
 1861502: 5095.0,
 1861503: 4491.0,
 1861504: 4287.0,
 1861505: 4321.0,
 1861506: 4257.0,
 1861507: 4234.0,
 1861508: 4220.0,
 1861509: 4217.0,
 1861510: 4213.0,
 1861511: 4203.0,
 1861512: 4183.0,
 1861513: 4147.0,
 1861514: 4128.0,
 1861515: 4159.0,
 1861516: 4099.0,
 1861517: 4053.0,
 1861518: 4046.0,
 1861519: 3999.0,
 1861520: 4004.0,
 1861521: 3470.0,
 1861522: 3477.0,
 1861523: 3439.0,
 1861524: 3219.0,
 1861525: 3218.0,
 1861526: 3183.0,
 1861527: 2955.0,
 1861528: 2754.0,
 1861529: 2704.0,
 1861530: 2725.0,
 1861531: 2744.0,
 1861532: 2720.0,
 1861533: 2737.0,
 1861534: 2691.0,
 1861535: 2797.0,
 1861536: 2865.0,
 1861537: 3013.0,
 1861538: 3179.0,
 1861539: 3045.0,
 1861540: 3036.0,
 1861541: 3061.0,
 1861542: 3090.0,
 1861543: 3180.0,
 1861544: 3127.0,
 1861545: 3143.0,
 1861546: 3072.0,
 1861547: 3059.0,
 1861548: 3339.0,
 1861549: 3364.0,
 1861550: 3344.0,
 1861551: 3359.0,
 1861552: 3388.0,
 1861553: 3464.0,
 1861554: 3466.0,
 1861555: 3392.0,
 1861556: 3440.0,
 1861557: 3328.0,
 1861558: 3183.0,
 1861559: 3187.0,
 1861560: 3151.0,
 1861561: 3136.0,
 1861562: 3265.0,
 1861563: 3255.0,
 1861564: 3657.0,
 1861565: 3689.0,
 1861566: 3763.0,
 1861567: 3778.0,
 1861568: 3770.0,
 1861569: 3923.0,
 1861570: 3883.0,
 1861571: 3884.0,
 1861572: 3903.0,
 1861573: 3902.0,
 1861574: 3911.0,
 1861575: 3863.0,
 1861576: 3772.0,
 1861577: 3733.0,
 1861578: 3749.0,
 1861579: 3805.0,
 1861580: 3838.0,
 1861581: 3811.0,
 1861582: 3823.0,
 1861583: 3828.0,
 1861584: 3830.0,
 1861585: 3841.0,
 1861586: 3745.0,
 1861587: 3756.0,
 1861588: 3789.0,
 1861589: 3727.0,
 1861590: 3757.0,
 1861591: 3782.0,
 1861592: 3804.0,
 1861593: 3808.0,
 1861594: 3823.0,
 1861595: 3833.0,
 1861596: 3825.0,
 1861597: 3824.0,
 1861598: 3813.0,
 1861599: 3791.0,
 1861600: 3774.0,
 1861601: 3741.0,
 1861602: 3730.0,
 1861603: 3668.0,
 1861604: 3638.0,
 1861605: 3631.0,
 1861606: 3608.0,
 1861607: 3581.0,
 1861608: 3572.0,
 1861609: 3533.0,
 1861610: 3557.0,
 1861611: 3385.0,
 1861612: 3305.0,
 1861613: 3150.0,
 1861614: 2947.0,
 1861615: 2945.0,
 1861616: 2939.0,
 1861617: 2844.0,
 1861618: 2862.0,
 1861619: 2768.0,
 1861620: 2749.0,
 1861621: 2704.0,
 1861622: 2655.0,
 1861623: 2592.0,
 1861624: 2306.0,
 1861625: 2300.0,
 1861626: 2334.0,
 1861627: 2314.0,
 1861628: 2333.0,
 1861629: 2259.0,
 1861630: 2233.0,
 1861631: 2154.0,
 1861632: 2130.0,
 1861633: 2120.0,
 1861634: 2097.0,
 1861635: 2090.0,
 1861636: 2057.0,
 1861637: 2016.0,
 1861638: 1926.0,
 1861639: 1925.0,
 1861640: 1503.0,
 1861641: 1396.0,
 1861642: 1305.0,
 1861643: 1215.0,
 1861644: 1141.0,
 1861645: 1133.0,
 1861646: 1163.0,
 1861647: 1144.0,
 1861648: 1126.0,
 1861649: 1110.0,
 1861650: 960.0,
 1861651: 997.0,
 1861652: 1025.0,
 1861653: 1052.0,
 1861654: 1000.0,
 1861655: 929.0,
 1861656: 931.0,
 1861657: 927.0,
 1861658: 912.0,
 1861659: 963.0,
 1861660: 969.0,
 1861661: 977.0,
 1861662: 1015.0,
 1861663: 1005.0,
 1861664: 965.0,
 1861665: 998.0,
 1861666: 1081.0,
 1861667: 1064.0,
 1861668: 1098.0,
 1861669: 1080.0,
 1861670: 1359.0,
 1861671: 1334.0,
 1861672: 1410.0,
 1861673: 1673.0,
 1861674: 1677.0,
 1861675: 1699.0,
 1861676: 1696.0,
 1861677: 1942.0,
 1861678: 1921.0,
 1861679: 1908.0,
 1861680: 2168.0,
 1861681: 2180.0,
 1861682: 2181.0,
 1861683: 2273.0,
 1861684: 2262.0,
 1861685: 2252.0,
 1861686: 2412.0,
 1861687: 2474.0,
 1861688: 2447.0,
 1861689: 3818.0,
 1861690: 3819.0,
 1861691: 5533.0,
 1861692: 5537.0,
 1861693: 5539.0,
 1861694: 5520.0,
 1861695: 5530.0,
 1861696: 5530.0,
 1861697: 5709.0,
 1861698: 5733.0,
 1861699: 5853.0,
 1861700: 5899.0,
 1861701: 5949.0,
 1861702: 6006.0,
 1861703: 6141.0,
 1861704: 6109.0,
 1861705: 6114.0,
 1861706: 6114.0,
 1861707: 6111.0,
 1861708: 6121.0,
 1861709: 6222.0,
 1861710: 6266.0,
 1861711: 6266.0,
 1861712: 6292.0,
 1861713: 6276.0,
 1861714: 6270.0,
 1861715: 6265.0,
 1861716: 6264.0,
 1861717: 6258.0,
 1861718: 6258.0,
 1861719: 6258.0,
 1861720: 6251.0,
 1861721: 6244.0,
 1861722: 6237.0,
 1861723: 6238.0,
 1861724: 6238.0,
 1861725: 6238.0,
 1861726: 6249.0,
 1861727: 6170.0,
 1861728: 6126.0,
 1861729: 6073.0,
 1861730: 6059.0,
 1861731: 6053.0,
 1861732: 6096.0,
 1861733: 6101.0,
 1861734: 6063.0,
 1861735: 6058.0,
 1861736: 6057.0,
 1861737: 6032.0,
 1861738: 5977.0,
 1861739: 5962.0,
 1861740: 5942.0,
 1861741: 5919.0,
 1861742: 5840.0,
 1861743: 5833.0,
 1861744: 5801.0,
 1861745: 5624.0,
 1861746: 5537.0,
 1861747: 5470.0,
 1861748: 5451.0,
 1861749: 5204.0,
 1861750: 5192.0,
 1861751: 5157.0,
 1861752: 4953.0,
 1861753: 4894.0,
 1861754: 4876.0,
 1861755: 4729.0,
 1861756: 4624.0,
 1861757: 4613.0,
 1861758: 4610.0,
 1861759: 4516.0,
 1861760: 4505.0,
 1861761: 4495.0,
 1861762: 4345.0,
 1861763: 4271.0,
 1861764: 3693.0,
 1861765: 2886.0,
 1861766: 2560.0,
 1861767: 1172.0,
 1861768: 1168.0,
 1861769: 1133.0,
 1861770: 1010.0,
 1861771: 975.0,
 1861772: 956.0,
 1861773: 951.0,
 1861774: 912.0,
 1861775: 789.0,
 1861776: 741.0,
 1861777: 654.0,
 1861778: 593.0,
 1861779: 456.0,
 1861780: 455.0,
 1861781: 450.0,
 1861782: 445.0,
 1861783: 441.0,
 1861784: 416.0,
 1861785: 339.0,
 1861786: 296.0,
 1861787: 274.0,
 1861788: 268.0,
 1861789: 268.0,
 1861790: 268.0}

In [ ]: