metadata: contig_metadata: 14 rows where bioproject = "PRJNA562549" and tax

14 rows where bioproject = "PRJNA562549" 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
9474351	9474351	PRJNA562549_P_NODE_29988_length_215_cov_3.928571_g29755_i0	PRJNA562549	29988	215	3.928571	8.44642765	Chlamydiales bacterium	2047757	Bacteria	Bacteria	136	3.28e-39	NR	MCP5470421.1	2047757	g29755	i0	90.1	0.990697674418605	71	7	99.1	0	3	215	7	77	MCP5470421.1 hypothetical protein [Chlamydiales bacterium]	diamond	213	136	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales			Chlamydiales bacterium
26762580	26762580	PRJNA562549_P_NODE_25481_length_232_cov_3.795322_g25248_i0	PRJNA562549	25481	232	3.795322	8.80514704	Planctomycetota bacterium	2026780	Bacteria	Bacteria	65.1	5.29e-12	NR	NBC10562.1	2026780	g25248	i0	65.5	0.711206896551724	55	18	71.1	1	25	189	1	54	NBC10562.1 YqaE/Pmp3 family membrane protein [Planctomycetota bacterium]	diamond	165	65.1	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
26952389	26952389	PRJNA562549_P_NODE_11782_length_334_cov_1.344322_g11549_i0	PRJNA562549	11782	334	1.344322	4.49003548	Verrucomicrobiaceae bacterium	2026800	Bacteria	Bacteria	110	1.81e-26	NR	RYD71398.1	2026800	g11549	i0	56.6	0.889221556886228	99	42	88	1	299	6	229	327	RYD71398.1 MAG: hypothetical protein EOP84_24945, partial [Verrucomicrobiaceae bacterium]	diamond	297	110	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae		Verrucomicrobiaceae bacterium
27300480	27300480	PRJNA562549_P_NODE_8243_length_400_cov_0.929204_g8010_i0	PRJNA562549	8243	400	0.929204	3.716816	Planctomycetota bacterium	2026780	Bacteria	Bacteria	45.4	0.0181	NR	MES2793200.1	2026780	g8010	i0	33.1	0.9525	127	63	85.5	7	354	13	95	212	MES2793200.1 hypothetical protein [Planctomycetota bacterium]	diamond	381	45.4	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
27679680	27679680	PRJNA562549_P_NODE_10524_length_354_cov_1.720137_g10291_i0	PRJNA562549	10524	354	1.720137	6.08928498	Simkania sp.	34094	Bacteria	Bacteria	85.9	1.2e-17	NR	MCB1084310.1	34094	g10291	i0	89.6	0.406779661016949	48	5	40.7	0	235	92	81	128	MCB1084310.1 hypothetical protein [Simkania sp.]	diamond	144	85.9	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Simkaniaceae	Simkania	Simkania sp.
27774317	27774317	PRJNA562549_P_NODE_9784_length_368_cov_2.045603_g9551_i0	PRJNA562549	9784	368	2.045603	7.52781904	Simkania sp.	34094	Bacteria	Bacteria	88.2	2.93e-19	NR	MCB1084323.1	34094	g9551	i0	62.1	0.53804347826087	66	25	53.8	0	203	6	30	95	MCB1084323.1 AMP-binding protein [Simkania sp.]	diamond	198	88.2	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Simkaniaceae	Simkania	Simkania sp.
27868701	27868701	PRJNA562549_P_NODE_36045_length_203_cov_0.915493_g35812_i0	PRJNA562549	36045	203	0.915493	1.85845079	Simkania sp.	34094	Bacteria	Bacteria	84	9.69e-18	NR	MCB1084310.1	34094	g35812	i0	76.5	0.753694581280788	51	12	75.4	0	46	198	1	51	MCB1084310.1 hypothetical protein [Simkania sp.]	diamond	153	84	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Simkaniaceae	Simkania	Simkania sp.
28595177	28595177	PRJNA562549_P_NODE_19307_length_264_cov_2.192118_g19074_i0	PRJNA562549	19307	264	2.192118	5.78719152	Simkania sp.	34094	Bacteria	Bacteria	178	2.2099999999999995e-55	NR	MCB1084326.1	34094	g19074	i0	93.1	0.988636363636364	87	6	98.9	0	263	3	41	127	MCB1084326.1 serine/threonine-protein kinase [Simkania sp.]	diamond	261	178	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Simkaniaceae	Simkania	Simkania sp.
28815765	28815765	PRJNA562549_P_NODE_30468_length_214_cov_1.549020_g30235_i0	PRJNA562549	30468	214	1.54902	3.3149028	Lentisphaerota bacterium	1932692	Bacteria	Bacteria	42	0.0484	NR	MBE6357758.1	1932692	g30235	i0	42.2	0.630841121495327	45	22	57.5	1	53	175	347	391	MBE6357758.1 glycosyltransferase family 39 protein [Lentisphaerota bacterium]	diamond	135	42	1	Bacteria	PVC group	Pseudomonadati	Lentisphaerota					Lentisphaerota bacterium
29510557	29510557	PRJNA562549_P_NODE_21210_length_253_cov_1.687500_g20977_i0	PRJNA562549	21210	253	1.6875	4.269375	Lentisphaerota bacterium	1932692	Bacteria	Bacteria	46.6	0.0018600000000000001	NR	MBE6406923.1	1932692	g20977	i0	52.2	1.64822134387352	46	22	54.5	0	250	113	267	312	MBE6406923.1 tetratricopeptide repeat protein [Lentisphaerota bacterium]	diamond	417	46.6	1	Bacteria	PVC group	Pseudomonadati	Lentisphaerota					Lentisphaerota bacterium
30016108	30016108	PRJNA562549_P_NODE_36271_length_202_cov_1.687943_g36038_i0	PRJNA562549	36271	202	1.687943	3.4096448600000002	Pirellulaceae bacterium	2699754	Bacteria	Bacteria	60.8	3.38e-9	NR	MFK7736369.1	2699754	g36038	i0	58	0.742574257425743	50	20	74.3	1	191	42	21	69	MFK7736369.1 peptidylprolyl isomerase [Pirellulaceae bacterium]	diamond	150	60.8	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae		Pirellulaceae bacterium
30092827	30092827	PRJNA562549_P_NODE_18252_length_271_cov_1.890476_g18019_i0	PRJNA562549	18252	271	1.890476	5.12318996	Roseimaritima	1579506	Bacteria	Bacteria	53.5	8.64e-6	NR	WP_145352804.1	1930274	g18019	i0	40.4	4.91512915129151	89	46	98.5	2	5	271	151	232	WP_145352804.1 DUF11 domain-containing protein [Roseimaritima multifibrata]	diamond	1332	53.9	0.992578849721707	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Roseimaritima	Roseimaritima multifibrata
31216177	31216177	PRJNA562549_P_NODE_26355_length_229_cov_1.654762_g26122_i0	PRJNA562549	26355	229	1.654762	3.78940498	Verrucomicrobiaceae bacterium	2026800	Bacteria	Bacteria	124	1.5799999999999999e-32	NR	RYD65414.1	2026800	g26122	i0	83.8	0.96943231441048	74	12	96.9	0	225	4	99	172	RYD65414.1 MAG: hypothetical protein EOP84_31955 [Verrucomicrobiaceae bacterium]	diamond	222	124	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae		Verrucomicrobiaceae bacterium
31690974	31690974	PRJNA562549_P_NODE_20217_length_259_cov_1.227273_g19984_i0	PRJNA562549	20217	259	1.227273	3.17863707	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	42.4	0.045	NR	MEI6341235.1	2026799	g19984	i0	44	0.579150579150579	50	26	55.6	1	103	246	109	158	MEI6341235.1 permease prefix domain 1-containing protein [Verrucomicrobiota bacterium]	diamond	150	42.4	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota 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);;