metadata: contig_metadata: 11 rows where bioproject = "PRJNA1241156" and tax

11 rows where bioproject = "PRJNA1241156" 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
27926395	27926395	PRJNA1241156_S_NODE_39785_length_303_cov_1.965385_g39325_i0	PRJNA1241156	39785	303	1.965385	5.95511655	Kiritimatiellia bacterium	2212473	Bacteria	Bacteria	108	3.78e-25	NR	MCQ2395362.1	2212473	g39325	i0	58.3	2.01980198019802	103	40	100	2	303	1	449	550	MCQ2395362.1 tRNA uridine-5-carboxymethylaminomethyl(34) synthesis enzyme MnmG [Kiritimatiellia bacterium]	diamond	612	108	1	Bacteria	PVC group	Pseudomonadati	Kiritimatiellota	Kiritimatiellia			Kiritimatiellia bacterium
28305252	28305252	PRJNA1241156_S_NODE_46986_length_284_cov_1.302905_g46526_i0	PRJNA1241156	46986	284	1.302905	3.7002502	Candidatus Omnitrophota bacterium	2035772	Bacteria	Bacteria	82	6.9e-16	NR	MDE2027097.1	2035772	g46526	i0	47.1	0.897887323943662	85	44	89.8	1	268	14	160	243	MDE2027097.1 glycosyltransferase [Candidatus Omnitrophota bacterium]	diamond	255	82	1	Bacteria	PVC group	Pseudomonadati	Candidatus Omnitrophota				Candidatus Omnitrophota bacterium
29536680	29536680	PRJNA1241156_S_NODE_76790_length_200_cov_6.535032_g76330_i0	PRJNA1241156	76790	200	6.535032	13.070064	Planctomycetota bacterium	2026780	Bacteria	Bacteria	42.4	0.0296	NR	HYG74173.1	2026780	g76330	i0	36	0.75	50	31	73.5	1	194	48	579	628	HYG74173.1 L-glutamate gamma-semialdehyde dehydrogenase [Planctomycetota bacterium]	diamond	150	42.4	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota				Planctomycetota bacterium
29631085	29631085	PRJNA1241156_S_NODE_15870_length_384_cov_3.639296_g15410_i0	PRJNA1241156	15870	384	3.639296	13.97489664	Planctomycetaceae bacterium	2026779	Bacteria	Bacteria	48.1	0.00217	NR	MBV8129862.1	2026779	g15410	i0	38.8	0.6640625	85	49	66.4	1	302	48	81	162	MBV8129862.1 iron ABC transporter permease [Planctomycetaceae bacterium]	diamond	255	48.1	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Planctomycetaceae bacterium
29884190	29884190	PRJNA1241156_S_NODE_64071_length_245_cov_2.881188_g63611_i0	PRJNA1241156	64071	245	2.881188	7.0589106	Candidatus Scalinduaceae bacterium	3015208	Bacteria	Bacteria	42.7	0.0374	NR	MFQ5962738.1	3015208	g63611	i0	32.8	0.820408163265306	67	34	68.6	2	209	42	74	140	MFQ5962738.1 dihydrolipoyl dehydrogenase family protein [Candidatus Scalinduaceae bacterium]	diamond	201	42.7	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Candidatus Brocadiia	Candidatus Brocadiales	Candidatus Scalinduaceae	Candidatus Scalinduaceae bacterium
30199713	30199713	PRJNA1241156_S_NODE_49052_length_278_cov_3.838298_g48592_i0	PRJNA1241156	49052	278	3.838298	10.67046844	Planctomycetota bacterium	2026780	Bacteria	Bacteria	43.1	0.0404	NR	MDE1890470.1	2026780	g48592	i0	36.1	0.658273381294964	61	33	65.8	1	204	22	118	172	MDE1890470.1 NAD(P)/FAD-dependent oxidoreductase [Planctomycetota bacterium]	diamond	183	43.1	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota				Planctomycetota bacterium
30263420	30263420	PRJNA1241156_S_NODE_30692_length_328_cov_6.301754_g30232_i0	PRJNA1241156	30692	328	6.301754	20.66975312	Planctomycetes bacterium MalM25	2527998	Bacteria	Bacteria	43.9	0.0348	NR	QDT68364.1	2527998	g30232	i0	38.6	0.640243902439024	70	40	63.1	2	3	209	255	322	QDT68364.1 putative murein peptide carboxypeptidase [Planctomycetes bacterium MalM25]	diamond	210	43.9	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota				Planctomycetes bacterium MalM25
30547496	30547496	PRJNA1241156_S_NODE_18253_length_373_cov_2.045455_g17793_i0	PRJNA1241156	18253	373	2.045455	7.62954715	Gemmataceae bacterium	2052164	Bacteria	Bacteria	47.4	0.00394	NR	MSQ94020.1	2052164	g17793	i0	34.2	0.635388739946381	79	32	51.5	3	64	255	1088	1161	MSQ94020.1 serine/threonine protein kinase [Gemmataceae bacterium]	diamond	237	47.4	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Gemmataceae bacterium
32065000	32065000	PRJNA1241156_S_NODE_31318_length_326_cov_5.561837_g30858_i0	PRJNA1241156	31318	326	5.561837	18.13158862	Candidatus Omnitrophota bacterium	2035772	Bacteria	Bacteria	50.8	1.26e-4	NR	MCG8432288.1	2035772	g30858	i0	34.8	0.634969325153374	69	45	63.5	0	73	279	168	236	MCG8432288.1 endonuclease/exonuclease/phosphatase family protein [Candidatus Omnitrophota bacterium]	diamond	207	50.8	1	Bacteria	PVC group	Pseudomonadati	Candidatus Omnitrophota				Candidatus Omnitrophota bacterium
32381567	32381567	PRJNA1241156_S_NODE_18399_length_372_cov_4.465046_g17939_i0	PRJNA1241156	18399	372	4.465046	16.60997112	Planctomycetia bacterium	2052181	Bacteria	Bacteria	45.4	0.0167	NR	GDX94692.1	2052181	g17939	i0	38.2	0.548387096774194	68	37	54.8	2	133	336	246	308	GDX94692.1 hypothetical protein LBMAG47_03550 [Planctomycetia bacterium]	diamond	204	45.4	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia			Planctomycetia bacterium
32602815	32602815	PRJNA1241156_S_NODE_54260_length_266_cov_1.426009_g53800_i0	PRJNA1241156	54260	266	1.426009	3.79318394	Sedimentisphaerales bacterium	2813034	Bacteria	Bacteria	46.2	0.00278	NR	MBN2376472.1	2813034	g53800	i0	52.4	0.473684210526316	42	18	46.2	2	51	173	153	193	MBN2376472.1 Gfo/Idh/MocA family oxidoreductase [Sedimentisphaerales bacterium]	diamond	126	46.2	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Sedimentisphaerales		Sedimentisphaerales 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);;