consensus_index
Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website
17 rows where inventory_id = 10067
Download this data as a CSV Spreadsheet (All Rows)
| Link | rowid ▼ | inventory_id | inchi_id | consensus_score | consensus_count |
|---|---|---|---|---|---|
| 34084 | 34084 | 10067 10067 | 11091 | 6 | 0.255522900293682 |
| 34085 | 34085 | 10067 10067 | 137053 | 2 | 0.165592577769802 |
| 34086 | 34086 | 10067 10067 | 148284 | 2 | 0.0740552520925396 |
| 34087 | 34087 | 10067 10067 | 200126 | 1 | 0.0204867684323998 |
| 34088 | 34088 | 10067 10067 | 216557 | 2 | 0.101404330182039 |
| 34089 | 34089 | 10067 10067 | 217171 | 1 | 0.0179259223783499 |
| 34090 | 34090 | 10067 10067 | 238966 | 2 | 0.0641337295958 |
| 34091 | 34091 | 10067 10067 | 239190 | 2 | 0.0413981444424505 |
| 34092 | 34092 | 10067 10067 | 239240 | 2 | 0.0409735368647997 |
| 34093 | 34093 | 10067 10067 | 240732 | 2 | 0.033801443394013 |
| 34094 | 34094 | 10067 10067 | 243217 | 2 | 0.0390305448850626 |
| 34095 | 34095 | 10067 10067 | 267621 | 2 | 0.0286814758053598 |
| 34096 | 34096 | 10067 10067 | 274014 | 1 | 0.0260740689139634 |
| 34097 | 34097 | 10067 10067 | 294528 | 1 | 0.0220626736964306 |
| 34098 | 34098 | 10067 10067 | 320533 | 1 | 0.0239012298377998 |
| 34099 | 34099 | 10067 10067 | 320762 | 1 | 0.0191209838702398 |
| 34100 | 34100 | 10067 10067 | 329602 | 1 | 0.016871456356094 |
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)
);