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

18 rows where analysis = "blastn", bioproject = "PRJNA283169" 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
371804	371804	PRJNA283169_P_NODE_6441_length_169_cov_1.016667_g6378_i0	PRJNA283169	6441	169	1.016667	1.71816723	uncultured Planctomycetota bacterium	120965	Bacteria	Bacteria	158	2.91e-34	NTclustered	gi\|2874254043\|emb\|OY970367.1\|	120965	g6378	i0	90.678	215.201183431953	118	11	70	0	6	123	3454591	3454708	MAG: uncultured Planctomycetota bacterium isolate MFD04580.bin.c.2 genome assembly, chromosome: 1	blastn	36369	158	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					uncultured Planctomycetota bacterium
2922427	2922427	PRJNA283169_P_NODE_4403_length_201_cov_1.210526_g4340_i0	PRJNA283169	4403	201	1.210526	2.43315726	Luteolibacter sp. Populi	3230487	Bacteria	Bacteria	355	1.19e-93	NTclustered	gi\|2774618348\|gb\|CP161812.1\|	3230487	g4340	i0	98.507	290.338308457711	201	3	100	0	1	201	1321144	1320944	Luteolibacter sp. Populi chromosome, complete genome	blastn	58358	355	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter sp. Populi
3609536	3609536	PRJNA283169_P_NODE_5463_length_183_cov_1.141791_g5400_i0	PRJNA283169	5463	183	1.141791	2.08947753	Methylacidiphilum (ex Ratnadevi et al. 2023)	511745	Bacteria	Bacteria	209	8.74e-50	NTclustered	gi\|189184875\|gb\|CP000975.1\|	481448	g5400	i0	87.845	112.595628415301	181	18	98	4	1	179	894475	894297	Methylacidiphilum infernorum V4, complete genome	blastn	20605	209	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Methylacidiphilae	Methylacidiphilales	Methylacidiphilaceae	Methylacidiphilum (ex Ratnadevi et al. 2023)	Candidatus Methylacidiphilum infernorum
5475228	5475228	PRJNA283169_P_NODE_885_length_412_cov_1.878788_g823_i0	PRJNA283169	885	412	1.878788	7.74060656	Gemmataceae bacterium	2052164	Bacteria	Bacteria	588	2.4399999999999994e-163	NTclustered	gi\|2063814025\|emb\|LR586051.1\|	2052164	g823	i0	98.788	101.507281553398	330	4	100	0	1	330	319633	319962	Gemmata bacterium CJuql4 whole genome assembly and annotation	blastn	41821	588	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		Gemmataceae bacterium
6749435	6749435	PRJNA283169_P_NODE_1666_length_314_cov_1.132075_g1604_i0	PRJNA283169	1666	314	1.132075	3.5547155	uncultured Verrucomicrobiota bacterium	156588	Bacteria	Bacteria	348	3.35e-91	NTclustered	gi\|226525339\|gb\|FJ872375.1\|	156588	g1604	i0	86.901	315.433121019108	313	38	99	2	2	314	27876	28185	Uncultured Verrucomicrobia bacterium clone 286 genomic sequence	blastn	99046	348	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					uncultured Verrucomicrobiota bacterium
9987119	9987119	PRJNA283169_P_NODE_6328_length_170_cov_1.446281_g6265_i0	PRJNA283169	6328	170	1.446281	2.4586777	Parachlamydia	83551	Bacteria	Bacteria	268	1.3e-67	NTclustered	gi\|470491594\|ref\|NR_077046.1\|	83552	g6265	i0	95.294	253.894117647059	170	7	100	1	1	170	453	621	Parachlamydia acanthamoebae strain UV-7 23S ribosomal RNA gene, complete sequence	blastn	43162	268	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Parachlamydia	Parachlamydia acanthamoebae
10575707	10575707	PRJNA283169_P_NODE_269_length_801_cov_4.973404_g217_i0	PRJNA283169	269	801	4.973404	39.83696604	Luteolibacter sp. SL250	2995170	Bacteria	Bacteria	898	0	NTclustered	gi\|2381117106\|gb\|CP113054.1\|	2995170	g217	i0	88.073	279.205992509363	763	84	95	6	2	762	4718743	4717986	Luteolibacter sp. SL250 chromosome	blastn	223644	898	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter sp. SL250
10575720	10575720	PRJNA283169_P_NODE_3689_length_216_cov_1.730539_g3626_i0	PRJNA283169	3689	216	1.730539	3.73796424	Caulifigura coniformis	2527983	Bacteria	Bacteria	267	6.25e-67	NTclustered	gi\|1712508784\|gb\|CP036271.1\|	2527983	g3626	i0	88.889	15.8935185185185	216	24	100	0	1	216	2926057	2926272	Caulifigura coniformis strain Pan44 chromosome	blastn	3433	267	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Caulifigura	Caulifigura coniformis
13125622	13125622	PRJNA283169_P_NODE_5491_length_182_cov_1.563910_g5428_i0	PRJNA283169	5491	182	1.56391	2.8463162	Luteolibacter sp. AS25	3135776	Bacteria	Bacteria	335	1.3699999999999997e-87	NTclustered	gi\|2889346039\|gb\|CP151837.1\|	3135776	g5428	i0	100	274.56043956044	181	0	99	0	1	181	456786	456606	Luteolibacter sp. AS25 chromosome, complete genome	blastn	49970	335	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter sp. AS25
14400807	14400807	PRJNA283169_P_NODE_7052_length_166_cov_0.880342_g6989_i0	PRJNA283169	7052	166	0.880342	1.46136772	Luteolibacter sp. LG18	2819286	Bacteria	Bacteria	219	1.3e-52	NTclustered	gi\|2585939279\|dbj\|AP024600.1\|	2819286	g6989	i0	90.419	47.3493975903614	167	14	100	2	1	166	2216675	2216840	Luteolibacter sp. LG18 DNA, complete genome	blastn	7860	219	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter sp. LG18
15674480	15674480	PRJNA283169_P_NODE_3733_length_215_cov_1.548193_g3670_i0	PRJNA283169	3733	215	1.548193	3.32861495	uncultured Gemmataceae bacterium	1914239	Bacteria	Bacteria	296	7.93e-76	NTclustered	gi\|2874253749\|emb\|OY969623.1\|	1914239	g3670	i0	93.171	111.125581395349	205	9	93	4	1	201	7051628	7051425	MAG: uncultured Gemmataceae bacterium isolate MFD06742.bin.c.1 genome assembly, chromosome: 1	blastn	23892	296	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
16361484	16361484	PRJNA283169_P_NODE_5773_length_178_cov_1.310078_g5710_i0	PRJNA283169	5773	178	1.310078	2.33193884	root	1	Root_unresolved	Root_unresolved	329	6.21e-86	NTclustered	gi\|1774728408\|gb\|MN684281.1\|	2736	g5710	i0	100	99.9550561797753	178	0	100	0	1	178	716	539	Verrucomicrobium spinosum strain MT_SG_E_24_27F.27F 16S ribosomal RNA gene, partial sequence	blastn	17792	329	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Verrucomicrobium	Verrucomicrobium spinosum
16949152	16949152	PRJNA283169_P_NODE_3954_length_211_cov_0.950617_g3891_i0	PRJNA283169	3954	211	0.950617	2.00580187	Caulifigura coniformis	2527983	Bacteria	Bacteria	346	7.59e-91	NTclustered	gi\|1712508784\|gb\|CP036271.1\|	2527983	g3891	i0	96.226	127.293838862559	212	6	100	2	1	211	2926655	2926865	Caulifigura coniformis strain Pan44 chromosome	blastn	26859	346	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Caulifigura	Caulifigura coniformis
18910419	18910419	PRJNA283169_P_NODE_2495_length_261_cov_2.066038_g2433_i0	PRJNA283169	2495	261	2.066038	5.39235918	Verrucomicrobiales	48461	Bacteria	Bacteria	200	8.029999999999999e-47	NTclustered	gi\|2240218473\|gb\|CP097283.1\|	239935	g2433	i0	82.609	264.275862068966	230	37	88	3	33	261	339980	339753	Akkermansia muciniphila strain NB2A-8-WC chromosome	blastn	68976	200	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Akkermansiaceae	Akkermansia	Akkermansia muciniphila
19497694	19497694	PRJNA283169_P_NODE_2456_length_263_cov_1.836449_g2394_i0	PRJNA283169	2456	263	1.836449	4.82986087	Humisphaera borealis	2807512	Bacteria	Bacteria	372	1.62e-98	NTclustered	gi\|1927742986\|gb\|CP063458.1\|	2807512	g2394	i0	92.636	17.6235741444867	258	19	98	0	1	258	5062908	5063165	Humisphaera borealis strain M1803 chromosome, complete genome	blastn	4635	372	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Tepidisphaerales	Tepidisphaeraceae	Humisphaera	Humisphaera borealis
20773289	20773289	PRJNA283169_P_NODE_6257_length_171_cov_1.557377_g6194_i0	PRJNA283169	6257	171	1.557377	2.66311467	uncultured Gemmataceae bacterium	1914239	Bacteria	Bacteria	217	4.8e-52	NTclustered	gi\|2874253749\|emb\|OY969623.1\|	1914239	g6194	i0	89.595	134.631578947368	173	14	99	4	2	171	7051977	7051806	MAG: uncultured Gemmataceae bacterium isolate MFD06742.bin.c.1 genome assembly, chromosome: 1	blastn	23022	217	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
23323804	23323804	PRJNA283169_P_NODE_2859_length_245_cov_2.081633_g2796_i0	PRJNA283169	2859	245	2.081633	5.10000085	uncultured Gemmataceae bacterium	1914239	Bacteria	Bacteria	342	1.17e-89	NTclustered	gi\|2874253749\|emb\|OY969623.1\|	1914239	g2796	i0	91.903	151.391836734694	247	17	100	2	1	245	7051862	7052107	MAG: uncultured Gemmataceae bacterium isolate MFD06742.bin.c.1 genome assembly, chromosome: 1	blastn	37091	342	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
24597889	24597889	PRJNA283169_P_NODE_4680_length_196_cov_1.061224_g4617_i0	PRJNA283169	4680	196	1.061224	2.07999904	Gimesia panareensis	2527978	Bacteria	Bacteria	82.4	2.16e-11	NTclustered	gi\|1712615819\|gb\|CP036277.1\|	2527978	g4617	i0	92.857	2.20918367346939	56	4	29	0	28	83	2381233	2381178	Gimesia panareensis strain Pan110 chromosome, complete genome	blastn	433	82.4	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Gimesia	Gimesia panareensis

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