metadata: contig_metadata: 4 rows where analysis = "diamond", bioproject = "PRJEB11748" and tax

4 rows where analysis = "diamond", bioproject = "PRJEB11748" 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
5122424	5122424	PRJEB11748_P_NODE_75005_length_486_cov_7.329412_g72850_i0	PRJEB11748	75005	486	7.329412	35.62094232	Apicomplexa	5794	SAR_Eukaryotes	SAR_Eukaryotes	112	3.11e-25	NR	XP_011132554.1	110365	g72850	i0	56.4	4.04320987654321	94	41	58	0	38	319	36	129	XP_011132554.1 heat shock protein 70 [Gregarina niphandrodes]	diamond	1965	113	0.991150442477876	Eukaryota	Sar	Apicomplexa	Conoidasida	Eugregarinorida	Gregarinidae	Gregarina	Gregarina niphandrodes
27190866	27190866	PRJEB11748_P_NODE_373682_length_184_cov_11.439024_g371499_i0	PRJEB11748	373682	184	11.439024	21.04780416	Cryptosporidium felis	83540	SAR_Eukaryotes	SAR_Eukaryotes	45.4	6.22e-4	NR	KAF7457853.1	83540	g371499	i0	60.6	0.53804347826087	33	13	53.8	0	132	34	64	96	KAF7457853.1 Regulator of rDNA transcription protein 15 [Cryptosporidium felis]	diamond	99	45.4	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Cryptosporidiidae	Cryptosporidium	Cryptosporidium felis
27475144	27475144	PRJEB11748_P_NODE_116823_length_384_cov_5.869969_g114649_i0	PRJEB11748	116823	384	5.869969	22.54068096	Gregarina niphandrodes	110365	SAR_Eukaryotes	SAR_Eukaryotes	65.1	2.72e-9	NR	XP_011131040.1	110365	g114649	i0	54.2	0.4609375	59	27	46.1	0	123	299	340	398	XP_011131040.1 putative phosphodiesterase [Gregarina niphandrodes]	diamond	177	65.1	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eugregarinorida	Gregarinidae	Gregarina	Gregarina niphandrodes
29180394	29180394	PRJEB11748_P_NODE_164229_length_318_cov_8.571984_g162046_i0	PRJEB11748	164229	318	8.571984	27.25890912	Plasmodium ovale	36330	SAR_Eukaryotes	SAR_Eukaryotes	43.9	0.0343	NR	SBT84168.1	36330	g162046	i0	35.7	0.660377358490566	70	34	66	3	81	290	341	399	SBT84168.1 PIR protein [Plasmodium ovale]	diamond	210	43.9	1	Eukaryota	Sar	Apicomplexa	Aconoidasida	Haemosporida	Plasmodiidae	Plasmodium	Plasmodium ovale

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