consensus_index

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

20 rows where inchi_id = 197052

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
30484 30484 8882 8882 197052 1 0.0789473684210526
125817 125817 44950 44950 197052 1 0.0789473684210526
242909 242909 82608 82608 197052 1 0.0681818181818182
504051 504051 201655 201655 197052 1 0.0681818181818182
506034 506034 202367 202367 197052 1 0.0591133004926108
507761 507761 203108 203108 197052 2 0.0573283915812155
508019 508019 203222 203222 197052 3 0.149211615225785
549751 549751 217372 217372 197052 1 0.0681818181818182
716908 716908 253562 253562 197052 1 0.0789473684210526
820066 820066 284601 284601 197052 1 0.0789473684210526
820071 820071 284602 284602 197052 1 0.0779220779220779
861119 861119 297754 297754 197052 2 0.424431771143369
865064 865064 298696 298696 197052 1 0.129032258064516
899092 899092 316134 316134 197052 1 0.0779220779220779
1074171 1074171 377170 377170 197052 1 0.0789473684210526
1300544 1300544 425155 425155 197052 1 0.0789473684210526
1509365 1509365 465774 465774 197052 1 0.0789473684210526
1601856 1601856 483868 483868 197052 1 0.0789473684210526
1627507 1627507 491588 491588 197052 1 0.0789473684210526
1726946 1726946 528812 528812 197052 1 0.0789473684210526 
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)
);