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

7 rows where bioproject = "PRJNA1253303", 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
27326718	27326718	PRJNA1253303_P_NODE_6143_length_249_cov_0.886364_g6121_i0	PRJNA1253303	6143	249	0.886364	2.20704636	Phytophthora capsici	4784	SAR_Eukaryotes	SAR_Eukaryotes	57.4	2.14e-8	NR	KAG1684115.1	4784	g6121	i0	36.6	0.987951807228916	82	51	98.8	1	248	3	10	90	KAG1684115.1 hypothetical protein DVH05_011859 [Phytophthora capsici]	diamond	246	57.4	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Peronosporales	Peronosporaceae	Phytophthora	Phytophthora capsici
27706007	27706007	PRJNA1253303_P_NODE_8064_length_243_cov_0.917647_g8042_i0	PRJNA1253303	8064	243	0.917647	2.22988221	Pythium insidiosum	114742	SAR_Eukaryotes	SAR_Eukaryotes	45.4	0.00443	NR	GLD91835.1	114742	g8042	i0	37.3	1.45679012345679	59	37	72.8	0	34	210	1143	1201	GLD91835.1 hypothetical protein PINS_up000368 [Pythium insidiosum]	diamond	354	45.4	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Pythiales	Pythiaceae	Pythium	Pythium insidiosum
28165588	28165588	PRJNA1253303_P_NODE_3965_length_278_cov_1.395122_g3943_i0	PRJNA1253303	3965	278	1.395122	3.87843916	Phytophthora	4783	SAR_Eukaryotes	SAR_Eukaryotes	57.4	1.08e-7	NR	KAJ8562019.1	4785	g3943	i0	40.7	2.62230215827338	81	45	85.3	2	237	1	39	118	KAJ8562019.1 hypothetical protein ON010_g7656 [Phytophthora cinnamomi]	diamond	729	57.4	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Peronosporales	Peronosporaceae	Phytophthora	Phytophthora cinnamomi
28842139	28842139	PRJNA1253303_P_NODE_4028_length_276_cov_1.536946_g4006_i0	PRJNA1253303	4028	276	1.536946	4.24197096	Phytophthora cinnamomi	4785	SAR_Eukaryotes	SAR_Eukaryotes	45.8	0.00436	NR	XP_067800426.1	4785	g4006	i0	35.2	1.3695652173913	54	35	58.7	0	258	97	24	77	XP_067800426.1 uncharacterized protein IUM83_06441 [Phytophthora cinnamomi]	diamond	378	45.8	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Peronosporales	Peronosporaceae	Phytophthora	Phytophthora cinnamomi
29775682	29775682	PRJNA1253303_P_NODE_6451_length_248_cov_0.891429_g6429_i0	PRJNA1253303	6451	248	0.891429	2.21074392	Oomycota	4762	SAR_Eukaryotes	SAR_Eukaryotes	127	1.6e-33	NR	TMW67214.1	41045	g6429	i0	76.8	12.8951612903226	82	19	99.2	0	247	2	57	138	TMW67214.1 hypothetical protein Poli38472_012330 [Pythium oligandrum]	diamond	3198	128	0.9921875	Eukaryota	Sar	Oomycota	Peronosporomycetes	Pythiales	Pythiaceae	Pythium	Pythium oligandrum
31084877	31084877	PRJNA1253303_P_NODE_6555_length_248_cov_0.891429_g6533_i0	PRJNA1253303	6555	248	0.891429	2.21074392	Pythium insidiosum	114742	SAR_Eukaryotes	SAR_Eukaryotes	113	2.69e-28	NR	KAJ0398756.1	114742	g6533	i0	69.5	2.9758064516129	82	25	99.2	0	247	2	104	185	KAJ0398756.1 hypothetical protein P43SY_009824 [Pythium insidiosum]	diamond	738	113	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Pythiales	Pythiaceae	Pythium	Pythium insidiosum
32665912	32665912	PRJNA1253303_P_NODE_4640_length_259_cov_1.419355_g4618_i0	PRJNA1253303	4640	259	1.419355	3.67612945	Phytophthora aleatoria	2496075	SAR_Eukaryotes	SAR_Eukaryotes	88.2	4.68e-18	NR	KAG6977701.1	2496075	g4618	i0	62.3	1.83011583011583	77	28	89.2	1	259	29	488	563	KAG6977701.1 hypothetical protein JG688_00000060 [Phytophthora aleatoria]	diamond	474	88.2	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Peronosporales	Peronosporaceae	Phytophthora	Phytophthora aleatoria

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