metadata: contig_metadata: 5 rows where bioproject = "PRJNA640350" and tax

5 rows where bioproject = "PRJNA640350" 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
4438258	4438258	PRJNA640350_P_NODE_39544_length_152_cov_3.430894_g39383_i0	PRJNA640350	39544	152	3.430894	5.21495888	Neospora caninum	29176	SAR_Eukaryotes	SAR_Eukaryotes	259	6.82e-65	NTclustered	gi\|820695469\|tpe\|LN714488.1\|	572307	g39383	i0	97.368	6.34868421052632	152	4	100	0	1	152	157140	157291	TPA_asm: Neospora caninum Liverpool, unplaced_1, complete genome	blastn	965	259	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Sarcocystidae	Neospora	Neospora caninum
9538983	9538983	PRJNA640350_P_NODE_27128_length_181_cov_4.460526_g26967_i0	PRJNA640350	27128	181	4.460526	8.07355206	Neospora caninum	29176	SAR_Eukaryotes	SAR_Eukaryotes	318	1.37e-82	NTclustered	gi\|820695469\|tpe\|LN714488.1\|	572307	g26967	i0	98.343	4.49171270718232	181	3	100	0	1	181	157512	157332	TPA_asm: Neospora caninum Liverpool, unplaced_1, complete genome	blastn	813	318	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Sarcocystidae	Neospora	Neospora caninum
12634745	12634745	PRJNA640350_P_NODE_31130_length_169_cov_3.800000_g30969_i0	PRJNA640350	31130	169	3.8	6.422	root	1	Root_unresolved	Root_unresolved	307	2.73e-79	NTclustered	gi\|10832\|emb\|X54512.1\|	5911	g30969	i0	99.408	95.112426035503	169	1	100	0	1	169	8136	8304	T. thermophila rdn A+ gene for pre-RNA, 17S rRNA, 5.8S rRNA, 26S rRNA	blastn	16074	307	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Hymenostomatida	Tetrahymenidae	Tetrahymena	Tetrahymena thermophila
13364528	13364528	PRJNA640350_P_NODE_19511_length_228_cov_2.673367_g19350_i0	PRJNA640350	19511	228	2.673367	6.09527676	Neospora caninum	29176	SAR_Eukaryotes	SAR_Eukaryotes	139	1.52e-28	NTclustered	gi\|820695469\|tpe\|LN714488.1\|	572307	g19350	i0	79.5	1.41666666666667	200	38	87	3	30	227	299998	300196	TPA_asm: Neospora caninum Liverpool, unplaced_1, complete genome	blastn	323	139	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Sarcocystidae	Neospora	Neospora caninum
13364717	13364717	PRJNA640350_P_NODE_4311_length_440_cov_5.564477_g4158_i0	PRJNA640350	4311	440	5.564477	24.4836988	Neospora caninum	29176	SAR_Eukaryotes	SAR_Eukaryotes	719	0	NTclustered	gi\|820695469\|tpe\|LN714488.1\|	572307	g4158	i0	96.339	65.7295454545455	437	16	99	0	4	440	116634	116198	TPA_asm: Neospora caninum Liverpool, unplaced_1, complete genome	blastn	28921	719	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Sarcocystidae	Neospora	Neospora caninum

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