metadata: contig_metadata: 11 rows where bioproject = "PRJNA642647", tax_clade = "Sar" and tax

11 rows where bioproject = "PRJNA642647", 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
5721543	5721543	PRJNA642647_P_NODE_5945_length_156_cov_2.445378_g5895_i0	PRJNA642647	5945	156	2.445378	3.81478968	Saprolegnia parasitica	101203	SAR_Eukaryotes	SAR_Eukaryotes	272	9.059999999999999e-69	NTclustered	gi\|813199071\|ref\|XR_001099870.1\|	695850	g5895	i0	98.693	40.2948717948718	153	2	98	0	1	153	928	776	Saprolegnia parasitica CBS 223.65 28S ribosomal RNA rRNA	blastn	6286	272	1	Eukaryota	Sar	Oomycota	Saprolegniomycetes	Saprolegniales	Saprolegniaceae	Saprolegnia	Saprolegnia parasitica
8271263	8271263	PRJNA642647_P_NODE_2967_length_203_cov_2.656627_g2917_i0	PRJNA642647	2967	203	2.656627	5.39295281	Pythium monospermum	92964	SAR_Eukaryotes	SAR_Eukaryotes	361	2.5899999999999994e-95	NTclustered	gi\|33520250\|gb\|AY273995.1\|	92964	g2917	i0	99.005	88.5221674876847	201	2	99	0	1	201	34	234	Pythium monospermum large subunit ribosomal RNA gene, partial sequence	blastn	17970	361	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Pythiales	Pythiaceae	Pythium	Pythium monospermum
8271273	8271273	PRJNA642647_P_NODE_3387_length_192_cov_2.232258_g3337_i0	PRJNA642647	3387	192	2.232258	4.28593536	Saprolegnia parasitica	101203	SAR_Eukaryotes	SAR_Eukaryotes	337	4.079999999999999e-88	NTclustered	gi\|813199067\|ref\|XR_001099866.1\|	695850	g3337	i0	98.429	82.578125	191	3	99	0	2	192	460	270	Saprolegnia parasitica CBS 223.65 28S ribosomal RNA rRNA	blastn	15855	337	1	Eukaryota	Sar	Oomycota	Saprolegniomycetes	Saprolegniales	Saprolegniaceae	Saprolegnia	Saprolegnia parasitica
12637734	12637734	PRJNA642647_P_NODE_4570_length_170_cov_2.015038_g4520_i0	PRJNA642647	4570	170	2.015038	3.4255646	Aphanomyces	100860	SAR_Eukaryotes	SAR_Eukaryotes	248	1.69e-61	NTclustered	gi\|268326957\|dbj\|AB533282.1\|	692225	g4520	i0	96.644	87.6470588235294	149	5	88	0	1	149	180	328	Aphanomyces sp. NJM 0703 genes for ITS1, 5.8S rRNA, ITS2, partial and complete sequence	blastn	14900	248	1	Eukaryota	Sar	Oomycota	Saprolegniomycetes	Saprolegniales	Verrucalvaceae	Aphanomyces	Aphanomyces sp. NJM 0703
14646885	14646885	PRJNA642647_P_NODE_1332_length_303_cov_3.669173_g1282_i0	PRJNA642647	1332	303	3.669173	11.11759419	Saprolegnia parasitica	101203	SAR_Eukaryotes	SAR_Eukaryotes	355	1.92e-93	NTclustered	gi\|813199067\|ref\|XR_001099866.1\|	695850	g1282	i0	88.514	75.049504950495	296	30	97	4	8	301	1665	1372	Saprolegnia parasitica CBS 223.65 28S ribosomal RNA rRNA	blastn	22740	355	1	Eukaryota	Sar	Oomycota	Saprolegniomycetes	Saprolegniales	Saprolegniaceae	Saprolegnia	Saprolegnia parasitica
14646887	14646887	PRJNA642647_P_NODE_152_length_908_cov_17.653272_g127_i0	PRJNA642647	152	908	17.653272	160.29170976	Aphanomyces astaci	112090	SAR_Eukaryotes	SAR_Eukaryotes	1162	0	NTclustered	gi\|698793876\|ref\|XR_717098.1\|	112090	g127	i0	98.195	85.3711453744493	665	12	73	0	1	665	2775	2111	Aphanomyces astaci 28S ribosomal RNA rRNA	blastn	77517	1162	1	Eukaryota	Sar	Oomycota	Saprolegniomycetes	Saprolegniales	Verrucalvaceae	Aphanomyces	Aphanomyces astaci
18470243	18470243	PRJNA642647_P_NODE_4415_length_172_cov_4.651852_g4365_i0	PRJNA642647	4415	172	4.651852	8.00118544	Aphanomyces astaci	112090	SAR_Eukaryotes	SAR_Eukaryotes	291	2.81e-74	NTclustered	gi\|698793876\|ref\|XR_717098.1\|	112090	g4365	i0	97.633	86.5232558139535	169	4	98	0	4	172	1911	2079	Aphanomyces astaci 28S ribosomal RNA rRNA	blastn	14882	291	1	Eukaryota	Sar	Oomycota	Saprolegniomycetes	Saprolegniales	Verrucalvaceae	Aphanomyces	Aphanomyces astaci
20284952	20284952	PRJNA642647_P_NODE_2336_length_225_cov_3.861702_g2286_i0	PRJNA642647	2336	225	3.861702	8.6888295	Pythiaceae	4782	SAR_Eukaryotes	SAR_Eukaryotes	398	2.2299999999999996e-106	NTclustered	gi\|573007533\|gb\|HQ643697.2\|	92964	g2286	i0	99.095	98.2266666666667	221	2	98	0	4	224	143	363	Pythium monospermum voucher CBS15873 18S ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence	blastn	22101	398	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Pythiales	Pythiaceae	Pythium	Pythium monospermum
28217996	28217996	PRJNA642647_P_NODE_5526_length_162_cov_1.120000_g5476_i0	PRJNA642647	5526	162	1.12	1.8144	Saprolegnia parasitica CBS 223.65	695850	SAR_Eukaryotes	SAR_Eukaryotes	70.9	1.19e-13	NR	XP_012202672.1	695850	g5476	i0	62.7	1.90740740740741	51	19	94.4	0	155	3	71	121	XP_012202672.1 translation initiation factor eIF-5A [Saprolegnia parasitica CBS 223.65]	diamond	309	70.9	1	Eukaryota	Sar	Oomycota	Saprolegniomycetes	Saprolegniales	Saprolegniaceae	Saprolegnia	Saprolegnia parasitica
28723488	28723488	PRJNA642647_P_NODE_1367_length_300_cov_2.475285_g1317_i0	PRJNA642647	1367	300	2.475285	7.425855	Pythium insidiosum	114742	SAR_Eukaryotes	SAR_Eukaryotes	135	9.54e-38	NR	GLD98056.1	114742	g1317	i0	57.1	1.19	119	28	96	1	299	12	12	130	GLD98056.1 hypothetical protein PINS_up006753 [Pythium insidiosum]	diamond	357	135	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Pythiales	Pythiaceae	Pythium	Pythium insidiosum
30460833	30460833	PRJNA642647_P_NODE_5233_length_166_cov_1.441860_g5183_i0	PRJNA642647	5233	166	1.44186	2.3934876	Phytophthora fragariae	53985	SAR_Eukaryotes	SAR_Eukaryotes	43.1	0.00328	NR	KAE8917126.1	53985	g5183	i0	56	0.903614457831325	50	21	90.4	1	15	164	10	58	KAE8917126.1 hypothetical protein PF009_g32553 [Phytophthora fragariae]	diamond	150	43.1	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);;