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

24 rows where analysis = "blastn", bioproject = "PRJNA867519" 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
848094	848094	PRJNA867519_P_NODE_23861_length_258_cov_1.664865_g23707_i0	PRJNA867519	23861	258	1.664865	4.2953517	Saprolegnia parasitica	101203	SAR_Eukaryotes	SAR_Eukaryotes	224	4.7e-54	NTclustered	gi\|813183247\|ref\|XM_012350822.1\|	695850	g23707	i0	85.514	44.7558139534884	214	31	83	0	45	258	71	284	Saprolegnia parasitica CBS 223.65 Ras-like GTP-binding protein YPT1 mRNA	blastn	11547	224	1	Eukaryota	Sar	Oomycota	Saprolegniomycetes	Saprolegniales	Saprolegniaceae	Saprolegnia	Saprolegnia parasitica
3398791	3398791	PRJNA867519_P_NODE_15843_length_297_cov_1.339286_g15689_i0	PRJNA867519	15843	297	1.339286	3.97767942	Saprolegnia diclina	112098	SAR_Eukaryotes	SAR_Eukaryotes	204	7.199999999999999e-48	NTclustered	gi\|669150451\|ref\|XM_008612566.1\|	1156394	g15689	i0	80.216	5.21885521885522	278	49	93	6	23	297	495	221	Saprolegnia diclina VS20 40S ribosomal protein S11 mRNA	blastn	1550	204	1	Eukaryota	Sar	Oomycota	Saprolegniomycetes	Saprolegniales	Saprolegniaceae	Saprolegnia	Saprolegnia diclina
3398897	3398897	PRJNA867519_P_NODE_28463_length_247_cov_1.770115_g28309_i0	PRJNA867519	28463	247	1.770115	4.37218405	Phytophthora capsici	4784	SAR_Eukaryotes	SAR_Eukaryotes	183	7.59e-42	NTclustered	gi\|189084813\|gb\|BT032344.1\|	4784	g28309	i0	80.851	38.5465587044534	235	43	95	2	2	235	1221	1454	Phytophthora capsici clone CBOT181-F14 mRNA sequence	blastn	9521	183	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Peronosporales	Peronosporaceae	Phytophthora	Phytophthora capsici
5951336	5951336	PRJNA867519_P_NODE_14465_length_309_cov_1.347458_g14311_i0	PRJNA867519	14465	309	1.347458	4.16364522	Aphanomyces invadans	157072	SAR_Eukaryotes	SAR_Eukaryotes	128	4.66e-25	NTclustered	gi\|673039884\|ref\|XM_008875681.1\|	157072	g14311	i0	84.328	1.2621359223301	134	17	43	3	166	298	459	329	Aphanomyces invadans 60S ribosomal protein mRNA	blastn	390	128	1	Eukaryota	Sar	Oomycota	Saprolegniomycetes	Saprolegniales	Verrucalvaceae	Aphanomyces	Aphanomyces invadans
8501074	8501074	PRJNA867519_P_NODE_3587_length_552_cov_2.200418_g3436_i0	PRJNA867519	3587	552	2.200418	12.14630736	Phytophthora cinnamomi	4785	SAR_Eukaryotes	SAR_Eukaryotes	291	1.0599999999999998e-73	NTclustered	gi\|2795045397\|ref\|XM_067939565.1\|	4785	g3436	i0	86.194	44.4347826086956	268	37	49	0	267	534	268	1	Phytophthora cinnamomi dynein light chain LC6, flagellar outer arm (IUM83_14793), partial mRNA	blastn	24528	291	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Peronosporales	Peronosporaceae	Phytophthora	Phytophthora cinnamomi
9776024	9776024	PRJNA867519_P_NODE_13068_length_322_cov_1.855422_g12914_i0	PRJNA867519	13068	322	1.855422	5.97445884	Saprolegnia parasitica	101203	SAR_Eukaryotes	SAR_Eukaryotes	257	5.97e-64	NTclustered	gi\|813199585\|ref\|XM_012353974.1\|	695850	g12914	i0	82.085	63.4596273291925	307	49	94	6	16	319	331	28	Saprolegnia parasitica CBS 223.65 40S ribosomal protein S15a mRNA	blastn	20434	257	1	Eukaryota	Sar	Oomycota	Saprolegniomycetes	Saprolegniales	Saprolegniaceae	Saprolegnia	Saprolegnia parasitica
10165514	10165514	PRJNA867519_P_NODE_18268_length_283_cov_1.657143_g18114_i0	PRJNA867519	18268	283	1.657143	4.68971469	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	169	2.4899999999999996e-37	NTclustered	gi\|813138592\|ref\|XM_012343408.1\|	695850	g18114	i0	83.158	26.6678445229682	190	26	66	4	59	245	1031	1217	Saprolegnia parasitica CBS 223.65 hypothetical protein partial mRNA	blastn	7547	169	1	Eukaryota	Sar	Oomycota	Saprolegniomycetes	Saprolegniales	Saprolegniaceae	Saprolegnia	Saprolegnia parasitica
11051759	11051759	PRJNA867519_P_NODE_14949_length_305_cov_0.995690_g14795_i0	PRJNA867519	14949	305	0.99569	3.0368545	Aphanomyces invadans	157072	SAR_Eukaryotes	SAR_Eukaryotes	165	3.5e-36	NTclustered	gi\|673017857\|ref\|XM_008864668.1\|	157072	g14795	i0	84	1.33770491803279	175	24	57	4	41	213	359	531	Aphanomyces invadans 60S ribosomal protein mRNA	blastn	408	165	1	Eukaryota	Sar	Oomycota	Saprolegniomycetes	Saprolegniales	Verrucalvaceae	Aphanomyces	Aphanomyces invadans
11440734	11440734	PRJNA867519_P_NODE_20069_length_275_cov_1.717822_g19915_i0	PRJNA867519	20069	275	1.717822	4.7240105	Saprolegnia	4769	SAR_Eukaryotes	SAR_Eukaryotes	224	5.059999999999999e-54	NTclustered	gi\|813184675\|ref\|XM_012351120.1\|	695850	g19915	i0	81.55	17.3454545454545	271	50	99	0	3	273	7184	7454	Saprolegnia parasitica CBS 223.65 hypothetical protein partial mRNA	blastn	4770	224	1	Eukaryota	Sar	Oomycota	Saprolegniomycetes	Saprolegniales	Saprolegniaceae	Saprolegnia	Saprolegnia parasitica
12327200	12327200	PRJNA867519_P_NODE_1790_length_732_cov_2.071320_g1643_i0	PRJNA867519	1790	732	2.07132	15.1620624	Phytophthora cinnamomi	4785	SAR_Eukaryotes	SAR_Eukaryotes	224	1.47e-53	NTclustered	gi\|2795061008\|ref\|XM_067940276.1\|	4785	g1643	i0	82.869	14.3032786885246	251	41	34	2	386	635	181	430	Phytophthora cinnamomi 60S ribosomal protein L23a (IUM83_15460), partial mRNA	blastn	10470	224	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Peronosporales	Peronosporaceae	Phytophthora	Phytophthora cinnamomi
12716540	12716540	PRJNA867519_P_NODE_14690_length_307_cov_1.316239_g14536_i0	PRJNA867519	14690	307	1.316239	4.04085373	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	320	7.11e-83	NTclustered	gi\|2795048880\|ref\|XM_067943659.1\|	4785	g14536	i0	86.552	99.2312703583062	290	39	94	0	1	290	296	7	Phytophthora cinnamomi Calmodulin (IUM83_18649), partial mRNA	blastn	30464	320	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Peronosporales	Peronosporaceae	Phytophthora	Phytophthora cinnamomi
13601846	13601846	PRJNA867519_P_NODE_32111_length_243_cov_0.905882_g31957_i0	PRJNA867519	32111	243	0.905882	2.20129326	Aphanomyces euteiches	100861	SAR_Eukaryotes	SAR_Eukaryotes	449	6.65e-122	NTclustered	gi\|166044491\|emb\|CU367400.1\|	100861	g31957	i0	100	3.46502057613169	243	0	100	0	1	243	238	480	Aphanomyces euteiches cDNA	blastn	842	449	1	Eukaryota	Sar	Oomycota	Saprolegniomycetes	Saprolegniales	Verrucalvaceae	Aphanomyces	Aphanomyces euteiches
15264908	15264908	PRJNA867519_P_NODE_26732_length_250_cov_0.870056_g26578_i0	PRJNA867519	26732	250	0.870056	2.17514	root	1	Root_unresolved	Root_unresolved	174	4.63e-39	NTclustered	gi\|669154877\|ref\|XM_008614779.1\|	1156394	g26578	i0	81.818	84.484	209	36	83	2	1	207	257	49	Saprolegnia diclina VS20 isocitrate dehydrogenase [NADP] mRNA	blastn	21121	174	1	Eukaryota	Sar	Oomycota	Saprolegniomycetes	Saprolegniales	Saprolegniaceae	Saprolegnia	Saprolegnia diclina
16150766	16150766	PRJNA867519_P_NODE_26073_length_250_cov_1.740113_g25919_i0	PRJNA867519	26073	250	1.740113	4.3502825	Saprolegnia diclina	112098	SAR_Eukaryotes	SAR_Eukaryotes	154	6.03e-33	NTclustered	gi\|669139319\|ref\|XM_008607006.1\|	1156394	g25919	i0	78.099	2.228	242	53	97	0	1	242	544	303	Saprolegnia diclina VS20 ribosomal RNA assembly protein mRNA	blastn	557	154	1	Eukaryota	Sar	Oomycota	Saprolegniomycetes	Saprolegniales	Saprolegniaceae	Saprolegnia	Saprolegnia diclina
16150868	16150868	PRJNA867519_P_NODE_5773_length_451_cov_2.031746_g5619_i0	PRJNA867519	5773	451	2.031746	9.16317446	Phytophthora sojae	67593	SAR_Eukaryotes	SAR_Eukaryotes	300	1.41e-76	NTclustered	gi\|695425628\|ref\|XM_009530930.1\|	67593	g5619	i0	79.859	38.7139689578714	427	73	94	9	30	451	322	740	Phytophthora sojae hypothetical protein mRNA	blastn	17460	300	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Peronosporales	Peronosporaceae	Phytophthora	Phytophthora sojae
17426266	17426266	PRJNA867519_P_NODE_1814_length_728_cov_17.335878_g1667_i0	PRJNA867519	1814	728	17.335878	126.20519184	Phytophthora sojae	67593	SAR_Eukaryotes	SAR_Eukaryotes	436	1.72e-117	NTclustered	gi\|695406639\|ref\|XM_009525867.1\|	67593	g1667	i0	79.806	35.1304945054945	619	110	85	11	23	638	10	616	Phytophthora sojae hypothetical protein mRNA	blastn	25575	436	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Peronosporales	Peronosporaceae	Phytophthora	Phytophthora sojae
17814453	17814453	PRJNA867519_P_NODE_4714_length_491_cov_14.232057_g4561_i0	PRJNA867519	4714	491	14.232057	69.87939987	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	399	1.4899999999999995e-106	NTclustered	gi\|695405971\|ref\|XM_009525682.1\|	67593	g4561	i0	84.925	72.6720977596741	398	56	81	4	42	437	51	446	Phytophthora sojae hypothetical protein mRNA	blastn	35682	403	0.990074441687345	Eukaryota	Sar	Oomycota	Peronosporomycetes	Peronosporales	Peronosporaceae	Phytophthora	Phytophthora sojae
20363378	20363378	PRJNA867519_P_NODE_7876_length_394_cov_1.763240_g7722_i0	PRJNA867519	7876	394	1.76324	6.9471656	Saprolegnia	4769	SAR_Eukaryotes	SAR_Eukaryotes	206	2.7299999999999994e-48	NTclustered	gi\|813186088\|ref\|XM_012351826.1\|	695850	g7722	i0	77.322	10.9263959390863	366	72	91	9	4	362	594	233	Saprolegnia parasitica CBS 223.65 40S ribosomal protein S8 mRNA	blastn	4305	207	0.995169082125604	Eukaryota	Sar	Oomycota	Saprolegniomycetes	Saprolegniales	Saprolegniaceae	Saprolegnia	Saprolegnia parasitica
21250244	21250244	PRJNA867519_P_NODE_18977_length_280_cov_1.487923_g18823_i0	PRJNA867519	18977	280	1.487923	4.1661844	Phytophthora cinnamomi	4785	SAR_Eukaryotes	SAR_Eukaryotes	172	1.8999999999999995e-38	NTclustered	gi\|2795052452\|ref\|XM_067926699.1\|	4785	g18823	i0	93.162	39.7392857142857	117	8	42	0	1	117	403	519	Phytophthora cinnamomi caltractin (IUM83_02754), partial mRNA	blastn	11127	172	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Peronosporales	Peronosporaceae	Phytophthora	Phytophthora cinnamomi
21250382	21250382	PRJNA867519_P_NODE_8037_length_391_cov_1.694969_g7883_i0	PRJNA867519	8037	391	1.694969	6.62732879	Saprolegnia parasitica	101203	SAR_Eukaryotes	SAR_Eukaryotes	239	2.67e-58	NTclustered	gi\|813150484\|ref\|XM_012345499.1\|	695850	g7883	i0	83.459	14.0281329923274	266	34	67	10	12	272	492	752	Saprolegnia parasitica CBS 223.65 40S ribosomal protein S3a-2 mRNA	blastn	5485	239	1	Eukaryota	Sar	Oomycota	Saprolegniomycetes	Saprolegniales	Saprolegniaceae	Saprolegnia	Saprolegnia parasitica
22524930	22524930	PRJNA867519_P_NODE_7018_length_414_cov_3.085044_g6864_i0	PRJNA867519	7018	414	3.085044	12.77208216	Saprolegnia diclina	112098	SAR_Eukaryotes	SAR_Eukaryotes	265	4.7e-66	NTclustered	gi\|669149499\|ref\|XM_008612090.1\|	1156394	g6864	i0	81.065	20.2512077294686	338	58	81	5	23	357	270	604	Saprolegnia diclina VS20 40S ribosomal protein mRNA	blastn	8384	265	1	Eukaryota	Sar	Oomycota	Saprolegniomycetes	Saprolegniales	Saprolegniaceae	Saprolegnia	Saprolegnia diclina
22524931	22524931	PRJNA867519_P_NODE_7078_length_413_cov_1.926471_g6924_i0	PRJNA867519	7078	413	1.926471	7.95632523	Phytophthora ramorum	164328	SAR_Eukaryotes	SAR_Eukaryotes	248	4.72e-61	NTclustered	gi\|2794923360\|ref\|XM_067881981.1\|	164328	g6924	i0	91.209	43.5956416464891	182	16	44	0	232	413	450	269	Phytophthora ramorum Calmodulin (KRP23_11430), partial mRNA	blastn	18005	248	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Peronosporales	Peronosporaceae	Phytophthora	Phytophthora ramorum
23800313	23800313	PRJNA867519_P_NODE_22639_length_264_cov_1.209424_g22485_i0	PRJNA867519	22639	264	1.209424	3.19287936	Phytophthora sojae	67593	SAR_Eukaryotes	SAR_Eukaryotes	148	2.9899999999999995e-31	NTclustered	gi\|695386086\|ref\|XM_009520166.1\|	67593	g22485	i0	79.186	6.65530303030303	221	40	83	5	47	264	955	738	Phytophthora sojae hypothetical protein mRNA	blastn	1757	148	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Peronosporales	Peronosporaceae	Phytophthora	Phytophthora sojae
23800417	23800417	PRJNA867519_P_NODE_4979_length_481_cov_3.487745_g4825_i0	PRJNA867519	4979	481	3.487745	16.77605345	Phytophthora cinnamomi	4785	SAR_Eukaryotes	SAR_Eukaryotes	302	4.21e-77	NTclustered	gi\|2795040529\|ref\|XM_067944818.1\|	4785	g4825	i0	80.89	39.970893970894	382	73	79	0	74	455	405	24	Phytophthora cinnamomi 60S ribosomal protein L23 (IUM83_19754), partial mRNA	blastn	19226	302	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Peronosporales	Peronosporaceae	Phytophthora	Phytophthora cinnamomi

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