home / zeropm-v0-0-4

consensus_index

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

10 rows where inchi_id = 7637

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
135915 135915 48158 48158 7637 3 0.382978723404255
144440 144440 51498 51498 7637 1 0.226111561530009
144464 144464 51507 51507 7637 7 0.620689655172414
226462 226462 77957 77957 7637 7 0.620689655172414
226543 226543 77979 77979 7637 1 0.20625
433686 433686 155859 155859 7637 4 0.833333333333333
585219 585219 228583 228583 7637 1 0.208333333333333
675941 675941 241627 241627 7637 1 0.189000994742078
877098 877098 304057 304057 7637 4 0.833333333333333
1619878 1619878 489158 489158 7637 8 0.9
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 1353.742ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website