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

23 rows where analysis = "blastn", bioproject = "PRJEB39643" and tax_clade = "PVC group"

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
1331550	1331550	PRJEB39643_P_NODE_114322_length_255_cov_1.692308_g114129_i0	PRJEB39643	114322	255	1.692308	4.3153854	Frigoriglobus tundricola	2774151	Bacteria	Bacteria	65.8	2.98e-6	NTclustered	gi\|1870286614\|gb\|CP053452.2\|	2774151	g114129	i0	100	1.43921568627451	35	0	14	0	221	255	7547724	7547758	Frigoriglobus tundricola strain PL17 chromosome, complete genome	blastn	367	65.8	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Frigoriglobus	Frigoriglobus tundricola
1332628	1332628	PRJEB39643_P_NODE_68782_length_276_cov_1.517241_g68589_i0	PRJEB39643	68782	276	1.517241	4.18758516	Gemmata massiliana	1210884	Bacteria	Bacteria	230	1.0899999999999995e-55	NTclustered	gi\|1804905141\|emb\|LR593886.1\|	1210884	g68589	i0	81.985	8.9963768115942	272	47	98	2	6	276	7183347	7183077	Gemmata massiliana isolate Soil9 genome assembly, chromosome: 1	blastn	2483	230	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Gemmata	Gemmata massiliana
2608062	2608062	PRJEB39643_P_NODE_53183_length_284_cov_1.459716_g52990_i0	PRJEB39643	53183	284	1.459716	4.14559344	uncultured Gemmataceae bacterium	1914239	Bacteria	Bacteria	159	1.5e-34	NTclustered	gi\|2874253853\|emb\|OY969909.1\|	1914239	g52990	i0	84.337	3.37323943661972	166	22	58	4	17	180	3849080	3848917	MAG: uncultured Gemmataceae bacterium isolate MFD01275.bin.c.1 genome assembly, chromosome: 1	blastn	958	159	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
2608434	2608434	PRJEB39643_P_NODE_91103_length_265_cov_1.604167_g90910_i0	PRJEB39643	91103	265	1.604167	4.25104255	Frigoriglobus tundricola	2774151	Bacteria	Bacteria	163	1.07e-35	NTclustered	gi\|1870286614\|gb\|CP053452.2\|	2774151	g90910	i0	85	1.17358490566038	160	24	60	0	1	160	3066628	3066469	Frigoriglobus tundricola strain PL17 chromosome, complete genome	blastn	311	163	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Frigoriglobus	Frigoriglobus tundricola
3883869	3883869	PRJEB39643_P_NODE_17404_length_439_cov_1.683060_g17211_i0	PRJEB39643	17404	439	1.68306	7.3886334	uncultured Planctomycetaceae bacterium	100233	Bacteria	Bacteria	65.8	5.45e-6	NTclustered	gi\|2874253948\|emb\|OY970273.1\|	100233	g17211	i0	93.182	0.100227790432802	44	3	10	0	384	427	6454238	6454281	MAG: uncultured Planctomycetaceae bacterium isolate MFD09495.bin.c.1 genome assembly, chromosome: 1	blastn	44	65.8	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		uncultured Planctomycetaceae bacterium
3883969	3883969	PRJEB39643_P_NODE_25984_length_359_cov_2.153846_g25791_i0	PRJEB39643	25984	359	2.153846	7.73230714	Gemmataceae bacterium	2052164	Bacteria	Bacteria	248	4.04e-61	NTclustered	gi\|2063814025\|emb\|LR586051.1\|	2052164	g25791	i0	82.253	2.15041782729805	293	46	81	5	32	321	1632613	1632324	Gemmata bacterium CJuql4 whole genome assembly and annotation	blastn	772	248	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		Gemmataceae bacterium
4817246	4817246	PRJEB39643_P_NODE_140684_length_244_cov_1.801170_g140491_i0	PRJEB39643	140684	244	1.80117	4.3948548	Gemmata	113	Bacteria	Bacteria	139	1.64e-28	NTclustered	gi\|1727537522\|gb\|CP042911.1\|	114	g140491	i0	91.176	1.67213114754098	102	9	42	0	52	153	6671605	6671706	Gemmata obscuriglobus strain DSM 5831 chromosome, complete genome	blastn	408	139	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Gemmata	Gemmata obscuriglobus
7709558	7709558	PRJEB39643_P_NODE_107387_length_258_cov_1.664865_g107194_i0	PRJEB39643	107387	258	1.664865	4.2953517	Limnoglobus roseus	2598579	Bacteria	Bacteria	117	8.2100000000000005e-22	NTclustered	gi\|1733446852\|gb\|CP042425.1\|	2598579	g107194	i0	81.081	1.08914728682171	148	26	57	2	98	244	7653651	7653505	Limnoglobus roseus strain PX52 chromosome, complete genome	blastn	281	117	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Limnoglobus	Limnoglobus roseus
8984258	8984258	PRJEB39643_P_NODE_106008_length_258_cov_1.664865_g105815_i0	PRJEB39643	106008	258	1.664865	4.2953517	Limnoglobus roseus	2598579	Bacteria	Bacteria	200	7.93e-47	NTclustered	gi\|1733446852\|gb\|CP042425.1\|	2598579	g105815	i0	83.036	4.0077519379845	224	34	86	4	37	258	936677	936456	Limnoglobus roseus strain PX52 chromosome, complete genome	blastn	1034	200	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Limnoglobus	Limnoglobus roseus
9917757	9917757	PRJEB39643_P_NODE_85588_length_268_cov_1.579487_g85395_i0	PRJEB39643	85588	268	1.579487	4.23302516	Gemmata	113	Bacteria	Bacteria	145	3.94e-30	NTclustered	gi\|1727537522\|gb\|CP042911.1\|	114	g85395	i0	84.828	7.55223880597015	145	20	54	2	124	267	5764370	5764513	Gemmata obscuriglobus strain DSM 5831 chromosome, complete genome	blastn	2024	145	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Gemmata	Gemmata obscuriglobus
12811813	12811813	PRJEB39643_P_NODE_67731_length_277_cov_1.509804_g67538_i0	PRJEB39643	67731	277	1.509804	4.18215708	Gemmataceae bacterium	2052164	Bacteria	Bacteria	265	3.0099999999999997e-66	NTclustered	gi\|2063814025\|emb\|LR586051.1\|	2052164	g67538	i0	84.701	81.187725631769	268	37	96	4	12	277	7465371	7465106	Gemmata bacterium CJuql4 whole genome assembly and annotation	blastn	22489	265	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		Gemmataceae bacterium
14085893	14085893	PRJEB39643_P_NODE_148872_length_241_cov_1.833333_g148679_i0	PRJEB39643	148872	241	1.833333	4.41833253	uncultured Gemmataceae bacterium	1914239	Bacteria	Bacteria	195	3.41e-45	NTclustered	gi\|2874253853\|emb\|OY969909.1\|	1914239	g148679	i0	81.633	2.64730290456432	245	35	99	7	4	241	4900474	4900233	MAG: uncultured Gemmataceae bacterium isolate MFD01275.bin.c.1 genome assembly, chromosome: 1	blastn	638	195	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
16634540	16634540	PRJEB39643_P_NODE_17474_length_438_cov_1.873973_g17281_i0	PRJEB39643	17474	438	1.8739730000000001	8.20800174	Phycisphaeraceae bacterium	2026777	Bacteria	Bacteria	58.4	0.001	NTclustered	gi\|1927958621\|gb\|CP054186.1\|	2026777	g17281	i0	100	0.0707762557077626	31	0	7	0	368	398	2637212	2637182	MAG: Phycisphaeraceae bacterium isolate H1_PLA1 chromosome	blastn	31	58.4	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales	Phycisphaeraceae		Phycisphaeraceae bacterium
16634948	16634948	PRJEB39643_P_NODE_49494_length_286_cov_1.446009_g49301_i0	PRJEB39643	49494	286	1.446009	4.13558574	Limnoglobus roseus	2598579	Bacteria	Bacteria	348	3.0100000000000004e-91	NTclustered	gi\|1733446852\|gb\|CP042425.1\|	2598579	g49301	i0	88.732	73.5734265734266	284	32	99	0	1	284	3302058	3301775	Limnoglobus roseus strain PX52 chromosome, complete genome	blastn	21042	348	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Limnoglobus	Limnoglobus roseus
17910160	17910160	PRJEB39643_P_NODE_96115_length_263_cov_1.621053_g95922_i0	PRJEB39643	96115	263	1.621053	4.26336939	Limnoglobus roseus	2598579	Bacteria	Bacteria	296	1e-75	NTclustered	gi\|1733446852\|gb\|CP042425.1\|	2598579	g95922	i0	87.5	28.7642585551331	256	32	97	0	1	256	812288	812033	Limnoglobus roseus strain PX52 chromosome, complete genome	blastn	7565	296	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Limnoglobus	Limnoglobus roseus
19183224	19183224	PRJEB39643_P_NODE_158016_length_223_cov_4.106667_g157822_i0	PRJEB39643	158016	223	4.106667	9.15786741	Frigoriglobus tundricola	2774151	Bacteria	Bacteria	187	5.1999999999999984e-43	NTclustered	gi\|1870286614\|gb\|CP053452.2\|	2774151	g157822	i0	84	4.39461883408072	200	27	88	5	27	223	4368128	4368325	Frigoriglobus tundricola strain PL17 chromosome, complete genome	blastn	980	187	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Frigoriglobus	Frigoriglobus tundricola
19183829	19183829	PRJEB39643_P_NODE_67256_length_277_cov_1.509804_g67063_i0	PRJEB39643	67256	277	1.509804	4.18215708	uncultured Gemmataceae bacterium	1914239	Bacteria	Bacteria	278	3.86e-70	NTclustered	gi\|2874253853\|emb\|OY969909.1\|	1914239	g67063	i0	84.838	7.76173285198556	277	40	99	2	1	275	3070548	3070824	MAG: uncultured Gemmataceae bacterium isolate MFD01275.bin.c.1 genome assembly, chromosome: 1	blastn	2150	278	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
20457980	20457980	PRJEB39643_P_NODE_106757_length_258_cov_1.664865_g106564_i0	PRJEB39643	106757	258	1.664865	4.2953517	Limnoglobus roseus	2598579	Bacteria	Bacteria	200	7.93e-47	NTclustered	gi\|1733446852\|gb\|CP042425.1\|	2598579	g106564	i0	82.278	1.77519379844961	237	36	91	6	1	234	787150	787383	Limnoglobus roseus strain PX52 chromosome, complete genome	blastn	458	200	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Limnoglobus	Limnoglobus roseus
21391514	21391514	PRJEB39643_P_NODE_19777_length_410_cov_1.952522_g19584_i0	PRJEB39643	19777	410	1.952522	8.0053402	Bacteria	2	Bacteria	Bacteria	54.7	0.011	NTclustered	gi\|2126063867\|gb\|CP085689.1\|	2886196	g19584	i0	100	0.141463414634146	29	0	7	0	179	207	2862583	2862555	Lentisphaerae bacterium WC36 chromosome, complete genome	blastn	58	54.7	1	Bacteria	PVC group	Pseudomonadati	Lentisphaerota					Lentisphaerae bacterium WC36
21734439	21734439	PRJEB39643_P_NODE_159918_length_200_cov_4.850394_g159724_i0	PRJEB39643	159918	200	4.850394	9.700788	uncultured Gemmataceae bacterium	1914239	Bacteria	Bacteria	246	7.43e-61	NTclustered	gi\|2874253853\|emb\|OY969909.1\|	1914239	g159724	i0	89.744	61.695	195	16	96	4	4	195	3845484	3845291	MAG: uncultured Gemmataceae bacterium isolate MFD01275.bin.c.1 genome assembly, chromosome: 1	blastn	12339	246	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
21735093	21735093	PRJEB39643_P_NODE_72898_length_274_cov_1.532338_g72705_i0	PRJEB39643	72898	274	1.532338	4.19860612	uncultured Gemmataceae bacterium	1914239	Bacteria	Bacteria	195	3.95e-45	NTclustered	gi\|2874253853\|emb\|OY969909.1\|	1914239	g72705	i0	81.702	2.4963503649635	235	41	85	2	1	234	9380685	9380918	MAG: uncultured Gemmataceae bacterium isolate MFD01275.bin.c.1 genome assembly, chromosome: 1	blastn	684	195	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
22666438	22666438	PRJEB39643_P_NODE_71898_length_275_cov_1.524752_g71705_i0	PRJEB39643	71898	275	1.524752	4.193068	root	1	Root_unresolved	Root_unresolved	52.8	0.025	NTclustered	gi\|2813917447\|gb\|CP170506.1\|	2811408	g71705	i0	100	0.203636363636364	28	0	10	0	1	28	5267480	5267507	MAG: Chthoniobacteraceae bacterium isolate SH-KS-3 chromosome, complete genome	blastn	56	52.8	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Spartobacteria	Chthoniobacterales	Chthoniobacteraceae		Chthoniobacteraceae bacterium
23010374	23010374	PRJEB39643_P_NODE_74519_length_273_cov_1.540000_g74326_i0	PRJEB39643	74519	273	1.54	4.2042	Luteolibacter ambystomatis	2824561	Bacteria	Bacteria	329	1.0299999999999998e-85	NTclustered	gi\|2029343589\|gb\|CP073100.1\|	2824561	g74326	i0	89.313	50.0586080586081	262	28	96	0	9	270	4710421	4710682	Luteolibacter ambystomatis strain 32A chromosome, complete genome	blastn	13666	329	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter ambystomatis

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