media_variant

22 rows where media = 280

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: raw_sample

id ▼ media variant study_code study_status raw_sample
6697 TOP CITY FUNKPAKET 280 DS 1 RHETOP6_ZT ok 3432.12
6700 TOP CITY FUNKPAKET 280 HpT 4 RHETOP6_ZH ok 3432.12
6701 TOP CITY FUNKPAKET 280 Ø 5 RHETOP6_ZD ok 568.41
6702 TOP CITY FUNKPAKET 280 0500-0600 6 RHETOP6_FAGA ok 199.29
6703 TOP CITY FUNKPAKET 280 0600-0700 7 RHETOP6_GAHA ok 494.98
6704 TOP CITY FUNKPAKET 280 0700-0800 8 RHETOP6_HAIA ok 703.47
6705 TOP CITY FUNKPAKET 280 0800-0900 9 RHETOP6_IAJA ok 604.94
6706 TOP CITY FUNKPAKET 280 0900-1000 10 RHETOP6_JAKA ok 564.7
6707 TOP CITY FUNKPAKET 280 1000-1100 11 RHETOP6_KALA ok 540.62
6708 TOP CITY FUNKPAKET 280 1100-1200 12 RHETOP6_LAMA ok 502.26
6709 TOP CITY FUNKPAKET 280 1200-1300 13 RHETOP6_MANA ok 531.32
6710 TOP CITY FUNKPAKET 280 1300-1400 14 RHETOP6_NAOA ok 502.31
6711 TOP CITY FUNKPAKET 280 1400-1500 15 RHETOP6_OAPA ok 481.98
6712 TOP CITY FUNKPAKET 280 1500-1600 16 RHETOP6_PAQA ok 501.41
6713 TOP CITY FUNKPAKET 280 1600-1700 17 RHETOP6_QARA ok 496.98
6714 TOP CITY FUNKPAKET 280 1700-1800 18 RHETOP6_RASA ok 540.72
6715 TOP CITY FUNKPAKET 280 1800-1900 19 RHETOP6_SATA ok 461.53
6716 TOP CITY FUNKPAKET 280 1900-2000 20 RHETOP6_TAUA ok 299.89
6717 TOP CITY FUNKPAKET 280 2000-2100 21 RHETOP6_UAVA ok 210.83
6718 TOP CITY FUNKPAKET 280 2100-2200 22 RHETOP6_VAWA ok 153.14
6719 TOP CITY FUNKPAKET 280 2200-2300 23 RHETOP6_WAXA ok 112.34
6720 TOP CITY FUNKPAKET 280 2300-2400 24 RHETOP6_XAYA ok 83.81

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

CREATE TABLE media_variant (
	id INTEGER NOT NULL, 
	media INTEGER, 
	variant INTEGER, 
	study_code VARCHAR(100), 
	study_status VARCHAR(7), 
	raw_sample INTEGER, 
	PRIMARY KEY (id), 
	UNIQUE (id), 
	FOREIGN KEY(media) REFERENCES media (id), 
	FOREIGN KEY(variant) REFERENCES variant (id)
);
CREATE UNIQUE INDEX ix_media_variant_study_code ON media_variant (study_code);
CREATE INDEX ix_media_variant_media ON media_variant (media);
CREATE INDEX ix_media_variant_variant ON media_variant (variant);
CREATE INDEX ix_media_variant_study_status ON media_variant (study_status);