consensus_index

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

10 rows where inventory_id = 223446

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
569829 569829 223446 223446 4338 2 0.0833950762849328
569830 569830 223446 223446 8465 1 0.072222254613293
569831 569831 223446 223446 27349 1 0.144444509226586
569832 569832 223446 223446 91300 1 0.0412698597790246
569833 569833 223446 223446 91919 6 0.288889018453172
569834 569834 223446 223446 121904 1 0.0481481697421953
569835 569835 223446 223446 137752 2 0.0745908238247561
569836 569836 223446 223446 146476 1 0.0412698597790246
569837 569837 223446 223446 192582 1 0.0577778036906344
569838 569838 223446 223446 217306 2 0.0833950762849328 
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)
);