metadata: contig_metadata: 6 rows where analysis = "diamond", bioproject = "PRJNA1247234" and tax

6 rows where analysis = "diamond", bioproject = "PRJNA1247234" 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
27863194	27863194	PRJNA1247234_P_NODE_18985_length_260_cov_1.668449_g18829_i0	PRJNA1247234	18985	260	1.668449	4.3379674	Ichthyophthirius multifiliis	5932	SAR_Eukaryotes	SAR_Eukaryotes	75.9	1.12e-15	NR	XP_004031317.1	5932	g18829	i0	47.4	0.876923076923077	76	40	87.7	0	241	14	21	96	XP_004031317.1 hypothetical protein IMG5_142740, partial [Ichthyophthirius multifiliis]	diamond	228	75.9	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Hymenostomatida		Ichthyophthirius	Ichthyophthirius multifiliis
27894745	27894745	PRJNA1247234_P_NODE_27245_length_243_cov_0.917647_g27089_i0	PRJNA1247234	27245	243	0.917647	2.22988221	Ichthyophthirius multifiliis	5932	SAR_Eukaryotes	SAR_Eukaryotes	87	1.17e-18	NR	XP_004036924.1	5932	g27089	i0	49.4	0.975308641975309	79	40	97.5	0	1	237	45	123	XP_004036924.1 proteasome subunit alpha type 3, putative [Ichthyophthirius multifiliis]	diamond	237	87	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Hymenostomatida		Ichthyophthirius	Ichthyophthirius multifiliis
28178763	28178763	PRJNA1247234_P_NODE_27646_length_242_cov_0.923077_g27490_i0	PRJNA1247234	27646	242	0.923077	2.23384634	Pseudocohnilembus persalinus	266149	SAR_Eukaryotes	SAR_Eukaryotes	87.4	2.63e-18	NR	KRX02208.1	266149	g27490	i0	52.5	0.991735537190083	80	38	99.2	0	3	242	5	84	KRX02208.1 hypothetical protein PPERSA_04830 [Pseudocohnilembus persalinus]	diamond	240	87.4	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Philasterida	Pseudocohnilembidae	Pseudocohnilembus	Pseudocohnilembus persalinus
28684357	28684357	PRJNA1247234_P_NODE_15147_length_289_cov_1.097222_g14991_i0	PRJNA1247234	15147	289	1.097222	3.17097158	Paramecium sonneborni	65129	SAR_Eukaryotes	SAR_Eukaryotes	58.2	2.51e-7	NR	CAD8118289.1	65129	g14991	i0	39.7	1.51557093425606	73	43	74.7	1	218	3	3144	3216	CAD8118289.1 unnamed protein product [Paramecium sonneborni]	diamond	438	58.2	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Peniculida	Parameciidae	Paramecium	Paramecium sonneborni
28891527	28891527	PRJNA1247234_P_NODE_27068_length_243_cov_0.917647_g26912_i0	PRJNA1247234	27068	243	0.917647	2.22988221	Tetrahymena	5890	SAR_Eukaryotes	SAR_Eukaryotes	57	3.53e-7	NR	KAL4440863.1	5901	g26912	i0	42.6	2	54	31	66.7	0	3	164	388	441	KAL4440863.1 hypothetical protein ABPG74_013844 [Tetrahymena malaccensis]	diamond	486	57	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Hymenostomatida	Tetrahymenidae	Tetrahymena	Tetrahymena malaccensis
30863396	30863396	PRJNA1247234_P_NODE_12634_length_311_cov_3.184874_g12478_i0	PRJNA1247234	12634	311	3.184874	9.90495814	Tetrahymena thermophila SB21	5911	SAR_Eukaryotes	SAR_Eukaryotes	113	2.2399999999999993e-28	NR	XP_001018798.2	312017	g12478	i0	54.4	1.98713826366559	103	46	98.4	1	1	306	43	145	XP_001018798.2 glutathione S-transferase, amine-terminal domain protein [Tetrahymena thermophila SB210]	diamond	618	113	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Hymenostomatida	Tetrahymenidae	Tetrahymena	Tetrahymena thermophila

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