metadata: contig_metadata: 5 rows where bioproject = "PRJNA883229", tax_clade = "Sar" and tax

5 rows where bioproject = "PRJNA883229", tax_clade = "Sar" 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
17438242	17438242	PRJNA883229_P_NODE_8574_length_253_cov_1.200000_g8528_i0	PRJNA883229	8574	253	1.2	3.036	Neospora caninum	29176	SAR_Eukaryotes	SAR_Eukaryotes	182	2.81e-41	NTclustered	gi\|401410671\|ref\|XM_003884735.1\|	572307	g8528	i0	83.505	35.7707509881423	194	32	77	0	60	253	1	194	Neospora caninum Liverpool hypothetical protein (NCLIV_051820), partial mRNA	blastn	9050	182	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Sarcocystidae	Neospora	Neospora caninum
27687571	27687571	PRJNA883229_P_NODE_13404_length_246_cov_0.901734_g13358_i0	PRJNA883229	13404	246	0.901734	2.21826564	Gregarina niphandrodes	110365	SAR_Eukaryotes	SAR_Eukaryotes	122	2.8499999999999995e-31	NR	XP_011130712.1	110365	g13358	i0	68.8	0.975609756097561	80	25	97.6	0	3	242	135	214	XP_011130712.1 putative cytosolic Fe-S cluster assembly factor nubp1 [Gregarina niphandrodes]	diamond	240	122	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eugregarinorida	Gregarinidae	Gregarina	Gregarina niphandrodes
30497765	30497765	PRJNA883229_P_NODE_11793_length_249_cov_0.886364_g11747_i0	PRJNA883229	11793	249	0.886364	2.20704636	Gregarina niphandrodes	110365	SAR_Eukaryotes	SAR_Eukaryotes	63.2	4.33e-10	NR	XP_011132929.1	110365	g11747	i0	50.7	0.831325301204819	69	31	83.1	1	244	38	94	159	XP_011132929.1 hypothetical protein GNI_156540 [Gregarina niphandrodes]	diamond	207	63.2	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eugregarinorida	Gregarinidae	Gregarina	Gregarina niphandrodes
30876840	30876840	PRJNA883229_P_NODE_15454_length_243_cov_0.917647_g15408_i0	PRJNA883229	15454	243	0.917647	2.22988221	Gregarina niphandrodes	110365	SAR_Eukaryotes	SAR_Eukaryotes	70.5	6.26e-12	NR	XP_011134237.1	110365	g15408	i0	43.8	0.987654320987654	80	41	96.3	2	2	235	59	136	XP_011134237.1 putative carboxypeptidase [Gregarina niphandrodes]	diamond	240	70.5	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eugregarinorida	Gregarinidae	Gregarina	Gregarina niphandrodes
32773466	32773466	PRJNA883229_P_NODE_15860_length_243_cov_0.917647_g15814_i0	PRJNA883229	15860	243	0.917647	2.22988221	Gregarina niphandrodes	110365	SAR_Eukaryotes	SAR_Eukaryotes	83.6	1.05e-18	NR	XP_011130537.1	110365	g15814	i0	57.9	0.938271604938272	76	31	92.6	1	225	1	30	105	XP_011130537.1 60S ribosomal protein L36 [Gregarina niphandrodes]	diamond	228	83.6	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);;