metadata: contig_metadata: 24 rows where analysis = "blastn", bioproject = "PRJNA781196" and tax

24 rows where analysis = "blastn", bioproject = "PRJNA781196" 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
2035255	2035255	PRJNA781196_P_NODE_34622_length_301_cov_1.368421_g34245_i0	PRJNA781196	34622	301	1.368421	4.11894721	Phytophthora nicotianae	4792	SAR_Eukaryotes	SAR_Eukaryotes	255	1.99e-63	NTclustered	gi\|675172666\|ref\|XM_008896970.1\|	761204	g34245	i0	83.824	4.95681063122924	272	40	90	4	1	270	467	198	Phytophthora parasitica INRA-310 ADP/ATP translocase 1 mRNA	blastn	1492	255	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Peronosporales	Peronosporaceae	Phytophthora	Phytophthora nicotianae
2035444	2035444	PRJNA781196_P_NODE_46562_length_262_cov_1.650794_g46185_i0	PRJNA781196	46562	262	1.650794	4.32508028	Saprolegnia parasitica	101203	SAR_Eukaryotes	SAR_Eukaryotes	300	7.73e-77	NTclustered	gi\|813177542\|ref\|XM_012349851.1\|	695850	g46185	i0	88.889	8.34732824427481	243	27	93	0	1	243	481	239	Saprolegnia parasitica CBS 223.65 30S ribosomal protein S19e mRNA	blastn	2187	300	1	Eukaryota	Sar	Oomycota	Saprolegniomycetes	Saprolegniales	Saprolegniaceae	Saprolegnia	Saprolegnia parasitica
2035521	2035521	PRJNA781196_P_NODE_51102_length_252_cov_1.743017_g50725_i0	PRJNA781196	51102	252	1.743017	4.39240284	Pythium sp. AP	378252	SAR_Eukaryotes	SAR_Eukaryotes	353	5.59e-93	NTclustered	gi\|90855438\|dbj\|AB254193.1\|	378252	g50725	i0	95.475	78.9285714285714	221	10	88	0	2	222	221	1	Pythium sp. AP genes for 28S rRNA, IGS, 5S rRNA, partial and complete sequence, strain: AP-1, AP-2 and AP-3	blastn	19890	353	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Pythiales	Pythiaceae	Pythium	Pythium sp. AP
2486889	2486889	PRJNA781196_P_NODE_9982_length_506_cov_1.080831_g9606_i0	PRJNA781196	9982	506	1.080831	5.46900486	Phytophthora	4783	SAR_Eukaryotes	SAR_Eukaryotes	597	5.069999999999999e-166	NTclustered	gi\|2795048588\|ref\|XM_067932045.1\|	4785	g9606	i0	88.016	70.9387351778656	509	55	100	5	1	506	677	172	Phytophthora cinnamomi 40S ribosomal protein S6 (IUM83_07725), partial mRNA	blastn	35895	597	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Peronosporales	Peronosporaceae	Phytophthora	Phytophthora cinnamomi
3310357	3310357	PRJNA781196_P_NODE_27283_length_333_cov_1.165385_g26906_i0	PRJNA781196	27283	333	1.165385	3.88073205	Saprolegnia diclina	112098	SAR_Eukaryotes	SAR_Eukaryotes	411	4.489999999999999e-110	NTclustered	gi\|669145711\|ref\|XM_008610196.1\|	1156394	g26906	i0	88.791	96.9069069069069	339	32	100	2	1	333	139	477	Saprolegnia diclina VS20 ubiquitin-40S ribosomal protein S27a mRNA	blastn	32270	411	1	Eukaryota	Sar	Oomycota	Saprolegniomycetes	Saprolegniales	Saprolegniaceae	Saprolegnia	Saprolegnia diclina
5039580	5039580	PRJNA781196_P_NODE_36444_length_294_cov_2.117647_g36067_i0	PRJNA781196	36444	294	2.117647	6.22588218	Saprolegnia	4769	SAR_Eukaryotes	SAR_Eukaryotes	154	7.27e-33	NTclustered	gi\|813126177\|ref\|XM_012341554.1\|	695850	g36067	i0	83.051	2.31632653061224	177	22	59	8	11	183	159	331	Saprolegnia parasitica CBS 223.65 hypothetical protein mRNA	blastn	681	154	1	Eukaryota	Sar	Oomycota	Saprolegniomycetes	Saprolegniales	Saprolegniaceae	Saprolegnia	Saprolegnia parasitica
6315159	6315159	PRJNA781196_P_NODE_17405_length_400_cov_1.483180_g17028_i0	PRJNA781196	17405	400	1.48318	5.93272	Phytophthora	4783	SAR_Eukaryotes	SAR_Eukaryotes	435	3.2600000000000004e-117	NTclustered	gi\|2795047467\|ref\|XM_067937988.1\|	4785	g17028	i0	86.318	99.4525	402	51	100	4	1	400	88	487	Phytophthora cinnamomi UPF0468 protein (IUM83_13323), partial mRNA	blastn	39781	435	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Peronosporales	Peronosporaceae	Phytophthora	Phytophthora cinnamomi
7137919	7137919	PRJNA781196_P_NODE_37306_length_291_cov_1.903670_g36929_i0	PRJNA781196	37306	291	1.90367	5.5396797	Saprolegnia diclina	112098	SAR_Eukaryotes	SAR_Eukaryotes	246	1.1499999999999999e-60	NTclustered	gi\|669146817\|ref\|XM_008610749.1\|	1156394	g36929	i0	83.582	5.78694158075601	268	39	91	5	26	291	45	309	Saprolegnia diclina VS20 40S ribosomal protein S8 mRNA	blastn	1684	246	1	Eukaryota	Sar	Oomycota	Saprolegniomycetes	Saprolegniales	Saprolegniaceae	Saprolegnia	Saprolegnia diclina
7589323	7589323	PRJNA781196_P_NODE_47866_length_258_cov_1.686486_g47489_i0	PRJNA781196	47866	258	1.686486	4.35113388	Phytophthora	4783	SAR_Eukaryotes	SAR_Eukaryotes	363	9.55e-96	NTclustered	gi\|38489929\|gb\|AY456093.1\|	4792	g47489	i0	92.188	96.9147286821705	256	20	99	0	3	258	826	1081	Phytophthora nicotianae heat shock protein 70 (Hsp70a) gene, complete cds	blastn	25004	363	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Peronosporales	Peronosporaceae	Phytophthora	Phytophthora nicotianae
8412279	8412279	PRJNA781196_P_NODE_28907_length_325_cov_1.238095_g28530_i0	PRJNA781196	28907	325	1.238095	4.02380875	Phytophthora sojae	67593	SAR_Eukaryotes	SAR_Eukaryotes	339	2.09e-88	NTclustered	gi\|695381842\|ref\|XM_009518920.1\|	67593	g28530	i0	85.849	43.5876923076923	318	45	98	0	8	325	1	318	Phytophthora sojae hypothetical protein partial mRNA	blastn	14166	339	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Peronosporales	Peronosporaceae	Phytophthora	Phytophthora sojae
9688177	9688177	PRJNA781196_P_NODE_63528_length_244_cov_0.912281_g63151_i0	PRJNA781196	63528	244	0.912281	2.22596564	Phytophthora sojae	67593	SAR_Eukaryotes	SAR_Eukaryotes	340	4.189999999999999e-89	NTclustered	gi\|695429123\|ref\|XM_009531818.1\|	67593	g63151	i0	91.803	146.754098360656	244	20	100	0	1	244	1160	917	Phytophthora sojae mitochondrial translation elongation factor Tu mRNA	blastn	35808	340	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Peronosporales	Peronosporaceae	Phytophthora	Phytophthora sojae
13512998	13512998	PRJNA781196_P_NODE_31411_length_314_cov_0.983402_g31034_i0	PRJNA781196	31411	314	0.983402	3.08788228	Phytophthora sojae	67593	SAR_Eukaryotes	SAR_Eukaryotes	202	2.7599999999999996e-47	NTclustered	gi\|695446583\|ref\|XM_009536226.1\|	67593	g31034	i0	81.423	3.17834394904459	253	41	80	6	65	314	61	310	Phytophthora sojae hypothetical protein partial mRNA	blastn	998	202	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Peronosporales	Peronosporaceae	Phytophthora	Phytophthora sojae
13513527	13513527	PRJNA781196_P_NODE_62691_length_245_cov_0.906977_g62314_i0	PRJNA781196	62691	245	0.906977	2.22209365	Phytophthora nicotianae	4792	SAR_Eukaryotes	SAR_Eukaryotes	52.8	0.022	NTclustered	gi\|675176454\|ref\|XM_008898864.1\|	761204	g62314	i0	100	0.228571428571429	28	0	11	0	113	140	3016	3043	Phytophthora parasitica INRA-310 hypothetical protein mRNA	blastn	56	52.8	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Peronosporales	Peronosporaceae	Phytophthora	Phytophthora nicotianae
13965307	13965307	PRJNA781196_P_NODE_61991_length_245_cov_0.906977_g61614_i0	PRJNA781196	61991	245	0.906977	2.22209365	Pythiaceae	4782	SAR_Eukaryotes	SAR_Eukaryotes	453	5.1900000000000006e-123	NTclustered	gi\|944326305\|gb\|KP842869.1\|	114742	g61614	i0	100	98.869387755102	245	0	100	0	1	245	498	254	Pythium insidiosum strain Eq-22 28S ribosomal RNA gene, partial sequence	blastn	24223	453	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Pythiales	Pythiaceae	Pythium	Pythium insidiosum
14788032	14788032	PRJNA781196_P_NODE_48932_length_255_cov_1.686813_g48555_i0	PRJNA781196	48932	255	1.686813	4.30137315	Phytophthora cinnamomi	4785	SAR_Eukaryotes	SAR_Eukaryotes	276	1.26e-69	NTclustered	gi\|2795023784\|ref\|XM_067929914.1\|	4785	g48555	i0	88.261	86.1529411764706	230	27	90	0	2	231	1466	1237	Phytophthora cinnamomi hsp70-like protein (IUM83_05758), partial mRNA	blastn	21969	276	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Peronosporales	Peronosporaceae	Phytophthora	Phytophthora cinnamomi
17337894	17337894	PRJNA781196_P_NODE_62534_length_245_cov_0.906977_g62157_i0	PRJNA781196	62534	245	0.906977	2.22209365	Aphanomyces invadans	157072	SAR_Eukaryotes	SAR_Eukaryotes	243	1.22e-59	NTclustered	gi\|673047296\|ref\|XM_008879387.1\|	157072	g62157	i0	84.49	3.13061224489796	245	38	100	0	1	245	295	51	Aphanomyces invadans 60S ribosomal protein mRNA	blastn	767	243	1	Eukaryota	Sar	Oomycota	Saprolegniomycetes	Saprolegniales	Verrucalvaceae	Aphanomyces	Aphanomyces invadans
18610605	18610605	PRJNA781196_P_NODE_17495_length_399_cov_1.435583_g17118_i0	PRJNA781196	17495	399	1.435583	5.72797617	Saprolegnia diclina	112098	SAR_Eukaryotes	SAR_Eukaryotes	303	9.56e-78	NTclustered	gi\|669140539\|ref\|XM_008607616.1\|	1156394	g17118	i0	81.768	2.03007518796993	362	66	91	0	1	362	420	59	Saprolegnia diclina VS20 50S ribosomal protein L14e mRNA	blastn	810	303	1	Eukaryota	Sar	Oomycota	Saprolegniomycetes	Saprolegniales	Saprolegniaceae	Saprolegnia	Saprolegnia diclina
18610706	18610706	PRJNA781196_P_NODE_24175_length_349_cov_1.536232_g23798_i0	PRJNA781196	24175	349	1.536232	5.36144968	Saprolegnia diclina	112098	SAR_Eukaryotes	SAR_Eukaryotes	235	3.05e-57	NTclustered	gi\|669150047\|ref\|XM_008612364.1\|	1156394	g23798	i0	79.143	95.3868194842407	350	65	99	8	3	348	770	425	Saprolegnia diclina VS20 hypothetical protein partial mRNA	blastn	33290	235	1	Eukaryota	Sar	Oomycota	Saprolegniomycetes	Saprolegniales	Saprolegniaceae	Saprolegnia	Saprolegnia diclina
19885986	19885986	PRJNA781196_P_NODE_27256_length_333_cov_1.200000_g26879_i0	PRJNA781196	27256	333	1.2	3.996	Phytophthora ramorum	164328	SAR_Eukaryotes	SAR_Eukaryotes	276	1.71e-69	NTclustered	gi\|2794910602\|ref\|XM_067891142.1\|	164328	g26879	i0	85.556	6.56156156156156	270	32	80	6	66	333	50	314	Phytophthora ramorum 60S ribosomal protein L7a-2 (KRP23_6008), partial mRNA	blastn	2185	276	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Peronosporales	Peronosporaceae	Phytophthora	Phytophthora ramorum
21161807	21161807	PRJNA781196_P_NODE_31277_length_314_cov_1.618257_g30900_i0	PRJNA781196	31277	314	1.618257	5.08132698	Achlya klebsiana	4767	SAR_Eukaryotes	SAR_Eukaryotes	231	3.52e-56	NTclustered	gi\|166301\|gb\|J05597.1\|ACKBTUB	4767	g30900	i0	80.255	85.6528662420382	314	56	99	6	3	313	962	652	A.klebsiana beta-tubulin gene, complete cds	blastn	26895	231	1	Eukaryota	Sar	Oomycota	Saprolegniomycetes	Saprolegniales	Achlyaceae	Achlya	Achlya klebsiana
21162101	21162101	PRJNA781196_P_NODE_51617_length_252_cov_0.871508_g51240_i0	PRJNA781196	51617	252	0.871508	2.19620016	Phytophthora infestans	4787	SAR_Eukaryotes	SAR_Eukaryotes	200	7.709999999999998e-47	NTclustered	gi\|301108026\|ref\|XM_002903049.1\|	403677	g51240	i0	84.848	6.90079365079365	198	30	79	0	50	247	294	97	Phytophthora infestans T30-4 40S ribosomal protein S21 (PITG_09442), mRNA	blastn	1739	200	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Peronosporales	Peronosporaceae	Phytophthora	Phytophthora infestans
22436576	22436576	PRJNA781196_P_NODE_34978_length_300_cov_1.030837_g34601_i0	PRJNA781196	34978	300	1.030837	3.092511	Phytophthora sojae	67593	SAR_Eukaryotes	SAR_Eukaryotes	309	1.5e-79	NTclustered	gi\|695375632\|ref\|XM_009517294.1\|	67593	g34601	i0	85.714	6.40333333333333	294	40	98	2	6	298	604	312	Phytophthora sojae hypothetical protein partial mRNA	blastn	1921	309	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Peronosporales	Peronosporaceae	Phytophthora	Phytophthora sojae
24985610	24985610	PRJNA781196_P_NODE_27040_length_334_cov_1.195402_g26663_i0	PRJNA781196	27040	334	1.195402	3.99264268	Saprolegnia diclina	112098	SAR_Eukaryotes	SAR_Eukaryotes	60.2	1.88e-4	NTclustered	gi\|669145043\|ref\|XM_008609862.1\|	1156394	g26663	i0	94.737	4.07784431137725	38	2	11	0	107	144	3567	3604	Saprolegnia diclina VS20 hypothetical protein partial mRNA	blastn	1362	60.2	1	Eukaryota	Sar	Oomycota	Saprolegniomycetes	Saprolegniales	Saprolegniaceae	Saprolegnia	Saprolegnia diclina
24985727	24985727	PRJNA781196_P_NODE_34240_length_302_cov_3.668122_g33863_i0	PRJNA781196	34240	302	3.668122	11.07772844	Phytophthora ramorum	164328	SAR_Eukaryotes	SAR_Eukaryotes	252	2.58e-62	NTclustered	gi\|2794921736\|ref\|XM_067881102.1\|	164328	g33863	i0	82.353	6.75496688741722	289	51	96	0	14	302	828	540	Phytophthora ramorum Succinate--CoA ligase [ADP-forming] subunit alpha (KRP23_10630), partial mRNA	blastn	2040	252	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Peronosporales	Peronosporaceae	Phytophthora	Phytophthora ramorum

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