consensus_index
Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website
20 rows where inchi_id = 139100
Download this data as a CSV Spreadsheet (All Rows)
| Link | rowid ▼ | inventory_id | inchi_id | consensus_score | consensus_count |
|---|---|---|---|---|---|
| 49365 | 49365 | 15158 15158 | 139100 | 4 | 0.473684210526316 |
| 122060 | 122060 | 42402 42402 | 139100 | 4 | 0.473684210526316 |
| 186024 | 186024 | 66355 66355 | 139100 | 4 | 0.340909090909091 |
| 268957 | 268957 | 91172 91172 | 139100 | 1 | 0.172413793103448 |
| 305275 | 305275 | 103199 103199 | 139100 | 4 | 0.470588235294118 |
| 450191 | 450191 | 161480 161480 | 139100 | 1 | 0.172413793103448 |
| 464425 | 464425 | 166900 166900 | 139100 | 4 | 0.470588235294118 |
| 465433 | 465433 | 168053 168053 | 139100 | 2 | 0.455695089190719 |
| 527369 | 527369 | 209674 209674 | 139100 | 4 | 0.340909090909091 |
| 588050 | 588050 | 229671 229671 | 139100 | 4 | 0.470588235294118 |
| 677044 | 677044 | 241915 241915 | 139100 | 4 | 0.473684210526316 |
| 752546 | 752546 | 264486 264486 | 139100 | 4 | 0.340909090909091 |
| 752549 | 752549 | 264487 264487 | 139100 | 4 | 0.473684210526316 |
| 1001325 | 1001325 | 358527 358527 | 139100 | 2 | 0.149844697475966 |
| 1212464 | 1212464 | 402943 402943 | 139100 | 2 | 0.149844697475966 |
| 1455497 | 1455497 | 451939 451939 | 139100 | 2 | 0.149844697475966 |
| 1592325 | 1592325 | 480647 480647 | 139100 | 2 | 0.149844697475966 |
| 1657843 | 1657843 | 502360 502360 | 139100 | 4 | 0.473684210526316 |
| 1657854 | 1657854 | 502364 502364 | 139100 | 2 | 0.149844697475966 |
| 1743878 | 1743878 | 534074 534074 | 139100 | 2 | 0.454545454545455 |
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)
);