metadata: contig_metadata: 10 rows where bioproject = "PRJNA559720", tax_clade = "Sar" and tax

10 rows where bioproject = "PRJNA559720", 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
27110369	27110369	PRJNA559720_P_NODE_7302_length_375_cov_1.274834_g7163_i0	PRJNA559720	7302	375	1.274834	4.7806275	Stylonychia lemnae	5949	SAR_Eukaryotes	SAR_Eukaryotes	72.4	3.41e-12	NR	CDW79102.1	5949	g7163	i0	35.4	0.632	79	48	61.6	2	375	145	162	239	CDW79102.1 zinc finger protein zic 3 [Stylonychia lemnae]	diamond	237	72.4	1	Eukaryota	Sar	Ciliophora	Spirotrichea	Sporadotrichida	Oxytrichidae	Stylonychia	Stylonychia lemnae
27440932	27440932	PRJNA559720_P_NODE_14123_length_249_cov_0.875000_g13984_i0	PRJNA559720	14123	249	0.875	2.17875	Paramecium	5884	SAR_Eukaryotes	SAR_Eukaryotes	54.3	2.57e-6	NR	CAD8158837.1	43138	g13984	i0	41.4	1.68674698795181	70	38	81.9	3	204	1	170	238	CAD8158837.1 unnamed protein product [Paramecium pentaurelia]	diamond	420	54.3	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Peniculida	Parameciidae	Paramecium	Paramecium pentaurelia
27503982	27503982	PRJNA559720_P_NODE_7703_length_364_cov_1.058419_g7564_i0	PRJNA559720	7703	364	1.058419	3.85264516	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	197	7.92e-58	NR	CAI2363253.1	5936	g7564	i0	74.8	32.4807692307692	119	29	98.1	1	362	6	314	431	CAI2363253.1 unnamed protein product [Moneuplotes crassus]	diamond	11823	197	1	Eukaryota	Sar	Ciliophora	Spirotrichea	Euplotida	Euplotidae	Moneuplotes	Moneuplotes crassus
29320982	29320982	PRJNA559720_P_NODE_13949_length_250_cov_0.870056_g13810_i0	PRJNA559720	13949	250	0.870056	2.17514	Paramecium tetraurelia	5888	SAR_Eukaryotes	SAR_Eukaryotes	108	1.24e-27	NR	XP_001456156.1	5888	g13810	i0	62.8	0.936	78	29	93.6	0	5	238	6	83	XP_001456156.1 uncharacterized protein GSPATT00021927001 [Paramecium tetraurelia]	diamond	234	108	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Peniculida	Parameciidae	Paramecium	Paramecium tetraurelia
29415645	29415645	PRJNA559720_P_NODE_15469_length_244_cov_0.900585_g15330_i0	PRJNA559720	15469	244	0.900585	2.1974274	Tetrahymena thermophila SB21	5911	SAR_Eukaryotes	SAR_Eukaryotes	118	1.38e-32	NR	XP_001016593.1	312017	g15330	i0	75	2.97540983606557	80	20	98.4	0	240	1	4	83	XP_001016593.1 histone H4 [Tetrahymena thermophila SB210]	diamond	726	118	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Hymenostomatida	Tetrahymenidae	Tetrahymena	Tetrahymena thermophila
30110514	30110514	PRJNA559720_P_NODE_7532_length_369_cov_1.084459_g7393_i0	PRJNA559720	7532	369	1.084459	4.00165371	Paramecium pentaurelia	43138	SAR_Eukaryotes	SAR_Eukaryotes	42.7	0.0392	NR	CAD8145104.1	43138	g7393	i0	33.3	0.536585365853659	66	33	53.7	2	145	342	42	96	CAD8145104.1 unnamed protein product [Paramecium pentaurelia]	diamond	198	42.7	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Peniculida	Parameciidae	Paramecium	Paramecium pentaurelia
30521271	30521271	PRJNA559720_P_NODE_12093_length_272_cov_1.547739_g11954_i0	PRJNA559720	12093	272	1.547739	4.20985008	Ichthyophthirius multifiliis	5932	SAR_Eukaryotes	SAR_Eukaryotes	54.7	3.04e-6	NR	XP_004027304.1	5932	g11954	i0	35.3	0.75	68	44	75	0	251	48	221	288	XP_004027304.1 tho complex 3, putative, partial [Ichthyophthirius multifiliis]	diamond	204	54.7	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Hymenostomatida		Ichthyophthirius	Ichthyophthirius multifiliis
31135304	31135304	PRJNA559720_P_NODE_1775_length_750_cov_2.909897_g1668_i0	PRJNA559720	1775	750	2.909897	21.8242275	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	138	4.44e-33	NR	OMJ95327.1	5963	g1668	i0	40.2	5.112	214	111	84.4	6	2	634	627	826	OMJ95327.1 hypothetical protein SteCoe_1390 [Stentor coeruleus]	diamond	3834	138	1	Eukaryota	Sar	Ciliophora	Heterotrichea	Heterotrichida	Stentoridae	Stentor	Stentor coeruleus
32513745	32513745	PRJNA559720_P_NODE_15699_length_243_cov_0.905882_g15560_i0	PRJNA559720	15699	243	0.905882	2.20129326	Tetrahymena thermophila SB21	5911	SAR_Eukaryotes	SAR_Eukaryotes	105	1.46e-27	NR	XP_001016593.1	312017	g15560	i0	73.1	0.962962962962963	78	19	96.3	1	10	243	4	79	XP_001016593.1 histone H4 [Tetrahymena thermophila SB210]	diamond	234	105	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Hymenostomatida	Tetrahymenidae	Tetrahymena	Tetrahymena thermophila
32891401	32891401	PRJNA559720_P_NODE_9680_length_315_cov_0.954545_g9541_i0	PRJNA559720	9680	315	0.954545	3.00681675	Ichthyophthirius multifiliis	5932	SAR_Eukaryotes	SAR_Eukaryotes	46.2	0.00548	NR	XP_004034918.1	5932	g9541	i0	48.9	0.428571428571429	45	23	42.9	0	135	1	573	617	XP_004034918.1 hypothetical protein IMG5_109710 [Ichthyophthirius multifiliis]	diamond	135	46.2	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Hymenostomatida		Ichthyophthirius	Ichthyophthirius multifiliis

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