metadata: contig_metadata: 5 rows where analysis = "blastn", bioproject = "PRJNA1249535" and tax

5 rows where analysis = "blastn", bioproject = "PRJNA1249535" and tax_phylum = "Planctomycetota"

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_kingdom	tax_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
4183608	4183608	PRJNA1249535_S_NODE_206604_length_303_cov_1.017391_g203221_i0	PRJNA1249535	206604	303	1.017391	3.08269473	Roseimaritima ulvae	980254	Bacteria	Bacteria	459	1.4199999999999996e-124	NTclustered	gi\|1727550343\|gb\|CP042914.1\|	980254	g203221	i0	94.059	212.3300330033	303	16	99	1	3	303	6160309	6160007	Roseimaritima ulvae strain UC8 chromosome, complete genome	blastn	64336	459	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Roseimaritima	Roseimaritima ulvae
6735071	6735071	PRJNA1249535_S_NODE_275546_length_266_cov_2.720207_g272163_i0	PRJNA1249535	275546	266	2.720207	7.23575062	Stieleria varia	2528005	Bacteria	Bacteria	470	5.669999999999999e-128	NTclustered	gi\|2720418917\|gb\|CP151726.1\|	2528005	g272163	i0	98.496	141.868421052632	266	4	100	0	1	266	2278152	2278417	Stieleria varia strain Pla52n chromosome, complete genome	blastn	37737	470	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Stieleria	Stieleria varia
9286814	9286814	PRJNA1249535_S_NODE_60188_length_445_cov_4.231183_g56819_i0	PRJNA1249535	60188	445	4.231183	18.82876435	Sedimentisphaerales bacterium	2813034	Bacteria	Bacteria	60.2	2.57e-4	NTclustered	gi\|2621701142\|emb\|OY759675.1\|	2813034	g56819	i0	100	0.0719101123595506	32	0	7	0	314	345	3644773	3644742	MAG: Sedimentisphaerales bacterium isolate f0e5d044-1a19-4baf-a299-9636c83af3ad genome assembly, chromosome: 1	blastn	32	60.2	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Sedimentisphaerales			Sedimentisphaerales bacterium
19483214	19483214	PRJNA1249535_S_NODE_260776_length_274_cov_2.706468_g257393_i0	PRJNA1249535	260776	274	2.706468	7.41572232	uncultured Gemmataceae bacterium	1914239	Bacteria	Bacteria	398	2.8099999999999998e-106	NTclustered	gi\|2874253749\|emb\|OY969623.1\|	1914239	g257393	i0	92.78	108.934306569343	277	17	100	3	1	274	7052242	7052518	MAG: uncultured Gemmataceae bacterium isolate MFD06742.bin.c.1 genome assembly, chromosome: 1	blastn	29848	398	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
20757081	20757081	PRJNA1249535_S_NODE_139777_length_342_cov_2.401487_g136394_i0	PRJNA1249535	139777	342	2.401487	8.21308554	Roseimaritima ulvae	980254	Bacteria	Bacteria	235	2.99e-57	NTclustered	gi\|1727550343\|gb\|CP042914.1\|	980254	g136394	i0	87.624	19.7017543859649	202	25	59	0	141	342	6157414	6157615	Roseimaritima ulvae strain UC8 chromosome, complete genome	blastn	6738	235	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Roseimaritima	Roseimaritima ulvae

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