metadata: contig_metadata: 8 rows where bioproject = "PRJNA816047" and tax

8 rows where bioproject = "PRJNA816047" 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
25876885	25876885	PRJNA816047d_S_NODE_54995_length_301_cov_1.689516_g53160_i0	PRJNA816047	54995	301	1.689516	5.08544316	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	179	1.17e-49	NR	CAJ1966911.1	2856	g53160	i0	91	102.099667774086	89	8	88.7	0	299	33	889	977	CAJ1966911.1 unnamed protein product [Cylindrotheca closterium]	diamond	30732	180	0.994444444444444	Eukaryota	Sar	Bacillariophyta	Bacillariophyceae	Bacillariales	Bacillariaceae	Cylindrotheca	Cylindrotheca closterium
32956609	32956609	PRJNA816047d_S_NODE_84994_length_259_cov_1.883495_g83159_i0	PRJNA816047	84994	259	1.883495	4.87825205	Cyclotella atomus	382360	SAR_Eukaryotes	SAR_Eukaryotes	107	2.35e-25	NR	KAL3779121.1	382360	g83159	i0	55.7	0.915057915057915	79	33	89.2	1	3	233	321	399	KAL3779121.1 hypothetical protein ACHAWO_004576, partial [Cyclotella atomus]	diamond	237	107	1	Eukaryota	Sar	Bacillariophyta	Coscinodiscophyceae	Stephanodiscales	Stephanodiscaceae	Cyclotella	Cyclotella atomus
32959470	32959470	PRJNA816047d_S_NODE_56330_length_298_cov_2.110204_g54495_i0	PRJNA816047	56330	298	2.110204	6.28840792	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	94.7	2.11e-22	NR	GFH51382.1	426638	g54495	i0	58.4	14.8590604026846	77	32	77.5	0	294	64	64	140	GFH51382.1 ribosomal L23-domain-containing protein [Chaetoceros tenuissimus]	diamond	4428	95.5	0.991623036649215	Eukaryota	Sar	Bacillariophyta	Coscinodiscophyceae	Chaetocerotales	Chaetocerotaceae	Chaetoceros	Chaetoceros tenuissimus
33007648	33007648	PRJNA816047d_S_NODE_75379_length_266_cov_3.361502_g73544_i0	PRJNA816047	75379	266	3.361502	8.94159532	Chaetoceros tenuissimus	426638	SAR_Eukaryotes	SAR_Eukaryotes	76.3	4.02e-14	NR	GFH48322.1	426638	g73544	i0	51.6	7.73684210526316	62	30	69.9	0	228	43	126	187	GFH48322.1 phosphoglycerate mutase [Chaetoceros tenuissimus]	diamond	2058	76.3	1	Eukaryota	Sar	Bacillariophyta	Coscinodiscophyceae	Chaetocerotales	Chaetocerotaceae	Chaetoceros	Chaetoceros tenuissimus
33058576	33058576	PRJNA816047d_S_NODE_42757_length_332_cov_6.946237_g40922_i0	PRJNA816047	42757	332	6.946237	23.06150684	Cyclotella cryptica	29204	SAR_Eukaryotes	SAR_Eukaryotes	65.5	1.07e-9	NR	KAL3798039.1	29204	g40922	i0	64	0.451807228915663	50	18	45.2	0	150	1	381	430	KAL3798039.1 hypothetical protein HJC23_012330 [Cyclotella cryptica]	diamond	150	65.5	1	Eukaryota	Sar	Bacillariophyta	Coscinodiscophyceae	Stephanodiscales	Stephanodiscaceae	Cyclotella	Cyclotella cryptica
33092605	33092605	PRJNA816047d_S_NODE_135598_length_226_cov_2.121387_g133763_i0	PRJNA816047	135598	226	2.121387	4.79433462	Phaeodactylum tricornutum CCAP 1	2850	SAR_Eukaryotes	SAR_Eukaryotes	84.3	1.89e-17	NR	XP_002179603.1	556484	g133763	i0	58.6	0.929203539823009	70	29	92.9	0	17	226	65	134	XP_002179603.1 coproporphyrinogen oxidase [Phaeodactylum tricornutum CCAP 1055/1]	diamond	210	84.3	1	Eukaryota	Sar	Bacillariophyta	Bacillariophyceae	Naviculales	Phaeodactylaceae	Phaeodactylum	Phaeodactylum tricornutum
33147008	33147008	PRJNA816047d_S_NODE_50503_length_311_cov_1.984496_g48668_i0	PRJNA816047	50503	311	1.984496	6.17178256	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	48.1	4.3e-4	NR	CAJ1969502.1	2856	g48668	i0	58.1	0.636655948553055	31	13	29.9	0	2	94	130	160	CAJ1969502.1 unnamed protein product [Cylindrotheca closterium]	diamond	198	48.5	0.991752577319588	Eukaryota	Sar	Bacillariophyta	Bacillariophyceae	Bacillariales	Bacillariaceae	Cylindrotheca	Cylindrotheca closterium
33178370	33178370	PRJNA816047d_S_NODE_73304_length_269_cov_3.787037_g71469_i0	PRJNA816047	73304	269	3.787037	10.18712953	Thalassiosira oceanica	159749	SAR_Eukaryotes	SAR_Eukaryotes	60.8	2.06e-8	NR	EJK54070.1	159749	g71469	i0	66.7	0.869888475836431	39	13	43.5	0	2	118	378	416	EJK54070.1 hypothetical protein THAOC_26379 [Thalassiosira oceanica]	diamond	234	60.8	1	Eukaryota	Sar	Bacillariophyta	Coscinodiscophyceae	Thalassiosirales	Thalassiosiraceae	Thalassiosira	Thalassiosira oceanica

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