metadata: contig_metadata: 25 rows where analysis = "blastn", bioproject = "PRJNA760904" and tax

25 rows where analysis = "blastn", bioproject = "PRJNA760904" 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
742216	742216	PRJNA760904_P_NODE_14501_length_251_cov_2.758427_g14444_i0	PRJNA760904	14501	251	2.758427	6.92365177	Phytophthora nicotianae	4792	SAR_Eukaryotes	SAR_Eukaryotes	54.7	0.006	NTclustered	gi\|675201180\|ref\|XM_008911227.1\|	761204	g14444	i0	96.875	0.685258964143426	32	1	13	0	10	41	421	452	Phytophthora parasitica INRA-310 hypothetical protein mRNA	blastn	172	54.7	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Peronosporales	Peronosporaceae	Phytophthora	Phytophthora nicotianae
742269	742269	PRJNA760904_P_NODE_5101_length_377_cov_10.717105_g5044_i0	PRJNA760904	5101	377	10.717105	40.40348585	Phytophthora sojae	67593	SAR_Eukaryotes	SAR_Eukaryotes	272	2.53e-68	NTclustered	gi\|695460853\|ref\|XM_009539792.1\|	67593	g5044	i0	83.333	70.9681697612732	294	49	78	0	42	335	16	309	Phytophthora sojae hypothetical protein mRNA	blastn	26755	272	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Peronosporales	Peronosporaceae	Phytophthora	Phytophthora sojae
2018234	2018234	PRJNA760904_P_NODE_15462_length_250_cov_0.870056_g15405_i0	PRJNA760904	15462	250	0.870056	2.17514	Aphanomyces euteiches	100861	SAR_Eukaryotes	SAR_Eukaryotes	318	2.02e-82	NTclustered	gi\|166039078\|emb\|CU357279.1\|	100861	g15405	i0	89.6	6.516	250	26	100	0	1	250	442	193	Aphanomyces euteiches cDNA	blastn	1629	318	1	Eukaryota	Sar	Oomycota	Saprolegniomycetes	Saprolegniales	Verrucalvaceae	Aphanomyces	Aphanomyces euteiches
4570629	4570629	PRJNA760904_P_NODE_4684_length_390_cov_2.182965_g4627_i0	PRJNA760904	4684	390	2.182965	8.5135635	Phytophthora cinnamomi	4785	SAR_Eukaryotes	SAR_Eukaryotes	375	1.95e-99	NTclustered	gi\|2795055209\|ref\|XM_067932227.1\|	4785	g4627	i0	84.375	98.8717948717949	384	58	98	2	2	384	524	142	Phytophthora cinnamomi succinate dehydrogenase [ubiquinone] flavoprotein subunit 1, mitochondrial (IUM83_07895), partial mRNA	blastn	38560	375	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Peronosporales	Peronosporaceae	Phytophthora	Phytophthora cinnamomi
8395478	8395478	PRJNA760904_P_NODE_10747_length_281_cov_1.480769_g10690_i0	PRJNA760904	10747	281	1.480769	4.16096089	Aphanomyces astaci	112090	SAR_Eukaryotes	SAR_Eukaryotes	340	4.939999999999999e-89	NTclustered	gi\|698793353\|ref\|XM_009831407.1\|	112090	g10690	i0	89.17	3.94306049822064	277	25	98	4	7	281	305	32	Aphanomyces astaci hypothetical protein mRNA	blastn	1108	340	1	Eukaryota	Sar	Oomycota	Saprolegniomycetes	Saprolegniales	Verrucalvaceae	Aphanomyces	Aphanomyces astaci
8395532	8395532	PRJNA760904_P_NODE_3327_length_451_cov_3.542328_g3270_i0	PRJNA760904	3327	451	3.542328	15.97589928	Aphanomyces astaci	112090	SAR_Eukaryotes	SAR_Eukaryotes	230	1.8799999999999996e-55	NTclustered	gi\|698820832\|ref\|XM_009845143.1\|	112090	g3270	i0	78.917	37.079822616408	351	64	76	5	35	377	422	74	Aphanomyces astaci 40S ribosomal protein S20 mRNA	blastn	16723	230	1	Eukaryota	Sar	Oomycota	Saprolegniomycetes	Saprolegniales	Verrucalvaceae	Aphanomyces	Aphanomyces astaci
8395542	8395542	PRJNA760904_P_NODE_4567_length_394_cov_2.239875_g4510_i0	PRJNA760904	4567	394	2.239875	8.8251075	Phytophthora sojae	67593	SAR_Eukaryotes	SAR_Eukaryotes	200	1.27e-46	NTclustered	gi\|695431986\|ref\|XM_009532530.1\|	67593	g4510	i0	82.819	22.3197969543147	227	35	57	4	170	394	1203	979	Phytophthora sojae hypothetical protein partial mRNA	blastn	8794	200	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Peronosporales	Peronosporaceae	Phytophthora	Phytophthora sojae
9670693	9670693	PRJNA760904_P_NODE_3328_length_451_cov_3.208995_g3271_i0	PRJNA760904	3328	451	3.208995	14.47256745	Saprolegnia parasitica	101203	SAR_Eukaryotes	SAR_Eukaryotes	195	6.859999999999999e-45	NTclustered	gi\|813119311\|ref\|XM_012340836.1\|	695850	g3271	i0	79.11	6.39911308203991	292	54	64	6	21	310	408	122	Saprolegnia parasitica CBS 223.65 60S ribosomal protein mRNA	blastn	2886	195	1	Eukaryota	Sar	Oomycota	Saprolegniomycetes	Saprolegniales	Saprolegniaceae	Saprolegnia	Saprolegnia parasitica
10946364	10946364	PRJNA760904_P_NODE_21389_length_217_cov_4.055556_g21332_i0	PRJNA760904	21389	217	4.055556	8.80055652	Phytophthora cinnamomi	4785	SAR_Eukaryotes	SAR_Eukaryotes	78.7	3.16e-10	NTclustered	gi\|2795032822\|ref\|XM_067928242.1\|	4785	g21332	i0	81	0.460829493087558	100	17	46	2	1	99	862	960	Phytophthora cinnamomi serine/threonine-protein phosphatase PP2A (IUM83_04186), partial mRNA	blastn	100	78.7	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Peronosporales	Peronosporaceae	Phytophthora	Phytophthora cinnamomi
13496040	13496040	PRJNA760904_P_NODE_6391_length_344_cov_1.704797_g6334_i0	PRJNA760904	6391	344	1.704797	5.86450168	Aphanomyces invadans	157072	SAR_Eukaryotes	SAR_Eukaryotes	230	1.4e-55	NTclustered	gi\|673019759\|ref\|XM_008865619.1\|	157072	g6334	i0	83.951	55.1453488372093	243	35	70	4	82	322	126	366	Aphanomyces invadans 40S ribosomal protein S23 mRNA	blastn	18970	230	1	Eukaryota	Sar	Oomycota	Saprolegniomycetes	Saprolegniales	Verrucalvaceae	Aphanomyces	Aphanomyces invadans
14771113	14771113	PRJNA760904_P_NODE_13392_length_260_cov_1.598930_g13335_i0	PRJNA760904	13392	260	1.59893	4.157218	Aphanomyces euteiches	100861	SAR_Eukaryotes	SAR_Eukaryotes	357	4.48e-94	NTclustered	gi\|166036466\|emb\|CU349508.1\|	100861	g13335	i0	91.473	19.0192307692308	258	22	99	0	1	258	469	726	Aphanomyces euteiches cDNA	blastn	4945	357	1	Eukaryota	Sar	Oomycota	Saprolegniomycetes	Saprolegniales	Verrucalvaceae	Aphanomyces	Aphanomyces euteiches
16044918	16044918	PRJNA760904_P_NODE_3233_length_457_cov_2.536458_g3176_i0	PRJNA760904	3233	457	2.536458	11.59161306	Phytophthora infestans	4787	SAR_Eukaryotes	SAR_Eukaryotes	322	3.06e-83	NTclustered	gi\|301107276\|ref\|XM_002902675.1\|	403677	g3176	i0	80.37	67.5711159737418	433	77	93	7	1	427	438	8	Phytophthora infestans T30-4 adenosylhomocysteinase (PITG_10198), partial mRNA	blastn	30880	322	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Peronosporales	Peronosporaceae	Phytophthora	Phytophthora infestans
18593905	18593905	PRJNA760904_P_NODE_13595_length_258_cov_3.243243_g13538_i0	PRJNA760904	13595	258	3.243243	8.36756694	Pseudoperonospora celtidis	291623	SAR_Eukaryotes	SAR_Eukaryotes	147	1.0500000000000001e-30	NTclustered	gi\|327206210\|gb\|JF414536.1\|	291623	g13538	i0	79.147	11.0232558139535	211	41	81	3	2	210	1168	959	Pseudoperonospora celtidis isolate SMK17780 cytochrome c oxidase subunit II (cox2) and cytochrome c oxidase subunit I (cox1) genes, partial cds; mitochondrial	blastn	2844	147	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Peronosporales	Peronosporaceae	Pseudoperonospora	Pseudoperonospora celtidis
18593935	18593935	PRJNA760904_P_NODE_20955_length_240_cov_2.389222_g20898_i0	PRJNA760904	20955	240	2.389222	5.7341328	Aphanomyces invadans	157072	SAR_Eukaryotes	SAR_Eukaryotes	322	1.49e-83	NTclustered	gi\|673025997\|ref\|XM_008868738.1\|	157072	g20898	i0	91.453	14.0125	234	20	98	0	2	235	274	507	Aphanomyces invadans 40S ribosomal protein S20 mRNA	blastn	3363	322	1	Eukaryota	Sar	Oomycota	Saprolegniomycetes	Saprolegniales	Verrucalvaceae	Aphanomyces	Aphanomyces invadans
19869097	19869097	PRJNA760904_P_NODE_12096_length_270_cov_1.563452_g12039_i0	PRJNA760904	12096	270	1.563452	4.2213204	Aphanomyces invadans	157072	SAR_Eukaryotes	SAR_Eukaryotes	337	6.1e-88	NTclustered	gi\|673038061\|ref\|XM_008874770.1\|	157072	g12039	i0	89.811	3.44074074074074	265	23	97	1	1	261	101	365	Aphanomyces invadans 60S ribosomal protein L38 mRNA	blastn	929	337	1	Eukaryota	Sar	Oomycota	Saprolegniomycetes	Saprolegniales	Verrucalvaceae	Aphanomyces	Aphanomyces invadans
19869108	19869108	PRJNA760904_P_NODE_14176_length_254_cov_1.696133_g14119_i0	PRJNA760904	14176	254	1.696133	4.30817782	Phytophthora cinnamomi	4785	SAR_Eukaryotes	SAR_Eukaryotes	141	4.78e-29	NTclustered	gi\|2795026431\|ref\|XM_067934112.1\|	4785	g14119	i0	77.255	2.91732283464567	255	48	98	8	5	254	1020	771	Phytophthora cinnamomi Acetyl-CoA acetyltransferase (IUM83_09660), partial mRNA	blastn	741	141	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Peronosporales	Peronosporaceae	Phytophthora	Phytophthora cinnamomi
20331392	20331392	PRJNA760904_P_NODE_2676_length_498_cov_1.449412_g2619_i0	PRJNA760904	2676	498	1.449412	7.21807176	Saprolegnia	4769	SAR_Eukaryotes	SAR_Eukaryotes	209	2.73e-49	NTclustered	gi\|813198223\|ref\|XM_012353305.1\|	695850	g2619	i0	79.932	57.2971887550201	294	51	58	7	209	498	662	373	Saprolegnia parasitica CBS 223.65 hypothetical protein partial mRNA	blastn	28534	209	1	Eukaryota	Sar	Oomycota	Saprolegniomycetes	Saprolegniales	Saprolegniaceae	Saprolegnia	Saprolegnia parasitica
20331410	20331410	PRJNA760904_P_NODE_816_length_826_cov_1.528552_g767_i0	PRJNA760904	816	826	1.528552	12.62583952	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	688	0	NTclustered	gi\|189085060\|gb\|BT032592.1\|	4784	g767	i0	82.104	81.8389830508475	827	126	99	13	8	826	449	1261	Phytophthora capsici clone CBOU109-N08 mRNA sequence	blastn	67599	689	0.998548621190131	Eukaryota	Sar	Oomycota	Peronosporomycetes	Peronosporales	Peronosporaceae	Phytophthora	Phytophthora capsici
21144783	21144783	PRJNA760904_P_NODE_15717_length_249_cov_1.306818_g15660_i0	PRJNA760904	15717	249	1.306818	3.25397682	Phytophthora sojae	67593	SAR_Eukaryotes	SAR_Eukaryotes	250	7.4499999999999995e-62	NTclustered	gi\|695406619\|ref\|XM_009525862.1\|	67593	g15660	i0	85.185	71.5863453815261	243	36	98	0	6	248	715	957	Phytophthora sojae hypothetical protein partial mRNA	blastn	17825	250	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Peronosporales	Peronosporaceae	Phytophthora	Phytophthora sojae
21144834	21144834	PRJNA760904_P_NODE_6097_length_351_cov_1.661871_g6040_i0	PRJNA760904	6097	351	1.661871	5.83316721	Aphanomyces astaci	112090	SAR_Eukaryotes	SAR_Eukaryotes	388	2.23e-103	NTclustered	gi\|698812671\|ref\|XM_009841063.1\|	112090	g6040	i0	89.137	3.13390313390313	313	32	89	2	40	351	643	332	Aphanomyces astaci ribosomal protein L22 mRNA	blastn	1100	388	1	Eukaryota	Sar	Oomycota	Saprolegniomycetes	Saprolegniales	Verrucalvaceae	Aphanomyces	Aphanomyces astaci
22419579	22419579	PRJNA760904_P_NODE_3418_length_446_cov_2.268097_g3361_i0	PRJNA760904	3418	446	2.268097	10.11571262	Phytophthora nicotianae	4792	SAR_Eukaryotes	SAR_Eukaryotes	442	2.189999999999999e-119	NTclustered	gi\|675187766\|ref\|XM_008904520.1\|	761204	g3361	i0	85.919	90.8834080717489	419	54	93	5	1	416	548	132	Phytophthora parasitica INRA-310 GTP-binding nuclear protein ran-1 mRNA	blastn	40534	442	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Peronosporales	Peronosporaceae	Phytophthora	Phytophthora nicotianae
23695203	23695203	PRJNA760904_P_NODE_339_length_1202_cov_3.022143_g312_i0	PRJNA760904	339	1202	3.022143	36.32615886	Phytophthora sojae	67593	SAR_Eukaryotes	SAR_Eukaryotes	682	0	NTclustered	gi\|695434305\|ref\|XM_009533098.1\|	67593	g312	i0	82.073	74.5299500831947	820	127	67	11	207	1016	1418	609	Phytophthora sojae hypothetical protein partial mRNA	blastn	89585	682	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Peronosporales	Peronosporaceae	Phytophthora	Phytophthora sojae
24156692	24156692	PRJNA760904_P_NODE_3199_length_459_cov_2.121762_g3142_i0	PRJNA760904	3199	459	2.121762	9.73888758	Saprolegnia	4769	SAR_Eukaryotes	SAR_Eukaryotes	318	3.9799999999999996e-82	NTclustered	gi\|813115972\|ref\|XM_012340060.1\|	695850	g3142	i0	80.23	64.797385620915	435	76	94	10	12	441	63	492	Saprolegnia parasitica CBS 223.65 40S ribosomal protein S23 mRNA	blastn	29742	318	1	Eukaryota	Sar	Oomycota	Saprolegniomycetes	Saprolegniales	Saprolegniaceae	Saprolegnia	Saprolegnia parasitica
24968865	24968865	PRJNA760904_P_NODE_3860_length_424_cov_1.176638_g3803_i0	PRJNA760904	3860	424	1.176638	4.98894512	Phytophthora ramorum	164328	SAR_Eukaryotes	SAR_Eukaryotes	244	6.28e-60	NTclustered	gi\|2794919585\|ref\|XM_067895150.1\|	164328	g3803	i0	77.75	14.5896226415094	400	88	94	1	19	417	3	402	Phytophthora ramorum 40S ribosomal protein S4 (KRP23_9578), partial mRNA	blastn	6186	244	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Peronosporales	Peronosporaceae	Phytophthora	Phytophthora ramorum
24968875	24968875	PRJNA760904_P_NODE_5560_length_365_cov_1.054795_g5503_i0	PRJNA760904	5560	365	1.054795	3.85000175	Aphanomyces euteiches	100861	SAR_Eukaryotes	SAR_Eukaryotes	163	1.53e-35	NTclustered	gi\|166039156\|emb\|CU355206.1\|	100861	g5503	i0	79.832	0.652054794520548	238	37	64	9	33	265	675	444	Aphanomyces euteiches cDNA	blastn	238	163	1	Eukaryota	Sar	Oomycota	Saprolegniomycetes	Saprolegniales	Verrucalvaceae	Aphanomyces	Aphanomyces euteiches

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