metadata: contig_metadata: 17 rows where analysis = "diamond", bioproject = "PRJNA909412" and tax

17 rows where analysis = "diamond", bioproject = "PRJNA909412" 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
16551671	16551671	PRJNA909412_P_NODE_1353_length_474_cov_3.337931_g1214_i0	PRJNA909412	1353	474	3.337931	15.82179294	Planctomycetaceae bacterium	2026779	Bacteria	Bacteria	241	1.05e-74	NR	NUQ35036.1	2026779	g1214	i0	64.6	5.6075949367088596	178	41	98.7	1	2	469	97	274	NUQ35036.1 adenosylhomocysteinase [Planctomycetaceae bacterium]	diamond	2658	241	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		Planctomycetaceae bacterium
20375526	20375526	PRJNA909412_P_NODE_6776_length_202_cov_2.355828_g6635_i0	PRJNA909412	6776	202	2.355828	4.75877256	Bacteria	2	Bacteria	Bacteria	122	2.75e-30	NR	MBT8037638.1	2499141	g6635	i0	80.6	9.93564356435644	67	13	99.5	0	2	202	624	690	MBT8037638.1 aminomethyl-transferring glycine dehydrogenase [Verrucomicrobiia bacterium]	diamond	2007	122	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				Verrucomicrobiia bacterium
26897966	26897966	PRJNA909412_P_NODE_13481_length_160_cov_2.851240_g13340_i0	PRJNA909412	13481	160	2.85124	4.561984	Planctomycetaceae bacterium	2026779	Bacteria	Bacteria	50.4	2.23e-5	NR	MCE5340208.1	2026779	g13340	i0	47.4	2.1375	57	25	97.5	1	3	158	828	884	MCE5340208.1 translation initiation factor IF-2 [Planctomycetaceae bacterium]	diamond	342	50.4	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		Planctomycetaceae bacterium
27024371	27024371	PRJNA909412_P_NODE_15802_length_153_cov_2.052632_g15661_i0	PRJNA909412	15802	153	2.052632	3.14052696	Chlamydiota bacterium	2081524	Bacteria	Bacteria	63.5	4.87e-10	NR	NBO24982.1	2081524	g15661	i0	54.9	7	51	23	100	0	1	153	88	138	NBO24982.1 type III PLP-dependent enzyme [Chlamydiota bacterium]	diamond	1071	63.5	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota					Chlamydiota bacterium
27118987	27118987	PRJNA909412_P_NODE_16222_length_152_cov_2.123894_g16081_i0	PRJNA909412	16222	152	2.123894	3.22831888	Phycisphaerales bacterium	2052180	Bacteria	Bacteria	90.5	9.5e-20	NR	MCI0362746.1	2052180	g16081	i0	85.1	10.1052631578947	47	7	92.8	0	11	151	151	197	MCI0362746.1 MmgE/PrpD family protein [Phycisphaerales bacterium]	diamond	1536	90.5	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			Phycisphaerales bacterium
27972002	27972002	PRJNA909412_P_NODE_1765_length_412_cov_3.632708_g1625_i0	PRJNA909412	1765	412	3.632708	14.96675696	Waddliaceae bacterium	2026802	Bacteria	Bacteria	98.6	1.7700000000000003e-21	NR	HEY4831209.1	2026802	g1625	i0	62	0.575242718446602	79	30	57.5	0	407	171	242	320	HEY4831209.1 F0F1 ATP synthase subunit alpha [Waddliaceae bacterium]	diamond	237	98.6	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Waddliaceae		Waddliaceae bacterium
28066723	28066723	PRJNA909412_P_NODE_8205_length_186_cov_1.088435_g8064_i0	PRJNA909412	8205	186	1.088435	2.0244891	Simkania sp.	34094	Bacteria	Bacteria	52.4	4.37e-7	NR	MCB1084365.1	34094	g8064	i0	43.3	0.967741935483871	60	34	96.8	0	182	3	2	61	MCB1084365.1 hypothetical protein [Simkania sp.]	diamond	180	52.4	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Simkaniaceae	Simkania	Simkania sp.
28571882	28571882	PRJNA909412_P_NODE_16767_length_151_cov_2.482143_g16626_i0	PRJNA909412	16767	151	2.482143	3.74803593	Chthoniobacterales bacterium	2201154	Bacteria	Bacteria	67.8	1.12e-11	NR	MEP6809396.1	2201154	g16626	i0	61.7	0.933774834437086	47	18	93.4	0	142	2	119	165	MEP6809396.1 arginine deiminase-related protein [Chthoniobacterales bacterium]	diamond	141	67.8	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Spartobacteria	Chthoniobacterales			Chthoniobacterales bacterium
29203609	29203609	PRJNA909412_P_NODE_12169_length_163_cov_2.016129_g12028_i0	PRJNA909412	12169	163	2.016129	3.28629027	Planctomycetota bacterium	2026780	Bacteria	Bacteria	80.5	5.94e-16	NR	MBM3984144.1	2026780	g12028	i0	73.5	7.38036809815951	49	13	90.2	0	154	8	302	350	MBM3984144.1 M20/M25/M40 family metallo-hydrolase [Planctomycetota bacterium]	diamond	1203	80.5	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
29298169	29298169	PRJNA909412_P_NODE_11949_length_165_cov_1.936508_g11808_i0	PRJNA909412	11949	165	1.936508	3.1952382	Verrucomicrobiia bacterium	2499141	Bacteria	Bacteria	82.8	7.49e-17	NR	MCB1120004.1	2499141	g11808	i0	82	2.72727272727273	50	9	90.9	0	3	152	125	174	MCB1120004.1 bifunctional folylpolyglutamate synthase/dihydrofolate synthase [Verrucomicrobiia bacterium]	diamond	450	82.8	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				Verrucomicrobiia bacterium
30404044	30404044	PRJNA909412_P_NODE_1233_length_504_cov_6.516129_g1095_i0	PRJNA909412	1233	504	6.516129	32.84129016	PVC group bacterium	2056642	Bacteria	Bacteria	54.3	3.65e-6	NR	MCP4648866.1	2056642	g1095	i0	35.9	0.81547619047619	103	66	61.3	0	92	400	1	103	MCP4648866.1 hypothetical protein [PVC group bacterium]	diamond	411	54.3	1	Bacteria	PVC group	Pseudomonadati						PVC group bacterium
31478324	31478324	PRJNA909412_P_NODE_3816_length_269_cov_1.073913_g3675_i0	PRJNA909412	3816	269	1.073913	2.88882597	Planctomycetota bacterium	2026780	Bacteria	Bacteria	83.2	4.8e-17	NR	MCB9913063.1	2026780	g3675	i0	55.7	2.63197026022305	79	34	88.1	1	267	31	171	248	MCB9913063.1 SDR family oxidoreductase [Planctomycetota bacterium]	diamond	708	83.2	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
31699578	31699578	PRJNA909412_P_NODE_11217_length_171_cov_1.727273_g11076_i0	PRJNA909412	11217	171	1.727273	2.95363683	Phycisphaerales bacterium	2052180	Bacteria	Bacteria	41.2	0.0498	NR	HZW05812.1	2052180	g11076	i0	50	0.631578947368421	36	14	56.1	1	52	147	40	75	HZW05812.1 class I SAM-dependent methyltransferase [Phycisphaerales bacterium]	diamond	108	41.2	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			Phycisphaerales bacterium
32015861	32015861	PRJNA909412_P_NODE_4978_length_234_cov_1.487179_g4837_i0	PRJNA909412	4978	234	1.487179	3.47999886	Planctomycetota bacterium	2026780	Bacteria	Bacteria	71.2	3.05e-12	NR	PCH78894.1	2026780	g4837	i0	46.7	0.961538461538462	75	40	96.2	0	234	10	545	619	PCH78894.1 MAG: hypothetical protein COB96_04960 [Planctomycetota bacterium]	diamond	225	71.2	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
32047602	32047602	PRJNA909412_P_NODE_158_length_1288_cov_8.624500_g127_i0	PRJNA909412	158	1288	8.6245	111.08356	PVC group bacterium	2056642	Bacteria	Bacteria	63.2	2.3e-8	NR	MCP4648866.1	2056642	g127	i0	44	0.232919254658385	100	56	23.3	0	477	178	1	100	MCP4648866.1 hypothetical protein [PVC group bacterium]	diamond	300	63.2	1	Bacteria	PVC group	Pseudomonadati						PVC group bacterium
32079118	32079118	PRJNA909412_P_NODE_9478_length_174_cov_2.681481_g9337_i0	PRJNA909412	9478	174	2.681481	4.66577694	Phycisphaerales bacterium	2052180	Bacteria	Bacteria	49.3	7.01e-5	NR	MCH2162015.1	2052180	g9337	i0	40	1.86206896551724	55	31	91.4	1	8	166	359	413	MCH2162015.1 MmgE/PrpD family protein [Phycisphaerales bacterium]	diamond	324	49.3	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			Phycisphaerales bacterium
32427285	32427285	PRJNA909412_P_NODE_1239_length_502_cov_3.231102_g1100_i0	PRJNA909412	1239	502	3.231102	16.22013204	Planctomycetota bacterium	2026780	Bacteria	Bacteria	171	1.12e-48	NR	MCD6378656.1	2026780	g1100	i0	52.5	1.91235059760956	160	75	95	1	486	10	84	243	MCD6378656.1 Gfo/Idh/MocA family oxidoreductase [Planctomycetota bacterium]	diamond	960	171	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);;