consensus_index

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

18 rows where inchi_id = 40422

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
98343 98343 34859 34859 40422 1 0.0525944258945079
211529 211529 74085 74085 40422 1 0.0406510373854863
241801 241801 82200 82200 40422 4 0.532491436537994
276710 276710 93805 93805 40422 6 0.382978723404255
439451 439451 157508 157508 40422 6 0.382978723404255
452882 452882 162577 162577 40422 6 0.473684210526316
471181 471181 170676 170676 40422 2 0.152038076758262
471186 471186 170677 170677 40422 2 0.234209076273052
550063 550063 217477 217477 40422 1 0.0406510373854863
550576 550576 217640 217640 40422 3 0.524040820577346
717074 717074 253612 253612 40422 1 0.0406510373854863
820319 820319 284699 284699 40422 1 0.0576257327486473
820327 820327 284700 284700 40422 1 0.0540024556541861
894406 894406 313930 313930 40422 3 0.454545454545455
945454 945454 338657 338657 40422 1 0.0576257327486473
964614 964614 348363 348363 40422 1 0.262020410288673
1609164 1609164 485923 485923 40422 1 0.0576257327486473
1715660 1715660 525543 525543 40422 1 0.0576257327486473 
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)
);