metadata: contig_metadata: 26 rows where analysis = "blastn", bioproject = "PRJNA1188114" and tax

26 rows where analysis = "blastn", bioproject = "PRJNA1188114" 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
320108	320108	PRJNA1188114_P_NODE_4861_length_207_cov_1.936709_g4809_i0	PRJNA1188114	4861	207	1.936709	4.00898763	Tetrahymena thermophila	5911	SAR_Eukaryotes	SAR_Eukaryotes	311	2.71e-80	NTclustered	gi\|829192616\|ref\|XM_001029813.3\|	312017	g4809	i0	94.527	0.971014492753623	201	11	97	0	1	201	259	459	Tetrahymena thermophila SB210 60S ribosomal protein L15 partial mRNA	blastn	201	311	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Hymenostomatida	Tetrahymenidae	Tetrahymena	Tetrahymena thermophila
1042122	1042122	PRJNA1188114_P_NODE_6941_length_188_cov_1.100719_g6889_i0	PRJNA1188114	6941	188	1.100719	2.06935172	Tetrahymena	5890	SAR_Eukaryotes	SAR_Eukaryotes	342	8.539999999999999e-90	NTclustered	gi\|148362050\|gb\|EF428128.1\|	5912	g6889	i0	100	99.9893617021277	185	0	98	0	2	186	762	578	Tetrahymena tropicalis strain Lahorensis 18S ribosomal RNA gene, partial sequence	blastn	18798	342	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Hymenostomatida	Tetrahymenidae	Tetrahymena	Tetrahymena tropicalis
2870757	2870757	PRJNA1188114_P_NODE_14643_length_165_cov_0.879310_g14591_i0	PRJNA1188114	14643	165	0.87931	1.4508615	Tetrahymena thermophila	5911	SAR_Eukaryotes	SAR_Eukaryotes	250	4.5599999999999996e-62	NTclustered	gi\|118385632\|ref\|XM_001025944.1\|	312017	g14591	i0	93.939	1	165	10	100	0	1	165	121	285	Tetrahymena thermophila SB210 receptor of activated kinase C 1A, component of 40S small ribosomal subunit partial mRNA	blastn	165	250	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Hymenostomatida	Tetrahymenidae	Tetrahymena	Tetrahymena thermophila
4146845	4146845	PRJNA1188114_P_NODE_10024_length_175_cov_1.396825_g9972_i0	PRJNA1188114	10024	175	1.396825	2.44444375	Tetrahymena thermophila	5911	SAR_Eukaryotes	SAR_Eukaryotes	172	1.08e-38	NTclustered	gi\|829185210\|ref\|XM_001032881.3\|	312017	g9972	i0	84.795	0.977142857142857	171	26	98	0	5	175	44	214	Tetrahymena thermophila SB210 hypothetical protein partial mRNA	blastn	171	172	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Hymenostomatida	Tetrahymenidae	Tetrahymena	Tetrahymena thermophila
4146886	4146886	PRJNA1188114_P_NODE_15064_length_165_cov_0.879310_g15012_i0	PRJNA1188114	15064	165	0.87931	1.4508615	Tetrahymena thermophila	5911	SAR_Eukaryotes	SAR_Eukaryotes	204	3.5999999999999995e-48	NTclustered	gi\|829173636\|ref\|XM_001017148.3\|	312017	g15012	i0	89.091	1	165	16	99	2	1	164	240	403	Tetrahymena thermophila SB210 hypothetical protein partial mRNA	blastn	165	204	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Hymenostomatida	Tetrahymenidae	Tetrahymena	Tetrahymena thermophila
4146946	4146946	PRJNA1188114_P_NODE_3564_length_232_cov_1.890710_g3512_i0	PRJNA1188114	3564	232	1.89071	4.3864472	Oxytricha sp. LPJ-2005	329142	SAR_Eukaryotes	SAR_Eukaryotes	174	4.24e-39	NTclustered	gi\|67462291\|gb\|DQ062087.1\|	329142	g3512	i0	84.884	62.8491379310345	172	26	74	0	42	213	316	487	Oxytricha sp. LPJ-2005 heat shock protein 70 mRNA, partial cds; macronuclear	blastn	14581	174	1	Eukaryota	Sar	Ciliophora	Spirotrichea	Sporadotrichida	Oxytrichidae	Oxytricha	Oxytricha sp. LPJ-2005
7973213	7973213	PRJNA1188114_P_NODE_1107_length_411_cov_2.640884_g1055_i0	PRJNA1188114	1107	411	2.640884	10.85403324	Tetrahymena thermophila	5911	SAR_Eukaryotes	SAR_Eukaryotes	394	5.7e-105	NTclustered	gi\|829197694\|ref\|XM_001029851.3\|	312017	g1055	i0	83.981	1.44282238442822	412	64	100	2	1	411	40	450	Tetrahymena thermophila SB210 papain family cysteine protease partial mRNA	blastn	593	394	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Hymenostomatida	Tetrahymenidae	Tetrahymena	Tetrahymena thermophila
7973263	7973263	PRJNA1188114_P_NODE_15867_length_164_cov_0.886957_g15815_i0	PRJNA1188114	15867	164	0.886957	1.45460948	Tetrahymena thermophila	5911	SAR_Eukaryotes	SAR_Eukaryotes	204	3.5699999999999997e-48	NTclustered	gi\|829101093\|ref\|XM_001007665.3\|	312017	g15815	i0	90.789	0.926829268292683	152	14	93	0	13	164	668	517	Tetrahymena thermophila SB210 AAA domain protein partial mRNA	blastn	152	204	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Hymenostomatida	Tetrahymenidae	Tetrahymena	Tetrahymena thermophila
7973312	7973312	PRJNA1188114_P_NODE_5307_length_200_cov_1.688742_g5255_i0	PRJNA1188114	5307	200	1.688742	3.377484	Tetrahymena thermophila	5911	SAR_Eukaryotes	SAR_Eukaryotes	250	5.7399999999999995e-62	NTclustered	gi\|146185323\|ref\|XM_001031586.2\|	312017	g5255	i0	94.969	1.125	159	8	80	0	42	200	1	159	Tetrahymena thermophila SB210 40S ribosomal protein S13 partial mRNA	blastn	225	250	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Hymenostomatida	Tetrahymenidae	Tetrahymena	Tetrahymena thermophila
7973336	7973336	PRJNA1188114_P_NODE_7587_length_185_cov_1.500000_g7535_i0	PRJNA1188114	7587	185	1.5	2.775	Tetrahymena thermophila	5911	SAR_Eukaryotes	SAR_Eukaryotes	220	4.09e-53	NTclustered	gi\|829150968\|ref\|XM_001010768.3\|	312017	g7535	i0	88.827	22.6756756756757	179	20	97	0	7	185	275	97	Tetrahymena thermophila SB210 peptidyl-prolyl cis-trans isomerase, cyclophilin-type protein partial mRNA	blastn	4195	220	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Hymenostomatida	Tetrahymenidae	Tetrahymena	Tetrahymena thermophila
10523730	10523730	PRJNA1188114_P_NODE_3449_length_235_cov_2.467742_g3397_i0	PRJNA1188114	3449	235	2.467742	5.7991937	Tetrahymena thermophila	5911	SAR_Eukaryotes	SAR_Eukaryotes	279	8.87e-71	NTclustered	gi\|829184873\|ref\|XM_001032358.3\|	312017	g3397	i0	88.186	1.00851063829787	237	24	100	3	1	235	469	235	Tetrahymena thermophila SB210 60S acidic ribosomal protein P0 partial mRNA	blastn	237	279	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Hymenostomatida	Tetrahymenidae	Tetrahymena	Tetrahymena thermophila
15622779	15622779	PRJNA1188114_P_NODE_19833_length_161_cov_0.910714_g19781_i0	PRJNA1188114	19833	161	0.910714	1.46624954	Tetrahymena thermophila	5911	SAR_Eukaryotes	SAR_Eukaryotes	176	7.609999999999999e-40	NTclustered	gi\|229595147\|ref\|XM_001019547.3\|	312017	g19781	i0	86.42	1.00621118012422	162	20	100	2	1	161	506	346	Tetrahymena thermophila SB210 papain family cysteine protease partial mRNA	blastn	162	176	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Hymenostomatida	Tetrahymenidae	Tetrahymena	Tetrahymena thermophila
15622795	15622795	PRJNA1188114_P_NODE_3293_length_241_cov_1.057292_g3241_i0	PRJNA1188114	3293	241	1.057292	2.54807372	Tetrahymena thermophila	5911	SAR_Eukaryotes	SAR_Eukaryotes	403	5.199999999999998e-108	NTclustered	gi\|829192616\|ref\|XM_001029813.3\|	312017	g3241	i0	97.071	8.54356846473029	239	7	99	0	3	241	283	45	Tetrahymena thermophila SB210 60S ribosomal protein L15 partial mRNA	blastn	2059	403	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Hymenostomatida	Tetrahymenidae	Tetrahymena	Tetrahymena thermophila
16897097	16897097	PRJNA1188114_P_NODE_13934_length_166_cov_0.871795_g13882_i0	PRJNA1188114	13934	166	0.871795	1.4471797	Tetrahymena thermophila	5911	SAR_Eukaryotes	SAR_Eukaryotes	152	1.33e-32	NTclustered	gi\|829160366\|ref\|XM_012796660.1\|	312017	g13882	i0	83.133	1	166	28	100	0	1	166	77	242	Tetrahymena thermophila SB210 tricarboxylate transporter partial mRNA	blastn	166	152	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Hymenostomatida	Tetrahymenidae	Tetrahymena	Tetrahymena thermophila
16897122	16897122	PRJNA1188114_P_NODE_1694_length_326_cov_3.353791_g1642_i0	PRJNA1188114	1694	326	3.353791	10.93335866	Tetrahymena thermophila	5911	SAR_Eukaryotes	SAR_Eukaryotes	453	7.190000000000001e-123	NTclustered	gi\|229594318\|ref\|XM_001030083.3\|	312017	g1642	i0	91.95	0.99079754601227	323	26	99	0	1	323	385	707	Tetrahymena thermophila SB210 40S ribosomal protein S3 partial mRNA	blastn	323	453	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Hymenostomatida	Tetrahymenidae	Tetrahymena	Tetrahymena thermophila
16897135	16897135	PRJNA1188114_P_NODE_1874_length_312_cov_3.433460_g1822_i0	PRJNA1188114	1874	312	3.43346	10.7123952	Tetrahymena pyriformis	5908	SAR_Eukaryotes	SAR_Eukaryotes	392	1.51e-104	NTclustered	gi\|10789\|emb\|X61053.1\|	5908	g1822	i0	96.996	120.416666666667	233	7	75	0	80	312	1334	1102	T.pyriformis TU20 gene for ubiquitin	blastn	37570	392	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Hymenostomatida	Tetrahymenidae	Tetrahymena	Tetrahymena pyriformis
18171626	18171626	PRJNA1188114_P_NODE_3115_length_247_cov_1.030303_g3063_i0	PRJNA1188114	3115	247	1.030303	2.54484841	Tetrahymena thermophila	5911	SAR_Eukaryotes	SAR_Eukaryotes	230	9.61e-56	NTclustered	gi\|829100410\|ref\|XM_001007359.3\|	312017	g3063	i0	85.268	0.906882591093117	224	31	90	2	7	229	651	429	Tetrahymena thermophila SB210 transmembrane protein, putative partial mRNA	blastn	224	230	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Hymenostomatida	Tetrahymenidae	Tetrahymena	Tetrahymena thermophila
18171644	18171644	PRJNA1188114_P_NODE_6115_length_191_cov_1.746479_g6063_i0	PRJNA1188114	6115	191	1.746479	3.33577489	Tetrahymena thermophila	5911	SAR_Eukaryotes	SAR_Eukaryotes	276	8.95e-70	NTclustered	gi\|829192652\|ref\|XM_001030092.3\|	312017	g6063	i0	92.67	2.77486910994764	191	14	100	0	1	191	367	177	Tetrahymena thermophila SB210 40S ribosomal protein S8-2 partial mRNA	blastn	530	276	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Hymenostomatida	Tetrahymenidae	Tetrahymena	Tetrahymena thermophila
18893584	18893584	PRJNA1188114_P_NODE_2615_length_266_cov_0.940092_g2563_i0	PRJNA1188114	2615	266	0.940092	2.50064472	Tetrahymena	5890	SAR_Eukaryotes	SAR_Eukaryotes	342	1.2899999999999999e-89	NTclustered	gi\|315570290\|tpg\|BK007907.1\|	5911	g2563	i0	89.925	2.01503759398496	268	24	99	3	1	265	634	367	TPA_exp: Tetrahymena thermophila 40S ribosomal protein rpS1e mRNA, complete cds	blastn	536	342	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Hymenostomatida	Tetrahymenidae	Tetrahymena	Tetrahymena thermophila
18893588	18893588	PRJNA1188114_P_NODE_3195_length_244_cov_1.569231_g3143_i0	PRJNA1188114	3195	244	1.569231	3.82892364	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	446	8.639999999999999e-121	NTclustered	gi\|1837628855\|gb\|MN158348.1\|	5909	g3143	i0	99.59	97.4754098360656	244	1	100	0	1	244	2903	2660	Tetrahymena rostrata strain TRAUS 18S ribosomal RNA gene, internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, and 28S ribosomal RNA gene, complete sequence	blastn	23784	446	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Hymenostomatida	Tetrahymenidae	Tetrahymena	Tetrahymena rostrata
19445974	19445974	PRJNA1188114_P_NODE_11696_length_168_cov_1.714286_g11644_i0	PRJNA1188114	11696	168	1.714286	2.88000048	Tetrahymena thermophila	5911	SAR_Eukaryotes	SAR_Eukaryotes	189	1.0299999999999998e-43	NTclustered	gi\|829183394\|ref\|XM_001020966.3\|	312017	g11644	i0	87.273	0.982142857142857	165	21	98	0	4	168	449	285	Tetrahymena thermophila SB210 transmembrane protein, putative partial mRNA	blastn	165	189	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Hymenostomatida	Tetrahymenidae	Tetrahymena	Tetrahymena thermophila
19446048	19446048	PRJNA1188114_P_NODE_3056_length_249_cov_1.470000_g3004_i0	PRJNA1188114	3056	249	1.47	3.6603	Tetrahymena thermophila	5911	SAR_Eukaryotes	SAR_Eukaryotes	206	1.6299999999999998e-48	NTclustered	gi\|829184530\|ref\|XM_001021598.3\|	312017	g3004	i0	81.818	1.01606425702811	253	38	100	4	1	249	336	88	Tetrahymena thermophila SB210 60S ribosomal protein L34 partial mRNA	blastn	253	206	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Hymenostomatida	Tetrahymenidae	Tetrahymena	Tetrahymena thermophila
21996756	21996756	PRJNA1188114_P_NODE_6618_length_189_cov_1.314286_g6566_i0	PRJNA1188114	6618	189	1.314286	2.48400054	Tetrahymena thermophila	5911	SAR_Eukaryotes	SAR_Eukaryotes	237	4.17e-58	NTclustered	gi\|829186368\|ref\|XM_001022292.3\|	312017	g6566	i0	89.362	0.994708994708995	188	20	99	0	1	188	693	506	Tetrahymena thermophila SB210 peptidase M16 inactive domain protein partial mRNA	blastn	188	237	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Hymenostomatida	Tetrahymenidae	Tetrahymena	Tetrahymena thermophila
22718929	22718929	PRJNA1188114_P_NODE_1558_length_342_cov_2.784983_g1506_i0	PRJNA1188114	1558	342	2.784983	9.52464186	Tetrahymena	5890	SAR_Eukaryotes	SAR_Eukaryotes	333	1.03e-86	NTclustered	gi\|315570342\|tpg\|BK007933.1\|	5911	g1506	i0	86.084	1.80701754385965	309	43	90	0	1	309	7	315	TPA_exp: Tetrahymena thermophila 40S ribosomal protein rpS26e mRNA, complete cds	blastn	618	333	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Hymenostomatida	Tetrahymenidae	Tetrahymena	Tetrahymena thermophila
23272171	23272171	PRJNA1188114_P_NODE_17079_length_163_cov_0.894737_g17027_i0	PRJNA1188114	17079	163	0.894737	1.45842131	Tetrahymena thermophila	5911	SAR_Eukaryotes	SAR_Eukaryotes	252	1.25e-62	NTclustered	gi\|118385632\|ref\|XM_001025944.1\|	312017	g17027	i0	94.479	1	163	9	100	0	1	163	513	351	Tetrahymena thermophila SB210 receptor of activated kinase C 1A, component of 40S small ribosomal subunit partial mRNA	blastn	163	252	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Hymenostomatida	Tetrahymenidae	Tetrahymena	Tetrahymena thermophila
23994221	23994221	PRJNA1188114_P_NODE_2299_length_282_cov_1.163090_g2247_i0	PRJNA1188114	2299	282	1.16309	3.2799138	Tetrahymena	5890	SAR_Eukaryotes	SAR_Eukaryotes	472	1.6799999999999998e-128	NTclustered	gi\|315570294\|tpg\|BK007909.1\|	5911	g2247	i0	96.809	2	282	9	100	0	1	282	654	373	TPA_exp: Tetrahymena thermophila 40S ribosomal protein rpS2e mRNA, complete cds	blastn	564	472	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);;