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

9 rows where analysis = "diamond", bioproject = "PRJNA898105" and tax_clade = "Sar"

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
26897668	26897668	PRJNA898105_P_NODE_5961_length_253_cov_1.388889_g5761_i0	PRJNA898105	5961	253	1.388889	3.51388917	Hondaea fermentalgiana	2315210	SAR_Eukaryotes	SAR_Eukaryotes	130	7.92e-33	NR	GBG23950.1	2315210	g5761	i0	74.1	0.960474308300395	81	21	96	0	243	1	545	625	GBG23950.1 Protein kinase, putative [Hondaea fermentalgiana]	diamond	243	130	1	Eukaryota	Sar		Bigyra	Thraustochytrida	Thraustochytriidae	Hondaea	Hondaea fermentalgiana
27403515	27403515	PRJNA898105_P_NODE_5863_length_255_cov_1.692308_g5663_i0	PRJNA898105	5863	255	1.692308	4.3153854	Durusdinium trenchii	1381693	SAR_Eukaryotes	SAR_Eukaryotes	135	6.209999999999999e-37	NR	CAK9041111.1	1381693	g5663	i0	74.4	2.01176470588235	86	20	98.8	1	253	2	104	189	CAK9041111.1 Cytochrome c peroxidase, partial [Durusdinium trenchii]	diamond	513	135	1	Eukaryota	Sar		Dinophyceae	Suessiales	Symbiodiniaceae	Durusdinium	Durusdinium trenchii
27537423	27537423	PRJNA898105_P_NODE_5043_length_271_cov_1.555556_g4843_i0	PRJNA898105	5043	271	1.555556	4.21555676	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	110	5.75e-26	NR	CAJ1921532.1	2856	g4843	i0	64	3.04428044280443	89	31	97.4	1	269	6	873	961	CAJ1921532.1 unnamed protein product [Cylindrotheca closterium]	diamond	825	110	1	Eukaryota	Sar	Bacillariophyta	Bacillariophyceae	Bacillariales	Bacillariaceae	Cylindrotheca	Cylindrotheca closterium
28161366	28161366	PRJNA898105_P_NODE_6325_length_250_cov_0.870056_g6125_i0	PRJNA898105	6325	250	0.870056	2.17514	Cylindrotheca closterium	2856	SAR_Eukaryotes	SAR_Eukaryotes	70.5	5.9e-12	NR	CAJ1962286.1	2856	g6125	i0	39.8	1.992	83	49	98.4	1	248	3	228	310	CAJ1962286.1 unnamed protein product [Cylindrotheca closterium]	diamond	498	70.5	1	Eukaryota	Sar	Bacillariophyta	Bacillariophyceae	Bacillariales	Bacillariaceae	Cylindrotheca	Cylindrotheca closterium
29707863	29707863	PRJNA898105_P_NODE_7050_length_247_cov_0.885057_g6850_i0	PRJNA898105	7050	247	0.885057	2.18609079	Pythium oligandrum	41045	SAR_Eukaryotes	SAR_Eukaryotes	57.8	1.94e-7	NR	TMW65743.1	41045	g6850	i0	47.1	1.60323886639676	68	33	78.9	1	243	49	224	291	TMW65743.1 hypothetical protein Poli38472_008385 [Pythium oligandrum]	diamond	396	57.8	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Pythiales	Pythiaceae	Pythium	Pythium oligandrum
30948289	30948289	PRJNA898105_P_NODE_8434_length_237_cov_2.810976_g8234_i0	PRJNA898105	8434	237	2.810976	6.66201312	Oomycota	4762	SAR_Eukaryotes	SAR_Eukaryotes	103	1.4499999999999998e-23	NR	TMW61054.1	41045	g8234	i0	58.2	5	79	33	100	0	1	237	313	391	TMW61054.1 hypothetical protein Poli38472_014515 [Pythium oligandrum]	diamond	1185	103	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Pythiales	Pythiaceae	Pythium	Pythium oligandrum
31098235	31098235	PRJNA898105_P_NODE_2315_length_387_cov_1.898089_g2115_i0	PRJNA898105	2315	387	1.898089	7.34560443	Hondaea fermentalgiana	2315210	SAR_Eukaryotes	SAR_Eukaryotes	57.4	9.96e-7	NR	GBG29737.1	2315210	g2115	i0	35.3	0.922480620155039	119	63	91.5	3	33	386	70	175	GBG29737.1 Long-chain fatty acid transport protein 4 [Hondaea fermentalgiana]	diamond	357	57.4	1	Eukaryota	Sar		Bigyra	Thraustochytrida	Thraustochytriidae	Hondaea	Hondaea fermentalgiana
31509635	31509635	PRJNA898105_P_NODE_2956_length_342_cov_1.988848_g2756_i0	PRJNA898105	2956	342	1.988848	6.80186016	Hondaea fermentalgiana	2315210	SAR_Eukaryotes	SAR_Eukaryotes	153	4.55e-42	NR	GBG24767.1	2315210	g2756	i0	61.4	2	114	44	100	0	342	1	287	400	GBG24767.1 Coronin-like protein [Hondaea fermentalgiana]	diamond	684	153	1	Eukaryota	Sar		Bigyra	Thraustochytrida	Thraustochytriidae	Hondaea	Hondaea fermentalgiana
31952227	31952227	PRJNA898105_P_NODE_6677_length_249_cov_0.875000_g6477_i0	PRJNA898105	6677	249	0.875	2.17875	Hondaea fermentalgiana	2315210	SAR_Eukaryotes	SAR_Eukaryotes	71.2	1.31e-13	NR	GBG34447.1	2315210	g6477	i0	50	1.7710843373494	72	35	85.5	1	214	2	53	124	GBG34447.1 Proteasome maturation protein [Hondaea fermentalgiana]	diamond	441	71.2	1	Eukaryota	Sar		Bigyra	Thraustochytrida	Thraustochytriidae	Hondaea	Hondaea fermentalgiana

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