metadata: contig_metadata: 14 rows where bioproject = "PRJNA454154" and tax

14 rows where bioproject = "PRJNA454154" 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
1093464	1093464	PRJNA454154_S_NODE_61_length_343_cov_85.529412_g58_i0	PRJNA454154	61	343	85.529412	293.36588316	Sessilida	1974272	SAR_Eukaryotes	SAR_Eukaryotes	590	5.56e-164	NTclustered	gi\|512134943\|gb\|JX178902.1\|	1295638	g58	i0	97.668	98.997084548105	343	8	100	0	1	343	1402	1060	Vorticella sp. 4 JG-2011 clone 2 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	33956	590	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Sessilida	Vorticellidae	Vorticella	Vorticella sp. 4 JG-2011
2992595	2992595	PRJNA454154_S_NODE_503_length_167_cov_7.823077_g500_i0	PRJNA454154	503	167	7.823077	13.06453859	uncultured stramenopile	152704	SAR_Eukaryotes	SAR_Eukaryotes	272	9.88e-69	NTclustered	gi\|187944206\|gb\|EU528042.1\|	152704	g500	i0	97.484	75.0419161676647	159	4	95	0	7	165	603	445	Uncultured stramenopile clone E2-B5 small subunit ribosomal RNA gene, partial sequence	blastn	12532	272	1	Eukaryota	Sar						uncultured stramenopile
3644449	3644449	PRJNA454154_S_NODE_323_length_193_cov_2.852564_g320_i0	PRJNA454154	323	193	2.852564	5.50544852	Poterioochromonas	88166	SAR_Eukaryotes	SAR_Eukaryotes	200	5.62e-47	NTclustered	gi\|323690576\|gb\|GU935635.1\|	88167	g320	i0	86.096	97.2901554404145	187	25	97	1	1	187	1409	1594	Poteriochroomonas malhamensis strain SAG 933.1c 28S ribosomal RNA gene, partial sequence	blastn	18777	200	1	Eukaryota	Sar		Synurophyceae	Ochromonadales	Ochromonadaceae	Poterioochromonas	Poterioochromonas malhamensis
8095072	8095072	PRJNA454154_S_NODE_447_length_176_cov_6.352518_g444_i0	PRJNA454154	447	176	6.352518	11.18043168	Poterioochromonas malhamensis	88167	SAR_Eukaryotes	SAR_Eukaryotes	324	2.85e-84	NTclustered	gi\|2088238071\|ref\|NC_056910.1\|	88167	g444	i0	100	91.9375	175	0	99	0	2	176	17680	17506	Poterioochromonas malhamensis strain SZCZR2049 plastid, complete genome	blastn	16181	324	1	Eukaryota	Sar		Synurophyceae	Ochromonadales	Ochromonadaceae	Poterioochromonas	Poterioochromonas malhamensis
10645825	10645825	PRJNA454154_S_NODE_309_length_194_cov_79.585987_g306_i0	PRJNA454154	309	194	79.585987	154.39681478	uncultured stramenopile	152704	SAR_Eukaryotes	SAR_Eukaryotes	207	3.38e-49	NTclustered	gi\|187944206\|gb\|EU528042.1\|	152704	g306	i0	98.305	82.8762886597938	118	2	61	0	31	148	118	1	Uncultured stramenopile clone E2-B5 small subunit ribosomal RNA gene, partial sequence	blastn	16078	207	1	Eukaryota	Sar						uncultured stramenopile
11920747	11920747	PRJNA454154_S_NODE_10_length_523_cov_39.701646_g7_i0	PRJNA454154	10	523	39.701646	207.63960858	Plasmodium chabaudi	5825	SAR_Eukaryotes	SAR_Eukaryotes	65.8	6.59e-6	NTclustered	gi\|1027949921\|ref\|XR_001678647.1\|	31271	g7	i0	77.311	0.227533460803059	119	21	22	4	408	522	1465	1349	Plasmodium chabaudi chabaudi 28S ribosomal RNA (PCHAS_0521461), rRNA	blastn	119	65.8	1	Eukaryota	Sar	Apicomplexa	Aconoidasida	Haemosporida	Plasmodiidae	Plasmodium	Plasmodium chabaudi
13195558	13195558	PRJNA454154_S_NODE_111_length_275_cov_5.210084_g108_i0	PRJNA454154	111	275	5.210084	14.327731	Plasmopara pimpinellae	162137	SAR_Eukaryotes	SAR_Eukaryotes	185	2.3899999999999998e-42	NTclustered	gi\|33520243\|gb\|AY273988.1\|	162137	g108	i0	80.859	75.92	256	32	91	13	25	274	217	461	Plasmopara pimpinellae large subunit ribosomal RNA gene, partial sequence	blastn	20878	185	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Peronosporales	Peronosporaceae	Plasmopara	Plasmopara pimpinellae
13847005	13847005	PRJNA454154_S_NODE_271_length_202_cov_10.387879_g268_i0	PRJNA454154	271	202	10.387879	20.98351558	Sessilida	1974272	SAR_Eukaryotes	SAR_Eukaryotes	335	1.5599999999999993e-87	NTclustered	gi\|363412153\|gb\|JN120227.1\|	60850	g268	i0	100	89.6039603960396	181	0	90	0	7	187	620	800	Vorticella convallaria isolate 96Vorsp16 18S ribosomal RNA gene, partial sequence	blastn	18100	335	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Sessilida	Vorticellidae	Vorticella	Vorticella convallaria
17019265	17019265	PRJNA454154_S_NODE_594_length_157_cov_4.116667_g591_i0	PRJNA454154	594	157	4.116667	6.46316719	Arachnula sp. CL22	862246	SAR_Eukaryotes	SAR_Eukaryotes	54.7	0.004	NTclustered	gi\|301014696\|gb\|GQ377694.1\|	862246	g591	i0	92.308	0.248407643312102	39	2	24	1	118	155	236	198	Arachnula sp. CL22 ribosomal protein S23a (rps23a) mRNA, partial cds	blastn	39	54.7	1	Eukaryota	Sar	Endomyxa		Vampyrellida	Leptophryidae	Arachnula	Arachnula sp. CL22
24668136	24668136	PRJNA454154_S_NODE_440_length_177_cov_2.685714_g437_i0	PRJNA454154	440	177	2.685714	4.75371378	Bakuella subtropica	1295181	SAR_Eukaryotes	SAR_Eukaryotes	121	4.039999999999999e-23	NTclustered	gi\|2468680567\|ref\|NC_072596.1\|	1295181	g437	i0	81.457	11.0847457627119	151	24	84	4	30	177	45124	44975	Bakuella subtropica mitochondrion, complete genome	blastn	1962	121	1	Eukaryota	Sar	Ciliophora	Spirotrichea	Urostylida	Bakuellidae	Bakuella	Bakuella subtropica
25319657	25319657	PRJNA454154_S_NODE_160_length_243_cov_3.737864_g157_i0	PRJNA454154	160	243	3.737864	9.08300952	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	180	9.63e-41	NTclustered	gi\|166303\|gb\|J05116.1\|ACKCAL	4767	g157	i0	85.227	36.2510288065844	176	24	72	2	63	237	945	771	A.klebsiana calmodulin gene, complete cds	blastn	8809	180	1	Eukaryota	Sar	Oomycota	Saprolegniomycetes	Saprolegniales	Achlyaceae	Achlya	Achlya klebsiana
29839596	29839596	PRJNA454154_S_NODE_391_length_183_cov_7.602740_g388_i0	PRJNA454154	391	183	7.60274	13.9130142	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	42	0.0307	NR	XP_013249139.1	5801	g388	i0	76	1.59016393442623	25	6	41	0	1	75	220	244	XP_013249139.1 60S ribosomal protein L8, putative [Eimeria acervulina]	diamond	291	42.4	0.990566037735849	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Eimeriidae	Eimeria	Eimeria acervulina
31940912	31940912	PRJNA454154_S_NODE_517_length_166_cov_1.131783_g514_i0	PRJNA454154	517	166	1.131783	1.87875978	Hondaea fermentalgiana	2315210	SAR_Eukaryotes	SAR_Eukaryotes	50.1	5.64e-6	NR	GBG29256.1	2315210	g514	i0	88.9	0.487951807228916	27	3	48.8	0	159	79	79	105	GBG29256.1 Non-specific lipid-transfer protein [Hondaea fermentalgiana]	diamond	81	50.1	1	Eukaryota	Sar		Bigyra	Thraustochytrida	Thraustochytriidae	Hondaea	Hondaea fermentalgiana
32321104	32321104	PRJNA454154_S_NODE_199_length_228_cov_4.277487_g196_i0	PRJNA454154	199	228	4.277487	9.75267036	Stentor coeruleus	5963	SAR_Eukaryotes	SAR_Eukaryotes	62.4	6.75e-11	NR	OMJ89045.1	5963	g196	i0	66	3.27631578947368	50	16	64.5	1	211	65	17	66	OMJ89045.1 hypothetical protein SteCoe_8868 [Stentor coeruleus]	diamond	747	62.4	1	Eukaryota	Sar	Ciliophora	Heterotrichea	Heterotrichida	Stentoridae	Stentor	Stentor coeruleus

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