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

22 rows where analysis = "blastn", bioproject = "PRJDB14274" 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
8551	8551	PRJDB14274_S_NODE_1961_length_435_cov_1.729947_g1883_i0	PRJDB14274	1961	435	1.729947	7.52526945	Tetrahymena thermophila	5911	SAR_Eukaryotes	SAR_Eukaryotes	350	1.3300000000000002e-91	NTclustered	gi\|829197694\|ref\|XM_001029851.3\|	312017	g1883	i0	84.488	0.928735632183908	361	48	83	7	52	410	639	993	Tetrahymena thermophila SB210 papain family cysteine protease partial mRNA	blastn	404	350	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Hymenostomatida	Tetrahymenidae	Tetrahymena	Tetrahymena thermophila
980947	980947	PRJDB14274_S_NODE_8261_length_221_cov_1.150000_g8183_i0	PRJDB14274	8261	221	1.15	2.5415	root	1	Root_unresolved	Root_unresolved	392	1.0199999999999999e-104	NTclustered	gi\|345541658\|gb\|JN547815.1\|	5911	g8183	i0	98.643	54.9457013574661	221	3	100	0	1	221	3696	3476	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	12143	392	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Hymenostomatida	Tetrahymenidae	Tetrahymena	Tetrahymena thermophila
1282803	1282803	PRJDB14274_S_NODE_4442_length_293_cov_1.625000_g4364_i0	PRJDB14274	4442	293	1.625	4.76125	Tetrahymena thermophila	5911	SAR_Eukaryotes	SAR_Eukaryotes	381	3.049999999999999e-101	NTclustered	gi\|829194480\|ref\|XM_012800280.1\|	312017	g4364	i0	90.102	1.23890784982935	293	29	100	0	1	293	265	557	Tetrahymena thermophila SB210 hypothetical protein partial mRNA	blastn	363	381	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Hymenostomatida	Tetrahymenidae	Tetrahymena	Tetrahymena thermophila
2558430	2558430	PRJDB14274_S_NODE_8263_length_221_cov_1.093750_g8185_i0	PRJDB14274	8263	221	1.09375	2.4171875	Tetrahymena sp. KGE15	1200497	SAR_Eukaryotes	SAR_Eukaryotes	403	4.69e-108	NTclustered	gi\|523704203\|emb\|HE861887.1\|	1200497	g8185	i0	99.548	100.565610859729	221	1	100	0	1	221	610	390	Tetrahymena sp. KGE15 partial 28S rRNA gene, strain KGE15	blastn	22225	403	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Hymenostomatida	Tetrahymenidae	Tetrahymena	Tetrahymena sp. KGE15
6386872	6386872	PRJDB14274_S_NODE_9646_length_206_cov_1.786207_g9568_i0	PRJDB14274	9646	206	1.786207	3.67958642	Tetrahymena thermophila	5911	SAR_Eukaryotes	SAR_Eukaryotes	244	2.7699999999999997e-60	NTclustered	gi\|829194717\|ref\|XM_001025217.3\|	312017	g9568	i0	88.67	0.985436893203884	203	20	97	1	7	206	570	368	Tetrahymena thermophila SB210 ubiquitin-40S ribosomal protein S27a partial mRNA	blastn	203	244	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Hymenostomatida	Tetrahymenidae	Tetrahymena	Tetrahymena thermophila
6386873	6386873	PRJDB14274_S_NODE_9926_length_204_cov_1.489510_g9848_i0	PRJDB14274	9926	204	1.48951	3.0386004	Tetrahymena thermophila	5911	SAR_Eukaryotes	SAR_Eukaryotes	298	2.07e-76	NTclustered	gi\|829164538\|ref\|XM_972017.2\|	312017	g9848	i0	94.33	1.77450980392157	194	11	95	0	6	199	44	237	Tetrahymena thermophila SB210 40S ribosomal protein S29 mRNA	blastn	362	298	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Hymenostomatida	Tetrahymenidae	Tetrahymena	Tetrahymena thermophila
8935511	8935511	PRJDB14274_S_NODE_1528_length_494_cov_1.351039_g1451_i0	PRJDB14274	1528	494	1.351039	6.67413266	Tetrahymena thermophila	5911	SAR_Eukaryotes	SAR_Eukaryotes	521	3.059999999999999e-143	NTclustered	gi\|229595107\|ref\|XM_001020023.3\|	312017	g1451	i0	91.733	0.759109311740891	375	31	76	0	9	383	100	474	Tetrahymena thermophila SB210 60S ribosomal protein L21 partial mRNA	blastn	375	521	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Hymenostomatida	Tetrahymenidae	Tetrahymena	Tetrahymena thermophila
8935533	8935533	PRJDB14274_S_NODE_4328_length_297_cov_1.101695_g4250_i0	PRJDB14274	4328	297	1.101695	3.27203415	Chilodonella hexasticha	1938391	SAR_Eukaryotes	SAR_Eukaryotes	503	6.34e-138	NTclustered	gi\|1389430803\|gb\|MH341631.1\|	1938391	g4250	i0	97.931	83.8181818181818	290	6	98	0	1	290	1686	1975	Chilodonella hexasticha strain C. hexasticha SC large subunit ribosomal RNA gene, partial sequence	blastn	24894	503	1	Eukaryota	Sar	Ciliophora	Phyllopharyngea	Chlamydodontida	Chilodonellidae	Chilodonella	Chilodonella hexasticha
8935547	8935547	PRJDB14274_S_NODE_7448_length_232_cov_1.520468_g7370_i0	PRJDB14274	7448	232	1.520468	3.52748576	Tetrahymena thermophila	5911	SAR_Eukaryotes	SAR_Eukaryotes	239	1.48e-58	NTclustered	gi\|118385632\|ref\|XM_001025944.1\|	312017	g7370	i0	90.96	0.762931034482759	177	16	76	0	2	178	856	1032	Tetrahymena thermophila SB210 receptor of activated kinase C 1A, component of 40S small ribosomal subunit partial mRNA	blastn	177	239	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Hymenostomatida	Tetrahymenidae	Tetrahymena	Tetrahymena thermophila
10211446	10211446	PRJDB14274_S_NODE_9109_length_210_cov_1.771812_g9031_i0	PRJDB14274	9109	210	1.771812	3.7208052	Chilodonella uncinata	151077	SAR_Eukaryotes	SAR_Eukaryotes	372	1.25e-98	NTclustered	gi\|300676714\|gb\|GQ377691.1\|	151077	g9031	i0	98.571	52.4	210	3	100	0	1	210	302	93	Chilodonella uncinata rps22a (rps22a) mRNA, complete cds	blastn	11004	372	1	Eukaryota	Sar	Ciliophora	Phyllopharyngea	Chlamydodontida	Chilodonellidae	Chilodonella	Chilodonella uncinata
15310640	15310640	PRJDB14274_S_NODE_4553_length_290_cov_1.925764_g4475_i0	PRJDB14274	4553	290	1.925764	5.5847156	Tetrahymena thermophila	5911	SAR_Eukaryotes	SAR_Eukaryotes	276	1.46e-69	NTclustered	gi\|829169821\|ref\|XM_012797582.1\|	312017	g4475	i0	86.047	0.889655172413793	258	35	89	1	14	270	702	959	Tetrahymena thermophila SB210 papain family cysteine protease partial mRNA	blastn	258	276	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Hymenostomatida	Tetrahymenidae	Tetrahymena	Tetrahymena thermophila
17860415	17860415	PRJDB14274_S_NODE_8735_length_215_cov_1.175325_g8657_i0	PRJDB14274	8735	215	1.175325	2.52694875	Tetrahymena thermophila	5911	SAR_Eukaryotes	SAR_Eukaryotes	318	1.69e-82	NTclustered	gi\|829196691\|ref\|XM_001026252.2\|	312017	g8657	i0	93.458	0.995348837209302	214	14	99	0	1	214	167	380	Tetrahymena thermophila SB210 60S ribosomal protein L27 partial mRNA	blastn	214	318	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Hymenostomatida	Tetrahymenidae	Tetrahymena	Tetrahymena thermophila
19134092	19134092	PRJDB14274_S_NODE_6536_length_247_cov_1.182796_g6458_i0	PRJDB14274	6536	247	1.182796	2.92150612	Tetrahymena pyriformis	5908	SAR_Eukaryotes	SAR_Eukaryotes	322	1.54e-83	NTclustered	gi\|10789\|emb\|X61053.1\|	5908	g6458	i0	96.41	114.303643724696	195	7	79	0	53	247	1334	1140	T.pyriformis TU20 gene for ubiquitin	blastn	28233	322	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Hymenostomatida	Tetrahymenidae	Tetrahymena	Tetrahymena pyriformis
19134096	19134096	PRJDB14274_S_NODE_7216_length_236_cov_1.114286_g7138_i0	PRJDB14274	7216	236	1.114286	2.62971496	Tetrahymena thermophila	5911	SAR_Eukaryotes	SAR_Eukaryotes	313	8.79e-81	NTclustered	gi\|829140183\|ref\|XM_001009203.3\|	312017	g7138	i0	92.273	3.56779661016949	220	17	93	0	17	236	984	765	Tetrahymena thermophila SB210 glyceraldehyde-3-phosphate dehydrogenase partial mRNA	blastn	842	313	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Hymenostomatida	Tetrahymenidae	Tetrahymena	Tetrahymena thermophila
20409166	20409166	PRJDB14274_S_NODE_3777_length_316_cov_1.258824_g3699_i0	PRJDB14274	3777	316	1.258824	3.97788384	Tetrahymena thermophila	5911	SAR_Eukaryotes	SAR_Eukaryotes	302	2.66e-77	NTclustered	gi\|829167874\|ref\|XM_001030102.3\|	312017	g3699	i0	85.714	0.908227848101266	287	39	91	2	1	286	286	1	Tetrahymena thermophila SB210 60S ribosomal protein L9 partial mRNA	blastn	287	302	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Hymenostomatida	Tetrahymenidae	Tetrahymena	Tetrahymena thermophila
20409191	20409191	PRJDB14274_S_NODE_9817_length_205_cov_1.201389_g9739_i0	PRJDB14274	9817	205	1.201389	2.46284745	Chilodonella uncinata	151077	SAR_Eukaryotes	SAR_Eukaryotes	363	7.279999999999998e-96	NTclustered	gi\|110645063\|gb\|DQ665311.1\|	151077	g9739	i0	98.537	33.0926829268293	205	3	100	0	1	205	686	890	Chilodonella uncinata clone 1 elongation factor 1-alpha (EF-1alpha) gene, partial cds; macronuclear	blastn	6784	363	1	Eukaryota	Sar	Ciliophora	Phyllopharyngea	Chlamydodontida	Chilodonellidae	Chilodonella	Chilodonella uncinata
21383131	21383131	PRJDB14274_S_NODE_6277_length_251_cov_1.710526_g6199_i0	PRJDB14274	6277	251	1.710526	4.29342026	Tetrahymena	5890	SAR_Eukaryotes	SAR_Eukaryotes	364	2.57e-96	NTclustered	gi\|3861467\|emb\|AJ012585.1\|	5911	g6199	i0	92.829	5.1394422310757	251	18	100	0	1	251	3117	3367	Tetrahymena thermophila macronuclear gene encoding ribosomal protein L3, exons 1-2	blastn	1290	364	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Hymenostomatida	Tetrahymenidae	Tetrahymena	Tetrahymena thermophila
21685142	21685142	PRJDB14274_S_NODE_5878_length_259_cov_0.984848_g5800_i0	PRJDB14274	5878	259	0.984848	2.55075632	Tetrahymena thermophila	5911	SAR_Eukaryotes	SAR_Eukaryotes	237	6.0700000000000005e-58	NTclustered	gi\|829188944\|ref\|XM_001031587.2\|	312017	g5800	i0	87.805	0.791505791505791	205	21	78	2	57	259	768	566	Tetrahymena thermophila SB210 60S ribosomal L7Ae-like protein partial mRNA	blastn	205	237	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Hymenostomatida	Tetrahymenidae	Tetrahymena	Tetrahymena thermophila
21685154	21685154	PRJDB14274_S_NODE_9458_length_208_cov_0.884354_g9380_i0	PRJDB14274	9458	208	0.884354	1.83945632	Tetrahymena thermophila	5911	SAR_Eukaryotes	SAR_Eukaryotes	316	5.849999999999998e-82	NTclustered	gi\|829169862\|ref\|XM_001015607.3\|	312017	g9380	i0	94.203	0.995192307692308	207	12	99	0	2	208	256	50	Tetrahymena thermophila SB210 60S ribosomal protein L37a partial mRNA	blastn	207	316	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Hymenostomatida	Tetrahymenidae	Tetrahymena	Tetrahymena thermophila
24234410	24234410	PRJDB14274_S_NODE_3480_length_329_cov_1.201493_g3402_i0	PRJDB14274	3480	329	1.201493	3.95291197	Tetrahymena thermophila	5911	SAR_Eukaryotes	SAR_Eukaryotes	270	7.849999999999999e-68	NTclustered	gi\|829143070\|ref\|XM_001009843.3\|	312017	g3402	i0	82.704	0.966565349544073	318	41	95	10	13	323	995	685	Tetrahymena thermophila SB210 papain family cysteine protease partial mRNA	blastn	318	270	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Hymenostomatida	Tetrahymenidae	Tetrahymena	Tetrahymena thermophila
24234416	24234416	PRJDB14274_S_NODE_4680_length_287_cov_1.057522_g4602_i0	PRJDB14274	4680	287	1.057522	3.03508814	Tetrahymena thermophila	5911	SAR_Eukaryotes	SAR_Eukaryotes	479	1.0299999999999996e-130	NTclustered	gi\|829174498\|ref\|XM_001017626.3\|	312017	g4602	i0	96.853	37.6864111498258	286	9	99	0	2	287	522	237	Tetrahymena thermophila SB210 ubiquitin/ribosomal fusion protein, putative partial mRNA	blastn	10816	479	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Hymenostomatida	Tetrahymenidae	Tetrahymena	Tetrahymena thermophila
25207032	25207032	PRJDB14274_S_NODE_2060_length_425_cov_1.865385_g1982_i0	PRJDB14274	2060	425	1.865385	7.92788625	Chilodonella	151076	SAR_Eukaryotes	SAR_Eukaryotes	628	1.4899999999999998e-175	NTclustered	gi\|1389430804\|gb\|MH341632.1\|	1654720	g1982	i0	96.335	95.2541176470588	382	14	90	0	44	425	417	36	Chilodonella piscicola strain SC large subunit ribosomal RNA gene, partial sequence	blastn	40483	628	1	Eukaryota	Sar	Ciliophora	Phyllopharyngea	Chlamydodontida	Chilodonellidae	Chilodonella	Chilodonella piscicola

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