consensus_index
Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website
19 rows where inchi_id = 23643
Download this data as a CSV Spreadsheet (All Rows)
| Link | rowid ▼ | inventory_id | inchi_id | consensus_score | consensus_count |
|---|---|---|---|---|---|
| 127018 | 127018 | 45401 45401 | 23643 | 1 | 0.0799754786180359 |
| 267458 | 267458 | 90656 90656 | 23643 | 1 | 0.146341463414634 |
| 278089 | 278089 | 94305 94305 | 23643 | 2 | 0.182647423110619 |
| 330559 | 330559 | 111419 111419 | 23643 | 8 | 0.625 |
| 331446 | 331446 | 111724 111724 | 23643 | 1 | 0.0973603391006915 |
| 474626 | 474626 | 172622 172622 | 23643 | 1 | 0.0894538085076666 |
| 523919 | 523919 | 208848 208848 | 23643 | 1 | 0.0762362252829878 |
| 568332 | 568332 | 222972 222972 | 23643 | 1 | 0.146341463414634 |
| 570752 | 570752 | 223748 223748 | 23643 | 1 | 0.0904582501976102 |
| 692727 | 692727 | 247152 247152 | 23643 | 1 | 0.0938126816783206 |
| 703534 | 703534 | 250530 250530 | 23643 | 1 | 0.3125 |
| 779809 | 779809 | 272696 272696 | 23643 | 1 | 0.0938126816783206 |
| 779816 | 779816 | 272697 272697 | 23643 | 1 | 0.100014819277109 |
| 779823 | 779823 | 272698 272698 | 23643 | 1 | 0.100014819277109 |
| 779830 | 779830 | 272699 272699 | 23643 | 1 | 0.100014819277109 |
| 800302 | 800302 | 279194 279194 | 23643 | 1 | 0.3125 |
| 880942 | 880942 | 306048 306048 | 23643 | 1 | 0.3 |
| 1644628 | 1644628 | 497828 497828 | 23643 | 1 | 0.3125 |
| 1670013 | 1670013 | 506608 506608 | 23643 | 1 | 0.0938126816783206 |
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)
);