consensus_index
Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website
12 rows where inchi_id = 49803
Download this data as a CSV Spreadsheet (All Rows)
| Link | rowid ▼ | inventory_id | inchi_id | consensus_score | consensus_count |
|---|---|---|---|---|---|
| 29209 | 29209 | 8461 8461 | 49803 | 1 | 0.155070415739335 |
| 82383 | 82383 | 29667 29667 | 49803 | 1 | 0.155070415739335 |
| 108801 | 108801 | 38146 38146 | 49803 | 8 | 0.9 |
| 175193 | 175193 | 62543 62543 | 49803 | 12 | 0.928571428571429 |
| 238828 | 238828 | 81254 81254 | 49803 | 8 | 0.9 |
| 238829 | 238829 | 81255 81255 | 49803 | 1 | 0.153846153846154 |
| 438146 | 438146 | 157054 157054 | 49803 | 2 | 0.183525594386367 |
| 476884 | 476884 | 173828 173828 | 49803 | 1 | 0.25 |
| 554991 | 554991 | 218817 218817 | 49803 | 1 | 0.153846153846154 |
| 554994 | 554994 | 218818 218818 | 49803 | 8 | 0.9 |
| 710501 | 710501 | 252048 252048 | 49803 | 8 | 0.9 |
| 1625545 | 1625545 | 490883 490883 | 49803 | 8 | 0.9 |
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)
);