metadata: contig_metadata: 13 rows where bioproject = "PRJNA169559", tax_clade = "PVC group" and tax

13 rows where bioproject = "PRJNA169559", tax_clade = "PVC group" and tax_phylum = "Planctomycetota"

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
5468352	5468352	PRJNA169559_P_NODE_32465_length_255_cov_1.853982_g30389_i0	PRJNA169559	32465	255	1.853982	4.7276541	Tautonia sociabilis	2080755	Bacteria	Bacteria	379	9.359999999999998e-101	NTclustered	gi\|2260349439\|ref\|NR_176521.1\|	2080755	g30389	i0	92.188	106.286274509804	256	19	100	1	1	255	1219	1474	Tautonia sociabilis strain GM2012 16S ribosomal RNA, partial sequence	blastn	27103	379	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae	Tautonia	Tautonia sociabilis
9293151	9293151	PRJNA169559_P_NODE_32848_length_254_cov_1.253333_g30772_i0	PRJNA169559	32848	254	1.253333	3.18346582	Humisphaera borealis	2807512	Bacteria	Bacteria	128	3.72e-25	NTclustered	gi\|1927742986\|gb\|CP063458.1\|	2807512	g30772	i0	96.154	47.1614173228346	78	3	61	0	177	254	5062760	5062683	Humisphaera borealis strain M1803 chromosome, complete genome	blastn	11979	128	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Tepidisphaerales	Tepidisphaeraceae	Humisphaera	Humisphaera borealis
13808196	13808196	PRJNA169559_P_NODE_17991_length_401_cov_4.258065_g15992_i0	PRJNA169559	17991	401	4.258065	17.07484065	Pseudomonadati	3379134	Bacteria	Bacteria	147	1.19e-41	NR	RMF40182.1	2026780	g15992	i0	69.1	16.3391521197007	110	33	81.5	1	74	400	94	203	RMF40182.1 MAG: NAD(P)H:quinone oxidoreductase [Planctomycetota bacterium]	diamond	6552	147	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
22041688	22041688	PRJNA169559_P_NODE_38198_length_239_cov_2.338095_g36121_i0	PRJNA169559	38198	239	2.338095	5.58804705	Humisphaera borealis	2807512	Bacteria	Bacteria	403	5.15e-108	NTclustered	gi\|1927742986\|gb\|CP063458.1\|	2807512	g36121	i0	97.071	74.7824267782427	239	7	100	0	1	239	5065002	5064764	Humisphaera borealis strain M1803 chromosome, complete genome	blastn	17873	403	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Tepidisphaerales	Tepidisphaeraceae	Humisphaera	Humisphaera borealis
27453346	27453346	PRJNA169559_P_NODE_22443_length_336_cov_2.817590_g20377_i0	PRJNA169559	22443	336	2.81759	9.4671024	Candidatus Brocadiia bacterium	2517210	Bacteria	Bacteria	89	5.94e-18	NR	NUM34221.1	2517210	g20377	i0	46.5	0.883928571428571	99	49	84.8	1	299	15	388	486	NUM34221.1 hypothetical protein [Candidatus Brocadiia bacterium]	diamond	297	89	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Candidatus Brocadiia				Candidatus Brocadiia bacterium
28495245	28495245	PRJNA169559_P_NODE_25187_length_300_cov_1.926199_g23111_i0	PRJNA169559	25187	300	1.926199	5.778597	Planctomycetota bacterium	2026780	Bacteria	Bacteria	127	8.27e-32	NR	MCX5689910.1	2026780	g23111	i0	74.7	9.91	99	23	99	1	297	1	198	294	MCX5689910.1 MmgE/PrpD family protein [Planctomycetota bacterium]	diamond	2973	127	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
29505340	29505340	PRJNA169559_P_NODE_34710_length_248_cov_2.155251_g32633_i0	PRJNA169559	34710	248	2.155251	5.34502248	Phycisphaerales bacterium	2052180	Bacteria	Bacteria	75.1	1.61e-13	NR	MCC7349131.1	2052180	g32633	i0	78	4.1491935483871	41	9	49.6	0	1	123	830	870	MCC7349131.1 pyruvate, phosphate dikinase [Phycisphaerales bacterium]	diamond	1029	75.1	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			Phycisphaerales bacterium
29537007	29537007	PRJNA169559_P_NODE_31890_length_257_cov_1.741228_g29814_i0	PRJNA169559	31890	257	1.741228	4.47495596	Planctomycetales bacterium	2053591	Bacteria	Bacteria	65.9	3.29e-10	NR	MCA9213857.1	2053591	g29814	i0	37	4.79766536964981	81	50	94.6	1	14	256	1966	2045	MCA9213857.1 hypothetical protein [Planctomycetales bacterium]	diamond	1233	65.9	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales			Planctomycetales bacterium
29694576	29694576	PRJNA169559_P_NODE_21450_length_351_cov_2.782609_g19387_i0	PRJNA169559	21450	351	2.782609	9.76695759	Planctomycetota bacterium	2026780	Bacteria	Bacteria	96.3	6.860000000000001e-21	NR	MEK7411798.1	2026780	g19387	i0	44.4	1	117	65	100	0	1	351	57	173	MEK7411798.1 hypothetical protein [Planctomycetota bacterium]	diamond	351	96.3	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
30642482	30642482	PRJNA169559_P_NODE_26893_length_284_cov_1.729412_g24817_i0	PRJNA169559	26893	284	1.729412	4.91153008	Planctomycetota bacterium	2026780	Bacteria	Bacteria	46.2	0.00366	NR	MFH1417650.1	2026780	g24817	i0	38	0.528169014084507	50	31	52.8	0	5	154	424	473	MFH1417650.1 protein kinase [Planctomycetota bacterium]	diamond	150	46.2	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
31608739	31608739	PRJNA169559_P_NODE_9176_length_561_cov_2.469925_g7481_i0	PRJNA169559	9176	561	2.469925	13.85627925	Bacteria	2	Bacteria	Bacteria	115	4.17e-28	NR	MEY4190276.1	2026780	g7481	i0	47.1	3.45454545454545	121	62	64.2	2	65	424	103	222	MEY4190276.1 hypothetical protein [Planctomycetota bacterium]	diamond	1938	115	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
32065378	32065378	PRJNA169559_P_NODE_298_length_5167_cov_5.449786_g98_i0	PRJNA169559	298	5167	5.449786	281.59044262	Gemmataceae bacterium	2052164	Bacteria	Bacteria	142	1.76e-29	NR	MFO0800230.1	2052164	g98	i0	26.7	0.541126378943294	932	546	50.5	44	2252	4858	8851	9708	MFO0800230.1 PKD domain-containing protein [Gemmataceae bacterium]	diamond	2796	142	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		Gemmataceae bacterium
32760557	32760557	PRJNA169559_P_NODE_2780_length_992_cov_4.067497_g1809_i0	PRJNA169559	2780	992	4.067497	40.34957024	Phycisphaerales bacterium	2052180	Bacteria	Bacteria	65.9	9.83e-8	NR	NOT01860.1	2052180	g1809	i0	28.7	1.94153225806452	171	117	50.5	4	169	669	52	221	NOT01860.1 DUF4215 domain-containing protein [Phycisphaerales bacterium]	diamond	1926	65.9	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);;