metadata: contig_metadata: 13 rows where bioproject = "PRJNA1068830", tax_clade = "PVC group" and tax

13 rows where bioproject = "PRJNA1068830", tax_clade = "PVC group" 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
4008961	4008961	PRJNA1068830_P_NODE_30224_length_415_cov_2.242690_g29521_i0	PRJNA1068830	30224	415	2.24269	9.3071635	Urbifossiella limnaea	2528023	Bacteria	Bacteria	449	1.2099999999999998e-121	NTclustered	gi\|1712585314\|gb\|CP036273.1\|	2528023	g29521	i0	86.473	99.0674698795181	414	50	99	5	6	415	2018222	2017811	Urbifossiella limnaea strain ETA_A1 chromosome, complete genome	blastn	41113	449	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Urbifossiella	Urbifossiella limnaea
6117332	6117332	PRJNA1068830_P_NODE_41465_length_345_cov_0.797794_g40762_i0	PRJNA1068830	41465	345	0.797794	2.7523893	Gemmata	113	Bacteria	Bacteria	459	1.65e-124	NTclustered	gi\|12583965\|gb\|AF245369.1\|AF245369	114	g40762	i0	90.778	141.214492753623	347	26	100	5	1	345	1916	1574	Gemmata obscuriglobus 23S ribosomal RNA gene, partial sequence	blastn	48719	459	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Gemmata	Gemmata obscuriglobus
27193650	27193650	PRJNA1068830_P_NODE_74542_length_252_cov_0.871508_g73839_i0	PRJNA1068830	74542	252	0.871508	2.19620016	Pirellulaceae bacterium	2699754	Bacteria	Bacteria	58.9	6.36e-8	NR	HEX5103081.1	2699754	g73839	i0	46.7	0.714285714285714	60	32	71.4	0	26	205	5	64	HEX5103081.1 serine/threonine-protein kinase [Pirellulaceae bacterium]	diamond	180	58.9	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae		Pirellulaceae bacterium
27225190	27225190	PRJNA1068830_P_NODE_61603_length_277_cov_1.343137_g60900_i0	PRJNA1068830	61603	277	1.343137	3.72048949	Planctomycetia bacterium	2052181	Bacteria	Bacteria	47	0.00166	NR	MBI3861953.1	2052181	g60900	i0	77.8	0.292418772563177	27	6	29.2	0	3	83	143	169	MBI3861953.1 hypothetical protein [Planctomycetia bacterium]	diamond	81	47	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia				Planctomycetia bacterium
27793998	27793998	PRJNA1068830_P_NODE_15404_length_623_cov_3.160000_g14725_i0	PRJNA1068830	15404	623	3.16	19.6868	Crateriforma spongiae	2724528	Bacteria	Bacteria	161	6.86e-44	NR	WP_168565541.1	2724528	g14725	i0	51.2	2.51364365971108	168	79	79.5	1	9	503	207	374	WP_168565541.1 galactokinase [Crateriforma spongiae]	diamond	1566	161	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Crateriforma	Crateriforma spongiae
27943429	27943429	PRJNA1068830_P_NODE_87865_length_242_cov_1.443787_g87162_i0	PRJNA1068830	87865	242	1.443787	3.49396454	Bacteria	2	Bacteria	Bacteria	91.3	1.25e-19	NR	HBH51526.1	2026779	g87162	i0	54.4	4.94628099173554	79	36	97.9	0	4	240	72	150	HBH51526.1 hypothetical protein [Planctomycetaceae bacterium]	diamond	1197	91.3	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		Planctomycetaceae bacterium
30383711	30383711	PRJNA1068830_P_NODE_84253_length_245_cov_0.906977_g83550_i0	PRJNA1068830	84253	245	0.906977	2.22209365	Planctomycetia bacterium	2052181	Bacteria	Bacteria	137	2.55e-36	NR	MDZ4782843.1	2052181	g83550	i0	77.8	0.991836734693878	81	18	99.2	0	245	3	139	219	MDZ4782843.1 MlaD family protein [Planctomycetia bacterium]	diamond	243	137	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia				Planctomycetia bacterium
30532793	30532793	PRJNA1068830_P_NODE_72993_length_253_cov_0.866667_g72290_i0	PRJNA1068830	72993	253	0.866667	2.19266751	Planctomycetia	203683	Bacteria	Bacteria	51.2	4.28e-5	NR	MFM7041767.1	2026779	g72290	i0	37	7.70750988142292	81	46	96	2	246	4	235	310	MFM7041767.1 M66 family metalloprotease [Planctomycetaceae bacterium]	diamond	1950	51.2	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		Planctomycetaceae bacterium
30857180	30857180	PRJNA1068830_P_NODE_86574_length_243_cov_0.917647_g85871_i0	PRJNA1068830	86574	243	0.917647	2.22988221	Planctomycetia bacterium	2052181	Bacteria	Bacteria	108	1.54e-25	NR	MDZ4779337.1	2052181	g85871	i0	64.2	1	81	29	100	0	1	243	440	520	MDZ4779337.1 lipopolysaccharide kinase InaA family protein [Planctomycetia bacterium]	diamond	243	108	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia				Planctomycetia bacterium
31047097	31047097	PRJNA1068830_P_NODE_61155_length_278_cov_1.521951_g60452_i0	PRJNA1068830	61155	278	1.521951	4.23102378	Pirellulales bacterium	2715253	Bacteria	Bacteria	102	3.649999999999999e-23	NR	MDA7937840.1	2715253	g60452	i0	58.9	0.971223021582734	90	37	97.1	0	7	276	64	153	MDA7937840.1 threonine ammonia-lyase [Pirellulales bacterium]	diamond	270	102	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales			Pirellulales bacterium
31670722	31670722	PRJNA1068830_P_NODE_57137_length_288_cov_1.381395_g56434_i0	PRJNA1068830	57137	288	1.381395	3.9784176	Bacteria	2	Bacteria	Bacteria	54.7	4.04e-6	NR	MEY3460111.1	2026780	g56434	i0	52.8	1.75	53	25	55.2	0	273	115	509	561	MEY3460111.1 hypothetical protein [Planctomycetota bacterium]	diamond	504	55.1	0.992740471869329	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
32659298	32659298	PRJNA1068830_P_NODE_85280_length_244_cov_0.912281_g84577_i0	PRJNA1068830	85280	244	0.912281	2.22596564	Planctomycetaceae bacterium	2026779	Bacteria	Bacteria	42.7	0.0384	NR	MCI0362211.1	2026779	g84577	i0	39.6	0.590163934426229	48	26	59	1	151	8	366	410	MCI0362211.1 hypothetical protein [Planctomycetaceae bacterium]	diamond	144	42.7	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		Planctomycetaceae bacterium
32690880	32690880	PRJNA1068830_P_NODE_72580_length_253_cov_0.866667_g71877_i0	PRJNA1068830	72580	253	0.866667	2.19266751	Planctomycetales bacterium	2053591	Bacteria	Bacteria	43.9	0.014	NR	MBI5757453.1	2053591	g71877	i0	43	0.936758893280632	79	34	93.7	3	15	251	100	167	MBI5757453.1 hypothetical protein [Planctomycetales bacterium]	diamond	237	43.9	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales			Planctomycetales 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);;