metadata: contig_metadata: 11 rows where bioproject = "PRJNA889065" and tax

11 rows where bioproject = "PRJNA889065" 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
9791232	9791232	PRJNA889065_S_NODE_13108_length_266_cov_2.914798_g12870_i0	PRJNA889065	13108	266	2.9147979999999998	7.75336268	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	102	5.99e-25	NR	KAK1947371.1	4793	g12870	i0	77.8	7.10526315789474	63	14	71.1	0	265	77	123	185	KAK1947371.1 60S ribosomal protein L23a [Phytophthora citrophthora]	diamond	1890	103	0.990291262135922	Eukaryota	Sar	Oomycota	Peronosporomycetes	Peronosporales	Peronosporaceae	Phytophthora	Phytophthora citrophthora
11445992	11445992	PRJNA889065_S_NODE_23929_length_199_cov_1.179487_g23691_i0	PRJNA889065	23929	199	1.179487	2.34717913	Aphanomyces	100860	SAR_Eukaryotes	SAR_Eukaryotes	368	1.51e-97	NTclustered	gi\|1923460172\|gb\|MW187638.1\|	1125843	g23691	i0	100	101.015075376884	199	0	100	0	1	199	245	443	Aphanomyces sinensis isolate CCRJB_22 small subunit ribosomal RNA gene, partial sequence; mitochondrial	blastn	20102	368	1	Eukaryota	Sar	Oomycota	Saprolegniomycetes	Saprolegniales	Verrucalvaceae	Aphanomyces	Aphanomyces sinensis
19093661	19093661	PRJNA889065_S_NODE_175_length_1291_cov_5.836538_g137_i0	PRJNA889065	175	1291	5.836538	75.34970558	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	211	2.06e-49	NTclustered	gi\|937408816\|ref\|NC_027966.1\|	114742	g137	i0	79.739	25.5267234701782	306	51	23	10	799	1098	10097	9797	Pythium insidiosum mitochondrial DNA, complete genome	blastn	32955	213	0.990610328638498	Eukaryota	Sar	Oomycota	Peronosporomycetes	Pythiales	Pythiaceae	Pythium	Pythium insidiosum
26651599	26651599	PRJNA889065_S_NODE_15781_length_244_cov_3.631841_g15543_i0	PRJNA889065	15781	244	3.631841	8.86169204	Viridiplantae	33090	SAR_Eukaryotes	SAR_Eukaryotes	97.8	3.11e-22	NR	KAG9404282.1	112091	g15543	i0	69.7	2.4344262295082	66	20	81.1	0	243	46	258	323	KAG9404282.1 Guanine nucleotide-binding protein subunit beta-2-like 1 [Aphanomyces cochlioides]	diamond	594	97.8	1	Eukaryota	Sar	Oomycota	Saprolegniomycetes	Saprolegniales	Verrucalvaceae	Aphanomyces	Aphanomyces cochlioides
26865955	26865955	PRJNA889065_S_NODE_6041_length_383_cov_6.747059_g5803_i0	PRJNA889065	6041	383	6.747059	25.84123597	Aphanomyces astaci	112090	SAR_Eukaryotes	SAR_Eukaryotes	68.9	8.89e-11	NR	RHY25281.1	112090	g5803	i0	50.8	4.06527415143603	61	28	46.2	1	1	177	260	320	RHY25281.1 hypothetical protein DYB25_005061 [Aphanomyces astaci]	diamond	1557	68.9	1	Eukaryota	Sar	Oomycota	Saprolegniomycetes	Saprolegniales	Verrucalvaceae	Aphanomyces	Aphanomyces astaci
27118464	27118464	PRJNA889065_S_NODE_23782_length_199_cov_2.653846_g23544_i0	PRJNA889065	23782	199	2.653846	5.28115354	Phytophthora infestans	4787	SAR_Eukaryotes	SAR_Eukaryotes	53.1	4.19e-6	NR	KAF4038965.1	4787	g23544	i0	51.9	0.814070351758794	54	25	79.9	1	41	199	108	161	KAF4038965.1 DNA/RNA non-specific endonuclease [Phytophthora infestans]	diamond	162	53.1	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Peronosporales	Peronosporaceae	Phytophthora	Phytophthora infestans
28073977	28073977	PRJNA889065_S_NODE_26905_length_187_cov_1.451389_g26667_i0	PRJNA889065	26905	187	1.451389	2.71409743	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	55.1	7.97e-7	NR	CCI10304.1	65357	g26667	i0	51.9	2.48663101604278	52	25	83.4	0	157	2	555	606	CCI10304.1 unnamed protein product [Albugo candida]	diamond	465	55.1	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Albuginales	Albuginaceae	Albugo	Albugo candida
29052998	29052998	PRJNA889065_S_NODE_10208_length_299_cov_4.472656_g9970_i0	PRJNA889065	10208	299	4.472656	13.37324144	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	106	3.28e-24	NR	TMW65930.1	41045	g9970	i0	48.9	11.3177257525084	94	48	94.3	0	297	16	228	321	TMW65930.1 hypothetical protein Poli38472_003695 [Pythium oligandrum]	diamond	3384	106	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Pythiales	Pythiaceae	Pythium	Pythium oligandrum
29116159	29116159	PRJNA889065_S_NODE_24468_length_196_cov_2.921569_g24230_i0	PRJNA889065	24468	196	2.921569	5.72627524	Peronosporaceae	4777	SAR_Eukaryotes	SAR_Eukaryotes	80.1	1.24e-16	NR	XP_024584861.1	4781	g24230	i0	73.3	10.3010204081633	45	12	68.9	0	1	135	137	181	XP_024584861.1 adp-ribosylation factor [Plasmopara halstedii]	diamond	2019	80.1	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Peronosporales	Peronosporaceae	Plasmopara	Plasmopara halstedii
31066775	31066775	PRJNA889065_S_NODE_27355_length_185_cov_1.943662_g27117_i0	PRJNA889065	27355	185	1.943662	3.5957747	Saprolegnia diclina VS2	112098	SAR_Eukaryotes	SAR_Eukaryotes	68.2	1.84e-11	NR	XP_008615048.1	1156394	g27117	i0	79.5	1.23243243243243	39	8	63.2	0	7	123	623	661	XP_008615048.1 hypothetical protein SDRG_10814 [Saprolegnia diclina VS20]	diamond	228	68.2	1	Eukaryota	Sar	Oomycota	Saprolegniomycetes	Saprolegniales	Saprolegniaceae	Saprolegnia	Saprolegnia diclina
31612033	31612033	PRJNA889065_S_NODE_33256_length_166_cov_1.731707_g33018_i0	PRJNA889065	33256	166	1.731707	2.87463362	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	94.7	3.17e-21	NR	KAF0714835.1	120398	g33018	i0	86.5	5.63855421686747	52	7	94	0	1	156	343	394	KAF0714835.1 hypothetical protein As57867_003645 [Aphanomyces stellatus]	diamond	936	95.5	0.991623036649215	Eukaryota	Sar	Oomycota	Saprolegniomycetes	Saprolegniales	Verrucalvaceae	Aphanomyces	Aphanomyces stellatus

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