metadata: contig_metadata: 4 rows where bioproject = "PRJNA1248424", tax_clade = "Sar" and tax

4 rows where bioproject = "PRJNA1248424", tax_clade = "Sar" and tax_phylum = "Bacillariophyta"

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
27579095	27579095	PRJNA1248424_P_NODE_81004_length_236_cov_2.558282_g74935_i0	PRJNA1248424	81004	236	2.558282	6.03754552	Pseudo-nitzschia multistriata	183589	SAR_Eukaryotes	SAR_Eukaryotes	85.5	3.02e-17	NR	VEU39903.1	183589	g74935	i0	51.3	0.966101694915254	76	37	96.6	0	8	235	748	823	VEU39903.1 unnamed protein product [Pseudo-nitzschia multistriata]	diamond	228	85.5	1	Eukaryota	Sar	Bacillariophyta	Bacillariophyceae	Bacillariales	Bacillariaceae	Pseudo-nitzschia	Pseudo-nitzschia multistriata
30578898	30578898	PRJNA1248424_P_NODE_76553_length_244_cov_1.128655_g70484_i0	PRJNA1248424	76553	244	1.128655	2.7539182	Cylindrotheca closterium	2856	SAR_Eukaryotes	SAR_Eukaryotes	50.4	5.21e-5	NR	CAJ1934411.1	2856	g70484	i0	45.6	0.836065573770492	68	33	82.4	3	38	238	86	150	CAJ1934411.1 unnamed protein product [Cylindrotheca closterium]	diamond	204	50.4	1	Eukaryota	Sar	Bacillariophyta	Bacillariophyceae	Bacillariales	Bacillariaceae	Cylindrotheca	Cylindrotheca closterium
31527461	31527461	PRJNA1248424_P_NODE_79396_length_242_cov_0.911243_g73327_i0	PRJNA1248424	79396	242	0.911243	2.20520806	Bacillariaceae sp.	3061772	SAR_Eukaryotes	SAR_Eukaryotes	50.4	1.29e-5	NR	KAL3923488.1	3061772	g73327	i0	44.7	1.16528925619835	47	26	58.3	0	5	145	21	67	KAL3923488.1 MAG: hypothetical protein SGILL_001628 [Bacillariaceae sp.]	diamond	282	50.4	1	Eukaryota	Sar	Bacillariophyta	Bacillariophyceae	Bacillariales	Bacillariaceae		Bacillariaceae sp.
31956531	31956531	PRJNA1248424_P_NODE_53757_length_292_cov_0.881279_g47689_i0	PRJNA1248424	53757	292	0.881279	2.57333468	root	1	Root_unresolved	Root_unresolved	47	0.00187	NR	EJK62404.1	159749	g47689	i0	40.8	8.46575342465753	49	29	50.3	0	290	144	204	252	EJK62404.1 hypothetical protein THAOC_16984 [Thalassiosira oceanica]	diamond	2472	47.4	0.991561181434599	Eukaryota	Sar	Bacillariophyta	Coscinodiscophyceae	Thalassiosirales	Thalassiosiraceae	Thalassiosira	Thalassiosira oceanica

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