metadata: contig_metadata: 20 rows where analysis = "blastn", bioproject = "PRJNA1022587" and tax

20 rows where analysis = "blastn", bioproject = "PRJNA1022587" and tax_clade = "Sar"

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
162663	162663	PRJNA1022587_S_NODE_321_length_400_cov_1.036697_g319_i0	PRJNA1022587	321	400	1.036697	4.146788	Phytophthora infestans	4787	SAR_Eukaryotes	SAR_Eukaryotes	603	8.439999999999997e-168	NTclustered	gi\|56547674\|gb\|AY830090.1\|	4787	g319	i0	94.015	1.51	401	18	100	3	1	400	734	1129	Phytophthora infestans clone PI-BAC-11A5 INF1 (inf1) and INF4 (inf4) genes, complete cds; Kre6-like (kre6-like) pseudogene, complete sequence; ORF457 gene, complete cds; INF3 (inf3) pseudogene, complete sequence; and INF6 (inf6) gene, complete cds	blastn	604	603	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Peronosporales	Peronosporaceae	Phytophthora	Phytophthora infestans
1437441	1437441	PRJNA1022587_S_NODE_1302_length_250_cov_0.971751_g1300_i0	PRJNA1022587	1302	250	0.971751	2.4293775	Phytophthora infestans	4787	SAR_Eukaryotes	SAR_Eukaryotes	278	3.43e-70	NTclustered	gi\|301104452\|ref\|XM_002901265.1\|	403677	g1300	i0	95.906	21.836	171	7	68	0	1	171	137	307	Phytophthora infestans T30-4 uncharacterized protein (PITG_11820), partial mRNA	blastn	5459	278	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Peronosporales	Peronosporaceae	Phytophthora	Phytophthora infestans
2713109	2713109	PRJNA1022587_S_NODE_1363_length_248_cov_0.811429_g1361_i0	PRJNA1022587	1363	248	0.811429	2.01234392	Phytophthora infestans	4787	SAR_Eukaryotes	SAR_Eukaryotes	231	2.68e-56	NTclustered	gi\|2906044\|gb\|AF045427.1\|AF045427	4787	g1361	i0	96.429	0.564516129032258	140	5	56	0	109	248	1	140	Phytophthora infestans clone O2ks repeat region	blastn	140	231	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Peronosporales	Peronosporaceae	Phytophthora	Phytophthora infestans
3989256	3989256	PRJNA1022587_S_NODE_1404_length_246_cov_1.231214_g1402_i0	PRJNA1022587	1404	246	1.231214	3.02878644	Phytophthora sojae	67593	SAR_Eukaryotes	SAR_Eukaryotes	344	3.27e-90	NTclustered	gi\|695405392\|ref\|XM_009525501.1\|	67593	g1402	i0	99.471	13.3292682926829	189	1	77	0	58	246	201	13	Phytophthora sojae hypothetical protein partial mRNA	blastn	3279	344	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Peronosporales	Peronosporaceae	Phytophthora	Phytophthora sojae
5265534	5265534	PRJNA1022587_S_NODE_105_length_588_cov_1.347573_g103_i0	PRJNA1022587	105	588	1.347573	7.92372924	Phytophthora infestans	4787	SAR_Eukaryotes	SAR_Eukaryotes	625	2.729999999999999e-174	NTclustered	gi\|56547674\|gb\|AY830090.1\|	4787	g103	i0	97.541	3.09863945578231	366	7	99	2	223	586	3171	2806	Phytophthora infestans clone PI-BAC-11A5 INF1 (inf1) and INF4 (inf4) genes, complete cds; Kre6-like (kre6-like) pseudogene, complete sequence; ORF457 gene, complete cds; INF3 (inf3) pseudogene, complete sequence; and INF6 (inf6) gene, complete cds	blastn	1822	625	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Peronosporales	Peronosporaceae	Phytophthora	Phytophthora infestans
5265537	5265537	PRJNA1022587_S_NODE_325_length_398_cov_1.387692_g323_i0	PRJNA1022587	325	398	1.387692	5.52301416	Phytophthora infestans	4787	SAR_Eukaryotes	SAR_Eukaryotes	296	1.59e-75	NTclustered	gi\|2906034\|gb\|AF045417.1\|AF045417	4787	g323	i0	96.111	0.452261306532663	180	7	45	0	11	190	243	422	Phytophthora infestans clone AF2 repeat region	blastn	180	296	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Peronosporales	Peronosporaceae	Phytophthora	Phytophthora infestans
7815257	7815257	PRJNA1022587_S_NODE_887_length_285_cov_0.816038_g885_i0	PRJNA1022587	887	285	0.816038	2.3257083	Phytophthora infestans	4787	SAR_Eukaryotes	SAR_Eukaryotes	475	1.32e-129	NTclustered	gi\|301090384\|ref\|XM_002895362.1\|	403677	g885	i0	96.842	6.68771929824561	285	7	100	2	1	285	1353	1071	Phytophthora infestans T30-4 uncharacterized protein (PITG_20406), partial mRNA	blastn	1906	475	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Peronosporales	Peronosporaceae	Phytophthora	Phytophthora infestans
10365911	10365911	PRJNA1022587_S_NODE_1589_length_241_cov_0.863095_g1587_i0	PRJNA1022587	1589	241	0.863095	2.08005895	Phytophthora infestans	4787	SAR_Eukaryotes	SAR_Eukaryotes	335	1.9199999999999993e-87	NTclustered	gi\|56547674\|gb\|AY830090.1\|	4787	g1587	i0	96.098	2.17842323651452	205	8	99	0	1	205	2074	1870	Phytophthora infestans clone PI-BAC-11A5 INF1 (inf1) and INF4 (inf4) genes, complete cds; Kre6-like (kre6-like) pseudogene, complete sequence; ORF457 gene, complete cds; INF3 (inf3) pseudogene, complete sequence; and INF6 (inf6) gene, complete cds	blastn	525	335	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Peronosporales	Peronosporaceae	Phytophthora	Phytophthora infestans
14191296	14191296	PRJNA1022587_S_NODE_1132_length_263_cov_0.789474_g1130_i0	PRJNA1022587	1132	263	0.789474	2.07631662	Phytophthora infestans	4787	SAR_Eukaryotes	SAR_Eukaryotes	198	2.9099999999999993e-46	NTclustered	gi\|301103683\|ref\|XM_002900882.1\|	403677	g1130	i0	97.436	0.444866920152091	117	2	44	1	12	128	164	49	Phytophthora infestans T30-4 uncharacterized protein (PITG_12329), partial mRNA	blastn	117	198	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Peronosporales	Peronosporaceae	Phytophthora	Phytophthora infestans
15031828	15031828	PRJNA1022587_S_NODE_1152_length_260_cov_2.486631_g1150_i0	PRJNA1022587	1152	260	2.486631	6.4652406	Phytophthora	4783	SAR_Eukaryotes	SAR_Eukaryotes	444	3.35e-120	NTclustered	gi\|33520246\|gb\|AY273991.1\|	4787	g1150	i0	100	92.3692307692308	240	0	92	0	3	242	495	734	Phytophthora infestans large subunit ribosomal RNA gene, partial sequence	blastn	24016	444	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Peronosporales	Peronosporaceae	Phytophthora	Phytophthora infestans
15465464	15465464	PRJNA1022587_S_NODE_213_length_454_cov_1.291339_g211_i0	PRJNA1022587	213	454	1.291339	5.86267906	Phytophthora infestans	4787	SAR_Eukaryotes	SAR_Eukaryotes	710	0	NTclustered	gi\|56547674\|gb\|AY830090.1\|	4787	g211	i0	94.934	2.60352422907489	454	22	100	1	1	454	1404	1856	Phytophthora infestans clone PI-BAC-11A5 INF1 (inf1) and INF4 (inf4) genes, complete cds; Kre6-like (kre6-like) pseudogene, complete sequence; ORF457 gene, complete cds; INF3 (inf3) pseudogene, complete sequence; and INF6 (inf6) gene, complete cds	blastn	1182	710	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Peronosporales	Peronosporaceae	Phytophthora	Phytophthora infestans
15465468	15465468	PRJNA1022587_S_NODE_953_length_278_cov_1.004878_g951_i0	PRJNA1022587	953	278	1.004878	2.79356084	Phytophthora sojae	67593	SAR_Eukaryotes	SAR_Eukaryotes	300	8.280000000000001e-77	NTclustered	gi\|695428791\|ref\|XM_009531739.1\|	67593	g951	i0	100	0.58273381294964	162	0	58	0	1	162	511	672	Phytophthora sojae hypothetical protein partial mRNA	blastn	162	300	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Peronosporales	Peronosporaceae	Phytophthora	Phytophthora sojae
16739625	16739625	PRJNA1022587_S_NODE_1454_length_245_cov_0.726744_g1452_i0	PRJNA1022587	1454	245	0.726744	1.7805228	Phytophthora sojae	67593	SAR_Eukaryotes	SAR_Eukaryotes	442	1.1199999999999994e-119	NTclustered	gi\|695428791\|ref\|XM_009531739.1\|	67593	g1452	i0	99.184	1.98775510204082	245	2	100	0	1	245	570	326	Phytophthora sojae hypothetical protein partial mRNA	blastn	487	442	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Peronosporales	Peronosporaceae	Phytophthora	Phytophthora sojae
16739626	16739626	PRJNA1022587_S_NODE_1494_length_244_cov_0.847953_g1492_i0	PRJNA1022587	1494	244	0.847953	2.06900532	Phytophthora infestans	4787	SAR_Eukaryotes	SAR_Eukaryotes	435	1.87e-117	NTclustered	gi\|56547695\|gb\|AY830101.1\|	4787	g1492	i0	98.77	7.86885245901639	244	3	100	0	1	244	576	819	Phytophthora infestans gypsy-like retrotransposon GypsyPi-1b, complete sequence	blastn	1920	435	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Peronosporales	Peronosporaceae	Phytophthora	Phytophthora infestans
16739627	16739627	PRJNA1022587_S_NODE_1554_length_242_cov_0.881657_g1552_i0	PRJNA1022587	1554	242	0.881657	2.13360994	Phytophthora infestans	4787	SAR_Eukaryotes	SAR_Eukaryotes	381	2.449999999999999e-101	NTclustered	gi\|62147598\|emb\|AJ893357.1\|	4787	g1552	i0	95.041	1	242	12	100	0	1	242	95799	96040	Phytophthora infestans, clone PI-BAC-49P21	blastn	242	381	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Peronosporales	Peronosporaceae	Phytophthora	Phytophthora infestans
18014551	18014551	PRJNA1022587_S_NODE_595_length_322_cov_1.108434_g593_i0	PRJNA1022587	595	322	1.108434	3.56915748	Phytophthora infestans	4787	SAR_Eukaryotes	SAR_Eukaryotes	579	1.1199999999999997e-160	NTclustered	gi\|56547697\|gb\|AY830103.1\|	4787	g593	i0	99.068	9.1055900621118	322	3	100	0	1	322	1617	1296	Phytophthora infestans gypsy-like retrotransposon GypsyPi-1d, complete sequence	blastn	2932	579	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Peronosporales	Peronosporaceae	Phytophthora	Phytophthora infestans
21839569	21839569	PRJNA1022587_S_NODE_1218_length_255_cov_0.906593_g1216_i0	PRJNA1022587	1218	255	0.906593	2.31181215	Phytophthora infestans	4787	SAR_Eukaryotes	SAR_Eukaryotes	436	5.469999999999999e-118	NTclustered	gi\|56547674\|gb\|AY830090.1\|	4787	g1216	i0	97.638	9.90980392156863	254	6	99	0	1	254	101287	101034	Phytophthora infestans clone PI-BAC-11A5 INF1 (inf1) and INF4 (inf4) genes, complete cds; Kre6-like (kre6-like) pseudogene, complete sequence; ORF457 gene, complete cds; INF3 (inf3) pseudogene, complete sequence; and INF6 (inf6) gene, complete cds	blastn	2527	436	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Peronosporales	Peronosporaceae	Phytophthora	Phytophthora infestans
21839574	21839574	PRJNA1022587_S_NODE_838_length_290_cov_0.944700_g836_i0	PRJNA1022587	838	290	0.9447	2.73963	Phytophthora ramorum	164328	SAR_Eukaryotes	SAR_Eukaryotes	69.4	2.67e-7	NTclustered	gi\|2794930048\|ref\|XM_067885575.1\|	164328	g836	i0	89.655	0.6	58	0	18	1	239	290	1	58	Phytophthora ramorum Retrovirus-related Pol polyprotein from transposon TNT 1-94 (KRP23_14722), partial mRNA	blastn	174	69.4	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Peronosporales	Peronosporaceae	Phytophthora	Phytophthora ramorum
23956426	23956426	PRJNA1022587_S_NODE_899_length_284_cov_0.966825_g897_i0	PRJNA1022587	899	284	0.966825	2.745783	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	525	1.2899999999999994e-144	NTclustered	gi\|1552298312\|gb\|MH401206.1\|	4787	g897	i0	100	100	284	0	100	0	1	284	647	364	Phytophthora infestans strain 13-A2 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	28400	525	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Peronosporales	Peronosporaceae	Phytophthora	Phytophthora infestans
24388776	24388776	PRJNA1022587_S_NODE_400_length_369_cov_0.777027_g398_i0	PRJNA1022587	400	369	0.777027	2.86722963	Phytophthora infestans	4787	SAR_Eukaryotes	SAR_Eukaryotes	580	3.619999999999999e-161	NTclustered	gi\|62147598\|emb\|AJ893357.1\|	4787	g398	i0	95.122	2.00271002710027	369	17	100	1	1	369	90316	90683	Phytophthora infestans, clone PI-BAC-49P21	blastn	739	580	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Peronosporales	Peronosporaceae	Phytophthora	Phytophthora infestans

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