metadata: contig_metadata: 9 rows where bioproject = "PRJNA833575", tax_clade = "Sar" and tax

9 rows where bioproject = "PRJNA833575", 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
26674439	26674439	PRJNA833575_P_NODE_40261_length_233_cov_0.878049_g40124_i0	PRJNA833575	40261	233	0.878049	2.04585417	Seminavis robusta	568900	SAR_Eukaryotes	SAR_Eukaryotes	96.3	1.1799999999999999e-23	NR	CAB9521274.1	568900	g40124	i0	58.1	0.952789699570815	74	31	95.3	0	232	11	20	93	CAB9521274.1 BolA-like protein 1 [Seminavis robusta]	diamond	222	96.3	1	Eukaryota	Sar	Bacillariophyta	Bacillariophyceae	Naviculales	Naviculaceae	Seminavis	Seminavis robusta
27054712	27054712	PRJNA833575_P_NODE_7102_length_533_cov_1.633621_g6965_i0	PRJNA833575	7102	533	1.633621	8.70719993	Pseudo-nitzschia multistriata	183589	SAR_Eukaryotes	SAR_Eukaryotes	63.2	5.55e-8	NR	VEU33820.1	183589	g6965	i0	27.7	0.872420262664165	155	106	85	3	456	4	178	330	VEU33820.1 unnamed protein product [Pseudo-nitzschia multistriata]	diamond	465	63.2	1	Eukaryota	Sar	Bacillariophyta	Bacillariophyceae	Bacillariales	Bacillariaceae	Pseudo-nitzschia	Pseudo-nitzschia multistriata
28033907	28033907	PRJNA833575_P_NODE_26385_length_290_cov_1.045249_g26248_i0	PRJNA833575	26385	290	1.045249	3.0312221	Cyclostephanos tholiformis	382380	SAR_Eukaryotes	SAR_Eukaryotes	51.2	7.15e-5	NR	KAL3810809.1	382380	g26248	i0	31.3	0.993103448275862	96	64	99.3	1	3	290	2842	2935	KAL3810809.1 hypothetical protein ACHAXA_008824, partial [Cyclostephanos tholiformis]	diamond	288	51.2	1	Eukaryota	Sar	Bacillariophyta	Coscinodiscophyceae	Stephanodiscales	Stephanodiscaceae	Cyclostephanos	Cyclostephanos tholiformis
28381045	28381045	PRJNA833575_P_NODE_33206_length_257_cov_1.340426_g33069_i0	PRJNA833575	33206	257	1.340426	3.44489482	Cyclotella atomus	382360	SAR_Eukaryotes	SAR_Eukaryotes	71.6	3.03e-12	NR	KAL3788716.1	382360	g33069	i0	43.2	2.06614785992218	88	45	96.9	2	4	252	415	502	KAL3788716.1 hypothetical protein ACHAWO_004571 [Cyclotella atomus]	diamond	531	71.6	1	Eukaryota	Sar	Bacillariophyta	Coscinodiscophyceae	Stephanodiscales	Stephanodiscaceae	Cyclotella	Cyclotella atomus
29580577	29580577	PRJNA833575_P_NODE_38850_length_235_cov_0.867470_g38713_i0	PRJNA833575	38850	235	0.86747	2.0385545	Thalassiosira pseudonana CCMP1335	296543	SAR_Eukaryotes	SAR_Eukaryotes	55.8	7.92e-7	NR	XP_002289633.1	296543	g38713	i0	41.7	1.57021276595745	72	39	91.9	1	227	12	426	494	XP_002289633.1 predicted protein [Thalassiosira pseudonana CCMP1335]	diamond	369	55.8	1	Eukaryota	Sar	Bacillariophyta	Coscinodiscophyceae	Thalassiosirales	Thalassiosiraceae	Thalassiosira	Thalassiosira pseudonana
30568371	30568371	PRJNA833575_P_NODE_40453_length_233_cov_0.878049_g40316_i0	PRJNA833575	40453	233	0.878049	2.04585417	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	85.5	2.92e-17	NR	EJK47659.1	159749	g40316	i0	66.1	3.78540772532189	59	18	73.4	1	171	1	432	490	EJK47659.1 hypothetical protein THAOC_33606 [Thalassiosira oceanica]	diamond	882	85.5	1	Eukaryota	Sar	Bacillariophyta	Coscinodiscophyceae	Thalassiosirales	Thalassiosiraceae	Thalassiosira	Thalassiosira oceanica
31603315	31603315	PRJNA833575_P_NODE_40596_length_233_cov_0.878049_g40459_i0	PRJNA833575	40596	233	0.878049	2.04585417	Fistulifera solaris	1519565	SAR_Eukaryotes	SAR_Eukaryotes	87	6.9e-18	NR	GAX13433.1	1519565	g40459	i0	51.3	2.98712446351931	78	35	97.9	2	4	231	188	264	GAX13433.1 kynurenine---oxoglutarate transaminase / cysteine-S-conjugate beta-lyase / glutamine---phenylpyruvate transaminase [Fistulifera solaris]	diamond	696	87	1	Eukaryota	Sar	Bacillariophyta	Bacillariophyceae	Naviculales	Naviculaceae	Fistulifera	Fistulifera solaris
31887823	31887823	PRJNA833575_P_NODE_11417_length_427_cov_2.008380_g11280_i0	PRJNA833575	11417	427	2.00838	8.5757826	Chaetoceros tenuissimus	426638	SAR_Eukaryotes	SAR_Eukaryotes	73.6	4.79e-12	NR	GFH47004.1	426638	g11280	i0	28	0.927400468384075	132	90	89.9	4	10	393	133	263	GFH47004.1 hypothetical protein CTEN210_03479 [Chaetoceros tenuissimus]	diamond	396	73.6	1	Eukaryota	Sar	Bacillariophyta	Coscinodiscophyceae	Chaetocerotales	Chaetocerotaceae	Chaetoceros	Chaetoceros tenuissimus
32646512	32646512	PRJNA833575_P_NODE_42160_length_231_cov_0.888889_g42023_i0	PRJNA833575	42160	231	0.888889	2.05333359	Nitzschia inconspicua	303405	SAR_Eukaryotes	SAR_Eukaryotes	49.7	1.08e-4	NR	KAG7366421.1	303405	g42023	i0	60	0.454545454545455	35	14	45.5	0	229	125	42	76	KAG7366421.1 RNA-binding region RNP-1 containing protein [Nitzschia inconspicua]	diamond	105	49.7	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);;