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

5 rows where analysis = "diamond", bioproject = "PRJNA306153" 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
27674689	27674689	PRJNA306153_S_NODE_1844_length_182_cov_4.555556_g1831_i0	PRJNA306153	1844	182	4.555556	8.29111192	Plasmodiophora brassicae	37360	SAR_Eukaryotes	SAR_Eukaryotes	93.2	6.71e-21	NR	CEP02379.1	37360	g1831	i0	73.3	1.97802197802198	60	16	98.9	0	181	2	22	81	CEP02379.1 hypothetical protein PBRA_008963 [Plasmodiophora brassicae]	diamond	360	93.2	1	Eukaryota	Sar	Endomyxa	Phytomyxea	Plasmodiophorida	Plasmodiophoridae	Plasmodiophora	Plasmodiophora brassicae
28495544	28495544	PRJNA306153_S_NODE_2487_length_158_cov_4.875969_g2474_i0	PRJNA306153	2487	158	4.875969	7.70403102	Plasmodiophora brassicae	37360	SAR_Eukaryotes	SAR_Eukaryotes	65.5	2.69e-11	NR	CEP03344.1	37360	g2474	i0	70.7	0.778481012658228	41	12	77.8	0	158	36	150	190	CEP03344.1 hypothetical protein PBRA_003104 [Plasmodiophora brassicae]	diamond	123	65.5	1	Eukaryota	Sar	Endomyxa	Phytomyxea	Plasmodiophorida	Plasmodiophoridae	Plasmodiophora	Plasmodiophora brassicae
29333910	29333910	PRJNA306153_S_NODE_1829_length_183_cov_2.662338_g1816_i0	PRJNA306153	1829	183	2.662338	4.87207854	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	110	2.49e-27	NR	CEP01219.1	37360	g1816	i0	81.7	6.83606557377049	60	11	98.4	0	2	181	141	200	CEP01219.1 hypothetical protein PBRA_001825 [Plasmodiophora brassicae]	diamond	1251	110	1	Eukaryota	Sar	Endomyxa	Phytomyxea	Plasmodiophorida	Plasmodiophoridae	Plasmodiophora	Plasmodiophora brassicae
29947944	29947944	PRJNA306153_S_NODE_1231_length_216_cov_3.267380_g1218_i0	PRJNA306153	1231	216	3.26738	7.0575408	Plasmodiophora brassicae	37360	SAR_Eukaryotes	SAR_Eukaryotes	53.1	6.18e-7	NR	CEP02593.1	37360	g1218	i0	59.5	1.27777777777778	42	17	58.3	0	215	90	61	102	CEP02593.1 hypothetical protein PBRA_002561 [Plasmodiophora brassicae]	diamond	276	53.1	1	Eukaryota	Sar	Endomyxa	Phytomyxea	Plasmodiophorida	Plasmodiophoridae	Plasmodiophora	Plasmodiophora brassicae
31148060	31148060	PRJNA306153_S_NODE_1335_length_209_cov_3.105556_g1322_i0	PRJNA306153	1335	209	3.105556	6.49061204	Plasmodiophora brassicae	37360	SAR_Eukaryotes	SAR_Eukaryotes	77.8	3.23e-15	NR	CAL69925.1	37360	g1322	i0	58	0.990430622009569	69	21	99	1	3	209	13	73	CAL69925.1 hypothetical protein [Plasmodiophora brassicae]	diamond	207	77.8	1	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);;