metadata: contig_metadata: 13 rows where bioproject = "PRJNA395690", tax_clade = "Sar" and tax

13 rows where bioproject = "PRJNA395690", 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
411755	411755	PRJNA395690_P_NODE_36501_length_159_cov_2.736364_g36349_i0	PRJNA395690	36501	159	2.736364	4.35081876	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	83.2	6.47e-17	NR	DAZ99440.1	4803	g36349	i0	71.2	15.377358490566	52	15	98.1	0	3	158	109	160	DAZ99440.1 TPA: hypothetical protein N0F65_004073 [Lagenidium giganteum]	diamond	2445	83.2	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Pythiales	Pythiaceae	Lagenidium	Lagenidium giganteum
1686434	1686434	PRJNA395690_P_NODE_22642_length_180_cov_1.557252_g22490_i0	PRJNA395690	22642	180	1.557252	2.8030536	Pythiales	121069	SAR_Eukaryotes	SAR_Eukaryotes	95.9	1.94e-22	NR	GLD96418.1	114742	g22490	i0	68.3	4.91666666666667	60	19	100	0	180	1	37	96	GLD96418.1 hypothetical protein PINS_up005101 [Pythium insidiosum]	diamond	885	96.7	0.991726990692865	Eukaryota	Sar	Oomycota	Peronosporomycetes	Pythiales	Pythiaceae	Pythium	Pythium insidiosum
1686613	1686613	PRJNA395690_P_NODE_3662_length_411_cov_1.856354_g3513_i0	PRJNA395690	3662	411	1.856354	7.62961494	Saprolegniales	4763	SAR_Eukaryotes	SAR_Eukaryotes	141	2.989999999999999e-38	NR	RQM26635.1	112090	g3513	i0	64.1	12.5036496350365	117	41	84.7	1	401	54	180	296	RQM26635.1 hypothetical protein B5M09_003301 [Aphanomyces astaci]	diamond	5139	141	1	Eukaryota	Sar	Oomycota	Saprolegniomycetes	Saprolegniales	Verrucalvaceae	Aphanomyces	Aphanomyces astaci
7456919	7456919	PRJNA395690_P_NODE_23226_length_179_cov_1.223077_g23074_i0	PRJNA395690	23226	179	1.223077	2.18930783	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	102	5.12e-26	NR	KAJ8524041.1	4785	g23074	i0	93.2	40.5418994413408	59	4	98.9	0	178	2	31	89	KAJ8524041.1 hypothetical protein ON010_g17076 [Phytophthora cinnamomi]	diamond	7257	102	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Peronosporales	Peronosporaceae	Phytophthora	Phytophthora cinnamomi
26743543	26743543	PRJNA395690_P_NODE_4941_length_358_cov_1.093851_g4792_i0	PRJNA395690	4941	358	1.093851	3.91598658	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	53.1	5.77e-6	NR	DAZ95418.1	4803	g4792	i0	32.1	3.94692737430168	84	48	67.9	2	91	333	22	99	DAZ95418.1 TPA: hypothetical protein N0F65_006308 [Lagenidium giganteum]	diamond	1413	53.1	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Pythiales	Pythiaceae	Lagenidium	Lagenidium giganteum
27154914	27154914	PRJNA395690_P_NODE_31842_length_164_cov_1.382609_g31690_i0	PRJNA395690	31842	164	1.382609	2.26747876	root	1	Root_unresolved	Root_unresolved	43.9	0.00496	NR	XP_012201743.1	695850	g31690	i0	47.5	1.26219512195122	40	18	67.7	1	8	118	147	186	XP_012201743.1 hypothetical protein SPRG_06891 [Saprolegnia parasitica CBS 223.65]	diamond	207	43.9	1	Eukaryota	Sar	Oomycota	Saprolegniomycetes	Saprolegniales	Saprolegniaceae	Saprolegnia	Saprolegnia parasitica
27328361	27328361	PRJNA395690_P_NODE_8163_length_283_cov_1.307692_g8011_i0	PRJNA395690	8163	283	1.307692	3.70076836	Aphanomyces euteiches	100861	SAR_Eukaryotes	SAR_Eukaryotes	72.8	1.07e-13	NR	KAH9128298.1	100861	g8011	i0	44.6	5.78798586572438	92	41	97.5	2	281	6	66	147	KAH9128298.1 hypothetical protein AeMF1_001525 [Aphanomyces euteiches]	diamond	1638	72.8	1	Eukaryota	Sar	Oomycota	Saprolegniomycetes	Saprolegniales	Verrucalvaceae	Aphanomyces	Aphanomyces euteiches
27707603	27707603	PRJNA395690_P_NODE_28784_length_167_cov_0.864407_g28632_i0	PRJNA395690	28784	167	0.864407	1.44355969	Saprolegnia parasitica CBS 223.65	695850	SAR_Eukaryotes	SAR_Eukaryotes	59.7	1.79e-9	NR	XP_012194695.1	695850	g28632	i0	60	0.808383233532934	45	16	80.8	1	165	31	94	136	XP_012194695.1 glycine cleavage system H protein [Saprolegnia parasitica CBS 223.65]	diamond	135	59.7	1	Eukaryota	Sar	Oomycota	Saprolegniomycetes	Saprolegniales	Saprolegniaceae	Saprolegnia	Saprolegnia parasitica
27724303	27724303	PRJNA395690_P_NODE_25824_length_173_cov_0.991935_g25672_i0	PRJNA395690	25824	173	0.991935	1.71604755	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	101	1.07e-24	NR	KAH9111342.1	100861	g25672	i0	71.9	16.7861271676301	57	16	98.8	0	3	173	149	205	KAH9111342.1 hypothetical protein AeMF1_014097 [Aphanomyces euteiches]	diamond	2904	101	1	Eukaryota	Sar	Oomycota	Saprolegniomycetes	Saprolegniales	Verrucalvaceae	Aphanomyces	Aphanomyces euteiches
28923586	28923586	PRJNA395690_P_NODE_6328_length_320_cov_1.129151_g6177_i0	PRJNA395690	6328	320	1.129151	3.6132832	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	53.5	3.86e-6	NR	RHY74090.1	112090	g6177	i0	48.3	5.25	58	25	49.7	1	3	161	98	155	RHY74090.1 hypothetical protein DYB30_004665 [Aphanomyces astaci]	diamond	1680	53.9	0.992578849721707	Eukaryota	Sar	Oomycota	Saprolegniomycetes	Saprolegniales	Verrucalvaceae	Aphanomyces	Aphanomyces astaci
30850339	30850339	PRJNA395690_P_NODE_12474_length_231_cov_1.120879_g12322_i0	PRJNA395690	12474	231	1.120879	2.58923049	Peronosporaceae	4777	SAR_Eukaryotes	SAR_Eukaryotes	110	1.18e-26	NR	XP_024581949.1	4781	g12322	i0	68.9	8.64935064935065	74	23	96.1	0	8	229	3	76	XP_024581949.1 elongation factor 1 [Plasmopara halstedii]	diamond	1998	111	0.990990990990991	Eukaryota	Sar	Oomycota	Peronosporomycetes	Peronosporales	Peronosporaceae	Plasmopara	Plasmopara halstedii
30850341	30850341	PRJNA395690_P_NODE_7994_length_286_cov_1.177215_g7842_i0	PRJNA395690	7994	286	1.177215	3.3668349	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	114	5.61e-27	NR	KAJ0412157.1	114742	g7842	i0	65.4	9.69230769230769	81	27	85	1	3	245	623	702	KAJ0412157.1 hypothetical protein ATCC90586_005770 [Pythium insidiosum]	diamond	2772	114	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Pythiales	Pythiaceae	Pythium	Pythium insidiosum
31055107	31055107	PRJNA395690_P_NODE_32515_length_164_cov_0.886957_g32363_i0	PRJNA395690	32515	164	0.886957	1.45460948	Aphanomyces astaci	112090	SAR_Eukaryotes	SAR_Eukaryotes	89	6.6e-19	NR	RHY01077.1	112090	g32363	i0	72.2	6.91463414634146	54	15	98.8	0	162	1	2108	2161	RHY01077.1 hypothetical protein DYB36_008905, partial [Aphanomyces astaci]	diamond	1134	89	1	Eukaryota	Sar	Oomycota	Saprolegniomycetes	Saprolegniales	Verrucalvaceae	Aphanomyces	Aphanomyces astaci

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