metadata: contig_metadata: 11 rows where analysis = "blastn", bioproject = "PRJNA278119" and tax

11 rows where analysis = "blastn", bioproject = "PRJNA278119" 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
2334173	2334173	PRJNA278119_P_NODE_7222_length_443_cov_1.319797_g6975_i0	PRJNA278119	7222	443	1.319797	5.84670071	Bacteria	2	Bacteria	Bacteria	544	5.8e-150	NTclustered	gi\|2076441902\|gb\|CP075368.1\|	2026777	g6975	i0	89.318	115.939051918736	440	37	98	10	6	440	2583492	2583926	MAG: Phycisphaeraceae bacterium isolate ACE_PLA2 chromosome	blastn	51361	544	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales	Phycisphaeraceae		Phycisphaeraceae bacterium
3609450	3609450	PRJNA278119_P_NODE_4763_length_551_cov_1.364542_g4519_i0	PRJNA278119	4763	551	1.364542	7.51862642	Bacteria	2	Bacteria	Bacteria	462	2.1099999999999999e-125	NTclustered	gi\|2874253853\|emb\|OY969909.1\|	1914239	g4519	i0	82.033	386.444646098004	551	91	99	8	5	551	2001738	2002284	MAG: uncultured Gemmataceae bacterium isolate MFD01275.bin.c.1 genome assembly, chromosome: 1	blastn	212931	462	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
4198722	4198722	PRJNA278119_P_NODE_9564_length_379_cov_2.351515_g9317_i0	PRJNA278119	9564	379	2.351515	8.91224185	Stieleria magnilauensis	2527963	Bacteria	Bacteria	54.7	0.01	NTclustered	gi\|1712780605\|gb\|CP036432.1\|	2527963	g9317	i0	100	0.0765171503957784	29	0	8	0	227	255	3127751	3127779	Planctomycetes bacterium TBK1r chromosome	blastn	29	54.7	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Stieleria	Stieleria magnilauensis
5474931	5474931	PRJNA278119_P_NODE_5825_length_494_cov_1.948315_g5579_i0	PRJNA278119	5825	494	1.948315	9.6246761	Phycisphaeraceae bacterium	2026777	Bacteria	Bacteria	503	1.11e-137	NTclustered	gi\|2076441902\|gb\|CP075368.1\|	2026777	g5579	i0	85.193	161.714574898785	493	69	99	4	2	493	2583948	2584437	MAG: Phycisphaeraceae bacterium isolate ACE_PLA2 chromosome	blastn	79887	503	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales	Phycisphaeraceae		Phycisphaeraceae bacterium
5474978	5474978	PRJNA278119_P_NODE_8705_length_400_cov_2.165242_g8458_i0	PRJNA278119	8705	400	2.165242	8.660968	Phycisphaerales bacterium	2052180	Bacteria	Bacteria	422	2.54e-113	NTclustered	gi\|1958061316\|gb\|CP064987.1\|	2052180	g8458	i0	88.539	256.775	349	38	87	2	53	400	2192397	2192050	Phycisphaerales bacterium isolate Fred_18-Q3-R57-64_MAXAC.330_cln chromosome, complete genome	blastn	102710	422	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			Phycisphaerales bacterium
11849832	11849832	PRJNA278119_P_NODE_2510_length_774_cov_1.750345_g2290_i0	PRJNA278119	2510	774	1.750345	13.5476703	uncultured Planctomycetaceae bacterium	100233	Bacteria	Bacteria	1208	0	NTclustered	gi\|389546986\|gb\|JQ401914.1\|	100233	g2290	i0	95.503	99.5813953488372	756	34	98	0	1	756	4	759	Uncultured Planctomycetaceae bacterium clone CNY_02145 16S ribosomal RNA gene, partial sequence	blastn	77076	1208	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		uncultured Planctomycetaceae bacterium
14400568	14400568	PRJNA278119_P_NODE_7852_length_424_cov_1.818667_g7605_i0	PRJNA278119	7852	424	1.818667	7.71114808	uncultured Gemmataceae bacterium	1914239	Bacteria	Bacteria	383	1.2799999999999998e-101	NTclustered	gi\|2874253853\|emb\|OY969909.1\|	1914239	g7605	i0	83.295	418.129716981132	431	57	100	12	1	424	2002912	2002490	MAG: uncultured Gemmataceae bacterium isolate MFD01275.bin.c.1 genome assembly, chromosome: 1	blastn	177287	383	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
15086474	15086474	PRJNA278119_P_NODE_39492_length_166_cov_1.333333_g39243_i0	PRJNA278119	39492	166	1.333333	2.21333278	Planctomycetia	203683	Bacteria	Bacteria	274	2.73e-69	NTclustered	gi\|1727537522\|gb\|CP042911.1\|	114	g39243	i0	96.386	113.807228915663	166	6	100	0	1	166	1038085	1038250	Gemmata obscuriglobus strain DSM 5831 chromosome, complete genome	blastn	18892	274	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Gemmata	Gemmata obscuriglobus
19497255	19497255	PRJNA278119_P_NODE_31296_length_177_cov_1.617188_g31047_i0	PRJNA278119	31296	177	1.617188	2.86242276	uncultured Phycisphaerales bacterium	904075	Bacteria	Bacteria	248	1.7799999999999998e-61	NTclustered	gi\|2874253847\|emb\|OY969903.1\|	904075	g31047	i0	92.09	15	177	12	100	2	1	177	1830328	1830502	MAG: uncultured Phycisphaerales bacterium isolate MFD01213.bin.c.1 genome assembly, chromosome: 1	blastn	2655	248	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			uncultured Phycisphaerales bacterium
20185002	20185002	PRJNA278119_P_NODE_7876_length_423_cov_2.639037_g7629_i0	PRJNA278119	7876	423	2.639037	11.16312651	Gemmataceae	1914233	Bacteria	Bacteria	460	5.71e-125	NTclustered	gi\|12583965\|gb\|AF245369.1\|AF245369	114	g7629	i0	86.62	229.919621749409	426	46	99	10	1	421	1303	1722	Gemmata obscuriglobus 23S ribosomal RNA gene, partial sequence	blastn	97256	462	0.995670995670996	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Gemmata	Gemmata obscuriglobus
24597288	24597288	PRJNA278119_P_NODE_22900_length_207_cov_0.924051_g22651_i0	PRJNA278119	22900	207	0.924051	1.91278557	Pirellulales bacterium	2715253	Bacteria	Bacteria	230	7.7999999999999985e-56	NTclustered	gi\|2874253964\|emb\|OY970289.1\|	2715253	g22651	i0	87.192	148.217391304348	203	24	97	2	7	207	313175	312973	MAG: Pirellulales bacterium isolate MFD05442.bin.c.2 genome assembly, chromosome: 1	blastn	30681	230	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales			Pirellulales 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);;