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

17 rows where analysis = "blastn", bioproject = "PRJNA986481" 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
973537	973537	PRJNA986481_P_NODE_34221_length_279_cov_2.378261_g33696_i0	PRJNA986481	34221	279	2.378261	6.63534819	Urbifossiella limnaea	2528023	Bacteria	Bacteria	435	2.18e-117	NTclustered	gi\|1712585314\|gb\|CP036273.1\|	2528023	g33696	i0	94.681	130.286738351254	282	11	100	4	1	279	2018960	2019240	Urbifossiella limnaea strain ETA_A1 chromosome, complete genome	blastn	36350	435	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Urbifossiella	Urbifossiella limnaea
3524410	3524410	PRJNA986481_P_NODE_5303_length_690_cov_5.115445_g4865_i0	PRJNA986481	5303	690	5.115445	35.2965705	Phycisphaeraceae bacterium	2026777	Bacteria	Bacteria	730	0	NTclustered	gi\|1927958621\|gb\|CP054186.1\|	2026777	g4865	i0	86.391	118.131884057971	676	82	97	10	1	672	1866868	1866199	MAG: Phycisphaeraceae bacterium isolate H1_PLA1 chromosome	blastn	81511	730	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales	Phycisphaeraceae		Phycisphaeraceae bacterium
4801482	4801482	PRJNA986481_P_NODE_36804_length_268_cov_3.470320_g36279_i0	PRJNA986481	36804	268	3.47032	9.3004576	Urbifossiella limnaea	2528023	Bacteria	Bacteria	387	5.92e-103	NTclustered	gi\|1712585314\|gb\|CP036273.1\|	2528023	g36279	i0	94.444	115.436567164179	252	12	94	2	18	268	4212569	4212319	Urbifossiella limnaea strain ETA_A1 chromosome, complete genome	blastn	30937	387	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Urbifossiella	Urbifossiella limnaea
4801883	4801883	PRJNA986481_P_NODE_624_length_1505_cov_372.283654_g486_i1	PRJNA986481	624	1505	372.283654	5602.8689927	Phycisphaeraceae bacterium	2026777	Bacteria	Bacteria	1823	0	NTclustered	gi\|1927958621\|gb\|CP054186.1\|	2026777	g486	i1	89.053	283.415946843854	1489	137	98	22	17	1489	1867669	1866191	MAG: Phycisphaeraceae bacterium isolate H1_PLA1 chromosome	blastn	426541	1823	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales	Phycisphaeraceae		Phycisphaeraceae bacterium
7350976	7350976	PRJNA986481_P_NODE_11706_length_479_cov_2.183721_g11183_i0	PRJNA986481	11706	479	2.183721	10.46002359	Tautonia plasticadhaerens	2527974	Bacteria	Bacteria	414	5.16e-111	NTclustered	gi\|1712713678\|gb\|CP036426.1\|	2527974	g11183	i0	85.859	1.30688935281837	396	48	82	6	87	478	1121110	1121501	Tautonia plasticadhaerens strain ElP chromosome	blastn	626	414	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae	Tautonia	Tautonia plasticadhaerens
9901838	9901838	PRJNA986481_P_NODE_41988_length_261_cov_1.264151_g41463_i0	PRJNA986481	41988	261	1.264151	3.29943411	Rubinisphaera brasiliensis	119	Bacteria	Bacteria	52.8	0.024	NTclustered	gi\|324966854\|gb\|CP002546.1\|	756272	g41463	i0	100	0.10727969348659	28	0	11	0	228	255	678723	678750	Rubinisphaera brasiliensis DSM 5305 chromosome, complete genome	blastn	28	52.8	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Rubinisphaera	Rubinisphaera brasiliensis
9902116	9902116	PRJNA986481_P_NODE_58708_length_243_cov_0.917526_g58183_i0	PRJNA986481	58708	243	0.917526	2.22958818	Planctomycetales bacterium ZRK34	2723666	Bacteria	Bacteria	235	2.03e-57	NTclustered	gi\|1898316769\|gb\|CP050848.1\|	2723666	g58183	i0	86.73	67.8395061728395	211	28	87	0	31	241	5655049	5654839	Planctomycetales bacterium ZRK34 chromosome, complete genome	blastn	16485	235	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales			Planctomycetales bacterium ZRK34
13727599	13727599	PRJNA986481_P_NODE_631_length_1502_cov_287.187887_g489_i1	PRJNA986481	631	1502	287.187887	4313.56206274	Phycisphaeraceae bacterium	2026777	Bacteria	Bacteria	1543	0	NTclustered	gi\|1927958621\|gb\|CP054186.1\|	2026777	g489	i1	85.87	455.456058588549	1465	189	97	15	17	1470	1867669	1866212	MAG: Phycisphaeraceae bacterium isolate H1_PLA1 chromosome	blastn	684095	1543	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales	Phycisphaeraceae		Phycisphaeraceae bacterium
16276771	16276771	PRJNA986481_P_NODE_56853_length_245_cov_1.020408_g56328_i0	PRJNA986481	56853	245	1.020408	2.4999996	Stieleria neptunia	2527979	Bacteria	Bacteria	60.2	1.32e-4	NTclustered	gi\|1712721777\|gb\|CP037423.1\|	2527979	g56328	i0	97.143	0.142857142857143	35	1	14	0	211	245	2671186	2671152	Stieleria neptunia strain Enr13 chromosome	blastn	35	60.2	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Stieleria	Stieleria neptunia
20099894	20099894	PRJNA986481_P_NODE_2596_length_918_cov_60.803222_g2265_i0	PRJNA986481	2596	918	60.803222	558.17357796	Phycisphaeraceae bacterium	2026777	Bacteria	Bacteria	861	0	NTclustered	gi\|2076441902\|gb\|CP075368.1\|	2026777	g2265	i0	84.589	210.652505446623	876	125	95	9	48	918	2584428	2583558	MAG: Phycisphaeraceae bacterium isolate ACE_PLA2 chromosome	blastn	193379	861	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales	Phycisphaeraceae		Phycisphaeraceae bacterium
20099980	20099980	PRJNA986481_P_NODE_30876_length_294_cov_1.820408_g30351_i0	PRJNA986481	30876	294	1.820408	5.35199952	Urbifossiella limnaea	2528023	Bacteria	Bacteria	472	1.7699999999999998e-128	NTclustered	gi\|1712585314\|gb\|CP036273.1\|	2528023	g30351	i0	95.578	62.5680272108844	294	13	100	0	1	294	2020320	2020027	Urbifossiella limnaea strain ETA_A1 chromosome, complete genome	blastn	18395	472	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Urbifossiella	Urbifossiella limnaea
20100242	20100242	PRJNA986481_P_NODE_4796_length_719_cov_2.541791_g4373_i0	PRJNA986481	4796	719	2.541791	18.27547729	Urbifossiella limnaea	2528023	Bacteria	Bacteria	1114	0	NTclustered	gi\|1712585314\|gb\|CP036273.1\|	2528023	g4373	i0	94.606	403.13769123783	723	33	100	6	1	719	2018233	2018953	Urbifossiella limnaea strain ETA_A1 chromosome, complete genome	blastn	289856	1114	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Urbifossiella	Urbifossiella limnaea
20100458	20100458	PRJNA986481_P_NODE_616_length_1507_cov_696.316187_g486_i0	PRJNA986481	616	1507	696.316187	10493.48493809	Phycisphaeraceae bacterium	2026777	Bacteria	Bacteria	1941	0	NTclustered	gi\|1927958621\|gb\|CP054186.1\|	2026777	g486	i0	90.451	381.806237558062	1487	122	98	16	17	1491	1866191	1867669	MAG: Phycisphaeraceae bacterium isolate H1_PLA1 chromosome	blastn	575382	1941	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales	Phycisphaeraceae		Phycisphaeraceae bacterium
21375719	21375719	PRJNA986481_P_NODE_3697_length_796_cov_6.619813_g3312_i0	PRJNA986481	3697	796	6.619813	52.69371148	Tautonia plasticadhaerens	2527974	Bacteria	Bacteria	257	1.58e-63	NTclustered	gi\|1712713678\|gb\|CP036426.1\|	2527974	g3312	i0	78.88	3.26005025125628	393	73	49	10	45	432	7249034	7248647	Tautonia plasticadhaerens strain ElP chromosome	blastn	2595	257	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae	Tautonia	Tautonia plasticadhaerens
21375797	21375797	PRJNA986481_P_NODE_41277_length_262_cov_0.948357_g40752_i0	PRJNA986481	41277	262	0.948357	2.48469534	Phycisphaeraceae bacterium	2026777	Bacteria	Bacteria	224	4.789999999999999e-54	NTclustered	gi\|2076441902\|gb\|CP075368.1\|	2026777	g40752	i0	82.129	2.95419847328244	263	45	100	2	1	262	2178502	2178763	MAG: Phycisphaeraceae bacterium isolate ACE_PLA2 chromosome	blastn	774	224	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales	Phycisphaeraceae		Phycisphaeraceae bacterium
22650636	22650636	PRJNA986481_P_NODE_35398_length_274_cov_2.160000_g34873_i0	PRJNA986481	35398	274	2.16	5.9184	Phycisphaeraceae bacterium	2026777	Bacteria	Bacteria	174	5.15e-39	NTclustered	gi\|2076441902\|gb\|CP075368.1\|	2026777	g34873	i0	83.333	78.6350364963504	198	23	70	10	22	213	2582790	2582983	MAG: Phycisphaeraceae bacterium isolate ACE_PLA2 chromosome	blastn	21546	174	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales	Phycisphaeraceae		Phycisphaeraceae bacterium
23926489	23926489	PRJNA986481_P_NODE_59719_length_241_cov_2.541667_g59194_i0	PRJNA986481	59719	241	2.541667	6.12541747	Roseimaritima multifibrata	1930274	Bacteria	Bacteria	58.4	4.66e-4	NTclustered	gi\|1712444166\|gb\|CP036262.1\|	1930274	g59194	i0	100	3.59751037344398	31	0	13	0	48	78	1735176	1735146	Roseimaritima multifibrata strain FF011L chromosome, complete genome	blastn	867	58.4	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Roseimaritima	Roseimaritima multifibrata

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