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

11 rows where analysis = "diamond", bioproject = "PRJNA390533" 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
18261155	18261155	PRJNA390533_P_NODE_1675_length_1297_cov_17.182830_g1397_i0	PRJNA390533	1675	1297	17.18283	222.8613051	Mayamaea pseudoterrestris	2872254	SAR_Eukaryotes	SAR_Eukaryotes	639	4.9899999999999975e-227	NR	GKY94468.1	2872254	g1397	i0	74.2	0.966846569005397	418	91	93.4	5	1273	62	8	422	GKY94468.1 hypothetical protein MPSEU_000412700 [Mayamaea pseudoterrestris]	diamond	1254	639	1	Eukaryota	Sar	Bacillariophyta	Bacillariophyceae	Naviculales	Naviculaceae	Mayamaea	Mayamaea pseudoterrestris
26853996	26853996	PRJNA390533_P_NODE_21341_length_364_cov_3.138462_g20317_i0	PRJNA390533	21341	364	3.138462	11.42400168	Aphanomyces stellatus	120398	SAR_Eukaryotes	SAR_Eukaryotes	47.8	0.00253	NR	KAF0697955.1	120398	g20317	i0	42.9	0.461538461538462	56	27	45.3	3	77	241	504	555	KAF0697955.1 hypothetical protein As57867_011343 [Aphanomyces stellatus]	diamond	168	47.8	1	Eukaryota	Sar	Oomycota	Saprolegniomycetes	Saprolegniales	Verrucalvaceae	Aphanomyces	Aphanomyces stellatus
27106707	27106707	PRJNA390533_P_NODE_14982_length_481_cov_3.789593_g13987_i0	PRJNA390533	14982	481	3.789593	18.22794233	Stylonychia lemnae	5949	SAR_Eukaryotes	SAR_Eukaryotes	62.4	4.16e-8	NR	CDW91853.1	5949	g13987	i0	30.1	2.71309771309771	136	87	79.8	4	21	404	150	285	CDW91853.1 UNKNOWN [Stylonychia lemnae]	diamond	1305	62.4	1	Eukaryota	Sar	Ciliophora	Spirotrichea	Sporadotrichida	Oxytrichidae	Stylonychia	Stylonychia lemnae
28243672	28243672	PRJNA390533_P_NODE_4946_length_865_cov_4.645278_g4327_i0	PRJNA390533	4946	865	4.645278	40.1816547	Stylonychia lemnae	5949	SAR_Eukaryotes	SAR_Eukaryotes	59.3	8.19e-7	NR	CDW86772.1	5949	g4327	i0	36.7	0.378034682080925	109	60	37.5	4	756	433	14	114	CDW86772.1 UNKNOWN [Stylonychia lemnae]	diamond	327	59.3	1	Eukaryota	Sar	Ciliophora	Spirotrichea	Sporadotrichida	Oxytrichidae	Stylonychia	Stylonychia lemnae
28275292	28275292	PRJNA390533_P_NODE_20346_length_379_cov_37.029412_g19322_i0	PRJNA390533	20346	379	37.029412	140.34147148	Ochromonadaceae sp. CCMP2298	483371	SAR_Eukaryotes	SAR_Eukaryotes	126	2.01e-31	NR	KAJ1426258.1	483371	g19322	i0	58	0.79155672823219	100	34	72.8	1	17	292	388	487	KAJ1426258.1 pyridoxal-dependent decarboxylase [Ochromonadaceae sp. CCMP2298]	diamond	300	126	1	Eukaryota	Sar		Synurophyceae	Ochromonadales	Ochromonadaceae		Ochromonadaceae sp. CCMP2298
28970080	28970080	PRJNA390533_P_NODE_40188_length_180_cov_1.156028_g39161_i0	PRJNA390533	40188	180	1.156028	2.0808504	Mayamaea pseudoterrestris	2872254	SAR_Eukaryotes	SAR_Eukaryotes	44.7	0.00323	NR	GKZ00607.1	2872254	g39161	i0	59.4	0.533333333333333	32	13	53.3	0	20	115	267	298	GKZ00607.1 hypothetical protein MPSEU_001012900 [Mayamaea pseudoterrestris]	diamond	96	44.7	1	Eukaryota	Sar	Bacillariophyta	Bacillariophyceae	Naviculales	Naviculaceae	Mayamaea	Mayamaea pseudoterrestris
29712691	29712691	PRJNA390533_P_NODE_11390_length_576_cov_3.877095_g10477_i0	PRJNA390533	11390	576	3.877095	22.3320672	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	165	2.9499999999999995e-48	NR	DBA01302.1	4803	g10477	i0	57.4	5.890625	148	57	74.5	2	506	78	36	182	DBA01302.1 TPA: hypothetical protein N0F65_001807 [Lagenidium giganteum]	diamond	3393	165	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Pythiales	Pythiaceae	Lagenidium	Lagenidium giganteum
29917432	29917432	PRJNA390533_P_NODE_28811_length_266_cov_2.488987_g27784_i0	PRJNA390533	28811	266	2.488987	6.62070542	Moneuplotes crassus	5936	SAR_Eukaryotes	SAR_Eukaryotes	98.2	2.1999999999999996e-24	NR	CAI2385228.1	5936	g27784	i0	48.8	0.969924812030075	86	44	97	0	3	260	19	104	CAI2385228.1 unnamed protein product [Moneuplotes crassus]	diamond	258	98.2	1	Eukaryota	Sar	Ciliophora	Spirotrichea	Euplotida	Euplotidae	Moneuplotes	Moneuplotes crassus
31592418	31592418	PRJNA390533_P_NODE_14796_length_485_cov_6.760090_g13804_i0	PRJNA390533	14796	485	6.76009	32.7864365	Gregarina niphandrodes	110365	SAR_Eukaryotes	SAR_Eukaryotes	51.6	1.64e-4	NR	XP_011128749.1	110365	g13804	i0	46.4	0.890721649484536	56	30	34.6	0	306	473	73	128	XP_011128749.1 thioredoxin-like protein [Gregarina niphandrodes]	diamond	432	51.6	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eugregarinorida	Gregarinidae	Gregarina	Gregarina niphandrodes
32652445	32652445	PRJNA390533_P_NODE_39180_length_184_cov_2.220690_g38153_i0	PRJNA390533	39180	184	2.22069	4.0860696	Bacillariophyta	2836	SAR_Eukaryotes	SAR_Eukaryotes	68.2	4.06e-12	NR	GMH95175.1	1606541	g38153	i0	83.8	2.4945652173913	37	6	60.3	0	162	52	166	202	GMH95175.1 hypothetical protein TrST_g3269 [Triparma strigata]	diamond	459	68.6	0.994169096209913	Eukaryota	Sar		Bolidophyceae	Parmales	Triparmaceae	Triparma	Triparma strigata
32667353	32667353	PRJNA390533_P_NODE_42380_length_171_cov_1.613636_g41353_i0	PRJNA390533	42380	171	1.613636	2.75931756	Tribonema minus	303371	SAR_Eukaryotes	SAR_Eukaryotes	43.5	0.0079	NR	KAG5179948.1	303371	g41353	i0	42.2	2.42105263157895	45	26	78.9	0	159	25	527	571	KAG5179948.1 hypothetical protein JKP88DRAFT_280042 [Tribonema minus]	diamond	414	43.5	1	Eukaryota	Sar		Xanthophyceae	Tribonematales	Tribonemataceae	Tribonema	Tribonema minus

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