metadata: contig_metadata: 12 rows where analysis = "blastn", bioproject = "PRJNA534016" and tax

12 rows where analysis = "blastn", bioproject = "PRJNA534016" 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
5611379	5611379	PRJNA534016_P_NODE_705_length_974_cov_2.341842_g633_i0	PRJNA534016	705	974	2.341842	22.80954108	Besnoitia besnoiti	94643	SAR_Eukaryotes	SAR_Eukaryotes	224	1.98e-53	NTclustered	gi\|1673119459\|ref\|XM_029365174.1\|	94643	g633	i0	78.592	1.7258726899384	341	71	35	2	556	895	340	1	Besnoitia besnoiti putative translation initiation factor SUI1 (BESB_067810), partial mRNA	blastn	1681	224	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Sarcocystidae	Besnoitia	Besnoitia besnoiti
9435757	9435757	PRJNA534016_P_NODE_13108_length_254_cov_3.364641_g13018_i0	PRJNA534016	13108	254	3.364641	8.54618814	Goussia balatonica	947538	SAR_Eukaryotes	SAR_Eukaryotes	433	7.05e-117	NTclustered	gi\|324022100\|gb\|GU593717.1\|	947538	g13018	i0	97.244	100.968503937008	254	7	100	0	1	254	1733	1986	Goussia balatonica strain 608 28S ribosomal RNA gene, partial sequence	blastn	25646	433	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Eimeriidae	Goussia	Goussia balatonica
9435868	9435868	PRJNA534016_P_NODE_4368_length_395_cov_1.788820_g4278_i0	PRJNA534016	4368	395	1.78882	7.065839	Eimeria mitis	44415	SAR_Eukaryotes	SAR_Eukaryotes	52.8	0.038	NTclustered	gi\|916503294\|ref\|XM_013496944.1\|	44415	g4278	i0	100	0.0708860759493671	28	0	7	0	295	322	5454	5481	Eimeria mitis uncharacterized protein (EMH_0004830), partial mRNA	blastn	28	52.8	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Eimeriidae	Eimeria	Eimeria mitis
10711578	10711578	PRJNA534016_P_NODE_19169_length_226_cov_2.516340_g19079_i0	PRJNA534016	19169	226	2.51634	5.6869284	Goussia sp. BMR-2011c	980545	SAR_Eukaryotes	SAR_Eukaryotes	385	1.75e-102	NTclustered	gi\|328460764\|gb\|GU479639.1\|	980545	g19079	i0	97.345	99.8141592920354	226	6	100	0	1	226	8	233	Goussia sp. BMR-2011c isolate GCAR812-#812 18S ribosomal RNA gene, partial sequence	blastn	22558	385	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Eimeriidae	Goussia	Goussia sp. BMR-2011c
12597259	12597259	PRJNA534016_P_NODE_210_length_1576_cov_9.371257_g186_i0	PRJNA534016	210	1576	9.371257	147.69101032	Toxoplasma	5810	SAR_Eukaryotes	SAR_Eukaryotes	881	0	NTclustered	gi\|260323703\|dbj\|AK317816.1\|	5811	g186	i0	78.702	46.5374365482233	1371	257	86	27	107	1461	1582	231	Toxoplasma gondii cDNA, clone: XTG00910.2, full cDNA, XTG Sugano cDNA library	blastn	73343	881	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Sarcocystidae	Toxoplasma	Toxoplasma gondii
19633631	19633631	PRJNA534016_P_NODE_2816_length_487_cov_2.768116_g2726_i0	PRJNA534016	2816	487	2.768116	13.48072492	Goussia bayae	2303416	SAR_Eukaryotes	SAR_Eukaryotes	516	1.4e-141	NTclustered	gi\|1450318675\|gb\|MH758782.1\|	2303416	g2726	i0	89.563	83.4004106776181	412	36	84	7	1	408	26	434	Goussia bayae isolate Choptank large subunit ribosomal RNA gene, partial sequence	blastn	40616	516	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Eimeriidae	Goussia	Goussia bayae
20909518	20909518	PRJNA534016_P_NODE_16717_length_244_cov_2.064327_g16627_i0	PRJNA534016	16717	244	2.064327	5.03695788	Plasmodium gallinaceum	5849	SAR_Eukaryotes	SAR_Eukaryotes	159	1.2599999999999999e-34	NTclustered	gi\|1620130521\|ref\|XM_028673620.1\|	5849	g16627	i0	79.556	62.6147540983607	225	44	92	2	16	239	4717	4940	Plasmodium gallinaceum chromodomain-helicase-DNA-binding protein 1 homolog, putative (CHD1), partial mRNA	blastn	15278	159	1	Eukaryota	Sar	Apicomplexa	Aconoidasida	Haemosporida	Plasmodiidae	Plasmodium	Plasmodium gallinaceum
20909545	20909545	PRJNA534016_P_NODE_18617_length_238_cov_2.800000_g18527_i0	PRJNA534016	18617	238	2.8	6.664	Caryospora bigenetica	86281	SAR_Eukaryotes	SAR_Eukaryotes	259	1.17e-64	NTclustered	gi\|794450787\|gb\|KP658102.1\|	86281	g18527	i0	86.441	95.2436974789916	236	32	99	0	1	236	443	678	Caryospora bigenetica voucher C_bigenetica_MTZ_07-12108 mitochondrion, complete genome	blastn	22668	259	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Eimeriidae	Caryospora	Caryospora bigenetica
23459722	23459722	PRJNA534016_P_NODE_16939_length_244_cov_0.900585_g16849_i0	PRJNA534016	16939	244	0.900585	2.1974274	Eimeria acervulina	5801	SAR_Eukaryotes	SAR_Eukaryotes	56.5	0.002	NTclustered	gi\|914996646\|ref\|XM_013391567.1\|	5801	g16849	i0	100	2.65573770491803	30	0	12	0	144	173	718	689	Eimeria acervulina hypothetical protein partial mRNA	blastn	648	56.5	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Eimeriidae	Eimeria	Eimeria acervulina
24733481	24733481	PRJNA534016_P_NODE_3160_length_459_cov_2.468912_g3070_i0	PRJNA534016	3160	459	2.468912	11.33230608	Cryptosporidium parvum	5807	SAR_Eukaryotes	SAR_Eukaryotes	272	3.1399999999999998e-68	NTclustered	gi\|126649276\|ref\|XM_001388273.1\|	353152	g3070	i0	80.27	8.32244008714597	370	66	80	5	87	452	112	478	Cryptosporidium parvum Iowa II ribosomal protein S23 (cgd6_1390) mRNA, partial cds	blastn	3820	272	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Cryptosporidiidae	Cryptosporidium	Cryptosporidium parvum
24733482	24733482	PRJNA534016_P_NODE_3240_length_453_cov_1.663158_g3150_i0	PRJNA534016	3240	453	1.663158	7.53410574	Eimeria necatrix	51315	SAR_Eukaryotes	SAR_Eukaryotes	302	3.95e-77	NTclustered	gi\|921119883\|ref\|XM_013579106.1\|	51315	g3150	i0	82.336	0.774834437086093	351	58	77	4	30	378	1372	1720	Eimeria necatrix sortilin, putative partial mRNA	blastn	351	302	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Eimeriidae	Eimeria	Eimeria necatrix
24733487	24733487	PRJNA534016_P_NODE_3660_length_429_cov_1.294944_g3570_i0	PRJNA534016	3660	429	1.294944	5.55530976	Eimeria sp.	1729940	SAR_Eukaryotes	SAR_Eukaryotes	383	1.2899999999999998e-101	NTclustered	gi\|1086927510\|gb\|KX094956.1\|	1729940	g3570	i0	82.91	61.1818181818182	433	66	100	8	1	429	1799	1371	Eimeria sp. strain OTU-Z2 mitochondrion, complete genome	blastn	26247	383	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Eimeriidae	Eimeria	Eimeria sp.

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