home / zeropm-v0-0-4

consensus_index

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

11 rows where inchi_id = 147523

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
24297 24297 7120 7120 147523 1 0.230769230769231
58651 58651 18523 18523 147523 4 0.5
100020 100020 35372 35372 147523 4 0.5
187701 187701 66821 66821 147523 1 0.189239332096475
271139 271139 91965 91965 147523 1 0.187951807228916
504965 504965 201996 201996 147523 1 0.187951807228916
564923 564923 221908 221908 147523 1 0.187951807228916
698447 698447 248970 248970 147523 1 0.189239332096475
791770 791770 276428 276428 147523 1 0.230769230769231
900760 900760 316979 316979 147523 1 0.226415094339623
1641520 1641520 496712 496712 147523 1 0.230769230769231
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 822.208ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website