metadata: contig_metadata: 21 rows where analysis = "diamond", bioproject = "PRJNA674048" and tax

21 rows where analysis = "diamond", bioproject = "PRJNA674048" 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
21045702	21045702	PRJNA674048_P_NODE_30097_length_165_cov_0.896552_g29894_i0	PRJNA674048	30097	165	0.896552	1.4793108	Verrucomicrobiia bacterium	2499141	Bacteria	Bacteria	106	2.63e-27	NR	MCX7827560.1	2499141	g29894	i0	100	1	55	0	100	0	1	165	62	116	MCX7827560.1 SLC13 family permease [Verrucomicrobiia bacterium]	diamond	165	106	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				Verrucomicrobiia bacterium
26765270	26765270	PRJNA674048_P_NODE_30881_length_164_cov_0.904348_g30678_i0	PRJNA674048	30881	164	0.904348	1.48313072	Kiritimatiellia bacterium	2212473	Bacteria	Bacteria	39.7	0.0334	NR	MBP5285696.1	2212473	g30678	i0	40.4	1.04268292682927	57	23	91.5	5	163	14	22	74	MBP5285696.1 alpha-L-rhamnosidase [Kiritimatiellia bacterium]	diamond	171	39.7	1	Bacteria	PVC group	Pseudomonadati	Kiritimatiellota	Kiritimatiellia				Kiritimatiellia bacterium
27018477	27018477	PRJNA674048_P_NODE_24922_length_176_cov_1.354331_g24719_i0	PRJNA674048	24922	176	1.354331	2.38362256	Planctomycetaceae bacterium	2026779	Bacteria	Bacteria	53.5	2.38e-6	NR	MFO1006751.1	2026779	g24719	i0	52.5	1.00568181818182	59	27	98.9	1	1	174	1439	1497	MFO1006751.1 Ig-like domain-containing protein [Planctomycetaceae bacterium]	diamond	177	53.5	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		Planctomycetaceae bacterium
27018479	27018479	PRJNA674048_P_NODE_33642_length_156_cov_2.542056_g33439_i0	PRJNA674048	33642	156	2.542056	3.96560736	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	102	7.8e-24	NR	MBN9691045.1	2026799	g33439	i0	96.1	0.980769230769231	51	2	98.1	0	155	3	12	62	MBN9691045.1 efflux transporter outer membrane subunit [Verrucomicrobiota bacterium]	diamond	153	102	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
27682353	27682353	PRJNA674048_P_NODE_31704_length_163_cov_0.912281_g31501_i0	PRJNA674048	31704	163	0.912281	1.48701803	Planctomycetota bacterium	2026780	Bacteria	Bacteria	62.4	1.48e-9	NR	MCZ6735150.1	2026780	g31501	i0	56.6	0.975460122699387	53	23	97.5	0	1	159	209	261	MCZ6735150.1 integrin alpha [Planctomycetota bacterium]	diamond	159	62.4	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
27839680	27839680	PRJNA674048_P_NODE_17204_length_214_cov_1.890909_g17001_i0	PRJNA674048	17204	214	1.890909	4.04654526	Candidatus Omnitrophota bacterium	2035772	Bacteria	Bacteria	44.3	0.0072	NR	MBU1128693.1	2035772	g17001	i0	35.6	0.827102803738318	59	35	82.7	1	36	212	358	413	MBU1128693.1 B12-binding domain-containing radical SAM protein [Candidatus Omnitrophota bacterium]	diamond	177	44.3	1	Bacteria	PVC group	Pseudomonadati	Candidatus Omnitrophota					Candidatus Omnitrophota bacterium
28293706	28293706	PRJNA674048_P_NODE_29566_length_166_cov_0.888889_g29363_i0	PRJNA674048	29566	166	0.888889	1.47555574	Rubinisphaera	1649490	Bacteria	Bacteria	100	2.5e-23	NR	MCA8987869.1	2026779	g29363	i0	94.3	2.87349397590361	53	3	95.8	0	164	6	322	374	MCA8987869.1 rod shape-determining protein RodA [Planctomycetaceae bacterium]	diamond	477	101	0.99009900990099	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		Planctomycetaceae bacterium
28786904	28786904	PRJNA674048_P_NODE_31987_length_163_cov_0.912281_g31784_i0	PRJNA674048	31987	163	0.912281	1.48701803	Verrucomicrobiia bacterium	2499141	Bacteria	Bacteria	94	2.8400000000000003e-21	NR	HVR65458.1	2499141	g31784	i0	78.8	0.957055214723926	52	11	95.7	0	162	7	101	152	HVR65458.1 agmatinase [Verrucomicrobiia bacterium]	diamond	156	94	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				Verrucomicrobiia bacterium
28976675	28976675	PRJNA674048_P_NODE_32748_length_162_cov_0.920354_g32545_i0	PRJNA674048	32748	162	0.920354	1.49097348	Thalassoglobus polymorphus	2527994	Bacteria	Bacteria	110	1.24e-26	NR	WP_197441640.1	2527994	g32545	i0	86.5	0.962962962962963	52	7	96.3	0	160	5	635	686	WP_197441640.1 neutral/alkaline non-lysosomal ceramidase N-terminal domain-containing protein [Thalassoglobus polymorphus]	diamond	156	110	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Thalassoglobus	Thalassoglobus polymorphus
29134637	29134637	PRJNA674048_P_NODE_31849_length_163_cov_0.912281_g31646_i0	PRJNA674048	31849	163	0.912281	1.48701803	Rubinisphaera italica	2527969	Bacteria	Bacteria	76.3	1.34e-14	NR	WP_146503456.1	2527969	g31646	i0	67.9	0.975460122699387	53	17	97.5	0	1	159	269	321	WP_146503456.1 signal peptide peptidase SppA [Rubinisphaera italica]	diamond	159	76.3	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Rubinisphaera	Rubinisphaera italica
29967381	29967381	PRJNA674048_P_NODE_23391_length_182_cov_1.406015_g23188_i0	PRJNA674048	23391	182	1.406015	2.5589473	Bacteria	2	Bacteria	Bacteria	62.4	1.7e-9	NR	MCA9090848.1	2026779	g23188	i0	47.5	1.92857142857143	59	31	97.3	0	181	5	10	68	MCA9090848.1 TauD/TfdA family dioxygenase [Planctomycetaceae bacterium]	diamond	351	62.4	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		Planctomycetaceae bacterium
30472953	30472953	PRJNA674048_P_NODE_24713_length_177_cov_1.007812_g24510_i0	PRJNA674048	24713	177	1.007812	1.78382724	Bacteria	2	Bacteria	Bacteria	101	2.39e-23	NR	HSY54503.1	2006848	g24510	i0	81	5.89830508474576	58	11	98.3	0	176	3	32	89	HSY54503.1 transketolase [Opitutaceae bacterium]	diamond	1044	101	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae		Opitutaceae bacterium
30555497	30555497	PRJNA674048_P_NODE_27233_length_169_cov_0.866667_g27030_i0	PRJNA674048	27233	169	0.866667	1.46466723	Planctomycetaceae bacterium	2026779	Bacteria	Bacteria	86.7	4.46e-18	NR	MBA3315149.1	2026779	g27030	i0	81.8	0.976331360946746	55	10	97.6	0	3	167	244	298	MBA3315149.1 ATP-binding cassette domain-containing protein [Planctomycetaceae bacterium]	diamond	165	86.7	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		Planctomycetaceae bacterium
30555500	30555500	PRJNA674048_P_NODE_31173_length_164_cov_0.904348_g30970_i0	PRJNA674048	31173	164	0.904348	1.48313072	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	41.2	0.0445	NR	MBS0658504.1	2026799	g30970	i0	43.9	0.75	41	23	75	0	2	124	177	217	MBS0658504.1 hypothetical protein [Verrucomicrobiota bacterium]	diamond	123	41.2	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
31725190	31725190	PRJNA674048_P_NODE_12197_length_263_cov_0.971963_g11994_i0	PRJNA674048	12197	263	0.971963	2.55626269	Chlamydiales bacterium	2047757	Bacteria	Bacteria	121	5.35e-33	NR	MCP5470421.1	2047757	g11994	i0	70.9	1.97338403041825	86	25	98.1	0	2	259	31	116	MCP5470421.1 hypothetical protein [Chlamydiales bacterium]	diamond	519	121	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales			Chlamydiales bacterium
31788319	31788319	PRJNA674048_P_NODE_9737_length_303_cov_1.385827_g9534_i0	PRJNA674048	9737	303	1.385827	4.19905581	Planctomycetota bacterium	2026780	Bacteria	Bacteria	62.8	7.13e-9	NR	MEK6799202.1	2026780	g9534	i0	63.4	0.831683168316832	41	15	40.6	0	298	176	1568	1608	MEK6799202.1 EGF domain-containing protein [Planctomycetota bacterium]	diamond	252	62.8	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
31851665	31851665	PRJNA674048_P_NODE_31997_length_163_cov_0.912281_g31794_i0	PRJNA674048	31997	163	0.912281	1.48701803	Planctomycetota bacterium	2026780	Bacteria	Bacteria	41.6	0.0317	NR	GJM20625.1	2026780	g31794	i0	51.2	0.791411042944785	43	21	79.1	0	134	6	173	215	GJM20625.1 MAG: hypothetical protein DHS20C15_05400 [Planctomycetota bacterium]	diamond	129	41.6	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
32010053	32010053	PRJNA674048_P_NODE_31998_length_163_cov_0.912281_g31795_i0	PRJNA674048	31998	163	0.912281	1.48701803	Rubinisphaera sp. JC75	2024857	Bacteria	Bacteria	91.7	4.3700000000000005e-21	NR	WP_237226502.1	2898658	g31795	i0	78.8	1.91411042944785	52	11	95.7	0	158	3	92	143	WP_237226502.1 bL17 family ribosomal protein [Rubinisphaera sp. JC750]	diamond	312	91.7	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Rubinisphaera	Rubinisphaera sp. JC750
32168422	32168422	PRJNA674048_P_NODE_11918_length_267_cov_1.192661_g11715_i0	PRJNA674048	11918	267	1.192661	3.18440487	Pirellulaceae bacterium	2699754	Bacteria	Bacteria	43.5	0.027	NR	HUE72001.1	2699754	g11715	i0	32.4	0.831460674157303	74	47	83.1	1	5	226	965	1035	HUE72001.1 hypothetical protein [Pirellulaceae bacterium]	diamond	222	43.5	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae		Pirellulaceae bacterium
32168427	32168427	PRJNA674048_P_NODE_29138_length_166_cov_1.444444_g28935_i0	PRJNA674048	29138	166	1.444444	2.39777704	Pirellulales bacterium	2715253	Bacteria	Bacteria	62.4	8.56e-10	NR	MDA7977157.1	2715253	g28935	i0	65.5	0.993975903614458	55	19	99.4	0	2	166	165	219	MDA7977157.1 slipin family protein [Pirellulales bacterium]	diamond	165	62.4	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales			Pirellulales bacterium
32168428	32168428	PRJNA674048_P_NODE_30798_length_164_cov_0.904348_g30595_i0	PRJNA674048	30798	164	0.904348	1.48313072	Blastopirellula sp. J2-11	2943192	Bacteria	Bacteria	41.6	0.0335	NR	WP_262024013.1	2943192	g30595	i0	46.3	0.98780487804878	54	27	95.1	1	5	160	1288	1341	WP_262024013.1 hypothetical protein [Blastopirellula sp. J2-11]	diamond	162	41.6	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Blastopirellula	Blastopirellula sp. J2-11

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);;