consensus_index

Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website

20 rows where inchi_id = 77886

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
93457 93457 33257 33257 77886 8 0.625
125897 125897 44974 44974 77886 6 0.465407604323691
125900 125900 44975 44975 77886 1 0.155844155844156
125904 125904 44976 44976 77886 11 0.482758620689655
215531 215531 74872 74872 77886 8 0.478260869565217
224118 224118 77334 77334 77886 1 0.153846153846154
426113 426113 153723 153723 77886 8 0.625
432192 432192 155455 155455 77886 1 0.153846153846154
476343 476343 173557 173557 77886 4 0.656703184093677
514377 514377 206387 206387 77886 8 0.625
518941 518941 207471 207471 77886 1 0.153846153846154
536345 536345 212858 212858 77886 8 0.478260869565217
590159 590159 230345 230345 77886 1 0.153846153846154
676066 676066 241644 241644 77886 1 0.153846153846154
750831 750831 263968 263968 77886 1 0.153846153846154
750835 750835 263969 263969 77886 1 0.151898734177215
892977 892977 313286 313286 77886 1 0.150943396226415
1611581 1611581 486487 486487 77886 8 0.625
1618481 1618481 488685 488685 77886 1 0.153846153846154
1672414 1672414 507485 507485 77886 4 0.656703184093677 
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)
);