consensus_index

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

9 rows where inventory_id = 497942

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
1644937 1644937 497942 497942 42923 5 0.307550721277852
1644938 1644938 497942 497942 75525 1 0.0341723023642058
1644939 1644939 497942 497942 124014 3 0.213243760032669
1644940 1644940 497942 497942 199390 1 0.0384438401597315
1644941 1644941 497942 497942 229907 1 0.153775360638926
1644942 1644942 497942 497942 234379 1 0.0768876803194631
1644943 1644943 497942 497942 235220 1 0.0512584535463087
1644944 1644944 497942 497942 275083 1 0.0439358173254075
1644945 1644945 497942 497942 289352 1 0.0615101442555705 
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)
);