home / zeropm-v0-0-4

consensus_index

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

12 rows where inchi_id = 339873

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
71102 71102 24080 24080 339873 4 0.473684210526316
105778 105778 37177 37177 339873 4 0.473684210526316
179606 179606 64122 64122 339873 2 0.454545454545455
391655 391655 134948 134948 339873 2 0.461538461538462
508534 508534 203459 203459 339873 2 0.454545454545455
541577 541577 214420 214420 339873 2 0.454545454545455
725680 725680 256385 256385 339873 2 0.454545454545455
837758 837758 290664 290664 339873 2 0.454545454545455
837787 837787 290665 290665 339873 2 0.16894076332975
960370 960370 345603 345603 339873 2 0.454545454545455
1707978 1707978 522284 522284 339873 2 0.454545454545455
1761025 1761025 540674 540674 339873 4 0.473684210526316
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 1039.289ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website