metadata: contig_metadata: 6 rows where analysis = "diamond", bioproject = "PRJNA557436" and tax

6 rows where analysis = "diamond", bioproject = "PRJNA557436" 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
26983872	26983872	PRJNA557436_S_NODE_7002_length_164_cov_2.031008_g6954_i0	PRJNA557436	7002	164	2.031008	3.33085312	Gregarina niphandrodes	110365	SAR_Eukaryotes	SAR_Eukaryotes	41.2	0.0437	NR	XP_011130180.1	110365	g6954	i0	43.9	0.75	41	23	75	0	127	5	129	169	XP_011130180.1 hypothetical protein GNI_067230 [Gregarina niphandrodes]	diamond	123	41.2	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eugregarinorida	Gregarinidae	Gregarina	Gregarina niphandrodes
27742547	27742547	PRJNA557436_S_NODE_5144_length_182_cov_3.353741_g5096_i0	PRJNA557436	5144	182	3.353741	6.10380862	Seminavis robusta	568900	SAR_Eukaryotes	SAR_Eukaryotes	43.1	0.0115	NR	CAB9498495.1	568900	g5096	i0	63.6	0.362637362637363	22	8	36.3	0	180	115	149	170	CAB9498495.1 expressed unknown protein [Seminavis robusta]	diamond	66	43.1	1	Eukaryota	Sar	Bacillariophyta	Bacillariophyceae	Naviculales	Naviculaceae	Seminavis	Seminavis robusta
30742314	30742314	PRJNA557436_S_NODE_8114_length_157_cov_1.286885_g8066_i0	PRJNA557436	8114	157	1.286885	2.02040945	Cylindrotheca closterium	2856	SAR_Eukaryotes	SAR_Eukaryotes	69.7	3.35e-12	NR	YP_009029080.1	2856	g8066	i0	58.8	0.974522292993631	51	21	97.5	0	3	155	92	142	YP_009029080.1 hypothetical protein [Cylindrotheca closterium]	diamond	153	69.7	1	Eukaryota	Sar	Bacillariophyta	Bacillariophyceae	Bacillariales	Bacillariaceae	Cylindrotheca	Cylindrotheca closterium
31912165	31912165	PRJNA557436_S_NODE_6197_length_171_cov_1.433824_g6149_i0	PRJNA557436	6197	171	1.433824	2.45183904	Fragilaria crotonensis	210448	SAR_Eukaryotes	SAR_Eukaryotes	73.9	1.38e-13	NR	KAI2511261.1	210448	g6149	i0	75.5	3.49122807017544	49	12	86	0	171	25	322	370	KAI2511261.1 Reverse transcriptase (RNA-dependent DNA polymerase) [Fragilaria crotonensis]	diamond	597	73.9	1	Eukaryota	Sar	Bacillariophyta	Fragilariophyceae	Fragilariales	Fragilariaceae	Fragilaria	Fragilaria crotonensis
32133764	32133764	PRJNA557436_S_NODE_5618_length_177_cov_1.183099_g5570_i0	PRJNA557436	5618	177	1.183099	2.09408523	Fragilaria crotonensis	210448	SAR_Eukaryotes	SAR_Eukaryotes	60.1	1.21e-8	NR	KAI2509714.1	210448	g5570	i0	62.2	0.76271186440678	45	16	76.3	1	135	1	182	225	KAI2509714.1 Reverse transcriptase (RNA-dependent DNA polymerase) [Fragilaria crotonensis]	diamond	135	60.1	1	Eukaryota	Sar	Bacillariophyta	Fragilariophyceae	Fragilariales	Fragilariaceae	Fragilaria	Fragilaria crotonensis
32716549	32716549	PRJNA557436_S_NODE_9240_length_151_cov_2.543103_g9192_i0	PRJNA557436	9240	151	2.543103	3.84008553	Bacillariaceae	33852	SAR_Eukaryotes	SAR_Eukaryotes	81.3	2.51e-16	NR	YP_009029080.1	2856	g9192	i0	67.3	3.87417218543046	49	16	97.4	0	151	5	292	340	YP_009029080.1 hypothetical protein [Cylindrotheca closterium]	diamond	585	81.3	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);;