metadata: contig_metadata: 15 rows where bioproject = "PRJNA1111146" and tax

15 rows where bioproject = "PRJNA1111146" 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
6594526	6594526	PRJNA1111146_P_NODE_322306_length_184_cov_1.183206_g321168_i0	PRJNA1111146	322306	184	1.183206	2.17709904	Hyaloperonospora parasitica	123356	SAR_Eukaryotes	SAR_Eukaryotes	87.9	4.3e-13	NTclustered	gi\|188030690\|emb\|CU694995.3\|	123356	g321168	i0	83.333	0.521739130434783	96	15	52	1	2	96	55672	55767	H.parasitica DNA sequence from clone HpEmoy2-18B18, complete sequence	blastn	96	87.9	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Peronosporales	Peronosporaceae	Hyaloperonospora	Hyaloperonospora parasitica
7869031	7869031	PRJNA1111146_P_NODE_291127_length_188_cov_2.118519_g289989_i0	PRJNA1111146	291127	188	2.118519	3.98281572	Albugo laibachii	653948	SAR_Eukaryotes	SAR_Eukaryotes	348	1.84e-91	NTclustered	gi\|325194231\|emb\|FR825088.1\|	890382	g289989	i0	100	1.38297872340426	188	0	100	0	1	188	429	616	Albugo laibachii Nc14, genomic contig CONTIG_1612_NC14_v4_1853_85	blastn	260	348	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Albuginales	Albuginaceae	Albugo	Albugo laibachii
9143692	9143692	PRJNA1111146_P_NODE_239708_length_198_cov_1.572414_g238570_i0	PRJNA1111146	239708	198	1.572414	3.11337972	Albugo laibachii	653948	SAR_Eukaryotes	SAR_Eukaryotes	298	2e-76	NTclustered	gi\|325194108\|emb\|FR824999.1\|	890382	g238570	i0	93.564	2.03535353535354	202	9	100	2	1	198	1152	951	Albugo laibachii Nc14, genomic contig CONTIG_1414_NC14_v4_2329_139	blastn	403	298	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Albuginales	Albuginaceae	Albugo	Albugo laibachii
12970433	12970433	PRJNA1111146_P_NODE_361611_length_181_cov_1.765625_g360473_i0	PRJNA1111146	361611	181	1.765625	3.19578125	Albugo laibachii	653948	SAR_Eukaryotes	SAR_Eukaryotes	283	5.01e-72	NTclustered	gi\|325194231\|emb\|FR825088.1\|	890382	g360473	i0	95.028	1.19889502762431	181	8	100	1	1	181	1165	986	Albugo laibachii Nc14, genomic contig CONTIG_1612_NC14_v4_1853_85	blastn	217	283	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Albuginales	Albuginaceae	Albugo	Albugo laibachii
14244445	14244445	PRJNA1111146_P_NODE_119672_length_233_cov_2.283333_g118534_i0	PRJNA1111146	119672	233	2.283333	5.32016589	Albugo laibachii	653948	SAR_Eukaryotes	SAR_Eukaryotes	372	1.41e-98	NTclustered	gi\|325194231\|emb\|FR825088.1\|	890382	g118534	i0	95.69	1.3862660944206	232	9	99	1	1	231	875	644	Albugo laibachii Nc14, genomic contig CONTIG_1612_NC14_v4_1853_85	blastn	323	372	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Albuginales	Albuginaceae	Albugo	Albugo laibachii
20616816	20616816	PRJNA1111146_P_NODE_146097_length_222_cov_1.656805_g144959_i0	PRJNA1111146	146097	222	1.656805	3.6781071	Albugo laibachii	653948	SAR_Eukaryotes	SAR_Eukaryotes	276	1.07e-69	NTclustered	gi\|325195820\|emb\|FR826611.1\|	890382	g144959	i0	93.122	38.2342342342342	189	11	85	2	24	211	210	23	Albugo laibachii Nc14, genomic contig CONTIG_3778_NC14_v4_313_8	blastn	8488	276	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Albuginales	Albuginaceae	Albugo	Albugo laibachii
23169317	23169317	PRJNA1111146_P_NODE_45279_length_295_cov_1.818182_g44142_i0	PRJNA1111146	45279	295	1.818182	5.3636369	Albugo laibachii	653948	SAR_Eukaryotes	SAR_Eukaryotes	540	4.79e-149	NTclustered	gi\|325194231\|emb\|FR825088.1\|	890382	g44142	i0	99.661	2.13898305084746	295	1	100	0	1	295	1150	1444	Albugo laibachii Nc14, genomic contig CONTIG_1612_NC14_v4_1853_85	blastn	631	540	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Albuginales	Albuginaceae	Albugo	Albugo laibachii
27153419	27153419	PRJNA1111146_P_NODE_440182_length_177_cov_0.887097_g439044_i0	PRJNA1111146	440182	177	0.887097	1.57016169	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	46.6	7e-4	NR	OWZ09828.1	4795	g439044	i0	42.3	4.32203389830508	52	30	88.1	0	1	156	1250	1301	OWZ09828.1 LOW QUALITY PROTEIN: hypothetical protein PHMEG_00017409 [Phytophthora megakarya]	diamond	765	47	0.991489361702128	Eukaryota	Sar	Oomycota	Peronosporomycetes	Peronosporales	Peronosporaceae	Phytophthora	Phytophthora megakarya
27699964	27699964	PRJNA1111146_P_NODE_316104_length_185_cov_0.863636_g314966_i0	PRJNA1111146	316104	185	0.863636	1.5977266	Peronospora destructor	86335	SAR_Eukaryotes	SAR_Eukaryotes	88.6	1.83e-19	NR	CAI5731206.1	86335	g314966	i0	80.3	4.94594594594595	61	12	98.9	0	2	184	81	141	CAI5731206.1 unnamed protein product [Peronospora destructor]	diamond	915	88.6	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Peronosporales	Peronosporaceae	Peronospora	Peronospora destructor
27888956	27888956	PRJNA1111146_P_NODE_375025_length_181_cov_0.867188_g373887_i0	PRJNA1111146	375025	181	0.867188	1.56961028	Phytophthora fragariaefolia	1490495	SAR_Eukaryotes	SAR_Eukaryotes	76.6	1.76e-14	NR	GMF39336.1	1490495	g373887	i0	66.7	0.895027624309392	54	18	89.5	0	179	18	391	444	GMF39336.1 unnamed protein product [Phytophthora fragariaefolia]	diamond	162	76.6	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Peronosporales	Peronosporaceae	Phytophthora	Phytophthora fragariaefolia
27975004	27975004	PRJNA1111146_P_NODE_375485_length_181_cov_0.859375_g374347_i0	PRJNA1111146	375485	181	0.859375	1.55546875	root	1	Root_unresolved	Root_unresolved	59.7	1.71e-8	NR	TMW62163.1	41045	g374347	i0	52	14.6850828729282	50	24	82.9	0	150	1	250	299	TMW62163.1 hypothetical protein Poli38472_009656 [Pythium oligandrum]	diamond	2658	59.7	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Pythiales	Pythiaceae	Pythium	Pythium oligandrum
28606451	28606451	PRJNA1111146_P_NODE_282067_length_190_cov_1.635036_g280929_i0	PRJNA1111146	282067	190	1.635036	3.1065684	root	1	Root_unresolved	Root_unresolved	50.1	4.93e-5	NR	XP_067784514.1	4785	g280929	i0	60	3.50526315789474	35	14	55.3	0	86	190	835	869	XP_067784514.1 Retrovirus-related Pol polyprotein from transposon TNT 1-94 [Phytophthora cinnamomi]	diamond	666	50.4	0.994047619047619	Eukaryota	Sar	Oomycota	Peronosporomycetes	Peronosporales	Peronosporaceae	Phytophthora	Phytophthora cinnamomi
29143551	29143551	PRJNA1111146_P_NODE_439389_length_177_cov_0.895161_g438251_i0	PRJNA1111146	439389	177	0.895161	1.58443497	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	44.7	0.00328	NR	KAF4134196.1	4787	g438251	i0	51.4	2.35593220338983	35	13	52.5	1	99	7	268	302	KAF4134196.1 hypothetical protein GN958_ATG16577, partial [Phytophthora infestans]	diamond	417	44.7	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Peronosporales	Peronosporaceae	Phytophthora	Phytophthora infestans
32154275	32154275	PRJNA1111146_P_NODE_343698_length_183_cov_0.861538_g342560_i0	PRJNA1111146	343698	183	0.861538	1.57661454	Hyaloperonospora brassicae	162125	SAR_Eukaryotes	SAR_Eukaryotes	43.5	0.00915	NR	CAI5708662.1	162125	g342560	i0	79.2	0.39344262295082	24	5	39.3	0	87	16	209	232	CAI5708662.1 unnamed protein product [Hyaloperonospora brassicae]	diamond	72	43.5	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Peronosporales	Peronosporaceae	Hyaloperonospora	Hyaloperonospora brassicae
32185982	32185982	PRJNA1111146_P_NODE_415298_length_178_cov_0.912000_g414160_i0	PRJNA1111146	415298	178	0.912	1.62336	Phytophthora megakarya	4795	SAR_Eukaryotes	SAR_Eukaryotes	57.4	1.31e-8	NR	OWZ00869.1	4795	g414160	i0	54.5	7.65168539325843	55	24	92.7	1	12	176	71	124	OWZ00869.1 hypothetical protein PHMEG_00027849 [Phytophthora megakarya]	diamond	1362	57.4	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Peronosporales	Peronosporaceae	Phytophthora	Phytophthora megakarya

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