metadata: contig_metadata: 14 rows where analysis = "blastn", bioproject = "PRJNA683669" and tax

14 rows where analysis = "blastn", bioproject = "PRJNA683669" 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
1941043	1941043	PRJNA683669_P_NODE_4522_length_612_cov_3.597403_g4298_i0	PRJNA683669	4522	612	3.597403	22.01610636	Phytophthora sojae	67593	SAR_Eukaryotes	SAR_Eukaryotes	313	2.52e-80	NTclustered	gi\|695447497\|ref\|XM_009536456.1\|	67593	g4298	i0	79.819	53.7483660130719	441	79	72	9	149	587	2084	1652	Phytophthora sojae hypothetical protein mRNA	blastn	32894	313	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Peronosporales	Peronosporaceae	Phytophthora	Phytophthora sojae
3215687	3215687	PRJNA683669_P_NODE_11023_length_388_cov_3.996825_g10792_i0	PRJNA683669	11023	388	3.996825	15.507681	Phytophthora nicotianae	4792	SAR_Eukaryotes	SAR_Eukaryotes	207	7.47e-49	NTclustered	gi\|675188146\|ref\|XM_008904710.1\|	761204	g10792	i0	82.833	48.5128865979381	233	38	60	2	59	290	364	133	Phytophthora parasitica INRA-310 40S ribosomal protein S27-like mRNA	blastn	18823	207	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Peronosporales	Peronosporaceae	Phytophthora	Phytophthora nicotianae
3215705	3215705	PRJNA683669_P_NODE_13143_length_357_cov_1.355634_g12912_i0	PRJNA683669	13143	357	1.355634	4.83961338	Saprolegnia parasitica	101203	SAR_Eukaryotes	SAR_Eukaryotes	52.8	0.034	NTclustered	gi\|813226630\|ref\|XM_012357002.1\|	695850	g12912	i0	100	0.0784313725490196	28	0	8	0	197	224	541	514	Saprolegnia parasitica CBS 223.65 hypothetical protein partial mRNA	blastn	28	52.8	1	Eukaryota	Sar	Oomycota	Saprolegniomycetes	Saprolegniales	Saprolegniaceae	Saprolegnia	Saprolegnia parasitica
3215963	3215963	PRJNA683669_P_NODE_8143_length_448_cov_1.434667_g7912_i0	PRJNA683669	8143	448	1.434667	6.42730816	Phytophthora sojae	67593	SAR_Eukaryotes	SAR_Eukaryotes	207	8.75e-49	NTclustered	gi\|695460914\|ref\|XM_009539807.1\|	67593	g7912	i0	90.909	34.4754464285714	154	14	34	0	3	156	201	354	Phytophthora sojae hypothetical protein mRNA	blastn	15445	207	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Peronosporales	Peronosporaceae	Phytophthora	Phytophthora sojae
3215964	3215964	PRJNA683669_P_NODE_8403_length_441_cov_1.160326_g8172_i0	PRJNA683669	8403	441	1.160326	5.11703766	Saprolegnia parasitica	101203	SAR_Eukaryotes	SAR_Eukaryotes	52.8	0.043	NTclustered	gi\|813126221\|ref\|XM_012341568.1\|	695850	g8172	i0	100	0.0634920634920635	28	0	6	0	8	35	3836	3809	Saprolegnia parasitica CBS 223.65 hypothetical protein partial mRNA	blastn	28	52.8	1	Eukaryota	Sar	Oomycota	Saprolegniomycetes	Saprolegniales	Saprolegniaceae	Saprolegnia	Saprolegnia parasitica
3726694	3726694	PRJNA683669_P_NODE_25303_length_255_cov_1.324176_g25071_i0	PRJNA683669	25303	255	1.324176	3.3766488	Phytophthora	4783	SAR_Eukaryotes	SAR_Eukaryotes	121	6.259999999999999e-23	NTclustered	gi\|156986803\|gb\|EU079734.1\|	129351	g25071	i0	87.5	36.7647058823529	104	13	41	0	144	247	43	146	Phytophthora heveae isolate PD_00117(P1102) heat shock protein 90 (HSP90) gene, partial cds	blastn	9375	121	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Peronosporales	Peronosporaceae	Phytophthora	Phytophthora heveae
8318202	8318202	PRJNA683669_P_NODE_34227_length_241_cov_0.863095_g33995_i0	PRJNA683669	34227	241	0.863095	2.08005895	Phytophthora nicotianae	4792	SAR_Eukaryotes	SAR_Eukaryotes	163	9.61e-36	NTclustered	gi\|675207376\|ref\|XM_008914325.1\|	761204	g33995	i0	80.751	28.1286307053942	213	37	87	2	10	218	382	594	Phytophthora parasitica INRA-310 hypothetical protein, variant mRNA	blastn	6779	163	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Peronosporales	Peronosporaceae	Phytophthora	Phytophthora nicotianae
9593568	9593568	PRJNA683669_P_NODE_21028_length_282_cov_1.416268_g20796_i0	PRJNA683669	21028	282	1.416268	3.99387576	Phytophthora infestans	4787	SAR_Eukaryotes	SAR_Eukaryotes	211	4.06e-50	NTclustered	gi\|301104768\|ref\|XM_002901423.1\|	403677	g20796	i0	81.273	85.9964539007092	267	45	94	5	1	265	3654	3391	Phytophthora infestans T30-4 ferredoxin-dependent glutamate synthase, putative (PITG_12037), partial mRNA	blastn	24251	211	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Peronosporales	Peronosporaceae	Phytophthora	Phytophthora infestans
12144431	12144431	PRJNA683669_P_NODE_34430_length_226_cov_2.013072_g34198_i0	PRJNA683669	34430	226	2.013072	4.54954272	Phytophthora cinnamomi	4785	SAR_Eukaryotes	SAR_Eukaryotes	169	1.91e-37	NTclustered	gi\|2795026083\|ref\|XM_067925526.1\|	4785	g34198	i0	80.263	8.78318584070797	228	41	100	4	1	226	888	663	Phytophthora cinnamomi alanine-tRNA ligase (IUM83_01657), partial mRNA	blastn	1985	169	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Peronosporales	Peronosporaceae	Phytophthora	Phytophthora cinnamomi
14693843	14693843	PRJNA683669_P_NODE_11972_length_373_cov_1.800000_g11741_i0	PRJNA683669	11972	373	1.8	6.714	Saprolegnia parasitica	101203	SAR_Eukaryotes	SAR_Eukaryotes	211	5.53e-50	NTclustered	gi\|813198778\|ref\|XM_012353582.1\|	695850	g11741	i0	84.091	7.44504021447721	220	33	59	2	79	297	336	118	Saprolegnia parasitica CBS 223.65 autophagy-like protein 8 mRNA	blastn	2777	211	1	Eukaryota	Sar	Oomycota	Saprolegniomycetes	Saprolegniales	Saprolegniaceae	Saprolegnia	Saprolegnia parasitica
15203461	15203461	PRJNA683669_P_NODE_10872_length_391_cov_0.968553_g10641_i0	PRJNA683669	10872	391	0.968553	3.78704223	Saprolegnia	4769	SAR_Eukaryotes	SAR_Eukaryotes	261	5.71e-65	NTclustered	gi\|813186130\|ref\|XM_012351847.1\|	695850	g10641	i0	79.945	9.69309462915601	364	66	92	7	6	365	382	22	Saprolegnia parasitica CBS 223.65 RuvB-like 2 partial mRNA	blastn	3790	261	1	Eukaryota	Sar	Oomycota	Saprolegniomycetes	Saprolegniales	Saprolegniaceae	Saprolegnia	Saprolegnia parasitica
15967823	15967823	PRJNA683669_P_NODE_9253_length_420_cov_2.187320_g9022_i0	PRJNA683669	9253	420	2.18732	9.186744	Saprolegnia diclina	112098	SAR_Eukaryotes	SAR_Eukaryotes	254	1.03e-62	NTclustered	gi\|669137463\|ref\|XM_008606078.1\|	1156394	g9022	i0	82.095	50.7761904761905	296	53	70	0	125	420	25	320	Saprolegnia diclina VS20 heat shock protein 90-2 partial mRNA	blastn	21326	254	1	Eukaryota	Sar	Oomycota	Saprolegniomycetes	Saprolegniales	Saprolegniaceae	Saprolegnia	Saprolegnia diclina
21067532	21067532	PRJNA683669_P_NODE_5837_length_533_cov_1.167391_g5608_i0	PRJNA683669	5837	533	1.167391	6.22219403	Phytophthora nicotianae	4792	SAR_Eukaryotes	SAR_Eukaryotes	496	2.01e-135	NTclustered	gi\|675213684\|ref\|XM_008917479.1\|	761204	g5608	i0	86.404	14.2926829268293	456	58	85	4	1	454	772	319	Phytophthora parasitica INRA-310 hypothetical protein partial mRNA	blastn	7618	496	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Peronosporales	Peronosporaceae	Phytophthora	Phytophthora nicotianae
24891012	24891012	PRJNA683669_P_NODE_11020_length_388_cov_6.155556_g10789_i0	PRJNA683669	11020	388	6.155556	23.88355728	Phytophthora sojae	67593	SAR_Eukaryotes	SAR_Eukaryotes	183	1.26e-41	NTclustered	gi\|695370545\|ref\|XM_009516042.1\|	67593	g10789	i0	78.571	68.0128865979381	294	51	74	12	73	360	58	345	Phytophthora sojae hypothetical protein mRNA	blastn	26389	183	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);;