metadata: contig_metadata: 10 rows where analysis = "diamond", bioproject = "PRJEB6584" and tax

10 rows where analysis = "diamond", bioproject = "PRJEB6584" and tax_clade = "PVC group"

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_species
26340717	26340717	PRJEB6584o_S_NODE_13439_length_240_cov_4.829268_g13331_i0	PRJEB6584	13439	240	4.829268	11.5902432	Pseudomonadati	3379134	Bacteria	Bacteria	120	4.1699999999999995e-30	NR	MCE9619661.1	2026780	g13331	i0	65.8	2.9875	79	27	98.8	0	238	2	24	102	MCE9619661.1 amidohydrolase family protein [Planctomycetota bacterium]	diamond	717	121	0.991735537190083	Bacteria	PVC group	Pseudomonadati	Planctomycetota				Planctomycetota bacterium
32928966	32928966	PRJEB6584a_S_NODE_3097_length_214_cov_4.039106_g3077_i0	PRJEB6584	3097	214	4.039106	8.64368684	Gemmataceae bacterium	2052164	Bacteria	Bacteria	67.4	5.31e-11	NR	MFO0877588.1	2052164	g3077	i0	49.2	4.55607476635514	65	33	91.1	0	2	196	1164	1228	MFO0877588.1 ATP-binding protein [Gemmataceae bacterium]	diamond	975	67.4	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Gemmataceae bacterium
32929019	32929019	PRJEB6584a_S_NODE_7641_length_163_cov_1.703125_g7621_i0	PRJEB6584	7641	163	1.703125	2.77609375	Akkermansiaceae bacterium	2562705	Bacteria	Bacteria	56.2	1.22e-7	NR	MBC7979552.1	2562705	g7621	i0	60	0.828220858895706	45	18	82.8	0	27	161	130	174	MBC7979552.1 acetyltransferase [Akkermansiaceae bacterium]	diamond	135	56.2	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Akkermansiaceae	Akkermansiaceae bacterium
32946837	32946837	PRJEB6584o_S_NODE_77970_length_153_cov_2.525424_g77862_i0	PRJEB6584	77970	153	2.525424	3.86389872	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	46.2	6.67e-4	NR	HOY59968.1	2026799	g77862	i0	52.5	2.92156862745098	40	16	72.5	1	132	22	3	42	HOY59968.1 hypothetical protein [Verrucomicrobiota bacterium]	diamond	447	46.2	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota				Verrucomicrobiota bacterium
33049006	33049006	PRJEB6584o_S_NODE_46549_length_168_cov_2.067669_g46441_i0	PRJEB6584	46549	168	2.067669	3.47368392	Planctomycetota bacterium	2026780	Bacteria	Bacteria	41.2	0.0472	NR	MCE9636583.1	2026780	g46441	i0	39.5	0.767857142857143	43	21	69.6	2	3	119	164	205	MCE9636583.1 glycosyltransferase family 39 protein [Planctomycetota bacterium]	diamond	129	41.2	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota				Planctomycetota bacterium
33110883	33110883	PRJEB6584o_S_NODE_62478_length_161_cov_2.484127_g62370_i0	PRJEB6584	62478	161	2.484127	3.99944447	Pseudomonadati	3379134	Bacteria	Bacteria	76.6	1.24e-14	NR	MCE9619661.1	2026780	g62370	i0	87.8	4.58385093167702	41	5	76.4	0	159	37	227	267	MCE9619661.1 amidohydrolase family protein [Planctomycetota bacterium]	diamond	738	76.6	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota				Planctomycetota bacterium
33128026	33128026	PRJEB6584o_S_NODE_8711_length_292_cov_4.914397_g8603_i0	PRJEB6584	8711	292	4.914397	14.35003924	Bacteria	2	Bacteria	Bacteria	122	1.28e-30	NR	MAC19092.1	2026778	g8603	i0	72.3	3.36986301369863	83	23	85.3	0	270	22	325	407	MAC19092.1 cystathionine beta-lyase [Phycisphaerae bacterium]	diamond	984	122	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae			Phycisphaerae bacterium
33134311	33134311	PRJEB6584o_S_NODE_23671_length_192_cov_2.713376_g23563_i0	PRJEB6584	23671	192	2.713376	5.20968192	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	50.8	2.44e-5	NR	NOS70016.1	2026799	g23563	i0	58.3	0.5625	36	15	56.3	0	190	83	232	267	NOS70016.1 hypothetical protein [Verrucomicrobiota bacterium]	diamond	108	50.8	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota				Verrucomicrobiota bacterium
33168260	33168260	PRJEB6584o_S_NODE_19840_length_203_cov_2.309524_g19732_i0	PRJEB6584	19840	203	2.309524	4.68833372	Planctomycetota bacterium	2026780	Bacteria	Bacteria	63.5	8.96e-10	NR	MBI1369225.1	2026780	g19732	i0	42.4	0.975369458128079	66	38	97.5	0	6	203	43	108	MBI1369225.1 IS630 family transposase [Planctomycetota bacterium]	diamond	198	63.5	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota				Planctomycetota bacterium
33179298	33179298	PRJEB6584o_S_NODE_20280_length_201_cov_4803.108434_g20172_i0	PRJEB6584	20280	201	4803.108434	9654.24795234	Pseudomonadati	3379134	Bacteria	Bacteria	44.7	0.00426	NR	MBI5779285.1	2026780	g20172	i0	54.8	1.26865671641791	42	18	62.7	1	29	154	192	232	MBI5779285.1 FkbM family methyltransferase [Planctomycetota bacterium]	diamond	255	44.7	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);;