metadata: contig_metadata: 6 rows where analysis = "diamond", bioproject = "PRJNA950981" and tax

6 rows where analysis = "diamond", bioproject = "PRJNA950981" 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
29109931	29109931	PRJNA950981_P_NODE_12068_length_296_cov_1.049327_g11892_i0	PRJNA950981	12068	296	1.049327	3.10600792	Babesia ovata	189622	SAR_Eukaryotes	SAR_Eukaryotes	60.8	1.83e-8	NR	XP_028865208.1	189622	g11892	i0	61.7	0.476351351351351	47	18	47.6	0	3	143	190	236	XP_028865208.1 translation initiation factor [Babesia ovata]	diamond	141	60.8	1	Eukaryota	Sar	Apicomplexa	Aconoidasida	Piroplasmida	Babesiidae	Babesia	Babesia ovata
30126694	30126694	PRJNA950981_P_NODE_21132_length_243_cov_0.917647_g20956_i0	PRJNA950981	21132	243	0.917647	2.22988221	Sarcocystidae	5809	SAR_Eukaryotes	SAR_Eukaryotes	101	3.22e-23	NR	XP_029219060.1	94643	g20956	i0	58.8	4.9382716049382704	80	32	98.8	1	241	2	153	231	XP_029219060.1 ribosomal protein RPL3 [Besnoitia besnoiti]	diamond	1200	102	0.990196078431373	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Sarcocystidae	Besnoitia	Besnoitia besnoiti
30342069	30342069	PRJNA950981_P_NODE_20912_length_243_cov_1.835294_g20736_i0	PRJNA950981	20912	243	1.835294	4.45976442	Cardiosporidium cionae	476202	SAR_Eukaryotes	SAR_Eukaryotes	67.8	4.29e-11	NR	KAF8821915.1	476202	g20736	i0	60.8	0.62962962962963	51	20	63	0	242	90	234	284	KAF8821915.1 putative proteasome subunit beta type 7 precursor, partial [Cardiosporidium cionae]	diamond	153	67.8	1	Eukaryota	Sar	Apicomplexa	Aconoidasida	Nephromycida		Cardiosporidium	Cardiosporidium cionae
30752327	30752327	PRJNA950981_P_NODE_21134_length_243_cov_0.917647_g20958_i0	PRJNA950981	21134	243	0.917647	2.22988221	Sarcocystis calchasi	1344799	SAR_Eukaryotes	SAR_Eukaryotes	122	8.97e-33	NR	CAL7863955.1	1344799	g20958	i0	70.4	2	81	24	100	0	243	1	54	134	CAL7863955.1 unnamed protein product [Sarcocystis calchasi]	diamond	486	122	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Sarcocystidae	Sarcocystis	Sarcocystis calchasi
31352808	31352808	PRJNA950981_P_NODE_8956_length_337_cov_0.886364_g8780_i0	PRJNA950981	8956	337	0.886364	2.98704668	Babesia ovata	189622	SAR_Eukaryotes	SAR_Eukaryotes	78.6	1.65e-15	NR	XP_028865997.1	189622	g8780	i0	38.7	0.98813056379822	111	61	92.6	2	19	330	29	139	XP_028865997.1 translationally-controlled tumor protein [Babesia ovata]	diamond	333	78.6	1	Eukaryota	Sar	Apicomplexa	Aconoidasida	Piroplasmida	Babesiidae	Babesia	Babesia ovata
32680653	32680653	PRJNA950981_P_NODE_2620_length_589_cov_3.437984_g2447_i0	PRJNA950981	2620	589	3.437984	20.24972576	Cyclospora cayetanensis	88456	SAR_Eukaryotes	SAR_Eukaryotes	207	4.5700000000000006e-64	NR	OEH76901.1	88456	g2447	i0	60.7	3.63667232597623	183	72	93.2	0	588	40	29	211	OEH76901.1 ribosomal protein rpl19 [Cyclospora cayetanensis]	diamond	2142	207	1	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);;