metadata: contig_metadata: 8 rows where analysis = "diamond", bioproject = "PRJNA1035005" and tax

8 rows where analysis = "diamond", bioproject = "PRJNA1035005" 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
13761266	13761266	PRJNA1035005_P_NODE_5411_length_456_cov_2.454308_g5011_i0	PRJNA1035005	5411	456	2.454308	11.19164448	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	205	1.5799999999999998e-58	NR	KAK1442945.1	33632	g5011	i0	65.3	10.8026315789474	150	52	98.7	0	450	1	258	407	KAK1442945.1 translation elongation factor-related protein [Babesia gibsoni]	diamond	4926	205	1	Eukaryota	Sar	Apicomplexa	Aconoidasida	Piroplasmida	Babesiidae	Babesia	Babesia gibsoni
23120891	23120891	PRJNA1035005_P_NODE_15399_length_321_cov_1.185484_g14993_i0	PRJNA1035005	15399	321	1.185484	3.80540364	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	119	4.16e-30	NR	XP_067916539.1	483139	g14993	i0	65.1	15.3177570093458	83	29	77.6	0	37	285	163	245	XP_067916539.1 rna recognition motif-containing protein, partial [Cystoisospora suis]	diamond	4917	119	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Sarcocystidae	Cystoisospora	Cystoisospora suis
27919526	27919526	PRJNA1035005_P_NODE_12085_length_344_cov_1.151292_g11680_i0	PRJNA1035005	12085	344	1.151292	3.96044448	Gregarina niphandrodes	110365	SAR_Eukaryotes	SAR_Eukaryotes	48.5	4.54e-4	NR	XP_011128624.1	110365	g11680	i0	54.1	0.322674418604651	37	17	32.3	0	6	116	14	50	XP_011128624.1 putative AN1-type zinc finger protein 6 [Gregarina niphandrodes]	diamond	111	48.5	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eugregarinorida	Gregarinidae	Gregarina	Gregarina niphandrodes
30375181	30375181	PRJNA1035005_P_NODE_5552_length_451_cov_1.706349_g5152_i0	PRJNA1035005	5552	451	1.706349	7.69563399	Apicomplexa	5794	SAR_Eukaryotes	SAR_Eukaryotes	206	1.1199999999999999e-60	NR	WBY56824.1	73239	g5152	i0	62.9	18.0731707317073	151	55	99.8	1	2	451	353	503	WBY56824.1 thioredoxin reductase [Plasmodium yoelii yoelii]	diamond	8151	208	0.990384615384615	Eukaryota	Sar	Apicomplexa	Aconoidasida	Haemosporida	Plasmodiidae	Plasmodium	Plasmodium yoelii
31172330	31172330	PRJNA1035005_P_NODE_8915_length_377_cov_1.766447_g8512_i0	PRJNA1035005	8915	377	1.766447	6.65950519	Cyclospora cayetanensis	88456	SAR_Eukaryotes	SAR_Eukaryotes	58.2	5.75e-7	NR	OEH79838.1	88456	g8512	i0	30.5	2.89655172413793	118	81	93.9	1	357	4	54	170	OEH79838.1 tetratricopeptide repeat-containing protein [Cyclospora cayetanensis]	diamond	1092	58.2	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Eimeriidae	Cyclospora	Cyclospora cayetanensis
32248445	32248445	PRJNA1035005_P_NODE_32138_length_280_cov_1.130435_g31732_i0	PRJNA1035005	32138	280	1.130435	3.165218	Toxoplasma gondii ME49	508771	SAR_Eukaryotes	SAR_Eukaryotes	124	4.54e-34	NR	XP_002367420.1	508771	g31732	i0	75.9	2.53928571428571	79	18	83.6	1	234	1	10	88	XP_002367420.1 translation initiation factor eIF-5A, putative [Toxoplasma gondii ME49]	diamond	711	124	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Sarcocystidae	Toxoplasma	Toxoplasma gondii
32398434	32398434	PRJNA1035005_P_NODE_31339_length_281_cov_1.125000_g30933_i0	PRJNA1035005	31339	281	1.125	3.16125	Toxoplasma	5810	SAR_Eukaryotes	SAR_Eukaryotes	132	1.09e-35	NR	5XXB_N	5811	g30933	i0	72	1.7508896797153	82	23	87.5	0	34	279	66	147	5XXB_N Chain N, Ribosomal protein uL13 [Toxoplasma gondii]	diamond	492	132	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Sarcocystidae	Toxoplasma	Toxoplasma gondii
32879341	32879341	PRJNA1035005_P_NODE_68140_length_248_cov_0.891429_g67734_i0	PRJNA1035005	68140	248	0.891429	2.21074392	Cyclospora cayetanensis	88456	SAR_Eukaryotes	SAR_Eukaryotes	54.7	1.67e-6	NR	XP_022588443.2	88456	g67734	i0	43.8	2.37096774193548	73	38	84.7	1	35	244	14	86	XP_022588443.2 proteasome subunit beta type-6 [Cyclospora cayetanensis]	diamond	588	54.7	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Eimeriidae	Cyclospora	Cyclospora cayetanensis

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