home / zeropm-v0-0-4

consensus_index

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

8 rows where inventory_id = 73346

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
207161 207161 73346 73346 41722 8 0.316921335597057
207162 207162 73346 73346 46393 1 0.0792303338992643
207163 207163 73346 73346 119280 1 0.0633842671194114
207164 207164 73346 73346 140661 1 0.0528202225995095
207165 207165 73346 73346 178525 1 0.0452744765138653
207166 207166 73346 73346 215809 1 0.105640445199019
207167 207167 73346 73346 225111 1 0.158460667798529
207168 207168 73346 73346 265626 1 0.158460667798529
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 1163.502ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website