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

6 rows where bioproject = "PRJNA816047", 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
26149640	26149640	PRJNA816047d_S_NODE_59733_length_291_cov_117.294118_g57898_i0	PRJNA816047	59733	291	117.294118	341.32588338	Pavlovales sp. CCMP2436	483367	Haptophyta	other_Eukaryota	129	3.5499999999999995e-35	NR	KAJ1619708.1	483367	g57898	i0	88.7	3.83505154639175	62	7	63.9	0	291	106	164	225	KAJ1619708.1 hypothetical protein T492DRAFT_1083555 [Pavlovales sp. CCMP2436]	diamond	1116	129	1	Eukaryota	Haptista	Haptophyta	Pavlovophyceae	Pavlovales			Pavlovales sp. CCMP2436
32990855	32990855	PRJNA816047d_S_NODE_93299_length_254_cov_1.293532_g91464_i0	PRJNA816047	93299	254	1.293532	3.28557128	Pavlovales sp. CCMP2436	483367	Haptophyta	other_Eukaryota	79.3	1.58e-15	NR	KAJ1624806.1	483367	g91464	i0	48.9	1.03937007874016	88	39	98	2	253	5	182	268	KAJ1624806.1 glutathione-s-transferase [Pavlovales sp. CCMP2436]	diamond	264	79.3	1	Eukaryota	Haptista	Haptophyta	Pavlovophyceae	Pavlovales			Pavlovales sp. CCMP2436
33024401	33024401	PRJNA816047d_S_NODE_167836_length_208_cov_2.658065_g166001_i0	PRJNA816047	167836	208	2.658065	5.5287752	Emiliania huxleyi CCMP1516	280463	Haptophyta	other_Eukaryota	47	2.77e-4	NR	XP_005785080.1	280463	g166001	i0	72.4	33.7644230769231	29	8	41.8	0	53	139	111	139	XP_005785080.1 hypothetical protein EMIHUDRAFT_418142 [Emiliania huxleyi CCMP1516]	diamond	7023	47	1	Eukaryota	Haptista	Haptophyta		Isochrysidales	Noelaerhabdaceae	Emiliania	Emiliania huxleyi
33041687	33041687	PRJNA816047d_S_NODE_59444_length_292_cov_1.548117_g57609_i0	PRJNA816047	59444	292	1.548117	4.52050164	Prymnesium sp.	2812485	Haptophyta	other_Eukaryota	122	2.45e-30	NR	KAL3905499.1	2812485	g57609	i0	63.4	2.8458904109589	93	34	95.5	0	281	3	44	136	KAL3905499.1 MAG: hypothetical protein SGPRY_010888, partial [Prymnesium sp.]	diamond	831	122	1	Eukaryota	Haptista	Haptophyta		Prymnesiales	Prymnesiaceae	Prymnesium	Prymnesium sp.
33078807	33078807	PRJNA816047d_S_NODE_88461_length_257_cov_1.117647_g86626_i0	PRJNA816047	88461	257	1.117647	2.87235279	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	124	1.1499999999999999e-32	NR	KAL1519728.1	97485	g86626	i0	70.6	2.97665369649805	85	24	99.2	1	1	255	71	154	KAL1519728.1 hypothetical protein AB1Y20_023237 [Prymnesium parvum]	diamond	765	125	0.992	Eukaryota	Haptista	Haptophyta		Prymnesiales	Prymnesiaceae	Prymnesium	Prymnesium parvum
33095931	33095931	PRJNA816047d_S_NODE_88150_length_257_cov_2.009804_g86315_i0	PRJNA816047	88150	257	2.009804	5.16519628	Pavlovophyceae	3435358	Haptophyta	other_Eukaryota	76.3	4.11e-14	NR	KAL1519955.1	97485	g86315	i0	63.9	5.04280155642023	61	22	71.2	0	225	43	108	168	KAL1519955.1 hypothetical protein AB1Y20_023441 [Prymnesium parvum]	diamond	1296	77	0.990909090909091	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);;