Property talk:P3117

From Wikidata
Jump to navigation Jump to search

Documentation

DSSTox substance ID
DSSTox substance identifier (DTXSID) used in the Environmental Protection Agency CompTox Dashboard
Applicable "stated in" valueDSSTOX (Q54774134)
Has qualityprefix (Q23585486)
Data typeExternal identifier
Domain
According to this template: chemical substance (Q79529)
According to statements in the property:
type of chemical entity (Q113145171), chemical element (Q11344), isotope (Q25276), group of chemical entities (Q55640599), type of mixture of chemical entities (Q119892838) or chemical substance (Q79529)
When possible, data should only be stored as statements
Allowed valuesDTXSID\d{7,9}
Examplebenzene (Q2270) → DTXSID3039242
atrazine (Q408652) → DTXSID9020112
bisphenol A (Q271980) → DTXSID7020182
perfluorooctanoic acid (Q418348) → DTXSID8031865
aspirin (Q18216) → DTXSID5020108
heroin (Q60168) → DTXSID6046761
Formatter URLhttps://comptox.epa.gov/dashboard/chemical/details/$1
Tracking: usageCategory:Pages using Wikidata property P3117 (Q47455012)
Lists
Proposal discussionProposal discussion
Current uses
Total861,103
Main statement861,093 out of 875,000 (98% complete)>99.9% of uses
Qualifier6<0.1% of uses
Reference4<0.1% 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: (+)-ephedrine (Q22330463)
List of violations of this constraint: Database reports/Constraint violations/P3117#Single value, SPARQL
Distinct values: this property likely contains a value that is different from all other items. (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/P3117#Unique value, SPARQL (every item), SPARQL (by value)
Format “DTXSID\d{7,9}”: value must be formatted using this pattern (PCRE syntax). (Help)
List of violations of this constraint: Database reports/Constraint violations/P3117#Format, hourly updated report, SPARQL
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/P3117#Type Q113145171, Q11344, Q25276, Q55640599, Q119892838, Q79529, SPARQL
Scope is as main value (Q54828448), as reference (Q54828450): the property must be used by specified way only (Help)
List of violations of this constraint: Database reports/Constraint violations/P3117#Scope, hourly updated report, 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/P3117#Entity types
This property is being used by:

Please notify projects that use this property before big changes (renaming, deletion, merge with another property, etc.)

ID naming[edit]

I propose to label this one "DSSTOX ID", per the pattern all (external) identifiers have. Anyway, "substance" is too vague, it should be "compound" (because substance is used when we don't know the formula). (ping ChemConnector). -DePiep (talk) 09:22, 21 April 2019 (UTC)[reply]

It is definitely NOT DSSTOX ID. The identifiers are minted as DTXSIDs (these are substance identifers) and are displayed on a record page and are used for direct URL linking into a page, for example https://comptox.epa.gov/dashboard/dsstoxdb/results?search=DTXSID3022401 lands at DTXSID3022401 for cholesterol. We also have DTXCIDs for chemical identifiers and DTXRIDs for registered chemicals from different sources. For details see the section in https://jcheminf.biomedcentral.com/articles/10.1186/s13321-017-0247-6
Antony Williams 15:25, 21 April 2019 (UTC)
OK we can change the label (underlying WD identifier P3117 is unchanged).
The "S" in DTXSID is for substance then, similar "C" in DTXCID for Chemical identifier, and "R" in DTXRID for Registered. The cholesterol page says: "Searched by DSSTox Substance Id.".
This property is defined to be the substance identifier (Not some DSSTOX generic identifier), so I'll change that in the label. "C" and "R" are not possible in this property (see regex pattern). -DePiep (talk) 09:23, 22 April 2019 (UTC)[reply]

URL updates[edit]

Please update the URLs.

I have received a notice that the the URLs need and update (site API change) formatter URL (P1630), URL match pattern (P8966)

While doing updates to en:riboflavin, which is undergoing a GA review, I noticed that the Infobox correctly links to DTXSID8021777 at comptox.epa.gov. However, when clicking on the link in the article, the URL automatically provided is this one, which goes to the wrong place. It turns out that the epa have recently changed their dashboard and the correct link for riboflavin is now a more complex one. All this is well beyond my skills to fix and needs your expertise delving in the bowels of Wikidata etc. Can you take a look, please? I suspect the problem now spreads to all our drug articles! Mike Turnbull 13:14, 1 December 2021 (UTC)

For riboflavin (Q130365):

old: https://comptox.epa.gov/dashboard/DTXSID8021777
new: https://comptox.epa.gov/dashboard/chemical/details/DTXSID8021777

So that looks straightforward:

https://comptox.epa.gov/dashboard/$1
https://comptox.epa.gov/dashboard/chemical/details/$1

See also en:Template talk:Infobox drug/formatCompTox edit request at enwiki. @Egon Willighagen, Michael D. Turnbull: -DePiep (talk) 11:19, 2 December 2021 (UTC)[reply]

Retrieved from "https://www.wikidata.org/w/index.php?title=Property_talk:P3117&oldid=2149067279"