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

20 rows where analysis = "blastn", bioproject = "PRJNA613025" 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
1867823	1867823	PRJNA613025_S_NODE_26502_length_181_cov_1.439394_g26348_i0	PRJNA613025	26502	181	1.439394	2.60530314	uncultured Gemmataceae bacterium	1914239	Bacteria	Bacteria	255	1.09e-63	NTclustered	gi\|2874253853\|emb\|OY969909.1\|	1914239	g26348	i0	92.265	91.9447513812155	181	12	99	2	1	180	2003089	2002910	MAG: uncultured Gemmataceae bacterium isolate MFD01275.bin.c.1 genome assembly, chromosome: 1	blastn	16642	255	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
3142821	3142821	PRJNA613025_S_NODE_3103_length_986_cov_24.961580_g854_i4	PRJNA613025	3103	986	24.96158	246.1211788	Phycisphaerales bacterium	2052180	Bacteria	Bacteria	1279	0	NTclustered	gi\|1958061316\|gb\|CP064987.1\|	2052180	g854	i4	90.432	149.685598377282	972	92	99	1	15	986	2192880	2191910	Phycisphaerales bacterium isolate Fred_18-Q3-R57-64_MAXAC.330_cln chromosome, complete genome	blastn	147590	1279	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			Phycisphaerales bacterium
4977011	4977011	PRJNA613025_S_NODE_32444_length_163_cov_1.245614_g32290_i0	PRJNA613025	32444	163	1.245614	2.03035082	Aquisphaera	1511635	Bacteria	Bacteria	235	1.26e-57	NTclustered	gi\|1730068067\|gb\|CP042997.1\|	406548	g32290	i0	93.21	134.668711656442	162	8	99	2	2	163	5178662	5178820	Aquisphaera giovannonii strain OJF2 chromosome, complete genome	blastn	21951	237	0.991561181434599	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae	Aquisphaera	Aquisphaera giovannonii
5695780	5695780	PRJNA613025_S_NODE_885_length_2470_cov_29.969021_g854_i0	PRJNA613025	885	2470	29.969021	740.2348187	Phycisphaerales bacterium	2052180	Bacteria	Bacteria	2536	0	NTclustered	gi\|1958061316\|gb\|CP064987.1\|	2052180	g854	i0	85.335	129.289068825911	2489	324	100	39	1	2470	2192614	2190148	Phycisphaerales bacterium isolate Fred_18-Q3-R57-64_MAXAC.330_cln chromosome, complete genome	blastn	319344	2536	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			Phycisphaerales bacterium
6969868	6969868	PRJNA613025_S_NODE_11966_length_340_cov_1.817869_g11812_i0	PRJNA613025	11966	340	1.817869	6.1807546	Candidatus Uabimicrobium amorphum	2596890	Bacteria	Bacteria	307	6.210000000000001e-79	NTclustered	gi\|1732437785\|dbj\|AP019860.1\|	2596890	g11812	i0	83.237	141.891176470588	346	46	100	11	1	340	4989683	4990022	Planctomycetes bacterium SRT547 DNA, complete genome	blastn	48243	307	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Candidatus Uabimicrobiia	Candidatus Uabimicrobiales	Candidatus Uabimicrobiaceae	Candidatus Uabimicrobium	Candidatus Uabimicrobium amorphum
6970382	6970382	PRJNA613025_S_NODE_32686_length_163_cov_0.894737_g32532_i0	PRJNA613025	32686	163	0.894737	1.45842131	Planctomycetia bacterium	2052181	Bacteria	Bacteria	65.8	1.75e-6	NTclustered	gi\|1938772707\|gb\|CP054190.1\|	2052181	g32532	i0	100	26.8159509202454	35	0	21	0	129	163	1078488	1078454	MAG: Planctomycetia bacterium isolate H1_PLA3 chromosome, complete genome	blastn	4371	65.8	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia				Planctomycetia bacterium
9520049	9520049	PRJNA613025_S_NODE_2008_length_1368_cov_6.043973_g854_i3	PRJNA613025	2008	1368	6.043973	82.68155064	Phycisphaerales bacterium	2052180	Bacteria	Bacteria	1476	0	NTclustered	gi\|1958061316\|gb\|CP064987.1\|	2052180	g854	i3	86.387	110.456140350877	1381	153	100	28	1	1368	2191160	2192518	Phycisphaerales bacterium isolate Fred_18-Q3-R57-64_MAXAC.330_cln chromosome, complete genome	blastn	151104	1476	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			Phycisphaerales bacterium
9520307	9520307	PRJNA613025_S_NODE_3248_length_949_cov_15.576667_g854_i7	PRJNA613025	3248	949	15.576667	147.82256983	Phycisphaeraceae bacterium	2026777	Bacteria	Bacteria	1286	0	NTclustered	gi\|1927958621\|gb\|CP054186.1\|	2026777	g854	i7	91.489	185.036880927292	940	73	99	6	14	949	1868926	1867990	MAG: Phycisphaeraceae bacterium isolate H1_PLA1 chromosome	blastn	175600	1286	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales	Phycisphaeraceae		Phycisphaeraceae bacterium
10795881	10795881	PRJNA613025_S_NODE_17369_length_246_cov_1.182741_g17215_i0	PRJNA613025	17369	246	1.182741	2.90954286	uncultured Gemmataceae bacterium	1914239	Bacteria	Bacteria	339	1.5199999999999998e-88	NTclustered	gi\|2874253749\|emb\|OY969623.1\|	1914239	g17215	i0	91.463	108.711382113821	246	21	100	0	1	246	7052348	7052593	MAG: uncultured Gemmataceae bacterium isolate MFD06742.bin.c.1 genome assembly, chromosome: 1	blastn	26743	339	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
10796152	10796152	PRJNA613025_S_NODE_28589_length_172_cov_2.016260_g28435_i0	PRJNA613025	28589	172	2.01626	3.4679672	Limnoglobus roseus	2598579	Bacteria	Bacteria	248	1.71e-61	NTclustered	gi\|1733446852\|gb\|CP042425.1\|	2598579	g28435	i0	92.982	184.098837209302	171	11	99	1	1	170	2956998	2957168	Limnoglobus roseus strain PX52 chromosome, complete genome	blastn	31665	248	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Limnoglobus	Limnoglobus roseus
14620640	14620640	PRJNA613025_S_NODE_1832_length_1463_cov_17.804102_g854_i2	PRJNA613025	1832	1463	17.804102	260.47401226	Phycisphaerales bacterium	2052180	Bacteria	Bacteria	1598	0	NTclustered	gi\|1958061316\|gb\|CP064987.1\|	2052180	g854	i2	86.576	177.127136021873	1475	166	100	25	1	1463	2191160	2192614	Phycisphaerales bacterium isolate Fred_18-Q3-R57-64_MAXAC.330_cln chromosome, complete genome	blastn	259137	1598	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			Phycisphaerales bacterium
14620927	14620927	PRJNA613025_S_NODE_3232_length_952_cov_9.457364_g854_i6	PRJNA613025	3232	952	9.457364	90.03410528	Phycisphaeraceae bacterium	2026777	Bacteria	Bacteria	1402	0	NTclustered	gi\|1927958621\|gb\|CP054186.1\|	2026777	g854	i6	93.291	141.616596638655	954	59	100	4	1	952	1868940	1867990	MAG: Phycisphaeraceae bacterium isolate H1_PLA1 chromosome	blastn	134819	1402	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales	Phycisphaeraceae		Phycisphaeraceae bacterium
15895152	15895152	PRJNA613025_S_NODE_933_length_2375_cov_23.797077_g854_i1	PRJNA613025	933	2375	23.797077	565.18057875	Phycisphaerales bacterium	2052180	Bacteria	Bacteria	2416	0	NTclustered	gi\|1958061316\|gb\|CP064987.1\|	2052180	g854	i1	85.177	100.199157894737	2395	311	100	42	1	2375	2190148	2192518	Phycisphaerales bacterium isolate Fred_18-Q3-R57-64_MAXAC.330_cln chromosome, complete genome	blastn	237973	2416	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			Phycisphaerales bacterium
16451614	16451614	PRJNA613025_S_NODE_26073_length_183_cov_1.500000_g25919_i0	PRJNA613025	26073	183	1.5	2.745	Singulisphaera	466152	Bacteria	Bacteria	230	6.71e-56	NTclustered	gi\|485099129\|ref\|NR_102524.1\|	466153	g25919	i0	89.617	258.568306010929	183	16	100	2	1	183	1543	1722	Singulisphaera acidiphila strain MOB10 23S ribosomal RNA gene, complete sequence	blastn	47318	230	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae	Singulisphaera	Singulisphaera acidiphila
19000300	19000300	PRJNA613025_S_NODE_3115_length_983_cov_30.907923_g854_i5	PRJNA613025	3115	983	30.907923	303.82488309	Bacteria	2	Bacteria	Bacteria	1203	0	NTclustered	gi\|2076441902\|gb\|CP075368.1\|	2026777	g854	i5	89.095	176.59003051882	972	101	99	5	1	970	2582676	2581708	MAG: Phycisphaeraceae bacterium isolate ACE_PLA2 chromosome	blastn	173588	1212	0.992574257425743	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales	Phycisphaeraceae		Phycisphaeraceae bacterium
21550705	21550705	PRJNA613025_S_NODE_25917_length_184_cov_1.133333_g25763_i0	PRJNA613025	25917	184	1.133333	2.08533272	Planctomycetota	203682	Bacteria	Bacteria	78.7	2.59e-10	NTclustered	gi\|1927961636\|gb\|CP054187.1\|	2052181	g25763	i0	78.102	1.69021739130435	137	20	70	7	56	184	1882494	1882628	MAG: Planctomycetia bacterium isolate H1_PLA2 chromosome, complete genome	blastn	311	78.7	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia				Planctomycetia bacterium
21550721	21550721	PRJNA613025_S_NODE_28417_length_173_cov_1.620968_g28263_i0	PRJNA613025	28417	173	1.620968	2.80427464	Aureliella	2795605	Bacteria	Bacteria	298	1.69e-76	NTclustered	gi\|1712701923\|gb\|CP036298.1\|	2527968	g28263	i0	97.701	102.346820809249	174	2	99	2	1	172	7000543	7000716	Aureliella helgolandensis strain Q31a chromosome, complete genome	blastn	17706	298	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Aureliella	Aureliella helgolandensis
22269017	22269017	PRJNA613025_S_NODE_26698_length_180_cov_1.755725_g26544_i0	PRJNA613025	26698	180	1.755725	3.160305	uncultured Gemmataceae bacterium	1914239	Bacteria	Bacteria	316	4.899999999999999e-82	NTclustered	gi\|2874253853\|emb\|OY969909.1\|	1914239	g26544	i0	98.333	139.4	180	3	100	0	1	180	2003630	2003451	MAG: uncultured Gemmataceae bacterium isolate MFD01275.bin.c.1 genome assembly, chromosome: 1	blastn	25092	316	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
23544337	23544337	PRJNA613025_S_NODE_26939_length_179_cov_1.561538_g26785_i0	PRJNA613025	26939	179	1.561538	2.79515302	Kolteria novifilia	2527975	Bacteria	Bacteria	165	1.87e-36	NTclustered	gi\|1712629967\|gb\|CP036279.1\|	2527975	g26785	i0	83.425	42.5586592178771	181	26	100	4	1	179	1830393	1830571	Planctomycetes bacterium Pan216 chromosome, complete genome	blastn	7618	165	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Kolteriales	Kolteriaceae	Kolteria	Kolteria novifilia
23544711	23544711	PRJNA613025_S_NODE_9639_length_407_cov_1.424581_g9486_i0	PRJNA613025	9639	407	1.424581	5.79804467	Phycisphaeraceae bacterium	2026777	Bacteria	Bacteria	315	4.51e-81	NTclustered	gi\|1927958621\|gb\|CP054186.1\|	2026777	g9486	i0	81.159	11.985257985258	414	58	99	18	1	404	1866284	1866687	MAG: Phycisphaeraceae bacterium isolate H1_PLA1 chromosome	blastn	4878	315	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales	Phycisphaeraceae		Phycisphaeraceae 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);;