metadata: contig_metadata: 7 rows where analysis = "diamond", bioproject = "PRJNA725806" and tax

7 rows where analysis = "diamond", bioproject = "PRJNA725806" 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
26735343	26735343	PRJNA725806_P_NODE_8861_length_386_cov_5.452722_g8576_i0	PRJNA725806	8861	386	5.452722	21.04750692	Paramecium sonneborni	65129	SAR_Eukaryotes	SAR_Eukaryotes	44.7	0.0348	NR	CAD8074060.1	65129	g8576	i0	51.4	0.272020725388601	35	17	27.2	0	145	41	124	158	CAD8074060.1 unnamed protein product [Paramecium sonneborni]	diamond	105	44.7	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Peniculida	Parameciidae	Paramecium	Paramecium sonneborni
28347134	28347134	PRJNA725806_P_NODE_27946_length_292_cov_4.623529_g27649_i0	PRJNA725806	27946	292	4.6235290000000004	13.50070468	Halteria grandinella	5974	SAR_Eukaryotes	SAR_Eukaryotes	43.9	0.0235	NR	YP_010049591.1	5974	g27649	i0	38.5	0.667808219178082	65	36	62.7	2	222	40	54	118	YP_010049591.1 hypothetical protein J6764_mgp19 [Halteria grandinella]	diamond	195	43.9	1	Eukaryota	Sar	Ciliophora	Spirotrichea	Sporadotrichida	Halteriidae	Halteria	Halteria grandinella
28452363	28452363	PRJNA725806_P_NODE_162806_length_163_cov_1.515873_g162504_i0	PRJNA725806	162806	163	1.515873	2.47087299	Ciliophora	5878	SAR_Eukaryotes	SAR_Eukaryotes	70.1	2.74e-12	NR	XP_004040044.1	5932	g162504	i0	68.1	2.55828220858896	47	15	86.5	0	158	18	792	838	XP_004040044.1 valyl-tRNA synthetase, putative [Ichthyophthirius multifiliis]	diamond	417	70.1	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Hymenostomatida		Ichthyophthirius	Ichthyophthirius multifiliis
28504997	28504997	PRJNA725806_P_NODE_57807_length_237_cov_10.645000_g57510_i0	PRJNA725806	57807	237	10.645	25.22865	Stylonychia lemnae	5949	SAR_Eukaryotes	SAR_Eukaryotes	45.1	0.00536	NR	CDW87724.1	5949	g57510	i0	36.4	0.69620253164557	55	35	69.6	0	191	27	501	555	CDW87724.1 abc transporter family protein [Stylonychia lemnae]	diamond	165	45.1	1	Eukaryota	Sar	Ciliophora	Spirotrichea	Sporadotrichida	Oxytrichidae	Stylonychia	Stylonychia lemnae
29957434	29957434	PRJNA725806_P_NODE_154191_length_167_cov_1.146154_g153889_i0	PRJNA725806	154191	167	1.146154	1.91407718	Blepharisma stoltei	1481888	SAR_Eukaryotes	SAR_Eukaryotes	50.1	3.49e-5	NR	CAG9331923.1	1481888	g153889	i0	40.4	0.844311377245509	47	28	84.4	0	163	23	423	469	CAG9331923.1 unnamed protein product [Blepharisma stoltei]	diamond	141	50.1	1	Eukaryota	Sar	Ciliophora	Heterotrichea	Heterotrichida	Blepharismidae	Blepharisma	Blepharisma stoltei
30062455	30062455	PRJNA725806_P_NODE_29231_length_289_cov_1.980159_g28934_i0	PRJNA725806	29231	289	1.980159	5.72265951	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	48.5	6.28e-4	NR	CDW75723.1	5949	g28934	i0	47.5	3.25951557093426	59	29	61.2	1	95	271	491	547	CDW75723.1 UNKNOWN [Stylonychia lemnae]	diamond	942	48.9	0.991820040899796	Eukaryota	Sar	Ciliophora	Spirotrichea	Sporadotrichida	Oxytrichidae	Stylonychia	Stylonychia lemnae
32613016	32613016	PRJNA725806_P_NODE_124320_length_182_cov_1.062069_g124018_i0	PRJNA725806	124320	182	1.062069	1.93296558	Stentor coeruleus	5963	SAR_Eukaryotes	SAR_Eukaryotes	68.2	1.49e-11	NR	OMJ79734.1	5963	g124018	i0	49.2	1.03846153846154	63	29	98.9	1	1	180	42	104	OMJ79734.1 hypothetical protein SteCoe_20161 [Stentor coeruleus]	diamond	189	68.2	1	Eukaryota	Sar	Ciliophora	Heterotrichea	Heterotrichida	Stentoridae	Stentor	Stentor coeruleus

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