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

12 rows where analysis = "diamond", bioproject = "PRJNA255848" 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
9985098	9985098	PRJNA255848_P_NODE_42368_length_164_cov_0.886957_g42050_i0	PRJNA255848	42368	164	0.886957	1.45460948	Pedosphaera	1032526	Bacteria	Bacteria	102	6.25e-25	NR	PHX95918.1	2024890	g42050	i0	92.6	3.95121951219512	54	4	98.8	0	1	162	108	161	PHX95918.1 MAG: hypothetical protein CK546_00005 [Pedosphaera sp.]	diamond	648	102	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Pedosphaerae	Pedosphaerales	Pedosphaeraceae	Pedosphaera	Pedosphaera sp.
27832078	27832078	PRJNA255848_P_NODE_47504_length_161_cov_0.910714_g47186_i0	PRJNA255848	47504	161	0.910714	1.46624954	Gemmataceae bacterium	2052164	Bacteria	Bacteria	61.6	1.31e-9	NR	MFO0878164.1	2052164	g47186	i0	52.8	0.987577639751553	53	25	98.8	0	160	2	163	215	MFO0878164.1 GntR family transcriptional regulator [Gemmataceae bacterium]	diamond	159	61.6	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		Gemmataceae bacterium
28590066	28590066	PRJNA255848_P_NODE_38867_length_165_cov_1.318966_g38549_i0	PRJNA255848	38867	165	1.318966	2.1762939	Planctomycetota bacterium	2026780	Bacteria	Bacteria	40.8	0.0387	NR	MCG3134052.1	2026780	g38549	i0	54.8	0.563636363636364	31	14	56.4	0	165	73	104	134	MCG3134052.1 hypothetical protein [Planctomycetota bacterium]	diamond	93	40.8	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
28590070	28590070	PRJNA255848_P_NODE_46147_length_162_cov_0.902655_g45829_i0	PRJNA255848	46147	162	0.902655	1.4623011	Tepidisphaeraceae bacterium	2876886	Bacteria	Bacteria	60.1	1.59e-9	NR	HMO25009.1	2876886	g45829	i0	65.2	2.7962962962963	46	16	85.2	0	160	23	91	136	HMO25009.1 glycosyltransferase [Tepidisphaeraceae bacterium]	diamond	453	60.1	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Tepidisphaerales	Tepidisphaeraceae		Tepidisphaeraceae bacterium
28828503	28828503	PRJNA255848_P_NODE_47248_length_161_cov_0.910714_g46930_i0	PRJNA255848	47248	161	0.910714	1.46624954	Bacteria	2	Bacteria	Bacteria	74.3	8.4e-15	NR	MEA2011983.1	2026799	g46930	i0	60.4	3.93167701863354	53	21	98.8	0	159	1	35	87	MEA2011983.1 phosphohydrolase [Verrucomicrobiota bacterium]	diamond	633	74.3	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
29032178	29032178	PRJNA255848_P_NODE_39108_length_165_cov_0.879310_g38790_i0	PRJNA255848	39108	165	0.87931	1.4508615	Lentisphaeria bacterium	2053569	Bacteria	Bacteria	42.4	0.018	NR	MBQ7206390.1	2053569	g38790	i0	44.8	0.527272727272727	29	16	52.7	0	34	120	17	45	MBQ7206390.1 helix-turn-helix domain-containing protein [Lentisphaeria bacterium]	diamond	87	42.4	1	Bacteria	PVC group	Pseudomonadati	Lentisphaerota	Lentisphaeria				Lentisphaeria bacterium
29726289	29726289	PRJNA255848_P_NODE_18250_length_233_cov_1.135870_g17932_i0	PRJNA255848	18250	233	1.13587	2.6465771	Verrucomicrobiia bacterium	2499141	Bacteria	Bacteria	42.4	0.0414	NR	HEY3862872.1	2499141	g17932	i0	48.5	0.424892703862661	33	17	42.5	0	91	189	193	225	HEY3862872.1 3'(2'),5'-bisphosphate nucleotidase CysQ [Verrucomicrobiia bacterium]	diamond	99	42.4	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				Verrucomicrobiia bacterium
30263901	30263901	PRJNA255848_P_NODE_45952_length_162_cov_0.902655_g45634_i0	PRJNA255848	45952	162	0.902655	1.4623011	Luteolibacter yonseiensis	1144680	Bacteria	Bacteria	92.4	2.25e-21	NR	WP_200350219.1	1144680	g45634	i0	75.9	1	54	13	100	0	1	162	121	174	WP_200350219.1 GDSL-type esterase/lipase family protein [Luteolibacter yonseiensis]	diamond	162	92.4	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter yonseiensis
31780644	31780644	PRJNA255848_P_NODE_42157_length_164_cov_0.886957_g41839_i0	PRJNA255848	42157	164	0.886957	1.45460948	Chlamydiota bacterium	2081524	Bacteria	Bacteria	111	3.3799999999999993e-28	NR	MES2122925.1	2081524	g41839	i0	92.6	0.98780487804878	54	4	98.8	0	163	2	14	67	MES2122925.1 metallophosphoesterase [Chlamydiota bacterium]	diamond	162	111	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota					Chlamydiota bacterium
31938823	31938823	PRJNA255848_P_NODE_35577_length_167_cov_0.864407_g35259_i0	PRJNA255848	35577	167	0.864407	1.44355969	Tepidisphaeraceae bacterium	2876886	Bacteria	Bacteria	64.3	3.17e-10	NR	HMO24746.1	2876886	g35259	i0	56.4	0.988023952095808	55	24	98.8	0	165	1	49	103	HMO24746.1 hypothetical protein [Tepidisphaeraceae bacterium]	diamond	165	64.3	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Tepidisphaerales	Tepidisphaeraceae		Tepidisphaeraceae bacterium
32540372	32540372	PRJNA255848_P_NODE_27879_length_188_cov_2.201439_g27561_i0	PRJNA255848	27879	188	2.201439	4.13870532	Isosphaera sp.	41672	Bacteria	Bacteria	42	0.006	NR	MBA4062752.1	41672	g27561	i0	44.4	0.574468085106383	36	20	57.4	0	10	117	36	71	MBA4062752.1 hypothetical protein [Isosphaera sp.]	diamond	108	42	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae	Isosphaera	Isosphaera sp.
32791952	32791952	PRJNA255848_P_NODE_34060_length_169_cov_1.700000_g33742_i0	PRJNA255848	34060	169	1.7	2.873	Candidatus Omnitrophota bacterium	2035772	Bacteria	Bacteria	45.8	9.95e-4	NR	MDP2913672.1	2035772	g33742	i0	57.9	1.2603550295858	38	13	67.5	1	122	9	33	67	MDP2913672.1 dTMP kinase [Candidatus Omnitrophota bacterium]	diamond	213	45.8	1	Bacteria	PVC group	Pseudomonadati	Candidatus Omnitrophota					Candidatus Omnitrophota 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);;