consensus_index

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

12 rows where inchi_id = 23892

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
45109 45109 13785 13785 23892 2 0.317504556494022
115875 115875 40430 40430 23892 2 0.317504556494022
187270 187270 66700 66700 23892 2 0.317504556494022
295720 295720 100089 100089 23892 2 0.317504556494022
330938 330938 111539 111539 23892 1 0.380952380952381
459679 459679 165257 165257 23892 1 0.311400580171955
474399 474399 172485 172485 23892 1 0.382978723404255
668544 668544 239521 239521 23892 2 0.317504556494022
838275 838275 290821 290821 23892 1 0.311400580171955
838279 838279 290822 290822 23892 2 0.317504556494022
941875 941875 337066 337066 23892 1 0.311400580171955
1739197 1739197 532734 532734 23892 2 0.317504556494022 
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)
);