metadata: contig_metadata: 20 rows where bioproject = "PRJNA760976" and tax

20 rows where bioproject = "PRJNA760976" 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
742319	742319	PRJNA760976_P_NODE_20301_length_347_cov_1.572993_g19980_i0	PRJNA760976	20301	347	1.572993	5.45828571	Pirellula sp. SH-Sr6A	1632865	Bacteria	Bacteria	542	1.5999999999999996e-149	NTclustered	gi\|1015448679\|gb\|CP011272.1\|	1632865	g19980	i0	95.072	229.449567723343	345	15	99	2	3	347	3095881	3096223	Pirellula sp. SH-Sr6A, complete genome	blastn	79619	542	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Pirellula	Pirellula sp. SH-Sr6A
742378	742378	PRJNA760976_P_NODE_381_length_1806_cov_4.244662_g300_i0	PRJNA760976	381	1806	4.244662	76.65859572	uncultured Parachlamydiaceae bacterium	464461	Bacteria	Bacteria	2351	0	NTclustered	gi\|2874253811\|emb\|OY969795.1\|	464461	g300	i0	90.252	117.550387596899	1826	141	99	30	3	1806	655386	653576	MAG: uncultured Parachlamydiaceae bacterium isolate MFD05502.bin.c.3 genome assembly, chromosome: 1	blastn	212296	2351	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae		uncultured Parachlamydiaceae bacterium
3293632	3293632	PRJNA760976_P_NODE_31363_length_297_cov_2.008929_g31042_i0	PRJNA760976	31363	297	2.008929	5.96651913	Chthoniobacterales bacterium	2201154	Bacteria	Bacteria	129	2.49e-32	NR	HEY5753501.1	2201154	g31042	i0	61.5	4.57575757575758	91	35	91.9	0	3	275	382	472	HEY5753501.1 alpha-galactosidase [Chthoniobacterales bacterium]	diamond	1359	129	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Spartobacteria	Chthoniobacterales			Chthoniobacterales bacterium
5845986	5845986	PRJNA760976_P_NODE_52085_length_245_cov_0.877907_g51764_i0	PRJNA760976	52085	245	0.877907	2.15087215	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	453	5.1900000000000006e-123	NTclustered	gi\|2874254019\|emb\|OY970344.1\|	412056	g51764	i0	100	202.167346938776	245	0	100	0	1	245	736722	736478	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04580.bin.c.3 genome assembly, chromosome: 1	blastn	49531	453	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
9670843	9670843	PRJNA760976_P_NODE_52408_length_244_cov_3.111111_g52087_i0	PRJNA760976	52408	244	3.111111	7.59111084	Pirellula sp. SH-Sr6A	1632865	Bacteria	Bacteria	363	8.949999999999999e-96	NTclustered	gi\|1015448679\|gb\|CP011272.1\|	1632865	g52087	i0	93.443	94.8483606557377	244	16	100	0	1	244	3097522	3097765	Pirellula sp. SH-Sr6A, complete genome	blastn	23143	363	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Pirellula	Pirellula sp. SH-Sr6A
13496071	13496071	PRJNA760976_P_NODE_13571_length_399_cov_2.168712_g13251_i0	PRJNA760976	13571	399	2.168712	8.65316088	Candidatus Organicella extenuata	2841811	Bacteria	Bacteria	78.7	6.31e-10	NTclustered	gi\|2569232906\|gb\|CP128385.1\|	2841811	g13251	i0	82.222	13.4411027568922	90	16	23	0	309	398	111648	111737	MAG: Candidatus Organicella extenuata isolate MAG_Ga0307966_1000010 chromosome, complete genome	blastn	5363	78.7	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota				Candidatus Organicella	Candidatus Organicella extenuata
22882707	22882707	PRJNA760976_P_NODE_11638_length_424_cov_2.179487_g11318_i0	PRJNA760976	11638	424	2.179487	9.24102488	Planctomycetia	203683	Bacteria	Bacteria	640	6.85e-179	NTclustered	gi\|12583969\|gb\|AF245373.1\|AF245373	79870	g11318	i0	94.313	120.905660377358	422	17	99	3	1	422	1444	1030	Planctomycete str. 449 23S ribosomal RNA gene, partial sequence	blastn	51264	640	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		planctomycete str. 449
27811474	27811474	PRJNA760976_P_NODE_34064_length_289_cov_1.027778_g33743_i0	PRJNA760976	34064	289	1.027778	2.97027842	Gemmataceae bacterium	2052164	Bacteria	Bacteria	99.4	8.34e-22	NR	HEX3148041.1	2052164	g33743	i0	54.3	1.94117647058824	94	43	97.6	0	3	284	635	728	HEX3148041.1 hypothetical protein [Gemmataceae bacterium]	diamond	561	99.4	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		Gemmataceae bacterium
28852974	28852974	PRJNA760976_P_NODE_56048_length_241_cov_1.351190_g55727_i0	PRJNA760976	56048	241	1.35119	3.2563679	Fuerstiella sp.	1936112	Bacteria	Bacteria	74.7	1.71e-13	NR	MEP3482112.1	1936112	g55727	i0	50	1.81742738589212	72	34	89.6	1	239	24	204	273	MEP3482112.1 NO-inducible flavohemoprotein [Fuerstiella sp.]	diamond	438	74.7	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Fuerstiella	Fuerstiella sp.
28916098	28916098	PRJNA760976_P_NODE_39848_length_272_cov_1.155779_g39527_i0	PRJNA760976	39848	272	1.155779	3.14371888	Parachlamydiaceae bacterium	2052176	Bacteria	Bacteria	95.5	1.2e-23	NR	MBA3721671.1	2052176	g39527	i0	64.6	1.43382352941176	65	23	71.7	0	76	270	1	65	MBA3721671.1 CsbD family protein [Parachlamydiaceae bacterium]	diamond	390	95.5	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae		Parachlamydiaceae bacterium
28979659	28979659	PRJNA760976_P_NODE_41908_length_266_cov_1.554404_g41587_i0	PRJNA760976	41908	266	1.554404	4.13471464	Gemmataceae bacterium	2052164	Bacteria	Bacteria	48.9	3.17e-4	NR	HEY8503922.1	2052164	g41587	i0	37.7	0.868421052631579	77	39	86.8	3	231	1	266	333	HEY8503922.1 hypothetical protein [Gemmataceae bacterium]	diamond	231	48.9	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		Gemmataceae bacterium
29526023	29526023	PRJNA760976_P_NODE_47910_length_251_cov_1.264045_g47589_i0	PRJNA760976	47910	251	1.264045	3.17275295	Pseudomonadati	3379134	Bacteria	Bacteria	102	6.989999999999999e-24	NR	MBS0634548.1	2026799	g47589	i0	61.8	3.70517928286853	76	29	90.8	0	249	22	28	103	MBS0634548.1 glycosyltransferase [Verrucomicrobiota bacterium]	diamond	930	103	0.990291262135922	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
30653276	30653276	PRJNA760976_P_NODE_49273_length_248_cov_2.600000_g48952_i0	PRJNA760976	49273	248	2.6	6.448	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	45.8	7.3e-4	NR	MEI6341283.1	2026799	g48952	i0	58.1	0.375	31	13	37.5	0	105	13	4	34	MEI6341283.1 hypothetical protein [Verrucomicrobiota bacterium]	diamond	93	45.8	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
30811400	30811400	PRJNA760976_P_NODE_35834_length_283_cov_1.442857_g35513_i0	PRJNA760976	35834	283	1.442857	4.08328531	Chlamydiota bacterium	2081524	Bacteria	Bacteria	47.8	8.72e-4	NR	MES2344608.1	2081524	g35513	i0	42.2	0.477031802120141	45	25	47.7	1	3	137	172	215	MES2344608.1 hypothetical protein [Chlamydiota bacterium]	diamond	135	47.8	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota					Chlamydiota bacterium
30843120	30843120	PRJNA760976_P_NODE_12134_length_418_cov_0.849275_g11814_i0	PRJNA760976	12134	418	0.849275	3.5499695	Planctomycetota bacterium	2026780	Bacteria	Bacteria	56.2	4.75e-6	NR	NLE60524.1	2026780	g11814	i0	37.6	0.839712918660287	117	69	83.3	3	409	62	67	180	NLE60524.1 carboxypeptidase regulatory-like domain-containing protein [Planctomycetota bacterium]	diamond	351	56.2	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
30874591	30874591	PRJNA760976_P_NODE_46994_length_253_cov_1.633333_g46673_i0	PRJNA760976	46994	253	1.633333	4.13233249	Simkania sp.	34094	Bacteria	Bacteria	152	4.39e-45	NR	MCB1084326.1	34094	g46673	i0	78.3	0.984189723320158	83	18	98.4	0	253	5	47	129	MCB1084326.1 serine/threonine-protein kinase [Simkania sp.]	diamond	249	152	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Simkaniaceae	Simkania	Simkania sp.
31664863	31664863	PRJNA760976_P_NODE_51137_length_246_cov_0.890173_g50816_i0	PRJNA760976	51137	246	0.890173	2.18982558	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	42.4	0.0423	NR	MCX6950839.1	2026799	g50816	i0	39.3	0.682926829268293	56	33	68.3	1	62	229	106	160	MCX6950839.1 phosphatase PAP2 family protein [Verrucomicrobiota bacterium]	diamond	168	42.4	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
32298122	32298122	PRJNA760976_P_NODE_39559_length_273_cov_0.950000_g39238_i0	PRJNA760976	39559	273	0.95	2.5935	Haloferula helveola	490095	Bacteria	Bacteria	56.2	9.72e-7	NR	WP_338688672.1	490095	g39238	i0	50	0.769230769230769	70	27	73.6	3	34	234	116	180	WP_338688672.1 IPT/TIG domain-containing protein [Haloferula helveola]	diamond	210	56.2	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Haloferula	Haloferula helveola
32613942	32613942	PRJNA760976_P_NODE_57040_length_239_cov_2.728916_g56719_i0	PRJNA760976	57040	239	2.728916	6.52210924	Chthoniobacterales bacterium	2201154	Bacteria	Bacteria	97.1	5.69e-22	NR	HYY13565.1	2201154	g56719	i0	60	8.56066945606694	75	30	94.1	0	230	6	28	102	HYY13565.1 hypothetical protein [Chthoniobacterales bacterium]	diamond	2046	97.1	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Spartobacteria	Chthoniobacterales			Chthoniobacterales bacterium
32645092	32645092	PRJNA760976_P_NODE_53460_length_244_cov_0.859649_g53139_i0	PRJNA760976	53460	244	0.859649	2.09754356	Tepidisphaeraceae bacterium	2876886	Bacteria	Bacteria	50.8	4.87e-5	NR	HMB95802.1	2876886	g53139	i0	82.6	0.565573770491803	23	4	28.3	0	244	176	282	304	HMB95802.1 DUF4139 domain-containing protein [Tepidisphaeraceae bacterium]	diamond	138	50.8	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Tepidisphaerales	Tepidisphaeraceae		Tepidisphaeraceae 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);;