metadata: contig_metadata: 9 rows where bioproject = "PRJNA694770" and tax

9 rows where bioproject = "PRJNA694770" 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
4503805	4503805	PRJNA694770_P_NODE_89124_length_246_cov_0.890173_g88830_i0	PRJNA694770	89124	246	0.890173	2.18982558	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	152	1.4999999999999999e-40	NR	DBA03661.1	4803	g88830	i0	84	143.231707317073	81	13	98.8	0	245	3	662	742	DBA03661.1 TPA: hypothetical protein N0F65_006840 [Lagenidium giganteum]	diamond	35235	153	0.993464052287582	Eukaryota	Sar	Oomycota	Peronosporomycetes	Pythiales	Pythiaceae	Lagenidium	Lagenidium giganteum
7558073	7558073	PRJNA694770_P_NODE_26506_length_380_cov_1.293160_g26212_i0	PRJNA694770	26506	380	1.29316	4.914008	root	1	Root_unresolved	Root_unresolved	686	0	NTclustered	gi\|166044642\|emb\|CU367551.1\|	100861	g26212	i0	99.211	100.097368421053	380	3	100	0	1	380	317	696	Aphanomyces euteiches cDNA	blastn	38037	691	0.992764109985528	Eukaryota	Sar	Oomycota	Saprolegniomycetes	Saprolegniales	Verrucalvaceae	Aphanomyces	Aphanomyces euteiches
15978261	15978261	PRJNA694770_P_NODE_81273_length_250_cov_0.870056_g80979_i0	PRJNA694770	81273	250	0.870056	2.17514	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	70.9	3.29e-12	NR	CCA20669.1	890382	g80979	i0	43.2	3.888	81	45	97.2	1	1	243	173	252	CCA20669.1 lipase putative [Albugo laibachii Nc14]	diamond	972	70.9	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Albuginales	Albuginaceae	Albugo	Albugo laibachii
15978496	15978496	PRJNA694770_P_NODE_89313_length_246_cov_0.890173_g89019_i0	PRJNA694770	89313	246	0.890173	2.18982558	Albugo laibachii	653948	SAR_Eukaryotes	SAR_Eukaryotes	392	1.15e-104	NTclustered	gi\|325194231\|emb\|FR825088.1\|	890382	g89019	i0	95.528	1.49186991869919	246	10	100	1	1	246	1289	1045	Albugo laibachii Nc14, genomic contig CONTIG_1612_NC14_v4_1853_85	blastn	367	392	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Albuginales	Albuginaceae	Albugo	Albugo laibachii
20306980	20306980	PRJNA694770_P_NODE_44036_length_314_cov_1.278008_g43742_i0	PRJNA694770	44036	314	1.278008	4.01294512	root	1	Root_unresolved	Root_unresolved	508	1.45e-139	NTclustered	gi\|166044588\|emb\|CU367497.1\|	100861	g43742	i0	95.86	73.5700636942675	314	13	100	0	1	314	32	345	Aphanomyces euteiches cDNA	blastn	23101	508	1	Eukaryota	Sar	Oomycota	Saprolegniomycetes	Saprolegniales	Verrucalvaceae	Aphanomyces	Aphanomyces euteiches
21582933	21582933	PRJNA694770_P_NODE_50917_length_294_cov_2.248869_g50623_i0	PRJNA694770	50917	294	2.248869	6.61167486	root	1	Root_unresolved	Root_unresolved	544	3.69e-150	NTclustered	gi\|166046790\|emb\|CU367365.1\|	100861	g50623	i0	100	14.9795918367347	294	0	100	0	1	294	798	505	Aphanomyces euteiches cDNA	blastn	4404	544	1	Eukaryota	Sar	Oomycota	Saprolegniomycetes	Saprolegniales	Verrucalvaceae	Aphanomyces	Aphanomyces euteiches
22858277	22858277	PRJNA694770_P_NODE_60618_length_279_cov_1.092233_g60324_i0	PRJNA694770	60618	279	1.092233	3.04733007	root	1	Root_unresolved	Root_unresolved	468	2.15e-127	NTclustered	gi\|166044639\|emb\|CU367548.1\|	100861	g60324	i0	97.445	69.8530465949821	274	7	98	0	1	274	391	118	Aphanomyces euteiches cDNA	blastn	19489	468	1	Eukaryota	Sar	Oomycota	Saprolegniomycetes	Saprolegniales	Verrucalvaceae	Aphanomyces	Aphanomyces euteiches
29387976	29387976	PRJNA694770_P_NODE_24469_length_392_cov_0.830721_g24175_i0	PRJNA694770	24469	392	0.830721	3.25642632	Phytophthora cactorum	29920	SAR_Eukaryotes	SAR_Eukaryotes	43.1	0.0292	NR	RAW34949.1	29920	g24175	i0	34.3	0.512755102040816	67	36	45.2	2	379	203	40	106	RAW34949.1 hypothetical protein PC110_g8746 [Phytophthora cactorum]	diamond	201	43.1	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Peronosporales	Peronosporaceae	Phytophthora	Phytophthora cactorum
30125279	30125279	PRJNA694770_P_NODE_66452_length_270_cov_0.857868_g66158_i0	PRJNA694770	66452	270	0.857868	2.3162436	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	64.3	1.36e-9	NR	TMW65555.1	41045	g66158	i0	65.1	11.133333333333301	43	15	47.8	0	142	270	397	439	TMW65555.1 hypothetical protein Poli38472_008197 [Pythium oligandrum]	diamond	3006	64.7	0.993817619783617	Eukaryota	Sar	Oomycota	Peronosporomycetes	Pythiales	Pythiaceae	Pythium	Pythium oligandrum

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