Query Methods
Query the AOP tables.
- aop2db.aop.query.get_aops(verbose=False)[source]
Get AOP rows.
NOTE: AOP has no links to Taxonomy.
- Parameters
verbose (bool) – If True, prints the SQL statement used to query the database.
- Return type
pandas DataFrame
- Return type
DataFrame
- aop2db.aop.query.get_bio_actions(verbose=False)[source]
Get table of biological actions.
- Parameters
verbose (bool) – If True, prints the SQL statement used to query the database.
- Return type
pandas DataFrame
- Return type
DataFrame
- aop2db.aop.query.get_bio_events(verbose=False)[source]
Get Biological Events rows with KeyEvent foreign key.
- Parameters
verbose (bool) – If True, prints the SQL statement used to query the database.
- Return type
pandas DataFrame
- Return type
DataFrame
- aop2db.aop.query.get_bio_objects(verbose=False)[source]
Get table of biological objects.
- Parameters
verbose (bool) – If True, prints the SQL statement used to query the database.
- Return type
pandas DataFrame
- Return type
DataFrame
- aop2db.aop.query.get_bio_processes(verbose=False)[source]
Get table of biological processes.
- Parameters
verbose (bool) – If True, prints the SQL statement used to query the database.
- Return type
pandas DataFrame
- Return type
DataFrame
- aop2db.aop.query.get_cell_terms(verbose=False)[source]
Get table of cell terms.
- Parameters
verbose (bool) – If True, prints the SQL statement used to query the database.
- Return type
pandas DataFrame
- Return type
DataFrame
- aop2db.aop.query.get_chemicals(synonyms=False, verbose=False)[source]
Get table of chemicals.
- Parameters
synonyms (bool) – If True, expands the DataFrame to include synonyms for each chemical.
verbose (bool) – If True, prints the SQL statement used to query the database.
- Return type
pandas DataFrame
- Return type
DataFrame
- aop2db.aop.query.get_key_event_relationships(species=None, verbose=False)[source]
Get a table of Key Event Relationships.
- Parameters
species (int) – The taxonomic ID of a species. Restricts the output to only that species e.g. 9606 for humans.
verbose (bool) – If True, prints the SQL statement used to query the database.
- Return type
pandas DataFrame
- Return type
DataFrame
- aop2db.aop.query.get_key_events(bio_events=False, stressors=False, detailed=False, species=None, verbose=False)[source]
Get table of key events.
- Parameters
bio_events (bool) – If True, produces a detailed DataFrame with extra information on joined bio events.
stressors (bool) – If True, produces a detailed DataFrame with extra information on joined stressors.
detailed (bool) – If True, produces a detailed DataFrame with the table IDs for AOPs, stressors, and bio events..
species (int) – The taxonomic ID of a species. Restricts the output to only that species e.g. 9606 for humans.
verbose (bool) – If True, prints the SQL statement used to query the database.
- Return type
pandas DataFrame
- Return type
DataFrame
- aop2db.aop.query.get_life_stages(verbose=False)[source]
Get table of life stages.
- Parameters
verbose (bool) – If True, prints the SQL statement used to query the database.
- Return type
pandas DataFrame
- Return type
DataFrame
- aop2db.aop.query.get_organ_terms(verbose=False)[source]
Get table of organ terms.
- Parameters
verbose (bool) – If True, prints the SQL statement used to query the database.
- Return type
pandas DataFrame
- Return type
DataFrame
- aop2db.aop.query.get_sexes(verbose=False)[source]
Get table of life stages.
- Parameters
verbose (bool) – If True, prints the SQL statement used to query the database.
- Return type
pandas DataFrame
- Return type
DataFrame