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

11 rows where analysis = "diamond", bioproject = "PRJNA312615" 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
9991882	9991882	PRJNA312615_P_NODE_1568_length_843_cov_3.249370_g1455_i0	PRJNA312615	1568	843	3.24937	27.3921891	Cercozoa sp. M6MM	1215613	SAR_Eukaryotes	SAR_Eukaryotes	359	2.4499999999999996e-121	NR	MES1911029.1	1215613	g1455	i0	68.4	0.96797153024911	272	82	95.4	1	834	31	1	272	MES1911029.1 hypothetical protein [Cercozoa sp. M6MM]	diamond	816	359	1	Eukaryota	Sar	Cercozoa					Cercozoa sp. M6MM
11266914	11266914	PRJNA312615_P_NODE_16529_length_302_cov_1.577075_g16378_i0	PRJNA312615	16529	302	1.577075	4.7627665	Cercozoa sp. M6MM	1215613	SAR_Eukaryotes	SAR_Eukaryotes	110	7.5299999999999995e-28	NR	MES1910388.1	1215613	g16378	i0	79	0.615894039735099	62	13	61.6	0	302	117	143	204	MES1910388.1 Proteasome subunit beta type-3-A [Cercozoa sp. M6MM]	diamond	186	110	1	Eukaryota	Sar	Cercozoa					Cercozoa sp. M6MM
18230520	18230520	PRJNA312615_P_NODE_8435_length_424_cov_2.885333_g8285_i0	PRJNA312615	8435	424	2.885333	12.23381192	Heteromita sp. PRA-74	323453	SAR_Eukaryotes	SAR_Eukaryotes	272	5.37e-90	NR	ADK26624.1	323453	g8285	i0	91.5	0.997641509433962	141	12	99.8	0	2	424	58	198	ADK26624.1 elongation factor 2, partial [Heteromita sp. PRA-74]	diamond	423	272	1	Eukaryota	Sar	Cercozoa		Cercomonadida	Heteromitidae	Heteromita	Heteromita sp. PRA-74
24604005	24604005	PRJNA312615_P_NODE_20300_length_270_cov_2.307692_g20149_i0	PRJNA312615	20300	270	2.307692	6.2307684	Gymnochlora stellata	67809	SAR_Eukaryotes	SAR_Eukaryotes	160	2.6899999999999998e-48	NR	ACF24571.1	67809	g20149	i0	82	7.85555555555556	89	16	98.9	0	269	3	49	137	ACF24571.1 ubiquitin-conjugating enzyme 2 [Gymnochlora stellata]	diamond	2121	160	1	Eukaryota	Sar	Cercozoa	Chlorarachniophyceae			Gymnochlora	Gymnochlora stellata
28748012	28748012	PRJNA312615_P_NODE_17807_length_289_cov_8.875000_g17656_i0	PRJNA312615	17807	289	8.875	25.64875	Gymnochlora stellata	67809	SAR_Eukaryotes	SAR_Eukaryotes	117	7.039999999999999e-32	NR	ACF24578.1	67809	g17656	i0	62.8	2.67820069204152	86	32	89.3	0	29	286	1	86	ACF24578.1 60S ribosomal protein L34 [Gymnochlora stellata]	diamond	774	117	1	Eukaryota	Sar	Cercozoa	Chlorarachniophyceae			Gymnochlora	Gymnochlora stellata
28842609	28842609	PRJNA312615_P_NODE_41968_length_189_cov_1.271429_g41817_i0	PRJNA312615	41968	189	1.271429	2.40300081	Cercozoa sp. M6MM	1215613	SAR_Eukaryotes	SAR_Eukaryotes	59.3	2.08e-8	NR	MES1912506.1	1215613	g41817	i0	47.4	0.904761904761905	57	30	90.5	0	6	176	12	68	MES1912506.1 hypothetical protein [Cercozoa sp. M6MM]	diamond	171	59.3	1	Eukaryota	Sar	Cercozoa					Cercozoa sp. M6MM
29568880	29568880	PRJNA312615_P_NODE_14830_length_319_cov_1.511111_g14679_i0	PRJNA312615	14830	319	1.511111	4.82044409	Cercozoa sp. M6MM	1215613	SAR_Eukaryotes	SAR_Eukaryotes	71.6	6.23e-12	NR	MES1914001.1	1215613	g14679	i0	45	0.940438871473354	100	53	94	1	6	305	255	352	MES1914001.1 hypothetical protein [Cercozoa sp. M6MM]	diamond	300	71.6	1	Eukaryota	Sar	Cercozoa					Cercozoa sp. M6MM
30453647	30453647	PRJNA312615_P_NODE_34733_length_208_cov_1.283019_g34582_i0	PRJNA312615	34733	208	1.283019	2.66867952	Cercozoa sp. M6MM	1215613	SAR_Eukaryotes	SAR_Eukaryotes	118	4.9199999999999993e-29	NR	MES1911648.1	1215613	g34582	i0	77.9	1.93269230769231	68	15	98.1	0	204	1	74	141	MES1911648.1 hypothetical protein [Cercozoa sp. M6MM]	diamond	402	118	1	Eukaryota	Sar	Cercozoa					Cercozoa sp. M6MM
31514221	31514221	PRJNA312615_P_NODE_33016_length_213_cov_1.243902_g32865_i0	PRJNA312615	33016	213	1.243902	2.64951126	root	1	Root_unresolved	Root_unresolved	96.3	2.9400000000000003e-21	NR	MES1906957.1	1215613	g32865	i0	67.1	1.97183098591549	70	23	98.6	0	212	3	337	406	MES1906957.1 hypothetical protein [Cercozoa sp. M6MM]	diamond	420	97.1	0.991761071060762	Eukaryota	Sar	Cercozoa					Cercozoa sp. M6MM
31686024	31686024	PRJNA312615_P_NODE_58777_length_157_cov_2.277778_g58626_i0	PRJNA312615	58777	157	2.277778	3.57611146	Heteromita sp. PRA-74	323453	SAR_Eukaryotes	SAR_Eukaryotes	68.6	4.79e-13	NR	ADK26622.1	323453	g58626	i0	96.8	0.592356687898089	31	1	59.2	0	2	94	100	130	ADK26622.1 rps22a [Heteromita sp. PRA-74]	diamond	93	68.6	1	Eukaryota	Sar	Cercozoa		Cercomonadida	Heteromitidae	Heteromita	Heteromita sp. PRA-74
32540630	32540630	PRJNA312615_P_NODE_40439_length_193_cov_1.062500_g40288_i0	PRJNA312615	40439	193	1.0625	2.050625	Bigelowiella natans	227086	SAR_Eukaryotes	SAR_Eukaryotes	98.6	3.94e-25	NR	AAP34642.1	227086	g40288	i0	70.3	0.994818652849741	64	19	99.5	0	1	192	13	76	AAP34642.1 small ubiquitin-like modifier [Bigelowiella natans]	diamond	192	98.6	1	Eukaryota	Sar	Cercozoa	Chlorarachniophyceae			Bigelowiella	Bigelowiella natans

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