metadata: contig_metadata: 30 rows where analysis = "diamond", bioproject = "PRJDB9741" and tax

30 rows where analysis = "diamond", bioproject = "PRJDB9741" 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
4809760	4809760	PRJDB9741_P_NODE_304_length_1585_cov_3.732422_g208_i0	PRJDB9741	304	1585	3.732422	59.1588887	Chthoniobacter sp.	2510640	Bacteria	Bacteria	844	2.88e-305	NR	MDR3405335.1	2510640	g208	i0	88.6	0.878233438485804	464	53	87.8	0	61	1452	1	464	MDR3405335.1 translation elongation factor EF1A family protein [Chthoniobacter sp.]	diamond	1392	844	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Spartobacteria	Chthoniobacterales	Chthoniobacteraceae	Chthoniobacter	Chthoniobacter sp.
22658748	22658748	PRJDB9741_P_NODE_10738_length_201_cov_1.914474_g10421_i0	PRJDB9741	10738	201	1.914474	3.84809274	Planctomycetota bacterium	2026780	Bacteria	Bacteria	109	4.59e-26	NR	MEY4831052.1	2026780	g10421	i0	88.9	8.17910447761194	54	6	80.6	0	200	39	385	438	MEY4831052.1 adenosylhomocysteinase [Planctomycetota bacterium]	diamond	1644	109	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
26773409	26773409	PRJDB9741_P_NODE_26181_length_168_cov_2.252101_g25864_i0	PRJDB9741	26181	168	2.252101	3.78352968	Planctomycetia	203683	Bacteria	Bacteria	97.8	5.5200000000000005e-22	NR	WP_074308323.1	1882752	g25864	i0	78.6	3	56	12	100	0	1	168	553	608	WP_074308323.1 hypothetical protein [Singulisphaera sp. GP187]	diamond	504	97.8	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae	Singulisphaera	Singulisphaera sp. GP187
27221947	27221947	PRJDB9741_P_NODE_20083_length_178_cov_1.193798_g19766_i0	PRJDB9741	20083	178	1.193798	2.12496044	Chthoniobacteraceae bacterium	2811408	Bacteria	Bacteria	62	2.42e-9	NR	HEV7404525.1	2811408	g19766	i0	55.2	0.97752808988764	58	26	97.8	0	176	3	586	643	HEV7404525.1 DUF1549 domain-containing protein [Chthoniobacteraceae bacterium]	diamond	174	62	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Spartobacteria	Chthoniobacterales	Chthoniobacteraceae		Chthoniobacteraceae bacterium
27790797	27790797	PRJDB9741_P_NODE_26904_length_167_cov_2.050847_g26587_i0	PRJDB9741	26904	167	2.050847	3.42491449	Verrucomicrobiaceae bacterium	2026800	Bacteria	Bacteria	51.6	9.9e-6	NR	MBK8092153.1	2026800	g26587	i0	87.1	0.55688622754491	31	4	55.7	0	75	167	630	660	MBK8092153.1 protein kinase [Verrucomicrobiaceae bacterium]	diamond	93	51.6	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae		Verrucomicrobiaceae bacterium
28390560	28390560	PRJDB9741_P_NODE_1926_length_548_cov_4.152305_g1621_i0	PRJDB9741	1926	548	4.152305	22.7546314	PVC group bacterium	2056642	Bacteria	Bacteria	51.6	5.03e-5	NR	MCP4648866.1	2056642	g1621	i0	43.2	0.481751824817518	88	50	48.2	0	264	1	1	88	MCP4648866.1 hypothetical protein [PVC group bacterium]	diamond	264	51.6	1	Bacteria	PVC group	Pseudomonadati						PVC group bacterium
28390565	28390565	PRJDB9741_P_NODE_38426_length_162_cov_0.902655_g38109_i0	PRJDB9741	38426	162	0.902655	1.4623011	Planctomycetaceae bacterium	2026779	Bacteria	Bacteria	41.6	0.0328	NR	MEO2037068.1	2026779	g38109	i0	38.9	1	54	32	100	1	1	162	255	307	MEO2037068.1 Gfo/Idh/MocA family oxidoreductase [Planctomycetaceae bacterium]	diamond	162	41.6	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		Planctomycetaceae bacterium
28542722	28542722	PRJDB9741_P_NODE_43307_length_151_cov_3.000000_g42990_i0	PRJDB9741	43307	151	3	4.53	Bacteria	2	Bacteria	Bacteria	73.6	1.38e-13	NR	MEO2089858.1	2052164	g42990	i0	83.7	12.6556291390728	49	8	97.4	0	149	3	321	369	MEO2089858.1 methyl-accepting chemotaxis protein [Gemmataceae bacterium]	diamond	1911	74.3	0.990578734858681	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		Gemmataceae bacterium
28832527	28832527	PRJDB9741_P_NODE_26888_length_167_cov_2.135593_g26571_i0	PRJDB9741	26888	167	2.135593	3.56644031	Chlamydia ibidis	1405396	Bacteria	Bacteria	45.8	5.95e-5	NR	EPP35138.1	1405396	g26571	i0	64.7	0.610778443113772	34	12	61.1	0	12	113	2	35	EPP35138.1 hypothetical protein CP10139811_1290, partial [Chlamydia ibidis]	diamond	102	45.8	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales	Chlamydiaceae	Chlamydia	Chlamydia ibidis
28864130	28864130	PRJDB9741_P_NODE_42428_length_154_cov_3.523810_g42111_i0	PRJDB9741	42428	154	3.52381	5.4266674	Opitutaceae bacterium	2006848	Bacteria	Bacteria	40.4	0.0342	NR	HEX3730387.1	2006848	g42111	i0	34.7	0.954545454545455	49	31	95.5	1	8	154	8	55	HEX3730387.1 hypothetical protein [Opitutaceae bacterium]	diamond	147	40.4	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae		Opitutaceae bacterium
28895636	28895636	PRJDB9741_P_NODE_40628_length_161_cov_0.910714_g40311_i0	PRJDB9741	40628	161	0.910714	1.46624954	Tepidisphaeraceae bacterium	2876886	Bacteria	Bacteria	103	4.579999999999999e-24	NR	MFT3788388.1	2876886	g40311	i0	90.6	0.987577639751553	53	5	98.8	0	161	3	119	171	MFT3788388.1 polyribonucleotide nucleotidyltransferase [Tepidisphaeraceae bacterium]	diamond	159	103	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Tepidisphaerales	Tepidisphaeraceae		Tepidisphaeraceae bacterium
28927319	28927319	PRJDB9741_P_NODE_16328_length_184_cov_1.637037_g16011_i0	PRJDB9741	16328	184	1.637037	3.01214808	Phycisphaerae bacterium	2026778	Bacteria	Bacteria	62.8	3.59e-10	NR	MCG3178245.1	2026778	g16011	i0	58.2	0.896739130434783	55	23	89.7	0	166	2	32	86	MCG3178245.1 hypothetical protein [Phycisphaerae bacterium]	diamond	165	62.8	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae				Phycisphaerae bacterium
28990782	28990782	PRJDB9741_P_NODE_32368_length_165_cov_0.879310_g32051_i0	PRJDB9741	32368	165	0.87931	1.4508615	Kiritimatiellia bacterium	2212473	Bacteria	Bacteria	62	2.12e-9	NR	MDY3228840.1	2212473	g32051	i0	64.8	0.981818181818182	54	17	98.2	1	4	165	334	385	MDY3228840.1 S8 family serine peptidase [Kiritimatiellia bacterium]	diamond	162	62	1	Bacteria	PVC group	Pseudomonadati	Kiritimatiellota	Kiritimatiellia				Kiritimatiellia bacterium
29053760	29053760	PRJDB9741_P_NODE_13848_length_189_cov_1.107143_g13531_i0	PRJDB9741	13848	189	1.107143	2.09250027	Opitutus sp.	1913982	Bacteria	Bacteria	43.9	0.00709	NR	MBA3849253.1	1913982	g13531	i0	40.7	2.73015873015873	59	35	93.7	0	179	3	325	383	MBA3849253.1 sugar tyrosine-protein kinase [Opitutus sp.]	diamond	516	43.9	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Opitutus	Opitutus sp.
29180127	29180127	PRJDB9741_P_NODE_19149_length_179_cov_2.007692_g18832_i0	PRJDB9741	19149	179	2.007692	3.59376868	Limnoglobus roseus	2598579	Bacteria	Bacteria	41.6	0.0418	NR	WP_168218902.1	2598579	g18832	i0	50	0.70391061452514	42	18	70.4	1	134	9	1111	1149	WP_168218902.1 FG-GAP-like repeat-containing protein [Limnoglobus roseus]	diamond	126	41.6	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Limnoglobus	Limnoglobus roseus
29211680	29211680	PRJDB9741_P_NODE_19169_length_179_cov_1.938462_g18852_i0	PRJDB9741	19169	179	1.938462	3.46984698	Gemmataceae bacterium	2052164	Bacteria	Bacteria	100	9.76e-23	NR	MFO0938084.1	2052164	g18852	i0	93.2	0.988826815642458	59	4	98.9	0	3	179	523	581	MFO0938084.1 hypothetical protein [Gemmataceae bacterium]	diamond	177	100	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		Gemmataceae bacterium
29274497	29274497	PRJDB9741_P_NODE_37429_length_162_cov_1.345133_g37112_i0	PRJDB9741	37429	162	1.345133	2.17911546	Rubripirellula sp.	1973111	Bacteria	Bacteria	58.2	4.4e-8	NR	MDE0862338.1	1973111	g37112	i0	60.9	0.851851851851852	46	17	83.3	1	137	3	407	452	MDE0862338.1 sulfatase [Rubripirellula sp.]	diamond	138	58.2	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Rubripirellula	Rubripirellula sp.
29527313	29527313	PRJDB9741_P_NODE_31630_length_165_cov_0.879310_g31313_i0	PRJDB9741	31630	165	0.87931	1.4508615	Pirellulales bacterium	2715253	Bacteria	Bacteria	98.2	1.98e-22	NR	MFO0897753.1	2715253	g31313	i0	85.2	0.981818181818182	54	8	98.2	0	164	3	359	412	MFO0897753.1 Ig-like domain-containing protein [Pirellulales bacterium]	diamond	162	98.2	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales			Pirellulales bacterium
29779821	29779821	PRJDB9741_P_NODE_14431_length_188_cov_1.100719_g14114_i0	PRJDB9741	14431	188	1.100719	2.06935172	Planctomycetota bacterium	2026780	Bacteria	Bacteria	110	1.23e-26	NR	MEQ1894885.1	2026780	g14114	i0	82.3	1.97872340425532	62	11	98.9	0	186	1	383	444	MEQ1894885.1 hypothetical protein [Planctomycetota bacterium]	diamond	372	110	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
30001093	30001093	PRJDB9741_P_NODE_28031_length_167_cov_0.864407_g27714_i0	PRJDB9741	28031	167	0.864407	1.44355969	Limnoglobus roseus	2598579	Bacteria	Bacteria	55.1	5.83e-7	NR	WP_149112082.1	2598579	g27714	i0	89.7	1.05988023952096	29	3	52.1	0	2	88	381	409	WP_149112082.1 TIGR00300 family protein [Limnoglobus roseus]	diamond	177	55.1	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Limnoglobus	Limnoglobus roseus
30317425	30317425	PRJDB9741_P_NODE_31592_length_165_cov_0.879310_g31275_i0	PRJDB9741	31592	165	0.87931	1.4508615	Pirellulales bacterium	2715253	Bacteria	Bacteria	57.4	8.55e-8	NR	HEY1064852.1	2715253	g31275	i0	53.7	0.981818181818182	54	25	98.2	0	164	3	221	274	HEY1064852.1 DUF4974 domain-containing protein [Pirellulales bacterium]	diamond	162	57.4	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales			Pirellulales bacterium
30506522	30506522	PRJDB9741_P_NODE_30553_length_166_cov_0.871795_g30236_i0	PRJDB9741	30553	166	0.871795	1.4471797	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	75.1	2.62e-14	NR	MEN9402104.1	2026799	g30236	i0	69.8	1.8433734939759	53	16	95.8	0	161	3	147	199	MEN9402104.1 hypothetical protein [Verrucomicrobiota bacterium]	diamond	306	75.1	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
31037937	31037937	PRJDB9741_P_NODE_9575_length_210_cov_2.608696_g9258_i0	PRJDB9741	9575	210	2.608696	5.4782616	Pseudomonadati	3379134	Bacteria	Bacteria	62.4	2.74e-10	NR	MFA7175497.1	2212473	g9258	i0	70.7	1.17142857142857	41	12	58.6	0	3	125	2	42	MFA7175497.1 DNA polymerase [Kiritimatiellia bacterium]	diamond	246	62.4	1	Bacteria	PVC group	Pseudomonadati	Kiritimatiellota	Kiritimatiellia				Kiritimatiellia bacterium
31169729	31169729	PRJDB9741_P_NODE_27595_length_167_cov_0.864407_g27278_i0	PRJDB9741	27595	167	0.864407	1.44355969	Opitutaceae bacterium	2006848	Bacteria	Bacteria	50.1	3.45e-5	NR	HUL54344.1	2006848	g27278	i0	70.4	0.48502994011976	27	8	48.5	0	85	165	8	34	HUL54344.1 phosphoenolpyruvate carboxykinase (GTP) [Opitutaceae bacterium]	diamond	81	50.1	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae		Opitutaceae bacterium
31675886	31675886	PRJDB9741_P_NODE_677_length_1076_cov_2.466407_g502_i0	PRJDB9741	677	1076	2.466407	26.53853932	PVC group bacterium	2056642	Bacteria	Bacteria	57	2.69e-6	NR	MCP4648866.1	2056642	g502	i0	36.9	0.287174721189591	103	65	28.7	0	497	189	1	103	MCP4648866.1 hypothetical protein [PVC group bacterium]	diamond	309	57	1	Bacteria	PVC group	Pseudomonadati						PVC group bacterium
31865567	31865567	PRJDB9741_P_NODE_28617_length_167_cov_0.864407_g28300_i0	PRJDB9741	28617	167	0.864407	1.44355969	Candidatus Velamenicoccus archaeovorus	1930593	Bacteria	Bacteria	44.7	0.00212	NR	MFB3738859.1	1930593	g28300	i0	55.3	0.844311377245509	47	20	82.6	1	139	2	4	50	MFB3738859.1 AmmeMemoRadiSam system protein B [Candidatus Velamenicoccus archaeovorus]	diamond	141	44.7	1	Bacteria	PVC group	Pseudomonadati	Candidatus Omnitrophota				Candidatus Velamenicoccus	Candidatus Velamenicoccus archaeovorus
32119056	32119056	PRJDB9741_P_NODE_19518_length_179_cov_1.176923_g19201_i0	PRJDB9741	19518	179	1.176923	2.10669217	Verrucomicrobiia bacterium	2499141	Bacteria	Bacteria	92.4	1.34e-20	NR	HUR41831.1	2499141	g19201	i0	78	4.94413407821229	59	13	98.9	0	1	177	214	272	HUR41831.1 malate dehydrogenase [Verrucomicrobiia bacterium]	diamond	885	92.4	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				Verrucomicrobiia bacterium
32150629	32150629	PRJDB9741_P_NODE_30618_length_166_cov_0.871795_g30301_i0	PRJDB9741	30618	166	0.871795	1.4471797	Sedimentisphaerales bacterium	2813034	Bacteria	Bacteria	42.4	0.0178	NR	MBN2210937.1	2813034	g30301	i0	47.4	2.58433734939759	38	20	68.7	0	116	3	625	662	MBN2210937.1 hypothetical protein [Sedimentisphaerales bacterium]	diamond	429	42.4	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Sedimentisphaerales			Sedimentisphaerales bacterium
32213926	32213926	PRJDB9741_P_NODE_25318_length_170_cov_1.247934_g25001_i0	PRJDB9741	25318	170	1.247934	2.1214878	Opitutaceae bacterium	2006848	Bacteria	Bacteria	87	3.41e-18	NR	MCE2862490.1	2006848	g25001	i0	69.8	2.82352941176471	53	16	93.5	0	6	164	242	294	MCE2862490.1 sialate O-acetylesterase [Opitutaceae bacterium]	diamond	480	87	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae		Opitutaceae bacterium
32467229	32467229	PRJDB9741_P_NODE_26179_length_168_cov_2.252101_g25862_i0	PRJDB9741	26179	168	2.252101	3.78352968	Planctomycetaceae bacterium	2026779	Bacteria	Bacteria	50.8	1.86e-5	NR	MDR0336275.1	2026779	g25862	i0	46.3	5.875	54	26	91.1	1	2	154	236	289	MDR0336275.1 family 78 glycoside hydrolase catalytic domain [Planctomycetaceae bacterium]	diamond	987	50.8	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);;