consensus_index
Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website
48 rows where inchi_id = 9020
Download this data as a CSV Spreadsheet (All Rows)
| Link | rowid ▼ | inventory_id | inchi_id | consensus_score | consensus_count |
|---|---|---|---|---|---|
| 7283 | 7283 | 2185 2185 | 9020 | 1 | 0.0882566092876692 |
| 19152 | 19152 | 5626 5626 | 9020 | 1 | 0.141227593699077 |
| 25899 | 25899 | 7587 7587 | 9020 | 1 | 0.0223058372510269 |
| 96543 | 96543 | 34224 34224 | 9020 | 1 | 0.141227593699077 |
| 96799 | 96799 | 34326 34326 | 9020 | 1 | 0.0223058372510269 |
| 159825 | 159825 | 57487 57487 | 9020 | 1 | 0.141227593699077 |
| 170382 | 170382 | 60768 60768 | 9020 | 1 | 0.0230151252365547 |
| 205339 | 205339 | 72791 72791 | 9020 | 1 | 0.0999211149092821 |
| 217123 | 217123 | 75349 75349 | 9020 | 1 | 0.116763969974979 |
| 227342 | 227342 | 78186 78186 | 9020 | 1 | 0.0225538459907221 |
| 427110 | 427110 | 154018 154018 | 9020 | 1 | 0.116763969974979 |
| 434064 | 434064 | 155979 155979 | 9020 | 1 | 0.0237936426312428 |
| 514772 | 514772 | 206495 206495 | 9020 | 1 | 0.13986013986014 |
| 514777 | 514777 | 206496 206496 | 9020 | 1 | 0.116763969974979 |
| 514783 | 514783 | 206497 206497 | 9020 | 1 | 0.116763969974979 |
| 514789 | 514789 | 206498 206498 | 9020 | 1 | 0.116763969974979 |
| 519875 | 519875 | 207719 207719 | 9020 | 8 | 0.576280332408756 |
| 519901 | 519901 | 207726 207726 | 9020 | 1 | 0.0222510208860451 |
| 519915 | 519915 | 207727 207727 | 9020 | 1 | 0.0222510208860451 |
| 519929 | 519929 | 207728 207728 | 9020 | 1 | 0.0237936426312428 |
| 534139 | 534139 | 211955 211955 | 9020 | 1 | 0.116763969974979 |
| 582210 | 582210 | 227680 227680 | 9020 | 1 | 0.0237936426312428 |
| 666933 | 666933 | 238826 238826 | 9020 | 1 | 0.0999211149092821 |
| 681966 | 681966 | 243553 243553 | 9020 | 1 | 0.0218308292902177 |
| 733902 | 733902 | 258856 258856 | 9020 | 1 | 0.142095914742451 |
| 762470 | 762470 | 267406 267406 | 9020 | 1 | 0.0237936426312428 |
| 762484 | 762484 | 267407 267407 | 9020 | 1 | 0.0223058372510269 |
| 762498 | 762498 | 267408 267408 | 9020 | 1 | 0.0230151252365547 |
| 762513 | 762513 | 267409 267409 | 9020 | 1 | 0.0237936426312428 |
| 854179 | 854179 | 295494 295494 | 9020 | 1 | 0.103173397873042 |
| 854184 | 854184 | 295495 295495 | 9020 | 1 | 0.141227593699077 |
| 854189 | 854189 | 295496 295496 | 9020 | 1 | 0.116763969974979 |
| 957143 | 957143 | 344144 344144 | 9020 | 1 | 0.0237936426312428 |
| 957205 | 957205 | 344176 344176 | 9020 | 5 | 0.551370854534993 |
| 1172498 | 1172498 | 393719 393719 | 9020 | 1 | 0.141227593699077 |
| 1172503 | 1172503 | 393720 393720 | 9020 | 1 | 0.141227593699077 |
| 1172508 | 1172508 | 393721 393721 | 9020 | 1 | 0.141227593699077 |
| 1427938 | 1427938 | 445325 445325 | 9020 | 1 | 0.141227593699077 |
| 1427943 | 1427943 | 445326 445326 | 9020 | 1 | 0.141227593699077 |
| 1427948 | 1427948 | 445327 445327 | 9020 | 1 | 0.141227593699077 |
| 1585693 | 1585693 | 478763 478763 | 9020 | 1 | 0.141227593699077 |
| 1585698 | 1585698 | 478764 478764 | 9020 | 1 | 0.141227593699077 |
| 1585703 | 1585703 | 478765 478765 | 9020 | 1 | 0.141227593699077 |
| 1606670 | 1606670 | 485407 485407 | 9020 | 1 | 0.141227593699077 |
| 1612582 | 1612582 | 486833 486833 | 9020 | 1 | 0.141227593699077 |
| 1620365 | 1620365 | 489308 489308 | 9020 | 1 | 0.0228460194371168 |
| 1717927 | 1717927 | 526134 526134 | 9020 | 1 | 0.140845070422535 |
| 1722637 | 1722637 | 527567 527567 | 9020 | 5 | 0.551370854534993 |
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)
);