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

23 rows where analysis = "blastn", bioproject = "PRJNA994052" 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
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.
4804098	4804098	PRJNA994052_P_NODE_19404_length_310_cov_17.611814_g18181_i0	PRJNA994052	19404	310	17.611814	54.5966234	Oleiharenicola sp. Vm1	3398393	Bacteria	Bacteria	108	6.09e-19	NTclustered	gi\|2912653302\|gb\|CP180537.1\|	3398393	g18181	i0	83.478	0.474193548387097	115	19	37	0	2	116	2448190	2448076	Oleiharenicola sp. Vm1 chromosome, complete genome	blastn	147	108	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Oleiharenicola	Oleiharenicola sp. Vm1
4804273	4804273	PRJNA994052_P_NODE_35884_length_267_cov_43.051546_g34638_i0	PRJNA994052	35884	267	43.051546	114.94762782	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	339	1.6699999999999998e-88	NTclustered	gi\|2874254096\|emb\|OY970179.1\|	412056	g34638	i0	89.668	69.7827715355805	271	21	100	5	1	267	1728723	1728990	MAG: uncultured Verrucomicrobiae bacterium isolate MFD05521.bin.c.1 genome assembly, chromosome: 1	blastn	18632	339	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
4804470	4804470	PRJNA994052_P_NODE_51204_length_239_cov_36.493976_g49949_i0	PRJNA994052	51204	239	36.493976	87.22060264	Opitutus sp. GAS368	1882749	Bacteria	Bacteria	351	1.89e-92	NTclustered	gi\|1085764882\|emb\|LT629735.1\|	1882749	g49949	i0	95.067	5.61924686192469	223	11	93	0	1	223	2195101	2195323	Opitutus sp. GAS368 genome assembly, chromosome: I	blastn	1343	351	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Opitutus	Opitutus sp. GAS368
4804502	4804502	PRJNA994052_P_NODE_54204_length_234_cov_96.956522_g52949_i0	PRJNA994052	54204	234	96.956522	226.87826148	Parachlamydiaceae bacterium	2052176	Bacteria	Bacteria	377	3.04e-100	NTclustered	gi\|1869331976\|gb\|CP058704.1\|	2052176	g52949	i0	96.889	85.8461538461538	225	7	96	0	10	234	1334101	1334325	Parachlamydiaceae bacterium isolate SSA5 chromosome	blastn	20088	377	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae		Parachlamydiaceae bacterium
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
8629469	8629469	PRJNA994052_P_NODE_41967_length_255_cov_6.824176_g40720_i0	PRJNA994052	41967	255	6.824176	17.4016488	Oleiharenicola sp. Vm1	3398393	Bacteria	Bacteria	263	9.83e-66	NTclustered	gi\|2912653302\|gb\|CP180537.1\|	3398393	g40720	i0	85.49	5.42745098039216	255	33	99	4	3	255	1381445	1381697	Oleiharenicola sp. Vm1 chromosome, complete genome	blastn	1384	263	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Oleiharenicola	Oleiharenicola sp. Vm1
9904412	9904412	PRJNA994052_P_NODE_22368_length_303_cov_5.952174_g21140_i0	PRJNA994052	22368	303	5.952174	18.03508722	uncultured Opitutus sp.	296825	Bacteria	Bacteria	339	1.93e-88	NTclustered	gi\|310754759\|gb\|HQ212649.1\|	296825	g21140	i0	86.557	50.5577557755776	305	23	96	12	8	299	866	567	Uncultured Opitutus sp. clone 1_N02 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	15319	339	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Opitutus	uncultured Opitutus sp.
11179846	11179846	PRJNA994052_P_NODE_48289_length_244_cov_11.578947_g47037_i0	PRJNA994052	48289	244	11.578947	28.25263068	uncultured Chlamydiae bacterium	305355	Bacteria	Bacteria	357	4.16e-94	NTclustered	gi\|2874254045\|emb\|OY970369.1\|	305355	g47037	i0	95.154	155.934426229508	227	9	93	2	19	244	174621	174396	MAG: uncultured Chlamydiae bacterium isolate MFD06092.bin.1.176 genome assembly, chromosome: 1	blastn	38048	357	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia				uncultured Chlamydiae 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
13730079	13730079	PRJNA994052_P_NODE_53391_length_235_cov_3559.271605_g52136_i0	PRJNA994052	53391	235	3559.271605	8364.28827175	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	285	1.91e-72	NTclustered	gi\|2874254096\|emb\|OY970179.1\|	412056	g52136	i0	89.427	19.3489361702128	227	23	97	1	9	235	1729011	1729236	MAG: uncultured Verrucomicrobiae bacterium isolate MFD05521.bin.c.1 genome assembly, chromosome: 1	blastn	4547	285	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
15004743	15004743	PRJNA994052_P_NODE_72152_length_210_cov_6.160584_g70896_i0	PRJNA994052	72152	210	6.160584	12.9372264	Opitutales bacterium	2026772	Bacteria	Bacteria	161	2.93e-35	NTclustered	gi\|2814788334\|emb\|OY762281.2\|	2026772	g70896	i0	81.818	87.8428571428571	198	30	92	5	4	196	976877	976681	MAG: Opitutales bacterium isolate 685e4509-010e-4797-9872-a51ee4494a19 genome assembly, chromosome: 1	blastn	18447	161	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales			Opitutales bacterium
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);;