metadata: contig_metadata: 7 rows where analysis = "diamond", bioproject = "PRJNA575566" and tax

7 rows where analysis = "diamond", bioproject = "PRJNA575566" 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
23512469	23512469	PRJNA575566_P_NODE_2619_length_640_cov_2.906736_g2429_i0	PRJNA575566	2619	640	2.906736	18.6031104	root	1	Root_unresolved	Root_unresolved	111	8.43e-27	NR	NP_037602.1	4787	g2429	i0	69.7	14.9390625	66	20	30.9	0	553	356	115	180	NP_037602.1 NADH dehydrogenase subunit 9 [Phytophthora infestans]	diamond	9561	112	0.991071428571429	Eukaryota	Sar	Oomycota	Peronosporomycetes	Peronosporales	Peronosporaceae	Phytophthora	Phytophthora infestans
26604464	26604464	PRJNA575566_P_NODE_17701_length_250_cov_1.693122_g17504_i0	PRJNA575566	17701	250	1.693122	4.232805	Aphanomyces stellatus	120398	SAR_Eukaryotes	SAR_Eukaryotes	62.8	3.17e-9	NR	KAF0690082.1	120398	g17504	i0	43.2	0.888	74	42	88.8	0	29	250	19	92	KAF0690082.1 hypothetical protein As57867_018414 [Aphanomyces stellatus]	diamond	222	62.8	1	Eukaryota	Sar	Oomycota	Saprolegniomycetes	Saprolegniales	Verrucalvaceae	Aphanomyces	Aphanomyces stellatus
27819837	27819837	PRJNA575566_P_NODE_25964_length_207_cov_0.876712_g25767_i0	PRJNA575566	25964	207	0.876712	1.81479384	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	102	2.5599999999999998e-23	NR	CAI5729819.1	86335	g25767	i0	77	9.01449275362319	61	14	88.4	0	184	2	450	510	CAI5729819.1 unnamed protein product [Peronospora destructor]	diamond	1866	103	0.990291262135922	Eukaryota	Sar	Oomycota	Peronosporomycetes	Peronosporales	Peronosporaceae	Peronospora	Peronospora destructor
28229819	28229819	PRJNA575566_P_NODE_14546_length_276_cov_1.190698_g14349_i0	PRJNA575566	14546	276	1.190698	3.28632648	Peronosporomycetes	3418804	SAR_Eukaryotes	SAR_Eukaryotes	53.5	3.26e-6	NR	YP_010394262.1	4786	g14349	i0	42.4	3.32608695652174	59	34	64.1	0	54	230	18	76	YP_010394262.1 ribosomal protein L5 [Phytophthora cryptogea]	diamond	918	53.5	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Peronosporales	Peronosporaceae	Phytophthora	Phytophthora cryptogea
29240521	29240521	PRJNA575566_P_NODE_29689_length_201_cov_0.914286_g29492_i0	PRJNA575566	29689	201	0.914286	1.83771486	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	43.1	0.0163	NR	OQR89803.1	74557	g29492	i0	32	2.85074626865672	75	40	95.5	2	201	10	512	586	OQR89803.1 hypothetical protein THRCLA_09572 [Thraustotheca clavata]	diamond	573	43.5	0.990804597701149	Eukaryota	Sar	Oomycota	Saprolegniomycetes	Saprolegniales	Achlyaceae	Thraustotheca	Thraustotheca clavata
29745411	29745411	PRJNA575566_P_NODE_12670_length_295_cov_1.094017_g12473_i0	PRJNA575566	12670	295	1.094017	3.22735015	Peronosporomycetes	3418804	SAR_Eukaryotes	SAR_Eukaryotes	43.5	0.0383	NR	KAF1332378.1	82926	g12473	i0	29.3	1.83050847457627	92	53	89.5	3	2	265	812	895	KAF1332378.1 Heat shock 70 kda protein, partial [Globisporangium splendens]	diamond	540	43.5	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Pythiales	Pythiaceae	Globisporangium	Globisporangium splendens
31375245	31375245	PRJNA575566_P_NODE_24476_length_209_cov_0.864865_g24279_i0	PRJNA575566	24476	209	0.864865	1.80756785	Phytophthora fragariae	53985	SAR_Eukaryotes	SAR_Eukaryotes	63.2	1.51e-9	NR	KAE9166247.1	53985	g24279	i0	44.4	3.61722488038277	63	35	90.4	0	11	199	763	825	KAE9166247.1 ABC transporter G family member 36 [Phytophthora fragariae]	diamond	756	63.2	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Peronosporales	Peronosporaceae	Phytophthora	Phytophthora fragariae

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