consensus_index

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

12 rows where inchi_id = 63828

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
66474 66474 21944 21944 63828 6 0.384615384615385
91047 91047 32486 32486 63828 6 0.384615384615385
138708 138708 49399 49399 63828 6 0.384615384615385
378066 378066 129182 129182 63828 6 0.384615384615385
492063 492063 185149 185149 63828 1 0.3125
545813 545813 215977 215977 63828 6 0.384615384615385
721502 721502 255007 255007 63828 9 0.388888888888889
828208 828208 287382 287382 63828 6 0.384615384615385
828211 828211 287383 287383 63828 3 0.375
1692902 1692902 515590 515590 63828 6 0.384615384615385
1697764 1697764 517675 517675 63828 1 0.3125
1758611 1758611 539425 539425 63828 6 0.384615384615385 
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)
);