metadata: contig_metadata: 10 rows where bioproject = "PRJNA492363" and tax

10 rows where bioproject = "PRJNA492363" 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
25975307	25975307	PRJNA492363_S_NODE_77812_length_217_cov_2.224359_g76991_i0	PRJNA492363	77812	217	2.224359	4.82685903	Hyaloperonospora brassicae	162125	SAR_Eukaryotes	SAR_Eukaryotes	109	7.65e-26	NR	CAI5737126.1	162125	g76991	i0	89.8	0.815668202764977	59	6	81.6	0	216	40	126	184	CAI5737126.1 unnamed protein product [Hyaloperonospora brassicae]	diamond	177	109	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Peronosporales	Peronosporaceae	Hyaloperonospora	Hyaloperonospora brassicae
26246428	26246428	PRJNA492363_S_NODE_12390_length_278_cov_1.474654_g11569_i0	PRJNA492363	12390	278	1.474654	4.09953812	Hyaloperonospora parasitica	123356	SAR_Eukaryotes	SAR_Eukaryotes	254	6.54e-63	NTclustered	gi\|188496780\|emb\|CU856298.2\|	123356	g11569	i0	85.306	0.881294964028777	245	36	88	0	1	245	81488	81244	H.parasitica DNA sequence from clone HpEmoy2-6G8, complete sequence	blastn	245	254	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Peronosporales	Peronosporaceae	Hyaloperonospora	Hyaloperonospora parasitica
32952564	32952564	PRJNA492363_S_NODE_75946_length_219_cov_1.215190_g75125_i0	PRJNA492363	75946	219	1.21519	2.6612661	Ochromonadaceae sp. CCMP2298	483371	SAR_Eukaryotes	SAR_Eukaryotes	87.4	3.18e-18	NR	KAJ1414037.1	483371	g75125	i0	58.3	0.986301369863014	72	29	98.6	1	219	4	8	78	KAJ1414037.1 peptidase family C69-domain-containing protein [Ochromonadaceae sp. CCMP2298]	diamond	216	87.4	1	Eukaryota	Sar		Synurophyceae	Ochromonadales	Ochromonadaceae		Ochromonadaceae sp. CCMP2298
32952617	32952617	PRJNA492363_S_NODE_88042_length_208_cov_0.870748_g87221_i0	PRJNA492363	88042	208	0.870748	1.81115584	Ochromonadaceae sp. CCMP2298	483371	SAR_Eukaryotes	SAR_Eukaryotes	79.3	2.92e-15	NR	KAJ1440570.1	483371	g87221	i0	82.5	0.576923076923077	40	7	57.7	0	146	27	509	548	KAJ1440570.1 hypothetical protein B484DRAFT_443343 [Ochromonadaceae sp. CCMP2298]	diamond	120	79.3	1	Eukaryota	Sar		Synurophyceae	Ochromonadales	Ochromonadaceae		Ochromonadaceae sp. CCMP2298
32986527	32986527	PRJNA492363_S_NODE_100979_length_201_cov_0.914286_g100158_i0	PRJNA492363	100979	201	0.914286	1.83771486	Ochromonadaceae sp. CCMP2298	483371	SAR_Eukaryotes	SAR_Eukaryotes	55.8	5.04e-7	NR	KAJ1441069.1	483371	g100158	i0	37.3	1.61194029850746	59	33	82.1	1	2	166	612	670	KAJ1441069.1 hypothetical protein B484DRAFT_390921 [Ochromonadaceae sp. CCMP2298]	diamond	324	55.8	1	Eukaryota	Sar		Synurophyceae	Ochromonadales	Ochromonadaceae		Ochromonadaceae sp. CCMP2298
33037675	33037675	PRJNA492363_S_NODE_14060_length_265_cov_0.941176_g13239_i0	PRJNA492363	14060	265	0.941176	2.4941164	Ochromonadaceae sp. CCMP2298	483371	SAR_Eukaryotes	SAR_Eukaryotes	118	1.01e-28	NR	KAJ1428064.1	483371	g13239	i0	66.3	0.973584905660377	86	29	97.4	0	2	259	231	316	KAJ1428064.1 glycoside hydrolase superfamily [Ochromonadaceae sp. CCMP2298]	diamond	258	118	1	Eukaryota	Sar		Synurophyceae	Ochromonadales	Ochromonadaceae		Ochromonadaceae sp. CCMP2298
33071673	33071673	PRJNA492363_S_NODE_11925_length_282_cov_1.447964_g11104_i0	PRJNA492363	11925	282	1.447964	4.08325848	Phytophthora sojae	67593	SAR_Eukaryotes	SAR_Eukaryotes	58.9	9.48e-8	NR	XP_009528625.1	67593	g11104	i0	36.9	0.893617021276596	84	50	88.3	2	3	251	146	227	XP_009528625.1 hypothetical protein PHYSODRAFT_301661 [Phytophthora sojae]	diamond	252	58.9	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Peronosporales	Peronosporaceae	Phytophthora	Phytophthora sojae
33106131	33106131	PRJNA492363_S_NODE_95326_length_204_cov_0.895105_g94505_i0	PRJNA492363	95326	204	0.895105	1.8260142	Ochromonadaceae sp. CCMP2298	483371	SAR_Eukaryotes	SAR_Eukaryotes	120	2.46e-31	NR	KAJ1385752.1	483371	g94505	i0	82.4	1	68	12	100	0	1	204	221	288	KAJ1385752.1 kinase-like domain-containing protein, partial [Ochromonadaceae sp. CCMP2298]	diamond	204	120	1	Eukaryota	Sar		Synurophyceae	Ochromonadales	Ochromonadaceae		Ochromonadaceae sp. CCMP2298
33157093	33157093	PRJNA492363_S_NODE_77880_length_217_cov_1.641026_g77059_i0	PRJNA492363	77880	217	1.641026	3.56102642	Ochromonadaceae sp. CCMP2298	483371	SAR_Eukaryotes	SAR_Eukaryotes	94.4	1.38e-20	NR	KAJ1440823.1	483371	g77059	i0	76.8	0.774193548387097	56	13	77.4	0	2	169	411	466	KAJ1440823.1 rab GDP dissociation inhibitor alpha putative [Ochromonadaceae sp. CCMP2298]	diamond	168	94.4	1	Eukaryota	Sar		Synurophyceae	Ochromonadales	Ochromonadaceae		Ochromonadaceae sp. CCMP2298
33174199	33174199	PRJNA492363_S_NODE_100872_length_201_cov_1.285714_g100051_i0	PRJNA492363	100872	201	1.285714	2.58428514	Ochromonadaceae sp. CCMP2298	483371	SAR_Eukaryotes	SAR_Eukaryotes	61.6	4.61e-9	NR	KAJ1438115.1	483371	g100051	i0	89.7	0.43283582089552203	29	3	43.3	0	89	175	692	720	KAJ1438115.1 hypothetical protein B484DRAFT_428161 [Ochromonadaceae sp. CCMP2298]	diamond	87	61.6	1	Eukaryota	Sar		Synurophyceae	Ochromonadales	Ochromonadaceae		Ochromonadaceae sp. CCMP2298

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