metadata: contig_metadata: 4 rows where bioproject = "PRJNA658591", tax_clade = "PVC group" and tax

4 rows where bioproject = "PRJNA658591", tax_clade = "PVC group" 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
4453403	4453403	PRJNA658591_S_NODE_9444_length_166_cov_0.888889_g9381_i0	PRJNA658591	9444	166	0.888889	1.47555574	uncultured Gemmataceae bacterium	1914239	Bacteria	Bacteria	215	1.68e-51	NTclustered	gi\|2874253749\|emb\|OY969623.1\|	1914239	g9381	i0	90	279.114457831325	170	11	100	6	1	166	7052303	7052470	MAG: uncultured Gemmataceae bacterium isolate MFD06742.bin.c.1 genome assembly, chromosome: 1	blastn	46333	215	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
12640592	12640592	PRJNA658591_S_NODE_10310_length_162_cov_1.079646_g10247_i0	PRJNA658591	10310	162	1.079646	1.74902652	Singulisphaera	466152	Bacteria	Bacteria	250	4.45e-62	NTclustered	gi\|485099129\|ref\|NR_102524.1\|	466153	g10247	i0	94.444	173.246913580247	162	9	100	0	1	162	1593	1754	Singulisphaera acidiphila strain MOB10 23S ribosomal RNA gene, complete sequence	blastn	28066	250	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae	Singulisphaera	Singulisphaera acidiphila
27460735	27460735	PRJNA658591_S_NODE_2163_length_288_cov_1.761506_g2100_i0	PRJNA658591	2163	288	1.761506	5.07313728	Planctomycetota bacterium	2026780	Bacteria	Bacteria	42.7	0.0463	NR	NOX57076.1	2026780	g2100	i0	40	0.46875	45	27	46.9	0	238	104	143	187	NOX57076.1 hypothetical protein [Planctomycetota bacterium]	diamond	135	42.7	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
29291846	29291846	PRJNA658591_S_NODE_8849_length_169_cov_0.866667_g8786_i0	PRJNA658591	8849	169	0.866667	1.46466723	Phycisphaerales bacterium	2052180	Bacteria	Bacteria	42.7	0.0141	NR	UCG46482.1	2052180	g8786	i0	45.1	0.905325443786982	51	23	90.5	2	157	5	99	144	UCG46482.1 MAG: hypothetical protein JSU94_13365, partial [Phycisphaerales bacterium]	diamond	153	42.7	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			Phycisphaerales bacterium

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