consensus_index
Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website
52 rows where inventory_id = 104201
Download this data as a CSV Spreadsheet (All Rows)
| Link | rowid ▼ | inventory_id | inchi_id | consensus_score | consensus_count |
|---|---|---|---|---|---|
| 308378 | 308378 | 104201 104201 | 8701 | 5 | 0.0833812923775558 |
| 308379 | 308379 | 104201 104201 | 29494 | 1 | 0.0159801008768998 |
| 308380 | 308380 | 104201 104201 | 78315 | 1 | 0.00903223093042163 |
| 308381 | 308381 | 104201 104201 | 119329 | 7 | 0.142491937695374 |
| 308382 | 308382 | 104201 104201 | 154986 | 1 | 0.00799005043844991 |
| 308383 | 308383 | 104201 104201 | 207688 | 1 | 0.00799005043844991 |
| 308384 | 308384 | 104201 104201 | 207698 | 1 | 0.0129838319624811 |
| 308385 | 308385 | 104201 104201 | 207700 | 1 | 0.0122200771411587 |
| 308386 | 308386 | 104201 104201 | 246889 | 1 | 0.0083096524559879 |
| 308387 | 308387 | 104201 104201 | 261263 | 1 | 0.0074193325499892 |
| 308388 | 308388 | 104201 104201 | 261264 | 1 | 0.00451611546521082 |
| 308389 | 308389 | 104201 104201 | 274096 | 1 | 0.00546687661578152 |
| 308390 | 308390 | 104201 104201 | 314216 | 2 | 0.0207741311399698 |
| 308391 | 308391 | 104201 104201 | 314302 | 4 | 0.0289651251221052 |
| 308392 | 308392 | 104201 104201 | 314600 | 4 | 0.0337234692651016 |
| 308393 | 308393 | 104201 104201 | 314709 | 4 | 0.103870655699849 |
| 308394 | 308394 | 104201 104201 | 315060 | 1 | 0.0188855737636089 |
| 308395 | 308395 | 104201 104201 | 315090 | 2 | 0.0096337726352265 |
| 308396 | 308396 | 104201 104201 | 315098 | 2 | 0.0149924377573027 |
| 308397 | 308397 | 104201 104201 | 315561 | 1 | 0.0115411839666499 |
| 308398 | 308398 | 104201 104201 | 315581 | 4 | 0.0567158888298855 |
| 308399 | 308399 | 104201 104201 | 315640 | 1 | 0.0098924433999856 |
| 308400 | 308400 | 104201 104201 | 315641 | 1 | 0.00944278688180443 |
| 308401 | 308401 | 104201 104201 | 315677 | 1 | 0.010933753231563 |
| 308402 | 308402 | 104201 104201 | 315686 | 3 | 0.0177616322812278 |
| 308403 | 308403 | 104201 104201 | 315688 | 4 | 0.016928251642355 |
| 308404 | 308404 | 104201 104201 | 315696 | 4 | 0.0536385759580212 |
| 308405 | 308405 | 104201 104201 | 315701 | 4 | 0.0219604812276379 |
| 308406 | 308406 | 104201 104201 | 315702 | 2 | 0.0160275901372457 |
| 308407 | 308407 | 104201 104201 | 315716 | 3 | 0.0143092122837474 |
| 308408 | 308408 | 104201 104201 | 316303 | 4 | 0.0209221495759226 |
| 308409 | 308409 | 104201 104201 | 316921 | 4 | 0.00973189031265155 |
| 308410 | 308410 | 104201 104201 | 317023 | 2 | 0.0120543735112073 |
| 308411 | 308411 | 104201 104201 | 317326 | 2 | 0.00925353348019981 |
| 308412 | 308412 | 104201 104201 | 317329 | 4 | 0.0105007991691099 |
| 308413 | 308413 | 104201 104201 | 317547 | 4 | 0.0125583160888011 |
| 308414 | 308414 | 104201 104201 | 317838 | 2 | 0.00829638883627048 |
| 308415 | 308415 | 104201 104201 | 317881 | 2 | 0.00656935708133346 |
| 308416 | 308416 | 104201 104201 | 317895 | 2 | 0.0086558879749874 |
| 308417 | 308417 | 104201 104201 | 317936 | 1 | 0.0148386650999784 |
| 308418 | 308418 | 104201 104201 | 317948 | 2 | 0.00796651562904036 |
| 308419 | 308419 | 104201 104201 | 318014 | 2 | 0.00766265370828874 |
| 308420 | 308420 | 104201 104201 | 318044 | 2 | 0.0118371598007953 |
| 308421 | 308421 | 104201 104201 | 318058 | 2 | 0.00679023718337444 |
| 308422 | 308422 | 104201 104201 | 318147 | 4 | 0.00810564789062398 |
| 308423 | 308423 | 104201 104201 | 318244 | 4 | 0.00866341811518742 |
| 308424 | 308424 | 104201 104201 | 318325 | 4 | 0.00810988509427243 |
| 308425 | 308425 | 104201 104201 | 318385 | 4 | 0.00800487597292574 |
| 308426 | 308426 | 104201 104201 | 320404 | 1 | 0.0071634934965413 |
| 308427 | 308427 | 104201 104201 | 320680 | 1 | 0.0071634934965413 |
| 308428 | 308428 | 104201 104201 | 320723 | 2 | 0.00842502269070681 |
| 308429 | 308429 | 104201 104201 | 329621 | 4 | 0.00733732385740438 |
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)
);