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

5 rows where analysis = "diamond", bioproject = "PRJNA415636" and tax_phylum = "Endomyxa"

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
2358741	2358741	PRJNA415636_S_NODE_2882_length_282_cov_1.519149_g2835_i0	PRJNA415636	2882	282	1.519149	4.28400018	Plasmodiophora brassicae	37360	SAR_Eukaryotes	SAR_Eukaryotes	108	5.460000000000001e-26	NR	CEP01219.1	37360	g2835	i0	63.9	0.882978723404255	83	29	88.3	1	282	34	236	317	CEP01219.1 hypothetical protein PBRA_001825 [Plasmodiophora brassicae]	diamond	249	108	1	Eukaryota	Sar	Endomyxa	Phytomyxea	Plasmodiophorida	Plasmodiophoridae	Plasmodiophora	Plasmodiophora brassicae
9347246	9347246	PRJNA415636_S_NODE_3988_length_249_cov_2.777228_g3941_i0	PRJNA415636	3988	249	2.777228	6.91529772	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	146	3.9e-43	NR	CEO98514.1	37360	g3941	i0	89	98.7951807228916	82	9	98.8	0	3	248	61	142	CEO98514.1 hypothetical protein PBRA_006628 [Plasmodiophora brassicae]	diamond	24600	147	0.993197278911565	Eukaryota	Sar	Endomyxa	Phytomyxea	Plasmodiophorida	Plasmodiophoridae	Plasmodiophora	Plasmodiophora brassicae
28023197	28023197	PRJNA415636_S_NODE_3485_length_262_cov_3.041860_g3438_i0	PRJNA415636	3485	262	3.04186	7.9696732	Plasmodiophora brassicae	37360	SAR_Eukaryotes	SAR_Eukaryotes	72.8	5.88e-14	NR	CEO99081.1	37360	g3438	i0	63.6	0.50381679389313	44	16	50.4	0	2	133	98	141	CEO99081.1 hypothetical protein PBRA_007195 [Plasmodiophora brassicae]	diamond	132	72.8	1	Eukaryota	Sar	Endomyxa	Phytomyxea	Plasmodiophorida	Plasmodiophoridae	Plasmodiophora	Plasmodiophora brassicae
28102747	28102747	PRJNA415636_S_NODE_3565_length_260_cov_3.356808_g3518_i0	PRJNA415636	3565	260	3.356808	8.7277008	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	86.3	9.59e-19	NR	CEP00996.1	37360	g3518	i0	78	2.33076923076923	50	11	57.7	0	2	151	143	192	CEP00996.1 hypothetical protein PBRA_008308 [Plasmodiophora brassicae]	diamond	606	86.7	0.995386389850058	Eukaryota	Sar	Endomyxa	Phytomyxea	Plasmodiophorida	Plasmodiophoridae	Plasmodiophora	Plasmodiophora brassicae
31704072	31704072	PRJNA415636_S_NODE_3737_length_255_cov_2.475962_g3690_i0	PRJNA415636	3737	255	2.475962	6.3137031	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	70.5	9.24e-14	NR	CEP00957.1	37360	g3690	i0	73.2	7.21176470588235	41	11	48.2	0	255	133	41	81	CEP00957.1 hypothetical protein PBRA_008269 [Plasmodiophora brassicae]	diamond	1839	71.2	0.990168539325843	Eukaryota	Sar	Endomyxa	Phytomyxea	Plasmodiophorida	Plasmodiophoridae	Plasmodiophora	Plasmodiophora brassicae

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