consensus_index

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

13 rows where inventory_id = 231

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
1058 1058 231 231 759 1 0.0738649460252915
1059 1059 231 231 771 3 0.147729892050583
1060 1060 231 231 9320 1 0.147729892050583
1061 1061 231 231 75905 5 0.111958322374931
1062 1062 231 231 75906 1 0.0184662365063229
1063 1063 231 231 106400 2 0.0301552379400308
1064 1064 231 231 125489 1 0.0164144324500648
1065 1065 231 231 128617 2 0.0603104758800615
1066 1066 231 231 129506 6 0.104460808452924
1067 1067 231 231 133351 4 0.147729892050583
1068 1068 231 231 133397 1 0.0492432973501943
1069 1069 231 231 138986 2 0.0660668161867619
1070 1070 231 231 140205 1 0.0211042702929404 
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)
);