metadata: contig_metadata: 23 rows where analysis = "blastn", bioproject = "PRJNA358490" and tax

23 rows where analysis = "blastn", bioproject = "PRJNA358490" 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
398983	398983	PRJNA358490_P_NODE_13261_length_214_cov_3.074286_g12917_i0	PRJNA358490	13261	214	3.074286	6.57897204	Tetrahymena thermophila	5911	SAR_Eukaryotes	SAR_Eukaryotes	272	1.33e-68	NTclustered	gi\|829167874\|ref\|XM_001030102.3\|	312017	g12917	i0	92.228	1.30373831775701	193	13	90	2	23	214	567	376	Tetrahymena thermophila SB210 60S ribosomal protein L9 partial mRNA	blastn	279	272	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Hymenostomatida	Tetrahymenidae	Tetrahymena	Tetrahymena thermophila
399036	399036	PRJNA358490_P_NODE_17421_length_157_cov_1.381356_g17077_i0	PRJNA358490	17421	157	1.381356	2.16872892	Tetrahymena thermophila	5911	SAR_Eukaryotes	SAR_Eukaryotes	99	1.64e-16	NTclustered	gi\|829191952\|ref\|XM_001023996.3\|	312017	g17077	i0	92.754	0.439490445859873	69	3	43	2	90	157	1458	1391	Tetrahymena thermophila SB210 protein disulfide-isomerase partial mRNA	blastn	69	99	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Hymenostomatida	Tetrahymenidae	Tetrahymena	Tetrahymena thermophila
399161	399161	PRJNA358490_P_NODE_8721_length_401_cov_2.116022_g8380_i0	PRJNA358490	8721	401	2.116022	8.48524822	Tetrahymena thermophila	5911	SAR_Eukaryotes	SAR_Eukaryotes	261	5.87e-65	NTclustered	gi\|829192317\|ref\|XM_001031469.3\|	312017	g8380	i0	96.226	0.396508728179551	159	6	40	0	20	178	259	417	Tetrahymena thermophila SB210 40S ribosomal protein S19 partial mRNA	blastn	159	261	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Hymenostomatida	Tetrahymenidae	Tetrahymena	Tetrahymena thermophila
1073215	1073215	PRJNA358490_P_NODE_14901_length_184_cov_1.200000_g14557_i0	PRJNA358490	14901	184	1.2	2.208	Tetrahymena	5890	SAR_Eukaryotes	SAR_Eukaryotes	322	1.08e-83	NTclustered	gi\|114329902\|ref\|NC_008339.1\|	5907	g14557	i0	98.37	27.3152173913043	184	2	100	1	1	184	2450	2632	Tetrahymena pigmentosa mitochondrion, complete genome	blastn	5026	324	0.993827160493827	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Hymenostomatida	Tetrahymenidae	Tetrahymena	Tetrahymena pigmentosa
1673659	1673659	PRJNA358490_P_NODE_13102_length_219_cov_1.366667_g12758_i0	PRJNA358490	13102	219	1.366667	2.99300073	Tetrahymena thermophila	5911	SAR_Eukaryotes	SAR_Eukaryotes	230	8.34e-56	NTclustered	gi\|829185574\|ref\|XM_001030186.3\|	312017	g12758	i0	89.005	1.30593607305936	191	14	85	6	21	206	475	663	Tetrahymena thermophila SB210 40S ribosomal protein S11, putative mRNA	blastn	286	230	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Hymenostomatida	Tetrahymenidae	Tetrahymena	Tetrahymena thermophila
1673708	1673708	PRJNA358490_P_NODE_17082_length_160_cov_1.347107_g16738_i0	PRJNA358490	17082	160	1.347107	2.1553712	Tetrahymena pyriformis	5908	SAR_Eukaryotes	SAR_Eukaryotes	130	5.96e-26	NTclustered	gi\|11466252\|ref\|NC_000862.1\|	5908	g16738	i0	94.186	1.6125	86	4	54	1	39	124	32530	32446	Tetrahymena pyriformis mitochondrion, complete genome	blastn	258	130	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Hymenostomatida	Tetrahymenidae	Tetrahymena	Tetrahymena pyriformis
4901132	4901132	PRJNA358490_P_NODE_11044_length_285_cov_5.288618_g10701_i0	PRJNA358490	11044	285	5.288618	15.0725613	Ciliophora	5878	SAR_Eukaryotes	SAR_Eukaryotes	479	1.02e-130	NTclustered	gi\|2065561668\|gb\|MZ540265.1\|	44029	g10701	i0	99.618	91.6982456140351	262	1	92	0	22	283	661	922	Paramecium jenningsi isolate UR02 small subunit ribosomal RNA gene, partial sequence	blastn	26134	479	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Peniculida	Parameciidae	Paramecium	Paramecium jenningsi
6176218	6176218	PRJNA358490_P_NODE_1805_length_1041_cov_179.045908_g1673_i0	PRJNA358490	1805	1041	179.045908	1863.86790228	Tetrahymena	5890	SAR_Eukaryotes	SAR_Eukaryotes	1762	0	NTclustered	gi\|2082965253\|gb\|MZ827093.1\|	2704173	g1673	i0	97.845	61.090297790586	1021	21	98	1	22	1041	78	1098	Tetrahymena scolopax isolate GP171 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	63595	1764	0.998866213151927	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Hymenostomatida	Tetrahymenidae	Tetrahymena	Tetrahymena scolopax
6776643	6776643	PRJNA358490_P_NODE_16966_length_161_cov_1.336066_g16622_i0	PRJNA358490	16966	161	1.336066	2.15106626	Tetrahymena thermophila	5911	SAR_Eukaryotes	SAR_Eukaryotes	248	1.59e-61	NTclustered	gi\|829174408\|ref\|XM_012797985.1\|	312017	g16622	i0	94.41	1.98757763975155	161	9	100	0	1	161	495	335	Tetrahymena thermophila SB210 60S ribosomal protein L17 partial mRNA	blastn	320	248	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Hymenostomatida	Tetrahymenidae	Tetrahymena	Tetrahymena thermophila
8052339	8052339	PRJNA358490_P_NODE_5287_length_595_cov_7.365108_g4995_i0	PRJNA358490	5287	595	7.365108	43.8223926	Tetrahymena thermophila	5911	SAR_Eukaryotes	SAR_Eukaryotes	472	3.8099999999999997e-128	NTclustered	gi\|829177473\|ref\|XM_001018846.3\|	312017	g4995	i0	84.774	1.34621848739496	486	56	81	9	22	500	216	690	Tetrahymena thermophila SB210 hypothetical protein partial mRNA	blastn	801	472	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Hymenostomatida	Tetrahymenidae	Tetrahymena	Tetrahymena thermophila
9327184	9327184	PRJNA358490_P_NODE_4328_length_675_cov_2.275157_g4078_i0	PRJNA358490	4328	675	2.275157	15.35730975	Tetrahymena furgasoni	5898	SAR_Eukaryotes	SAR_Eukaryotes	580	6.939999999999998e-161	NTclustered	gi\|1268580094\|gb\|KY218574.1\|	5898	g4078	i0	97.368	61.3792592592593	342	8	51	1	314	655	1	341	Tetrahymena furgasoni isolate 20749-1 small subunit ribosomal RNA gene, partial sequence; mitochondrial	blastn	41431	580	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Hymenostomatida	Tetrahymenidae	Tetrahymena	Tetrahymena furgasoni
9327197	9327197	PRJNA358490_P_NODE_4948_length_622_cov_5.259005_g4673_i0	PRJNA358490	4948	622	5.259005	32.7110111	Tetrahymena thermophila	5911	SAR_Eukaryotes	SAR_Eukaryotes	363	2.51e-95	NTclustered	gi\|829181013\|ref\|XM_001020009.2\|	312017	g4673	i0	80.417	0.87620578778135	480	90	77	4	21	498	996	1473	Tetrahymena thermophila SB210 coiled-coil protein, putative partial mRNA	blastn	545	363	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Hymenostomatida	Tetrahymenidae	Tetrahymena	Tetrahymena thermophila
9327230	9327230	PRJNA358490_P_NODE_7468_length_461_cov_2.540284_g7133_i0	PRJNA358490	7468	461	2.540284	11.71070924	Tetrahymena thermophila	5911	SAR_Eukaryotes	SAR_Eukaryotes	313	1.86e-80	NTclustered	gi\|829184530\|ref\|XM_001021598.3\|	312017	g7133	i0	85.209	0.674620390455531	311	38	67	4	134	440	372	66	Tetrahymena thermophila SB210 60S ribosomal protein L34 partial mRNA	blastn	311	313	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Hymenostomatida	Tetrahymenidae	Tetrahymena	Tetrahymena thermophila
10602707	10602707	PRJNA358490_P_NODE_13229_length_215_cov_1.988636_g12885_i0	PRJNA358490	13229	215	1.988636	4.2755674	Tetrahymena thermophila	5911	SAR_Eukaryotes	SAR_Eukaryotes	209	1.06e-49	NTclustered	gi\|3366650\|gb\|AF031319.1\|AF031319	5911	g12885	i0	87.845	0.841860465116279	181	18	84	3	20	200	1170	1346	Tetrahymena thermophila granule lattice protein 3 precursor (GRL3) mRNA, complete cds	blastn	181	209	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Hymenostomatida	Tetrahymenidae	Tetrahymena	Tetrahymena thermophila
10602767	10602767	PRJNA358490_P_NODE_17689_length_155_cov_1.413793_g17345_i0	PRJNA358490	17689	155	1.413793	2.19137915	Tetrahymena sp. FN-2012	1217406	SAR_Eukaryotes	SAR_Eukaryotes	287	3.21e-73	NTclustered	gi\|400269896\|gb\|JX271898.1\|	1217406	g17345	i0	100	96.9225806451613	155	0	100	0	1	155	859	1013	Tetrahymena sp. FN-2012 strain HFCC700 28S large subunit ribosomal RNA gene, partial sequence	blastn	15023	287	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Hymenostomatida	Tetrahymenidae	Tetrahymena	Tetrahymena sp. FN-2012
15701777	15701777	PRJNA358490_P_NODE_5273_length_596_cov_6.184919_g4982_i0	PRJNA358490	5273	596	6.184919	36.86211724	Tetrahymena thermophila	5911	SAR_Eukaryotes	SAR_Eukaryotes	429	2.33e-115	NTclustered	gi\|829195582\|ref\|XM_001025656.3\|	312017	g4982	i0	86.48	0.657718120805369	392	51	66	2	105	495	432	42	Tetrahymena thermophila SB210 60S ribosomal protein L14 partial mRNA	blastn	392	429	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Hymenostomatida	Tetrahymenidae	Tetrahymena	Tetrahymena thermophila
16976405	16976405	PRJNA358490_P_NODE_17454_length_157_cov_1.033898_g17110_i0	PRJNA358490	17454	157	1.033898	1.62321986	Tetrahymena thermophila	5911	SAR_Eukaryotes	SAR_Eukaryotes	171	3.43e-38	NTclustered	gi\|829197936\|ref\|XM_001026932.3\|	312017	g17110	i0	87.248	0.949044585987261	149	19	95	0	1	149	1535	1387	Tetrahymena thermophila SB210 DnaK protein partial mRNA	blastn	149	171	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Hymenostomatida	Tetrahymenidae	Tetrahymena	Tetrahymena thermophila
18250637	18250637	PRJNA358490_P_NODE_16755_length_163_cov_1.258065_g16411_i0	PRJNA358490	16755	163	1.258065	2.05064595	Tetrahymena thermophila	5911	SAR_Eukaryotes	SAR_Eukaryotes	145	2.18e-30	NTclustered	gi\|118388719\|ref\|XM_001027456.1\|	312017	g16411	i0	85.106	0.865030674846626	141	21	87	0	9	149	782	642	Tetrahymena thermophila SB210 eukaryotic aspartyl protease partial mRNA	blastn	141	145	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Hymenostomatida	Tetrahymenidae	Tetrahymena	Tetrahymena thermophila
18250788	18250788	PRJNA358490_P_NODE_9715_length_347_cov_2.704545_g9373_i0	PRJNA358490	9715	347	2.704545	9.38477115	Tetrahymena pyriformis	5908	SAR_Eukaryotes	SAR_Eukaryotes	340	6.259999999999999e-89	NTclustered	gi\|295494762\|gb\|GU596435.1\|	5908	g9373	i0	85.672	0.965417867435158	335	34	95	11	12	339	470	143	Tetrahymena pyriformis ribosomal protein S30 (rps30) mRNA, complete cds	blastn	335	340	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Hymenostomatida	Tetrahymenidae	Tetrahymena	Tetrahymena pyriformis
19524876	19524876	PRJNA358490_P_NODE_3656_length_747_cov_4.545198_g3432_i0	PRJNA358490	3656	747	4.545198	33.95262906	Tetrahymena thermophila	5911	SAR_Eukaryotes	SAR_Eukaryotes	510	1.03e-139	NTclustered	gi\|829143070\|ref\|XM_001009843.3\|	312017	g3432	i0	82.072	1.04685408299866	608	99	81	7	118	720	1131	529	Tetrahymena thermophila SB210 papain family cysteine protease partial mRNA	blastn	782	510	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Hymenostomatida	Tetrahymenidae	Tetrahymena	Tetrahymena thermophila
19524948	19524948	PRJNA358490_P_NODE_8716_length_401_cov_3.066298_g8375_i0	PRJNA358490	8716	401	3.066298	12.29585498	Tetrahymena thermophila	5911	SAR_Eukaryotes	SAR_Eukaryotes	342	2.04e-89	NTclustered	gi\|829174395\|ref\|XM_012797980.1\|	312017	g8375	i0	91.837	0.610972568578554	245	20	61	0	135	379	546	302	Tetrahymena thermophila SB210 60S ribosomal protein L18 partial mRNA	blastn	245	342	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Hymenostomatida	Tetrahymenidae	Tetrahymena	Tetrahymena thermophila
22075666	22075666	PRJNA358490_P_NODE_9378_length_365_cov_5.530675_g9036_i0	PRJNA358490	9378	365	5.530675	20.18696375	Tetrahymena thermophila	5911	SAR_Eukaryotes	SAR_Eukaryotes	361	5.0699999999999986e-95	NTclustered	gi\|829162594\|ref\|XM_001013247.3\|	312017	g9036	i0	95.175	14.9178082191781	228	11	62	0	119	346	426	199	Tetrahymena thermophila SB210 60S ribosomal protein L23 partial mRNA	blastn	5445	361	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Hymenostomatida	Tetrahymenidae	Tetrahymena	Tetrahymena thermophila
24625147	24625147	PRJNA358490_P_NODE_10480_length_308_cov_1.769517_g10138_i0	PRJNA358490	10480	308	1.769517	5.45011236	Tetrahymena thermophila	5911	SAR_Eukaryotes	SAR_Eukaryotes	261	4.39e-65	NTclustered	gi\|829160192\|ref\|XM_001012283.3\|	312017	g10138	i0	89.423	0.954545454545455	208	20	67	2	40	246	207	1	Tetrahymena thermophila SB210 40S ribosomal protein S28e, putative partial mRNA	blastn	294	261	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Hymenostomatida	Tetrahymenidae	Tetrahymena	Tetrahymena thermophila

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