metadata: contig_metadata: 21 rows where bioproject = "PRJNA1073183" and tax

21 rows where bioproject = "PRJNA1073183" 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
1016073	1016073	PRJNA1073183_P_NODE_4461_length_599_cov_1.638783_g4369_i0	PRJNA1073183	4461	599	1.638783	9.81631017	Pirellulaceae bacterium	2699754	Bacteria	Bacteria	229	6.420000000000001e-73	NR	MFK7736369.1	2699754	g4369	i0	62.9	2.70951585976628	178	61	87.1	3	39	560	21	197	MFK7736369.1 peptidylprolyl isomerase [Pirellulaceae bacterium]	diamond	1623	229	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae		Pirellulaceae bacterium
4013793	4013793	PRJNA1073183_P_NODE_3184_length_701_cov_1.805732_g3099_i0	PRJNA1073183	3184	701	1.805732	12.65818132	Verrucomicrobiaceae bacterium	2026800	Bacteria	Bacteria	348	1.29e-117	NR	RYD65414.1	2026800	g3099	i0	73.9	1.00142653352354	234	58	99.7	2	700	2	85	316	RYD65414.1 MAG: hypothetical protein EOP84_31955 [Verrucomicrobiaceae bacterium]	diamond	702	348	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae		Verrucomicrobiaceae bacterium
10390308	10390308	PRJNA1073183_P_NODE_10889_length_389_cov_2.066456_g10794_i0	PRJNA1073183	10889	389	2.066456	8.03851384	uncultured Verrucomicrobiota bacterium	156588	Bacteria	Bacteria	496	1.43e-135	NTclustered	gi\|226525339\|gb\|FJ872375.1\|	156588	g10794	i0	91.831	155.804627249357	355	29	91	0	1	355	27824	27470	Uncultured Verrucomicrobia bacterium clone 286 genomic sequence	blastn	60608	496	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					uncultured Verrucomicrobiota bacterium
11665886	11665886	PRJNA1073183_P_NODE_24590_length_262_cov_2.005291_g24495_i0	PRJNA1073183	24590	262	2.005291	5.25386242	uncultured Planctomycetaceae bacterium	100233	Bacteria	Bacteria	451	2.02e-122	NTclustered	gi\|389547028\|gb\|JQ401956.1\|	100233	g24495	i0	97.71	98.2328244274809	262	6	100	0	1	262	39	300	Uncultured Planctomycetaceae bacterium clone CNY_02197 16S ribosomal RNA gene, partial sequence	blastn	25737	451	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		uncultured Planctomycetaceae bacterium
12941003	12941003	PRJNA1073183_P_NODE_25491_length_256_cov_3.234973_g25396_i0	PRJNA1073183	25491	256	3.234973	8.28153088	uncultured Planctomycetaceae bacterium	100233	Bacteria	Bacteria	215	2.8e-51	NTclustered	gi\|2874254106\|emb\|OY970189.1\|	100233	g25396	i0	85.922	113.05078125	206	23	79	6	9	211	4317291	4317089	MAG: uncultured Planctomycetaceae bacterium isolate MFD09603.bin.2.127 genome assembly, chromosome: 1	blastn	28941	215	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		uncultured Planctomycetaceae bacterium
15489960	15489960	PRJNA1073183_P_NODE_30873_length_245_cov_1.901163_g30778_i0	PRJNA1073183	30873	245	1.901163	4.65784935	uncultured Gemmataceae bacterium	1914239	Bacteria	Bacteria	353	5.41e-93	NTclustered	gi\|2874253853\|emb\|OY969909.1\|	1914239	g30778	i0	92.653	194.951020408163	245	18	100	0	1	245	2002870	2002626	MAG: uncultured Gemmataceae bacterium isolate MFD01275.bin.c.1 genome assembly, chromosome: 1	blastn	47763	353	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
16764429	16764429	PRJNA1073183_P_NODE_8634_length_434_cov_1.673130_g8540_i0	PRJNA1073183	8634	434	1.67313	7.2613842	Chlamydiales bacterium	2047757	Bacteria	Bacteria	242	8.820000000000001e-80	NR	MCP5470421.1	2047757	g8540	i0	81.1	0.988479262672811	143	27	98.8	0	6	434	1	143	MCP5470421.1 hypothetical protein [Chlamydiales bacterium]	diamond	429	242	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales			Chlamydiales bacterium
17593823	17593823	PRJNA1073183_P_NODE_19314_length_297_cov_1.736607_g19219_i0	PRJNA1073183	19314	297	1.736607	5.15772279	Singulisphaera	466152	Bacteria	Bacteria	387	6.66e-103	NTclustered	gi\|485099129\|ref\|NR_102524.1\|	466153	g19219	i0	90.301	118.043771043771	299	24	99	5	2	297	299	3	Singulisphaera acidiphila strain MOB10 23S ribosomal RNA gene, complete sequence	blastn	35059	387	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae	Singulisphaera	Singulisphaera acidiphila
21864238	21864238	PRJNA1073183_P_NODE_34298_length_241_cov_0.916667_g34203_i0	PRJNA1073183	34298	241	0.916667	2.20916747	Pseudomonadati	3379134	Bacteria	Bacteria	117	1.9000000000000003e-28	NR	MSU23997.1	1913982	g34203	i0	79.7	13.6680497925311	79	16	98.3	0	3	239	603	681	MSU23997.1 DUF1592 domain-containing protein [Opitutus sp.]	diamond	3294	117	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Opitutus	Opitutus sp.
26655638	26655638	PRJNA1073183_P_NODE_32101_length_244_cov_0.900585_g32006_i0	PRJNA1073183	32101	244	0.900585	2.1974274	Chlamydiales bacterium	2047757	Bacteria	Bacteria	140	2.07e-40	NR	MCP5470420.1	2047757	g32006	i0	80.2	0.995901639344262	81	16	99.6	0	1	243	2	82	MCP5470420.1 ribosomal protein L24e family protein [Chlamydiales bacterium]	diamond	243	140	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales			Chlamydiales bacterium
27446861	27446861	PRJNA1073183_P_NODE_13103_length_358_cov_1.080702_g13008_i0	PRJNA1073183	13103	358	1.080702	3.86891316	Telmatocola sphagniphila	1123043	Bacteria	Bacteria	68.9	8.84e-11	NR	WP_213498649.1	1123043	g13008	i0	28.2	2.70670391061453	131	80	98	1	6	356	468	598	WP_213498649.1 ATP-dependent zinc metalloprotease FtsH [Telmatocola sphagniphila]	diamond	969	68.9	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Telmatocola	Telmatocola sphagniphila
28235688	28235688	PRJNA1073183_P_NODE_17366_length_314_cov_1.099585_g17271_i0	PRJNA1073183	17366	314	1.099585	3.4526969	Waddliaceae bacterium	2026802	Bacteria	Bacteria	70.1	1.65e-11	NR	HEY4831209.1	2026802	g17271	i0	45.3	1.39490445859873	86	45	80.3	1	1	252	267	352	HEY4831209.1 F0F1 ATP synthase subunit alpha [Waddliaceae bacterium]	diamond	438	70.1	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Waddliaceae		Waddliaceae bacterium
28678152	28678152	PRJNA1073183_P_NODE_2787_length_747_cov_1.158754_g2704_i0	PRJNA1073183	2787	747	1.158754	8.65589238	Verrucomicrobiaceae bacterium	2026800	Bacteria	Bacteria	381	2.7799999999999993e-126	NR	RYD77759.1	2026800	g2704	i0	78.4	0.983935742971888	245	53	98.4	0	737	3	161	405	RYD77759.1 MAG: hypothetical protein EOP84_15150, partial [Verrucomicrobiaceae bacterium]	diamond	735	381	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae		Verrucomicrobiaceae bacterium
28795628	28795628	PRJNA1073183_P_NODE_26847_length_251_cov_0.865169_g26752_i0	PRJNA1073183	26847	251	0.865169	2.17157419	Bacteria	2	Bacteria	Bacteria	76.6	3.47e-14	NR	MFM1768708.1	2026799	g26752	i0	44.7	3.54980079681275	76	40	90.8	2	16	243	73	146	MFM1768708.1 hypothetical protein [Verrucomicrobiota bacterium]	diamond	891	76.6	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
28898843	28898843	PRJNA1073183_P_NODE_12708_length_363_cov_1.327586_g12613_i0	PRJNA1073183	12708	363	1.327586	4.81913718	Verrucomicrobiaceae bacterium	2026800	Bacteria	Bacteria	128	6.84e-33	NR	RYD71398.1	2026800	g12613	i0	58.5	0.975206611570248	118	46	95	3	347	3	233	350	RYD71398.1 MAG: hypothetical protein EOP84_24945, partial [Verrucomicrobiaceae bacterium]	diamond	354	128	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae		Verrucomicrobiaceae bacterium
29246303	29246303	PRJNA1073183_P_NODE_24209_length_265_cov_1.203125_g24114_i0	PRJNA1073183	24209	265	1.203125	3.18828125	Opitutaceae bacterium	2006848	Bacteria	Bacteria	43.1	0.0352	NR	HXC01461.1	2006848	g24114	i0	33.7	0.973584905660377	86	44	82.6	3	22	240	371	456	HXC01461.1 methyltransferase domain-containing protein [Opitutaceae bacterium]	diamond	258	43.1	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae		Opitutaceae bacterium
30004298	30004298	PRJNA1073183_P_NODE_10131_length_403_cov_1.830303_g10037_i0	PRJNA1073183	10131	403	1.830303	7.37612109	Lentisphaerota bacterium	1932692	Bacteria	Bacteria	47	0.00695	NR	NQU40615.1	1932692	g10037	i0	50	0.588089330024814	46	21	34.2	1	1	138	378	421	NQU40615.1 glycosyltransferase [Lentisphaerota bacterium]	diamond	237	47	1	Bacteria	PVC group	Pseudomonadati	Lentisphaerota					Lentisphaerota bacterium
31047157	31047157	PRJNA1073183_P_NODE_29015_length_248_cov_0.880000_g28920_i0	PRJNA1073183	29015	248	0.88	2.1824	Sedimentisphaerales bacterium	2813034	Bacteria	Bacteria	81.6	2.07e-16	NR	MBN1974499.1	2813034	g28920	i0	64.2	0.641129032258065	53	19	64.1	0	162	4	8	60	MBN1974499.1 hypothetical protein [Sedimentisphaerales bacterium]	diamond	159	81.6	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Sedimentisphaerales			Sedimentisphaerales bacterium
31164456	31164456	PRJNA1073183_P_NODE_28795_length_248_cov_0.880000_g28700_i0	PRJNA1073183	28795	248	0.88	2.1824	Bacteria	2	Bacteria	Bacteria	147	4.73e-39	NR	MFN4244329.1	2795155	g28700	i0	82.9	9.91935483870968	82	14	99.2	0	246	1	1076	1157	MFN4244329.1 methionine synthase [Tepidisphaerales bacterium]	diamond	2460	147	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Tepidisphaerales			Tepidisphaerales bacterium
32249085	32249085	PRJNA1073183_P_NODE_26358_length_251_cov_1.297753_g26263_i0	PRJNA1073183	26358	251	1.297753	3.25736003	Parachlamydiaceae bacterium	2052176	Bacteria	Bacteria	102	8.989999999999998e-24	NR	MBA3815054.1	2052176	g26263	i0	57.8	5.00796812749004	83	34	98	1	250	5	230	312	MBA3815054.1 RsmB/NOP family class I SAM-dependent RNA methyltransferase [Parachlamydiaceae bacterium]	diamond	1257	102	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae		Parachlamydiaceae bacterium
32470455	32470455	PRJNA1073183_P_NODE_28439_length_249_cov_0.875000_g28344_i0	PRJNA1073183	28439	249	0.875	2.17875	Planctomycetota bacterium	2026780	Bacteria	Bacteria	43.9	0.00629	NR	MBL8754923.1	2026780	g28344	i0	42.9	0.927710843373494	77	32	83.1	4	214	8	14	86	MBL8754923.1 hypothetical protein [Planctomycetota bacterium]	diamond	231	43.9	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota 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);;