metadata: contig_metadata: 6 rows where analysis = "diamond", bioproject = "PRJNA911178" and tax

6 rows where analysis = "diamond", bioproject = "PRJNA911178" 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
4720453	4720453	PRJNA911178_P_NODE_181124_length_282_cov_1.904306_g178651_i0	PRJNA911178	181124	282	1.904306	5.37014292	Toxoplasma	5810	SAR_Eukaryotes	SAR_Eukaryotes	102	5.59e-24	NR	CEL74008.1	432359	g178651	i0	52.2	4.87234042553191	92	43	96.8	1	9	281	79	170	CEL74008.1 TPA: hydroxyacylglutathione hydrolase, putative [Toxoplasma gondii VEG]	diamond	1374	102	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Sarcocystidae	Toxoplasma	Toxoplasma gondii
4720646	4720646	PRJNA911178_P_NODE_202284_length_270_cov_2.309645_g199810_i0	PRJNA911178	202284	270	2.309645	6.2360415	Cyclospora cayetanensis	88456	SAR_Eukaryotes	SAR_Eukaryotes	118	9.37e-29	NR	OEH78182.1	88456	g199810	i0	65.9	0.977777777777778	88	30	97.8	0	264	1	421	508	OEH78182.1 heat shock protein [Cyclospora cayetanensis]	diamond	264	118	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Eimeriidae	Cyclospora	Cyclospora cayetanensis
29179461	29179461	PRJNA911178_P_NODE_141949_length_312_cov_1.255230_g139476_i0	PRJNA911178	141949	312	1.25523	3.9163176	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	68.2	1.03e-10	NR	VWU48375.1	2600580	g139476	i0	41.9	1.70192307692308	74	43	71.2	0	85	306	508	581	VWU48375.1 RNA-binding protein, putative [Hepatocystis sp. ex Piliocolobus tephrosceles]	diamond	531	68.2	1	Eukaryota	Sar	Apicomplexa	Aconoidasida	Haemosporida	Plasmodiidae	Hepatocystis	Hepatocystis sp. ex Piliocolobus tephrosceles
29747338	29747338	PRJNA911178_P_NODE_225090_length_258_cov_2.021622_g222616_i0	PRJNA911178	225090	258	2.021622	5.21578476	Eucoccidiorida	75739	SAR_Eukaryotes	SAR_Eukaryotes	110	5.830000000000001e-27	NR	AFV39095.1	93969	g222616	i0	66.7	4.37209302325581	75	20	87.2	1	2	226	100	169	AFV39095.1 glutamate tRNA ligase, partial [Cryptosporidium meleagridis]	diamond	1128	111	0.990990990990991	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Cryptosporidiidae	Cryptosporidium	Cryptosporidium meleagridis
31193167	31193167	PRJNA911178_P_NODE_79435_length_398_cov_2.150769_g76969_i0	PRJNA911178	79435	398	2.150769	8.56006062	Porospora cf. gigantea A	2853593	SAR_Eukaryotes	SAR_Eukaryotes	46.6	0.00804	NR	XP_067807512.1	2853593	g76969	i0	32.6	1.80904522613065	95	42	69.3	4	390	115	124	199	XP_067807512.1 MAG: uncharacterized protein KVP18_005252 [Porospora cf. gigantea A]	diamond	720	46.6	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eugregarinorida	Porosporidae	Porospora	Porospora cf. gigantea A
31896731	31896731	PRJNA911178_P_NODE_235277_length_253_cov_1.700000_g232803_i0	PRJNA911178	235277	253	1.7	4.301	Babesia	5864	SAR_Eukaryotes	SAR_Eukaryotes	45.1	0.0031	NR	BAN65996.1	5865	g232803	i0	34.7	1.77865612648221	75	48	88.9	1	228	4	1	74	BAN65996.1 mitochondrial import inner membrane translocase subunit Tim17, putative [Babesia bovis]	diamond	450	45.1	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);;