consensus_index
Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website
20 rows where inchi_id = 50235
Download this data as a CSV Spreadsheet (All Rows)
| Link | rowid ▼ | inventory_id | inchi_id | consensus_score | consensus_count |
|---|---|---|---|---|---|
| 62125 | 62125 | 19982 19982 | 50235 | 1 | 0.043919971544508 |
| 140836 | 140836 | 50187 50187 | 50235 | 2 | 0.0570991446360562 |
| 141621 | 141621 | 50496 50496 | 50235 | 1 | 0.112 |
| 206123 | 206123 | 73055 73055 | 50235 | 1 | 0.0500119764630541 |
| 360247 | 360247 | 122318 122318 | 50235 | 1 | 0.0500119764630541 |
| 371006 | 371006 | 126337 126337 | 50235 | 1 | 0.113207547169811 |
| 507348 | 507348 | 202927 202927 | 50235 | 1 | 0.226415094339623 |
| 507410 | 507410 | 202949 202949 | 50235 | 1 | 0.0532855519347373 |
| 507510 | 507510 | 202994 202994 | 50235 | 4 | 0.833333333333333 |
| 529605 | 529605 | 210244 210244 | 50235 | 1 | 0.0532855519347373 |
| 529613 | 529613 | 210245 210245 | 50235 | 1 | 0.0542922615899877 |
| 556552 | 556552 | 219274 219274 | 50235 | 2 | 0.0663881210860227 |
| 662911 | 662911 | 237689 237689 | 50235 | 1 | 0.0500119764630541 |
| 708726 | 708726 | 251582 251582 | 50235 | 2 | 0.0570991446360562 |
| 807082 | 807082 | 281081 281081 | 50235 | 1 | 0.0542922615899877 |
| 807090 | 807090 | 281082 281082 | 50235 | 1 | 0.0542922615899877 |
| 807100 | 807100 | 281083 281083 | 50235 | 2 | 0.0663881210860227 |
| 807108 | 807108 | 281084 281084 | 50235 | 1 | 0.0542922615899877 |
| 1755818 | 1755818 | 538159 538159 | 50235 | 1 | 0.043919971544508 |
| 1757470 | 1757470 | 538872 538872 | 50235 | 1 | 0.113636363636364 |
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)
);