metadata: contig_metadata: 11 rows where analysis = "diamond", bioproject = "PRJNA515078" and tax

11 rows where analysis = "diamond", bioproject = "PRJNA515078" and tax_phylum = "Cercozoa"

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
16413684	16413684	PRJNA515078_P_NODE_6993_length_353_cov_2.145570_g6760_i0	PRJNA515078	6993	353	2.14557	7.5738621	Cercozoa sp. M6MM	1215613	SAR_Eukaryotes	SAR_Eukaryotes	172	1.76e-50	NR	MES1911029.1	1215613	g6760	i0	75.7	0.977337110481586	115	28	97.7	0	352	8	17	131	MES1911029.1 hypothetical protein [Cercozoa sp. M6MM]	diamond	345	172	1	Eukaryota	Sar	Cercozoa					Cercozoa sp. M6MM
27835138	27835138	PRJNA515078_P_NODE_26504_length_169_cov_1.181818_g26271_i0	PRJNA515078	26504	169	1.181818	1.99727242	Cercozoa sp. M6MM	1215613	SAR_Eukaryotes	SAR_Eukaryotes	53.5	1.27e-6	NR	MES1907419.1	1215613	g26271	i0	52.1	0.85207100591716	48	23	85.2	0	162	19	156	203	MES1907419.1 hypothetical protein [Cercozoa sp. M6MM]	diamond	144	53.5	1	Eukaryota	Sar	Cercozoa					Cercozoa sp. M6MM
27866717	27866717	PRJNA515078_P_NODE_13845_length_237_cov_1.755000_g13612_i0	PRJNA515078	13845	237	1.755	4.15935	Heteromita sp. PRA-74	323453	SAR_Eukaryotes	SAR_Eukaryotes	127	8.55e-36	NR	ADK26622.1	323453	g13612	i0	84.3	0.886075949367089	70	11	88.6	0	2	211	61	130	ADK26622.1 rps22a [Heteromita sp. PRA-74]	diamond	210	127	1	Eukaryota	Sar	Cercozoa		Cercomonadida	Heteromitidae	Heteromita	Heteromita sp. PRA-74
29634629	29634629	PRJNA515078_P_NODE_6930_length_355_cov_1.946541_g6697_i0	PRJNA515078	6930	355	1.946541	6.91022055	Cercozoa sp. M6MM	1215613	SAR_Eukaryotes	SAR_Eukaryotes	132	4.82e-35	NR	MES1911029.1	1215613	g6697	i0	59.3	1.8169014084507	118	44	96.3	2	353	12	155	272	MES1911029.1 hypothetical protein [Cercozoa sp. M6MM]	diamond	645	132	1	Eukaryota	Sar	Cercozoa					Cercozoa sp. M6MM
29761172	29761172	PRJNA515078_P_NODE_22991_length_181_cov_1.083333_g22758_i0	PRJNA515078	22991	181	1.083333	1.96083273	Heteromita sp. PRA-74	323453	SAR_Eukaryotes	SAR_Eukaryotes	73.2	9.89e-15	NR	ADK26622.1	323453	g22758	i0	90	0.662983425414365	40	4	66.3	0	60	179	1	40	ADK26622.1 rps22a [Heteromita sp. PRA-74]	diamond	120	73.2	1	Eukaryota	Sar	Cercozoa		Cercomonadida	Heteromitidae	Heteromita	Heteromita sp. PRA-74
29792716	29792716	PRJNA515078_P_NODE_31011_length_157_cov_1.625000_g30778_i0	PRJNA515078	31011	157	1.625	2.55125	Cercozoa sp. M6MM	1215613	SAR_Eukaryotes	SAR_Eukaryotes	44.7	0.00238	NR	MES1909263.1	1215613	g30778	i0	51.5	1.5859872611465	33	16	63.1	0	57	155	2785	2817	MES1909263.1 hypothetical protein [Cercozoa sp. M6MM]	diamond	249	44.7	1	Eukaryota	Sar	Cercozoa					Cercozoa sp. M6MM
30425186	30425186	PRJNA515078_P_NODE_7253_length_346_cov_1.440129_g7020_i0	PRJNA515078	7253	346	1.440129	4.98284634	Heteromita sp. PRA-74	323453	SAR_Eukaryotes	SAR_Eukaryotes	89	1.23e-18	NR	ADK26624.1	323453	g7020	i0	72.7	0.476878612716763	55	15	47.7	0	345	181	222	276	ADK26624.1 elongation factor 2, partial [Heteromita sp. PRA-74]	diamond	165	89	1	Eukaryota	Sar	Cercozoa		Cercomonadida	Heteromitidae	Heteromita	Heteromita sp. PRA-74
30456698	30456698	PRJNA515078_P_NODE_29213_length_161_cov_1.879032_g28980_i0	PRJNA515078	29213	161	1.879032	3.02524152	Bigelowiella natans	227086	SAR_Eukaryotes	SAR_Eukaryotes	45.8	5.53e-4	NR	AAT09077.1	227086	g28980	i0	47.9	2.6832298136646	48	21	89.4	1	148	5	1	44	AAT09077.1 transcription factor BTF3 [Bigelowiella natans]	diamond	432	45.8	1	Eukaryota	Sar	Cercozoa	Chlorarachniophyceae			Bigelowiella	Bigelowiella natans
31182706	31182706	PRJNA515078_P_NODE_18435_length_202_cov_1.890909_g18202_i0	PRJNA515078	18435	202	1.890909	3.81963618	Heteromita sp. PRA-74	323453	SAR_Eukaryotes	SAR_Eukaryotes	113	6.59e-29	NR	ADK26624.1	323453	g18202	i0	77.6	0.995049504950495	67	15	99.5	0	1	201	137	203	ADK26624.1 elongation factor 2, partial [Heteromita sp. PRA-74]	diamond	201	113	1	Eukaryota	Sar	Cercozoa		Cercomonadida	Heteromitidae	Heteromita	Heteromita sp. PRA-74
31689001	31689001	PRJNA515078_P_NODE_9437_length_296_cov_2.250965_g9204_i0	PRJNA515078	9437	296	2.250965	6.6628564	Cercozoa sp. M6MM	1215613	SAR_Eukaryotes	SAR_Eukaryotes	47.8	0.00128	NR	MES1910542.1	1215613	g9204	i0	42.2	0.456081081081081	45	25	44.6	1	39	170	3871	3915	MES1910542.1 hypothetical protein [Cercozoa sp. M6MM]	diamond	135	47.8	1	Eukaryota	Sar	Cercozoa					Cercozoa sp. M6MM
32732474	32732474	PRJNA515078_P_NODE_29860_length_160_cov_1.235772_g29627_i0	PRJNA515078	29860	160	1.235772	1.9772352	Cercozoa sp. M6MM	1215613	SAR_Eukaryotes	SAR_Eukaryotes	65.1	1.57e-11	NR	MES1913677.1	1215613	g29627	i0	57.8	6.075	45	19	84.4	0	15	149	71	115	MES1913677.1 hypothetical protein [Cercozoa sp. M6MM]	diamond	972	65.1	1	Eukaryota	Sar	Cercozoa					Cercozoa sp. M6MM

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