metadata: contig_metadata: 11 rows where bioproject = "PRJNA946307" and tax

11 rows where bioproject = "PRJNA946307" 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
1260398	1260398	PRJNA946307_P_NODE_27321_length_247_cov_2.631313_g26447_i0	PRJNA946307	27321	247	2.631313	6.49934311	root	1	Root_unresolved	Root_unresolved	390	4.1699999999999997e-104	NTclustered	gi\|833494852\|ref\|XM_012915026.1\|	5866	g26447	i0	98.636	116.838056680162	220	3	89	0	15	234	265	46	Babesia bigemina hypothetical protein, conserved partial mRNA	blastn	28859	390	1	Eukaryota	Sar	Apicomplexa	Aconoidasida	Piroplasmida	Babesiidae	Babesia	Babesia bigemina
5088205	5088205	PRJNA946307_P_NODE_125624_length_172_cov_6.902439_g124750_i0	PRJNA946307	125624	172	6.902439	11.87219508	Eimeria	5800	SAR_Eukaryotes	SAR_Eukaryotes	84.2	5.12e-12	NTclustered	gi\|349663672\|gb\|JN181057.1\|	637837	g124750	i0	97.917	0.819767441860465	48	1	28	0	66	113	396	349	Eimeria trichosuri strain Marco 23S ribosomal RNA gene, partial sequence; plastid	blastn	141	84.2	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Eimeriidae	Eimeria	Eimeria trichosuri
5089290	5089290	PRJNA946307_P_NODE_9304_length_446_cov_3.853904_g8466_i0	PRJNA946307	9304	446	3.853904	17.18841184	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	60.2	2.58e-4	NTclustered	gi\|915002776\|ref\|XM_013393443.1\|	5801	g8466	i0	94.872	7.47085201793722	39	1	9	1	118	155	11084	11046	Eimeria acervulina UBA/TS-N domain-containing protein, putative partial mRNA	blastn	3332	60.2	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Eimeriidae	Eimeria	Eimeria acervulina
11464563	11464563	PRJNA946307_P_NODE_65649_length_200_cov_1.311258_g64775_i0	PRJNA946307	65649	200	1.311258	2.622516	Eimeriidae	5799	SAR_Eukaryotes	SAR_Eukaryotes	87.9	4.76e-13	NTclustered	gi\|324022087\|gb\|GU593704.1\|	947528	g64775	i0	100	22.445	47	0	24	0	15	61	2000	2046	Eimeria anguillae strain 128 28S ribosomal RNA gene, partial sequence	blastn	4489	87.9	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Eimeriidae	Eimeria	Eimeria anguillae
17837281	17837281	PRJNA946307_P_NODE_117854_length_176_cov_1.590551_g116980_i0	PRJNA946307	117854	176	1.590551	2.79936976	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	292	8.04e-75	NTclustered	gi\|2866450391\|gb\|PQ722880.1\|	35084	g116980	i0	99.379	91.5056818181818	161	1	91	0	2	162	1525	1365	Babesia sp. isolate YN-4 WX-T-162 small subunit ribosomal RNA gene, partial sequence	blastn	16105	292	1	Eukaryota	Sar	Apicomplexa	Aconoidasida	Piroplasmida	Babesiidae	Babesia	Babesia sp.
20387012	20387012	PRJNA946307_P_NODE_57816_length_210_cov_2.652174_g56942_i0	PRJNA946307	57816	210	2.652174	5.5695654	Plasmodium	5820	SAR_Eukaryotes	SAR_Eukaryotes	56.5	0.001	NTclustered	gi\|1084887524\|ref\|XM_018786797.1\|	647221	g56942	i0	100	6.10952380952381	30	0	14	0	71	100	1516	1545	Plasmodium gaboni putative membrane protein partial mRNA	blastn	1283	56.5	1	Eukaryota	Sar	Apicomplexa	Aconoidasida	Haemosporida	Plasmodiidae	Plasmodium	Plasmodium gaboni
21329422	21329422	PRJNA946307_P_NODE_44377_length_211_cov_1.975309_g43503_i0	PRJNA946307	44377	211	1.975309	4.16790199	Eimeria necatrix	51315	SAR_Eukaryotes	SAR_Eukaryotes	379	7.489999999999999e-101	NTclustered	gi\|921123462\|ref\|XM_013580892.1\|	51315	g43503	i0	99.519	168.611374407583	208	1	99	0	3	210	360	153	Eimeria necatrix hypothetical protein partial mRNA	blastn	35577	379	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Eimeriidae	Eimeria	Eimeria necatrix
22937582	22937582	PRJNA946307_P_NODE_116918_length_176_cov_3.409449_g116044_i0	PRJNA946307	116918	176	3.409449	6.00063024	Apicomplexa	5794	SAR_Eukaryotes	SAR_Eukaryotes	75	3.17e-9	NTclustered	gi\|1272609464\|gb\|KY882319.1\|	83999	g116044	i0	97.674	23.5511363636364	43	1	24	0	1	43	387	345	Cryptosporidium serpentis isolate HR226 28S ribosomal RNA gene, partial sequence	blastn	4145	75	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Cryptosporidiidae	Cryptosporidium	Cryptosporidium serpentis
24212040	24212040	PRJNA946307_P_NODE_25659_length_254_cov_3.375610_g24785_i0	PRJNA946307	25659	254	3.37561	8.5740494	Eimeria	5800	SAR_Eukaryotes	SAR_Eukaryotes	52.8	0.023	NTclustered	gi\|915142304\|ref\|XM_013482287.1\|	5804	g24785	i0	100	0.220472440944882	28	0	11	0	41	68	433	460	Eimeria maxima hypothetical protein, conserved partial mRNA	blastn	56	52.8	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Eimeriidae	Eimeria	Eimeria maxima
29053373	29053373	PRJNA946307_P_NODE_66768_length_199_cov_4.706667_g65894_i0	PRJNA946307	66768	199	4.706667	9.36626733	Plasmodium	5820	SAR_Eukaryotes	SAR_Eukaryotes	44.7	0.0042	NR	WBY57322.1	73239	g65894	i0	64.5	1.40201005025126	31	11	46.7	0	94	2	82	112	WBY57322.1 bifunctional farnesyl/geranylgeranyl diphosphate synthase [Plasmodium yoelii yoelii]	diamond	279	44.7	1	Eukaryota	Sar	Apicomplexa	Aconoidasida	Haemosporida	Plasmodiidae	Plasmodium	Plasmodium yoelii
31738646	31738646	PRJNA946307_P_NODE_111437_length_179_cov_1.492308_g110563_i0	PRJNA946307	111437	179	1.492308	2.67123132	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	73.9	1.89e-14	NR	BAN66151.1	5865	g110563	i0	65.5	13.4748603351955	58	19	95.5	1	171	1	6	63	BAN66151.1 40S ribosomal protein S8 [Babesia bovis]	diamond	2412	73.9	1	Eukaryota	Sar	Apicomplexa	Aconoidasida	Piroplasmida	Babesiidae	Babesia	Babesia bovis

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