metadata: contig_metadata: 9 rows where analysis = "diamond", bioproject = "PRJNA1158727" and tax

9 rows where analysis = "diamond", bioproject = "PRJNA1158727" 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
13059297	13059297	PRJNA1158727_P_NODE_49951_length_501_cov_1.927570_g42496_i0	PRJNA1158727	49951	501	1.92757	9.6571257	Tetrahymena thermophila SB21	5911	SAR_Eukaryotes	SAR_Eukaryotes	155	6.1099999999999985e-43	NR	XP_001023521.1	312017	g42496	i0	54.9	0.850299401197605	142	58	82	2	90	500	174	314	XP_001023521.1 poly (3-hydroxybutyrate) depolymerase [Tetrahymena thermophila SB210]	diamond	426	155	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Hymenostomatida	Tetrahymenidae	Tetrahymena	Tetrahymena thermophila
26818952	26818952	PRJNA1158727_P_NODE_166961_length_228_cov_2.341935_g159499_i0	PRJNA1158727	166961	228	2.341935	5.3396118	Halteria grandinella	5974	SAR_Eukaryotes	SAR_Eukaryotes	117	1.33e-30	NR	TNV78266.1	5974	g159499	i0	72	1.97368421052632	75	21	98.7	0	228	4	60	134	TNV78266.1 hypothetical protein FGO68_gene9047 [Halteria grandinella]	diamond	450	117	1	Eukaryota	Sar	Ciliophora	Spirotrichea	Sporadotrichida	Halteriidae	Halteria	Halteria grandinella
27229920	27229920	PRJNA1158727_P_NODE_154443_length_244_cov_0.900585_g146981_i0	PRJNA1158727	154443	244	0.900585	2.1974274	Pseudocohnilembus persalinus	266149	SAR_Eukaryotes	SAR_Eukaryotes	65.1	5.12e-11	NR	KRW99836.1	266149	g146981	i0	44.9	11.0040983606557	78	41	93.4	2	9	236	23	100	KRW99836.1 hypothetical protein PPERSA_10955 [Pseudocohnilembus persalinus]	diamond	2685	65.1	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Philasterida	Pseudocohnilembidae	Pseudocohnilembus	Pseudocohnilembus persalinus
27324872	27324872	PRJNA1158727_P_NODE_158623_length_242_cov_2.289941_g151161_i0	PRJNA1158727	158623	242	2.289941	5.54165722	Paramecium sonneborni	65129	SAR_Eukaryotes	SAR_Eukaryotes	83.6	1.48e-16	NR	CAD8048029.1	65129	g151161	i0	46.3	4.94628099173554	80	43	99.2	0	242	3	255	334	CAD8048029.1 unnamed protein product [Paramecium sonneborni]	diamond	1197	83.6	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Peniculida	Parameciidae	Paramecium	Paramecium sonneborni
28796422	28796422	PRJNA1158727_P_NODE_159807_length_242_cov_0.911243_g152345_i0	PRJNA1158727	159807	242	0.911243	2.20520806	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	74.3	1.55e-14	NR	XP_004039581.1	5932	g152345	i0	50	3.63223140495868	78	38	95.5	1	232	2	7	84	XP_004039581.1 transcription factor btf3, putative [Ichthyophthirius multifiliis]	diamond	879	74.3	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Hymenostomatida		Ichthyophthirius	Ichthyophthirius multifiliis
31070900	31070900	PRJNA1158727_P_NODE_129815_length_256_cov_1.683060_g122354_i0	PRJNA1158727	129815	256	1.68306	4.3086336	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	109	8.38e-27	NR	CAD8147233.1	43137	g122354	i0	65.5	13.65234375	84	28	97.3	1	3	251	213	296	CAD8147233.1 unnamed protein product [Paramecium octaurelia]	diamond	3495	109	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Peniculida	Parameciidae	Paramecium	Paramecium octaurelia
32082760	32082760	PRJNA1158727_P_NODE_146778_length_247_cov_0.885057_g139316_i0	PRJNA1158727	146778	247	0.885057	2.18609079	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	46.6	0.00173	NR	KAL4454048.1	5901	g139316	i0	37.8	2.72064777327935	82	42	88.7	3	227	9	1351	1432	KAL4454048.1 hypothetical protein ABPG73_009847 [Tetrahymena malaccensis]	diamond	672	46.6	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Hymenostomatida	Tetrahymenidae	Tetrahymena	Tetrahymena malaccensis
32569962	32569962	PRJNA1158727_P_NODE_121559_length_265_cov_2.161458_g114098_i0	PRJNA1158727	121559	265	2.161458	5.7278637	Tetrahymena thermophila SB21	5911	SAR_Eukaryotes	SAR_Eukaryotes	143	5.7e-39	NR	XP_001008438.1	312017	g114098	i0	69.3	0.99622641509434	88	27	99.6	0	264	1	124	211	XP_001008438.1 papain family cysteine protease [Tetrahymena thermophila SB210]	diamond	264	143	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Hymenostomatida	Tetrahymenidae	Tetrahymena	Tetrahymena thermophila
32758608	32758608	PRJNA1158727_P_NODE_151380_length_245_cov_0.895349_g143918_i0	PRJNA1158727	151380	245	0.895349	2.19360505	Stylonychia lemnae	5949	SAR_Eukaryotes	SAR_Eukaryotes	145	3.88e-38	NR	CDW71243.1	5949	g143918	i0	100	0.83265306122449	68	0	83.3	0	5	208	71	138	CDW71243.1 iq and aaa domain-containing protein 1 [Stylonychia lemnae]	diamond	204	145	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);;