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

5 rows where analysis = "diamond", bioproject = "PRJNA700095" 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
28693567	28693567	PRJNA700095_P_NODE_48867_length_255_cov_4.708791_g47603_i0	PRJNA700095	48867	255	4.708791	12.00741705	Babesia duncani	323732	SAR_Eukaryotes	SAR_Eukaryotes	99.4	5.7299999999999996e-24	NR	XP_067803689.1	323732	g47603	i0	58.4	1.82352941176471	77	32	90.6	0	234	4	8	84	XP_067803689.1 bifunctional RNA recognition motif domain/RNA-binding domain superfamily/Nucleotide-binding alpha-beta plait domain superfamily [Babesia duncani]	diamond	465	99.4	1	Eukaryota	Sar	Apicomplexa	Aconoidasida	Piroplasmida	Babesiidae	Babesia	Babesia duncani
28862263	28862263	PRJNA700095_P_NODE_27988_length_322_cov_1.843373_g26724_i0	PRJNA700095	27988	322	1.843373	5.93566106	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	67.4	1.44e-10	NR	KAF8821376.1	476202	g26724	i0	34.9	3.64285714285714	106	65	96	2	8	316	4	108	KAF8821376.1 3' exoribonuclease family, domain 1 domain-containing protein [Cardiosporidium cionae]	diamond	1173	67.8	0.994100294985251	Eukaryota	Sar	Apicomplexa	Aconoidasida	Nephromycida		Cardiosporidium	Cardiosporidium cionae
30462337	30462337	PRJNA700095_P_NODE_60673_length_244_cov_0.900585_g59409_i0	PRJNA700095	60673	244	0.900585	2.1974274	Babesia microti strain RI	1133968	SAR_Eukaryotes	SAR_Eukaryotes	47.4	8.47e-4	NR	XP_012647374.1	1133968	g59409	i0	40	0.737704918032787	60	36	73.8	0	191	12	326	385	XP_012647374.1 conserved Plasmodium membrane protein, unknown function [Babesia microti strain RI]	diamond	180	47.4	1	Eukaryota	Sar	Apicomplexa	Aconoidasida	Piroplasmida	Babesiidae	Babesia	Babesia microti
30746254	30746254	PRJNA700095_P_NODE_39434_length_277_cov_1.867647_g38170_i0	PRJNA700095	39434	277	1.867647	5.17338219	Cryptosporidium felis	83540	SAR_Eukaryotes	SAR_Eukaryotes	43.9	0.0205	NR	KAF7458112.1	83540	g38170	i0	43.1	0.552346570397112	51	26	55.2	1	163	11	145	192	KAF7458112.1 nuclear movement family protein [Cryptosporidium felis]	diamond	153	43.9	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Cryptosporidiidae	Cryptosporidium	Cryptosporidium felis
31694592	31694592	PRJNA700095_P_NODE_28517_length_319_cov_0.930894_g27253_i0	PRJNA700095	28517	319	0.930894	2.96955186	Cardiosporidium cionae	476202	SAR_Eukaryotes	SAR_Eukaryotes	45.8	0.00708	NR	KAF8820158.1	476202	g27253	i0	32.4	0.667711598746082	71	47	66.8	1	3	215	457	526	KAF8820158.1 hypothetical protein IE077_003488 [Cardiosporidium cionae]	diamond	213	45.8	1	Eukaryota	Sar	Apicomplexa	Aconoidasida	Nephromycida		Cardiosporidium	Cardiosporidium cionae

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