metadata: contig_metadata: 10 rows where analysis = "diamond", bioproject = "PRJNA922890" and tax

10 rows where analysis = "diamond", bioproject = "PRJNA922890" and tax_phylum = "Apicomplexa"

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
27150642	27150642	PRJNA922890_P_NODE_75242_length_232_cov_0.895706_g74832_i0	PRJNA922890	75242	232	0.895706	2.07803792	Theileria equi strain WA	1537102	SAR_Eukaryotes	SAR_Eukaryotes	153	3.43e-41	NR	XP_004832121.1	1537102	g74832	i0	96.1	0.995689655172414	77	3	99.6	0	1	231	337	413	XP_004832121.1 cell division cycle protein 48, putative [Theileria equi strain WA]	diamond	231	153	1	Eukaryota	Sar	Apicomplexa	Aconoidasida	Piroplasmida	Theileriidae	Theileria	Theileria equi
27182509	27182509	PRJNA922890_P_NODE_33522_length_331_cov_1.393130_g33112_i0	PRJNA922890	33522	331	1.39313	4.6112603	Theileria equi strain WA	1537102	SAR_Eukaryotes	SAR_Eukaryotes	118	6.47e-30	NR	XP_004830243.1	1537102	g33112	i0	52.8	3.92447129909366	106	50	96.1	0	10	327	99	204	XP_004830243.1 equi merozoite antigen 3 [Theileria equi strain WA]	diamond	1299	118	1	Eukaryota	Sar	Apicomplexa	Aconoidasida	Piroplasmida	Theileriidae	Theileria	Theileria equi
27404074	27404074	PRJNA922890_P_NODE_34823_length_326_cov_0.871595_g34413_i0	PRJNA922890	34823	326	0.871595	2.8413997	Theileria equi	5872	SAR_Eukaryotes	SAR_Eukaryotes	103	1.62e-24	NR	BAA32987.1	5872	g34413	i0	53.8	0.855828220858896	93	43	85.6	0	46	324	1	93	BAA32987.1 merozoite antigen [Theileria equi]	diamond	279	103	1	Eukaryota	Sar	Apicomplexa	Aconoidasida	Piroplasmida	Theileriidae	Theileria	Theileria equi
27404077	27404077	PRJNA922890_P_NODE_71243_length_234_cov_0.884848_g70833_i0	PRJNA922890	71243	234	0.884848	2.07054432	Theileria equi strain WA	1537102	SAR_Eukaryotes	SAR_Eukaryotes	159	2.32e-44	NR	XP_004829015.1	1537102	g70833	i0	98.7	0.987179487179487	77	1	98.7	0	232	2	143	219	XP_004829015.1 hypothetical protein BEWA_021970 [Theileria equi strain WA]	diamond	231	159	1	Eukaryota	Sar	Apicomplexa	Aconoidasida	Piroplasmida	Theileriidae	Theileria	Theileria equi
30624876	30624876	PRJNA922890_P_NODE_39813_length_307_cov_1.134454_g39403_i0	PRJNA922890	39813	307	1.134454	3.48277378	Theileria equi strain WA	1537102	SAR_Eukaryotes	SAR_Eukaryotes	47.8	4.55e-4	NR	XP_004832670.1	1537102	g39403	i0	73	0.361563517915309	37	10	36.2	0	42	152	1	37	XP_004832670.1 signal peptide containing protein [Theileria equi strain WA]	diamond	111	47.8	1	Eukaryota	Sar	Apicomplexa	Aconoidasida	Piroplasmida	Theileriidae	Theileria	Theileria equi
31004224	31004224	PRJNA922890_P_NODE_32094_length_338_cov_1.174721_g31684_i0	PRJNA922890	32094	338	1.174721	3.97055698	Theileria equi strain WA	1537102	SAR_Eukaryotes	SAR_Eukaryotes	53.5	1.75e-5	NR	XP_004830611.1	1537102	g31684	i0	31.3	0.994082840236686	112	62	86.1	1	43	333	317	428	XP_004830611.1 hypothetical protein BEWA_003530 [Theileria equi strain WA]	diamond	336	53.5	1	Eukaryota	Sar	Apicomplexa	Aconoidasida	Piroplasmida	Theileriidae	Theileria	Theileria equi
32111111	32111111	PRJNA922890_P_NODE_46258_length_287_cov_0.779817_g45848_i0	PRJNA922890	46258	287	0.779817	2.23807479	Theileria equi strain WA	1537102	SAR_Eukaryotes	SAR_Eukaryotes	94.4	3.16e-20	NR	XP_004832412.1	1537102	g45848	i0	74.6	0.700348432055749	67	16	69	1	198	1	1	67	XP_004832412.1 cysteine protease [Theileria equi strain WA]	diamond	201	94.4	1	Eukaryota	Sar	Apicomplexa	Aconoidasida	Piroplasmida	Theileriidae	Theileria	Theileria equi
32174547	32174547	PRJNA922890_P_NODE_76978_length_231_cov_0.901235_g76568_i0	PRJNA922890	76978	231	0.901235	2.08185285	Theileria equi strain WA	1537102	SAR_Eukaryotes	SAR_Eukaryotes	130	1.81e-35	NR	XP_004830960.1	1537102	g76568	i0	71.4	1	77	22	100	0	1	231	95	171	XP_004830960.1 N-acetylglucosaminyl-phosphatidylinositol de-N-acetylase, putative [Theileria equi strain WA]	diamond	231	130	1	Eukaryota	Sar	Apicomplexa	Aconoidasida	Piroplasmida	Theileriidae	Theileria	Theileria equi
32301257	32301257	PRJNA922890_P_NODE_81299_length_229_cov_0.912500_g80889_i0	PRJNA922890	81299	229	0.9125	2.089625	Theileria equi strain WA	1537102	SAR_Eukaryotes	SAR_Eukaryotes	63.2	1.96e-9	NR	XP_004831947.1	1537102	g80889	i0	58.8	0.668122270742358	51	20	65.5	1	3	152	2121	2171	XP_004831947.1 conserved hypothetical protein [Theileria equi strain WA]	diamond	153	63.2	1	Eukaryota	Sar	Apicomplexa	Aconoidasida	Piroplasmida	Theileriidae	Theileria	Theileria equi
32466653	32466653	PRJNA922890_P_NODE_83539_length_228_cov_0.905660_g83129_i0	PRJNA922890	83539	228	0.90566	2.0649048	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	126	2.66e-35	NR	XP_627324.1	353152	g83129	i0	78.4	11.7368421052632	74	16	97.4	0	3	224	15	88	XP_627324.1 40S ribosomal protein S15A, partial [Cryptosporidium parvum Iowa II]	diamond	2676	126	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Cryptosporidiidae	Cryptosporidium	Cryptosporidium parvum

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