Chemical Viewed Structurally Relationships

$395 / year

This dataset provides the information on relationships between concepts or atoms known to the Metathesaurus for the semantic type “Chemical Viewed Structurally”. In the dataset, for asymmetrical relationships there is one row for each direction of the relationship.

Categories: ,

The UMLS, or Unified Medical Language System, is a set of files and software that brings together many health and biomedical vocabularies and standards to enable interoperability between computer systems. One powerful use of the UMLS is linking health information, medical terms, drug names, and billing codes across different computer systems. Some examples of this are:
– Linking terms and codes between your doctor, your pharmacy, and your insurance company
– Patient care coordination among several departments within a hospital
The UMLS has many other uses, including search engine retrieval, data mining, public health statistics reporting, and terminology research.
The UMLS has three tools (Knowledge Sources):
– Metathesaurus: Terms and codes from many vocabularies, including CPT, ICD-10-CM, LOINC, MeSH, RxNorm, and SNOMED CT
– Semantic Network: Broad categories (semantic types) and their relationships (semantic relations)
– SPECIALIST Lexicon and Lexical Tools: Natural language processing tools

The 2017AA Metathesaurus contains approximately 3.44 million concepts and 13.7 million unique concept names from 199 source vocabularies. The Metathesaurus is a very large, multi-purpose, and multi-lingual vocabulary database that contains information about biomedical and health related concepts, their various names, and the relationships among them. It is built from the electronic versions of many different thesauri, classifications, code sets, and lists of controlled terms used in patient care, health services billing, public health statistics, indexing and cataloging biomedical literature, and /or basic, clinical, and health services research. In this documentation, these are referred to as the “source vocabularies” of the Metathesaurus. In the Metathesaurus, all the source vocabularies are available in a single, fully-specified database format.

The Metathesaurus is organized by concept or meaning. In essence, its purpose is to link alternative names and views of the same concept together and to identify useful relationships between different concepts. All concepts in the Metathesaurus are assigned to at least one semantic type from the Semantic Network. This provides consistent categorization of all concepts in the Metathesaurus at the relatively general level represented in the Semantic Network.

The purpose of the Semantic Network is to provide a consistent categorization of all concepts represented in the UMLS Metathesaurus and to provide a set of useful relationships between these concepts. All information about specific concepts is found in the Metathesaurus; the Network provides information about the set of basic semantic types, or categories, which may be assigned to these concepts, and it defines the set of relationships that may hold between the semantic types. The current release of the Semantic Network contains 125 semantic types and 54 relationships. The Semantic Network serves as an authority for the semantic types that are assigned to concepts in the Metathesaurus. The Network defines these types, both with textual descriptions and by means of the information inherent in its hierarchies.

Of the fifty-four semantic relationships, the primary link between most of the semantic types is the ‘isa’ (is a) relationship. These semantic relationships may or may not hold at the concept level. One of the more important relationships within the Semantic Network is the Parent-Child, or Broader-Narrower, relationship. This relationship illustrates the hierarchies that exist between biomedical concepts. Child (narrower) relationships can be thought of as a subtype. For example, the semantic type Biologic Function is the parent of, or broader than, the semantic type Physiologic Function.

Date Created


Last Modified




Update Frequency


Temporal Coverage


Spatial Coverage



John Snow Labs => U.S. National Library of Medicine (NLM)

Source License URL

John Snow Labs Standard License

Source License Requirements

Reporting Requirements

Source Citation



Chemical Viewed Structural Concepts, Chemical Viewed Structural Types, Health and Biomedical Vocabularies, Health and Biomedical Standards, Health Information Link, UMLS Concept Structure, Health and Biomedical Standards, Health Information Link, UMLS Concept Structure, Metathesaurus Relationships, MRREL

Other Titles

Metathesaurus Concepts and Their Relationships, Substances Chemical Viewed Structurally Relationships

Name Description Type Constraints
Concept_Unique_Identifier_1Unique identifier of first conceptstringrequired : 1
Atom_Unique_Identifier_1Unique identifier of first atomstring-
Relationship_Column_Name_1The name of the column in "Chemical Viewed Structurally Concepts and Types" that contains the first identifier to which the relationship is attachedstringrequired : 1
Relationship_LabelRelationship of second concept or atom to first concept or atomstringrequired : 1
Concept_Unique_Identifier_2Unique identifier of second conceptstringrequired : 1
Semantic_Type_Group_Concept_Unique_Identifier_2The group of the semantic type in the semantic treestring-
Atom_Unique_Identifier_2Unique identifier of second atomstring-
Relationship_Column_Name_2The name of the column in "Chemical Viewed Structurally Concepts and Types" that contains the second identifier to which the relationship is attachedstringrequired : 1
Additional_Relationship_LabelAdditional (more specific) relationship label (optional)string-
Relationship_Unique_IdentifierUnique identifier of relationshipstringrequired : 1
Source_Relationship_IdentifierSource attributed relationship identifierstring-
Source_AbbreviationSource vocabulary abbreviationstringrequired : 1
Source_Relationship_LabelSource of relationship labelsstring-
Relationship_GroupThe group that the relationship belongs tointegerlevel : Nominal
Is_Source_Directionality_FlagIndicates if it is a source asserted directionality flag. True indicates that this is the direction of the relationship in its source; false indicates that it is not; a blank indicates that it is not important or has not yet been determinedboolean-
Suppressible_FlagIn the UMLS Metathesaurus terms can be marked as "suppressible", these terms can then be removed from the subset. These terms are most often identified as suppressible because of ambiguity in meaning or lack of face validity. Suppressible flag. Values = E: Suppressible due to editor decision, N: Not suppressible, O: Obsolete, Y: Suppressible due to SABstringrequired : 1
Content_View_FlagContent View Flag. Bit field used to flag rows included in Content View. This field is a varchar field to maximize the number of bits available for use.integerlevel : Nominal
No data for preview
Related Data Packages