metadata: contig_metadata: 22 rows where analysis = "diamond", bioproject = "PRJNA1013345" and tax

22 rows where analysis = "diamond", bioproject = "PRJNA1013345" 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
3984886	3984886	PRJNA1013345_P_NODE_27844_length_161_cov_0.894737_g27714_i0	PRJNA1013345	27844	161	0.894737	1.44052657	Lacipirellula limnantheis	2528024	Bacteria	Bacteria	53.5	1.1e-6	NR	QDT75061.1	2528024	g27714	i0	69.7	0.614906832298137	33	9	61.5	1	99	1	22	53	QDT75061.1 hypothetical protein I41_42700 [Lacipirellula limnantheis]	diamond	99	53.5	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Lacipirellulaceae	Lacipirellula	Lacipirellula limnantheis
7810920	7810920	PRJNA1013345_P_NODE_25787_length_163_cov_0.879310_g25657_i0	PRJNA1013345	25787	163	0.87931	1.4332753	Planctomycetota bacterium	2026780	Bacteria	Bacteria	97.8	3.22e-23	NR	MCH2373162.1	2026780	g25657	i0	86.8	0.975460122699387	53	7	97.5	0	3	161	43	95	MCH2373162.1 aldolase/citrate lyase family protein [Planctomycetota bacterium]	diamond	159	97.8	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
9085929	9085929	PRJNA1013345_P_NODE_27848_length_161_cov_0.894737_g27718_i0	PRJNA1013345	27848	161	0.894737	1.44052657	Planctomycetaceae bacterium	2026779	Bacteria	Bacteria	100	7.52e-23	NR	MBX3437542.1	2026779	g27718	i0	88.5	0.968944099378882	52	6	96.9	0	159	4	146	197	MBX3437542.1 preprotein translocase subunit SecA [Planctomycetaceae bacterium]	diamond	156	100	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		Planctomycetaceae bacterium
15030260	15030260	PRJNA1013345_P_NODE_26372_length_162_cov_0.886957_g26242_i0	PRJNA1013345	26372	162	0.886957	1.43687034	Tepidisphaeraceae bacterium	2876886	Bacteria	Bacteria	110	2.65e-28	NR	HZN69188.1	2876886	g26242	i0	94.3	0.981481481481482	53	3	98.1	0	160	2	57	109	HZN69188.1 6-phosphogluconolactonase [Tepidisphaeraceae bacterium]	diamond	159	110	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Tepidisphaerales	Tepidisphaeraceae		Tepidisphaeraceae bacterium
15460762	15460762	PRJNA1013345_P_NODE_12953_length_187_cov_3.064286_g12823_i0	PRJNA1013345	12953	187	3.064286	5.73021482	Paludisphaera borealis	1387353	Bacteria	Bacteria	114	6.8699999999999996e-31	NR	WP_076348924.1	1387353	g12823	i0	80.6	1.98930481283422	62	12	99.5	0	187	2	59	120	WP_076348924.1 NIPSNAP family protein [Paludisphaera borealis]	diamond	372	114	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae	Paludisphaera	Paludisphaera borealis
15461077	15461077	PRJNA1013345_P_NODE_31133_length_158_cov_0.918919_g31003_i0	PRJNA1013345	31133	158	0.918919	1.45189202	Verrucomicrobiales bacterium	2026801	Bacteria	Bacteria	97.4	6.38e-22	NR	MDB6070440.1	2026801	g31003	i0	96.2	0.987341772151899	52	2	98.7	0	1	156	456	507	MDB6070440.1 hybrid sensor histidine kinase/response regulator [Verrucomicrobiales bacterium]	diamond	156	97.4	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales			Verrucomicrobiales bacterium
27563966	27563966	PRJNA1013345_P_NODE_22004_length_167_cov_1.700000_g21874_i0	PRJNA1013345	22004	167	1.7	2.839	Zavarzinella	600332	Bacteria	Bacteria	112	5.23e-27	NR	MEZ6141805.1	1914240	g21874	i0	90.9	9.88023952095808	55	5	98.8	0	1	165	517	571	MEZ6141805.1 S9 family peptidase [Zavarzinella sp.]	diamond	1650	112	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Zavarzinella	Zavarzinella sp.
28740256	28740256	PRJNA1013345_P_NODE_13567_length_186_cov_1.136691_g13437_i0	PRJNA1013345	13567	186	1.136691	2.11424526	Candidatus Brocadiaceae bacterium	2094028	Bacteria	Bacteria	72	8.12e-13	NR	MFO0793970.1	2094028	g13437	i0	56.5	1	62	22	91.9	1	12	182	96	157	MFO0793970.1 hypothetical protein [Candidatus Brocadiaceae bacterium]	diamond	186	72	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Candidatus Brocadiia	Candidatus Brocadiales	Candidatus Brocadiaceae		Candidatus Brocadiaceae bacterium
28993165	28993165	PRJNA1013345_P_NODE_10828_length_199_cov_3.335526_g10698_i0	PRJNA1013345	10828	199	3.335526	6.63769674	Phycisphaerales bacterium	2052180	Bacteria	Bacteria	44.7	9.96e-4	NR	MCH2142345.1	2052180	g10698	i0	46.9	0.738693467336683	49	24	70.9	2	57	197	19	67	MCH2142345.1 hypothetical protein [Phycisphaerales bacterium]	diamond	147	44.7	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			Phycisphaerales bacterium
29182460	29182460	PRJNA1013345_P_NODE_32069_length_157_cov_0.927273_g31939_i0	PRJNA1013345	32069	157	0.927273	1.45581861	Pirellulales bacterium	2715253	Bacteria	Bacteria	96.3	1.29e-21	NR	MEX2309924.1	2715253	g31939	i0	86.5	1.96815286624204	52	7	99.4	0	2	157	419	470	MEX2309924.1 DUF1598 domain-containing protein [Pirellulales bacterium]	diamond	309	96.3	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales			Pirellulales bacterium
29403304	29403304	PRJNA1013345_P_NODE_21629_length_168_cov_1.578512_g21499_i0	PRJNA1013345	21629	168	1.578512	2.65190016	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	77.8	2.94e-15	NR	MES2659112.1	2026799	g21499	i0	63	0.964285714285714	54	20	96.4	0	164	3	31	84	MES2659112.1 transporter [Verrucomicrobiota bacterium]	diamond	162	77.8	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
29553137	29553137	PRJNA1013345_P_NODE_32950_length_155_cov_2.518519_g32820_i0	PRJNA1013345	32950	155	2.518519	3.90370445	Horticoccus	2986286	Bacteria	Bacteria	77.8	2.46e-15	NR	MEK0448159.1	2026799	g32820	i0	70	4.74193548387097	50	15	96.8	0	1	150	148	197	MEK0448159.1 hypothetical protein [Verrucomicrobiota bacterium]	diamond	735	77.8	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
29813639	29813639	PRJNA1013345_P_NODE_26931_length_161_cov_3.263158_g26801_i0	PRJNA1013345	26931	161	3.263158	5.25368438	Candidatus Theseobacter exili	3039698	Bacteria	Bacteria	40.8	0.0149	NR	MDP8219236.1	3039698	g26801	i0	45.9	0.68944099378882	37	20	68.9	0	141	31	6	42	MDP8219236.1 YkgJ family cysteine cluster protein [Candidatus Theseobacter exili]	diamond	111	40.8	1	Bacteria	PVC group	Pseudomonadati	Candidatus Auribacterota	Candidatus Auribacteria	Candidatus Theseobacterales	Candidatus Theseobacteraceae	Candidatus Theseobacter	Candidatus Theseobacter exili
29932531	29932531	PRJNA1013345_P_NODE_20831_length_169_cov_3.418033_g20701_i0	PRJNA1013345	20831	169	3.418033	5.77647577	Bacteria	2	Bacteria	Bacteria	42	0.0251	NR	MCX6869067.1	2026799	g20701	i0	39.5	6.10650887573965	43	25	74.6	1	36	161	303	345	MCX6869067.1 glutamine synthetase family protein [Verrucomicrobiota bacterium]	diamond	1032	42.4	0.990566037735849	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
30003411	30003411	PRJNA1013345_P_NODE_16451_length_179_cov_1.583333_g16321_i0	PRJNA1013345	16451	179	1.583333	2.83416607	Coraliomargarita parva	3014050	Bacteria	Bacteria	42.4	0.0216	NR	WP_269522163.1	3014050	g16321	i0	41.7	0.804469273743017	48	27	78.8	1	10	150	14	61	WP_269522163.1 hypothetical protein [Coraliomargarita parva]	diamond	144	42.4	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Puniceicoccales	Coraliomargaritaceae	Coraliomargarita	Coraliomargarita parva
30034964	30034964	PRJNA1013345_P_NODE_14911_length_183_cov_0.875000_g14781_i0	PRJNA1013345	14911	183	0.875	1.60125	Gemmatales bacterium	2838789	Bacteria	Bacteria	45.1	0.00264	NR	HMP58027.1	2838789	g14781	i0	41.1	1.83606557377049	56	30	90.2	2	19	183	234	287	HMP58027.1 hypothetical protein [Gemmatales bacterium]	diamond	336	45.1	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales			Gemmatales bacterium
31108956	31108956	PRJNA1013345_P_NODE_25455_length_163_cov_0.879310_g25325_i0	PRJNA1013345	25455	163	0.87931	1.4332753	Lacipirellula parvula	2650471	Bacteria	Bacteria	53.1	2.69e-6	NR	WP_152098417.1	2650471	g25325	i0	93.1	0.533742331288344	29	2	53.4	0	87	1	1	29	WP_152098417.1 NCS1 family nucleobase:cation symporter-1 [Lacipirellula parvula]	diamond	87	53.1	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Lacipirellulaceae	Lacipirellula	Lacipirellula parvula
31544158	31544158	PRJNA1013345_P_NODE_25456_length_163_cov_0.879310_g25326_i0	PRJNA1013345	25456	163	0.87931	1.4332753	Limnoglobus	2731450	Bacteria	Bacteria	76.3	1.9e-14	NR	MDB5307073.1	2052164	g25326	i0	64.8	3.90184049079755	54	19	99.4	0	1	162	92	145	MDB5307073.1 serine/threonine protein kinase [Gemmataceae bacterium]	diamond	636	76.3	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		Gemmataceae bacterium
31741467	31741467	PRJNA1013345_P_NODE_25677_length_163_cov_0.879310_g25547_i0	PRJNA1013345	25677	163	0.87931	1.4332753	Planctomycetaceae bacterium	2026779	Bacteria	Bacteria	54.7	7.56e-7	NR	MBL8855614.1	2026779	g25547	i0	51.9	0.957055214723926	52	25	95.7	0	156	1	277	328	MBL8855614.1 acyltransferase [Planctomycetaceae bacterium]	diamond	156	54.7	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		Planctomycetaceae bacterium
32342997	32342997	PRJNA1013345_P_NODE_29019_length_160_cov_0.902655_g28889_i0	PRJNA1013345	29019	160	0.902655	1.444248	Planctomycetota bacterium	2026780	Bacteria	Bacteria	70.1	2.63e-12	NR	MEI7853283.1	2026780	g28889	i0	69.2	2.85	52	16	97.5	0	158	3	3628	3679	MEI7853283.1 leucine-rich repeat protein [Planctomycetota bacterium]	diamond	456	70.1	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
32564495	32564495	PRJNA1013345_P_NODE_10619_length_201_cov_1.538961_g10489_i0	PRJNA1013345	10619	201	1.538961	3.09331161	Phycisphaerales bacterium	2052180	Bacteria	Bacteria	42	0.0416	NR	MDB5304050.1	2052180	g10489	i0	48.7	0.582089552238806	39	20	58.2	0	79	195	443	481	MDB5304050.1 hypothetical protein [Phycisphaerales bacterium]	diamond	117	42	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			Phycisphaerales bacterium
32658350	32658350	PRJNA1013345_P_NODE_19240_length_173_cov_1.619048_g19110_i0	PRJNA1013345	19240	173	1.619048	2.80095304	Lacipirellulaceae bacterium	2691534	Bacteria	Bacteria	53.5	2.23e-6	NR	HMO84383.1	2691534	g19110	i0	53.6	0.971098265895954	56	25	97.1	1	2	169	53	107	HMO84383.1 ABC transporter permease [Lacipirellulaceae bacterium]	diamond	168	53.5	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Lacipirellulaceae		Lacipirellulaceae 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);;