metadata: contig_metadata: 20 rows where analysis = "blastn", bioproject = "PRJNA401346" and tax

20 rows where analysis = "blastn", bioproject = "PRJNA401346" 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
1689193	1689193	PRJNA401346_P_NODE_8422_length_202_cov_0.907801_g8401_i0	PRJNA401346	8422	202	0.907801	1.83375802	Chilodonella uncinata	151077	SAR_Eukaryotes	SAR_Eukaryotes	318	1.57e-82	NTclustered	gi\|300676714\|gb\|GQ377691.1\|	151077	g8401	i0	95.05	15.4356435643564	202	10	100	0	1	202	287	86	Chilodonella uncinata rps22a (rps22a) mRNA, complete cds	blastn	3118	318	1	Eukaryota	Sar	Ciliophora	Phyllopharyngea	Chlamydodontida	Chilodonellidae	Chilodonella	Chilodonella uncinata
4241261	4241261	PRJNA401346_P_NODE_2384_length_325_cov_1.454545_g2363_i0	PRJNA401346	2384	325	1.454545	4.72727125	Tetrahymena thermophila	5911	SAR_Eukaryotes	SAR_Eukaryotes	451	2.5800000000000003e-122	NTclustered	gi\|146181944\|ref\|XM_001023662.2\|	312017	g2363	i0	91.692	1	325	27	100	0	1	325	244	568	Tetrahymena thermophila SB210 60S ribosomal protein L13/L16 partial mRNA	blastn	325	451	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Hymenostomatida	Tetrahymenidae	Tetrahymena	Tetrahymena thermophila
5517918	5517918	PRJNA401346_P_NODE_1845_length_360_cov_4.638796_g1824_i0	PRJNA401346	1845	360	4.638796	16.6996656	Pleurotricha lanceolata	57511	SAR_Eukaryotes	SAR_Eukaryotes	207	6.88e-49	NTclustered	gi\|21779953\|gb\|AF506074.1\|	57511	g1824	i0	83.051	35.1222222222222	236	33	64	6	24	255	1502	1270	Pleurotricha lanceolata macronuclear histone H4 gene, complete cds	blastn	12644	207	1	Eukaryota	Sar	Ciliophora	Spirotrichea	Sporadotrichida	Oxytrichidae	Pleurotricha	Pleurotricha lanceolata
5518018	5518018	PRJNA401346_P_NODE_5045_length_237_cov_1.454545_g5024_i0	PRJNA401346	5045	237	1.454545	3.44727165	Tetrahymena thermophila	5911	SAR_Eukaryotes	SAR_Eukaryotes	372	1.44e-98	NTclustered	gi\|829195198\|ref\|XM_001025389.3\|	312017	g5024	i0	95.299	14.6877637130802	234	11	99	0	4	237	255	22	Tetrahymena thermophila SB210 40S ribosomal protein S14 partial mRNA	blastn	3481	372	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Hymenostomatida	Tetrahymenidae	Tetrahymena	Tetrahymena thermophila
7459021	7459021	PRJNA401346_P_NODE_2626_length_312_cov_1.015936_g2605_i0	PRJNA401346	2626	312	1.015936	3.16972032	Ciliophora	5878	SAR_Eukaryotes	SAR_Eukaryotes	571	1.81e-158	NTclustered	gi\|2065561668\|gb\|MZ540265.1\|	44029	g2605	i0	99.679	97.5897435897436	312	1	100	0	1	312	622	933	Paramecium jenningsi isolate UR02 small subunit ribosomal RNA gene, partial sequence	blastn	30448	571	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Peniculida	Parameciidae	Paramecium	Paramecium jenningsi
9342363	9342363	PRJNA401346_P_NODE_288_length_848_cov_2.416773_g274_i0	PRJNA401346	288	848	2.416773	20.49423504	Vorticella microstoma	77619	SAR_Eukaryotes	SAR_Eukaryotes	1192	0	NTclustered	gi\|21429685\|gb\|AY101350.1\|	77619	g274	i0	94.771	87.0212264150943	765	40	90	0	84	848	7	771	Vorticella microstoma alpha-tubulin gene, partial cds	blastn	73794	1192	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Sessilida	Vorticellidae	Vorticella	Vorticella microstoma
10618063	10618063	PRJNA401346_P_NODE_1049_length_457_cov_1.919192_g1028_i0	PRJNA401346	1049	457	1.919192	8.77070744	Chilodonella uncinata	151077	SAR_Eukaryotes	SAR_Eukaryotes	660	0	NTclustered	gi\|301014695\|gb\|GQ377692.1\|	151077	g1028	i0	93.304	56.2013129102845	448	29	98	1	1	448	23	469	Chilodonella uncinata ribosomal protein S23a-like (rps23a) mRNA, complete sequence	blastn	25684	660	1	Eukaryota	Sar	Ciliophora	Phyllopharyngea	Chlamydodontida	Chilodonellidae	Chilodonella	Chilodonella uncinata
10618273	10618273	PRJNA401346_P_NODE_7989_length_204_cov_0.881119_g7968_i0	PRJNA401346	7989	204	0.881119	1.79748276	Tetrahymena thermophila	5911	SAR_Eukaryotes	SAR_Eukaryotes	283	5.8e-72	NTclustered	gi\|829199477\|ref\|XM_001027976.3\|	312017	g7968	i0	92.04	1.56372549019608	201	16	99	0	1	201	436	636	Tetrahymena thermophila SB210 60S ribosomal protein L3, putative partial mRNA	blastn	319	283	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Hymenostomatida	Tetrahymenidae	Tetrahymena	Tetrahymena thermophila
13167951	13167951	PRJNA401346_P_NODE_2471_length_320_cov_0.969112_g2450_i0	PRJNA401346	2471	320	0.969112	3.1011584	Tetrahymena thermophila	5911	SAR_Eukaryotes	SAR_Eukaryotes	359	1.58e-94	NTclustered	gi\|829101149\|ref\|XM_001007727.3\|	312017	g2450	i0	86.875	1	320	42	100	0	1	320	315	634	Tetrahymena thermophila SB210 peptidase C13 family protein partial mRNA	blastn	320	359	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Hymenostomatida	Tetrahymenidae	Tetrahymena	Tetrahymena thermophila
13834582	13834582	PRJNA401346_P_NODE_1871_length_359_cov_1.073826_g1850_i0	PRJNA401346	1871	359	1.073826	3.85503534	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	348	3.8700000000000003e-91	NTclustered	gi\|331686195\|gb\|HQ432921.1\|	94289	g1850	i0	88.356	88.4763231197772	292	30	81	4	1	290	496	207	Sterkiella histriomuscorum strain BA elongation factor-1 (ef-1) gene, complete cds; macronuclear	blastn	31763	350	0.994285714285714	Eukaryota	Sar	Ciliophora	Spirotrichea	Sporadotrichida	Oxytrichidae	Sterkiella	Sterkiella histriomuscorum
14443305	14443305	PRJNA401346_P_NODE_8692_length_201_cov_0.914286_g8671_i0	PRJNA401346	8692	201	0.914286	1.83771486	Ichthyophthirius multifiliis	5932	SAR_Eukaryotes	SAR_Eukaryotes	121	4.7199999999999996e-23	NTclustered	gi\|471230232\|ref\|XM_004036352.1\|	5932	g8671	i0	77.665	0.980099502487562	197	44	98	0	1	197	122	318	Ichthyophthirius multifiliis ribosomal protein, putative (IMG5_083830) mRNA, complete cds	blastn	197	121	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Hymenostomatida		Ichthyophthirius	Ichthyophthirius multifiliis
15716866	15716866	PRJNA401346_P_NODE_1313_length_414_cov_2.249292_g1292_i0	PRJNA401346	1313	414	2.249292	9.31206888	Opisthonecta sp. FG-2015	1607889	SAR_Eukaryotes	SAR_Eukaryotes	739	0	NTclustered	gi\|759083562\|gb\|KM222179.1\|	1607889	g1292	i0	99.029	88.9806763285024	412	4	99	0	3	414	447	36	Opisthonecta sp. FG-2015 voucher SZ2011052301 large subunit ribosomal RNA gene, partial sequence	blastn	36838	739	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Sessilida	Opisthonectidae	Opisthonecta	Opisthonecta sp. FG-2015
18265893	18265893	PRJNA401346_P_NODE_5335_length_230_cov_1.171598_g5314_i0	PRJNA401346	5335	230	1.171598	2.6946754	Tetrahymena thermophila	5911	SAR_Eukaryotes	SAR_Eukaryotes	228	3.1799999999999992e-55	NTclustered	gi\|829195582\|ref\|XM_001025656.3\|	312017	g5314	i0	85.714	0.943478260869565	217	29	94	2	15	230	387	172	Tetrahymena thermophila SB210 60S ribosomal protein L14 partial mRNA	blastn	217	228	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Hymenostomatida	Tetrahymenidae	Tetrahymena	Tetrahymena thermophila
20815881	20815881	PRJNA401346_P_NODE_4417_length_253_cov_1.447917_g4396_i0	PRJNA401346	4417	253	1.447917	3.66323001	Euplotes vannus	5939	SAR_Eukaryotes	SAR_Eukaryotes	257	4.5300000000000005e-64	NTclustered	gi\|409187355\|gb\|JQ289918.1\|	5939	g4396	i0	85.098	228.438735177866	255	34	100	4	1	253	124	376	Euplotes vannus clone eu568c5 polyubiquitin gene, partial cds; macronuclear	blastn	57795	257	1	Eukaryota	Sar	Ciliophora	Spirotrichea	Euplotida	Euplotidae	Euplotes	Euplotes vannus
20815911	20815911	PRJNA401346_P_NODE_5457_length_227_cov_1.265060_g5436_i0	PRJNA401346	5457	227	1.26506	2.8716862	Tetrahymena thermophila	5911	SAR_Eukaryotes	SAR_Eukaryotes	80.5	9.27e-11	NTclustered	gi\|829144161\|ref\|XM_012796023.1\|	312017	g5436	i0	95.918	0.215859030837004	49	2	22	0	179	227	456	408	Tetrahymena thermophila SB210 nucleoside diphosphate kinase partial mRNA	blastn	49	80.5	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Hymenostomatida	Tetrahymenidae	Tetrahymena	Tetrahymena thermophila
22090663	22090663	PRJNA401346_P_NODE_3338_length_284_cov_2.210762_g3317_i0	PRJNA401346	3338	284	2.210762	6.27856408	Vorticella microstoma	77619	SAR_Eukaryotes	SAR_Eukaryotes	503	6.02e-138	NTclustered	gi\|21429685\|gb\|AY101350.1\|	77619	g3317	i0	98.592	96.6654929577465	284	4	100	0	1	284	1087	804	Vorticella microstoma alpha-tubulin gene, partial cds	blastn	27453	503	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Sessilida	Vorticellidae	Vorticella	Vorticella microstoma
22090712	22090712	PRJNA401346_P_NODE_5018_length_238_cov_1.084746_g4997_i0	PRJNA401346	5018	238	1.084746	2.58169548	Paramecium tetraurelia	5888	SAR_Eukaryotes	SAR_Eukaryotes	244	3.2899999999999996e-60	NTclustered	gi\|2386231765\|ref\|XM_001433469.2\|	5888	g4997	i0	85.776	18.1050420168067	232	31	97	2	8	238	681	451	Paramecium tetraurelia uncharacterized protein (GSPATT00035238001), mRNA	blastn	4309	244	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Peniculida	Parameciidae	Paramecium	Paramecium tetraurelia
23366290	23366290	PRJNA401346_P_NODE_3739_length_272_cov_0.867299_g3718_i0	PRJNA401346	3739	272	0.867299	2.35905328	Tetrahymena thermophila	5911	SAR_Eukaryotes	SAR_Eukaryotes	248	2.97e-61	NTclustered	gi\|829197694\|ref\|XM_001029851.3\|	312017	g3718	i0	83.582	2.27573529411765	268	40	98	4	1	266	524	789	Tetrahymena thermophila SB210 papain family cysteine protease partial mRNA	blastn	619	248	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Hymenostomatida	Tetrahymenidae	Tetrahymena	Tetrahymena thermophila
24640583	24640583	PRJNA401346_P_NODE_3260_length_287_cov_1.132743_g3239_i0	PRJNA401346	3260	287	1.132743	3.25097241	Tetrahymena thermophila	5911	SAR_Eukaryotes	SAR_Eukaryotes	261	4.05e-65	NTclustered	gi\|829160192\|ref\|XM_001012283.3\|	312017	g3239	i0	89.423	1.02439024390244	208	20	72	2	56	262	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
24640736	24640736	PRJNA401346_P_NODE_760_length_529_cov_0.920940_g739_i0	PRJNA401346	760	529	0.92094	4.8717726	Uroleptus gallina	57513	SAR_Eukaryotes	SAR_Eukaryotes	643	6.729999999999998e-180	NTclustered	gi\|21215215\|gb\|AF510209.1\|	57513	g739	i0	88.636	98.7296786389414	528	60	99	0	2	529	625	1152	Uroleptus gallina beta-tubulin gene, complete cds	blastn	52228	643	1	Eukaryota	Sar	Ciliophora	Spirotrichea	Urostylida	Urostylidae	Uroleptus	Uroleptus gallina

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