metadata: contig_metadata: 8 rows where bioproject = "PRJNA603943" and tax

8 rows where bioproject = "PRJNA603943" 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
20979846	20979846	PRJNA603943_P_NODE_52317_length_251_cov_2.595506_g52125_i0	PRJNA603943	52317	251	2.595506	6.51472006	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	101	9.62e-23	NR	KAJ1616776.1	483367	g52125	i0	78.1	4.98406374501992	64	14	76.5	0	60	251	12	75	KAJ1616776.1 chaperonin Cpn60/TCP-1 family [Pavlovales sp. CCMP2436]	diamond	1251	102	0.990196078431373	Eukaryota	Haptista	Haptophyta	Pavlovophyceae	Pavlovales			Pavlovales sp. CCMP2436
28040863	28040863	PRJNA603943_P_NODE_61865_length_246_cov_0.890173_g61673_i0	PRJNA603943	61865	246	0.890173	2.18982558	root	1	Root_unresolved	Root_unresolved	89	1.99e-18	NR	XP_005762436.1	280463	g61673	i0	54.3	3.91463414634146	81	32	98.8	2	3	245	370	445	XP_005762436.1 glyceraldehyde-3-phosphate dehydrogenase [Emiliania huxleyi CCMP1516]	diamond	963	89	1	Eukaryota	Haptista	Haptophyta		Isochrysidales	Noelaerhabdaceae	Emiliania	Emiliania huxleyi
29321986	29321986	PRJNA603943_P_NODE_48869_length_263_cov_1.215789_g48677_i0	PRJNA603943	48869	263	1.215789	3.19752507	Diacronema lutheri	2081491	Haptophyta	other_Eukaryota	93.2	8.71e-20	NR	KAG8461906.1	2081491	g48677	i0	64.3	0.958174904942966	84	27	92.4	3	262	20	1273	1356	KAG8461906.1 hypothetical protein KFE25_013925 [Diacronema lutheri]	diamond	252	93.2	1	Eukaryota	Haptista	Haptophyta	Pavlovophyceae	Pavlovales	Pavlovaceae	Diacronema	Diacronema lutheri
29700579	29700579	PRJNA603943_P_NODE_67430_length_242_cov_2.278107_g67238_i0	PRJNA603943	67430	242	2.278107	5.51301894	Prymnesium parvum	97485	Haptophyta	other_Eukaryota	69.7	1.15e-11	NR	KAL1502925.1	97485	g67238	i0	36.7	0.979338842975207	79	48	97.9	1	5	241	219	295	KAL1502925.1 hypothetical protein AB1Y20_010997 [Prymnesium parvum]	diamond	237	69.7	1	Eukaryota	Haptista	Haptophyta		Prymnesiales	Prymnesiaceae	Prymnesium	Prymnesium parvum
30269823	30269823	PRJNA603943_P_NODE_55572_length_250_cov_0.870056_g55380_i0	PRJNA603943	55572	250	0.870056	2.17514	Prymnesium parvum	97485	Haptophyta	other_Eukaryota	80.9	2.85e-17	NR	KAL1500526.1	97485	g55380	i0	55.4	0.996	83	24	99.6	1	1	249	2	71	KAL1500526.1 hypothetical protein AB1Y20_013182 [Prymnesium parvum]	diamond	249	80.9	1	Eukaryota	Haptista	Haptophyta		Prymnesiales	Prymnesiaceae	Prymnesium	Prymnesium parvum
31628574	31628574	PRJNA603943_P_NODE_57796_length_248_cov_0.880000_g57604_i0	PRJNA603943	57796	248	0.88	2.1824	Prymnesium parvum	97485	Haptophyta	other_Eukaryota	50.8	2.04e-5	NR	KAL1524702.1	97485	g57604	i0	37.3	0.907258064516129	75	44	87.1	2	230	15	27	101	KAL1524702.1 hypothetical protein AB1Y20_019587 [Prymnesium parvum]	diamond	225	50.8	1	Eukaryota	Haptista	Haptophyta		Prymnesiales	Prymnesiaceae	Prymnesium	Prymnesium parvum
31913258	31913258	PRJNA603943_P_NODE_20677_length_378_cov_1.340984_g20485_i0	PRJNA603943	20677	378	1.340984	5.06891952	Diacronema lutheri	2081491	Haptophyta	other_Eukaryota	197	1.52e-58	NR	KAG8463530.1	2081491	g20485	i0	78.5	0.96031746031746	121	26	96	0	363	1	1	121	KAG8463530.1 hypothetical protein KFE25_003803 [Diacronema lutheri]	diamond	363	197	1	Eukaryota	Haptista	Haptophyta	Pavlovophyceae	Pavlovales	Pavlovaceae	Diacronema	Diacronema lutheri
32892425	32892425	PRJNA603943_P_NODE_23480_length_361_cov_0.916667_g23288_i0	PRJNA603943	23480	361	0.916667	3.30916787	Prymnesium parvum	97485	Haptophyta	other_Eukaryota	55.5	4.82e-6	NR	KAL1503913.1	97485	g23288	i0	33	0.85595567867036	103	62	85.6	2	47	355	286	381	KAL1503913.1 hypothetical protein AB1Y20_012374 [Prymnesium parvum]	diamond	309	55.5	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);;