home / zeropm-v0-0-4

consensus_index

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

28 rows where inchi_id = 197923

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
10172 10172 3076 3076 197923 1 0.187951807228916
24613 24613 7221 7221 197923 1 0.3125
114553 114553 39975 39975 197923 1 0.3125
182038 182038 65001 65001 197923 1 0.184931566205262
200700 200700 71304 71304 197923 1 0.187951807228916
224537 224537 77451 77451 197923 1 0.187951807228916
432500 432500 155538 155538 197923 1 0.187951807228916
519051 519051 207500 207500 197923 1 0.187951807228916
589870 589870 230244 230244 197923 1 0.187951807228916
598942 598942 235782 235782 197923 1 0.187951807228916
676542 676542 241781 241781 197923 1 0.189239332096475
751607 751607 264241 264241 197923 1 0.187951807228916
751609 751609 264242 264242 197923 1 0.3125
751611 751611 264243 264243 197923 1 0.3125
751613 751613 264244 264244 197923 1 0.307692307692308
938097 938097 335165 335165 197923 1 0.3
999167 999167 358038 358038 197923 1 0.3125
999169 999169 358039 358039 197923 1 0.3125
999171 999171 358040 358040 197923 1 0.3125
1210226 1210226 402441 402441 197923 1 0.3125
1210228 1210228 402442 402442 197923 1 0.3125
1210230 1210230 402443 402443 197923 1 0.3125
1453794 1453794 451551 451551 197923 1 0.3125
1453796 1453796 451552 451552 197923 1 0.3125
1453798 1453798 451553 451553 197923 1 0.3125
1592014 1592014 480559 480559 197923 1 0.3125
1618724 1618724 488771 488771 197923 1 0.3125
1721508 1721508 527238 527238 197923 1 0.3
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 652.264ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website