metadata: contig_metadata: 13 rows where analysis = "blastn", bioproject = "PRJNA770826" and tax

13 rows where analysis = "blastn", bioproject = "PRJNA770826" 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
2482131	2482131	PRJNA770826_P_NODE_6942_length_314_cov_1.920755_g6771_i0	PRJNA770826	6942	314	1.920755	6.0311707	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	54.7	0.008	NTclustered	gi\|915131143\|ref\|XM_013480025.1\|	5804	g6771	i0	100	1.54140127388535	29	0	9	0	116	144	2636	2664	Eimeria maxima hypothetical protein, conserved partial mRNA	blastn	484	54.7	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Eimeriidae	Eimeria	Eimeria maxima
3758469	3758469	PRJNA770826_P_NODE_3703_length_448_cov_2.213033_g3532_i0	PRJNA770826	3703	448	2.213033	9.91438784	Toxoplasma	5810	SAR_Eukaryotes	SAR_Eukaryotes	193	2.45e-44	NTclustered	gi\|260323800\|dbj\|AK318085.1\|	5811	g3532	i0	84	6.125	200	32	45	0	235	434	482	283	Toxoplasma gondii cDNA, clone: XTG04568.2, full cDNA, XTG Sugano cDNA library	blastn	2744	193	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Sarcocystidae	Toxoplasma	Toxoplasma gondii
5850381	5850381	PRJNA770826_P_NODE_16985_length_196_cov_1.414966_g16814_i0	PRJNA770826	16985	196	1.414966	2.77333336	Cryptosporidium parvum	5807	SAR_Eukaryotes	SAR_Eukaryotes	156	1.26e-33	NTclustered	gi\|66357071\|ref\|XM_625714.1\|	353152	g16814	i0	82.222	6.37244897959184	180	32	92	0	15	194	792	613	Cryptosporidium parvum Iowa II 26S proteasome regulatory subunit S4 like AAA ATpase (cgd4_1170) partial mRNA	blastn	1249	156	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Cryptosporidiidae	Cryptosporidium	Cryptosporidium parvum
7125567	7125567	PRJNA770826_P_NODE_15686_length_204_cov_1.341935_g15515_i0	PRJNA770826	15686	204	1.341935	2.7375474	Plasmodium yoelii	5861	SAR_Eukaryotes	SAR_Eukaryotes	150	6.129999999999999e-32	NTclustered	gi\|82596320\|ref\|XM_721120.1\|	5861	g15515	i0	85.915	10.4509803921569	142	19	69	1	39	179	201	342	Plasmodium yoelii tubulin subunit beta (PY17X_1210100), partial mRNA	blastn	2132	150	1	Eukaryota	Sar	Apicomplexa	Aconoidasida	Haemosporida	Plasmodiidae	Plasmodium	Plasmodium yoelii
8400068	8400068	PRJNA770826_P_NODE_18047_length_191_cov_0.992958_g17876_i0	PRJNA770826	18047	191	0.992958	1.89654978	Cyclospora cayetanensis	88456	SAR_Eukaryotes	SAR_Eukaryotes	60.2	9.82e-5	NTclustered	gi\|1472910765\|ref\|XM_022731850.2\|	88456	g17876	i0	94.872	0.408376963350785	39	1	20	1	120	157	70	108	PREDICTED: Cyclospora cayetanensis ATP synthase subunit gamma, mitochondrial (LOC34618524), mRNA	blastn	78	60.2	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Eimeriidae	Cyclospora	Cyclospora cayetanensis
8400153	8400153	PRJNA770826_P_NODE_39967_length_163_cov_0.912281_g39796_i0	PRJNA770826	39967	163	0.912281	1.48701803	Plasmodium sp. gorilla clade G2	880535	SAR_Eukaryotes	SAR_Eukaryotes	111	2.21e-20	NTclustered	gi\|1620167104\|ref\|XM_028681483.1\|	880535	g39796	i0	83.077	27.1165644171779	130	15	77	7	38	162	413	540	Plasmodium sp. gorilla clade G2 superoxide dismutase [Fe] (PADL01_0814000), partial mRNA	blastn	4420	111	1	Eukaryota	Sar	Apicomplexa	Aconoidasida	Haemosporida	Plasmodiidae	Plasmodium	Plasmodium sp. gorilla clade G2
12686354	12686354	PRJNA770826_P_NODE_6370_length_331_cov_1.524823_g6199_i0	PRJNA770826	6370	331	1.524823	5.04716413	root	1	Root_unresolved	Root_unresolved	56.5	0.002	NTclustered	gi\|457877692\|ref\|XM_004225016.1\|	1120755	g6199	i0	100	0.365558912386707	30	0	9	0	214	243	3944	3915	Plasmodium cynomolgi strain B WD domain G-beta repeat domain containing protein (PCYB_145450) mRNA, complete cds	blastn	121	56.5	1	Eukaryota	Sar	Apicomplexa	Aconoidasida	Haemosporida	Plasmodiidae	Plasmodium	Plasmodium cynomolgi
17325163	17325163	PRJNA770826_P_NODE_13814_length_217_cov_0.928571_g13643_i0	PRJNA770826	13814	217	0.928571	2.01499907	Besnoitia besnoiti	94643	SAR_Eukaryotes	SAR_Eukaryotes	207	3.87e-49	NTclustered	gi\|1673121360\|ref\|XM_029366660.1\|	94643	g13643	i0	83.871	98.36866359447	217	35	100	0	1	217	376	160	Besnoitia besnoiti ribosomal protein RPS23 (BESB_083100), partial mRNA	blastn	21346	207	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Sarcocystidae	Besnoitia	Besnoitia besnoiti
18598687	18598687	PRJNA770826_P_NODE_36115_length_164_cov_1.808696_g35944_i0	PRJNA770826	36115	164	1.808696	2.96626144	Plasmodium chabaudi	5825	SAR_Eukaryotes	SAR_Eukaryotes	111	2.23e-20	NTclustered	gi\|1027949014\|ref\|XM_016799907.1\|	31271	g35944	i0	84.211	1.39024390243902	114	18	70	0	42	155	2289	2176	Plasmodium chabaudi chabaudi DNA-directed RNA polymerase II subunit RPB2, putative (PCHAS_0314500), partial mRNA	blastn	228	111	1	Eukaryota	Sar	Apicomplexa	Aconoidasida	Haemosporida	Plasmodiidae	Plasmodium	Plasmodium chabaudi
19873730	19873730	PRJNA770826_P_NODE_4816_length_390_cov_1.554252_g4645_i0	PRJNA770826	4816	390	1.554252	6.0615828	Cyclospora cayetanensis	88456	SAR_Eukaryotes	SAR_Eukaryotes	137	1e-27	NTclustered	gi\|1472918886\|ref\|XR_003297360.1\|	88456	g4645	i0	81.143	10.4205128205128	175	29	45	4	201	374	930	759	PREDICTED: Cyclospora cayetanensis large subunit ribosomal RNA (LOC113146729), rRNA	blastn	4064	137	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Eimeriidae	Cyclospora	Cyclospora cayetanensis
20333157	20333157	PRJNA770826_P_NODE_6956_length_314_cov_1.494340_g6785_i0	PRJNA770826	6956	314	1.49434	4.6922276	Cryptosporidium	5806	SAR_Eukaryotes	SAR_Eukaryotes	204	7.66e-48	NTclustered	gi\|2785775084\|ref\|XM_067210558.1\|	117008	g6785	i0	83.258	23.296178343949	221	37	70	0	4	224	282	62	Cryptosporidium andersoni ADP ribosylation factor (cand_003110), partial mRNA	blastn	7315	204	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Cryptosporidiidae	Cryptosporidium	Cryptosporidium andersoni
22424205	22424205	PRJNA770826_P_NODE_27978_length_167_cov_1.762712_g27807_i0	PRJNA770826	27978	167	1.762712	2.94372904	Besnoitia besnoiti	94643	SAR_Eukaryotes	SAR_Eukaryotes	159	8.02e-35	NTclustered	gi\|1673125320\|ref\|XM_029365497.1\|	94643	g27807	i0	83.929	38.2455089820359	168	25	100	2	1	167	355	189	Besnoitia besnoiti ribosomal protein RPL11 (BESB_071240), partial mRNA	blastn	6387	159	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Sarcocystidae	Besnoitia	Besnoitia besnoiti
23699809	23699809	PRJNA770826_P_NODE_16039_length_202_cov_1.274510_g15868_i0	PRJNA770826	16039	202	1.27451	2.5745102	Cryptosporidium sp.	90962	SAR_Eukaryotes	SAR_Eukaryotes	224	3.52e-54	NTclustered	gi\|1444394105\|gb\|MH553333.1\|	90962	g15868	i0	86.634	82.7722772277228	202	27	100	0	1	202	73	274	Cryptosporidium sp. isolate OP19 clone actC actin gene, partial cds	blastn	16720	224	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Cryptosporidiidae	Cryptosporidium	Cryptosporidium sp.

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