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

5 rows where bioproject = "PRJEB12296", 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
8638732	8638732	PRJEB12296_P_NODE_7_length_660_cov_2421.206022_g6_i0	PRJEB12296	7	660	2421.206022	15979.9597452	Eucoccidiorida	75739	SAR_Eukaryotes	SAR_Eukaryotes	204	1.7099999999999998e-47	NTclustered	gi\|8927036\|gb\|AF076872.1\|AF076872	482539	g6	i0	92.308	21.7136363636364	143	11	22	0	477	619	432	574	Isospora felis large subunit ribosomal RNA gene, partial sequence	blastn	14331	204	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Sarcocystidae	Cystoisospora	Cystoisospora felis
26151346	26151346	PRJEB12296_S_NODE_821_length_387_cov_193.340909_g790_i0	PRJEB12296	821	387	193.340909	748.22931783	Eucoccidiorida	75739	SAR_Eukaryotes	SAR_Eukaryotes	207	7.45e-49	NTclustered	gi\|8927036\|gb\|AF076872.1\|AF076872	482539	g790	i0	91.892	38.3229974160207	148	12	38	0	2	149	579	432	Isospora felis large subunit ribosomal RNA gene, partial sequence	blastn	14831	207	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Sarcocystidae	Cystoisospora	Cystoisospora felis
26181283	26181283	PRJEB12296_S_NODE_6478_length_194_cov_117.823899_g6446_i0	PRJEB12296	6478	194	117.823899	228.57836406	Hepatozoon canis	110120	SAR_Eukaryotes	SAR_Eukaryotes	139	1.25e-28	NTclustered	gi\|1584069862\|gb\|MH615006.1\|	110120	g6446	i0	86.923	41.8144329896907	130	9	65	8	60	186	2227	2351	Hepatozoon canis isolate 9992 18S small subunit ribosomal RNA gene, internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, and 28S large subunit ribosomal RNA gene, complete sequence	blastn	8112	139	1	Eukaryota	Sar	Apicomplexa			Hepatozoidae	Hepatozoon	Hepatozoon canis
26316930	26316930	PRJEB12296_S_NODE_335_length_511_cov_378.033613_g308_i0	PRJEB12296	335	511	378.033613	1931.75176243	Eimeria paludosa	1497015	SAR_Eukaryotes	SAR_Eukaryotes	104	1.36e-17	NTclustered	gi\|653601277\|gb\|KJ767188.1\|	1497015	g308	i0	88.043	4.54990215264188	92	6	18	5	65	155	330	243	Eimeria paludosa isolate DMH01 28S ribosomal RNA gene, partial sequence	blastn	2325	104	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Eimeriidae	Eimeria	Eimeria paludosa
26453221	26453221	PRJEB12296_S_NODE_3768_length_234_cov_1780.055276_g3736_i0	PRJEB12296	3768	234	1780.055276	4165.32934584	Platyproteum noduliferae	2903131	SAR_Eukaryotes	SAR_Eukaryotes	73.1	1.61e-8	NTclustered	gi\|2250018225\|dbj\|LC663666.1\|	2903131	g3736	i0	97.619	0.179487179487179	42	1	18	0	51	92	3299	3340	Platyproteum noduliferae P1 genes for 18S rRNA, ITS1, 5.8S rRNA, ITS2, 28S rRNA, partial and complete sequence	blastn	42	73.1	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Archigregarinorida	Selenidiidae	Platyproteum	Platyproteum noduliferae

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