metadata: contig_metadata: 9 rows where bioproject = "PRJNA1263632", tax_clade = "Sar" and tax

9 rows where bioproject = "PRJNA1263632", tax_clade = "Sar" 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
5467041	5467041	PRJNA1263632_P_NODE_4205_length_303_cov_1.686957_g4187_i0	PRJNA1263632	4205	303	1.686957	5.11147971	Oomycota	4762	SAR_Eukaryotes	SAR_Eukaryotes	171	1.09e-49	NR	OQS04692.1	74557	g4187	i0	84.2	24	101	16	100	0	303	1	10	110	OQS04692.1 aspartyl/Asparaginyl beta-hydroxylase [Thraustotheca clavata]	diamond	7272	172	0.994186046511628	Eukaryota	Sar	Oomycota	Saprolegniomycetes	Saprolegniales	Achlyaceae	Thraustotheca	Thraustotheca clavata
8017038	8017038	PRJNA1263632_P_NODE_2547_length_381_cov_1.483766_g2529_i0	PRJNA1263632	2547	381	1.483766	5.65314846	Aphanomyces astaci	112090	SAR_Eukaryotes	SAR_Eukaryotes	259	1.99e-64	NTclustered	gi\|698807229\|ref\|XM_009838342.1\|	112090	g2529	i0	80.112	82.6692913385827	357	63	92	4	31	380	441	86	Aphanomyces astaci polyubiquitin mRNA	blastn	31497	259	1	Eukaryota	Sar	Oomycota	Saprolegniomycetes	Saprolegniales	Verrucalvaceae	Aphanomyces	Aphanomyces astaci
10567713	10567713	PRJNA1263632_P_NODE_1049_length_583_cov_1.327451_g1031_i0	PRJNA1263632	1049	583	1.327451	7.73903933	Peronosporomycetes	3418804	SAR_Eukaryotes	SAR_Eukaryotes	296	1.82e-99	NR	KAG1694345.1	4784	g1031	i0	71.4	6.65351629502573	185	53	95.2	0	29	583	1	185	KAG1694345.1 40S ribosomal protein S4 [Phytophthora capsici]	diamond	3879	296	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Peronosporales	Peronosporaceae	Phytophthora	Phytophthora capsici
15666642	15666642	PRJNA1263632_P_NODE_5213_length_277_cov_1.122549_g5195_i0	PRJNA1263632	5213	277	1.122549	3.10946073	Peronosporomycetes	3418804	SAR_Eukaryotes	SAR_Eukaryotes	149	1.1399999999999996e-43	NR	CCI48174.1	65357	g5195	i0	77.2	11.7942238267148	92	21	99.6	0	2	277	11	102	CCI48174.1 unnamed protein product [Albugo candida]	diamond	3267	149	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Albuginales	Albuginaceae	Albugo	Albugo candida
20765350	20765350	PRJNA1263632_P_NODE_6857_length_249_cov_0.875000_g6839_i0	PRJNA1263632	6857	249	0.875	2.17875	Thraustotheca clavata	74557	SAR_Eukaryotes	SAR_Eukaryotes	143	1.28e-39	NR	OQR97649.1	74557	g6839	i0	85.4	13.8313253012048	82	12	98.8	0	2	247	86	167	OQR97649.1 malate dehydrogenase, mitochondrial precursor [Thraustotheca clavata]	diamond	3444	143	1	Eukaryota	Sar	Oomycota	Saprolegniomycetes	Saprolegniales	Achlyaceae	Thraustotheca	Thraustotheca clavata
28102284	28102284	PRJNA1263632_P_NODE_5605_length_268_cov_1.184615_g5587_i0	PRJNA1263632	5605	268	1.184615	3.1747682	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	92.4	1.69e-19	NR	AOW41676.1	4803	g5587	i0	49.4	1.90298507462687	89	44	99.6	1	268	2	359	446	AOW41676.1 glycoside hydrolase 20 [Lagenidium giganteum]	diamond	510	92.4	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Pythiales	Pythiaceae	Lagenidium	Lagenidium giganteum
28937195	28937195	PRJNA1263632_P_NODE_6808_length_249_cov_0.875000_g6790_i0	PRJNA1263632	6808	249	0.875	2.17875	Phytophthora ramorum	164328	SAR_Eukaryotes	SAR_Eukaryotes	73.9	4.28e-13	NR	KAL4144622.1	164328	g6790	i0	45.1	1.72289156626506	71	36	85.5	1	249	37	987	1054	KAL4144622.1 hypothetical protein PRNP1_013751 [Phytophthora ramorum]	diamond	429	73.9	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Peronosporales	Peronosporaceae	Phytophthora	Phytophthora ramorum
29631427	29631427	PRJNA1263632_P_NODE_3790_length_318_cov_2.820408_g3772_i0	PRJNA1263632	3790	318	2.820408	8.96889744	Thraustotheca clavata	74557	SAR_Eukaryotes	SAR_Eukaryotes	176	1.33e-51	NR	OQR91137.1	74557	g3772	i0	79	2.97169811320755	105	22	99.1	0	317	3	2	106	OQR91137.1 60S ribosomal protein L3 [Thraustotheca clavata]	diamond	945	176	1	Eukaryota	Sar	Oomycota	Saprolegniomycetes	Saprolegniales	Achlyaceae	Thraustotheca	Thraustotheca clavata
29852843	29852843	PRJNA1263632_P_NODE_3691_length_322_cov_1.855422_g3673_i0	PRJNA1263632	3691	322	1.855422	5.97445884	Albugo candida	65357	SAR_Eukaryotes	SAR_Eukaryotes	45.8	0.00748	NR	CCI42232.1	65357	g3673	i0	37.3	0.959627329192547	59	36	55	1	36	212	95	152	CCI42232.1 unnamed protein product [Albugo candida]	diamond	309	45.8	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Albuginales	Albuginaceae	Albugo	Albugo candida

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