metadata: contig_metadata: 5 rows where bioproject = "PRJNA289590", tax_clade = "PVC group" and tax

5 rows where bioproject = "PRJNA289590", 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
1647294	1647294	PRJNA289590_P_NODE_22_length_11072_cov_17.623787_g20_i0	PRJNA289590	22	11072	17.623787	1951.30569664	Phycisphaerales bacterium	2052180	Bacteria	Bacteria	878	1.28e-273	NR	MCA9280974.1	2052180	g20	i0	38.2	1.15019869942197	1418	822	37.6	19	5960	1794	1	1393	MCA9280974.1 AAA family ATPase [Phycisphaerales bacterium]	diamond	12735	878	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			Phycisphaerales bacterium
23324821	23324821	PRJNA289590_P_NODE_5199_length_432_cov_2.026110_g4975_i0	PRJNA289590	5199	432	2.02611	8.7527952	Sedimentisphaerales bacterium	2813034	Bacteria	Bacteria	54.7	0.012	NTclustered	gi\|2621703756\|emb\|OY762711.1\|	2813034	g4975	i0	94.286	0.0810185185185185	35	2	8	0	25	59	3671457	3671423	MAG: Sedimentisphaerales bacterium isolate 370b4a7f-3155-49ac-97a8-084c2d75e38e genome assembly, chromosome: 1	blastn	35	54.7	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Sedimentisphaerales			Sedimentisphaerales bacterium
25285525	25285525	PRJNA289590_P_NODE_29660_length_164_cov_0.904348_g29436_i0	PRJNA289590	29660	164	0.904348	1.48313072	Engelhardtia	139931	Bacteria	Bacteria	195	2.15e-45	NTclustered	gi\|1712638177\|gb\|CP036287.1\|	2528011	g29436	i0	90.604	160.975609756098	149	10	90	4	1	147	5247535	5247389	Planctomycetes bacterium Pla133 chromosome, complete genome	blastn	26400	195	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia			Engelhardtia	Engelhardtia mirabilis
32129141	32129141	PRJNA289590_P_NODE_14638_length_236_cov_1.946524_g14414_i0	PRJNA289590	14638	236	1.946524	4.59379664	Gemmataceae bacterium	2052164	Bacteria	Bacteria	50.8	3.83e-5	NR	MCI0681538.1	2052164	g14414	i0	42.7	0.953389830508475	75	42	94.1	1	14	235	122	196	MCI0681538.1 hypothetical protein [Gemmataceae bacterium]	diamond	225	50.8	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		Gemmataceae bacterium
32431475	32431475	PRJNA289590_P_NODE_27019_length_168_cov_0.873950_g26795_i0	PRJNA289590	27019	168	0.87395	1.468236	Bacteria	2	Bacteria	Bacteria	70.9	9.11e-14	NR	MBL8820106.1	37635	g26795	i0	62.7	11.9464285714286	51	19	91.1	0	3	155	83	133	MBL8820106.1 GNAT family N-acetyltransferase [Planctomyces sp.]	diamond	2007	71.2	0.995786516853933	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Planctomyces	Planctomyces sp.

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