consensus_index
Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website
20 rows where inchi_id = 85238
Download this data as a CSV Spreadsheet (All Rows)
| Link | rowid ▼ | inventory_id | inchi_id | consensus_score | consensus_count |
|---|---|---|---|---|---|
| 19601 | 19601 | 5753 5753 | 85238 | 8 | 0.519685039370079 |
| 58993 | 58993 | 18662 18662 | 85238 | 1 | 0.177154801914002 |
| 102502 | 102502 | 36107 36107 | 85238 | 1 | 0.177154801914002 |
| 102531 | 102531 | 36115 36115 | 85238 | 8 | 0.519685039370079 |
| 195623 | 195623 | 69350 69350 | 85238 | 12 | 0.526315789473684 |
| 218059 | 218059 | 75618 75618 | 85238 | 7 | 0.519685039370079 |
| 344485 | 344485 | 116361 116361 | 85238 | 1 | 0.170454545454545 |
| 427700 | 427700 | 154192 154192 | 85238 | 7 | 0.519685039370079 |
| 479946 | 479946 | 175646 175646 | 85238 | 1 | 0.170454545454545 |
| 533094 | 533094 | 211475 211475 | 85238 | 8 | 0.413793103448276 |
| 856869 | 856869 | 296388 296388 | 85238 | 4 | 0.506024096385542 |
| 856872 | 856872 | 296389 296389 | 85238 | 8 | 0.519685039370079 |
| 856875 | 856875 | 296390 296390 | 85238 | 8 | 0.519685039370079 |
| 917920 | 917920 | 325362 325362 | 85238 | 4 | 0.506024096385542 |
| 1174235 | 1174235 | 394095 394095 | 85238 | 8 | 0.519685039370079 |
| 1429631 | 1429631 | 445724 445724 | 85238 | 8 | 0.519685039370079 |
| 1586876 | 1586876 | 479023 479023 | 85238 | 8 | 0.519685039370079 |
| 1607037 | 1607037 | 485504 485504 | 85238 | 8 | 0.519685039370079 |
| 1613275 | 1613275 | 487052 487052 | 85238 | 8 | 0.519685039370079 |
| 1676200 | 1676200 | 508897 508897 | 85238 | 1 | 0.177154801914002 |
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)
);