consensus_index

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

10 rows where inventory_id = 215020

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
543549 543549 215020 215020 43729 1 0.0421455938697318
543550 543550 215020 215020 68380 9 0.210727969348659
543551 543551 215020 215020 103356 3 0.210727969348659
543552 543552 215020 215020 173430 1 0.070242656449553
543553 543553 215020 215020 182398 1 0.0526819923371648
543554 543554 215020 215020 186713 1 0.10536398467433
543555 543555 215020 215020 219091 1 0.070242656449553
543556 543556 215020 215020 220485 1 0.070242656449553
543557 543557 215020 215020 243103 2 0.10536398467433
543558 543558 215020 215020 284697 1 0.0526819923371648 
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)
);