metadata: contig_metadata: 15 rows where analysis = "blastn", bioproject = "PRJNA1031674" and tax

15 rows where analysis = "blastn", bioproject = "PRJNA1031674" 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
3993229	3993229	PRJNA1031674_P_NODE_21464_length_253_cov_1.483333_g21253_i0	PRJNA1031674	21464	253	1.483333	3.75283249	Aquisphaera giovannonii	406548	Bacteria	Bacteria	418	1.9599999999999994e-112	NTclustered	gi\|1730068067\|gb\|CP042997.1\|	406548	g21253	i0	96.443	171.766798418972	253	9	100	0	1	253	5180068	5179816	Aquisphaera giovannonii strain OJF2 chromosome, complete genome	blastn	43457	418	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae	Aquisphaera	Aquisphaera giovannonii
5269638	5269638	PRJNA1031674_P_NODE_25385_length_245_cov_1.790698_g25174_i0	PRJNA1031674	25385	245	1.790698	4.3872101	Limnoglobus roseus	2598579	Bacteria	Bacteria	257	4.37e-64	NTclustered	gi\|1733446852\|gb\|CP042425.1\|	2598579	g25174	i0	86.192	11.6081632653061	239	32	97	1	8	245	4773768	4773530	Limnoglobus roseus strain PX52 chromosome, complete genome	blastn	2844	257	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Limnoglobus	Limnoglobus roseus
5269639	5269639	PRJNA1031674_P_NODE_25465_length_245_cov_1.488372_g25254_i0	PRJNA1031674	25465	245	1.488372	3.6465114	Humisphaera borealis	2807512	Bacteria	Bacteria	156	1.64e-33	NTclustered	gi\|1927742986\|gb\|CP063458.1\|	2807512	g25254	i0	79.757	96.5183673469388	247	24	100	9	1	245	5063493	5063271	Humisphaera borealis strain M1803 chromosome, complete genome	blastn	23647	156	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Tepidisphaerales	Tepidisphaeraceae	Humisphaera	Humisphaera borealis
7819220	7819220	PRJNA1031674_P_NODE_13047_length_283_cov_2.100000_g12836_i0	PRJNA1031674	13047	283	2.1	5.943	Polystyrenella longa	2528007	Bacteria	Bacteria	355	1.78e-93	NTclustered	gi\|1712652806\|gb\|CP036281.1\|	2528007	g12836	i0	91.188	105.3074204947	261	23	92	0	21	281	1416626	1416886	Polystyrenella longa strain Pla110 chromosome, complete genome	blastn	29802	355	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Polystyrenella	Polystyrenella longa
7819528	7819528	PRJNA1031674_P_NODE_5447_length_364_cov_2.701031_g5237_i0	PRJNA1031674	5447	364	2.701031	9.83175284	Phycisphaerales bacterium	2052180	Bacteria	Bacteria	340	6.579999999999999e-89	NTclustered	gi\|1958061316\|gb\|CP064987.1\|	2052180	g5237	i0	98.446	158.200549450549	193	3	96	0	169	361	2192229	2192421	Phycisphaerales bacterium isolate Fred_18-Q3-R57-64_MAXAC.330_cln chromosome, complete genome	blastn	57585	340	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			Phycisphaerales bacterium
16743869	16743869	PRJNA1031674_P_NODE_954_length_739_cov_3.369369_g760_i0	PRJNA1031674	954	739	3.369369	24.89963691	Tautonia plasticadhaerens	2527974	Bacteria	Bacteria	1040	0	NTclustered	gi\|1712713678\|gb\|CP036426.1\|	2527974	g760	i0	92.194	281.331529093369	743	47	100	10	1	739	266600	265865	Tautonia plasticadhaerens strain ElP chromosome	blastn	207904	1040	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae	Tautonia	Tautonia plasticadhaerens
18018501	18018501	PRJNA1031674_P_NODE_1835_length_555_cov_2.396266_g1628_i0	PRJNA1031674	1835	555	2.396266	13.2992763	uncultured Planctomycetaceae bacterium	100233	Bacteria	Bacteria	702	0	NTclustered	gi\|2874254106\|emb\|OY970189.1\|	100233	g1628	i0	89.568	152.223423423423	556	54	100	4	1	555	4317053	4317605	MAG: uncultured Planctomycetaceae bacterium isolate MFD09603.bin.2.127 genome assembly, chromosome: 1	blastn	84484	702	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		uncultured Planctomycetaceae bacterium
18018703	18018703	PRJNA1031674_P_NODE_5715_length_358_cov_2.529825_g5505_i0	PRJNA1031674	5715	358	2.529825	9.0567735	Isosphaeraceae bacterium EP7	3139350	Bacteria	Bacteria	420	8.07e-113	NTclustered	gi\|2719878338\|gb\|CP151667.1\|	3139350	g5505	i0	89.911	133.379888268156	337	19	91	9	1	324	1599835	1599501	Isosphaeraceae bacterium EP7 chromosome, complete genome	blastn	47750	420	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae		Isosphaeraceae bacterium EP7
19292386	19292386	PRJNA1031674_P_NODE_14316_length_279_cov_2.058252_g14105_i0	PRJNA1031674	14316	279	2.058252	5.74252308	Humisphaera borealis	2807512	Bacteria	Bacteria	279	1.08e-70	NTclustered	gi\|1927742986\|gb\|CP063458.1\|	2807512	g14105	i0	86.434	116.806451612903	258	31	92	4	1	256	5063511	5063256	Humisphaera borealis strain M1803 chromosome, complete genome	blastn	32589	279	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Tepidisphaerales	Tepidisphaeraceae	Humisphaera	Humisphaera borealis
19292472	19292472	PRJNA1031674_P_NODE_18556_length_264_cov_2.104712_g18345_i0	PRJNA1031674	18556	264	2.104712	5.55643968	Planctomyces sp. SH-PL62	1636152	Bacteria	Bacteria	339	1.65e-88	NTclustered	gi\|1015454008\|gb\|CP011273.1\|	1636152	g18345	i0	89.85	109.083333333333	266	23	100	3	1	264	1156967	1157230	Planctomyces sp. SH-PL62, complete genome	blastn	28798	339	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Planctomyces	Planctomyces sp. SH-PL62
19292559	19292559	PRJNA1031674_P_NODE_24396_length_247_cov_0.885057_g24185_i0	PRJNA1031674	24396	247	0.885057	2.18609079	uncultured Gemmataceae bacterium	1914239	Bacteria	Bacteria	189	1.6299999999999999e-43	NTclustered	gi\|2874253749\|emb\|OY969623.1\|	1914239	g24185	i0	80.859	11.0283400809717	256	36	100	9	1	247	7050442	7050693	MAG: uncultured Gemmataceae bacterium isolate MFD06742.bin.c.1 genome assembly, chromosome: 1	blastn	2724	189	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
19292612	19292612	PRJNA1031674_P_NODE_27836_length_241_cov_0.916667_g27625_i0	PRJNA1031674	27836	241	0.916667	2.20916747	Limnoglobus roseus	2598579	Bacteria	Bacteria	84.2	7.69e-12	NTclustered	gi\|1733446852\|gb\|CP042425.1\|	2598579	g27625	i0	85.897	0.730290456431535	78	11	32	0	164	241	3873771	3873694	Limnoglobus roseus strain PX52 chromosome, complete genome	blastn	176	84.2	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Limnoglobus	Limnoglobus roseus
20567715	20567715	PRJNA1031674_P_NODE_13957_length_280_cov_2.222222_g13746_i0	PRJNA1031674	13957	280	2.222222	6.2222216	Isosphaeraceae bacterium EP7	3139350	Bacteria	Bacteria	390	4.809999999999999e-104	NTclustered	gi\|2719878338\|gb\|CP151667.1\|	3139350	g13746	i0	91.873	289.792857142857	283	18	100	4	1	280	1600460	1600180	Isosphaeraceae bacterium EP7 chromosome, complete genome	blastn	81142	390	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae		Isosphaeraceae bacterium EP7
20567780	20567780	PRJNA1031674_P_NODE_17797_length_267_cov_2.046392_g17586_i0	PRJNA1031674	17797	267	2.046392	5.46386664	Phycisphaeraceae bacterium	2026777	Bacteria	Bacteria	178	3.86e-40	NTclustered	gi\|1927958621\|gb\|CP054186.1\|	2026777	g17586	i0	80.591	1.73782771535581	237	40	88	6	1	234	1287323	1287090	MAG: Phycisphaeraceae bacterium isolate H1_PLA1 chromosome	blastn	464	178	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales	Phycisphaeraceae		Phycisphaeraceae bacterium
23118968	23118968	PRJNA1031674_P_NODE_22399_length_250_cov_2.175141_g22188_i0	PRJNA1031674	22399	250	2.175141	5.4378525	Lignipirellula cremea	2528010	Bacteria	Bacteria	300	7.32e-77	NTclustered	gi\|1712668320\|gb\|CP036433.1\|	2528010	g22188	i0	91.705	87.836	217	16	86	2	33	247	1144123	1144339	Lignipirellula cremea strain Pla85_3_4 chromosome, complete genome	blastn	21959	300	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Lignipirellula	Lignipirellula cremea

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