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

12 rows where analysis = "diamond", bioproject = "PRJNA851399" and tax_phylum = "Verrucomicrobiota"

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
26833562	26833562	PRJNA851399_P_NODE_35221_length_163_cov_0.894737_g34768_i0	PRJNA851399	35221	163	0.894737	1.45842131	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	57	1.18e-7	NR	MBS0631760.1	2026799	g34768	i0	52.8	0.975460122699387	53	25	97.5	0	159	1	718	770	MBS0631760.1 M48 family metalloprotease [Verrucomicrobiota bacterium]	diamond	159	57	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
27086670	27086670	PRJNA851399_P_NODE_17462_length_184_cov_1.511111_g17009_i0	PRJNA851399	17462	184	1.511111	2.78044424	Lacunisphaera sp.	1961806	Bacteria	Bacteria	117	5.22e-29	NR	MDI1334970.1	1961806	g17009	i0	93.3	0.978260869565217	60	4	97.8	0	182	3	408	467	MDI1334970.1 penicillin-binding protein 2 [Lacunisphaera sp.]	diamond	180	117	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Lacunisphaera	Lacunisphaera sp.
28002762	28002762	PRJNA851399_P_NODE_41365_length_161_cov_0.910714_g40912_i0	PRJNA851399	41365	161	0.910714	1.46624954	Verrucomicrobiales bacterium	2026801	Bacteria	Bacteria	42	0.0229	NR	MDB6024811.1	2026801	g40912	i0	43.4	1.86335403726708	53	23	98.8	1	2	160	7	52	MDB6024811.1 Binding-protein-dependent transport system inner rane component [Verrucomicrobiales bacterium]	diamond	300	42	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales			Verrucomicrobiales bacterium
28286494	28286494	PRJNA851399_P_NODE_18586_length_181_cov_1.545455_g18133_i0	PRJNA851399	18586	181	1.545455	2.79727355	Terrimicrobiaceae bacterium	2832348	Bacteria	Bacteria	88.2	1.38e-19	NR	HEY5704678.1	2832348	g18133	i0	86.4	0.729281767955801	44	6	72.9	0	178	47	190	233	HEY5704678.1 C4-type zinc ribbon domain-containing protein [Terrimicrobiaceae bacterium]	diamond	132	88.2	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Terrimicrobiia	Terrimicrobiales	Terrimicrobiaceae		Terrimicrobiaceae bacterium
30276471	30276471	PRJNA851399_P_NODE_10792_length_237_cov_0.744681_g10339_i0	PRJNA851399	10792	237	0.744681	1.76489397	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	43.5	0.0177	NR	PYI75966.1	2026799	g10339	i0	38.8	0.848101265822785	67	35	77.2	2	41	223	102	168	PYI75966.1 MAG: acyl-CoA dehydrogenase [Verrucomicrobiota bacterium]	diamond	201	43.5	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
30339873	30339873	PRJNA851399_P_NODE_38792_length_162_cov_0.902655_g38339_i0	PRJNA851399	38792	162	0.902655	1.4623011	Chthoniobacterales bacterium	2201154	Bacteria	Bacteria	62	1.93e-9	NR	HXM29525.1	2201154	g38339	i0	51.9	0.962962962962963	52	25	96.3	0	161	6	169	220	HXM29525.1 Na/Pi cotransporter family protein [Chthoniobacterales bacterium]	diamond	156	62	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Spartobacteria	Chthoniobacterales			Chthoniobacterales bacterium
30466021	30466021	PRJNA851399_P_NODE_30313_length_165_cov_0.879310_g29860_i0	PRJNA851399	30313	165	0.87931	1.4508615	Prosthecobacter sp.	1965333	Bacteria	Bacteria	108	8.37e-26	NR	WP_300199569.1	1965333	g29860	i0	100	1.96363636363636	54	0	98.2	0	164	3	455	508	WP_300199569.1 excinuclease ABC subunit UvrA [Prosthecobacter sp.]	diamond	324	108	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Prosthecobacter	Prosthecobacter sp.
31761719	31761719	PRJNA851399_P_NODE_31357_length_165_cov_0.879310_g30904_i0	PRJNA851399	31357	165	0.87931	1.4508615	Verrucomicrobiia bacterium	2499141	Bacteria	Bacteria	84.3	1.38e-17	NR	HEX7569162.1	2499141	g30904	i0	82.6	1.67272727272727	46	8	83.6	0	165	28	294	339	HEX7569162.1 PIN domain-containing protein [Verrucomicrobiia bacterium]	diamond	276	84.3	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				Verrucomicrobiia bacterium
32014833	32014833	PRJNA851399_P_NODE_18338_length_182_cov_1.360902_g17885_i0	PRJNA851399	18338	182	1.360902	2.47684164	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	90.5	1.64e-19	NR	RFC48550.1	2026799	g17885	i0	74.6	1.96153846153846	59	15	97.3	0	2	178	289	347	RFC48550.1 MAG: MFS family permease [Verrucomicrobiota bacterium]	diamond	357	90.5	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
32181420	32181420	PRJNA851399_P_NODE_30278_length_165_cov_0.879310_g29825_i0	PRJNA851399	30278	165	0.87931	1.4508615	Bacteria	2	Bacteria	Bacteria	93.6	1.11e-20	NR	MES2465762.1	2026799	g29825	i0	75.5	1.90909090909091	53	13	96.4	0	5	163	384	436	MES2465762.1 UDP-N-acetylmuramoyl-L-alanine--D-glutamate ligase [Verrucomicrobiota bacterium]	diamond	315	93.6	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
32204732	32204732	PRJNA851399_P_NODE_19738_length_178_cov_1.581395_g19285_i0	PRJNA851399	19738	178	1.581395	2.8148831	Verrucomicrobiia bacterium	2499141	Bacteria	Bacteria	105	8.61e-25	NR	MDR3455851.1	2499141	g19285	i0	86.4	1.98876404494382	59	8	99.4	0	177	1	222	280	MDR3455851.1 WecB/TagA/CpsF family glycosyltransferase [Verrucomicrobiia bacterium]	diamond	354	105	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				Verrucomicrobiia bacterium
32867592	32867592	PRJNA851399_P_NODE_10840_length_236_cov_1.080214_g10387_i0	PRJNA851399	10840	236	1.080214	2.54930504	Opitutaceae bacterium TAV1	278956	Bacteria	Bacteria	48.1	3.6e-4	NR	EIQ00196.1	278956	g10387	i0	83.3	0.635593220338983	24	4	30.5	0	73	2	3	26	EIQ00196.1 site-specific DNA methylase [Opitutaceae bacterium TAV1]	diamond	150	48.1	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae		Opitutaceae bacterium TAV1

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);;