metadata: contig_metadata: 8 rows where bioproject = "PRJNA893346" and tax

8 rows where bioproject = "PRJNA893346" 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_species
18719726	18719726	PRJNA893346_P_NODE_29275_length_276_cov_1.477833_g28785_i0	PRJNA893346	29275	276	1.477833	4.07881908	Gemmataceae bacterium	2052164	Bacteria	Bacteria	129	5.709999999999999e-34	NR	HZZ81531.1	2052164	g28785	i0	63.3	3.8804347826087	90	33	97.8	0	274	5	221	310	HZZ81531.1 phosphoglycerate kinase [Gemmataceae bacterium]	diamond	1071	129	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Gemmataceae bacterium
27245220	27245220	PRJNA893346_P_NODE_29943_length_272_cov_1.155779_g29453_i0	PRJNA893346	29943	272	1.155779	3.14371888	Verrucomicrobiales bacterium	2026801	Bacteria	Bacteria	57.4	3.77e-7	NR	HAE18699.1	2026801	g29453	i0	36	3.92647058823529	89	53	98.2	2	269	3	426	510	HAE18699.1 hypothetical protein [Verrucomicrobiales bacterium]	diamond	1068	57.4	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales		Verrucomicrobiales bacterium
27695501	27695501	PRJNA893346_P_NODE_35844_length_247_cov_0.885057_g35354_i0	PRJNA893346	35844	247	0.885057	2.18609079	Pseudomonadati	3379134	Bacteria	Bacteria	45.1	0.00592	NR	MDA1274163.1	2026799	g35354	i0	43.1	2.22267206477733	58	29	68	2	59	226	60	115	MDA1274163.1 hypothetical protein [Verrucomicrobiota bacterium]	diamond	549	45.1	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota				Verrucomicrobiota bacterium
31035374	31035374	PRJNA893346_P_NODE_25555_length_300_cov_1.647577_g25065_i0	PRJNA893346	25555	300	1.647577	4.942731	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	44.3	0.0134	NR	MEI6341235.1	2026799	g25065	i0	36	0.75	75	39	66	2	205	8	84	158	MEI6341235.1 permease prefix domain 1-containing protein [Verrucomicrobiota bacterium]	diamond	225	44.3	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota				Verrucomicrobiota bacterium
31066879	31066879	PRJNA893346_P_NODE_39795_length_241_cov_0.916667_g39305_i0	PRJNA893346	39795	241	0.916667	2.20916747	Candidatus Omnitrophota bacterium	2035772	Bacteria	Bacteria	71.2	2.87e-12	NR	MBI5023900.1	2035772	g39305	i0	49.2	1.61825726141079	63	32	78.4	0	2	190	133	195	MBI5023900.1 molecular chaperone DnaJ [Candidatus Omnitrophota bacterium]	diamond	390	71.2	1	Bacteria	PVC group	Pseudomonadati	Candidatus Omnitrophota				Candidatus Omnitrophota bacterium
31446088	31446088	PRJNA893346_P_NODE_8136_length_558_cov_1.501031_g7656_i0	PRJNA893346	8136	558	1.501031	8.37575298	Candidatus Omnitrophota bacterium	2035772	Bacteria	Bacteria	54.3	8.33e-5	NR	MBF0533231.1	2035772	g7656	i0	24.3	1.59139784946237	136	103	73.1	0	510	103	1622	1757	MBF0533231.1 fibronectin type III domain-containing protein [Candidatus Omnitrophota bacterium]	diamond	888	54.3	1	Bacteria	PVC group	Pseudomonadati	Candidatus Omnitrophota				Candidatus Omnitrophota bacterium
31699142	31699142	PRJNA893346_P_NODE_32577_length_255_cov_1.269231_g32087_i0	PRJNA893346	32577	255	1.269231	3.23653905	Planctomycetota bacterium	2026780	Bacteria	Bacteria	103	7.4e-24	NR	GDY13910.1	2026780	g32087	i0	62.4	1	85	32	100	0	1	255	261	345	GDY13910.1 hypothetical protein LBMAG53_27880 [Planctomycetota bacterium]	diamond	255	103	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota				Planctomycetota bacterium
31699150	31699150	PRJNA893346_P_NODE_5517_length_690_cov_1.416532_g5057_i0	PRJNA893346	5517	690	1.416532	9.7740708	Planctomycetota bacterium	2026780	Bacteria	Bacteria	68.2	3.97e-9	NR	MBC8354889.1	2026780	g5057	i0	28.7	2.36521739130435	188	115	77	6	156	686	174	353	MBC8354889.1 DUF11 domain-containing protein [Planctomycetota bacterium]	diamond	1632	68.2	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);;