metadata: contig_metadata: 11 rows where analysis = "diamond", bioproject = "PRJNA800053" and tax

11 rows where analysis = "diamond", bioproject = "PRJNA800053" 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
10148382	10148382	PRJNA800053_P_NODE_14588_length_268_cov_1.579487_g14424_i0	PRJNA800053	14588	268	1.579487	4.23302516	Stylonychia lemnae	5949	SAR_Eukaryotes	SAR_Eukaryotes	125	4.2e-31	NR	CDW81236.1	5949	g14424	i0	58.4	0.996268656716418	89	37	99.6	0	268	2	147	235	CDW81236.1 malate dehydrogenase [Stylonychia lemnae]	diamond	267	125	1	Eukaryota	Sar	Ciliophora	Spirotrichea	Sporadotrichida	Oxytrichidae	Stylonychia	Stylonychia lemnae
26705627	26705627	PRJNA800053_P_NODE_17541_length_251_cov_0.865169_g17377_i0	PRJNA800053	17541	251	0.865169	2.17157419	Tetrahymena thermophila SB21	5911	SAR_Eukaryotes	SAR_Eukaryotes	71.6	1.25e-12	NR	XP_001018318.1	312017	g17377	i0	48.6	0.860557768924303	72	37	86.1	0	35	250	111	182	XP_001018318.1 enoyl-CoA hydratase/delta3,5-delta2,4-dienoyl-CoA isomerase [Tetrahymena thermophila SB210]	diamond	216	71.6	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Hymenostomatida	Tetrahymenidae	Tetrahymena	Tetrahymena thermophila
27063004	27063004	PRJNA800053_P_NODE_15222_length_264_cov_1.198953_g15058_i0	PRJNA800053	15222	264	1.198953	3.16523592	root	1	Root_unresolved	Root_unresolved	115	1.57e-27	NR	XP_001021485.3	312017	g15058	i0	61.4	10	88	34	100	0	1	264	441	528	XP_001021485.3 succinyl-CoA:3-ketoacid-coenzyme A transferase [Tetrahymena thermophila SB210]	diamond	2640	115	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Hymenostomatida	Tetrahymenidae	Tetrahymena	Tetrahymena thermophila
27370462	27370462	PRJNA800053_P_NODE_19843_length_247_cov_0.885057_g19679_i0	PRJNA800053	19843	247	0.885057	2.18609079	Moneuplotes crassus	5936	SAR_Eukaryotes	SAR_Eukaryotes	46.6	0.00167	NR	CAI2369249.1	5936	g19679	i0	54.1	0.449392712550607	37	17	44.9	0	4	114	211	247	CAI2369249.1 unnamed protein product [Moneuplotes crassus]	diamond	111	46.6	1	Eukaryota	Sar	Ciliophora	Spirotrichea	Euplotida	Euplotidae	Moneuplotes	Moneuplotes crassus
29210565	29210565	PRJNA800053_P_NODE_12569_length_283_cov_1.100000_g12405_i0	PRJNA800053	12569	283	1.1	3.113	Paramecium	5884	SAR_Eukaryotes	SAR_Eukaryotes	82.4	3.93e-16	NR	XP_001450671.1	5888	g12405	i0	44.3	6.53003533568905	88	42	89	2	256	5	42	126	XP_001450671.1 uncharacterized protein GSPATT00017618001 [Paramecium tetraurelia]	diamond	1848	83.2	0.990384615384615	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Peniculida	Parameciidae	Paramecium	Paramecium tetraurelia
29359410	29359410	PRJNA800053_P_NODE_23649_length_241_cov_0.916667_g23485_i0	PRJNA800053	23649	241	0.916667	2.20916747	Tetrahymena thermophila SB21	5911	SAR_Eukaryotes	SAR_Eukaryotes	68.6	2.89e-11	NR	XP_001033076.2	312017	g23485	i0	65.1	0.535269709543568	43	15	53.5	0	132	4	416	458	XP_001033076.2 ubiquitin carboxyl-terminal hydrolase [Tetrahymena thermophila SB210]	diamond	129	68.6	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Hymenostomatida	Tetrahymenidae	Tetrahymena	Tetrahymena thermophila
29422265	29422265	PRJNA800053_P_NODE_14229_length_271_cov_0.994949_g14065_i0	PRJNA800053	14229	271	0.994949	2.69631179	Paramecium tetraurelia	5888	SAR_Eukaryotes	SAR_Eukaryotes	77.4	3.25e-14	NR	XP_001448566.1	5888	g14065	i0	51.5	2.19188191881919	66	32	73.1	0	3	200	562	627	XP_001448566.1 uncharacterized protein GSPATT00016010001 [Paramecium tetraurelia]	diamond	594	77.4	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Peniculida	Parameciidae	Paramecium	Paramecium tetraurelia
29737953	29737953	PRJNA800053_P_NODE_6750_length_360_cov_1.606272_g6586_i0	PRJNA800053	6750	360	1.606272	5.7825792	Tetrahymena malaccensis	5901	SAR_Eukaryotes	SAR_Eukaryotes	110	1.83e-25	NR	KAL4449249.1	5901	g6586	i0	63	0.766666666666667	92	34	76.7	0	356	81	605	696	KAL4449249.1 hypothetical protein ABPG74_015631 [Tetrahymena malaccensis]	diamond	276	110	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Hymenostomatida	Tetrahymenidae	Tetrahymena	Tetrahymena malaccensis
30211863	30211863	PRJNA800053_P_NODE_18792_length_249_cov_0.875000_g18628_i0	PRJNA800053	18792	249	0.875	2.17875	Stylonychia lemnae	5949	SAR_Eukaryotes	SAR_Eukaryotes	43.1	0.0276	NR	CDW81038.1	5949	g18628	i0	81.8	0.265060240963855	22	4	26.5	0	2	67	106	127	CDW81038.1 nli interacting factor-like phosphatase family protein [Stylonychia lemnae]	diamond	66	43.1	1	Eukaryota	Sar	Ciliophora	Spirotrichea	Sporadotrichida	Oxytrichidae	Stylonychia	Stylonychia lemnae
30370486	30370486	PRJNA800053_P_NODE_23212_length_242_cov_0.911243_g23048_i0	PRJNA800053	23212	242	0.911243	2.20520806	Moneuplotes crassus	5936	SAR_Eukaryotes	SAR_Eukaryotes	64.7	1.04e-10	NR	CAI2376927.1	5936	g23048	i0	43.4	0.942148760330578	76	33	94.2	1	4	231	62	127	CAI2376927.1 unnamed protein product [Moneuplotes crassus]	diamond	228	64.7	1	Eukaryota	Sar	Ciliophora	Spirotrichea	Euplotida	Euplotidae	Moneuplotes	Moneuplotes crassus
30559371	30559371	PRJNA800053_P_NODE_15833_length_260_cov_1.427807_g15669_i0	PRJNA800053	15833	260	1.427807	3.7122982	Stylonychia lemnae	5949	SAR_Eukaryotes	SAR_Eukaryotes	90.1	3.79e-19	NR	CDW76069.1	5949	g15669	i0	86.5	0.6	52	7	60	0	4	159	186	237	CDW76069.1 UNKNOWN [Stylonychia lemnae]	diamond	156	90.1	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);;