consensus_index
Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website
17 rows where inventory_id = 486202
Download this data as a CSV Spreadsheet (All Rows)
| Link | rowid ▼ | inventory_id | inchi_id | consensus_score | consensus_count |
|---|---|---|---|---|---|
| 1610684 | 1610684 | 486202 486202 | 75401 | 5 | 0.234845648708928 |
| 1610685 | 1610685 | 486202 486202 | 92545 | 2 | 0.0853077557825181 |
| 1610686 | 1610686 | 486202 486202 | 169000 | 2 | 0.110131839149341 |
| 1610687 | 1610687 | 486202 486202 | 171210 | 3 | 0.148458396990429 |
| 1610688 | 1610688 | 486202 486202 | 173581 | 2 | 0.0603216926016244 |
| 1610689 | 1610689 | 486202 486202 | 197801 | 1 | 0.0192690578821541 |
| 1610690 | 1610690 | 486202 486202 | 199605 | 2 | 0.0603216926016244 |
| 1610691 | 1610691 | 486202 486202 | 237489 | 1 | 0.0299740900389063 |
| 1610692 | 1610692 | 486202 486202 | 237700 | 1 | 0.0337208512937696 |
| 1610693 | 1610693 | 486202 486202 | 241524 | 2 | 0.0389374851435224 |
| 1610694 | 1610694 | 486202 486202 | 241857 | 1 | 0.0168604256468848 |
| 1610695 | 1610695 | 486202 486202 | 264422 | 1 | 0.0158686359029504 |
| 1610696 | 1610696 | 486202 486202 | 275153 | 2 | 0.024939950439381 |
| 1610697 | 1610697 | 486202 486202 | 282133 | 2 | 0.0322433009579393 |
| 1610698 | 1610698 | 486202 486202 | 288691 | 2 | 0.0332059989027397 |
| 1610699 | 1610699 | 486202 486202 | 288693 | 2 | 0.0294339721051521 |
| 1610700 | 1610700 | 486202 486202 | 321865 | 1 | 0.0179844540233438 |
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)
);