metadata: contig_metadata: 19 rows where bioproject = "PRJEB81171", tax_clade = "PVC group" and tax

19 rows where bioproject = "PRJEB81171", 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
1414062	1414062	PRJEB81171_P_NODE_6882_length_265_cov_0.932292_g6755_i0	PRJEB81171	6882	265	0.932292	2.4705738	uncultured Gemmataceae bacterium	1914239	Bacteria	Bacteria	396	9.71e-106	NTclustered	gi\|2874253853\|emb\|OY969909.1\|	1914239	g6755	i0	93.633	102.509433962264	267	13	100	4	1	265	2002387	2002651	MAG: uncultured Gemmataceae bacterium isolate MFD01275.bin.c.1 genome assembly, chromosome: 1	blastn	27165	396	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
2689393	2689393	PRJEB81171_P_NODE_2243_length_443_cov_1.629730_g2118_i0	PRJEB81171	2243	443	1.62973	7.2197039	uncultured Gemmataceae bacterium	1914239	Bacteria	Bacteria	449	1.3e-121	NTclustered	gi\|2874253853\|emb\|OY969909.1\|	1914239	g2118	i0	85.045	221.851015801354	448	59	100	8	1	443	2002086	2001642	MAG: uncultured Gemmataceae bacterium isolate MFD01275.bin.c.1 genome assembly, chromosome: 1	blastn	98280	449	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
9066731	9066731	PRJEB81171_P_NODE_6568_length_270_cov_1.583756_g6441_i0	PRJEB81171	6568	270	1.583756	4.2761412	Planctomyces sp. SH-PL62	1636152	Bacteria	Bacteria	228	3.8299999999999994e-55	NTclustered	gi\|1015454008\|gb\|CP011273.1\|	1636152	g6441	i0	83.534	8.01851851851852	249	35	91	6	25	270	6489338	6489093	Planctomyces sp. SH-PL62, complete genome	blastn	2165	228	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Planctomyces	Planctomyces sp. SH-PL62
11617943	11617943	PRJEB81171_P_NODE_4290_length_321_cov_0.943548_g4163_i0	PRJEB81171	4290	321	0.943548	3.02878908	Phycisphaeraceae bacterium	2026777	Bacteria	Bacteria	250	9.95e-62	NTclustered	gi\|2076441902\|gb\|CP075368.1\|	2026777	g4163	i0	81.21	2.90965732087227	314	55	97	4	1	312	2178613	2178924	MAG: Phycisphaeraceae bacterium isolate ACE_PLA2 chromosome	blastn	934	250	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales	Phycisphaeraceae		Phycisphaeraceae bacterium
15441880	15441880	PRJEB81171_P_NODE_4913_length_300_cov_1.682819_g4786_i0	PRJEB81171	4913	300	1.682819	5.048457	Limnoglobus roseus	2598579	Bacteria	Bacteria	429	1.1e-115	NTclustered	gi\|1733446852\|gb\|CP042425.1\|	2598579	g4786	i0	92.667	126.216666666667	300	19	99	3	3	300	2957123	2956825	Limnoglobus roseus strain PX52 chromosome, complete genome	blastn	37865	429	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Limnoglobus	Limnoglobus roseus
16716222	16716222	PRJEB81171_P_NODE_8734_length_248_cov_0.891429_g8607_i0	PRJEB81171	8734	248	0.891429	2.21074392	Phycisphaera mikurensis	547188	Bacteria	Bacteria	52.8	0.022	NTclustered	gi\|381385343\|dbj\|AP012338.1\|	1142394	g8607	i0	100	0.112903225806452	28	0	11	0	127	154	2362396	2362423	Phycisphaera mikurensis NBRC 102666 DNA, complete genome	blastn	28	52.8	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales	Phycisphaeraceae	Phycisphaera	Phycisphaera mikurensis
24365146	24365146	PRJEB81171_P_NODE_2980_length_382_cov_1.669903_g2853_i0	PRJEB81171	2980	382	1.669903	6.37902946	uncultured Gemmataceae bacterium	1914239	Bacteria	Bacteria	542	1.7699999999999999e-149	NTclustered	gi\|2874253853\|emb\|OY969909.1\|	1914239	g2853	i0	92.228	99.8586387434555	386	24	100	6	1	382	2003086	2002703	MAG: uncultured Gemmataceae bacterium isolate MFD01275.bin.c.1 genome assembly, chromosome: 1	blastn	38146	542	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
26717274	26717274	PRJEB81171_P_NODE_6021_length_278_cov_2.282927_g5894_i0	PRJEB81171	6021	278	2.282927	6.34653706	Planctomycetota bacterium	2026780	Bacteria	Bacteria	82	4.27e-16	NR	MCP4609751.1	2026780	g5894	i0	50	1.78057553956835	84	41	89.6	1	253	5	234	317	MCP4609751.1 sulfotransferase [Planctomycetota bacterium]	diamond	495	82	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
27097411	27097411	PRJEB81171_P_NODE_5622_length_285_cov_0.985849_g5495_i0	PRJEB81171	5622	285	0.985849	2.80966965	Planctomycetaceae bacterium	2026779	Bacteria	Bacteria	58.5	1.56e-7	NR	MFN0198965.1	2026779	g5495	i0	33.3	0.947368421052632	90	59	94.7	1	14	283	23	111	MFN0198965.1 hypothetical protein [Planctomycetaceae bacterium]	diamond	270	58.5	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		Planctomycetaceae bacterium
27539909	27539909	PRJEB81171_P_NODE_7404_length_256_cov_1.699454_g7277_i0	PRJEB81171	7404	256	1.699454	4.35060224	Pirellulaceae bacterium	2699754	Bacteria	Bacteria	58.9	1.21e-8	NR	HEY6564530.1	2699754	g7277	i0	68.4	1.32421875	38	12	44.5	0	130	243	3	40	HEY6564530.1 6-carboxytetrahydropterin synthase [Pirellulaceae bacterium]	diamond	339	58.9	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae		Pirellulaceae bacterium
27855498	27855498	PRJEB81171_P_NODE_665_length_797_cov_2.678177_g555_i0	PRJEB81171	665	797	2.678177	21.34507069	Pirellulaceae bacterium	2699754	Bacteria	Bacteria	77	7.02e-12	NR	MFM8407616.1	2699754	g555	i0	32.3	1.88958594730238	251	140	84.7	11	724	50	141	387	MFM8407616.1 SdrD B-like domain-containing protein [Pirellulaceae bacterium]	diamond	1506	77	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae		Pirellulaceae bacterium
27981910	27981910	PRJEB81171_P_NODE_7725_length_253_cov_0.866667_g7598_i0	PRJEB81171	7725	253	0.866667	2.19266751	Gemmataceae bacterium	2052164	Bacteria	Bacteria	101	8.13e-23	NR	HMC65002.1	2052164	g7598	i0	58.8	0.948616600790514	80	33	94.9	0	10	249	214	293	HMC65002.1 vWA domain-containing protein [Gemmataceae bacterium]	diamond	240	101	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		Gemmataceae bacterium
28732393	28732393	PRJEB81171_P_NODE_427_length_977_cov_2.418142_g340_i0	PRJEB81171	427	977	2.418142	23.62524734	Planctomycetia	203683	Bacteria	Bacteria	55.5	2.25e-4	NR	MFM8580792.1	2026779	g340	i0	48.6	1.41555783009212	70	35	21.5	1	308	99	424	492	MFM8580792.1 collagen binding domain-containing protein [Planctomycetaceae bacterium]	diamond	1383	55.5	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		Planctomycetaceae bacterium
28921639	28921639	PRJEB81171_P_NODE_1248_length_589_cov_1.982558_g1126_i0	PRJEB81171	1248	589	1.982558	11.67726662	Bacteria	2	Bacteria	Bacteria	101	5.71e-21	NR	QOJ04281.1	2052181	g1126	i0	41.7	2.80135823429542	151	76	75.9	4	581	135	334	474	QOJ04281.1 MAG: hypothetical protein HRU71_12640 [Planctomycetia bacterium]	diamond	1650	102	0.990196078431373	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia				Planctomycetia bacterium
30571148	30571148	PRJEB81171_P_NODE_6293_length_274_cov_1.532338_g6166_i0	PRJEB81171	6293	274	1.532338	4.19860612	Phycisphaeraceae bacterium	2026777	Bacteria	Bacteria	47	0.00163	NR	QYK46985.1	2026777	g6166	i0	32.9	0.897810218978102	82	36	84.3	2	41	271	135	202	QYK46985.1 MAG: isoprenylcysteine carboxylmethyltransferase family protein [Phycisphaeraceae bacterium]	diamond	246	47	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales	Phycisphaeraceae		Phycisphaeraceae bacterium
31171438	31171438	PRJEB81171_P_NODE_8015_length_251_cov_1.353933_g7888_i0	PRJEB81171	8015	251	1.353933	3.39837183	Planctomycetota bacterium	2026780	Bacteria	Bacteria	43.5	0.0213	NR	MBN8643811.1	2026780	g7888	i0	41.5	0.633466135458167	53	26	59.8	2	74	223	284	334	MBN8643811.1 radical SAM family heme chaperone HemW [Planctomycetota bacterium]	diamond	159	43.5	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
31298125	31298125	PRJEB81171_P_NODE_7875_length_252_cov_0.871508_g7748_i0	PRJEB81171	7875	252	0.871508	2.19620016	Planctomycetota bacterium	2026780	Bacteria	Bacteria	75.1	1.58e-13	NR	MBI5765270.1	2026780	g7748	i0	100	0.404761904761905	34	0	40.5	0	1	102	397	430	MBI5765270.1 beta-ketoacyl-[acyl-carrier-protein] synthase family protein [Planctomycetota bacterium]	diamond	102	75.1	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
31519748	31519748	PRJEB81171_P_NODE_6716_length_267_cov_3.860825_g6589_i0	PRJEB81171	6716	267	3.860825	10.30840275	Phycisphaerales bacterium	2052180	Bacteria	Bacteria	118	3.21e-32	NR	MBE2293297.1	2052180	g6589	i0	70.2	5.68539325842697	84	25	94.4	0	15	266	3	86	MBE2293297.1 group 1 truncated hemoglobin [Phycisphaerales bacterium]	diamond	1518	118	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			Phycisphaerales bacterium
32088977	32088977	PRJEB81171_P_NODE_8958_length_247_cov_0.896552_g8831_i0	PRJEB81171	8958	247	0.896552	2.21448344	Phycisphaeraceae bacterium	2026777	Bacteria	Bacteria	44.7	0.00839	NR	MBX3390531.1	2026777	g8831	i0	38.1	1.02024291497976	84	47	97.2	3	244	5	298	380	MBX3390531.1 hypothetical protein [Phycisphaeraceae bacterium]	diamond	252	44.7	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales	Phycisphaeraceae		Phycisphaeraceae 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);;