metadata: contig_metadata: 8 rows where bioproject = "PRJNA976345", tax_clade = "Sar" and tax

8 rows where bioproject = "PRJNA976345", 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
14976877	14976877	PRJNA976345_P_NODE_97712_length_191_cov_2.576923_g96104_i0	PRJNA976345	97712	191	2.576923	4.92192293	Phytophthora	4783	SAR_Eukaryotes	SAR_Eukaryotes	58.5	2.96e-8	NR	KAG2762856.1	29920	g96104	i0	42.4	10.1937172774869	59	34	92.7	0	177	1	108	166	KAG2762856.1 hypothetical protein Pcac1_g25383 [Phytophthora cactorum]	diamond	1947	58.9	0.99320882852292	Eukaryota	Sar	Oomycota	Peronosporomycetes	Peronosporales	Peronosporaceae	Phytophthora	Phytophthora cactorum
21350592	21350592	PRJNA976345_P_NODE_45537_length_257_cov_2.738739_g43929_i0	PRJNA976345	45537	257	2.738739	7.03855923	Saprolegnia parasitica	101203	SAR_Eukaryotes	SAR_Eukaryotes	159	1.3399999999999996e-34	NTclustered	gi\|813189934\|ref\|XM_012352177.1\|	695850	g43929	i0	79.825	2.16731517509728	228	39	87	6	11	233	606	381	Saprolegnia parasitica CBS 223.65 40S ribosomal protein S7 mRNA	blastn	557	159	1	Eukaryota	Sar	Oomycota	Saprolegniomycetes	Saprolegniales	Saprolegniaceae	Saprolegnia	Saprolegnia parasitica
22625602	22625602	PRJNA976345_P_NODE_47118_length_254_cov_1.246575_g45510_i0	PRJNA976345	47118	254	1.246575	3.1663005	Phytophthora nicotianae	4792	SAR_Eukaryotes	SAR_Eukaryotes	169	2.19e-37	NTclustered	gi\|675163068\|ref\|XM_008892171.1\|	761204	g45510	i0	80	0.905511811023622	230	44	90	2	25	253	1466	1238	Phytophthora parasitica INRA-310 protoporphyrinogen oxidase partial mRNA	blastn	230	169	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Peronosporales	Peronosporaceae	Phytophthora	Phytophthora nicotianae
28043004	28043004	PRJNA976345_P_NODE_162665_length_161_cov_2.198413_g161057_i0	PRJNA976345	162665	161	2.198413	3.53944493	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	42	0.00603	NR	OQS05078.1	74557	g161057	i0	52.4	3.80124223602484	42	18	78.3	1	34	159	18	57	OQS05078.1 hypothetical protein THRCLA_20722 [Thraustotheca clavata]	diamond	612	42.4	0.990566037735849	Eukaryota	Sar	Oomycota	Saprolegniomycetes	Saprolegniales	Achlyaceae	Thraustotheca	Thraustotheca clavata
28832254	28832254	PRJNA976345_P_NODE_195168_length_151_cov_1.612069_g193560_i0	PRJNA976345	195168	151	1.612069	2.43422419	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	50.1	2.64e-5	NR	KAH9100875.1	100861	g193560	i0	60	4.27152317880795	35	14	69.5	0	143	39	93	127	KAH9100875.1 hypothetical protein Ae201684P_007066 [Aphanomyces euteiches]	diamond	645	50.4	0.994047619047619	Eukaryota	Sar	Oomycota	Saprolegniomycetes	Saprolegniales	Verrucalvaceae	Aphanomyces	Aphanomyces euteiches
29305879	29305879	PRJNA976345_P_NODE_28909_length_314_cov_1.731183_g27304_i0	PRJNA976345	28909	314	1.731183	5.43591462	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	107	3.9799999999999998e-25	NR	CCI42781.1	65357	g27304	i0	57.5	4.20382165605096	87	37	83.1	0	2	262	323	409	CCI42781.1 unnamed protein product [Albugo candida]	diamond	1320	108	0.990740740740741	Eukaryota	Sar	Oomycota	Peronosporomycetes	Albuginales	Albuginaceae	Albugo	Albugo candida
29678326	29678326	PRJNA976345_P_NODE_27730_length_320_cov_2.287719_g26126_i0	PRJNA976345	27730	320	2.287719	7.3207008	Aphanomyces stellatus	120398	SAR_Eukaryotes	SAR_Eukaryotes	85.1	3.39e-17	NR	KAF0697845.1	120398	g26126	i0	42.3	0.975	104	59	96.6	1	313	5	15	118	KAF0697845.1 hypothetical protein As57867_011456 [Aphanomyces stellatus]	diamond	312	85.1	1	Eukaryota	Sar	Oomycota	Saprolegniomycetes	Saprolegniales	Verrucalvaceae	Aphanomyces	Aphanomyces stellatus
31137826	31137826	PRJNA976345_P_NODE_61335_length_227_cov_5.244792_g59727_i0	PRJNA976345	61335	227	5.244792	11.90567784	root	1	Root_unresolved	Root_unresolved	63.5	7.04e-10	NR	KAJ0405509.1	114742	g59727	i0	47.1	2.7488986784141	68	36	89.9	0	21	224	126	193	KAJ0405509.1 hypothetical protein P43SY_011357 [Pythium insidiosum]	diamond	624	63.9	0.993740219092332	Eukaryota	Sar	Oomycota	Peronosporomycetes	Pythiales	Pythiaceae	Pythium	Pythium insidiosum

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