search

humlab-sead / sead_browser_client

Online browser client for the SEAD database
2 stars 0 forks source link

Sample features #303

Open johanvonboer opened 11 months ago

johanvonboer commented 11 months ago

Sample features are not shown in the landing pages.

We have information on feature_type, feature_name and description, etc.

In tbl_features.

image

Query which might be useful:

SELECT
        tbl_sites.site_id,
        tbl_physical_sample_features.*,
        tbl_features.*,
        tbl_feature_types.*,
        tbl_physical_samples.sample_group_id
        FROM
        tbl_sites
        LEFT JOIN tbl_sample_groups ON tbl_sample_groups.site_id = tbl_sites.site_id
        LEFT JOIN tbl_physical_samples ON tbl_physical_samples.sample_group_id=tbl_sample_groups.sample_group_id
        LEFT JOIN tbl_physical_sample_features ON tbl_physical_sample_features.physical_sample_id=tbl_physical_samples.physical_sample_id
        LEFT JOIN tbl_features ON tbl_features.feature_id=tbl_physical_sample_features.feature_id
        LEFT JOIN tbl_feature_types ON tbl_feature_types.feature_type_id=tbl_features.feature_type_id
        WHERE tbl_sites.site_id=1