Property talk:P235

From Wikidata
Jump to navigation Jump to search

Documentation

InChIKey
a hashed version of the full standard InChI
Descriptioncondensed version of the full standard International Chemical Identifier (Q203250)
RepresentsInChIKey (Q21445422)
Data typeExternal identifier
Template parameterinfo in Template:Chembox InChIKey (Q6871531)
Domainchemical substance (Q79529) (note: this should be moved to the property statements)
Allowed values
According to this template: 14 letters - 10 letters - 1 letter
According to statements in the property:
[A-Z]{14}-[A-Z]{10}-[A-Z]
When possible, data should only be stored as statements
Examplegold (Q897)PCHJSUWPFVWCPO-UHFFFAOYSA-N
ethanol (Q153)LFQSCWFLJHTTHZ-UHFFFAOYSA-N
Formatter URLhttps://www.ncbi.nlm.nih.gov/sites/entrez?cmd=search&db=pccompound&term="$1"[InChIKey]
Robot and gadget jobsDeltaBot does the following jobs:
Tracking: usageCategory:Pages using Wikidata property P235 (Q28753657)
See alsoInChI (P234)
Lists
  • Items with the most statements of this property
  • Count of items by number of statements (chart)
  • Count of items by number of sitelinks (chart)
  • Items with the most identifier properties
  • Items with no other external identifier
  • Items with no other statements
  • Most recently created items
  • Items with novalue claims
  • Items with unknown value claims
  • Usage history (total)
  • Database reports/Complex constraint violations/P235
  • Database reports/Constraint violations/P235
  • Map
  • Random list
  • Proposal discussion[not applicable Proposal discussion]
    Current uses
    Total2,817,553
    Main statement1,363,93148.4% of uses
    Qualifier2<0.1% of uses
    Reference1,453,62051.6% of uses
    Search for values
    [create Create a translatable help page (preferably in English) for this property to be included here]
    Single value: this property generally contains a single value. (Help)
    Exceptions are possible as rare values may exist. Exceptions can be specified using exception to constraint (P2303). Known exceptions: (1RS,5RS,6RS,7RS)-(RS)-adhyperforin (Q110201299)
    List of violations of this constraint: Database reports/Constraint violations/P235#Single value, SPARQL
    Format “[A-Z]{14}-[A-Z]{10}-[A-Z]: value must be formatted using this pattern (PCRE syntax). (Help)
    List of violations of this constraint: Database reports/Constraint violations/P235#Format, hourly updated report, SPARQL
    Scope is as main value (Q54828448), as reference (Q54828450): the property must be used by specified way only (Help)
    Exceptions are possible as rare values may exist. Exceptions can be specified using exception to constraint (P2303).
    List of violations of this constraint: Database reports/Constraint violations/P235#Scope, SPARQL
    Allowed entity types are Wikibase item (Q29934200): the property may only be used on a certain entity type (Help)
    Exceptions are possible as rare values may exist. Exceptions can be specified using exception to constraint (P2303).
    List of violations of this constraint: Database reports/Constraint violations/P235#Entity types
    Item “InChI (P234): Items with this property should also have “InChI (P234)”. (Help)
    Exceptions are possible as rare values may exist. Exceptions can be specified using exception to constraint (P2303).
    List of violations of this constraint: Database reports/Constraint violations/P235#Item P234, search, SPARQL
    Conflicts with “DOI (P356): this property must not be used with the listed properties and values. (Help)
    Exceptions are possible as rare values may exist. Exceptions can be specified using exception to constraint (P2303).
    List of violations of this constraint: Database reports/Constraint violations/P235#Conflicts with P356, search, SPARQL
    Modified unique value constraint
    Lists items having the same value, except if both statements have mutual tautomer of (P6185) statements, see discussion below. Please don't switch on the normal unique value constraint, use this instead. (Help)
    Violations query: SELECT DISTINCT ?item ?item2 ?value { ?item wdt:P235 ?value . ?item2 wdt:P235 ?value . MINUS { ?item wdt:P6185 ?item2. ?item2 wdt:P6185 ?item } MINUS { ?item wdt:P31 wd:Q757764. } FILTER( ?item != ?item2 && STR( ?item ) < STR( ?item2 ) ) . FILTER( ?item NOT IN ( wd:Q106010164, wd:Q106010167, wd:Q106010168, wd:Q106010169, wd:Q106010170, wd:Q106010171, wd:Q106010172, wd:Q106010173 )). } LIMIT 1000
    List of this constraint violations: Database reports/Complex constraint violations/P235#Modified unique value constraint

    Domain

    [edit]
    Saehrimnir
    Leyo
    Snipre
    Dcirovic
    Walkerma
    Egon Willighagen
    Denise Slenter
    Daniel Mietchen
    Kopiersperre
    Emily Temple-Wood
    Pablo Busatto (Almondega)
    Antony Williams (EPA)
    TomT0m
    Wostr
    Devon Fyson
    User:DePiep
    User:DavRosen
    Benjaminabel
    99of9
    Kubaello
    Fractaler
    Sebotic
    Netha
    Hugo
    Samuel Clark
    Tris T7
    Leiem
    Christianhauck
    SCIdude
    Binter
    Photocyte
    Robert Giessmann
    Cord Wiljes
    Adriano Rutz
    Jonathan Bisson
    GrndStt
    Ameisenigel
    Charles Tapley Hoyt
    ChemHobby
    Peter Murray-Rust
    Erfurth
    TiagoLubiana
    NadirSH
    Matthias M.
    S8321414
    Peter F. Patel-Schneider

    Notified participants of WikiProject Chemistry The domain of this property should not be molecular entity (Q2393187)? Almondega (talk) 20:38, 19 August 2015 (UTC)[reply]

    @Almondega: No. We're talking of the type of the class of all molecule (Q11369)  View with Reasonator View with SQID here. author  TomT0m / talk page 07:55, 20 August 2015 (UTC)[reply]
    @TomT0m: the way it is, hydrogen anion (Q29004) is being incorrectly reported as if violating a restriction. Almondega (talk) 11:16, 20 August 2015 (UTC)[reply]
    @Almondega: We should correct the constraint then and follow the discussion on the WikiProject Chemistry then such that we can sort things out and reach a consensus. Did you indentify which one ? author  TomT0m / talk page 11:58, 20 August 2015 (UTC)[reply]
    @Almondega: No, the InChI can be used for disconnected structures too (and not just salts). Egon Willighagen (talk) 08:29, 23 August 2015 (UTC)[reply]
    @Egon Willighagen:I am saying this too Almondega (talk) 11:02, 23 August 2015 (UTC)[reply]
    @Almondega: Sorry, I know, because you clearly started your answer with "No"... I just wanted to second it, and the ping was just because to ping you that another reply was posted... sorry for the confusion.

    Duplicate

    [edit]

    @Egon Willighagen: Hello, just to inform you that one of your data imports create sevral duplicates (see here). This is not a criticism but just a remark to help you to improve your matching work. I tried to correct most of them. Snipre (talk) 18:53, 6 May 2019 (UTC)[reply]

    @Snipre: thanks for the heads up. That's a bit surprising, because it does an explicit check if the InChI is already there before creating a new item (github.com/egonw/ons-wikidata/../createWDitemsFromSMILES.groovy#L112-L132). I'll look into them asap (on the road) and see what goes wrong. --Egon Willighagen (talk) 04:40, 7 May 2019 (UTC)[reply]
    @Egon Willighagen: It is mainly due to mix of different IDs. So looking for the presence of one particular ID is not sufficient to be sure that you add the data to the correct item. In my opinion, the best solution is always check before importation if the ID we want to add is already present in WD then look for some matching IDs. Snipre (talk) 18:19, 7 May 2019 (UTC)[reply]
    @Snipre: Okay, I figured out what happened. Unlike I assumed in my first reply, this is *not* a data import. Well, not like adding new compounds. What it is instead, was that I computed InChIKeys from the given SMILES (process with >99% accuracy), which means that the new hits were not new conflicts, just existing conflicts (the same chemical structure, just one without an InChIKey before this). So, thank you very much for the curation work!! I'm please to see this "import" made these existing conflicts visible, which is a win to me. I'm sorry you had to "beat me" to fixing them. I had intended to do that myself, but fell ill two weeks ago with a nasty virus. I'm sorry for the inconvenience it cause, even if I did not really cause them, just made them visible. --Egon Willighagen (talk) 06:05, 10 May 2019 (UTC)[reply]

    modified unique value constraint

    [edit]

    The complex constraint I just added lists all violating items having the same value, except if both statements have mutual tautomer of (P6185) statements. I'm proposing to remove the current unique value constraint because it gives false positives, see Wikidata_talk:WikiProject_Chemistry#Non-standard_InChI. Please give your opinion. --SCIdude (talk) 14:44, 10 January 2020 (UTC)[reply]

    Now I added the exception: if both items have the mutual statement "instance of"-->"atropisomer", for example gossypol: Q29652363, Q29652392. No need anymore to add single exceptions! --SCIdude (talk) 06:57, 2 August 2020 (UTC)[reply]
    Shouldn't this relation be done using stereoisomer of (P3364) (maybe with a proper qualifier to indicate atropoisomerism)? Just like we don't add instance of (P31)stereoisomer (Q235816) and instance of (P31)tautomer (Q334640)? Wostr (talk) 09:24, 2 August 2020 (UTC)[reply]
    [edit]

    I deleted the constraint related to InChI as one reason for the fact that items with InChIKey but without InChI exist is the limitation of the number of digits for string items. So this contraint and the constraint violation report is just a loss of time. Snipre (talk) 22:17, 21 February 2021 (UTC)[reply]

    If there is a problem of length of InChI value, somevalue should be added with a proper qualifier indicating that a correct value cannot be added due to the limit. Wostr (talk) 09:29, 22 February 2021 (UTC)[reply]