metadata: contig_metadata: 20 rows where analysis = "blastn", bioproject = "PRJNA561212" and tax

20 rows where analysis = "blastn", bioproject = "PRJNA561212" 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
545354	545354	PRJNA561212_P_NODE_21541_length_250_cov_6.966102_g21330_i0	PRJNA561212	21541	250	6.966102	17.415255	Anatilimnocola aggregata	2528021	Bacteria	Bacteria	296	9.47e-76	NTclustered	gi\|1712591889\|gb\|CP036274.1\|	2528021	g21330	i0	89.655	19.424	232	24	93	0	10	241	7630835	7631066	Anatilimnocola aggregata strain ETA_A8 chromosome, complete genome	blastn	4856	296	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Anatilimnocola	Anatilimnocola aggregata
1130752	1130752	PRJNA561212_P_NODE_23241_length_247_cov_0.896552_g23030_i0	PRJNA561212	23241	247	0.896552	2.21448344	Botrimarina	2795782	Bacteria	Bacteria	95.3	3.66e-15	NTclustered	gi\|1712768844\|gb\|CP036350.1\|	2527962	g23030	i0	96.491	20.587044534413	57	2	34	0	10	66	4246291	4246235	Planctomycetes bacterium K2D chromosome, complete genome	blastn	5085	95.3	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetes bacterium K2D
1820964	1820964	PRJNA561212_P_NODE_14702_length_292_cov_1.977169_g14491_i0	PRJNA561212	14702	292	1.977169	5.77333348	uncultured Gemmataceae bacterium	1914239	Bacteria	Bacteria	329	1.12e-85	NTclustered	gi\|2874253749\|emb\|OY969623.1\|	1914239	g14491	i0	88.603	164.352739726027	272	29	92	2	8	277	7050231	7050502	MAG: uncultured Gemmataceae bacterium isolate MFD06742.bin.c.1 genome assembly, chromosome: 1	blastn	47991	329	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
3096532	3096532	PRJNA561212_P_NODE_9643_length_355_cov_0.872340_g9432_i0	PRJNA561212	9643	355	0.87234	3.096807	uncultured Parachlamydiaceae bacterium	464461	Bacteria	Bacteria	555	2.0999999999999995e-153	NTclustered	gi\|2874253811\|emb\|OY969795.1\|	464461	g9432	i0	95.665	107.729577464789	346	14	97	1	10	355	655845	656189	MAG: uncultured Parachlamydiaceae bacterium isolate MFD05502.bin.c.3 genome assembly, chromosome: 1	blastn	38244	555	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae		uncultured Parachlamydiaceae bacterium
5649177	5649177	PRJNA561212_P_NODE_19045_length_261_cov_0.978723_g18834_i0	PRJNA561212	19045	261	0.978723	2.55446703	Phycisphaeraceae bacterium	2026777	Bacteria	Bacteria	418	2.0399999999999995e-112	NTclustered	gi\|2076441902\|gb\|CP075368.1\|	2026777	g18834	i0	97.541	165.486590038314	244	6	93	0	9	252	2582267	2582024	MAG: Phycisphaeraceae bacterium isolate ACE_PLA2 chromosome	blastn	43192	418	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales	Phycisphaeraceae		Phycisphaeraceae bacterium
6923628	6923628	PRJNA561212_P_NODE_9766_length_353_cov_1.125000_g9555_i0	PRJNA561212	9766	353	1.125	3.97125	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	344	4.92e-90	NTclustered	gi\|2874253779\|emb\|OY969763.1\|	412056	g9555	i0	85.671	75.371104815864	328	45	93	2	18	344	3832605	3832279	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04967.bin.c.2 genome assembly, chromosome: 1	blastn	26606	344	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
8198302	8198302	PRJNA561212_P_NODE_21207_length_251_cov_0.876404_g20996_i0	PRJNA561212	21207	251	0.876404	2.19977404	Fontisphaera persica	2974023	Bacteria	Bacteria	359	1.2e-94	NTclustered	gi\|2439237958\|gb\|CP116615.1\|	2974023	g20996	i0	94.421	140.247011952191	233	13	93	0	12	244	3863253	3863485	Fontisphaera persica strain B-154 chromosome, complete genome	blastn	35202	359	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Limisphaerales	Fontisphaeraceae	Fontisphaera	Fontisphaera persica
12024337	12024337	PRJNA561212_P_NODE_11810_length_323_cov_0.904000_g11599_i0	PRJNA561212	11810	323	0.904	2.91992	uncultured Parachlamydiaceae bacterium	464461	Bacteria	Bacteria	250	1e-61	NTclustered	gi\|2874253811\|emb\|OY969795.1\|	464461	g11599	i0	81.672	32.4953560371517	311	47	94	8	10	314	2059953	2060259	MAG: uncultured Parachlamydiaceae bacterium isolate MFD05502.bin.c.3 genome assembly, chromosome: 1	blastn	10496	250	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae		uncultured Parachlamydiaceae bacterium
12024349	12024349	PRJNA561212_P_NODE_12570_length_314_cov_1.228216_g12359_i0	PRJNA561212	12570	314	1.228216	3.85659824	Parachlamydiales bacterium	2052178	Bacteria	Bacteria	259	1.6100000000000002e-64	NTclustered	gi\|2874253843\|emb\|OY969899.1\|	2052178	g12359	i0	85	138.041401273885	260	34	82	5	12	269	2631817	2632073	MAG: Parachlamydiales bacterium isolate MFD00082.bin.c.1 genome assembly, chromosome: 1	blastn	43345	259	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales			Parachlamydiales bacterium
12024666	12024666	PRJNA561212_P_NODE_9630_length_355_cov_1.262411_g9419_i0	PRJNA561212	9630	355	1.262411	4.48155905	uncultured Parachlamydiaceae bacterium	464461	Bacteria	Bacteria	496	1.29e-135	NTclustered	gi\|2874253811\|emb\|OY969795.1\|	464461	g9419	i0	93.452	165.397183098592	336	19	94	3	9	343	654397	654730	MAG: uncultured Parachlamydiaceae bacterium isolate MFD05502.bin.c.3 genome assembly, chromosome: 1	blastn	58716	496	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae		uncultured Parachlamydiaceae bacterium
13884557	13884557	PRJNA561212_P_NODE_25031_length_244_cov_0.871345_g24820_i0	PRJNA561212	25031	244	0.871345	2.1260818	Pirellula	123	Bacteria	Bacteria	102	2.15e-17	NTclustered	gi\|470485626\|ref\|NR_076710.1\|	125	g24820	i0	78.659	27.2827868852459	164	28	67	4	55	217	1839	1682	Pirellula staleyi strain DSM 6068 23S ribosomal RNA gene, complete sequence	blastn	6657	102	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Pirellula	Pirellula staleyi
15158739	15158739	PRJNA561212_P_NODE_19632_length_256_cov_1.617486_g19421_i0	PRJNA561212	19632	256	1.617486	4.14076416	Phycisphaera	666508	Bacteria	Bacteria	202	2.1799999999999998e-47	NTclustered	gi\|470476024\|ref\|NR_076315.1\|	547188	g19421	i0	82.553	14.2578125	235	36	91	5	11	243	193	424	Phycisphaera mikurensis strain FYK2301M01 23S ribosomal RNA gene, complete sequence	blastn	3650	202	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales	Phycisphaeraceae	Phycisphaera	Phycisphaera mikurensis
15848122	15848122	PRJNA561212_P_NODE_12753_length_312_cov_1.230126_g12542_i0	PRJNA561212	12753	312	1.230126	3.83799312	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	359	1.5299999999999998e-94	NTclustered	gi\|2874253690\|emb\|OY969416.1\|	412056	g12542	i0	88.667	26.1185897435897	300	27	95	6	10	304	1316380	1316677	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04967.bin.1.157 genome assembly, chromosome: 1	blastn	8149	359	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
15848323	15848323	PRJNA561212_P_NODE_24873_length_244_cov_0.912281_g24662_i0	PRJNA561212	24873	244	0.912281	2.22596564	Planctopirus ephydatiae	2528019	Bacteria	Bacteria	189	1.6099999999999996e-43	NTclustered	gi\|1712709119\|gb\|CP036299.1\|	2528019	g24662	i0	81.545	331.040983606557	233	40	95	3	8	239	3939188	3939418	Planctopirus ephydatiae strain spb1 chromosome, complete genome	blastn	80774	189	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Planctopirus	Planctopirus ephydatiae
16433401	16433401	PRJNA561212_P_NODE_8493_length_377_cov_1.207237_g8282_i0	PRJNA561212	8493	377	1.207237	4.55128349	Waddlia	71666	Bacteria	Bacteria	276	1.96e-69	NTclustered	gi\|297375547\|gb\|CP001928.1\|	716544	g8282	i0	81.111	144.596816976127	360	55	94	11	14	368	1839144	1838793	Waddlia chondrophila WSU 86-1044, complete genome	blastn	54513	276	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Waddliaceae	Waddlia	Waddlia chondrophila
19671898	19671898	PRJNA561212_P_NODE_19636_length_256_cov_1.612022_g19425_i0	PRJNA561212	19636	256	1.612022	4.12677632	uncultured Parachlamydiaceae bacterium	464461	Bacteria	Bacteria	182	2.84e-41	NTclustered	gi\|2874253811\|emb\|OY969795.1\|	464461	g19425	i0	80.658	31.5234375	243	39	93	8	10	247	2058798	2059037	MAG: uncultured Parachlamydiaceae bacterium isolate MFD05502.bin.c.3 genome assembly, chromosome: 1	blastn	8070	182	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae		uncultured Parachlamydiaceae bacterium
20947746	20947746	PRJNA561212_P_NODE_9997_length_349_cov_1.094203_g9786_i0	PRJNA561212	9997	349	1.094203	3.81876847	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	536	7.459999999999997e-148	NTclustered	gi\|2874253690\|emb\|OY969416.1\|	412056	g9786	i0	95.015	257.819484240688	341	17	98	0	9	349	1315691	1316031	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04967.bin.1.157 genome assembly, chromosome: 1	blastn	89979	536	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
22222338	22222338	PRJNA561212_P_NODE_12458_length_315_cov_1.371901_g12247_i0	PRJNA561212	12458	315	1.371901	4.32148815	Parachlamydiaceae bacterium	2052176	Bacteria	Bacteria	453	6.92e-123	NTclustered	gi\|1869331976\|gb\|CP058704.1\|	2052176	g12247	i0	94.257	155.911111111111	296	17	94	0	10	305	835843	836138	Parachlamydiaceae bacterium isolate SSA5 chromosome	blastn	49112	453	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae		Parachlamydiaceae bacterium
22222538	22222538	PRJNA561212_P_NODE_3778_length_568_cov_2.135354_g3571_i0	PRJNA561212	3778	568	2.135354	12.12881072	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	678	0	NTclustered	gi\|2874253690\|emb\|OY969416.1\|	412056	g3571	i0	88.969	217.588028169014	553	56	97	3	9	560	1314951	1315499	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04967.bin.1.157 genome assembly, chromosome: 1	blastn	123590	678	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
24771647	24771647	PRJNA561212_P_NODE_2080_length_756_cov_2.455344_g1885_i0	PRJNA561212	2080	756	2.455344	18.56240064	uncultured Parachlamydiaceae bacterium	464461	Bacteria	Bacteria	778	0	NTclustered	gi\|2874253811\|emb\|OY969795.1\|	464461	g1885	i0	86.95	106.57671957672	705	77	92	13	1	699	654305	653610	MAG: uncultured Parachlamydiaceae bacterium isolate MFD05502.bin.c.3 genome assembly, chromosome: 1	blastn	80572	778	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae		uncultured Parachlamydiaceae 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);;