metadata: contig_metadata: 18 rows where analysis = "diamond", bioproject = "PRJEB80557" and tax

18 rows where analysis = "diamond", bioproject = "PRJEB80557" 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
11199754	11199754	PRJEB80557_S_NODE_17449_length_226_cov_1.457627_g17053_i0	PRJEB80557	17449	226	1.457627	3.29423702	Tepidisphaeraceae bacterium	2876886	Bacteria	Bacteria	90.1	1.78e-19	NR	HQY87905.1	2876886	g17053	i0	64.4	0.783185840707965	59	21	78.3	0	1	177	221	279	HQY87905.1 phosphatidate cytidylyltransferase [Tepidisphaeraceae bacterium]	diamond	177	90.1	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Tepidisphaerales	Tepidisphaeraceae		Tepidisphaeraceae bacterium
15441564	15441564	PRJEB80557_S_NODE_24533_length_194_cov_1.068966_g24137_i0	PRJEB80557	24533	194	1.068966	2.07379404	Pirellulaceae bacterium	2699754	Bacteria	Bacteria	125	8.429999999999998e-32	NR	HEV7281210.1	2699754	g24137	i0	95.3	0.989690721649485	64	3	99	0	3	194	327	390	HEV7281210.1 ribulose-phosphate 3-epimerase [Pirellulaceae bacterium]	diamond	192	125	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae		Pirellulaceae bacterium
23091212	23091212	PRJEB80557_S_NODE_6359_length_349_cov_1.763333_g5963_i0	PRJEB80557	6359	349	1.763333	6.15403217	PVC group	1783257	Bacteria	Bacteria	85.1	1.65e-17	NR	MDR1190930.1	2026801	g5963	i0	50.5	3.30945558739255	95	47	81.7	0	11	295	28	122	MDR1190930.1 response regulator [Verrucomicrobiales bacterium]	diamond	1155	85.9	0.990686845168801	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales			Verrucomicrobiales bacterium
26590774	26590774	PRJEB80557_S_NODE_26341_length_188_cov_1.417266_g25945_i0	PRJEB80557	26341	188	1.417266	2.66446008	Phycisphaeraceae bacterium	2026777	Bacteria	Bacteria	42	0.0341	NR	MCC7406532.1	2026777	g25945	i0	44.6	0.893617021276596	56	29	87.8	2	21	185	262	316	MCC7406532.1 hypothetical protein [Phycisphaeraceae bacterium]	diamond	168	42	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales	Phycisphaeraceae		Phycisphaeraceae bacterium
27508398	27508398	PRJEB80557_S_NODE_25943_length_189_cov_1.835714_g25547_i0	PRJEB80557	25943	189	1.835714	3.46949946	Gimesia alba	2527973	Bacteria	Bacteria	47.4	4.37e-4	NR	WP_145218180.1	2527973	g25547	i0	37.3	0.936507936507937	59	36	92.1	1	13	186	456	514	WP_145218180.1 type IV secretory system conjugative DNA transfer family protein [Gimesia alba]	diamond	177	47.4	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Gimesia	Gimesia alba
27571359	27571359	PRJEB80557_S_NODE_18564_length_220_cov_0.912281_g18168_i0	PRJEB80557	18564	220	0.912281	2.0070182	Isosphaeraceae bacterium	2691532	Bacteria	Bacteria	94.4	3.2200000000000003e-21	NR	HKM56288.1	2691532	g18168	i0	58.3	4.90909090909091	72	30	98.2	0	217	2	37	108	HKM56288.1 hypothetical protein [Isosphaeraceae bacterium]	diamond	1080	94.4	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae		Isosphaeraceae bacterium
27761139	27761139	PRJEB80557_S_NODE_26924_length_186_cov_1.335766_g26528_i0	PRJEB80557	26924	186	1.335766	2.48452476	Planctomycetia bacterium	2052181	Bacteria	Bacteria	42.4	0.00925	NR	NHZ84603.1	2052181	g26528	i0	60.7	0.451612903225806	28	11	45.2	0	181	98	53	80	NHZ84603.1 hypothetical protein [Planctomycetia bacterium]	diamond	84	42.4	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia				Planctomycetia bacterium
27887041	27887041	PRJEB80557_S_NODE_10285_length_285_cov_2.309322_g9889_i0	PRJEB80557	10285	285	2.309322	6.5815677	Planctomycetaceae bacterium	2026779	Bacteria	Bacteria	128	2.89e-33	NR	MCA8983503.1	2026779	g9889	i0	92.8	2.17894736842105	69	5	72.6	0	23	229	178	246	MCA8983503.1 hypothetical protein [Planctomycetaceae bacterium]	diamond	621	128	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		Planctomycetaceae bacterium
28139970	28139970	PRJEB80557_S_NODE_29065_length_179_cov_2.176923_g28669_i0	PRJEB80557	29065	179	2.176923	3.89669217	Akkermansia sp.	1872421	Bacteria	Bacteria	93.2	2.35e-20	NR	WP_290549583.1	1872421	g28669	i0	70.7	2.91620111731844	58	17	97.2	0	178	5	336	393	WP_290549583.1 hypothetical protein [Akkermansia sp.]	diamond	522	93.2	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Akkermansiaceae	Akkermansia	Akkermansia sp.
28606036	28606036	PRJEB80557_S_NODE_17987_length_223_cov_1.091954_g17591_i0	PRJEB80557	17987	223	1.091954	2.43505742	Pseudomonadati	3379134	Bacteria	Bacteria	52.4	1.08e-5	NR	OGV65628.1	1798582	g17591	i0	81.3	3.44394618834081	32	6	43	0	212	117	335	366	OGV65628.1 MAG: sugar kinase [Lentisphaerae bacterium RIFOXYC12_FULL_60_16]	diamond	768	52.4	1	Bacteria	PVC group	Pseudomonadati	Lentisphaerota					Lentisphaerae bacterium RIFOXYC12_FULL_60_16
30128726	30128726	PRJEB80557_S_NODE_4012_length_418_cov_1.685637_g3616_i0	PRJEB80557	4012	418	1.685637	7.04596266	Planctomycetaceae bacterium	2026779	Bacteria	Bacteria	108	1.79e-25	NR	MFO1094496.1	2026779	g3616	i0	64	0.638755980861244	89	32	63.9	0	18	284	207	295	MFO1094496.1 hypothetical protein [Planctomycetaceae bacterium]	diamond	267	108	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		Planctomycetaceae bacterium
30128727	30128727	PRJEB80557_S_NODE_5092_length_382_cov_2.021021_g4696_i0	PRJEB80557	5092	382	2.021021	7.72030022	Verrucomicrobiia bacterium	2499141	Bacteria	Bacteria	42.7	0.0487	NR	HXT83015.1	2499141	g4696	i0	46.7	0.353403141361257	45	23	35.3	1	39	173	10	53	HXT83015.1 hypothetical protein [Verrucomicrobiia bacterium]	diamond	135	42.7	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				Verrucomicrobiia bacterium
30248368	30248368	PRJEB80557_S_NODE_14772_length_243_cov_3.376289_g14376_i0	PRJEB80557	14772	243	3.376289	8.20438227	Simkania	34093	Bacteria	Bacteria	86.7	1.34e-17	NR	MBS3905301.1	34094	g14376	i0	53.1	2	81	36	98.8	2	4	243	643	722	MBS3905301.1 hypothetical protein [Simkania sp.]	diamond	486	86.7	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Simkaniaceae	Simkania	Simkania sp.
30413687	30413687	PRJEB80557_S_NODE_3613_length_435_cov_2.095855_g3217_i0	PRJEB80557	3613	435	2.095855	9.11696925	Candidatus Omnitrophota bacterium	2035772	Bacteria	Bacteria	65.9	1.06e-9	NR	MFC1632301.1	2035772	g3217	i0	32.7	2.09655172413793	156	85	96.6	7	3	422	62	213	MFC1632301.1 LamG domain-containing protein [Candidatus Omnitrophota bacterium]	diamond	912	65.9	1	Bacteria	PVC group	Pseudomonadati	Candidatus Omnitrophota					Candidatus Omnitrophota bacterium
31013679	31013679	PRJEB80557_S_NODE_15255_length_240_cov_1.319372_g14859_i0	PRJEB80557	15255	240	1.319372	3.1664928	Phycisphaerales bacterium	2052180	Bacteria	Bacteria	89	8.87e-19	NR	HYF15161.1	2052180	g14859	i0	59.5	0.9875	79	32	98.8	0	238	2	269	347	HYF15161.1 M20/M25/M40 family metallo-hydrolase [Phycisphaerales bacterium]	diamond	237	89	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			Phycisphaerales bacterium
31361576	31361576	PRJEB80557_S_NODE_14176_length_248_cov_1.557789_g13780_i0	PRJEB80557	14176	248	1.557789	3.86331672	Pirellulaceae bacterium	2699754	Bacteria	Bacteria	136	1.48e-35	NR	HEV7281210.1	2699754	g13780	i0	87.5	0.967741935483871	80	10	96.8	0	9	248	255	334	HEV7281210.1 ribulose-phosphate 3-epimerase [Pirellulaceae bacterium]	diamond	240	136	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae		Pirellulaceae bacterium
31519737	31519737	PRJEB80557_S_NODE_20676_length_209_cov_1.581250_g20280_i0	PRJEB80557	20676	209	1.58125	3.3048125	Planctomycetota bacterium	2026780	Bacteria	Bacteria	43.9	0.0095	NR	MCE9555703.1	2026780	g20280	i0	85.7	0.301435406698565	21	3	30.1	0	186	124	955	975	MCE9555703.1 N-6 DNA methylase [Planctomycetota bacterium]	diamond	63	43.9	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
32215644	32215644	PRJEB80557_S_NODE_4098_length_414_cov_2.413699_g3702_i0	PRJEB80557	4098	414	2.413699	9.99271386	Chlamydiota bacterium	2081524	Bacteria	Bacteria	84	3.67e-16	NR	MES2198641.1	2081524	g3702	i0	78.6	0.405797101449275	56	12	40.6	0	413	246	256	311	MES2198641.1 metal ABC transporter permease [Chlamydiota bacterium]	diamond	168	84	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota					Chlamydiota 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);;