consensus_index

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

10 rows where inventory_id = 488475

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
1617740 1617740 488475 488475 3456 9 0.293653479841279
1617741 1617741 488475 488475 11831 1 0.0829446985461313
1617742 1617742 488475 488475 47694 1 0.0829446985461313
1617743 1617743 488475 488475 51315 2 0.165889397092263
1617744 1617744 488475 488475 97914 1 0.0414723492730656
1617745 1617745 488475 488475 140362 1 0.066355758836905
1617746 1617746 488475 488475 149842 1 0.0552964656974209
1617747 1617747 488475 488475 167740 1 0.0368643104649472
1617748 1617748 488475 488475 210580 1 0.0473969705977893
1617749 1617749 488475 488475 267472 1 0.110592931394842 
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)
);