consensus_index
Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website
37 rows where inchi_id = 43767
Download this data as a CSV Spreadsheet (All Rows)
| Link | rowid ▼ | inventory_id | inchi_id | consensus_score | consensus_count |
|---|---|---|---|---|---|
| 19539 | 19539 | 5747 5747 | 43767 | 1 | 0.090192768528766 |
| 39748 | 39748 | 12017 12017 | 43767 | 8 | 0.625 |
| 101284 | 101284 | 35760 35760 | 43767 | 1 | 0.090192768528766 |
| 129949 | 129949 | 46301 46301 | 43767 | 2 | 0.0637883907141877 |
| 150561 | 150561 | 53983 53983 | 43767 | 4 | 0.833333333333333 |
| 218021 | 218021 | 75609 75609 | 43767 | 2 | 0.148009985857802 |
| 280012 | 280012 | 94954 94954 | 43767 | 8 | 0.625 |
| 427669 | 427669 | 154184 154184 | 43767 | 2 | 0.148009985857802 |
| 515105 | 515105 | 206557 206557 | 43767 | 2 | 0.148009985857802 |
| 533108 | 533108 | 211480 211480 | 43767 | 2 | 0.148009985857802 |
| 559463 | 559463 | 220100 220100 | 43767 | 8 | 0.9 |
| 704402 | 704402 | 250780 250780 | 43767 | 8 | 0.625 |
| 735144 | 735144 | 259323 259323 | 43767 | 2 | 0.0637837753305799 |
| 801708 | 801708 | 279648 279648 | 43767 | 4 | 0.833333333333333 |
| 801710 | 801710 | 279649 279649 | 43767 | 8 | 0.625 |
| 856741 | 856741 | 296367 296367 | 43767 | 1 | 0.25531914893617 |
| 856762 | 856762 | 296368 296368 | 43767 | 1 | 0.090192768528766 |
| 856807 | 856807 | 296369 296369 | 43767 | 1 | 0.25531914893617 |
| 856810 | 856810 | 296370 296370 | 43767 | 1 | 0.149253731343284 |
| 944252 | 944252 | 338154 338154 | 43767 | 1 | 0.253012048192771 |
| 1173861 | 1173861 | 394085 394085 | 43767 | 1 | 0.090192768528766 |
| 1173924 | 1173924 | 394086 394086 | 43767 | 1 | 0.090192768528766 |
| 1173987 | 1173987 | 394087 394087 | 43767 | 1 | 0.090192768528766 |
| 1174050 | 1174050 | 394088 394088 | 43767 | 1 | 0.090192768528766 |
| 1174113 | 1174113 | 394089 394089 | 43767 | 1 | 0.090192768528766 |
| 1174176 | 1174176 | 394090 394090 | 43767 | 1 | 0.090192768528766 |
| 1429383 | 1429383 | 445716 445716 | 43767 | 1 | 0.090192768528766 |
| 1429446 | 1429446 | 445717 445717 | 43767 | 1 | 0.090192768528766 |
| 1429509 | 1429509 | 445718 445718 | 43767 | 1 | 0.090192768528766 |
| 1429572 | 1429572 | 445719 445719 | 43767 | 1 | 0.090192768528766 |
| 1586628 | 1586628 | 479015 479015 | 43767 | 1 | 0.090192768528766 |
| 1586691 | 1586691 | 479016 479016 | 43767 | 1 | 0.090192768528766 |
| 1586754 | 1586754 | 479017 479017 | 43767 | 1 | 0.090192768528766 |
| 1586817 | 1586817 | 479018 479018 | 43767 | 1 | 0.090192768528766 |
| 1606984 | 1606984 | 485501 485501 | 43767 | 1 | 0.090192768528766 |
| 1613206 | 1613206 | 487045 487045 | 43767 | 1 | 0.090192768528766 |
| 1718191 | 1718191 | 526216 526216 | 43767 | 1 | 0.25531914893617 |
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)
);