consensus_index

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

24 rows where inventory_id = 61218

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
171550 171550 61218 61218 137043 3 0.122601769438622
171551 171551 61218 61218 141173 2 0.0280907143326238
171552 171552 61218 61218 189117 1 0.0278025968257187
171553 171553 61218 61218 192032 2 0.194618177780031
171554 171554 61218 61218 217815 1 0.0973090888900153
171555 171555 61218 61218 222711 3 0.0327423844604082
171556 171556 61218 61218 235005 3 0.0850073190956054
171557 171557 61218 61218 235006 3 0.039456902308952
171558 171558 61218 61218 237478 2 0.0239558416746248
171559 171559 61218 61218 243001 1 0.0149706290600024
171560 171560 61218 61218 243368 2 0.0217589737586644
171561 171561 61218 61218 259555 2 0.023261321397922
171562 171562 61218 61218 260192 1 0.0324363629633384
171563 171563 61218 61218 264249 1 0.0129745451853354
171564 171564 61218 61218 275523 3 0.0425036595478027
171565 171565 61218 61218 276489 1 0.0194618177780031
171566 171566 61218 61218 288177 2 0.0183896892506613
171567 171567 61218 61218 292145 1 0.021624241975559
171568 171568 61218 61218 309430 1 0.0114481281047077
171569 171569 61218 61218 319447 1 0.021624241975559
171570 171570 61218 61218 320759 1 0.0108121209877795
171571 171571 61218 61218 320961 1 0.0102430619884227
171572 171572 61218 61218 321738 1 0.021624241975559
171573 171573 61218 61218 326254 1 0.00973090888900153 
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)
);