metadata: contig_metadata: 10 rows where bioproject = "PRJNA473799" and tax

10 rows where bioproject = "PRJNA473799" 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
8098467	8098467	PRJNA473799_P_NODE_13607_length_296_cov_1.004484_g13333_i0	PRJNA473799	13607	296	1.004484	2.97327264	Cryptosporidium sp. duck-like genotype	1856839	SAR_Eukaryotes	SAR_Eukaryotes	137	7.38e-28	NTclustered	gi\|1272609485\|gb\|KY882340.1\|	1856839	g13333	i0	94.382	32.3310810810811	89	5	30	0	1	89	189	101	Cryptosporidium sp. duck-like genotype isolate UY5645 28S ribosomal RNA gene, partial sequence	blastn	9570	137	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Cryptosporidiidae	Cryptosporidium	Cryptosporidium sp. duck-like genotype
9373390	9373390	PRJNA473799_P_NODE_30728_length_257_cov_2.478261_g30454_i0	PRJNA473799	30728	257	2.478261	6.36913077	Neospora caninum	29176	SAR_Eukaryotes	SAR_Eukaryotes	241	4.65e-59	NTclustered	gi\|820695469\|tpe\|LN714488.1\|	572307	g30454	i0	87.923	1.61089494163424	207	21	80	4	2	206	80544	80340	TPA_asm: Neospora caninum Liverpool, unplaced_1, complete genome	blastn	414	241	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Sarcocystidae	Neospora	Neospora caninum
18297605	18297605	PRJNA473799_P_NODE_57055_length_227_cov_3.064935_g56781_i0	PRJNA473799	57055	227	3.064935	6.95740245	Neospora caninum	29176	SAR_Eukaryotes	SAR_Eukaryotes	281	2.37e-71	NTclustered	gi\|820695469\|tpe\|LN714488.1\|	572307	g56781	i0	89.083	1.99559471365639	229	21	100	4	1	227	80266	80492	TPA_asm: Neospora caninum Liverpool, unplaced_1, complete genome	blastn	453	281	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Sarcocystidae	Neospora	Neospora caninum
26886546	26886546	PRJNA473799_P_NODE_20581_length_277_cov_1.460784_g20307_i0	PRJNA473799	20581	277	1.460784	4.04637168	Plasmodium ovale wallikeri	864142	SAR_Eukaryotes	SAR_Eukaryotes	68.6	4.71e-11	NR	SBT55483.1	864142	g20307	i0	46.4	0.747292418772563	69	37	74.7	0	11	217	40	108	SBT55483.1 STP1 protein [Plasmodium ovale wallikeri]	diamond	207	68.6	1	Eukaryota	Sar	Apicomplexa	Aconoidasida	Haemosporida	Plasmodiidae	Plasmodium	Plasmodium ovale
26918017	26918017	PRJNA473799_P_NODE_27662_length_263_cov_1.573684_g27388_i0	PRJNA473799	27662	263	1.573684	4.13878892	Plasmodium ovale wallikeri	864142	SAR_Eukaryotes	SAR_Eukaryotes	77.4	2.36e-14	NR	SBT55340.1	864142	g27388	i0	49.3	2.42965779467681	75	38	85.6	0	225	1	305	379	SBT55340.1 PIR Superfamily Protein [Plasmodium ovale wallikeri]	diamond	639	77.4	1	Eukaryota	Sar	Apicomplexa	Aconoidasida	Haemosporida	Plasmodiidae	Plasmodium	Plasmodium ovale
27487015	27487015	PRJNA473799_P_NODE_51663_length_242_cov_0.911243_g51389_i0	PRJNA473799	51663	242	0.911243	2.20520806	Plasmodium vivax	5855	SAR_Eukaryotes	SAR_Eukaryotes	46.6	0.00108	NR	CAA63219.1	5855	g51389	i0	56.8	0.855371900826446	44	18	54.5	1	144	13	141	183	CAA63219.1 pva1 [Plasmodium vivax]	diamond	207	46.6	1	Eukaryota	Sar	Apicomplexa	Aconoidasida	Haemosporida	Plasmodiidae	Plasmodium	Plasmodium vivax
28465937	28465937	PRJNA473799_P_NODE_50126_length_243_cov_0.905882_g49852_i0	PRJNA473799	50126	243	0.905882	2.20129326	Besnoitia besnoiti	94643	SAR_Eukaryotes	SAR_Eukaryotes	48.9	1.1e-4	NR	XP_029214941.1	94643	g49852	i0	49	1.25925925925926	51	26	63	0	153	1	3	53	XP_029214941.1 uncharacterized protein BESB_058130 [Besnoitia besnoiti]	diamond	306	48.9	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Sarcocystidae	Besnoitia	Besnoitia besnoiti
29129077	29129077	PRJNA473799_P_NODE_7229_length_410_cov_1.910979_g6956_i0	PRJNA473799	7229	410	1.910979	7.8350139	Plasmodium ovale wallikeri	864142	SAR_Eukaryotes	SAR_Eukaryotes	60.5	1.52e-7	NR	SBT57149.1	864142	g6956	i0	65.9	0.3	41	14	30	0	129	7	972	1012	SBT57149.1 STP1 protein [Plasmodium ovale wallikeri]	diamond	123	60.5	1	Eukaryota	Sar	Apicomplexa	Aconoidasida	Haemosporida	Plasmodiidae	Plasmodium	Plasmodium ovale
30992547	30992547	PRJNA473799_P_NODE_35754_length_251_cov_0.865169_g35480_i0	PRJNA473799	35754	251	0.865169	2.17157419	Babesia bovis T2Bo	484906	SAR_Eukaryotes	SAR_Eukaryotes	97.8	1.75e-21	NR	XP_001609528.1	484906	g35480	i0	64.9	0.884462151394422	74	22	87.3	2	31	249	207	277	XP_001609528.1 DNA gyrase/topoisomerase IV subunit A family protein [Babesia bovis T2Bo]	diamond	222	97.8	1	Eukaryota	Sar	Apicomplexa	Aconoidasida	Piroplasmida	Babesiidae	Babesia	Babesia bovis
32368885	32368885	PRJNA473799_P_NODE_13479_length_296_cov_3.838565_g13205_i0	PRJNA473799	13479	296	3.838565	11.3621524	root	1	Root_unresolved	Root_unresolved	72	2.79e-13	NR	XP_029214941.1	94643	g13205	i0	75.5	6.98310810810811	53	13	53.7	0	52	210	71	123	XP_029214941.1 uncharacterized protein BESB_058130 [Besnoitia besnoiti]	diamond	2067	72	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Sarcocystidae	Besnoitia	Besnoitia besnoiti

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