metadata: contig_metadata: 9 rows where analysis = "diamond", bioproject = "PRJNA694557" and tax

9 rows where analysis = "diamond", bioproject = "PRJNA694557" 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
1949151	1949151	PRJNA694557_P_NODE_13062_length_365_cov_1.842466_g12842_i0	PRJNA694557	13062	365	1.842466	6.7250009	Bacillariophyta	2836	SAR_Eukaryotes	SAR_Eukaryotes	209	2.32e-61	NR	KAI2512534.1	210448	g12842	i0	87.5	4.93150684931507	120	15	98.6	0	1	360	467	586	KAI2512534.1 Transketolase [Fragilaria crotonensis]	diamond	1800	211	0.990521327014218	Eukaryota	Sar	Bacillariophyta	Fragilariophyceae	Fragilariales	Fragilariaceae	Fragilaria	Fragilaria crotonensis
27367343	27367343	PRJNA694557_P_NODE_17843_length_301_cov_1.688596_g17623_i0	PRJNA694557	17843	301	1.688596	5.08267396	Mayamaea pseudoterrestris	2872254	SAR_Eukaryotes	SAR_Eukaryotes	131	3.41e-34	NR	GKY99632.1	2872254	g17623	i0	73.3	0.857142857142857	86	23	85.7	0	2	259	304	389	GKY99632.1 hypothetical protein MPSEU_000917300 [Mayamaea pseudoterrestris]	diamond	258	131	1	Eukaryota	Sar	Bacillariophyta	Bacillariophyceae	Naviculales	Naviculaceae	Mayamaea	Mayamaea pseudoterrestris
27746202	27746202	PRJNA694557_P_NODE_7724_length_508_cov_4.262069_g7504_i0	PRJNA694557	7724	508	4.262069	21.65131052	Chaetoceros tenuissimus	426638	SAR_Eukaryotes	SAR_Eukaryotes	53.5	1.03e-4	NR	GFH51894.1	426638	g7504	i0	46.8	0.708661417322835	47	24	27.8	1	178	38	1762	1807	GFH51894.1 hypothetical protein CTEN210_08370 [Chaetoceros tenuissimus]	diamond	360	53.5	1	Eukaryota	Sar	Bacillariophyta	Coscinodiscophyceae	Chaetocerotales	Chaetocerotaceae	Chaetoceros	Chaetoceros tenuissimus
28946026	28946026	PRJNA694557_P_NODE_12308_length_379_cov_1.333333_g12088_i0	PRJNA694557	12308	379	1.333333	5.05333207	Phaeodactylum tricornutum CCAP 1	2850	SAR_Eukaryotes	SAR_Eukaryotes	177	3.4099999999999998e-53	NR	XP_002180880.1	556484	g12088	i0	69.7	0.941952506596306	119	36	94.2	0	378	22	135	253	XP_002180880.1 predicted protein [Phaeodactylum tricornutum CCAP 1055/1]	diamond	357	177	1	Eukaryota	Sar	Bacillariophyta	Bacillariophyceae	Naviculales	Phaeodactylaceae	Phaeodactylum	Phaeodactylum tricornutum
29198522	29198522	PRJNA694557_P_NODE_16769_length_313_cov_1.900000_g16549_i0	PRJNA694557	16769	313	1.9	5.947	Phaeodactylum tricornutum CCAP 1	2850	SAR_Eukaryotes	SAR_Eukaryotes	62	8.2e-9	NR	XP_002180880.1	556484	g16549	i0	56.5	0.440894568690096	46	20	44.1	0	175	312	65	110	XP_002180880.1 predicted protein [Phaeodactylum tricornutum CCAP 1055/1]	diamond	138	62	1	Eukaryota	Sar	Bacillariophyta	Bacillariophyceae	Naviculales	Phaeodactylaceae	Phaeodactylum	Phaeodactylum tricornutum
29230153	29230153	PRJNA694557_P_NODE_6689_length_557_cov_3.768595_g6470_i0	PRJNA694557	6689	557	3.768595	20.99107415	Mayamaea pseudoterrestris	2872254	SAR_Eukaryotes	SAR_Eukaryotes	206	2.4299999999999998e-60	NR	GKY93920.1	2872254	g6470	i0	62.5	1.54578096947935	144	54	77.6	0	1	432	403	546	GKY93920.1 hypothetical protein MPSEU_000358900 [Mayamaea pseudoterrestris]	diamond	861	206	1	Eukaryota	Sar	Bacillariophyta	Bacillariophyceae	Naviculales	Naviculaceae	Mayamaea	Mayamaea pseudoterrestris
29798139	29798139	PRJNA694557_P_NODE_16351_length_318_cov_1.257143_g16131_i0	PRJNA694557	16351	318	1.257143	3.99771474	Phaeodactylum tricornutum CCAP 1	2850	SAR_Eukaryotes	SAR_Eukaryotes	70.9	1.23e-11	NR	XP_002178656.1	556484	g16131	i0	69.7	0.622641509433962	66	16	60.4	3	192	1	1	64	XP_002178656.1 transketolase [Phaeodactylum tricornutum CCAP 1055/1]	diamond	198	70.9	1	Eukaryota	Sar	Bacillariophyta	Bacillariophyceae	Naviculales	Phaeodactylaceae	Phaeodactylum	Phaeodactylum tricornutum
29967594	29967594	PRJNA694557_P_NODE_24591_length_246_cov_0.890173_g24371_i0	PRJNA694557	24591	246	0.890173	2.18982558	Bacillariophyta	2836	SAR_Eukaryotes	SAR_Eukaryotes	150	4.379999999999999e-40	NR	GFH43592.1	426638	g24371	i0	86.3	1.95121951219512	80	11	97.6	0	245	6	280	359	GFH43592.1 transketolase [Chaetoceros tenuissimus]	diamond	480	150	1	Eukaryota	Sar	Bacillariophyta	Coscinodiscophyceae	Chaetocerotales	Chaetocerotaceae	Chaetoceros	Chaetoceros tenuissimus
31452910	31452910	PRJNA694557_P_NODE_8656_length_472_cov_1.478697_g8436_i0	PRJNA694557	8656	472	1.478697	6.97944984	Bacillariophyta	2836	SAR_Eukaryotes	SAR_Eukaryotes	163	1.5199999999999996e-43	NR	VEU40729.1	183589	g8436	i0	87.2	2.73305084745763	86	11	54.7	0	3	260	112	197	VEU40729.1 unnamed protein product [Pseudo-nitzschia multistriata]	diamond	1290	164	0.99390243902439	Eukaryota	Sar	Bacillariophyta	Bacillariophyceae	Bacillariales	Bacillariaceae	Pseudo-nitzschia	Pseudo-nitzschia multistriata

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