metadata: contig_metadata: 14 rows where analysis = "blastn", bioproject = "PRJNA1196438" and tax

14 rows where analysis = "blastn", bioproject = "PRJNA1196438" and tax_clade = "Sar"

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
323048	323048	PRJNA1196438_P_NODE_36261_length_294_cov_4.647059_g35835_i0	PRJNA1196438	36261	294	4.647059	13.66235346	Neospora caninum	29176	SAR_Eukaryotes	SAR_Eukaryotes	510	3.74e-140	NTclustered	gi\|820695469\|tpe\|LN714488.1\|	572307	g35835	i0	98.611	5.06462585034014	288	4	98	0	7	294	117534	117247	TPA_asm: Neospora caninum Liverpool, unplaced_1, complete genome	blastn	1489	510	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Sarcocystidae	Neospora	Neospora caninum
1598181	1598181	PRJNA1196438_P_NODE_73902_length_244_cov_0.912281_g73475_i0	PRJNA1196438	73902	244	0.912281	2.22596564	Ichthyophthirius multifiliis	5932	SAR_Eukaryotes	SAR_Eukaryotes	111	3.58e-20	NTclustered	gi\|471227796\|ref\|XM_004034752.1\|	5932	g73475	i0	86.408	0.422131147540984	103	12	41	2	1	101	469	367	Ichthyophthirius multifiliis ku p70 DNA helicase, putative (IMG5_113130) mRNA, complete cds	blastn	103	111	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Hymenostomatida		Ichthyophthirius	Ichthyophthirius multifiliis
1598316	1598316	PRJNA1196438_P_NODE_83882_length_225_cov_4.177632_g83455_i0	PRJNA1196438	83882	225	4.177632	9.399672	Neospora caninum	29176	SAR_Eukaryotes	SAR_Eukaryotes	313	8.31e-81	NTclustered	gi\|820695469\|tpe\|LN714488.1\|	572307	g83455	i0	91.964	20.3022222222222	224	17	99	1	2	225	300321	300543	TPA_asm: Neospora caninum Liverpool, unplaced_1, complete genome	blastn	4568	313	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Sarcocystidae	Neospora	Neospora caninum
2874439	2874439	PRJNA1196438_P_NODE_82783_length_228_cov_2.567742_g82356_i0	PRJNA1196438	82783	228	2.567742	5.85445176	Ichthyophthirius multifiliis	5932	SAR_Eukaryotes	SAR_Eukaryotes	255	1.44e-63	NTclustered	gi\|471228778\|ref\|XM_004035212.1\|	5932	g82356	i0	87.387	0.973684210526316	222	28	97	0	5	226	635	856	Ichthyophthirius multifiliis swirm domain protein (IMG5_102740) mRNA, complete cds	blastn	222	255	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Hymenostomatida		Ichthyophthirius	Ichthyophthirius multifiliis
4149952	4149952	PRJNA1196438_P_NODE_37204_length_293_cov_2.468182_g36778_i0	PRJNA1196438	37204	293	2.468182	7.23177326	Ichthyophthirius multifiliis	5932	SAR_Eukaryotes	SAR_Eukaryotes	165	3.34e-36	NTclustered	gi\|471221682\|ref\|XM_004029611.1\|	5932	g36778	i0	85.625	0.641638225255973	160	19	54	4	16	172	691	533	Ichthyophthirius multifiliis hypothetical protein (IMG5_176090) mRNA, complete cds	blastn	188	165	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Hymenostomatida		Ichthyophthirius	Ichthyophthirius multifiliis
4150368	4150368	PRJNA1196438_P_NODE_68624_length_248_cov_3.068571_g68197_i0	PRJNA1196438	68624	248	3.068571	7.61005608	Neospora caninum	29176	SAR_Eukaryotes	SAR_Eukaryotes	329	9.249999999999998e-86	NTclustered	gi\|820695469\|tpe\|LN714488.1\|	572307	g68197	i0	90.726	2.00403225806452	248	21	100	2	1	246	80162	80409	TPA_asm: Neospora caninum Liverpool, unplaced_1, complete genome	blastn	497	329	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Sarcocystidae	Neospora	Neospora caninum
5426227	5426227	PRJNA1196438_P_NODE_3885_length_495_cov_2.902844_g3472_i0	PRJNA1196438	3885	495	2.902844	14.3690778	Tetrahymena thermophila	5911	SAR_Eukaryotes	SAR_Eukaryotes	54.7	0.013	NTclustered	gi\|829186935\|ref\|XM_001022570.3\|	312017	g3472	i0	100	0.0585858585858586	29	0	6	0	167	195	1608	1636	Tetrahymena thermophila SB210 Serine/Threonine kinase domain protein partial mRNA	blastn	29	54.7	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Hymenostomatida	Tetrahymenidae	Tetrahymena	Tetrahymena thermophila
5426799	5426799	PRJNA1196438_P_NODE_77525_length_239_cov_2.813253_g77098_i0	PRJNA1196438	77525	239	2.813253	6.72367467	Ichthyophthirius multifiliis	5932	SAR_Eukaryotes	SAR_Eukaryotes	99	2.72e-16	NTclustered	gi\|471219214\|ref\|XM_004024088.1\|	5932	g77098	i0	89.024	0.343096234309623	82	5	33	3	3	82	408	487	Ichthyophthirius multifiliis hypothetical protein (IMG5_199330) mRNA, complete cds	blastn	82	99	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Hymenostomatida		Ichthyophthirius	Ichthyophthirius multifiliis
11801594	11801594	PRJNA1196438_P_NODE_39290_length_290_cov_1.488479_g38863_i0	PRJNA1196438	39290	290	1.488479	4.3165891	Babesia duncani	323732	SAR_Eukaryotes	SAR_Eukaryotes	54.7	0.007	NTclustered	gi\|2794768076\|ref\|XM_067947470.1\|	323732	g38863	i0	90.476	0.144827586206897	42	3	14	1	43	84	205	165	Babesia duncani uncharacterized protein (BdWA1_002447), partial mRNA	blastn	42	54.7	1	Eukaryota	Sar	Apicomplexa	Aconoidasida	Piroplasmida	Babesiidae	Babesia	Babesia duncani
12522011	12522011	PRJNA1196438_P_NODE_47670_length_277_cov_1.446078_g47243_i0	PRJNA1196438	47670	277	1.446078	4.00563606	Tetrahymenidae	291294	SAR_Eukaryotes	SAR_Eukaryotes	324	4.89e-84	NTclustered	gi\|114329902\|ref\|NC_008339.1\|	5907	g47243	i0	89.453	4.66425992779783	256	27	92	0	22	277	27206	26951	Tetrahymena pigmentosa mitochondrion, complete genome	blastn	1292	324	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Hymenostomatida	Tetrahymenidae	Tetrahymena	Tetrahymena pigmentosa
18174731	18174731	PRJNA1196438_P_NODE_42735_length_284_cov_6.407583_g42308_i0	PRJNA1196438	42735	284	6.407583	18.19753572	Babesia ovata	189622	SAR_Eukaryotes	SAR_Eukaryotes	460	3.68e-125	NTclustered	gi\|1624698158\|ref\|XM_029013947.1\|	189622	g42308	i0	98.473	791.676056338028	262	3	92	1	13	273	724	985	Babesia ovata endonuclease-reverse transcriptase (BOVATA_050300), partial mRNA	blastn	224836	460	1	Eukaryota	Sar	Apicomplexa	Aconoidasida	Piroplasmida	Babesiidae	Babesia	Babesia ovata
20724719	20724719	PRJNA1196438_P_NODE_61577_length_256_cov_1.513661_g61150_i0	PRJNA1196438	61577	256	1.513661	3.87497216	Neospora caninum	29176	SAR_Eukaryotes	SAR_Eukaryotes	399	7.209999999999998e-107	NTclustered	gi\|820695469\|tpe\|LN714488.1\|	572307	g61150	i0	94.922	26.6484375	256	12	99	1	2	256	302325	302070	TPA_asm: Neospora caninum Liverpool, unplaced_1, complete genome	blastn	6822	399	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Sarcocystidae	Neospora	Neospora caninum
20724922	20724922	PRJNA1196438_P_NODE_76557_length_241_cov_3.660714_g76130_i0	PRJNA1196438	76557	241	3.660714	8.82232074	Ichthyophthirius multifiliis	5932	SAR_Eukaryotes	SAR_Eukaryotes	117	7.58e-22	NTclustered	gi\|471226651\|ref\|XM_004032309.1\|	5932	g76130	i0	90.805	0.360995850622407	87	8	36	0	1	87	544	630	Ichthyophthirius multifiliis tubulin-tyrosine ligase family protein, putative (IMG5_124010) mRNA, complete cds	blastn	87	117	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Hymenostomatida		Ichthyophthirius	Ichthyophthirius multifiliis
23275375	23275375	PRJNA1196438_P_NODE_45179_length_281_cov_1.129808_g44752_i0	PRJNA1196438	45179	281	1.129808	3.17476048	Babesia ovata	189622	SAR_Eukaryotes	SAR_Eukaryotes	427	3.68e-115	NTclustered	gi\|1624698160\|ref\|XM_029013948.1\|	189622	g44752	i0	94.891	833.46975088968	274	13	98	1	8	281	296	24	Babesia ovata zinc finger protein 33B (BOVATA_050310), partial mRNA	blastn	234205	427	1	Eukaryota	Sar	Apicomplexa	Aconoidasida	Piroplasmida	Babesiidae	Babesia	Babesia ovata

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