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

4 rows where bioproject = "PRJNA287283" 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
29884763	29884763	PRJNA287283_P_NODE_5571_length_249_cov_0.948980_g5347_i0	PRJNA287283	5571	249	0.94898	2.3629602	Emiliania huxleyi CCMP1516	280463	Haptophyta	other_Eukaryota	97.8	7.01e-22	NR	XP_005783765.1	280463	g5347	i0	58.2	1.09638554216867	91	20	88	1	29	247	4	94	XP_005783765.1 hypothetical protein EMIHUDRAFT_232135 [Emiliania huxleyi CCMP1516]	diamond	273	97.8	1	Eukaryota	Haptista	Haptophyta		Isochrysidales	Noelaerhabdaceae	Emiliania	Emiliania huxleyi
29916364	29916364	PRJNA287283_P_NODE_9471_length_179_cov_0.888889_g9247_i0	PRJNA287283	9471	179	0.888889	1.59111131	Chrysochromulina tobinii	1460289	Haptophyta	other_Eukaryota	76.3	4.95e-15	NR	KOO29512.1	1460289	g9247	i0	62.7	0.988826815642458	59	19	93.9	1	7	174	156	214	KOO29512.1 hypothetical protein Ctob_006952 [Chrysochromulina tobinii]	diamond	177	76.3	1	Eukaryota	Haptista	Haptophyta		Prymnesiales	Chrysochromulinaceae	Chrysochromulina	Chrysochromulina tobinii
32319117	32319117	PRJNA287283_P_NODE_7399_length_200_cov_1.265306_g7175_i0	PRJNA287283	7399	200	1.265306	2.530612	Chrysochromulina tobinii	1460289	Haptophyta	other_Eukaryota	44.7	0.00432	NR	KOO34292.1	1460289	g7175	i0	50	1.485	48	21	69	2	138	1	267	313	KOO34292.1 calmodulin [Chrysochromulina tobinii]	diamond	297	44.7	1	Eukaryota	Haptista	Haptophyta		Prymnesiales	Chrysochromulinaceae	Chrysochromulina	Chrysochromulina tobinii
32445599	32445599	PRJNA287283_P_NODE_2259_length_440_cov_1.408269_g2036_i0	PRJNA287283	2259	440	1.408269	6.1963836	Diacronema lutheri	2081491	Haptophyta	other_Eukaryota	63.2	1.96e-8	NR	KAG8464901.1	2081491	g2036	i0	34	1.10454545454545	100	61	65.5	3	49	336	33	131	KAG8464901.1 hypothetical protein KFE25_012264 [Diacronema lutheri]	diamond	486	63.2	1	Eukaryota	Haptista	Haptophyta	Pavlovophyceae	Pavlovales	Pavlovaceae	Diacronema	Diacronema lutheri

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