consensus_index

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

9 rows where inventory_id = 73781

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
209007 209007 73781 73781 48074 6 0.253412292410176
209008 209008 73781 73781 132648 2 0.253412292410176
209009 209009 73781 73781 143869 1 0.0422353820683627
209010 209010 73781 73781 195285 2 0.103455135158983
209011 209011 73781 73781 195699 2 0.0801360031100757
209012 209012 73781 73781 201384 1 0.063353073102544
209013 209013 73781 73781 201987 1 0.0844707641367253
209014 209014 73781 73781 237464 1 0.063353073102544
209015 209015 73781 73781 266533 2 0.0428344954261934 
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)
);