metadata: contig_metadata: 14 rows where analysis = "blastn", bioproject = "PRJNA492406" and tax

14 rows where analysis = "blastn", bioproject = "PRJNA492406" 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
452873	452873	PRJNA492406_P_NODE_7481_length_443_cov_1.745946_g7182_i0	PRJNA492406	7481	443	1.745946	7.73454078	Saprolegnia diclina	112098	SAR_Eukaryotes	SAR_Eukaryotes	174	8.77e-39	NTclustered	gi\|669159439\|ref\|XM_008617060.1\|	1156394	g7182	i0	77.895	31.7584650112867	285	59	64	4	54	336	451	169	Saprolegnia diclina VS20 60S ribosomal protein mRNA	blastn	14069	174	1	Eukaryota	Sar	Oomycota	Saprolegniomycetes	Saprolegniales	Saprolegniaceae	Saprolegnia	Saprolegnia diclina
8752260	8752260	PRJNA492406_P_NODE_9687_length_394_cov_6.704050_g9388_i0	PRJNA492406	9687	394	6.70405	26.413957	Peronosporomycetes	3418804	SAR_Eukaryotes	SAR_Eukaryotes	702	0	NTclustered	gi\|440919553\|gb\|JX436353.1\|	1279233	g9388	i0	98.98	98.1218274111675	392	4	99	0	1	392	381	772	Myzocytiopsis sp. GPR-2013 28S ribosomal RNA gene, partial sequence	blastn	38660	702	1	Eukaryota	Sar	Oomycota		Myzocytiopsidales	Myzocytiopsidaceae	Myzocytiopsis	Myzocytiopsis sp. GPR-2013
10656406	10656406	PRJNA492406_P_NODE_32129_length_241_cov_0.916667_g31830_i0	PRJNA492406	32129	241	0.916667	2.20916747	Phytophthora infestans	4787	SAR_Eukaryotes	SAR_Eukaryotes	302	1.95e-77	NTclustered	gi\|301107178\|ref\|XM_002902626.1\|	403677	g31830	i0	89.256	88.9045643153527	242	24	100	2	1	241	209	449	Phytophthora infestans T30-4 40S ribosomal protein S2 (PITG_10146), mRNA	blastn	21426	302	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Peronosporales	Peronosporaceae	Phytophthora	Phytophthora infestans
11930811	11930811	PRJNA492406_P_NODE_10630_length_379_cov_1.006536_g10331_i0	PRJNA492406	10630	379	1.006536	3.81477144	Albugo laibachii	653948	SAR_Eukaryotes	SAR_Eukaryotes	193	2.04e-44	NTclustered	gi\|325195237\|emb\|FR826032.1\|	890382	g10331	i0	82.456	39.4934036939314	228	33	59	3	1	224	431	207	Albugo laibachii Nc14, genomic contig CONTIG_3119_NC14_v4_456_35141	blastn	14968	193	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Albuginales	Albuginaceae	Albugo	Albugo laibachii
11930904	11930904	PRJNA492406_P_NODE_14170_length_333_cov_1.184615_g13871_i0	PRJNA492406	14170	333	1.184615	3.94476795	Aphanomyces invadans	157072	SAR_Eukaryotes	SAR_Eukaryotes	132	3.92e-26	NTclustered	gi\|673039884\|ref\|XM_008875681.1\|	157072	g13871	i0	81.707	1.33633633633634	164	25	49	5	171	332	459	299	Aphanomyces invadans 60S ribosomal protein mRNA	blastn	445	132	1	Eukaryota	Sar	Oomycota	Saprolegniomycetes	Saprolegniales	Verrucalvaceae	Aphanomyces	Aphanomyces invadans
11931129	11931129	PRJNA492406_P_NODE_23990_length_263_cov_2.010526_g23691_i0	PRJNA492406	23990	263	2.010526	5.28768338	Phytophthora litchii	100870	SAR_Eukaryotes	SAR_Eukaryotes	425	1.2299999999999999e-114	NTclustered	gi\|2248512916\|ref\|NC_063792.1\|	100870	g23691	i0	95.833	99.9961977186312	264	10	100	1	1	263	6047	6310	Phytophthora litchii isolate SHS3 mitochondrion, complete genome	blastn	26299	425	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Peronosporales	Peronosporaceae	Phytophthora	Phytophthora litchii
13206122	13206122	PRJNA492406_P_NODE_17951_length_294_cov_1.737557_g17652_i0	PRJNA492406	17951	294	1.737557	5.10841758	Lagenidium sp.	2358452	SAR_Eukaryotes	SAR_Eukaryotes	475	1.3699999999999999e-129	NTclustered	gi\|1923460301\|gb\|MW187669.1\|	2358452	g17652	i0	95.932	101.404761904762	295	8	100	4	1	294	346	55	Lagenidium sp. isolate CCRJB_35 small subunit ribosomal RNA gene, partial sequence; mitochondrial	blastn	29813	475	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Pythiales	Pythiaceae	Lagenidium	Lagenidium sp.
14481442	14481442	PRJNA492406_P_NODE_7712_length_436_cov_12.730028_g7413_i0	PRJNA492406	7712	436	12.730028	55.50292208	Pythium monospermum	92964	SAR_Eukaryotes	SAR_Eukaryotes	769	0	NTclustered	gi\|33520250\|gb\|AY273995.1\|	92964	g7413	i0	98.618	99.2775229357798	434	6	99	0	1	434	467	34	Pythium monospermum large subunit ribosomal RNA gene, partial sequence	blastn	43285	769	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Pythiales	Pythiaceae	Pythium	Pythium monospermum
16401939	16401939	PRJNA492406_P_NODE_9753_length_393_cov_3.375000_g9454_i0	PRJNA492406	9753	393	3.375	13.26375	Pythiaceae	4782	SAR_Eukaryotes	SAR_Eukaryotes	664	0	NTclustered	gi\|937408816\|ref\|NC_027966.1\|	114742	g9454	i0	97.201	103.918575063613	393	10	100	1	1	393	10824	11215	Pythium insidiosum mitochondrial DNA, complete genome	blastn	40840	664	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Pythiales	Pythiaceae	Pythium	Pythium insidiosum
17676909	17676909	PRJNA492406_P_NODE_24854_length_259_cov_1.655914_g24555_i0	PRJNA492406	24854	259	1.655914	4.28881726	Phytophthora	4783	SAR_Eukaryotes	SAR_Eukaryotes	342	1.25e-89	NTclustered	gi\|2651589115\|gb\|PP108238.1\|	4785	g24555	i0	90.421	103.200772200772	261	23	100	2	1	259	23610	23350	Phytophthora cinnamomi strain CT09CHAP1 mitochondrion, complete genome	blastn	26729	342	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Peronosporales	Peronosporaceae	Phytophthora	Phytophthora cinnamomi
18304044	18304044	PRJNA492406_P_NODE_19575_length_285_cov_2.165094_g19276_i0	PRJNA492406	19575	285	2.165094	6.1705179	Saprolegnia parasitica	101203	SAR_Eukaryotes	SAR_Eukaryotes	139	1.96e-28	NTclustered	gi\|813163222\|ref\|XM_012347282.1\|	695850	g19276	i0	79.048	19.7719298245614	210	38	73	6	71	277	323	117	Saprolegnia parasitica CBS 223.65 translation initiation factor eIF-5A mRNA	blastn	5635	139	1	Eukaryota	Sar	Oomycota	Saprolegniomycetes	Saprolegniales	Saprolegniaceae	Saprolegnia	Saprolegnia parasitica
19578038	19578038	PRJNA492406_P_NODE_10796_length_376_cov_1.722772_g10497_i0	PRJNA492406	10796	376	1.722772	6.47762272	Aphanomyces euteiches	100861	SAR_Eukaryotes	SAR_Eukaryotes	298	4.16e-76	NTclustered	gi\|166040594\|emb\|CU350614.1\|	100861	g10497	i0	84.488	78.5398936170213	303	45	80	2	75	376	786	485	Aphanomyces euteiches cDNA	blastn	29531	298	1	Eukaryota	Sar	Oomycota	Saprolegniomycetes	Saprolegniales	Verrucalvaceae	Aphanomyces	Aphanomyces euteiches
19578409	19578409	PRJNA492406_P_NODE_26256_length_252_cov_1.391061_g25957_i0	PRJNA492406	26256	252	1.391061	3.50547372	Phytophthora cinnamomi	4785	SAR_Eukaryotes	SAR_Eukaryotes	150	7.879999999999999e-32	NTclustered	gi\|2795050694\|ref\|XM_067937128.1\|	4785	g25957	i0	84.076	6.42063492063492	157	23	62	2	97	252	759	914	Phytophthora cinnamomi AMP deaminase (IUM83_12500), partial mRNA	blastn	1618	150	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Peronosporales	Peronosporaceae	Phytophthora	Phytophthora cinnamomi
22776289	22776289	PRJNA492406_P_NODE_21198_length_278_cov_1.117073_g20899_i0	PRJNA492406	21198	278	1.117073	3.10546294	Saprolegnia	4769	SAR_Eukaryotes	SAR_Eukaryotes	211	3.9900000000000002e-50	NTclustered	gi\|813135721\|ref\|XM_012343195.1\|	695850	g20899	i0	81.641	4.64028776978417	256	45	92	2	24	278	922	668	Saprolegnia parasitica CBS 223.65 T-complex protein 1 subunit beta mRNA	blastn	1290	211	1	Eukaryota	Sar	Oomycota	Saprolegniomycetes	Saprolegniales	Saprolegniaceae	Saprolegnia	Saprolegnia parasitica

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