metadata: contig_metadata: 9 rows where analysis = "diamond", bioproject = "PRJNA760976" and tax

9 rows where analysis = "diamond", bioproject = "PRJNA760976" 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
18594060	18594060	PRJNA760976_P_NODE_44695_length_259_cov_1.403226_g44374_i0	PRJNA760976	44695	259	1.403226	3.63435534	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	84.7	1.34e-18	NR	KAL1515208.1	97485	g44374	i0	63.2	5.66409266409266	68	23	78.8	1	55	258	7	72	KAL1515208.1 hypothetical protein AB1Y20_004269 [Prymnesium parvum]	diamond	1467	85.5	0.990643274853801	Eukaryota	Haptista	Haptophyta		Prymnesiales	Prymnesiaceae	Prymnesium	Prymnesium parvum
27220592	27220592	PRJNA760976_P_NODE_51942_length_245_cov_0.895349_g51621_i0	PRJNA760976	51942	245	0.895349	2.19360505	Diacronema	70451	Haptophyta	other_Eukaryota	70.1	2.05e-12	NR	KAJ1639226.1	483367	g51621	i0	68.2	1.07755102040816	44	14	53.9	0	111	242	4	47	KAJ1639226.1 P-loop containing nucleoside triphosphate hydrolase protein [Pavlovales sp. CCMP2436]	diamond	264	70.1	1	Eukaryota	Haptista	Haptophyta	Pavlovophyceae	Pavlovales			Pavlovales sp. CCMP2436
27789476	27789476	PRJNA760976_P_NODE_47044_length_253_cov_1.405556_g46723_i0	PRJNA760976	47044	253	1.405556	3.55605668	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	50.8	5.56e-5	NR	KAL1526365.1	97485	g46723	i0	41.5	3.53359683794466	65	38	77.1	0	2	196	72	136	KAL1526365.1 hypothetical protein AB1Y20_015079 [Prymnesium parvum]	diamond	894	50.8	1	Eukaryota	Haptista	Haptophyta		Prymnesiales	Prymnesiaceae	Prymnesium	Prymnesium parvum
28000908	28000908	PRJNA760976_P_NODE_57965_length_215_cov_5.183099_g57644_i0	PRJNA760976	57965	215	5.183099	11.14366285	Prymnesium parvum	97485	Haptophyta	other_Eukaryota	87.8	3.54e-18	NR	KAL1500060.1	97485	g57644	i0	63.3	0.837209302325581	60	22	83.7	0	215	36	4330	4389	KAL1500060.1 hypothetical protein AB1Y20_012737 [Prymnesium parvum]	diamond	180	87.8	1	Eukaryota	Haptista	Haptophyta		Prymnesiales	Prymnesiaceae	Prymnesium	Prymnesium parvum
29452779	29452779	PRJNA760976_P_NODE_53170_length_244_cov_0.871345_g52849_i0	PRJNA760976	53170	244	0.871345	2.1260818	Prymnesium parvum	97485	Haptophyta	other_Eukaryota	79	1.56e-16	NR	KAL1495125.1	97485	g52849	i0	48.6	0.909836065573771	74	38	91	0	21	242	58	131	KAL1495125.1 hypothetical protein AB1Y20_016992 [Prymnesium parvum]	diamond	222	79	1	Eukaryota	Haptista	Haptophyta		Prymnesiales	Prymnesiaceae	Prymnesium	Prymnesium parvum
31443544	31443544	PRJNA760976_P_NODE_51516_length_245_cov_3.476744_g51195_i0	PRJNA760976	51516	245	3.476744	8.5180228	Chrysochromulina tobinii	1460289	Haptophyta	other_Eukaryota	48.5	6.88e-5	NR	KOO29468.1	1460289	g51195	i0	70.3	0.453061224489796	37	11	45.3	0	225	115	78	114	KOO29468.1 ubiquitin [Chrysochromulina tobinii]	diamond	111	48.5	1	Eukaryota	Haptista	Haptophyta		Prymnesiales	Chrysochromulinaceae	Chrysochromulina	Chrysochromulina tobinii
31769529	31769529	PRJNA760976_P_NODE_23797_length_328_cov_1.231373_g23476_i0	PRJNA760976	23797	328	1.231373	4.03890344	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	122	4.18e-30	NR	KOO27239.1	1460289	g23476	i0	59.6	1.80182926829268	99	38	90.5	1	3	299	327	423	KOO27239.1 isocitrate dehydrogenase [Chrysochromulina tobinii]	diamond	591	122	1	Eukaryota	Haptista	Haptophyta		Prymnesiales	Chrysochromulinaceae	Chrysochromulina	Chrysochromulina tobinii
32560808	32560808	PRJNA760976_P_NODE_17359_length_366_cov_1.921502_g17038_i0	PRJNA760976	17359	366	1.921502	7.03269732	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	107	1.98e-24	NR	KOO52876.1	1460289	g17038	i0	55.2	3.29508196721311	87	39	71.3	0	365	105	76	162	KOO52876.1 ATP-binding cassette superfamily [Chrysochromulina tobinii]	diamond	1206	107	1	Eukaryota	Haptista	Haptophyta		Prymnesiales	Chrysochromulinaceae	Chrysochromulina	Chrysochromulina tobinii
32708314	32708314	PRJNA760976_P_NODE_53920_length_243_cov_0.905882_g53599_i0	PRJNA760976	53920	243	0.905882	2.20129326	Chrysochromulina tobinii	1460289	Haptophyta	other_Eukaryota	95.1	1.24e-20	NR	KOO28631.1	1460289	g53599	i0	53.8	0.962962962962963	78	35	96.3	1	3	236	206	282	KOO28631.1 putative eh domain-containing protein [Chrysochromulina tobinii]	diamond	234	95.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);;