metadata: contig_metadata: 20 rows where analysis = "blastn", bioproject = "PRJNA432257" and tax

20 rows where analysis = "blastn", bioproject = "PRJNA432257" 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
429654	429654	PRJNA432257_S_NODE_41161_length_248_cov_64.464455_g40780_i0	PRJNA432257	41161	248	64.464455	159.8718484	Pirellulimonas nuda	2528009	Bacteria	Bacteria	217	7.52e-52	NTclustered	gi\|1712662089\|gb\|CP036291.1\|	2528009	g40780	i0	88.462	137.616935483871	182	17	73	3	12	191	1067705	1067526	Pirellulimonas nuda strain Pla175 chromosome, complete genome	blastn	34129	217	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Lacipirellulaceae	Pirellulimonas	Pirellulimonas nuda
429909	429909	PRJNA432257_S_NODE_581_length_1526_cov_27.298187_g551_i0	PRJNA432257	581	1526	27.298187	416.57033362	uncultured Planctomycetaceae bacterium	100233	Bacteria	Bacteria	1496	0	NTclustered	gi\|2874253757\|emb\|OY969698.1\|	100233	g551	i0	84.937	206.815203145478	1507	195	98	29	6	1493	4421394	4422887	MAG: uncultured Planctomycetaceae bacterium isolate MFD00082.bin.2.56 genome assembly, chromosome: 1	blastn	315600	1496	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		uncultured Planctomycetaceae bacterium
429994	429994	PRJNA432257_S_NODE_64661_length_210_cov_1.601156_g64280_i0	PRJNA432257	64661	210	1.601156	3.3624276	Humisphaera borealis	2807512	Bacteria	Bacteria	250	6.09e-62	NTclustered	gi\|1927742986\|gb\|CP063458.1\|	2807512	g64280	i0	88.152	27.6952380952381	211	23	100	2	1	210	2902613	2902822	Humisphaera borealis strain M1803 chromosome, complete genome	blastn	5816	250	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Tepidisphaerales	Tepidisphaeraceae	Humisphaera	Humisphaera borealis
430111	430111	PRJNA432257_S_NODE_73981_length_199_cov_2.450617_g73600_i0	PRJNA432257	73981	199	2.450617	4.87672783	Humisphaera borealis	2807512	Bacteria	Bacteria	219	1.6099999999999996e-52	NTclustered	gi\|1927742986\|gb\|CP063458.1\|	2807512	g73600	i0	88.462	135.100502512563	182	19	91	2	18	199	5062978	5062799	Humisphaera borealis strain M1803 chromosome, complete genome	blastn	26885	219	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Tepidisphaerales	Tepidisphaeraceae	Humisphaera	Humisphaera borealis
430414	430414	PRJNA432257_S_NODE_99441_length_177_cov_1.092857_g99060_i0	PRJNA432257	99441	177	1.092857	1.93435689	Humisphaera borealis	2807512	Bacteria	Bacteria	217	5.01e-52	NTclustered	gi\|1927742986\|gb\|CP063458.1\|	2807512	g99060	i0	88.764	3.52542372881356	178	18	100	2	1	177	2902525	2902349	Humisphaera borealis strain M1803 chromosome, complete genome	blastn	624	217	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Tepidisphaerales	Tepidisphaeraceae	Humisphaera	Humisphaera borealis
5533603	5533603	PRJNA432257_S_NODE_5905_length_493_cov_75.263158_g5629_i0	PRJNA432257	5905	493	75.263158	371.04736894	Fuerstiella marisgermanici	1891926	Bacteria	Bacteria	351	4.24e-92	NTclustered	gi\|1140105870\|gb\|CP017641.1\|	1891926	g5629	i0	81.659	71.9229208924949	458	52	92	21	1	454	5362457	5362028	Fuerstiella marisgermanici strain NH11 chromosome, complete genome	blastn	35458	351	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Fuerstiella	Fuerstiella marisgermanici
8082853	8082853	PRJNA432257_S_NODE_34767_length_264_cov_421.493392_g34386_i0	PRJNA432257	34767	264	421.493392	1112.74255488	Pirellulales bacterium	2715253	Bacteria	Bacteria	195	3.79e-45	NTclustered	gi\|2874253964\|emb\|OY970289.1\|	2715253	g34386	i0	84.615	5.0530303030303	195	30	74	0	70	264	312845	313039	MAG: Pirellulales bacterium isolate MFD05442.bin.c.2 genome assembly, chromosome: 1	blastn	1334	195	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales			Pirellulales bacterium
8741589	8741589	PRJNA432257_S_NODE_39267_length_253_cov_2.481481_g38886_i0	PRJNA432257	39267	253	2.481481	6.27814693	Rubinisphaera	1649490	Bacteria	Bacteria	255	1.63e-63	NTclustered	gi\|470488120\|ref\|NR_076852.1\|	119	g38886	i0	86.134	70.8063241106719	238	31	93	2	1	236	711	948	Planctomyces brasiliensis strain DSM 5305 23S ribosomal RNA gene, complete sequence	blastn	17914	255	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Rubinisphaera	Rubinisphaera brasiliensis
9357624	9357624	PRJNA432257_S_NODE_31228_length_275_cov_14.344538_g30847_i0	PRJNA432257	31228	275	14.344538	39.4474795	Tepidisphaeraceae bacterium	2876886	Bacteria	Bacteria	206	1.83e-48	NTclustered	gi\|2874253799\|emb\|OY969783.1\|	2876886	g30847	i0	91.333	60.1163636363636	150	13	56	0	22	171	2503764	2503913	MAG: Tepidisphaeraceae bacterium isolate MFD04580.bin.c.1 genome assembly, chromosome: 1	blastn	16532	206	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Tepidisphaerales	Tepidisphaeraceae		Tepidisphaeraceae bacterium
9357845	9357845	PRJNA432257_S_NODE_47808_length_235_cov_1.732323_g47427_i0	PRJNA432257	47808	235	1.732323	4.07095905	Planctomyces sp. SH-PL14	1632864	Bacteria	Bacteria	265	2.49e-66	NTclustered	gi\|1015434452\|gb\|CP011270.1\|	1632864	g47427	i0	88.053	5.70212765957447	226	23	94	2	14	235	4955779	4955554	Planctomyces sp. SH-PL14, complete genome	blastn	1340	265	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Planctomyces	Planctomyces sp. SH-PL14
10633697	10633697	PRJNA432257_S_NODE_5289_length_512_cov_129.416842_g5022_i0	PRJNA432257	5289	512	129.416842	662.61423104	Thalassoglobus polymorphus	2527994	Bacteria	Bacteria	531	5.28e-146	NTclustered	gi\|1712486265\|gb\|CP036267.1\|	2527994	g5022	i0	87.049	80.31640625	471	59	92	2	38	506	5085500	5085970	Thalassoglobus polymorphus strain Mal48 chromosome	blastn	41122	531	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Thalassoglobus	Thalassoglobus polymorphus
12567626	12567626	PRJNA432257_S_NODE_59890_length_216_cov_2.854749_g59509_i0	PRJNA432257	59890	216	2.854749	6.16625784	root	1	Root_unresolved	Root_unresolved	243	1.05e-59	NTclustered	gi\|1927742986\|gb\|CP063458.1\|	2807512	g59509	i0	92.398	21.8055555555556	171	12	79	1	47	216	5063232	5063062	Humisphaera borealis strain M1803 chromosome, complete genome	blastn	4710	243	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Tepidisphaerales	Tepidisphaeraceae	Humisphaera	Humisphaera borealis
13183308	13183308	PRJNA432257_S_NODE_39591_length_252_cov_5.167442_g39210_i0	PRJNA432257	39591	252	5.167442	13.02195384	Planctomyces sp. SH-PL14	1632864	Bacteria	Bacteria	377	3.32e-100	NTclustered	gi\|1015434452\|gb\|CP011270.1\|	1632864	g39210	i0	96.889	89.6587301587302	225	7	89	0	1	225	4955548	4955324	Planctomyces sp. SH-PL14, complete genome	blastn	22594	377	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Planctomyces	Planctomyces sp. SH-PL14
15731623	15731623	PRJNA432257_S_NODE_104773_length_172_cov_1.851852_g104392_i0	PRJNA432257	104773	172	1.851852	3.18518544	Lacipirellula limnantheis	2528024	Bacteria	Bacteria	204	3.76e-48	NTclustered	gi\|1712529062\|gb\|CP036339.1\|	2528024	g104392	i0	88	104.296511627907	175	18	100	3	1	172	5171273	5171447	Lacipirellula limnantheis strain I41 chromosome	blastn	17939	204	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Lacipirellulaceae	Lacipirellula	Lacipirellula limnantheis
17007053	17007053	PRJNA432257_S_NODE_49714_length_231_cov_241.932990_g49333_i0	PRJNA432257	49714	231	241.93299	558.8652069	Anatilimnocola aggregata	2528021	Bacteria	Bacteria	261	3.1500000000000007e-65	NTclustered	gi\|1712591889\|gb\|CP036274.1\|	2528021	g49333	i0	91.237	87.8917748917749	194	13	83	3	3	194	7630891	7631082	Anatilimnocola aggregata strain ETA_A8 chromosome, complete genome	blastn	20303	261	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Anatilimnocola	Anatilimnocola aggregata
17007481	17007481	PRJNA432257_S_NODE_83634_length_189_cov_226.052632_g83253_i0	PRJNA432257	83634	189	226.052632	427.23947448	planctomycete str. 139	149588	Bacteria	Bacteria	200	5.47e-47	NTclustered	gi\|12583967\|gb\|AF245371.1\|AF245371	149588	g83253	i0	91.156	78.2169312169312	147	13	78	0	8	154	191	45	Planctomycete str. 139 23S ribosomal RNA gene, partial sequence	blastn	14783	200	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		planctomycete str. 139
19555480	19555480	PRJNA432257_S_NODE_38296_length_255_cov_26.564220_g37915_i0	PRJNA432257	38296	255	26.56422	67.738761	Phycisphaeraceae bacterium D3-23	3004190	Bacteria	Bacteria	206	1.68e-48	NTclustered	gi\|2727577647\|gb\|CP114179.1\|	3004190	g37915	i0	84.332	417.839215686274	217	27	84	6	1	215	1066112	1066323	Phycisphaeraceae bacterium D3-23 chromosome, complete genome	blastn	106549	206	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales	Phycisphaeraceae		Phycisphaeraceae bacterium D3-23
20830615	20830615	PRJNA432257_S_NODE_102617_length_174_cov_1.992701_g102236_i0	PRJNA432257	102617	174	1.992701	3.46729974	Humisphaera borealis	2807512	Bacteria	Bacteria	180	6.439999999999998e-41	NTclustered	gi\|1927742986\|gb\|CP063458.1\|	2807512	g102236	i0	86.145	1.36781609195402	166	23	95	0	8	173	6044036	6043871	Humisphaera borealis strain M1803 chromosome, complete genome	blastn	238	180	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Tepidisphaerales	Tepidisphaeraceae	Humisphaera	Humisphaera borealis
24656292	24656292	PRJNA432257_S_NODE_64180_length_210_cov_55.988439_g63799_i0	PRJNA432257	64180	210	55.988439	117.5757219	Candidatus Jettenia sp. CY-1	3054210	Bacteria	Bacteria	54.7	0.005	NTclustered	gi\|2556878231\|gb\|CP129468.1\|	3054210	g63799	i0	96.875	0.819047619047619	32	1	29	0	140	171	771958	771989	MAG: Candidatus Jettenia sp. CY-1 chromosome, complete genome	blastn	172	54.7	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Candidatus Brocadiia	Candidatus Brocadiales	Candidatus Brocadiaceae	Candidatus Jettenia	Candidatus Jettenia sp. CY-1
25314770	25314770	PRJNA432257_S_NODE_15460_length_351_cov_33.726115_g15079_i0	PRJNA432257	15460	351	33.726115	118.37866365	Isosphaeraceae	1763524	Bacteria	Bacteria	189	2.4199999999999992e-43	NTclustered	gi\|319748837\|gb\|CP002353.1\|	575540	g15079	i0	99.048	31.7207977207977	105	1	30	0	1	105	4041729	4041625	Isosphaera pallida ATCC 43644, complete genome	blastn	11134	189	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae	Isosphaera	Isosphaera pallida

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