metadata: contig_metadata: 4 rows where bioproject = "PRJNA1002816" and tax

4 rows where bioproject = "PRJNA1002816" 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_order	tax_family	tax_genus	tax_species
29402854	29402854	PRJNA1002816_P_NODE_21049_length_235_cov_2.709877_g20889_i0	PRJNA1002816	21049	235	2.709877	6.36821095	Chrysochromulina tobinii	1460289	Haptophyta	other_Eukaryota	48.9	4.23e-5	NR	KOO29468.1	1460289	g20889	i0	70.3	0.472340425531915	37	11	47.2	0	215	105	78	114	KOO29468.1 ubiquitin [Chrysochromulina tobinii]	diamond	111	48.9	1	Eukaryota	Haptista	Haptophyta	Prymnesiales	Chrysochromulinaceae	Chrysochromulina	Chrysochromulina tobinii
29458283	29458283	PRJNA1002816_P_NODE_16710_length_260_cov_1.256684_g16550_i0	PRJNA1002816	16710	260	1.256684	3.2673784	root	1	Root_unresolved	Root_unresolved	45.4	0.00501	NR	XP_005767904.1	280463	g16550	i0	32.6	3.08076923076923	92	55	99.2	2	260	3	117	207	XP_005767904.1 hypothetical protein EMIHUDRAFT_245824, partial [Emiliania huxleyi CCMP1516]	diamond	801	45.8	0.991266375545852	Eukaryota	Haptista	Haptophyta	Isochrysidales	Noelaerhabdaceae	Emiliania	Emiliania huxleyi
29908249	29908249	PRJNA1002816_P_NODE_20571_length_242_cov_0.911243_g20411_i0	PRJNA1002816	20571	242	0.911243	2.20520806	Prymnesium parvum	97485	Haptophyta	other_Eukaryota	124	3.68e-33	NR	KAL1530296.1	97485	g20411	i0	73.8	0.991735537190083	80	21	99.2	0	1	240	40	119	KAL1530296.1 hypothetical protein AB1Y20_001207 [Prymnesium parvum]	diamond	240	124	1	Eukaryota	Haptista	Haptophyta	Prymnesiales	Prymnesiaceae	Prymnesium	Prymnesium parvum
31765315	31765315	PRJNA1002816_P_NODE_8817_length_378_cov_1.449180_g8657_i0	PRJNA1002816	8817	378	1.44918	5.4779004	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	68.9	7.46e-11	NR	KAL1511748.1	97485	g8657	i0	35.5	1.87301587301587	121	61	84.1	4	39	356	89	207	KAL1511748.1 hypothetical protein AB1Y20_005036 [Prymnesium parvum]	diamond	708	68.9	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);;