metadata: contig_metadata: 26 rows where analysis = "blastn", bioproject = "PRJNA753704" and tax

26 rows where analysis = "blastn", bioproject = "PRJNA753704" 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
730921	730921	PRJNA753704_P_NODE_15841_length_302_cov_1.017467_g15480_i0	PRJNA753704	15841	302	1.017467	3.07275034	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	375	1.4699999999999999e-99	NTclustered	gi\|2874254096\|emb\|OY970179.1\|	412056	g15480	i0	89.073	174.513245033113	302	33	100	0	1	302	1727840	1727539	MAG: uncultured Verrucomicrobiae bacterium isolate MFD05521.bin.c.1 genome assembly, chromosome: 1	blastn	52703	375	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
2006975	2006975	PRJNA753704_P_NODE_13502_length_324_cov_3.840637_g13141_i0	PRJNA753704	13502	324	3.840637	12.44366388	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	154	8.110000000000001e-33	NTclustered	gi\|2916415364\|gb\|CP170459.1\|	2026799	g13141	i0	75.61	18.0648148148148	328	70	99	9	3	324	2578401	2578078	MAG: Verrucomicrobiota bacterium isolate tig00002468 chromosome, complete genome	blastn	5853	154	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
2006999	2006999	PRJNA753704_P_NODE_15982_length_300_cov_5.088106_g15621_i0	PRJNA753704	15982	300	5.088106	15.264318	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	422	1.85e-113	NTclustered	gi\|2874253690\|emb\|OY969416.1\|	412056	g15621	i0	92.308	123.27	299	19	99	2	1	297	1317486	1317782	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04967.bin.1.157 genome assembly, chromosome: 1	blastn	36981	422	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
2477402	2477402	PRJNA753704_P_NODE_15562_length_304_cov_1.653680_g15201_i0	PRJNA753704	15562	304	1.65368	5.0271872	Verrucomicrobiota	74201	Bacteria	Bacteria	363	1.15e-95	NTclustered	gi\|183579829\|emb\|AM905426.1\|	320771	g15201	i0	88.235	75.8355263157895	306	32	100	4	1	304	1072	769	Bacterium Ellin514 23S rRNA gene, isolate Ellin514	blastn	23054	366	0.991803278688525	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Pedosphaerae	Pedosphaerales	Pedosphaeraceae	Pedosphaera	Pedosphaera parvula
3282246	3282246	PRJNA753704_P_NODE_11083_length_355_cov_3.127660_g10722_i0	PRJNA753704	11083	355	3.12766	11.103193	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	248	3.99e-61	NTclustered	gi\|2874253690\|emb\|OY969416.1\|	412056	g10722	i0	79.67	1.02535211267606	364	58	99	14	2	355	2924375	2924732	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04967.bin.1.157 genome assembly, chromosome: 1	blastn	364	248	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
3282295	3282295	PRJNA753704_P_NODE_15863_length_301_cov_5.995614_g15502_i0	PRJNA753704	15863	301	5.995614	18.04679814	Akkermansiaceae bacterium	2562705	Bacteria	Bacteria	235	2.59e-57	NTclustered	gi\|2022020957\|gb\|CP059069.1\|	2562705	g15502	i0	81.373	430.893687707641	306	41	99	11	2	301	3411371	3411076	Akkermansiaceae bacterium strain AJA081-3 chromosome, complete genome	blastn	129699	235	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Akkermansiaceae		Akkermansiaceae bacterium
4559457	4559457	PRJNA753704_P_NODE_1924_length_786_cov_2.035063_g1597_i0	PRJNA753704	1924	786	2.035063	15.99559518	Opitutales bacterium	2026772	Bacteria	Bacteria	797	0	NTclustered	gi\|2814788334\|emb\|OY762281.2\|	2026772	g1597	i0	85.733	236.450381679389	764	97	97	9	28	786	978097	977341	MAG: Opitutales bacterium isolate 685e4509-010e-4797-9872-a51ee4494a19 genome assembly, chromosome: 1	blastn	185850	797	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales			Opitutales bacterium
4559655	4559655	PRJNA753704_P_NODE_824_length_1175_cov_19.828494_g595_i0	PRJNA753704	824	1175	19.828494	232.9848045	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	1650	0	NTclustered	gi\|2874253690\|emb\|OY969416.1\|	412056	g595	i0	92.027	214.738723404255	1179	86	100	6	1	1175	1316107	1314933	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04967.bin.1.157 genome assembly, chromosome: 1	blastn	252318	1650	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
5030398	5030398	PRJNA753704_P_NODE_4864_length_514_cov_6.065760_g4504_i0	PRJNA753704	4864	514	6.06576	31.1780064	Fontisphaera	3050007	Bacteria	Bacteria	643	6.529999999999998e-180	NTclustered	gi\|2621704341\|emb\|OY760937.1\|	2499141	g4504	i0	89.3	104.20233463035	514	54	100	1	1	514	3991560	3992072	MAG: Verrucomicrobiae bacterium isolate 066a7682-a1ac-48de-8761-1470dc9e5c3e genome assembly, chromosome: 1	blastn	53560	643	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				Verrucomicrobiia bacterium
5834638	5834638	PRJNA753704_P_NODE_21445_length_263_cov_2.821053_g21084_i0	PRJNA753704	21445	263	2.821053	7.41936939	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	281	2.81e-71	NTclustered	gi\|2874253690\|emb\|OY969416.1\|	412056	g21084	i0	87.149	0.946768060836502	249	30	94	2	17	263	680147	679899	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04967.bin.1.157 genome assembly, chromosome: 1	blastn	249	281	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
5834663	5834663	PRJNA753704_P_NODE_23205_length_254_cov_1.502762_g22844_i0	PRJNA753704	23205	254	1.502762	3.81701548	Fontisphaera persica	2974023	Bacteria	Bacteria	148	2.86e-31	NTclustered	gi\|2439237958\|gb\|CP116615.1\|	2974023	g22844	i0	78.03	19.8346456692913	264	38	100	15	1	254	4468761	4469014	Fontisphaera persica strain B-154 chromosome, complete genome	blastn	5038	148	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Limisphaerales	Fontisphaeraceae	Fontisphaera	Fontisphaera persica
5834761	5834761	PRJNA753704_P_NODE_4065_length_556_cov_5.424431_g3706_i0	PRJNA753704	4065	556	5.424431	30.15983636	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	869	0	NTclustered	gi\|2874254096\|emb\|OY970179.1\|	412056	g3706	i0	94.964	172.584532374101	556	24	100	2	1	556	557743	558294	MAG: uncultured Verrucomicrobiae bacterium isolate MFD05521.bin.c.1 genome assembly, chromosome: 1	blastn	95957	869	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
8384252	8384252	PRJNA753704_P_NODE_13967_length_319_cov_3.105691_g13606_i0	PRJNA753704	13967	319	3.105691	9.90715429	Fontisphaera persica	2974023	Bacteria	Bacteria	139	2.23e-28	NTclustered	gi\|2439237958\|gb\|CP116615.1\|	2974023	g13606	i0	80.978	0.576802507836991	184	27	56	8	1	180	3045937	3045758	Fontisphaera persica strain B-154 chromosome, complete genome	blastn	184	139	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Limisphaerales	Fontisphaeraceae	Fontisphaera	Fontisphaera persica
8384397	8384397	PRJNA753704_P_NODE_25887_length_247_cov_3.293103_g25526_i0	PRJNA753704	25887	247	3.293103	8.13396441	Horticoccus luteus	2862869	Bacteria	Bacteria	248	2.65e-61	NTclustered	gi\|2077391884\|gb\|CP080507.1\|	2862869	g25526	i0	84.921	2.04048582995951	252	30	100	6	1	247	2448363	2448611	Horticoccus luteus strain KSB-15 chromosome, complete genome	blastn	504	248	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Horticoccus	Horticoccus luteus
10935202	10935202	PRJNA753704_P_NODE_5449_length_488_cov_3.708434_g5088_i0	PRJNA753704	5449	488	3.708434	18.09715792	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	453	1.12e-122	NTclustered	gi\|2874254096\|emb\|OY970179.1\|	412056	g5088	i0	83.707	143.282786885246	491	69	100	8	1	488	1727274	1727756	MAG: uncultured Verrucomicrobiae bacterium isolate MFD05521.bin.c.1 genome assembly, chromosome: 1	blastn	69922	453	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
12210658	12210658	PRJNA753704_P_NODE_370_length_1650_cov_13.802790_g242_i0	PRJNA753704	370	1650	13.80279	227.746035	Pedosphaera parvula	1032527	Bacteria	Bacteria	1803	0	NTclustered	gi\|183579829\|emb\|AM905426.1\|	320771	g242	i0	86.448	231.107878787879	1675	192	100	24	1	1650	1668	4	Bacterium Ellin514 23S rRNA gene, isolate Ellin514	blastn	381328	1803	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Pedosphaerae	Pedosphaerales	Pedosphaeraceae	Pedosphaera	Pedosphaera parvula
12210703	12210703	PRJNA753704_P_NODE_8070_length_410_cov_1.851632_g7709_i0	PRJNA753704	8070	410	1.851632	7.5916912	Horticoccus luteus	2862869	Bacteria	Bacteria	619	8.61e-173	NTclustered	gi\|2077391884\|gb\|CP080507.1\|	2862869	g7709	i0	93.902	106.936585365854	410	25	100	0	1	410	539571	539980	Horticoccus luteus strain KSB-15 chromosome, complete genome	blastn	43844	619	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Horticoccus	Horticoccus luteus
13484803	13484803	PRJNA753704_P_NODE_18291_length_282_cov_12.966507_g17930_i0	PRJNA753704	18291	282	12.966507	36.56554974	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	241	5.17e-59	NTclustered	gi\|2874254065\|emb\|OY970130.1\|	412056	g17930	i0	82.517	1.8936170212766	286	39	100	10	1	282	1683029	1683307	MAG: uncultured Verrucomicrobiae bacterium isolate MFD05705.bin.c.1 genome assembly, chromosome: 1	blastn	534	241	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
14760006	14760006	PRJNA753704_P_NODE_2392_length_707_cov_2.812303_g2053_i0	PRJNA753704	2392	707	2.812303	19.88298221	Opitutus sp. VeGlc2	134634	Bacteria	Bacteria	1033	0	NTclustered	gi\|164510706\|emb\|AJ966885.1\|	134634	g2053	i0	93.108	79.6562942008487	711	39	99	8	3	707	2586	1880	Opitutus sp. VeGlc2 16S rRNA gene (partial), 23S rRNA gene, tRNA-Ala gene, tRNA-Ile gene, ITS1 and ITS2, strain DSM 11246	blastn	56317	1033	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Opitutus	Opitutus sp. VeGlc2
16504981	16504981	PRJNA753704_P_NODE_2453_length_701_cov_2.759554_g2113_i0	PRJNA753704	2453	701	2.759554	19.34447354	Verrucomicrobiota	74201	Bacteria	Bacteria	488	4.4999999999999985e-133	NTclustered	gi\|183579829\|emb\|AM905426.1\|	320771	g2113	i0	79.466	97.9472182596291	711	128	100	16	1	701	721	19	Bacterium Ellin514 23S rRNA gene, isolate Ellin514	blastn	68661	488	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Pedosphaerae	Pedosphaerales	Pedosphaeraceae	Pedosphaera	Pedosphaera parvula
18583021	18583021	PRJNA753704_P_NODE_375_length_1641_cov_9.331633_g246_i0	PRJNA753704	375	1641	9.331633	153.13209753	Fontisphaera persica	2974023	Bacteria	Bacteria	1345	0	NTclustered	gi\|2439237958\|gb\|CP116615.1\|	2974023	g246	i0	81.65	172.392443631932	1673	260	100	37	1	1641	3862696	3861039	Fontisphaera persica strain B-154 chromosome, complete genome	blastn	282896	1345	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Limisphaerales	Fontisphaeraceae	Fontisphaera	Fontisphaera persica
21133646	21133646	PRJNA753704_P_NODE_25877_length_247_cov_3.885057_g25516_i0	PRJNA753704	25877	247	3.885057	9.59609079	Luteolibacter sp. Populi	3230487	Bacteria	Bacteria	231	2.6699999999999997e-56	NTclustered	gi\|2774618348\|gb\|CP161812.1\|	3230487	g25516	i0	88.83	263.939271255061	188	21	76	0	2	189	3261597	3261410	Luteolibacter sp. Populi chromosome, complete genome	blastn	65193	231	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter sp. Populi
21133760	21133760	PRJNA753704_P_NODE_8137_length_408_cov_5.205970_g7776_i0	PRJNA753704	8137	408	5.20597	21.2403576	uncultured Verrucomicrobiota bacterium	156588	Bacteria	Bacteria	279	1.65e-70	NTclustered	gi\|110753282\|gb\|DQ827969.1\|	156588	g7776	i0	84.106	71.6936274509804	302	35	73	11	1	296	295	1	Uncultured Verrucomicrobia bacterium clone DOK_BIODYN_clone279 16S ribosomal RNA gene, partial sequence	blastn	29251	279	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					uncultured Verrucomicrobiota bacterium
23684003	23684003	PRJNA753704_P_NODE_17159_length_291_cov_1.018349_g16798_i0	PRJNA753704	17159	291	1.018349	2.96339559	Opitutus terrae	107709	Bacteria	Bacteria	322	1.86e-83	NTclustered	gi\|177839040\|gb\|CP001032.1\|	452637	g16798	i0	88.043	2.94158075601375	276	28	95	4	1	275	4393426	4393697	Opitutus terrae PB90-1, complete genome	blastn	856	322	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Opitutus	Opitutus terrae
23684190	23684190	PRJNA753704_P_NODE_659_length_1290_cov_7.337716_g462_i0	PRJNA753704	659	1290	7.337716	94.6565364	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	957	0	NTclustered	gi\|2874254065\|emb\|OY970130.1\|	412056	g462	i0	80.526	76.7069767441861	1294	213	98	31	1	1268	5153590	5152310	MAG: uncultured Verrucomicrobiae bacterium isolate MFD05705.bin.c.1 genome assembly, chromosome: 1	blastn	98952	957	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
24957500	24957500	PRJNA753704_P_NODE_13980_length_319_cov_2.528455_g13619_i0	PRJNA753704	13980	319	2.528455	8.06577145	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	281	3.5000000000000007e-71	NTclustered	gi\|2874253690\|emb\|OY969416.1\|	412056	g13619	i0	82.675	2.7115987460815	329	45	100	11	1	319	2925045	2924719	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04967.bin.1.157 genome assembly, chromosome: 1	blastn	865	281	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae 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);;