consensus_index
Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website
18 rows where inventory_id = 73789
Download this data as a CSV Spreadsheet (All Rows)
| Link | rowid ▼ | inventory_id | inchi_id | consensus_score | consensus_count |
|---|---|---|---|---|---|
| 209077 | 209077 | 73789 73789 | 48082 | 8 | 0.266225145445887 |
| 209078 | 209078 | 73789 73789 | 136252 | 2 | 0.133112572722943 |
| 209079 | 209079 | 73789 73789 | 148708 | 1 | 0.0532450290891774 |
| 209080 | 209080 | 73789 73789 | 192439 | 2 | 0.0443708575743145 |
| 209081 | 209081 | 73789 73789 | 195226 | 1 | 0.0190160818175633 |
| 209082 | 209082 | 73789 73789 | 195294 | 1 | 0.0242022859496261 |
| 209083 | 209083 | 73789 73789 | 195647 | 1 | 0.0332781431807358 |
| 209084 | 209084 | 73789 73789 | 199908 | 2 | 0.0443708575743145 |
| 209085 | 209085 | 73789 73789 | 202168 | 1 | 0.0204788573419913 |
| 209086 | 209086 | 73789 73789 | 208865 | 1 | 0.0887417151486289 |
| 209087 | 209087 | 73789 73789 | 217188 | 1 | 0.0166390715903679 |
| 209088 | 209088 | 73789 73789 | 217780 | 2 | 0.0665562863614717 |
| 209089 | 209089 | 73789 73789 | 235165 | 1 | 0.0380321636351267 |
| 209090 | 209090 | 73789 73789 | 249851 | 1 | 0.0295805717162096 |
| 209091 | 209091 | 73789 73789 | 274918 | 1 | 0.0532450290891774 |
| 209092 | 209092 | 73789 73789 | 291890 | 1 | 0.0266225145445887 |
| 209093 | 209093 | 73789 73789 | 294846 | 1 | 0.0156603026732875 |
| 209094 | 209094 | 73789 73789 | 326521 | 1 | 0.0177483430297258 |
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)
);