metadata: contig_metadata: 10 rows where analysis = "diamond", bioproject = "PRJNA1198392" and tax

10 rows where analysis = "diamond", bioproject = "PRJNA1198392" 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
10528244	10528244	PRJNA1198392_P_NODE_11789_length_273_cov_2.290000_g11648_i0	PRJNA1198392	11789	273	2.29	6.2517	Oomycota	4762	SAR_Eukaryotes	SAR_Eukaryotes	120	1.78e-29	NR	XP_067797348.1	4785	g11648	i0	62.2	27.6923076923077	90	30	98.9	2	3	272	486	571	XP_067797348.1 dynein intermediate chain 2 [Phytophthora cinnamomi]	diamond	7560	121	0.991735537190083	Eukaryota	Sar	Oomycota	Peronosporomycetes	Peronosporales	Peronosporaceae	Phytophthora	Phytophthora cinnamomi
26755815	26755815	PRJNA1198392_P_NODE_20501_length_242_cov_1.822485_g20360_i0	PRJNA1198392	20501	242	1.822485	4.4104137	Aphanomyces stellatus	120398	SAR_Eukaryotes	SAR_Eukaryotes	94.7	1.88e-20	NR	KAF0719334.1	120398	g20360	i0	62.2	10.0661157024793	74	28	91.7	0	242	21	1465	1538	KAF0719334.1 hypothetical protein As57867_001117 [Aphanomyces stellatus]	diamond	2436	94.7	1	Eukaryota	Sar	Oomycota	Saprolegniomycetes	Saprolegniales	Verrucalvaceae	Aphanomyces	Aphanomyces stellatus
26914255	26914255	PRJNA1198392_P_NODE_8742_length_288_cov_1.432558_g8601_i0	PRJNA1198392	8742	288	1.432558	4.12576704	Aphanomyces stellatus	120398	SAR_Eukaryotes	SAR_Eukaryotes	57	5.98e-7	NR	KAF0690680.1	120398	g8601	i0	39.8	1.125	108	45	96.9	4	281	3	416	518	KAF0690680.1 hypothetical protein As57867_017873 [Aphanomyces stellatus]	diamond	324	57	1	Eukaryota	Sar	Oomycota	Saprolegniomycetes	Saprolegniales	Verrucalvaceae	Aphanomyces	Aphanomyces stellatus
27186069	27186069	PRJNA1198392_P_NODE_10902_length_278_cov_1.502439_g10761_i0	PRJNA1198392	10902	278	1.502439	4.17678042	Phytophthora	4783	SAR_Eukaryotes	SAR_Eukaryotes	105	6.909999999999998e-24	NR	KUF86458.1	4792	g10761	i0	52.2	22.3057553956835	92	44	99.3	0	1	276	569	660	KUF86458.1 ATP-binding Cassette (ABC) superfamily [Phytophthora nicotianae]	diamond	6201	105	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Peronosporales	Peronosporaceae	Phytophthora	Phytophthora nicotianae
30325837	30325837	PRJNA1198392_P_NODE_11032_length_277_cov_1.838235_g10891_i0	PRJNA1198392	11032	277	1.838235	5.09191095	Aphanomyces stellatus	120398	SAR_Eukaryotes	SAR_Eukaryotes	196	9.45e-58	NR	KAF0700649.1	120398	g10891	i0	95.7	3.985559566787	92	4	99.6	0	1	276	457	548	KAF0700649.1 hypothetical protein As57867_008792 [Aphanomyces stellatus]	diamond	1104	196	1	Eukaryota	Sar	Oomycota	Saprolegniomycetes	Saprolegniales	Verrucalvaceae	Aphanomyces	Aphanomyces stellatus
30894181	30894181	PRJNA1198392_P_NODE_20114_length_243_cov_0.905882_g19973_i0	PRJNA1198392	20114	243	0.905882	2.20129326	Aphanomyces invadans	157072	SAR_Eukaryotes	SAR_Eukaryotes	127	2.42e-34	NR	RHY35304.1	157072	g19973	i0	73.4	0.975308641975309	79	21	97.5	0	241	5	126	204	RHY35304.1 hypothetical protein DYB32_000196 [Aphanomyces invadans]	diamond	237	127	1	Eukaryota	Sar	Oomycota	Saprolegniomycetes	Saprolegniales	Verrucalvaceae	Aphanomyces	Aphanomyces invadans
31368340	31368340	PRJNA1198392_P_NODE_11696_length_274_cov_1.527363_g11555_i0	PRJNA1198392	11696	274	1.527363	4.18497462	Aphanomyces astaci	112090	SAR_Eukaryotes	SAR_Eukaryotes	65.9	4.02e-10	NR	RHY89022.1	112090	g11555	i0	43.1	1.90510948905109	102	45	97.4	5	272	6	2129	2230	RHY89022.1 hypothetical protein DYB35_008116 [Aphanomyces astaci]	diamond	522	65.9	1	Eukaryota	Sar	Oomycota	Saprolegniomycetes	Saprolegniales	Verrucalvaceae	Aphanomyces	Aphanomyces astaci
31431331	31431331	PRJNA1198392_P_NODE_19956_length_243_cov_1.811765_g19815_i0	PRJNA1198392	19956	243	1.811765	4.40258895	Albugo laibachii Nc14	890382	SAR_Eukaryotes	SAR_Eukaryotes	130	7.150000000000001e-36	NR	CCA22399.1	890382	g19815	i0	79.7	5.82716049382716	79	16	97.5	0	241	5	41	119	CCA22399.1 40S ribosomal protein S82 putative [Albugo laibachii Nc14]	diamond	1416	130	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Albuginales	Albuginaceae	Albugo	Albugo laibachii
31513812	31513812	PRJNA1198392_P_NODE_21256_length_241_cov_0.916667_g21115_i0	PRJNA1198392	21256	241	0.916667	2.20916747	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	43.5	0.0185	NR	KAI9914150.1	230839	g21115	i0	74.2	7.03319502074689	31	8	38.6	0	1	93	262	292	KAI9914150.1 hypothetical protein PsorP6_005752 [Peronosclerospora sorghi]	diamond	1695	43.5	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Peronosporales	Peronosporaceae	Peronosclerospora	Peronosclerospora sorghi
32159118	32159118	PRJNA1198392_P_NODE_20418_length_243_cov_0.905882_g20277_i0	PRJNA1198392	20418	243	0.905882	2.20129326	Lagenidium giganteum	4803	SAR_Eukaryotes	SAR_Eukaryotes	106	1.25e-24	NR	DBA03770.1	4803	g20277	i0	63.5	0.91358024691358	74	26	91.4	1	243	22	588	660	DBA03770.1 TPA: hypothetical protein N0F65_005660 [Lagenidium giganteum]	diamond	222	106	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Pythiales	Pythiaceae	Lagenidium	Lagenidium giganteum

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