metadata: contig_metadata: 18 rows where bioproject = "PRJNA1002816", tax_clade = "Sar" and tax

18 rows where bioproject = "PRJNA1002816", 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
7805410	7805410	PRJNA1002816_P_NODE_17127_length_255_cov_1.269231_g16967_i0	PRJNA1002816	17127	255	1.269231	3.23653905	Hyaloperonospora parasitica	123356	SAR_Eukaryotes	SAR_Eukaryotes	52.8	0.023	NTclustered	gi\|187468407\|emb\|CU855855.1\|	123356	g16967	i0	100	0.109803921568627	28	0	11	0	176	203	107949	107976	H.parasitica DNA sequence from clone HpEmoy2-17E12, complete sequence	blastn	28	52.8	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Peronosporales	Peronosporaceae	Hyaloperonospora	Hyaloperonospora parasitica
10356004	10356004	PRJNA1002816_P_NODE_15249_length_278_cov_1.014634_g15089_i0	PRJNA1002816	15249	278	1.014634	2.82068252	Oomycota	4762	SAR_Eukaryotes	SAR_Eukaryotes	79	5.87e-15	NR	OQR90378.1	1202772	g15089	i0	45.1	3.92805755395683	91	49	98.2	1	6	278	118	207	OQR90378.1 Non-selective Cation Channel-2 (NSCC2) Family [Achlya hypogyna]	diamond	1092	79.3	0.996216897856242	Eukaryota	Sar	Oomycota	Saprolegniomycetes	Saprolegniales	Achlyaceae	Achlya	Achlya hypogyna
11631615	11631615	PRJNA1002816_P_NODE_8850_length_377_cov_3.539474_g8690_i0	PRJNA1002816	8850	377	3.539474	13.34381698	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	77	2.27e-15	NR	DBA03679.1	4803	g8690	i0	61.3	3.59681697612732	62	24	49.3	0	35	220	1	62	DBA03679.1 TPA: hypothetical protein N0F65_004096 [Lagenidium giganteum]	diamond	1356	77	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Pythiales	Pythiaceae	Lagenidium	Lagenidium giganteum
16729668	16729668	PRJNA1002816_P_NODE_10954_length_336_cov_1.266160_g10794_i0	PRJNA1002816	10954	336	1.26616	4.2542976	Phytophthora palmivora	4796	SAR_Eukaryotes	SAR_Eukaryotes	243	1.75e-59	NTclustered	gi\|2026389858\|gb\|MT032128.1\|	4796	g10794	i0	80.122	70.2440476190476	327	63	97	2	1	326	13682	14007	Phytophthora palmivora mitochondrion, complete genome	blastn	23602	243	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Peronosporales	Peronosporaceae	Phytophthora	Phytophthora palmivora
16729748	16729748	PRJNA1002816_P_NODE_14894_length_282_cov_1.162679_g14734_i0	PRJNA1002816	14894	282	1.162679	3.27875478	Aphanomyces astaci	112090	SAR_Eukaryotes	SAR_Eukaryotes	254	6.64e-63	NTclustered	gi\|698815387\|ref\|XM_009842421.1\|	112090	g14734	i0	87.054	71.3794326241135	224	29	79	0	59	282	64	287	Aphanomyces astaci actin mRNA	blastn	20129	254	1	Eukaryota	Sar	Oomycota	Saprolegniomycetes	Saprolegniales	Verrucalvaceae	Aphanomyces	Aphanomyces astaci
18004666	18004666	PRJNA1002816_P_NODE_20735_length_241_cov_1.035714_g20575_i0	PRJNA1002816	20735	241	1.035714	2.49607074	Saprolegnia parasitica	101203	SAR_Eukaryotes	SAR_Eukaryotes	93.5	1.28e-14	NTclustered	gi\|813156946\|ref\|XM_012346432.1\|	695850	g20575	i0	93.548	35.850622406639	62	4	26	0	15	76	136	75	Saprolegnia parasitica CBS 223.65 histone H2B partial mRNA	blastn	8640	93.5	1	Eukaryota	Sar	Oomycota	Saprolegniomycetes	Saprolegniales	Saprolegniaceae	Saprolegnia	Saprolegnia parasitica
25227076	25227076	PRJNA1002816_P_NODE_15120_length_279_cov_1.490291_g14960_i0	PRJNA1002816	15120	279	1.490291	4.15791189	Saprolegnia	4769	SAR_Eukaryotes	SAR_Eukaryotes	159	1.47e-34	NTclustered	gi\|813156379\|ref\|XM_012346149.1\|	695850	g14960	i0	83.237	3.56989247311828	173	29	62	0	107	279	439	267	Saprolegnia parasitica CBS 223.65 hypothetical protein mRNA	blastn	996	159	1	Eukaryota	Sar	Oomycota	Saprolegniomycetes	Saprolegniales	Saprolegniaceae	Saprolegnia	Saprolegnia parasitica
27002601	27002601	PRJNA1002816_P_NODE_5742_length_474_cov_1.114713_g5582_i0	PRJNA1002816	5742	474	1.114713	5.28373962	Aphanomyces astaci	112090	SAR_Eukaryotes	SAR_Eukaryotes	127	8.4e-31	NR	RHY64856.1	112090	g5582	i0	44.6	10.1962025316456	148	77	91.8	2	31	465	408	553	RHY64856.1 hypothetical protein DYB34_006549 [Aphanomyces astaci]	diamond	4833	127	1	Eukaryota	Sar	Oomycota	Saprolegniomycetes	Saprolegniales	Verrucalvaceae	Aphanomyces	Aphanomyces astaci
27406526	27406526	PRJNA1002816_P_NODE_18663_length_248_cov_0.880000_g18503_i0	PRJNA1002816	18663	248	0.88	2.1824	Peronosporomycetes	3418804	SAR_Eukaryotes	SAR_Eukaryotes	118	4.29e-31	NR	KAG3111330.1	53986	g18503	i0	73.8	12.241935483871	80	20	96.8	1	4	243	104	182	KAG3111330.1 hypothetical protein PI125_g9222 [Phytophthora idaei]	diamond	3036	118	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Peronosporales	Peronosporaceae	Phytophthora	Phytophthora idaei
27792724	27792724	PRJNA1002816_P_NODE_17504_length_251_cov_0.865169_g17344_i0	PRJNA1002816	17504	251	0.865169	2.17157419	Albugo laibachii Nc14	890382	SAR_Eukaryotes	SAR_Eukaryotes	77.8	1.85e-14	NR	CCA25279.1	890382	g17344	i0	47.6	3.9203187250996	82	43	98	0	247	2	466	547	CCA25279.1 conserved hypothetical protein [Albugo laibachii Nc14]	diamond	984	77.8	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Albuginales	Albuginaceae	Albugo	Albugo laibachii
27816934	27816934	PRJNA1002816_P_NODE_12944_length_307_cov_2.081197_g12784_i0	PRJNA1002816	12944	307	2.081197	6.38927479	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	151	1.1599999999999999e-43	NR	KAL0590341.1	65357	g12784	i0	72.5	20.9315960912052	102	28	99.7	0	307	2	36	137	KAL0590341.1 hypothetical protein ABG067_001587 [Albugo candida]	diamond	6426	151	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Albuginales	Albuginaceae	Albugo	Albugo candida
28353454	28353454	PRJNA1002816_P_NODE_16506_length_262_cov_1.597884_g16346_i0	PRJNA1002816	16506	262	1.597884	4.18645608	Saprolegniales	4763	SAR_Eukaryotes	SAR_Eukaryotes	104	1.0099999999999999e-23	NR	OQS03538.1	74557	g16346	i0	53.1	8.43893129770992	81	38	92.7	0	248	6	500	580	OQS03538.1 hypothetical protein THRCLA_04144, partial [Thraustotheca clavata]	diamond	2211	104	1	Eukaryota	Sar	Oomycota	Saprolegniomycetes	Saprolegniales	Achlyaceae	Thraustotheca	Thraustotheca clavata
28739833	28739833	PRJNA1002816_P_NODE_18507_length_248_cov_0.880000_g18347_i0	PRJNA1002816	18507	248	0.88	2.1824	Thraustotheca clavata	74557	SAR_Eukaryotes	SAR_Eukaryotes	109	2.14e-27	NR	OQS05478.1	74557	g18347	i0	68.3	5.92741935483871	82	26	99.2	0	248	3	133	214	OQS05478.1 40S ribosomal protein S3-3 [Thraustotheca clavata]	diamond	1470	109	1	Eukaryota	Sar	Oomycota	Saprolegniomycetes	Saprolegniales	Achlyaceae	Thraustotheca	Thraustotheca clavata
29521703	29521703	PRJNA1002816_P_NODE_15930_length_270_cov_0.827411_g15770_i0	PRJNA1002816	15930	270	0.827411	2.2340097	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	43.1	0.0222	NR	KAG1698619.1	4784	g15770	i0	47.6	1.5	42	20	44.4	1	270	151	6	47	KAG1698619.1 hypothetical protein DVH05_014577 [Phytophthora capsici]	diamond	405	43.1	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Peronosporales	Peronosporaceae	Phytophthora	Phytophthora capsici
30343496	30343496	PRJNA1002816_P_NODE_19752_length_244_cov_0.900585_g19592_i0	PRJNA1002816	19752	244	0.900585	2.1974274	Aphanomyces	100860	SAR_Eukaryotes	SAR_Eukaryotes	106	1.24e-24	NR	RHY08398.1	112090	g19592	i0	76.3	2.80327868852459	76	18	93.4	0	232	5	6	81	RHY08398.1 hypothetical protein DYB25_006691, partial [Aphanomyces astaci]	diamond	684	107	0.990654205607477	Eukaryota	Sar	Oomycota	Saprolegniomycetes	Saprolegniales	Verrucalvaceae	Aphanomyces	Aphanomyces astaci
30848534	30848534	PRJNA1002816_P_NODE_18954_length_247_cov_0.885057_g18794_i0	PRJNA1002816	18954	247	0.885057	2.18609079	Peronosporaceae	4777	SAR_Eukaryotes	SAR_Eukaryotes	87.8	1.77e-18	NR	XP_067822579.1	4779	g18794	i0	55.7	5.69635627530364	79	35	96	0	238	2	18	96	XP_067822579.1 hypothetical protein CCR75_003707 [Bremia lactucae]	diamond	1407	87.8	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Peronosporales	Peronosporaceae	Bremia	Bremia lactucae
31544067	31544067	PRJNA1002816_P_NODE_20536_length_242_cov_0.911243_g20376_i0	PRJNA1002816	20536	242	0.911243	2.20520806	root	1	Root_unresolved	Root_unresolved	50.4	7.09e-5	NR	TMW65114.1	41045	g20376	i0	35.9	1.8595041322314	78	46	96.7	2	242	9	593	666	TMW65114.1 hypothetical protein Poli38472_009281 [Pythium oligandrum]	diamond	450	50.8	0.992125984251969	Eukaryota	Sar	Oomycota	Peronosporomycetes	Pythiales	Pythiaceae	Pythium	Pythium oligandrum
32152513	32152513	PRJNA1002816_P_NODE_15478_length_275_cov_1.396040_g15318_i0	PRJNA1002816	15478	275	1.39604	3.83911	Albugo candida	65357	SAR_Eukaryotes	SAR_Eukaryotes	68.2	2.37e-12	NR	KAL0592358.1	65357	g15318	i0	40.5	1.72363636363636	79	43	86.2	1	273	37	40	114	KAL0592358.1 hypothetical protein ABG067_000466 [Albugo candida]	diamond	474	68.2	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);;