metadata: contig_metadata: 10 rows where analysis = "blastn", bioproject = "PRJNA340009" and tax

10 rows where analysis = "blastn", bioproject = "PRJNA340009" 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
392124	392124	PRJNA340009_P_NODE_32141_length_221_cov_0.819767_g31834_i0	PRJNA340009	32141	221	0.819767	1.81168507	Phytophthora cinnamomi	4785	SAR_Eukaryotes	SAR_Eukaryotes	145	3.14e-30	NTclustered	gi\|2795058078\|ref\|XM_067944971.1\|	4785	g31834	i0	81.714	1.57918552036199	175	30	79	2	1	174	3813	3986	Phytophthora cinnamomi structural maintenance of chromosomes protein (IUM83_19902), partial mRNA	blastn	349	145	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Peronosporales	Peronosporaceae	Phytophthora	Phytophthora cinnamomi
5496240	5496240	PRJNA340009_P_NODE_79925_length_154_cov_2.914286_g79618_i0	PRJNA340009	79925	154	2.914286	4.48800044	Aphanomyces invadans	157072	SAR_Eukaryotes	SAR_Eukaryotes	132	1.58e-26	NTclustered	gi\|1111669769\|ref\|NC_032052.1\|	157072	g79618	i0	83.571	6.61038961038961	140	23	91	0	5	144	10733	10872	Aphanomyces invadans isolate NJM9701 mitochondrion, complete genome	blastn	1018	132	1	Eukaryota	Sar	Oomycota	Saprolegniomycetes	Saprolegniales	Verrucalvaceae	Aphanomyces	Aphanomyces invadans
8045297	8045297	PRJNA340009_P_NODE_30667_length_225_cov_1.420455_g30360_i0	PRJNA340009	30667	225	1.420455	3.19602375	Aphanomyces invadans	157072	SAR_Eukaryotes	SAR_Eukaryotes	176	1.14e-39	NTclustered	gi\|1111669769\|ref\|NC_032052.1\|	157072	g30360	i0	82.99	62	194	33	88	0	4	197	5998	5805	Aphanomyces invadans isolate NJM9701 mitochondrion, complete genome	blastn	13950	176	1	Eukaryota	Sar	Oomycota	Saprolegniomycetes	Saprolegniales	Verrucalvaceae	Aphanomyces	Aphanomyces invadans
8722518	8722518	PRJNA340009_P_NODE_20147_length_269_cov_2.086364_g19840_i0	PRJNA340009	20147	269	2.086364	5.61231916	root	1	Root_unresolved	Root_unresolved	483	7.369999999999998e-132	NTclustered	gi\|166044518\|emb\|CU367427.1\|	100861	g19840	i0	99.251	18.817843866171	267	2	99	0	1	267	536	802	Aphanomyces euteiches cDNA	blastn	5062	483	1	Eukaryota	Sar	Oomycota	Saprolegniomycetes	Saprolegniales	Verrucalvaceae	Aphanomyces	Aphanomyces euteiches
9998312	9998312	PRJNA340009_P_NODE_69288_length_164_cov_0.886957_g68981_i0	PRJNA340009	69288	164	0.886957	1.45460948	root	1	Root_unresolved	Root_unresolved	298	1.59e-76	NTclustered	gi\|166046539\|emb\|CU367656.1\|	100861	g68981	i0	99.39	99.8658536585366	164	1	100	0	1	164	515	352	Aphanomyces euteiches cDNA	blastn	16378	298	1	Eukaryota	Sar	Oomycota	Saprolegniomycetes	Saprolegniales	Verrucalvaceae	Aphanomyces	Aphanomyces euteiches
10595893	10595893	PRJNA340009_P_NODE_3969_length_524_cov_6.880000_g3669_i0	PRJNA340009	3969	524	6.88	36.0512	Aphanomyces astaci	112090	SAR_Eukaryotes	SAR_Eukaryotes	281	6.02e-71	NTclustered	gi\|698807229\|ref\|XM_009838342.1\|	112090	g3669	i0	80.533	64.5152671755725	375	65	70	4	23	390	68	441	Aphanomyces astaci polyubiquitin mRNA	blastn	33806	281	1	Eukaryota	Sar	Oomycota	Saprolegniomycetes	Saprolegniales	Verrucalvaceae	Aphanomyces	Aphanomyces astaci
15694693	15694693	PRJNA340009_P_NODE_29193_length_229_cov_73.461111_g28886_i0	PRJNA340009	29193	229	73.461111	168.22594419	Aphanomyces astaci	112090	SAR_Eukaryotes	SAR_Eukaryotes	388	1.3699999999999998e-103	NTclustered	gi\|1111669722\|ref\|NC_032051.1\|	112090	g28886	i0	99.531	103.248908296943	213	1	93	0	17	229	3749	3961	Aphanomyces astaci isolate AP03 mitochondrion, complete genome	blastn	23644	388	1	Eukaryota	Sar	Oomycota	Saprolegniomycetes	Saprolegniales	Verrucalvaceae	Aphanomyces	Aphanomyces astaci
22746840	22746840	PRJNA340009_P_NODE_23258_length_253_cov_1.411765_g22951_i0	PRJNA340009	23258	253	1.411765	3.57176545	root	1	Root_unresolved	Root_unresolved	337	5.659999999999998e-88	NTclustered	gi\|166046496\|emb\|CU367613.1\|	100861	g22951	i0	94.931	89.802371541502	217	8	85	3	38	253	329	115	Aphanomyces euteiches cDNA	blastn	22720	337	1	Eukaryota	Sar	Oomycota	Saprolegniomycetes	Saprolegniales	Verrucalvaceae	Aphanomyces	Aphanomyces euteiches
24021677	24021677	PRJNA340009_P_NODE_13199_length_322_cov_24.179487_g12892_i0	PRJNA340009	13199	322	24.179487	77.85794814	root	1	Root_unresolved	Root_unresolved	496	1.16e-135	NTclustered	gi\|166046794\|emb\|CU367369.1\|	100861	g12892	i0	100	83.2546583850932	268	0	83	0	22	289	792	525	Aphanomyces euteiches cDNA	blastn	26808	496	1	Eukaryota	Sar	Oomycota	Saprolegniomycetes	Saprolegniales	Verrucalvaceae	Aphanomyces	Aphanomyces euteiches
24618193	24618193	PRJNA340009_P_NODE_29360_length_229_cov_1.766667_g29053_i0	PRJNA340009	29360	229	1.766667	4.04566743	Achlya bisexualis	4766	SAR_Eukaryotes	SAR_Eukaryotes	257	4.03e-64	NTclustered	gi\|2289\|emb\|X59936.1\|	4766	g29053	i0	86.9	96.0087336244542	229	30	100	0	1	229	237	9	A.bisexualis gene for actin	blastn	21986	257	1	Eukaryota	Sar	Oomycota	Saprolegniomycetes	Saprolegniales	Achlyaceae	Achlya	Achlya bisexualis

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