Citric Acid
Everything that changed this substance, across every flow that resolves to it. Back to the substance
fo-0ea1a43a8ab28905
Changes
57| # | Step | Field | From | To | Why |
|---|---|---|---|---|---|
| 22,209 | bootstrap_labels | prefLabel | — | [{"@value":"citric acid","@language":"en","source":{"prov:wasGeneratedBy":"bootstrap_labels","prov:wasAttributedTo":"br… | Bootstrapped prefLabel from legacy name field |
| 22,210 | bootstrap_labels | name | citric acid | — | Purged legacy name field to enforce prefLabel usage |
| 22,211 | bootstrap_labels | synonyms | [".beta.-Hydroxytricarballylic acid","1,2,3-PROPANETRICARBOXYLIC ACID,2-HYDROXY (CITRIC ACID)","1,2,3-Propanetricarboxy… | [] | Removed legacy synonyms field in favor of structured labels |
| 23,453 | bootstrap_labels | synonyms | ["citricacid","citric acid","1,2,3-propanetricarboxylic acid, 2-hydroxy-","3-carboxy-3-hydroxy-pentanedioic acid","2-hy… | [] | Removed legacy synonyms field in favor of structured labels |
| 83,181 | default_context_mapping | context | — | {"dimension":"Environmental","media":"Water","water_body":"Surface water"} | Mapped from context mapping for source=EF 3.1, source context Emissions > Emissions to water > Emissions to fresh water |
| 83,182 | default_context_mapping | context_iri | — | https://vocab.brightway.one/flow-contexts/envi-wate-suwa | Mapped from context mapping for source=EF 3.1, source context Emissions > Emissions to water > Emissions to fresh water |
| 99,639 | default_context_mapping | context | — | {"dimension":"Environmental","media":"Ground","geography":"Agricultural"} | Mapped from context mapping for source=EF 3.1, source context Emissions > Emissions to soil > Emissions to agricultural soil |
| 99,640 | default_context_mapping | context_iri | — | https://vocab.brightway.one/flow-contexts/envi-grou-agri | Mapped from context mapping for source=EF 3.1, source context Emissions > Emissions to soil > Emissions to agricultural soil |
| 109,979 | 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 |
| 109,980 | 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 |
| 110,761 | default_context_mapping | context | — | {"dimension":"Environmental","media":"Air","strata":"Aircraft cruise height"} | Mapped from context mapping for source=EF 3.1, source context Emissions > Emissions to air > Emissions to lower stratosphere and upper troposphere |
| 110,762 | default_context_mapping | context_iri | — | https://vocab.brightway.one/flow-contexts/envi-air-aicrhe | Mapped from context mapping for source=EF 3.1, source context Emissions > Emissions to air > Emissions to lower stratosphere and upper troposphere |
| 111,963 | default_context_mapping | context | — | {"dimension":"Environmental","media":"Water","water_body":"Ocean"} | Mapped from context mapping for source=EF 3.1, source context Emissions > Emissions to water > Emissions to sea water |
| 111,964 | default_context_mapping | context_iri | — | https://vocab.brightway.one/flow-contexts/envi-wate-ocea | Mapped from context mapping for source=EF 3.1, source context Emissions > Emissions to water > Emissions to sea water |
| 115,325 | default_context_mapping | context | — | {"dimension":"Environmental","media":"Water","water_body":"Unknown"} | Mapped from context mapping for source=EF 3.1, source context Emissions > Emissions to water > Emissions to water, unspecified |
| 115,326 | default_context_mapping | context_iri | — | https://vocab.brightway.one/flow-contexts/envi-wate-unkn | Mapped from context mapping for source=EF 3.1, source context Emissions > Emissions to water > Emissions to water, unspecified |
| 117,519 | default_context_mapping | context | — | {"dimension":"Environmental","media":"Air","strata":"Medium stack, <150 meters","population_density":"Rural (<1000 peop… | Mapped from context mapping for source=EF 3.1, source context Emissions > Emissions to air > Emissions to non-urban air or from high stacks |
| 117,520 | default_context_mapping | context_iri | — | https://vocab.brightway.one/flow-contexts/envi-air-mest15me-ru10pesq | Mapped from context mapping for source=EF 3.1, source context Emissions > Emissions to air > Emissions to non-urban air or from high stacks |
| 121,665 | default_context_mapping | context | — | {"dimension":"Environmental","media":"Ground","geography":"Unknown"} | Mapped from context mapping for source=EF 3.1, source context Emissions > Emissions to soil > Emissions to soil, unspecified |
| 121,666 | default_context_mapping | context_iri | — | https://vocab.brightway.one/flow-contexts/envi-grou-unkn | Mapped from context mapping for source=EF 3.1, source context Emissions > Emissions to soil > Emissions to soil, unspecified |
| 122,071 | default_context_mapping | context | — | {"dimension":"Environmental","media":"Air","strata":"Ground level","population_density":"Urban (>1000 people/square mil… | Mapped from context mapping for source=EF 3.1, source context Emissions > Emissions to air > Emissions to urban air close to ground |
| 122,072 | default_context_mapping | context_iri | — | https://vocab.brightway.one/flow-contexts/envi-air-grle-ur10pesq | Mapped from context mapping for source=EF 3.1, source context Emissions > Emissions to air > Emissions to urban air close to ground |
| 128,775 | default_context_mapping | context | — | {"dimension":"Environmental","media":"Water","water_body":"Long-term"} | Mapped from context mapping for source=EF 3.1, source context Emissions > Emissions to water > Emissions to water, unspecified (long-term) |
| 128,776 | default_context_mapping | context_iri | — | https://vocab.brightway.one/flow-contexts/envi-wate-lote | Mapped from context mapping for source=EF 3.1, source context Emissions > Emissions to water > Emissions to water, unspecified (long-term) |
| 135,283 | default_context_mapping | context | — | {"dimension":"Environmental","media":"Air","strata":"Long-term"} | Mapped from context mapping for source=EF 3.1, source context Emissions > Emissions to air > Emissions to air, unspecified (long-term) |
| 135,284 | default_context_mapping | context_iri | — | https://vocab.brightway.one/flow-contexts/envi-air-lote | Mapped from context mapping for source=EF 3.1, source context Emissions > Emissions to air > Emissions to air, unspecified (long-term) |
| 152,355 | default_context_mapping | context | — | {"dimension":"Environmental","media":"Air","strata":"Unknown"} | Mapped from context mapping for source=EF 3.1, source context Emissions > Emissions to air > Emissions to air, unspecified |
| 152,356 | default_context_mapping | context_iri | — | https://vocab.brightway.one/flow-contexts/envi-air-unkn | Mapped from context mapping for source=EF 3.1, source context Emissions > Emissions to air > Emissions to air, unspecified |
| 154,677 | default_context_mapping | context | — | {"dimension":"Environmental","media":"Air","indoor":"Unknown"} | Mapped from context mapping for source=EF 3.1, source context Emissions > Emissions to air > Emissions to air, indoor |
| 154,678 | default_context_mapping | context_iri | — | https://vocab.brightway.one/flow-contexts/envi-air-indr-unkn | Mapped from context mapping for source=EF 3.1, source context Emissions > Emissions to air > Emissions to air, indoor |
| 220,418 | unit_normalization | unit_iri | — | https://vocab.brightway.one/units/unit/KiloGM | Unit IRI set from normalization of 'kg' |
| 226,104 | normalize_name_case | prefLabel | [{"@value":"citric acid","@language":"en","source":{"prov:wasGeneratedBy":"bootstrap_labels","prov:wasAttributedTo":"br… | [{"@value":"Citric Acid","@language":"en","source":{"prov:wasGeneratedBy":"bootstrap_labels","prov:wasAttributedTo":"br… | Title-cased words without internal capitals (preserved words with uppercase letters beyond the first character) |
| 247,320 | enrich_references | properties | {} | {"https://w3id.org/chemrof/molecular_formula":{"@id":"https://w3id.org/chemrof/molecular_formula","@value":["C6H8O7"],"… | Added ChEBI/PubChem properties (chebi_ids=1, pubchem_cids=1) |
| 247,321 | enrich_references | skos_definition | — | [{"@value":"A tricarboxylic acid that is propane-1,2,3-tricarboxylic acid bearing a hydroxy substituent at position 2.… | Merged ChEBI/PubChem definitions into skos:definition |
| 247,322 | enrich_references | references | [] | [{"@id":"bpdb:1359","provenance":{"prov:wasGeneratedBy":"enrich_references.chebi_xrefs","prov:wasAttributedTo":"brightw… | Added references with provenance; cas_numbers=['77-92-9']; matched_chebi_ids=['http://purl.obolibrary.org/obo/CHEBI_30769']; candidate_pubchem_cids=[311, 31348, 68654, 19782904]; selected_pubchem_cids=[311]; 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 |
| 254,133 | rdkit_pre_consensus | properties | {"https://w3id.org/chemrof/molecular_formula":{"@id":"https://w3id.org/chemrof/molecular_formula","@value":["C6H8O7"],"… | {"https://w3id.org/chemrof/molecular_formula":{"@id":"https://w3id.org/chemrof/molecular_formula","@value":["C6H8O7"],"… | rdkit_pre_consensus from 'C(C(=O)O)C(CC(=O)O)(C(=O)O)O'; added: monoisotopic_mass |
| 257,185 | chebi_altlabels | altLabel | [] | [{"@value":"2-Hydroxy-1,2,3-propanetricarboxylic acid","@language":"en","source":{"prov:wasGeneratedBy":"chebi_altlabel… | Added 7 ChEBI synonym(s) as altLabel from 1 linked ChEBI record(s) |
| 265,214 | consensus_match | altLabel | [{"@value":"2-Hydroxy-1,2,3-propanetricarboxylic acid","@language":"en","source":{"prov:wasGeneratedBy":"chebi_altlabel… | [{"@value":"2-Hydroxy-1,2,3-propanetricarboxylic acid","@language":"en","source":{"prov:wasGeneratedBy":"chebi_altlabel… | group_key=citricacid||dimension=Environmental > media=Water > water_body=Surface water; cas=77-92-9; added Common Chemistry CAS names as altLabel: 1,2,3-Propanetricarboxylic acid, 2-hydroxy-, 2-Hydroxy-1,2,3-propanetricarboxyic acid, 2-Hydroxypropan-1,2,3-tricarboxylic acid, 3-Carboxy-3-hydroxy-pentanedioic acid, 3-Hydroxy-3-carboxy-1,5-pentanedioic acid, 3-Hydroxy-3-carboxypentanedioic acid, 3-Hydroxy-pentane-1,3-5-trioic acid, 32: PN: CN118717671 SEQID: 106 claimed protein, 8: PN: WO2017048620 SEQID: 13 claimed sequence, Aciletten, BioLink Acidifier, C 1949, Celenex 3P6, Cellborn SC-C, Chemfill, Citretten, Citric acid monoglyceride, Citro, Citrosol 502, E 330, EL 4, EL 4 (polycarboxylic acid), EMPROVE Essential Ph Eur, BP,JP,USP, E 330, FCC, F 0001 (polycarboxylic acid), F 3500, F 4020, FE 2, Grindsted Pro Tex TR 100, Hydrocerol A, INS 330, Jet Setter, KK 120, Liquinat L 50, MeSH ID: D019343, Monoglyceride citrate, NSC 112226, NSC 30279, NSC 626579, PAS 33, SH 74, Suby G, TBA 80, Uro-trainer; object_uuid=fo-0ea1a43a8ab28905 |
| 265,215 | consensus_match | cas_match_labels | — | {"77-92-9":"exactMatch"} | group_key=citricacid||dimension=Environmental > media=Water > water_body=Surface water; group_sources=['chebi', 'ec_inventory', 'pubchem']; cas_sources={'77-92-9': ['chebi', 'ec_inventory', 'pubchem']}; assigned CAS labels from group consensus; object_uuid=fo-0ea1a43a8ab28905: {'77-92-9': 'exactMatch'} |
| 279,336 | opsin_iupac | properties | {"https://w3id.org/chemrof/molecular_formula":{"@id":"https://w3id.org/chemrof/molecular_formula","@value":["C6H8O7"],"… | {"https://w3id.org/chemrof/molecular_formula":{"@id":"https://w3id.org/chemrof/molecular_formula","@value":["C6H8O7"],"… | opsin_iupac: set authoritative IUPAC name, SMILES, InChI from 'Citric Acid' |
| 286,208 | rdkit_post_consensus | properties | {"https://w3id.org/chemrof/molecular_formula":{"@id":"https://w3id.org/chemrof/molecular_formula","@value":["C6H8O7"],"… | {"https://w3id.org/chemrof/molecular_formula":{"@id":"https://w3id.org/chemrof/molecular_formula","@value":["C6H8O7"],"… | rdkit_post_consensus from 'O=C(O)CC(O)(CC(=O)O)C(=O)O'; confirmed: smiles_string, inchi2d_string, inchi2d_key_string, molecular_formula, molecular_mass, monoisotopic_mass |
| 291,590 | strip_catalogue_altlabels | altLabel | [{"@value":"2-Hydroxy-1,2,3-propanetricarboxylic acid","@language":"en","source":{"prov:wasGeneratedBy":"chebi_altlabel… | [{"@value":"2-Hydroxy-1,2,3-propanetricarboxylic acid","@language":"en","source":{"prov:wasGeneratedBy":"chebi_altlabel… | Removed 17 catalogue altLabel value(s): 'C 1949' (grade code), 'Citrosol 502' (trade name), 'E 330' (grade code), 'EL 4' (grade code), 'EL 4 (polycarboxylic acid)' (grade code), 'F 0001 (polycarboxylic acid)' (grade code), 'F 3500' (grade code), 'F 4020' (grade code), 'FE 2' (grade code), 'INS 330' (grade code), 'KK 120' (grade code), 'NSC 112226' (registry code), 'NSC 30279' (registry code), 'NSC 626579' (registry code), 'PAS 33' (grade code), 'SH 74' (grade code), 'TBA 80' (grade code) |
| 322,644 | carry_associations_onto_flows | concept_associations | [] | [{"@type":"xkos:ConceptAssociation","xkos:sourceConcept":{"@id":"https://vocab.brightway.one/ef/3.1/flow/4666bcf0-ef30-… | associations resolved on the elementary layer |
| 330,855 | carry_associations_onto_flows | concept_associations | [] | [{"@type":"xkos:ConceptAssociation","xkos:sourceConcept":{"@id":"https://vocab.brightway.one/ef/3.1/flow/53af8d53-ea35-… | associations resolved on the elementary layer |
| 336,026 | carry_associations_onto_flows | concept_associations | [] | [{"@type":"xkos:ConceptAssociation","xkos:sourceConcept":{"@id":"https://vocab.brightway.one/ef/3.1/flow/6520f621-4678-… | associations resolved on the elementary layer |
| 336,417 | carry_associations_onto_flows | concept_associations | [] | [{"@type":"xkos:ConceptAssociation","xkos:sourceConcept":{"@id":"https://vocab.brightway.one/ef/3.1/flow/666a8f65-c0b5-… | associations resolved on the elementary layer |
| 337,018 | carry_associations_onto_flows | concept_associations | [] | [{"@type":"xkos:ConceptAssociation","xkos:sourceConcept":{"@id":"https://vocab.brightway.one/ef/3.1/flow/6866e1c9-d897-… | associations resolved on the elementary layer |
| 338,698 | carry_associations_onto_flows | concept_associations | [] | [{"@type":"xkos:ConceptAssociation","xkos:sourceConcept":{"@id":"https://vocab.brightway.one/ef/3.1/flow/6e093281-b213-… | associations resolved on the elementary layer |
| 339,794 | carry_associations_onto_flows | concept_associations | [] | [{"@type":"xkos:ConceptAssociation","xkos:sourceConcept":{"@id":"https://vocab.brightway.one/ef/3.1/flow/71ced5bc-13de-… | associations resolved on the elementary layer |
| 341,867 | carry_associations_onto_flows | concept_associations | [] | [{"@type":"xkos:ConceptAssociation","xkos:sourceConcept":{"@id":"https://vocab.brightway.one/ef/3.1/flow/78d0d625-a3b6-… | associations resolved on the elementary layer |