metadata: contig_metadata: 6 rows where bioproject = "PRJNA849646" and tax

6 rows where bioproject = "PRJNA849646" 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
5941537	5941537	PRJNA849646_P_NODE_36445_length_243_cov_1.811765_g36327_i0	PRJNA849646	36445	243	1.811765	4.40258895	Eimeria maxima	5804	SAR_Eukaryotes	SAR_Eukaryotes	80.5	1e-10	NTclustered	gi\|915141676\|ref\|XM_013482159.1\|	5804	g36327	i0	84.81	30.5308641975309	79	12	33	0	1	79	4782	4860	Eimeria maxima hypothetical protein, conserved partial mRNA	blastn	7419	80.5	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Eimeriidae	Eimeria	Eimeria maxima
13986980	13986980	PRJNA849646_P_NODE_12171_length_283_cov_2.657143_g12053_i0	PRJNA849646	12171	283	2.657143	7.51971469	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	518	2.14e-142	NTclustered	gi\|14495562\|gb\|L21708.2\|PFA34K	5821	g12053	i0	99.647	99.9964664310954	283	1	100	0	1	283	940	1222	Plasmodium berghei p23-like protein mRNA, partial cds	blastn	28299	523	0.990439770554493	Eukaryota	Sar	Apicomplexa	Aconoidasida	Haemosporida	Plasmodiidae	Plasmodium	Plasmodium berghei
23790672	23790672	PRJNA849646_P_NODE_5659_length_310_cov_2.877637_g5541_i0	PRJNA849646	5659	310	2.877637	8.9206747	Gregarina niphandrodes	110365	SAR_Eukaryotes	SAR_Eukaryotes	52.8	0.029	NTclustered	gi\|749159684\|ref\|XM_011133169.1\|	110365	g5541	i0	100	0.0903225806451613	28	0	9	0	117	144	439	466	Gregarina niphandrodes hypothetical protein partial mRNA	blastn	28	52.8	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eugregarinorida	Gregarinidae	Gregarina	Gregarina niphandrodes
26737935	26737935	PRJNA849646_P_NODE_19541_length_269_cov_2.163265_g19423_i0	PRJNA849646	19541	269	2.163265	5.81918285	Gregarina niphandrodes	110365	SAR_Eukaryotes	SAR_Eukaryotes	48.5	4.74e-4	NR	XP_011129914.1	110365	g19423	i0	39	0.91449814126394	82	45	91.4	2	248	3	390	466	XP_011129914.1 putative pentatricopeptide repeat protein [Gregarina niphandrodes]	diamond	246	48.5	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eugregarinorida	Gregarinidae	Gregarina	Gregarina niphandrodes
27276247	27276247	PRJNA849646_P_NODE_15463_length_277_cov_1.509804_g15345_i0	PRJNA849646	15463	277	1.509804	4.18215708	Gregarina niphandrodes	110365	SAR_Eukaryotes	SAR_Eukaryotes	101	1.39e-22	NR	XP_011132332.1	110365	g15345	i0	80.6	0.671480144404332	62	12	67.1	0	190	5	482	543	XP_011132332.1 major facilitator superfamily transporter [Gregarina niphandrodes]	diamond	186	101	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eugregarinorida	Gregarinidae	Gregarina	Gregarina niphandrodes
30402904	30402904	PRJNA849646_P_NODE_33593_length_246_cov_2.352601_g33475_i0	PRJNA849646	33593	246	2.352601	5.78739846	Gregarina niphandrodes	110365	SAR_Eukaryotes	SAR_Eukaryotes	64.3	9.84e-10	NR	XP_011130027.1	110365	g33475	i0	73.8	0.51219512195122	42	11	51.2	0	245	120	2877	2918	XP_011130027.1 hypothetical protein GNI_063170 [Gregarina niphandrodes]	diamond	126	64.3	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eugregarinorida	Gregarinidae	Gregarina	Gregarina niphandrodes

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