metadata: contig_metadata: 7 rows where bioproject = "PRJNA554794", tax_clade = "Sar" and tax

7 rows where bioproject = "PRJNA554794", 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
5624730	5624730	PRJNA554794_P_NODE_13045_length_256_cov_3.642512_g9116_i0	PRJNA554794	13045	256	3.642512	9.32483072	Navicula avium	2018708	SAR_Eukaryotes	SAR_Eukaryotes	97.1	1.06e-15	NTclustered	gi\|2721953916\|gb\|OR464343.1\|	2018708	g9116	i0	77.401	6.29296875	177	31	67	8	15	185	45347	45520	Haslea avium mitochondrion, complete genome	blastn	1611	97.1	1	Eukaryota	Sar	Bacillariophyta	Bacillariophyceae	Naviculales	Naviculaceae	Navicula	Navicula avium
27345900	27345900	PRJNA554794_P_NODE_22663_length_167_cov_0.864407_g18734_i0	PRJNA554794	22663	167	0.864407	1.44355969	Bacillariophyta	2836	SAR_Eukaryotes	SAR_Eukaryotes	82.8	4.55e-17	NR	CAJ1930326.1	2856	g18734	i0	85.2	15.5209580838323	54	8	97	0	2	163	252	305	CAJ1930326.1 unnamed protein product [Cylindrotheca closterium]	diamond	2592	82.8	1	Eukaryota	Sar	Bacillariophyta	Bacillariophyceae	Bacillariales	Bacillariaceae	Cylindrotheca	Cylindrotheca closterium
28324442	28324442	PRJNA554794_P_NODE_24226_length_162_cov_0.902655_g20297_i0	PRJNA554794	24226	162	0.902655	1.4623011	Bacillariophyta	2836	SAR_Eukaryotes	SAR_Eukaryotes	102	1.63e-25	NR	GKY93303.1	2872254	g20297	i0	94.3	4.90740740740741	53	3	98.1	0	161	3	85	137	GKY93303.1 60S ribosomal protein L15-2 [Mayamaea pseudoterrestris]	diamond	795	102	1	Eukaryota	Sar	Bacillariophyta	Bacillariophyceae	Naviculales	Naviculaceae	Mayamaea	Mayamaea pseudoterrestris
29351994	29351994	PRJNA554794_P_NODE_24289_length_162_cov_0.893805_g20360_i0	PRJNA554794	24289	162	0.893805	1.4479641	Fragilaria crotonensis	210448	SAR_Eukaryotes	SAR_Eukaryotes	77.4	6.07e-16	NR	KAI2509358.1	210448	g20360	i0	94.6	2.77777777777778	37	2	68.5	0	1	111	148	184	KAI2509358.1 chlorophyll A-B binding protein [Fragilaria crotonensis]	diamond	450	77.4	1	Eukaryota	Sar	Bacillariophyta	Fragilariophyceae	Fragilariales	Fragilariaceae	Fragilaria	Fragilaria crotonensis
30535101	30535101	PRJNA554794_P_NODE_8053_length_564_cov_1.320388_g4437_i0	PRJNA554794	8053	564	1.320388	7.44698832	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	49.7	0.00293	NR	KAG7370307.1	303405	g4437	i0	28.9	5.10106382978723	190	92	80.9	10	41	496	9	193	KAG7370307.1 bacterial-like globin [Nitzschia inconspicua]	diamond	2877	50.1	0.992015968063872	Eukaryota	Sar	Bacillariophyta	Bacillariophyceae	Bacillariales	Bacillariaceae	Nitzschia	Nitzschia inconspicua
31595469	31595469	PRJNA554794_P_NODE_7476_length_627_cov_1.256055_g3977_i0	PRJNA554794	7476	627	1.256055	7.87546485	Nitzschia inconspicua	303405	SAR_Eukaryotes	SAR_Eukaryotes	46.6	0.0466	NR	KAG7344801.1	303405	g3977	i0	35.3	0.488038277511962	102	58	48.8	3	213	518	554	647	KAG7344801.1 bacterial-like globin [Nitzschia inconspicua]	diamond	306	46.6	1	Eukaryota	Sar	Bacillariophyta	Bacillariophyceae	Bacillariales	Bacillariaceae	Nitzschia	Nitzschia inconspicua
32432548	32432548	PRJNA554794_P_NODE_23299_length_165_cov_0.870690_g19370_i0	PRJNA554794	23299	165	0.87069	1.4366385	Bacillariophyta	2836	SAR_Eukaryotes	SAR_Eukaryotes	105	5.87e-25	NR	CAJ1949580.1	2856	g19370	i0	87	4.90909090909091	54	7	98.2	0	163	2	467	520	CAJ1949580.1 unnamed protein product [Cylindrotheca closterium]	diamond	810	106	0.990566037735849	Eukaryota	Sar	Bacillariophyta	Bacillariophyceae	Bacillariales	Bacillariaceae	Cylindrotheca	Cylindrotheca closterium

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