metadata: contig_metadata: 10 rows where analysis = "diamond", bioproject = "PRJNA853203" and tax

10 rows where analysis = "diamond", bioproject = "PRJNA853203" 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
7219675	7219675	PRJNA853203_P_NODE_40006_length_246_cov_0.901734_g39857_i0	PRJNA853203	40006	246	0.901734	2.21826564	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	111	3.27e-27	NR	XP_009032801.1	44056	g39857	i0	64.9	3.81707317073171	77	26	92.7	1	12	239	120	196	XP_009032801.1 hypothetical protein AURANDRAFT_18666 [Aureococcus anophagefferens]	diamond	939	111	1	Eukaryota	Sar		Pelagophyceae	Pelagomonadales	Pelagomonadaceae	Aureococcus	Aureococcus anophagefferens
27212895	27212895	PRJNA853203_P_NODE_45042_length_243_cov_0.917647_g44893_i0	PRJNA853203	45042	243	0.917647	2.22988221	Cyclotella cryptica	29204	SAR_Eukaryotes	SAR_Eukaryotes	72.8	1e-12	NR	KAL3801545.1	29204	g44893	i0	82.3	1.95061728395062	79	14	97.5	0	1	237	564	642	KAL3801545.1 hypothetical protein HJC23_000983 [Cyclotella cryptica]	diamond	474	72.8	1	Eukaryota	Sar	Bacillariophyta	Coscinodiscophyceae	Stephanodiscales	Stephanodiscaceae	Cyclotella	Cyclotella cryptica
27907603	27907603	PRJNA853203_P_NODE_39465_length_246_cov_0.901734_g39316_i0	PRJNA853203	39465	246	0.901734	2.21826564	Durusdinium trenchii	1381693	SAR_Eukaryotes	SAR_Eukaryotes	62	6.37e-9	NR	CAK9071266.1	1381693	g39316	i0	43.8	0.890243902439024	73	38	85.4	1	3	212	69	141	CAK9071266.1 Adenylate cyclase type 10 (AH-related protein) (Adenylate cyclase homolog) (Germ cell soluble adenylyl cyclase) (hsAC) (sAC) (Testicular soluble adenylyl cyclase) [Durusdinium trenchii]	diamond	219	62	1	Eukaryota	Sar		Dinophyceae	Suessiales	Symbiodiniaceae	Durusdinium	Durusdinium trenchii
28286533	28286533	PRJNA853203_P_NODE_13986_length_279_cov_1.728155_g13837_i0	PRJNA853203	13986	279	1.728155	4.82155245	Cyclotella cryptica	29204	SAR_Eukaryotes	SAR_Eukaryotes	69.7	1.93e-11	NR	KAL3780888.1	29204	g13837	i0	47.4	0.838709677419355	78	41	83.9	0	277	44	824	901	KAL3780888.1 hypothetical protein HJC23_009934 [Cyclotella cryptica]	diamond	234	69.7	1	Eukaryota	Sar	Bacillariophyta	Coscinodiscophyceae	Stephanodiscales	Stephanodiscaceae	Cyclotella	Cyclotella cryptica
29202541	29202541	PRJNA853203_P_NODE_43429_length_244_cov_0.912281_g43280_i0	PRJNA853203	43429	244	0.912281	2.22596564	Cyclotella cryptica	29204	SAR_Eukaryotes	SAR_Eukaryotes	43.1	0.0183	NR	KAL3783202.1	29204	g43280	i0	68.8	0.39344262295082	32	9	38.1	1	93	1	1	32	KAL3783202.1 hypothetical protein HJC23_013545 [Cyclotella cryptica]	diamond	96	43.1	1	Eukaryota	Sar	Bacillariophyta	Coscinodiscophyceae	Stephanodiscales	Stephanodiscaceae	Cyclotella	Cyclotella cryptica
30971426	30971426	PRJNA853203_P_NODE_10914_length_287_cov_1.130841_g10765_i0	PRJNA853203	10914	287	1.130841	3.24551367	Ochromonadaceae sp. CCMP2298	483371	SAR_Eukaryotes	SAR_Eukaryotes	72	3.26e-12	NR	KAJ1422616.1	483371	g10765	i0	56.9	0.606271777003484	58	24	59.6	1	79	249	270	327	KAJ1422616.1 Spc98 family-domain-containing protein [Ochromonadaceae sp. CCMP2298]	diamond	174	72	1	Eukaryota	Sar		Synurophyceae	Ochromonadales	Ochromonadaceae		Ochromonadaceae sp. CCMP2298
31034801	31034801	PRJNA853203_P_NODE_28895_length_252_cov_0.871508_g28746_i0	PRJNA853203	28895	252	0.871508	2.19620016	Cyclotella cryptica	29204	SAR_Eukaryotes	SAR_Eukaryotes	44.7	0.00866	NR	KAL3776596.1	29204	g28746	i0	86.4	0.523809523809524	22	3	26.2	0	251	186	38	59	KAL3776596.1 hypothetical protein HJC23_005796 [Cyclotella cryptica]	diamond	132	44.7	1	Eukaryota	Sar	Bacillariophyta	Coscinodiscophyceae	Stephanodiscales	Stephanodiscaceae	Cyclotella	Cyclotella cryptica
31350716	31350716	PRJNA853203_P_NODE_32276_length_250_cov_0.881356_g32127_i0	PRJNA853203	32276	250	0.881356	2.20339	Moneuplotes crassus	5936	SAR_Eukaryotes	SAR_Eukaryotes	65.5	3.95e-10	NR	CAI2366031.1	5936	g32127	i0	43.4	0.912	76	39	91.2	1	247	20	141	212	CAI2366031.1 unnamed protein product [Moneuplotes crassus]	diamond	228	65.5	1	Eukaryota	Sar	Ciliophora	Spirotrichea	Euplotida	Euplotidae	Moneuplotes	Moneuplotes crassus
31508900	31508900	PRJNA853203_P_NODE_18736_length_269_cov_1.224490_g18587_i0	PRJNA853203	18736	269	1.22449	3.2938781	Cyclotella cryptica	29204	SAR_Eukaryotes	SAR_Eukaryotes	48.9	3.38e-4	NR	KAL3792175.1	29204	g18587	i0	53.7	0.45724907063197	41	19	45.7	0	124	2	37	77	KAL3792175.1 hypothetical protein HJC23_009639 [Cyclotella cryptica]	diamond	123	48.9	1	Eukaryota	Sar	Bacillariophyta	Coscinodiscophyceae	Stephanodiscales	Stephanodiscaceae	Cyclotella	Cyclotella cryptica
31508904	31508904	PRJNA853203_P_NODE_25036_length_255_cov_3.071429_g24887_i0	PRJNA853203	25036	255	3.071429	7.83214395	Vaucheria litorea	109269	SAR_Eukaryotes	SAR_Eukaryotes	138	3.08e-39	NR	YP_002327561.1	109269	g24887	i0	78.6	2.96470588235294	84	18	98.8	0	3	254	89	172	YP_002327561.1 photosystem I assembly protein Ycf4 [Vaucheria litorea]	diamond	756	138	1	Eukaryota	Sar		Xanthophyceae	Vaucheriales	Vaucheriaceae	Vaucheria	Vaucheria litorea

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