metadata: contig_metadata: 6 rows where analysis = "diamond", bioproject = "PRJNA1073183" and tax

6 rows where analysis = "diamond", bioproject = "PRJNA1073183" and tax_phylum = "Haptophyta"

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
19313083	19313083	PRJNA1073183_P_NODE_32576_length_243_cov_0.905882_g32481_i0	PRJNA1073183	32576	243	0.905882	2.20129326	Chrysochromulina tobinii	1460289	Haptophyta	other_Eukaryota	103	2.0499999999999999e-23	NR	KOO20942.1	1460289	g32481	i0	58.5	3.03703703703704	82	32	100	2	243	1	297	377	KOO20942.1 acid trehalase-like protein 1 [Chrysochromulina tobinii]	diamond	738	103	1	Eukaryota	Haptista	Haptophyta		Prymnesiales	Chrysochromulinaceae	Chrysochromulina	Chrysochromulina tobinii
26932390	26932390	PRJNA1073183_P_NODE_5082_length_563_cov_1.100000_g4989_i0	PRJNA1073183	5082	563	1.1	6.193	Diacronema	70451	Haptophyta	other_Eukaryota	261	7.67e-84	NR	KAJ1637874.1	483367	g4989	i0	69.8	2.01420959147425	189	55	99.6	2	562	2	30	218	KAJ1637874.1 cytosolic fructose-1,6-bisphosphatase [Pavlovales sp. CCMP2436]	diamond	1134	261	1	Eukaryota	Haptista	Haptophyta	Pavlovophyceae	Pavlovales			Pavlovales sp. CCMP2436
27920170	27920170	PRJNA1073183_P_NODE_32105_length_244_cov_0.900585_g32010_i0	PRJNA1073183	32105	244	0.900585	2.1974274	Prymnesium parvum	97485	Haptophyta	other_Eukaryota	84	5.51e-17	NR	KAL1496500.1	97485	g32010	i0	55.1	0.959016393442623	78	32	95.9	1	243	10	160	234	KAL1496500.1 hypothetical protein AB1Y20_016454 [Prymnesium parvum]	diamond	234	84	1	Eukaryota	Haptista	Haptophyta		Prymnesiales	Prymnesiaceae	Prymnesium	Prymnesium parvum
28078001	28078001	PRJNA1073183_P_NODE_33565_length_242_cov_0.911243_g33470_i0	PRJNA1073183	33565	242	0.911243	2.20520806	Chrysochromulina tobinii	1460289	Haptophyta	other_Eukaryota	58.5	9.67e-8	NR	KOO24027.1	1460289	g33470	i0	51.5	0.818181818181818	66	28	76.9	2	219	34	367	432	KOO24027.1 cyanophycinase [Chrysochromulina tobinii]	diamond	198	58.5	1	Eukaryota	Haptista	Haptophyta		Prymnesiales	Chrysochromulinaceae	Chrysochromulina	Chrysochromulina tobinii
29688052	29688052	PRJNA1073183_P_NODE_24130_length_265_cov_1.604167_g24035_i0	PRJNA1073183	24130	265	1.604167	4.25104255	Chrysochromulina tobinii	1460289	Haptophyta	other_Eukaryota	147	7.79e-39	NR	KOO30669.1	1460289	g24035	i0	72.6	0.950943396226415	84	23	95.1	0	3	254	227	310	KOO30669.1 lysosomal alpha-mannosidase-like protein [Chrysochromulina tobinii]	diamond	252	147	1	Eukaryota	Haptista	Haptophyta		Prymnesiales	Chrysochromulinaceae	Chrysochromulina	Chrysochromulina tobinii
30825628	30825628	PRJNA1073183_P_NODE_15694_length_329_cov_10.035156_g15599_i0	PRJNA1073183	15694	329	10.035156	33.01566324	Emiliania huxleyi CCMP1516	280463	Haptophyta	other_Eukaryota	87	1.62e-19	NR	XP_005782836.1	280463	g15599	i0	50	1.89665653495441	102	47	92.1	2	309	7	16	114	XP_005782836.1 hypothetical protein EMIHUDRAFT_442529 [Emiliania huxleyi CCMP1516]	diamond	624	87	1	Eukaryota	Haptista	Haptophyta		Isochrysidales	Noelaerhabdaceae	Emiliania	Emiliania huxleyi

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