metadata: contig_metadata: 7 rows where analysis = "blastn", bioproject = "PRJNA670521" and tax

7 rows where analysis = "blastn", bioproject = "PRJNA670521" 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
3189038	3189038	PRJNA670521_P_NODE_44083_length_311_cov_1.605042_g43338_i0	PRJNA670521	44083	311	1.605042	4.99168062	uncultured Eimeriidae	404735	SAR_Eukaryotes	SAR_Eukaryotes	531	3.06e-146	NTclustered	gi\|134022621\|gb\|EF023971.1\|	404735	g43338	i0	97.428	68.8617363344052	311	8	100	0	1	311	687	997	Eimeriidae environmental sample clone Amb_18S_1440 18S ribosomal RNA gene, partial sequence	blastn	21416	531	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Eimeriidae		uncultured Eimeriidae
6268853	6268853	PRJNA670521_P_NODE_67845_length_256_cov_0.934426_g67100_i0	PRJNA670521	67845	256	0.934426	2.39213056	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	407	4.31e-109	NTclustered	gi\|833494855\|ref\|XM_012915027.1\|	5866	g67100	i0	95.331	1134.17578125	257	11	100	1	1	256	390	134	Babesia bigemina hypothetical protein, conserved partial mRNA	blastn	290349	407	1	Eukaryota	Sar	Apicomplexa	Aconoidasida	Piroplasmida	Babesiidae	Babesia	Babesia bigemina
14667399	14667399	PRJNA670521_P_NODE_82992_length_245_cov_1.220930_g82247_i0	PRJNA670521	82992	245	1.22093	2.9912785	Plasmodium falciparum	5833	SAR_Eukaryotes	SAR_Eukaryotes	62.1	3.67e-5	NTclustered	gi\|258597912\|ref\|XM_001348775.2\|	36329	g82247	i0	100	12.0489795918367	33	0	13	0	97	129	3641	3609	Plasmodium falciparum 3D7 conserved Plasmodium protein, unknown function (PF3D7_1466900), partial mRNA	blastn	2952	62.1	1	Eukaryota	Sar	Apicomplexa	Aconoidasida	Haemosporida	Plasmodiidae	Plasmodium	Plasmodium falciparum
15941024	15941024	PRJNA670521_P_NODE_65293_length_261_cov_1.515957_g64548_i0	PRJNA670521	65293	261	1.515957	3.95664777	Eimeria tenella	5802	SAR_Eukaryotes	SAR_Eukaryotes	132	2.97e-26	NTclustered	gi\|13774514\|gb\|AF353515.1\|	5802	g64548	i0	82.237	24.1340996168582	152	27	58	0	1	152	1042	891	Eimeria tenella enolase mRNA, complete cds	blastn	6299	132	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Eimeriidae	Eimeria	Eimeria tenella
15941200	15941200	PRJNA670521_P_NODE_85473_length_244_cov_0.900585_g84728_i0	PRJNA670521	85473	244	0.900585	2.1974274	Eimeria bovis	5803	SAR_Eukaryotes	SAR_Eukaryotes	60.2	1.32e-4	NTclustered	gi\|228205225\|gb\|FJ873129.1\|	5803	g84728	i0	91.304	2.09426229508197	46	1	18	3	73	117	140	97	Eimeria bovis calmodulin domain protein kinase (CDPK) gene, partial cds	blastn	511	60.2	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Eimeriidae	Eimeria	Eimeria bovis
17216472	17216472	PRJNA670521_P_NODE_92174_length_241_cov_0.916667_g91429_i0	PRJNA670521	92174	241	0.916667	2.20916747	Toxoplasma gondii	5811	SAR_Eukaryotes	SAR_Eukaryotes	58.4	4.66e-4	NTclustered	gi\|820700576\|tpe\|LN714500.1\|	432359	g91429	i0	90.698	0.178423236514523	43	4	18	0	135	177	7083899	7083941	TPA_asm: Toxoplasma gondii VEG, chromosome chrX, complete genome	blastn	43	58.4	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Sarcocystidae	Toxoplasma	Toxoplasma gondii
19764994	19764994	PRJNA670521_P_NODE_26116_length_380_cov_0.801303_g25372_i0	PRJNA670521	26116	380	0.801303	3.0449514	Plasmodium chabaudi	5825	SAR_Eukaryotes	SAR_Eukaryotes	235	3.3499999999999997e-57	NTclustered	gi\|1027948394\|ref\|XM_016798018.1\|	31271	g25372	i0	81.786	19.9394736842105	280	51	74	0	91	370	108	387	Plasmodium chabaudi chabaudi histone H3, putative (PCHAS_0109400), partial mRNA	blastn	7577	235	1	Eukaryota	Sar	Apicomplexa	Aconoidasida	Haemosporida	Plasmodiidae	Plasmodium	Plasmodium chabaudi

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