metadata: contig_metadata: 16 rows where bioproject = "PRJNA1093008" and tax

16 rows where bioproject = "PRJNA1093008" 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
5301617	5301617	PRJNA1093008_S_NODE_67265_length_268_cov_1.794872_g66938_i0	PRJNA1093008	67265	268	1.794872	4.81025696	Luteolibacter sp.	1962973	Bacteria	Bacteria	412	9.77e-111	NTclustered	gi\|2836248208\|gb\|CP121322.1\|	1962973	g66938	i0	94.403	292.05223880597	268	15	100	0	1	268	1010179	1009912	MAG: Luteolibacter sp. isolate NCC532_bact_1514 chromosome, complete genome	blastn	78270	412	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter sp.
6576466	6576466	PRJNA1093008_S_NODE_43906_length_305_cov_1.659483_g43579_i0	PRJNA1093008	43906	305	1.659483	5.06142315	Rohdeia mirabilis	2528008	Bacteria	Bacteria	436	6.719999999999999e-118	NTclustered	gi\|1712658140\|gb\|CP036290.1\|	2528008	g43579	i0	92.557	128.170491803279	309	16	100	6	1	305	3892973	3893278	Planctomycetes bacterium Pla163 chromosome, complete genome	blastn	39092	436	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia			Rohdeia	Rohdeia mirabilis
9947189	9947189	PRJNA1093008_S_NODE_46968_length_299_cov_2.500000_g46641_i0	PRJNA1093008	46968	299	2.5	7.475	Planctomycetia	203683	Bacteria	Bacteria	401	2.3999999999999993e-107	NTclustered	gi\|2874254106\|emb\|OY970189.1\|	100233	g46641	i0	94.595	158.996655518395	259	14	87	0	1	259	4317940	4318198	MAG: uncultured Planctomycetaceae bacterium isolate MFD09603.bin.2.127 genome assembly, chromosome: 1	blastn	47540	403	0.995037220843672	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		uncultured Planctomycetaceae bacterium
16775749	16775749	PRJNA1093008_S_NODE_55334_length_285_cov_1.816038_g55007_i0	PRJNA1093008	55334	285	1.816038	5.1757083	Nibricoccus aquaticus	2576891	Bacteria	Bacteria	453	6.18e-123	NTclustered	gi\|1243404978\|gb\|CP023344.1\|	2576891	g55007	i0	98.819	31.4385964912281	254	3	89	0	7	260	2497239	2496986	Nibricoccus aquaticus strain HZ-65 chromosome, complete genome	blastn	8960	453	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Nibricoccus	Nibricoccus aquaticus
20145418	20145418	PRJNA1093008_S_NODE_54816_length_286_cov_1.446009_g54489_i0	PRJNA1093008	54816	286	1.446009	4.13558574	Opitutus	178440	Bacteria	Bacteria	438	1.7399999999999996e-118	NTclustered	gi\|470483113\|ref\|NR_076574.1\|	107709	g54489	i0	94.681	157.800699300699	282	15	99	0	1	282	1778	1497	Opitutus terrae strain PB90-1 23S ribosomal RNA gene, complete sequence	blastn	45131	438	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Opitutus	Opitutus terrae
26750686	26750686	PRJNA1093008_S_NODE_77521_length_255_cov_2.115385_g77194_i0	PRJNA1093008	77521	255	2.115385	5.39423175	Paludisphaera sp.	2017432	Bacteria	Bacteria	90.9	2.43e-19	NR	WP_337174845.1	2017432	g77194	i0	58.6	0.823529411764706	70	29	82.4	0	40	249	1	70	WP_337174845.1 carboxylate-amine ligase [Paludisphaera sp.]	diamond	210	90.9	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae	Paludisphaera	Paludisphaera sp.
28322222	28322222	PRJNA1093008_S_NODE_18006_length_384_cov_1.627010_g17679_i0	PRJNA1093008	18006	384	1.62701	6.2477184	Candidatus Merdousia	2840660	Bacteria	Bacteria	130	6.59e-35	NR	MBP3525086.1	2026772	g17679	i0	68.9	3.0234375	90	28	70.3	0	270	1	14	103	MBP3525086.1 YggS family pyridoxal phosphate-dependent enzyme [Opitutales bacterium]	diamond	1161	131	0.99236641221374	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales			Opitutales bacterium
28393964	28393964	PRJNA1093008_S_NODE_87906_length_246_cov_2.502890_g87579_i0	PRJNA1093008	87906	246	2.50289	6.1571094	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	42.7	0.0368	NR	MES2597082.1	2026799	g87579	i0	27.7	1.23170731707317	101	51	96.3	2	5	241	59	159	MES2597082.1 acyltransferase [Verrucomicrobiota bacterium]	diamond	303	42.7	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
28709951	28709951	PRJNA1093008_S_NODE_16967_length_389_cov_5.126582_g16640_i0	PRJNA1093008	16967	389	5.126582	19.94240398	Verrucomicrobiia bacterium	2499141	Bacteria	Bacteria	55.1	6.37e-6	NR	HEU6449705.1	2499141	g16640	i0	44	0.77120822622108	100	44	73.3	4	359	75	18	110	HEU6449705.1 KGG domain-containing protein [Verrucomicrobiia bacterium]	diamond	300	55.1	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				Verrucomicrobiia bacterium
29025845	29025845	PRJNA1093008_S_NODE_82588_length_250_cov_1.740113_g82261_i0	PRJNA1093008	82588	250	1.740113	4.3502825	Planctomycetota bacterium	2026780	Bacteria	Bacteria	42.7	0.0153	NR	MCH8217179.1	2026780	g82261	i0	26.5	0.816	68	47	78	1	250	56	1	68	MCH8217179.1 hypothetical protein [Planctomycetota bacterium]	diamond	204	42.7	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
29088763	29088763	PRJNA1093008_S_NODE_75308_length_258_cov_1.248649_g74981_i0	PRJNA1093008	75308	258	1.248649	3.22151442	Planctomycetaceae bacterium	2026779	Bacteria	Bacteria	43.5	0.0238	NR	MDR2438853.1	2026779	g74981	i0	43.8	0.558139534883721	48	22	50	1	186	58	133	180	MDR2438853.1 porin [Planctomycetaceae bacterium]	diamond	144	43.5	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		Planctomycetaceae bacterium
29435679	29435679	PRJNA1093008_S_NODE_79390_length_253_cov_1.877778_g79063_i0	PRJNA1093008	79390	253	1.877778	4.75077834	Opitutus sp.	1913982	Bacteria	Bacteria	45.1	0.00662	NR	MSU23188.1	1913982	g79063	i0	38.3	0.557312252964427	47	29	55.7	0	1	141	203	249	MSU23188.1 RNA polymerase-associated protein RapA [Opitutus sp.]	diamond	141	45.1	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Opitutus	Opitutus sp.
29467216	29467216	PRJNA1093008_S_NODE_97230_length_238_cov_2.260606_g96903_i0	PRJNA1093008	97230	238	2.260606	5.38024228	Chlamydiales bacterium STE3	1910938	Bacteria	Bacteria	42.7	0.0347	NR	KAF3361683.1	1910938	g96903	i0	43.8	0.605042016806723	48	27	60.5	0	26	169	347	394	KAF3361683.1 hypothetical protein PHSC3_001806 [Chlamydiales bacterium STE3]	diamond	144	42.7	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales			Chlamydiales bacterium STE3
30541494	30541494	PRJNA1093008_S_NODE_37193_length_319_cov_3.906504_g36866_i0	PRJNA1093008	37193	319	3.906504	12.46174776	Gemmataceae bacterium	2052164	Bacteria	Bacteria	42.4	0.0442	NR	MFO0841988.1	2052164	g36866	i0	53.8	0.244514106583072	26	12	24.5	0	216	139	81	106	MFO0841988.1 hypothetical protein [Gemmataceae bacterium]	diamond	78	42.4	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		Gemmataceae bacterium
32249294	32249294	PRJNA1093008_S_NODE_79018_length_254_cov_1.016575_g78691_i0	PRJNA1093008	79018	254	1.016575	2.5821005	Phycisphaerales bacterium	2052180	Bacteria	Bacteria	43.5	0.0226	NR	MSR40364.1	2052180	g78691	i0	28.4	1.03937007874016	88	41	78	2	28	225	380	467	MSR40364.1 hypothetical protein [Phycisphaerales bacterium]	diamond	264	43.5	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			Phycisphaerales bacterium
32557001	32557001	PRJNA1093008_S_NODE_16099_length_394_cov_3.828660_g15773_i0	PRJNA1093008	16099	394	3.82866	15.0849204	root	1	Root_unresolved	Root_unresolved	107	3.07e-26	NR	MBZ0109748.1	1872076	g15773	i0	56.1	4.90355329949239	107	45	80.7	2	3	320	76	181	MBZ0109748.1 DJ-1/PfpI family protein [Candidatus Scalindua rubra]	diamond	1932	107	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Candidatus Brocadiia	Candidatus Brocadiales	Candidatus Scalinduaceae	Candidatus Scalindua	Candidatus Scalindua rubra

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);;