home / zeropm-v0-0-4

consensus_index

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

19 rows where inchi_id = 31903

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
10346 10346 3147 3147 31903 3 0.231149464778454
10366 10366 3156 3156 31903 3 0.235448483462082
161885 161885 58088 58088 31903 2 0.123417914472439
207144 207144 73338 73338 31903 3 0.235448483462082
207215 207215 73362 73362 31903 3 0.231149464778454
234118 234118 79998 79998 31903 3 0.235448483462082
238461 238461 81142 81142 31903 1 0.0905751462945404
273739 273739 92841 92841 31903 3 0.231149464778454
437949 437949 156993 156993 31903 1 0.0905751462945404
502370 502370 200663 200663 31903 1 0.0906747615674175
521408 521408 208079 208079 31903 1 0.0905751462945404
563079 563079 221308 221308 31903 3 0.231149464778454
663026 663026 237727 237727 31903 1 0.0905751462945404
688562 688562 245533 245533 31903 1 0.0800231835228409
710016 710016 251912 251912 31903 1 0.0890053917381127
790416 790416 276010 276010 31903 8 0.461538461538462
947959 947959 339864 339864 31903 2 0.630993034743972
1623457 1623457 490244 490244 31903 3 0.235448483462082
1724575 1724575 528103 528103 31903 3 0.235448483462082
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 844.762ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website