home / zeropm-v0-0-4

consensus_index

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

29 rows where inventory_id = 356146

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
992720 992720 356146 356146 3515 8 0.250709456076058
992721 992721 356146 356146 17497 1 0.125354728038029
992722 992722 356146 356146 33583 1 0.0313386820095073
992723 992723 356146 356146 35243 1 0.035815636582294
992724 992724 356146 356146 51185 1 0.0167139637384039
992725 992725 356146 356146 55862 1 0.0835698186920194
992726 992726 356146 356146 63839 1 0.0125354728038029
992727 992727 356146 356146 68015 1 0.0119385455274313
992728 992728 356146 356146 81686 1 0.0104462273365024
992729 992729 356146 356146 89238 1 0.00928553541022437
992730 992730 356146 356146 123672 1 0.0626773640190145
992731 992731 356146 356146 138713 1 0.0278566062306731
992732 992732 356146 356146 139788 1 0.0227917687341871
992733 992733 356146 356146 139807 1 0.017907818291147
992734 992734 356146 356146 149107 1 0.0250709456076058
992735 992735 356146 356146 167393 1 0.0192853427750814
992736 992736 356146 356146 167437 1 0.0208924546730048
992737 992737 356146 356146 167549 1 0.0113958843670936
992738 992738 356146 356146 171165 1 0.0131952345303188
992739 992739 356146 356146 171594 1 0.0109004111337417
992740 992740 356146 356146 171796 1 0.0147476150632975
992741 992741 356146 356146 171797 1 0.0156693410047536
992742 992742 356146 356146 171936 1 0.0139283031153366
992743 992743 356146 356146 172056 1 0.0501418912152116
992744 992744 356146 356146 178265 1 0.0417849093460097
992745 992745 356146 356146 191532 1 0.0096426713875407
992746 992746 356146 356146 231459 1 0.0100283782430423
992747 992747 356146 356146 340654 1 0.0089539091455735
992748 992748 356146 356146 340655 1 0.00864515365779511
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 773.323ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website