metadata: contig_metadata: 25 rows where analysis = "blastn", bioproject = "PRJNA564013" and tax

25 rows where analysis = "blastn", bioproject = "PRJNA564013" 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
1822101	1822101	PRJNA564013_P_NODE_106082_length_400_cov_21.525074_g103243_i0	PRJNA564013	106082	400	21.525074	86.100296	Luteolibacter sp. SL250	2995170	Bacteria	Bacteria	521	2.4299999999999995e-143	NTclustered	gi\|2381117106\|gb\|CP113054.1\|	2995170	g103243	i0	98.639	152.9825	294	4	89	0	25	318	4041	3748	Luteolibacter sp. SL250 chromosome	blastn	61193	521	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter sp. SL250
1824442	1824442	PRJNA564013_P_NODE_206182_length_300_cov_5.682008_g203331_i0	PRJNA564013	206182	300	5.682008	17.046024	Verrucomicrobium sp. GAS474	1882831	Bacteria	Bacteria	76.8	1.66e-9	NTclustered	gi\|1085974270\|emb\|LT629781.1\|	1882831	g203331	i0	95.745	2.07333333333333	47	2	16	0	154	200	1256987	1256941	Verrucomicrobiaceae bacterium GAS474 genome assembly, chromosome: I	blastn	622	76.8	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Verrucomicrobium	Verrucomicrobium sp. GAS474
1824721	1824721	PRJNA564013_P_NODE_220222_length_287_cov_5.013274_g217371_i0	PRJNA564013	220222	287	5.013274	14.38809638	uncultured Planctomycetaceae bacterium	100233	Bacteria	Bacteria	189	1.94e-43	NTclustered	gi\|2874253948\|emb\|OY970273.1\|	100233	g217371	i0	86.982	11.8675958188153	169	20	59	2	45	212	2996129	2996296	MAG: uncultured Planctomycetaceae bacterium isolate MFD09495.bin.c.1 genome assembly, chromosome: 1	blastn	3406	189	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		uncultured Planctomycetaceae bacterium
3098847	3098847	PRJNA564013_P_NODE_163163_length_340_cov_1.620072_g160313_i0	PRJNA564013	163163	340	1.620072	5.5082448	Akkermansiaceae bacterium	2562705	Bacteria	Bacteria	202	3.0099999999999996e-47	NTclustered	gi\|2022020957\|gb\|CP059069.1\|	2562705	g160313	i0	78.571	0.947058823529412	322	58	93	11	23	338	2959926	2960242	Akkermansiaceae bacterium strain AJA081-3 chromosome, complete genome	blastn	322	202	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Akkermansiaceae		Akkermansiaceae bacterium
3103981	3103981	PRJNA564013_P_NODE_91423_length_426_cov_4.572603_g88590_i0	PRJNA564013	91423	426	4.572603	19.47928878	Limnoglobus roseus	2598579	Bacteria	Bacteria	448	4.48e-121	NTclustered	gi\|1733446852\|gb\|CP042425.1\|	2598579	g88590	i0	86.634	0.948356807511737	404	54	95	0	19	422	2773654	2774057	Limnoglobus roseus strain PX52 chromosome, complete genome	blastn	404	448	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Limnoglobus	Limnoglobus roseus
4377679	4377679	PRJNA564013_P_NODE_27884_length_715_cov_4.585627_g25372_i0	PRJNA564013	27884	715	4.585627	32.78723305	uncultured Planctomycetaceae bacterium	100233	Bacteria	Bacteria	806	0	NTclustered	gi\|2874254106\|emb\|OY970189.1\|	100233	g25372	i0	87.84	149.292307692308	699	69	96	11	18	705	4317031	4317724	MAG: uncultured Planctomycetaceae bacterium isolate MFD09603.bin.2.127 genome assembly, chromosome: 1	blastn	106744	806	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		uncultured Planctomycetaceae bacterium
5650266	5650266	PRJNA564013_P_NODE_104825_length_402_cov_10.832845_g101989_i0	PRJNA564013	104825	402	10.832845	43.5480369	Akkermansiaceae bacterium	2562705	Bacteria	Bacteria	383	1.2e-101	NTclustered	gi\|2022020957\|gb\|CP059069.1\|	2562705	g101989	i0	86.158	64.1069651741294	354	49	88	0	22	375	1052990	1053343	Akkermansiaceae bacterium strain AJA081-3 chromosome, complete genome	blastn	25771	383	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Akkermansiaceae		Akkermansiaceae bacterium
8202564	8202564	PRJNA564013_P_NODE_245447_length_265_cov_3.514706_g242595_i0	PRJNA564013	245447	265	3.514706	9.3139709	Singulisphaera acidiphila	466153	Bacteria	Bacteria	113	1.1e-20	NTclustered	gi\|430012750\|gb\|CP003364.1\|	886293	g242595	i0	83.898	2.33584905660377	118	19	45	0	30	147	4872095	4871978	Singulisphaera acidiphila DSM 18658, complete genome	blastn	619	113	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae	Singulisphaera	Singulisphaera acidiphila
9476760	9476760	PRJNA564013_P_NODE_174908_length_329_cov_6.570896_g172058_i0	PRJNA564013	174908	329	6.570896	21.61824784	uncultured Gemmataceae bacterium	1914239	Bacteria	Bacteria	375	1.6199999999999998e-99	NTclustered	gi\|2874253853\|emb\|OY969909.1\|	1914239	g172058	i0	90.747	33.1519756838906	281	26	86	0	25	305	5812997	5813277	MAG: uncultured Gemmataceae bacterium isolate MFD01275.bin.c.1 genome assembly, chromosome: 1	blastn	10907	375	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
9477132	9477132	PRJNA564013_P_NODE_191808_length_314_cov_2.130435_g188957_i0	PRJNA564013	191808	314	2.130435	6.6895659	Oceaniferula spumae	2979115	Bacteria	Bacteria	75	6.27e-9	NTclustered	gi\|2753272999\|dbj\|AP026866.1\|	2979115	g188957	i0	83.544	0.251592356687898	79	13	25	0	214	292	3016571	3016493	Verrucomicrobiaceae bacterium NT6N DNA, complete genome	blastn	79	75	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Oceaniferula	Oceaniferula spumae
10060341	10060341	PRJNA564013_P_NODE_193508_length_312_cov_5.306773_g190657_i0	PRJNA564013	193508	312	5.306773	16.55713176	Chlamydia	810	Bacteria	Bacteria	483	8.729999999999998e-132	NTclustered	gi\|2160499992\|gb\|CP042720.1\|	813	g190657	i0	99.251	85.5769230769231	267	2	86	0	23	289	662119	662385	Chlamydia trachomatis strain TC0080-IGR-TC0081::TncL2/tetR-1645 chromosome, complete genome	blastn	26700	483	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales	Chlamydiaceae	Chlamydia	Chlamydia trachomatis
10751472	10751472	PRJNA564013_P_NODE_131429_length_370_cov_1.728155_g128581_i0	PRJNA564013	131429	370	1.728155	6.3941735	Synoicihabitans lomoniglobus	2909285	Bacteria	Bacteria	239	2.52e-58	NTclustered	gi\|2452067159\|gb\|CP119075.1\|	2909285	g128581	i0	85.043	1.99189189189189	234	35	63	0	45	278	5910229	5909996	Synoicihabitans lomoniglobus strain LMO-M01 chromosome, complete genome	blastn	737	239	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Synoicihabitans	Synoicihabitans lomoniglobus
10752491	10752491	PRJNA564013_P_NODE_17169_length_875_cov_42.504914_g15045_i0	PRJNA564013	17169	875	42.504914	371.9179975	uncultured Planctomycetaceae bacterium	100233	Bacteria	Bacteria	497	9.429999999999999e-136	NTclustered	gi\|2874253757\|emb\|OY969698.1\|	100233	g15045	i0	83.005	1.27885714285714	559	85	63	10	299	851	6609191	6608637	MAG: uncultured Planctomycetaceae bacterium isolate MFD00082.bin.2.56 genome assembly, chromosome: 1	blastn	1119	497	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		uncultured Planctomycetaceae bacterium
12028006	12028006	PRJNA564013_P_NODE_205330_length_301_cov_3.562500_g202479_i0	PRJNA564013	205330	301	3.5625	10.723125	Oleiharenicola sp. Vm1	3398393	Bacteria	Bacteria	244	4.3099999999999997e-60	NTclustered	gi\|2912653302\|gb\|CP180537.1\|	3398393	g202479	i0	83.271	13.0299003322259	269	41	89	4	23	289	4199366	4199632	Oleiharenicola sp. Vm1 chromosome, complete genome	blastn	3922	244	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Oleiharenicola	Oleiharenicola sp. Vm1
13302117	13302117	PRJNA564013_P_NODE_165351_length_338_cov_2.021661_g162501_i0	PRJNA564013	165351	338	2.021661	6.83321418	Luteolibacter sp. LG18	2819286	Bacteria	Bacteria	337	7.869999999999997e-88	NTclustered	gi\|2585939279\|dbj\|AP024600.1\|	2819286	g162501	i0	86.306	67.1923076923077	314	37	92	6	1	311	633277	632967	Luteolibacter sp. LG18 DNA, complete genome	blastn	22711	337	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter sp. LG18
13305546	13305546	PRJNA564013_P_NODE_340351_length_204_cov_1.286713_g337499_i0	PRJNA564013	340351	204	1.286713	2.62489452	Singulisphaera acidiphila	466153	Bacteria	Bacteria	115	2.2400000000000003e-21	NTclustered	gi\|430012750\|gb\|CP003364.1\|	886293	g337499	i0	86.111	5.31862745098039	108	14	52	1	98	204	1287778	1287671	Singulisphaera acidiphila DSM 18658, complete genome	blastn	1085	115	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae	Singulisphaera	Singulisphaera acidiphila
14577824	14577824	PRJNA564013_P_NODE_204092_length_302_cov_5.439834_g201241_i0	PRJNA564013	204092	302	5.439834	16.42829868	Planctellipticum variicoloris	3064265	Bacteria	Bacteria	156	2.08e-33	NTclustered	gi\|2557458921\|gb\|CP130886.1\|	3064265	g201241	i0	81.095	6.50993377483444	201	32	66	6	76	273	5816755	5816558	Planctellipticum variicoloris strain SH412 chromosome, complete genome	blastn	1966	156	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Planctellipticum	Planctellipticum variicoloris
14579765	14579765	PRJNA564013_P_NODE_310712_length_219_cov_1.575949_g307860_i0	PRJNA564013	310712	219	1.575949	3.45132831	Lacipirellula parvula	2650471	Bacteria	Bacteria	211	3.02e-50	NTclustered	gi\|1761017769\|dbj\|AP021861.1\|	2650471	g307860	i0	84.163	4.01369863013699	221	32	100	3	1	219	12708	12927	Lacipirellula parvula PX69 DNA, complete genome	blastn	879	211	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Lacipirellulaceae	Lacipirellula	Lacipirellula parvula
14580054	14580054	PRJNA564013_P_NODE_325952_length_210_cov_3.496644_g323100_i0	PRJNA564013	325952	210	3.496644	7.3429524	Chthoniobacteraceae bacterium	2811408	Bacteria	Bacteria	137	4.95e-28	NTclustered	gi\|2813917447\|gb\|CP170506.1\|	2811408	g323100	i0	83.221	23.5857142857143	149	25	71	0	53	201	5181599	5181747	MAG: Chthoniobacteraceae bacterium isolate SH-KS-3 chromosome, complete genome	blastn	4953	137	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Spartobacteria	Chthoniobacterales	Chthoniobacteraceae		Chthoniobacteraceae bacterium
14581696	14581696	PRJNA564013_P_NODE_78352_length_457_cov_21.659091_g75529_i0	PRJNA564013	78352	457	21.659091	98.98204587	Tepidisphaeraceae bacterium	2876886	Bacteria	Bacteria	289	3.1e-73	NTclustered	gi\|2874253799\|emb\|OY969783.1\|	2876886	g75529	i0	79.567	3.7308533916849	416	75	90	9	25	435	5423188	5422778	MAG: Tepidisphaeraceae bacterium isolate MFD04580.bin.c.1 genome assembly, chromosome: 1	blastn	1705	289	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Tepidisphaerales	Tepidisphaeraceae		Tepidisphaeraceae bacterium
14581823	14581823	PRJNA564013_P_NODE_85032_length_440_cov_10.195251_g82202_i0	PRJNA564013	85032	440	10.195251	44.8591044	uncultured Planctomycetaceae bacterium	100233	Bacteria	Bacteria	231	5.09e-56	NTclustered	gi\|2874254106\|emb\|OY970189.1\|	100233	g82202	i0	86.222	0.511363636363636	225	17	50	7	202	421	5846175	5846390	MAG: uncultured Planctomycetaceae bacterium isolate MFD09603.bin.2.127 genome assembly, chromosome: 1	blastn	225	231	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		uncultured Planctomycetaceae bacterium
15855388	15855388	PRJNA564013_P_NODE_69473_length_484_cov_10.137116_g66662_i0	PRJNA564013	69473	484	10.137116	49.06364144	Telmatocola sphagniphila	1123043	Bacteria	Bacteria	185	4.459999999999999e-42	NTclustered	gi\|2041266541\|gb\|CP074694.1\|	1123043	g66662	i0	82.11	500.485537190083	218	37	60	2	90	305	3722923	3722706	Telmatocola sphagniphila strain SP2T chromosome, complete genome	blastn	242235	185	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Telmatocola	Telmatocola sphagniphila
16435561	16435561	PRJNA564013_P_NODE_352513_length_197_cov_2.029412_g349661_i0	PRJNA564013	352513	197	2.029412	3.99794164	Pseudomonadati	3379134	Bacteria	Bacteria	60.2	1.02e-4	NTclustered	gi\|1712524857\|gb\|CP036424.1\|	2527998	g349661	i0	94.737	1.91878172588832	38	2	20	0	104	141	2555089	2555052	Planctomycetes bacterium MalM25 chromosome	blastn	378	60.2	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetes bacterium MalM25
19677128	19677128	PRJNA564013_P_NODE_298976_length_226_cov_2.193939_g296124_i0	PRJNA564013	298976	226	2.193939	4.95830214	Rosistilla ulvae	1930277	Bacteria	Bacteria	65.8	2.58e-6	NTclustered	gi\|1712438206\|gb\|CP036261.1\|	1930277	g296124	i0	80.952	2.68141592920354	84	14	37	2	43	125	7048266	7048184	Rosistilla ulvae strain EC9 chromosome	blastn	606	65.8	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Rosistilla	Rosistilla ulvae
22226551	22226551	PRJNA564013_P_NODE_237058_length_272_cov_6.161137_g234206_i0	PRJNA564013	237058	272	6.161137	16.75829264	Phycisphaeraceae bacterium	2026777	Bacteria	Bacteria	235	2.31e-57	NTclustered	gi\|1927958621\|gb\|CP054186.1\|	2026777	g234206	i0	84.914	0.955882352941177	232	35	85	0	23	254	2983790	2983559	MAG: Phycisphaeraceae bacterium isolate H1_PLA1 chromosome	blastn	260	235	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);;