metadata: contig_metadata: 5 rows where analysis = "diamond", bioproject = "PRJNA1068830" and tax

5 rows where analysis = "diamond", bioproject = "PRJNA1068830" 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
26814254	26814254	PRJNA1068830_P_NODE_35461_length_378_cov_0.878689_g34758_i0	PRJNA1068830	35461	378	0.878689	3.32144442	Prymnesium sp.	2812485	Haptophyta	other_Eukaryota	100	6.75e-22	NR	KAL3911515.1	2812485	g34758	i0	45.1	1.05555555555556	133	62	98.4	3	5	376	35	165	KAL3911515.1 MAG: hypothetical protein SGPRY_008664 [Prymnesium sp.]	diamond	399	100	1	Eukaryota	Haptista	Haptophyta	Prymnesiales	Prymnesiaceae	Prymnesium	Prymnesium sp.
27256943	27256943	PRJNA1068830_P_NODE_20123_length_532_cov_4.389978_g19423_i0	PRJNA1068830	20123	532	4.389978	23.35468296	Emiliania huxleyi CCMP1516	280463	Haptophyta	other_Eukaryota	110	4.0400000000000005e-27	NR	XP_005778651.1	280463	g19423	i0	39.9	0.806390977443609	143	74	80.6	2	492	64	2	132	XP_005778651.1 hypothetical protein EMIHUDRAFT_73627, partial [Emiliania huxleyi CCMP1516]	diamond	429	110	1	Eukaryota	Haptista	Haptophyta	Isochrysidales	Noelaerhabdaceae	Emiliania	Emiliania huxleyi
30943708	30943708	PRJNA1068830_P_NODE_23414_length_486_cov_1.886199_g22713_i0	PRJNA1068830	23414	486	1.886199	9.16692714	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	53.1	7.76e-5	NR	XP_005759829.1	280463	g22713	i0	51.8	0.919753086419753	56	26	34	1	484	320	194	249	XP_005759829.1 hypothetical protein EMIHUDRAFT_121126 [Emiliania huxleyi CCMP1516]	diamond	447	53.1	1	Eukaryota	Haptista	Haptophyta	Isochrysidales	Noelaerhabdaceae	Emiliania	Emiliania huxleyi
31584498	31584498	PRJNA1068830_P_NODE_22516_length_498_cov_1.383529_g21815_i0	PRJNA1068830	22516	498	1.383529	6.88997442	Emiliania huxleyi CCMP1516	280463	Haptophyta	other_Eukaryota	52.8	1.58e-4	NR	XP_005766117.1	280463	g21815	i0	28.3	0.63855421686747	106	73	63.3	3	498	184	335	438	XP_005766117.1 hypothetical protein EMIHUDRAFT_119756 [Emiliania huxleyi CCMP1516]	diamond	318	52.8	1	Eukaryota	Haptista	Haptophyta	Isochrysidales	Noelaerhabdaceae	Emiliania	Emiliania huxleyi
31679089	31679089	PRJNA1068830_P_NODE_70537_length_256_cov_1.704918_g69834_i0	PRJNA1068830	70537	256	1.704918	4.36459008	Chrysochromulina tobinii	1460289	Haptophyta	other_Eukaryota	92	1.99e-19	NR	KOO30472.1	1460289	g69834	i0	45.1	0.9609375	82	45	96.1	0	251	6	2710	2791	KOO30472.1 beta-ketoacyl synthase [Chrysochromulina tobinii]	diamond	246	92	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);;