metadata: contig_metadata: 13 rows where bioproject = "PRJNA1120586", tax_clade = "PVC group" and tax

13 rows where bioproject = "PRJNA1120586", 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
1550308	1550308	PRJNA1120586_P_NODE_14162_length_336_cov_2.883895_g13971_i0	PRJNA1120586	14162	336	2.883895	9.6898872	Urbifossiella limnaea	2528023	Bacteria	Bacteria	337	7.81e-88	NTclustered	gi\|1712585314\|gb\|CP036273.1\|	2528023	g13971	i0	84.956	248.738095238095	339	44	100	5	1	336	4211930	4212264	Urbifossiella limnaea strain ETA_A1 chromosome, complete genome	blastn	83576	337	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Urbifossiella	Urbifossiella limnaea
1550469	1550469	PRJNA1120586_P_NODE_24882_length_277_cov_3.346154_g24691_i0	PRJNA1120586	24882	277	3.346154	9.26884658	Urbifossiella limnaea	2528023	Bacteria	Bacteria	348	2.9e-91	NTclustered	gi\|1712585314\|gb\|CP036273.1\|	2528023	g24691	i0	89.455	125.72202166065	275	29	99	0	1	275	2019590	2019864	Urbifossiella limnaea strain ETA_A1 chromosome, complete genome	blastn	34825	348	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Urbifossiella	Urbifossiella limnaea
1550828	1550828	PRJNA1120586_P_NODE_44562_length_231_cov_5.567901_g44371_i0	PRJNA1120586	44562	231	5.567901	12.86185131	uncultured Gemmata sp.	459262	Bacteria	Bacteria	394	2.98e-105	NTclustered	gi\|330376222\|gb\|JF731389.1\|	459262	g44371	i0	97.403	99.987012987013	231	6	100	0	1	231	432	202	Uncultured Gemmata sp. clone BacTopLow012 16S ribosomal RNA gene, partial sequence	blastn	23097	394	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Gemmata	uncultured Gemmata sp.
4103449	4103449	PRJNA1120586_P_NODE_51524_length_227_cov_0.911392_g51333_i0	PRJNA1120586	51524	227	0.911392	2.06885984	Planctomycetota bacterium	2026780	Bacteria	Bacteria	164	6.72e-45	NR	RLT10205.1	2026780	g51333	i0	94.7	0.991189427312775	75	4	99.1	0	3	227	307	381	RLT10205.1 MAG: DUF1553 domain-containing protein [Planctomycetota bacterium]	diamond	225	164	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
21953030	21953030	PRJNA1120586_P_NODE_43178_length_233_cov_0.878049_g42987_i0	PRJNA1120586	43178	233	0.878049	2.04585417	Planctomyces	118	Bacteria	Bacteria	156	6.59e-43	NR	MFN5899559.1	37635	g42987	i0	100	3.9656652360515	77	0	99.1	0	2	232	248	324	MFN5899559.1 hypothetical protein [Planctomyces sp.]	diamond	924	156	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Planctomyces	Planctomyces sp.
22705390	22705390	PRJNA1120586_P_NODE_50638_length_227_cov_1.069620_g50447_i0	PRJNA1120586	50638	227	1.06962	2.4280374	Bacteria	2	Bacteria	Bacteria	196	8.829999999999999e-46	NTclustered	gi\|2874254043\|emb\|OY970367.1\|	120965	g50447	i0	82.667	291.396475770925	225	35	99	4	1	225	3454566	3454786	MAG: uncultured Planctomycetota bacterium isolate MFD04580.bin.c.2 genome assembly, chromosome: 1	blastn	66147	196	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					uncultured Planctomycetota bacterium
23980679	23980679	PRJNA1120586_P_NODE_3439_length_580_cov_2.802348_g3252_i0	PRJNA1120586	3439	580	2.802348	16.2536184	Limnoglobus	2731450	Bacteria	Bacteria	695	0	NTclustered	gi\|2874253853\|emb\|OY969909.1\|	1914239	g3252	i0	88.356	309.872413793103	584	61	100	6	1	580	2002294	2002874	MAG: uncultured Gemmataceae bacterium isolate MFD01275.bin.c.1 genome assembly, chromosome: 1	blastn	179726	699	0.994277539341917	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
24502457	24502457	PRJNA1120586_P_NODE_9740_length_386_cov_1.640379_g9549_i0	PRJNA1120586	9740	386	1.640379	6.33186294	Frigoriglobus tundricola	2774151	Bacteria	Bacteria	532	1.08e-146	NTclustered	gi\|1870286614\|gb\|CP053452.2\|	2774151	g9549	i0	91.582	151.253886010363	392	23	99	5	1	383	4959452	4959842	Frigoriglobus tundricola strain PL17 chromosome, complete genome	blastn	58384	532	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Frigoriglobus	Frigoriglobus tundricola
29280467	29280467	PRJNA1120586_P_NODE_34109_length_249_cov_1.311111_g33918_i0	PRJNA1120586	34109	249	1.311111	3.26466639	Planctomycetota bacterium	2026780	Bacteria	Bacteria	84.3	1.36e-18	NR	MCH8147290.1	2026780	g33918	i0	100	0.506024096385542	42	0	50.6	0	3	128	100	141	MCH8147290.1 aspartate 1-decarboxylase [Planctomycetota bacterium]	diamond	126	84.3	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
30007051	30007051	PRJNA1120586_P_NODE_25171_length_276_cov_2.647343_g24980_i0	PRJNA1120586	25171	276	2.647343	7.30666668	Planctomycetota bacterium	2026780	Bacteria	Bacteria	122	3.07e-32	NR	MCH8147293.1	2026780	g24980	i0	100	0.619565217391304	57	0	62	0	276	106	186	242	MCH8147293.1 hypothetical protein [Planctomycetota bacterium]	diamond	171	122	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
30564543	30564543	PRJNA1120586_P_NODE_15833_length_324_cov_1.101961_g15642_i0	PRJNA1120586	15833	324	1.101961	3.57035364	Pseudomonadati	3379134	Bacteria	Bacteria	206	2.99e-64	NR	MBA4040115.1	37635	g15642	i0	100	2	108	0	100	0	324	1	97	204	MBA4040115.1 glycosyltransferase [Planctomyces sp.]	diamond	648	206	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Planctomyces	Planctomyces sp.
31081244	31081244	PRJNA1120586_P_NODE_23935_length_281_cov_2.193396_g23744_i0	PRJNA1120586	23935	281	2.193396	6.16344276	Planctomyces sp.	37635	Bacteria	Bacteria	157	2.31e-45	NR	MBA4040115.1	37635	g23744	i0	96.4	0.886120996441281	83	3	88.6	0	32	280	1	83	MBA4040115.1 glycosyltransferase [Planctomyces sp.]	diamond	249	157	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Planctomyces	Planctomyces sp.
32568079	32568079	PRJNA1120586_P_NODE_8659_length_404_cov_2.047761_g8468_i0	PRJNA1120586	8659	404	2.047761	8.27295444	Planctomycetota bacterium	2026780	Bacteria	Bacteria	282	8.089999999999999e-90	NR	MCH8147294.1	2026780	g8468	i0	100	0.995049504950495	134	0	99.5	0	403	2	257	390	MCH8147294.1 non-ribosomal peptide synthetase [Planctomycetota bacterium]	diamond	402	282	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);;