consensus_index
Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website
18 rows where inventory_id = 486005
Download this data as a CSV Spreadsheet (All Rows)
| Link | rowid ▼ | inventory_id | inchi_id | consensus_score | consensus_count |
|---|---|---|---|---|---|
| 1609791 | 1609791 | 486005 486005 | 23718 | 1 | 0.0636756002791535 |
| 1609792 | 1609792 | 486005 486005 | 63056 | 8 | 0.254702401116614 |
| 1609793 | 1609793 | 486005 486005 | 136811 | 1 | 0.127351200558307 |
| 1609794 | 1609794 | 486005 486005 | 137660 | 1 | 0.0849008003722047 |
| 1609795 | 1609795 | 486005 486005 | 147595 | 1 | 0.0318378001395768 |
| 1609796 | 1609796 | 486005 486005 | 185872 | 1 | 0.0181930286511867 |
| 1609797 | 1609797 | 486005 486005 | 186844 | 2 | 0.0805439713042315 |
| 1609798 | 1609798 | 486005 486005 | 187351 | 1 | 0.0363860573023734 |
| 1609799 | 1609799 | 486005 486005 | 192459 | 1 | 0.0849008003722047 |
| 1609800 | 1609800 | 486005 486005 | 199611 | 1 | 0.0254702401116614 |
| 1609801 | 1609801 | 486005 486005 | 203058 | 1 | 0.0169801600744409 |
| 1609802 | 1609802 | 486005 486005 | 227367 | 1 | 0.0212252000930512 |
| 1609803 | 1609803 | 486005 486005 | 233193 | 1 | 0.0283002667907349 |
| 1609804 | 1609804 | 486005 486005 | 253962 | 1 | 0.023154763737874 |
| 1609805 | 1609805 | 486005 486005 | 270864 | 1 | 0.0195924923935857 |
| 1609806 | 1609806 | 486005 486005 | 271988 | 1 | 0.0149824941833302 |
| 1609807 | 1609807 | 486005 486005 | 284000 | 1 | 0.0424504001861024 |
| 1609808 | 1609808 | 486005 486005 | 326579 | 1 | 0.0159189000697884 |
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)
);