metadata: contig_metadata: 5 rows where analysis = "blastn", bioproject = "PRJNA515078" and tax

5 rows where analysis = "blastn", bioproject = "PRJNA515078" 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
3037821	3037821	PRJNA515078_P_NODE_12723_length_249_cov_1.438679_g12490_i0	PRJNA515078	12723	249	1.438679	3.58231071	Plasmodium gaboni	647221	SAR_Eukaryotes	SAR_Eukaryotes	93.5	1.33e-14	NTclustered	gi\|1084839774\|ref\|XM_018785426.1\|	647221	g12490	i0	89.189	0.29718875502008	74	8	30	0	176	249	1682	1609	Plasmodium gaboni heat shock protein 70 partial mRNA	blastn	74	93.5	1	Eukaryota	Sar	Apicomplexa	Aconoidasida	Haemosporida	Plasmodiidae	Plasmodium	Plasmodium gaboni
11314123	11314123	PRJNA515078_P_NODE_25809_length_171_cov_1.395522_g25576_i0	PRJNA515078	25809	171	1.395522	2.38634262	Eimeria	5800	SAR_Eukaryotes	SAR_Eukaryotes	106	1.08e-18	NTclustered	gi\|324022095\|gb\|GU593712.1\|	5804	g25576	i0	79.618	48.7894736842105	157	25	91	6	1	156	344	494	Eimeria maxima strain Barksdale 28S ribosomal RNA gene, partial sequence	blastn	8343	106	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Eimeriidae	Eimeria	Eimeria maxima
11965571	11965571	PRJNA515078_P_NODE_22970_length_181_cov_1.347222_g22737_i0	PRJNA515078	22970	181	1.347222	2.43847182	Cyclospora cayetanensis	88456	SAR_Eukaryotes	SAR_Eukaryotes	58.4	3.3e-4	NTclustered	gi\|1472916858\|ref\|XM_026333920.1\|	88456	g22737	i0	90.698	0.76243093922651906	43	4	24	0	19	61	856	898	PREDICTED: Cyclospora cayetanensis ice-structuring glycoprotein-like (LOC113146470), mRNA	blastn	138	58.4	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Eimeriidae	Cyclospora	Cyclospora cayetanensis
15789546	15789546	PRJNA515078_P_NODE_23313_length_180_cov_1.076923_g23080_i0	PRJNA515078	23313	180	1.076923	1.9384614	Gregarina niphandrodes	110365	SAR_Eukaryotes	SAR_Eukaryotes	137	4.1e-28	NTclustered	gi\|749156468\|ref\|XM_011131561.1\|	110365	g23080	i0	80.925	4.60555555555556	173	33	96	0	6	178	586	758	Gregarina niphandrodes putative cell division protein 48 partial mRNA	blastn	829	137	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eugregarinorida	Gregarinidae	Gregarina	Gregarina niphandrodes
17688852	17688852	PRJNA515078_P_NODE_4914_length_430_cov_1.786260_g4681_i0	PRJNA515078	4914	430	1.78626	7.680918	Eimeria	5800	SAR_Eukaryotes	SAR_Eukaryotes	52.8	0.041	NTclustered	gi\|916426085\|ref\|XM_013378820.1\|	5802	g4681	i0	100	0.130232558139535	28	0	7	0	263	290	380	407	Eimeria tenella uncharacterized protein (ETH_00005955), partial mRNA	blastn	56	52.8	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Eimeriidae	Eimeria	Eimeria tenella

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