metadata: contig_metadata: 5 rows where analysis = "diamond", bioproject = "PRJEB48218" and tax

5 rows where analysis = "diamond", bioproject = "PRJEB48218" and tax_kingdom = "Metazoa"

descending

Link	rowid ▼	query	bioproject	node	length	coverage	rel_abundance	taxname_lca	taxid_lca	taxoncategory	taxoncategorysimple	bits	evalue	analysis_used	target	taxid	gene	allele	pident	sumperc_cov	alnlen	mismatch	qcov	gapopen	qstart	qend	tstart	tend	target_title	analysis	sumalnlen	maxbits	bits_percmax	tax_superkingdom	tax_clade	tax_kingdom	tax_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
27633893	27633893	PRJEB48218_S_NODE_7824_length_341_cov_3.272436_g6862_i0	PRJEB48218	7824	341	3.272436	11.15900676	Hypsibius exemplaris	2072580	Tardigrada	other_Eukaryota	97.8	8.360000000000001e-22	NR	OQV18944.1	2072580	g6862	i0	77.2	0.501466275659824	57	13	50.1	0	172	2	253	309	OQV18944.1 hypothetical protein BV898_07003 [Hypsibius exemplaris]	diamond	171	97.8	1	Eukaryota	Opisthokonta	Metazoa	Tardigrada	Eutardigrada	Parachela	Hypsibiidae	Hypsibius	Hypsibius exemplaris
29086327	29086327	PRJEB48218_S_NODE_10628_length_277_cov_3.741935_g9666_i0	PRJEB48218	10628	277	3.741935	10.36515995	Mercenaria mercenaria	6596	Mollusca	Mollusca	63.9	1.93e-9	NR	XP_053372933.1	6596	g9666	i0	42.7	1.62454873646209	75	43	81.2	0	20	244	108	182	XP_053372933.1 uncharacterized protein LOC128546441 [Mercenaria mercenaria]	diamond	450	63.9	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Venerida	Veneridae	Mercenaria	Mercenaria mercenaria
30318408	30318408	PRJEB48218_S_NODE_20752_length_203_cov_2.471264_g19790_i0	PRJEB48218	20752	203	2.471264	5.01666592	Mirounga leonina	9715	Chordata	Chordata	57.8	3.57e-9	NR	KAF3824377.1	9715	g19790	i0	83.3	0.532019704433498	36	6	53.2	0	78	185	27	62	KAF3824377.1 hypothetical protein GH733_008662 [Mirounga leonina]	diamond	108	57.8	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Carnivora	Phocidae	Mirounga	Mirounga leonina
30823382	30823382	PRJEB48218_S_NODE_10314_length_282_cov_5.375494_g9352_i0	PRJEB48218	10314	282	5.375494	15.15889308	Haliotis asinina	109174	Mollusca	Mollusca	43.9	0.0224	NR	XP_067657806.1	109174	g9352	i0	35.4	1.36170212765957	65	36	68.1	2	252	61	144	203	XP_067657806.1 uncharacterized protein [Haliotis asinina]	diamond	384	43.9	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda	Lepetellida	Haliotidae	Haliotis	Haliotis asinina
31550698	31550698	PRJEB48218_S_NODE_27276_length_163_cov_2.298507_g26314_i0	PRJEB48218	27276	163	2.298507	3.74656641	Argopecten irradians	31199	Mollusca	Mollusca	42	0.0201	NR	XP_069108365.1	31199	g26314	i0	45	0.736196319018405	40	21	73.6	1	26	145	11	49	XP_069108365.1 uncharacterized protein [Argopecten irradians]	diamond	120	42	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Pectinida	Pectinidae	Argopecten	Argopecten irradians

Advanced export

JSON shape: default, array, newline-delimited

CREATE TABLE contig_metadata(query VARCHAR, bioproject VARCHAR, node VARCHAR, length VARCHAR, coverage VARCHAR, rel_abundance VARCHAR, taxname_lca VARCHAR, taxid_lca VARCHAR, taxoncategory VARCHAR, taxoncategorysimple VARCHAR, bits VARCHAR, evalue VARCHAR, lowcoverage_flag VARCHAR, analysis_used VARCHAR, "target" VARCHAR, taxid VARCHAR, gene VARCHAR, allele VARCHAR, pident VARCHAR, sumperc_cov VARCHAR, alnlen VARCHAR, mismatch VARCHAR, qcov VARCHAR, gapopen VARCHAR, qstart VARCHAR, qend VARCHAR, tstart VARCHAR, tend VARCHAR, target_title VARCHAR, analysis VARCHAR, sumalnlen VARCHAR, maxbits VARCHAR, bits_percmax VARCHAR, tax_superkingdom VARCHAR, tax_clade VARCHAR, tax_kingdom VARCHAR, tax_phylum VARCHAR, tax_class VARCHAR, tax_order VARCHAR, tax_family VARCHAR, tax_genus VARCHAR, tax_species VARCHAR);;