home / zeropm-v0-0-4

consensus_index

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

10 rows where inchi_id = 137707

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
129383 129383 46125 46125 137707 1 0.114285714285714
215866 215866 74962 74962 137707 2 0.259842519685039
217184 217184 75366 75366 137707 1 0.0835820895522388
427140 427140 154026 154026 137707 1 0.113989637305699
734104 734104 258940 258940 137707 1 0.113636363636364
854775 854775 295654 295654 137707 1 0.113636363636364
854779 854779 295655 295655 137707 1 0.112
891327 891327 312487 312487 137707 1 0.112
1611750 1611750 486541 486541 137707 2 0.260869565217391
1612615 1612615 486844 486844 137707 1 0.113636363636364
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 553.327ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website