consensus_index

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

8 rows where inventory_id = 87284

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
257814 257814 87284 87284 1524 1 0.132137823996693
257815 257815 87284 87284 12497 1 0.0660689119983467
257816 257816 87284 87284 12970 5 0.264275647993387
257817 257817 87284 87284 32135 1 0.0880918826644622
257818 257818 87284 87284 106891 2 0.264275647993387
257819 257819 87284 87284 167814 1 0.0440459413322311
257820 257820 87284 87284 195222 2 0.0706306378899233
257821 257821 87284 87284 243517 1 0.0528551295986774 
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)
);