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

5 rows where analysis = "blastn", bioproject = "PRJEB14664" and tax_clade = "PVC group"

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
15323343	15323343	PRJEB14664_P_NODE_14853_length_184_cov_1.463087_g14723_i0	PRJEB14664	14853	184	1.463087	2.69208008	uncultured Gemmataceae bacterium	1914239	Bacteria	Bacteria	134	5.45e-27	NTclustered	gi\|2874253749\|emb\|OY969623.1\|	1914239	g14723	i0	82.692	73.5	156	22	83	4	33	184	7052393	7052239	MAG: uncultured Gemmataceae bacterium isolate MFD06742.bin.c.1 genome assembly, chromosome: 1	blastn	13524	134	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
16288458	16288458	PRJEB14664_P_NODE_4473_length_411_cov_1.779255_g4345_i0	PRJEB14664	4473	411	1.779255	7.31273805	Telmatocola	1382832	Bacteria	Bacteria	298	4.59e-76	NTclustered	gi\|2874254043\|emb\|OY970367.1\|	120965	g4345	i0	80.494	228.579075425791	405	65	96	12	16	411	3454131	3453732	MAG: uncultured Planctomycetota bacterium isolate MFD04580.bin.c.2 genome assembly, chromosome: 1	blastn	93946	298	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					uncultured Planctomycetota bacterium
19146642	19146642	PRJEB14664_P_NODE_10576_length_232_cov_1.802030_g10446_i0	PRJEB14664	10576	232	1.80203	4.1807096	Kolteria novifilia	2527975	Bacteria	Bacteria	176	1.18e-39	NTclustered	gi\|1712629967\|gb\|CP036279.1\|	2527975	g10446	i0	81.034	294.560344827586	232	35	98	7	1	227	1830090	1830317	Planctomycetes bacterium Pan216 chromosome, complete genome	blastn	68338	176	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Kolteriales	Kolteriaceae	Kolteria	Kolteria novifilia
21697878	21697878	PRJEB14664_P_NODE_14118_length_191_cov_1.076923_g13988_i0	PRJEB14664	14118	191	1.076923	2.05692293	Verrucomicrobiia bacterium	2499141	Bacteria	Bacteria	263	6.97e-66	NTclustered	gi\|2621704341\|emb\|OY760937.1\|	2499141	g13988	i0	91.579	30.2198952879581	190	16	99	0	1	190	3990517	3990328	MAG: Verrucomicrobiae bacterium isolate 066a7682-a1ac-48de-8761-1470dc9e5c3e genome assembly, chromosome: 1	blastn	5772	263	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				Verrucomicrobiia bacterium
22662664	22662664	PRJEB14664_P_NODE_10458_length_234_cov_1.402010_g10328_i0	PRJEB14664	10458	234	1.40201	3.2807034	Gemmata	113	Bacteria	Bacteria	399	6.499999999999999e-107	NTclustered	gi\|1804905141\|emb\|LR593886.1\|	1210884	g10328	i0	97.436	111.636752136752	234	6	100	0	1	234	3634164	3634397	Gemmata massiliana isolate Soil9 genome assembly, chromosome: 1	blastn	26123	399	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Gemmata	Gemmata massiliana

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