metadata: contig_metadata: 16 rows where analysis = "blastn", bioproject = "PRJNA1086823" and tax

16 rows where analysis = "blastn", bioproject = "PRJNA1086823" 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
1468426	1468426	PRJNA1086823_P_NODE_18922_length_242_cov_0.923077_g18805_i0	PRJNA1086823	18922	242	0.923077	2.23384634	Fuerstiella marisgermanici	1891926	Bacteria	Bacteria	106	1.65e-18	NTclustered	gi\|1140105870\|gb\|CP017641.1\|	1891926	g18805	i0	80.272	0.607438016528926	147	24	60	5	74	217	8579905	8579761	Fuerstiella marisgermanici strain NH11 chromosome, complete genome	blastn	147	106	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Fuerstiella	Fuerstiella marisgermanici
2744536	2744536	PRJNA1086823_P_NODE_323_length_1281_cov_11.298841_g255_i0	PRJNA1086823	323	1281	11.298841	144.73815321	Lacipirellula parvula	2650471	Bacteria	Bacteria	1495	0	NTclustered	gi\|1761017769\|dbj\|AP021861.1\|	2650471	g255	i0	88.844	108.067915690867	1228	122	96	11	44	1268	5163908	5162693	Lacipirellula parvula PX69 DNA, complete genome	blastn	138435	1495	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Lacipirellulaceae	Lacipirellula	Lacipirellula parvula
4020227	4020227	PRJNA1086823_P_NODE_11524_length_257_cov_1.695652_g11407_i0	PRJNA1086823	11524	257	1.695652	4.35782564	uncultured Planctomycetota bacterium	120965	Bacteria	Bacteria	427	3.32e-115	NTclustered	gi\|338181944\|gb\|JF982452.1\|	120965	g11407	i0	96.863	99.0894941634241	255	8	99	0	3	257	294	40	Uncultured planctomycete clone Upland_40_1739 16S ribosomal RNA gene, partial sequence	blastn	25466	427	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					uncultured Planctomycetota bacterium
4020302	4020302	PRJNA1086823_P_NODE_1484_length_610_cov_2.549348_g1370_i0	PRJNA1086823	1484	610	2.549348	15.5510228	Humisphaera borealis	2807512	Bacteria	Bacteria	1068	0	NTclustered	gi\|1927742986\|gb\|CP063458.1\|	2807512	g1370	i0	98.512	284.159016393443	605	9	99	0	4	608	5062990	5063594	Humisphaera borealis strain M1803 chromosome, complete genome	blastn	173337	1068	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Tepidisphaerales	Tepidisphaeraceae	Humisphaera	Humisphaera borealis
4020538	4020538	PRJNA1086823_P_NODE_7744_length_296_cov_5.757848_g7627_i0	PRJNA1086823	7744	296	5.757848	17.04323008	Bythopirellula goksoeyrii	1400387	Bacteria	Bacteria	403	6.59e-108	NTclustered	gi\|1727544988\|gb\|CP042913.1\|	1400387	g7627	i0	92.527	203.415540540541	281	21	95	0	16	296	5093472	5093752	Bythopirellula goksoeyrii strain Pr1d chromosome	blastn	60211	403	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Lacipirellulaceae	Bythopirellula	Bythopirellula goksoeyrii
11672577	11672577	PRJNA1086823_P_NODE_6770_length_314_cov_14.597510_g6653_i0	PRJNA1086823	6770	314	14.59751	45.8361814	Urbifossiella limnaea	2528023	Bacteria	Bacteria	331	3.37e-86	NTclustered	gi\|1712585314\|gb\|CP036273.1\|	2528023	g6653	i0	85.942	144.452229299363	313	41	100	2	4	314	2020313	2020002	Urbifossiella limnaea strain ETA_A1 chromosome, complete genome	blastn	45358	331	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Urbifossiella	Urbifossiella limnaea
12947352	12947352	PRJNA1086823_P_NODE_11151_length_261_cov_1.468085_g11034_i0	PRJNA1086823	11151	261	1.468085	3.83170185	Humisphaera borealis	2807512	Bacteria	Bacteria	449	7.22e-122	NTclustered	gi\|1927742986\|gb\|CP063458.1\|	2807512	g11034	i0	97.701	62.544061302682	261	6	100	0	1	261	5064742	5065002	Humisphaera borealis strain M1803 chromosome, complete genome	blastn	16324	449	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Tepidisphaerales	Tepidisphaeraceae	Humisphaera	Humisphaera borealis
12947466	12947466	PRJNA1086823_P_NODE_15931_length_247_cov_0.896552_g15814_i0	PRJNA1086823	15931	247	0.896552	2.21448344	Pirellulales bacterium	2715253	Bacteria	Bacteria	250	7.38e-62	NTclustered	gi\|2874253964\|emb\|OY970289.1\|	2715253	g15814	i0	88.517	67.5182186234818	209	20	84	2	41	247	2333935	2334141	MAG: Pirellulales bacterium isolate MFD05442.bin.c.2 genome assembly, chromosome: 1	blastn	16677	250	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales			Pirellulales bacterium
12947618	12947618	PRJNA1086823_P_NODE_551_length_976_cov_3.849391_g465_i0	PRJNA1086823	551	976	3.849391	37.57005616	uncultured Planctomycetota bacterium	120965	Bacteria	Bacteria	1777	0	NTclustered	gi\|60266308\|gb\|AY921762.1\|	120965	g465	i0	99.589	99.4579918032787	974	4	99	0	1	974	20	993	Uncultured planctomycete clone AKYH674 16S ribosomal RNA gene, partial sequence	blastn	97071	1777	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					uncultured Planctomycetota bacterium
15496533	15496533	PRJNA1086823_P_NODE_5313_length_347_cov_1.138686_g5196_i0	PRJNA1086823	5313	347	1.138686	3.95124042	Lacipirellula limnantheis	2528024	Bacteria	Bacteria	329	1.36e-85	NTclustered	gi\|1712529062\|gb\|CP036339.1\|	2528024	g5196	i0	83.898	1.02017291066282	354	48	100	6	1	347	571663	572014	Lacipirellula limnantheis strain I41 chromosome	blastn	354	329	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Lacipirellulaceae	Lacipirellula	Lacipirellula limnantheis
15496539	15496539	PRJNA1086823_P_NODE_5693_length_337_cov_5.621212_g5576_i0	PRJNA1086823	5693	337	5.621212	18.94348444	Humisphaera borealis	2807512	Bacteria	Bacteria	523	5.609999999999999e-144	NTclustered	gi\|1927742986\|gb\|CP063458.1\|	2807512	g5576	i0	94.955	87.13353115727	337	11	100	4	1	337	5064149	5063819	Humisphaera borealis strain M1803 chromosome, complete genome	blastn	29364	523	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Tepidisphaerales	Tepidisphaeraceae	Humisphaera	Humisphaera borealis
16770748	16770748	PRJNA1086823_P_NODE_19094_length_242_cov_0.923077_g18977_i0	PRJNA1086823	19094	242	0.923077	2.23384634	Phycisphaeraceae bacterium	2026777	Bacteria	Bacteria	180	9.58e-41	NTclustered	gi\|2258877542\|gb\|CP060234.1\|	2026777	g18977	i0	82.075	18.3471074380165	212	36	87	1	26	235	3099030	3099241	MAG: Phycisphaeraceae bacterium isolate HK-STAS-PLAN-6 chromosome	blastn	4440	180	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales	Phycisphaeraceae		Phycisphaeraceae bacterium
20143778	20143778	PRJNA1086823_P_NODE_36_length_2739_cov_21.929857_g29_i0	PRJNA1086823	36	2739	21.929857	600.65878323	Bacteria	2	Bacteria	Bacteria	2756	0	NTclustered	gi\|2076441902\|gb\|CP075368.1\|	2026777	g29	i0	84.993	131.49142022636	2752	371	99	40	5	2739	2584437	2581711	MAG: Phycisphaeraceae bacterium isolate ACE_PLA2 chromosome	blastn	360155	2774	0.99351117519827	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales	Phycisphaeraceae		Phycisphaeraceae bacterium
20595011	20595011	PRJNA1086823_P_NODE_8317_length_289_cov_1.629630_g8200_i0	PRJNA1086823	8317	289	1.62963	4.7096307	Kolteria novifilia	2527975	Bacteria	Bacteria	329	1.1e-85	NTclustered	gi\|1712629967\|gb\|CP036279.1\|	2527975	g8200	i0	87.329	239.747404844291	292	31	100	5	1	289	1831145	1830857	Planctomycetes bacterium Pan216 chromosome, complete genome	blastn	69287	329	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Kolteriales	Kolteriaceae	Kolteria	Kolteria novifilia
21419425	21419425	PRJNA1086823_P_NODE_297_length_1332_cov_10.119936_g234_i0	PRJNA1086823	297	1332	10.119936	134.79754752	Lacipirellula	2691417	Bacteria	Bacteria	1890	0	NTclustered	gi\|1712529062\|gb\|CP036339.1\|	2528024	g234	i0	92.523	126.92042042042	1324	92	99	7	13	1332	5170372	5169052	Lacipirellula limnantheis strain I41 chromosome	blastn	169058	1890	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Lacipirellulaceae	Lacipirellula	Lacipirellula limnantheis
24419482	24419482	PRJNA1086823_P_NODE_11240_length_260_cov_1.668449_g11123_i0	PRJNA1086823	11240	260	1.668449	4.3379674	uncultured Planctomycetaceae bacterium	100233	Bacteria	Bacteria	147	1.06e-30	NTclustered	gi\|2874253948\|emb\|OY970273.1\|	100233	g11123	i0	77.395	2.18076923076923	261	50	99	7	1	257	2846207	2845952	MAG: uncultured Planctomycetaceae bacterium isolate MFD09495.bin.c.1 genome assembly, chromosome: 1	blastn	567	147	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		uncultured Planctomycetaceae 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);;