consensus_index
Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website
23 rows where inventory_id = 42992
Download this data as a CSV Spreadsheet (All Rows)
| Link | rowid ▼ | inventory_id | inchi_id | consensus_score | consensus_count |
|---|---|---|---|---|---|
| 123922 | 123922 | 42992 42992 | 1073 | 3 | 0.109467672854003 |
| 123923 | 123923 | 42992 42992 | 49220 | 2 | 0.0251136065029037 |
| 123924 | 123924 | 42992 42992 | 53081 | 1 | 0.109467672854003 |
| 123925 | 123925 | 42992 42992 | 54003 | 5 | 0.175748501338161 |
| 123926 | 123926 | 42992 42992 | 84323 | 1 | 0.0312764779582867 |
| 123927 | 123927 | 42992 42992 | 137046 | 1 | 0.0729784485693356 |
| 123928 | 123928 | 42992 42992 | 137627 | 1 | 0.0182446121423339 |
| 123929 | 123929 | 42992 42992 | 175623 | 1 | 0.0364892242846678 |
| 123930 | 123930 | 42992 42992 | 176824 | 1 | 0.0729784485693356 |
| 123931 | 123931 | 42992 42992 | 177231 | 1 | 0.0547338364270017 |
| 123932 | 123932 | 42992 42992 | 186533 | 1 | 0.0218935345708007 |
| 123933 | 123933 | 42992 42992 | 195195 | 1 | 0.0437870691416013 |
| 123934 | 123934 | 42992 42992 | 197883 | 1 | 0.0145956897138671 |
| 123935 | 123935 | 42992 42992 | 200002 | 1 | 0.0128785497475298 |
| 123936 | 123936 | 42992 42992 | 202593 | 1 | 0.0136834591067504 |
| 123937 | 123937 | 42992 42992 | 204708 | 1 | 0.0199032132461824 |
| 123938 | 123938 | 42992 42992 | 204867 | 1 | 0.0156382389791433 |
| 123939 | 123939 | 42992 42992 | 208893 | 1 | 0.0121630747615559 |
| 123940 | 123940 | 42992 42992 | 208894 | 1 | 0.0168411804390774 |
| 123941 | 123941 | 42992 42992 | 212779 | 1 | 0.0109467672854003 |
| 123942 | 123942 | 42992 42992 | 309510 | 2 | 0.0213659019847456 |
| 123943 | 123943 | 42992 42992 | 315681 | 1 | 0.0273669182135008 |
| 123944 | 123944 | 42992 42992 | 315682 | 1 | 0.0243261495231119 |
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)
);