metadata: contig_metadata: 8 rows where analysis = "diamond", bioproject = "PRJNA513467" and tax

8 rows where analysis = "diamond", bioproject = "PRJNA513467" 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
26792419	26792419	PRJNA513467_S_NODE_4421_length_189_cov_1.315789_g4398_i0	PRJNA513467	4421	189	1.315789	2.48684121	Peronospora belbahrii	622444	SAR_Eukaryotes	SAR_Eukaryotes	107	3.3100000000000004e-26	NR	CAH0521718.1	622444	g4398	i0	91.8	1.93650793650794	61	5	96.8	0	184	2	168	228	CAH0521718.1 unnamed protein product [Peronospora belbahrii]	diamond	366	107	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Peronosporales	Peronosporaceae	Peronospora	Peronospora belbahrii
27550936	27550936	PRJNA513467_S_NODE_3904_length_197_cov_2.662500_g3881_i0	PRJNA513467	3904	197	2.6625	5.245125	Ochromonadaceae sp. CCMP2298	483371	SAR_Eukaryotes	SAR_Eukaryotes	62	3.2e-9	NR	KAJ1434169.1	483371	g3881	i0	80.6	0.548223350253807	36	7	54.8	0	2	109	462	497	KAJ1434169.1 imidazoleglycerol-phosphate dehydratase [Ochromonadaceae sp. CCMP2298]	diamond	108	62	1	Eukaryota	Sar		Synurophyceae	Ochromonadales	Ochromonadaceae		Ochromonadaceae sp. CCMP2298
29193121	29193121	PRJNA513467_S_NODE_3669_length_201_cov_3.329268_g3646_i0	PRJNA513467	3669	201	3.329268	6.69182868	Symbiodinium microadriaticum	2951	SAR_Eukaryotes	SAR_Eukaryotes	121	4.9899999999999994e-30	NR	CAE7482096.1	2951	g3646	i0	79.1	1	67	14	100	0	201	1	506	572	CAE7482096.1 EPRS1, partial [Symbiodinium microadriaticum]	diamond	201	121	1	Eukaryota	Sar		Dinophyceae	Suessiales	Symbiodiniaceae	Symbiodinium	Symbiodinium microadriaticum
29319200	29319200	PRJNA513467_S_NODE_6149_length_168_cov_1.190840_g6126_i0	PRJNA513467	6149	168	1.19084	2.0006112	Tetrahymena thermophila SB21	5911	SAR_Eukaryotes	SAR_Eukaryotes	79	2.12e-15	NR	XP_001010801.1	312017	g6126	i0	61.8	1.91071428571429	55	21	98.2	0	2	166	313	367	XP_001010801.1 FAD-binding containing protein [Tetrahymena thermophila SB210]	diamond	321	79	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Hymenostomatida	Tetrahymenidae	Tetrahymena	Tetrahymena thermophila
31150982	31150982	PRJNA513467_S_NODE_2815_length_221_cov_2.043478_g2792_i0	PRJNA513467	2815	221	2.043478	4.51608638	Peronospora belbahrii	622444	SAR_Eukaryotes	SAR_Eukaryotes	85.5	2.82e-18	NR	CAH0481068.1	622444	g2792	i0	87.8	0.665158371040724	49	6	66.5	0	220	74	190	238	CAH0481068.1 unnamed protein product [Peronospora belbahrii]	diamond	147	85.5	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Peronosporales	Peronosporaceae	Peronospora	Peronospora belbahrii
31372940	31372940	PRJNA513467_S_NODE_3456_length_206_cov_1.337278_g3433_i0	PRJNA513467	3456	206	1.337278	2.75479268	Tetrahymena thermophila SB21	5911	SAR_Eukaryotes	SAR_Eukaryotes	51.6	3.3e-6	NR	XP_001010221.2	312017	g3433	i0	86.7	0.436893203883495	30	4	43.7	0	2	91	95	124	XP_001010221.2 ribosomal protein L35 [Tetrahymena thermophila SB210]	diamond	90	51.6	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Hymenostomatida	Tetrahymenidae	Tetrahymena	Tetrahymena thermophila
31594378	31594378	PRJNA513467_S_NODE_216_length_619_cov_2.841924_g194_i0	PRJNA513467	216	619	2.841924	17.59150956	Ochromonadaceae sp. CCMP2298	483371	SAR_Eukaryotes	SAR_Eukaryotes	187	4.93e-57	NR	KAJ1398873.1	483371	g194	i0	60.5	0.736672051696284	152	57	73.7	3	562	107	2	150	KAJ1398873.1 ribosomal protein L25/Gln-tRNA synthetase, partial [Ochromonadaceae sp. CCMP2298]	diamond	456	187	1	Eukaryota	Sar		Synurophyceae	Ochromonadales	Ochromonadaceae		Ochromonadaceae sp. CCMP2298
32495566	32495566	PRJNA513467_S_NODE_2399_length_235_cov_2.106061_g2376_i0	PRJNA513467	2399	235	2.106061	4.94924335	Oomycota	4762	SAR_Eukaryotes	SAR_Eukaryotes	92.8	7.79e-20	NR	KAG7402106.1	109152	g2376	i0	58.3	14.6170212765957	72	30	91.9	0	233	18	620	691	KAG7402106.1 hypothetical protein PHYBOEH_007320 [Phytophthora boehmeriae]	diamond	3435	93.2	0.995708154506438	Eukaryota	Sar	Oomycota	Peronosporomycetes	Peronosporales	Peronosporaceae	Phytophthora	Phytophthora boehmeriae

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