metadata: contig_metadata: 17 rows where analysis = "blastn", bioproject = "PRJNA330616" and tax

17 rows where analysis = "blastn", bioproject = "PRJNA330616" 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
389862	389862	PRJNA330616_P_NODE_4081_length_424_cov_3.610667_g3673_i0	PRJNA330616	4081	424	3.610667	15.30922808	uncultured Gemmataceae bacterium	1914239	Bacteria	Bacteria	531	4.299999999999998e-146	NTclustered	gi\|2874253853\|emb\|OY969909.1\|	1914239	g3673	i0	91.667	135.478773584906	384	31	90	1	42	424	2003596	2003213	MAG: uncultured Gemmataceae bacterium isolate MFD01275.bin.c.1 genome assembly, chromosome: 1	blastn	57443	531	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
1664370	1664370	PRJNA330616_P_NODE_22442_length_178_cov_1.961240_g22033_i0	PRJNA330616	22442	178	1.96124	3.4910072	Stieleria marina	1930275	Bacteria	Bacteria	263	6.39e-66	NTclustered	gi\|1712461730\|gb\|CP036526.1\|	1930275	g22033	i0	93.296	90.6292134831461	179	10	100	2	1	178	2124323	2124146	Planctomycetes bacterium K23_9 chromosome, complete genome	blastn	16132	263	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Stieleria	Stieleria marina
5493127	5493127	PRJNA330616_P_NODE_16665_length_205_cov_1.641026_g16256_i0	PRJNA330616	16665	205	1.641026	3.3641033	Saltatorellus ferox	2528018	Bacteria	Bacteria	169	1.7e-37	NTclustered	gi\|1712682957\|gb\|CP036434.1\|	2528018	g16256	i0	81.731	128.512195121951	208	32	100	6	1	205	2931221	2931425	Planctomycetes bacterium Poly30 chromosome, complete genome	blastn	26345	169	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia			Saltatorellus	Saltatorellus ferox
5493200	5493200	PRJNA330616_P_NODE_20885_length_185_cov_1.272059_g20476_i0	PRJNA330616	20885	185	1.272059	2.35330915	Rohdeia mirabilis	2528008	Bacteria	Bacteria	281	1.8500000000000002e-71	NTclustered	gi\|1712658140\|gb\|CP036290.1\|	2528008	g20476	i0	94.505	91.8108108108108	182	10	98	0	4	185	3892426	3892607	Planctomycetes bacterium Pla163 chromosome, complete genome	blastn	16985	281	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia			Rohdeia	Rohdeia mirabilis
5493393	5493393	PRJNA330616_P_NODE_3885_length_436_cov_1.560724_g3478_i0	PRJNA330616	3885	436	1.560724	6.80475664	uncultured Planctomycetaceae bacterium	100233	Bacteria	Bacteria	414	4.66e-111	NTclustered	gi\|2874254106\|emb\|OY970189.1\|	100233	g3478	i0	84.055	162.178899082569	439	61	100	9	1	436	4317493	4317061	MAG: uncultured Planctomycetaceae bacterium isolate MFD09603.bin.2.127 genome assembly, chromosome: 1	blastn	70710	414	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		uncultured Planctomycetaceae bacterium
9317776	9317776	PRJNA330616_P_NODE_28488_length_164_cov_1.756522_g28079_i0	PRJNA330616	28488	164	1.756522	2.88069608	uncultured Phycisphaerales bacterium	904075	Bacteria	Bacteria	183	4.65e-42	NTclustered	gi\|2874253847\|emb\|OY969903.1\|	904075	g28079	i0	87.421	36.0670731707317	159	20	97	0	1	159	1830684	1830526	MAG: uncultured Phycisphaerales bacterium isolate MFD01213.bin.c.1 genome assembly, chromosome: 1	blastn	5915	183	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			uncultured Phycisphaerales bacterium
9317807	9317807	PRJNA330616_P_NODE_30368_length_163_cov_0.894737_g29959_i0	PRJNA330616	30368	163	0.894737	1.45842131	uncultured Phycisphaerales bacterium	904075	Bacteria	Bacteria	145	2.18e-30	NTclustered	gi\|2874253847\|emb\|OY969903.1\|	904075	g29959	i0	82.822	11.3926380368098	163	27	99	1	1	162	1829828	1829990	MAG: uncultured Phycisphaerales bacterium isolate MFD01213.bin.c.1 genome assembly, chromosome: 1	blastn	1857	145	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			uncultured Phycisphaerales bacterium
10593352	10593352	PRJNA330616_P_NODE_20369_length_187_cov_1.456522_g19960_i0	PRJNA330616	20369	187	1.456522	2.72369614	uncultured Gemmataceae bacterium	1914239	Bacteria	Bacteria	292	8.66e-75	NTclustered	gi\|2874253853\|emb\|OY969909.1\|	1914239	g19960	i0	95.135	192.390374331551	185	9	99	0	1	185	2002706	2002522	MAG: uncultured Gemmataceae bacterium isolate MFD01275.bin.c.1 genome assembly, chromosome: 1	blastn	35977	292	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
11272560	11272560	PRJNA330616_P_NODE_24369_length_171_cov_1.549180_g23960_i0	PRJNA330616	24369	171	1.54918	2.6490978	Frigoriglobus	2774146	Bacteria	Bacteria	281	1.68e-71	NTclustered	gi\|2874253853\|emb\|OY969909.1\|	1914239	g23960	i0	96.471	110.549707602339	170	6	99	0	2	171	2003641	2003472	MAG: uncultured Gemmataceae bacterium isolate MFD01275.bin.c.1 genome assembly, chromosome: 1	blastn	18904	281	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
13143051	13143051	PRJNA330616_P_NODE_11111_length_248_cov_1.537688_g10702_i0	PRJNA330616	11111	248	1.537688	3.81346624	Tuwongella immobilis	692036	Bacteria	Bacteria	405	1.49e-108	NTclustered	gi\|1804913728\|emb\|LR593887.1\|	692036	g10702	i0	99.111	214.197580645161	225	2	91	0	24	248	2737357	2737581	Tuwongella immobilis isolate MBLW1 genome assembly, chromosome: 1	blastn	53121	405	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Tuwongella	Tuwongella immobilis
13143424	13143424	PRJNA330616_P_NODE_711_length_1154_cov_2.714027_g457_i0	PRJNA330616	711	1154	2.714027	31.31987158	Planctomyces sp. SH-PL62	1636152	Bacteria	Bacteria	1347	0	NTclustered	gi\|1015454008\|gb\|CP011273.1\|	1636152	g457	i0	87.863	451.884748700173	1170	112	100	25	1	1154	2759859	2758704	Planctomyces sp. SH-PL62, complete genome	blastn	521475	1347	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Planctomyces	Planctomyces sp. SH-PL62
15097345	15097345	PRJNA330616_P_NODE_8172_length_290_cov_1.858921_g7763_i0	PRJNA330616	8172	290	1.858921	5.3908709	Isosphaera	127	Bacteria	Bacteria	403	6.44e-108	NTclustered	gi\|470487262\|ref\|NR_076810.1\|	128	g7763	i0	91.781	235.013793103448	292	21	100	3	1	290	2777	2487	Isosphaera pallida strain IS1B 23S ribosomal RNA gene, complete sequence	blastn	68154	403	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae	Isosphaera	Isosphaera pallida
15692542	15692542	PRJNA330616_P_NODE_6253_length_335_cov_1.881119_g5844_i0	PRJNA330616	6253	335	1.881119	6.30174865	uncultured Gemmataceae bacterium	1914239	Bacteria	Bacteria	523	5.569999999999998e-144	NTclustered	gi\|2874253853\|emb\|OY969909.1\|	1914239	g5844	i0	94.69	186.617910447761	339	14	100	4	1	335	2002958	2002620	MAG: uncultured Gemmataceae bacterium isolate MFD01275.bin.c.1 genome assembly, chromosome: 1	blastn	62517	523	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
18241146	18241146	PRJNA330616_P_NODE_1215_length_849_cov_5.172500_g880_i0	PRJNA330616	1215	849	5.1725	43.914525	Phycisphaerales bacterium	2052180	Bacteria	Bacteria	1208	0	NTclustered	gi\|1958061316\|gb\|CP064987.1\|	2052180	g880	i0	92.628	169.780918727915	841	61	99	1	1	841	2192041	2192880	Phycisphaerales bacterium isolate Fred_18-Q3-R57-64_MAXAC.330_cln chromosome, complete genome	blastn	144144	1208	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			Phycisphaerales bacterium
23341717	23341717	PRJNA330616_P_NODE_31419_length_162_cov_0.902655_g31010_i0	PRJNA330616	31419	162	0.902655	1.4623011	uncultured Planctomycetaceae bacterium	100233	Bacteria	Bacteria	263	5.72e-66	NTclustered	gi\|2874254106\|emb\|OY970189.1\|	100233	g31010	i0	96.25	39.1913580246914	160	6	99	0	1	160	4317914	4318073	MAG: uncultured Planctomycetaceae bacterium isolate MFD09603.bin.2.127 genome assembly, chromosome: 1	blastn	6349	263	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		uncultured Planctomycetaceae bacterium
24021100	24021100	PRJNA330616_P_NODE_17979_length_198_cov_1.382550_g17570_i0	PRJNA330616	17979	198	1.38255	2.737449	Pirellula	123	Bacteria	Bacteria	261	2.6200000000000002e-65	NTclustered	gi\|470485626\|ref\|NR_076710.1\|	125	g17570	i0	94.152	164.863636363636	171	10	86	0	1	171	2113	2283	Pirellula staleyi strain DSM 6068 23S ribosomal RNA gene, complete sequence	blastn	32643	261	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Pirellula	Pirellula staleyi
24615773	24615773	PRJNA330616_P_NODE_21980_length_180_cov_1.862595_g21571_i0	PRJNA330616	21980	180	1.862595	3.352671	Rohdeia mirabilis	2528008	Bacteria	Bacteria	259	8.38e-65	NTclustered	gi\|1712658140\|gb\|CP036290.1\|	2528008	g21571	i0	94.118	158.466666666667	170	10	94	0	1	170	3894026	3893857	Planctomycetes bacterium Pla163 chromosome, complete genome	blastn	28524	259	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia			Rohdeia	Rohdeia mirabilis

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);;