metadata: contig_metadata: 10 rows where bioproject = "PRJNA703759", tax_clade = "Sar" and tax

10 rows where bioproject = "PRJNA703759", 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
1961031	1961031	PRJNA703759_P_NODE_9842_length_431_cov_1.743017_g9366_i0	PRJNA703759	9842	431	1.743017	7.51240327	Albugo laibachii	653948	SAR_Eukaryotes	SAR_Eukaryotes	560	5.59e-155	NTclustered	gi\|325194231\|emb\|FR825088.1\|	890382	g9366	i0	90.3	1.11832946635731	433	34	100	6	1	431	472	898	Albugo laibachii Nc14, genomic contig CONTIG_1612_NC14_v4_1853_85	blastn	482	560	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Albuginales	Albuginaceae	Albugo	Albugo laibachii
4512091	4512091	PRJNA703759_P_NODE_15784_length_341_cov_3.179104_g15308_i0	PRJNA703759	15784	341	3.179104	10.84074464	Albugo laibachii	653948	SAR_Eukaryotes	SAR_Eukaryotes	538	2.0299999999999994e-148	NTclustered	gi\|325194231\|emb\|FR825088.1\|	890382	g15308	i0	95.308	1.09970674486804	341	13	100	2	1	341	711	1048	Albugo laibachii Nc14, genomic contig CONTIG_1612_NC14_v4_1853_85	blastn	375	538	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Albuginales	Albuginaceae	Albugo	Albugo laibachii
4512801	4512801	PRJNA703759_P_NODE_43984_length_246_cov_1.919075_g43508_i0	PRJNA703759	43984	246	1.919075	4.7209245	Albugo laibachii	653948	SAR_Eukaryotes	SAR_Eukaryotes	433	6.79e-117	NTclustered	gi\|325194231\|emb\|FR825088.1\|	890382	g43508	i0	98.374	2.14227642276423	246	4	100	0	1	246	1468	1223	Albugo laibachii Nc14, genomic contig CONTIG_1612_NC14_v4_1853_85	blastn	527	433	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Albuginales	Albuginaceae	Albugo	Albugo laibachii
13438142	13438142	PRJNA703759_P_NODE_30651_length_264_cov_2.706806_g30175_i0	PRJNA703759	30651	264	2.706806	7.14596784	Albugo laibachii	653948	SAR_Eukaryotes	SAR_Eukaryotes	405	1.61e-108	NTclustered	gi\|325195057\|emb\|FR825852.1\|	890382	g30175	i0	94.34	103.931818181818	265	14	100	1	1	264	176	440	Albugo laibachii Nc14, genomic contig CONTIG_2891_NC14_v4_540_391	blastn	27438	405	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Albuginales	Albuginaceae	Albugo	Albugo laibachii
26893188	26893188	PRJNA703759_P_NODE_18461_length_320_cov_1.234818_g17985_i0	PRJNA703759	18461	320	1.234818	3.9514176	Phytophthora palmivora	4796	SAR_Eukaryotes	SAR_Eukaryotes	43.5	0.04	NR	POM77060.1	4796	g17985	i0	26.5	1.565625	102	60	95.6	1	2	307	98	184	POM77060.1 Hypothetical protein PHPALM_5616 [Phytophthora palmivora]	diamond	501	43.5	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Peronosporales	Peronosporaceae	Phytophthora	Phytophthora palmivora
27114243	27114243	PRJNA703759_P_NODE_45342_length_246_cov_0.901734_g44866_i0	PRJNA703759	45342	246	0.901734	2.21826564	Lagenidium giganteum	4803	SAR_Eukaryotes	SAR_Eukaryotes	45.4	0.00437	NR	DBA04873.1	4803	g44866	i0	36.1	0.74390243902439	61	37	74.4	1	214	32	895	953	DBA04873.1 TPA: hypothetical protein N0F65_006875 [Lagenidium giganteum]	diamond	183	45.4	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Pythiales	Pythiaceae	Lagenidium	Lagenidium giganteum
27903867	27903867	PRJNA703759_P_NODE_50985_length_242_cov_0.923077_g50509_i0	PRJNA703759	50985	242	0.923077	2.23384634	Thraustotheca clavata	74557	SAR_Eukaryotes	SAR_Eukaryotes	48.5	3.29e-4	NR	OQR95089.1	74557	g50509	i0	45.6	0.706611570247934	57	27	65.7	1	84	242	260	316	OQR95089.1 hypothetical protein THRCLA_08025, partial [Thraustotheca clavata]	diamond	171	48.5	1	Eukaryota	Sar	Oomycota	Saprolegniomycetes	Saprolegniales	Achlyaceae	Thraustotheca	Thraustotheca clavata
28325531	28325531	PRJNA703759_P_NODE_47766_length_244_cov_0.912281_g47290_i0	PRJNA703759	47766	244	0.912281	2.22596564	Oomycota	4762	SAR_Eukaryotes	SAR_Eukaryotes	82.8	2.92e-16	NR	KAF1320204.1	82926	g47290	i0	52.6	6.78688524590164	78	37	95.9	0	242	9	279	356	KAF1320204.1 Pollike protein, partial [Globisporangium splendens]	diamond	1656	82.8	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Pythiales	Pythiaceae	Globisporangium	Globisporangium splendens
28346074	28346074	PRJNA703759_P_NODE_49266_length_243_cov_0.917647_g48790_i0	PRJNA703759	49266	243	0.917647	2.22988221	Pythium insidiosum	114742	SAR_Eukaryotes	SAR_Eukaryotes	142	1.3199999999999999e-40	NR	GLD95470.1	114742	g48790	i0	78.8	1.97530864197531	80	17	98.8	0	242	3	111	190	GLD95470.1 hypothetical protein PINS_up004115 [Pythium insidiosum]	diamond	480	142	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Pythiales	Pythiaceae	Pythium	Pythium insidiosum
28882750	28882750	PRJNA703759_P_NODE_40508_length_249_cov_0.886364_g40032_i0	PRJNA703759	40508	249	0.886364	2.20704636	Thraustotheca clavata	74557	SAR_Eukaryotes	SAR_Eukaryotes	68.6	3.25e-11	NR	OQR89966.1	74557	g40032	i0	37.8	5.73493975903614	82	49	96.4	1	249	10	416	497	OQR89966.1 disulfide-isomerase [Thraustotheca clavata]	diamond	1428	68.6	1	Eukaryota	Sar	Oomycota	Saprolegniomycetes	Saprolegniales	Achlyaceae	Thraustotheca	Thraustotheca clavata

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