metadata: contig_metadata: 14 rows where analysis = "blastn", bioproject = "PRJNA994052" and tax

14 rows where analysis = "blastn", bioproject = "PRJNA994052" 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
2251479	2251479	PRJNA994052_P_NODE_23382_length_299_cov_72.672566_g22150_i0	PRJNA994052	23382	299	72.672566	217.29097234	Polystyrenella longa	2528007	Bacteria	Bacteria	134	9.65e-27	NTclustered	gi\|1712652806\|gb\|CP036281.1\|	2528007	g22150	i0	88.991	18.8260869565217	109	10	36	2	187	293	1415588	1415480	Polystyrenella longa strain Pla110 chromosome, complete genome	blastn	5629	134	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Polystyrenella	Polystyrenella longa
3527363	3527363	PRJNA994052_P_NODE_69823_length_212_cov_168.726619_g68567_i0	PRJNA994052	69823	212	168.726619	357.70043228	Aureliella sp.	2795609	Bacteria	Bacteria	198	2.26e-46	NTclustered	gi\|2626244095\|emb\|OY829846.1\|	2795609	g68567	i0	84.314	1.50471698113208	204	31	96	1	8	211	5640474	5640676	MAG: Aureliella sp. isolate e39ea203-26a8-405f-9782-9267d5c1de48 genome assembly, chromosome: 1	blastn	319	198	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Aureliella	Aureliella sp.
4804666	4804666	PRJNA994052_P_NODE_70564_length_211_cov_2356.115942_g69308_i0	PRJNA994052	70564	211	2356.115942	4971.40463762	Polystyrenella longa	2528007	Bacteria	Bacteria	226	1.0299999999999999e-54	NTclustered	gi\|1712652806\|gb\|CP036281.1\|	2528007	g69308	i0	86.7	47.1421800947867	203	27	96	0	6	208	1415677	1415475	Polystyrenella longa strain Pla110 chromosome, complete genome	blastn	9947	226	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Polystyrenella	Polystyrenella longa
6079432	6079432	PRJNA994052_P_NODE_22365_length_303_cov_6.443478_g21137_i0	PRJNA994052	22365	303	6.443478	19.52373834	Polystyrenella longa	2528007	Bacteria	Bacteria	110	1.65e-19	NTclustered	gi\|1712652806\|gb\|CP036281.1\|	2528007	g21137	i0	85.321	56.7887788778878	109	12	35	4	15	121	1415954	1415848	Polystyrenella longa strain Pla110 chromosome, complete genome	blastn	17207	110	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Polystyrenella	Polystyrenella longa
6079877	6079877	PRJNA994052_P_NODE_63905_length_220_cov_63.027211_g62649_i0	PRJNA994052	63905	220	63.027211	138.6598642	Planctomycetota bacterium	2026780	Bacteria	Bacteria	211	3.04e-50	NTclustered	gi\|1850852299\|gb\|CP053450.1\|	2026780	g62649	i0	85.644	3.82727272727273	202	27	91	2	16	215	719910	719709	MAG: Planctomycetota bacterium isolate PNC22 chromosome	blastn	842	211	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
6079952	6079952	PRJNA994052_P_NODE_71425_length_210_cov_236.737226_g70169_i0	PRJNA994052	71425	210	236.737226	497.1481746	uncultured Planctomycetaceae bacterium	100233	Bacteria	Bacteria	231	2.2099999999999997e-56	NTclustered	gi\|2874253757\|emb\|OY969698.1\|	100233	g70169	i0	87.192	29.8619047619048	203	26	97	0	2	204	4422887	4422685	MAG: uncultured Planctomycetaceae bacterium isolate MFD00082.bin.2.56 genome assembly, chromosome: 1	blastn	6271	231	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		uncultured Planctomycetaceae bacterium
6080035	6080035	PRJNA994052_P_NODE_79485_length_201_cov_35.335938_g78228_i0	PRJNA994052	79485	201	35.335938	71.02523538	uncultured Gemmataceae bacterium	1914239	Bacteria	Bacteria	222	1.26e-53	NTclustered	gi\|2874253853\|emb\|OY969909.1\|	1914239	g78228	i0	87.065	3.82089552238806	201	20	98	6	6	201	3768213	3768412	MAG: uncultured Gemmataceae bacterium isolate MFD01275.bin.c.1 genome assembly, chromosome: 1	blastn	768	222	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
7354578	7354578	PRJNA994052_P_NODE_82106_length_198_cov_55.480000_g80849_i0	PRJNA994052	82106	198	55.48	109.8504	uncultured Gemmataceae bacterium	1914239	Bacteria	Bacteria	171	4.54e-38	NTclustered	gi\|2874253749\|emb\|OY969623.1\|	1914239	g80849	i0	83.516	25.5606060606061	182	30	92	0	12	193	7050406	7050225	MAG: uncultured Gemmataceae bacterium isolate MFD06742.bin.c.1 genome assembly, chromosome: 1	blastn	5061	171	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
12455888	12455888	PRJNA994052_P_NODE_65810_length_218_cov_8.041379_g64554_i0	PRJNA994052	65810	218	8.041379	17.53020622	Anatilimnocola aggregata	2528021	Bacteria	Bacteria	110	1.13e-19	NTclustered	gi\|1712591889\|gb\|CP036274.1\|	2528021	g64554	i0	87.368	138.51376146789	95	12	44	0	115	209	7630886	7630980	Anatilimnocola aggregata strain ETA_A8 chromosome, complete genome	blastn	30196	110	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Anatilimnocola	Anatilimnocola aggregata
12752264	12752264	PRJNA994052_P_NODE_18410_length_311_cov_29.945378_g17188_i0	PRJNA994052	18410	311	29.945378	93.13012558	Planctomycetia	203683	Bacteria	Bacteria	176	1.65e-39	NTclustered	gi\|12583967\|gb\|AF245371.1\|AF245371	149588	g17188	i0	88	101.1961414791	150	14	91	4	161	307	300	152	Planctomycete str. 139 23S ribosomal RNA gene, partial sequence	blastn	31472	176	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		planctomycete str. 139
15004751	15004751	PRJNA994052_P_NODE_73052_length_208_cov_304.533333_g71796_i0	PRJNA994052	73052	208	304.533333	633.42933264	Planctopirus ephydatiae	2528019	Bacteria	Bacteria	150	6.28e-32	NTclustered	gi\|1712709119\|gb\|CP036299.1\|	2528019	g71796	i0	80.402	9.64423076923077	199	37	95	2	4	201	3939224	3939421	Planctopirus ephydatiae strain spb1 chromosome, complete genome	blastn	2006	150	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Planctopirus	Planctopirus ephydatiae
17554729	17554729	PRJNA994052_P_NODE_78354_length_202_cov_91.798450_g77097_i0	PRJNA994052	78354	202	91.79845	185.432869	uncultured Gemmataceae bacterium	1914239	Bacteria	Bacteria	235	1.6299999999999997e-57	NTclustered	gi\|2874253749\|emb\|OY969623.1\|	1914239	g77097	i0	88.601	52.3316831683168	193	22	96	0	10	202	7050195	7050387	MAG: uncultured Gemmataceae bacterium isolate MFD06742.bin.c.1 genome assembly, chromosome: 1	blastn	10571	235	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
18828012	18828012	PRJNA994052_P_NODE_24975_length_295_cov_8.581081_g23739_i0	PRJNA994052	24975	295	8.581081	25.31418895	uncultured Gemmataceae bacterium	1914239	Bacteria	Bacteria	222	1.97e-53	NTclustered	gi\|2874253853\|emb\|OY969909.1\|	1914239	g23739	i0	80.702	7.11864406779661	285	55	97	0	8	292	9270165	9269881	MAG: uncultured Gemmataceae bacterium isolate MFD01275.bin.c.1 genome assembly, chromosome: 1	blastn	2100	222	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
18828218	18828218	PRJNA994052_P_NODE_39355_length_260_cov_12.604278_g38109_i0	PRJNA994052	39355	260	12.604278	32.7711228	Phycisphaeraceae bacterium	2026777	Bacteria	Bacteria	337	5.839999999999998e-88	NTclustered	gi\|1927958621\|gb\|CP054186.1\|	2026777	g38109	i0	90.31	16.3576923076923	258	23	99	2	4	260	2649395	2649651	MAG: Phycisphaeraceae bacterium isolate H1_PLA1 chromosome	blastn	4253	337	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales	Phycisphaeraceae		Phycisphaeraceae 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);;