metadata: contig_metadata: 14 rows where analysis = "blastn", bioproject = "PRJNA656952" and tax

14 rows where analysis = "blastn", bioproject = "PRJNA656952" 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
1898498	1898498	PRJNA656952_P_NODE_30922_length_251_cov_1.488764_g30735_i0	PRJNA656952	30922	251	1.488764	3.73679764	Aquisphaera giovannonii	406548	Bacteria	Bacteria	270	5.77e-68	NTclustered	gi\|1730068067\|gb\|CP042997.1\|	406548	g30735	i0	86.111	5.82470119521912	252	33	100	2	1	251	273092	272842	Aquisphaera giovannonii strain OJF2 chromosome, complete genome	blastn	1462	270	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae	Aquisphaera	Aquisphaera giovannonii
1898797	1898797	PRJNA656952_P_NODE_43962_length_241_cov_0.916667_g43775_i0	PRJNA656952	43962	241	0.916667	2.20916747	Luteolibacter sp. SL250	2995170	Bacteria	Bacteria	340	4.13e-89	NTclustered	gi\|2381117106\|gb\|CP113054.1\|	2995170	g43775	i0	92.116	1	241	19	100	0	1	241	1656689	1656929	Luteolibacter sp. SL250 chromosome	blastn	241	340	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter sp. SL250
3172901	3172901	PRJNA656952_P_NODE_16683_length_326_cov_1.517787_g16496_i0	PRJNA656952	16683	326	1.517787	4.94798562	uncultured Verrucomicrobiota bacterium	156588	Bacteria	Bacteria	363	1.25e-95	NTclustered	gi\|226525339\|gb\|FJ872375.1\|	156588	g16496	i0	90.545	370.128834355828	275	24	84	2	38	311	27211	27484	Uncultured Verrucomicrobia bacterium clone 286 genomic sequence	blastn	120662	363	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					uncultured Verrucomicrobiota bacterium
4450043	4450043	PRJNA656952_P_NODE_22864_length_288_cov_1.320930_g22677_i0	PRJNA656952	22864	288	1.32093	3.8042784	Phycisphaerales bacterium	2052180	Bacteria	Bacteria	337	6.57e-88	NTclustered	gi\|1958061316\|gb\|CP064987.1\|	2052180	g22677	i0	88.136	4.04513888888889	295	19	99	6	1	286	577547	577834	Phycisphaerales bacterium isolate Fred_18-Q3-R57-64_MAXAC.330_cln chromosome, complete genome	blastn	1165	337	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			Phycisphaerales bacterium
5725929	5725929	PRJNA656952_P_NODE_36885_length_247_cov_0.885057_g36698_i0	PRJNA656952	36885	247	0.885057	2.18609079	Luteolibacter sp. SL250	2995170	Bacteria	Bacteria	285	2.02e-72	NTclustered	gi\|2381117106\|gb\|CP113054.1\|	2995170	g36698	i0	87.449	1.11336032388664	247	31	100	0	1	247	2795441	2795195	Luteolibacter sp. SL250 chromosome	blastn	275	285	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter sp. SL250
10826628	10826628	PRJNA656952_P_NODE_32489_length_250_cov_0.870056_g32302_i0	PRJNA656952	32489	250	0.870056	2.17514	Lacipirellula limnantheis	2528024	Bacteria	Bacteria	307	4.3800000000000005e-79	NTclustered	gi\|1712529062\|gb\|CP036339.1\|	2528024	g32302	i0	89.627	0.964	241	25	96	0	10	250	5092434	5092674	Lacipirellula limnantheis strain I41 chromosome	blastn	241	307	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Lacipirellulaceae	Lacipirellula	Lacipirellula limnantheis
10826764	10826764	PRJNA656952_P_NODE_38729_length_245_cov_0.895349_g38542_i0	PRJNA656952	38729	245	0.895349	2.19360505	Oleiharenicola sp. Vm1	3398393	Bacteria	Bacteria	252	2.0299999999999998e-62	NTclustered	gi\|2912653302\|gb\|CP180537.1\|	3398393	g38542	i0	85.714	0.971428571428571	238	34	97	0	8	245	3935928	3935691	Oleiharenicola sp. Vm1 chromosome, complete genome	blastn	238	252	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Oleiharenicola	Oleiharenicola sp. Vm1
10826785	10826785	PRJNA656952_P_NODE_39669_length_244_cov_0.900585_g39482_i0	PRJNA656952	39669	244	0.900585	2.1974274	uncultured Gemmataceae bacterium	1914239	Bacteria	Bacteria	75	4.7e-9	NTclustered	gi\|2874253853\|emb\|OY969909.1\|	1914239	g39482	i0	83.544	0.733606557377049	79	13	32	0	143	221	4625057	4625135	MAG: uncultured Gemmataceae bacterium isolate MFD01275.bin.c.1 genome assembly, chromosome: 1	blastn	179	75	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
10826948	10826948	PRJNA656952_P_NODE_689_length_1017_cov_2.231992_g586_i0	PRJNA656952	689	1017	2.231992	22.69935864	uncultured Verrucomicrobiota bacterium	156588	Bacteria	Bacteria	1251	0	NTclustered	gi\|226525288\|gb\|FJ872373.1\|	156588	g586	i0	88.954	167.350049164208	1023	99	100	12	1	1017	15377	16391	Uncultured Verrucomicrobia bacterium clone 118 genomic sequence	blastn	170195	1251	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					uncultured Verrucomicrobiota bacterium
13376622	13376622	PRJNA656952_P_NODE_40111_length_244_cov_0.900585_g39924_i0	PRJNA656952	40111	244	0.900585	2.1974274	Luteolibacter sp. SL250	2995170	Bacteria	Bacteria	231	2.63e-56	NTclustered	gi\|2381117106\|gb\|CP113054.1\|	2995170	g39924	i0	84.783	0.942622950819672	230	35	94	0	15	244	47529	47300	Luteolibacter sp. SL250 chromosome	blastn	230	231	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter sp. SL250
17200455	17200455	PRJNA656952_P_NODE_37494_length_246_cov_0.890173_g37307_i0	PRJNA656952	37494	246	0.890173	2.18982558	Lignipirellula cremea	2528010	Bacteria	Bacteria	178	3.5099999999999993e-40	NTclustered	gi\|1712668320\|gb\|CP036433.1\|	2528010	g37307	i0	80.672	0.967479674796748	238	38	95	6	1	234	3224211	3223978	Lignipirellula cremea strain Pla85_3_4 chromosome, complete genome	blastn	238	178	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Lignipirellula	Lignipirellula cremea
18474653	18474653	PRJNA656952_P_NODE_32955_length_250_cov_0.870056_g32768_i0	PRJNA656952	32955	250	0.870056	2.17514	Tepidisphaeraceae bacterium	2876886	Bacteria	Bacteria	388	1.5199999999999998e-103	NTclustered	gi\|2874253799\|emb\|OY969783.1\|	2876886	g32768	i0	96.97	282.532	231	7	92	0	1	231	2501336	2501106	MAG: Tepidisphaeraceae bacterium isolate MFD04580.bin.c.1 genome assembly, chromosome: 1	blastn	70633	388	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Tepidisphaerales	Tepidisphaeraceae		Tepidisphaeraceae bacterium
21024460	21024460	PRJNA656952_P_NODE_12577_length_361_cov_2.138889_g12390_i0	PRJNA656952	12577	361	2.138889	7.72138929	Chthoniobacter flavus	191863	Bacteria	Bacteria	608	1.619999999999999e-169	NTclustered	gi\|183579828\|emb\|AM905425.1\|	497964	g12390	i0	97.734	241.257617728532	353	8	98	0	9	361	2749	2397	Chthoniobacter flavus 23S rRNA gene, strain Ellin428	blastn	87094	608	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Spartobacteria	Chthoniobacterales	Chthoniobacteraceae	Chthoniobacter	Chthoniobacter flavus
22299818	22299818	PRJNA656952_P_NODE_41578_length_243_cov_0.905882_g41391_i0	PRJNA656952	41578	243	0.905882	2.20129326	Opitutus terrae	107709	Bacteria	Bacteria	161	3.4899999999999997e-35	NTclustered	gi\|177839040\|gb\|CP001032.1\|	452637	g41391	i0	81.592	0.827160493827161	201	32	82	5	41	240	4144126	4144322	Opitutus terrae PB90-1, complete genome	blastn	201	161	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Opitutus	Opitutus terrae

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