metadata: contig_metadata: 10 rows where analysis = "diamond", bioproject = "PRJNA222400" and tax

10 rows where analysis = "diamond", bioproject = "PRJNA222400" 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
6744838	6744838	PRJNA222400_P_NODE_3526_length_241_cov_2.536458_g3493_i0	PRJNA222400	3526	241	2.536458	6.11286378	Gregarina niphandrodes	110365	SAR_Eukaryotes	SAR_Eukaryotes	75.5	1.03e-14	NR	XP_011128579.1	110365	g3493	i0	52.6	0.970954356846473	78	37	97.1	0	237	4	3	80	XP_011128579.1 40S ribosomal protein S9 [Gregarina niphandrodes]	diamond	234	75.5	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eugregarinorida	Gregarinidae	Gregarina	Gregarina niphandrodes
18218821	18218821	PRJNA222400_P_NODE_1355_length_445_cov_1.270202_g1322_i0	PRJNA222400	1355	445	1.270202	5.6523989	Aconoidasida	422676	SAR_Eukaryotes	SAR_Eukaryotes	196	4.5e-61	NR	KAF8822852.1	476202	g1322	i0	66.7	3.6	132	44	89	0	424	29	42	173	KAF8822852.1 ribosomal protein RPL11 [Cardiosporidium cionae]	diamond	1602	197	0.99492385786802	Eukaryota	Sar	Apicomplexa	Aconoidasida	Nephromycida		Cardiosporidium	Cardiosporidium cionae
19493190	19493190	PRJNA222400_P_NODE_5936_length_184_cov_1.540741_g5903_i0	PRJNA222400	5936	184	1.540741	2.83496344	Cardiosporidium cionae	476202	SAR_Eukaryotes	SAR_Eukaryotes	67	1.66e-12	NR	KAF8822144.1	476202	g5903	i0	61.7	2.93478260869565	60	23	97.8	0	184	5	6	65	KAF8822144.1 ribosomal protein RPS25 [Cardiosporidium cionae]	diamond	540	67	1	Eukaryota	Sar	Apicomplexa	Aconoidasida	Nephromycida		Cardiosporidium	Cardiosporidium cionae
24593421	24593421	PRJNA222400_P_NODE_2780_length_287_cov_1.302521_g2747_i0	PRJNA222400	2780	287	1.302521	3.73823527	Eimeria maxima	5804	SAR_Eukaryotes	SAR_Eukaryotes	141	1.42e-39	NR	XP_013333069.1	5804	g2747	i0	72.6	0.878048780487805	84	23	87.8	0	263	12	157	240	XP_013333069.1 lactoylglutathione lyase, putative [Eimeria maxima]	diamond	252	141	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Eimeriidae	Eimeria	Eimeria maxima
27217922	27217922	PRJNA222400_P_NODE_3322_length_253_cov_1.220588_g3289_i0	PRJNA222400	3322	253	1.220588	3.08808764	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	114	1.5400000000000002e-27	NR	KAK1444442.1	33632	g3289	i0	63.9	18.8893280632411	83	30	98.4	0	4	252	424	506	KAK1444442.1 hypothetical protein BgAZ_103480 [Babesia gibsoni]	diamond	4779	114	1	Eukaryota	Sar	Apicomplexa	Aconoidasida	Piroplasmida	Babesiidae	Babesia	Babesia gibsoni
27863577	27863577	PRJNA222400_P_NODE_6445_length_177_cov_0.875000_g6412_i0	PRJNA222400	6445	177	0.875	1.54875	Plasmodium cynomolgi strain B	1120755	SAR_Eukaryotes	SAR_Eukaryotes	62	2.39e-9	NR	XP_004225382.1	1120755	g6412	i0	52.7	2.83050847457627	55	26	93.2	0	5	169	91	145	XP_004225382.1 asparagine - tRNA ligase [Plasmodium cynomolgi strain B]	diamond	501	62	1	Eukaryota	Sar	Apicomplexa	Aconoidasida	Haemosporida	Plasmodiidae	Plasmodium	Plasmodium cynomolgi
28891594	28891594	PRJNA222400_P_NODE_2648_length_296_cov_1.834008_g2615_i0	PRJNA222400	2648	296	1.834008	5.42866368	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	108	3.39e-28	NR	CAL7860326.1	1344799	g2615	i0	57.3	1.81418918918919	89	37	89.2	1	295	32	32	120	CAL7860326.1 unnamed protein product [Sarcocystis calchasi]	diamond	537	108	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Sarcocystidae	Sarcocystis	Sarcocystis calchasi
31323995	31323995	PRJNA222400_P_NODE_6095_length_182_cov_1.172932_g6062_i0	PRJNA222400	6095	182	1.172932	2.13473624	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	107	8.350000000000001e-27	NR	XP_013335841.1	5804	g6062	i0	76.7	21.7417582417582	60	14	98.9	0	181	2	60	119	XP_013335841.1 nucleoside diphosphate kinase, putative [Eimeria maxima]	diamond	3957	108	0.990740740740741	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Eimeriidae	Eimeria	Eimeria maxima
31591160	31591160	PRJNA222400_P_NODE_3896_length_226_cov_1.468927_g3863_i0	PRJNA222400	3896	226	1.468927	3.31977502	Cryptosporidium hominis	237895	SAR_Eukaryotes	SAR_Eukaryotes	64.7	5.53e-10	NR	KAL3126795.1	237895	g3863	i0	37.5	5.03097345132743	80	43	96.9	2	222	4	419	498	KAL3126795.1 putative sortilin [Cryptosporidium hominis]	diamond	1137	64.7	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Cryptosporidiidae	Cryptosporidium	Cryptosporidium hominis
32209869	32209869	PRJNA222400_P_NODE_3878_length_227_cov_1.140449_g3845_i0	PRJNA222400	3878	227	1.140449	2.58881923	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	99.4	1.35e-24	NR	OEH75439.1	88456	g3845	i0	54.7	5.90748898678414	75	34	99.1	0	2	226	22	96	OEH75439.1 ubiquitin-conjugating related protein [Cyclospora cayetanensis]	diamond	1341	100	0.994	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Eimeriidae	Cyclospora	Cyclospora cayetanensis

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