metadata: contig_metadata: 21 rows where bioproject = "PRJNA1120586" and tax

21 rows where bioproject = "PRJNA1120586" 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
276150	276150	PRJNA1120586_P_NODE_38041_length_239_cov_1.282353_g37850_i0	PRJNA1120586	38041	239	1.282353	3.06482367	Prosthecobacter vanneervenii	48466	Bacteria	Bacteria	425	1.1e-114	NTclustered	gi\|12583975\|gb\|AF245379.1\|AF245379	48466	g37850	i0	98.745	169.836820083682	239	3	100	0	1	239	582	820	Prosthecobacter sp. FC-2 23S ribosomal RNA gene, partial sequence	blastn	40591	425	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Prosthecobacter	Prosthecobacter vanneervenii
1028381	1028381	PRJNA1120586_P_NODE_28441_length_265_cov_1.846939_g28250_i0	PRJNA1120586	28441	265	1.846939	4.89438835	Akkermansia	239934	Bacteria	Bacteria	490	4.3299999999999986e-134	NTclustered	gi\|1888387165\|gb\|CP058562.1\|	239935	g28250	i0	100	296	265	0	100	0	1	265	139143	139407	Akkermansia muciniphila strain AK32 chromosome, complete genome	blastn	78440	490	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Akkermansiaceae	Akkermansia	Akkermansia muciniphila
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
9204105	9204105	PRJNA1120586_P_NODE_37928_length_239_cov_1.694118_g37737_i0	PRJNA1120586	37928	239	1.694118	4.04894202	uncultured Verrucomicrobiales bacterium	100234	Bacteria	Bacteria	372	1.45e-98	NTclustered	gi\|220682330\|gb\|FJ542937.1\|	100234	g37737	i0	94.958	99.6610878661088	238	10	99	2	3	239	545	309	Uncultured Verrucomicrobiales bacterium clone B01-06A 16S ribosomal RNA gene, partial sequence	blastn	23819	372	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales			uncultured Verrucomicrobiales bacterium
15578891	15578891	PRJNA1120586_P_NODE_33313_length_251_cov_1.560440_g33122_i0	PRJNA1120586	33313	251	1.56044	3.9167044	Verrucomicrobiaceae bacterium	2026800	Bacteria	Bacteria	67.8	9.42e-13	NR	RYD71399.1	2026800	g33122	i0	53.4	0.872509960159363	73	34	87.3	0	219	1	6	78	RYD71399.1 MAG: hypothetical protein EOP84_24950, partial [Verrucomicrobiaceae bacterium]	diamond	219	67.8	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae		Verrucomicrobiaceae bacterium
18128219	18128219	PRJNA1120586_P_NODE_8155_length_413_cov_2.223837_g7964_i0	PRJNA1120586	8155	413	2.223837	9.18444681	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	675	0	NTclustered	gi\|2874253768\|emb\|OY969715.1\|	412056	g7964	i0	96.126	189.217917675545	413	16	100	0	1	413	915205	915617	MAG: uncultured Verrucomicrobiae bacterium isolate MFD01916.bin.1.1 genome assembly, chromosome: 1	blastn	78147	675	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae 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
26785450	26785450	PRJNA1120586_P_NODE_44461_length_232_cov_0.883436_g44270_i0	PRJNA1120586	44461	232	0.883436	2.04957152	Opitutaceae bacterium	2006848	Bacteria	Bacteria	78.6	3.22e-16	NR	MFA5056513.1	2006848	g44270	i0	50	1.00862068965517	78	38	99.6	1	1	231	15	92	MFA5056513.1 hypothetical protein [Opitutaceae bacterium]	diamond	234	78.6	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae		Opitutaceae bacterium
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
29690714	29690714	PRJNA1120586_P_NODE_41870_length_234_cov_0.872727_g41679_i0	PRJNA1120586	41870	234	0.872727	2.04218118	Opitutaceae bacterium	2006848	Bacteria	Bacteria	65.1	4.53e-10	NR	MCE2861284.1	2006848	g41679	i0	93.9	1.26923076923077	33	2	42.3	0	1	99	731	763	MCE2861284.1 oligopeptide transporter, OPT family [Opitutaceae bacterium]	diamond	297	65.1	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae		Opitutaceae 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.
31460795	31460795	PRJNA1120586_P_NODE_44076_length_232_cov_0.883436_g43885_i0	PRJNA1120586	44076	232	0.883436	2.04957152	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	155	6.889999999999998e-42	NR	MEY4688418.1	2026799	g43885	i0	97.4	1.99137931034483	77	2	99.6	0	231	1	580	656	MEY4688418.1 hypothetical protein [Verrucomicrobiota bacterium]	diamond	462	155	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
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);;