metadata: contig_metadata: 8 rows where analysis = "diamond", bioproject = "PRJNA1227535" and tax

8 rows where analysis = "diamond", bioproject = "PRJNA1227535" 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
9263445	9263445	PRJNA1227535_P_NODE_28068_length_245_cov_1.430233_g27944_i0	PRJNA1227535	28068	245	1.430233	3.50407085	Bacillariophyta	2836	SAR_Eukaryotes	SAR_Eukaryotes	134	1.78e-36	NR	EJK48596.1	159749	g27944	i0	81.3	25.5061224489796	80	15	98	0	244	5	53	132	EJK48596.1 hypothetical protein THAOC_32592 [Thalassiosira oceanica]	diamond	6249	134	1	Eukaryota	Sar	Bacillariophyta	Coscinodiscophyceae	Thalassiosirales	Thalassiosiraceae	Thalassiosira	Thalassiosira oceanica
28620394	28620394	PRJNA1227535_P_NODE_10607_length_290_cov_1.976959_g10484_i0	PRJNA1227535	10607	290	1.976959	5.7331811	Peronospora farinosa	134698	SAR_Eukaryotes	SAR_Eukaryotes	102	3.88e-23	NR	CAI5722522.1	134698	g10484	i0	87.5	1.15862068965517	56	7	57.9	0	288	121	319	374	CAI5722522.1 unnamed protein product [Peronospora farinosa]	diamond	336	102	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Peronosporales	Peronosporaceae	Peronospora	Peronospora farinosa
29188752	29188752	PRJNA1227535_P_NODE_19329_length_261_cov_1.303191_g19205_i0	PRJNA1227535	19329	261	1.303191	3.40132851	Ochromonadaceae sp. CCMP2298	483371	SAR_Eukaryotes	SAR_Eukaryotes	152	1.93e-41	NR	KAJ1439139.1	483371	g19205	i0	82.8	2	87	15	100	0	261	1	327	413	KAJ1439139.1 chaperonin Cpn60/TCP-1 family [Ochromonadaceae sp. CCMP2298]	diamond	522	152	1	Eukaryota	Sar		Synurophyceae	Ochromonadales	Ochromonadaceae		Ochromonadaceae sp. CCMP2298
29567312	29567312	PRJNA1227535_P_NODE_25010_length_249_cov_0.886364_g24886_i0	PRJNA1227535	25010	249	0.886364	2.20704636	Synura synuroidea	47573	SAR_Eukaryotes	SAR_Eukaryotes	50.4	7.57e-5	NR	NP_038170.1	47573	g24886	i0	36.8	0.91566265060241	76	46	90.4	2	226	2	371	445	NP_038170.1 NADH dehydrogenase subunit 11 [Synura synuroidea]	diamond	228	50.4	1	Eukaryota	Sar		Synurophyceae	Synurales	Mallomonadaceae	Synura	Synura synuroidea
30281510	30281510	PRJNA1227535_P_NODE_26052_length_247_cov_4.028736_g25928_i0	PRJNA1227535	26052	247	4.028736	9.95097792	root	1	Root_unresolved	Root_unresolved	46.6	0.00179	NR	CAB9507385.1	568900	g25928	i0	35.8	2.79352226720648	81	51	97.2	1	241	2	2213	2293	CAB9507385.1 Clustered mitochondria protein homolog [Seminavis robusta]	diamond	690	46.6	1	Eukaryota	Sar	Bacillariophyta	Bacillariophyceae	Naviculales	Naviculaceae	Seminavis	Seminavis robusta
31007804	31007804	PRJNA1227535_P_NODE_17414_length_267_cov_1.525773_g17291_i0	PRJNA1227535	17414	267	1.525773	4.07381391	Oomycota	4762	SAR_Eukaryotes	SAR_Eukaryotes	100	1.84e-22	NR	OQR90711.1	74557	g17291	i0	56.6	4.64044943820225	76	33	85.4	0	264	37	158	233	OQR90711.1 coatomer subunit gamma [Thraustotheca clavata]	diamond	1239	100	1	Eukaryota	Sar	Oomycota	Saprolegniomycetes	Saprolegniales	Achlyaceae	Thraustotheca	Thraustotheca clavata
31779381	31779381	PRJNA1227535_P_NODE_26717_length_247_cov_0.896552_g26593_i0	PRJNA1227535	26717	247	0.896552	2.21448344	Mayamaea pseudoterrestris	2872254	SAR_Eukaryotes	SAR_Eukaryotes	100	1.78e-22	NR	GKY97920.1	2872254	g26593	i0	59	1.0080971659919	83	31	97.2	1	245	6	206	288	GKY97920.1 hypothetical protein MPSEU_000750000 [Mayamaea pseudoterrestris]	diamond	249	100	1	Eukaryota	Sar	Bacillariophyta	Bacillariophyceae	Naviculales	Naviculaceae	Mayamaea	Mayamaea pseudoterrestris
31779385	31779385	PRJNA1227535_P_NODE_9617_length_294_cov_2.018100_g9494_i0	PRJNA1227535	9617	294	2.0181	5.933214	Ochromonadaceae sp. CCMP2298	483371	SAR_Eukaryotes	SAR_Eukaryotes	173	6.42e-49	NR	KAJ1416357.1	483371	g9494	i0	90.7	0.989795918367347	97	9	99	0	292	2	263	359	KAJ1416357.1 chaperonin Cpn60/TCP-1 family [Ochromonadaceae sp. CCMP2298]	diamond	291	173	1	Eukaryota	Sar		Synurophyceae	Ochromonadales	Ochromonadaceae		Ochromonadaceae sp. CCMP2298

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