metadata: contig_metadata: 9 rows where bioproject = "PRJNA737474", tax_clade = "Metamonada" and tax

9 rows where bioproject = "PRJNA737474", tax_clade = "Metamonada" and tax_phylum = "Fornicata"

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
26532398	26532398	PRJNA737474f_S_NODE_3360_length_1266_cov_4.109807_g2963_i0	PRJNA737474	3360	1266	4.109807	52.03015662	Spironucleus salmonicida	348837	Fornicata	other_Eukaryota	259	2.07e-74	NR	XP_067763333.1	348837	g2963	i0	54	0.535545023696682	226	104	53.6	0	707	30	343	568	XP_067763333.1 Elongation factor 2 [Spironucleus salmonicida]	diamond	678	259	1	Eukaryota	Metamonada	Fornicata	Diplomonadida	Hexamitidae	Spironucleus	Spironucleus salmonicida
32992889	32992889	PRJNA737474f_S_NODE_114899_length_283_cov_1.080952_g114221_i0	PRJNA737474	114899	283	1.080952	3.05909416	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	108	4.3899999999999995e-25	NR	KAG9397068.1	201153	g114221	i0	62.4	12.7526501766784	93	35	98.6	0	3	281	1357	1449	KAG9397068.1 RNA polymerase Rpb1 domain 5 [Carpediemonas membranifera]	diamond	3609	108	1	Eukaryota	Metamonada	Fornicata			Carpediemonas	Carpediemonas membranifera
33020890	33020890	PRJNA737474b_S_NODE_20436_length_354_cov_6.871886_g19397_i0	PRJNA737474	20436	354	6.871886	24.32647644	Aduncisulcus paluster	2918883	Fornicata	other_Eukaryota	65.5	1.22e-9	NR	GKT24586.1	2918883	g19397	i0	50	1.92372881355932	58	29	49.2	0	179	6	1	58	GKT24586.1 Actin-1 [Aduncisulcus paluster]	diamond	681	65.5	1	Eukaryota	Metamonada	Fornicata			Aduncisulcus	Aduncisulcus paluster
33074594	33074594	PRJNA737474g_S_NODE_70101_length_364_cov_2.683849_g68807_i0	PRJNA737474	70101	364	2.683849	9.76921036	Carpediemonas membranifera	201153	Fornicata	other_Eukaryota	107	1.8e-27	NR	KAG9393782.1	201153	g68807	i0	67.1	0.675824175824176	82	27	67.6	0	363	118	22	103	KAG9393782.1 Ribosomal protein L44e [Carpediemonas membranifera]	diamond	246	107	1	Eukaryota	Metamonada	Fornicata			Carpediemonas	Carpediemonas membranifera
33090604	33090604	PRJNA737474f_S_NODE_36694_length_371_cov_4.251678_g36016_i0	PRJNA737474	36694	371	4.251678	15.77372538	Carpediemonas membranifera	201153	Fornicata	other_Eukaryota	114	5.06e-30	NR	KAG9393782.1	201153	g36016	i0	68.7	0.671159029649596	83	26	67.1	0	370	122	21	103	KAG9393782.1 Ribosomal protein L44e [Carpediemonas membranifera]	diamond	249	114	1	Eukaryota	Metamonada	Fornicata			Carpediemonas	Carpediemonas membranifera
33142886	33142886	PRJNA737474g_S_NODE_67703_length_368_cov_3.708475_g66409_i0	PRJNA737474	67703	368	3.708475	13.647188	Carpediemonas membranifera	201153	Fornicata	other_Eukaryota	119	3.63e-32	NR	KAG9393782.1	201153	g66409	i0	68.6	0.701086956521739	86	27	70.1	0	342	85	18	103	KAG9393782.1 Ribosomal protein L44e [Carpediemonas membranifera]	diamond	258	119	1	Eukaryota	Metamonada	Fornicata			Carpediemonas	Carpediemonas membranifera
33146567	33146567	PRJNA737474f_S_NODE_81447_length_304_cov_1.367965_g80769_i0	PRJNA737474	81447	304	1.367965	4.1586136	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	75.9	7.52e-15	NR	KAG9392706.1	201153	g80769	i0	55.6	1.27302631578947	63	26	62.2	1	15	203	90	150	KAG9392706.1 Translation elongation factor IF5A [Carpediemonas membranifera]	diamond	387	75.9	1	Eukaryota	Metamonada	Fornicata			Carpediemonas	Carpediemonas membranifera
33158661	33158661	PRJNA737474f_S_NODE_37440_length_369_cov_1.881757_g36762_i0	PRJNA737474	37440	369	1.881757	6.94368333	Carpediemonas membranifera	201153	Fornicata	other_Eukaryota	128	1.19e-32	NR	KAG9395512.1	201153	g36762	i0	52.5	0.991869918699187	122	58	99.2	0	369	4	224	345	KAG9395512.1 Chaperone DnaJ [Carpediemonas membranifera]	diamond	366	128	1	Eukaryota	Metamonada	Fornicata			Carpediemonas	Carpediemonas membranifera
33175599	33175599	PRJNA737474f_S_NODE_139376_length_271_cov_1.176768_g138698_i0	PRJNA737474	139376	271	1.176768	3.18904128	Carpediemonas membranifera	201153	Fornicata	other_Eukaryota	73.2	6.91e-13	NR	KAG9395486.1	201153	g138698	i0	52.4	3.44280442804428	63	30	69.7	0	200	12	193	255	KAG9395486.1 Protein kinase domain [Carpediemonas membranifera]	diamond	933	73.2	1	Eukaryota	Metamonada	Fornicata			Carpediemonas	Carpediemonas membranifera

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