metadata: contig_metadata: 9 rows where bioproject = "PRJNA896758", tax_clade = "Sar" and tax

9 rows where bioproject = "PRJNA896758", tax_clade = "Sar" 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
5072032	5072032	PRJNA896758_P_NODE_3564_length_609_cov_1.533582_g3182_i0	PRJNA896758	3564	609	1.533582	9.33951438	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	60.2	3.61e-4	NTclustered	gi\|915124826\|ref\|XM_013478223.1\|	5804	g3182	i0	92.857	13.1264367816092	42	1	7	2	287	327	1674	1634	Eimeria maxima hypothetical protein, conserved partial mRNA	blastn	7994	60.2	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Eimeriidae	Eimeria	Eimeria maxima
5976133	5976133	PRJNA896758_P_NODE_19185_length_265_cov_2.026042_g18795_i0	PRJNA896758	19185	265	2.026042	5.3690113	Plasmodium gaboni	647221	SAR_Eukaryotes	SAR_Eukaryotes	56.5	0.002	NTclustered	gi\|1084892431\|ref\|XM_018787042.1\|	647221	g18795	i0	94.595	0.864150943396226	37	0	14	2	130	166	1270	1236	Plasmodium gaboni hypothetical protein partial mRNA	blastn	229	56.5	1	Eukaryota	Sar	Apicomplexa	Aconoidasida	Haemosporida	Plasmodiidae	Plasmodium	Plasmodium gaboni
7250898	7250898	PRJNA896758_P_NODE_13686_length_311_cov_1.294118_g13296_i0	PRJNA896758	13686	311	1.294118	4.02470698	Eimeria tenella	5802	SAR_Eukaryotes	SAR_Eukaryotes	58.4	6.25e-4	NTclustered	gi\|916419483\|ref\|XM_013375519.1\|	5802	g13296	i0	100	0.0996784565916399	31	0	10	0	215	245	1094	1064	Eimeria tenella uncharacterized protein (ETH_00043430), partial mRNA	blastn	31	58.4	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Eimeriidae	Eimeria	Eimeria tenella
7622005	7622005	PRJNA896758_P_NODE_5726_length_475_cov_2.865672_g5337_i0	PRJNA896758	5726	475	2.865672	13.611942	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	58.4	0.001	NTclustered	gi\|84998371\|ref\|XM_948814.1\|	5874	g5337	i0	97.059	6.74947368421053	34	1	7	0	441	474	589	556	Theileria annulata SNF2-family protein (chromodomain-helicase-DNA-binding protein 1) (TA06105), partial mRNA	blastn	3206	58.4	1	Eukaryota	Sar	Apicomplexa	Aconoidasida	Piroplasmida	Theileriidae	Theileria	Theileria annulata
11076292	11076292	PRJNA896758_P_NODE_11489_length_339_cov_1.236842_g11099_i0	PRJNA896758	11489	339	1.236842	4.19289438	Plasmodium vinckei	5860	SAR_Eukaryotes	SAR_Eukaryotes	54.7	0.009	NTclustered	gi\|669196265\|ref\|XM_008624922.1\|	54757	g11099	i0	96.97	0.0973451327433628	33	0	9	1	74	105	2243	2211	Plasmodium vinckei vinckei conserved Plasmodium protein, unknown function (PVVCY_1401030), partial mRNA	blastn	33	54.7	1	Eukaryota	Sar	Apicomplexa	Aconoidasida	Haemosporida	Plasmodiidae	Plasmodium	Plasmodium vinckei
17451100	17451100	PRJNA896758_P_NODE_3534_length_612_cov_1.204082_g3153_i0	PRJNA896758	3534	612	1.204082	7.36898184	Plasmodium chabaudi	5825	SAR_Eukaryotes	SAR_Eukaryotes	91.6	1.29e-13	NTclustered	gi\|1027949921\|ref\|XR_001678647.1\|	31271	g3153	i0	78.523	0.243464052287582	149	24	24	6	12	157	1322	1465	Plasmodium chabaudi chabaudi 28S ribosomal RNA (PCHAS_0521461), rRNA	blastn	149	91.6	1	Eukaryota	Sar	Apicomplexa	Aconoidasida	Haemosporida	Plasmodiidae	Plasmodium	Plasmodium chabaudi
22549694	22549694	PRJNA896758_P_NODE_24278_length_245_cov_1.401163_g23888_i0	PRJNA896758	24278	245	1.401163	3.43284935	Cryptosporidium ubiquitum	857276	SAR_Eukaryotes	SAR_Eukaryotes	172	1.63e-38	NTclustered	gi\|1624732878\|ref\|XM_029020185.1\|	857276	g23888	i0	81.731	54.469387755102	208	36	84	2	6	212	1117	1323	Cryptosporidium ubiquitum vacuolar ATP synthase subunit A (cubi_03172), partial mRNA	blastn	13345	172	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Cryptosporidiidae	Cryptosporidium	Cryptosporidium ubiquitum
22549704	22549704	PRJNA896758_P_NODE_25198_length_244_cov_0.871345_g24808_i0	PRJNA896758	25198	244	0.871345	2.1260818	Eimeria tenella	5802	SAR_Eukaryotes	SAR_Eukaryotes	58.4	4.73e-4	NTclustered	gi\|916422565\|ref\|XM_013377060.1\|	5802	g24808	i0	100	3.2172131147541	31	0	13	0	172	202	494	464	Eimeria tenella RNA recognition motif. family protein, related (ETH_00009915), partial mRNA	blastn	785	58.4	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Eimeriidae	Eimeria	Eimeria tenella
27884634	27884634	PRJNA896758_P_NODE_22405_length_249_cov_0.875000_g22015_i0	PRJNA896758	22405	249	0.875	2.17875	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	46.2	0.00125	NR	XP_013248924.1	5801	g22015	i0	39.7	1.34939759036145	58	35	69.9	0	67	240	18	75	XP_013248924.1 glycolipid transfer protein, putative [Eimeria acervulina]	diamond	336	46.6	0.991416309012876	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Eimeriidae	Eimeria	Eimeria acervulina

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