metadata: contig_metadata: 4 rows where bioproject = "PRJNA692200", tax_clade = "Haptista" and tax

4 rows where bioproject = "PRJNA692200", 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
30019551	30019551	PRJNA692200_S_NODE_14071_length_193_cov_1.479167_g14014_i0	PRJNA692200	14071	193	1.479167	2.85479231	Emiliania huxleyi CCMP1516	280463	Haptophyta	other_Eukaryota	83.6	1.65e-18	NR	XP_005785072.1	280463	g14014	i0	63.8	1.07253886010363	69	20	99.5	2	2	193	67	135	XP_005785072.1 hypothetical protein EMIHUDRAFT_456021 [Emiliania huxleyi CCMP1516]	diamond	207	83.6	1	Eukaryota	Haptista	Haptophyta		Isochrysidales	Noelaerhabdaceae	Emiliania	Emiliania huxleyi
30082410	30082410	PRJNA692200_S_NODE_1472_length_408_cov_27.220056_g1417_i0	PRJNA692200	1472	408	27.220056	111.05782848	Emiliania huxleyi CCMP1516	280463	Haptophyta	other_Eukaryota	87.4	2.84e-19	NR	XP_005782836.1	280463	g1417	i0	51	1.5	98	44	71.3	2	47	337	20	114	XP_005782836.1 hypothetical protein EMIHUDRAFT_442529 [Emiliania huxleyi CCMP1516]	diamond	612	87.4	1	Eukaryota	Haptista	Haptophyta		Isochrysidales	Noelaerhabdaceae	Emiliania	Emiliania huxleyi
30114103	30114103	PRJNA692200_S_NODE_5512_length_280_cov_1.467532_g5455_i0	PRJNA692200	5512	280	1.467532	4.1090896	Diacronema lutheri	2081491	Haptophyta	other_Eukaryota	68.9	3.95e-13	NR	KAG8467831.1	2081491	g5455	i0	80.6	6.40714285714286	36	7	38.6	0	12	119	31	66	KAG8467831.1 hypothetical protein KFE25_006883 [Diacronema lutheri]	diamond	1794	68.9	1	Eukaryota	Haptista	Haptophyta	Pavlovophyceae	Pavlovales	Pavlovaceae	Diacronema	Diacronema lutheri
32685900	32685900	PRJNA692200_S_NODE_22160_length_162_cov_0.876106_g22103_i0	PRJNA692200	22160	162	0.876106	1.41929172	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	56.6	1.55e-7	NR	KAL1495652.1	97485	g22103	i0	61.9	6.55555555555556	42	16	77.8	0	2	127	429	470	KAL1495652.1 hypothetical protein AB1Y20_016518 [Prymnesium parvum]	diamond	1062	57	0.992982456140351	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);;