metadata: contig_metadata: 12 rows where analysis = "diamond", bioproject = "PRJNA315314" and tax

12 rows where analysis = "diamond", bioproject = "PRJNA315314" 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
15683673	15683673	PRJNA315314_S_NODE_6113_length_327_cov_2.268456_g5792_i0	PRJNA315314	6113	327	2.268456	7.41785112	Phycisphaerae bacterium	2026778	Bacteria	Bacteria	185	5.21e-54	NR	MCG3126236.1	2026778	g5792	i0	82.4	18.8256880733945	108	19	99.1	0	325	2	188	295	MCG3126236.1 Phenylacetaldehyde dehydrogenase [Phycisphaerae bacterium]	diamond	6156	185	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae				Phycisphaerae bacterium
27042746	27042746	PRJNA315314_S_NODE_9322_length_265_cov_4.644068_g9001_i0	PRJNA315314	9322	265	4.644068	12.3067802	Gemmataceae bacterium	2052164	Bacteria	Bacteria	43.1	0.0368	NR	HZT83001.1	2052164	g9001	i0	40	0.679245283018868	60	29	60	1	23	181	703	762	HZT83001.1 hypothetical protein [Gemmataceae bacterium]	diamond	180	43.1	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		Gemmataceae bacterium
27074305	27074305	PRJNA315314_S_NODE_10102_length_255_cov_2.022124_g9781_i0	PRJNA315314	10102	255	2.022124	5.1564162	Planctomycetota bacterium	2026780	Bacteria	Bacteria	91.7	2.75e-19	NR	MEY4566438.1	2026780	g9781	i0	55.6	0.952941176470588	81	36	95.3	0	13	255	224	304	MEY4566438.1 hypothetical protein [Planctomycetota bacterium]	diamond	243	91.7	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
27611558	27611558	PRJNA315314_S_NODE_31404_length_152_cov_2.243902_g31083_i0	PRJNA315314	31404	152	2.243902	3.41073104	Phycisphaerales bacterium	2052180	Bacteria	Bacteria	86.7	2.71e-18	NR	MEN6384997.1	2052180	g31083	i0	76	0.986842105263158	50	12	98.7	0	1	150	206	255	MEN6384997.1 DUF2828 family protein [Phycisphaerales bacterium]	diamond	150	86.7	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			Phycisphaerales bacterium
30232287	30232287	PRJNA315314_S_NODE_10172_length_254_cov_1.986667_g9851_i0	PRJNA315314	10172	254	1.986667	5.04613418	Aquisphaera insulae	2712864	Bacteria	Bacteria	53.5	6.47e-6	NR	WP_165229365.1	2712864	g9851	i0	40.2	1.7244094488189	87	39	89.8	3	22	249	224	308	WP_165229365.1 DUF3466 family protein [Aquisphaera insulae]	diamond	438	53.5	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae	Aquisphaera	Aquisphaera insulae
30422277	30422277	PRJNA315314_S_NODE_14193_length_217_cov_1.765957_g13872_i0	PRJNA315314	14193	217	1.765957	3.83212669	Planctomycetaceae bacterium	2026779	Bacteria	Bacteria	70.5	4.47e-12	NR	MBL8872133.1	2026779	g13872	i0	41.7	3.96774193548387	72	42	99.5	0	2	217	258	329	MBL8872133.1 carboxypeptidase regulatory-like domain-containing protein [Planctomycetaceae bacterium]	diamond	861	70.5	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		Planctomycetaceae bacterium
31054082	31054082	PRJNA315314_S_NODE_18355_length_192_cov_8.742331_g18034_i0	PRJNA315314	18355	192	8.742331	16.78527552	Planctomycetota bacterium	2026780	Bacteria	Bacteria	42	0.037	NR	MBM4008176.1	2026780	g18034	i0	63	0.421875	27	10	42.2	0	7	87	436	462	MBM4008176.1 glycosyl transferase family 39 [Planctomycetota bacterium]	diamond	81	42	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
31085425	31085425	PRJNA315314_S_NODE_20375_length_183_cov_3.279221_g20054_i0	PRJNA315314	20375	183	3.279221	6.00097443	Planctomycetota bacterium	2026780	Bacteria	Bacteria	42	0.0312	NR	RMG34231.1	2026780	g20054	i0	43.6	0.901639344262295	55	31	90.2	0	169	5	22	76	RMG34231.1 MAG: hypothetical protein D6725_14655 [Planctomycetota bacterium]	diamond	165	42	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
31116740	31116740	PRJNA315314_S_NODE_29015_length_157_cov_2.281250_g28694_i0	PRJNA315314	29015	157	2.28125	3.5815625	Phycisphaera mikurensis	547188	Bacteria	Bacteria	59.3	1.57e-8	NR	WP_014436784.1	547188	g28694	i0	67.5	0.764331210191083	40	13	76.4	0	122	3	7	46	WP_014436784.1 tyrosine--tRNA ligase [Phycisphaera mikurensis]	diamond	120	59.3	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales	Phycisphaeraceae	Phycisphaera	Phycisphaera mikurensis
31355941	31355941	PRJNA315314_S_NODE_17896_length_195_cov_1.228916_g17575_i0	PRJNA315314	17896	195	1.228916	2.3963862	Pseudomonadati	3379134	Bacteria	Bacteria	63.5	8.88e-10	NR	MBF0244012.1	2026780	g17575	i0	56.6	1.63076923076923	53	23	81.5	0	194	36	670	722	MBF0244012.1 arginine--tRNA ligase [Planctomycetota bacterium]	diamond	318	63.9	0.993740219092332	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
31450816	31450816	PRJNA315314_S_NODE_17256_length_198_cov_2.378698_g16935_i0	PRJNA315314	17256	198	2.378698	4.70982204	Pseudomonadati	3379134	Bacteria	Bacteria	65.1	2.3e-10	NR	WP_148074969.1	1400387	g16935	i0	47.8	2	67	34	100	1	1	198	127	193	WP_148074969.1 glycosyltransferase [Bythopirellula goksoeyrii]	diamond	396	65.1	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Lacipirellulaceae	Bythopirellula	Bythopirellula goksoeyrii
32620945	32620945	PRJNA315314_S_NODE_6620_length_314_cov_2.185965_g6299_i0	PRJNA315314	6620	314	2.185965	6.8639301	Pseudomonadati	3379134	Bacteria	Bacteria	52.8	2.62e-5	NR	HBO46329.1	2026779	g6299	i0	40	3.53503184713376	100	57	95.5	1	303	4	437	533	HBO46329.1 hypothetical protein [Planctomycetaceae bacterium]	diamond	1110	52.8	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		Planctomycetaceae 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);;