metadata: contig_metadata: 10 rows where bioproject = "PRJNA169559" and tax

10 rows where bioproject = "PRJNA169559" 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
16357185	16357185	PRJNA169559_P_NODE_12073_length_485_cov_1.857456_g10218_i0	PRJNA169559	12073	485	1.857456	9.0086616	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	119	3.57e-30	NR	KAL3802215.1	29204	g10218	i0	74.4	37.8989690721649	78	20	48.2	0	186	419	110	187	KAL3802215.1 hypothetical protein HJC23_001759 [Cyclotella cryptica]	diamond	18381	120	0.991666666666667	Eukaryota	Sar	Bacillariophyta	Coscinodiscophyceae	Stephanodiscales	Stephanodiscaceae	Cyclotella	Cyclotella cryptica
16942118	16942118	PRJNA169559_P_NODE_13894_length_450_cov_4.061758_g11978_i0	PRJNA169559	13894	450	4.061758	18.277911	Thalassiosira oceanica	159749	SAR_Eukaryotes	SAR_Eukaryotes	132	1.3e-36	NR	EJK75259.1	159749	g11978	i0	63.1	0.686666666666667	103	37	68	1	100	405	9	111	EJK75259.1 hypothetical protein THAOC_03022 [Thalassiosira oceanica]	diamond	309	132	1	Eukaryota	Sar	Bacillariophyta	Coscinodiscophyceae	Thalassiosirales	Thalassiosiraceae	Thalassiosira	Thalassiosira oceanica
20766412	20766412	PRJNA169559_P_NODE_15797_length_425_cov_2.262626_g13837_i0	PRJNA169559	15797	425	2.262626	9.6161605	Bacillariophyta	2836	SAR_Eukaryotes	SAR_Eukaryotes	72.8	1.42e-13	NR	KAI2505161.1	210448	g13837	i0	55.4	1.60235294117647	56	25	39.5	0	329	162	12	67	KAI2505161.1 K6-linked polyubiquitin modification-dependent protein binding protein [Fragilaria crotonensis]	diamond	681	73.2	0.994535519125683	Eukaryota	Sar	Bacillariophyta	Fragilariophyceae	Fragilariales	Fragilariaceae	Fragilaria	Fragilaria crotonensis
27421801	27421801	PRJNA169559_P_NODE_33743_length_251_cov_1.761261_g31666_i0	PRJNA169559	33743	251	1.761261	4.42076511	Fragilariopsis cylindrus CCMP11	186039	SAR_Eukaryotes	SAR_Eukaryotes	44.3	0.0112	NR	OEU20283.1	635003	g31666	i0	32.9	2.0199203187251	85	55	99.2	1	251	3	204	288	OEU20283.1 Pkinase-domain-containing protein [Fragilariopsis cylindrus CCMP1102]	diamond	507	44.3	1	Eukaryota	Sar	Bacillariophyta	Bacillariophyceae	Bacillariales	Bacillariaceae	Fragilariopsis	Fragilariopsis cylindrus
29126832	29126832	PRJNA169559_P_NODE_44969_length_216_cov_1.679144_g42892_i0	PRJNA169559	44969	216	1.679144	3.62695104	Cyclotella cryptica	29204	SAR_Eukaryotes	SAR_Eukaryotes	63.9	8.85e-10	NR	KAL3788956.1	29204	g42892	i0	46.8	2.56944444444444	62	33	86.1	0	10	195	344	405	KAL3788956.1 hypothetical protein HJC23_000240 [Cyclotella cryptica]	diamond	555	63.9	1	Eukaryota	Sar	Bacillariophyta	Coscinodiscophyceae	Stephanodiscales	Stephanodiscaceae	Cyclotella	Cyclotella cryptica
31527763	31527763	PRJNA169559_P_NODE_2916_length_969_cov_2.653191_g1922_i0	PRJNA169559	2916	969	2.653191	25.70942079	Seminavis robusta	568900	SAR_Eukaryotes	SAR_Eukaryotes	111	1.6399999999999998e-23	NR	CAB9518259.1	568900	g1922	i0	46.8	0.38390092879257	124	65	38.4	1	941	570	137	259	CAB9518259.1 protocatechuate 3,4-dioxygenase [Seminavis robusta]	diamond	372	111	1	Eukaryota	Sar	Bacillariophyta	Bacillariophyceae	Naviculales	Naviculaceae	Seminavis	Seminavis robusta
31748929	31748929	PRJNA169559_P_NODE_25017_length_302_cov_2.150183_g22941_i0	PRJNA169559	25017	302	2.150183	6.49355266	Cyclotella cryptica	29204	SAR_Eukaryotes	SAR_Eukaryotes	53.5	1.23e-5	NR	KAL3803881.1	29204	g22941	i0	43.9	0.566225165562914	57	24	48.7	1	14	160	664	720	KAL3803881.1 hypothetical protein HJC23_004043, partial [Cyclotella cryptica]	diamond	171	53.5	1	Eukaryota	Sar	Bacillariophyta	Coscinodiscophyceae	Stephanodiscales	Stephanodiscaceae	Cyclotella	Cyclotella cryptica
32065372	32065372	PRJNA169559_P_NODE_10618_length_519_cov_2.042857_g8835_i0	PRJNA169559	10618	519	2.042857	10.60242783	Fragilaria crotonensis	210448	SAR_Eukaryotes	SAR_Eukaryotes	99.8	7.37e-22	NR	KAI2502852.1	210448	g8835	i0	35.1	1.31791907514451	114	74	65.9	0	449	108	77	190	KAI2502852.1 Ribosomal L30 N-terminal domain [Fragilaria crotonensis]	diamond	684	99.8	1	Eukaryota	Sar	Bacillariophyta	Fragilariophyceae	Fragilariales	Fragilariaceae	Fragilaria	Fragilaria crotonensis
32381908	32381908	PRJNA169559_P_NODE_3099_length_942_cov_2.627601_g1922_i1	PRJNA169559	3099	942	2.627601	24.75200142	Seminavis robusta	568900	SAR_Eukaryotes	SAR_Eukaryotes	111	1.36e-23	NR	CAB9518259.1	568900	g1922	i1	46.8	0.394904458598726	124	65	39.5	1	914	543	137	259	CAB9518259.1 protocatechuate 3,4-dioxygenase [Seminavis robusta]	diamond	372	111	1	Eukaryota	Sar	Bacillariophyta	Bacillariophyceae	Naviculales	Naviculaceae	Seminavis	Seminavis robusta
32697469	32697469	PRJNA169559_P_NODE_25180_length_300_cov_2.173432_g23104_i0	PRJNA169559	25180	300	2.173432	6.520296	Thalassiosira pseudonana CCMP1335	296543	SAR_Eukaryotes	SAR_Eukaryotes	92.8	1.15e-20	NR	XP_002294877.1	296543	g23104	i0	53.4	3.52	88	29	76	1	298	71	146	233	XP_002294877.1 proteasome subunit alpha type 2 [Thalassiosira pseudonana CCMP1335]	diamond	1056	92.8	1	Eukaryota	Sar	Bacillariophyta	Coscinodiscophyceae	Thalassiosirales	Thalassiosiraceae	Thalassiosira	Thalassiosira pseudonana

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