consensus_index

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

8 rows where inchi_id = 19

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
135531 135531 48028 48028 19 15 0.359925987652625
219718 219718 76103 76103 19 7 0.422535211267606
300431 300431 101726 101726 19 1 0.310344827586207
428919 428919 154553 154553 19 7 0.422535211267606
461974 461974 165973 165973 19 1 0.310344827586207
668844 668844 239635 239635 19 11 0.426287744227353
737338 737338 259997 259997 19 5 0.41958041958042
737343 737343 259998 259998 19 8 0.42368278109723 
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)
);