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

6 rows where analysis = "diamond", bioproject = "PRJNA951388" 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
26993701	26993701	PRJNA951388_S_NODE_5782_length_352_cov_3.279570_g5655_i0	PRJNA951388	5782	352	3.27957	11.5440864	Halteria grandinella	5974	SAR_Eukaryotes	SAR_Eukaryotes	47.4	0.00302	NR	TNV83925.1	5974	g5655	i0	29.4	0.928977272727273	109	74	90.3	3	350	33	106	214	TNV83925.1 hypothetical protein FGO68_gene17221 [Halteria grandinella]	diamond	327	47.4	1	Eukaryota	Sar	Ciliophora	Spirotrichea	Sporadotrichida	Halteriidae	Halteria	Halteria grandinella
28516565	28516565	PRJNA951388_S_NODE_4147_length_403_cov_2.515152_g4020_i0	PRJNA951388	4147	403	2.515152	10.13606256	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	99	1.3400000000000002e-21	NR	XP_004024266.1	5932	g4020	i0	39.5	2.75434243176179	147	72	96.8	4	7	396	26	172	XP_004024266.1 methionyl-tRNA formyltransferase, putative [Ichthyophthirius multifiliis]	diamond	1110	100	0.99	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Hymenostomatida		Ichthyophthirius	Ichthyophthirius multifiliis
29242741	29242741	PRJNA951388_S_NODE_2289_length_490_cov_7.235012_g2163_i0	PRJNA951388	2289	490	7.235012	35.4515588	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	144	7.499999999999999e-38	NR	TNV79671.1	5974	g2163	i0	53.7	15.9367346938776	136	61	83.3	1	484	77	273	406	TNV79671.1 hypothetical protein FGO68_gene6240 [Halteria grandinella]	diamond	7809	145	0.993103448275862	Eukaryota	Sar	Ciliophora	Spirotrichea	Sporadotrichida	Halteriidae	Halteria	Halteria grandinella
30443018	30443018	PRJNA951388_S_NODE_7373_length_313_cov_2.320833_g7246_i0	PRJNA951388	7373	313	2.320833	7.26420729	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	76.6	7.67e-14	NR	XP_001423282.1	5888	g7246	i0	37.9	1.97444089456869	103	64	98.7	0	2	310	254	356	XP_001423282.1 uncharacterized protein GSPATT00000319001 [Paramecium tetraurelia]	diamond	618	76.6	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Peniculida	Parameciidae	Paramecium	Paramecium tetraurelia
30847076	30847076	PRJNA951388_S_NODE_3174_length_442_cov_5.766938_g3047_i0	PRJNA951388	3174	442	5.766938	25.48986596	Tetrahymena thermophila SB21	5911	SAR_Eukaryotes	SAR_Eukaryotes	112	5.88e-28	NR	XP_001014252.1	312017	g3047	i0	41.7	0.943438914027149	139	80	93.7	1	2	415	54	192	XP_001014252.1 UMP-CMP kinase [Tetrahymena thermophila SB210]	diamond	417	112	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Hymenostomatida	Tetrahymenidae	Tetrahymena	Tetrahymena thermophila
32530118	32530118	PRJNA951388_S_NODE_10019_length_261_cov_2.867021_g9892_i0	PRJNA951388	10019	261	2.867021	7.48292481	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	104	6.05e-25	NR	CDW73994.1	5949	g9892	i0	57.6	12.5977011494253	85	36	97.7	0	6	260	28	112	CDW73994.1 protein kinase 2 [Stylonychia lemnae]	diamond	3288	104	1	Eukaryota	Sar	Ciliophora	Spirotrichea	Sporadotrichida	Oxytrichidae	Stylonychia	Stylonychia lemnae

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