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

9 rows where analysis = "blastn", bioproject = "PRJNA431371" 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
3639068	3639068	PRJNA431371_P_NODE_24263_length_254_cov_0.839779_g24190_i0	PRJNA431371	24263	254	0.839779	2.13303866	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	370	5.61e-98	NTclustered	gi\|833494855\|ref\|XM_012915027.1\|	5866	g24190	i0	92.941	697.232283464567	255	16	100	2	1	254	435	182	Babesia bigemina hypothetical protein, conserved partial mRNA	blastn	177097	370	1	Eukaryota	Sar	Apicomplexa	Aconoidasida	Piroplasmida	Babesiidae	Babesia	Babesia bigemina
4916205	4916205	PRJNA431371_P_NODE_4924_length_536_cov_1.829374_g4851_i0	PRJNA431371	4924	536	1.829374	9.80544464	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	69.4	5.23e-7	NTclustered	gi\|1145262560\|ref\|XM_012909437.2\|	5854	g4851	i0	97.561	10.1399253731343	41	0	7	1	384	423	1612	1652	Plasmodium reichenowi hypothetical protein partial mRNA	blastn	5435	69.4	1	Eukaryota	Sar	Apicomplexa	Aconoidasida	Haemosporida	Plasmodiidae	Plasmodium	Plasmodium reichenowi
6805760	6805760	PRJNA431371_P_NODE_13926_length_340_cov_2.314607_g13853_i0	PRJNA431371	13926	340	2.314607	7.8696638	Toxoplasma gondii	5811	SAR_Eukaryotes	SAR_Eukaryotes	169	3.0599999999999995e-37	NTclustered	gi\|237837590\|ref\|XM_002368052.1\|	508771	g13853	i0	85.987	12.9323529411765	157	22	46	0	184	340	573	417	Toxoplasma gondii ME49 ribosomal protein RPL30 (RPL30), mRNA	blastn	4397	169	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Sarcocystidae	Toxoplasma	Toxoplasma gondii
9356304	9356304	PRJNA431371_P_NODE_20528_length_282_cov_1.440191_g20455_i0	PRJNA431371	20528	282	1.440191	4.06133862	Babesia caballi	5871	SAR_Eukaryotes	SAR_Eukaryotes	132	3.25e-26	NTclustered	gi\|2794952797\|ref\|XM_067862068.1\|	5871	g20455	i0	79	16.2269503546099	200	36	70	4	1	197	262	458	Babesia caballi 60S ribosomal protein L11a, putative (BcabD6B2_55360), partial mRNA	blastn	4576	132	1	Eukaryota	Sar	Apicomplexa	Aconoidasida	Piroplasmida	Babesiidae	Babesia	Babesia caballi
12566938	12566938	PRJNA431371_P_NODE_9430_length_406_cov_0.717718_g9357_i0	PRJNA431371	9430	406	0.717718	2.91393508	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	601	3.0799999999999995e-167	NTclustered	gi\|833494855\|ref\|XM_012915027.1\|	5866	g9357	i0	93.564	771.84236453202	404	25	99	1	2	404	425	22	Babesia bigemina hypothetical protein, conserved partial mRNA	blastn	313368	601	1	Eukaryota	Sar	Apicomplexa	Aconoidasida	Piroplasmida	Babesiidae	Babesia	Babesia bigemina
15731005	15731005	PRJNA431371_P_NODE_3293_length_624_cov_4.787659_g3220_i0	PRJNA431371	3293	624	4.787659	29.87499216	Besnoitia besnoiti	94643	SAR_Eukaryotes	SAR_Eukaryotes	315	7.149999999999999e-81	NTclustered	gi\|1673113577\|ref\|XM_029362037.1\|	94643	g3220	i0	79.06	59.9967948717949	468	90	74	7	15	478	167	630	Besnoitia besnoiti ribosomal protein RPL10A (BESB_034510), partial mRNA	blastn	37438	315	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Sarcocystidae	Besnoitia	Besnoitia besnoiti
22104881	22104881	PRJNA431371_P_NODE_30038_length_247_cov_0.885057_g29965_i0	PRJNA431371	30038	247	0.885057	2.18609079	Babesia bigemina	5866	SAR_Eukaryotes	SAR_Eukaryotes	202	2.0899999999999999e-47	NTclustered	gi\|833480665\|ref\|XM_012910612.1\|	5866	g29965	i0	84.541	43.8259109311741	207	28	83	3	4	208	291	495	Babesia bigemina eukaryotic translation initiation factor 4A, putative partial mRNA	blastn	10825	202	1	Eukaryota	Sar	Apicomplexa	Aconoidasida	Piroplasmida	Babesiidae	Babesia	Babesia bigemina
24654474	24654474	PRJNA431371_P_NODE_21980_length_271_cov_1.959596_g21907_i0	PRJNA431371	21980	271	1.959596	5.31050516	Plasmodium falciparum	5833	SAR_Eukaryotes	SAR_Eukaryotes	54.7	0.007	NTclustered	gi\|86171479\|ref\|XM_961127.1\|	36329	g21907	i0	100	0.107011070110701	29	0	11	0	197	225	310	282	Plasmodium falciparum 3D7 tyrosine kinase-like protein, putative (PF3D7_0623800), partial mRNA	blastn	29	54.7	1	Eukaryota	Sar	Apicomplexa	Aconoidasida	Haemosporida	Plasmodiidae	Plasmodium	Plasmodium falciparum
24654879	24654879	PRJNA431371_P_NODE_8280_length_430_cov_1.683473_g8207_i0	PRJNA431371	8280	430	1.683473	7.2389339	Besnoitia besnoiti	94643	SAR_Eukaryotes	SAR_Eukaryotes	241	8.25e-59	NTclustered	gi\|1673115679\|ref\|XM_029363146.1\|	94643	g8207	i0	85.408	49.1139534883721	233	32	54	2	97	328	410	179	Besnoitia besnoiti ribosomal protein RPS15 (BESB_046950), partial mRNA	blastn	21119	241	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Sarcocystidae	Besnoitia	Besnoitia besnoiti

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