consensus_index

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

23 rows where inchi_id = 137143

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
29842 29842 8648 8648 137143 1 0.155995964536346
108024 108024 37933 37933 137143 2 0.268427203496603
172477 172477 61571 61571 137143 1 0.0343898784246031
191897 191897 68180 68180 137143 2 0.178778954632294
284080 284080 96323 96323 137143 1 0.230769230769231
438936 438936 157307 157307 137143 1 0.164384536492497
438941 438941 157308 157308 137143 2 0.178778954632294
551938 551938 218052 218052 137143 2 0.193152167464051
551946 551946 218053 218053 137143 1 0.164384536492497
714144 714144 252845 252845 137143 3 0.313601864034951
714153 714153 252847 252847 137143 1 0.155995964536346
816004 816004 283426 283426 137143 1 0.155995964536346
816011 816011 283427 283427 137143 1 0.196779964221825
904755 904755 319125 319125 137143 1 0.208816705336427
915449 915449 324329 324329 137143 1 0.196078431372549
1072167 1072167 376597 376597 137143 1 0.155995964536346
1298522 1298522 424580 424580 137143 1 0.155995964536346
1507948 1507948 465362 465362 137143 1 0.155995964536346
1601414 1601414 483731 483731 137143 1 0.155995964536346
1626281 1626281 491106 491106 137143 1 0.155995964536346
1726438 1726438 528623 528623 137143 3 0.313601864034951
1726442 1726442 528624 528624 137143 2 0.178778954632294
1761847 1761847 541008 541008 137143 1 0.0370321386060045 
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)
);