metadata: contig_metadata: 5 rows where analysis = "diamond", bioproject = "PRJNA1158727" and tax

5 rows where analysis = "diamond", bioproject = "PRJNA1158727" 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
1577813	1577813	PRJNA1158727_P_NODE_104682_length_286_cov_1.446009_g97221_i0	PRJNA1158727	104682	286	1.446009	4.13558574	Eimeria praecox	51316	SAR_Eukaryotes	SAR_Eukaryotes	99	4.5e-23	NR	CDI80419.1	51316	g97221	i0	48.4	3.73426573426573	95	46	99.7	1	1	285	79	170	CDI80419.1 thioredoxin, putative [Eimeria praecox]	diamond	1068	99	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Eimeriidae	Eimeria	Eimeria praecox
21982891	21982891	PRJNA1158727_P_NODE_65318_length_396_cov_1.430341_g57857_i0	PRJNA1158727	65318	396	1.430341	5.66415036	Cryptosporidium ubiquitum	857276	SAR_Eukaryotes	SAR_Eukaryotes	122	7.6e-33	NR	XP_028876282.1	857276	g57857	i0	61.6	2.23484848484848	99	38	75	0	19	315	3	101	XP_028876282.1 histone H4 [Cryptosporidium ubiquitum]	diamond	885	122	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Cryptosporidiidae	Cryptosporidium	Cryptosporidium ubiquitum
24529818	24529818	PRJNA1158727_P_NODE_133820_length_252_cov_1.312849_g126359_i0	PRJNA1158727	133820	252	1.312849	3.30837948	Plasmodium	5820	SAR_Eukaryotes	SAR_Eukaryotes	111	1.37e-28	NR	SOV82142.1	5854	g126359	i0	67.1	8.52380952380952	82	27	97.6	0	7	252	7	88	SOV82142.1 60S ribosomal protein L17, putative [Plasmodium reichenowi]	diamond	2148	112	0.991071428571429	Eukaryota	Sar	Apicomplexa	Aconoidasida	Haemosporida	Plasmodiidae	Plasmodium	Plasmodium reichenowi
28303671	28303671	PRJNA1158727_P_NODE_146366_length_247_cov_0.885057_g138904_i0	PRJNA1158727	146366	247	0.885057	2.18609079	Cryptosporidium muris RN66	441375	SAR_Eukaryotes	SAR_Eukaryotes	92.4	9.84e-20	NR	XP_002141413.1	441375	g138904	i0	47.4	0.947368421052632	78	40	93.5	1	1	231	71	148	XP_002141413.1 eukaryotic translation initiation factor 5, putative [Cryptosporidium muris RN66]	diamond	234	92.4	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Cryptosporidiidae	Cryptosporidium	Cryptosporidium muris
28828049	28828049	PRJNA1158727_P_NODE_133808_length_252_cov_1.335196_g126347_i0	PRJNA1158727	133808	252	1.335196	3.36469392	root	1	Root_unresolved	Root_unresolved	132	3.4e-37	NR	XP_013336607.1	5804	g126347	i0	75.9	543.440476190476	83	20	98.8	0	3	251	5	87	XP_013336607.1 polyubiquitin, putative, partial [Eimeria maxima]	diamond	136947	132	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Eimeriidae	Eimeria	Eimeria maxima

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