consensus_index

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

10 rows where inventory_id = 294323

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
850754 850754 294323 294323 51651 1 0.128011753948592
850755 850755 294323 294323 66029 1 0.032002938487148
850756 850756 294323 294323 79580 1 0.256023507897184
850757 850757 294323 294323 101684 3 0.256023507897184
850758 850758 294323 294323 159706 1 0.0512047015794368
850759 850759 294323 294323 161203 1 0.0426705846495307
850760 850760 294323 294323 174074 1 0.0853411692990614
850761 850761 294323 294323 192485 1 0.0284470564330205
850762 850762 294323 294323 260865 1 0.064005876974296
850763 850763 294323 294323 290895 1 0.0365747868424549 
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)
);