metadata: contig_metadata: 5 rows where analysis = "diamond", bioproject = "PRJNA674050" and tax

5 rows where analysis = "diamond", bioproject = "PRJNA674050" and tax_phylum = "Ciliophora"

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
27018484	27018484	PRJNA674050_P_NODE_19402_length_260_cov_1.871658_g19199_i0	PRJNA674050	19402	260	1.871658	4.8663108	Tetrahymena thermophila SB21	5911	SAR_Eukaryotes	SAR_Eukaryotes	162	4.62e-45	NR	XP_001031695.1	312017	g19199	i0	83.7	0.992307692307692	86	14	99.2	0	258	1	155	240	XP_001031695.1 hypothetical protein TTHERM_00760790 [Tetrahymena thermophila SB210]	diamond	258	162	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Hymenostomatida	Tetrahymenidae	Tetrahymena	Tetrahymena thermophila
27018488	27018488	PRJNA674050_P_NODE_7942_length_316_cov_1.201646_g7739_i0	PRJNA674050	7942	316	1.201646	3.79720136	Tetrahymena thermophila	5911	SAR_Eukaryotes	SAR_Eukaryotes	155	1.0099999999999999e-46	NR	2XZN_Z	5911	g7739	i0	80.6	0.882911392405063	93	18	88.3	0	279	1	1	93	2XZN_Z Chain Z, Rps21e [Tetrahymena thermophila]	diamond	279	155	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Hymenostomatida	Tetrahymenidae	Tetrahymena	Tetrahymena thermophila
28345020	28345020	PRJNA674050_P_NODE_36086_length_244_cov_0.906433_g35883_i0	PRJNA674050	36086	244	0.906433	2.21169652	Tetrahymena malaccensis	5901	SAR_Eukaryotes	SAR_Eukaryotes	82.8	2.86e-16	NR	KAL4437891.1	5901	g35883	i0	70	1.35245901639344	50	15	61.5	0	242	93	244	293	KAL4437891.1 hypothetical protein ABPG74_001062 [Tetrahymena malaccensis]	diamond	330	82.8	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Hymenostomatida	Tetrahymenidae	Tetrahymena	Tetrahymena malaccensis
28439895	28439895	PRJNA674050_P_NODE_33746_length_245_cov_0.906977_g33543_i0	PRJNA674050	33746	245	0.906977	2.22209365	Tetrahymena thermophila SB21	5911	SAR_Eukaryotes	SAR_Eukaryotes	149	9.24e-40	NR	XP_001008369.3	312017	g33543	i0	87.7	0.991836734693878	81	10	99.2	0	244	2	473	553	XP_001008369.3 glycosyl hydrolase family 31 protein [Tetrahymena thermophila SB210]	diamond	243	149	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Hymenostomatida	Tetrahymenidae	Tetrahymena	Tetrahymena thermophila
32579672	32579672	PRJNA674050_P_NODE_33439_length_245_cov_0.906977_g33236_i0	PRJNA674050	33439	245	0.906977	2.22209365	Tetrahymena malaccensis	5901	SAR_Eukaryotes	SAR_Eukaryotes	54.7	2.95e-7	NR	KAL4477597.1	5901	g33236	i0	47.1	0.83265306122449	68	33	83.3	1	25	228	1	65	KAL4477597.1 hypothetical protein ABPG74_002747 [Tetrahymena malaccensis]	diamond	204	54.7	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Hymenostomatida	Tetrahymenidae	Tetrahymena	Tetrahymena malaccensis

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