metadata: contig_metadata: 6 rows where bioproject = "PRJNA896758" and tax

6 rows where bioproject = "PRJNA896758" 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
28042595	28042595	PRJNA896758_P_NODE_18645_length_269_cov_1.714286_g18255_i0	PRJNA896758	18645	269	1.714286	4.61142934	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	55.5	1.69e-6	NR	KAI2505127.1	210448	g18255	i0	37.8	1.98513011152416	90	41	83.6	4	28	252	174	263	KAI2505127.1 hypothetical protein MHU86_9315 [Fragilaria crotonensis]	diamond	534	55.5	1	Eukaryota	Sar	Bacillariophyta	Fragilariophyceae	Fragilariales	Fragilariaceae	Fragilaria	Fragilaria crotonensis
28516230	28516230	PRJNA896758_P_NODE_5867_length_470_cov_1.052897_g5478_i0	PRJNA896758	5867	470	1.052897	4.9486159	root	1	Root_unresolved	Root_unresolved	121	1.31e-28	NR	KAL3778812.1	29204	g5478	i0	41.6	5.72553191489362	154	89	97.7	1	464	6	1431	1584	KAL3778812.1 hypothetical protein HJC23_009845 [Cyclotella cryptica]	diamond	2691	121	1	Eukaryota	Sar	Bacillariophyta	Coscinodiscophyceae	Stephanodiscales	Stephanodiscaceae	Cyclotella	Cyclotella cryptica
31074525	31074525	PRJNA896758_P_NODE_15715_length_289_cov_1.203704_g15325_i0	PRJNA896758	15715	289	1.203704	3.47870456	root	1	Root_unresolved	Root_unresolved	87.8	8.56e-18	NR	6LKZ_C	2850	g15325	i0	66.1	4.50519031141869	59	20	61.2	0	178	2	3	61	6LKZ_C Chain C, isocitrate dehydrogenase [Phaeodactylum tricornutum]	diamond	1302	88.6	0.99097065462754	Eukaryota	Sar	Bacillariophyta	Bacillariophyceae	Naviculales	Phaeodactylaceae	Phaeodactylum	Phaeodactylum tricornutum
31414552	31414552	PRJNA896758_P_NODE_26016_length_242_cov_0.911243_g25626_i0	PRJNA896758	26016	242	0.911243	2.20520806	Fistulifera solaris	1519565	SAR_Eukaryotes	SAR_Eukaryotes	52.4	1.47e-5	NR	GAX15755.1	1519565	g25626	i0	45.1	3.29752066115702	51	28	63.2	0	61	213	552	602	GAX15755.1 hypothetical protein FisN_3Lh193 [Fistulifera solaris]	diamond	798	52.4	1	Eukaryota	Sar	Bacillariophyta	Bacillariophyceae	Naviculales	Naviculaceae	Fistulifera	Fistulifera solaris
31699233	31699233	PRJNA896758_P_NODE_21617_length_250_cov_1.395480_g21227_i0	PRJNA896758	21617	250	1.39548	3.4887	Bacillariaceae sp.	3061772	SAR_Eukaryotes	SAR_Eukaryotes	114	1.78e-30	NR	KAL3932861.1	3061772	g21227	i0	58.7	4.38	92	26	96	1	9	248	21	112	KAL3932861.1 MAG: hypothetical protein SGARI_003851 [Bacillariaceae sp.]	diamond	1095	114	1	Eukaryota	Sar	Bacillariophyta	Bacillariophyceae	Bacillariales	Bacillariaceae		Bacillariaceae sp.
32363821	32363821	PRJNA896758_P_NODE_24119_length_246_cov_0.890173_g23729_i0	PRJNA896758	24119	246	0.890173	2.18982558	Cylindrotheca closterium	2856	SAR_Eukaryotes	SAR_Eukaryotes	95.5	1.16e-21	NR	CAJ1965656.1	2856	g23729	i0	54.9	3.97560975609756	82	31	98.8	3	244	2	111	187	CAJ1965656.1 unnamed protein product [Cylindrotheca closterium]	diamond	978	95.5	1	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);;