consensus_index
Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website
18 rows where inventory_id = 34011
Download this data as a CSV Spreadsheet (All Rows)
| Link | rowid ▼ | inventory_id | inchi_id | consensus_score | consensus_count |
|---|---|---|---|---|---|
| 96005 | 96005 | 34011 34011 | 2321 | 3 | 0.0717222062207448 |
| 96006 | 96006 | 34011 34011 | 45335 | 5 | 0.168894455840956 |
| 96007 | 96007 | 34011 34011 | 58158 | 4 | 0.187400132202635 |
| 96008 | 96008 | 34011 34011 | 195734 | 1 | 0.0171428900436788 |
| 96009 | 96009 | 34011 34011 | 196240 | 1 | 0.027857196320978 |
| 96010 | 96010 | 34011 34011 | 197729 | 1 | 0.0247619522853138 |
| 96011 | 96011 | 34011 34011 | 200092 | 1 | 0.0557143926419561 |
| 96012 | 96012 | 34011 34011 | 228431 | 1 | 0.013928598160489 |
| 96013 | 96013 | 34011 34011 | 233002 | 1 | 0.0159183978977017 |
| 96014 | 96014 | 34011 34011 | 248566 | 1 | 0.0371429284279707 |
| 96015 | 96015 | 34011 34011 | 248571 | 1 | 0.0742858568559414 |
| 96016 | 96016 | 34011 34011 | 248582 | 3 | 0.176882170979221 |
| 96017 | 96017 | 34011 34011 | 248584 | 1 | 0.0131092688569308 |
| 96018 | 96018 | 34011 34011 | 248984 | 1 | 0.0318367957954035 |
| 96019 | 96019 | 34011 34011 | 261625 | 1 | 0.0148571713711883 |
| 96020 | 96020 | 34011 34011 | 315679 | 1 | 0.0222857570567824 |
| 96021 | 96021 | 34011 34011 | 315681 | 1 | 0.0202597791425295 |
| 96022 | 96022 | 34011 34011 | 315682 | 1 | 0.0185714642139854 |
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)
);