metadata: contig_metadata: 19 rows where analysis = "diamond", bioproject = "PRJNA293022" and tax

19 rows where analysis = "diamond", bioproject = "PRJNA293022" 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
1648215	1648215	PRJNA293022_P_NODE_73722_length_165_cov_0.896552_g72985_i0	PRJNA293022	73722	165	0.896552	1.4793108	Limisphaerales bacterium	2052186	Bacteria	Bacteria	119	1.36e-29	NR	KAF0175639.1	2052186	g72985	i0	96.3	1.96363636363636	54	2	98.2	0	3	164	340	393	KAF0175639.1 MAG: folate hydrolase-like protein [Limisphaerales bacterium]	diamond	324	119	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Limisphaerales			Limisphaerales bacterium
26631040	26631040	PRJNA293022_P_NODE_41841_length_216_cov_0.892216_g41104_i0	PRJNA293022	41841	216	0.892216	1.92718656	Luteolibacter pohnpeiensis	454153	Bacteria	Bacteria	42.4	0.0349	NR	WP_200270805.1	454153	g41104	i0	34.5	0.763888888888889	55	36	76.4	0	42	206	64	118	WP_200270805.1 hypothetical protein [Luteolibacter pohnpeiensis]	diamond	165	42.4	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter pohnpeiensis
26852947	26852947	PRJNA293022_P_NODE_78621_length_162_cov_1.398230_g77884_i0	PRJNA293022	78621	162	1.39823	2.2651326	Urbifossiella sp.	2807431	Bacteria	Bacteria	54.7	5.11e-7	NR	HEX4606642.1	2807431	g77884	i0	48	1.83333333333333	50	26	92.6	0	151	2	96	145	HEX4606642.1 TIGR02996 domain-containing protein [Urbifossiella sp.]	diamond	297	54.7	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Urbifossiella	Urbifossiella sp.
27186445	27186445	PRJNA293022_P_NODE_27222_length_270_cov_1.140271_g26485_i0	PRJNA293022	27222	270	1.140271	3.0787317	Bacteria	2	Bacteria	Bacteria	104	1.57e-25	NR	MDF2578416.1	2047757	g26485	i0	60.9	1.93333333333333	87	34	96.7	0	10	270	30	116	MDF2578416.1 integrase [Chlamydiales bacterium]	diamond	522	105	0.990476190476191	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales			Chlamydiales bacterium
27548090	27548090	PRJNA293022_P_NODE_75424_length_164_cov_0.904348_g74687_i0	PRJNA293022	75424	164	0.904348	1.48313072	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	76.3	1.94e-14	NR	MBI4658885.1	2026799	g74687	i0	71.2	0.951219512195122	52	11	95.1	1	5	160	715	762	MBI4658885.1 hypothetical protein [Verrucomicrobiota bacterium]	diamond	156	76.3	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
28197091	28197091	PRJNA293022_P_NODE_76006_length_164_cov_0.904348_g75269_i0	PRJNA293022	76006	164	0.904348	1.48313072	Pseudomonadati	3379134	Bacteria	Bacteria	92	3.05e-20	NR	TXT34745.1	2026780	g75269	i0	84.9	1.9390243902439	53	8	97	0	161	3	76	128	TXT34745.1 MAG: adenylate kinase [Planctomycetota bacterium]	diamond	318	92	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
28653275	28653275	PRJNA293022_P_NODE_62167_length_176_cov_1.606299_g61430_i0	PRJNA293022	62167	176	1.606299	2.82708624	Chthoniobacterales bacterium	2201154	Bacteria	Bacteria	41.2	0.0344	NR	MFL6553260.1	2201154	g61430	i0	52.5	0.681818181818182	40	16	66.5	2	18	134	121	158	MFL6553260.1 hypothetical protein [Chthoniobacterales bacterium]	diamond	120	41.2	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Spartobacteria	Chthoniobacterales			Chthoniobacterales bacterium
28810735	28810735	PRJNA293022_P_NODE_30348_length_255_cov_1.000000_g29611_i0	PRJNA293022	30348	255	1	2.55	Pirellulales bacterium	2715253	Bacteria	Bacteria	58.2	1.61e-7	NR	MCH2116316.1	2715253	g29611	i0	33.8	0.835294117647059	71	47	83.5	0	3	215	260	330	MCH2116316.1 trypsin-like serine protease [Pirellulales bacterium]	diamond	213	58.2	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales			Pirellulales bacterium
28986851	28986851	PRJNA293022_P_NODE_67568_length_169_cov_0.866667_g66831_i0	PRJNA293022	67568	169	0.866667	1.46466723	Pseudomonadati	3379134	Bacteria	Bacteria	71.6	1.37e-13	NR	MBN1511991.1	2026778	g66831	i0	58.8	1.86390532544379	51	21	90.5	0	162	10	61	111	MBN1511991.1 peroxiredoxin [Phycisphaerae bacterium]	diamond	315	71.6	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae				Phycisphaerae bacterium
29190135	29190135	PRJNA293022_P_NODE_69289_length_168_cov_0.873950_g68552_i0	PRJNA293022	69289	168	0.87395	1.468236	Verrucomicrobiia bacterium	2499141	Bacteria	Bacteria	62	2.16e-10	NR	HEV2319410.1	2499141	g68552	i0	61.1	0.964285714285714	54	20	94.6	1	160	2	1	54	HEV2319410.1 hypothetical protein [Verrucomicrobiia bacterium]	diamond	162	62	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				Verrucomicrobiia bacterium
29252895	29252895	PRJNA293022_P_NODE_49489_length_198_cov_1.536913_g48752_i0	PRJNA293022	49489	198	1.536913	3.04308774	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	43.9	0.00815	NR	MEY4199220.1	2026799	g48752	i0	43.1	0.772727272727273	51	23	77.3	2	16	168	248	292	MEY4199220.1 nuclease superfamily [Verrucomicrobiota bacterium]	diamond	153	43.9	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
29333904	29333904	PRJNA293022_P_NODE_79089_length_162_cov_0.920354_g78352_i0	PRJNA293022	79089	162	0.920354	1.49097348	Pseudomonadati	3379134	Bacteria	Bacteria	52.8	3.54e-6	NR	HCO21516.1	122	g78352	i0	51.1	5.46296296296296	47	23	87	0	153	13	145	191	HCO21516.1 hypothetical protein [Gimesia maris]	diamond	885	52.8	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Gimesia	Gimesia maris
29568810	29568810	PRJNA293022_P_NODE_73310_length_165_cov_1.775862_g72573_i0	PRJNA293022	73310	165	1.775862	2.9301723	Phycisphaerae bacterium SM23_33	1703412	Bacteria	Bacteria	44.3	0.00363	NR	KPK79959.1	1703412	g72573	i0	43.5	1.8	46	21	83.6	1	163	26	238	278	KPK79959.1 MAG: hypothetical protein AMJ81_12595 [Phycisphaerae bacterium SM23_33]	diamond	297	44.3	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae				Phycisphaerae bacterium SM23_33
29694842	29694842	PRJNA293022_P_NODE_49170_length_199_cov_1.020000_g48433_i0	PRJNA293022	49170	199	1.02	2.0298	Planctomycetota bacterium	2026780	Bacteria	Bacteria	42.4	0.0139	NR	MEY2806385.1	2026780	g48433	i0	43.1	0.768844221105528	51	26	72.4	2	151	8	53	103	MEY2806385.1 hypothetical protein [Planctomycetota bacterium]	diamond	153	42.4	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
30011151	30011151	PRJNA293022_P_NODE_69031_length_168_cov_0.873950_g68294_i0	PRJNA293022	69031	168	0.87395	1.468236	Limisphaerales bacterium	2052186	Bacteria	Bacteria	110	1.85e-26	NR	TXT50969.1	2052186	g68294	i0	98.2	0.982142857142857	55	1	98.2	0	3	167	2327	2381	TXT50969.1 MAG: hypothetical protein FD140_2031 [Limisphaerales bacterium]	diamond	165	110	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Limisphaerales			Limisphaerales bacterium
30863991	30863991	PRJNA293022_P_NODE_68834_length_168_cov_1.008403_g68097_i0	PRJNA293022	68834	168	1.008403	1.69411704	Candidatus Udaeobacter sp.	2665650	Bacteria	Bacteria	41.2	0.0462	NR	HYY24259.1	2665650	g68097	i0	38.3	0.839285714285714	47	28	83.9	1	152	12	136	181	HYY24259.1 alpha/beta hydrolase [Candidatus Udaeobacter sp.]	diamond	141	41.2	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Spartobacteria	Chthoniobacterales	Chthoniobacteraceae	Candidatus Udaeobacter	Candidatus Udaeobacter sp.
30863993	30863993	PRJNA293022_P_NODE_75594_length_164_cov_0.904348_g74857_i0	PRJNA293022	75594	164	0.904348	1.48313072	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	97.8	4.500000000000001e-22	NR	MEI6358247.1	2026799	g74857	i0	86.8	1.9390243902439	53	7	97	0	162	4	262	314	MEI6358247.1 NPCBM/NEW2 domain-containing protein [Verrucomicrobiota bacterium]	diamond	318	97.8	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
32572160	32572160	PRJNA293022_P_NODE_68059_length_169_cov_0.866667_g67322_i0	PRJNA293022	68059	169	0.866667	1.46466723	Opitutaceae bacterium	2006848	Bacteria	Bacteria	68.9	8e-12	NR	MBL9207199.1	2006848	g67322	i0	71.2	2.84023668639053	52	15	92.3	0	168	13	140	191	MBL9207199.1 hypothetical protein [Opitutaceae bacterium]	diamond	480	68.9	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae		Opitutaceae bacterium
32823864	32823864	PRJNA293022_P_NODE_9760_length_458_cov_8.687042_g9027_i0	PRJNA293022	9760	458	8.687042	39.78665236	Planctomycetaceae bacterium	2026779	Bacteria	Bacteria	45.4	0.0236	NR	MCP4478562.1	2026779	g9027	i0	52.8	0.53056768558952	36	17	23.6	0	304	411	142	177	MCP4478562.1 hypothetical protein [Planctomycetaceae bacterium]	diamond	243	45.4	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		Planctomycetaceae 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);;