metadata: contig_metadata: 5 rows where bioproject = "PRJNA416866" and tax

5 rows where bioproject = "PRJNA416866" 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
9347748	9347748	PRJNA416866_P_NODE_7268_length_240_cov_1.430168_g7124_i0	PRJNA416866	7268	240	1.430168	3.4324032	Plasmodium vinckei	5860	SAR_Eukaryotes	SAR_Eukaryotes	261	3.2900000000000007e-65	NTclustered	gi\|669202240\|ref\|XM_008627895.1\|	54757	g7124	i0	87.124	8.74166666666667	233	26	96	2	10	240	860	630	Plasmodium vinckei vinckei 26S protease regulatory subunit 6B, putative (PVVCY_0701540), partial mRNA	blastn	2098	261	1	Eukaryota	Sar	Apicomplexa	Aconoidasida	Haemosporida	Plasmodiidae	Plasmodium	Plasmodium vinckei
18271303	18271303	PRJNA416866_P_NODE_6995_length_245_cov_2.673913_g6851_i0	PRJNA416866	6995	245	2.673913	6.55108685	Plasmodium vinckei	5860	SAR_Eukaryotes	SAR_Eukaryotes	159	1.27e-34	NTclustered	gi\|669198058\|ref\|XM_008625818.1\|	54757	g6851	i0	86.713	6.33061224489796	143	19	58	0	3	145	509	367	Plasmodium vinckei vinckei eukaryotic translation initiation factor 2 subunit gamma, putative (PVVCY_1003730), partial mRNA	blastn	1551	159	1	Eukaryota	Sar	Apicomplexa	Aconoidasida	Haemosporida	Plasmodiidae	Plasmodium	Plasmodium vinckei
19545475	19545475	PRJNA416866_P_NODE_3236_length_373_cov_1.435897_g3093_i0	PRJNA416866	3236	373	1.435897	5.35589581	Eimeria tenella	5802	SAR_Eukaryotes	SAR_Eukaryotes	196	9.17e-59	NR	XP_013232628.1	5802	g3093	i0	78	12.8525469168901	123	27	98.9	0	2	370	18	140	XP_013232628.1 60S ribosomal protein L3, putative [Eimeria tenella]	diamond	4794	196	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Eimeriidae	Eimeria	Eimeria tenella
24646050	24646050	PRJNA416866_P_NODE_9020_length_214_cov_1.254902_g8876_i0	PRJNA416866	9020	214	1.254902	2.68549028	Plasmodium	5820	SAR_Eukaryotes	SAR_Eukaryotes	110	7.71e-27	NR	XP_028860810.1	5858	g8876	i0	80	1.96261682242991	70	14	98.1	0	211	2	198	267	XP_028860810.1 phosphoglycerate kinase, putative [Plasmodium malariae]	diamond	420	111	0.990990990990991	Eukaryota	Sar	Apicomplexa	Aconoidasida	Haemosporida	Plasmodiidae	Plasmodium	Plasmodium malariae
30960339	30960339	PRJNA416866_P_NODE_9134_length_212_cov_2.602649_g8990_i0	PRJNA416866	9134	212	2.602649	5.51761588	Neospora caninum Liverpool	572307	SAR_Eukaryotes	SAR_Eukaryotes	85.9	2.15e-19	NR	XP_003882281.1	572307	g8990	i0	60.3	4.7688679245283	68	27	96.2	0	212	9	74	141	XP_003882281.1 40S ribosomal protein S12, related [Neospora caninum Liverpool]	diamond	1011	85.9	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Sarcocystidae	Neospora	Neospora caninum

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