metadata: contig_metadata: 5 rows where bioproject = "PRJNA1074408", tax_clade = "Sar" and tax

5 rows where bioproject = "PRJNA1074408", tax_clade = "Sar" 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
10394285	10394285	PRJNA1074408_S_NODE_6789_length_179_cov_1.595588_g6659_i0	PRJNA1074408	6789	179	1.595588	2.85610252	Goussia carpelli	947543	SAR_Eukaryotes	SAR_Eukaryotes	259	8.32e-65	NTclustered	gi\|324022099\|gb\|GU593716.1\|	947543	g6659	i0	92.818	100.111731843575	181	10	100	3	1	179	441	620	Goussia carpelli strain 23 28S ribosomal RNA gene, partial sequence	blastn	17920	259	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Eimeriidae	Goussia	Goussia carpelli
15044191	15044191	PRJNA1074408_S_NODE_9752_length_152_cov_0.880734_g9622_i0	PRJNA1074408	9752	152	0.880734	1.33871568	root	1	Root_unresolved	Root_unresolved	268	1.13e-67	NTclustered	gi\|833494852\|ref\|XM_012915026.1\|	5866	g9622	i0	98.684	101.473684210526	152	1	100	1	1	152	239	89	Babesia bigemina hypothetical protein, conserved partial mRNA	blastn	15424	268	1	Eukaryota	Sar	Apicomplexa	Aconoidasida	Piroplasmida	Babesiidae	Babesia	Babesia bigemina
19316655	19316655	PRJNA1074408_S_NODE_2116_length_313_cov_3.514815_g1986_i0	PRJNA1074408	2116	313	3.514815	11.00137095	Goussia sp. BMR-2011c	980545	SAR_Eukaryotes	SAR_Eukaryotes	545	1.1e-150	NTclustered	gi\|328460764\|gb\|GU479639.1\|	980545	g1986	i0	98.083	101.680511182109	313	6	100	0	1	313	38	350	Goussia sp. BMR-2011c isolate GCAR812-#812 18S ribosomal RNA gene, partial sequence	blastn	31826	545	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Eimeriidae	Goussia	Goussia sp. BMR-2011c
21418576	21418576	PRJNA1074408_S_NODE_1757_length_342_cov_5.137124_g1627_i0	PRJNA1074408	1757	342	5.137124	17.56896408	Goussia	169155	SAR_Eukaryotes	SAR_Eukaryotes	414	3.58e-111	NTclustered	gi\|328460778\|gb\|GU479653.1\|	947544	g1627	i0	88.793	79.0233918128655	348	24	98	10	7	342	406	750	Goussia chalupskyi isolate LEC123-#123 18S ribosomal RNA gene, partial sequence	blastn	27026	414	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Eimeriidae	Goussia	Goussia chalupskyi
30415356	30415356	PRJNA1074408_S_NODE_5173_length_203_cov_1.912500_g5043_i0	PRJNA1074408	5173	203	1.9125	3.882375	Plasmodium malariae	5858	SAR_Eukaryotes	SAR_Eukaryotes	42.7	0.0229	NR	XP_028860088.1	5858	g5043	i0	45.5	1.30049261083744	44	22	65	1	163	32	719	760	XP_028860088.1 conserved Plasmodium protein, unknown function [Plasmodium malariae]	diamond	264	42.7	1	Eukaryota	Sar	Apicomplexa	Aconoidasida	Haemosporida	Plasmodiidae	Plasmodium	Plasmodium malariae

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