metadata: contig_metadata: 24 rows where analysis = "blastn", bioproject = "PRJNA382357" and tax

24 rows where analysis = "blastn", bioproject = "PRJNA382357" and tax_phylum = "Verrucomicrobiota"

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
404184	404184	PRJNA382357_P_NODE_65081_length_292_cov_2.532468_g64342_i0	PRJNA382357	65081	292	2.532468	7.39480656	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	442	1.3699999999999994e-119	NTclustered	gi\|2874254020\|emb\|OY970345.1\|	412056	g64342	i0	94.198	105.33904109589	293	12	99	5	3	292	3893321	3893611	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04212.bin.2.122 genome assembly, chromosome: 1	blastn	30759	442	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
1678188	1678188	PRJNA382357_P_NODE_18022_length_516_cov_1.463736_g17292_i0	PRJNA382357	18022	516	1.463736	7.55287776	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	481	5.44e-131	NTclustered	gi\|2874253952\|emb\|OY970277.1\|	412056	g17292	i0	91.691	154.085271317829	349	26	85	3	138	485	2750152	2750498	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04580.bin.1.45 genome assembly, chromosome: 1	blastn	79508	481	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
2953366	2953366	PRJNA382357_P_NODE_128503_length_215_cov_9.110390_g127764_i0	PRJNA382357	128503	215	9.11039	19.5873385	Horticoccus luteus	2862869	Bacteria	Bacteria	148	2.35e-31	NTclustered	gi\|2077391884\|gb\|CP080507.1\|	2862869	g127764	i0	86.567	0.623255813953488	134	18	62	0	82	215	2307294	2307427	Horticoccus luteus strain KSB-15 chromosome, complete genome	blastn	134	148	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Horticoccus	Horticoccus luteus
4229614	4229614	PRJNA382357_P_NODE_109584_length_232_cov_8.286550_g108845_i0	PRJNA382357	109584	232	8.28655	19.224796	Opitutus sp. GAS368	1882749	Bacteria	Bacteria	135	2e-27	NTclustered	gi\|1085764882\|emb\|LT629735.1\|	1882749	g108845	i0	89.623	15.4741379310345	106	11	71	0	127	232	589694	589589	Opitutus sp. GAS368 genome assembly, chromosome: I	blastn	3590	135	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Opitutus	Opitutus sp. GAS368
4231394	4231394	PRJNA382357_P_NODE_66544_length_289_cov_3.442982_g65805_i0	PRJNA382357	66544	289	3.442982	9.95021798	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	196	1.17e-45	NTclustered	gi\|2874253690\|emb\|OY969416.1\|	412056	g65805	i0	99.083	10.8754325259516	109	1	38	0	6	114	1315317	1315425	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04967.bin.1.157 genome assembly, chromosome: 1	blastn	3143	196	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
5506293	5506293	PRJNA382357_P_NODE_120665_length_222_cov_8.776398_g119926_i0	PRJNA382357	120665	222	8.776398	19.48360356	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	52.8	0.02	NTclustered	gi\|2874253768\|emb\|OY969715.1\|	412056	g119926	i0	96.774	0.13963963963964	31	1	14	0	129	159	2439815	2439785	MAG: uncultured Verrucomicrobiae bacterium isolate MFD01916.bin.1.1 genome assembly, chromosome: 1	blastn	31	52.8	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
5507366	5507366	PRJNA382357_P_NODE_33085_length_394_cov_4.912913_g32346_i0	PRJNA382357	33085	394	4.912913	19.35687722	Actomonas aquatica	2866162	Bacteria	Bacteria	54.7	0.01	NTclustered	gi\|2647674565\|gb\|CP139781.1\|	2866162	g32346	i0	100	0.0736040609137056	29	0	7	0	166	194	3697277	3697305	Actomonas aquatica strain WL0086 chromosome, complete genome	blastn	29	54.7	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Actomonas	Actomonas aquatica
8056639	8056639	PRJNA382357_P_NODE_2047_length_1237_cov_12.414966_g1586_i0	PRJNA382357	2047	1237	12.414966	153.57312942	Akkermansiaceae bacterium	2562705	Bacteria	Bacteria	597	1.2899999999999998e-165	NTclustered	gi\|2022020957\|gb\|CP059069.1\|	2562705	g1586	i0	86.572	51.6119644300728	566	47	92	21	103	663	3411200	3410659	Akkermansiaceae bacterium strain AJA081-3 chromosome, complete genome	blastn	63844	597	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Akkermansiaceae		Akkermansiaceae bacterium
13156286	13156286	PRJNA382357_P_NODE_116891_length_226_cov_1.181818_g116152_i0	PRJNA382357	116891	226	1.181818	2.67090868	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	357	3.81e-94	NTclustered	gi\|2874254020\|emb\|OY970345.1\|	412056	g116152	i0	95.133	38.4601769911504	226	11	100	0	1	226	3893912	3893687	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04212.bin.2.122 genome assembly, chromosome: 1	blastn	8692	357	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
15705487	15705487	PRJNA382357_P_NODE_130993_length_213_cov_7.927632_g130254_i0	PRJNA382357	130993	213	7.927632	16.88585616	Akkermansiaceae bacterium	2562705	Bacteria	Bacteria	231	2.24e-56	NTclustered	gi\|2022020957\|gb\|CP059069.1\|	2562705	g130254	i0	97.761	227.643192488263	134	3	96	0	1	134	3411747	3411614	Akkermansiaceae bacterium strain AJA081-3 chromosome, complete genome	blastn	48488	231	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Akkermansiaceae		Akkermansiaceae bacterium
15707056	15707056	PRJNA382357_P_NODE_74493_length_275_cov_11.046729_g73754_i0	PRJNA382357	74493	275	11.046729	30.37850475	uncultured Verrucomicrobiota bacterium	156588	Bacteria	Bacteria	255	1.79e-63	NTclustered	gi\|226525339\|gb\|FJ872375.1\|	156588	g73754	i0	90.674	2.88363636363636	193	16	70	2	1	192	28187	28378	Uncultured Verrucomicrobia bacterium clone 286 genomic sequence	blastn	793	255	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					uncultured Verrucomicrobiota bacterium
15707091	15707091	PRJNA382357_P_NODE_76353_length_272_cov_14.549763_g75614_i0	PRJNA382357	76353	272	14.549763	39.57535536	Luteolibacter sp. AS25	3135776	Bacteria	Bacteria	337	6.15e-88	NTclustered	gi\|2889346039\|gb\|CP151837.1\|	3135776	g75614	i0	98.936	292.955882352941	188	2	100	0	1	188	456796	456983	Luteolibacter sp. AS25 chromosome, complete genome	blastn	79684	337	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter sp. AS25
15707115	15707115	PRJNA382357_P_NODE_77633_length_270_cov_4.956938_g76894_i0	PRJNA382357	77633	270	4.956938	13.3837326	Opitutus sp. GAS368	1882749	Bacteria	Bacteria	128	4e-25	NTclustered	gi\|1085764882\|emb\|LT629735.1\|	1882749	g76894	i0	86.441	0.437037037037037	118	14	43	2	1	117	1391862	1391746	Opitutus sp. GAS368 genome assembly, chromosome: I	blastn	118	128	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Opitutus	Opitutus sp. GAS368
19528916	19528916	PRJNA382357_P_NODE_15316_length_551_cov_25.571429_g14592_i0	PRJNA382357	15316	551	25.571429	140.89857379	uncultured Verrucomicrobiota bacterium	156588	Bacteria	Bacteria	582	1.5599999999999996e-161	NTclustered	gi\|226525288\|gb\|FJ872373.1\|	156588	g14592	i0	88.66	150.098003629764	485	45	87	8	1	480	15846	15367	Uncultured Verrucomicrobia bacterium clone 118 genomic sequence	blastn	82704	582	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					uncultured Verrucomicrobiota bacterium
19529297	19529297	PRJNA382357_P_NODE_20896_length_483_cov_4.123223_g20161_i0	PRJNA382357	20896	483	4.123223	19.91516709	uncultured Verrucomicrobiota bacterium	156588	Bacteria	Bacteria	363	1.91e-95	NTclustered	gi\|226525288\|gb\|FJ872373.1\|	156588	g20161	i0	83.293	158.291925465839	413	50	84	17	2	407	15382	15782	Uncultured Verrucomicrobia bacterium clone 118 genomic sequence	blastn	76455	363	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					uncultured Verrucomicrobiota bacterium
20804627	20804627	PRJNA382357_P_NODE_154037_length_202_cov_22.078014_g153298_i0	PRJNA382357	154037	202	22.078014	44.59758828	Termitidicoccus mucosus	1184151	Bacteria	Bacteria	172	1.2899999999999999e-38	NTclustered	gi\|2724066732\|gb\|CP109796.1\|	1184151	g153298	i0	91.935	14.5544554455446	124	9	100	1	80	202	781758	781635	Termitidicoccus mucosus strain TSB47 chromosome, complete genome	blastn	2940	172	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Termitidicoccus	Termitidicoccus mucosus
20805518	20805518	PRJNA382357_P_NODE_51017_length_325_cov_3.522727_g50278_i0	PRJNA382357	51017	325	3.522727	11.44886275	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	381	3.429999999999999e-101	NTclustered	gi\|2874254019\|emb\|OY970344.1\|	412056	g50278	i0	91.398	6.4	279	23	86	1	25	302	1270223	1270501	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04580.bin.c.3 genome assembly, chromosome: 1	blastn	2080	381	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
20805848	20805848	PRJNA382357_P_NODE_69957_length_283_cov_1.572072_g69218_i0	PRJNA382357	69957	283	1.572072	4.44896376	Horticoccus luteus	2862869	Bacteria	Bacteria	73.1	2e-8	NTclustered	gi\|2077391884\|gb\|CP080507.1\|	2862869	g69218	i0	80.208	0.339222614840989	96	19	34	0	165	260	2688544	2688639	Horticoccus luteus strain KSB-15 chromosome, complete genome	blastn	96	73.1	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Horticoccus	Horticoccus luteus
22079716	22079716	PRJNA382357_P_NODE_162818_length_190_cov_7.751938_g162079_i0	PRJNA382357	162818	190	7.751938	14.7286822	Termitidicoccus mucosus	1184151	Bacteria	Bacteria	87.9	4.47e-13	NTclustered	gi\|2724066732\|gb\|CP109796.1\|	1184151	g162079	i0	88.312	0.405263157894737	77	4	40	4	112	187	2466961	2467033	Termitidicoccus mucosus strain TSB47 chromosome, complete genome	blastn	77	87.9	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Termitidicoccus	Termitidicoccus mucosus
22080343	22080343	PRJNA382357_P_NODE_42378_length_353_cov_2.301370_g41639_i0	PRJNA382357	42378	353	2.30137	8.1238361	Nibricoccus aquaticus	2576891	Bacteria	Bacteria	156	2.47e-33	NTclustered	gi\|1243404978\|gb\|CP023344.1\|	2576891	g41639	i0	88.55	11.4079320113314	131	12	37	3	3	133	440327	440454	Nibricoccus aquaticus strain HZ-65 chromosome, complete genome	blastn	4027	156	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Nibricoccus	Nibricoccus aquaticus
22080682	22080682	PRJNA382357_P_NODE_6498_length_788_cov_5.572215_g5847_i0	PRJNA382357	6498	788	5.572215	43.9090542	Oleiharenicola sp. Vm1	3398393	Bacteria	Bacteria	472	5.119999999999998e-128	NTclustered	gi\|2912653302\|gb\|CP180537.1\|	3398393	g5847	i0	94.719	63.1281725888325	303	16	99	0	1	303	3557183	3557485	Oleiharenicola sp. Vm1 chromosome, complete genome	blastn	49745	472	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Oleiharenicola	Oleiharenicola sp. Vm1
22080934	22080934	PRJNA382357_P_NODE_79778_length_267_cov_1.737864_g79039_i0	PRJNA382357	79778	267	1.737864	4.64009688	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	255	1.73e-63	NTclustered	gi\|2874254019\|emb\|OY970344.1\|	412056	g79039	i0	84.015	1.00749063670412	269	40	100	2	1	267	228782	229049	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04580.bin.c.3 genome assembly, chromosome: 1	blastn	269	255	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
23354768	23354768	PRJNA382357_P_NODE_126399_length_217_cov_2.820513_g125660_i0	PRJNA382357	126399	217	2.820513	6.12051321	Opitutus sp. GAS368	1882749	Bacteria	Bacteria	148	2.38e-31	NTclustered	gi\|1085764882\|emb\|LT629735.1\|	1882749	g125660	i0	95.652	34.9308755760369	92	4	42	0	6	97	3718600	3718691	Opitutus sp. GAS368 genome assembly, chromosome: I	blastn	7580	148	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Opitutus	Opitutus sp. GAS368
24629254	24629254	PRJNA382357_P_NODE_14180_length_569_cov_26.818898_g13459_i0	PRJNA382357	14180	569	26.818898	152.59952962	Akkermansiaceae bacterium	2562705	Bacteria	Bacteria	523	9.889999999999997e-144	NTclustered	gi\|2022020957\|gb\|CP059069.1\|	2562705	g13459	i0	97.097	263.924428822496	310	9	100	0	168	477	3412420	3412729	Akkermansiaceae bacterium strain AJA081-3 chromosome, complete genome	blastn	150173	523	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Akkermansiaceae		Akkermansiaceae 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);;