metadata: contig_metadata: 9 rows where analysis = "blastn", bioproject = "PRJNA1115053" and tax

9 rows where analysis = "blastn", bioproject = "PRJNA1115053" 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
5330480	5330480	PRJNA1115053_S_NODE_320205_length_156_cov_1.699115_g318388_i0	PRJNA1115053	320205	156	1.699115	2.6506194	Eimeria acervulina	5801	SAR_Eukaryotes	SAR_Eukaryotes	52.8	0.013	NTclustered	gi\|915003695\|ref\|XM_013393730.1\|	5801	g318388	i0	96.875	0.205128205128205	32	0	20	1	35	65	229	260	Eimeria acervulina hypothetical protein, conserved partial mRNA	blastn	32	52.8	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Eimeriidae	Eimeria	Eimeria acervulina
5331978	5331978	PRJNA1115053_S_NODE_60265_length_314_cov_5.003690_g58448_i0	PRJNA1115053	60265	314	5.00369	15.7115866	Babesia ovata	189622	SAR_Eukaryotes	SAR_Eukaryotes	508	1.45e-139	NTclustered	gi\|1624698156\|ref\|XM_029013946.1\|	189622	g58448	i0	96.178	37.1019108280255	314	7	100	4	1	314	193	501	Babesia ovata CTP synthase, putative (BOVATA_050290), partial mRNA	blastn	11650	508	1	Eukaryota	Sar	Apicomplexa	Aconoidasida	Piroplasmida	Babesiidae	Babesia	Babesia ovata
6601111	6601111	PRJNA1115053_S_NODE_126586_length_235_cov_8.661458_g124769_i0	PRJNA1115053	126586	235	8.661458	20.3544263	Babesia ovata	189622	SAR_Eukaryotes	SAR_Eukaryotes	387	5.08e-103	NTclustered	gi\|1624698156\|ref\|XM_029013946.1\|	189622	g124769	i0	96.596	35.5446808510638	235	5	100	2	1	235	333	102	Babesia ovata CTP synthase, putative (BOVATA_050290), partial mRNA	blastn	8353	387	1	Eukaryota	Sar	Apicomplexa	Aconoidasida	Piroplasmida	Babesiidae	Babesia	Babesia ovata
9150950	9150950	PRJNA1115053_S_NODE_13528_length_527_cov_1788.493802_g11795_i0	PRJNA1115053	13528	527	1788.493802	9425.36233654	Plasmodium berghei	5821	SAR_Eukaryotes	SAR_Eukaryotes	451	4.36e-122	NTclustered	gi\|27764590\|gb\|AY180902.1\|	5821	g11795	i0	100	80.111954459203	244	0	81	0	51	294	928	685	Plasmodium berghei 31 kDa antigen mRNA, complete cds	blastn	42219	451	1	Eukaryota	Sar	Apicomplexa	Aconoidasida	Haemosporida	Plasmodiidae	Plasmodium	Plasmodium berghei
15051823	15051823	PRJNA1115053_S_NODE_115112_length_245_cov_1.425743_g113295_i0	PRJNA1115053	115112	245	1.425743	3.49307035	Plasmodium	5820	SAR_Eukaryotes	SAR_Eukaryotes	58.4	4.75e-4	NTclustered	gi\|1084780983\|ref\|XM_018784089.1\|	647221	g113295	i0	92.683	0.33469387755102	41	2	17	1	26	66	2523	2484	Plasmodium gaboni hypothetical protein partial mRNA	blastn	82	58.4	1	Eukaryota	Sar	Apicomplexa	Aconoidasida	Haemosporida	Plasmodiidae	Plasmodium	Plasmodium gaboni
20624889	20624889	PRJNA1115053_S_NODE_157857_length_215_cov_1.093023_g156040_i0	PRJNA1115053	157857	215	1.093023	2.34999945	Plasmodium berghei	5821	SAR_Eukaryotes	SAR_Eukaryotes	52.8	0.019	NTclustered	gi\|1843571751\|ref\|XM_034565646.1\|	5823	g156040	i0	100	0.130232558139535	28	0	13	0	76	103	1226	1253	Plasmodium berghei ANKA conserved Plasmodium protein, unknown function (PBANKA_1111500), partial mRNA	blastn	28	52.8	1	Eukaryota	Sar	Apicomplexa	Aconoidasida	Haemosporida	Plasmodiidae	Plasmodium	Plasmodium berghei
20630663	20630663	PRJNA1115053_S_NODE_83197_length_278_cov_8.744681_g81380_i0	PRJNA1115053	83197	278	8.744681	24.31021318	Cryptosporidium parvum	5807	SAR_Eukaryotes	SAR_Eukaryotes	158	5.2699999999999985e-34	NTclustered	gi\|2560612139\|gb\|OR419798.1\|	5807	g81380	i0	84.118	65.6870503597122	170	20	60	6	1	168	4280	4116	Cryptosporidium parvum small subunit ribosomal RNA gene, internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence	blastn	18261	158	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Cryptosporidiidae	Cryptosporidium	Cryptosporidium parvum
22701635	22701635	PRJNA1115053_S_NODE_66778_length_302_cov_96.853282_g64961_i0	PRJNA1115053	66778	302	96.853282	292.49691164	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	481	3.03e-131	NTclustered	gi\|833494855\|ref\|XM_012915027.1\|	5866	g64961	i0	95.364	1196.37748344371	302	14	100	0	1	302	121	422	Babesia bigemina hypothetical protein, conserved partial mRNA	blastn	361306	481	1	Eukaryota	Sar	Apicomplexa	Aconoidasida	Piroplasmida	Babesiidae	Babesia	Babesia bigemina
23177590	23177590	PRJNA1115053_S_NODE_221099_length_185_cov_2.704225_g219282_i0	PRJNA1115053	221099	185	2.704225	5.00281625	Theileria equi	5872	SAR_Eukaryotes	SAR_Eukaryotes	52.8	0.016	NTclustered	gi\|510899745\|ref\|XM_004828559.1\|	1537102	g219282	i0	94.286	0.189189189189189	35	1	19	1	18	52	411	378	Theileria equi strain WA hypothetical protein (BEWA_017910), partial mRNA	blastn	35	52.8	1	Eukaryota	Sar	Apicomplexa	Aconoidasida	Piroplasmida	Theileriidae	Theileria	Theileria equi

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