metadata: contig_metadata: 5 rows where bioproject = "PRJNA1123309" and tax

5 rows where bioproject = "PRJNA1123309" 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_genus	tax_species
10481878	10481878	PRJNA1123309_P_NODE_32869_length_288_cov_1.381395_g32489_i0	PRJNA1123309	32869	288	1.381395	3.9784176	Candidatus Sumerlaeaceae bacterium	2315423	Bacteria	Bacteria	135	4.55e-35	NR	MBX7245183.1	2315423	g32489	i0	64.2	2.96875	95	34	99	0	2	286	347	441	MBX7245183.1 FAD-dependent thymidylate synthase [Candidatus Sumerlaeaceae bacterium]	diamond	855	135	1	Bacteria	Bacteria candidate phyla	Candidatus Sumerlaeota	Candidatus Sumerlaeia	Candidatus Sumerlaeales	Candidatus Sumerlaeaceae		Candidatus Sumerlaeaceae bacterium
14306987	14306987	PRJNA1123309_P_NODE_19752_length_355_cov_2.400709_g19373_i0	PRJNA1123309	19752	355	2.400709	8.52251695	Candidatus Sumerlaea chitinivorans	2250252	Bacteria	Bacteria	231	4.02e-56	NTclustered	gi\|1419285073\|gb\|CP030759.1\|	2250252	g19373	i0	80.122	345.850704225352	327	51	90	13	27	346	160502	160821	Candidatus Sumerlaea chitinivorans isolate BY40 chromosome, complete genome	blastn	122777	231	1	Bacteria	Bacteria candidate phyla	Candidatus Sumerlaeota	Candidatus Sumerlaeia	Candidatus Sumerlaeales	Candidatus Sumerlaeaceae	Candidatus Sumerlaea	Candidatus Sumerlaea chitinivorans
21954837	21954837	PRJNA1123309_P_NODE_15838_length_389_cov_2.781646_g15459_i0	PRJNA1123309	15838	389	2.781646	10.82060294	Candidatus Sumerlaea chitinivorans	2250252	Bacteria	Bacteria	265	4.39e-66	NTclustered	gi\|1419285073\|gb\|CP030759.1\|	2250252	g15459	i0	79.841	183.172236503856	377	65	95	10	9	379	160823	160452	Candidatus Sumerlaea chitinivorans isolate BY40 chromosome, complete genome	blastn	71254	265	1	Bacteria	Bacteria candidate phyla	Candidatus Sumerlaeota	Candidatus Sumerlaeia	Candidatus Sumerlaeales	Candidatus Sumerlaeaceae	Candidatus Sumerlaea	Candidatus Sumerlaea chitinivorans
28523053	28523053	PRJNA1123309_P_NODE_66647_length_242_cov_0.923077_g66267_i0	PRJNA1123309	66647	242	0.923077	2.23384634	Candidatus Sumerlaea chitinivorans	2250252	Bacteria	Bacteria	51.6	2.68e-5	NR	AXA35498.1	2250252	g66267	i0	62.2	0.557851239669422	45	16	54.5	1	134	3	174	218	AXA35498.1 N-acetylmuramoyl-L-alanine amidase [Candidatus Sumerlaea chitinivorans]	diamond	135	51.6	1	Bacteria	Bacteria candidate phyla	Candidatus Sumerlaeota	Candidatus Sumerlaeia	Candidatus Sumerlaeales	Candidatus Sumerlaeaceae	Candidatus Sumerlaea	Candidatus Sumerlaea chitinivorans
31524049	31524049	PRJNA1123309_P_NODE_55636_length_248_cov_0.891429_g55256_i0	PRJNA1123309	55636	248	0.891429	2.21074392	Candidatus Sumerlaeaceae bacterium	2315423	Bacteria	Bacteria	119	1.07e-29	NR	MCX7717181.1	2315423	g55256	i0	69.5	0.991935483870968	82	25	99.2	0	246	1	196	277	MCX7717181.1 dihydrolipoyl dehydrogenase [Candidatus Sumerlaeaceae bacterium]	diamond	246	119	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);;