metadata: contig_metadata: 6 rows where bioproject = "PRJNA690592" and tax

6 rows where bioproject = "PRJNA690592" and tax_phylum = "Candidatus Cloacimonadota"

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
27903572	27903572	PRJNA690592_S_NODE_9165_length_942_cov_5.707710_g8452_i0	PRJNA690592	9165	942	5.70771	53.7666282	Candidatus Cloacimonadota bacterium	2030808	Bacteria	Bacteria	87	9.73e-16	NR	MCL1827488.1	2030808	g8452	i0	34.5	0.656050955414013	206	114	64.6	5	644	36	86	273	MCL1827488.1 phosphatidate cytidylyltransferase [Candidatus Cloacimonadota bacterium]	diamond	618	87	1	Bacteria	FCB group	Pseudomonadati	Candidatus Cloacimonadota					Candidatus Cloacimonadota bacterium
29103695	29103695	PRJNA690592_S_NODE_20008_length_667_cov_13.220539_g19049_i0	PRJNA690592	20008	667	13.220539	88.18099513	Candidatus Cloacimonadota bacterium	2030808	Bacteria	Bacteria	123	1.9e-31	NR	MBN2830161.1	2030808	g19049	i0	43.5	1.33583208395802	154	79	66.1	5	126	566	18	170	MBN2830161.1 lipocalin family protein [Candidatus Cloacimonadota bacterium]	diamond	891	123	1	Bacteria	FCB group	Pseudomonadati	Candidatus Cloacimonadota					Candidatus Cloacimonadota bacterium
30461998	30461998	PRJNA690592_S_NODE_121073_length_303_cov_1.573913_g120059_i0	PRJNA690592	121073	303	1.573913	4.76895639	Candidatus Cloacimonadota bacterium	2030808	Bacteria	Bacteria	95.1	1.62e-20	NR	MEA2097023.1	2030808	g120059	i0	51.5	3.04950495049505	103	48	100	2	1	303	181	283	MEA2097023.1 protein kinase [Candidatus Cloacimonadota bacterium]	diamond	924	95.1	1	Bacteria	FCB group	Pseudomonadati	Candidatus Cloacimonadota					Candidatus Cloacimonadota bacterium
30556157	30556157	PRJNA690592_S_NODE_119453_length_305_cov_1.219828_g118439_i0	PRJNA690592	119453	305	1.219828	3.7204754	Candidatus Tenebribacter mawsonii	3039904	Bacteria	Bacteria	58.5	2.13e-7	NR	MDP8203590.1	3039904	g118439	i0	41	3.38360655737705	83	48	81.6	1	52	300	417	498	MDP8203590.1 mucoidy inhibitor MuiA family protein [Candidatus Tenebribacter mawsonii]	diamond	1032	58.5	1	Bacteria	FCB group	Pseudomonadati	Candidatus Cloacimonadota	Candidatus Cloacimonadia	Candidatus Cloacimonadales		Candidatus Tenebribacter	Candidatus Tenebribacter mawsonii
32022148	32022148	PRJNA690592_S_NODE_129738_length_295_cov_1.036036_g128724_i0	PRJNA690592	129738	295	1.036036	3.0563062	Pseudomonadati	3379134	Bacteria	Bacteria	118	8.600000000000001e-30	NR	KQC04858.1	1732214	g128724	i0	56.6	11.1050847457627	99	41	98.6	1	295	5	182	280	KQC04858.1 MAG: UDP-glucose 4-epimerase [Candidatus Cloacimonas sp. SDB]	diamond	3276	119	0.991596638655462	Bacteria	FCB group	Pseudomonadati	Candidatus Cloacimonadota	Candidatus Cloacimonadia	Candidatus Cloacimonadales	Candidatus Cloacimonadaceae	Candidatus Cloacimonas	Candidatus Cloacimonas sp. SDB
32327596	32327596	PRJNA690592_S_NODE_67539_length_386_cov_1.313099_g66525_i0	PRJNA690592	67539	386	1.313099	5.06856214	Candidatus Cloacimonadota bacterium	2030808	Bacteria	Bacteria	44.7	0.0382	NR	MBP7563356.1	2030808	g66525	i0	25.2	0.955958549222798	123	84	95.6	2	378	10	834	948	MBP7563356.1 tetratricopeptide repeat protein [Candidatus Cloacimonadota bacterium]	diamond	369	44.7	1	Bacteria	FCB group	Pseudomonadati	Candidatus Cloacimonadota					Candidatus Cloacimonadota 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);;