home / zeropm-v0-0-4

consensus_index

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

17 rows where inchi_id = 46790

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
14068 14068 4321 4321 46790 1 0.253012048192771
53054 53054 16504 16504 46790 1 0.258620689655172
193956 193956 68903 68903 46790 1 0.101097805520718
223911 223911 77251 77251 46790 1 0.102766798418972
320008 320008 107845 107845 46790 2 0.214886757703598
358647 358647 121727 121727 46790 5 0.550591736736354
470131 470131 170141 170141 46790 2 0.214886757703598
485235 485235 179475 179475 46790 5 0.550591736736354
503004 503004 201297 201297 46790 1 0.112
518918 518918 207459 207459 46790 1 0.102766798418972
575530 575530 225447 225447 46790 2 0.214886757703598
590404 590404 230415 230415 46790 1 0.102766798418972
598856 598856 235741 235741 46790 1 0.103343465045593
598861 598861 235742 235742 46790 1 0.102766798418972
675838 675838 241585 241585 46790 1 0.101097805520718
750506 750506 263836 263836 46790 1 0.102766798418972
1665498 1665498 504948 504948 46790 1 0.259842519685039
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 1366.919ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website