consensus_index
Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website
42 rows where inchi_id = 142027
Download this data as a CSV Spreadsheet (All Rows)
| Link | rowid ▼ | inventory_id | inchi_id | consensus_score | consensus_count |
|---|---|---|---|---|---|
| 45182 | 45182 | 13801 13801 | 142027 | 1 | 0.074719800747198 |
| 49259 | 49259 | 15136 15136 | 142027 | 1 | 0.173228346456693 |
| 116287 | 116287 | 40545 40545 | 142027 | 1 | 0.074719800747198 |
| 128263 | 128263 | 45829 45829 | 142027 | 1 | 0.074719800747198 |
| 295820 | 295820 | 100116 100116 | 142027 | 1 | 0.074719800747198 |
| 304832 | 304832 | 103059 103059 | 142027 | 1 | 0.172413793103448 |
| 305786 | 305786 | 103338 103338 | 142027 | 3 | 0.154036673080485 |
| 464226 | 464226 | 166796 166796 | 142027 | 1 | 0.172413793103448 |
| 464629 | 464629 | 166994 166994 | 142027 | 3 | 0.154036673080485 |
| 489937 | 489937 | 183723 183723 | 142027 | 2 | 0.149327558746106 |
| 541086 | 541086 | 214307 214307 | 142027 | 1 | 0.074719800747198 |
| 587514 | 587514 | 229517 229517 | 142027 | 4 | 0.149196727317719 |
| 588506 | 588506 | 229817 229817 | 142027 | 1 | 0.172413793103448 |
| 668555 | 668555 | 239525 239525 | 142027 | 1 | 0.074719800747198 |
| 677365 | 677365 | 241996 241996 | 142027 | 3 | 0.154036673080485 |
| 838375 | 838375 | 290844 290844 | 142027 | 1 | 0.074719800747198 |
| 946574 | 946574 | 339202 339202 | 142027 | 2 | 0.11969516655643 |
| 953392 | 953392 | 342195 342195 | 142027 | 1 | 0.0980392156862745 |
| 1124353 | 1124353 | 384332 384332 | 142027 | 1 | 0.074719800747198 |
| 1124361 | 1124361 | 384333 384333 | 142027 | 1 | 0.074719800747198 |
| 1124369 | 1124369 | 384334 384334 | 142027 | 1 | 0.074719800747198 |
| 1362296 | 1362296 | 433391 433391 | 142027 | 1 | 0.074719800747198 |
| 1362304 | 1362304 | 433392 433392 | 142027 | 1 | 0.074719800747198 |
| 1362312 | 1362312 | 433393 433393 | 142027 | 1 | 0.074719800747198 |
| 1362320 | 1362320 | 433394 433394 | 142027 | 1 | 0.074719800747198 |
| 1362328 | 1362328 | 433395 433395 | 142027 | 1 | 0.074719800747198 |
| 1362336 | 1362336 | 433396 433396 | 142027 | 1 | 0.074719800747198 |
| 1362344 | 1362344 | 433397 433397 | 142027 | 1 | 0.074719800747198 |
| 1362352 | 1362352 | 433398 433398 | 142027 | 1 | 0.074719800747198 |
| 1362360 | 1362360 | 433399 433399 | 142027 | 1 | 0.074719800747198 |
| 1362368 | 1362368 | 433400 433400 | 142027 | 1 | 0.074719800747198 |
| 1362376 | 1362376 | 433401 433401 | 142027 | 1 | 0.074719800747198 |
| 1362384 | 1362384 | 433402 433402 | 142027 | 1 | 0.074719800747198 |
| 1548508 | 1548508 | 471431 471431 | 142027 | 1 | 0.074719800747198 |
| 1548516 | 1548516 | 471432 471432 | 142027 | 1 | 0.074719800747198 |
| 1548524 | 1548524 | 471433 471433 | 142027 | 1 | 0.074719800747198 |
| 1604056 | 1604056 | 484645 484645 | 142027 | 1 | 0.074719800747198 |
| 1651858 | 1651858 | 500318 500318 | 142027 | 1 | 0.074719800747198 |
| 1657434 | 1657434 | 502229 502229 | 142027 | 1 | 0.173228346456693 |
| 1658788 | 1658788 | 502669 502669 | 142027 | 3 | 0.154036673080485 |
| 1739268 | 1739268 | 532749 532749 | 142027 | 1 | 0.074719800747198 |
| 1743724 | 1743724 | 534039 534039 | 142027 | 1 | 0.0990458956412811 |
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)
);