home / zeropm-v0-0-4

consensus_index

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

12 rows where inchi_id = 198742

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
11639 11639 3514 3514 198742 2 0.127333199816094
27348 27348 7936 7936 198742 2 0.127333199816094
80391 80391 29003 29003 198742 2 0.127333199816094
138430 138430 49291 49291 198742 2 0.0856988821014906
231114 231114 79104 79104 198742 1 0.138089371490047
435865 435865 156411 156411 198742 1 0.138089371490047
698480 698480 248982 248982 198742 3 0.105695637736482
791856 791856 276455 276455 198742 1 0.138089371490047
791866 791866 276456 276456 198742 2 0.112552845812306
914297 914297 323434 323434 198742 1 0.138089371490047
1622335 1622335 489838 489838 198742 1 0.134701720434543
1724044 1724044 527943 527943 198742 2 0.116149348414568
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 796.854ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website