metadata: contig_metadata: 9 rows where analysis = "blastn", bioproject = "PRJNA1078753" and tax

9 rows where analysis = "blastn", bioproject = "PRJNA1078753" 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
4844995	4844995	PRJNA1078753_P_NODE_26384_length_253_cov_1.283333_g26188_i0	PRJNA1078753	26384	253	1.283333	3.24683249	Saprolegnia	4769	SAR_Eukaryotes	SAR_Eukaryotes	100	8.08e-17	NTclustered	gi\|813174578\|ref\|XM_012349556.1\|	695850	g26188	i0	81.452	0.980237154150198	124	21	49	2	10	132	121	243	Saprolegnia parasitica CBS 223.65 60S ribosomal protein L27a mRNA	blastn	248	100	1	Eukaryota	Sar	Oomycota	Saprolegniomycetes	Saprolegniales	Saprolegniaceae	Saprolegnia	Saprolegnia parasitica
9120152	9120152	PRJNA1078753_P_NODE_25068_length_258_cov_1.470270_g24872_i0	PRJNA1078753	25068	258	1.47027	3.7932966	Phytophthora nicotianae	4792	SAR_Eukaryotes	SAR_Eukaryotes	117	8.2100000000000005e-22	NTclustered	gi\|675208352\|ref\|XM_008914813.1\|	761204	g24872	i0	79.874	8.72480620155039	159	32	62	0	1	159	284	126	Phytophthora parasitica INRA-310 ribonucleoprotein-associated protein mRNA	blastn	2251	117	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Peronosporales	Peronosporaceae	Phytophthora	Phytophthora nicotianae
14221147	14221147	PRJNA1078753_P_NODE_10972_length_344_cov_1.420664_g10776_i0	PRJNA1078753	10972	344	1.420664	4.88708416	Paralagenidium karlingii	1440115	SAR_Eukaryotes	SAR_Eukaryotes	137	8.729999999999999e-28	NTclustered	gi\|2554484921\|ref\|NC_080886.1\|	1440115	g10776	i0	89.815	33.1279069767442	108	10	31	1	101	207	41659	41766	Paralagenidium karlingii isolate 19-09020 mitochondrion, complete genome	blastn	11396	137	1	Eukaryota	Sar	Oomycota	Peronosporomycetes			Paralagenidium	Paralagenidium karlingii
15495119	15495119	PRJNA1078753_P_NODE_18873_length_283_cov_1.466667_g18677_i0	PRJNA1078753	18873	283	1.466667	4.15066761	Phytophthora nicotianae	4792	SAR_Eukaryotes	SAR_Eukaryotes	124	5.46e-24	NTclustered	gi\|675169594\|ref\|XM_008895434.1\|	761204	g18677	i0	81.41	3.50883392226148	156	25	54	3	130	283	525	372	Phytophthora parasitica INRA-310 40S ribosomal protein S16 mRNA	blastn	993	124	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Peronosporales	Peronosporaceae	Phytophthora	Phytophthora nicotianae
16769682	16769682	PRJNA1078753_P_NODE_5614_length_447_cov_3.227273_g5418_i0	PRJNA1078753	5614	447	3.227273	14.42591031	Phytophthora cinnamomi	4785	SAR_Eukaryotes	SAR_Eukaryotes	350	1.37e-91	NTclustered	gi\|2795029237\|ref\|XM_067937609.1\|	4785	g5418	i0	83.161	75.8076062639821	386	61	86	4	64	447	31	414	Phytophthora cinnamomi 40S ribosomal protein S14 (IUM83_12961), partial mRNA	blastn	33886	350	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Peronosporales	Peronosporaceae	Phytophthora	Phytophthora cinnamomi
17594805	17594805	PRJNA1078753_P_NODE_6034_length_433_cov_6.050000_g5838_i0	PRJNA1078753	6034	433	6.05	26.1965	Phytophthora	4783	SAR_Eukaryotes	SAR_Eukaryotes	305	2.91e-78	NTclustered	gi\|2795029237\|ref\|XM_067937609.1\|	4785	g5838	i0	81.72	79.9099307159353	372	62	85	5	1	369	399	31	Phytophthora cinnamomi 40S ribosomal protein S14 (IUM83_12961), partial mRNA	blastn	34601	305	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Peronosporales	Peronosporaceae	Phytophthora	Phytophthora cinnamomi
20593753	20593753	PRJNA1078753_P_NODE_7577_length_394_cov_2.242991_g7381_i0	PRJNA1078753	7577	394	2.242991	8.83738454	Phytophthora sojae	67593	SAR_Eukaryotes	SAR_Eukaryotes	387	9.1e-103	NTclustered	gi\|195970350\|gb\|EU880228.1\|	67593	g7381	i0	87.463	85.3984771573604	335	42	85	0	6	340	353	19	Phytophthora sojae calmodulin (CAM1) mRNA, complete cds	blastn	33647	387	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Peronosporales	Peronosporaceae	Phytophthora	Phytophthora sojae
23144732	23144732	PRJNA1078753_P_NODE_2319_length_650_cov_2.150780_g2131_i0	PRJNA1078753	2319	650	2.15078	13.98007	Phytophthora nicotianae	4792	SAR_Eukaryotes	SAR_Eukaryotes	54.7	0.018	NTclustered	gi\|675214874\|ref\|XM_008918074.1\|	761204	g2131	i0	96.875	0.0984615384615385	32	1	5	0	352	383	119	88	Phytophthora parasitica INRA-310 hypothetical protein partial mRNA	blastn	64	54.7	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Peronosporales	Peronosporaceae	Phytophthora	Phytophthora nicotianae
23144776	23144776	PRJNA1078753_P_NODE_30019_length_249_cov_1.312500_g29823_i0	PRJNA1078753	30019	249	1.3125	3.268125	Phytophthora cinnamomi	4785	SAR_Eukaryotes	SAR_Eukaryotes	222	1.62e-53	NTclustered	gi\|2795016949\|ref\|XM_067930458.1\|	4785	g29823	i0	83.682	83.2730923694779	239	35	95	4	11	247	927	691	Phytophthora cinnamomi protein transporter Sec61 subunit alpha isoform 2 (IUM83_06269), partial mRNA	blastn	20735	222	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);;