metadata: contig_metadata: 13 rows where analysis = "blastn", bioproject = "PRJNA473799" and tax

13 rows where analysis = "blastn", bioproject = "PRJNA473799" 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
6199120	6199120	PRJNA473799_P_NODE_7345_length_405_cov_11.307229_g7071_i0	PRJNA473799	7345	405	11.307229	45.79427745	Phaeophyceae	2870	SAR_Eukaryotes	SAR_Eukaryotes	108	8.18e-19	NTclustered	gi\|16326555\|gb\|AF409123.1\|	2889	g7071	i0	81.379	32.9728395061728	145	15	34	9	10	147	3797	3936	Alaria esculenta internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, and 28S large subunit ribosomal RNA gene, complete sequence	blastn	13354	108	1	Eukaryota	Sar		Phaeophyceae	Laminariales	Alariaceae	Alaria	Alaria esculenta
6823515	6823515	PRJNA473799_P_NODE_45006_length_246_cov_0.890173_g44732_i0	PRJNA473799	45006	246	0.890173	2.18982558	Aphanomyces euteiches	100861	SAR_Eukaryotes	SAR_Eukaryotes	444	3.14e-120	NTclustered	gi\|166046624\|emb\|CU367741.1\|	100861	g44732	i0	99.187	53.349593495935	246	2	100	0	1	246	40	285	Aphanomyces euteiches cDNA	blastn	13124	444	1	Eukaryota	Sar	Oomycota	Saprolegniomycetes	Saprolegniales	Verrucalvaceae	Aphanomyces	Aphanomyces euteiches
8098467	8098467	PRJNA473799_P_NODE_13607_length_296_cov_1.004484_g13333_i0	PRJNA473799	13607	296	1.004484	2.97327264	Cryptosporidium sp. duck-like genotype	1856839	SAR_Eukaryotes	SAR_Eukaryotes	137	7.38e-28	NTclustered	gi\|1272609485\|gb\|KY882340.1\|	1856839	g13333	i0	94.382	32.3310810810811	89	5	30	0	1	89	189	101	Cryptosporidium sp. duck-like genotype isolate UY5645 28S ribosomal RNA gene, partial sequence	blastn	9570	137	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Cryptosporidiidae	Cryptosporidium	Cryptosporidium sp. duck-like genotype
9373390	9373390	PRJNA473799_P_NODE_30728_length_257_cov_2.478261_g30454_i0	PRJNA473799	30728	257	2.478261	6.36913077	Neospora caninum	29176	SAR_Eukaryotes	SAR_Eukaryotes	241	4.65e-59	NTclustered	gi\|820695469\|tpe\|LN714488.1\|	572307	g30454	i0	87.923	1.61089494163424	207	21	80	4	2	206	80544	80340	TPA_asm: Neospora caninum Liverpool, unplaced_1, complete genome	blastn	414	241	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Sarcocystidae	Neospora	Neospora caninum
11299122	11299122	PRJNA473799_P_NODE_5529_length_517_cov_9.927928_g5262_i0	PRJNA473799	5529	517	9.927928	51.32738776	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	202	4.75e-47	NTclustered	gi\|223047900\|gb\|FJ032683.1\|	329655	g5262	i0	86.316	67.6382978723404	190	20	43	6	331	517	2416	2230	Uncultured marine Polycystinea clone Ma_1A27 28S ribosomal RNA gene, partial sequence	blastn	34969	202	1	Eukaryota	Sar		Polycystinea				uncultured marine Polycystinea
13199707	13199707	PRJNA473799_P_NODE_9931_length_335_cov_1.549618_g9657_i0	PRJNA473799	9931	335	1.549618	5.1912203	Chilodonella piscicola	1654720	SAR_Eukaryotes	SAR_Eukaryotes	553	7.099999999999998e-153	NTclustered	gi\|1389430804\|gb\|MH341632.1\|	1654720	g9657	i0	96.418	36.8268656716418	335	12	100	0	1	335	348	14	Chilodonella piscicola strain SC large subunit ribosomal RNA gene, partial sequence	blastn	12337	553	1	Eukaryota	Sar	Ciliophora	Phyllopharyngea	Chlamydodontida	Chilodonellidae	Chilodonella	Chilodonella piscicola
18297605	18297605	PRJNA473799_P_NODE_57055_length_227_cov_3.064935_g56781_i0	PRJNA473799	57055	227	3.064935	6.95740245	Neospora caninum	29176	SAR_Eukaryotes	SAR_Eukaryotes	281	2.37e-71	NTclustered	gi\|820695469\|tpe\|LN714488.1\|	572307	g56781	i0	89.083	1.99559471365639	229	21	100	4	1	227	80266	80492	TPA_asm: Neospora caninum Liverpool, unplaced_1, complete genome	blastn	453	281	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Sarcocystidae	Neospora	Neospora caninum
19571666	19571666	PRJNA473799_P_NODE_50296_length_243_cov_0.905882_g50022_i0	PRJNA473799	50296	243	0.905882	2.20129326	Heteromita sp. PRA-74	323453	SAR_Eukaryotes	SAR_Eukaryotes	148	2.72e-31	NTclustered	gi\|300676723\|gb\|GQ377712.1\|	323453	g50022	i0	81.921	0.728395061728395	177	31	73	1	1	177	185	10	Heteromita sp. PRA-74 elongation factor 2 (ef2) mRNA, partial cds	blastn	177	148	1	Eukaryota	Sar	Cercozoa		Cercomonadida	Heteromitidae	Heteromita	Heteromita sp. PRA-74
19571674	19571674	PRJNA473799_P_NODE_50776_length_243_cov_0.905882_g50502_i0	PRJNA473799	50776	243	0.905882	2.20129326	uncultured Chrysophyceae	183512	SAR_Eukaryotes	SAR_Eukaryotes	449	6.65e-122	NTclustered	gi\|406609781\|dbj\|AB749056.1\|	183512	g50502	i0	100	100.004115226337	243	0	100	0	1	243	248	6	Uncultured chrysophyte gene for 18S ribosomal RNA, partial sequence, clone: Cn-St.6-7	blastn	24301	449	1	Eukaryota	Sar		Chrysophyceae				uncultured Chrysophyceae
22122198	22122198	PRJNA473799_P_NODE_35438_length_251_cov_0.865169_g35164_i0	PRJNA473799	35438	251	0.865169	2.17157419	Saprolegnia parasitica	101203	SAR_Eukaryotes	SAR_Eukaryotes	52.8	0.023	NTclustered	gi\|813143131\|ref\|XM_012344133.1\|	695850	g35164	i0	100	0.111553784860558	28	0	11	0	68	95	1436	1409	Saprolegnia parasitica CBS 223.65 hypothetical protein partial mRNA	blastn	28	52.8	1	Eukaryota	Sar	Oomycota	Saprolegniomycetes	Saprolegniales	Saprolegniaceae	Saprolegnia	Saprolegnia parasitica
23397776	23397776	PRJNA473799_P_NODE_2579_length_884_cov_18.921085_g2350_i0	PRJNA473799	2579	884	18.921085	167.2623914	Heterosigma akashiwo	2829	SAR_Eukaryotes	SAR_Eukaryotes	427	1.27e-114	NTclustered	gi\|16326556\|gb\|AF409124.1\|	2829	g2350	i0	78.212	58.7601809954751	716	122	80	27	179	884	2706	2015	Heterosigma akashiwo internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, and 28S large subunit ribosomal RNA gene, complete sequence	blastn	51944	427	1	Eukaryota	Sar		Raphidophyceae	Chattonellales	Chattonellaceae	Heterosigma	Heterosigma akashiwo
23397904	23397904	PRJNA473799_P_NODE_34679_length_251_cov_0.882022_g34405_i0	PRJNA473799	34679	251	0.882022	2.21387522	Albugo laibachii	653948	SAR_Eukaryotes	SAR_Eukaryotes	420	5.41e-113	NTclustered	gi\|325194231\|emb\|FR825088.1\|	890382	g34405	i0	96.813	1.31075697211155	251	8	100	0	1	251	444	694	Albugo laibachii Nc14, genomic contig CONTIG_1612_NC14_v4_1853_85	blastn	329	420	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Albuginales	Albuginaceae	Albugo	Albugo laibachii
24047504	24047504	PRJNA473799_P_NODE_13779_length_294_cov_1.968326_g13505_i0	PRJNA473799	13779	294	1.968326	5.78687844	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	145	4.3699999999999995e-30	NTclustered	gi\|2202538974\|gb\|OM891880.1\|	355634	g13505	i0	87.805	53.5374149659864	123	15	42	0	119	241	3709	3831	Navicula arenaria small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence	blastn	15740	145	1	Eukaryota	Sar	Bacillariophyta	Bacillariophyceae	Naviculales	Naviculaceae	Navicula	Navicula arenaria

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