home / zeropm-v0-0-4

consensus_index

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

15 rows where inchi_id = 115828

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
26277 26277 7687 7687 115828 2 0.473684210526316
103225 103225 36314 36314 115828 2 0.473684210526316
134263 134263 47655 47655 115828 3 0.478260869565217
228177 228177 78436 78436 115828 2 0.384615384615385
393200 393200 135639 135639 115828 1 0.408628001184222
434547 434547 156125 156125 115828 1 0.466666666666667
494287 494287 187184 187184 115828 1 0.454545454545455
579691 579691 226943 226943 115828 1 0.454545454545455
684059 684059 244092 244092 115828 2 0.473684210526316
766046 766046 268259 268259 115828 1 0.454545454545455
766048 766048 268260 268260 115828 2 0.473684210526316
766051 766051 268261 268261 115828 2 0.384615384615385
927842 927842 330034 330034 115828 1 0.454545454545455
1620950 1620950 489484 489484 115828 2 0.473684210526316
1723053 1723053 527687 527687 115828 2 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 767.411ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website