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

13 rows where analysis = "blastn", bioproject = "PRJNA1112809" 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
219989	219989	PRJNA1112809_P_NODE_182781_length_244_cov_2.678363_g179506_i0	PRJNA1112809	182781	244	2.678363	6.53520572	Neospora caninum	29176	SAR_Eukaryotes	SAR_Eukaryotes	348	2.51e-91	NTclustered	gi\|820695469\|tpe\|LN714488.1\|	572307	g179506	i0	93.22	44.4754098360656	236	16	97	0	1	236	116600	116365	TPA_asm: Neospora caninum Liverpool, unplaced_1, complete genome	blastn	10852	348	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Sarcocystidae	Neospora	Neospora caninum
2769696	2769696	PRJNA1112809_P_NODE_127723_length_287_cov_1.439252_g124448_i0	PRJNA1112809	127723	287	1.439252	4.13065324	Neospora caninum	29176	SAR_Eukaryotes	SAR_Eukaryotes	303	6.64e-78	NTclustered	gi\|820695469\|tpe\|LN714488.1\|	572307	g124448	i0	92.488	30.6062717770035	213	15	98	1	1	213	300530	300319	TPA_asm: Neospora caninum Liverpool, unplaced_1, complete genome	blastn	8784	303	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Sarcocystidae	Neospora	Neospora caninum
2769975	2769975	PRJNA1112809_P_NODE_143803_length_269_cov_3.137755_g140528_i0	PRJNA1112809	143803	269	3.137755	8.44056095	uncultured ciliate	187299	SAR_Eukaryotes	SAR_Eukaryotes	497	2.63e-136	NTclustered	gi\|1628762178\|gb\|MK868185.1\|	187299	g140528	i0	100	100.2156133829	269	0	100	0	1	269	110	378	Uncultured ciliate clone TFA3.22 small subunit ribosomal RNA gene, partial sequence	blastn	26958	497	1	Eukaryota	Sar	Ciliophora					uncultured ciliate
8676628	8676628	PRJNA1112809_P_NODE_188027_length_243_cov_0.905882_g184752_i0	PRJNA1112809	188027	243	0.905882	2.20129326	Xanthonema	82368	SAR_Eukaryotes	SAR_Eukaryotes	444	3.09e-120	NTclustered	gi\|2358229\|gb\|U43277.1\|HDU43277	82369	g184752	i0	99.588	100.481481481481	243	1	100	0	1	243	354	112	Heterothrix debilis nuclear 18S ribosomal RNA gene	blastn	24417	444	1	Eukaryota	Sar		Xanthophyceae	Tribonematales	Xanthonemataceae	Xanthonema	Xanthonema debile
11226609	11226609	PRJNA1112809_P_NODE_142789_length_270_cov_5.827411_g139514_i0	PRJNA1112809	142789	270	5.827411	15.7340097	root	1	Root_unresolved	Root_unresolved	477	3.4499999999999986e-130	NTclustered	gi\|345541658\|gb\|JN547815.1\|	5911	g139514	i0	98.519	80.3296296296296	270	4	100	0	1	270	3528	3797	Tetrahymena thermophila strain ATCC 30382 18S ribosomal RNA gene, partial sequence; and internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, and 26S ribosomal RNA gene, complete sequence	blastn	21689	477	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Hymenostomatida	Tetrahymenidae	Tetrahymena	Tetrahymena thermophila
12973029	12973029	PRJNA1112809_P_NODE_133071_length_281_cov_1.370192_g129796_i0	PRJNA1112809	133071	281	1.370192	3.85023952	Tetrahymena thermophila	5911	SAR_Eukaryotes	SAR_Eukaryotes	176	1.47e-39	NTclustered	gi\|829188477\|ref\|XM_001023087.3\|	312017	g129796	i0	82.673	26.9679715302491	202	31	71	4	8	207	850	1049	Tetrahymena thermophila SB210 S-adenosyl-L-homocysteine hydrolase partial mRNA	blastn	7578	176	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Hymenostomatida	Tetrahymenidae	Tetrahymena	Tetrahymena thermophila
14247915	14247915	PRJNA1112809_P_NODE_123592_length_292_cov_1.406393_g120317_i0	PRJNA1112809	123592	292	1.406393	4.10666756	Chrysolepidomonas dendrolepidota	64707	SAR_Eukaryotes	SAR_Eukaryotes	425	1.38e-114	NTclustered	gi\|16326553\|gb\|AF409121.1\|	64707	g120317	i0	93.151	100.027397260274	292	17	100	2	1	292	3326	3038	Chrysolepidomonas dendrolepidota internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, and 28S large subunit ribosomal RNA gene, complete sequence	blastn	29208	425	1	Eukaryota	Sar		Chrysophyceae	Chromulinales	Chrysolepidomonadaceae	Chrysolepidomonas	Chrysolepidomonas dendrolepidota
14248927	14248927	PRJNA1112809_P_NODE_177492_length_246_cov_1.653179_g174217_i0	PRJNA1112809	177492	246	1.653179	4.06682034	Neospora caninum	29176	SAR_Eukaryotes	SAR_Eukaryotes	237	5.72e-58	NTclustered	gi\|820695469\|tpe\|LN714488.1\|	572307	g174217	i0	84.979	9.07317073170732	233	35	100	0	14	246	96457	96225	TPA_asm: Neospora caninum Liverpool, unplaced_1, complete genome	blastn	2232	237	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Sarcocystidae	Neospora	Neospora caninum
14250681	14250681	PRJNA1112809_P_NODE_92572_length_347_cov_4.594891_g89297_i0	PRJNA1112809	92572	347	4.594891	15.94427177	Tetrahymena pyriformis	5908	SAR_Eukaryotes	SAR_Eukaryotes	597	3.369999999999999e-166	NTclustered	gi\|10782\|emb\|X54004.1\|	5908	g89297	i0	97.983	57.7060518731988	347	2	100	1	1	347	3290	2949	Tetrahymena pyriformis gene for 26S large subunit ribosomal RNA	blastn	20024	597	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Hymenostomatida	Tetrahymenidae	Tetrahymena	Tetrahymena pyriformis
21895594	21895594	PRJNA1112809_P_NODE_113678_length_306_cov_3.180258_g110403_i0	PRJNA1112809	113678	306	3.180258	9.73158948	Esquamula lacrimiformis	1176540	SAR_Eukaryotes	SAR_Eukaryotes	206	2.0699999999999997e-48	NTclustered	gi\|409971369\|dbj\|AB714271.1\|	1176540	g110403	i0	87.363	65.1176470588235	182	19	59	4	2	181	3696	3875	Esquamula lacrimiformis gene for 28S ribosomal RNA, partial sequence	blastn	19926	206	1	Eukaryota	Sar	Cercozoa	Imbricatea	Thaumatomonadida		Esquamula	Esquamula lacrimiformis
21896454	21896454	PRJNA1112809_P_NODE_155878_length_258_cov_1.529730_g152603_i0	PRJNA1112809	155878	258	1.52973	3.9467034	Cryptosporidium hominis	237895	SAR_Eukaryotes	SAR_Eukaryotes	460	3.29e-125	NTclustered	gi\|67586105\|ref\|XM_660074.1\|	353151	g152603	i0	98.842	6.03875968992248	259	1	100	2	1	258	1095	838	Cryptosporidium hominis TU502 sensor histidine kinase (Chro.00003) partial mRNA	blastn	1558	460	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Cryptosporidiidae	Cryptosporidium	Cryptosporidium hominis
23172066	23172066	PRJNA1112809_P_NODE_163919_length_251_cov_1.224719_g160644_i0	PRJNA1112809	163919	251	1.224719	3.07404469	Neospora caninum	29176	SAR_Eukaryotes	SAR_Eukaryotes	176	1.2899999999999999e-39	NTclustered	gi\|820695469\|tpe\|LN714488.1\|	572307	g160644	i0	94.017	32.6374501992032	117	5	70	2	76	192	300012	299898	TPA_asm: Neospora caninum Liverpool, unplaced_1, complete genome	blastn	8192	176	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Sarcocystidae	Neospora	Neospora caninum
24445753	24445753	PRJNA1112809_P_NODE_160500_length_254_cov_1.237569_g157225_i0	PRJNA1112809	160500	254	1.237569	3.14342526	Eimeria maxima	5804	SAR_Eukaryotes	SAR_Eukaryotes	52.8	0.023	NTclustered	gi\|915123824\|ref\|XM_013477722.1\|	5804	g157225	i0	100	0.110236220472441	28	0	11	0	161	188	2407	2434	Eimeria maxima hypothetical protein, conserved partial mRNA	blastn	28	52.8	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Eimeriidae	Eimeria	Eimeria maxima

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