metadata: contig_metadata: 16 rows where analysis = "blastn", bioproject = "PRJNA1122875" and tax

16 rows where analysis = "blastn", bioproject = "PRJNA1122875" 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
1552230	1552230	PRJNA1122875_P_NODE_3182_length_832_cov_1.808959_g3001_i0	PRJNA1122875	3182	832	1.808959	15.05053888	uncultured Chlamydiae bacterium	305355	Bacteria	Bacteria	1020	0	NTclustered	gi\|2874254045\|emb\|OY970369.1\|	305355	g3001	i0	88.889	117.123798076923	837	81	100	11	1	832	174366	175195	MAG: uncultured Chlamydiae bacterium isolate MFD06092.bin.1.176 genome assembly, chromosome: 1	blastn	97447	1020	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia				uncultured Chlamydiae bacterium
2828172	2828172	PRJNA1122875_P_NODE_20783_length_365_cov_1.630137_g20559_i0	PRJNA1122875	20783	365	1.630137	5.95000005	Phycisphaerales bacterium	2052180	Bacteria	Bacteria	209	1.94e-49	NTclustered	gi\|2108005054\|gb\|CP070772.1\|	2052180	g20559	i0	82.7	2.92876712328767	237	39	65	2	1	236	3896000	3895765	MAG: Phycisphaerales bacterium isolate bin220 chromosome	blastn	1069	209	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			Phycisphaerales bacterium
4104418	4104418	PRJNA1122875_P_NODE_10564_length_510_cov_2.466819_g10343_i0	PRJNA1122875	10564	510	2.466819	12.5807769	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	283	1.63e-71	NTclustered	gi\|2874254065\|emb\|OY970130.1\|	412056	g10343	i0	76.908	78.2294117647059	511	110	99	6	1	507	1489827	1489321	MAG: uncultured Verrucomicrobiae bacterium isolate MFD05705.bin.c.1 genome assembly, chromosome: 1	blastn	39897	283	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
9205868	9205868	PRJNA1122875_P_NODE_51408_length_243_cov_0.905882_g51184_i0	PRJNA1122875	51408	243	0.905882	2.20129326	Phycisphaeraceae bacterium	2026777	Bacteria	Bacteria	150	7.55e-32	NTclustered	gi\|2621705104\|emb\|OY763327.1\|	2026777	g51184	i0	85.417	34.3909465020576	144	21	59	0	98	241	3235723	3235866	MAG: Phycisphaeraceae bacterium isolate 55aab3a5-de4e-4c55-acd5-ede7382e386b genome assembly, chromosome: 1	blastn	8357	150	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales	Phycisphaeraceae		Phycisphaeraceae bacterium
10481037	10481037	PRJNA1122875_P_NODE_11709_length_486_cov_2.285714_g11487_i0	PRJNA1122875	11709	486	2.285714	11.10857004	Candidatus Euplotechlamydia quinta	2936506	Bacteria	Bacteria	652	0	NTclustered	gi\|2226301499\|gb\|ON271409.1\|	2936506	g11487	i0	92.544	101.156378600823	456	32	94	2	32	486	464	10	Chlamydiia bacterium (ex Euplotes octocarinatus) isolate Zam5b-1 16S ribosomal RNA gene, partial sequence	blastn	49162	652	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Candidatus Rhabdochlamydiaceae	Candidatus Euplotechlamydia	Candidatus Euplotechlamydia quinta
10481106	10481106	PRJNA1122875_P_NODE_16669_length_409_cov_2.276786_g16445_i0	PRJNA1122875	16669	409	2.276786	9.31205474	Planctomycetales bacterium 10988	2603660	Bacteria	Bacteria	62.1	6.53e-5	NTclustered	gi\|1775855904\|gb\|CP043547.1\|	2603660	g16445	i0	100	0.17359413202934	33	0	8	0	338	370	5886971	5887003	Planctomycetales bacterium 10988 chromosome, complete genome	blastn	71	62.1	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales			Planctomycetales bacterium 10988
13782122	13782122	PRJNA1122875_P_NODE_52531_length_242_cov_0.911243_g52307_i0	PRJNA1122875	52531	242	0.911243	2.20520806	Bacteria	2	Bacteria	Bacteria	267	7.15e-67	NTclustered	gi\|2874253853\|emb\|OY969909.1\|	1914239	g52307	i0	86.975	10.3471074380165	238	29	98	2	4	240	8703073	8702837	MAG: uncultured Gemmataceae bacterium isolate MFD01275.bin.c.1 genome assembly, chromosome: 1	blastn	2504	267	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
16331251	16331251	PRJNA1122875_P_NODE_49413_length_245_cov_0.895349_g49189_i0	PRJNA1122875	49413	245	0.895349	2.19360505	Schlesneria	656899	Bacteria	Bacteria	97.1	1.01e-15	NTclustered	gi\|2806767875\|gb\|CP124747.2\|	3044399	g49189	i0	98.182	21.6448979591837	55	1	22	0	1	55	4770029	4769975	Schlesneria sp. DSM 10557 chromosome, complete genome	blastn	5303	97.1	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Schlesneria	Schlesneria sp. DSM 10557
16854635	16854635	PRJNA1122875_P_NODE_11894_length_482_cov_2.100244_g11671_i0	PRJNA1122875	11894	482	2.100244	10.12317608	Roseibacillus persicicus	454148	Bacteria	Bacteria	52.8	0.047	NTclustered	gi\|2889362999\|gb\|CP151838.1\|	454148	g11671	i0	100	0.0580912863070539	28	0	6	0	9	36	770285	770258	Roseibacillus persicicus strain AS69 chromosome, complete genome	blastn	28	52.8	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Roseibacillus	Roseibacillus persicicus
21954521	21954521	PRJNA1122875_P_NODE_40798_length_259_cov_1.612903_g40574_i0	PRJNA1122875	40798	259	1.612903	4.17741877	Humisphaera borealis	2807512	Bacteria	Bacteria	54.7	0.007	NTclustered	gi\|1927742986\|gb\|CP063458.1\|	2807512	g40574	i0	100	0.111969111969112	29	0	11	0	219	247	5934336	5934364	Humisphaera borealis strain M1803 chromosome, complete genome	blastn	29	54.7	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Tepidisphaerales	Tepidisphaeraceae	Humisphaera	Humisphaera borealis
23229805	23229805	PRJNA1122875_P_NODE_18179_length_391_cov_2.012579_g17955_i0	PRJNA1122875	18179	391	2.012579	7.86918389	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	538	2.3499999999999992e-148	NTclustered	gi\|2874254096\|emb\|OY970179.1\|	412056	g17955	i0	92.593	171.953964194373	378	23	96	4	16	391	1728256	1728630	MAG: uncultured Verrucomicrobiae bacterium isolate MFD05521.bin.c.1 genome assembly, chromosome: 1	blastn	67234	538	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
24503286	24503286	PRJNA1122875_P_NODE_10420_length_513_cov_2.193182_g10200_i0	PRJNA1122875	10420	513	2.193182	11.25102366	uncultured Parachlamydiaceae bacterium	464461	Bacteria	Bacteria	484	4.179999999999999e-132	NTclustered	gi\|2874253811\|emb\|OY969795.1\|	464461	g10200	i0	83.908	95.0740740740741	522	68	100	14	1	513	2059082	2058568	MAG: uncultured Parachlamydiaceae bacterium isolate MFD05502.bin.c.3 genome assembly, chromosome: 1	blastn	48773	484	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae		uncultured Parachlamydiaceae bacterium
24503385	24503385	PRJNA1122875_P_NODE_17060_length_405_cov_0.825301_g16836_i0	PRJNA1122875	17060	405	0.825301	3.34246905	Mucisphaera calidilacus	2527982	Bacteria	Bacteria	180	1.7099999999999996e-40	NTclustered	gi\|1712644202\|gb\|CP036280.1\|	2527982	g16836	i0	84.239	40.3160493827161	184	29	45	0	207	390	141340	141157	Mucisphaera calidilacus strain Pan265 chromosome, complete genome	blastn	16328	180	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales	Phycisphaeraceae	Mucisphaera	Mucisphaera calidilacus
24503673	24503673	PRJNA1122875_P_NODE_41340_length_257_cov_1.277174_g41116_i0	PRJNA1122875	41340	257	1.277174	3.28233718	Urbifossiella limnaea	2528023	Bacteria	Bacteria	54.7	0.006	NTclustered	gi\|1712585314\|gb\|CP036273.1\|	2528023	g41116	i0	100	0.221789883268482	29	0	11	0	202	230	4813016	4812988	Urbifossiella limnaea strain ETA_A1 chromosome, complete genome	blastn	57	54.7	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Urbifossiella	Urbifossiella limnaea
24503718	24503718	PRJNA1122875_P_NODE_44480_length_250_cov_0.870056_g44256_i0	PRJNA1122875	44480	250	0.870056	2.17514	uncultured Planctomycetaceae bacterium	100233	Bacteria	Bacteria	187	5.949999999999998e-43	NTclustered	gi\|2874253757\|emb\|OY969698.1\|	100233	g44256	i0	81.579	7.568	228	40	91	2	1	227	1689981	1690207	MAG: uncultured Planctomycetaceae bacterium isolate MFD00082.bin.2.56 genome assembly, chromosome: 1	blastn	1892	187	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		uncultured Planctomycetaceae bacterium
24503846	24503846	PRJNA1122875_P_NODE_52760_length_242_cov_0.911243_g52536_i0	PRJNA1122875	52760	242	0.911243	2.20520806	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	52.8	0.022	NTclustered	gi\|2874253779\|emb\|OY969763.1\|	412056	g52536	i0	100	0.115702479338843	28	0	12	0	112	139	3371446	3371473	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04967.bin.c.2 genome assembly, chromosome: 1	blastn	28	52.8	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);;