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

11 rows where analysis = "diamond", bioproject = "PRJEB55250" 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
7369375	7369375	PRJEB55250_P_NODE_3486_length_360_cov_2.463415_g3362_i0	PRJEB55250	3486	360	2.463415	8.868294	Tetrahymena	5890	SAR_Eukaryotes	SAR_Eukaryotes	146	1.1999999999999999e-41	NR	XP_001014308.1	312017	g3362	i0	58.3	1.91666666666667	115	48	95.8	0	349	5	52	166	XP_001014308.1 eukaryotic translation initiation factor 5A [Tetrahymena thermophila SB210]	diamond	690	147	0.993197278911565	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Hymenostomatida	Tetrahymenidae	Tetrahymena	Tetrahymena thermophila
7774074	7774074	PRJEB55250_P_NODE_11047_length_253_cov_3.255556_g10923_i0	PRJEB55250	11047	253	3.255556	8.23655668	Sterkiella histriomuscorum	94289	SAR_Eukaryotes	SAR_Eukaryotes	137	1.37e-38	NR	AAZ23859.1	94289	g10923	i0	79.5	15.7114624505929	78	16	92.5	0	237	4	1	78	AAZ23859.1 ribosomal protein L10 [Sterkiella histriomuscorum]	diamond	3975	137	1	Eukaryota	Sar	Ciliophora	Spirotrichea	Sporadotrichida	Oxytrichidae	Sterkiella	Sterkiella histriomuscorum
26843875	26843875	PRJEB55250_P_NODE_10681_length_256_cov_1.683060_g10557_i0	PRJEB55250	10681	256	1.68306	4.3086336	Cercozoa sp. M6MM	1215613	SAR_Eukaryotes	SAR_Eukaryotes	127	2.54e-34	NR	MES1909310.1	1215613	g10557	i0	67.1	0.99609375	85	21	91.4	2	2	235	138	222	MES1909310.1 hypothetical protein [Cercozoa sp. M6MM]	diamond	255	127	1	Eukaryota	Sar	Cercozoa					Cercozoa sp. M6MM
27847958	27847958	PRJEB55250_P_NODE_15284_length_243_cov_1.811765_g15160_i0	PRJEB55250	15284	243	1.811765	4.40258895	Oomycota	4762	SAR_Eukaryotes	SAR_Eukaryotes	67	9.91e-11	NR	CAH0481103.1	622444	g15160	i0	47	2.71604938271605	66	35	81.5	0	46	243	136	201	CAH0481103.1 unnamed protein product [Peronospora belbahrii]	diamond	660	67.4	0.99406528189911	Eukaryota	Sar	Oomycota	Peronosporomycetes	Peronosporales	Peronosporaceae	Peronospora	Peronospora belbahrii
28107324	28107324	PRJEB55250_P_NODE_16465_length_241_cov_0.916667_g16341_i0	PRJEB55250	16465	241	0.916667	2.20916747	Pelagophyceae sp. CCMP2	1982007	SAR_Eukaryotes	SAR_Eukaryotes	88.6	4e-19	NR	KAJ1448903.1	483370	g16341	i0	54.7	0.933609958506224	75	34	93.4	0	227	3	15	89	KAJ1448903.1 hypothetical protein M885DRAFT_537562 [Pelagophyceae sp. CCMP2097]	diamond	225	88.6	1	Eukaryota	Sar		Pelagophyceae				Pelagophyceae sp. CCMP2097
28928368	28928368	PRJEB55250_P_NODE_10708_length_256_cov_1.683060_g10584_i0	PRJEB55250	10708	256	1.68306	4.3086336	Cercozoa sp. M6MM	1215613	SAR_Eukaryotes	SAR_Eukaryotes	77	7.4e-16	NR	MES1912234.1	1215613	g10584	i0	50.7	1.6640625	71	32	83.2	1	228	16	52	119	MES1912234.1 hypothetical protein [Cercozoa sp. M6MM]	diamond	426	77	1	Eukaryota	Sar	Cercozoa					Cercozoa sp. M6MM
29875700	29875700	PRJEB55250_P_NODE_14691_length_245_cov_0.895349_g14567_i0	PRJEB55250	14691	245	0.895349	2.19360505	Discostella pseudostelligera	259834	SAR_Eukaryotes	SAR_Eukaryotes	68.9	2.2e-11	NR	KAL3756347.1	259834	g14567	i0	100	0.404081632653061	33	0	40.4	0	3	101	474	506	KAL3756347.1 hypothetical protein ACHAWU_007298 [Discostella pseudostelligera]	diamond	99	68.9	1	Eukaryota	Sar	Bacillariophyta	Coscinodiscophyceae	Stephanodiscales	Stephanodiscaceae	Discostella	Discostella pseudostelligera
31202139	31202139	PRJEB55250_P_NODE_11975_length_250_cov_0.870056_g11851_i0	PRJEB55250	11975	250	0.870056	2.17514	Cardiosporidium cionae	476202	SAR_Eukaryotes	SAR_Eukaryotes	80.9	1.52e-15	NR	KAF8821414.1	476202	g11851	i0	47	5.94	83	43	99.6	1	250	2	426	507	KAF8821414.1 putative elongation factor Tu [Cardiosporidium cionae]	diamond	1485	80.9	1	Eukaryota	Sar	Apicomplexa	Aconoidasida	Nephromycida		Cardiosporidium	Cardiosporidium cionae
31234062	31234062	PRJEB55250_P_NODE_9715_length_263_cov_1.621053_g9591_i0	PRJEB55250	9715	263	1.621053	4.26336939	Blastocystis sp. Blastoise	3128533	SAR_Eukaryotes	SAR_Eukaryotes	58.2	1.82e-7	NR	KAK8803337.1	3128533	g9591	i0	32.9	2.77186311787072	85	54	97	1	2	256	286	367	KAK8803337.1 hypothetical protein WA158_001031 [Blastocystis sp. Blastoise]	diamond	729	58.2	1	Eukaryota	Sar		Bigyra	Opalinata	Blastocystidae	Blastocystis	Blastocystis sp. Blastoise
31645268	31645268	PRJEB55250_P_NODE_14557_length_245_cov_0.895349_g14433_i0	PRJEB55250	14557	245	0.895349	2.19360505	Phytophthora fragariaefolia	1490495	SAR_Eukaryotes	SAR_Eukaryotes	49.3	1.74e-4	NR	GMF48238.1	1490495	g14433	i0	32.9	0.857142857142857	70	47	85.7	0	238	29	164	233	GMF48238.1 unnamed protein product [Phytophthora fragariaefolia]	diamond	210	49.3	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Peronosporales	Peronosporaceae	Phytophthora	Phytophthora fragariaefolia
32814811	32814811	PRJEB55250_P_NODE_12180_length_250_cov_0.870056_g12056_i0	PRJEB55250	12180	250	0.870056	2.17514	Aphanomyces astaci	112090	SAR_Eukaryotes	SAR_Eukaryotes	80.5	2.09e-15	NR	XP_009844359.1	112090	g12056	i0	60	4.524	80	27	90	2	11	235	527	606	XP_009844359.1 hsp70-like protein [Aphanomyces astaci]	diamond	1131	80.5	1	Eukaryota	Sar	Oomycota	Saprolegniomycetes	Saprolegniales	Verrucalvaceae	Aphanomyces	Aphanomyces astaci

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