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

8 rows where bioproject = "PRJNA773247", 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
27306304	27306304	PRJNA773247_P_NODE_20523_length_316_cov_1.251029_g20439_i0	PRJNA773247	20523	316	1.251029	3.95325164	Pythium insidiosum	114742	SAR_Eukaryotes	SAR_Eukaryotes	124	1.48e-33	NR	GLD98056.1	114742	g20439	i0	66.3	0.873417721518987	92	30	86.4	1	2	274	93	184	GLD98056.1 hypothetical protein PINS_up006753 [Pythium insidiosum]	diamond	276	124	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Pythiales	Pythiaceae	Pythium	Pythium insidiosum
28326002	28326002	PRJNA773247_P_NODE_3166_length_1086_cov_27.430405_g3105_i0	PRJNA773247	3166	1086	27.430405	297.8941983	Peronosporaceae	4777	SAR_Eukaryotes	SAR_Eukaryotes	177	3.94e-49	NR	POM62048.1	4796	g3105	i0	64.5	4.41160220994475	124	44	34.3	0	496	867	164	287	POM62048.1 RNA-binding protein [Phytophthora palmivora]	diamond	4791	178	0.99438202247191	Eukaryota	Sar	Oomycota	Peronosporomycetes	Peronosporales	Peronosporaceae	Phytophthora	Phytophthora palmivora
28443068	28443068	PRJNA773247_P_NODE_14806_length_387_cov_3.213376_g14722_i0	PRJNA773247	14806	387	3.213376	12.43576512	Pythium oligandrum	41045	SAR_Eukaryotes	SAR_Eukaryotes	59.3	3.17e-7	NR	TMW55127.1	41045	g14722	i0	38.8	0.89922480620155	116	58	84.5	4	48	374	2420	2529	TMW55127.1 hypothetical protein Poli38472_013889 [Pythium oligandrum]	diamond	348	59.3	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Pythiales	Pythiaceae	Pythium	Pythium oligandrum
28452626	28452626	PRJNA773247_P_NODE_15686_length_373_cov_7.220000_g15602_i0	PRJNA773247	15686	373	7.22	26.9306	Peronosporomycetes	3418804	SAR_Eukaryotes	SAR_Eukaryotes	77.4	1.26e-13	NR	DBA00161.1	4803	g15602	i0	36.8	2.29222520107239	133	70	95.7	3	367	11	795	927	DBA00161.1 TPA: hypothetical protein N0F65_007786 [Lagenidium giganteum]	diamond	855	77.8	0.994858611825193	Eukaryota	Sar	Oomycota	Peronosporomycetes	Pythiales	Pythiaceae	Lagenidium	Lagenidium giganteum
28831234	28831234	PRJNA773247_P_NODE_22748_length_296_cov_3.982063_g22664_i0	PRJNA773247	22748	296	3.982063	11.78690648	Phytophthora	4783	SAR_Eukaryotes	SAR_Eukaryotes	66.2	4.06e-10	NR	ETK87403.1	4792	g22664	i0	43	14.8175675675676	86	42	87.2	1	7	264	4955	5033	ETK87403.1 hypothetical protein L915_08162 [Phytophthora nicotianae]	diamond	4386	66.2	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Peronosporales	Peronosporaceae	Phytophthora	Phytophthora nicotianae
30179556	30179556	PRJNA773247_P_NODE_21652_length_305_cov_4.547414_g21568_i0	PRJNA773247	21652	305	4.547414	13.8696127	Saprolegnia diclina VS2	112098	SAR_Eukaryotes	SAR_Eukaryotes	92.8	5.83e-20	NR	XP_008606331.1	1156394	g21568	i0	51.1	0.904918032786885	92	45	90.5	0	295	20	137	228	XP_008606331.1 hypothetical protein SDRG_02515 [Saprolegnia diclina VS20]	diamond	276	92.8	1	Eukaryota	Sar	Oomycota	Saprolegniomycetes	Saprolegniales	Saprolegniaceae	Saprolegnia	Saprolegnia diclina
30495785	30495785	PRJNA773247_P_NODE_16533_length_360_cov_5.923345_g16449_i0	PRJNA773247	16533	360	5.923345	21.324042	Globisporangium splendens	82926	SAR_Eukaryotes	SAR_Eukaryotes	87.4	3.3e-17	NR	KAF1328387.1	82926	g16449	i0	51.8	2.775	83	40	69.2	0	2	250	593	675	KAF1328387.1 Phosphatidylinositol kinase, partial [Globisporangium splendens]	diamond	999	87.4	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Pythiales	Pythiaceae	Globisporangium	Globisporangium splendens
30653448	30653448	PRJNA773247_P_NODE_11393_length_458_cov_1.979221_g11310_i0	PRJNA773247	11393	458	1.979221	9.06483218	Pythium insidiosum	114742	SAR_Eukaryotes	SAR_Eukaryotes	169	3.779999999999999e-48	NR	GLD96801.1	114742	g11310	i0	67.2	1.5589519650655	119	39	77.9	0	94	450	245	363	GLD96801.1 hypothetical protein PINS_up005484 [Pythium insidiosum]	diamond	714	169	1	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);;