metadata: contig_metadata: 14 rows where analysis = "blastn", bioproject = "PRJNA515078" and tax

14 rows where analysis = "blastn", bioproject = "PRJNA515078" 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
1762141	1762141	PRJNA515078_P_NODE_402_length_1386_cov_64.408451_g135_i3	PRJNA515078	402	1386	64.408451	892.70113086	Aphanomyces euteiches	100861	SAR_Eukaryotes	SAR_Eukaryotes	573	2.4499999999999996e-158	NTclustered	gi\|166035209\|emb\|CU349042.1\|	100861	g135	i3	80.914	44.1219336219336	744	126	53	13	646	1381	818	83	Aphanomyces euteiches cDNA	blastn	61153	573	1	Eukaryota	Sar	Oomycota	Saprolegniomycetes	Saprolegniales	Verrucalvaceae	Aphanomyces	Aphanomyces euteiches
3038012	3038012	PRJNA515078_P_NODE_8643_length_311_cov_1.624088_g8410_i0	PRJNA515078	8643	311	1.624088	5.05091368	Aphanomyces euteiches	100861	SAR_Eukaryotes	SAR_Eukaryotes	239	2.08e-58	NTclustered	gi\|166037229\|emb\|CU357094.1\|	100861	g8410	i0	80.707	39.3022508038585	311	56	99	4	2	310	215	523	Aphanomyces euteiches cDNA	blastn	12223	239	1	Eukaryota	Sar	Oomycota	Saprolegniomycetes	Saprolegniales	Verrucalvaceae	Aphanomyces	Aphanomyces euteiches
6864739	6864739	PRJNA515078_P_NODE_9886_length_288_cov_1.593625_g9653_i0	PRJNA515078	9886	288	1.593625	4.58964	Plasmopara halstedii	4781	SAR_Eukaryotes	SAR_Eukaryotes	63.9	1.23e-5	NTclustered	gi\|1378169911\|ref\|XM_024719330.1\|	4781	g9653	i0	95	1.13194444444444	40	2	24	0	116	155	299	260	Plasmopara halstedii uncharacterized protein (PHALS_06101), partial mRNA	blastn	326	63.9	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Peronosporales	Peronosporaceae	Plasmopara	Plasmopara halstedii
8139870	8139870	PRJNA515078_P_NODE_19927_length_194_cov_2.210191_g19694_i0	PRJNA515078	19927	194	2.210191	4.28777054	Phytophthora cichorii	1320215	SAR_Eukaryotes	SAR_Eukaryotes	110	9.8e-20	NTclustered	gi\|1233049965\|gb\|KX252011.1\|	1320215	g19694	i0	81.119	8.02577319587629	143	21	72	6	50	189	479	340	Phytophthora cichorii isolate 62A8(ex-type) heat shock protein 90 gene, partial cds	blastn	1557	110	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Peronosporales	Peronosporaceae	Phytophthora	Phytophthora cichorii
8139999	8139999	PRJNA515078_P_NODE_527_length_1261_cov_91.323529_g135_i4	PRJNA515078	527	1261	91.323529	1151.58970069	Aphanomyces euteiches	100861	SAR_Eukaryotes	SAR_Eukaryotes	573	2.2199999999999993e-158	NTclustered	gi\|166035209\|emb\|CU349042.1\|	100861	g135	i4	80.914	48.4996034892942	744	126	58	13	521	1256	818	83	Aphanomyces euteiches cDNA	blastn	61158	573	1	Eukaryota	Sar	Oomycota	Saprolegniomycetes	Saprolegniales	Verrucalvaceae	Aphanomyces	Aphanomyces euteiches
9415022	9415022	PRJNA515078_P_NODE_30828_length_158_cov_0.966942_g30595_i0	PRJNA515078	30828	158	0.966942	1.52776836	Phytophthora sojae	67593	SAR_Eukaryotes	SAR_Eukaryotes	134	4.53e-27	NTclustered	gi\|695379949\|ref\|XM_009518377.1\|	67593	g30595	i0	85.714	3.77215189873418	126	18	80	0	2	127	106	231	Phytophthora sojae hypothetical protein partial mRNA	blastn	596	134	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Peronosporales	Peronosporaceae	Phytophthora	Phytophthora sojae
15139007	15139007	PRJNA515078_P_NODE_21112_length_189_cov_1.026316_g20879_i0	PRJNA515078	21112	189	1.026316	1.93973724	Globisporangium	1448052	SAR_Eukaryotes	SAR_Eukaryotes	180	7.13e-41	NTclustered	gi\|269812125\|gb\|GU138663.1\|	2052682	g20879	i0	86.31	88.6825396825397	168	20	89	1	3	170	23312	23148	Pythium ultimum culture-collection CBS:398.51 mitochondrion, complete genome	blastn	16761	180	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Pythiales	Pythiaceae	Globisporangium	Globisporangium ultimum
15139029	15139029	PRJNA515078_P_NODE_2812_length_581_cov_5.056985_g2596_i0	PRJNA515078	2812	581	5.056985	29.38108285	Aphanomyces	100860	SAR_Eukaryotes	SAR_Eukaryotes	470	1.34e-127	NTclustered	gi\|698783348\|ref\|XM_009826416.1\|	112090	g2596	i0	85.275	70.4182444061962	455	67	78	0	88	542	67	521	Aphanomyces astaci hypothetical protein mRNA	blastn	40913	472	0.995762711864407	Eukaryota	Sar	Oomycota	Saprolegniomycetes	Saprolegniales	Verrucalvaceae	Aphanomyces	Aphanomyces astaci
15139046	15139046	PRJNA515078_P_NODE_3452_length_521_cov_11.522727_g3222_i0	PRJNA515078	3452	521	11.522727	60.03340767	Saprolegniales	4763	SAR_Eukaryotes	SAR_Eukaryotes	494	7.06e-135	NTclustered	gi\|166303\|gb\|J05116.1\|ACKCAL	4767	g3222	i0	86.637	64.785028790787	449	57	86	3	1	447	505	952	A.klebsiana calmodulin gene, complete cds	blastn	33753	496	0.995967741935484	Eukaryota	Sar	Oomycota	Saprolegniomycetes	Saprolegniales	Achlyaceae	Achlya	Achlya klebsiana
17064209	17064209	PRJNA515078_P_NODE_6394_length_371_cov_1.634731_g6161_i0	PRJNA515078	6394	371	1.634731	6.06485201	Aphanomyces euteiches	100861	SAR_Eukaryotes	SAR_Eukaryotes	246	1.51e-60	NTclustered	gi\|166051160\|emb\|CU363257.1\|	100861	g6161	i0	86.547	27.9568733153639	223	30	60	0	52	274	603	825	Aphanomyces euteiches cDNA	blastn	10372	246	1	Eukaryota	Sar	Oomycota	Saprolegniomycetes	Saprolegniales	Verrucalvaceae	Aphanomyces	Aphanomyces euteiches
17064216	17064216	PRJNA515078_P_NODE_74_length_2273_cov_17.095707_g59_i0	PRJNA515078	74	2273	17.095707	388.58542011	Aphanomyces astaci	112090	SAR_Eukaryotes	SAR_Eukaryotes	1358	0	NTclustered	gi\|698782776\|ref\|XM_009826130.1\|	112090	g59	i0	78.968	59.0488341399032	2035	397	89	26	230	2244	2042	19	Aphanomyces astaci hsp82-like protein partial mRNA	blastn	134218	1358	1	Eukaryota	Sar	Oomycota	Saprolegniomycetes	Saprolegniales	Verrucalvaceae	Aphanomyces	Aphanomyces astaci
22163610	22163610	PRJNA515078_P_NODE_218_length_1674_cov_6.378131_g182_i0	PRJNA515078	218	1674	6.378131	106.76991294	Achlya ambisexualis	4768	SAR_Eukaryotes	SAR_Eukaryotes	961	0	NTclustered	gi\|22086552\|gb\|AF402101.1\|	4768	g182	i0	78.944	61.7837514934289	1458	274	86	32	1	1440	584	2026	Achlya ambisexualis isolate JS855 heat shock protein Hsp90 mRNA, complete cds	blastn	103426	961	1	Eukaryota	Sar	Oomycota	Saprolegniomycetes	Saprolegniales	Achlyaceae	Achlya	Achlya ambisexualis
23439397	23439397	PRJNA515078_P_NODE_99_length_2090_cov_16.373113_g59_i1	PRJNA515078	99	2090	16.373113	342.1980617	Aphanomyces astaci	112090	SAR_Eukaryotes	SAR_Eukaryotes	1232	0	NTclustered	gi\|698782770\|ref\|XM_009826127.1\|	112090	g59	i1	78.885	59.7913875598086	1866	360	88	28	17	1861	208	2060	Aphanomyces astaci hsp82-like protein mRNA	blastn	124964	1232	1	Eukaryota	Sar	Oomycota	Saprolegniomycetes	Saprolegniales	Verrucalvaceae	Aphanomyces	Aphanomyces astaci
24062867	24062867	PRJNA515078_P_NODE_14699_length_229_cov_1.619792_g14466_i0	PRJNA515078	14699	229	1.619792	3.70932368	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	58.4	4.39e-4	NTclustered	gi\|146220213\|gb\|EF216565.1\|	299392	g14466	i0	86.538	4.31877729257642	52	7	23	0	102	153	510	459	Phytophthora alni subsp. alni strain SCRP2 clone S23-25(P1) SSR marker sequence	blastn	989	58.4	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Peronosporales	Peronosporaceae	Phytophthora	Phytophthora x alni

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