metadata: contig_metadata: 8 rows where bioproject = "PRJNA1151638", tax_clade = "PVC group" and tax

8 rows where bioproject = "PRJNA1151638", tax_clade = "PVC group" 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
1576603	1576603	PRJNA1151638_P_NODE_5022_length_251_cov_1.752809_g4955_i0	PRJNA1151638	5022	251	1.752809	4.39955059	uncultured Gemmataceae bacterium	1914239	Bacteria	Bacteria	211	3.55e-50	NTclustered	gi\|2874253853\|emb\|OY969909.1\|	1914239	g4955	i0	82.283	5.91235059760956	254	35	99	10	1	248	9492539	9492290	MAG: uncultured Gemmataceae bacterium isolate MFD01275.bin.c.1 genome assembly, chromosome: 1	blastn	1484	211	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
12515689	12515689	PRJNA1151638_P_NODE_2850_length_299_cov_1.035398_g2783_i0	PRJNA1151638	2850	299	1.035398	3.09584002	Bacteria	2	Bacteria	Bacteria	71.3	7.68e-8	NTclustered	gi\|1712585314\|gb\|CP036273.1\|	2528023	g2783	i0	97.561	0.989966555183946	41	1	18	0	69	109	2206261	2206221	Urbifossiella limnaea strain ETA_A1 chromosome, complete genome	blastn	296	71.3	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Urbifossiella	Urbifossiella limnaea
16879088	16879088	PRJNA1151638_P_NODE_6334_length_244_cov_0.912281_g6267_i0	PRJNA1151638	6334	244	0.912281	2.22596564	Planctomycetota bacterium	2026780	Bacteria	Bacteria	131	7.019999999999998e-35	NR	REK09410.1	2026780	g6267	i0	88.9	1.77049180327869	72	8	88.5	0	27	242	1	72	REK09410.1 MAG: gfo/Idh/MocA family oxidoreductase [Planctomycetota bacterium]	diamond	432	131	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
21438825	21438825	PRJNA1151638_P_NODE_1417_length_385_cov_2.407051_g1350_i0	PRJNA1151638	1417	385	2.407051	9.26714635	Pirellulales	2691354	Bacteria	Bacteria	377	5.34e-100	NTclustered	gi\|1712647354\|gb\|CP036289.1\|	2527984	g1350	i0	87.425	101.735064935065	334	34	86	8	1	332	2673687	2673360	Bremerella volcania strain Pan97 chromosome, complete genome	blastn	39168	377	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Bremerella	Bremerella volcania
22713899	22713899	PRJNA1151638_P_NODE_3618_length_276_cov_1.600985_g3551_i0	PRJNA1151638	3618	276	1.600985	4.4187186	Bacteria	2	Bacteria	Bacteria	57	5.07e-7	NR	MEY4395675.1	2026780	g3551	i0	45.5	5.59782608695652	77	38	79.3	1	3	221	355	431	MEY4395675.1 hypothetical protein [Planctomycetota bacterium]	diamond	1545	57	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
24527950	24527950	PRJNA1151638_P_NODE_5340_length_249_cov_1.619318_g5273_i0	PRJNA1151638	5340	249	1.619318	4.03210182	uncultured Gemmataceae bacterium	1914239	Bacteria	Bacteria	137	6.0499999999999996e-28	NTclustered	gi\|2874253853\|emb\|OY969909.1\|	1914239	g5273	i0	77.328	25.714859437751	247	46	97	10	1	242	4263252	4263493	MAG: uncultured Gemmataceae bacterium isolate MFD01275.bin.c.1 genome assembly, chromosome: 1	blastn	6403	137	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
30577172	30577172	PRJNA1151638_P_NODE_6773_length_242_cov_0.923077_g6706_i0	PRJNA1151638	6773	242	0.923077	2.23384634	Planctomycetota bacterium	2026780	Bacteria	Bacteria	98.6	1.7099999999999998e-23	NR	MCE9565124.1	2026780	g6706	i0	74.1	1.58677685950413	58	15	71.9	0	177	4	1	58	MCE9565124.1 oxidoreductase [Planctomycetota bacterium]	diamond	384	98.6	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
31399271	31399271	PRJNA1151638_P_NODE_2456_length_315_cov_2.334711_g2389_i0	PRJNA1151638	2456	315	2.334711	7.35433965	Planctomycetota bacterium	2026780	Bacteria	Bacteria	102	1.0300000000000001e-22	NR	MCC7510596.1	2026780	g2389	i0	49.5	1.96190476190476	103	51	97.1	1	309	4	747	849	MCC7510596.1 DNA polymerase III subunit alpha [Planctomycetota bacterium]	diamond	618	102	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);;