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

22 rows where analysis = "blastn", bioproject = "PRJNA1103784" 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
2295635	2295635	PRJNA1103784_P_NODE_6722_length_246_cov_0.890173_g6667_i0	PRJNA1103784	6722	246	0.890173	2.18982558	root	1	Root_unresolved	Root_unresolved	366	6.99e-97	NTclustered	gi\|345541658\|gb\|JN547815.1\|	5911	g6667	i0	93.522	89.0081300813008	247	14	100	2	1	246	2520	2275	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	21896	366	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Hymenostomatida	Tetrahymenidae	Tetrahymena	Tetrahymena thermophila
2762825	2762825	PRJNA1103784_P_NODE_3363_length_301_cov_1.289474_g3308_i0	PRJNA1103784	3363	301	1.289474	3.88131674	Chilodonella uncinata	151077	SAR_Eukaryotes	SAR_Eukaryotes	534	2.28e-147	NTclustered	gi\|300676714\|gb\|GQ377691.1\|	151077	g3308	i0	98.671	46.468438538206	301	4	100	0	1	301	74	374	Chilodonella uncinata rps22a (rps22a) mRNA, complete cds	blastn	13987	534	1	Eukaryota	Sar	Ciliophora	Phyllopharyngea	Chlamydodontida	Chilodonellidae	Chilodonella	Chilodonella uncinata
2762866	2762866	PRJNA1103784_P_NODE_5803_length_250_cov_1.333333_g5748_i0	PRJNA1103784	5803	250	1.333333	3.3333325	Tetrahymena thermophila	5911	SAR_Eukaryotes	SAR_Eukaryotes	115	2.85e-21	NTclustered	gi\|829192014\|ref\|XM_012799966.1\|	312017	g5748	i0	88.421	1.68	95	11	38	0	109	203	219	125	Tetrahymena thermophila SB210 hypothetical protein partial mRNA	blastn	420	115	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Hymenostomatida	Tetrahymenidae	Tetrahymena	Tetrahymena thermophila
3570698	3570698	PRJNA1103784_P_NODE_4463_length_273_cov_1.180000_g4408_i0	PRJNA1103784	4463	273	1.18	3.2214	Tetrahymena	5890	SAR_Eukaryotes	SAR_Eukaryotes	364	2.8299999999999993e-96	NTclustered	gi\|10805\|emb\|X52242.1\|	5911	g4408	i0	94.142	9.87912087912088	239	14	88	0	1	239	242	480	T.thermophila mRNA for calmodulin	blastn	2697	364	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Hymenostomatida	Tetrahymenidae	Tetrahymena	Tetrahymena thermophila
4038851	4038851	PRJNA1103784_P_NODE_1164_length_468_cov_0.997468_g1109_i0	PRJNA1103784	1164	468	0.997468	4.66815024	Tetrahymena thermophila	5911	SAR_Eukaryotes	SAR_Eukaryotes	267	1.4899999999999998e-66	NTclustered	gi\|829157134\|ref\|XM_001011598.2\|	312017	g1109	i0	79.156	0.861111111111111	403	71	84	10	2	396	466	863	Tetrahymena thermophila SB210 60S ribosomal protein L5 partial mRNA	blastn	403	267	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Hymenostomatida	Tetrahymenidae	Tetrahymena	Tetrahymena thermophila
4038889	4038889	PRJNA1103784_P_NODE_3404_length_299_cov_2.044248_g3349_i0	PRJNA1103784	3404	299	2.044248	6.11230152	Tetrahymena thermophila	5911	SAR_Eukaryotes	SAR_Eukaryotes	226	1.5499999999999994e-54	NTclustered	gi\|829197457\|ref\|XM_001026661.3\|	312017	g3349	i0	82.558	1.7056856187291	258	43	86	2	1	257	422	166	Tetrahymena thermophila SB210 60S ribosomal protein L36 partial mRNA	blastn	510	226	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Hymenostomatida	Tetrahymenidae	Tetrahymena	Tetrahymena thermophila
4038912	4038912	PRJNA1103784_P_NODE_5104_length_261_cov_1.244681_g5049_i0	PRJNA1103784	5104	261	1.244681	3.24861741	Chilodonella uncinata	151077	SAR_Eukaryotes	SAR_Eukaryotes	427	3.38e-115	NTclustered	gi\|301014695\|gb\|GQ377692.1\|	151077	g5049	i0	96.169	70.3946360153257	261	10	100	0	1	261	464	204	Chilodonella uncinata ribosomal protein S23a-like (rps23a) mRNA, complete sequence	blastn	18373	427	1	Eukaryota	Sar	Ciliophora	Phyllopharyngea	Chlamydodontida	Chilodonellidae	Chilodonella	Chilodonella uncinata
4038920	4038920	PRJNA1103784_P_NODE_5584_length_251_cov_2.061798_g5529_i0	PRJNA1103784	5584	251	2.061798	5.17511298	Tetrahymena thermophila	5911	SAR_Eukaryotes	SAR_Eukaryotes	182	2.78e-41	NTclustered	gi\|146161228\|ref\|XM_971777.2\|	312017	g5529	i0	79.842	1.42629482071713	253	47	100	3	1	251	193	443	Tetrahymena thermophila SB210 ribosomal protein L11, amine-terminal domain protein partial mRNA	blastn	358	182	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Hymenostomatida	Tetrahymenidae	Tetrahymena	Tetrahymena thermophila
4848210	4848210	PRJNA1103784_P_NODE_4024_length_282_cov_1.320574_g3969_i0	PRJNA1103784	4024	282	1.320574	3.72401868	Tetrahymena	5890	SAR_Eukaryotes	SAR_Eukaryotes	427	3.7e-115	NTclustered	gi\|822092996\|gb\|KP313320.1\|	5911	g3969	i0	93.993	95.177304964539	283	15	100	2	1	282	263	544	Tetrahymena thermophila isolate 19869-1 alpha-tubulin (ATU1) gene, partial cds; macronuclear	blastn	26840	427	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Hymenostomatida	Tetrahymenidae	Tetrahymena	Tetrahymena thermophila
7397969	7397969	PRJNA1103784_P_NODE_3886_length_285_cov_1.702830_g3831_i0	PRJNA1103784	3886	285	1.70283	4.8530655	Litostomatea	5988	SAR_Eukaryotes	SAR_Eukaryotes	255	1.87e-63	NTclustered	gi\|92790165\|emb\|AJ965268.1\|	47892	g3831	i0	85.039	176.049122807018	254	35	89	3	5	257	570	319	Eudiplodinium maggii partial mRNA for Polyubiqutin 1 (polyubiqutin 1 gene)	blastn	50174	255	1	Eukaryota	Sar	Ciliophora	Litostomatea	Entodiniomorphida	Ophryoscolecidae	Eudiplodinium	Eudiplodinium maggii
8673426	8673426	PRJNA1103784_P_NODE_8087_length_228_cov_2.980645_g8032_i0	PRJNA1103784	8087	228	2.980645	6.7958706	root	1	Root_unresolved	Root_unresolved	252	1.87e-62	NTclustered	gi\|10832\|emb\|X54512.1\|	5911	g8032	i0	86.842	43.1666666666667	228	26	99	4	4	228	6862	6636	T. thermophila rdn A+ gene for pre-RNA, 17S rRNA, 5.8S rRNA, 26S rRNA	blastn	9842	252	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Hymenostomatida	Tetrahymenidae	Tetrahymena	Tetrahymena thermophila
9139723	9139723	PRJNA1103784_P_NODE_3108_length_310_cov_2.645570_g3053_i0	PRJNA1103784	3108	310	2.64557	8.201267	Tetrahymena pyriformis	5908	SAR_Eukaryotes	SAR_Eukaryotes	65.8	3.72e-6	NTclustered	gi\|9246256\|gb\|AF119380.1\|AF119380	5908	g3053	i0	79.348	0.593548387096774	92	19	30	0	1	92	2082	2173	Tetrahymena pyriformis epiplasmin C (EPIC) gene, complete cds	blastn	184	65.8	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Hymenostomatida	Tetrahymenidae	Tetrahymena	Tetrahymena pyriformis
9139755	9139755	PRJNA1103784_P_NODE_5388_length_255_cov_1.406593_g5333_i0	PRJNA1103784	5388	255	1.406593	3.58681215	Chilodonella uncinata	151077	SAR_Eukaryotes	SAR_Eukaryotes	283	7.55e-72	NTclustered	gi\|662862630\|gb\|KJ000270.1\|	151077	g5333	i0	86.77	5.11372549019608	257	30	100	3	1	255	539	793	Chilodonella uncinata strain ATCC PRA-256 clone P7 protein kinase domain containing protein gene, partial cds; macronuclear	blastn	1304	283	1	Eukaryota	Sar	Ciliophora	Phyllopharyngea	Chlamydodontida	Chilodonellidae	Chilodonella	Chilodonella uncinata
12965939	12965939	PRJNA1103784_P_NODE_1111_length_476_cov_1.908189_g1056_i0	PRJNA1103784	1111	476	1.908189	9.08297964	Tetrahymena thermophila	5911	SAR_Eukaryotes	SAR_Eukaryotes	568	3.72e-157	NTclustered	gi\|829189667\|ref\|XM_001023313.3\|	312017	g1056	i0	90.3	0.909663865546218	433	42	91	0	44	476	10	442	Tetrahymena thermophila SB210 ribosomal protein L19 partial mRNA	blastn	433	568	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Hymenostomatida	Tetrahymenidae	Tetrahymena	Tetrahymena thermophila
15047857	15047857	PRJNA1103784_P_NODE_1972_length_373_cov_3.110000_g1917_i0	PRJNA1103784	1972	373	3.11	11.6003	Chilodonella	151076	SAR_Eukaryotes	SAR_Eukaryotes	623	5.999999999999999e-174	NTclustered	gi\|1389430804\|gb\|MH341632.1\|	1654720	g1917	i0	96.783	96.6514745308311	373	12	100	0	1	373	14	386	Chilodonella piscicola strain SC large subunit ribosomal RNA gene, partial sequence	blastn	36051	623	1	Eukaryota	Sar	Ciliophora	Phyllopharyngea	Chlamydodontida	Chilodonellidae	Chilodonella	Chilodonella piscicola
16322663	16322663	PRJNA1103784_P_NODE_1733_length_394_cov_1.448598_g1678_i0	PRJNA1103784	1733	394	1.448598	5.70747612	Tetrahymena	5890	SAR_Eukaryotes	SAR_Eukaryotes	211	5.88e-50	NTclustered	gi\|315570342\|tpg\|BK007933.1\|	5911	g1678	i0	81.749	1.33502538071066	263	39	65	8	135	391	299	40	TPA_exp: Tetrahymena thermophila 40S ribosomal protein rpS26e mRNA, complete cds	blastn	526	211	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Hymenostomatida	Tetrahymenidae	Tetrahymena	Tetrahymena thermophila
16789228	16789228	PRJNA1103784_P_NODE_1994_length_372_cov_1.324415_g1939_i0	PRJNA1103784	1994	372	1.324415	4.9268238	Tetrahymena thermophila	5911	SAR_Eukaryotes	SAR_Eukaryotes	372	2.39e-98	NTclustered	gi\|829170408\|ref\|XM_001015874.3\|	312017	g1939	i0	88.779	0.814516129032258	303	34	81	0	46	348	393	91	Tetrahymena thermophila SB210 40S ribosomal protein S15 partial mRNA	blastn	303	372	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Hymenostomatida	Tetrahymenidae	Tetrahymena	Tetrahymena thermophila
16789277	16789277	PRJNA1103784_P_NODE_4834_length_266_cov_1.196891_g4779_i0	PRJNA1103784	4834	266	1.196891	3.18373006	Chilodonella uncinata	151077	SAR_Eukaryotes	SAR_Eukaryotes	387	5.87e-103	NTclustered	gi\|110645063\|gb\|DQ665311.1\|	151077	g4779	i0	97.768	27.0751879699248	224	5	84	0	6	229	224	1	Chilodonella uncinata clone 1 elongation factor 1-alpha (EF-1alpha) gene, partial cds; macronuclear	blastn	7202	387	1	Eukaryota	Sar	Ciliophora	Phyllopharyngea	Chlamydodontida	Chilodonellidae	Chilodonella	Chilodonella uncinata
19337888	19337888	PRJNA1103784_P_NODE_1876_length_381_cov_1.996753_g1821_i0	PRJNA1103784	1876	381	1.996753	7.60762893	Tetrahymena nigricans	2704176	SAR_Eukaryotes	SAR_Eukaryotes	505	2.32e-138	NTclustered	gi\|2082965251\|gb\|MZ827091.1\|	2704176	g1821	i0	91.076	68.750656167979	381	22	99	8	6	381	614	987	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	26194	505	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Hymenostomatida	Tetrahymenidae	Tetrahymena	Tetrahymena nigricans
21888965	21888965	PRJNA1103784_P_NODE_6718_length_246_cov_0.890173_g6663_i0	PRJNA1103784	6718	246	0.890173	2.18982558	Tetrahymena thermophila	5911	SAR_Eukaryotes	SAR_Eukaryotes	246	9.5e-61	NTclustered	gi\|118378434\|ref\|XM_001022393.1\|	312017	g6663	i0	85.124	0.983739837398374	242	35	98	1	3	244	1129	889	Tetrahymena thermophila SB210 cystathionine beta-synthase partial mRNA	blastn	242	246	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Hymenostomatida	Tetrahymenidae	Tetrahymena	Tetrahymena thermophila
22697127	22697127	PRJNA1103784_P_NODE_1538_length_413_cov_1.358824_g1483_i0	PRJNA1103784	1538	413	1.358824	5.61194312	Tetrahymena	5890	SAR_Eukaryotes	SAR_Eukaryotes	379	1.5999999999999998e-100	NTclustered	gi\|315570322\|tpg\|BK007923.1\|	5911	g1483	i0	84.576	2.85956416464891	389	52	93	7	29	413	13	397	TPA_exp: Tetrahymena thermophila 40S ribosomal protein rpS16e mRNA, complete cds	blastn	1181	379	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Hymenostomatida	Tetrahymenidae	Tetrahymena	Tetrahymena thermophila
23164461	23164461	PRJNA1103784_P_NODE_4579_length_270_cov_2.345178_g4524_i0	PRJNA1103784	4579	270	2.345178	6.3319806	Chilodonella hexasticha	1938391	SAR_Eukaryotes	SAR_Eukaryotes	422	1.64e-113	NTclustered	gi\|1389430803\|gb\|MH341631.1\|	1938391	g4524	i0	94.815	49.3222222222222	270	14	100	0	1	270	1814	2083	Chilodonella hexasticha strain C. hexasticha SC large subunit ribosomal RNA gene, partial sequence	blastn	13317	422	1	Eukaryota	Sar	Ciliophora	Phyllopharyngea	Chlamydodontida	Chilodonellidae	Chilodonella	Chilodonella hexasticha

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