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

5 rows where analysis = "blastn", bioproject = "PRJNA436017" 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
1705731	1705731	PRJNA436017_P_NODE_27262_length_156_cov_1.638655_g26964_i0	PRJNA436017	27262	156	1.638655	2.5563018	Theileria equi	5872	SAR_Eukaryotes	SAR_Eukaryotes	84.2	4.56e-12	NTclustered	gi\|510902051\|ref\|XM_004829620.1\|	1537102	g26964	i0	79.339	3.91025641025641	121	23	77	2	16	135	450	331	Theileria equi strain WA 40S ribosomal protein S13e, putative (BEWA_028610), mRNA	blastn	610	84.2	1	Eukaryota	Sar	Apicomplexa	Aconoidasida	Piroplasmida	Theileriidae	Theileria	Theileria equi
4917196	4917196	PRJNA436017_P_NODE_27764_length_155_cov_1.288136_g27466_i0	PRJNA436017	27764	155	1.288136	1.9966108	Plasmodium	5820	SAR_Eukaryotes	SAR_Eukaryotes	113	5.76e-21	NTclustered	gi\|1145263656\|ref\|XM_012910100.2\|	5854	g27466	i0	80.263	2.54838709677419	152	28	97	2	3	153	1863	2013	Plasmodium reichenowi elongation factor 2 partial mRNA	blastn	395	113	1	Eukaryota	Sar	Apicomplexa	Aconoidasida	Haemosporida	Plasmodiidae	Plasmodium	Plasmodium reichenowi
13184696	13184696	PRJNA436017_P_NODE_8251_length_307_cov_2.777778_g7954_i0	PRJNA436017	8251	307	2.777778	8.52777846	Rhytidocystis dobrovolskiji	2719951	SAR_Eukaryotes	SAR_Eukaryotes	132	3.58e-26	NTclustered	gi\|1823682786\|gb\|MT231947.1\|	2719951	g7954	i0	81.609	39.8892508143323	174	18	56	8	1	173	3471	3311	Rhytidocystis dobrovolskiji isolate OL_MBS2015 small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence	blastn	12246	132	1	Eukaryota	Sar	Apicomplexa	Marosporida	Agamococcidiorida	Rhytidocystidae	Rhytidocystis	Rhytidocystis dobrovolskiji
14459476	14459476	PRJNA436017_P_NODE_15052_length_214_cov_1.593220_g14754_i0	PRJNA436017	15052	214	1.59322	3.4094908	Plasmodium gaboni	647221	SAR_Eukaryotes	SAR_Eukaryotes	261	2.88e-65	NTclustered	gi\|1084958024\|ref\|XM_018783292.1\|	647221	g14754	i0	89.1	148	211	22	99	1	4	214	452	243	Plasmodium gaboni polyubiquitin partial mRNA	blastn	31672	261	1	Eukaryota	Sar	Apicomplexa	Aconoidasida	Haemosporida	Plasmodiidae	Plasmodium	Plasmodium gaboni
20832597	20832597	PRJNA436017_P_NODE_317_length_1438_cov_4.779443_g256_i0	PRJNA436017	317	1438	4.779443	68.72839034	Legerella nova	3081637	SAR_Eukaryotes	SAR_Eukaryotes	76.8	8.75e-9	NTclustered	gi\|2699878143\|gb\|OR693319.1\|	3081637	g256	i0	91.228	5.10639777468707	57	4	4	1	994	1049	19884	19940	Legerella nova apicoplast, complete genome	blastn	7343	76.8	1	Eukaryota	Sar	Apicomplexa			Legerellidae	Legerella	Legerella nova

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