metadata: contig_metadata: 16 rows where analysis = "blastn", bioproject = "PRJEB36940" and tax

16 rows where analysis = "blastn", bioproject = "PRJEB36940" and tax_phylum = "Oomycota"

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
56759	56759	PRJEB36940_P_NODE_13481_length_249_cov_0.880682_g13352_i0	PRJEB36940	13481	249	0.880682	2.19289818	Phytophthora ramorum	164328	SAR_Eukaryotes	SAR_Eukaryotes	121	6.09e-23	NTclustered	gi\|2794925534\|ref\|XM_067883139.1\|	164328	g13352	i0	86.364	1.82730923694779	110	15	44	0	116	225	145	254	Phytophthora ramorum Eukaryotic translation initiation factor 2 subunit alpha (KRP23_12511), partial mRNA	blastn	455	121	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Peronosporales	Peronosporaceae	Phytophthora	Phytophthora ramorum
2606657	2606657	PRJEB36940_P_NODE_12583_length_251_cov_2.500000_g12454_i0	PRJEB36940	12583	251	2.5	6.275	Phytophthora nicotianae	4792	SAR_Eukaryotes	SAR_Eukaryotes	122	1.7099999999999998e-23	NTclustered	gi\|675206244\|ref\|XM_008913759.1\|	761204	g12454	i0	78.238	1.63745019920319	193	40	76	2	51	242	115	306	Phytophthora parasitica INRA-310 60S ribosomal protein L11 mRNA	blastn	411	122	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Peronosporales	Peronosporaceae	Phytophthora	Phytophthora nicotianae
5159072	5159072	PRJEB36940_P_NODE_14985_length_244_cov_1.824561_g14856_i0	PRJEB36940	14985	244	1.824561	4.45192884	Pythium monospermum	92964	SAR_Eukaryotes	SAR_Eukaryotes	435	1.87e-117	NTclustered	gi\|33520250\|gb\|AY273995.1\|	92964	g14856	i0	98.77	101.532786885246	244	3	100	0	1	244	465	708	Pythium monospermum large subunit ribosomal RNA gene, partial sequence	blastn	24774	435	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Pythiales	Pythiaceae	Pythium	Pythium monospermum
5159079	5159079	PRJEB36940_P_NODE_1565_length_668_cov_5.191597_g1445_i0	PRJEB36940	1565	668	5.191597	34.67986796	Aphanomyces invadans	157072	SAR_Eukaryotes	SAR_Eukaryotes	244	1.02e-59	NTclustered	gi\|673039884\|ref\|XM_008875681.1\|	157072	g1445	i0	77.305	12.9131736526946	423	90	63	6	41	460	31	450	Aphanomyces invadans 60S ribosomal protein mRNA	blastn	8626	244	1	Eukaryota	Sar	Oomycota	Saprolegniomycetes	Saprolegniales	Verrucalvaceae	Aphanomyces	Aphanomyces invadans
7709151	7709151	PRJEB36940_P_NODE_2947_length_494_cov_1.446556_g2820_i0	PRJEB36940	2947	494	1.446556	7.14598664	Aphanomyces astaci	112090	SAR_Eukaryotes	SAR_Eukaryotes	231	5.77e-56	NTclustered	gi\|698791735\|ref\|XM_009830598.1\|	112090	g2820	i0	77.349	18.419028340081	415	79	82	12	58	463	81	489	Aphanomyces astaci malate dehydrogenase, NAD-dependent mRNA	blastn	9099	231	1	Eukaryota	Sar	Oomycota	Saprolegniomycetes	Saprolegniales	Verrucalvaceae	Aphanomyces	Aphanomyces astaci
10259458	10259458	PRJEB36940_P_NODE_11489_length_260_cov_1.668449_g11360_i0	PRJEB36940	11489	260	1.668449	4.3379674	Phytophthora sojae	67593	SAR_Eukaryotes	SAR_Eukaryotes	141	4.9199999999999993e-29	NTclustered	gi\|695403666\|ref\|XM_009525044.1\|	67593	g11360	i0	80.435	61.0615384615385	184	36	71	0	11	194	222	39	Phytophthora sojae hypothetical protein mRNA	blastn	15876	141	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Peronosporales	Peronosporaceae	Phytophthora	Phytophthora sojae
10259503	10259503	PRJEB36940_P_NODE_1869_length_616_cov_1.858195_g1749_i0	PRJEB36940	1869	616	1.858195	11.4464812	Saprolegnia parasitica	101203	SAR_Eukaryotes	SAR_Eukaryotes	302	5.490000000000001e-77	NTclustered	gi\|813119301\|ref\|XM_012340833.1\|	695850	g1749	i0	79.905	51.9350649350649	423	75	68	10	191	608	562	979	Saprolegnia parasitica CBS 223.65 hypothetical protein partial mRNA	blastn	31992	302	1	Eukaryota	Sar	Oomycota	Saprolegniomycetes	Saprolegniales	Saprolegniaceae	Saprolegnia	Saprolegnia parasitica
11534968	11534968	PRJEB36940_P_NODE_3070_length_485_cov_1.446602_g2943_i0	PRJEB36940	3070	485	1.446602	7.0160197	Aphanomyces invadans	157072	SAR_Eukaryotes	SAR_Eukaryotes	270	1.1999999999999998e-67	NTclustered	gi\|673019759\|ref\|XM_008865619.1\|	157072	g2943	i0	80.925	30.6515463917526	346	62	71	4	103	446	127	470	Aphanomyces invadans 40S ribosomal protein S23 mRNA	blastn	14866	270	1	Eukaryota	Sar	Oomycota	Saprolegniomycetes	Saprolegniales	Verrucalvaceae	Aphanomyces	Aphanomyces invadans
13742442	13742442	PRJEB36940_P_NODE_11131_length_264_cov_1.471204_g11002_i0	PRJEB36940	11131	264	1.471204	3.88397856	Phytophthora	4783	SAR_Eukaryotes	SAR_Eukaryotes	180	1.06e-40	NTclustered	gi\|2795026849\|ref\|XM_067926286.1\|	4785	g11002	i0	84.043	23.9507575757576	188	29	71	1	77	264	33	219	Phytophthora cinnamomi succinyl-CoA ligase [GDP-forming] subunit alpha, mitochondrial (IUM83_02375), partial mRNA	blastn	6323	180	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Peronosporales	Peronosporaceae	Phytophthora	Phytophthora cinnamomi
15358966	15358966	PRJEB36940_P_NODE_5833_length_355_cov_1.936170_g5704_i0	PRJEB36940	5833	355	1.93617	6.8734035	Phytophthora ramorum	164328	SAR_Eukaryotes	SAR_Eukaryotes	254	8.58e-63	NTclustered	gi\|2794905809\|ref\|XM_067889902.1\|	164328	g5704	i0	82.474	68.6084507042253	291	49	82	2	54	343	23	312	Phytophthora ramorum 13 kDa ribonucleoprotein-associated protein (KRP23_4892), partial mRNA	blastn	24356	254	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Peronosporales	Peronosporaceae	Phytophthora	Phytophthora ramorum
16633588	16633588	PRJEB36940_P_NODE_1494_length_683_cov_3.898361_g1374_i0	PRJEB36940	1494	683	3.898361	26.62580563	Saprolegnia parasitica	101203	SAR_Eukaryotes	SAR_Eukaryotes	368	5.96e-97	NTclustered	gi\|813142527\|ref\|XM_012343931.1\|	695850	g1374	i0	77.19	70.4626647144949	662	131	96	17	10	664	721	73	Saprolegnia parasitica CBS 223.65 60S ribosomal protein L3 mRNA	blastn	48126	368	1	Eukaryota	Sar	Oomycota	Saprolegniomycetes	Saprolegniales	Saprolegniaceae	Saprolegnia	Saprolegnia parasitica
16633721	16633721	PRJEB36940_P_NODE_9034_length_289_cov_1.439815_g8905_i0	PRJEB36940	9034	289	1.439815	4.16106535	Aphanomyces astaci	112090	SAR_Eukaryotes	SAR_Eukaryotes	195	4.2e-45	NTclustered	gi\|698801103\|ref\|XM_009835279.1\|	112090	g8905	i0	86.441	62.3356401384083	177	24	61	0	110	286	624	800	Aphanomyces astaci adenosylhomocysteinase 2 mRNA	blastn	18015	195	1	Eukaryota	Sar	Oomycota	Saprolegniomycetes	Saprolegniales	Verrucalvaceae	Aphanomyces	Aphanomyces astaci
19182202	19182202	PRJEB36940_P_NODE_13236_length_249_cov_2.363636_g13107_i0	PRJEB36940	13236	249	2.363636	5.88545364	Albugo laibachii	653948	SAR_Eukaryotes	SAR_Eukaryotes	416	6.939999999999999e-112	NTclustered	gi\|325194231\|emb\|FR825088.1\|	890382	g13107	i0	96.787	1.92771084337349	249	8	100	0	1	249	1133	1381	Albugo laibachii Nc14, genomic contig CONTIG_1612_NC14_v4_1853_85	blastn	480	416	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Albuginales	Albuginaceae	Albugo	Albugo laibachii
20457516	20457516	PRJEB36940_P_NODE_11217_length_263_cov_1.610526_g11088_i0	PRJEB36940	11217	263	1.610526	4.23568338	Phytophthora cinnamomi	4785	SAR_Eukaryotes	SAR_Eukaryotes	122	1.8e-23	NTclustered	gi\|2795047393\|ref\|XM_067937896.1\|	4785	g11088	i0	87.156	1.13688212927757	109	12	41	2	52	159	10	117	Phytophthora cinnamomi Nucleoside diphosphate kinase B (IUM83_13233), partial mRNA	blastn	299	122	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Peronosporales	Peronosporaceae	Phytophthora	Phytophthora cinnamomi
20457561	20457561	PRJEB36940_P_NODE_16097_length_240_cov_2.802395_g15968_i0	PRJEB36940	16097	240	2.802395	6.725748	Phytophthora sojae	67593	SAR_Eukaryotes	SAR_Eukaryotes	169	2.05e-37	NTclustered	gi\|695420111\|ref\|XM_009529545.1\|	67593	g15968	i0	82.979	10.2125	188	30	78	2	6	192	199	13	Phytophthora sojae hypothetical protein mRNA	blastn	2451	169	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Peronosporales	Peronosporaceae	Phytophthora	Phytophthora sojae
24282612	24282612	PRJEB36940_P_NODE_4760_length_391_cov_1.421384_g4631_i0	PRJEB36940	4760	391	1.421384	5.55761144	Phytophthora sojae	67593	SAR_Eukaryotes	SAR_Eukaryotes	250	1.23e-61	NTclustered	gi\|695388802\|ref\|XM_009520976.1\|	67593	g4631	i0	82.686	59.5473145780051	283	47	72	2	95	376	419	700	Phytophthora sojae hypothetical protein partial mRNA	blastn	23283	250	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Peronosporales	Peronosporaceae	Phytophthora	Phytophthora sojae

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