metadata: contig_metadata: 21 rows where bioproject = "PRJEB7366", tax_clade = "PVC group" and tax

21 rows where bioproject = "PRJEB7366", 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
3961341	3961341	PRJEB7366_P_NODE_1844_length_722_cov_6.005822_g1493_i1	PRJEB7366	1844	722	6.005822	43.36203484	uncultured Gemmataceae bacterium	1914239	Bacteria	Bacteria	830	0	NTclustered	gi\|2874253749\|emb\|OY969623.1\|	1914239	g1493	i1	87.432	195.027700831025	740	70	100	18	1	722	7050217	7050951	MAG: uncultured Gemmataceae bacterium isolate MFD06742.bin.c.1 genome assembly, chromosome: 1	blastn	140810	830	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
6513367	6513367	PRJEB7366_P_NODE_2766_length_575_cov_2.559259_g2365_i0	PRJEB7366	2766	575	2.559259	14.71573925	Planctomycetota bacterium	2026780	Bacteria	Bacteria	186	7.909999999999999e-55	NR	MFM7522431.1	2026780	g2365	i0	52.7	2.88	184	85	96	2	555	4	23	204	MFM7522431.1 glutamine synthetase type III [Planctomycetota bacterium]	diamond	1656	186	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
10338291	10338291	PRJEB7366_P_NODE_1829_length_725_cov_5.195652_g1493_i0	PRJEB7366	1829	725	5.195652	37.668477	uncultured Gemmataceae bacterium	1914239	Bacteria	Bacteria	688	0	NTclustered	gi\|2874253749\|emb\|OY969623.1\|	1914239	g1493	i0	84.384	88.7751724137931	730	83	98	22	1	710	7050951	7050233	MAG: uncultured Gemmataceae bacterium isolate MFD06742.bin.c.1 genome assembly, chromosome: 1	blastn	64362	688	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
11613733	11613733	PRJEB7366_P_NODE_11890_length_235_cov_1.305000_g11456_i0	PRJEB7366	11890	235	1.305	3.06675	Singulisphaera sp. Ch08	3120278	Bacteria	Bacteria	289	1.47e-73	NTclustered	gi\|2732846650\|gb\|CP155447.1\|	3120278	g11456	i0	89.03	166.042553191489	237	21	100	5	1	235	2809208	2808975	Singulisphaera sp. Ch08 chromosome, complete genome	blastn	39020	289	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae	Singulisphaera	Singulisphaera sp. Ch08
17986827	17986827	PRJEB7366_P_NODE_16675_length_189_cov_4.272727_g16241_i0	PRJEB7366	16675	189	4.272727	8.07545403	uncultured Gemmataceae bacterium	1914239	Bacteria	Bacteria	289	1.14e-73	NTclustered	gi\|2874253749\|emb\|OY969623.1\|	1914239	g16241	i0	94.18	697.513227513228	189	11	100	0	1	189	7053135	7053323	MAG: uncultured Gemmataceae bacterium isolate MFD06742.bin.c.1 genome assembly, chromosome: 1	blastn	131830	289	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
19260834	19260834	PRJEB7366_P_NODE_16276_length_192_cov_2.038217_g15842_i0	PRJEB7366	16276	192	2.038217	3.91337664	Phycisphaerales bacterium	2052180	Bacteria	Bacteria	88.2	3.94e-19	NR	MBL8881156.1	2052180	g15842	i0	68.8	7.84375	64	20	100	0	192	1	83	146	MBL8881156.1 3-hydroxyacyl-CoA dehydrogenase family protein [Phycisphaerales bacterium]	diamond	1506	88.2	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			Phycisphaerales bacterium
26622526	26622526	PRJEB7366_P_NODE_5421_length_387_cov_1.863636_g4988_i0	PRJEB7366	5421	387	1.863636	7.21227132	Planctomycetota bacterium	2026780	Bacteria	Bacteria	77	8.04e-14	NR	MDX2017484.1	2026780	g4988	i0	43.3	0.751937984496124	97	51	75.2	2	74	364	125	217	MDX2017484.1 choice-of-anchor A family protein [Planctomycetota bacterium]	diamond	291	77	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
27311633	27311633	PRJEB7366_P_NODE_823_length_1073_cov_3.099229_g607_i0	PRJEB7366	823	1073	3.099229	33.25472717	Pseudomonadati	3379134	Bacteria	Bacteria	49.7	0.0219	NR	MCA9291207.1	2052180	g607	i0	28.8	1.31127679403541	205	114	54	8	274	852	841	1025	MCA9291207.1 filamentous hemagglutinin N-terminal domain-containing protein [Phycisphaerales bacterium]	diamond	1407	50.1	0.992015968063872	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			Phycisphaerales bacterium
27571238	27571238	PRJEB7366_P_NODE_6824_length_335_cov_2.693333_g6390_i0	PRJEB7366	6824	335	2.693333	9.02266555	Phycisphaerae bacterium RAS1	2528034	Bacteria	Bacteria	58.2	4.22e-7	NR	TWT44212.1	2528034	g6390	i0	46.2	0.698507462686567	78	40	69	2	328	98	667	743	TWT44212.1 Glutamine synthetase [Phycisphaerae bacterium RAS1]	diamond	234	58.2	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae				Phycisphaerae bacterium RAS1
28139857	28139857	PRJEB7366_P_NODE_16765_length_189_cov_1.292208_g16331_i0	PRJEB7366	16765	189	1.292208	2.44227312	Planctomycetota bacterium	2026780	Bacteria	Bacteria	57.8	7.57e-8	NR	MEE8468276.1	2026780	g16331	i0	65.7	1.66666666666667	35	12	55.6	0	187	83	261	295	MEE8468276.1 3-hydroxyacyl-CoA dehydrogenase NAD-binding domain-containing protein [Planctomycetota bacterium]	diamond	315	57.8	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
28763790	28763790	PRJEB7366_P_NODE_15407_length_199_cov_1.219512_g14973_i0	PRJEB7366	15407	199	1.219512	2.42682888	Pseudomonadati	3379134	Bacteria	Bacteria	48.9	1.33e-4	NR	MEM1165877.1	2026780	g14973	i0	52.4	3.18090452261307	42	20	63.3	0	197	72	361	402	MEM1165877.1 zinc metallochaperone GTPase ZigA [Planctomycetota bacterium]	diamond	633	49.3	0.991886409736308	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
28953569	28953569	PRJEB7366_P_NODE_9328_length_275_cov_2.466667_g8894_i0	PRJEB7366	9328	275	2.466667	6.78333425	Bacteria	2	Bacteria	Bacteria	59.7	1.14e-8	NR	MBW7991269.1	2026780	g8894	i0	44.8	2.94545454545455	67	33	73.1	1	270	70	98	160	MBW7991269.1 ferritin family protein [Planctomycetota bacterium]	diamond	810	59.7	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
29086964	29086964	PRJEB7366_P_NODE_20368_length_168_cov_2.308271_g19934_i0	PRJEB7366	20368	168	2.308271	3.87789528	Phycisphaerae bacterium	2026778	Bacteria	Bacteria	51.6	9.92e-6	NR	MFQ5414057.1	2026778	g19934	i0	43.8	0.857142857142857	48	26	83.9	1	158	18	341	388	MFQ5414057.1 hypothetical protein [Phycisphaerae bacterium]	diamond	144	51.6	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae				Phycisphaerae bacterium
29521630	29521630	PRJEB7366_P_NODE_5650_length_377_cov_1.614035_g5217_i0	PRJEB7366	5650	377	1.614035	6.08491195	Pseudomonadati	3379134	Bacteria	Bacteria	52.4	6.69e-5	NR	OPZ98894.1	1852905	g5217	i0	43.5	4.3368700265252	69	38	54.1	1	52	255	392	460	OPZ98894.1 MAG: Large cysteine-rich periplasmic protein OmcB precursor [Planctomycetes bacterium ADurb.Bin412]	diamond	1635	52.8	0.992424242424242	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetes bacterium ADurb.Bin412
29876284	29876284	PRJEB7366_P_NODE_16031_length_194_cov_1.761006_g15597_i0	PRJEB7366	16031	194	1.761006	3.41635164	Planctomycetota bacterium	2026780	Bacteria	Bacteria	50.1	5.03e-5	NR	MFH1268967.1	2026780	g15597	i0	53.5	0.664948453608247	43	20	66.5	0	62	190	293	335	MFH1268967.1 TMEM143 family protein [Planctomycetota bacterium]	diamond	129	50.1	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
30065612	30065612	PRJEB7366_P_NODE_7592_length_313_cov_2.158273_g7158_i0	PRJEB7366	7592	313	2.158273	6.75539449	Phycisphaerales bacterium	2052180	Bacteria	Bacteria	138	2.8099999999999997e-35	NR	HMN42288.1	2052180	g7158	i0	55.8	0.996805111821086	104	46	99.7	0	2	313	1349	1452	HMN42288.1 GC-type dockerin domain-anchored protein [Phycisphaerales bacterium]	diamond	312	138	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			Phycisphaerales bacterium
30090005	30090005	PRJEB7366_P_NODE_19072_length_175_cov_1.142857_g18638_i0	PRJEB7366	19072	175	1.142857	1.99999975	Bacteria	2	Bacteria	Bacteria	82	2.11e-16	NR	MDP9173442.1	2026780	g18638	i0	60.7	3.92571428571429	56	22	96	0	2	169	370	425	MDP9173442.1 phosphoglycerate dehydrogenase [Planctomycetota bacterium]	diamond	687	82	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
30413569	30413569	PRJEB7366_P_NODE_11293_length_243_cov_1.471154_g10859_i0	PRJEB7366	11293	243	1.471154	3.57490422	Phycisphaerae bacterium	2026778	Bacteria	Bacteria	56.2	6.78e-7	NR	MFQ5414057.1	2026778	g10859	i0	38.6	1.02469135802469	83	39	92.6	4	16	240	305	383	MFQ5414057.1 hypothetical protein [Phycisphaerae bacterium]	diamond	249	56.2	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae				Phycisphaerae bacterium
31519628	31519628	PRJEB7366_P_NODE_976_length_999_cov_4.215768_g739_i0	PRJEB7366	976	999	4.215768	42.11552232	Planctomycetota bacterium	2026780	Bacteria	Bacteria	78.2	1.09e-13	NR	MEW6744140.1	2026780	g739	i0	40.5	0.606606606606607	111	55	30	2	393	692	21	131	MEW6744140.1 hypothetical protein [Planctomycetota bacterium]	diamond	606	78.2	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
32113426	32113426	PRJEB7366_P_NODE_4038_length_463_cov_2.359813_g3613_i0	PRJEB7366	4038	463	2.359813	10.92593419	Bacteria	2	Bacteria	Bacteria	160	2.06e-42	NR	OQB82108.1	1852903	g3613	i0	75.3	3.16198704103672	97	24	62.9	0	461	171	839	935	OQB82108.1 MAG: Pyruvate, phosphate dikinase [Planctomycetes bacterium ADurb.Bin126]	diamond	1464	160	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetes bacterium ADurb.Bin126
32626374	32626374	PRJEB7366_P_NODE_14740_length_205_cov_1.176471_g14306_i0	PRJEB7366	14740	205	1.176471	2.41176555	Phycisphaerales bacterium	2052180	Bacteria	Bacteria	68.6	1.76e-11	NR	HMN42288.1	2052180	g14306	i0	42.4	0.965853658536585	66	38	96.6	0	203	6	1355	1420	HMN42288.1 GC-type dockerin domain-anchored protein [Phycisphaerales bacterium]	diamond	198	68.6	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);;