consensus_index
Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website
43 rows where inchi_id = 84027
Download this data as a CSV Spreadsheet (All Rows)
| Link | rowid ▼ | inventory_id | inchi_id | consensus_score | consensus_count |
|---|---|---|---|---|---|
| 1350 | 1350 | 293 293 | 84027 | 11 | 0.426287744227353 |
| 19046 | 19046 | 5597 5597 | 84027 | 7 | 0.422535211267606 |
| 82098 | 82098 | 29575 29575 | 84027 | 7 | 0.422535211267606 |
| 159068 | 159068 | 57276 57276 | 84027 | 12 | 0.426956885726245 |
| 203159 | 203159 | 71993 71993 | 84027 | 11 | 0.426287744227353 |
| 216917 | 216917 | 75291 75291 | 84027 | 7 | 0.422535211267606 |
| 218370 | 218370 | 75709 75709 | 84027 | 1 | 0.310344827586207 |
| 426957 | 426957 | 153976 153976 | 84027 | 8 | 0.42368278109723 |
| 514709 | 514709 | 206478 206478 | 84027 | 11 | 0.426287744227353 |
| 514714 | 514714 | 206479 206479 | 84027 | 5 | 0.41958041958042 |
| 534301 | 534301 | 212018 212018 | 84027 | 7 | 0.422535211267606 |
| 666898 | 666898 | 238811 238811 | 84027 | 7 | 0.422535211267606 |
| 733652 | 733652 | 258729 258729 | 84027 | 11 | 0.426287744227353 |
| 853411 | 853411 | 295263 295263 | 84027 | 5 | 0.41958041958042 |
| 853416 | 853416 | 295264 295264 | 84027 | 7 | 0.422535211267606 |
| 853421 | 853421 | 295265 295265 | 84027 | 5 | 0.41958041958042 |
| 853426 | 853426 | 295266 295266 | 84027 | 8 | 0.42368278109723 |
| 853431 | 853431 | 295267 295267 | 84027 | 8 | 0.42368278109723 |
| 1172066 | 1172066 | 393599 393599 | 84027 | 7 | 0.422535211267606 |
| 1172071 | 1172071 | 393600 393600 | 84027 | 7 | 0.422535211267606 |
| 1172076 | 1172076 | 393601 393601 | 84027 | 7 | 0.422535211267606 |
| 1172081 | 1172081 | 393602 393602 | 84027 | 7 | 0.422535211267606 |
| 1172086 | 1172086 | 393603 393603 | 84027 | 7 | 0.422535211267606 |
| 1172091 | 1172091 | 393604 393604 | 84027 | 7 | 0.422535211267606 |
| 1172096 | 1172096 | 393605 393605 | 84027 | 7 | 0.422535211267606 |
| 1427594 | 1427594 | 445234 445234 | 84027 | 7 | 0.422535211267606 |
| 1427599 | 1427599 | 445235 445235 | 84027 | 7 | 0.422535211267606 |
| 1427604 | 1427604 | 445236 445236 | 84027 | 7 | 0.422535211267606 |
| 1427609 | 1427609 | 445237 445237 | 84027 | 7 | 0.422535211267606 |
| 1427614 | 1427614 | 445238 445238 | 84027 | 7 | 0.422535211267606 |
| 1427619 | 1427619 | 445239 445239 | 84027 | 7 | 0.422535211267606 |
| 1427624 | 1427624 | 445240 445240 | 84027 | 7 | 0.422535211267606 |
| 1585462 | 1585462 | 478702 478702 | 84027 | 7 | 0.422535211267606 |
| 1585467 | 1585467 | 478703 478703 | 84027 | 7 | 0.422535211267606 |
| 1585472 | 1585472 | 478704 478704 | 84027 | 7 | 0.422535211267606 |
| 1585477 | 1585477 | 478705 478705 | 84027 | 7 | 0.422535211267606 |
| 1585482 | 1585482 | 478706 478706 | 84027 | 7 | 0.422535211267606 |
| 1585487 | 1585487 | 478707 478707 | 84027 | 7 | 0.422535211267606 |
| 1585492 | 1585492 | 478708 478708 | 84027 | 7 | 0.422535211267606 |
| 1606583 | 1606583 | 485382 485382 | 84027 | 7 | 0.422535211267606 |
| 1612422 | 1612422 | 486780 486780 | 84027 | 7 | 0.422535211267606 |
| 1613498 | 1613498 | 487115 487115 | 84027 | 1 | 0.3125 |
| 1717840 | 1717840 | 526110 526110 | 84027 | 4 | 0.417633410672854 |
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)
);