metadata: contig_metadata: 11 rows where analysis = "diamond", bioproject = "PRJNA642647" and tax

11 rows where analysis = "diamond", bioproject = "PRJNA642647" 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
26986236	26986236	PRJNA642647_P_NODE_4962_length_166_cov_2.961240_g4912_i0	PRJNA642647	4962	166	2.96124	4.9156584	Planctomycetaceae bacterium	2026779	Bacteria	Bacteria	53.5	1.83e-6	NR	HQX49920.1	2026779	g4912	i0	65.8	0.686746987951807	38	10	63.3	1	162	58	46	83	HQX49920.1 carbon-nitrogen hydrolase family protein [Planctomycetaceae bacterium]	diamond	114	53.5	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		Planctomycetaceae bacterium
28483183	28483183	PRJNA642647_P_NODE_3426_length_191_cov_2.246753_g3376_i0	PRJNA642647	3426	191	2.246753	4.29129823	PVC group	1783257	Bacteria	Bacteria	60.1	2.18e-9	NR	WP_088258631.1	1908690	g3376	i0	71.9	1.00523560209424	32	9	50.3	0	4	99	103	134	WP_088258631.1 zinc-finger-containing protein [Fimbriiglobus ruber]	diamond	192	60.1	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Fimbriiglobus	Fimbriiglobus ruber
29575707	29575707	PRJNA642647_P_NODE_3510_length_189_cov_1.822368_g3460_i0	PRJNA642647	3510	189	1.822368	3.44427552	Planctomycetales bacterium 71-1	2053591	Bacteria	Bacteria	68.9	1.01e-11	NR	OJW23182.1	1895807	g3460	i0	54.8	0.984126984126984	62	28	98.4	0	2	187	223	284	OJW23182.1 MAG: hypothetical protein BGO49_27190 [Planctomycetales bacterium 71-10]	diamond	186	68.9	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales			Planctomycetales bacterium 71-10
29575709	29575709	PRJNA642647_P_NODE_4390_length_173_cov_1.448529_g4340_i0	PRJNA642647	4390	173	1.448529	2.50595517	Planctomycetota bacterium	2026780	Bacteria	Bacteria	87.8	1.26e-19	NR	MEA3224481.1	2026780	g4340	i0	69.1	2.84393063583815	55	17	95.4	0	166	2	116	170	MEA3224481.1 hypothetical protein [Planctomycetota bacterium]	diamond	492	87.8	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
29765237	29765237	PRJNA642647_P_NODE_4751_length_168_cov_1.022901_g4701_i0	PRJNA642647	4751	168	1.022901	1.71847368	Planctomycetaceae bacterium	2026779	Bacteria	Bacteria	79.3	3.1e-17	NR	MCE5266732.1	2026779	g4701	i0	92.1	0.678571428571429	38	3	67.9	0	166	53	91	128	MCE5266732.1 hypothetical protein [Planctomycetaceae bacterium]	diamond	114	79.3	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		Planctomycetaceae bacterium
29954928	29954928	PRJNA642647_P_NODE_6631_length_150_cov_3.681416_g6581_i0	PRJNA642647	6631	150	3.681416	5.522124	Planctomycetota bacterium	2026780	Bacteria	Bacteria	52.8	2.96e-6	NR	MCX5690565.1	2026780	g6581	i0	42.7	1.92	96	7	96	1	148	5	88	183	MCX5690565.1 AAA family ATPase [Planctomycetota bacterium]	diamond	288	52.8	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
30018217	30018217	PRJNA642647_P_NODE_3571_length_188_cov_1.384106_g3521_i0	PRJNA642647	3571	188	1.384106	2.60211928	Phycisphaerae bacterium	2026778	Bacteria	Bacteria	69.7	1.4e-12	NR	MFA5239790.1	2026778	g3521	i0	51.6	0.98936170212766	62	30	98.9	0	3	188	23	84	MFA5239790.1 HNH endonuclease signature motif containing protein [Phycisphaerae bacterium]	diamond	186	69.7	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae				Phycisphaerae bacterium
30334442	30334442	PRJNA642647_P_NODE_1372_length_299_cov_2.374046_g1322_i0	PRJNA642647	1372	299	2.374046	7.09839754	Phycisphaerales bacterium	2052180	Bacteria	Bacteria	48.5	6.28e-4	NR	MCC6427801.1	2052180	g1322	i0	45.2	3.93311036789298	62	29	57.2	2	35	205	128	189	MCC6427801.1 hypothetical protein [Phycisphaerales bacterium]	diamond	1176	48.5	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			Phycisphaerales bacterium
30409869	30409869	PRJNA642647_P_NODE_5173_length_166_cov_2.682171_g5123_i0	PRJNA642647	5173	166	2.682171	4.45240386	Planctomycetia	203683	Bacteria	Bacteria	48.1	1.64e-4	NR	MBV8231459.1	2026779	g5123	i0	95.7	2.00602409638554	23	1	41.6	0	70	2	79	101	MBV8231459.1 flagellar biosynthesis protein FlhF [Planctomycetaceae bacterium]	diamond	333	48.1	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		Planctomycetaceae bacterium
31819573	31819573	PRJNA642647_P_NODE_2997_length_202_cov_2.321212_g2947_i0	PRJNA642647	2997	202	2.321212	4.6888482399999996	Gemmataceae bacterium	2052164	Bacteria	Bacteria	53.9	2.46e-6	NR	MCX7664400.1	2052164	g2947	i0	42.1	0.846534653465347	57	33	84.7	0	31	201	28	84	MCX7664400.1 hypothetical protein [Gemmataceae bacterium]	diamond	171	53.9	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		Gemmataceae bacterium
32641673	32641673	PRJNA642647_P_NODE_3740_length_185_cov_0.932432_g3690_i0	PRJNA642647	3740	185	0.932432	1.7249992	Planctomycetota bacterium	2026780	Bacteria	Bacteria	51.6	6.39e-6	NR	MDP6940246.1	2026780	g3690	i0	59.5	1.75135135135135	37	15	60	0	163	53	116	152	MDP6940246.1 HK97 family phage prohead protease [Planctomycetota bacterium]	diamond	324	51.6	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota 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);;