home / zeropm-v0-0-4

consensus_index

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

6 rows where inventory_id = 300009

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
869747 869747 300009 300009 16227 4 0.392156862745098
869748 869748 300009 300009 137162 1 0.196078431372549
869749 869749 300009 300009 140573 1 0.0980392156862745
869750 869750 300009 300009 141299 1 0.130718954248366
869751 869751 300009 300009 247676 1 0.065359477124183
869752 869752 300009 300009 257048 1 0.0784313725490196
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)
);
Powered by Datasette · Queries took 1535.281ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website