metadata: contig_metadata: 19 rows where analysis = "blastn", bioproject = "PRJNA690592" and tax

19 rows where analysis = "blastn", bioproject = "PRJNA690592" 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
672103	672103	PRJNA690592_S_NODE_89701_length_342_cov_1.732342_g88687_i0	PRJNA690592	89701	342	1.732342	5.92460964	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	477	4.499999999999998e-130	NTclustered	gi\|2874254096\|emb\|OY970179.1\|	412056	g88687	i0	91.86	184.938596491228	344	25	100	3	1	342	1726797	1727139	MAG: uncultured Verrucomicrobiae bacterium isolate MFD05521.bin.c.1 genome assembly, chromosome: 1	blastn	63249	477	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
4498762	4498762	PRJNA690592_S_NODE_101224_length_326_cov_1.371542_g100210_i0	PRJNA690592	101224	326	1.371542	4.47122692	uncultured Planctomycetaceae bacterium	100233	Bacteria	Bacteria	54.7	0.009	NTclustered	gi\|2874254106\|emb\|OY970189.1\|	100233	g100210	i0	96.875	0.098159509202454	32	1	10	0	100	131	1498363	1498332	MAG: uncultured Planctomycetaceae bacterium isolate MFD09603.bin.2.127 genome assembly, chromosome: 1	blastn	32	54.7	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		uncultured Planctomycetaceae bacterium
5775027	5775027	PRJNA690592_S_NODE_206325_length_244_cov_0.929825_g205311_i0	PRJNA690592	206325	244	0.929825	2.268773	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	374	4.1399999999999986e-99	NTclustered	gi\|2874254096\|emb\|OY970179.1\|	412056	g205311	i0	94.309	181.975409836066	246	11	100	3	1	244	1726884	1727128	MAG: uncultured Verrucomicrobiae bacterium isolate MFD05521.bin.c.1 genome assembly, chromosome: 1	blastn	44402	374	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
5775306	5775306	PRJNA690592_S_NODE_41745_length_475_cov_2.838308_g40731_i0	PRJNA690592	41745	475	2.838308	13.481963	Planctomycetales bacterium ZRK34	2723666	Bacteria	Bacteria	54.7	0.013	NTclustered	gi\|1898316769\|gb\|CP050848.1\|	2723666	g40731	i0	100	0.0610526315789474	29	0	6	0	270	298	2922813	2922785	Planctomycetales bacterium ZRK34 chromosome, complete genome	blastn	29	54.7	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales			Planctomycetales bacterium ZRK34
7050495	7050495	PRJNA690592_S_NODE_57366_length_414_cov_1.841642_g56352_i0	PRJNA690592	57366	414	1.841642	7.62439788	uncultured Gemmataceae bacterium	1914239	Bacteria	Bacteria	527	5.419999999999999e-145	NTclustered	gi\|2874253853\|emb\|OY969909.1\|	1914239	g56352	i0	89.688	182.93961352657	417	38	100	4	1	414	2002311	2001897	MAG: uncultured Gemmataceae bacterium isolate MFD01275.bin.c.1 genome assembly, chromosome: 1	blastn	75737	527	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
7050726	7050726	PRJNA690592_S_NODE_90806_length_340_cov_2.831461_g89792_i0	PRJNA690592	90806	340	2.831461	9.6269674	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	172	2.36e-38	NTclustered	gi\|2874253952\|emb\|OY970277.1\|	412056	g89792	i0	78.519	51.25	270	52	79	6	11	277	3078634	3078900	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04580.bin.1.45 genome assembly, chromosome: 1	blastn	17425	172	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
10876053	10876053	PRJNA690592_S_NODE_76249_length_366_cov_3.139932_g75235_i0	PRJNA690592	76249	366	3.139932	11.49215112	Schlesneria sphaerica	3373610	Bacteria	Bacteria	60.2	2.08e-4	NTclustered	gi\|2844279856\|gb\|CP172346.1\|	3373610	g75235	i0	94.872	0.10655737704918	39	0	11	2	302	340	6286491	6286527	Schlesneria sp. T3-172 chromosome, complete genome	blastn	39	60.2	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Schlesneria	Schlesneria sphaerica
13425554	13425554	PRJNA690592_S_NODE_39411_length_488_cov_1.296386_g38399_i0	PRJNA690592	39411	488	1.296386	6.32636368	Chlamydiales bacterium CRIB33	553509	Bacteria	Bacteria	739	0	NTclustered	gi\|196051292\|gb\|EU683887.1\|	553509	g38399	i0	94.07	110.665983606557	489	26	100	3	1	488	21	507	Chlamydiales bacterium CRIB33 16S ribosomal RNA gene, partial sequence	blastn	54005	739	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales			Chlamydiales bacterium CRIB33
13932899	13932899	PRJNA690592_S_NODE_134911_length_290_cov_1.064516_g133897_i0	PRJNA690592	134911	290	1.064516	3.0870964	Verrucomicrobiales	48461	Bacteria	Bacteria	204	7.01e-48	NTclustered	gi\|1815841271\|gb\|CP049143.1\|	2711231	g133897	i0	82.684	233.772413793103	231	39	79	1	5	234	5626819	5627049	Roseimicrobium sp. ORNL1 chromosome, complete genome	blastn	67794	204	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Roseimicrobium	Roseimicrobium sp. ORNL1
14699744	14699744	PRJNA690592_S_NODE_119512_length_305_cov_1.060345_g118498_i0	PRJNA690592	119512	305	1.060345	3.23405225	Verrucomicrobium spinosum	2736	Bacteria	Bacteria	303	7.11e-78	NTclustered	gi\|12583973\|gb\|AF245377.1\|	240016	g118498	i0	90.749	208.639344262295	227	21	74	0	1	227	941	715	Verrucomicrobium spinosum 23S ribosomal RNA gene, partial sequence	blastn	63635	303	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Verrucomicrobium	Verrucomicrobium spinosum
18523030	18523030	PRJNA690592_S_NODE_147735_length_279_cov_1.121359_g146721_i0	PRJNA690592	147735	279	1.121359	3.12859161	Prosthecobacter debontii	48467	Bacteria	Bacteria	366	8.08e-97	NTclustered	gi\|164510703\|emb\|AJ966882.1\|	48467	g146721	i0	96	224.58064516129	225	9	81	0	55	279	4243	4467	Prosthecobacter debontii 16S rRNA gene (partial), 23S rRNA gene (partial), tRNA-Ala gene, tRNA-Ile gene and ITS1, strain DSM 14044	blastn	62658	366	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Prosthecobacter	Prosthecobacter debontii
18523964	18523964	PRJNA690592_S_NODE_7255_length_1037_cov_3.536307_g6632_i0	PRJNA690592	7255	1037	3.536307	36.67150359	Akkermansia muciniphila	239935	Bacteria	Bacteria	58.4	0.002	NTclustered	gi\|1888387165\|gb\|CP058562.1\|	239935	g6632	i0	97.059	1.14850530376085	34	1	3	0	135	168	1958297	1958264	Akkermansia muciniphila strain AK32 chromosome, complete genome	blastn	1191	58.4	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Akkermansiaceae	Akkermansia	Akkermansia muciniphila
19798029	19798029	PRJNA690592_S_NODE_159836_length_269_cov_1.571429_g158822_i0	PRJNA690592	159836	269	1.571429	4.22714401	uncultured Chlamydiales bacterium	174324	Bacteria	Bacteria	54.7	0.007	NTclustered	gi\|2874253712\|emb\|OY969554.1\|	174324	g158822	i0	100	0.107806691449814	29	0	11	0	183	211	822741	822713	MAG: uncultured Chlamydiales bacterium isolate MFD04540.bin.c.3 genome assembly, chromosome: 1	blastn	29	54.7	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales			uncultured Chlamydiales bacterium
19798138	19798138	PRJNA690592_S_NODE_176116_length_257_cov_1.847826_g175102_i0	PRJNA690592	176116	257	1.847826	4.74891282	uncultured Gemmataceae bacterium	1914239	Bacteria	Bacteria	289	1.64e-73	NTclustered	gi\|2874253853\|emb\|OY969909.1\|	1914239	g175102	i0	88.655	147.988326848249	238	26	93	1	1	238	2001635	2001871	MAG: uncultured Gemmataceae bacterium isolate MFD01275.bin.c.1 genome assembly, chromosome: 1	blastn	38033	289	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
22349227	22349227	PRJNA690592_S_NODE_62898_length_398_cov_1.418462_g61884_i0	PRJNA690592	62898	398	1.418462	5.64547876	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	558	1.84e-154	NTclustered	gi\|2874254096\|emb\|OY970179.1\|	412056	g61884	i0	92	112.379396984925	400	28	100	4	1	398	1728429	1728826	MAG: uncultured Verrucomicrobiae bacterium isolate MFD05521.bin.c.1 genome assembly, chromosome: 1	blastn	44727	558	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
24130851	24130851	PRJNA690592_S_NODE_14719_length_767_cov_1.717579_g13835_i0	PRJNA690592	14719	767	1.717579	13.17383093	Engelhardtia	139931	Bacteria	Bacteria	54.7	0.021	NTclustered	gi\|1712638177\|gb\|CP036287.1\|	2528011	g13835	i0	100	0.075619295958279	29	0	4	0	132	160	304603	304575	Planctomycetes bacterium Pla133 chromosome, complete genome	blastn	58	54.7	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia			Engelhardtia	Engelhardtia mirabilis
24897515	24897515	PRJNA690592_S_NODE_185360_length_251_cov_1.556180_g184346_i0	PRJNA690592	185360	251	1.55618	3.9060118	Lacipirellula parvula	2650471	Bacteria	Bacteria	122	1.7099999999999998e-23	NTclustered	gi\|1761017769\|dbj\|AP021861.1\|	2650471	g184346	i0	83.969	7.1394422310757	131	17	51	3	123	251	2454744	2454616	Lacipirellula parvula PX69 DNA, complete genome	blastn	1792	122	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Lacipirellulaceae	Lacipirellula	Lacipirellula parvula
24898438	24898438	PRJNA690592_S_NODE_97620_length_331_cov_1.069767_g96606_i0	PRJNA690592	97620	331	1.069767	3.54092877	Isosphaera pallida	128	Bacteria	Bacteria	65.8	4e-6	NTclustered	gi\|319748837\|gb\|CP002353.1\|	575540	g96606	i0	91.489	1.62235649546828	47	4	14	0	129	175	1374069	1374115	Isosphaera pallida ATCC 43644, complete genome	blastn	537	65.8	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae	Isosphaera	Isosphaera pallida
25405420	25405420	PRJNA690592_S_NODE_143700_length_282_cov_1.473684_g142686_i0	PRJNA690592	143700	282	1.473684	4.15578888	Fontisphaera	3050007	Bacteria	Bacteria	309	1.4e-79	NTclustered	gi\|2621704341\|emb\|OY760937.1\|	2499141	g142686	i0	86.572	76.2198581560284	283	35	100	3	1	282	3991663	3991943	MAG: Verrucomicrobiae bacterium isolate 066a7682-a1ac-48de-8761-1470dc9e5c3e genome assembly, chromosome: 1	blastn	21494	309	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				Verrucomicrobiia 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);;