Table mesh_terms

Table mesh_terms stores relationship information for pairs of MeSH terms. Each row corresponds to one pair of MeSH terms: a term of category A,C,D,G defining a phenotype (column mterm) and a term of category D defining a chemical (column dterm). Attributes of this relationship consist of number of articles in PubMed annotated by each of these MeSH terms separately (columns nm and nd contains number of articles annotated by mterm and dterm respectively), number of articles annotated by both terms (column inters), number of articles annotated by either term (column unio), computed strength of the relationship between the terms in the pair (column dscore) and comma separated list of PMID identifiers of the articles annotated by both terms. Column mid is an identifier of the row and dtid column is a key linking into dterm_go table. This table has 9,725,157 rows and 10 columns that are separated by tabs. Size of a plain table is 1.97GB. Compressed table takes 801MB. Information in this table is as of September 2013.表格`mesh_terms`存储医学主题词（MeSH Terms）两两配对的关联信息。每一行对应一组医学主题词对：一类属于A、C、D、G类别、用于定义表型的主题词（字段`mterm`），以及一类属于D类别、用于定义化学物质的主题词（字段`dterm`）。 该关联的属性包括：两个主题词各自在PubMed数据库中被单独标注的文献数量（字段`nm`与`nd`分别对应`mterm`与`dterm`的标注文献数）、同时被两个主题词标注的文献数量（字段`inters`）、被任一主题词标注的文献数量（字段`unio`）、该组主题词间关联的计算强度（字段`dscore`），以及同时被两个主题词标注的文献对应的PMID标识符逗号分隔列表。 字段`mid`为该行的唯一标识符，字段`dtid`为关联至`dterm_go`表的外键。该表格共9,725,157行、10列，字段以制表符分隔。未压缩的原始表格大小为1.97GB，压缩后大小为801MB。表格内的数据截至2013年9月。

搜集汇总

背景与挑战

背景概述

Table mesh_terms数据集存储MeSH术语对的关系信息，专注于表型与化学物质术语之间的关联，提供文章数量统计和关系强度计算。数据集规模庞大，包含超过970万行和10列，数据截至2013年9月，适用于生物医学文献分析研究。