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

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
147800 147800 53234 53234 47313 80 0.280065477689588
147801 147801 53234 53234 63103 23 0.124962035003556
147802 147802 53234 53234 87544 2 0.207108709312088
147803 147803 53234 53234 172907 2 0.0654935244683923
147804 147804 53234 53234 186281 1 0.0585791891189484
147805 147805 53234 53234 186637 28 0.129880723813573
147806 147806 53234 53234 192074 1 0.0585791891189484
147807 147807 53234 53234 262843 1 0.0732239863986855
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 2166.378ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website