consensus_index
Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website
18 rows where inchi_id = 23840
Download this data as a CSV Spreadsheet (All Rows)
| Link | rowid ▼ | inventory_id | inchi_id | consensus_score | consensus_count |
|---|---|---|---|---|---|
| 13314 | 13314 | 4085 4085 | 23840 | 12 | 0.527472527472527 |
| 36112 | 36112 | 10766 10766 | 23840 | 8 | 0.625 |
| 87326 | 87326 | 31259 31259 | 23840 | 8 | 0.625 |
| 155359 | 155359 | 55871 55871 | 23840 | 8 | 0.625 |
| 264652 | 264652 | 89662 89662 | 23840 | 7 | 0.620689655172414 |
| 448351 | 448351 | 160728 160728 | 23840 | 7 | 0.620689655172414 |
| 531114 | 531114 | 210712 210712 | 23840 | 3 | 0.151781311417071 |
| 661556 | 661556 | 237048 237048 | 23840 | 7 | 0.620689655172414 |
| 692575 | 692575 | 247041 247041 | 23840 | 8 | 0.625 |
| 736900 | 736900 | 259849 259849 | 23840 | 1 | 0.150345232287777 |
| 779491 | 779491 | 272586 272586 | 23840 | 8 | 0.625 |
| 779493 | 779493 | 272587 272587 | 23840 | 4 | 0.6 |
| 779495 | 779495 | 272588 272588 | 23840 | 4 | 0.6 |
| 816274 | 816274 | 283487 283487 | 23840 | 1 | 0.0405375857069106 |
| 860025 | 860025 | 297434 297434 | 23840 | 4 | 0.254826254826255 |
| 860030 | 860030 | 297435 297435 | 23840 | 1 | 0.150670270224862 |
| 1638235 | 1638235 | 495458 495458 | 23840 | 8 | 0.625 |
| 1732517 | 1732517 | 530608 530608 | 23840 | 8 | 0.625 |
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)
);