metadata: contig_metadata: 15 rows where bioproject = "PRJNA188516" and tax

15 rows where bioproject = "PRJNA188516" 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
4192942	4192942	PRJNA188516_P_NODE_5824_length_163_cov_0.912281_g5774_i0	PRJNA188516	5824	163	0.912281	1.48701803	Phytophthora sojae	67593	SAR_Eukaryotes	SAR_Eukaryotes	95.3	2.23e-15	NTclustered	gi\|695375632\|ref\|XM_009517294.1\|	67593	g5774	i0	80.992	0.742331288343558	121	21	74	2	29	148	268	149	Phytophthora sojae hypothetical protein partial mRNA	blastn	121	95.3	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Peronosporales	Peronosporaceae	Phytophthora	Phytophthora sojae
10569835	10569835	PRJNA188516_P_NODE_1789_length_263_cov_1.705607_g1739_i0	PRJNA188516	1789	263	1.705607	4.48574641	[Pythium] brassicae (nom. inval.)	1485010	SAR_Eukaryotes	SAR_Eukaryotes	123	2.22e-32	NR	TYZ67175.1	1485010	g1739	i0	67.4	1.96197718631179	86	26	98.1	1	262	5	198	281	TYZ67175.1 hypothetical protein PybrP1_001669, partial [[Pythium] brassicae (nom. inval.)]	diamond	516	123	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Pythiales	Pythiaceae	Globisporangium	[Pythium] brassicae (nom. inval.)
14394887	14394887	PRJNA188516_P_NODE_3372_length_185_cov_1.147059_g3322_i0	PRJNA188516	3372	185	1.147059	2.12205915	Phytophthora cinnamomi	4785	SAR_Eukaryotes	SAR_Eukaryotes	106	1.2e-18	NTclustered	gi\|2795059860\|ref\|XM_067943008.1\|	4785	g3322	i0	78.571	5.53513513513514	168	31	90	4	10	176	211	374	Phytophthora cinnamomi 40S ribosomal protein S3a (IUM83_18029), partial mRNA	blastn	1024	106	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Peronosporales	Peronosporaceae	Phytophthora	Phytophthora cinnamomi
16943100	16943100	PRJNA188516_P_NODE_5334_length_164_cov_1.356522_g5284_i0	PRJNA188516	5334	164	1.356522	2.22469608	Aphanomyces invadans	157072	SAR_Eukaryotes	SAR_Eukaryotes	106	3.84e-27	NR	XP_008876054.1	157072	g5284	i0	96.3	0.98780487804878	54	2	98.8	0	162	1	44	97	XP_008876054.1 hypothetical protein H310_11242 [Aphanomyces invadans]	diamond	162	106	1	Eukaryota	Sar	Oomycota	Saprolegniomycetes	Saprolegniales	Verrucalvaceae	Aphanomyces	Aphanomyces invadans
20767342	20767342	PRJNA188516_P_NODE_3857_length_172_cov_1.382114_g3807_i0	PRJNA188516	3857	172	1.382114	2.37723608	Aphanomyces invadans	157072	SAR_Eukaryotes	SAR_Eukaryotes	228	2.2299999999999997e-55	NTclustered	gi\|673047298\|ref\|XM_008879388.1\|	157072	g3807	i0	91.515	2.44186046511628	165	14	96	0	1	165	183	19	Aphanomyces invadans 60S ribosomal protein L10 mRNA	blastn	420	228	1	Eukaryota	Sar	Oomycota	Saprolegniomycetes	Saprolegniales	Verrucalvaceae	Aphanomyces	Aphanomyces invadans
22042438	22042438	PRJNA188516_P_NODE_3998_length_169_cov_1.300000_g3948_i0	PRJNA188516	3998	169	1.3	2.197	Albugo laibachii Nc14	890382	SAR_Eukaryotes	SAR_Eukaryotes	76.6	1.55e-14	NR	CCA20828.1	890382	g3948	i0	55.6	3.62130177514793	54	24	95.9	0	162	1	242	295	CCA20828.1 hypothetical protein SORBIDRAFT_01g039390 [Albugo laibachii Nc14]	diamond	612	76.6	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Albuginales	Albuginaceae	Albugo	Albugo laibachii
22042448	22042448	PRJNA188516_P_NODE_4558_length_167_cov_1.279661_g4508_i0	PRJNA188516	4558	167	1.279661	2.13703387	Aphanomyces invadans	157072	SAR_Eukaryotes	SAR_Eukaryotes	180	6.16e-41	NTclustered	gi\|673042380\|ref\|XM_008876929.1\|	157072	g4508	i0	86.875	3.46706586826347	160	21	96	0	1	160	249	408	Aphanomyces invadans 40S ribosomal protein partial mRNA	blastn	579	180	1	Eukaryota	Sar	Oomycota	Saprolegniomycetes	Saprolegniales	Verrucalvaceae	Aphanomyces	Aphanomyces invadans
28368712	28368712	PRJNA188516_P_NODE_3626_length_178_cov_1.209302_g3576_i0	PRJNA188516	3626	178	1.209302	2.15255756	Thraustotheca clavata	74557	SAR_Eukaryotes	SAR_Eukaryotes	96.3	2.01e-21	NR	OQR99116.1	74557	g3576	i0	81.4	0.99438202247191	59	11	99.4	0	178	2	119	177	OQR99116.1 isocitrate lyase [Thraustotheca clavata]	diamond	177	96.3	1	Eukaryota	Sar	Oomycota	Saprolegniomycetes	Saprolegniales	Achlyaceae	Thraustotheca	Thraustotheca clavata
29270498	29270498	PRJNA188516_P_NODE_3009_length_197_cov_1.054054_g2959_i0	PRJNA188516	3009	197	1.054054	2.07648638	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	88.2	2.46e-20	NR	OWZ14719.1	4795	g2959	i0	75.4	20.741116751269	57	14	86.8	0	196	26	91	147	OWZ14719.1 60S ribosomal protein L27a, partial [Phytophthora megakarya]	diamond	4086	89	0.991011235955056	Eukaryota	Sar	Oomycota	Peronosporomycetes	Peronosporales	Peronosporaceae	Phytophthora	Phytophthora megakarya
29473617	29473617	PRJNA188516_P_NODE_4030_length_169_cov_0.866667_g3980_i0	PRJNA188516	4030	169	0.866667	1.46466723	Aphanomyces euteiches	100861	SAR_Eukaryotes	SAR_Eukaryotes	111	1.33e-29	NR	KAF0743747.1	100861	g3980	i0	96.4	0.976331360946746	55	2	97.6	0	3	167	60	114	KAF0743747.1 hypothetical protein Ae201684_001401 [Aphanomyces euteiches]	diamond	165	111	1	Eukaryota	Sar	Oomycota	Saprolegniomycetes	Saprolegniales	Verrucalvaceae	Aphanomyces	Aphanomyces euteiches
30327228	30327228	PRJNA188516_P_NODE_5972_length_162_cov_0.920354_g5922_i0	PRJNA188516	5972	162	0.920354	1.49097348	Aphanomyces astaci	112090	SAR_Eukaryotes	SAR_Eukaryotes	103	3.63e-25	NR	KAF0716188.1	112090	g5922	i0	88.7	0.981481481481482	53	6	98.1	0	160	2	43	95	KAF0716188.1 hypothetical protein AaE_011167 [Aphanomyces astaci]	diamond	159	103	1	Eukaryota	Sar	Oomycota	Saprolegniomycetes	Saprolegniales	Verrucalvaceae	Aphanomyces	Aphanomyces astaci
30660435	30660435	PRJNA188516_P_NODE_2973_length_198_cov_1.395973_g2923_i0	PRJNA188516	2973	198	1.395973	2.76402654	Aphanomyces	100860	SAR_Eukaryotes	SAR_Eukaryotes	103	3.2199999999999993e-24	NR	KAH9152901.1	100861	g2923	i0	76.6	2.89393939393939	64	15	97	0	193	2	263	326	KAH9152901.1 hypothetical protein LEN26_003626, partial [Aphanomyces euteiches]	diamond	573	104	0.990384615384615	Eukaryota	Sar	Oomycota	Saprolegniomycetes	Saprolegniales	Verrucalvaceae	Aphanomyces	Aphanomyces euteiches
31116342	31116342	PRJNA188516_P_NODE_4175_length_169_cov_0.866667_g4125_i0	PRJNA188516	4175	169	0.866667	1.46466723	Saprolegnia parasitica CBS 223.65	695850	SAR_Eukaryotes	SAR_Eukaryotes	85.1	5.57e-18	NR	XP_012196032.1	695850	g4125	i0	68.6	0.905325443786982	51	16	90.5	0	168	16	82	132	XP_012196032.1 hypothetical protein SPRG_02090 [Saprolegnia parasitica CBS 223.65]	diamond	153	85.1	1	Eukaryota	Sar	Oomycota	Saprolegniomycetes	Saprolegniales	Saprolegniaceae	Saprolegnia	Saprolegnia parasitica
32033844	32033844	PRJNA188516_P_NODE_5858_length_163_cov_0.903509_g5808_i0	PRJNA188516	5858	163	0.903509	1.47271967	Aphanomyces stellatus	120398	SAR_Eukaryotes	SAR_Eukaryotes	105	9.54e-25	NR	KAF0687498.1	120398	g5808	i0	78.2	1.01226993865031	55	11	99.4	1	2	163	385	439	KAF0687498.1 hypothetical protein As57867_020702 [Aphanomyces stellatus]	diamond	165	105	1	Eukaryota	Sar	Oomycota	Saprolegniomycetes	Saprolegniales	Verrucalvaceae	Aphanomyces	Aphanomyces stellatus
32494783	32494783	PRJNA188516_P_NODE_3019_length_197_cov_0.966216_g2969_i0	PRJNA188516	3019	197	0.966216	1.90344552	Aphanomyces	100860	SAR_Eukaryotes	SAR_Eukaryotes	70.5	2.43e-13	NR	KAF0744591.1	100861	g2969	i0	82.2	2.07106598984772	45	8	68.5	0	196	62	18	62	KAF0744591.1 hypothetical protein Ae201684_001059 [Aphanomyces euteiches]	diamond	408	70.9	0.994358251057828	Eukaryota	Sar	Oomycota	Saprolegniomycetes	Saprolegniales	Verrucalvaceae	Aphanomyces	Aphanomyces euteiches

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