metadata: contig_metadata: 28 rows where analysis = "diamond", bioproject = "PRJNA1159911" and tax

28 rows where analysis = "diamond", bioproject = "PRJNA1159911" and tax_phylum = "Planctomycetota"

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
1581830	1581830	PRJNA1159911_P_NODE_101182_length_241_cov_0.916667_g100640_i0	PRJNA1159911	101182	241	0.916667	2.20916747	Pirellulales bacterium	2715253	Bacteria	Bacteria	131	1.04e-35	NR	HEY1601773.1	2715253	g100640	i0	83.8	1.99170124481328	80	13	99.6	0	2	241	70	149	HEY1601773.1 ABC-2 family transporter protein [Pirellulales bacterium]	diamond	480	131	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales			Pirellulales bacterium
12516595	12516595	PRJNA1159911_P_NODE_100030_length_242_cov_0.911243_g99488_i0	PRJNA1159911	100030	242	0.911243	2.20520806	Bacteria	2	Bacteria	Bacteria	105	2.22e-24	NR	MFM9995341.1	2052180	g99488	i0	74	2.88842975206612	77	20	95.5	0	2	232	108	184	MFM9995341.1 tRNA modification GTPase [Phycisphaerales bacterium]	diamond	699	105	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			Phycisphaerales bacterium
14336424	14336424	PRJNA1159911_P_NODE_27092_length_527_cov_1.969163_g26552_i0	PRJNA1159911	27092	527	1.969163	10.37748901	Planctomycetota bacterium	2026780	Bacteria	Bacteria	186	2.3e-51	NR	MEK6704019.1	2026780	g26552	i0	67.9	10.2352941176471	137	36	78	2	3	413	716	844	MEK6704019.1 pyruvate, phosphate dikinase [Planctomycetota bacterium]	diamond	5394	186	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
21985678	21985678	PRJNA1159911_P_NODE_99718_length_242_cov_0.911243_g99176_i0	PRJNA1159911	99718	242	0.911243	2.20520806	Phycisphaerales bacterium	2052180	Bacteria	Bacteria	131	1.42e-36	NR	MFN0011101.1	2052180	g99176	i0	76.9	0.966942148760331	78	18	96.7	0	8	241	19	96	MFN0011101.1 2-C-methyl-D-erythritol 2,4-cyclodiphosphate synthase [Phycisphaerales bacterium]	diamond	234	131	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			Phycisphaerales bacterium
24534732	24534732	PRJNA1159911_P_NODE_89980_length_249_cov_0.875000_g89438_i0	PRJNA1159911	89980	249	0.875	2.17875	Bacteria	2	Bacteria	Bacteria	119	4.47e-29	NR	MEA1951780.1	2026780	g89438	i0	69.5	5.87951807228916	82	25	98.8	0	3	248	361	442	MEA1951780.1 ATP-binding protein [Planctomycetota bacterium]	diamond	1464	120	0.991666666666667	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
26692115	26692115	PRJNA1159911_P_NODE_92881_length_247_cov_0.885057_g92339_i0	PRJNA1159911	92881	247	0.885057	2.18609079	Pirellulaceae bacterium	2699754	Bacteria	Bacteria	104	5.1800000000000005e-27	NR	MDX1948638.1	2699754	g92339	i0	62.2	0.995951417004049	82	31	99.6	0	247	2	24	105	MDX1948638.1 STAS domain-containing protein [Pirellulaceae bacterium]	diamond	246	104	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae		Pirellulaceae bacterium
26755245	26755245	PRJNA1159911_P_NODE_95501_length_245_cov_0.895349_g94959_i0	PRJNA1159911	95501	245	0.895349	2.19360505	Planctomycetota bacterium	2026780	Bacteria	Bacteria	141	6.37e-38	NR	MBI5762914.1	2026780	g94959	i0	98.8	0.991836734693878	81	1	99.2	0	3	245	73	153	MBI5762914.1 efflux RND transporter periplasmic adaptor subunit [Planctomycetota bacterium]	diamond	243	141	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
27324910	27324910	PRJNA1159911_P_NODE_70243_length_283_cov_1.390476_g69701_i0	PRJNA1159911	70243	283	1.390476	3.93504708	Planctomycetota bacterium	2026780	Bacteria	Bacteria	174	3.18e-51	NR	MBI5765247.1	2026780	g69701	i0	93.6	0.996466431095406	94	6	99.6	0	283	2	124	217	MBI5765247.1 hypothetical protein [Planctomycetota bacterium]	diamond	282	174	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
27767172	27767172	PRJNA1159911_P_NODE_92744_length_247_cov_0.885057_g92202_i0	PRJNA1159911	92744	247	0.885057	2.18609079	Planctomycetota bacterium	2026780	Bacteria	Bacteria	80.5	1.14e-15	NR	MBI5765379.1	2026780	g92202	i0	90.1	0.983805668016194	81	8	98.4	0	245	3	156	236	MBI5765379.1 hypothetical protein [Planctomycetota bacterium]	diamond	243	80.5	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
28051112	28051112	PRJNA1159911_P_NODE_98625_length_243_cov_0.905882_g98083_i0	PRJNA1159911	98625	243	0.905882	2.20129326	Pirellulaceae bacterium	2699754	Bacteria	Bacteria	152	7.659999999999998e-41	NR	HTN76971.1	2699754	g98083	i0	85	0.987654320987654	80	12	98.8	0	3	242	185	264	HTN76971.1 HEAT repeat domain-containing protein [Pirellulaceae bacterium]	diamond	240	152	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae		Pirellulaceae bacterium
28417954	28417954	PRJNA1159911_P_NODE_99926_length_242_cov_0.911243_g99384_i0	PRJNA1159911	99926	242	0.911243	2.20520806	Pseudomonadati	3379134	Bacteria	Bacteria	104	7.14e-25	NR	WP_202973945.1	1908690	g99384	i0	62.8	2.05785123966942	78	29	96.7	0	242	9	115	192	WP_202973945.1 LysR family transcriptional regulator [Fimbriiglobus ruber]	diamond	498	104	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Fimbriiglobus	Fimbriiglobus ruber
28588062	28588062	PRJNA1159911_P_NODE_87087_length_251_cov_0.865169_g86545_i0	PRJNA1159911	87087	251	0.865169	2.17157419	Phycisphaerales bacterium	2052180	Bacteria	Bacteria	72.4	1.43e-12	NR	MFN0012498.1	2052180	g86545	i0	74.1	0.693227091633466	58	9	69.3	1	17	190	446	497	MFN0012498.1 hypothetical protein [Phycisphaerales bacterium]	diamond	174	72.4	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			Phycisphaerales bacterium
28619645	28619645	PRJNA1159911_P_NODE_89767_length_249_cov_0.875000_g89225_i0	PRJNA1159911	89767	249	0.875	2.17875	Planctomycetota bacterium	2026780	Bacteria	Bacteria	165	4.05e-45	NR	MBI5764481.1	2026780	g89225	i0	98.8	0.987951807228916	82	1	98.8	0	247	2	55	136	MBI5764481.1 PQQ-binding-like beta-propeller repeat protein [Planctomycetota bacterium]	diamond	246	165	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
29314089	29314089	PRJNA1159911_P_NODE_80349_length_262_cov_1.560847_g79807_i0	PRJNA1159911	80349	262	1.560847	4.08941914	Pirellulaceae bacterium	2699754	Bacteria	Bacteria	174	1.9e-49	NR	MCU0878749.1	2699754	g79807	i0	91.9	7.83206106870229	86	7	98.5	0	3	260	39	124	MCU0878749.1 sulfatase [Pirellulaceae bacterium]	diamond	2052	174	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae		Pirellulaceae bacterium
29459379	29459379	PRJNA1159911_P_NODE_87310_length_251_cov_0.865169_g86768_i0	PRJNA1159911	87310	251	0.865169	2.17157419	Bacteria	2	Bacteria	Bacteria	111	2.38e-26	NR	HMF10999.1	2052164	g86768	i0	65.9	6.02390438247012	82	28	98	0	249	4	431	512	HMF10999.1 DUF1592 domain-containing protein [Gemmataceae bacterium]	diamond	1512	112	0.991071428571429	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		Gemmataceae bacterium
29503388	29503388	PRJNA1159911_P_NODE_98690_length_243_cov_0.864706_g98148_i0	PRJNA1159911	98690	243	0.864706	2.10123558	Anatilimnocola aggregata	2528021	Bacteria	Bacteria	66.6	1.29e-10	NR	WP_202921841.1	2528021	g98148	i0	78.4	0.45679012345679	37	8	45.7	0	1	111	331	367	WP_202921841.1 sulfotransferase family protein [Anatilimnocola aggregata]	diamond	111	66.6	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Anatilimnocola	Anatilimnocola aggregata
29629447	29629447	PRJNA1159911_P_NODE_86030_length_252_cov_1.664804_g85488_i0	PRJNA1159911	86030	252	1.664804	4.19530608	Phycisphaerales bacterium	2052180	Bacteria	Bacteria	82.8	1.43e-16	NR	MDB5324978.1	2052180	g85488	i0	65.4	3.72619047619048	52	18	61.9	0	95	250	218	269	MDB5324978.1 class SAM-dependent methyltransferase [Phycisphaerales bacterium]	diamond	939	82.8	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			Phycisphaerales bacterium
29711920	29711920	PRJNA1159911_P_NODE_13550_length_852_cov_3.657253_g13089_i0	PRJNA1159911	13550	852	3.657253	31.15979556	Pseudomonadati	3379134	Bacteria	Bacteria	163	4.97e-46	NR	MBL8800382.1	2026780	g13089	i0	46.1	3.85915492957746	180	95	63.4	2	751	212	1	178	MBL8800382.1 hypothetical protein [Planctomycetota bacterium]	diamond	3288	163	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
30608994	30608994	PRJNA1159911_P_NODE_73933_length_275_cov_1.143564_g73391_i0	PRJNA1159911	73933	275	1.143564	3.144801	Planctomycetota bacterium	2026780	Bacteria	Bacteria	193	1.4099999999999998e-56	NR	MBI5765377.1	2026780	g73391	i0	100	0.992727272727273	91	0	99.3	0	3	275	135	225	MBI5765377.1 hypothetical protein [Planctomycetota bacterium]	diamond	273	193	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
30735440	30735440	PRJNA1159911_P_NODE_90154_length_249_cov_0.875000_g89612_i0	PRJNA1159911	90154	249	0.875	2.17875	Pirellulales bacterium	2715253	Bacteria	Bacteria	64.7	7.41e-10	NR	HEV2970683.1	2715253	g89612	i0	48.8	1.97590361445783	82	37	98.8	2	247	2	1259	1335	HEV2970683.1 CHAT domain-containing tetratricopeptide repeat protein [Pirellulales bacterium]	diamond	492	64.7	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales			Pirellulales bacterium
30830231	30830231	PRJNA1159911_P_NODE_73874_length_275_cov_1.292079_g73332_i0	PRJNA1159911	73874	275	1.292079	3.55321725	Planctomycetota bacterium	2026780	Bacteria	Bacteria	46.2	0.00313	NR	MEM1422499.1	2026780	g73332	i0	47.5	0.665454545454545	61	29	66.5	2	56	238	286	343	MEM1422499.1 hypothetical protein [Planctomycetota bacterium]	diamond	183	46.2	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
31114416	31114416	PRJNA1159911_P_NODE_92855_length_247_cov_0.885057_g92313_i0	PRJNA1159911	92855	247	0.885057	2.18609079	Planctomycetota bacterium	2026780	Bacteria	Bacteria	159	1.5499999999999996e-43	NR	MBI5765358.1	2026780	g92313	i0	100	0.995951417004049	82	0	99.6	0	247	2	506	587	MBI5765358.1 DNA mismatch repair endonuclease MutL [Planctomycetota bacterium]	diamond	246	159	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
31494231	31494231	PRJNA1159911_P_NODE_94776_length_245_cov_1.575581_g94234_i0	PRJNA1159911	94776	245	1.575581	3.86017345	Planctomycetota bacterium	2026780	Bacteria	Bacteria	128	3e-35	NR	MBI5762274.1	2026780	g94234	i0	100	0.808163265306122	66	0	80.8	0	198	1	1	66	MBI5762274.1 50S ribosomal protein L15 [Planctomycetota bacterium]	diamond	198	128	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
31747044	31747044	PRJNA1159911_P_NODE_75237_length_272_cov_1.547739_g74695_i0	PRJNA1159911	75237	272	1.547739	4.20985008	Planctomycetota bacterium	2026780	Bacteria	Bacteria	184	6.5199999999999996e-52	NR	MBI5763418.1	2026780	g74695	i0	95.6	0.992647058823529	90	4	99.3	0	3	272	176	265	MBI5763418.1 hypothetical protein [Planctomycetota bacterium]	diamond	270	184	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
32095118	32095118	PRJNA1159911_P_NODE_87578_length_251_cov_0.865169_g87036_i0	PRJNA1159911	87578	251	0.865169	2.17157419	Phycisphaerae bacterium	2026778	Bacteria	Bacteria	125	2.4499999999999997e-31	NR	HEY3243823.1	2026778	g87036	i0	76.1	0.800796812749004	67	16	80.1	0	241	41	352	418	HEY3243823.1 hypothetical protein [Phycisphaerae bacterium]	diamond	201	125	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae				Phycisphaerae bacterium
32316950	32316950	PRJNA1159911_P_NODE_91679_length_248_cov_0.880000_g91137_i0	PRJNA1159911	91679	248	0.88	2.1824	Planctomycetales bacterium	2053591	Bacteria	Bacteria	105	2.1599999999999998e-24	NR	MCG2682228.1	2053591	g91137	i0	66.7	0.979838709677419	81	27	98	0	5	247	241	321	MCG2682228.1 ISNCY family transposase [Planctomycetales bacterium]	diamond	243	105	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales			Planctomycetales bacterium
32632460	32632460	PRJNA1159911_P_NODE_89700_length_249_cov_0.875000_g89158_i0	PRJNA1159911	89700	249	0.875	2.17875	Planctomycetota bacterium	2026780	Bacteria	Bacteria	176	1.2099999999999997e-54	NR	MBI5764041.1	2026780	g89158	i0	98.8	0.987951807228916	82	1	98.8	0	3	248	73	154	MBI5764041.1 hypothetical protein [Planctomycetota bacterium]	diamond	246	176	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
32727219	32727219	PRJNA1159911_P_NODE_72020_length_279_cov_1.325243_g71478_i0	PRJNA1159911	72020	279	1.325243	3.69742797	Planctomycetota bacterium	2026780	Bacteria	Bacteria	192	3.7e-55	NR	MBI5765262.1	2026780	g71478	i0	100	0.989247311827957	92	0	98.9	0	2	277	394	485	MBI5765262.1 primosomal protein N' [Planctomycetota bacterium]	diamond	276	192	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota 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);;