metadata: contig_metadata: 18 rows where analysis = "blastn", bioproject = "PRJNA358009" and tax

18 rows where analysis = "blastn", bioproject = "PRJNA358009" 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
398387	398387	PRJNA358009_P_NODE_7221_length_264_cov_24.548837_g7153_i0	PRJNA358009	7221	264	24.548837	64.80892968	Isosphaeraceae bacterium EP7	3139350	Bacteria	Bacteria	270	6.119999999999999e-68	NTclustered	gi\|2719878338\|gb\|CP151667.1\|	3139350	g7153	i0	85.283	154.973484848485	265	36	99	2	2	264	1599568	1599305	Isosphaeraceae bacterium EP7 chromosome, complete genome	blastn	40913	270	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae		Isosphaeraceae bacterium EP7
1673061	1673061	PRJNA358009_P_NODE_8942_length_189_cov_2.092857_g8873_i0	PRJNA358009	8942	189	2.092857	3.95549973	Aeoliella mucimassa	2527972	Bacteria	Bacteria	350	5.14e-92	NTclustered	gi\|1712622222\|gb\|CP036278.1\|	2527972	g8873	i0	100	154.650793650794	189	0	100	0	1	189	2044643	2044831	Aeoliella mucimassa strain Pan181 chromosome, complete genome	blastn	29229	350	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Lacipirellulaceae	Aeoliella	Aeoliella mucimassa
2948920	2948920	PRJNA358009_P_NODE_463_length_505_cov_8.182018_g416_i0	PRJNA358009	463	505	8.182018	41.3191909	uncultured Planctomycetaceae bacterium	100233	Bacteria	Bacteria	298	5.74e-76	NTclustered	gi\|2874254106\|emb\|OY970189.1\|	100233	g416	i0	90.393	51.0633663366337	229	19	82	3	277	503	5936873	5936646	MAG: uncultured Planctomycetaceae bacterium isolate MFD09603.bin.2.127 genome assembly, chromosome: 1	blastn	25787	298	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		uncultured Planctomycetaceae bacterium
4225391	4225391	PRJNA358009_P_NODE_13344_length_166_cov_4.444444_g13275_i0	PRJNA358009	13344	166	4.444444	7.37777704	Limnoglobus roseus	2598579	Bacteria	Bacteria	248	1.65e-61	NTclustered	gi\|1733446852\|gb\|CP042425.1\|	2598579	g13275	i0	95.484	134.506024096386	155	7	93	0	5	159	2957038	2956884	Limnoglobus roseus strain PX52 chromosome, complete genome	blastn	22328	248	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Limnoglobus	Limnoglobus roseus
6775958	6775958	PRJNA358009_P_NODE_6946_length_305_cov_10.621094_g6882_i0	PRJNA358009	6946	305	10.621094	32.3943367	Planctomyces sp. SH-PL62	1636152	Bacteria	Bacteria	460	3.99e-125	NTclustered	gi\|1015454008\|gb\|CP011273.1\|	1636152	g6882	i0	94.389	570.737704918033	303	11	98	5	1	300	1156298	1155999	Planctomyces sp. SH-PL62, complete genome	blastn	174075	460	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Planctomyces	Planctomyces sp. SH-PL62
9326444	9326444	PRJNA358009_P_NODE_6928_length_310_cov_6.084291_g6864_i0	PRJNA358009	6928	310	6.084291	18.8613021	uncultured Singulisphaera sp.	651290	Bacteria	Bacteria	492	1.44e-134	NTclustered	gi\|1917890560\|gb\|MW144133.1\|	651290	g6864	i0	96.026	94.5387096774193	302	12	97	0	7	308	93	394	Uncultured Singulisphaera sp. clone OTU844 16S ribosomal RNA gene, partial sequence	blastn	29307	492	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae	Singulisphaera	uncultured Singulisphaera sp.
10602104	10602104	PRJNA358009_P_NODE_8129_length_207_cov_3.139241_g8060_i0	PRJNA358009	8129	207	3.139241	6.49822887	uncultured Planctomycetaceae bacterium	100233	Bacteria	Bacteria	268	1.6499999999999994e-67	NTclustered	gi\|2874253757\|emb\|OY969698.1\|	100233	g8060	i0	92.105	66.1884057971015	190	15	92	0	18	207	4420200	4420011	MAG: uncultured Planctomycetaceae bacterium isolate MFD00082.bin.2.56 genome assembly, chromosome: 1	blastn	13701	268	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		uncultured Planctomycetaceae bacterium
13151989	13151989	PRJNA358009_P_NODE_2611_length_327_cov_3.528777_g2548_i0	PRJNA358009	2611	327	3.528777	11.539100790000001	uncultured Phycisphaerales bacterium	904075	Bacteria	Bacteria	115	3.87e-21	NTclustered	gi\|2874253847\|emb\|OY969903.1\|	904075	g2548	i0	89.888	23.9266055045872	89	9	27	0	232	320	1832126	1832038	MAG: uncultured Phycisphaerales bacterium isolate MFD01213.bin.c.1 genome assembly, chromosome: 1	blastn	7824	115	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			uncultured Phycisphaerales bacterium
14427010	14427010	PRJNA358009_P_NODE_15672_length_162_cov_0.902655_g15603_i0	PRJNA358009	15672	162	0.902655	1.4623011	Thermogutta terrifontis	1331910	Bacteria	Bacteria	226	7.509999999999998e-55	NTclustered	gi\|1238331385\|gb\|CP018477.1\|	1331910	g15603	i0	93.464	18.5493827160494	153	9	94	1	3	155	3642374	3642223	Thermogutta terrifontis strain R1 chromosome, complete genome	blastn	3005	226	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Thermoguttaceae	Thermogutta	Thermogutta terrifontis
18249843	18249843	PRJNA358009_P_NODE_14495_length_164_cov_1.773913_g14426_i0	PRJNA358009	14495	164	1.773913	2.90921732	Planctomyces sp. SH-PL62	1636152	Bacteria	Bacteria	252	1.26e-62	NTclustered	gi\|1015454008\|gb\|CP011273.1\|	1636152	g14426	i0	96.689	8.82317073170732	151	5	92	0	7	157	1155391	1155241	Planctomyces sp. SH-PL62, complete genome	blastn	1447	252	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Planctomyces	Planctomyces sp. SH-PL62
20799639	20799639	PRJNA358009_P_NODE_11797_length_172_cov_3.813008_g11728_i0	PRJNA358009	11797	172	3.813008	6.55837376	Limnoglobus roseus	2598579	Bacteria	Bacteria	230	6.21e-56	NTclustered	gi\|1733446852\|gb\|CP042425.1\|	2598579	g11728	i0	91.176	163.912790697674	170	14	100	1	4	172	2957321	2957152	Limnoglobus roseus strain PX52 chromosome, complete genome	blastn	28193	230	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Limnoglobus	Limnoglobus roseus
20799778	20799778	PRJNA358009_P_NODE_237_length_616_cov_8.601411_g199_i0	PRJNA358009	237	616	8.601411	52.98469176	Planctomyces sp. SH-PL62	1636152	Bacteria	Bacteria	263	2.5900000000000002e-65	NTclustered	gi\|1015454008\|gb\|CP011273.1\|	1636152	g199	i0	91.71	53.4918831168831	193	10	53	5	427	616	1156109	1156298	Planctomyces sp. SH-PL62, complete genome	blastn	32951	263	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Planctomyces	Planctomyces sp. SH-PL62
21474587	21474587	PRJNA358009_P_NODE_11637_length_173_cov_2.508065_g11568_i0	PRJNA358009	11637	173	2.508065	4.33895245	Phycisphaera	666508	Bacteria	Bacteria	128	2.35e-25	NTclustered	gi\|470476024\|ref\|NR_076315.1\|	547188	g11568	i0	81.481	9.20231213872832	162	25	92	5	7	166	418	260	Phycisphaera mikurensis strain FYK2301M01 23S ribosomal RNA gene, complete sequence	blastn	1592	128	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales	Phycisphaeraceae	Phycisphaera	Phycisphaera mikurensis
22074864	22074864	PRJNA358009_P_NODE_4318_length_327_cov_2.176259_g4255_i0	PRJNA358009	4318	327	2.176259	7.11636693	Gimesia panareensis	2527978	Bacteria	Bacteria	93.5	1.81e-14	NTclustered	gi\|1712615819\|gb\|CP036277.1\|	2527978	g4255	i0	98.113	14.4434250764526	53	1	16	0	275	327	7402368	7402420	Gimesia panareensis strain Pan110 chromosome, complete genome	blastn	4723	93.5	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Gimesia	Gimesia panareensis
22074919	22074919	PRJNA358009_P_NODE_8598_length_192_cov_10.412587_g8529_i0	PRJNA358009	8598	192	10.412587	19.992167039999998	uncultured Planctomycetaceae bacterium	100233	Bacteria	Bacteria	246	7.07e-61	NTclustered	gi\|2874254106\|emb\|OY970189.1\|	100233	g8529	i0	90.86	199.822916666667	186	14	97	2	1	186	4319894	4319712	MAG: uncultured Planctomycetaceae bacterium isolate MFD09603.bin.2.127 genome assembly, chromosome: 1	blastn	38366	246	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		uncultured Planctomycetaceae bacterium
23350143	23350143	PRJNA358009_P_NODE_1259_length_351_cov_1.778146_g1198_i0	PRJNA358009	1259	351	1.778146	6.24129246	Singulisphaera sp. Ch08	3120278	Bacteria	Bacteria	185	3.1299999999999996e-42	NTclustered	gi\|2732846650\|gb\|CP155447.1\|	3120278	g1198	i0	94.309	59.014245014245	123	3	64	4	223	345	3412449	3412331	Singulisphaera sp. Ch08 chromosome, complete genome	blastn	20714	185	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae	Singulisphaera	Singulisphaera sp. Ch08
23350338	23350338	PRJNA358009_P_NODE_7939_length_214_cov_6.387879_g7870_i0	PRJNA358009	7939	214	6.387879	13.67006106	Paludisphaera borealis	1387353	Bacteria	Bacteria	309	1.01e-79	NTclustered	gi\|1133581311\|gb\|CP019082.1\|	1387353	g7870	i0	93.689	453.214953271028	206	13	96	0	2	207	121443	121648	Paludisphaera borealis strain PX4 chromosome, complete genome	blastn	96988	309	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae	Paludisphaera	Paludisphaera borealis
24624539	24624539	PRJNA358009_P_NODE_5400_length_327_cov_1.769784_g5337_i0	PRJNA358009	5400	327	1.769784	5.78719368	uncultured Gemmataceae bacterium	1914239	Bacteria	Bacteria	130	1.38e-25	NTclustered	gi\|2874253853\|emb\|OY969909.1\|	1914239	g5337	i0	91.579	51.3547400611621	95	6	29	2	1	94	2002059	2001966	MAG: uncultured Gemmataceae bacterium isolate MFD01275.bin.c.1 genome assembly, chromosome: 1	blastn	16793	130	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae 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);;