consensus_index

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

20 rows where inchi_id = 75536

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
31590 31590 9281 9281 75536 8 0.625
77884 77884 28079 28079 75536 1 0.192307692307692
84827 84827 30525 30525 75536 8 0.625
247276 247276 84154 84154 75536 6 0.615384615384615
247759 247759 84312 84312 75536 1 0.161764705882353
441935 441935 158425 158425 75536 1 0.161764705882353
536471 536471 212912 212912 75536 1 0.161764705882353
539088 539088 213755 213755 75536 11 0.634146341463415
842326 842326 291945 291945 75536 8 0.625
842328 842328 291946 291946 75536 7 0.620689655172414
849183 849183 293772 293772 75536 1 0.192307692307692
884276 884276 307738 307738 75536 4 0.6
888524 888524 309904 309904 75536 1 0.1875
1169605 1169605 392820 392820 75536 1 0.192307692307692
1425182 1425182 444401 444401 75536 1 0.192307692307692
1583812 1583812 478140 478140 75536 1 0.192307692307692
1606130 1606130 485224 485224 75536 1 0.192307692307692
1630353 1630353 492683 492683 75536 8 0.625
1630585 1630585 492767 492767 75536 1 0.192307692307692
1727972 1727972 529179 529179 75536 1 0.192307692307692 
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)
);