consensus_index
Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website
21 rows where inchi_id = 142002
Download this data as a CSV Spreadsheet (All Rows)
| Link | rowid ▼ | inventory_id | inchi_id | consensus_score | consensus_count |
|---|---|---|---|---|---|
| 48488 | 48488 | 14912 14912 | 142002 | 5 | 0.404496106308204 |
| 135177 | 135177 | 47907 47907 | 142002 | 1 | 0.265116279069767 |
| 220969 | 220969 | 76486 76486 | 142002 | 1 | 0.259842519685039 |
| 302428 | 302428 | 102352 102352 | 142002 | 4 | 0.418194686689153 |
| 429764 | 429764 | 154801 154801 | 142002 | 1 | 0.259842519685039 |
| 516714 | 516714 | 206958 206958 | 142002 | 1 | 0.259842519685039 |
| 593938 | 593938 | 231431 231431 | 142002 | 1 | 0.259842519685039 |
| 597496 | 597496 | 235429 235429 | 142002 | 1 | 0.259842519685039 |
| 671679 | 671679 | 240400 240400 | 142002 | 1 | 0.263157894736842 |
| 742875 | 742875 | 261574 261574 | 142002 | 1 | 0.259842519685039 |
| 742878 | 742878 | 261575 261575 | 142002 | 1 | 0.259842519685039 |
| 876151 | 876151 | 303207 303207 | 142002 | 1 | 0.253012048192771 |
| 975784 | 975784 | 353335 353335 | 142002 | 1 | 0.259842519685039 |
| 975787 | 975787 | 353336 353336 | 142002 | 1 | 0.259842519685039 |
| 1185719 | 1185719 | 397339 397339 | 142002 | 1 | 0.259842519685039 |
| 1185722 | 1185722 | 397340 397340 | 142002 | 1 | 0.259842519685039 |
| 1438737 | 1438737 | 448302 448302 | 142002 | 1 | 0.259842519685039 |
| 1438740 | 1438740 | 448303 448303 | 142002 | 1 | 0.259842519685039 |
| 1590150 | 1590150 | 480007 480007 | 142002 | 1 | 0.259842519685039 |
| 1616397 | 1616397 | 488091 488091 | 142002 | 1 | 0.259842519685039 |
| 1719588 | 1719588 | 526651 526651 | 142002 | 1 | 0.259842519685039 |
CREATE TABLE [consensus_index] (
[inventory_id] integer,
[inchi_id] text,
[consensus_score] text,
[consensus_count] integer,
FOREIGN KEY (inventory_id) REFERENCES inventories(inventory_id),
FOREIGN KEY (inchi_id) REFERENCES substances(inchi_id)
);