metadata: contig_metadata: 10 rows where analysis = "diamond", bioproject = "PRJNA767802" and tax

10 rows where analysis = "diamond", bioproject = "PRJNA767802" 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
16047753	16047753	PRJNA767802_P_NODE_16013_length_167_cov_0.864407_g15940_i0	PRJNA767802	16013	167	0.864407	1.44355969	Pirellulimonas	2795783	Bacteria	Bacteria	101	3.23e-23	NR	MEN1680226.1	2026780	g15940	i0	87.3	2.96407185628743	55	7	98.8	0	1	165	521	575	MEN1680226.1 CRISPR-associated helicase Cas3' [Planctomycetota bacterium]	diamond	495	102	0.990196078431373	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
23698152	23698152	PRJNA767802_P_NODE_3919_length_437_cov_1.311856_g3846_i0	PRJNA767802	3919	437	1.311856	5.73281072	Pirellulaceae bacterium	2699754	Bacteria	Bacteria	276	7.88e-89	NR	MBC7856119.1	2699754	g3846	i0	98.6	0.995423340961098	145	2	99.5	0	437	3	162	306	MBC7856119.1 sigma-54-dependent Fis family transcriptional regulator [Pirellulaceae bacterium]	diamond	435	276	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae		Pirellulaceae bacterium
26926677	26926677	PRJNA767802_P_NODE_18482_length_162_cov_0.902655_g18409_i0	PRJNA767802	18482	162	0.902655	1.4623011	Botrimarina mediterranea	2528022	Bacteria	Bacteria	77	8.32e-15	NR	WP_145116791.1	2528022	g18409	i0	72.2	1	54	13	100	1	1	162	289	340	WP_145116791.1 DUF1559 domain-containing protein [Botrimarina mediterranea]	diamond	162	77	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Lacipirellulaceae	Botrimarina	Botrimarina mediterranea
27432703	27432703	PRJNA767802_P_NODE_11163_length_211_cov_1.574074_g11090_i0	PRJNA767802	11163	211	1.574074	3.32129614	Pirellulaceae bacterium	2699754	Bacteria	Bacteria	131	2e-34	NR	MBC7856119.1	2699754	g11090	i0	94.2	0.981042654028436	69	4	98.1	0	3	209	310	378	MBC7856119.1 sigma-54-dependent Fis family transcriptional regulator [Pirellulaceae bacterium]	diamond	207	131	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae		Pirellulaceae bacterium
27811566	27811566	PRJNA767802_P_NODE_4204_length_416_cov_1.915531_g4131_i0	PRJNA767802	4204	416	1.915531	7.96860896	Fimbriiglobus ruber	1908690	Bacteria	Bacteria	127	9.47e-33	NR	WP_161967608.1	1908690	g4131	i0	49.6	0.987980769230769	137	64	95.2	2	5	400	45	181	WP_161967608.1 c-type cytochrome [Fimbriiglobus ruber]	diamond	411	127	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Fimbriiglobus	Fimbriiglobus ruber
30495697	30495697	PRJNA767802_P_NODE_1773_length_687_cov_1.719436_g1715_i0	PRJNA767802	1773	687	1.719436	11.81252532	Pirellulales bacterium	2715253	Bacteria	Bacteria	268	3.059999999999999e-87	NR	MFO0903704.1	2715253	g1715	i0	92	0.59825327510917	137	11	59.8	0	411	1	1	137	MFO0903704.1 glycosyltransferase [Pirellulales bacterium]	diamond	411	268	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales			Pirellulales bacterium
30938052	30938052	PRJNA767802_P_NODE_8054_length_265_cov_1.879630_g7981_i0	PRJNA767802	8054	265	1.87963	4.9810195	Pirellulaceae bacterium	2699754	Bacteria	Bacteria	172	1.29e-49	NR	MBC7856119.1	2699754	g7981	i0	97.7	0.984905660377358	87	2	98.5	0	263	3	63	149	MBC7856119.1 sigma-54-dependent Fis family transcriptional regulator [Pirellulaceae bacterium]	diamond	261	172	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae		Pirellulaceae bacterium
32266443	32266443	PRJNA767802_P_NODE_10038_length_226_cov_1.389831_g9965_i0	PRJNA767802	10038	226	1.389831	3.14101806	Pirellulaceae bacterium	2699754	Bacteria	Bacteria	132	6.42e-34	NR	MFN0018561.1	2699754	g9965	i0	91.8	0.969026548672566	73	6	96.9	0	7	225	31	103	MFN0018561.1 tetratricopeptide repeat protein [Pirellulaceae bacterium]	diamond	219	132	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae		Pirellulaceae bacterium
32812441	32812441	PRJNA767802_P_NODE_4460_length_400_cov_4.339031_g4387_i0	PRJNA767802	4460	400	4.339031	17.356124	Pseudomonadati	3379134	Bacteria	Bacteria	55.5	2.22e-6	NR	MBN1442838.1	2026780	g4387	i0	43.6	2.31	101	53	75.8	1	1	303	63	159	MBN1442838.1 hypothetical protein [Planctomycetota bacterium]	diamond	924	55.8	0.99462365591397806	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
32906857	32906857	PRJNA767802_P_NODE_3600_length_459_cov_2.475610_g3527_i0	PRJNA767802	3600	459	2.47561	11.3630499	Pseudomonadati	3379134	Bacteria	Bacteria	64.3	2.94e-10	NR	MCW8132934.1	2026780	g3527	i0	47	2.20915032679739	66	33	43.1	1	253	56	23	86	MCW8132934.1 SWIB/MDM2 domain-containing protein [Planctomycetota bacterium]	diamond	1014	64.7	0.993817619783617	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);;