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

11 rows where analysis = "diamond", bioproject = "PRJEB12982" 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_genus	tax_species
26843372	26843372	PRJEB12982_P_NODE_7101_length_273_cov_0.906250_g6938_i0	PRJEB12982	7101	273	0.90625	2.4740625	Cerasicoccus arenae	424488	Bacteria	Bacteria	82	1.4e-16	NR	WP_189512798.1	424488	g6938	i0	43.2	0.967032967032967	88	50	96.7	0	5	268	76	163	WP_189512798.1 putative 4-mercaptohistidine N1-methyltransferase [Cerasicoccus arenae]	diamond	264	82	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Puniceicoccales	Cerasicoccaceae	Cerasicoccus	Cerasicoccus arenae
27665092	27665092	PRJEB12982_P_NODE_20284_length_162_cov_0.902655_g20121_i0	PRJEB12982	20284	162	0.902655	1.4623011	Pirellulales bacterium	2715253	Bacteria	Bacteria	72.4	4.24e-14	NR	HVA49718.1	2715253	g20121	i0	64.2	0.981481481481482	53	19	98.1	0	2	160	102	154	HVA49718.1 hypothetical protein [Pirellulales bacterium]	diamond	159	72.4	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales			Pirellulales bacterium
27696816	27696816	PRJEB12982_P_NODE_17144_length_167_cov_0.864407_g16981_i0	PRJEB12982	17144	167	0.864407	1.44355969	Phycisphaerales bacterium	2052180	Bacteria	Bacteria	39.7	0.0255	NR	HRJ50108.1	2052180	g16981	i0	36.5	0.934131736526946	52	23	93.4	1	158	3	17	58	HRJ50108.1 hypothetical protein [Phycisphaerales bacterium]	diamond	156	39.7	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			Phycisphaerales bacterium
27910908	27910908	PRJEB12982_P_NODE_15265_length_177_cov_1.195312_g15102_i0	PRJEB12982	15265	177	1.195312	2.11570224	Planctomyces	118	Bacteria	Bacteria	74.7	3.13e-14	NR	MFO0536479.1	37635	g15102	i0	66	5.40677966101695	53	18	89.8	0	1	159	57	109	MFO0536479.1 aldehyde dehydrogenase family protein [Planctomyces sp.]	diamond	957	74.7	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Planctomyces	Planctomyces sp.
28454439	28454439	PRJEB12982_P_NODE_15666_length_174_cov_1.352000_g15503_i0	PRJEB12982	15666	174	1.352	2.35248	Victivallales bacterium	2212475	Bacteria	Bacteria	55.1	5.99e-7	NR	MBT7162488.1	2212475	g15503	i0	51	2.62068965517241	51	25	87.9	0	172	20	240	290	MBT7162488.1 response regulator [Victivallales bacterium]	diamond	456	55.1	1	Bacteria	PVC group	Pseudomonadati	Lentisphaerota	Lentisphaeria	Victivallales			Victivallales bacterium
28517482	28517482	PRJEB12982_P_NODE_16767_length_167_cov_1.296610_g16604_i0	PRJEB12982	16767	167	1.29661	2.1653387	Verrucomicrobiaceae bacterium	2026800	Bacteria	Bacteria	79.7	8.17e-16	NR	RYD71398.1	2026800	g16604	i0	64.8	0.970059880239521	54	19	97	0	3	164	236	289	RYD71398.1 MAG: hypothetical protein EOP84_24945, partial [Verrucomicrobiaceae bacterium]	diamond	162	79.7	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae		Verrucomicrobiaceae bacterium
29780335	29780335	PRJEB12982_P_NODE_17011_length_167_cov_0.864407_g16848_i0	PRJEB12982	17011	167	0.864407	1.44355969	Planctomycetota bacterium	2026780	Bacteria	Bacteria	42	0.0252	NR	MEQ1634930.1	2026780	g16848	i0	53.1	0.880239520958084	49	18	88	2	148	2	5	48	MEQ1634930.1 phosphoenolpyruvate carboxykinase (ATP) [Planctomycetota bacterium]	diamond	147	42	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
31385664	31385664	PRJEB12982_P_NODE_13876_length_187_cov_1.478261_g13713_i0	PRJEB12982	13876	187	1.478261	2.76434807	root	1	Root_unresolved	Root_unresolved	76.6	8.88e-16	NR	MCP5470420.1	2047757	g13713	i0	55.7	1.9572192513369	61	27	97.9	0	185	3	2	62	MCP5470420.1 ribosomal protein L24e family protein [Chlamydiales bacterium]	diamond	366	76.6	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales			Chlamydiales bacterium
31606925	31606925	PRJEB12982_P_NODE_20256_length_162_cov_0.902655_g20093_i0	PRJEB12982	20256	162	0.902655	1.4623011	Planctomycetia	203683	Bacteria	Bacteria	86.3	2.14e-18	NR	HKB03998.1	2052164	g20093	i0	80	2.77777777777778	50	10	92.6	0	2	151	34	83	HKB03998.1 hypothetical protein [Gemmataceae bacterium]	diamond	450	86.3	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		Gemmataceae bacterium
32467728	32467728	PRJEB12982_P_NODE_10599_length_217_cov_0.970238_g10436_i0	PRJEB12982	10599	217	0.970238	2.10541646	Planctomycetota bacterium	2026780	Bacteria	Bacteria	44.3	0.00767	NR	MCZ7647757.1	2026780	g10436	i0	40.3	0.857142857142857	62	35	85.7	2	8	193	42	101	MCZ7647757.1 ThuA domain-containing protein [Planctomycetota bacterium]	diamond	186	44.3	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
32556369	32556369	PRJEB12982_P_NODE_3059_length_440_cov_1.723785_g2898_i0	PRJEB12982	3059	440	1.723785	7.584654	Pseudomonadati	3379134	Bacteria	Bacteria	181	4.13e-53	NR	MFB3430228.1	2052180	g2898	i0	55.1	10.0159090909091	147	64	99.5	2	438	1	48	193	MFB3430228.1 NAD(P)-dependent alcohol dehydrogenase [Phycisphaerales bacterium]	diamond	4407	181	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			Phycisphaerales 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);;