home / zeropm-v0-0-4

consensus_index

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

15 rows where inventory_id = 7890

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
27113 27113 7890 7890 30575 8 0.270162403645047
27114 27114 7890 7890 46499 2 0.110293339435698
27115 27115 7890 7890 63043 1 0.135081201822523
27116 27116 7890 7890 120237 1 0.0192973145460748
27117 27117 7890 7890 139934 1 0.0900541345483488
27118 27118 7890 7890 216509 1 0.0540324807290093
27119 27119 7890 7890 256376 1 0.0385946290921495
27120 27120 7890 7890 256829 1 0.0675406009112616
27121 27121 7890 7890 274146 1 0.0270162403645047
27122 27122 7890 7890 274224 1 0.0450270672741744
27123 27123 7890 7890 274347 1 0.0300180448494496
27124 27124 7890 7890 288980 1 0.0245602185131861
27125 27125 7890 7890 289755 1 0.0225135336370872
27126 27126 7890 7890 322818 1 0.0337703004556308
27127 27127 7890 7890 322830 1 0.0207817233573113
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 1702.342ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website