metadata: contig_metadata: 5 rows where bioproject = "PRJNA849172", tax_clade = "Bacteria candidate phyla" and tax

5 rows where bioproject = "PRJNA849172", tax_clade = "Bacteria candidate phyla" and tax_phylum = "Candidatus Sumerlaeota"

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_phylum	tax_class	tax_order	tax_family	tax_species
22511272	22511272	PRJNA849172_P_NODE_113778_length_237_cov_3.804878_g113418_i0	PRJNA849172	113778	237	3.804878	9.01756086	Bacillati	1783272	Bacteria	Bacteria	77.4	1.18e-14	NR	OQB20731.1	1852823	g113418	i0	73.1	4.67088607594937	52	14	65.8	0	157	2	4	55	OQB20731.1 MAG: ATPase family associated with various cellular activities (AAA) [candidate division BRC1 bacterium ADurb.Bin183]	diamond	1107	77.4	1	Bacteria	Bacteria candidate phyla	Candidatus Sumerlaeota				candidate division BRC1 bacterium ADurb.Bin183
27276227	27276227	PRJNA849172_P_NODE_73363_length_266_cov_2.316062_g73003_i0	PRJNA849172	73363	266	2.316062	6.16072492	Candidatus Sumerlaeota bacterium	2107588	Bacteria	Bacteria	82.8	3.68e-16	NR	MFC1601206.1	2107588	g73003	i0	56.5	1.3984962406015	62	27	69.9	0	2	187	423	484	MFC1601206.1 DUF4375 domain-containing protein [Candidatus Sumerlaeota bacterium]	diamond	372	82.8	1	Bacteria	Bacteria candidate phyla	Candidatus Sumerlaeota				Candidatus Sumerlaeota bacterium
28728688	28728688	PRJNA849172_P_NODE_95527_length_248_cov_4.777143_g95167_i0	PRJNA849172	95527	248	4.777143	11.84731464	Candidatus Sumerlaeaceae bacterium	2315423	Bacteria	Bacteria	59.7	1.8e-8	NR	MBX7245576.1	2315423	g95167	i0	45	1.37903225806452	60	32	71.4	1	248	72	150	209	MBX7245576.1 50S ribosome-binding GTPase [Candidatus Sumerlaeaceae bacterium]	diamond	342	59.7	1	Bacteria	Bacteria candidate phyla	Candidatus Sumerlaeota	Candidatus Sumerlaeia	Candidatus Sumerlaeales	Candidatus Sumerlaeaceae	Candidatus Sumerlaeaceae bacterium
29549313	29549313	PRJNA849172_P_NODE_13370_length_576_cov_23.524851_g13012_i0	PRJNA849172	13370	576	23.524851	135.50314176	Candidatus Sumerlaeota bacterium	2107588	Bacteria	Bacteria	119	6.27e-28	NR	MBI1785407.1	2107588	g13012	i0	39.1	1	192	79	100	4	1	576	126	279	MBI1785407.1 type II secretion system protein [Candidatus Sumerlaeota bacterium]	diamond	576	119	1	Bacteria	Bacteria candidate phyla	Candidatus Sumerlaeota				Candidatus Sumerlaeota bacterium
32173125	32173125	PRJNA849172_P_NODE_64118_length_276_cov_2.290640_g63758_i0	PRJNA849172	64118	276	2.29064	6.3221664	Candidatus Sumerlaeaceae bacterium	2315423	Bacteria	Bacteria	94.4	5.16e-23	NR	MBX7247137.1	2315423	g63758	i0	62.5	0.782608695652174	72	27	78.3	0	1	216	10	81	MBX7247137.1 ATP synthase F1 subunit epsilon [Candidatus Sumerlaeaceae bacterium]	diamond	216	94.4	1	Bacteria	Bacteria candidate phyla	Candidatus Sumerlaeota	Candidatus Sumerlaeia	Candidatus Sumerlaeales	Candidatus Sumerlaeaceae	Candidatus Sumerlaeaceae 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);;