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

6 rows where analysis = "diamond", bioproject = "PRJNA393181" 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
6181534	6181534	PRJNA393181_S_NODE_32205_length_195_cov_2.962025_g32099_i0	PRJNA393181	32205	195	2.962025	5.77594875	Oomycota	4762	SAR_Eukaryotes	SAR_Eukaryotes	95.1	4.47e-21	NR	DAZ94941.1	4803	g32099	i0	69.8	6.69230769230769	63	19	96.9	0	7	195	231	293	DAZ94941.1 TPA: hypothetical protein N0F65_012658 [Lagenidium giganteum]	diamond	1305	95.1	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Pythiales	Pythiaceae	Lagenidium	Lagenidium giganteum
27028849	27028849	PRJNA393181_S_NODE_21702_length_251_cov_2.378505_g21596_i0	PRJNA393181	21702	251	2.378505	5.97004755	Paramecium	5884	SAR_Eukaryotes	SAR_Eukaryotes	58.9	8.07e-8	NR	XP_001458813.1	5888	g21596	i0	36.3	1.91235059760956	80	51	95.6	0	240	1	14	93	XP_001458813.1 uncharacterized protein GSPATT00024144001 [Paramecium tetraurelia]	diamond	480	58.9	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Peniculida	Parameciidae	Paramecium	Paramecium tetraurelia
27991433	27991433	PRJNA393181_S_NODE_44185_length_158_cov_1.933884_g44079_i0	PRJNA393181	44185	158	1.933884	3.05553672	Paramecium octaurelia	43137	SAR_Eukaryotes	SAR_Eukaryotes	44.7	0.00246	NR	CAD8195753.1	43137	g44079	i0	40.8	0.930379746835443	49	29	93	0	158	12	363	411	CAD8195753.1 unnamed protein product [Paramecium octaurelia]	diamond	147	44.7	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Peniculida	Parameciidae	Paramecium	Paramecium octaurelia
29064908	29064908	PRJNA393181_S_NODE_26968_length_219_cov_2.082418_g26862_i0	PRJNA393181	26968	219	2.082418	4.56049542	Theileria equi strain WA	1537102	SAR_Eukaryotes	SAR_Eukaryotes	67	2.27e-11	NR	XP_004832625.1	1537102	g26862	i0	71.8	3.91780821917808	39	11	53.4	0	119	3	2	40	XP_004832625.1 Ras-related protein Rab1b small GTP-binding protein [Theileria equi strain WA]	diamond	858	67	1	Eukaryota	Sar	Apicomplexa	Aconoidasida	Piroplasmida	Theileriidae	Theileria	Theileria equi
29506763	29506763	PRJNA393181_S_NODE_46950_length_152_cov_1.356522_g46844_i0	PRJNA393181	46950	152	1.356522	2.06191344	Stephanodiscus triporus	2934178	SAR_Eukaryotes	SAR_Eukaryotes	52	5.73e-6	NR	KAL3782798.1	2934178	g46844	i0	48	3.88815789473684	50	23	98.7	2	152	3	185	231	KAL3782798.1 hypothetical protein ACHAW5_000514 [Stephanodiscus triporus]	diamond	591	52	1	Eukaryota	Sar	Bacillariophyta	Coscinodiscophyceae	Stephanodiscales	Stephanodiscaceae	Stephanodiscus	Stephanodiscus triporus
32098413	32098413	PRJNA393181_S_NODE_25598_length_226_cov_2.582011_g25492_i0	PRJNA393181	25598	226	2.582011	5.83534486	Symbiodinium microadriaticum	2951	SAR_Eukaryotes	SAR_Eukaryotes	79.3	2.71e-15	NR	CAE7503004.1	2951	g25492	i0	55.1	0.915929203539823	69	31	91.6	0	8	214	285	353	CAE7503004.1 unnamed protein product, partial [Symbiodinium microadriaticum]	diamond	207	79.3	1	Eukaryota	Sar		Dinophyceae	Suessiales	Symbiodiniaceae	Symbiodinium	Symbiodinium microadriaticum

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