metadata: contig_metadata: 23 rows where analysis = "blastn", bioproject = "PRJNA1059246" and tax

23 rows where analysis = "blastn", bioproject = "PRJNA1059246" 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
1011435	1011435	PRJNA1059246_P_NODE_23701_length_461_cov_1.817010_g23077_i0	PRJNA1059246	23701	461	1.81701	8.3764161	Bacteria	2	Bacteria	Bacteria	510	6.139999999999998e-140	NTclustered	gi\|1927958621\|gb\|CP054186.1\|	2026777	g23077	i0	86.638	347.561822125813	464	58	100	4	1	461	1867449	1866987	MAG: Phycisphaeraceae bacterium isolate H1_PLA1 chromosome	blastn	160226	510	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales	Phycisphaeraceae		Phycisphaeraceae bacterium
1451588	1451588	PRJNA1059246_P_NODE_30842_length_393_cov_1.412500_g30216_i0	PRJNA1059246	30842	393	1.4125	5.551125	uncultured Phycisphaerales bacterium	904075	Bacteria	Bacteria	457	6.82e-124	NTclustered	gi\|2874253847\|emb\|OY969903.1\|	904075	g30216	i0	89.13	114.511450381679	368	39	93	1	27	393	1830402	1830035	MAG: uncultured Phycisphaerales bacterium isolate MFD01213.bin.c.1 genome assembly, chromosome: 1	blastn	45003	457	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			uncultured Phycisphaerales bacterium
1451648	1451648	PRJNA1059246_P_NODE_35022_length_365_cov_1.229452_g34396_i0	PRJNA1059246	35022	365	1.229452	4.4874998	uncultured Phycisphaerales bacterium	904075	Bacteria	Bacteria	470	8.069999999999999e-128	NTclustered	gi\|2874253847\|emb\|OY969903.1\|	904075	g34396	i0	89.946	85.0986301369863	368	31	100	5	1	365	1830482	1830846	MAG: uncultured Phycisphaerales bacterium isolate MFD01213.bin.c.1 genome assembly, chromosome: 1	blastn	31061	470	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			uncultured Phycisphaerales bacterium
1451857	1451857	PRJNA1059246_P_NODE_50282_length_288_cov_1.432558_g49656_i0	PRJNA1059246	50282	288	1.432558	4.12576704	Gemmata massiliana	1210884	Bacteria	Bacteria	370	6.48e-98	NTclustered	gi\|1804905141\|emb\|LR593886.1\|	1210884	g49656	i0	90.068	142.145833333333	292	20	100	8	1	288	3633637	3633923	Gemmata massiliana isolate Soil9 genome assembly, chromosome: 1	blastn	40938	370	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Gemmata	Gemmata massiliana
1451923	1451923	PRJNA1059246_P_NODE_55922_length_271_cov_1.040404_g55296_i0	PRJNA1059246	55922	271	1.040404	2.81949484	uncultured Planctomycetales bacterium	100371	Bacteria	Bacteria	396	9.969999999999997e-106	NTclustered	gi\|38195204\|gb\|AY360627.1\|	100371	g55296	i0	97.414	86.3948339483395	232	6	86	0	1	232	4	235	Uncultured Planctomycetales bacterium clone M10Ba37 small subunit ribosomal RNA gene, partial sequence	blastn	23413	396	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales			uncultured Planctomycetales bacterium
2727343	2727343	PRJNA1059246_P_NODE_21283_length_491_cov_1.105263_g20664_i0	PRJNA1059246	21283	491	1.105263	5.42684133	Tepidisphaeraceae bacterium	2876886	Bacteria	Bacteria	619	1.05e-172	NTclustered	gi\|2874253799\|emb\|OY969783.1\|	2876886	g20664	i0	89.452	239.582484725051	493	48	100	4	1	491	2503659	2503169	MAG: Tepidisphaeraceae bacterium isolate MFD04580.bin.c.1 genome assembly, chromosome: 1	blastn	117635	619	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Tepidisphaerales	Tepidisphaeraceae		Tepidisphaeraceae bacterium
2727403	2727403	PRJNA1059246_P_NODE_24923_length_448_cov_1.349333_g24299_i0	PRJNA1059246	24923	448	1.349333	6.04501184	uncultured Planctomycetaceae bacterium	100233	Bacteria	Bacteria	291	8.44e-74	NTclustered	gi\|2874253948\|emb\|OY970273.1\|	100233	g24299	i0	80.8	48.9397321428571	375	68	83	4	75	447	6941659	6941287	MAG: uncultured Planctomycetaceae bacterium isolate MFD09495.bin.c.1 genome assembly, chromosome: 1	blastn	21925	291	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		uncultured Planctomycetaceae bacterium
4003242	4003242	PRJNA1059246_P_NODE_18364_length_536_cov_1.587473_g17748_i0	PRJNA1059246	18364	536	1.587473	8.50885528	Bremerella sp. TYQ1	3119568	Bacteria	Bacteria	56.5	0.004	NTclustered	gi\|2101355205\|gb\|CP083740.1\|	3119568	g17748	i0	96.97	0.123134328358209	33	1	6	0	152	184	6472236	6472204	Bremerella sp. TYQ1 chromosome, complete genome	blastn	66	56.5	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Bremerella	Bremerella sp. TYQ1
5280237	5280237	PRJNA1059246_P_NODE_73105_length_229_cov_2.192308_g72479_i0	PRJNA1059246	73105	229	2.192308	5.02038532	Phycisphaeraceae bacterium	2026777	Bacteria	Bacteria	141	4.24e-29	NTclustered	gi\|2621705104\|emb\|OY763327.1\|	2026777	g72479	i0	78.39	274.803493449782	236	37	98	6	6	229	1577027	1576794	MAG: Phycisphaeraceae bacterium isolate 55aab3a5-de4e-4c55-acd5-ede7382e386b genome assembly, chromosome: 1	blastn	62930	141	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales	Phycisphaeraceae		Phycisphaeraceae bacterium
6555366	6555366	PRJNA1059246_P_NODE_67806_length_245_cov_1.412791_g67180_i0	PRJNA1059246	67806	245	1.412791	3.46133795	uncultured Phycisphaerales bacterium	904075	Bacteria	Bacteria	139	1.6499999999999999e-28	NTclustered	gi\|2874253847\|emb\|OY969903.1\|	904075	g67180	i0	85.612	53.9877551020408	139	13	56	4	1	136	1831191	1831325	MAG: uncultured Phycisphaerales bacterium isolate MFD01213.bin.c.1 genome assembly, chromosome: 1	blastn	13227	139	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			uncultured Phycisphaerales bacterium
9104657	9104657	PRJNA1059246_P_NODE_37528_length_350_cov_1.346570_g36902_i0	PRJNA1059246	37528	350	1.34657	4.712995	uncultured Gemmataceae bacterium	1914239	Bacteria	Bacteria	67.6	1.18e-6	NTclustered	gi\|2874253853\|emb\|OY969909.1\|	1914239	g36902	i0	93.333	0.128571428571429	45	3	13	0	40	84	8373166	8373210	MAG: uncultured Gemmataceae bacterium isolate MFD01275.bin.c.1 genome assembly, chromosome: 1	blastn	45	67.6	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
10380341	10380341	PRJNA1059246_P_NODE_36289_length_357_cov_1.602113_g35663_i0	PRJNA1059246	36289	357	1.602113	5.71954341	Gemmataceae bacterium	2052164	Bacteria	Bacteria	117	1.18e-21	NTclustered	gi\|2063814025\|emb\|LR586051.1\|	2052164	g35663	i0	79.641	13.9299719887955	167	30	46	4	136	300	2057879	2058043	Gemmata bacterium CJuql4 whole genome assembly and annotation	blastn	4973	117	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		Gemmataceae bacterium
10380652	10380652	PRJNA1059246_P_NODE_63489_length_249_cov_1.579545_g62863_i0	PRJNA1059246	63489	249	1.579545	3.93306705	uncultured Planctomycetaceae bacterium	100233	Bacteria	Bacteria	300	7.29e-77	NTclustered	gi\|2874254106\|emb\|OY970189.1\|	100233	g62863	i0	88.353	44.3333333333333	249	29	100	0	1	249	5408352	5408600	MAG: uncultured Planctomycetaceae bacterium isolate MFD09603.bin.2.127 genome assembly, chromosome: 1	blastn	11039	300	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		uncultured Planctomycetaceae bacterium
11655462	11655462	PRJNA1059246_P_NODE_28370_length_414_cov_1.967742_g27745_i0	PRJNA1059246	28370	414	1.967742	8.14645188	Urbifossiella limnaea	2528023	Bacteria	Bacteria	54.7	0.011	NTclustered	gi\|1712585314\|gb\|CP036273.1\|	2528023	g27745	i0	100	0.070048309178744	29	0	7	0	334	362	2934163	2934135	Urbifossiella limnaea strain ETA_A1 chromosome, complete genome	blastn	29	54.7	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Urbifossiella	Urbifossiella limnaea
11655562	11655562	PRJNA1059246_P_NODE_35790_length_360_cov_1.445993_g35164_i0	PRJNA1059246	35790	360	1.445993	5.2055748	Aquisphaera giovannonii	406548	Bacteria	Bacteria	217	1.14e-51	NTclustered	gi\|1730068067\|gb\|CP042997.1\|	406548	g35164	i0	77.686	2.04444444444444	363	75	100	6	1	360	9446461	9446102	Aquisphaera giovannonii strain OJF2 chromosome, complete genome	blastn	736	217	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae	Aquisphaera	Aquisphaera giovannonii
12930654	12930654	PRJNA1059246_P_NODE_29311_length_406_cov_1.726727_g28686_i0	PRJNA1059246	29311	406	1.726727	7.01051162	uncultured Phycisphaerales bacterium	904075	Bacteria	Bacteria	457	7.0699999999999984e-124	NTclustered	gi\|2874253847\|emb\|OY969903.1\|	904075	g28686	i0	87.719	73.012315270936	399	39	98	10	11	406	1831539	1831148	MAG: uncultured Phycisphaerales bacterium isolate MFD01213.bin.c.1 genome assembly, chromosome: 1	blastn	29643	457	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			uncultured Phycisphaerales bacterium
14205944	14205944	PRJNA1059246_P_NODE_56392_length_269_cov_1.382653_g55766_i0	PRJNA1059246	56392	269	1.382653	3.71933657	Phycisphaerales bacterium	2052180	Bacteria	Bacteria	327	3.66e-85	NTclustered	gi\|1958061316\|gb\|CP064987.1\|	2052180	g55766	i0	88.806	73.6840148698885	268	28	99	2	2	268	2190220	2190486	Phycisphaerales bacterium isolate Fred_18-Q3-R57-64_MAXAC.330_cln chromosome, complete genome	blastn	19821	327	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			Phycisphaerales bacterium
16754256	16754256	PRJNA1059246_P_NODE_58374_length_262_cov_1.539683_g57748_i0	PRJNA1059246	58374	262	1.539683	4.03396946	Phycisphaeraceae bacterium	2026777	Bacteria	Bacteria	351	2.1e-92	NTclustered	gi\|1927958621\|gb\|CP054186.1\|	2026777	g57748	i0	90.84	381.053435114504	262	24	100	0	1	262	1868671	1868932	MAG: Phycisphaeraceae bacterium isolate H1_PLA1 chromosome	blastn	99836	351	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales	Phycisphaeraceae		Phycisphaeraceae bacterium
18028893	18028893	PRJNA1059246_P_NODE_45915_length_308_cov_0.982979_g45289_i0	PRJNA1059246	45915	308	0.982979	3.02757532	Phycisphaerales bacterium	2052180	Bacteria	Bacteria	484	2.3899999999999998e-132	NTclustered	gi\|1958061316\|gb\|CP064987.1\|	2052180	g45289	i0	95.395	250.012987012987	304	14	99	0	5	308	2192228	2192531	Phycisphaerales bacterium isolate Fred_18-Q3-R57-64_MAXAC.330_cln chromosome, complete genome	blastn	77004	484	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			Phycisphaerales bacterium
18029153	18029153	PRJNA1059246_P_NODE_68215_length_245_cov_0.895349_g67589_i0	PRJNA1059246	68215	245	0.895349	2.19360505	Pirellula sp. SH-Sr6A	1632865	Bacteria	Bacteria	231	2.65e-56	NTclustered	gi\|1015448679\|gb\|CP011272.1\|	1632865	g67589	i0	84.016	382.595918367347	244	35	99	4	3	244	3097662	3097421	Pirellula sp. SH-Sr6A, complete genome	blastn	93736	231	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Pirellula	Pirellula sp. SH-Sr6A
19302822	19302822	PRJNA1059246_P_NODE_40996_length_331_cov_2.383721_g40370_i0	PRJNA1059246	40996	331	2.383721	7.89011651	Phycisphaerales bacterium	2052180	Bacteria	Bacteria	340	5.94e-89	NTclustered	gi\|1958061316\|gb\|CP064987.1\|	2052180	g40370	i0	85.671	65.631419939577	328	41	98	6	1	326	2190606	2190283	Phycisphaerales bacterium isolate Fred_18-Q3-R57-64_MAXAC.330_cln chromosome, complete genome	blastn	21724	340	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			Phycisphaerales bacterium
20578226	20578226	PRJNA1059246_P_NODE_46637_length_304_cov_2.000000_g46011_i0	PRJNA1059246	46637	304	2	6.08	Tepidisphaeraceae bacterium	2876886	Bacteria	Bacteria	449	8.599999999999998e-122	NTclustered	gi\|2874253799\|emb\|OY969783.1\|	2876886	g46011	i0	93.443	224.273026315789	305	16	100	3	1	304	2501007	2501308	MAG: Tepidisphaeraceae bacterium isolate MFD04580.bin.c.1 genome assembly, chromosome: 1	blastn	68179	449	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Tepidisphaerales	Tepidisphaeraceae		Tepidisphaeraceae bacterium
23129186	23129186	PRJNA1059246_P_NODE_24059_length_457_cov_1.934896_g23435_i0	PRJNA1059246	24059	457	1.934896	8.84247472	Aquisphaera giovannonii	406548	Bacteria	Bacteria	601	3.51e-167	NTclustered	gi\|1730068067\|gb\|CP042997.1\|	406548	g23435	i0	90.652	140.592997811816	460	32	100	8	1	457	5178734	5179185	Aquisphaera giovannonii strain OJF2 chromosome, complete genome	blastn	64251	601	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae	Aquisphaera	Aquisphaera giovannonii

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