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 = 43874

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
6381 6381 1959 1959 43874 1 0.136602451838879
39785 39785 12032 12032 43874 6 0.473684210526316
154096 154096 55380 55380 43874 1 0.137281292059219
249634 249634 84880 84880 43874 1 0.136602451838879
280141 280141 95004 95004 43874 5 0.466666666666667
454105 454105 163113 163113 43874 5 0.466666666666667
477994 477994 174422 174422 43874 1 0.120594537287055
522437 522437 208438 208438 43874 1 0.136602451838879
734683 734683 259178 259178 43874 1 0.137281292059219
787388 787388 275007 275007 43874 1 0.120594537287055
787393 787393 275008 275008 43874 1 0.120594537287055
798353 798353 278506 278506 43874 1 0.0933554486872455
798358 798358 278507 278507 43874 1 0.0559814229918522
889658 889658 310810 310810 43874 1 0.120594537287055
922833 922833 327577 327577 43874 1 0.0933554486872455
939184 939184 335642 335642 43874 3 0.454545454545455
1736014 1736014 531812 531812 43874 6 0.473684210526316
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 1459.744ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website