consensus_index

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

10 rows where inventory_id = 3430

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
11243 11243 3430 3430 10444 8 0.183821229021522
11244 11244 3430 3430 46272 1 0.0728671711469797
11245 11245 3430 3430 54956 14 0.192340584817995
11246 11246 3430 3430 54958 5 0.0673585398415841
11247 11247 3430 3430 69413 1 0.10930075672047
11248 11248 3430 3430 101941 2 0.218601513440939
11249 11249 3430 3430 202128 1 0.0364335855734898
11250 11250 3430 3430 202403 1 0.0273251891801174
11251 11251 3430 3430 202508 1 0.0546503783602348
11252 11252 3430 3430 202729 1 0.0312287876344199 
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)
);