metadata: contig_metadata: 4 rows where bioproject = "PRJNA888821" and tax

4 rows where bioproject = "PRJNA888821" 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
8515747	8515747	PRJNA888821_P_NODE_3267_length_381_cov_6.798701_g3186_i0	PRJNA888821	3267	381	6.798701	25.90305081	Gregarina sp. Phaedon/Daegwallyeong/2010	1049247	SAR_Eukaryotes	SAR_Eukaryotes	222	2.62e-53	NTclustered	gi\|339715944\|gb\|JF412715.1\|	1049247	g3186	i0	85.915	114.902887139108	213	24	87	4	1	210	4500	4291	Gregarina sp. Phaedon/Daegwallyeong/2010 18S ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, and 28S ribosomal RNA gene, complete sequence; and 28S-18S intergenic spacer, partial sequence	blastn	43778	222	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eugregarinorida	Gregarinidae	Gregarina	Gregarina sp. Phaedon/Daegwallyeong/2010
11066248	11066248	PRJNA888821_P_NODE_24889_length_292_cov_10.401826_g24807_i0	PRJNA888821	24889	292	10.401826	30.37333192	Eimeria acervulina	5801	SAR_Eukaryotes	SAR_Eukaryotes	52.8	0.027	NTclustered	gi\|915005879\|ref\|XM_013394413.1\|	5801	g24807	i0	100	0.0958904109589041	28	0	10	0	218	245	1071	1098	Eimeria acervulina hypothetical protein, conserved partial mRNA	blastn	28	52.8	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Eimeriidae	Eimeria	Eimeria acervulina
18714192	18714192	PRJNA888821_P_NODE_30915_length_266_cov_1.290155_g30832_i0	PRJNA888821	30915	266	1.290155	3.4318123	Plasmodium falciparum	5833	SAR_Eukaryotes	SAR_Eukaryotes	462	9.48e-126	NTclustered	gi\|258597637\|ref\|XM_001348206.2\|	36329	g30832	i0	99.605	3.80451127819549	253	1	95	0	8	260	378	630	Plasmodium falciparum 3D7 conserved Plasmodium protein, unknown function (PF3D7_1407200), partial mRNA	blastn	1012	462	1	Eukaryota	Sar	Apicomplexa	Aconoidasida	Haemosporida	Plasmodiidae	Plasmodium	Plasmodium falciparum
19989467	19989467	PRJNA888821_P_NODE_32156_length_260_cov_16.748663_g32073_i0	PRJNA888821	32156	260	16.748663	43.5465238	Sarcocystis zamani	137009	SAR_Eukaryotes	SAR_Eukaryotes	102	2.32e-17	NTclustered	gi\|1005651882\|gb\|KU244522.1\|	137009	g32073	i0	98.305	20.7884615384615	59	0	22	1	1	58	3267	3325	Sarcocystis zamani voucher DOA02 18S ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence	blastn	5405	102	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Sarcocystidae	Sarcocystis	Sarcocystis zamani

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