metadata: contig_metadata: 5 rows where bioproject = "PRJNA898105" and tax

5 rows where bioproject = "PRJNA898105" 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
3424682	3424682	PRJNA898105_P_NODE_8103_length_242_cov_0.911243_g7903_i0	PRJNA898105	8103	242	0.911243	2.20520806	Planctomycetales bacterium ZRK34	2723666	Bacteria	Bacteria	63.9	1.01e-5	NTclustered	gi\|1898316769\|gb\|CP050848.1\|	2723666	g7903	i0	93.023	0.177685950413223	43	3	18	0	200	242	594295	594337	Planctomycetales bacterium ZRK34 chromosome, complete genome	blastn	43	63.9	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales			Planctomycetales bacterium ZRK34
5977160	5977160	PRJNA898105_P_NODE_6405_length_250_cov_0.870056_g6205_i0	PRJNA898105	6405	250	0.870056	2.17514	Lacipirellula parvula	2650471	Bacteria	Bacteria	340	4.31e-89	NTclustered	gi\|1761017769\|dbj\|AP021861.1\|	2650471	g6205	i0	91.2	1	250	22	100	0	1	250	3775882	3776131	Lacipirellula parvula PX69 DNA, complete genome	blastn	250	340	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Lacipirellulaceae	Lacipirellula	Lacipirellula parvula
16546739	16546739	PRJNA898105_P_NODE_4353_length_283_cov_1.642857_g4153_i0	PRJNA898105	4353	283	1.642857	4.64928531	Humisphaera	2807511	Bacteria	Bacteria	361	3.82e-95	NTclustered	gi\|1927742986\|gb\|CP063458.1\|	2807512	g4153	i0	92.829	91.0459363957597	251	14	88	3	32	281	5064105	5063858	Humisphaera borealis strain M1803 chromosome, complete genome	blastn	25766	363	0.994490358126722	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Tepidisphaerales	Tepidisphaeraceae	Humisphaera	Humisphaera borealis
27277112	27277112	PRJNA898105_P_NODE_7483_length_245_cov_0.895349_g7283_i0	PRJNA898105	7483	245	0.895349	2.19360505	Gemmataceae bacterium	2052164	Bacteria	Bacteria	122	1.48e-30	NR	HZV08024.1	2052164	g7283	i0	80.2	3.95510204081633	81	16	99.2	0	243	1	345	425	HZV08024.1 hypothetical protein [Gemmataceae bacterium]	diamond	969	122	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		Gemmataceae bacterium
31224662	31224662	PRJNA898105_P_NODE_7735_length_244_cov_0.900585_g7535_i0	PRJNA898105	7735	244	0.900585	2.1974274	Paludisphaera rhizosphaerae	2711216	Bacteria	Bacteria	116	7.789999999999999e-31	NR	WP_165074790.1	2711216	g7535	i0	79.4	0.836065573770492	68	14	83.6	0	1	204	103	170	WP_165074790.1 hypothetical protein [Paludisphaera rhizosphaerae]	diamond	204	116	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae	Paludisphaera	Paludisphaera rhizosphaerae

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