metadata: contig_metadata: 7 rows where bioproject = "PRJNA833575" and tax

7 rows where bioproject = "PRJNA833575" 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
26801350	26801350	PRJNA833575_P_NODE_31161_length_266_cov_1.461929_g31024_i0	PRJNA833575	31161	266	1.461929	3.88873114	Diacronema lutheri	2081491	Haptophyta	other_Eukaryota	75.9	3.7e-14	NR	KAG8461834.1	2081491	g31024	i0	45	1.80451127819549	80	43	90.2	1	246	7	171	249	KAG8461834.1 hypothetical protein KFE25_013853 [Diacronema lutheri]	diamond	480	75.9	1	Eukaryota	Haptista	Haptophyta	Pavlovophyceae	Pavlovales	Pavlovaceae	Diacronema	Diacronema lutheri
29620517	29620517	PRJNA833575_P_NODE_34010_length_253_cov_2.217391_g33873_i0	PRJNA833575	34010	253	2.217391	5.60999923	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	104	3.4099999999999995e-24	NR	KAL1527885.1	97485	g33873	i0	63.1	1.99209486166008	84	30	99.6	1	2	253	183	265	KAL1527885.1 hypothetical protein AB1Y20_009261 [Prymnesium parvum]	diamond	504	104	1	Eukaryota	Haptista	Haptophyta		Prymnesiales	Prymnesiaceae	Prymnesium	Prymnesium parvum
29715405	29715405	PRJNA833575_P_NODE_43350_length_229_cov_1.637500_g43213_i0	PRJNA833575	43350	229	1.6375	3.749875	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	66.6	9.98e-11	NR	KAL1495669.1	97485	g43213	i0	40.5	3.66812227074236	74	42	96.9	1	224	3	114	185	KAL1495669.1 hypothetical protein AB1Y20_016534 [Prymnesium parvum]	diamond	840	67	0.994029850746269	Eukaryota	Haptista	Haptophyta		Prymnesiales	Prymnesiaceae	Prymnesium	Prymnesium parvum
30117672	30117672	PRJNA833575_P_NODE_24172_length_302_cov_3.064378_g24035_i0	PRJNA833575	24172	302	3.064378	9.25442156	Chrysochromulina tobinii	1460289	Haptophyta	other_Eukaryota	62.4	7.88e-9	NR	KOO30387.1	1460289	g24035	i0	55.2	1.45033112582781	58	25	56.6	1	100	270	20	77	KOO30387.1 papain family cysteine protease containing protein [Chrysochromulina tobinii]	diamond	438	62.4	1	Eukaryota	Haptista	Haptophyta		Prymnesiales	Chrysochromulinaceae	Chrysochromulina	Chrysochromulina tobinii
30371043	30371043	PRJNA833575_P_NODE_42692_length_230_cov_0.894410_g42555_i0	PRJNA833575	42692	230	0.89441	2.057143	Diacronema lutheri	2081491	Haptophyta	other_Eukaryota	76.6	2.16e-14	NR	KAG8462885.1	2081491	g42555	i0	62.5	0.730434782608696	56	21	73	0	217	50	271	326	KAG8462885.1 hypothetical protein KFE25_001658 [Diacronema lutheri]	diamond	168	76.6	1	Eukaryota	Haptista	Haptophyta	Pavlovophyceae	Pavlovales	Pavlovaceae	Diacronema	Diacronema lutheri
31571765	31571765	PRJNA833575_P_NODE_38776_length_235_cov_0.867470_g38639_i0	PRJNA833575	38776	235	0.86747	2.0385545	Prymnesium parvum	97485	Haptophyta	other_Eukaryota	105	5.09e-26	NR	KAL1521367.1	97485	g38639	i0	64.1	2.98723404255319	78	26	99.6	1	234	1	44	119	KAL1521367.1 hypothetical protein AB1Y20_021033 [Prymnesium parvum]	diamond	702	105	1	Eukaryota	Haptista	Haptophyta		Prymnesiales	Prymnesiaceae	Prymnesium	Prymnesium parvum
32867213	32867213	PRJNA833575_P_NODE_46660_length_226_cov_0.917197_g46523_i0	PRJNA833575	46660	226	0.917197	2.07286522	Chrysochromulina tobinii	1460289	Haptophyta	other_Eukaryota	55.1	1.25e-6	NR	KOO30224.1	1460289	g46523	i0	51.9	0.716814159292035	54	26	71.7	0	48	209	54	107	KOO30224.1 hypothetical protein Ctob_004347, partial [Chrysochromulina tobinii]	diamond	162	55.1	1	Eukaryota	Haptista	Haptophyta		Prymnesiales	Chrysochromulinaceae	Chrysochromulina	Chrysochromulina tobinii

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