home / zeropm-v0-0-4

consensus_index

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

13 rows where inchi_id = 123842

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
9684 9684 2935 2935 123842 1 0.0945933700923838
45790 45790 13970 13970 123842 6 0.334271340633088
161518 161518 57963 57963 123842 1 0.0269384096160544
297088 297088 100487 100487 123842 6 0.272243401966932
460800 460800 165605 165605 123842 1 0.0963787615748977
479894 479894 175598 175598 123842 1 0.0411874936163183
502378 502378 200665 200665 123842 1 0.0411874936163183
538784 538784 213668 213668 123842 1 0.0391484356161702
727493 727493 256865 256865 123842 6 0.334271340633088
843211 843211 292178 292178 123842 1 0.0391484356161702
843378 843378 292227 292227 123842 1 0.0963787615748977
931087 931087 331505 331505 123842 3 0.336
1739859 1739859 532887 532887 123842 6 0.334271340633088
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 1406.358ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website