metadata: contig_metadata: 8 rows where bioproject = "PRJDB4941", tax_clade = "Sar" and tax

8 rows where bioproject = "PRJDB4941", 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
26747220	26747220	PRJDB4941_P_NODE_5941_length_527_cov_2.125523_g5174_i0	PRJDB4941	5941	527	2.125523	11.20150621	Paramecium octaurelia	43137	SAR_Eukaryotes	SAR_Eukaryotes	71.2	2.46e-11	NR	CAD8154896.1	43137	g5174	i0	36.1	0.69449715370019	122	70	67.2	3	80	433	131	248	CAD8154896.1 unnamed protein product [Paramecium octaurelia]	diamond	366	71.2	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Peniculida	Parameciidae	Paramecium	Paramecium octaurelia
29653186	29653186	PRJDB4941_P_NODE_34850_length_168_cov_1.445378_g34082_i0	PRJDB4941	34850	168	1.445378	2.42823504	Ichthyophthirius multifiliis	5932	SAR_Eukaryotes	SAR_Eukaryotes	49.3	6.33e-5	NR	XP_004023887.1	5932	g34082	i0	54.8	0.75	42	18	75	1	160	35	76	116	XP_004023887.1 leucine carboxyl methyltransferase family protein, putative [Ichthyophthirius multifiliis]	diamond	126	49.3	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Hymenostomatida		Ichthyophthirius	Ichthyophthirius multifiliis
29747952	29747952	PRJDB4941_P_NODE_14031_length_286_cov_1.890295_g13263_i0	PRJDB4941	14031	286	1.890295	5.4062437	Tetrahymena thermophila SB21	5911	SAR_Eukaryotes	SAR_Eukaryotes	62.4	6.47e-9	NR	XP_001016059.2	312017	g13263	i0	42.9	0.881118881118881	84	43	85	2	23	265	179	260	XP_001016059.2 phosphatidylinositol N-acetylglucosaminyltransferase subunit C [Tetrahymena thermophila SB210]	diamond	252	62.4	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Hymenostomatida	Tetrahymenidae	Tetrahymena	Tetrahymena thermophila
29906314	29906314	PRJDB4941_P_NODE_33651_length_170_cov_1.289256_g32883_i0	PRJDB4941	33651	170	1.289256	2.1917352	Halteria grandinella	5974	SAR_Eukaryotes	SAR_Eukaryotes	58.5	2.94e-8	NR	TNV76369.1	5974	g32883	i0	65.2	0.811764705882353	46	16	81.2	0	33	170	194	239	TNV76369.1 hypothetical protein FGO68_gene16248 [Halteria grandinella]	diamond	138	58.5	1	Eukaryota	Sar	Ciliophora	Spirotrichea	Sporadotrichida	Halteriidae	Halteria	Halteria grandinella
30411971	30411971	PRJDB4941_P_NODE_13613_length_292_cov_1.469136_g12845_i0	PRJDB4941	13613	292	1.469136	4.28987712	Paramecium sonneborni	65129	SAR_Eukaryotes	SAR_Eukaryotes	45.1	0.01	NR	CAD8086577.1	65129	g12845	i0	41.8	0.565068493150685	55	31	55.5	1	20	181	375	429	CAD8086577.1 unnamed protein product [Paramecium sonneborni]	diamond	165	45.1	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Peniculida	Parameciidae	Paramecium	Paramecium sonneborni
31201117	31201117	PRJDB4941_P_NODE_34555_length_169_cov_0.866667_g33787_i0	PRJDB4941	34555	169	0.866667	1.46466723	Tetrahymena thermophila SB21	5911	SAR_Eukaryotes	SAR_Eukaryotes	82	1.17e-16	NR	XP_001027491.1	312017	g33787	i0	64.3	2.98224852071006	56	20	99.4	0	169	2	244	299	XP_001027491.1 papain family cysteine protease [Tetrahymena thermophila SB210]	diamond	504	82	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Hymenostomatida	Tetrahymenidae	Tetrahymena	Tetrahymena thermophila
31701672	31701672	PRJDB4941_P_NODE_5677_length_545_cov_1.677419_g4912_i0	PRJDB4941	5677	545	1.677419	9.14193355	Tetrahymena	5890	SAR_Eukaryotes	SAR_Eukaryotes	120	8.37e-29	NR	KAL4476538.1	5901	g4912	i0	46.6	2.19633027522936	133	70	72.7	1	397	2	263	395	KAL4476538.1 hypothetical protein ABPG74_010271 [Tetrahymena malaccensis]	diamond	1197	120	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Hymenostomatida	Tetrahymenidae	Tetrahymena	Tetrahymena malaccensis
32055542	32055542	PRJDB4941_P_NODE_36958_length_166_cov_0.888889_g36190_i0	PRJDB4941	36958	166	0.888889	1.47555574	Paramecium tetraurelia	5888	SAR_Eukaryotes	SAR_Eukaryotes	68.2	2.89e-13	NR	XP_001450385.1	5888	g36190	i0	52.7	2.98192771084337	55	26	99.4	0	166	2	22	76	XP_001450385.1 uncharacterized protein GSPATT00017345001 [Paramecium tetraurelia]	diamond	495	68.2	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Peniculida	Parameciidae	Paramecium	Paramecium tetraurelia

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