metadata: contig_metadata: 18 rows where analysis = "blastn", bioproject = "PRJNA437204" and tax

18 rows where analysis = "blastn", bioproject = "PRJNA437204" 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
431500	431500	PRJNA437204_P_NODE_101181_length_247_cov_0.885057_g100882_i0	PRJNA437204	101181	247	0.885057	2.18609079	Toxoplasma gondii	5811	SAR_Eukaryotes	SAR_Eukaryotes	453	5.2400000000000005e-123	NTclustered	gi\|1084993388\|ref\|XM_018782422.1\|	508771	g100882	i0	100	2.02024291497976	245	0	99	0	3	247	23046	22802	Toxoplasma gondii ME49 ATG C terminal domain-containing protein partial mRNA	blastn	499	453	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Sarcocystidae	Toxoplasma	Toxoplasma gondii
3641021	3641021	PRJNA437204_P_NODE_62863_length_276_cov_1.512315_g62564_i0	PRJNA437204	62863	276	1.512315	4.1739894	Toxoplasma	5810	SAR_Eukaryotes	SAR_Eukaryotes	510	3.48e-140	NTclustered	gi\|260232132\|dbj\|AK318131.1\|	5811	g62564	i0	100	5.40579710144928	276	0	100	0	1	276	297	22	Toxoplasma gondii cDNA, clone: XTG04081.2, full cDNA, XTG Sugano cDNA library	blastn	1492	510	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Sarcocystidae	Toxoplasma	Toxoplasma gondii
4258538	4258538	PRJNA437204_P_NODE_101344_length_247_cov_0.885057_g101045_i0	PRJNA437204	101344	247	0.885057	2.18609079	Toxoplasma gondii	5811	SAR_Eukaryotes	SAR_Eukaryotes	451	1.88e-122	NTclustered	gi\|820699808\|tpe\|LN714499.1\|	432359	g101045	i0	99.595	1.83400809716599	247	1	100	0	1	247	5254999	5254753	TPA_asm: Toxoplasma gondii VEG, chromosome chrIX, complete genome	blastn	453	451	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Sarcocystidae	Toxoplasma	Toxoplasma gondii
4259458	4259458	PRJNA437204_P_NODE_33924_length_342_cov_1.695167_g33625_i0	PRJNA437204	33924	342	1.695167	5.79747114	Eimeria tenella	5802	SAR_Eukaryotes	SAR_Eukaryotes	54.7	0.009	NTclustered	gi\|916419477\|ref\|XM_013375516.1\|	5802	g33625	i0	100	0.166666666666667	29	0	8	0	117	145	361	389	Eimeria tenella uncharacterized protein (ETH_00033750), partial mRNA	blastn	57	54.7	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Eimeriidae	Eimeria	Eimeria tenella
5537068	5537068	PRJNA437204_P_NODE_81625_length_251_cov_0.865169_g81326_i0	PRJNA437204	81625	251	0.865169	2.17157419	Sarcocystis zamani	137009	SAR_Eukaryotes	SAR_Eukaryotes	108	4.79e-19	NTclustered	gi\|12005306\|gb\|AF237616.1\|AF237616	137009	g81326	i0	86.869	29.0438247011952	99	10	39	3	6	102	1612	1709	Sarcocystis zamani large subunit ribosomal RNA gene, partial sequence	blastn	7290	108	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Sarcocystidae	Sarcocystis	Sarcocystis zamani
9361110	9361110	PRJNA437204_P_NODE_65868_length_271_cov_1.555556_g65569_i0	PRJNA437204	65868	271	1.555556	4.21555676	Toxoplasma gondii	5811	SAR_Eukaryotes	SAR_Eukaryotes	479	9.62e-131	NTclustered	gi\|820696962\|tpe\|LN714494.1\|	432359	g65569	i0	98.524	1.3210332103321	271	4	100	0	1	271	566778	567048	TPA_asm: Toxoplasma gondii VEG, chromosome chrV, complete genome	blastn	358	479	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Sarcocystidae	Toxoplasma	Toxoplasma gondii
11910979	11910979	PRJNA437204_P_NODE_24350_length_383_cov_1.870968_g24051_i0	PRJNA437204	24350	383	1.870968	7.16580744	Besnoitia besnoiti	94643	SAR_Eukaryotes	SAR_Eukaryotes	132	4.56e-26	NTclustered	gi\|1673123994\|ref\|XM_029360740.1\|	94643	g24051	i0	87.719	6.82506527415144	114	12	30	2	15	127	267	379	Besnoitia besnoiti ribosomal-ubiquitin protein RPL40 (BESB_020310), partial mRNA	blastn	2614	132	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Sarcocystidae	Besnoitia	Besnoitia besnoiti
12568158	12568158	PRJNA437204_P_NODE_108590_length_245_cov_0.895349_g108291_i0	PRJNA437204	108590	245	0.895349	2.19360505	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	52.8	0.022	NTclustered	gi\|915129830\|ref\|XM_013479724.1\|	5804	g108291	i0	100	2.65714285714286	28	0	11	0	27	54	1680	1653	Eimeria maxima hypothetical protein, conserved partial mRNA	blastn	651	52.8	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Eimeriidae	Eimeria	Eimeria maxima
15118096	15118096	PRJNA437204_P_NODE_87572_length_250_cov_0.870056_g87273_i0	PRJNA437204	87572	250	0.870056	2.17514	Toxoplasma	5810	SAR_Eukaryotes	SAR_Eukaryotes	462	8.83e-126	NTclustered	gi\|260326415\|dbj\|AK318027.1\|	5811	g87273	i0	100	3	250	0	100	0	1	250	1177	928	Toxoplasma gondii cDNA, clone: XTG06762.2, full cDNA, XTG Sugano cDNA library	blastn	750	462	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Sarcocystidae	Toxoplasma	Toxoplasma gondii
18283107	18283107	PRJNA437204_P_NODE_100975_length_247_cov_0.885057_g100676_i0	PRJNA437204	100975	247	0.885057	2.18609079	Besnoitia besnoiti	94643	SAR_Eukaryotes	SAR_Eukaryotes	183	7.59e-42	NTclustered	gi\|1673123994\|ref\|XM_029360740.1\|	94643	g100676	i0	80.579	49.2429149797571	242	44	98	3	1	241	149	388	Besnoitia besnoiti ribosomal-ubiquitin protein RPL40 (BESB_020310), partial mRNA	blastn	12163	183	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Sarcocystidae	Besnoitia	Besnoitia besnoiti
18283522	18283522	PRJNA437204_P_NODE_122715_length_242_cov_0.911243_g122416_i0	PRJNA437204	122715	242	0.911243	2.20520806	Toxoplasma gondii	5811	SAR_Eukaryotes	SAR_Eukaryotes	448	2.3799999999999995e-121	NTclustered	gi\|1084989028\|ref\|XM_002366895.2\|	508771	g122416	i0	100	2	242	0	100	0	1	242	9682	9441	Toxoplasma gondii ME49 hypothetical protein mRNA	blastn	484	448	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Sarcocystidae	Toxoplasma	Toxoplasma gondii
18941770	18941770	PRJNA437204_P_NODE_96675_length_248_cov_0.880000_g96376_i0	PRJNA437204	96675	248	0.88	2.1824	Toxoplasma	5810	SAR_Eukaryotes	SAR_Eukaryotes	459	1.13e-124	NTclustered	gi\|260323689\|dbj\|AK317802.1\|	5811	g96376	i0	100	3	248	0	100	0	1	248	676	429	Toxoplasma gondii cDNA, clone: XTG01934.2, full cDNA, XTG Sugano cDNA library	blastn	744	459	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Sarcocystidae	Toxoplasma	Toxoplasma gondii
19557705	19557705	PRJNA437204_P_NODE_118336_length_243_cov_0.905882_g118037_i0	PRJNA437204	118336	243	0.905882	2.20129326	Toxoplasma gondii	5811	SAR_Eukaryotes	SAR_Eukaryotes	438	1.4399999999999996e-118	NTclustered	gi\|820702250\|tpe\|LN714502.1\|	432359	g118037	i0	99.177	1.37037037037037	243	2	100	0	1	243	1826027	1826269	TPA_asm: Toxoplasma gondii VEG, chromosome chrXII, complete genome	blastn	333	438	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Sarcocystidae	Toxoplasma	Toxoplasma gondii
20215648	20215648	PRJNA437204_P_NODE_127836_length_241_cov_0.916667_g127537_i0	PRJNA437204	127836	241	0.916667	2.20916747	Toxoplasma	5810	SAR_Eukaryotes	SAR_Eukaryotes	444	3.06e-120	NTclustered	gi\|397562555\|gb\|JX045422.1\|	5811	g127537	i0	100	89.746887966805	240	0	99	0	2	241	1365	1126	Toxoplasma gondii strain CTG actin gene, complete cds	blastn	21629	444	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Sarcocystidae	Toxoplasma	Toxoplasma gondii
20835039	20835039	PRJNA437204_P_NODE_82097_length_251_cov_0.865169_g81798_i0	PRJNA437204	82097	251	0.865169	2.17157419	Toxoplasma gondii	5811	SAR_Eukaryotes	SAR_Eukaryotes	464	2.47e-126	NTclustered	gi\|1084900229\|ref\|XM_002371668.2\|	508771	g81798	i0	100	3	251	0	100	0	1	251	1387	1637	Toxoplasma gondii ME49 hypothetical protein mRNA	blastn	753	464	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Sarcocystidae	Toxoplasma	Toxoplasma gondii
20835329	20835329	PRJNA437204_P_NODE_96597_length_248_cov_0.880000_g96298_i0	PRJNA437204	96597	248	0.88	2.1824	Toxoplasma gondii	5811	SAR_Eukaryotes	SAR_Eukaryotes	453	5.2600000000000005e-123	NTclustered	gi\|1084937653\|ref\|XM_018779541.1\|	508771	g96298	i0	99.597	2.00403225806452	248	1	100	0	1	248	4356	4603	Toxoplasma gondii ME49 hypothetical protein mRNA	blastn	497	453	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Sarcocystidae	Toxoplasma	Toxoplasma gondii
22109197	22109197	PRJNA437204_P_NODE_41918_length_319_cov_1.540650_g41619_i0	PRJNA437204	41918	319	1.54065	4.9146735	Eimeria tenella	5802	SAR_Eukaryotes	SAR_Eukaryotes	117	1.05e-21	NTclustered	gi\|916418543\|ref\|XM_013375049.1\|	5802	g41619	i0	89.362	4.30094043887147	94	8	29	2	211	303	254	162	Eimeria tenella 40S ribosomal protein S17, putative (ETH_00024690), partial mRNA	blastn	1372	117	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Eimeriidae	Eimeria	Eimeria tenella
23385536	23385536	PRJNA437204_P_NODE_81359_length_251_cov_0.865169_g81060_i0	PRJNA437204	81359	251	0.865169	2.17157419	Toxoplasma gondii	5811	SAR_Eukaryotes	SAR_Eukaryotes	459	1.1499999999999996e-124	NTclustered	gi\|820698309\|tpe\|LN714497.1\|	432359	g81060	i0	99.602	1.41035856573705	251	1	100	0	1	251	814106	813856	TPA_asm: Toxoplasma gondii VEG, chromosome chrVIIb, complete genome	blastn	354	459	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Sarcocystidae	Toxoplasma	Toxoplasma gondii

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