metadata: contig_metadata: 13 rows where analysis = "blastn", bioproject = "PRJNA683669" and tax

13 rows where analysis = "blastn", bioproject = "PRJNA683669" 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
665015	665015	PRJNA683669_P_NODE_32281_length_243_cov_0.905882_g32049_i0	PRJNA683669	32281	243	0.905882	2.20129326	Plasmodium malariae	5858	SAR_Eukaryotes	SAR_Eukaryotes	63.9	1.01e-5	NTclustered	gi\|1624469197\|ref\|XM_029008392.1\|	5858	g32049	i0	82.192	2.48559670781893	73	13	30	0	154	226	1861	1933	Plasmodium malariae conserved Plasmodium protein, unknown function (PmUG01_14079400), partial mRNA	blastn	604	63.9	1	Eukaryota	Sar	Apicomplexa	Aconoidasida	Haemosporida	Plasmodiidae	Plasmodium	Plasmodium malariae
1940946	1940946	PRJNA683669_P_NODE_23442_length_267_cov_1.587629_g23210_i0	PRJNA683669	23442	267	1.587629	4.23896943	Besnoitia besnoiti	94643	SAR_Eukaryotes	SAR_Eukaryotes	65.8	3.14e-6	NTclustered	gi\|1673115281\|ref\|XM_029362947.1\|	94643	g23210	i0	84.615	0.243445692883895	65	10	24	0	141	205	3341	3277	Besnoitia besnoiti Pumilio-family RNA binding repeat-containing protein (BESB_044960), partial mRNA	blastn	65	65.8	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Sarcocystidae	Besnoitia	Besnoitia besnoiti
2450138	2450138	PRJNA683669_P_NODE_16622_length_318_cov_0.942857_g16391_i0	PRJNA683669	16622	318	0.942857	2.99828526	Plasmodium	5820	SAR_Eukaryotes	SAR_Eukaryotes	263	1.26e-65	NTclustered	gi\|17028074\|gb\|L40815.1\|PFAHSP70	5821	g16391	i0	81.847	70.9842767295598	314	55	98	1	3	314	1969	2282	Plasmodium berghei heat shock protein 70 (hsp70) gene, complete cds	blastn	22573	263	1	Eukaryota	Sar	Apicomplexa	Aconoidasida	Haemosporida	Plasmodiidae	Plasmodium	Plasmodium berghei
7043667	7043667	PRJNA683669_P_NODE_28206_length_248_cov_1.542857_g27974_i0	PRJNA683669	28206	248	1.542857	3.82628536	Plasmodium reichenowi	5854	SAR_Eukaryotes	SAR_Eukaryotes	52.8	0.022	NTclustered	gi\|1145260929\|ref\|XM_012908485.2\|	5854	g27974	i0	100	0.112903225806452	28	0	11	0	58	85	582	555	Plasmodium reichenowi eukaryotic translation initiation factor 3 subunit 8, putative partial mRNA	blastn	28	52.8	1	Eukaryota	Sar	Apicomplexa	Aconoidasida	Haemosporida	Plasmodiidae	Plasmodium	Plasmodium reichenowi
8318096	8318096	PRJNA683669_P_NODE_18807_length_298_cov_1.013333_g18575_i0	PRJNA683669	18807	298	1.013333	3.01973234	Plasmodium knowlesi	5850	SAR_Eukaryotes	SAR_Eukaryotes	52.8	0.028	NTclustered	gi\|1976645069\|ref\|XM_002257463.2\|	5851	g18575	i0	100	0.0939597315436242	28	0	9	0	59	86	10	37	Plasmodium knowlesi strain H SICAvar, type I (fragment) (PKNH_0100300), partial mRNA	blastn	28	52.8	1	Eukaryota	Sar	Apicomplexa	Aconoidasida	Haemosporida	Plasmodiidae	Plasmodium	Plasmodium knowlesi
9593500	9593500	PRJNA683669_P_NODE_12768_length_362_cov_1.065744_g12537_i0	PRJNA683669	12768	362	1.065744	3.85799328	Eimeria maxima	5804	SAR_Eukaryotes	SAR_Eukaryotes	63.9	1.59e-5	NTclustered	gi\|915135556\|ref\|XM_013480917.1\|	5804	g12537	i0	100	0.187845303867403	34	0	9	0	303	336	1011	978	Eimeria maxima hypothetical protein, conserved partial mRNA	blastn	68	63.9	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Eimeriidae	Eimeria	Eimeria maxima
13418991	13418991	PRJNA683669_P_NODE_3131_length_742_cov_1.361734_g2922_i0	PRJNA683669	3131	742	1.361734	10.10406628	Besnoitia besnoiti	94643	SAR_Eukaryotes	SAR_Eukaryotes	455	4.8500000000000006e-123	NTclustered	gi\|1673126454\|ref\|XM_029361296.1\|	94643	g2922	i0	84.222	65.05525606469	469	72	63	2	114	581	468	1	Besnoitia besnoiti putative elongation factor 1-alpha (EF-1-ALPHA) (BESB_026160), partial mRNA	blastn	48271	455	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Sarcocystidae	Besnoitia	Besnoitia besnoiti
18517200	18517200	PRJNA683669_P_NODE_9775_length_410_cov_1.195846_g9544_i0	PRJNA683669	9775	410	1.195846	4.9029686	Cystoisospora suis	483139	SAR_Eukaryotes	SAR_Eukaryotes	311	5.88e-80	NTclustered	gi\|2795629584\|ref\|XM_068068822.1\|	483139	g9544	i0	82.997	74.4878048780488	347	55	84	4	7	351	1266	1610	Cystoisospora suis tubulin alpha chain (CSUI_008696), mRNA	blastn	30540	311	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Sarcocystidae	Cystoisospora	Cystoisospora suis
21577182	21577182	PRJNA683669_P_NODE_9717_length_411_cov_1.233728_g9486_i0	PRJNA683669	9717	411	1.233728	5.07062208	Eimeria	5800	SAR_Eukaryotes	SAR_Eukaryotes	52.8	0.039	NTclustered	gi\|916418939\|ref\|XM_013375247.1\|	5802	g9486	i0	94.286	0.289537712895377	35	1	8	1	145	178	893	927	Eimeria tenella uncharacterized protein (ETH_00036470), partial mRNA	blastn	119	52.8	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Eimeriidae	Eimeria	Eimeria tenella
22342268	22342268	PRJNA683669_P_NODE_25938_length_251_cov_1.297753_g25706_i0	PRJNA683669	25938	251	1.297753	3.25736003	Eimeria necatrix	51315	SAR_Eukaryotes	SAR_Eukaryotes	56.5	0.002	NTclustered	gi\|921128087\|ref\|XM_013583159.1\|	51315	g25706	i0	100	0.119521912350598	30	0	12	0	185	214	6652	6623	Eimeria necatrix hypothetical protein, conserved partial mRNA	blastn	30	56.5	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Eimeriidae	Eimeria	Eimeria necatrix
22342370	22342370	PRJNA683669_P_NODE_7798_length_458_cov_1.392208_g7567_i0	PRJNA683669	7798	458	1.392208	6.37631264	Eimeria tenella	5802	SAR_Eukaryotes	SAR_Eukaryotes	58.4	0.001	NTclustered	gi\|916414351\|ref\|XM_013372953.1\|	5802	g7567	i0	100	0.318777292576419	31	0	7	0	423	453	5267	5237	Eimeria tenella uncharacterized protein (ETH_00027635), partial mRNA	blastn	146	58.4	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Eimeriidae	Eimeria	Eimeria tenella
23617920	23617920	PRJNA683669_P_NODE_3339_length_717_cov_1.776398_g3123_i0	PRJNA683669	3339	717	1.776398	12.73677366	Plasmodium yoelii	5861	SAR_Eukaryotes	SAR_Eukaryotes	126	4.1699999999999996e-24	NTclustered	gi\|82597122\|ref\|XM_721455.1\|	5861	g3123	i0	70.894	2.51464435146443	615	160	84	17	36	640	137	742	Plasmodium yoelii uncharacterized protein (PY17X_0516200), partial mRNA	blastn	1803	126	1	Eukaryota	Sar	Apicomplexa	Aconoidasida	Haemosporida	Plasmodiidae	Plasmodium	Plasmodium yoelii
24891049	24891049	PRJNA683669_P_NODE_16020_length_324_cov_1.179283_g15789_i0	PRJNA683669	16020	324	1.179283	3.82087692	Eimeria tenella	5802	SAR_Eukaryotes	SAR_Eukaryotes	56.5	0.002	NTclustered	gi\|916414713\|ref\|XM_013373134.1\|	5802	g15789	i0	100	0.182098765432099	30	0	9	0	148	177	1096	1067	Eimeria tenella uncharacterized protein (ETH_00027175), partial mRNA	blastn	59	56.5	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Eimeriidae	Eimeria	Eimeria tenella

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