consensus_index

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

20 rows where inventory_id = 152991

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
421496 421496 152991 152991 45277 6 0.252179509356819
421497 421497 152991 152991 45290 1 0.0140099727420455
421498 421498 152991 152991 63043 1 0.0360256441938313
421499 421499 152991 152991 93562 4 0.149946833392512
421500 421500 152991 152991 137093 2 0.102951853584937
421501 421501 152991 152991 144678 2 0.0426261170576531
421502 421502 152991 152991 145087 2 0.046041468605105
421503 421503 152991 152991 152472 1 0.0148340887856952
421504 421504 152991 152991 210639 2 0.0204544591939608
421505 421505 152991 152991 231999 1 0.0420299182261365
421506 421506 152991 152991 232081 1 0.0315224386696024
421507 421507 152991 152991 232096 1 0.028019945484091
421508 421508 152991 152991 232133 1 0.0252179509356819
421509 421509 152991 152991 232134 1 0.0210149591130683
421510 421510 152991 152991 232135 1 0.0193984237966784
421511 421511 152991 152991 232170 1 0.0180128220969157
421512 421512 152991 152991 232174 1 0.0168119672904546
421513 421513 152991 152991 232192 1 0.0157612193348012
421514 421514 152991 152991 232462 2 0.0727979538056337
421515 421515 152991 152991 249110 1 0.022925409941529 
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)
);