metadata: contig_metadata: 16 rows where bioproject = "PRJNA635397" and tax

16 rows where bioproject = "PRJNA635397" and tax_phylum = "Planctomycetota"

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
605924	605924	PRJNA635397_P_NODE_42861_length_247_cov_0.890805_g42407_i0	PRJNA635397	42861	247	0.890805	2.20028835	Planctomycetaceae bacterium	2026779	Bacteria	Bacteria	272	1.5699999999999999e-68	NTclustered	gi\|1702190059\|gb\|CP030884.1\|	2026779	g42407	i0	86.694	116.951417004049	248	29	99	4	1	245	438505	438751	Planctomycetaceae bacterium isolate ECT2AJA-110-A chromosome	blastn	28887	272	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		Planctomycetaceae bacterium
2428982	2428982	PRJNA635397_P_NODE_7762_length_651_cov_2.598616_g7320_i0	PRJNA635397	7762	651	2.598616	16.91699016	Planctomycetia	203683	Bacteria	Bacteria	974	0	NTclustered	gi\|219903967\|emb\|AM935706.1\|	100371	g7320	i0	94.21	103.668202764977	639	35	98	2	1	638	638	1	Uncultured Planctomycetales bacterium partial 16S rRNA gene, clone AMCA8	blastn	67488	981	0.992864424057085	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales			uncultured Planctomycetales bacterium
3156584	3156584	PRJNA635397_P_NODE_26443_length_310_cov_1.675105_g25989_i0	PRJNA635397	26443	310	1.675105	5.1928255	Bacteria	2	Bacteria	Bacteria	165	2.21e-50	NR	MBM4098314.1	2026780	g25989	i0	85	10.6258064516129	100	15	96.8	0	2	301	23	122	MBM4098314.1 phosphoglycerate kinase [Planctomycetota bacterium]	diamond	3294	165	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
6984504	6984504	PRJNA635397_P_NODE_46706_length_242_cov_0.911243_g46252_i0	PRJNA635397	46706	242	0.911243	2.20520806	Tepidisphaeraceae bacterium	2876886	Bacteria	Bacteria	313	9.06e-81	NTclustered	gi\|2874253799\|emb\|OY969783.1\|	2876886	g46252	i0	90.041	30.6404958677686	241	24	99	0	1	241	2503158	2502918	MAG: Tepidisphaeraceae bacterium isolate MFD04580.bin.c.1 genome assembly, chromosome: 1	blastn	7415	313	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Tepidisphaerales	Tepidisphaeraceae		Tepidisphaeraceae bacterium
17183987	17183987	PRJNA635397_P_NODE_48374_length_208_cov_4.192593_g47920_i0	PRJNA635397	48374	208	4.192593	8.72059344	Tautonia plasticadhaerens	2527974	Bacteria	Bacteria	318	1.63e-82	NTclustered	gi\|1712713678\|gb\|CP036426.1\|	2527974	g47920	i0	94.313	134.024038461538	211	6	100	5	1	208	267249	267456	Tautonia plasticadhaerens strain ElP chromosome	blastn	27877	318	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae	Tautonia	Tautonia plasticadhaerens
23558406	23558406	PRJNA635397_P_NODE_32239_length_279_cov_2.611650_g31785_i0	PRJNA635397	32239	279	2.61165	7.2865035	Tautonia plasticadhaerens	2527974	Bacteria	Bacteria	455	1.68e-123	NTclustered	gi\|1712713678\|gb\|CP036426.1\|	2527974	g31785	i0	96.057	196.10394265233	279	11	100	0	1	279	267668	267946	Tautonia plasticadhaerens strain ElP chromosome	blastn	54713	455	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae	Tautonia	Tautonia plasticadhaerens
27049435	27049435	PRJNA635397_P_NODE_42182_length_248_cov_0.885714_g41728_i0	PRJNA635397	42182	248	0.885714	2.19657072	Planctomycetota bacterium	2026780	Bacteria	Bacteria	156	4.53e-44	NR	MCE9566415.1	2026780	g41728	i0	86.4	3.94354838709677	81	11	98	0	3	245	311	391	MCE9566415.1 phage portal protein [Planctomycetota bacterium]	diamond	978	156	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
27491805	27491805	PRJNA635397_P_NODE_41363_length_249_cov_0.886364_g40909_i0	PRJNA635397	41363	249	0.886364	2.20704636	Crateriforma spongiae	2724528	Bacteria	Bacteria	42.4	0.0473	NR	WP_168564633.1	2724528	g40909	i0	41.2	0.614457831325301	51	29	60.2	1	156	7	46	96	WP_168564633.1 adenylyl-sulfate kinase [Crateriforma spongiae]	diamond	153	42.4	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Crateriforma	Crateriforma spongiae
28924930	28924930	PRJNA635397_P_NODE_21548_length_346_cov_1.864469_g21094_i0	PRJNA635397	21548	346	1.864469	6.45106274	Bacteria	2	Bacteria	Bacteria	46.6	0.00549	NR	MBX3402345.1	2026777	g21094	i0	31.8	4.70809248554913	110	72	94.5	2	334	8	786	893	MBX3402345.1 alanine--tRNA ligase [Phycisphaeraceae bacterium]	diamond	1629	47	0.991489361702128	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales	Phycisphaeraceae		Phycisphaeraceae bacterium
29809052	29809052	PRJNA635397_P_NODE_41911_length_248_cov_1.394286_g41457_i0	PRJNA635397	41911	248	1.394286	3.45782928	Bacteria	2	Bacteria	Bacteria	70.9	6.27e-13	NR	WP_105336449.1	124	g41457	i0	54.7	1.24596774193548	53	24	64.1	0	2	160	132	184	WP_105336449.1 hypothetical protein [Blastopirellula marina]	diamond	309	70.9	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Blastopirellula	Blastopirellula marina
29923090	29923090	PRJNA635397_P_NODE_46091_length_242_cov_2.899408_g45637_i0	PRJNA635397	46091	242	2.899408	7.01656736	Stieleria neptunia	2527979	Bacteria	Bacteria	41.6	0.0284	NR	WP_145386459.1	2527979	g45637	i0	40	0.557851239669422	45	27	55.8	0	226	92	35	79	WP_145386459.1 hypothetical protein [Stieleria neptunia]	diamond	135	41.6	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Stieleria	Stieleria neptunia
31123196	31123196	PRJNA635397_P_NODE_29155_length_294_cov_3.800905_g28701_i0	PRJNA635397	29155	294	3.800905	11.1746607	Pirellulaceae bacterium	2699754	Bacteria	Bacteria	43.5	0.0369	NR	MCL4203912.1	2699754	g28701	i0	28.6	0.857142857142857	84	59	85.7	1	286	35	285	367	MCL4203912.1 DEAD/DEAH box helicase [Pirellulaceae bacterium]	diamond	252	43.5	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae		Pirellulaceae bacterium
31534880	31534880	PRJNA635397_P_NODE_35816_length_264_cov_2.136126_g35362_i0	PRJNA635397	35816	264	2.136126	5.63937264	Tepidisphaeraceae bacterium	2876886	Bacteria	Bacteria	41.2	0.0315	NR	HSZ57079.1	2876886	g35362	i0	35.8	0.602272727272727	53	32	60.2	1	48	206	30	80	HSZ57079.1 hypothetical protein [Tepidisphaeraceae bacterium]	diamond	159	41.2	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Tepidisphaerales	Tepidisphaeraceae		Tepidisphaeraceae bacterium
32009218	32009218	PRJNA635397_P_NODE_21558_length_346_cov_1.710623_g21104_i0	PRJNA635397	21558	346	1.710623	5.91875558	Singulisphaera acidiphila	466153	Bacteria	Bacteria	44.3	0.035	NR	WP_015245602.1	466153	g21104	i0	38.8	0.69364161849711	80	46	68.5	2	77	313	181	258	WP_015245602.1 serine/threonine-protein kinase [Singulisphaera acidiphila]	diamond	240	44.3	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae	Singulisphaera	Singulisphaera acidiphila
32230884	32230884	PRJNA635397_P_NODE_24378_length_324_cov_1.215139_g23924_i0	PRJNA635397	24378	324	1.215139	3.93705036	Phycisphaerales bacterium	2052180	Bacteria	Bacteria	88.2	1.18e-18	NR	MBY0308879.1	2052180	g23924	i0	92.9	0.388888888888889	42	3	38.9	0	130	5	191	232	MBY0308879.1 hypothetical protein [Phycisphaerales bacterium]	diamond	126	88.2	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			Phycisphaerales bacterium
32610165	32610165	PRJNA635397_P_NODE_24220_length_325_cov_1.198413_g23766_i0	PRJNA635397	24220	325	1.198413	3.89484225	Planctomycetota bacterium	2026780	Bacteria	Bacteria	44.7	0.0162	NR	TAH36757.1	2026780	g23766	i0	36.4	0.710769230769231	77	40	67.4	3	319	101	64	135	TAH36757.1 MAG: ribonuclease PH [Planctomycetota bacterium]	diamond	231	44.7	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota 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);;