metadata: contig_metadata: 5 rows where analysis = "diamond", bioproject = "PRJNA939415" and tax

5 rows where analysis = "diamond", bioproject = "PRJNA939415" 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
22592965	22592965	PRJNA939415_P_NODE_66878_length_267_cov_1.577320_g66456_i0	PRJNA939415	66878	267	1.57732	4.2114444	Plasmodium	5820	SAR_Eukaryotes	SAR_Eukaryotes	89.4	1.01e-18	NR	XP_001351251.1	36329	g66456	i0	52.4	3.7752808988764	84	40	94.4	0	3	254	191	274	XP_001351251.1 stomatin-like protein, putative [Plasmodium falciparum 3D7]	diamond	1008	89.7	0.996655518394649	Eukaryota	Sar	Apicomplexa	Aconoidasida	Haemosporida	Plasmodiidae	Plasmodium	Plasmodium falciparum
27688971	27688971	PRJNA939415_P_NODE_84564_length_250_cov_0.870056_g84142_i0	PRJNA939415	84564	250	0.870056	2.17514	Cystoisospora suis	483139	SAR_Eukaryotes	SAR_Eukaryotes	43.1	0.0311	NR	XP_067926183.1	483139	g84142	i0	38.3	0.72	60	34	68.4	1	61	231	1221	1280	XP_067926183.1 vacuolar transporter chaperone vtc2 [Cystoisospora suis]	diamond	180	43.1	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Sarcocystidae	Cystoisospora	Cystoisospora suis
29835525	29835525	PRJNA939415_P_NODE_76471_length_257_cov_4.081522_g76049_i0	PRJNA939415	76471	257	4.081522	10.48951154	Nephromyces sp. MMRI	2496275	SAR_Eukaryotes	SAR_Eukaryotes	66.2	2.08e-10	NR	AZL94549.1	2496275	g76049	i0	47.6	0.980544747081712	84	41	98.1	2	257	6	37	117	AZL94549.1 hydroxyacid oxidase [Nephromyces sp. MMRI]	diamond	252	66.2	1	Eukaryota	Sar	Apicomplexa	Aconoidasida	Nephromycida		Nephromyces	Nephromyces sp. MMRI
31643693	31643693	PRJNA939415_P_NODE_88236_length_247_cov_1.586207_g87814_i0	PRJNA939415	88236	247	1.586207	3.91793129	root	1	Root_unresolved	Root_unresolved	87.4	1.97e-20	NR	XP_067803900.1	323732	g87814	i0	55.2	7.28744939271255	67	30	81.4	0	211	11	9	75	XP_067803900.1 bifunctional Acyl-CoA-binding protein [Babesia duncani]	diamond	1800	87.4	1	Eukaryota	Sar	Apicomplexa	Aconoidasida	Piroplasmida	Babesiidae	Babesia	Babesia duncani
32907702	32907702	PRJNA939415_P_NODE_95780_length_241_cov_0.916667_g95358_i0	PRJNA939415	95780	241	0.916667	2.20916747	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	43.5	0.0198	NR	XP_013252393.1	5801	g95358	i0	34.3	1.55601659751037	70	45	85.9	1	230	24	1370	1439	XP_013252393.1 Midasin, related [Eimeria acervulina]	diamond	375	43.5	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Eimeriidae	Eimeria	Eimeria acervulina

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