metadata: contig_metadata: 23 rows where bioproject = "PRJNA801875" and tax

23 rows where bioproject = "PRJNA801875" 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
3351969	3351969	PRJNA801875_P_NODE_1703_length_289_cov_1.496063_g1600_i0	PRJNA801875	1703	289	1.496063	4.32362207	uncultured Parachlamydiaceae bacterium	464461	Bacteria	Bacteria	331	3.07e-86	NTclustered	gi\|2874253811\|emb\|OY969795.1\|	464461	g1600	i0	87.805	189.314878892734	287	30	98	4	3	286	655090	655374	MAG: uncultured Parachlamydiaceae bacterium isolate MFD05502.bin.c.3 genome assembly, chromosome: 1	blastn	54712	331	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae		uncultured Parachlamydiaceae bacterium
3352006	3352006	PRJNA801875_P_NODE_63_length_1602_cov_7.909381_g37_i0	PRJNA801875	63	1602	7.909381	126.70828362	Phycisphaeraceae bacterium	2026777	Bacteria	Bacteria	2143	0	NTclustered	gi\|1927958621\|gb\|CP054186.1\|	2026777	g37	i0	90.875	355.411985018727	1611	127	99	16	1	1599	1867800	1866198	MAG: Phycisphaeraceae bacterium isolate H1_PLA1 chromosome	blastn	569370	2143	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales	Phycisphaeraceae		Phycisphaeraceae bacterium
7179396	7179396	PRJNA801875_P_NODE_266_length_878_cov_5.584816_g188_i0	PRJNA801875	266	878	5.584816	49.03468448	Urbifossiella limnaea	2528023	Bacteria	Bacteria	1314	0	NTclustered	gi\|1712585314\|gb\|CP036273.1\|	2528023	g188	i0	93.95	165.386104783599	876	41	99	12	1	867	2019352	2018480	Urbifossiella limnaea strain ETA_A1 chromosome, complete genome	blastn	145209	1314	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Urbifossiella	Urbifossiella limnaea
9729153	9729153	PRJNA801875_P_NODE_2468_length_219_cov_4.048913_g2365_i0	PRJNA801875	2468	219	4.048913	8.86711947	Urbifossiella limnaea	2528023	Bacteria	Bacteria	335	1.7199999999999992e-87	NTclustered	gi\|1712585314\|gb\|CP036273.1\|	2528023	g2365	i0	94.86	128.643835616438	214	11	98	0	3	216	2020229	2020016	Urbifossiella limnaea strain ETA_A1 chromosome, complete genome	blastn	28173	335	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Urbifossiella	Urbifossiella limnaea
14829486	14829486	PRJNA801875_P_NODE_1392_length_332_cov_4.767677_g1289_i0	PRJNA801875	1392	332	4.767677	15.82868764	Bacteria	2	Bacteria	Bacteria	109	9.42e-27	NR	WP_006341469.1	83552	g1289	i0	74.3	8.06024096385542	70	18	63.3	0	312	103	1	70	WP_006341469.1 SDR family NAD(P)-dependent oxidoreductase [Parachlamydia acanthamoebae]	diamond	2676	110	0.990909090909091	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Parachlamydia	Parachlamydia acanthamoebae
14829498	14829498	PRJNA801875_P_NODE_2712_length_205_cov_3.835294_g2609_i0	PRJNA801875	2712	205	3.835294	7.8623527	Phycisphaeraceae bacterium	2026777	Bacteria	Bacteria	313	7.4399999999999995e-81	NTclustered	gi\|1927958621\|gb\|CP054186.1\|	2026777	g2609	i0	94.146	338.892682926829	205	12	100	0	1	205	1868496	1868292	MAG: Phycisphaeraceae bacterium isolate H1_PLA1 chromosome	blastn	69473	313	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales	Phycisphaeraceae		Phycisphaeraceae bacterium
15249858	15249858	PRJNA801875_P_NODE_2472_length_219_cov_2.500000_g2369_i0	PRJNA801875	2472	219	2.5	5.475	Bacteria	2	Bacteria	Bacteria	219	1.8099999999999993e-52	NTclustered	gi\|2874253676\|emb\|OY969110.1\|	305355	g2369	i0	85.377	117.972602739726	212	29	97	2	5	216	415119	415328	MAG: uncultured Chlamydiae bacterium isolate MFD00082.bin.c.5 genome assembly, chromosome: 1	blastn	25836	220	0.995454545454545	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia				uncultured Chlamydiae bacterium
15249880	15249880	PRJNA801875_P_NODE_652_length_534_cov_1.687375_g550_i0	PRJNA801875	652	534	1.687375	9.0105825	Opitutaceae	134623	Bacteria	Bacteria	95.3	8.59e-15	NTclustered	gi\|573471959\|gb\|CP007053.1\|	794903	g550	i0	76.216	18.9569288389513	185	40	34	4	141	323	2149300	2149118	Opitutaceae bacterium TAV5, complete genome	blastn	10123	95.3	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae		Opitutaceae bacterium TAV5
17379468	17379468	PRJNA801875_P_NODE_3134_length_187_cov_2.980263_g3031_i0	PRJNA801875	3134	187	2.980263	5.57309181	uncultured Chlamydiae bacterium	305355	Bacteria	Bacteria	322	1.1e-83	NTclustered	gi\|116292835\|gb\|DQ996922.1\|	305355	g3031	i0	97.849	106.48128342246	186	4	99	0	2	187	581	396	Uncultured Chlamydiae bacterium clone MD2896-0.1m.78 16S ribosomal RNA gene, partial sequence	blastn	19912	322	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia				uncultured Chlamydiae bacterium
17379482	17379482	PRJNA801875_P_NODE_4274_length_158_cov_1.666667_g4171_i0	PRJNA801875	4274	158	1.666667	2.63333386	uncultured Parachlamydiaceae bacterium	464461	Bacteria	Bacteria	230	5.619999999999999e-56	NTclustered	gi\|2874253811\|emb\|OY969795.1\|	464461	g4171	i0	94.595	311.291139240506	148	8	94	0	10	157	655043	654896	MAG: uncultured Parachlamydiaceae bacterium isolate MFD05502.bin.c.3 genome assembly, chromosome: 1	blastn	49184	230	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae		uncultured Parachlamydiaceae bacterium
17379488	17379488	PRJNA801875_P_NODE_594_length_565_cov_4.316981_g494_i0	PRJNA801875	594	565	4.316981	24.39094265	Urbifossiella limnaea	2528023	Bacteria	Bacteria	867	0	NTclustered	gi\|1712585314\|gb\|CP036273.1\|	2528023	g494	i0	94.504	232.053097345133	564	27	99	4	4	565	4212510	4211949	Urbifossiella limnaea strain ETA_A1 chromosome, complete genome	blastn	131110	867	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Urbifossiella	Urbifossiella limnaea
27591462	27591462	PRJNA801875_P_NODE_2664_length_208_cov_1.346821_g2561_i0	PRJNA801875	2664	208	1.346821	2.80138768	Planctomycetota bacterium	2026780	Bacteria	Bacteria	84.3	7.68e-18	NR	HKE02376.1	2026780	g2561	i0	64.7	1.96153846153846	68	23	96.6	1	206	6	144	211	HKE02376.1 glucose 1-dehydrogenase [Planctomycetota bacterium]	diamond	408	84.3	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
28443931	28443931	PRJNA801875_P_NODE_666_length_527_cov_2.611789_g564_i0	PRJNA801875	666	527	2.611789	13.76412803	Verrucomicrobiaceae bacterium	2026800	Bacteria	Bacteria	262	1.27e-84	NR	RYD65414.1	2026800	g564	i0	73	0.990512333965844	174	45	99.1	1	523	2	146	317	RYD65414.1 MAG: hypothetical protein EOP84_31955 [Verrucomicrobiaceae bacterium]	diamond	522	262	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae		Verrucomicrobiaceae bacterium
28790940	28790940	PRJNA801875_P_NODE_1307_length_348_cov_2.977636_g1204_i0	PRJNA801875	1307	348	2.977636	10.36217328	Chthoniobacteraceae bacterium	2811408	Bacteria	Bacteria	152	1.3399999999999996e-43	NR	HEY2344067.1	2811408	g1204	i0	67	1.98275862068966	115	38	99.1	0	346	2	27	141	HEY2344067.1 glucose 1-dehydrogenase [Chthoniobacteraceae bacterium]	diamond	690	152	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Spartobacteria	Chthoniobacterales	Chthoniobacteraceae		Chthoniobacteraceae bacterium
28822341	28822341	PRJNA801875_P_NODE_2408_length_224_cov_1.407407_g2305_i0	PRJNA801875	2408	224	1.407407	3.15259168	Planctomycetota bacterium	2026780	Bacteria	Bacteria	124	1.7199999999999995e-31	NR	MCK6445862.1	2026780	g2305	i0	75.3	6.80357142857143	73	18	97.8	0	221	3	197	269	MCK6445862.1 cystathionine beta-synthase [Planctomycetota bacterium]	diamond	1524	124	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
28854042	28854042	PRJNA801875_P_NODE_3128_length_188_cov_1.228758_g3025_i0	PRJNA801875	3128	188	1.228758	2.31006504	Verrucomicrobiaceae bacterium	2026800	Bacteria	Bacteria	82	1.57e-16	NR	RYD71398.1	2026800	g3025	i0	62.3	0.973404255319149	61	23	97.3	0	184	2	229	289	RYD71398.1 MAG: hypothetical protein EOP84_24945, partial [Verrucomicrobiaceae bacterium]	diamond	183	82	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae		Verrucomicrobiaceae bacterium
30338971	30338971	PRJNA801875_P_NODE_2532_length_215_cov_1.872222_g2429_i0	PRJNA801875	2532	215	1.872222	4.0252773	Chthoniobacterales bacterium	2201154	Bacteria	Bacteria	81.6	9.57e-17	NR	HEY8903241.1	2201154	g2429	i0	60.3	5.41395348837209	63	25	87.9	0	6	194	32	94	HEY8903241.1 SDR family oxidoreductase [Chthoniobacterales bacterium]	diamond	1164	81.6	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Spartobacteria	Chthoniobacterales			Chthoniobacterales bacterium
30654344	30654344	PRJNA801875_P_NODE_1993_length_257_cov_1.815315_g1890_i0	PRJNA801875	1993	257	1.815315	4.66535955	Planctomycetota bacterium	2026780	Bacteria	Bacteria	46.6	0.00203	NR	GDY11708.1	2026780	g1890	i0	43.9	1.4124513618677	57	28	65.4	2	237	70	3022	3075	GDY11708.1 hypothetical protein LBMAG53_05860 [Planctomycetota bacterium]	diamond	363	46.6	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
31065455	31065455	PRJNA801875_P_NODE_1895_length_269_cov_1.606838_g1792_i0	PRJNA801875	1895	269	1.606838	4.32239422	Planctomycetaceae bacterium	2026779	Bacteria	Bacteria	105	5.59e-25	NR	MAG94705.1	2026779	g1792	i0	57.5	1.95167286245353	87	35	95.9	2	2	259	96	181	MAG94705.1 hypothetical protein [Planctomycetaceae bacterium]	diamond	525	105	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		Planctomycetaceae bacterium
31950627	31950627	PRJNA801875_P_NODE_277_length_867_cov_9.108173_g197_i0	PRJNA801875	277	867	9.108173	78.96785991	Phycisphaerales bacterium	2052180	Bacteria	Bacteria	72.8	2.93e-10	NR	NOT01860.1	2052180	g197	i0	29.1	0.688581314878893	199	133	67.5	6	864	280	27	221	NOT01860.1 DUF4215 domain-containing protein [Phycisphaerales bacterium]	diamond	597	72.8	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			Phycisphaerales bacterium
32330758	32330758	PRJNA801875_P_NODE_3639_length_172_cov_1.204380_g3536_i0	PRJNA801875	3639	172	1.20438	2.0715336	Phycisphaerales bacterium	2052180	Bacteria	Bacteria	47	4.47e-4	NR	HYE61306.1	2052180	g3536	i0	44.6	0.976744186046512	56	30	97.7	1	3	170	618	672	HYE61306.1 hypothetical protein [Phycisphaerales bacterium]	diamond	168	47	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			Phycisphaerales bacterium
32466068	32466068	PRJNA801875_P_NODE_1779_length_280_cov_3.640816_g1676_i0	PRJNA801875	1779	280	3.640816	10.1942848	Planctomycetia	203683	Bacteria	Bacteria	47.8	9.87e-4	NR	MFM7518713.1	117	g1676	i0	45.6	3.38571428571429	79	39	83.6	2	249	16	243	318	MFM7518713.1 hypothetical protein [Pirellula sp.]	diamond	948	47.8	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Pirellula	Pirellula sp.
32520526	32520526	PRJNA801875_P_NODE_1059_length_396_cov_2.662050_g956_i0	PRJNA801875	1059	396	2.66205	10.541718	Planctomycetaceae bacterium	2026779	Bacteria	Bacteria	75.5	7.64e-13	NR	MEZ6056578.1	2026779	g956	i0	43.4	0.856060606060606	113	63	84.8	1	380	45	1334	1446	MEZ6056578.1 Ig-like domain-containing protein [Planctomycetaceae bacterium]	diamond	339	75.5	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		Planctomycetaceae 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);;