metadata: contig_metadata: 5 rows where analysis = "diamond", bioproject = "PRJEB83711" and tax

5 rows where analysis = "diamond", bioproject = "PRJEB83711" and tax_clade = "Sar"

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
3970631	3970631	PRJEB83711_P_NODE_61564_length_251_cov_0.876404_g61298_i0	PRJEB83711	61564	251	0.876404	2.19977404	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	109	1.73e-26	NR	AAL50117.1	77619	g61298	i0	73.2	5.09163346613546	71	19	84.9	0	249	37	110	180	AAL50117.1 actin, partial [Vorticella microstoma]	diamond	1278	110	0.990909090909091	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Sessilida	Vorticellidae	Vorticella	Vorticella microstoma
27981977	27981977	PRJEB83711_P_NODE_58525_length_253_cov_0.866667_g58259_i0	PRJEB83711	58525	253	0.866667	2.19266751	Blepharisma stoltei	1481888	SAR_Eukaryotes	SAR_Eukaryotes	64.3	9.82e-10	NR	CAG9325523.1	1481888	g58259	i0	48.4	2.53754940711462	62	28	73.5	1	219	34	47	104	CAG9325523.1 unnamed protein product [Blepharisma stoltei]	diamond	642	64.3	1	Eukaryota	Sar	Ciliophora	Heterotrichea	Heterotrichida	Blepharismidae	Blepharisma	Blepharisma stoltei
30697750	30697750	PRJEB83711_P_NODE_47834_length_271_cov_1.585859_g47568_i0	PRJEB83711	47834	271	1.585859	4.29767789	Thalassiosira oceanica	159749	SAR_Eukaryotes	SAR_Eukaryotes	45.1	0.00743	NR	EJK44156.1	159749	g47568	i0	50	0.664206642066421	60	25	65.3	2	233	57	230	285	EJK44156.1 hypothetical protein THAOC_37330 [Thalassiosira oceanica]	diamond	180	45.1	1	Eukaryota	Sar	Bacillariophyta	Coscinodiscophyceae	Thalassiosirales	Thalassiosiraceae	Thalassiosira	Thalassiosira oceanica
30919204	30919204	PRJEB83711_P_NODE_67474_length_248_cov_0.891429_g67208_i0	PRJEB83711	67474	248	0.891429	2.21074392	Pseudocohnilembus persalinus	266149	SAR_Eukaryotes	SAR_Eukaryotes	47	6.26e-4	NR	KRX00730.1	266149	g67208	i0	90.5	0.254032258064516	21	2	25.4	0	121	183	134	154	KRX00730.1 hypothetical protein PPERSA_02990 [Pseudocohnilembus persalinus]	diamond	63	47	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Philasterida	Pseudocohnilembidae	Pseudocohnilembus	Pseudocohnilembus persalinus
32398254	32398254	PRJEB83711_P_NODE_71179_length_246_cov_0.901734_g70913_i0	PRJEB83711	71179	246	0.901734	2.21826564	Suessiales	89954	SAR_Eukaryotes	SAR_Eukaryotes	104	8.09e-24	NR	CAE8594869.1	89957	g70913	i0	68.8	4.57317073170732	77	22	93.9	1	244	14	662	736	CAE8594869.1 unnamed protein product [Polarella glacialis]	diamond	1125	104	1	Eukaryota	Sar		Dinophyceae	Suessiales	Suessiaceae	Polarella	Polarella glacialis

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