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

4 rows where bioproject = "PRJNA356682", 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
8050661	8050661	PRJNA356682_P_NODE_21347_length_313_cov_9.075000_g20656_i0	PRJNA356682	21347	313	9.075	28.40475	Minutocellus polymorphus	265543	SAR_Eukaryotes	SAR_Eukaryotes	126	1.7e-24	NTclustered	gi\|2020303798\|gb\|MW417227.1\|	265543	g20656	i0	77.934	3.80830670926518	213	39	67	7	84	292	8483	8691	Minutocellus polymorphus isolate CNS00217 mitochondrion, complete genome	blastn	1192	126	1	Eukaryota	Sar	Bacillariophyta	Mediophyceae	Cymatosirales	Cymatosiraceae	Minutocellus	Minutocellus polymorphus
15100156	15100156	PRJNA356682_P_NODE_30932_length_267_cov_6.515464_g30241_i0	PRJNA356682	30932	267	6.515464	17.39628888	Chaetoceros	49237	SAR_Eukaryotes	SAR_Eukaryotes	124	5.099999999999999e-24	NTclustered	gi\|126116701\|gb\|EF423439.1\|	426684	g30241	i0	84.091	49.3483146067416	132	17	49	4	1	131	328	200	Chaetoceros sp. strain DH29 large subunit ribosomal RNA gene, partial sequence	blastn	13176	124	1	Eukaryota	Sar	Bacillariophyta	Coscinodiscophyceae	Chaetocerotales	Chaetocerotaceae	Chaetoceros	Chaetoceros sp. strain DH29
28590862	28590862	PRJNA356682_P_NODE_33027_length_260_cov_1.593583_g32336_i0	PRJNA356682	33027	260	1.593583	4.1433158	Mayamaea pseudoterrestris	2872254	SAR_Eukaryotes	SAR_Eukaryotes	67	1.22e-10	NR	GKY91104.1	2872254	g32336	i0	61.4	1.01538461538462	44	17	50.8	0	133	2	246	289	GKY91104.1 elongation factor 1-gamma [Mayamaea pseudoterrestris]	diamond	264	67	1	Eukaryota	Sar	Bacillariophyta	Bacillariophyceae	Naviculales	Naviculaceae	Mayamaea	Mayamaea pseudoterrestris
31338715	31338715	PRJNA356682_P_NODE_22816_length_305_cov_1.284483_g22125_i0	PRJNA356682	22816	305	1.284483	3.91767315	Nitzschia inconspicua	303405	SAR_Eukaryotes	SAR_Eukaryotes	100	1.04e-24	NR	KAG7373989.1	303405	g22125	i0	47.6	4.90819672131148	103	52	99.3	1	305	3	18	120	KAG7373989.1 50S ribosomal protein L14e [Nitzschia inconspicua]	diamond	1497	100	1	Eukaryota	Sar	Bacillariophyta	Bacillariophyceae	Bacillariales	Bacillariaceae	Nitzschia	Nitzschia inconspicua

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