metadata: contig_metadata: 19 rows where bioproject = "PRJNA637328" and tax

19 rows where bioproject = "PRJNA637328" 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
608974	608974	PRJNA637328_P_NODE_16381_length_252_cov_2.886700_g15904_i0	PRJNA637328	16381	252	2.8867	7.274484	Tepidisphaeraceae bacterium	2876886	Bacteria	Bacteria	132	5.67e-36	NR	HEY7090713.1	2876886	g15904	i0	79.7	0.94047619047619	79	16	94	0	14	250	1	79	HEY7090713.1 5'/3'-nucleotidase SurE [Tepidisphaeraceae bacterium]	diamond	237	132	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Tepidisphaerales	Tepidisphaeraceae		Tepidisphaeraceae bacterium
1155175	1155175	PRJNA637328_P_NODE_6041_length_358_cov_2.271845_g5566_i0	PRJNA637328	6041	358	2.271845	8.1332051	root	1	Root_unresolved	Root_unresolved	187	8.909999999999998e-43	NTclustered	gi\|2916079367\|gb\|CP137543.1\|	83554	g5566	i0	90.714	76.3128491620112	140	13	80	0	1	140	469422	469561	Chlamydia psittaci strain LS-2203 chromosome, complete genome	blastn	27320	187	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales	Chlamydiaceae	Chlamydia	Chlamydia psittaci
1155187	1155187	PRJNA637328_S_NODE_2401_length_209_cov_1.703488_g2324_i0	PRJNA637328	2401	209	1.703488	3.56028992	Gemmata	113	Bacteria	Bacteria	342	9.709999999999999e-90	NTclustered	gi\|1804905141\|emb\|LR593886.1\|	1210884	g2324	i0	96.172	115.851674641148	209	8	100	0	1	209	3635600	3635392	Gemmata massiliana isolate Soil9 genome assembly, chromosome: 1	blastn	24213	342	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Gemmata	Gemmata massiliana
3159934	3159934	PRJNA637328_P_NODE_16583_length_251_cov_4.024752_g16106_i0	PRJNA637328	16583	251	4.024752	10.10212752	uncultured Verrucomicrobiota bacterium	156588	Bacteria	Bacteria	250	7.52e-62	NTclustered	gi\|226525261\|gb\|FJ872372.1\|	156588	g16106	i0	85.366	205.179282868526	246	31	97	5	3	245	11978	11735	Uncultured Verrucomicrobia bacterium clone 106 genomic sequence	blastn	51500	250	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					uncultured Verrucomicrobiota bacterium
4983402	4983402	PRJNA637328_S_NODE_3944_length_157_cov_0.975000_g3867_i0	PRJNA637328	3944	157	0.975	1.53075	Verrucomicrobiota	74201	Bacteria	Bacteria	276	7.06e-70	NTclustered	gi\|2874254065\|emb\|OY970130.1\|	412056	g3867	i0	98.71	174.191082802548	155	2	99	0	1	155	5154276	5154430	MAG: uncultured Verrucomicrobiae bacterium isolate MFD05705.bin.c.1 genome assembly, chromosome: 1	blastn	27348	276	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
13363361	13363361	PRJNA637328_S_NODE_1931_length_244_cov_1.478261_g1854_i0	PRJNA637328	1931	244	1.478261	3.60695684	Gemmata sp. SH-PL17	1630693	Bacteria	Bacteria	412	8.759999999999998e-111	NTclustered	gi\|1015440974\|gb\|CP011271.1\|	1630693	g1854	i0	97.131	40.844262295082	244	7	100	0	1	244	560096	559853	Gemmata sp. SH-PL17, complete genome	blastn	9966	412	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Gemmata	Gemmata sp. SH-PL17
14638120	14638120	PRJNA637328_S_NODE_1052_length_374_cov_2.192878_g975_i0	PRJNA637328	1052	374	2.192878	8.20136372	Frigoriglobus tundricola	2774151	Bacteria	Bacteria	595	1.3099999999999996e-165	NTclustered	gi\|1870286614\|gb\|CP053452.2\|	2774151	g975	i0	95.676	604.545454545455	370	16	99	0	1	370	4959490	4959859	Frigoriglobus tundricola strain PL17 chromosome, complete genome	blastn	226100	595	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Frigoriglobus	Frigoriglobus tundricola
15183599	15183599	PRJNA637328_S_NODE_1432_length_303_cov_2.101504_g1355_i0	PRJNA637328	1432	303	2.101504	6.36755712	Gemmataceae	1914233	Bacteria	Bacteria	433	8.63e-117	NTclustered	gi\|1727537522\|gb\|CP042911.1\|	114	g1355	i0	92.409	100.580858085809	303	23	100	0	1	303	1036166	1036468	Gemmata obscuriglobus strain DSM 5831 chromosome, complete genome	blastn	30476	433	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Gemmata	Gemmata obscuriglobus
15183609	15183609	PRJNA637328_S_NODE_3552_length_166_cov_1.186047_g3475_i0	PRJNA637328	3552	166	1.186047	1.96883802	Gemmataceae	1914233	Bacteria	Bacteria	279	5.86e-71	NTclustered	gi\|1804905141\|emb\|LR593886.1\|	1210884	g3475	i0	96.988	91.1024096385542	166	5	100	0	1	166	3633871	3633706	Gemmata massiliana isolate Soil9 genome assembly, chromosome: 1	blastn	15123	279	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Gemmata	Gemmata massiliana
16457876	16457876	PRJNA637328_S_NODE_2653_length_197_cov_1.375000_g2576_i0	PRJNA637328	2653	197	1.375	2.70875	Gemmata	113	Bacteria	Bacteria	309	9.17e-80	NTclustered	gi\|1804905141\|emb\|LR593886.1\|	1210884	g2576	i0	94.924	207.832487309645	197	10	100	0	1	197	3633974	3634170	Gemmata massiliana isolate Soil9 genome assembly, chromosome: 1	blastn	40943	309	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Gemmata	Gemmata massiliana
22286036	22286036	PRJNA637328_P_NODE_12778_length_271_cov_1.256757_g12302_i0	PRJNA637328	12778	271	1.256757	3.40581147	Neochlamydia sp. S13	1353976	Bacteria	Bacteria	233	8.27e-57	NTclustered	gi\|1550189844\|dbj\|AP017977.1\|	1353976	g12302	i0	82.353	135.287822878229	272	44	99	4	2	271	792241	791972	Neochlamydia sp. S13 DNA, complete genome	blastn	36663	233	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Neochlamydia	Neochlamydia sp. S13
27744663	27744663	PRJNA637328_S_NODE_3984_length_156_cov_1.033613_g3907_i0	PRJNA637328	3984	156	1.033613	1.61243628	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	40.8	0.0439	NR	GIT06037.1	2026799	g3907	i0	50	0.769230769230769	40	18	76.9	1	19	138	29	66	GIT06037.1 MAG: hypothetical protein CM1200mP29_14480 [Verrucomicrobiota bacterium]	diamond	120	40.8	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
27870572	27870572	PRJNA637328_P_NODE_13505_length_266_cov_3.580645_g13029_i0	PRJNA637328	13505	266	3.580645	9.5245157	Opitutia bacterium	2026771	Bacteria	Bacteria	119	3.71e-32	NR	MEL0099990.1	2026771	g13029	i0	62.5	1.98496240601504	88	33	99.2	0	266	3	14	101	MEL0099990.1 hypothetical protein [Opitutia bacterium]	diamond	528	119	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia				Opitutia bacterium
29828170	29828170	PRJNA637328_P_NODE_17431_length_248_cov_1.507538_g16954_i0	PRJNA637328	17431	248	1.507538	3.73869424	Planctomycetota bacterium	2026780	Bacteria	Bacteria	65.9	9.64e-11	NR	MCC7014462.1	2026780	g16954	i0	64.4	3.22983870967742	45	16	54.4	0	239	105	58	102	MCC7014462.1 hypothetical protein [Planctomycetota bacterium]	diamond	801	65.9	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
30365777	30365777	PRJNA637328_P_NODE_7112_length_334_cov_1.224561_g6637_i0	PRJNA637328	7112	334	1.224561	4.09003374	Opitutales bacterium	2026772	Bacteria	Bacteria	44.7	0.0194	NR	HNX04777.1	2026772	g6637	i0	42.6	0.94311377245509	54	20	45.8	2	57	209	14	59	HNX04777.1 prepilin peptidase [Opitutales bacterium]	diamond	315	44.7	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales			Opitutales bacterium
30460569	30460569	PRJNA637328_P_NODE_10573_length_289_cov_2.079167_g10098_i0	PRJNA637328	10573	289	2.079167	6.00879263	Lacipirellulaceae bacterium	2691534	Bacteria	Bacteria	182	6.09e-56	NR	HEX5471787.1	2691534	g10098	i0	82.3	1.98269896193772	96	17	99.7	0	288	1	52	147	HEX5471787.1 orotidine 5'-phosphate decarboxylase / HUMPS family protein [Lacipirellulaceae bacterium]	diamond	573	182	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Lacipirellulaceae		Lacipirellulaceae bacterium
30839286	30839286	PRJNA637328_P_NODE_13134_length_268_cov_4.972603_g12658_i0	PRJNA637328	13134	268	4.972603	13.32657604	Lacipirellulaceae bacterium	2691534	Bacteria	Bacteria	134	5.979999999999998e-35	NR	HVT29988.1	2691534	g12658	i0	69.3	1.97014925373134	88	27	98.5	0	264	1	347	434	HVT29988.1 CehA/McbA family metallohydrolase [Lacipirellulaceae bacterium]	diamond	528	134	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Lacipirellulaceae		Lacipirellulaceae bacterium
31389223	31389223	PRJNA637328_P_NODE_20376_length_231_cov_2.901099_g19899_i0	PRJNA637328	20376	231	2.901099	6.70153869	Bacteria	2	Bacteria	Bacteria	43.5	0.0171	NR	PIE24439.1	2026780	g19899	i0	36.7	2.36363636363636	60	35	74	1	10	180	196	255	PIE24439.1 MAG: hypothetical protein CSA62_03955 [Planctomycetota bacterium]	diamond	546	43.5	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
32199146	32199146	PRJNA637328_P_NODE_19058_length_241_cov_2.916667_g18581_i0	PRJNA637328	19058	241	2.916667	7.02916747	Planctomycetota bacterium	2026780	Bacteria	Bacteria	136	2.9199999999999996e-37	NR	TXT18583.1	2026780	g18581	i0	98.8	0.995850622406639	80	1	99.6	0	1	240	12	91	TXT18583.1 MAG: phosphonate transport system permease protein [Planctomycetota bacterium]	diamond	240	136	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota 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);;