metadata: contig_metadata: 5 rows where bioproject = "PRJNA534016", tax_clade = "Haptista" and tax

5 rows where bioproject = "PRJNA534016", 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
28071746	28071746	PRJNA534016_P_NODE_45_length_2458_cov_11.742558_g35_i0	PRJNA534016	45	2458	11.742558	288.63207564	Diacronema	70451	Haptophyta	other_Eukaryota	110	9.77e-21	NR	KAJ1629248.1	483367	g35	i0	23.3	1.41944670463792	576	230	69.2	22	250	1950	528	900	KAJ1629248.1 glycosyl hydrolases family 18-domain-containing protein [Pavlovales sp. CCMP2436]	diamond	3489	111	0.990990990990991	Eukaryota	Haptista	Haptophyta	Pavlovophyceae	Pavlovales			Pavlovales sp. CCMP2436
29082323	29082323	PRJNA534016_P_NODE_6028_length_341_cov_1.029851_g5938_i0	PRJNA534016	6028	341	1.029851	3.51179191	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	115	2.8799999999999997e-30	NR	KAL1522025.1	97485	g5938	i0	60.7	4.62756598240469	89	35	78.3	0	74	340	60	148	KAL1522025.1 hypothetical protein AB1Y20_021670 [Prymnesium parvum]	diamond	1578	115	1	Eukaryota	Haptista	Haptophyta		Prymnesiales	Prymnesiaceae	Prymnesium	Prymnesium parvum
30014685	30014685	PRJNA534016_P_NODE_17911_length_242_cov_0.911243_g17821_i0	PRJNA534016	17911	242	0.911243	2.20520806	Pavlovales sp. CCMP2436	483367	Haptophyta	other_Eukaryota	100	1.75e-22	NR	KAJ1621741.1	483367	g17821	i0	55.7	1.95867768595041	79	35	97.9	0	240	4	310	388	KAJ1621741.1 BT1 family-domain-containing protein [Pavlovales sp. CCMP2436]	diamond	474	100	1	Eukaryota	Haptista	Haptophyta	Pavlovophyceae	Pavlovales			Pavlovales sp. CCMP2436
30583121	30583121	PRJNA534016_P_NODE_15193_length_248_cov_0.880000_g15103_i0	PRJNA534016	15193	248	0.88	2.1824	Chrysochromulina tobinii	1460289	Haptophyta	other_Eukaryota	56.2	5.18e-7	NR	KOO27608.1	1460289	g15103	i0	42.9	1.01612903225806	84	45	98	2	245	3	30	113	KOO27608.1 short-chain dehydrogenase reductase sdr [Chrysochromulina tobinii]	diamond	252	56.2	1	Eukaryota	Haptista	Haptophyta		Prymnesiales	Chrysochromulinaceae	Chrysochromulina	Chrysochromulina tobinii
30836071	30836071	PRJNA534016_P_NODE_11914_length_264_cov_1.602094_g11824_i0	PRJNA534016	11914	264	1.602094	4.22952816	Emiliania huxleyi CCMP1516	280463	Haptophyta	other_Eukaryota	99.8	3.3e-22	NR	XP_005762670.1	280463	g11824	i0	57.5	1.81818181818182	80	34	90.9	0	25	264	161	240	XP_005762670.1 hypothetical protein EMIHUDRAFT_215920 [Emiliania huxleyi CCMP1516]	diamond	480	99.8	1	Eukaryota	Haptista	Haptophyta		Isochrysidales	Noelaerhabdaceae	Emiliania	Emiliania huxleyi

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