metadata: contig_metadata: 27 rows where bioproject = "PRJEB43370" and tax

27 rows where bioproject = "PRJEB43370" 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
6438384	6438384	PRJEB43370_P_NODE_7566_length_169_cov_0.866667_g7523_i0	PRJEB43370	7566	169	0.866667	1.46466723	uncultured Parachlamydiaceae bacterium	464461	Bacteria	Bacteria	187	3.71e-43	NTclustered	gi\|2874253811\|emb\|OY969795.1\|	464461	g7523	i0	86.857	134.526627218935	175	13	100	7	1	169	2059568	2059398	MAG: uncultured Parachlamydiaceae bacterium isolate MFD05502.bin.c.3 genome assembly, chromosome: 1	blastn	22735	187	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae		uncultured Parachlamydiaceae bacterium
7712599	7712599	PRJEB43370_P_NODE_4847_length_205_cov_1.000000_g4804_i0	PRJEB43370	4847	205	1	2.05	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	121	4.839999999999999e-23	NTclustered	gi\|2874253952\|emb\|OY970277.1\|	412056	g4804	i0	77.941	30.380487804878	204	37	98	8	1	200	3078687	3078886	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04580.bin.1.45 genome assembly, chromosome: 1	blastn	6228	121	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
7712633	7712633	PRJEB43370_P_NODE_8287_length_167_cov_1.322034_g8244_i0	PRJEB43370	8287	167	1.322034	2.20779678	Phycisphaerae bacterium	2026778	Bacteria	Bacteria	85.5	1.14e-17	NR	MBP8303816.1	2026778	g8244	i0	70.9	8.89221556886227	55	16	98.8	0	167	3	213	267	MBP8303816.1 molecular chaperone DnaK [Phycisphaerae bacterium]	diamond	1485	85.5	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae				Phycisphaerae bacterium
13743416	13743416	PRJEB43370_P_NODE_4571_length_210_cov_1.285714_g4528_i0	PRJEB43370	4571	210	1.285714	2.6999994	Planctomycetota bacterium	2026780	Bacteria	Bacteria	81.3	4.41e-18	NR	MBM3989060.1	2026780	g4528	i0	60.9	2.71428571428571	64	25	91.4	0	3	194	15	78	MBM3989060.1 RNA-binding protein [Planctomycetota bacterium]	diamond	570	81.3	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
23012187	23012187	PRJEB43370_P_NODE_7539_length_169_cov_0.866667_g7496_i0	PRJEB43370	7539	169	0.866667	1.46466723	Candidatus Protochlamydia naegleriophila	389348	Bacteria	Bacteria	257	2.79e-64	NTclustered	gi\|971146634\|emb\|LN879502.1\|	389348	g7496	i0	94.083	25.7751479289941	169	10	100	0	1	169	1250508	1250676	Protochlamydia naegleriophila genome assembly PNK1, chromosome : cPNK	blastn	4356	257	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Candidatus Protochlamydia	Candidatus Protochlamydia naegleriophila
26621862	26621862	PRJEB43370_P_NODE_7761_length_169_cov_0.866667_g7718_i0	PRJEB43370	7761	169	0.866667	1.46466723	Terrimicrobium sacchariphilum	690879	Bacteria	Bacteria	47.4	3.04e-4	NR	WP_075079027.1	690879	g7718	i0	58.8	0.603550295857988	34	14	60.4	0	167	66	290	323	WP_075079027.1 hypothetical protein [Terrimicrobium sacchariphilum]	diamond	102	47.4	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Terrimicrobiia	Terrimicrobiales	Terrimicrobiaceae	Terrimicrobium	Terrimicrobium sacchariphilum
27349787	27349787	PRJEB43370_P_NODE_5943_length_187_cov_2.260870_g5900_i0	PRJEB43370	5943	187	2.26087	4.2278269	Tichowtungia aerotolerans	2697043	Bacteria	Bacteria	94.7	1.32e-23	NR	WP_160629922.1	2697043	g5900	i0	68.9	7.74866310160428	61	19	97.9	0	4	186	3	63	WP_160629922.1 peptidylprolyl isomerase [Tichowtungia aerotolerans]	diamond	1449	94.7	1	Bacteria	PVC group	Pseudomonadati	Kiritimatiellota	Tichowtungiia	Tichowtungiales	Tichowtungiaceae	Tichowtungia	Tichowtungia aerotolerans
27627250	27627250	PRJEB43370_P_NODE_4364_length_214_cov_1.260606_g4321_i0	PRJEB43370	4364	214	1.260606	2.69769684	Bacteria	2	Bacteria	Bacteria	101	1.0399999999999997e-23	NR	MFA5258231.1	2026772	g4321	i0	65.7	5.60747663551402	67	23	93.9	0	202	2	3	69	MFA5258231.1 malate dehydrogenase [Opitutales bacterium]	diamond	1200	101	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales			Opitutales bacterium
27823379	27823379	PRJEB43370_P_NODE_3904_length_224_cov_1.251429_g3861_i0	PRJEB43370	3904	224	1.251429	2.80320096	Simkania sp.	34094	Bacteria	Bacteria	130	7.97e-36	NR	MCB1084310.1	34094	g3861	i0	82.4	0.991071428571429	74	13	99.1	0	224	3	15	88	MCB1084310.1 hypothetical protein [Simkania sp.]	diamond	222	130	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Simkaniaceae	Simkania	Simkania sp.
27879678	27879678	PRJEB43370_P_NODE_5905_length_188_cov_1.424460_g5862_i0	PRJEB43370	5905	188	1.42446	2.6779848	Bacteria	2	Bacteria	Bacteria	57.8	8.93e-8	NR	MCX7805658.1	2026780	g5862	i0	41.9	4.56382978723404	62	31	98.9	1	188	3	382	438	MCX7805658.1 SMP-30/gluconolactonase/LRE family protein [Planctomycetota bacterium]	diamond	858	58.2	0.993127147766323	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
28006190	28006190	PRJEB43370_P_NODE_6545_length_179_cov_1.600000_g6502_i0	PRJEB43370	6545	179	1.6	2.864	Pseudomonadati	3379134	Bacteria	Bacteria	77.4	9.41e-15	NR	HUO08880.1	2026778	g6502	i0	62.7	7.91061452513966	59	21	98.9	1	177	1	127	184	HUO08880.1 phosphoenolpyruvate carboxykinase (GTP) [Phycisphaerae bacterium]	diamond	1416	77.4	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae				Phycisphaerae bacterium
28258393	28258393	PRJEB43370_P_NODE_10166_length_163_cov_1.359649_g10123_i0	PRJEB43370	10166	163	1.359649	2.21622787	Pseudomonadati	3379134	Bacteria	Bacteria	48.1	1.6e-4	NR	WP_149113609.1	2598579	g10123	i0	48	1.78527607361963	50	21	92	2	7	156	799	843	WP_149113609.1 FAD-binding protein [Limnoglobus roseus]	diamond	291	48.5	0.991752577319588	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Limnoglobus	Limnoglobus roseus
28328257	28328257	PRJEB43370_P_NODE_3986_length_222_cov_1.202312_g3943_i0	PRJEB43370	3986	222	1.202312	2.66913264	Pirellulaceae bacterium	2699754	Bacteria	Bacteria	42.7	0.0288	NR	MDX1929322.1	2699754	g3943	i0	39.1	0.932432432432432	69	36	85.1	1	214	26	172	240	MDX1929322.1 SdrD B-like domain-containing protein [Pirellulaceae bacterium]	diamond	207	42.7	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae		Pirellulaceae bacterium
28612581	28612581	PRJEB43370_P_NODE_1507_length_356_cov_1.084691_g1464_i0	PRJEB43370	1507	356	1.084691	3.86149996	Planctomycetota bacterium	2026780	Bacteria	Bacteria	43.9	0.0453	NR	MDP6113334.1	2026780	g1464	i0	34.8	0.943820224719101	112	61	92.7	5	4	333	195	296	MDP6113334.1 hypothetical protein [Planctomycetota bacterium]	diamond	336	43.9	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
28738878	28738878	PRJEB43370_P_NODE_8067_length_168_cov_0.873950_g8024_i0	PRJEB43370	8067	168	0.87395	1.468236	Planctomycetia bacterium	2052181	Bacteria	Bacteria	80.1	8.96e-16	NR	MFM8494351.1	2052181	g8024	i0	67.3	1.96428571428571	55	17	96.4	1	166	5	466	520	MFM8494351.1 S8 family serine peptidase [Planctomycetia bacterium]	diamond	330	80.1	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia				Planctomycetia bacterium
28770355	28770355	PRJEB43370_P_NODE_8087_length_168_cov_0.873950_g8044_i0	PRJEB43370	8087	168	0.87395	1.468236	Planctomycetota bacterium	2026780	Bacteria	Bacteria	46.2	7.99e-4	NR	MCW8133401.1	2026780	g8044	i0	45.7	2.41071428571429	46	20	82.1	2	155	18	207	247	MCW8133401.1 hypothetical protein [Planctomycetota bacterium]	diamond	405	46.2	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
28770358	28770358	PRJEB43370_P_NODE_8947_length_166_cov_0.888889_g8904_i0	PRJEB43370	8947	166	0.888889	1.47555574	Akkermansiaceae bacterium	2562705	Bacteria	Bacteria	79.7	3.44e-16	NR	MDB4508061.1	2562705	g8904	i0	58.2	1.96987951807229	55	23	99.4	0	2	166	73	127	MDB4508061.1 endonuclease/exonuclease/phosphatase family protein [Akkermansiaceae bacterium]	diamond	327	79.7	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Akkermansiaceae		Akkermansiaceae bacterium
29464644	29464644	PRJEB43370_P_NODE_10410_length_163_cov_0.912281_g10367_i0	PRJEB43370	10410	163	0.912281	1.48701803	Phycisphaerae bacterium	2026778	Bacteria	Bacteria	50.1	3.16e-5	NR	MCG3131231.1	2026778	g10367	i0	52.2	1.65644171779141	46	21	84.7	1	161	24	270	314	MCG3131231.1 hypothetical protein [Phycisphaerae bacterium]	diamond	270	50.1	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae				Phycisphaerae bacterium
29590971	29590971	PRJEB43370_P_NODE_6630_length_178_cov_1.612403_g6587_i0	PRJEB43370	6630	178	1.612403	2.87007734	Phycisphaerales bacterium	2052180	Bacteria	Bacteria	98.6	1.2e-22	NR	MEQ8850611.1	2052180	g6587	i0	74.6	0.99438202247191	59	15	99.4	0	2	178	81	139	MEQ8850611.1 peptidylprolyl isomerase [Phycisphaerales bacterium]	diamond	177	98.6	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			Phycisphaerales bacterium
29710587	29710587	PRJEB43370_P_NODE_7970_length_168_cov_0.873950_g7927_i0	PRJEB43370	7970	168	0.87395	1.468236	Alienimonas	2714737	Bacteria	Bacteria	51.6	8.96e-6	NR	MEM9703337.1	2026780	g7927	i0	53.7	1.46428571428571	41	19	73.2	0	123	1	83	123	MEM9703337.1 patatin-like phospholipase family protein [Planctomycetota bacterium]	diamond	246	52	0.992307692307692	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
30096543	30096543	PRJEB43370_P_NODE_752_length_502_cov_1.375276_g709_i0	PRJEB43370	752	502	1.375276	6.90388552	Pirellulaceae bacterium	2699754	Bacteria	Bacteria	46.2	0.0302	NR	MEZ6091142.1	2699754	g709	i0	47.5	0.239043824701195	40	21	23.9	0	396	277	315	354	MEZ6091142.1 hypothetical protein [Pirellulaceae bacterium]	diamond	120	46.2	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae		Pirellulaceae bacterium
30507452	30507452	PRJEB43370_P_NODE_8053_length_168_cov_0.873950_g8010_i0	PRJEB43370	8053	168	0.87395	1.468236	Phycisphaerales bacterium	2052180	Bacteria	Bacteria	42	0.0255	NR	MBZ0171110.1	2052180	g8010	i0	45.5	0.982142857142857	55	28	94.6	1	9	167	78	132	MBZ0171110.1 cadherin-like domain-containing protein [Phycisphaerales bacterium]	diamond	165	42	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			Phycisphaerales bacterium
31448948	31448948	PRJEB43370_P_NODE_9836_length_164_cov_0.904348_g9793_i0	PRJEB43370	9836	164	0.904348	1.48313072	Bacteria	2	Bacteria	Bacteria	50.8	1.78e-5	NR	MBI5764236.1	2026780	g9793	i0	55.6	4.0609756097561	54	19	98.8	2	164	3	1227	1275	MBI5764236.1 HYR domain-containing protein [Planctomycetota bacterium]	diamond	666	51.2	0.9921875	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
31512335	31512335	PRJEB43370_P_NODE_6876_length_175_cov_1.238095_g6833_i0	PRJEB43370	6876	175	1.238095	2.16666625	Rubripirellula	1579505	Bacteria	Bacteria	42.4	0.0211	NR	RLT13610.1	2026780	g6833	i0	34.5	2.98285714285714	58	37	99.4	1	174	1	641	697	RLT13610.1 MAG: FAD-binding protein [Planctomycetota bacterium]	diamond	522	42.4	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
31550663	31550663	PRJEB43370_P_NODE_8036_length_168_cov_0.873950_g7993_i0	PRJEB43370	8036	168	0.87395	1.468236	Candidatus Omnitrophota bacterium	2035772	Bacteria	Bacteria	53.9	9.92e-8	NR	MFQ5680630.1	2035772	g7993	i0	52.8	2.83928571428571	53	23	92.9	2	156	1	18	69	MFQ5680630.1 acyl carrier protein [Candidatus Omnitrophota bacterium]	diamond	477	53.9	1	Bacteria	PVC group	Pseudomonadati	Candidatus Omnitrophota					Candidatus Omnitrophota bacterium
31803324	31803324	PRJEB43370_P_NODE_8057_length_168_cov_0.873950_g8014_i0	PRJEB43370	8057	168	0.87395	1.468236	Planctomycetota bacterium	2026780	Bacteria	Bacteria	45.4	5.07e-4	NR	MBI3407224.1	2026780	g8014	i0	42	0.892857142857143	50	29	89.3	0	3	152	39	88	MBI3407224.1 hypothetical protein [Planctomycetota bacterium]	diamond	150	45.4	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
32214882	32214882	PRJEB43370_P_NODE_9378_length_165_cov_0.896552_g9335_i0	PRJEB43370	9378	165	0.896552	1.4793108	Gemmata sp. SH-PL17	1630693	Bacteria	Bacteria	42.7	0.0129	NR	WP_162271578.1	1630693	g9335	i0	52.2	4.65454545454545	46	19	80	2	163	32	137	181	WP_162271578.1 serine/threonine protein kinase [Gemmata sp. SH-PL17]	diamond	768	43.1	0.990719257540603	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Gemmata	Gemmata sp. SH-PL17

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);;