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

11 rows where analysis = "diamond", bioproject = "PRJNA657343" 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
9551445	9551445	PRJNA657343_P_NODE_17488_length_218_cov_1.763314_g17464_i0	PRJNA657343	17488	218	1.763314	3.84402452	Pirellulales bacterium	2715253	Bacteria	Bacteria	101	2.58e-23	NR	MBN2295153.1	2715253	g17464	i0	78.9	0.784403669724771	57	12	78.4	0	5	175	382	438	MBN2295153.1 adenosylhomocysteinase [Pirellulales bacterium]	diamond	171	101	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales			Pirellulales bacterium
13914369	13914369	PRJNA657343_P_NODE_22331_length_199_cov_1.346667_g22307_i0	PRJNA657343	22331	199	1.346667	2.67986733	Planctomycetaceae bacterium	2026779	Bacteria	Bacteria	99.8	1.35e-22	NR	PHY00844.1	2026779	g22307	i0	66.2	4.89949748743719	65	22	98	0	197	3	342	406	PHY00844.1 MAG: betaine-aldehyde dehydrogenase [Planctomycetaceae bacterium]	diamond	975	99.8	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		Planctomycetaceae bacterium
26891742	26891742	PRJNA657343_P_NODE_4521_length_359_cov_3.725806_g4498_i0	PRJNA657343	4521	359	3.725806	13.37564354	Planctomycetota bacterium	2026780	Bacteria	Bacteria	45.4	0.0145	NR	MCB9879835.1	2026780	g4498	i0	27.5	0.852367688022284	102	61	85.2	2	311	6	306	394	MCB9879835.1 hypothetical protein [Planctomycetota bacterium]	diamond	306	45.4	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
27018043	27018043	PRJNA657343_P_NODE_17322_length_219_cov_1.152941_g17298_i0	PRJNA657343	17322	219	1.152941	2.52494079	Planctomycetia bacterium	2052181	Bacteria	Bacteria	54.7	1.95e-7	NR	MBL8864092.1	2052181	g17298	i0	54.3	0.63013698630137	46	21	63	0	2	139	29	74	MBL8864092.1 hypothetical protein [Planctomycetia bacterium]	diamond	138	54.7	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia				Planctomycetia bacterium
27175966	27175966	PRJNA657343_P_NODE_40282_length_165_cov_0.896552_g40258_i0	PRJNA657343	40282	165	0.896552	1.4793108	Phycisphaerales bacterium	2052180	Bacteria	Bacteria	47.4	1.62e-4	NR	MEZ6235105.1	2052180	g40258	i0	59.4	0.581818181818182	32	13	58.2	0	105	10	13	44	MEZ6235105.1 thiol-disulfide oxidoreductase DCC family protein [Phycisphaerales bacterium]	diamond	96	47.4	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			Phycisphaerales bacterium
27744998	27744998	PRJNA657343_P_NODE_22264_length_199_cov_1.986667_g22240_i0	PRJNA657343	22264	199	1.986667	3.95346733	Pirellula sp.	117	Bacteria	Bacteria	41.6	0.0489	NR	MCF7963611.1	117	g22240	i0	36.1	0.919597989949749	61	29	76.9	2	6	158	59	119	MCF7963611.1 lysophospholipid acyltransferase family protein [Pirellula sp.]	diamond	183	41.6	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Pirellula	Pirellula sp.
27997468	27997468	PRJNA657343_P_NODE_24605_length_192_cov_1.321678_g24581_i0	PRJNA657343	24605	192	1.321678	2.53762176	Tepidisphaeraceae bacterium	2876886	Bacteria	Bacteria	42.4	0.0272	NR	HEV7300754.1	2876886	g24581	i0	42.9	0.65625	42	24	65.6	0	46	171	577	618	HEV7300754.1 ankyrin repeat domain-containing protein [Tepidisphaeraceae bacterium]	diamond	126	42.4	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Tepidisphaerales	Tepidisphaeraceae		Tepidisphaeraceae bacterium
28029037	28029037	PRJNA657343_P_NODE_44965_length_161_cov_3.125000_g44941_i0	PRJNA657343	44965	161	3.125	5.03125	Tepidisphaeraceae bacterium	2876886	Bacteria	Bacteria	48.5	1.1e-4	NR	HEV8604544.1	2876886	g44941	i0	43.1	1.90062111801242	51	25	95	1	3	155	124	170	HEV8604544.1 hypothetical protein [Tepidisphaeraceae bacterium]	diamond	306	48.5	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Tepidisphaerales	Tepidisphaeraceae		Tepidisphaeraceae bacterium
29165777	29165777	PRJNA657343_P_NODE_16869_length_221_cov_1.180233_g16845_i0	PRJNA657343	16869	221	1.180233	2.60831493	Candidatus Brocadiia bacterium	2517210	Bacteria	Bacteria	77	2.26e-14	NR	NUM34221.1	2517210	g16845	i0	54.9	0.963800904977376	71	26	91	2	19	219	396	464	NUM34221.1 hypothetical protein [Candidatus Brocadiia bacterium]	diamond	213	77	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Candidatus Brocadiia				Candidatus Brocadiia bacterium
29240980	29240980	PRJNA657343_P_NODE_34169_length_170_cov_2.049587_g34145_i0	PRJNA657343	34169	170	2.049587	3.4842979	Bacteria	2	Bacteria	Bacteria	88.2	1.48e-19	NR	GJM22915.1	2026780	g34145	i0	66.1	5.85882352941176	56	19	98.8	0	3	170	119	174	GJM22915.1 MAG: 2,3-bisphosphoglycerate-dependent phosphoglycerate mutase [Planctomycetota bacterium]	diamond	996	89	0.991011235955056	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
30966192	30966192	PRJNA657343_P_NODE_12574_length_246_cov_3.106599_g12550_i0	PRJNA657343	12574	246	3.106599	7.64223354	Phycisphaeraceae bacterium	2026777	Bacteria	Bacteria	104	4.42e-24	NR	MCB9847620.1	2026777	g12550	i0	66.7	0.804878048780488	66	22	80.5	0	198	1	3	68	MCB9847620.1 aspartate aminotransferase family protein [Phycisphaeraceae bacterium]	diamond	198	104	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales	Phycisphaeraceae		Phycisphaeraceae 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);;