metadata: contig_metadata: 18 rows where analysis = "blastn", bioproject = "PRJNA688655" and tax

18 rows where analysis = "blastn", bioproject = "PRJNA688655" 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
1943144	1943144	PRJNA688655_P_NODE_16582_length_241_cov_0.916667_g16517_i0	PRJNA688655	16582	241	0.916667	2.20916747	Anaerohalosphaeraceae bacterium	2873829	Bacteria	Bacteria	198	2.63e-46	NTclustered	gi\|2621717560\|emb\|OY775912.1\|	2873829	g16517	i0	82.051	0.970954356846473	234	40	97	2	1	233	210893	210661	MAG: Anaerohalosphaeraceae bacterium isolate 978f9c3d-91dc-4e11-95ec-8fa255ba7f00 genome assembly, chromosome: 1	blastn	234	198	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Sedimentisphaerales	Anaerohalosphaeraceae		Anaerohalosphaeraceae bacterium
1943227	1943227	PRJNA688655_P_NODE_8282_length_251_cov_0.865169_g8217_i0	PRJNA688655	8282	251	0.865169	2.17157419	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	135	2.2e-27	NTclustered	gi\|2874253779\|emb\|OY969763.1\|	412056	g8217	i0	100	42.4422310756972	73	0	29	0	179	251	4441584	4441656	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04967.bin.c.2 genome assembly, chromosome: 1	blastn	10653	135	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
1943231	1943231	PRJNA688655_P_NODE_8802_length_250_cov_0.870056_g8737_i0	PRJNA688655	8802	250	0.870056	2.17514	Planctomycetes bacterium MalM25	2527998	Bacteria	Bacteria	141	4.7e-29	NTclustered	gi\|1712524857\|gb\|CP036424.1\|	2527998	g8737	i0	82.609	1.192	161	26	64	2	89	248	1453926	1453767	Planctomycetes bacterium MalM25 chromosome	blastn	298	141	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetes bacterium MalM25
4495124	4495124	PRJNA688655_P_NODE_16124_length_241_cov_0.916667_g16059_i0	PRJNA688655	16124	241	0.916667	2.20916747	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	340	4.13e-89	NTclustered	gi\|2874253768\|emb\|OY969715.1\|	412056	g16059	i0	92.149	236.705394190871	242	17	100	2	1	241	913971	913731	MAG: uncultured Verrucomicrobiae bacterium isolate MFD01916.bin.1.1 genome assembly, chromosome: 1	blastn	57046	340	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
5770847	5770847	PRJNA688655_P_NODE_7505_length_253_cov_1.322222_g7440_i0	PRJNA688655	7505	253	1.322222	3.34522166	Urbifossiella limnaea	2528023	Bacteria	Bacteria	255	1.63e-63	NTclustered	gi\|1712585314\|gb\|CP036273.1\|	2528023	g7440	i0	85.098	3.50592885375494	255	33	100	5	1	253	4212384	4212133	Urbifossiella limnaea strain ETA_A1 chromosome, complete genome	blastn	887	255	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Urbifossiella	Urbifossiella limnaea
9595818	9595818	PRJNA688655_P_NODE_8528_length_250_cov_0.870056_g8463_i0	PRJNA688655	8528	250	0.870056	2.17514	Luteolibacter ambystomatis	2824561	Bacteria	Bacteria	274	4.44e-69	NTclustered	gi\|2029343589\|gb\|CP073100.1\|	2824561	g8463	i0	87.137	42.1	241	31	96	0	4	244	122915	123155	Luteolibacter ambystomatis strain 32A chromosome, complete genome	blastn	10525	274	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter ambystomatis
10871308	10871308	PRJNA688655_P_NODE_9389_length_249_cov_0.875000_g9324_i0	PRJNA688655	9389	249	0.875	2.17875	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	100	7.94e-17	NTclustered	gi\|2874253779\|emb\|OY969763.1\|	412056	g9324	i0	84.314	0.409638554216867	102	16	41	0	8	109	5092002	5092103	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04967.bin.c.2 genome assembly, chromosome: 1	blastn	102	100	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
13421188	13421188	PRJNA688655_P_NODE_9351_length_249_cov_0.875000_g9286_i0	PRJNA688655	9351	249	0.875	2.17875	Stieleria magnilauensis	2527963	Bacteria	Bacteria	460	3.16e-125	NTclustered	gi\|1712780605\|gb\|CP036432.1\|	2527963	g9286	i0	100	1.99196787148594	249	0	100	0	1	249	3810794	3811042	Planctomycetes bacterium TBK1r chromosome	blastn	496	460	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Stieleria	Stieleria magnilauensis
13930823	13930823	PRJNA688655_P_NODE_1071_length_518_cov_2.195506_g1006_i0	PRJNA688655	1071	518	2.195506	11.37272108	Gemmataceae	1914233	Bacteria	Bacteria	592	2.4199999999999993e-164	NTclustered	gi\|1727537522\|gb\|CP042911.1\|	114	g1006	i0	87.356	135.324324324324	522	58	100	7	1	518	2943090	2942573	Gemmata obscuriglobus strain DSM 5831 chromosome, complete genome	blastn	70098	592	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Gemmata	Gemmata obscuriglobus
14696186	14696186	PRJNA688655_P_NODE_9632_length_249_cov_0.875000_g9567_i0	PRJNA688655	9632	249	0.875	2.17875	Oleiharenicola sp. Vm1	3398393	Bacteria	Bacteria	213	9.77e-51	NTclustered	gi\|2912653302\|gb\|CP180537.1\|	3398393	g9567	i0	82.186	3.61847389558233	247	44	99	0	1	247	751418	751172	Oleiharenicola sp. Vm1 chromosome, complete genome	blastn	901	213	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Oleiharenicola	Oleiharenicola sp. Vm1
17245070	17245070	PRJNA688655_P_NODE_14074_length_244_cov_0.900585_g14009_i0	PRJNA688655	14074	244	0.900585	2.1974274	Planctomyces sp. SH-PL62	1636152	Bacteria	Bacteria	246	9.409999999999999e-61	NTclustered	gi\|1015454008\|gb\|CP011273.1\|	1636152	g14009	i0	84.898	3.37295081967213	245	35	100	2	1	244	104470	104713	Planctomyces sp. SH-PL62, complete genome	blastn	823	246	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Planctomyces	Planctomyces sp. SH-PL62
19794018	19794018	PRJNA688655_P_NODE_11696_length_246_cov_0.890173_g11631_i0	PRJNA688655	11696	246	0.890173	2.18982558	Termitidicoccus mucosus	1184151	Bacteria	Bacteria	89.8	1.69e-13	NTclustered	gi\|2724066732\|gb\|CP109796.1\|	1184151	g11631	i0	84.615	0.626016260162602	91	13	37	1	34	123	1494597	1494507	Termitidicoccus mucosus strain TSB47 chromosome, complete genome	blastn	154	89.8	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Termitidicoccus	Termitidicoccus mucosus
21069524	21069524	PRJNA688655_P_NODE_11977_length_246_cov_0.890173_g11912_i0	PRJNA688655	11977	246	0.890173	2.18982558	Candidatus Uabimicrobium amorphum	2596890	Bacteria	Bacteria	60.2	1.33e-4	NTclustered	gi\|1732437785\|dbj\|AP019860.1\|	2596890	g11912	i0	100	1.88617886178862	32	0	13	0	128	159	9005431	9005400	Planctomycetes bacterium SRT547 DNA, complete genome	blastn	464	60.2	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Candidatus Uabimicrobiia	Candidatus Uabimicrobiales	Candidatus Uabimicrobiaceae	Candidatus Uabimicrobium	Candidatus Uabimicrobium amorphum
22344451	22344451	PRJNA688655_P_NODE_14058_length_244_cov_0.900585_g13993_i0	PRJNA688655	14058	244	0.900585	2.1974274	Urbifossiella limnaea	2528023	Bacteria	Bacteria	102	2.15e-17	NTclustered	gi\|1712585314\|gb\|CP036273.1\|	2528023	g13993	i0	92.857	17.1065573770492	70	5	29	0	1	70	673712	673643	Urbifossiella limnaea strain ETA_A1 chromosome, complete genome	blastn	4174	102	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Urbifossiella	Urbifossiella limnaea
22344584	22344584	PRJNA688655_P_NODE_8298_length_251_cov_0.865169_g8233_i0	PRJNA688655	8298	251	0.865169	2.17157419	Rosistilla oblonga	2527990	Bacteria	Bacteria	52.8	0.023	NTclustered	gi\|1712688765\|gb\|CP036292.1\|	2527990	g8233	i0	96.774	0.123505976095618	31	1	12	0	111	141	4896261	4896231	Rosistilla oblonga strain CA51 chromosome, complete genome	blastn	31	52.8	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Rosistilla	Rosistilla oblonga
23619958	23619958	PRJNA688655_P_NODE_14059_length_244_cov_0.900585_g13994_i0	PRJNA688655	14059	244	0.900585	2.1974274	Sedimentisphaerales bacterium	2813034	Bacteria	Bacteria	62.1	3.66e-5	NTclustered	gi\|2874254109\|emb\|OY970194.1\|	2813034	g13994	i0	100	2.79508196721311	33	0	18	0	152	184	5415360	5415392	MAG: Sedimentisphaerales bacterium isolate MFD00905.bin.c.1 genome assembly, chromosome: 1	blastn	682	62.1	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Sedimentisphaerales			Sedimentisphaerales bacterium
24128820	24128820	PRJNA688655_P_NODE_11739_length_246_cov_0.890173_g11674_i0	PRJNA688655	11739	246	0.890173	2.18982558	Gimesia	1649453	Bacteria	Bacteria	134	7.71e-27	NTclustered	gi\|1712472787\|gb\|CP036266.1\|	2605989	g11674	i0	86.179	3.67073170731707	123	17	50	0	62	184	7990894	7990772	Gimesia chilikensis strain HG66A1 chromosome	blastn	903	134	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Gimesia	Gimesia chilikensis
24893270	24893270	PRJNA688655_P_NODE_14500_length_243_cov_0.905882_g14435_i0	PRJNA688655	14500	243	0.905882	2.20129326	uncultured Gemmataceae bacterium	1914239	Bacteria	Bacteria	148	2.72e-31	NTclustered	gi\|2874253853\|emb\|OY969909.1\|	1914239	g14435	i0	93.137	2.62962962962963	102	6	42	1	86	186	3082173	3082274	MAG: uncultured Gemmataceae bacterium isolate MFD01275.bin.c.1 genome assembly, chromosome: 1	blastn	639	148	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae 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);;