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

9 rows where analysis = "blastn", bioproject = "PRJNA788929" 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
769006	769006	PRJNA788929_P_NODE_10821_length_537_cov_18.424569_g10168_i0	PRJNA788929	10821	537	18.424569	98.93993553	Pythium monospermum	92964	SAR_Eukaryotes	SAR_Eukaryotes	789	0	NTclustered	gi\|33520250\|gb\|AY273995.1\|	92964	g10168	i0	98.441	92.4320297951583	449	6	84	1	1	449	448	1	Pythium monospermum large subunit ribosomal RNA gene, partial sequence	blastn	49636	789	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Pythiales	Pythiaceae	Pythium	Pythium monospermum
2045535	2045535	PRJNA788929_P_NODE_45742_length_225_cov_11.322368_g45081_i0	PRJNA788929	45742	225	11.322368	25.475328	Aphanomyces astaci	112090	SAR_Eukaryotes	SAR_Eukaryotes	359	1.0499999999999999e-94	NTclustered	gi\|1111669722\|ref\|NC_032051.1\|	112090	g45081	i0	98.522	97.8488888888889	203	3	90	0	2	204	3844	3642	Aphanomyces astaci isolate AP03 mitochondrion, complete genome	blastn	22016	359	1	Eukaryota	Sar	Oomycota	Saprolegniomycetes	Saprolegniales	Verrucalvaceae	Aphanomyces	Aphanomyces astaci
4597853	4597853	PRJNA788929_P_NODE_46444_length_221_cov_5.621622_g45783_i0	PRJNA788929	46444	221	5.621622	12.42378462	Thraustotheca clavata	74557	SAR_Eukaryotes	SAR_Eukaryotes	128	3.16e-25	NTclustered	gi\|533310373\|ref\|NC_022179.1\|	74557	g45783	i0	84.211	12.420814479638	133	19	60	2	60	191	4965	5096	Thraustotheca clavata mitochondrion, complete genome	blastn	2745	128	1	Eukaryota	Sar	Oomycota	Saprolegniomycetes	Saprolegniales	Achlyaceae	Thraustotheca	Thraustotheca clavata
7147837	7147837	PRJNA788929_P_NODE_2926_length_1222_cov_47.370757_g2551_i0	PRJNA788929	2926	1222	47.370757	578.87065054	Pythium insidiosum	114742	SAR_Eukaryotes	SAR_Eukaryotes	1938	0	NTclustered	gi\|937408816\|ref\|NC_027966.1\|	114742	g2551	i0	95.775	102.805237315876	1207	42	98	5	25	1222	11635	10429	Pythium insidiosum mitochondrial DNA, complete genome	blastn	125628	1938	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Pythiales	Pythiaceae	Pythium	Pythium insidiosum
9697741	9697741	PRJNA788929_P_NODE_34908_length_263_cov_7.463158_g34247_i0	PRJNA788929	34908	263	7.463158	19.62810554	Saprolegnia ferax	4770	SAR_Eukaryotes	SAR_Eukaryotes	427	3.41e-115	NTclustered	gi\|50261276\|ref\|NC_005984.1\|	4770	g34247	i0	98.361	98.4828897338403	244	2	92	1	22	263	9338	9581	Saprolegnia ferax mitochondrion, complete genome	blastn	25901	427	1	Eukaryota	Sar	Oomycota	Saprolegniomycetes	Saprolegniales	Saprolegniaceae	Saprolegnia	Saprolegnia ferax
12693844	12693844	PRJNA788929_P_NODE_20570_length_360_cov_6.797909_g19910_i0	PRJNA788929	20570	360	6.797909	24.4724724	Hyaloperonospora	184462	SAR_Eukaryotes	SAR_Eukaryotes	217	1.14e-51	NTclustered	gi\|33520224\|gb\|AY273969.1\|	123356	g19910	i0	94.928	39.7361111111111	138	7	38	0	26	163	404	541	Hyaloperonospora parasitica large subunit ribosomal RNA gene, partial sequence	blastn	14305	219	0.990867579908676	Eukaryota	Sar	Oomycota	Peronosporomycetes	Peronosporales	Peronosporaceae	Hyaloperonospora	Hyaloperonospora parasitica
16517008	16517008	PRJNA788929_P_NODE_12173_length_498_cov_11.847059_g11516_i0	PRJNA788929	12173	498	11.847059	58.99835382	Aphanomyces	100860	SAR_Eukaryotes	SAR_Eukaryotes	584	3.879999999999999e-162	NTclustered	gi\|1111669722\|ref\|NC_032051.1\|	112090	g11516	i0	90.044	52.8895582329317	452	43	91	2	48	498	41411	41861	Aphanomyces astaci isolate AP03 mitochondrion, complete genome	blastn	26339	584	1	Eukaryota	Sar	Oomycota	Saprolegniomycetes	Saprolegniales	Verrucalvaceae	Aphanomyces	Aphanomyces astaci
19896178	19896178	PRJNA788929_P_NODE_29576_length_290_cov_19.281106_g28915_i0	PRJNA788929	29576	290	19.281106	55.9152074	Aphanomyces laevis	112092	SAR_Eukaryotes	SAR_Eukaryotes	496	1.03e-135	NTclustered	gi\|17224981\|gb\|AF320584.1\|	112092	g28915	i0	100	92.8275862068966	268	0	92	0	1	268	990	723	Aphanomyces laevis 28S ribosomal RNA gene, partial sequence	blastn	26920	496	1	Eukaryota	Sar	Oomycota	Saprolegniomycetes	Saprolegniales	Verrucalvaceae	Aphanomyces	Aphanomyces laevis
19896573	19896573	PRJNA788929_P_NODE_8456_length_632_cov_24.334526_g7808_i0	PRJNA788929	8456	632	24.334526	153.79420432	Phytophthora andina	283009	SAR_Eukaryotes	SAR_Eukaryotes	272	4.419999999999999e-68	NTclustered	gi\|334701739\|ref\|NC_015619.1\|	283009	g7808	i0	77.874	72.9382911392405	461	86	72	13	118	570	21819	22271	Phytophthora andina mitochondrion, complete genome	blastn	46097	272	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Peronosporales	Peronosporaceae	Phytophthora	Phytophthora andina

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