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

10 rows where bioproject = "PRJNA1073712", 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
4013974	4013974	PRJNA1073712_P_NODE_11544_length_250_cov_2.033898_g11461_i0	PRJNA1073712	11544	250	2.033898	5.084745	Albugo laibachii	653948	SAR_Eukaryotes	SAR_Eukaryotes	462	8.83e-126	NTclustered	gi\|325195820\|emb\|FR826611.1\|	890382	g11461	i0	100	21.136	250	0	100	0	1	250	278	29	Albugo laibachii Nc14, genomic contig CONTIG_3778_NC14_v4_313_8	blastn	5284	462	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Albuginales	Albuginaceae	Albugo	Albugo laibachii
6565526	6565526	PRJNA1073712_P_NODE_12726_length_248_cov_0.880000_g12643_i0	PRJNA1073712	12726	248	0.88	2.1824	Phytophthora nicotianae	4792	SAR_Eukaryotes	SAR_Eukaryotes	215	2.7e-51	NTclustered	gi\|675199240\|ref\|XM_008910257.1\|	761204	g12643	i0	82.661	89.8145161290323	248	37	100	3	1	248	785	1026	Phytophthora parasitica INRA-310 ATP synthase subunit beta, mitochondrial mRNA	blastn	22274	215	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Peronosporales	Peronosporaceae	Phytophthora	Phytophthora nicotianae
18039332	18039332	PRJNA1073712_P_NODE_9355_length_268_cov_1.553846_g9272_i0	PRJNA1073712	9355	268	1.553846	4.16430728	Aphanomyces invadans	157072	SAR_Eukaryotes	SAR_Eukaryotes	228	3.8e-55	NTclustered	gi\|673016107\|ref\|XM_008863793.1\|	157072	g9272	i0	82.593	8.63805970149254	270	35	96	6	1	258	340	71	Aphanomyces invadans hypothetical protein partial mRNA	blastn	2315	228	1	Eukaryota	Sar	Oomycota	Saprolegniomycetes	Saprolegniales	Verrucalvaceae	Aphanomyces	Aphanomyces invadans
27280269	27280269	PRJNA1073712_P_NODE_16743_length_241_cov_0.916667_g16660_i0	PRJNA1073712	16743	241	0.916667	2.20916747	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	71.6	2.35e-12	NR	CCI44919.1	65357	g16660	i0	47.1	5.81327800829875	68	36	84.6	0	239	36	682	749	CCI44919.1 unnamed protein product [Albugo candida]	diamond	1401	72	0.994444444444444	Eukaryota	Sar	Oomycota	Peronosporomycetes	Albuginales	Albuginaceae	Albugo	Albugo candida
28480128	28480128	PRJNA1073712_P_NODE_5486_length_322_cov_0.923695_g5403_i0	PRJNA1073712	5486	322	0.923695	2.9742979	Peronosporomycetes	3418804	SAR_Eukaryotes	SAR_Eukaryotes	77.8	4.55e-14	NR	GLE08717.1	114742	g5403	i0	53.2	2.32919254658385	62	29	57.8	0	318	133	182	243	GLE08717.1 hypothetical protein PINS_up020080 [Pythium insidiosum]	diamond	750	77.8	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Pythiales	Pythiaceae	Pythium	Pythium insidiosum
28772654	28772654	PRJNA1073712_P_NODE_16507_length_242_cov_0.875740_g16424_i0	PRJNA1073712	16507	242	0.87574	2.1192908	Lagenidium giganteum	4803	SAR_Eukaryotes	SAR_Eukaryotes	105	1.4699999999999999e-24	NR	DAZ93390.1	4803	g16424	i0	65.8	0.942148760330578	76	26	94.2	0	3	230	5	80	DAZ93390.1 TPA: hypothetical protein N0F65_012447 [Lagenidium giganteum]	diamond	228	105	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Pythiales	Pythiaceae	Lagenidium	Lagenidium giganteum
29467023	29467023	PRJNA1073712_P_NODE_14450_length_245_cov_0.895349_g14367_i0	PRJNA1073712	14450	245	0.895349	2.19360505	Aphanomyces euteiches	100861	SAR_Eukaryotes	SAR_Eukaryotes	58.5	7.8e-9	NR	KAH9147500.1	100861	g14367	i0	55.6	4.37142857142857	45	20	55.1	0	90	224	29	73	KAH9147500.1 hypothetical protein AeRB84_008913, partial [Aphanomyces euteiches]	diamond	1071	58.5	1	Eukaryota	Sar	Oomycota	Saprolegniomycetes	Saprolegniales	Verrucalvaceae	Aphanomyces	Aphanomyces euteiches
29688059	29688059	PRJNA1073712_P_NODE_6950_length_296_cov_1.376682_g6867_i0	PRJNA1073712	6950	296	1.376682	4.07497872	Globisporangium splendens	82926	SAR_Eukaryotes	SAR_Eukaryotes	124	5.16e-32	NR	KAF1325827.1	82926	g6867	i0	60.2	2.94932432432432	98	39	99.3	0	3	296	100	197	KAF1325827.1 60s acidic ribosomal protein p0, partial [Globisporangium splendens]	diamond	873	124	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Pythiales	Pythiaceae	Globisporangium	Globisporangium splendens
30225330	30225330	PRJNA1073712_P_NODE_10112_length_261_cov_1.292553_g10029_i0	PRJNA1073712	10112	261	1.292553	3.37356333	[Pythium] brassicae (nom. inval.)	1485010	SAR_Eukaryotes	SAR_Eukaryotes	119	1.43e-32	NR	TYZ67485.1	1485010	g10029	i0	64.6	5.6551724137931	82	29	94.3	0	251	6	1	82	TYZ67485.1 hypothetical protein PybrP1_008862 [[Pythium] brassicae (nom. inval.)]	diamond	1476	119	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Pythiales	Pythiaceae	Globisporangium	[Pythium] brassicae (nom. inval.)
32533722	32533722	PRJNA1073712_P_NODE_16499_length_242_cov_0.899408_g16416_i0	PRJNA1073712	16499	242	0.899408	2.17656736	Phytophthora palmivora	4796	SAR_Eukaryotes	SAR_Eukaryotes	99.8	1.83e-22	NR	POM57954.1	4796	g16416	i0	63.8	3.96694214876033	80	4	99.2	1	242	3	171	225	POM57954.1 Histone acetyltransferase ESA1 [Phytophthora palmivora]	diamond	960	99.8	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Peronosporales	Peronosporaceae	Phytophthora	Phytophthora palmivora

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