metadata: contig_metadata: 16 rows where bioproject = "PRJNA675331", tax_clade = "Sar" and tax

16 rows where bioproject = "PRJNA675331", 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
5751353	5751353	PRJNA675331_P_NODE_5705_length_402_cov_1.118541_g5533_i0	PRJNA675331	5705	402	1.118541	4.49653482	Aphanomyces invadans	157072	SAR_Eukaryotes	SAR_Eukaryotes	268	3.52e-67	NTclustered	gi\|673042664\|ref\|XM_008877071.1\|	157072	g5533	i0	82.468	40.9179104477612	308	52	76	2	96	402	492	186	Aphanomyces invadans ubiquitin-40S ribosomal protein S27a mRNA	blastn	16449	268	1	Eukaryota	Sar	Oomycota	Saprolegniomycetes	Saprolegniales	Verrucalvaceae	Aphanomyces	Aphanomyces invadans
7026393	7026393	PRJNA675331_P_NODE_18006_length_251_cov_1.162921_g17834_i0	PRJNA675331	18006	251	1.162921	2.91893171	Pythium insidiosum	114742	SAR_Eukaryotes	SAR_Eukaryotes	147	2.26e-40	NR	KAJ0401849.1	114742	g17834	i0	81.7	3.9203187250996	82	15	98	0	248	3	334	415	KAJ0401849.1 hypothetical protein P43SY_007783 [Pythium insidiosum]	diamond	984	147	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Pythiales	Pythiaceae	Pythium	Pythium insidiosum
7546420	7546420	PRJNA675331_P_NODE_16386_length_262_cov_1.343915_g16214_i0	PRJNA675331	16386	262	1.343915	3.5210573	Peronosporomycetes	3418804	SAR_Eukaryotes	SAR_Eukaryotes	132	7.79e-34	NR	KAI9994381.1	4787	g16214	i0	73.3	22.5114503816794	86	22	98.5	1	259	2	400	484	KAI9994381.1 hypothetical protein PInf_010991 [Phytophthora infestans]	diamond	5898	132	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Peronosporales	Peronosporaceae	Phytophthora	Phytophthora infestans
12127060	12127060	PRJNA675331_P_NODE_18650_length_250_cov_0.870056_g18478_i0	PRJNA675331	18650	250	0.870056	2.17514	Thraustotheca clavata	74557	SAR_Eukaryotes	SAR_Eukaryotes	62	6.47e-9	NR	OQR88751.1	74557	g18478	i0	47	2.988	83	39	99.6	2	249	1	104	181	OQR88751.1 hypothetical protein THRCLA_10124 [Thraustotheca clavata]	diamond	747	62	1	Eukaryota	Sar	Oomycota	Saprolegniomycetes	Saprolegniales	Achlyaceae	Thraustotheca	Thraustotheca clavata
18499985	18499985	PRJNA675331_P_NODE_13795_length_277_cov_1.132353_g13623_i0	PRJNA675331	13795	277	1.132353	3.13661781	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	140	2.26e-37	NR	OQS06767.1	74557	g13623	i0	66.7	35.8375451263538	90	30	97.5	0	271	2	214	303	OQS06767.1 seryl-tRNA synthetase [Thraustotheca clavata]	diamond	9927	140	1	Eukaryota	Sar	Oomycota	Saprolegniomycetes	Saprolegniales	Achlyaceae	Thraustotheca	Thraustotheca clavata
19774628	19774628	PRJNA675331_P_NODE_22396_length_244_cov_0.900585_g22224_i0	PRJNA675331	22396	244	0.900585	2.1974274	Thraustotheca clavata	74557	SAR_Eukaryotes	SAR_Eukaryotes	108	2.64e-25	NR	OQR97897.1	74557	g22224	i0	72.5	3.39344262295082	69	19	84.8	0	208	2	633	701	OQR97897.1 phosphatidylinositol-4-phosphate-5-kinase (Pi-PIPK-D2) [Thraustotheca clavata]	diamond	828	108	1	Eukaryota	Sar	Oomycota	Saprolegniomycetes	Saprolegniales	Achlyaceae	Thraustotheca	Thraustotheca clavata
22845947	22845947	PRJNA675331_P_NODE_23618_length_242_cov_0.911243_g23446_i0	PRJNA675331	23618	242	0.911243	2.20520806	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	115	1.2200000000000002e-27	NR	KAJ8569432.1	4785	g23446	i0	64.6	11.7520661157025	79	28	97.9	0	239	3	501	579	KAJ8569432.1 hypothetical protein ON010_g5828 [Phytophthora cinnamomi]	diamond	2844	116	0.991379310344828	Eukaryota	Sar	Oomycota	Peronosporomycetes	Peronosporales	Peronosporaceae	Phytophthora	Phytophthora cinnamomi
26606895	26606895	PRJNA675331_P_NODE_5381_length_413_cov_1.132353_g5209_i0	PRJNA675331	5381	413	1.132353	4.67661789	Thraustotheca clavata	74557	SAR_Eukaryotes	SAR_Eukaryotes	52	1.39e-4	NR	OQR87035.1	74557	g5209	i0	38.8	1.08232445520581	67	35	48.7	2	24	224	149	209	OQR87035.1 thrombospondin [Thraustotheca clavata]	diamond	447	52	1	Eukaryota	Sar	Oomycota	Saprolegniomycetes	Saprolegniales	Achlyaceae	Thraustotheca	Thraustotheca clavata
28672866	28672866	PRJNA675331_P_NODE_15347_length_269_cov_1.372449_g15175_i0	PRJNA675331	15347	269	1.372449	3.69188781	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	57.4	2.9e-7	NR	KAH9137962.1	100861	g15175	i0	43.5	9.9368029739777	69	37	77	1	216	10	111	177	KAH9137962.1 hypothetical protein AeRB84_017580 [Aphanomyces euteiches]	diamond	2673	57.4	1	Eukaryota	Sar	Oomycota	Saprolegniomycetes	Saprolegniales	Verrucalvaceae	Aphanomyces	Aphanomyces euteiches
28850199	28850199	PRJNA675331_P_NODE_22988_length_243_cov_0.905882_g22816_i0	PRJNA675331	22988	243	0.905882	2.20129326	Phytophthora cinnamomi	4785	SAR_Eukaryotes	SAR_Eukaryotes	62.8	3.27e-9	NR	KAJ8571916.1	4785	g22816	i0	41.8	2.92592592592593	79	36	97.5	2	5	241	235	303	KAJ8571916.1 hypothetical protein ON010_g4918 [Phytophthora cinnamomi]	diamond	711	62.8	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Peronosporales	Peronosporaceae	Phytophthora	Phytophthora cinnamomi
29292385	29292385	PRJNA675331_P_NODE_21749_length_245_cov_0.895349_g21577_i0	PRJNA675331	21749	245	0.895349	2.19360505	Aphanomyces stellatus	120398	SAR_Eukaryotes	SAR_Eukaryotes	61.2	1.14e-8	NR	KAF0715838.1	120398	g21577	i0	50	0.612244897959184	50	25	61.2	0	151	2	83	132	KAF0715838.1 hypothetical protein As57867_003139 [Aphanomyces stellatus]	diamond	150	61.2	1	Eukaryota	Sar	Oomycota	Saprolegniomycetes	Saprolegniales	Verrucalvaceae	Aphanomyces	Aphanomyces stellatus
29841029	29841029	PRJNA675331_P_NODE_7051_length_365_cov_1.431507_g6879_i0	PRJNA675331	7051	365	1.431507	5.22500055	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	114	1.14e-26	NR	KAJ8578504.1	4785	g6879	i0	44.5	16.6438356164384	119	63	97.8	1	359	3	437	552	KAJ8578504.1 hypothetical protein ON010_g699 [Phytophthora cinnamomi]	diamond	6075	114	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Peronosporales	Peronosporaceae	Phytophthora	Phytophthora cinnamomi
31155812	31155812	PRJNA675331_P_NODE_23035_length_243_cov_0.905882_g22863_i0	PRJNA675331	23035	243	0.905882	2.20129326	Peronosclerospora sorghi	230839	SAR_Eukaryotes	SAR_Eukaryotes	84.3	8.27e-17	NR	KAI9921555.1	230839	g22863	i0	51.8	3.08641975308642	83	37	98.8	1	241	2	386	468	KAI9921555.1 hypothetical protein PsorP6_000365 [Peronosclerospora sorghi]	diamond	750	84.3	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Peronosporales	Peronosporaceae	Peronosclerospora	Peronosclerospora sorghi
31579244	31579244	PRJNA675331_P_NODE_7416_length_357_cov_1.084507_g7244_i0	PRJNA675331	7416	357	1.084507	3.87168999	Peronosporomycetes	3418804	SAR_Eukaryotes	SAR_Eukaryotes	79	2.86e-14	NR	XP_024579952.1	4781	g7244	i0	41.9	3.01680672268908	117	62	95.8	3	2	343	984	1097	XP_024579952.1 importin-like protein [Plasmopara halstedii]	diamond	1077	79	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Peronosporales	Peronosporaceae	Plasmopara	Plasmopara halstedii
31883509	31883509	PRJNA675331_P_NODE_14897_length_272_cov_1.160804_g14725_i0	PRJNA675331	14897	272	1.160804	3.15738688	Lagenidium giganteum	4803	SAR_Eukaryotes	SAR_Eukaryotes	71.2	4.6e-12	NR	DAZ96141.1	4803	g14725	i0	44	1.00367647058824	91	50	99.3	1	272	3	77	167	DAZ96141.1 TPA: hypothetical protein N0F65_008720 [Lagenidium giganteum]	diamond	273	71.2	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Pythiales	Pythiaceae	Lagenidium	Lagenidium giganteum
32642318	32642318	PRJNA675331_P_NODE_22420_length_244_cov_0.900585_g22248_i0	PRJNA675331	22420	244	0.900585	2.1974274	Phytophthora sojae	67593	SAR_Eukaryotes	SAR_Eukaryotes	43.5	0.0197	NR	XP_009522124.1	67593	g22248	i0	38.2	0.836065573770492	68	40	83.6	1	206	3	619	684	XP_009522124.1 hypothetical protein PHYSODRAFT_496155 [Phytophthora sojae]	diamond	204	43.5	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Peronosporales	Peronosporaceae	Phytophthora	Phytophthora sojae

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