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

5 rows where analysis = "diamond", bioproject = "PRJNA385396" and tax_clade = "Haptista"

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_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
8060057	8060057	PRJNA385396_P_NODE_13927_length_251_cov_0.865169_g13835_i0	PRJNA385396	13927	251	0.865169	2.17157419	Diacronema	70451	Haptophyta	other_Eukaryota	154	1.8e-41	NR	KAJ1625898.1	483367	g13835	i0	83.1	3.9681274900398402	83	14	99.2	0	3	251	158	240	KAJ1625898.1 cell division control protein 48-like protein E-like protein [Pavlovales sp. CCMP2436]	diamond	996	154	1	Eukaryota	Haptista	Haptophyta	Pavlovophyceae	Pavlovales			Pavlovales sp. CCMP2436
14436031	14436031	PRJNA385396_P_NODE_9332_length_292_cov_2.100457_g9240_i0	PRJNA385396	9332	292	2.100457	6.13333444	Viridiplantae	33090	Haptophyta	other_Eukaryota	137	2.08e-38	NR	KAL1496287.1	97485	g9240	i0	65.3	2.88698630136986	95	33	97.6	0	6	290	36	130	KAL1496287.1 hypothetical protein AB1Y20_016250 [Prymnesium parvum]	diamond	843	138	0.992753623188406	Eukaryota	Haptista	Haptophyta		Prymnesiales	Prymnesiaceae	Prymnesium	Prymnesium parvum
16984119	16984119	PRJNA385396_P_NODE_10854_length_275_cov_1.519802_g10762_i0	PRJNA385396	10854	275	1.519802	4.1794555	Prymnesium sp.	2812485	Haptophyta	other_Eukaryota	173	2.41e-48	NR	KAL3928576.1	2812485	g10762	i0	91.1	4.88727272727273	90	8	98.2	0	3	272	627	716	KAL3928576.1 MAG: hypothetical protein SGPRY_002330 [Prymnesium sp.]	diamond	1344	173	1	Eukaryota	Haptista	Haptophyta		Prymnesiales	Prymnesiaceae	Prymnesium	Prymnesium sp.
29191119	29191119	PRJNA385396_P_NODE_21189_length_241_cov_0.916667_g21097_i0	PRJNA385396	21189	241	0.916667	2.20916747	Prymnesium parvum	97485	Haptophyta	other_Eukaryota	128	3.1299999999999996e-32	NR	KAL1521942.1	97485	g21097	i0	82.7	5.850622406639	75	13	93.4	0	17	241	460	534	KAL1521942.1 hypothetical protein AB1Y20_021590 [Prymnesium parvum]	diamond	1410	128	1	Eukaryota	Haptista	Haptophyta		Prymnesiales	Prymnesiaceae	Prymnesium	Prymnesium parvum
31244217	31244217	PRJNA385396_P_NODE_14295_length_250_cov_0.870056_g14203_i0	PRJNA385396	14295	250	0.870056	2.17514	Chrysochromulina tobinii	1460289	Haptophyta	other_Eukaryota	55.5	1.32e-6	NR	KOO35235.1	1460289	g14203	i0	40.3	0.924	77	38	92.4	1	239	9	3	71	KOO35235.1 wd repeat-containing protein, partial [Chrysochromulina tobinii]	diamond	231	55.5	1	Eukaryota	Haptista	Haptophyta		Prymnesiales	Chrysochromulinaceae	Chrysochromulina	Chrysochromulina tobinii

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);;