metadata: contig_metadata: 6 rows where bioproject = "PRJNA1126198", tax_clade = "Haptista" and tax

6 rows where bioproject = "PRJNA1126198", tax_clade = "Haptista" and tax_superkingdom = "Eukaryota"

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
16858582	16858582	PRJNA1126198_P_NODE_304714_length_264_cov_2.596859_g303993_i0	PRJNA1126198	304714	264	2.596859	6.85570776	Diacronema lutheri	2081491	Haptophyta	other_Eukaryota	127	6.67e-36	NR	KAG8458387.1	2081491	g303993	i0	72.2	3.53409090909091	79	22	89.8	0	1	237	30	108	KAG8458387.1 hypothetical protein KFE25_004528 [Diacronema lutheri]	diamond	933	127	1	Eukaryota	Haptista	Haptophyta	Pavlovophyceae	Pavlovales	Pavlovaceae	Diacronema	Diacronema lutheri
18132995	18132995	PRJNA1126198_P_NODE_25015_length_466_cov_7.129771_g24314_i0	PRJNA1126198	25015	466	7.129771	33.22473286	Emiliania huxleyi CCMP1516	280463	Haptophyta	other_Eukaryota	124	2.84e-33	NR	XP_005765065.1	280463	g24314	i0	55.6	2.96781115879828	117	48	75.3	1	96	446	7	119	XP_005765065.1 hypothetical protein EMIHUDRAFT_416466 [Emiliania huxleyi CCMP1516]	diamond	1383	124	1	Eukaryota	Haptista	Haptophyta		Isochrysidales	Noelaerhabdaceae	Emiliania	Emiliania huxleyi
20682599	20682599	PRJNA1126198_P_NODE_169637_length_304_cov_1.688312_g168917_i0	PRJNA1126198	169637	304	1.688312	5.13246848	Diacronema lutheri	2081491	Haptophyta	other_Eukaryota	130	8.57e-34	NR	KAG8465735.1	2081491	g168917	i0	63.4	0.996710526315789	101	37	99.7	0	303	1	77	177	KAG8465735.1 hypothetical protein KFE25_005305 [Diacronema lutheri]	diamond	303	130	1	Eukaryota	Haptista	Haptophyta	Pavlovophyceae	Pavlovales	Pavlovaceae	Diacronema	Diacronema lutheri
26658524	26658524	PRJNA1126198_P_NODE_234881_length_282_cov_1.483254_g234160_i0	PRJNA1126198	234881	282	1.483254	4.18277628	Chrysochromulina tobinii	1460289	Haptophyta	other_Eukaryota	52.8	1.77e-5	NR	KOO34995.1	1460289	g234160	i0	35.9	1.95744680851064	92	52	92.6	3	22	282	19	108	KOO34995.1 acyl-coenzyme a:6-aminopenicillanic acid acyl-transferase [Chrysochromulina tobinii]	diamond	552	52.8	1	Eukaryota	Haptista	Haptophyta		Prymnesiales	Chrysochromulinaceae	Chrysochromulina	Chrysochromulina tobinii
27323200	27323200	PRJNA1126198_P_NODE_7923_length_645_cov_1.828671_g7267_i0	PRJNA1126198	7923	645	1.828671	11.79492795	Prymnesium parvum	97485	Haptophyta	other_Eukaryota	198	1.6299999999999997e-57	NR	KAL1499712.1	97485	g7267	i0	55.1	0.911627906976744	196	75	85.6	4	622	71	268	462	KAL1499712.1 hypothetical protein AB1Y20_011907 [Prymnesium parvum]	diamond	588	198	1	Eukaryota	Haptista	Haptophyta		Prymnesiales	Prymnesiaceae	Prymnesium	Prymnesium parvum
29501691	29501691	PRJNA1126198_P_NODE_195910_length_294_cov_1.389140_g195190_i0	PRJNA1126198	195910	294	1.38914	4.0840716	Prymnesium parvum	97485	Haptophyta	other_Eukaryota	53.5	1.09e-5	NR	KAL1527782.1	97485	g195190	i0	37.8	1.6734693877551	82	41	82.7	3	293	51	593	665	KAL1527782.1 hypothetical protein AB1Y20_009167 [Prymnesium parvum]	diamond	492	53.5	1	Eukaryota	Haptista	Haptophyta		Prymnesiales	Prymnesiaceae	Prymnesium	Prymnesium parvum

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