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 = 107799

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
14157 14157 4352 4352 107799 2 0.309102636750802
31150 31150 9122 9122 107799 2 0.309102636750802
181988 181988 64986 64986 107799 2 0.260627970527265
244875 244875 83328 83328 107799 2 0.260627970527265
440854 440854 158048 158048 107799 1 0.31304347826087
719044 719044 254240 254240 107799 2 0.309102636750802
823674 823674 285906 285906 107799 2 0.309102636750802
823679 823679 285907 285907 107799 1 0.311688311688312
927707 927707 329975 329975 107799 1 0.311688311688312
1629264 1629264 492260 492260 107799 2 0.315789473684211
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 1404.662ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website