metadata: contig_metadata: 11 rows where analysis = "diamond", bioproject = "PRJNA1065838" and tax

11 rows where analysis = "diamond", bioproject = "PRJNA1065838" 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
26963771	26963771	PRJNA1065838_S_NODE_32382_length_168_cov_0.873950_g32280_i0	PRJNA1065838	32382	168	0.87395	1.468236	Tetrahymenidae	291294	SAR_Eukaryotes	SAR_Eukaryotes	65.5	1.65e-11	NR	XP_004040069.1	5932	g32280	i0	58.7	1.64285714285714	46	19	82.1	0	138	1	72	117	XP_004040069.1 hypothetical protein IMG5_002370 [Ichthyophthirius multifiliis]	diamond	276	65.5	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Hymenostomatida		Ichthyophthirius	Ichthyophthirius multifiliis
27635935	27635935	PRJNA1065838_S_NODE_18464_length_207_cov_0.968354_g18362_i0	PRJNA1065838	18464	207	0.968354	2.00449278	Tetrahymena thermophila SB21	5911	SAR_Eukaryotes	SAR_Eukaryotes	42.4	0.0323	NR	XP_001024687.1	312017	g18362	i0	44.4	0.652173913043478	45	25	65.2	0	70	204	61	105	XP_001024687.1 hypothetical protein TTHERM_00616170 [Tetrahymena thermophila SB210]	diamond	135	42.4	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Hymenostomatida	Tetrahymenidae	Tetrahymena	Tetrahymena thermophila
29214751	29214751	PRJNA1065838_S_NODE_20669_length_200_cov_1.033113_g20567_i0	PRJNA1065838	20669	200	1.033113	2.066226	Tetrahymena thermophila SB21	5911	SAR_Eukaryotes	SAR_Eukaryotes	57	1.93e-7	NR	XP_001021414.1	312017	g20567	i0	46.2	0.975	65	32	97.5	2	199	5	351	412	XP_001021414.1 acid ceramidase-like protein, putative [Tetrahymena thermophila SB210]	diamond	195	57	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Hymenostomatida	Tetrahymenidae	Tetrahymena	Tetrahymena thermophila
29237932	29237932	PRJNA1065838_S_NODE_22389_length_195_cov_1.308219_g22287_i0	PRJNA1065838	22389	195	1.308219	2.55102705	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	73.6	2.11e-14	NR	XP_004040150.1	5932	g22287	i0	50.8	9.96923076923077	65	32	100	0	195	1	46	110	XP_004040150.1 hypothetical protein IMG5_000740 [Ichthyophthirius multifiliis]	diamond	1944	73.6	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Hymenostomatida		Ichthyophthirius	Ichthyophthirius multifiliis
29364231	29364231	PRJNA1065838_S_NODE_29169_length_175_cov_1.507937_g29067_i0	PRJNA1065838	29169	175	1.507937	2.63888975	Sporadotrichida	693921	SAR_Eukaryotes	SAR_Eukaryotes	54.3	1.2e-6	NR	CDW74325.1	5949	g29067	i0	65.7	2.58857142857143	35	12	60	0	69	173	481	515	CDW74325.1 pyridine nucleotide-disulfide oxidoreductase family protein [Stylonychia lemnae]	diamond	453	54.7	0.992687385740402	Eukaryota	Sar	Ciliophora	Spirotrichea	Sporadotrichida	Oxytrichidae	Stylonychia	Stylonychia lemnae
30446458	30446458	PRJNA1065838_S_NODE_36393_length_162_cov_0.902655_g36291_i0	PRJNA1065838	36393	162	0.902655	1.4623011	Ochromonadaceae sp. CCMP2298	483371	SAR_Eukaryotes	SAR_Eukaryotes	108	7.77e-26	NR	KAJ1424691.1	483371	g36291	i0	92.5	1.96296296296296	53	4	98.1	0	3	161	411	463	KAJ1424691.1 hypothetical protein B484DRAFT_331127 [Ochromonadaceae sp. CCMP2298]	diamond	318	108	1	Eukaryota	Sar		Synurophyceae	Ochromonadales	Ochromonadaceae		Ochromonadaceae sp. CCMP2298
30952002	30952002	PRJNA1065838_S_NODE_28874_length_176_cov_1.228346_g28772_i0	PRJNA1065838	28874	176	1.228346	2.16188896	Paramecium sonneborni	65129	SAR_Eukaryotes	SAR_Eukaryotes	54.7	8.97e-7	NR	CAD8084114.1	65129	g28772	i0	47.4	0.971590909090909	57	30	97.2	0	171	1	138	194	CAD8084114.1 unnamed protein product [Paramecium sonneborni]	diamond	171	54.7	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Peniculida	Parameciidae	Paramecium	Paramecium sonneborni
31299421	31299421	PRJNA1065838_S_NODE_31755_length_169_cov_0.866667_g31653_i0	PRJNA1065838	31755	169	0.866667	1.46466723	Paramecium primaurelia	5886	SAR_Eukaryotes	SAR_Eukaryotes	85.1	1.98e-19	NR	CAD8083909.1	5886	g31653	i0	65.5	1.95266272189349	55	19	97.6	0	167	3	58	112	CAD8083909.1 unnamed protein product [Paramecium primaurelia]	diamond	330	85.1	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Peniculida	Parameciidae	Paramecium	Paramecium primaurelia
31520992	31520992	PRJNA1065838_S_NODE_29196_length_175_cov_1.238095_g29094_i0	PRJNA1065838	29196	175	1.238095	2.16666625	Pseudocohnilembus persalinus	266149	SAR_Eukaryotes	SAR_Eukaryotes	109	3.91e-26	NR	KRX08977.1	266149	g29094	i0	91.4	13.92	58	5	99.4	0	174	1	561	618	KRX08977.1 P-loop containing nucleoside triphosphate hydrolase [Pseudocohnilembus persalinus]	diamond	2436	109	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Philasterida	Pseudocohnilembidae	Pseudocohnilembus	Pseudocohnilembus persalinus
31607476	31607476	PRJNA1065838_S_NODE_25056_length_188_cov_1.122302_g24954_i0	PRJNA1065838	25056	188	1.122302	2.10992776	root	1	Root_unresolved	Root_unresolved	71.2	4.13e-13	NR	ETO99862.1	1317063	g24954	i0	58.3	1.91489361702128	60	25	95.7	0	188	9	105	164	ETO99862.1 hypothetical protein F441_22714, partial [Phytophthora nicotianae CJ01A1]	diamond	360	71.2	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Peronosporales	Peronosporaceae	Phytophthora	Phytophthora nicotianae
32722375	32722375	PRJNA1065838_S_NODE_23220_length_193_cov_1.305556_g23118_i0	PRJNA1065838	23220	193	1.305556	2.51972308	Pseudocohnilembus persalinus	266149	SAR_Eukaryotes	SAR_Eukaryotes	62.4	2.26e-9	NR	KRW98125.1	266149	g23118	i0	42.2	1.95854922279793	64	37	99.5	0	1	192	437	500	KRW98125.1 P-loop containing nucleoside triphosphate hydrolase [Pseudocohnilembus persalinus]	diamond	378	62.4	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Philasterida	Pseudocohnilembidae	Pseudocohnilembus	Pseudocohnilembus persalinus

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