Piroxicam
Everything that changed this flow. Back to the flow
fd33b45f-f89e-41ad-a0bf-b699b63ec03a
By field
13 fields| Field | Changes | Written by | Latest note |
|---|---|---|---|
| properties | 5 | enrich_references, normalise_property_values, opsin_iupac, rdkit_post_consensus, rdkit_pre_consensus | typed the way the ontology types it |
| altLabel | 3 | chebi_altlabels, consensus_match, strip_catalogue_altlabels | Removed 3 catalogue altLabel value(s): 'CHF 1251' (grade code), 'CP 16171' (grade code), 'NSC 666076' (registry code) |
| prefLabel | 2 | bootstrap_labels, normalize_name_case | Title-cased words without internal capitals (preserved words with uppercase letters beyond the first character) |
| cas_match_labels | 1 | consensus_match | group_key=piroxicam||dimension=Environmental > media=Ground > geography=Unknown; group_sources=['chebi', 'ec_inventory', 'pubchem']; cas_sources={'36322-90-4': ['chebi', 'ec_inventory', 'pubchem']}; assigned CAS labels from group consensus; object_uuid=fo-8ac6a044ba290053: {'36322-90-4': 'exactMatch'} |
| concept_associations | 1 | carry_associations_onto_flows | associations resolved on the elementary layer |
| context | 1 | default_context_mapping | Mapped from context mapping for source=EF 3.1, source context Emissions > Emissions to soil > Emissions to non-agricultural soil |
| context_iri | 1 | default_context_mapping | Mapped from context mapping for source=EF 3.1, source context Emissions > Emissions to soil > Emissions to non-agricultural soil |
| name | 1 | bootstrap_labels | Purged legacy name field to enforce prefLabel usage |
| references | 1 | enrich_references | Added references with provenance; cas_numbers=['36322-90-4']; matched_chebi_ids=['http://purl.obolibrary.org/obo/CHEBI_8249']; candidate_pubchem_cids=[4201, 54676228]; selected_pubchem_cids=[54676228]; formula_similarity_expected=[]; pubchem_selection_rule=curated_cas_then_formula_similarity_then_prefer_chebi_aligned_when_unambiguous_else_keep_all_cas_matches; single_cas_commonchem_link=yes |
| skos_definition | 1 | enrich_references | Merged ChEBI/PubChem definitions into skos:definition |
| synonyms | 1 | bootstrap_labels | Removed legacy synonyms field in favor of structured labels |
| types | 1 | link_flows_to_their_substance | the substance's answer, copied onto its flow |
| unit_iri | 1 | unit_normalization | Unit IRI set from normalization of 'kg' |
Where several steps wrote one field, the last one won — and the log below shows the sequence.
Changes
20| # | Step | Field | From | To | Why |
|---|---|---|---|---|---|
| 17,273 | bootstrap_labels | prefLabel | — | [{"@value":"piroxicam","@language":"en","source":{"prov:wasGeneratedBy":"bootstrap_labels","prov:wasAttributedTo":"cons… | Bootstrapped prefLabel from legacy name field |
| 17,274 | bootstrap_labels | name | piroxicam | — | Purged legacy name field to enforce prefLabel usage |
| 17,275 | bootstrap_labels | synonyms | ["organic","piroxicam"] | [] | Removed legacy synonyms field in favor of structured labels |
| 201,836 | default_context_mapping | context | — | {"dimension":"Environmental","media":"Ground","geography":"Non-agricultural"} | Mapped from context mapping for source=EF 3.1, source context Emissions > Emissions to soil > Emissions to non-agricultural soil |
| 201,837 | default_context_mapping | context_iri | — | https://vocab.brightway.one/flow-contexts/envi-grou-noag | Mapped from context mapping for source=EF 3.1, source context Emissions > Emissions to soil > Emissions to non-agricultural soil |
| 219,000 | unit_normalization | unit_iri | — | https://vocab.brightway.one/units/unit/KiloGM | Unit IRI set from normalization of 'kg' |
| 225,043 | normalize_name_case | prefLabel | [{"@value":"piroxicam","@language":"en","source":{"prov:wasGeneratedBy":"bootstrap_labels","prov:wasAttributedTo":"cons… | [{"@value":"Piroxicam","@language":"en","source":{"prov:wasGeneratedBy":"bootstrap_labels","prov:wasAttributedTo":"cons… | Title-cased words without internal capitals (preserved words with uppercase letters beyond the first character) |
| 243,379 | enrich_references | properties | {} | {"https://w3id.org/chemrof/molecular_formula":{"@id":"https://w3id.org/chemrof/molecular_formula","@value":["C15H13N3O4… | Added ChEBI/PubChem properties (chebi_ids=1, pubchem_cids=1) |
| 243,380 | enrich_references | skos_definition | — | [{"@value":"A monocarboxylic acid amide resulting from the formal condensation of the carboxy group of 4-hydroxy-2-meth… | Merged ChEBI/PubChem definitions into skos:definition |
| 243,381 | enrich_references | references | [] | [{"@id":"drugcentral:2210","provenance":{"prov:wasGeneratedBy":"enrich_references.chebi_xrefs","prov:wasAttributedTo":"… | Added references with provenance; cas_numbers=['36322-90-4']; matched_chebi_ids=['http://purl.obolibrary.org/obo/CHEBI_8249']; candidate_pubchem_cids=[4201, 54676228]; selected_pubchem_cids=[54676228]; formula_similarity_expected=[]; pubchem_selection_rule=curated_cas_then_formula_similarity_then_prefer_chebi_aligned_when_unambiguous_else_keep_all_cas_matches; single_cas_commonchem_link=yes |
| 252,982 | rdkit_pre_consensus | properties | {"https://w3id.org/chemrof/molecular_formula":{"@id":"https://w3id.org/chemrof/molecular_formula","@value":["C15H13N3O4… | {"https://w3id.org/chemrof/molecular_formula":{"@id":"https://w3id.org/chemrof/molecular_formula","@value":["C15H13N3O4… | rdkit_pre_consensus from 'CN1C(=C(C2=CC=CC=C2S1(=O)=O)O)C(=O)NC3=CC=CC=N3'; added: monoisotopic_mass |
| 256,650 | chebi_altlabels | altLabel | [] | [{"@value":"4-Hydroxy-2-methyl-N-(2-pyridyl)-2H-1,2-benzothiazin-3-caboxyamid-1,1-dioxid","@language":"en","source":{"p… | Added 6 ChEBI synonym(s) as altLabel from 1 linked ChEBI record(s) |
| 270,777 | consensus_match | altLabel | [{"@value":"4-Hydroxy-2-methyl-N-(2-pyridyl)-2H-1,2-benzothiazin-3-caboxyamid-1,1-dioxid","@language":"en","source":{"p… | [{"@value":"4-Hydroxy-2-methyl-N-(2-pyridyl)-2H-1,2-benzothiazin-3-caboxyamid-1,1-dioxid","@language":"en","source":{"p… | group_key=piroxicam||dimension=Environmental > media=Ground > geography=Unknown; cas=36322-90-4; added Common Chemistry CAS names as altLabel: 2<em>H</em>-1,2-Benzothiazine-3-carboxamide, 4-hydroxy-2-methyl-<em>N</em>-2-pyridinyl-, 1,1-dioxide, 4-Hydroxy-2-methyl-<em>N</em>-(2-pyridyl)-2<em>H</em>-1,2-benzothiazine-3-carboxamide 1,1-dioxide, Artroxicam, Baxo, Bruxicam, CHF 1251, CP 16171, Caliment, Dispercam, Doblexan, Dolibid, Erazon, Felden gel, Feldene Melt, Feldene Zydis, Feldoral, Feledene, Feloxin, Felvin 20, Felxicam, Flogobene, Flogosan, Geldene, Improntal, Inflacin, Larapam, Laxidene, Maxvin, MeSH ID: D010894, Murupe, NSC 666076, Neoxicam, Nesprex-DT, Nkoyo piroxicam, Pirkam, Piroflex, Piroftal, Piroxidine, Piroxitas-DT, Pixicam, Reudene, Rheugesic, Riacen, Roxicam, Roxiden, Sasulen, Solocalm, Uphaxicam, Zunden; object_uuid=fo-8ac6a044ba290053 |
| 270,778 | consensus_match | cas_match_labels | — | {"36322-90-4":"exactMatch"} | group_key=piroxicam||dimension=Environmental > media=Ground > geography=Unknown; group_sources=['chebi', 'ec_inventory', 'pubchem']; cas_sources={'36322-90-4': ['chebi', 'ec_inventory', 'pubchem']}; assigned CAS labels from group consensus; object_uuid=fo-8ac6a044ba290053: {'36322-90-4': 'exactMatch'} |
| 278,185 | opsin_iupac | properties | {"https://w3id.org/chemrof/molecular_formula":{"@id":"https://w3id.org/chemrof/molecular_formula","@value":["C15H13N3O4… | {"https://w3id.org/chemrof/molecular_formula":{"@id":"https://w3id.org/chemrof/molecular_formula","@value":["C15H13N3O4… | opsin_iupac: set authoritative IUPAC name, SMILES, InChI from '4-hydroxy-2-methyl-N-pyridin-2-yl-2H-1,2-benzothiazine-3-carboxamide 1,1-dioxide' |
| 284,927 | rdkit_post_consensus | properties | {"https://w3id.org/chemrof/molecular_formula":{"@id":"https://w3id.org/chemrof/molecular_formula","@value":["C15H13N3O4… | {"https://w3id.org/chemrof/molecular_formula":{"@id":"https://w3id.org/chemrof/molecular_formula","@value":["C15H13N3O4… | rdkit_post_consensus from 'CN1C(C(=O)Nc2ccccn2)=C(O)c2ccccc2S1(=O)=O'; confirmed: smiles_string, inchi2d_string, inchi2d_key_string, molecular_formula, molecular_mass, monoisotopic_mass |
| 290,754 | strip_catalogue_altlabels | altLabel | [{"@value":"4-Hydroxy-2-methyl-N-(2-pyridyl)-2H-1,2-benzothiazin-3-caboxyamid-1,1-dioxid","@language":"en","source":{"p… | [{"@value":"4-Hydroxy-2-methyl-N-(2-pyridyl)-2H-1,2-benzothiazin-3-caboxyamid-1,1-dioxid","@language":"en","source":{"p… | Removed 3 catalogue altLabel value(s): 'CHF 1251' (grade code), 'CP 16171' (grade code), 'NSC 666076' (registry code) |
| 381,952 | carry_associations_onto_flows | concept_associations | [] | [{"@type":"xkos:ConceptAssociation","xkos:sourceConcept":{"@id":"https://vocab.brightway.one/ef/3.1/flow/fd33b45f-f89e-… | associations resolved on the elementary layer |
| 392,538 | normalise_property_values | properties | {"https://w3id.org/chemrof/molecular_formula":{"@id":"https://w3id.org/chemrof/molecular_formula","@value":["C15H13N3O4… | {"https://w3id.org/chemrof/molecular_formula":{"@id":"https://w3id.org/chemrof/molecular_formula","@value":["C15H13N3O4… | typed the way the ontology types it |
| 401,062 | link_flows_to_their_substance | types | — | ["https://w3id.org/chemrof/NeutralMolecule"] | the substance's answer, copied onto its flow |
PROV-O trail
20 activitiesOne activity per change: which version of the flow it consumed, and which it produced. The values are on the change with the same number — stored once, not twice.
| Activity | Field | Agent | Used | Generated |
|---|---|---|---|---|
| ef:activity/change/20260821T1554374006150000/17273 | prefLabel | ef:agent/bootstrap_labels | ef:flow/fd33b45f-f89e-41ad-a0bf-b699b63ec03a/v0 | ef:flow/fd33b45f-f89e-41ad-a0bf-b699b63ec03a/v1 |
| ef:activity/change/20260821T1554374006150000/17274 | name | ef:agent/bootstrap_labels | ef:flow/fd33b45f-f89e-41ad-a0bf-b699b63ec03a/v1 | ef:flow/fd33b45f-f89e-41ad-a0bf-b699b63ec03a/v2 |
| ef:activity/change/20260821T1554374006150000/17275 | synonyms | ef:agent/bootstrap_labels | ef:flow/fd33b45f-f89e-41ad-a0bf-b699b63ec03a/v2 | ef:flow/fd33b45f-f89e-41ad-a0bf-b699b63ec03a/v3 |
| ef:activity/change/20260821T1554374006150000/201836 | context | ef:agent/default_context_mapping | ef:flow/fd33b45f-f89e-41ad-a0bf-b699b63ec03a/v3 | ef:flow/fd33b45f-f89e-41ad-a0bf-b699b63ec03a/v4 |
| ef:activity/change/20260821T1554374006150000/201837 | context_iri | ef:agent/default_context_mapping | ef:flow/fd33b45f-f89e-41ad-a0bf-b699b63ec03a/v4 | ef:flow/fd33b45f-f89e-41ad-a0bf-b699b63ec03a/v5 |
| ef:activity/change/20260821T1554374006150000/219000 | unit_iri | ef:agent/unit_normalization | ef:flow/fd33b45f-f89e-41ad-a0bf-b699b63ec03a/v5 | ef:flow/fd33b45f-f89e-41ad-a0bf-b699b63ec03a/v6 |
| ef:activity/change/20260821T1554374006150000/225043 | prefLabel | ef:agent/normalize_name_case | ef:flow/fd33b45f-f89e-41ad-a0bf-b699b63ec03a/v6 | ef:flow/fd33b45f-f89e-41ad-a0bf-b699b63ec03a/v7 |
| ef:activity/change/20260821T1554374006150000/243379 | properties | ef:agent/enrich_references | ef:flow/fd33b45f-f89e-41ad-a0bf-b699b63ec03a/v7 | ef:flow/fd33b45f-f89e-41ad-a0bf-b699b63ec03a/v8 |
| ef:activity/change/20260821T1554374006150000/243380 | skos_definition | ef:agent/enrich_references | ef:flow/fd33b45f-f89e-41ad-a0bf-b699b63ec03a/v8 | ef:flow/fd33b45f-f89e-41ad-a0bf-b699b63ec03a/v9 |
| ef:activity/change/20260821T1554374006150000/243381 | references | ef:agent/enrich_references | ef:flow/fd33b45f-f89e-41ad-a0bf-b699b63ec03a/v9 | ef:flow/fd33b45f-f89e-41ad-a0bf-b699b63ec03a/v10 |
| ef:activity/change/20260821T1554374006150000/252982 | properties | ef:agent/rdkit_pre_consensus | ef:flow/fd33b45f-f89e-41ad-a0bf-b699b63ec03a/v10 | ef:flow/fd33b45f-f89e-41ad-a0bf-b699b63ec03a/v11 |
| ef:activity/change/20260821T1554374006150000/256650 | altLabel | ef:agent/chebi_altlabels | ef:flow/fd33b45f-f89e-41ad-a0bf-b699b63ec03a/v11 | ef:flow/fd33b45f-f89e-41ad-a0bf-b699b63ec03a/v12 |
| ef:activity/change/20260821T1554374006150000/270777 | altLabel | ef:agent/consensus_match | ef:flow/fd33b45f-f89e-41ad-a0bf-b699b63ec03a/v12 | ef:flow/fd33b45f-f89e-41ad-a0bf-b699b63ec03a/v13 |
| ef:activity/change/20260821T1554374006150000/270778 | cas_match_labels | ef:agent/consensus_match | ef:flow/fd33b45f-f89e-41ad-a0bf-b699b63ec03a/v13 | ef:flow/fd33b45f-f89e-41ad-a0bf-b699b63ec03a/v14 |
| ef:activity/change/20260821T1554374006150000/278185 | properties | ef:agent/opsin_iupac | ef:flow/fd33b45f-f89e-41ad-a0bf-b699b63ec03a/v14 | ef:flow/fd33b45f-f89e-41ad-a0bf-b699b63ec03a/v15 |
| ef:activity/change/20260821T1554374006150000/284927 | properties | ef:agent/rdkit_post_consensus | ef:flow/fd33b45f-f89e-41ad-a0bf-b699b63ec03a/v15 | ef:flow/fd33b45f-f89e-41ad-a0bf-b699b63ec03a/v16 |
| ef:activity/change/20260821T1554374006150000/290754 | altLabel | ef:agent/strip_catalogue_altlabels | ef:flow/fd33b45f-f89e-41ad-a0bf-b699b63ec03a/v16 | ef:flow/fd33b45f-f89e-41ad-a0bf-b699b63ec03a/v17 |
| ef:activity/change/20260821T1554374006150000/381952 | concept_associations | ef:agent/carry_associations_onto_flows | ef:flow/fd33b45f-f89e-41ad-a0bf-b699b63ec03a/v17 | ef:flow/fd33b45f-f89e-41ad-a0bf-b699b63ec03a/v18 |
| ef:activity/change/20260821T1554374006150000/392538 | properties | ef:agent/normalise_property_values | ef:flow/fd33b45f-f89e-41ad-a0bf-b699b63ec03a/v18 | ef:flow/fd33b45f-f89e-41ad-a0bf-b699b63ec03a/v19 |
| ef:activity/change/20260821T1554374006150000/401062 | types | ef:agent/link_flows_to_their_substance | ef:flow/fd33b45f-f89e-41ad-a0bf-b699b63ec03a/v19 | ef:flow/fd33b45f-f89e-41ad-a0bf-b699b63ec03a/v20 |