metadata: contig_metadata: 7 rows where analysis = "diamond", bioproject = "PRJEB12237" and tax

7 rows where analysis = "diamond", bioproject = "PRJEB12237" 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
8947701	8947701	PRJEB12237_P_NODE_8768_length_184_cov_0.979866_g8572_i0	PRJEB12237	8768	184	0.979866	1.80295344	Cyclospora cayetanensis	88456	SAR_Eukaryotes	SAR_Eukaryotes	95.1	5.55e-24	NR	OEH75539.1	88456	g8572	i0	72.4	3.78260869565217	58	16	94.6	0	184	11	5	62	OEH75539.1 small nuclear ribonucleoprotein e [Cyclospora cayetanensis]	diamond	696	95.1	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Eimeriidae	Cyclospora	Cyclospora cayetanensis
14048820	14048820	PRJEB12237_P_NODE_5752_length_246_cov_3.985782_g5556_i0	PRJEB12237	5752	246	3.985782	9.80502372	Piroplasmida	5863	SAR_Eukaryotes	SAR_Eukaryotes	143	8.95e-40	NR	UKK02294.2	68886	g5556	i0	79	12.8414634146341	81	17	98.8	0	2	244	93	173	UKK02294.2 putative ADP/ATP transporter [Theileria orientalis]	diamond	3159	143	1	Eukaryota	Sar	Apicomplexa	Aconoidasida	Piroplasmida	Theileriidae	Theileria	Theileria orientalis
26678228	26678228	PRJEB12237_P_NODE_2801_length_415_cov_2.536842_g2605_i0	PRJEB12237	2801	415	2.536842	10.5278943	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	111	4.2100000000000006e-27	NR	OEH74043.1	88456	g2605	i0	43	4.73493975903614	128	73	92.5	0	32	415	110	237	OEH74043.1 ribosomal protein rpp0 [Cyclospora cayetanensis]	diamond	1965	111	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Eimeriidae	Cyclospora	Cyclospora cayetanensis
26805083	26805083	PRJEB12237_P_NODE_10901_length_160_cov_1.280000_g10705_i0	PRJEB12237	10901	160	1.28	2.048	Sarcocystidae	5809	SAR_Eukaryotes	SAR_Eukaryotes	48.5	1.1e-4	NR	XP_067926039.1	483139	g10705	i0	47.8	8.7	46	24	86.3	0	159	22	347	392	XP_067926039.1 camp-dependent protein kinase regulatory subunit [Cystoisospora suis]	diamond	1392	48.5	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Sarcocystidae	Cystoisospora	Cystoisospora suis
30058119	30058119	PRJEB12237_P_NODE_5871_length_243_cov_1.730769_g5675_i0	PRJEB12237	5871	243	1.730769	4.20576867	Conoidasida	1280412	SAR_Eukaryotes	SAR_Eukaryotes	58.2	1.01e-7	NR	XP_022587039.1	88456	g5675	i0	35.1	2.74074074074074	74	47	91.4	1	19	240	161	233	XP_022587039.1 phosducin-like protein 3 [Cyclospora cayetanensis]	diamond	666	58.2	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Eimeriidae	Cyclospora	Cyclospora cayetanensis
30816572	30816572	PRJEB12237_P_NODE_6934_length_216_cov_1.767956_g6738_i0	PRJEB12237	6934	216	1.767956	3.81878496	root	1	Root_unresolved	Root_unresolved	101	5.32e-25	NR	KAK1441808.1	33632	g6738	i0	66.2	6.90277777777778	71	23	98.6	1	3	215	75	144	KAK1441808.1 ribosomal protein L22/L17 like protein [Babesia gibsoni]	diamond	1491	102	0.990196078431373	Eukaryota	Sar	Apicomplexa	Aconoidasida	Piroplasmida	Babesiidae	Babesia	Babesia gibsoni
32776409	32776409	PRJEB12237_P_NODE_7020_length_214_cov_1.597765_g6824_i0	PRJEB12237	7020	214	1.597765	3.4192171	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	45.8	5.52e-4	NR	XP_953348.1	5874	g6824	i0	42.9	1.30373831775701	49	25	68.7	1	68	214	9	54	XP_953348.1 60S ribosomal protein P1, putative [Theileria annulata]	diamond	279	46.2	0.991341991341991	Eukaryota	Sar	Apicomplexa	Aconoidasida	Piroplasmida	Theileriidae	Theileria	Theileria annulata

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