consensus_index

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

11 rows where inventory_id = 525542

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
1715649 1715649 525542 525542 6801 1 0.0377381095004193
1715650 1715650 525542 525542 56065 8 0.301904876003355
1715651 1715651 525542 525542 71273 1 0.100634958667785
1715652 1715652 525542 525542 137217 2 0.150952438001677
1715653 1715653 525542 525542 167192 1 0.0754762190008386
1715654 1715654 525542 525542 204666 1 0.100634958667785
1715655 1715655 525542 525542 231765 1 0.0431292680004792
1715656 1715656 525542 525542 241833 1 0.0301904876003355
1715657 1715657 525542 525542 245816 1 0.0603809752006709
1715658 1715658 525542 525542 294834 1 0.0503174793338924
1715659 1715659 525542 525542 310061 1 0.0335449862225949 
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)
);