metadata: contig_metadata: 14 rows where bioproject = "PRJNA1180292", tax_clade = "Sar" and tax

14 rows where bioproject = "PRJNA1180292", 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
11796553	11796553	PRJNA1180292_P_NODE_9370_length_250_cov_0.881356_g9238_i0	PRJNA1180292	9370	250	0.881356	2.20339	Oxytricha sp. LPJ-2005	329142	SAR_Eukaryotes	SAR_Eukaryotes	372	1.53e-98	NTclustered	gi\|67462291\|gb\|DQ062087.1\|	329142	g9238	i0	93.6	99.06	250	15	100	1	1	250	793	545	Oxytricha sp. LPJ-2005 heat shock protein 70 mRNA, partial cds; macronuclear	blastn	24765	372	1	Eukaryota	Sar	Ciliophora	Spirotrichea	Sporadotrichida	Oxytrichidae	Oxytricha	Oxytricha sp. LPJ-2005
15620677	15620677	PRJNA1180292_P_NODE_7053_length_266_cov_1.233161_g6921_i0	PRJNA1180292	7053	266	1.233161	3.28020826	Gastrocirrhus monilifer	402891	SAR_Eukaryotes	SAR_Eukaryotes	69.4	2.42e-7	NTclustered	gi\|759083525\|gb\|KM222142.1\|	402891	g6921	i0	73.558	1.21804511278195	208	43	76	12	3	204	1718	1517	Gastrocirrhus monilifer voucher CXM08100701 large subunit ribosomal RNA gene, partial sequence	blastn	324	69.4	1	Eukaryota	Sar	Ciliophora	Spirotrichea	Euplotida	Gastrocirrhidae	Gastrocirrhus	Gastrocirrhus monilifer
20719250	20719250	PRJNA1180292_P_NODE_6817_length_270_cov_1.319797_g6685_i0	PRJNA1180292	6817	270	1.319797	3.5634519	Euplotes eurystomus	5941	SAR_Eukaryotes	SAR_Eukaryotes	191	5.03e-44	NTclustered	gi\|159037\|gb\|M57231.1\|EUPUBQP	5941	g6685	i0	88.961	69.4185185185185	154	17	57	0	117	270	852	699	Euplotes eurystomus macronuclear polyubiquitin, complete cds	blastn	18743	191	1	Eukaryota	Sar	Ciliophora	Spirotrichea	Euplotida	Euplotidae	Euplotes	Euplotes eurystomus
23270030	23270030	PRJNA1180292_P_NODE_4299_length_334_cov_0.892720_g4167_i0	PRJNA1180292	4299	334	0.89272	2.9816848	Euplotes eurystomus	5941	SAR_Eukaryotes	SAR_Eukaryotes	202	2.95e-47	NTclustered	gi\|1209311\|gb\|L15292.1\|EUPHSP70B	5941	g4167	i0	82.353	18.8233532934132	238	37	71	5	29	264	317	83	Euplotes eurystomus macronuclear heat shock protein (hsp1a) gene, complete cds and promoters	blastn	6287	202	1	Eukaryota	Sar	Ciliophora	Spirotrichea	Euplotida	Euplotidae	Euplotes	Euplotes eurystomus
27261981	27261981	PRJNA1180292_P_NODE_6563_length_275_cov_1.158416_g6431_i0	PRJNA1180292	6563	275	1.158416	3.185644	Blepharisma stoltei	1481888	SAR_Eukaryotes	SAR_Eukaryotes	43.5	0.0293	NR	CAG9334146.1	1481888	g6431	i0	51.3	0.425454545454545	39	19	42.5	0	149	33	473	511	CAG9334146.1 unnamed protein product [Blepharisma stoltei]	diamond	117	43.5	1	Eukaryota	Sar	Ciliophora	Heterotrichea	Heterotrichida	Blepharismidae	Blepharisma	Blepharisma stoltei
27470699	27470699	PRJNA1180292_P_NODE_7843_length_253_cov_0.866667_g7711_i0	PRJNA1180292	7843	253	0.866667	2.19266751	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	157	2.1099999999999998e-47	NR	XP_004035804.1	5932	g7711	i0	84.5	61.7549407114625	84	13	99.6	0	2	253	5	88	XP_004035804.1 mitosis protein DIM1, putative [Ichthyophthirius multifiliis]	diamond	15624	157	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Hymenostomatida		Ichthyophthirius	Ichthyophthirius multifiliis
27546186	27546186	PRJNA1180292_P_NODE_2604_length_421_cov_1.227011_g2472_i0	PRJNA1180292	2604	421	1.227011	5.16571631	Stylonychia lemnae	5949	SAR_Eukaryotes	SAR_Eukaryotes	60.5	1.71e-7	NR	CDW86050.1	5949	g2472	i0	44	0.356294536817102	50	28	35.6	0	6	155	632	681	CDW86050.1 zf-traf multi-domain protein [Stylonychia lemnae]	diamond	150	60.5	1	Eukaryota	Sar	Ciliophora	Spirotrichea	Sporadotrichida	Oxytrichidae	Stylonychia	Stylonychia lemnae
29030374	29030374	PRJNA1180292_P_NODE_8348_length_252_cov_0.871508_g8216_i0	PRJNA1180292	8348	252	0.871508	2.19620016	Moneuplotes crassus	5936	SAR_Eukaryotes	SAR_Eukaryotes	57.4	2.2e-7	NR	CAI2369068.1	5936	g8216	i0	36.3	0.952380952380952	80	44	95.2	1	240	1	17	89	CAI2369068.1 unnamed protein product [Moneuplotes crassus]	diamond	240	57.4	1	Eukaryota	Sar	Ciliophora	Spirotrichea	Euplotida	Euplotidae	Moneuplotes	Moneuplotes crassus
29175756	29175756	PRJNA1180292_P_NODE_8869_length_251_cov_0.876404_g8737_i0	PRJNA1180292	8869	251	0.876404	2.19977404	Paramecium	5884	SAR_Eukaryotes	SAR_Eukaryotes	45.8	0.00243	NR	XP_001459843.1	5888	g8737	i0	44.8	2.77290836653386	58	32	69.3	0	249	76	150	207	XP_001459843.1 uncharacterized protein GSPATT00025180001 [Paramecium tetraurelia]	diamond	696	45.8	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Peniculida	Parameciidae	Paramecium	Paramecium tetraurelia
29408964	29408964	PRJNA1180292_P_NODE_10609_length_247_cov_0.896552_g10477_i0	PRJNA1180292	10609	247	0.896552	2.21448344	Stentor coeruleus	5963	SAR_Eukaryotes	SAR_Eukaryotes	131	8.789999999999999e-34	NR	OMJ67872.1	5963	g10477	i0	70.7	0.995951417004049	82	24	99.6	0	1	246	180	261	OMJ67872.1 hypothetical protein SteCoe_34848 [Stentor coeruleus]	diamond	246	131	1	Eukaryota	Sar	Ciliophora	Heterotrichea	Heterotrichida	Stentoridae	Stentor	Stentor coeruleus
30577506	30577506	PRJNA1180292_P_NODE_9393_length_250_cov_0.881356_g9261_i0	PRJNA1180292	9393	250	0.881356	2.20339	Tetrahymena thermophila SB21	5911	SAR_Eukaryotes	SAR_Eukaryotes	44.3	0.011	NR	XP_001021464.3	312017	g9261	i0	57.1	0.42	35	15	42	0	141	245	148	182	XP_001021464.3 DnaJ carboxy-terminal domain protein [Tetrahymena thermophila SB210]	diamond	105	44.3	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Hymenostomatida	Tetrahymenidae	Tetrahymena	Tetrahymena thermophila
30925510	30925510	PRJNA1180292_P_NODE_11754_length_245_cov_0.906977_g11622_i0	PRJNA1180292	11754	245	0.906977	2.22209365	Stentor coeruleus	5963	SAR_Eukaryotes	SAR_Eukaryotes	161	5.04e-49	NR	OMJ77430.1	5963	g11622	i0	95	0.979591836734694	80	4	98	0	242	3	66	145	OMJ77430.1 hypothetical protein SteCoe_22989 [Stentor coeruleus]	diamond	240	161	1	Eukaryota	Sar	Ciliophora	Heterotrichea	Heterotrichida	Stentoridae	Stentor	Stentor coeruleus
31652267	31652267	PRJNA1180292_P_NODE_11677_length_245_cov_0.906977_g11545_i0	PRJNA1180292	11677	245	0.906977	2.22209365	Tetrahymena thermophila SB21	5911	SAR_Eukaryotes	SAR_Eukaryotes	94.4	8.25e-22	NR	XP_001020579.2	312017	g11545	i0	71.9	0.697959183673469	57	16	69.8	0	173	3	26	82	XP_001020579.2 ADP-ribosylation factor(Arf)/Arf-like (Arl) small GTPase family protein [Tetrahymena thermophila SB210]	diamond	171	94.4	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Hymenostomatida	Tetrahymenidae	Tetrahymena	Tetrahymena thermophila
32000434	32000434	PRJNA1180292_P_NODE_4498_length_327_cov_1.216535_g4366_i0	PRJNA1180292	4498	327	1.216535	3.97806945	Paramecium pentaurelia	43138	SAR_Eukaryotes	SAR_Eukaryotes	80.9	4.29e-15	NR	CAD8183410.1	43138	g4366	i0	39.4	3.01834862385321	109	64	99.1	2	3	326	2549	2656	CAD8183410.1 unnamed protein product [Paramecium pentaurelia]	diamond	987	80.9	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Peniculida	Parameciidae	Paramecium	Paramecium pentaurelia

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