consensus_index

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

11 rows where inventory_id = 471051

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
1545854 1545854 471051 471051 274 1 0.0328030728633972
1545855 1545855 471051 471051 21011 1 0.0369034569713218
1545856 1545856 471051 471051 21097 1 0.0492046092950957
1545857 1545857 471051 471051 37225 1 0.0295227655770575
1545858 1545858 471051 471051 73580 8 0.295227655770575
1545859 1545859 471051 471051 170329 1 0.147613827885287
1545860 1545860 471051 471051 201516 2 0.120526185765991
1545861 1545861 471051 471051 238874 1 0.0984092185901915
1545862 1545862 471051 471051 265921 1 0.0590455311541149
1545863 1545863 471051 471051 284669 1 0.0738069139426436
1545864 1545864 471051 471051 287435 1 0.0421753793957964 
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)
);