metadata: contig_metadata: 10 rows where bioproject = "PRJDB14274" and tax

10 rows where bioproject = "PRJDB14274" 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
980943	980943	PRJDB14274_S_NODE_6481_length_248_cov_1.101604_g6403_i0	PRJDB14274	6481	248	1.101604	2.73197792	Oomycota	4762	SAR_Eukaryotes	SAR_Eukaryotes	178	3.5499999999999993e-40	NTclustered	gi\|59894163\|gb\|AY729864.1\|	74557	g6403	i0	79.918	27.5604838709677	244	47	98	2	6	248	958	1200	Thraustotheca clavata heat shock protein 90 gene, partial cds	blastn	6835	178	1	Eukaryota	Sar	Oomycota	Saprolegniomycetes	Saprolegniales	Achlyaceae	Thraustotheca	Thraustotheca clavata
6386870	6386870	PRJDB14274_S_NODE_8926_length_212_cov_1.483444_g8848_i0	PRJDB14274	8926	212	1.483444	3.14490128	Aphanomyces astaci	112090	SAR_Eukaryotes	SAR_Eukaryotes	52.8	0.019	NTclustered	gi\|698803785\|ref\|XM_009836620.1\|	112090	g8848	i0	96.774	0.14622641509434	31	1	15	0	84	114	963	993	Aphanomyces astaci hypothetical protein mRNA	blastn	31	52.8	1	Eukaryota	Sar	Oomycota	Saprolegniomycetes	Saprolegniales	Verrucalvaceae	Aphanomyces	Aphanomyces astaci
16585361	16585361	PRJDB14274_S_NODE_1994_length_431_cov_2.789189_g1916_i0	PRJDB14274	1994	431	2.789189	12.02140459	Aphanomyces astaci	112090	SAR_Eukaryotes	SAR_Eukaryotes	244	6.39e-60	NTclustered	gi\|698807229\|ref\|XM_009838342.1\|	112090	g1916	i0	80.119	66.0719257540603	337	59	77	4	102	431	441	106	Aphanomyces astaci polyubiquitin mRNA	blastn	28477	244	1	Eukaryota	Sar	Oomycota	Saprolegniomycetes	Saprolegniales	Verrucalvaceae	Aphanomyces	Aphanomyces astaci
17860386	17860386	PRJDB14274_S_NODE_3895_length_311_cov_1.332000_g3817_i0	PRJDB14274	3895	311	1.332	4.14252	Phytophthora cinnamomi	4785	SAR_Eukaryotes	SAR_Eukaryotes	165	3.58e-36	NTclustered	gi\|2795048880\|ref\|XM_067943659.1\|	4785	g3817	i0	76.623	4.79742765273312	308	67	98	4	1	304	415	109	Phytophthora cinnamomi Calmodulin (IUM83_18649), partial mRNA	blastn	1492	165	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Peronosporales	Peronosporaceae	Phytophthora	Phytophthora cinnamomi
20107487	20107487	PRJDB14274_S_NODE_2736_length_370_cov_2.307443_g2658_i0	PRJDB14274	2736	370	2.307443	8.5375391	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	215	4.24e-51	NTclustered	gi\|673019759\|ref\|XM_008865619.1\|	157072	g2658	i0	79.734	20.6486486486486	301	57	81	4	5	303	184	482	Aphanomyces invadans 40S ribosomal protein S23 mRNA	blastn	7640	217	0.990783410138249	Eukaryota	Sar	Oomycota	Saprolegniomycetes	Saprolegniales	Verrucalvaceae	Aphanomyces	Aphanomyces invadans
28447930	28447930	PRJDB14274_S_NODE_2226_length_410_cov_2.042980_g2148_i0	PRJDB14274	2226	410	2.04298	8.376218	Oomycota	4762	SAR_Eukaryotes	SAR_Eukaryotes	94.7	8.97e-22	NR	KAE8911393.1	53985	g2148	i0	53.2	2.68536585365854	94	33	62.2	3	409	155	48	139	KAE8911393.1 hypothetical protein PF003_g4481 [Phytophthora fragariae]	diamond	1101	95.5	0.991623036649215	Eukaryota	Sar	Oomycota	Peronosporomycetes	Peronosporales	Peronosporaceae	Phytophthora	Phytophthora fragariae
29237189	29237189	PRJDB14274_S_NODE_1529_length_493_cov_2.893519_g1452_i0	PRJDB14274	1529	493	2.893519	14.26504867	Oomycota	4762	SAR_Eukaryotes	SAR_Eukaryotes	161	4.62e-43	NR	XP_024573476.1	4781	g1452	i0	64.7	8.3184584178499	116	41	70.6	0	7	354	533	648	XP_024573476.1 dead deah box helicase [Plasmopara halstedii]	diamond	4101	162	0.993827160493827	Eukaryota	Sar	Oomycota	Peronosporomycetes	Peronosporales	Peronosporaceae	Plasmopara	Plasmopara halstedii
32681604	32681604	PRJDB14274_S_NODE_7020_length_239_cov_1.393258_g6942_i0	PRJDB14274	7020	239	1.393258	3.32988662	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	45.1	7.97e-4	NR	OQR86152.1	1202772	g6942	i0	61.3	0.803347280334728	31	12	38.9	0	15	107	55	85	OQR86152.1 hypothetical protein ACHHYP_10924 [Achlya hypogyna]	diamond	192	45.1	1	Eukaryota	Sar	Oomycota	Saprolegniomycetes	Saprolegniales	Achlyaceae	Achlya	Achlya hypogyna
32750736	32750736	PRJDB14274_S_NODE_8780_length_214_cov_1.535948_g8702_i0	PRJDB14274	8780	214	1.535948	3.28692872	Phytophthora infestans T3	4787	SAR_Eukaryotes	SAR_Eukaryotes	115	6.1499999999999986e-28	NR	XP_002997683.1	403677	g8702	i0	79.7	3.86915887850467	69	14	96.7	0	6	212	146	214	XP_002997683.1 aconitate hydratase, mitochondrial precursor [Phytophthora infestans T30-4]	diamond	828	115	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Peronosporales	Peronosporaceae	Phytophthora	Phytophthora infestans
32782025	32782025	PRJDB14274_S_NODE_5920_length_258_cov_1.203046_g5842_i0	PRJDB14274	5920	258	1.203046	3.10385868	Thraustotheca clavata	74557	SAR_Eukaryotes	SAR_Eukaryotes	75.1	5.91e-14	NR	OQS02109.1	74557	g5842	i0	56.4	3.77906976744186	78	16	90.7	2	24	257	20	79	OQS02109.1 60S ribosomal protein L7a-2 [Thraustotheca clavata]	diamond	975	75.1	1	Eukaryota	Sar	Oomycota	Saprolegniomycetes	Saprolegniales	Achlyaceae	Thraustotheca	Thraustotheca clavata

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