consensus_index

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

12 rows where inventory_id = 57964

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
161525 161525 57964 57964 748 3 0.104380199065432
161526 161526 57964 57964 39169 1 0.0552310792670392
161527 161527 57964 57964 75859 2 0.165693237801118
161528 161528 57964 57964 75887 1 0.0828466189005588
161529 161529 57964 57964 120116 10 0.154597257342996
161530 161530 57964 57964 133053 2 0.0956630354473759
161531 161531 57964 57964 133445 6 0.0837425618758849
161532 161532 57964 57964 139004 1 0.0331386475602235
161533 161533 57964 57964 145572 2 0.0676439810737286
161534 161534 57964 57964 220270 1 0.0414233094502794
161535 161535 57964 57964 224656 1 0.0276155396335196
161536 161536 57964 57964 238341 1 0.0828466189005588 
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)
);