metadata: contig_metadata: 22 rows where analysis = "blastn", bioproject = "PRJNA695140" and tax

22 rows where analysis = "blastn", bioproject = "PRJNA695140" 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
676068	676068	PRJNA695140_S_NODE_11341_length_159_cov_3.762295_g11160_i0	PRJNA695140	11341	159	3.762295	5.98204905	Pedosphaera parvula	1032527	Bacteria	Bacteria	220	3.4099999999999998e-53	NTclustered	gi\|183579829\|emb\|AM905426.1\|	320771	g11160	i0	91.824	109.849056603774	159	11	99	2	2	159	1802	1645	Bacterium Ellin514 23S rRNA gene, isolate Ellin514	blastn	17466	220	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Pedosphaerae	Pedosphaerales	Pedosphaeraceae	Pedosphaera	Pedosphaera parvula
1952113	1952113	PRJNA695140_S_NODE_7902_length_188_cov_1.807947_g7721_i0	PRJNA695140	7902	188	1.807947	3.39894036	uncultured Gemmataceae bacterium	1914239	Bacteria	Bacteria	235	1.49e-57	NTclustered	gi\|2874253749\|emb\|OY969623.1\|	1914239	g7721	i0	89.418	2.01595744680851	189	17	99	3	2	188	7050744	7050557	MAG: uncultured Gemmataceae bacterium isolate MFD06742.bin.c.1 genome assembly, chromosome: 1	blastn	379	235	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
3227028	3227028	PRJNA695140_S_NODE_11263_length_160_cov_1.577236_g11082_i0	PRJNA695140	11263	160	1.577236	2.5235776	Luteolibacter sp. LG18	2819286	Bacteria	Bacteria	217	4.45e-52	NTclustered	gi\|2585939279\|dbj\|AP024600.1\|	2819286	g11082	i0	91.25	17.00625	160	13	100	1	1	160	2218397	2218555	Luteolibacter sp. LG18 DNA, complete genome	blastn	2721	217	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter sp. LG18
4504088	4504088	PRJNA695140_S_NODE_10284_length_166_cov_3.007752_g10103_i0	PRJNA695140	10284	166	3.007752	4.99286832	Fontisphaera persica	2974023	Bacteria	Bacteria	263	5.9e-66	NTclustered	gi\|2439237958\|gb\|CP116615.1\|	2974023	g10103	i0	95.181	188.542168674699	166	8	100	0	1	166	3861794	3861959	Fontisphaera persica strain B-154 chromosome, complete genome	blastn	31298	263	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Limisphaerales	Fontisphaeraceae	Fontisphaera	Fontisphaera persica
5779648	5779648	PRJNA695140_S_NODE_8265_length_184_cov_1.802721_g8084_i0	PRJNA695140	8265	184	1.802721	3.31700664	Lacunisphaera limnophila	1838286	Bacteria	Bacteria	171	4.15e-38	NTclustered	gi\|1070531674\|gb\|CP016094.1\|	1838286	g8084	i0	85.057	60.4021739130435	174	18	93	7	7	178	2014843	2014676	Lacunisphaera limnophila strain IG16b, complete genome	blastn	11114	171	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Lacunisphaera	Lacunisphaera limnophila
7054695	7054695	PRJNA695140_S_NODE_2666_length_320_cov_2.607774_g2485_i0	PRJNA695140	2666	320	2.607774	8.3448768	Luteolibacter luteus	2728835	Bacteria	Bacteria	340	5.719999999999999e-89	NTclustered	gi\|1835317346\|gb\|CP051774.1\|	2728835	g2485	i0	90.98	260.0125	255	19	79	4	66	318	3804531	3804279	Luteolibacter luteus strain G-1-1-1 chromosome, complete genome	blastn	83204	340	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter luteus
7559398	7559398	PRJNA695140_S_NODE_12346_length_154_cov_2.119658_g12165_i0	PRJNA695140	12346	154	2.119658	3.26427332	Waddlia	71666	Bacteria	Bacteria	193	7.14e-45	NTclustered	gi\|297375547\|gb\|CP001928.1\|	716544	g12165	i0	89.61	124.116883116883	154	12	99	4	1	152	1838894	1838743	Waddlia chondrophila WSU 86-1044, complete genome	blastn	19114	193	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Waddliaceae	Waddlia	Waddlia chondrophila
8329196	8329196	PRJNA695140_S_NODE_11427_length_159_cov_1.795082_g11246_i0	PRJNA695140	11427	159	1.795082	2.85418038	Luteolibacter sp.	1962973	Bacteria	Bacteria	183	4.469999999999999e-42	NTclustered	gi\|2836248208\|gb\|CP121322.1\|	1962973	g11246	i0	87.421	9.0440251572327	159	20	100	0	1	159	1010278	1010436	MAG: Luteolibacter sp. isolate NCC532_bact_1514 chromosome, complete genome	blastn	1438	183	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter sp.
8329229	8329229	PRJNA695140_S_NODE_2967_length_304_cov_3.149813_g2786_i0	PRJNA695140	2967	304	3.149813	9.57543152	Fuerstiella marisgermanici	1891926	Bacteria	Bacteria	278	4.2900000000000005e-70	NTclustered	gi\|1140105870\|gb\|CP017641.1\|	1891926	g2786	i0	89.189	89.0394736842105	222	24	73	0	1	222	5363175	5363396	Fuerstiella marisgermanici strain NH11 chromosome, complete genome	blastn	27068	278	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Fuerstiella	Fuerstiella marisgermanici
8329261	8329261	PRJNA695140_S_NODE_6267_length_210_cov_2.063584_g6086_i0	PRJNA695140	6267	210	2.063584	4.3335264	Fontisphaera persica	2974023	Bacteria	Bacteria	263	7.82e-66	NTclustered	gi\|2439237958\|gb\|CP116615.1\|	2974023	g6086	i0	89.756	83.1619047619048	205	21	98	0	6	210	3863230	3863026	Fontisphaera persica strain B-154 chromosome, complete genome	blastn	17464	263	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Limisphaerales	Fontisphaeraceae	Fontisphaera	Fontisphaera persica
9604623	9604623	PRJNA695140_S_NODE_8668_length_180_cov_1.867133_g8487_i0	PRJNA695140	8668	180	1.867133	3.3608394	uncultured Planctomycetaceae bacterium	100233	Bacteria	Bacteria	204	3.98e-48	NTclustered	gi\|2874253903\|emb\|OY970228.1\|	100233	g8487	i0	87.571	109.605555555556	177	21	98	1	1	177	2663825	2664000	MAG: uncultured Planctomycetaceae bacterium isolate MFD00731.bin.c.1 genome assembly, chromosome: 1	blastn	19729	204	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		uncultured Planctomycetaceae bacterium
11385057	11385057	PRJNA695140_S_NODE_1889_length_384_cov_1.930836_g1708_i0	PRJNA695140	1889	384	1.930836	7.41441024	Gimesia	1649453	Bacteria	Bacteria	363	1.49e-95	NTclustered	gi\|1712472787\|gb\|CP036266.1\|	2605989	g1708	i0	87.5	104.807291666667	320	32	83	8	66	382	2180318	2180004	Gimesia chilikensis strain HG66A1 chromosome	blastn	40246	363	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Gimesia	Gimesia chilikensis
11385111	11385111	PRJNA695140_S_NODE_7709_length_190_cov_2.281046_g7528_i0	PRJNA695140	7709	190	2.281046	4.3339874	Parachlamydia	83551	Bacteria	Bacteria	158	3.36e-34	NTclustered	gi\|470491594\|ref\|NR_077046.1\|	83552	g7528	i0	82.292	19.1947368421053	192	25	99	7	3	190	1538	1724	Parachlamydia acanthamoebae strain UV-7 23S ribosomal RNA gene, complete sequence	blastn	3647	158	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Parachlamydia	Parachlamydia acanthamoebae
12155218	12155218	PRJNA695140_S_NODE_1070_length_517_cov_1.752083_g893_i0	PRJNA695140	1070	517	1.752083	9.05826911	uncultured Gemmataceae bacterium	1914239	Bacteria	Bacteria	664	0	NTclustered	gi\|2874253749\|emb\|OY969623.1\|	1914239	g893	i0	89.792	280.976789168279	529	38	99	12	1	516	7051128	7050603	MAG: uncultured Gemmataceae bacterium isolate MFD06742.bin.c.1 genome assembly, chromosome: 1	blastn	145265	664	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
12660928	12660928	PRJNA695140_S_NODE_2490_length_331_cov_4.329932_g2309_i0	PRJNA695140	2490	331	4.329932	14.33207492	Oleiharenicola	2100741	Bacteria	Bacteria	62.1	5.18e-5	NTclustered	gi\|2707273910\|gb\|CP149973.1\|	3034326	g2309	i0	95	1.53474320241692	40	1	12	1	282	321	459931	459893	Opitutia bacterium KCR 482 chromosome, complete genome	blastn	508	62.1	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia				Opitutia bacterium KCR 482
13935502	13935502	PRJNA695140_S_NODE_2251_length_348_cov_56.128617_g2070_i0	PRJNA695140	2251	348	56.128617	195.32758716	Pseudomonadati	3379134	Bacteria	Bacteria	527	4.489999999999998e-145	NTclustered	gi\|470491594\|ref\|NR_077046.1\|	83552	g2070	i0	94.203	158.991379310345	345	20	99	0	4	348	2281	2625	Parachlamydia acanthamoebae strain UV-7 23S ribosomal RNA gene, complete sequence	blastn	55329	527	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Parachlamydia	Parachlamydia acanthamoebae
15978773	15978773	PRJNA695140_S_NODE_113_length_1975_cov_50.620743_g35_i0	PRJNA695140	113	1975	50.620743	999.75967425	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	2833	0	NTclustered	gi\|2874254096\|emb\|OY970179.1\|	412056	g35	i0	92.63	132.66582278481	1981	128	100	14	1	1975	1727236	1729204	MAG: uncultured Verrucomicrobiae bacterium isolate MFD05521.bin.c.1 genome assembly, chromosome: 1	blastn	262015	2833	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
19802925	19802925	PRJNA695140_S_NODE_1316_length_466_cov_3.559441_g1137_i0	PRJNA695140	1316	466	3.559441	16.58699506	Fuerstiella marisgermanici	1891926	Bacteria	Bacteria	560	6.08e-155	NTclustered	gi\|1140105870\|gb\|CP017641.1\|	1891926	g1137	i0	89.135	129.637339055794	451	47	97	2	2	451	5362813	5362364	Fuerstiella marisgermanici strain NH11 chromosome, complete genome	blastn	60411	560	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Fuerstiella	Fuerstiella marisgermanici
21583787	21583787	PRJNA695140_S_NODE_1777_length_396_cov_43.370474_g1596_i0	PRJNA695140	1777	396	43.370474	171.74707704	Candidatus Rhabdochlamydia	292833	Bacteria	Bacteria	643	4.919999999999999e-180	NTclustered	gi\|2082223669\|gb\|CP075585.1\|	225148	g1596	i0	95.96	165.457070707071	396	16	100	0	1	396	1018382	1017987	Candidatus Rhabdochlamydia porcellionis strain 15C chromosome, complete genome	blastn	65521	643	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Candidatus Rhabdochlamydiaceae	Candidatus Rhabdochlamydia	Candidatus Rhabdochlamydia porcellionis
23628806	23628806	PRJNA695140_S_NODE_1719_length_403_cov_4.928962_g1538_i0	PRJNA695140	1719	403	4.928962	19.86371686	Fontisphaera persica	2974023	Bacteria	Bacteria	333	1.23e-86	NTclustered	gi\|2439237958\|gb\|CP116615.1\|	2974023	g1538	i0	85.03	40.560794044665	334	43	82	7	74	403	3862491	3862161	Fontisphaera persica strain B-154 chromosome, complete genome	blastn	16346	333	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Limisphaerales	Fontisphaeraceae	Fontisphaera	Fontisphaera persica
23628820	23628820	PRJNA695140_S_NODE_2739_length_315_cov_8.935252_g2558_i0	PRJNA695140	2739	315	8.935252	28.1460438	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	272	2.0799999999999998e-68	NTclustered	gi\|2874254040\|emb\|OY970364.1\|	412056	g2558	i0	82.39	10.1365079365079	318	51	100	5	1	315	952605	952290	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04463.bin.c.15 genome assembly, chromosome: 1	blastn	3193	272	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
25408027	25408027	PRJNA695140_S_NODE_13200_length_150_cov_2.141593_g13019_i0	PRJNA695140	13200	150	2.141593	3.2123895	Planctomycetia	203683	Bacteria	Bacteria	135	1.18e-27	NTclustered	gi\|2874253749\|emb\|OY969623.1\|	1914239	g13019	i0	94.318	71.9666666666667	88	5	59	0	1	88	7051883	7051796	MAG: uncultured Gemmataceae bacterium isolate MFD06742.bin.c.1 genome assembly, chromosome: 1	blastn	10795	135	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae 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);;