consensus_index
Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website
21 rows where inchi_id = 36703
Download this data as a CSV Spreadsheet (All Rows)
| Link | rowid ▼ | inventory_id | inchi_id | consensus_score | consensus_count |
|---|---|---|---|---|---|
| 59889 | 59889 | 19008 19008 | 36703 | 5 | 0.380952380952381 |
| 80815 | 80815 | 29143 29143 | 36703 | 5 | 0.380952380952381 |
| 143426 | 143426 | 51129 51129 | 36703 | 3 | 0.375 |
| 348862 | 348862 | 117857 117857 | 36703 | 5 | 0.380952380952381 |
| 373844 | 373844 | 127460 127460 | 36703 | 1 | 0.0617076301917323 |
| 507025 | 507025 | 202769 202769 | 36703 | 3 | 0.375 |
| 562962 | 562962 | 221273 221273 | 36703 | 3 | 0.375 |
| 700588 | 700588 | 249608 249608 | 36703 | 5 | 0.380952380952381 |
| 795337 | 795337 | 277564 277564 | 36703 | 3 | 0.375 |
| 795341 | 795341 | 277565 277565 | 36703 | 3 | 0.276923076923077 |
| 795344 | 795344 | 277566 277566 | 36703 | 4 | 0.378378378378378 |
| 887281 | 887281 | 309317 309317 | 36703 | 3 | 0.375 |
| 1053350 | 1053350 | 372397 372397 | 36703 | 5 | 0.325116492253909 |
| 1053353 | 1053353 | 372398 372398 | 36703 | 5 | 0.325116492253909 |
| 1275884 | 1275884 | 419670 419670 | 36703 | 5 | 0.325116492253909 |
| 1275887 | 1275887 | 419671 419671 | 36703 | 5 | 0.325116492253909 |
| 1275890 | 1275890 | 419672 419672 | 36703 | 5 | 0.325116492253909 |
| 1494212 | 1494212 | 462275 462275 | 36703 | 5 | 0.325116492253909 |
| 1598922 | 1598922 | 482959 482959 | 36703 | 5 | 0.325116492253909 |
| 1677875 | 1677875 | 509532 509532 | 36703 | 5 | 0.325116492253909 |
| 1753856 | 1753856 | 537366 537366 | 36703 | 5 | 0.380952380952381 |
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)
);