metadata: contig_metadata: 4 rows where bioproject = "PRJNA448207" and tax

4 rows where bioproject = "PRJNA448207" 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
28623698	28623698	PRJNA448207_P_NODE_29207_length_246_cov_0.890173_g29044_i0	PRJNA448207	29207	246	0.890173	2.18982558	Seminavis robusta	568900	SAR_Eukaryotes	SAR_Eukaryotes	115	9.949999999999999e-28	NR	CAB9510069.1	568900	g29044	i0	67.5	0.975609756097561	80	26	97.6	0	6	245	254	333	CAB9510069.1 Retinal-specific ATP-binding cassette transporter [Seminavis robusta]	diamond	240	115	1	Eukaryota	Sar	Bacillariophyta	Bacillariophyceae	Naviculales	Naviculaceae	Seminavis	Seminavis robusta
30392467	30392467	PRJNA448207_P_NODE_26393_length_250_cov_0.870056_g26230_i0	PRJNA448207	26393	250	0.870056	2.17514	Fistulifera solaris	1519565	SAR_Eukaryotes	SAR_Eukaryotes	89.4	1.06e-19	NR	GAX13124.1	1519565	g26230	i0	68.4	1.824	76	23	91.2	1	249	22	151	225	GAX13124.1 hypothetical protein FisN_17Hh053 [Fistulifera solaris]	diamond	456	89.4	1	Eukaryota	Sar	Bacillariophyta	Bacillariophyceae	Naviculales	Naviculaceae	Fistulifera	Fistulifera solaris
30534621	30534621	PRJNA448207_P_NODE_25513_length_251_cov_0.865169_g25350_i0	PRJNA448207	25513	251	0.865169	2.17157419	Bacillariophyceae	33849	SAR_Eukaryotes	SAR_Eukaryotes	49.7	1.46e-4	NR	KAG7354329.1	303405	g25350	i0	76.9	0.932270916334661	26	6	31.1	0	250	173	601	626	KAG7354329.1 phosphoenolpyruvate carboxykinase [Nitzschia inconspicua]	diamond	234	50.1	0.992015968063872	Eukaryota	Sar	Bacillariophyta	Bacillariophyceae	Bacillariales	Bacillariaceae	Nitzschia	Nitzschia inconspicua
30802735	30802735	PRJNA448207_P_NODE_26934_length_249_cov_0.875000_g26771_i0	PRJNA448207	26934	249	0.875	2.17875	Fistulifera solaris	1519565	SAR_Eukaryotes	SAR_Eukaryotes	120	1.16e-31	NR	GAX26690.1	1519565	g26771	i0	69.9	1	83	25	100	0	249	1	127	209	GAX26690.1 hypothetical protein FisN_2Hh367 [Fistulifera solaris]	diamond	249	120	1	Eukaryota	Sar	Bacillariophyta	Bacillariophyceae	Naviculales	Naviculaceae	Fistulifera	Fistulifera solaris

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