metadata: contig_metadata: 22 rows where analysis = "blastn", bioproject = "PRJNA1249535" and tax

22 rows where analysis = "blastn", bioproject = "PRJNA1249535" and tax_phylum = "Ciliophora"

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
357306	357306	PRJNA1249535_S_NODE_283581_length_262_cov_1.238095_g280198_i0	PRJNA1249535	283581	262	1.238095	3.2438089	Trachelocercidae sp. 3 BS-2022	2930473	SAR_Eukaryotes	SAR_Eukaryotes	54.7	0.007	NTclustered	gi\|2261268975\|emb\|OX095823.1\|	2930473	g280198	i0	100	0.217557251908397	29	0	11	0	234	262	37	9	Trachelocercidae sp. 3 BS-2022 partial 18S rRNA gene, isolate SAMEA13863269, clone N34:18S_rRNA::TRINITY_DN3988_c0_g1_i52:177-1769(-)	blastn	57	54.7	1	Eukaryota	Sar	Ciliophora	Karyorelictea	Protostomatida	Trachelocercidae		Trachelocercidae sp. 3 BS-2022
2905832	2905832	PRJNA1249535_S_NODE_106323_length_368_cov_5.586441_g102940_i0	PRJNA1249535	106323	368	5.586441	20.55810288	Ichthyophthirius multifiliis	5932	SAR_Eukaryotes	SAR_Eukaryotes	569	7.809999999999997e-158	NTclustered	gi\|161087246\|gb\|EU185635.1\|	5932	g102940	i0	94.595	64.5842391304348	370	17	100	3	1	368	1736	2104	Ichthyophthirius multifiliis 28S ribosomal RNA gene, partial sequence	blastn	23767	569	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Hymenostomatida		Ichthyophthirius	Ichthyophthirius multifiliis
2906555	2906555	PRJNA1249535_S_NODE_153763_length_333_cov_1.738462_g150380_i0	PRJNA1249535	153763	333	1.738462	5.78907846	Paramecium tetraurelia	5888	SAR_Eukaryotes	SAR_Eukaryotes	56.5	0.002	NTclustered	gi\|145534274\|ref\|XM_001452845.1\|	5888	g150380	i0	97.059	0.27027027027027	34	0	10	1	268	300	1460	1493	Paramecium tetraurelia uncharacterized protein (GSPATT00002886001), partial mRNA	blastn	90	56.5	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Peniculida	Parameciidae	Paramecium	Paramecium tetraurelia
4184803	4184803	PRJNA1249535_S_NODE_305424_length_250_cov_1.322034_g302041_i0	PRJNA1249535	305424	250	1.322034	3.305085	Paraurostyla viridis	57502	SAR_Eukaryotes	SAR_Eukaryotes	52.8	0.023	NTclustered	gi\|15554319\|gb\|AY044840.1\|	57502	g302041	i0	96.774	0.124	31	1	12	0	214	244	97	127	Paraurostyla viridis macronuclear actin I gene, complete cds	blastn	31	52.8	1	Eukaryota	Sar	Ciliophora	Spirotrichea	Stichotrichida	Amphisiellidae	Paraurostyla	Paraurostyla viridis
9284829	9284829	PRJNA1249535_S_NODE_215488_length_298_cov_2.488889_g212105_i0	PRJNA1249535	215488	298	2.488889	7.41688922	Ichthyophthirius multifiliis	5932	SAR_Eukaryotes	SAR_Eukaryotes	52.8	0.028	NTclustered	gi\|471225807\|ref\|XM_004031915.1\|	5932	g212105	i0	100	0.0939597315436242	28	0	9	0	112	139	375	402	Ichthyophthirius multifiliis hypothetical protein (IMG5_133430) mRNA, complete cds	blastn	28	52.8	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Hymenostomatida		Ichthyophthirius	Ichthyophthirius multifiliis
9286349	9286349	PRJNA1249535_S_NODE_36528_length_536_cov_8.427646_g33239_i0	PRJNA1249535	36528	536	8.427646	45.17218256	Paramecium tetraurelia	5888	SAR_Eukaryotes	SAR_Eukaryotes	54.7	0.015	NTclustered	gi\|145525349\|ref\|XM_001448460.1\|	5888	g33239	i0	96.875	0.0597014925373134	32	1	6	0	52	83	774	805	Paramecium tetraurelia uncharacterized protein (GSPATT00015960001), partial mRNA	blastn	32	54.7	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Peniculida	Parameciidae	Paramecium	Paramecium tetraurelia
10563043	10563043	PRJNA1249535_S_NODE_79729_length_402_cov_1.942249_g76348_i0	PRJNA1249535	79729	402	1.942249	7.80784098	Paramecium tetraurelia	5888	SAR_Eukaryotes	SAR_Eukaryotes	56.5	0.003	NTclustered	gi\|145534274\|ref\|XM_001452845.1\|	5888	g76348	i0	97.059	0.0845771144278607	34	0	8	1	9	41	1493	1460	Paramecium tetraurelia uncharacterized protein (GSPATT00002886001), partial mRNA	blastn	34	56.5	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Peniculida	Parameciidae	Paramecium	Paramecium tetraurelia
15080074	15080074	PRJNA1249535_S_NODE_257672_length_276_cov_1.536946_g254289_i0	PRJNA1249535	257672	276	1.536946	4.24197096	root	1	Root_unresolved	Root_unresolved	329	1.05e-85	NTclustered	gi\|10832\|emb\|X54512.1\|	5911	g254289	i0	88.406	53.5942028985507	276	28	99	4	3	275	6588	6862	T. thermophila rdn A+ gene for pre-RNA, 17S rRNA, 5.8S rRNA, 26S rRNA	blastn	14792	329	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Hymenostomatida	Tetrahymenidae	Tetrahymena	Tetrahymena thermophila
15658289	15658289	PRJNA1249535_S_NODE_127193_length_351_cov_2.352518_g123810_i0	PRJNA1249535	127193	351	2.352518	8.25733818	Paramecium tetraurelia	5888	SAR_Eukaryotes	SAR_Eukaryotes	58.4	7.13e-4	NTclustered	gi\|145481216\|ref\|XM_001426594.1\|	5888	g123810	i0	84.746	0.168091168091168	59	7	17	2	1	58	1179	1122	Paramecium tetraurelia uncharacterized protein (GSPATT00029864001), partial mRNA	blastn	59	58.4	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Peniculida	Parameciidae	Paramecium	Paramecium tetraurelia
16932273	16932273	PRJNA1249535_S_NODE_103014_length_372_cov_1.501672_g99631_i0	PRJNA1249535	103014	372	1.501672	5.58621984	Remanella sp. 1 BS-2022	2930476	SAR_Eukaryotes	SAR_Eukaryotes	58.4	7.6e-4	NTclustered	gi\|2261269021\|emb\|OX095846.1\|	2930476	g99631	i0	100	0.311827956989247	31	0	8	0	342	372	42	12	Remanella sp. 1 BS-2022 partial 18S rRNA gene, isolate SAMEA13863273, clone N44:18S_rRNA::TRINITY_DN644_c0_g1_i12:99-1693(+)	blastn	116	58.4	1	Eukaryota	Sar	Ciliophora	Karyorelictea	Loxodida	Loxodidae	Remanella	Remanella sp. 1 BS-2022
16934995	16934995	PRJNA1249535_S_NODE_313754_length_245_cov_5.325581_g310371_i0	PRJNA1249535	313754	245	5.325581	13.04767345	Tetrahymena nigricans	2704176	SAR_Eukaryotes	SAR_Eukaryotes	350	7e-92	NTclustered	gi\|2082965251\|gb\|MZ827091.1\|	2704176	g310371	i0	92.683	95.2081632653061	246	12	100	5	1	245	539	779	Tetrahymena nigricans isolate VB57 internal transcribed spacer 1, partial sequence; 5.8S ribosomal RNA gene and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence	blastn	23326	350	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Hymenostomatida	Tetrahymenidae	Tetrahymena	Tetrahymena nigricans
18207168	18207168	PRJNA1249535_S_NODE_131155_length_348_cov_2.585455_g127772_i0	PRJNA1249535	131155	348	2.585455	8.9973834	Tetrahymena thermophila	5911	SAR_Eukaryotes	SAR_Eukaryotes	52.8	0.033	NTclustered	gi\|15027629\|ref\|NC_003029.1\|	5911	g127772	i0	100	0.0804597701149425	28	0	8	0	136	163	19507	19480	Tetrahymena thermophila mitochondrion, complete genome	blastn	28	52.8	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Hymenostomatida	Tetrahymenidae	Tetrahymena	Tetrahymena thermophila
18208462	18208462	PRJNA1249535_S_NODE_230435_length_290_cov_3.377880_g227052_i0	PRJNA1249535	230435	290	3.37788	9.795852	Tetrahymena thermophila	5911	SAR_Eukaryotes	SAR_Eukaryotes	54.7	0.007	NTclustered	gi\|829192088\|ref\|XM_001024080.2\|	312017	g227052	i0	100	0.1	29	0	10	0	59	87	913	941	Tetrahymena thermophila SB210 hypothetical protein partial mRNA	blastn	29	54.7	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Hymenostomatida	Tetrahymenidae	Tetrahymena	Tetrahymena thermophila
18209546	18209546	PRJNA1249535_S_NODE_322575_length_240_cov_7.431138_g319192_i0	PRJNA1249535	322575	240	7.431138	17.8347312	Paramecium tetraurelia	5888	SAR_Eukaryotes	SAR_Eukaryotes	52.8	0.022	NTclustered	gi\|145534274\|ref\|XM_001452845.1\|	5888	g319192	i0	96.875	0.133333333333333	32	0	13	1	207	238	1490	1460	Paramecium tetraurelia uncharacterized protein (GSPATT00002886001), partial mRNA	blastn	32	52.8	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Peniculida	Parameciidae	Paramecium	Paramecium tetraurelia
18210606	18210606	PRJNA1249535_S_NODE_77255_length_406_cov_2.786787_g73874_i0	PRJNA1249535	77255	406	2.786787	11.31435522	Tetrahymena thermophila	5911	SAR_Eukaryotes	SAR_Eukaryotes	52.8	0.039	NTclustered	gi\|15027629\|ref\|NC_003029.1\|	5911	g73874	i0	100	0.0689655172413793	28	0	7	0	187	214	19507	19480	Tetrahymena thermophila mitochondrion, complete genome	blastn	28	52.8	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Hymenostomatida	Tetrahymenidae	Tetrahymena	Tetrahymena thermophila
20758120	20758120	PRJNA1249535_S_NODE_215777_length_298_cov_1.955556_g212394_i0	PRJNA1249535	215777	298	1.955556	5.82755688	Paramecium tetraurelia	5888	SAR_Eukaryotes	SAR_Eukaryotes	52.8	0.028	NTclustered	gi\|145534274\|ref\|XM_001452845.1\|	5888	g212394	i0	96.875	0.10738255033557	32	0	11	1	195	226	1460	1490	Paramecium tetraurelia uncharacterized protein (GSPATT00002886001), partial mRNA	blastn	32	52.8	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Peniculida	Parameciidae	Paramecium	Paramecium tetraurelia
20758905	20758905	PRJNA1249535_S_NODE_277857_length_265_cov_1.765625_g274474_i0	PRJNA1249535	277857	265	1.765625	4.67890625	Tetrahymena thermophila	5911	SAR_Eukaryotes	SAR_Eukaryotes	52.8	0.024	NTclustered	gi\|15027629\|ref\|NC_003029.1\|	5911	g274474	i0	100	0.105660377358491	28	0	11	0	212	239	19507	19480	Tetrahymena thermophila mitochondrion, complete genome	blastn	28	52.8	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Hymenostomatida	Tetrahymenidae	Tetrahymena	Tetrahymena thermophila
22032704	22032704	PRJNA1249535_S_NODE_166378_length_325_cov_2.984127_g162995_i0	PRJNA1249535	166378	325	2.984127	9.69841275	Paramecium tetraurelia	5888	SAR_Eukaryotes	SAR_Eukaryotes	56.5	0.002	NTclustered	gi\|145534274\|ref\|XM_001452845.1\|	5888	g162995	i0	97.059	0.104615384615385	34	0	10	1	285	317	1460	1493	Paramecium tetraurelia uncharacterized protein (GSPATT00002886001), partial mRNA	blastn	34	56.5	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Peniculida	Parameciidae	Paramecium	Paramecium tetraurelia
22032840	22032840	PRJNA1249535_S_NODE_176618_length_319_cov_3.207317_g173235_i0	PRJNA1249535	176618	319	3.207317	10.23134123	Pseudouroleptus caudatus	400982	SAR_Eukaryotes	SAR_Eukaryotes	590	5.1299999999999986e-164	NTclustered	gi\|751363254\|gb\|KP266664.1\|	1539408	g173235	i0	100	99.8620689655172	319	0	100	0	1	319	336	18	Pseudouroleptus caudatus caudatus isolate X016 28S ribosomal RNA gene, partial sequence	blastn	31856	590	1	Eukaryota	Sar	Ciliophora	Spirotrichea	Stichotrichida	Spirofilidae	Pseudouroleptus	Pseudouroleptus caudatus
23307424	23307424	PRJNA1249535_S_NODE_106959_length_368_cov_2.379661_g103576_i0	PRJNA1249535	106959	368	2.379661	8.75715248	Remanella sp. 1 BS-2022	2930476	SAR_Eukaryotes	SAR_Eukaryotes	52.8	0.035	NTclustered	gi\|2261269021\|emb\|OX095846.1\|	2930476	g103576	i0	100	0.0760869565217391	28	0	8	0	341	368	41	14	Remanella sp. 1 BS-2022 partial 18S rRNA gene, isolate SAMEA13863273, clone N44:18S_rRNA::TRINITY_DN644_c0_g1_i12:99-1693(+)	blastn	28	52.8	1	Eukaryota	Sar	Ciliophora	Karyorelictea	Loxodida	Loxodidae	Remanella	Remanella sp. 1 BS-2022
24581834	24581834	PRJNA1249535_S_NODE_132020_length_347_cov_4.251825_g128637_i0	PRJNA1249535	132020	347	4.251825	14.75383275	Strombidium sp.	181122	SAR_Eukaryotes	SAR_Eukaryotes	56.5	0.003	NTclustered	gi\|1939457674\|gb\|MT471315.1\|	181122	g128637	i0	94.595	0.190201729106628	37	0	10	1	193	227	21337	21373	Strombidium sp. mitochondrion, complete genome	blastn	66	56.5	1	Eukaryota	Sar	Ciliophora	Spirotrichea		Strombidiidae	Strombidium	Strombidium sp.
24583267	24583267	PRJNA1249535_S_NODE_244820_length_282_cov_6.425837_g241437_i0	PRJNA1249535	244820	282	6.425837	18.12086034	Ichthyophthirius multifiliis	5932	SAR_Eukaryotes	SAR_Eukaryotes	52.8	0.026	NTclustered	gi\|471222720\|ref\|XM_004030109.1\|	5932	g241437	i0	100	0.099290780141844	28	0	10	0	88	115	1100	1127	Ichthyophthirius multifiliis protein kinase domain protein (IMG5_167160) mRNA, partial cds	blastn	28	52.8	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Hymenostomatida		Ichthyophthirius	Ichthyophthirius multifiliis

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