consensus_index
Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website
46 rows where inchi_id = 139487
Download this data as a CSV Spreadsheet (All Rows)
| Link | rowid ▼ | inventory_id | inchi_id | consensus_score | consensus_count |
|---|---|---|---|---|---|
| 54805 | 54805 | 17124 17124 | 139487 | 2 | 0.189251606107572 |
| 69581 | 69581 | 23381 23381 | 139487 | 1 | 0.145085729088083 |
| 114750 | 114750 | 40059 40059 | 139487 | 2 | 0.189251606107572 |
| 150984 | 150984 | 54112 54112 | 139487 | 1 | 0.14147725704779 |
| 187483 | 187483 | 66770 66770 | 139487 | 4 | 0.261921324930619 |
| 338094 | 338094 | 113993 113993 | 139487 | 2 | 0.183815178951643 |
| 477243 | 477243 | 174025 174025 | 139487 | 1 | 0.174783397772137 |
| 493132 | 493132 | 185957 185957 | 139487 | 1 | 0.14147725704779 |
| 542993 | 542993 | 214840 214840 | 139487 | 1 | 0.144045527299549 |
| 567595 | 567595 | 222765 222765 | 139487 | 1 | 0.174783397772137 |
| 661855 | 661855 | 237178 237178 | 139487 | 2 | 0.183815178951643 |
| 695652 | 695652 | 248038 248038 | 139487 | 2 | 0.189251606107572 |
| 785783 | 785783 | 274585 274585 | 139487 | 3 | 0.249416671324075 |
| 785788 | 785788 | 274586 274586 | 139487 | 1 | 0.174783397772137 |
| 785793 | 785793 | 274587 274587 | 139487 | 3 | 0.255900916997318 |
| 785798 | 785798 | 274588 274588 | 139487 | 1 | 0.160900002131653 |
| 785803 | 785803 | 274589 274589 | 139487 | 2 | 0.189251606107572 |
| 835090 | 835090 | 289735 289735 | 139487 | 1 | 0.144045527299549 |
| 835093 | 835093 | 289736 289736 | 139487 | 1 | 0.145085729088083 |
| 1046712 | 1046712 | 370455 370455 | 139487 | 3 | 0.260983302651512 |
| 1046717 | 1046717 | 370456 370456 | 139487 | 3 | 0.260983302651512 |
| 1046722 | 1046722 | 370457 370457 | 139487 | 3 | 0.260983302651512 |
| 1046727 | 1046727 | 370458 370458 | 139487 | 3 | 0.260983302651512 |
| 1046732 | 1046732 | 370459 370459 | 139487 | 3 | 0.260983302651512 |
| 1046737 | 1046737 | 370460 370460 | 139487 | 3 | 0.260983302651512 |
| 1267984 | 1267984 | 417349 417349 | 139487 | 3 | 0.260983302651512 |
| 1267989 | 1267989 | 417350 417350 | 139487 | 3 | 0.260983302651512 |
| 1267994 | 1267994 | 417351 417351 | 139487 | 3 | 0.260983302651512 |
| 1267999 | 1267999 | 417352 417352 | 139487 | 3 | 0.260983302651512 |
| 1268004 | 1268004 | 417353 417353 | 139487 | 3 | 0.260983302651512 |
| 1268009 | 1268009 | 417354 417354 | 139487 | 3 | 0.260983302651512 |
| 1268014 | 1268014 | 417355 417355 | 139487 | 3 | 0.260983302651512 |
| 1268019 | 1268019 | 417356 417356 | 139487 | 3 | 0.260983302651512 |
| 1268024 | 1268024 | 417357 417357 | 139487 | 3 | 0.260983302651512 |
| 1268029 | 1268029 | 417358 417358 | 139487 | 3 | 0.260983302651512 |
| 1489290 | 1489290 | 460818 460818 | 139487 | 3 | 0.260983302651512 |
| 1489295 | 1489295 | 460819 460819 | 139487 | 3 | 0.260983302651512 |
| 1489300 | 1489300 | 460820 460820 | 139487 | 3 | 0.260983302651512 |
| 1489305 | 1489305 | 460821 460821 | 139487 | 3 | 0.260983302651512 |
| 1489310 | 1489310 | 460822 460822 | 139487 | 3 | 0.260983302651512 |
| 1489315 | 1489315 | 460823 460823 | 139487 | 3 | 0.260983302651512 |
| 1597559 | 1597559 | 482467 482467 | 139487 | 3 | 0.260983302651512 |
| 1673382 | 1673382 | 507823 507823 | 139487 | 3 | 0.260983302651512 |
| 1751553 | 1751553 | 536555 536555 | 139487 | 3 | 0.255900916997318 |
| 1755812 | 1755812 | 538156 538156 | 139487 | 3 | 0.42052772921983 |
| 1760328 | 1760328 | 540381 540381 | 139487 | 1 | 0.145085729088083 |
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)
);