consensus_index
Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website
25 rows where inchi_id = 31263
Download this data as a CSV Spreadsheet (All Rows)
| Link | rowid ▼ | inventory_id | inchi_id | consensus_score | consensus_count |
|---|---|---|---|---|---|
| 11300 | 11300 | 3443 3443 | 31263 | 1 | 0.0637784105612819 |
| 58348 | 58348 | 18406 18406 | 31263 | 1 | 0.0753591730404307 |
| 81839 | 81839 | 29466 29466 | 31263 | 1 | 0.0753591730404307 |
| 158779 | 158779 | 57175 57175 | 31263 | 1 | 0.0753591730404307 |
| 341781 | 341781 | 115344 115344 | 31263 | 1 | 0.0777069171207824 |
| 341927 | 341927 | 115401 115401 | 31263 | 6 | 0.514285714285714 |
| 478858 | 478858 | 174935 174935 | 31263 | 1 | 0.0801080756757669 |
| 566041 | 566041 | 222262 222262 | 31263 | 1 | 0.0772069575663858 |
| 697162 | 697162 | 248547 248547 | 31263 | 1 | 0.0753591730404307 |
| 697232 | 697232 | 248570 248570 | 31263 | 8 | 0.519685039370079 |
| 789396 | 789396 | 275693 275693 | 31263 | 1 | 0.0772069575663858 |
| 789401 | 789401 | 275694 275694 | 31263 | 1 | 0.0753591730404307 |
| 789406 | 789406 | 275695 275695 | 31263 | 1 | 0.0772069575663858 |
| 789560 | 789560 | 275746 275746 | 31263 | 8 | 0.519685039370079 |
| 789563 | 789563 | 275747 275747 | 31263 | 4 | 0.506024096385542 |
| 930570 | 930570 | 331306 331306 | 31263 | 1 | 0.3 |
| 1049160 | 1049160 | 371227 371227 | 31263 | 1 | 0.0753591730404307 |
| 1049165 | 1049165 | 371228 371228 | 31263 | 1 | 0.0753591730404307 |
| 1270816 | 1270816 | 418219 418219 | 31263 | 1 | 0.0753591730404307 |
| 1270821 | 1270821 | 418220 418220 | 31263 | 1 | 0.0753591730404307 |
| 1491117 | 1491117 | 461397 461397 | 31263 | 1 | 0.0753591730404307 |
| 1491122 | 1491122 | 461398 461398 | 31263 | 1 | 0.0753591730404307 |
| 1598087 | 1598087 | 482668 482668 | 31263 | 1 | 0.0753591730404307 |
| 1675017 | 1675017 | 508431 508431 | 31263 | 1 | 0.0753591730404307 |
| 1752579 | 1752579 | 536914 536914 | 31263 | 1 | 0.0753591730404307 |
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)
);