metadata: contig_metadata: 19 rows where analysis = "blastn", bioproject = "PRJEB64798" and tax

19 rows where analysis = "blastn", bioproject = "PRJEB64798" and tax_phylum = "Lentisphaerota"

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
129066	129066	PRJEB64798_P_NODE_51701_length_272_cov_5.286996_g49936_i0	PRJEB64798	51701	272	5.286996	14.38062912	Lentisphaeria bacterium	2053569	Bacteria	Bacteria	394	3.6e-105	NTclustered	gi\|2189495548\|gb\|CP091727.1\|	2053569	g49936	i0	93.561	394.172794117647	264	17	97	0	1	264	948032	948295	MAG: Lentisphaeria bacterium isolate nC33_lr_bin.207.fa chromosome	blastn	107215	394	1	Bacteria	PVC group	Pseudomonadati	Lentisphaerota	Lentisphaeria				Lentisphaeria bacterium
3544140	3544140	PRJEB64798_P_NODE_57763_length_256_cov_9.835749_g55998_i0	PRJEB64798	57763	256	9.835749	25.17951744	Bacteria	2	Bacteria	Bacteria	139	1.74e-28	NTclustered	gi\|1995790976\|gb\|CP071032.1\|	1932692	g55998	i0	92	141.56640625	100	6	39	1	106	205	1587173	1587270	Lentisphaerae bacterium strain zth2 chromosome, complete genome	blastn	36241	139	1	Bacteria	PVC group	Pseudomonadati	Lentisphaerota					Lentisphaerota bacterium
4820794	4820794	PRJEB64798_P_NODE_134364_length_196_cov_5.278912_g132598_i0	PRJEB64798	134364	196	5.278912	10.34666752	Bacteria	2	Bacteria	Bacteria	141	3.5200000000000003e-29	NTclustered	gi\|1995790976\|gb\|CP071032.1\|	1932692	g132598	i0	84.138	84.1785714285714	145	23	74	0	51	195	1585862	1585718	Lentisphaerae bacterium strain zth2 chromosome, complete genome	blastn	16499	141	1	Bacteria	PVC group	Pseudomonadati	Lentisphaerota					Lentisphaerota bacterium
5231644	5231644	PRJEB64798_P_NODE_50585_length_275_cov_8.902655_g48820_i0	PRJEB64798	50585	275	8.902655	24.48230125	Lentisphaeria bacterium	2053569	Bacteria	Bacteria	375	1.3199999999999998e-99	NTclustered	gi\|2189495548\|gb\|CP091727.1\|	2053569	g48820	i0	91.822	150.367272727273	269	22	98	0	5	273	950369	950101	MAG: Lentisphaeria bacterium isolate nC33_lr_bin.207.fa chromosome	blastn	41351	375	1	Bacteria	PVC group	Pseudomonadati	Lentisphaerota	Lentisphaeria				Lentisphaeria bacterium
6095977	6095977	PRJEB64798_P_NODE_134365_length_196_cov_5.272109_g132599_i0	PRJEB64798	134365	196	5.272109	10.33333364	Bacteria	2	Bacteria	Bacteria	78.7	2.8e-10	NTclustered	gi\|2126063867\|gb\|CP085689.1\|	2886196	g132599	i0	85.526	66.8316326530612	76	10	38	1	12	86	2382576	2382651	Lentisphaerae bacterium WC36 chromosome, complete genome	blastn	13099	78.7	1	Bacteria	PVC group	Pseudomonadati	Lentisphaerota					Lentisphaerae bacterium WC36
6506688	6506688	PRJEB64798_P_NODE_242606_length_154_cov_4.638095_g240840_i0	PRJEB64798	242606	154	4.638095	7.1426663	uncultured Lentisphaeria bacterium	1506601	Bacteria	Bacteria	267	4.15e-67	NTclustered	gi\|672889648\|dbj\|AB936715.1\|	1506601	g240840	i0	99.32	98.3441558441558	147	1	95	0	4	150	164	310	Uncultured Lentisphaeria bacterium gene for 16S ribosomal RNA, partial sequence, clone: 6S4-13	blastn	15145	267	1	Bacteria	PVC group	Pseudomonadati	Lentisphaerota	Lentisphaeria				uncultured Lentisphaeria bacterium
7370918	7370918	PRJEB64798_P_NODE_28566_length_368_cov_16.890282_g26810_i0	PRJEB64798	28566	368	16.890282	62.15623776	Bacteria	2	Bacteria	Bacteria	165	4.2999999999999995e-36	NTclustered	gi\|2126063867\|gb\|CP085689.1\|	2886196	g26810	i0	78.467	108.366847826087	274	43	72	12	18	282	2384239	2383973	Lentisphaerae bacterium WC36 chromosome, complete genome	blastn	39879	165	1	Bacteria	PVC group	Pseudomonadati	Lentisphaerota					Lentisphaerae bacterium WC36
9921682	9921682	PRJEB64798_P_NODE_50688_length_275_cov_4.969027_g48923_i0	PRJEB64798	50688	275	4.969027	13.66482425	Bacteria	2	Bacteria	Bacteria	132	3.16e-26	NTclustered	gi\|1995790976\|gb\|CP071032.1\|	1932692	g48923	i0	76.259	89.8909090909091	278	49	97	15	8	275	1587205	1586935	Lentisphaerae bacterium strain zth2 chromosome, complete genome	blastn	24720	132	1	Bacteria	PVC group	Pseudomonadati	Lentisphaerota					Lentisphaerota bacterium
14157775	14157775	PRJEB64798_P_NODE_65212_length_240_cov_12.460733_g63447_i0	PRJEB64798	65212	240	12.460733	29.9057592	Victivallales bacterium	2212475	Bacteria	Bacteria	350	6.839999999999999e-92	NTclustered	gi\|2622071908\|emb\|OY787460.1\|	2212475	g63447	i0	93.617	209.391666666667	235	13	98	2	2	235	6140439	6140672	MAG: Victivallales bacterium isolate c43507a4-3b0a-454f-a213-a96987c4837a genome assembly, chromosome: 1	blastn	50254	350	1	Bacteria	PVC group	Pseudomonadati	Lentisphaerota	Lentisphaeria	Victivallales			Victivallales bacterium
16295634	16295634	PRJEB64798_P_NODE_163553_length_182_cov_0.977444_g161787_i0	PRJEB64798	163553	182	0.977444	1.77894808	Bacteria	2	Bacteria	Bacteria	171	4.1e-38	NTclustered	gi\|1995790976\|gb\|CP071032.1\|	1932692	g161787	i0	84.53	54.5384615384615	181	18	97	6	7	182	1585323	1585148	Lentisphaerae bacterium strain zth2 chromosome, complete genome	blastn	9926	171	1	Bacteria	PVC group	Pseudomonadati	Lentisphaerota					Lentisphaerota bacterium
16704037	16704037	PRJEB64798_P_NODE_16574_length_489_cov_49.159091_g14874_i0	PRJEB64798	16574	489	49.159091	240.38795499	Victivallaceae bacterium	2793042	Bacteria	Bacteria	139	3.56e-28	NTclustered	gi\|2621704067\|emb\|OY761536.1\|	2793042	g14874	i0	88.034	56.9386503067485	117	14	24	0	369	485	1448355	1448239	MAG: Victivallaceae bacterium isolate e353ef71-700a-4510-b67c-5bed4426050c genome assembly, chromosome: 1	blastn	27843	139	1	Bacteria	PVC group	Pseudomonadati	Lentisphaerota	Lentisphaeria	Victivallales	Victivallaceae		Victivallaceae bacterium
17571663	17571663	PRJEB64798_P_NODE_86874_length_212_cov_16.294479_g85108_i0	PRJEB64798	86874	212	16.294479	34.54429548	Bacteria	2	Bacteria	Bacteria	137	5e-28	NTclustered	gi\|2126063867\|gb\|CP085689.1\|	2886196	g85108	i0	82.39	69.7877358490566	159	26	75	2	32	189	2383943	2384100	Lentisphaerae bacterium WC36 chromosome, complete genome	blastn	14795	137	1	Bacteria	PVC group	Pseudomonadati	Lentisphaerota					Lentisphaerae bacterium WC36
17980522	17980522	PRJEB64798_P_NODE_46035_length_289_cov_25.666667_g44270_i0	PRJEB64798	46035	289	25.666667	74.17666763	Lentisphaera profundi	1658616	Bacteria	Bacteria	294	4.03e-75	NTclustered	gi\|2445967839\|gb\|CP117812.1\|	1658616	g44270	i0	86.617	210.889273356401	269	33	92	3	22	288	2072634	2072367	Lentisphaera profundi strain SAORIC-696 chromosome 2, complete sequence	blastn	60947	294	1	Bacteria	PVC group	Pseudomonadati	Lentisphaerota	Lentisphaeria	Lentisphaerales	Lentisphaeraceae	Lentisphaera	Lentisphaera profundi
18844940	18844940	PRJEB64798_P_NODE_231695_length_158_cov_3.568807_g229929_i0	PRJEB64798	231695	158	3.568807	5.63871506	Bacteria	2	Bacteria	Bacteria	134	4.53e-27	NTclustered	gi\|2126063867\|gb\|CP085689.1\|	2886196	g229929	i0	92.553	210.879746835443	94	5	58	2	62	153	2382792	2382885	Lentisphaerae bacterium WC36 chromosome, complete genome	blastn	33319	134	1	Bacteria	PVC group	Pseudomonadati	Lentisphaerota					Lentisphaerae bacterium WC36
18845392	18845392	PRJEB64798_P_NODE_80115_length_215_cov_2.656627_g78349_i0	PRJEB64798	80115	215	2.656627	5.71174805	Bacteria	2	Bacteria	Bacteria	54.7	0.005	NTclustered	gi\|2126063867\|gb\|CP085689.1\|	2886196	g78349	i0	100	0.269767441860465	29	0	13	0	22	50	2563330	2563302	Lentisphaerae bacterium WC36 chromosome, complete genome	blastn	58	54.7	1	Bacteria	PVC group	Pseudomonadati	Lentisphaerota					Lentisphaerae bacterium WC36
20120276	20120276	PRJEB64798_P_NODE_7496_length_720_cov_24.754098_g6165_i0	PRJEB64798	7496	720	24.754098	178.2295056	Bacteria	2	Bacteria	Bacteria	449	2.1899999999999995e-121	NTclustered	gi\|2126063867\|gb\|CP085689.1\|	2886196	g6165	i0	81.162	541.0125	568	100	79	6	149	715	2382792	2383353	Lentisphaerae bacterium WC36 chromosome, complete genome	blastn	389529	449	1	Bacteria	PVC group	Pseudomonadati	Lentisphaerota					Lentisphaerae bacterium WC36
20528255	20528255	PRJEB64798_P_NODE_164357_length_181_cov_5.242424_g162591_i0	PRJEB64798	164357	181	5.242424	9.48878744	Lentisphaera profundi	1658616	Bacteria	Bacteria	115	1.9300000000000003e-21	NTclustered	gi\|2445967839\|gb\|CP117812.1\|	1658616	g162591	i0	84.298	12.828729281768	121	15	65	4	2	119	2073538	2073657	Lentisphaera profundi strain SAORIC-696 chromosome 2, complete sequence	blastn	2322	115	1	Bacteria	PVC group	Pseudomonadati	Lentisphaerota	Lentisphaeria	Lentisphaerales	Lentisphaeraceae	Lentisphaera	Lentisphaera profundi
20529985	20529985	PRJEB64798_P_NODE_47937_length_283_cov_9.811966_g46172_i0	PRJEB64798	47937	283	9.811966	27.76786378	Victivallaceae bacterium	2793042	Bacteria	Bacteria	396	1.05e-105	NTclustered	gi\|2621704067\|emb\|OY761536.1\|	2793042	g46172	i0	92.171	142.491166077739	281	20	99	2	4	283	1449123	1449402	MAG: Victivallaceae bacterium isolate e353ef71-700a-4510-b67c-5bed4426050c genome assembly, chromosome: 1	blastn	40325	396	1	Bacteria	PVC group	Pseudomonadati	Lentisphaerota	Lentisphaeria	Victivallales	Victivallaceae		Victivallaceae bacterium
21805154	21805154	PRJEB64798_P_NODE_238558_length_155_cov_12.801887_g236792_i0	PRJEB64798	238558	155	12.801887	19.84292485	Lentisphaeria bacterium	2053569	Bacteria	Bacteria	143	7.349999999999998e-30	NTclustered	gi\|2189495548\|gb\|CP091727.1\|	2053569	g236792	i0	84.106	100.470967741935	151	20	96	4	7	155	1134847	1134699	MAG: Lentisphaeria bacterium isolate nC33_lr_bin.207.fa chromosome	blastn	15573	143	1	Bacteria	PVC group	Pseudomonadati	Lentisphaerota	Lentisphaeria				Lentisphaeria 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);;