metadata: contig_metadata: 4 rows where bioproject = "PRJNA450343", tax_clade = "Sar" and tax

4 rows where bioproject = "PRJNA450343", 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
13192589	13192589	PRJNA450343_P_NODE_11791_length_165_cov_0.879310_g11723_i0	PRJNA450343	11791	165	0.87931	1.4508615	Cryptosporidium viatorum	1176757	SAR_Eukaryotes	SAR_Eukaryotes	113	6.240000000000001e-21	NTclustered	gi\|441431303\|gb\|JX978273.1\|	1176757	g11723	i0	98.438	16.6484848484848	64	1	59	0	1	64	1887	1824	Cryptosporidium viatorum isolate Swec025 70 kDa heat shock protein (HSP70) gene, partial cds	blastn	2747	113	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Cryptosporidiidae	Cryptosporidium	Cryptosporidium viatorum
26871205	26871205	PRJNA450343_P_NODE_13621_length_161_cov_1.821429_g13553_i0	PRJNA450343	13621	161	1.821429	2.93250069	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	50.1	3.19e-5	NR	XP_038969887.1	5851	g13553	i0	42.3	6.3167701863354	52	29	96.9	1	3	158	693	743	XP_038969887.1 general transcription factor 3C polypeptide 5, putative [Plasmodium knowlesi strain H]	diamond	1017	50.4	0.994047619047619	Eukaryota	Sar	Apicomplexa	Aconoidasida	Haemosporida	Plasmodiidae	Plasmodium	Plasmodium knowlesi
26965723	26965723	PRJNA450343_P_NODE_5502_length_227_cov_0.859551_g5434_i0	PRJNA450343	5502	227	0.859551	1.95118077	root	1	Root_unresolved	Root_unresolved	80.5	7.97e-18	NR	CXH16301.1	5821	g5434	i0	78	1.33480176211454	50	11	66.1	0	225	76	11	60	CXH16301.1 hypothetical protein PBK173_000516600 [Plasmodium berghei]	diamond	303	80.9	0.995055624227441	Eukaryota	Sar	Apicomplexa	Aconoidasida	Haemosporida	Plasmodiidae	Plasmodium	Plasmodium berghei
29871219	29871219	PRJNA450343_P_NODE_12651_length_163_cov_1.342105_g12583_i0	PRJNA450343	12651	163	1.342105	2.18763115	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	116	1.46e-28	NR	GFE53926.1	5869	g12583	i0	92.6	45.7177914110429	54	4	99.4	0	162	1	66	119	GFE53926.1 succinate flavo subunit [Babesia ovis]	diamond	7452	117	0.991452991452991	Eukaryota	Sar	Apicomplexa	Aconoidasida	Piroplasmida	Babesiidae	Babesia	Babesia ovis

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