metadata: contig_metadata: 19 rows where bioproject = "PRJEB76780", tax_clade = "Sar" and tax

19 rows where bioproject = "PRJEB76780", tax_clade = "Sar" 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
1413374	1413374	PRJEB76780_P_NODE_13442_length_242_cov_0.923077_g13342_i0	PRJEB76780	13442	242	0.923077	2.23384634	Sterkiella nova	200597	SAR_Eukaryotes	SAR_Eukaryotes	165	2.68e-36	NTclustered	gi\|1051275\|gb\|U37280.1\|ONU37280	200597	g13342	i0	81.068	5.45867768595041	206	39	85	0	27	232	1602	1807	Oxytricha nova Hsp70 gene, complete cds	blastn	1321	165	1	Eukaryota	Sar	Ciliophora	Spirotrichea	Sporadotrichida	Oxytrichidae	Sterkiella	Sterkiella nova
15441219	15441219	PRJEB76780_P_NODE_3753_length_421_cov_1.913793_g3653_i0	PRJEB76780	3753	421	1.913793	8.05706853	Ichthyophthirius multifiliis	5932	SAR_Eukaryotes	SAR_Eukaryotes	126	3.88e-32	NR	XP_004039243.1	5932	g3653	i0	55.2	1.76722090261283	125	54	89.1	1	41	415	27	149	XP_004039243.1 hypothetical protein IMG5_030200 [Ichthyophthirius multifiliis]	diamond	744	126	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Hymenostomatida		Ichthyophthirius	Ichthyophthirius multifiliis
26685927	26685927	PRJEB76780_P_NODE_2301_length_545_cov_2.239407_g2201_i0	PRJEB76780	2301	545	2.239407	12.20476815	Pseudocohnilembus persalinus	266149	SAR_Eukaryotes	SAR_Eukaryotes	60.5	4.49e-8	NR	KRX08349.1	266149	g2201	i0	35.5	0.66605504587156	121	68	65.5	4	453	97	17	129	KRX08349.1 hypothetical protein PPERSA_03343 [Pseudocohnilembus persalinus]	diamond	363	60.5	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Philasterida	Pseudocohnilembidae	Pseudocohnilembus	Pseudocohnilembus persalinus
28550362	28550362	PRJEB76780_P_NODE_3767_length_420_cov_1.798271_g3667_i0	PRJEB76780	3767	420	1.798271	7.5527382	Stentor coeruleus	5963	SAR_Eukaryotes	SAR_Eukaryotes	77	1.7e-14	NR	OMJ89086.1	5963	g3667	i0	41.5	0.757142857142857	106	61	75.7	1	332	15	14	118	OMJ89086.1 hypothetical protein SteCoe_8807 [Stentor coeruleus]	diamond	318	77	1	Eukaryota	Sar	Ciliophora	Heterotrichea	Heterotrichida	Stentoridae	Stentor	Stentor coeruleus
28637811	28637811	PRJEB76780_P_NODE_10307_length_253_cov_0.866667_g10207_i0	PRJEB76780	10307	253	0.866667	2.19266751	Ciliophora	5878	SAR_Eukaryotes	SAR_Eukaryotes	54.7	2.12e-6	NR	CDW91600.1	5949	g10207	i0	30.5	1.86166007905138	82	49	97.2	1	250	5	135	208	CDW91600.1 UNKNOWN [Stylonychia lemnae]	diamond	471	55.1	0.992740471869329	Eukaryota	Sar	Ciliophora	Spirotrichea	Sporadotrichida	Oxytrichidae	Stylonychia	Stylonychia lemnae
29402633	29402633	PRJEB76780_P_NODE_1969_length_591_cov_2.034749_g1870_i0	PRJEB76780	1969	591	2.034749	12.02536659	Tetrahymena thermophila SB21	5911	SAR_Eukaryotes	SAR_Eukaryotes	98.2	1.44e-20	NR	XP_012652918.1	312017	g1870	i0	32.7	1.05583756345178	208	127	99.5	7	1	588	132	338	XP_012652918.1 ferric reductase-like transmembrane component family protein [Tetrahymena thermophila SB210]	diamond	624	98.2	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Hymenostomatida	Tetrahymenidae	Tetrahymena	Tetrahymena thermophila
29433919	29433919	PRJEB76780_P_NODE_12270_length_246_cov_0.901734_g12170_i0	PRJEB76780	12270	246	0.901734	2.21826564	Blepharisma stoltei	1481888	SAR_Eukaryotes	SAR_Eukaryotes	94.7	2.04e-20	NR	CAG9324716.1	1481888	g12170	i0	54.3	2.07317073170732	81	37	98.8	0	243	1	964	1044	CAG9324716.1 unnamed protein product [Blepharisma stoltei]	diamond	510	94.7	1	Eukaryota	Sar	Ciliophora	Heterotrichea	Heterotrichida	Blepharismidae	Blepharisma	Blepharisma stoltei
29844674	29844674	PRJEB76780_P_NODE_6351_length_320_cov_1.263158_g6251_i0	PRJEB76780	6351	320	1.263158	4.0421056	Halteria grandinella	5974	SAR_Eukaryotes	SAR_Eukaryotes	150	5.539999999999999e-42	NR	TNV86214.1	5974	g6251	i0	70.9	0.965625	103	30	96.6	0	310	2	110	212	TNV86214.1 hypothetical protein FGO68_gene7586 [Halteria grandinella]	diamond	309	150	1	Eukaryota	Sar	Ciliophora	Spirotrichea	Sporadotrichida	Halteriidae	Halteria	Halteria grandinella
30160398	30160398	PRJEB76780_P_NODE_4552_length_381_cov_1.009740_g4452_i0	PRJEB76780	4552	381	1.00974	3.8471094	Stentor coeruleus	5963	SAR_Eukaryotes	SAR_Eukaryotes	75.5	6.16e-13	NR	OMJ66344.1	5963	g4452	i0	34.2	0.897637795275591	114	71	89	2	9	347	806	916	OMJ66344.1 hypothetical protein SteCoe_36834 [Stentor coeruleus]	diamond	342	75.5	1	Eukaryota	Sar	Ciliophora	Heterotrichea	Heterotrichida	Stentoridae	Stentor	Stentor coeruleus
30319163	30319163	PRJEB76780_P_NODE_11472_length_249_cov_0.886364_g11372_i0	PRJEB76780	11472	249	0.886364	2.20704636	Pseudocohnilembus persalinus	266149	SAR_Eukaryotes	SAR_Eukaryotes	73.2	6.34e-13	NR	KRX10142.1	266149	g11372	i0	53.8	0.783132530120482	65	27	78.3	1	14	208	169	230	KRX10142.1 Nucleoside diphosphate kinase [Pseudocohnilembus persalinus]	diamond	195	73.2	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Philasterida	Pseudocohnilembidae	Pseudocohnilembus	Pseudocohnilembus persalinus
30508191	30508191	PRJEB76780_P_NODE_7753_length_290_cov_1.465438_g7653_i0	PRJEB76780	7753	290	1.465438	4.2497702	Ichthyophthirius multifiliis	5932	SAR_Eukaryotes	SAR_Eukaryotes	55.5	2.12e-6	NR	XP_004029734.1	5932	g7653	i0	30.8	0.941379310344828	91	63	94.1	0	6	278	195	285	XP_004029734.1 ubiquitin-conjugating enzyme family protein, putative [Ichthyophthirius multifiliis]	diamond	273	55.5	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Hymenostomatida		Ichthyophthirius	Ichthyophthirius multifiliis
31202808	31202808	PRJEB76780_P_NODE_12955_length_243_cov_1.370588_g12855_i0	PRJEB76780	12955	243	1.370588	3.33052884	Blepharisma stoltei	1481888	SAR_Eukaryotes	SAR_Eukaryotes	65.9	2.78e-10	NR	CAG9331708.1	1481888	g12855	i0	42	1	81	46	100	1	1	243	352	431	CAG9331708.1 unnamed protein product [Blepharisma stoltei]	diamond	243	65.9	1	Eukaryota	Sar	Ciliophora	Heterotrichea	Heterotrichida	Blepharismidae	Blepharisma	Blepharisma stoltei
31677631	31677631	PRJEB76780_P_NODE_4937_length_365_cov_1.602740_g4837_i0	PRJEB76780	4937	365	1.60274	5.850001	Stentor coeruleus	5963	SAR_Eukaryotes	SAR_Eukaryotes	116	1.3199999999999999e-28	NR	OMJ75977.1	5963	g4837	i0	43.4	1.0027397260274	122	68	99.5	1	1	363	191	312	OMJ75977.1 hypothetical protein SteCoe_24786 [Stentor coeruleus]	diamond	366	116	1	Eukaryota	Sar	Ciliophora	Heterotrichea	Heterotrichida	Stentoridae	Stentor	Stentor coeruleus
31772543	31772543	PRJEB76780_P_NODE_5377_length_349_cov_1.474638_g5277_i0	PRJEB76780	5377	349	1.474638	5.14648662	Ichthyophthirius multifiliis	5932	SAR_Eukaryotes	SAR_Eukaryotes	99.4	3.14e-22	NR	XP_004034583.1	5932	g5277	i0	44.2	3.97994269340974	113	62	96.3	1	349	14	158	270	XP_004034583.1 zinc-binding dehydrogenase family protein, putative [Ichthyophthirius multifiliis]	diamond	1389	99.4	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Hymenostomatida		Ichthyophthirius	Ichthyophthirius multifiliis
31796770	31796770	PRJEB76780_P_NODE_12037_length_247_cov_0.896552_g11937_i0	PRJEB76780	12037	247	0.896552	2.21448344	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	68.6	2.69e-11	NR	XP_001470740.1	312017	g11937	i0	56.1	1.96761133603239	57	25	69.2	0	68	238	8	64	XP_001470740.1 NAD-dependent epimerase/dehydratase family protein [Tetrahymena thermophila SB210]	diamond	486	68.9	0.995645863570392	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Hymenostomatida	Tetrahymenidae	Tetrahymena	Tetrahymena thermophila
31930674	31930674	PRJEB76780_P_NODE_10677_length_252_cov_0.871508_g10577_i0	PRJEB76780	10677	252	0.871508	2.19620016	Moneuplotes crassus	5936	SAR_Eukaryotes	SAR_Eukaryotes	53.5	6.31e-6	NR	CAI2359373.1	5936	g10577	i0	32.9	0.869047619047619	73	45	83.3	2	218	9	1	72	CAI2359373.1 unnamed protein product [Moneuplotes crassus]	diamond	219	53.5	1	Eukaryota	Sar	Ciliophora	Spirotrichea	Euplotida	Euplotidae	Moneuplotes	Moneuplotes crassus
31994052	31994052	PRJEB76780_P_NODE_12218_length_246_cov_0.901734_g12118_i0	PRJEB76780	12218	246	0.901734	2.21826564	Stylonychia lemnae	5949	SAR_Eukaryotes	SAR_Eukaryotes	139	4.14e-36	NR	CDW80266.1	5949	g12118	i0	87.5	0.975609756097561	80	10	97.6	0	245	6	101	180	CDW80266.1 UNKNOWN [Stylonychia lemnae]	diamond	240	139	1	Eukaryota	Sar	Ciliophora	Spirotrichea	Sporadotrichida	Oxytrichidae	Stylonychia	Stylonychia lemnae
32057302	32057302	PRJEB76780_P_NODE_11998_length_247_cov_0.896552_g11898_i0	PRJEB76780	11998	247	0.896552	2.21448344	Stentor coeruleus	5963	SAR_Eukaryotes	SAR_Eukaryotes	77.4	4.31e-16	NR	OMJ90512.1	5963	g11898	i0	53.7	3.63157894736842	82	34	99.6	2	246	1	15	92	OMJ90512.1 hypothetical protein SteCoe_7101 [Stentor coeruleus]	diamond	897	77.4	1	Eukaryota	Sar	Ciliophora	Heterotrichea	Heterotrichida	Stentoridae	Stentor	Stentor coeruleus
32437299	32437299	PRJEB76780_P_NODE_12239_length_246_cov_0.901734_g12139_i0	PRJEB76780	12239	246	0.901734	2.21826564	Stylonychia lemnae	5949	SAR_Eukaryotes	SAR_Eukaryotes	112	9.44e-27	NR	CDW86777.1	5949	g12139	i0	86.7	7.35365853658537	60	8	73.2	0	65	244	1	60	CDW86777.1 UNKNOWN [Stylonychia lemnae]	diamond	1809	112	1	Eukaryota	Sar	Ciliophora	Spirotrichea	Sporadotrichida	Oxytrichidae	Stylonychia	Stylonychia lemnae

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