metadata: contig_metadata: 6 rows where bioproject = "PRJEB50765", tax_clade = "Sar" and tax

6 rows where bioproject = "PRJEB50765", 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
6094470	6094470	PRJEB50765_P_NODE_1345_length_263_cov_2.123894_g1321_i0	PRJEB50765	1345	263	2.123894	5.58584122	Bacillariophyta	2836	SAR_Eukaryotes	SAR_Eukaryotes	152	1.5899999999999996e-43	NR	KAI2505670.1	210448	g1321	i0	79.3	7.93916349809886	87	18	99.2	0	2	262	119	205	KAI2505670.1 small subunit ribosomal protein [Fragilaria crotonensis]	diamond	2088	153	0.993464052287582	Eukaryota	Sar	Bacillariophyta	Fragilariophyceae	Fragilariales	Fragilariaceae	Fragilaria	Fragilaria crotonensis
7771948	7771948	PRJEB50765_P_NODE_1487_length_249_cov_1.726415_g1463_i0	PRJEB50765	1487	249	1.726415	4.29877335	Ditylum brightwellii	49249	SAR_Eukaryotes	SAR_Eukaryotes	243	1.25e-59	NTclustered	gi\|398372885\|gb\|JX305463.1\|	49249	g1463	i0	84.836	91.6184738955823	244	33	97	4	3	244	1129	1370	Ditylum brightwellii strain B-326 heat shock protein 70 (Hsp70) mRNA, complete cds	blastn	22813	243	1	Eukaryota	Sar	Bacillariophyta	Mediophyceae	Lithodesmiales	Lithodesmiaceae	Ditylum	Ditylum brightwellii
10322474	10322474	PRJEB50765_P_NODE_1329_length_265_cov_2.548246_g1305_i0	PRJEB50765	1329	265	2.548246	6.7528519	root	1	Root_unresolved	Root_unresolved	141	3.05e-39	NR	CAJ1931814.1	2856	g1305	i0	72.7	12.9509433962264	88	24	99.6	0	265	2	26	113	CAJ1931814.1 unnamed protein product [Cylindrotheca closterium]	diamond	3432	142	0.992957746478873	Eukaryota	Sar	Bacillariophyta	Bacillariophyceae	Bacillariales	Bacillariaceae	Cylindrotheca	Cylindrotheca closterium
30184718	30184718	PRJEB50765_P_NODE_1112_length_301_cov_2.484848_g1088_i0	PRJEB50765	1112	301	2.484848	7.47939248	Nitzschia	2857	SAR_Eukaryotes	SAR_Eukaryotes	85.9	5.42e-19	NR	KAG7373989.1	303405	g1088	i0	59.2	2.97009966777409	76	27	71.8	1	296	81	52	127	KAG7373989.1 50S ribosomal protein L14e [Nitzschia inconspicua]	diamond	894	85.9	1	Eukaryota	Sar	Bacillariophyta	Bacillariophyceae	Bacillariales	Bacillariaceae	Nitzschia	Nitzschia inconspicua
31139057	31139057	PRJEB50765_P_NODE_2075_length_199_cov_1.438272_g2051_i0	PRJEB50765	2075	199	1.438272	2.86216128	Phaeodactylum tricornutum	2850	SAR_Eukaryotes	SAR_Eukaryotes	57.8	1.05e-8	NR	AID23596.1	2850	g2051	i0	60.9	1.38693467336683	46	18	69.3	0	195	58	72	117	AID23596.1 putative voltage-dependent anion-selective channel protein, partial [Phaeodactylum tricornutum]	diamond	276	57.8	1	Eukaryota	Sar	Bacillariophyta	Bacillariophyceae	Naviculales	Phaeodactylaceae	Phaeodactylum	Phaeodactylum tricornutum
31322273	31322273	PRJEB50765_P_NODE_1875_length_213_cov_1.721591_g1851_i0	PRJEB50765	1875	213	1.721591	3.66698883	Bacillariophyta	2836	SAR_Eukaryotes	SAR_Eukaryotes	42.7	0.0242	NR	CAB9522553.1	568900	g1851	i0	68	0.704225352112676	25	8	35.2	0	139	213	22	46	CAB9522553.1 60S ribosomal protein L7a [Seminavis robusta]	diamond	150	42.7	1	Eukaryota	Sar	Bacillariophyta	Bacillariophyceae	Naviculales	Naviculaceae	Seminavis	Seminavis robusta

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