metadata: contig_metadata: 9 rows where bioproject = "PRJNA893346" and tax

9 rows where bioproject = "PRJNA893346" 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
21270243	21270243	PRJNA893346_P_NODE_33697_length_251_cov_0.865169_g33207_i0	PRJNA893346	33697	251	0.865169	2.17157419	Pavlovales sp. CCMP2436	483367	Haptophyta	other_Eukaryota	86.7	8.14e-19	NR	KAJ1639328.1	483367	g33207	i0	52.9	0.836653386454183	70	32	83.7	1	236	27	21	89	KAJ1639328.1 thioredoxin-like protein [Pavlovales sp. CCMP2436]	diamond	210	86.7	1	Eukaryota	Haptista	Haptophyta	Pavlovophyceae	Pavlovales			Pavlovales sp. CCMP2436
26746505	26746505	PRJNA893346_P_NODE_9061_length_525_cov_2.674779_g8579_i0	PRJNA893346	9061	525	2.674779	14.04258975	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	86.3	2.5e-18	NR	KAL1504491.1	97485	g8579	i0	50.6	2.44	83	27	47.4	1	276	524	10	78	KAL1504491.1 hypothetical protein AB1Y20_010896 [Prymnesium parvum]	diamond	1281	86.3	1	Eukaryota	Haptista	Haptophyta		Prymnesiales	Prymnesiaceae	Prymnesium	Prymnesium parvum
27624458	27624458	PRJNA893346_P_NODE_17624_length_369_cov_1.023649_g17135_i0	PRJNA893346	17624	369	1.023649	3.77726481	Chrysochromulina tobinii	1460289	Haptophyta	other_Eukaryota	63.9	2.65e-9	NR	KOO33364.1	1460289	g17135	i0	53.3	1.6260162601626	60	28	48.8	0	186	7	17	76	KOO33364.1 extracellular signal-regulated protein kinase, partial [Chrysochromulina tobinii]	diamond	600	63.9	1	Eukaryota	Haptista	Haptophyta		Prymnesiales	Chrysochromulinaceae	Chrysochromulina	Chrysochromulina tobinii
27845128	27845128	PRJNA893346_P_NODE_18524_length_359_cov_1.328671_g18035_i0	PRJNA893346	18524	359	1.328671	4.76992889	Prymnesium parvum	97485	Haptophyta	other_Eukaryota	99	7.079999999999999e-23	NR	KAL1529182.1	97485	g18035	i0	50.9	0.952646239554318	114	56	95.3	0	346	5	4	117	KAL1529182.1 hypothetical protein AB1Y20_000141 [Prymnesium parvum]	diamond	342	99	1	Eukaryota	Haptista	Haptophyta		Prymnesiales	Prymnesiaceae	Prymnesium	Prymnesium parvum
29486928	29486928	PRJNA893346_P_NODE_12730_length_438_cov_1.509589_g12244_i0	PRJNA893346	12730	438	1.509589	6.61199982	Prymnesium parvum	97485	Haptophyta	other_Eukaryota	91.3	2.41e-20	NR	KAL1515331.1	97485	g12244	i0	40.7	1.84246575342466	135	64	85.6	2	12	386	4	132	KAL1515331.1 hypothetical protein AB1Y20_001962 [Prymnesium parvum]	diamond	807	91.3	1	Eukaryota	Haptista	Haptophyta		Prymnesiales	Prymnesiaceae	Prymnesium	Prymnesium parvum
31192650	31192650	PRJNA893346_P_NODE_15675_length_392_cov_1.633229_g15187_i0	PRJNA893346	15675	392	1.633229	6.40225768	Diacronema lutheri	2081491	Haptophyta	other_Eukaryota	62.4	2.3e-8	NR	KAG8460774.1	2081491	g15187	i0	38.7	0.910714285714286	119	57	80.4	5	322	8	236	352	KAG8460774.1 hypothetical protein KFE25_010829 [Diacronema lutheri]	diamond	357	62.4	1	Eukaryota	Haptista	Haptophyta	Pavlovophyceae	Pavlovales	Pavlovaceae	Diacronema	Diacronema lutheri
32181547	32181547	PRJNA893346_P_NODE_37678_length_244_cov_0.900585_g37188_i0	PRJNA893346	37678	244	0.900585	2.1974274	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	82.4	3.96e-16	NR	KAJ1627865.1	483367	g37188	i0	61.5	10.0204918032787	65	25	79.9	0	197	3	87	151	KAJ1627865.1 P-loop containing nucleoside triphosphate hydrolase protein [Pavlovales sp. CCMP2436]	diamond	2445	83.2	0.990384615384615	Eukaryota	Haptista	Haptophyta	Pavlovophyceae	Pavlovales			Pavlovales sp. CCMP2436
32466464	32466464	PRJNA893346_P_NODE_27019_length_290_cov_1.419355_g26529_i0	PRJNA893346	27019	290	1.419355	4.1161295	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	135	3.03e-38	NR	KAL1523551.1	97485	g26529	i0	69.8	3.96206896551724	96	29	99.3	0	289	2	11	106	KAL1523551.1 hypothetical protein AB1Y20_018487 [Prymnesium parvum]	diamond	1149	135	1	Eukaryota	Haptista	Haptophyta		Prymnesiales	Prymnesiaceae	Prymnesium	Prymnesium parvum
32750062	32750062	PRJNA893346_P_NODE_14440_length_410_cov_1.370920_g13952_i0	PRJNA893346	14440	410	1.37092	5.620772	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	63.2	1.74e-8	NR	KAL1525386.1	97485	g13952	i0	31.5	2.01219512195122	149	86	98.8	5	4	408	307	453	KAL1525386.1 hypothetical protein AB1Y20_020245 [Prymnesium parvum]	diamond	825	63.2	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);;