metadata: contig_metadata: 7 rows where bioproject = "PRJNA854078", tax_clade = "Sar" and tax

7 rows where bioproject = "PRJNA854078", 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
21243732	21243732	PRJNA854078_P_NODE_12437_length_267_cov_1.020619_g12225_i0	PRJNA854078	12437	267	1.020619	2.72505273	Pythium insidiosum	114742	SAR_Eukaryotes	SAR_Eukaryotes	70.1	1.08e-11	NR	GLD99222.1	114742	g12225	i0	50.9	5.89887640449438	55	26	60.7	1	41	202	130	184	GLD99222.1 hypothetical protein PINS_up007940 [Pythium insidiosum]	diamond	1575	70.1	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Pythiales	Pythiaceae	Pythium	Pythium insidiosum
25067746	25067746	PRJNA854078_P_NODE_11640_length_276_cov_1.517241_g11428_i0	PRJNA854078	11640	276	1.517241	4.18758516	Aphanomyces invadans	157072	SAR_Eukaryotes	SAR_Eukaryotes	100	8.94e-17	NTclustered	gi\|673049800\|ref\|XM_008880639.1\|	157072	g11428	i0	82.203	16.1775362318841	118	19	42	2	1	117	1064	1180	Aphanomyces invadans actin mRNA	blastn	4465	100	1	Eukaryota	Sar	Oomycota	Saprolegniomycetes	Saprolegniales	Verrucalvaceae	Aphanomyces	Aphanomyces invadans
26936588	26936588	PRJNA854078_P_NODE_4762_length_435_cov_1.930939_g4550_i0	PRJNA854078	4762	435	1.930939	8.39958465	Saprolegniales	4763	SAR_Eukaryotes	SAR_Eukaryotes	164	1.6e-45	NR	AIG55528.1	74557	g4550	i0	54.5	3	145	63	100	1	1	435	119	260	AIG55528.1 secreted protein [Thraustotheca clavata]	diamond	1305	164	1	Eukaryota	Sar	Oomycota	Saprolegniomycetes	Saprolegniales	Achlyaceae	Thraustotheca	Thraustotheca clavata
27442738	27442738	PRJNA854078_P_NODE_16763_length_240_cov_2.029940_g16551_i0	PRJNA854078	16763	240	2.02994	4.871856	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	55.5	1.01e-6	NR	CCI50355.1	65357	g16551	i0	46.3	2.0125	80	42	98.8	1	239	3	33	112	CCI50355.1 unnamed protein product [Albugo candida]	diamond	483	55.5	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Albuginales	Albuginaceae	Albugo	Albugo candida
28002820	28002820	PRJNA854078_P_NODE_15085_length_247_cov_0.885057_g14873_i0	PRJNA854078	15085	247	0.885057	2.18609079	Pythium oligandrum	41045	SAR_Eukaryotes	SAR_Eukaryotes	81.6	5.16e-16	NR	TMW66198.1	41045	g14873	i0	45.7	3.93522267206478	81	44	98.4	0	247	5	256	336	TMW66198.1 hypothetical protein Poli38472_003963 [Pythium oligandrum]	diamond	972	81.6	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Pythiales	Pythiaceae	Pythium	Pythium oligandrum
29526436	29526436	PRJNA854078_P_NODE_10710_length_288_cov_1.074419_g10498_i0	PRJNA854078	10710	288	1.074419	3.09432672	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	79.7	6.5e-15	NR	OQS03426.1	74557	g10498	i0	44.8	2.9375	96	52	100	1	288	1	231	325	OQS03426.1 mitogen-activated protein kinase [Thraustotheca clavata]	diamond	846	79.7	1	Eukaryota	Sar	Oomycota	Saprolegniomycetes	Saprolegniales	Achlyaceae	Thraustotheca	Thraustotheca clavata
31959767	31959767	PRJNA854078_P_NODE_5937_length_387_cov_12.640127_g5725_i0	PRJNA854078	5937	387	12.640127	48.91729149	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	149	6.799999999999998e-44	NR	XP_067794467.1	4785	g5725	i0	68.6	9.06976744186047	105	33	81.4	0	30	344	2	106	XP_067794467.1 60S ribosomal protein L30 [Phytophthora cinnamomi]	diamond	3510	150	0.993333333333333	Eukaryota	Sar	Oomycota	Peronosporomycetes	Peronosporales	Peronosporaceae	Phytophthora	Phytophthora cinnamomi

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