metadata: contig_metadata: 9 rows where bioproject = "PRJEB14175" and tax

9 rows where bioproject = "PRJEB14175" 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
25509988	25509988	PRJEB14175_P_NODE_50201_length_526_cov_12.432258_g47967_i0	PRJEB14175	50201	526	12.432258	65.39367708	Candidatus Sumerlaea chitinivorans	2250252	Bacteria	Bacteria	420	1.2299999999999998e-112	NTclustered	gi\|1419285073\|gb\|CP030759.1\|	2250252	g47967	i0	81.712	469.30608365019	514	85	97	8	17	526	160348	160856	Candidatus Sumerlaea chitinivorans isolate BY40 chromosome, complete genome	blastn	246855	420	1	Bacteria	Bacteria candidate phyla	Candidatus Sumerlaeota	Candidatus Sumerlaeia	Candidatus Sumerlaeales	Candidatus Sumerlaeaceae	Candidatus Sumerlaea	Candidatus Sumerlaea chitinivorans
25777152	25777152	PRJEB14175_P_NODE_186307_length_239_cov_3.471910_g184040_i0	PRJEB14175	186307	239	3.47191	8.2978649	Candidatus Sumerlaea chitinivorans	2250252	Bacteria	Bacteria	152	2.06e-32	NTclustered	gi\|1419285073\|gb\|CP030759.1\|	2250252	g184040	i0	80.788	77.602510460251	203	32	84	6	34	233	160638	160836	Candidatus Sumerlaea chitinivorans isolate BY40 chromosome, complete genome	blastn	18547	152	1	Bacteria	Bacteria candidate phyla	Candidatus Sumerlaeota	Candidatus Sumerlaeia	Candidatus Sumerlaeales	Candidatus Sumerlaeaceae	Candidatus Sumerlaea	Candidatus Sumerlaea chitinivorans
25777635	25777635	PRJEB14175_P_NODE_197195_length_230_cov_4.343195_g194928_i0	PRJEB14175	197195	230	4.343195	9.9893485	Candidatus Sumerlaea chitinivorans	2250252	Bacteria	Bacteria	217	6.88e-52	NTclustered	gi\|1419285073\|gb\|CP030759.1\|	2250252	g194928	i0	84.545	189.326086956522	220	33	96	1	7	226	161591	161809	Candidatus Sumerlaea chitinivorans isolate BY40 chromosome, complete genome	blastn	43545	217	1	Bacteria	Bacteria candidate phyla	Candidatus Sumerlaeota	Candidatus Sumerlaeia	Candidatus Sumerlaeales	Candidatus Sumerlaeaceae	Candidatus Sumerlaea	Candidatus Sumerlaea chitinivorans
26056681	26056681	PRJEB14175_P_NODE_94885_length_369_cov_6.577922_g92619_i0	PRJEB14175	94885	369	6.577922	24.27253218	Candidatus Sumerlaea chitinivorans	2250252	Bacteria	Bacteria	348	3.99e-91	NTclustered	gi\|1419285073\|gb\|CP030759.1\|	2250252	g92619	i0	85.07	191.634146341463	355	37	93	13	17	361	161064	161412	Candidatus Sumerlaea chitinivorans isolate BY40 chromosome, complete genome	blastn	70713	348	1	Bacteria	Bacteria candidate phyla	Candidatus Sumerlaeota	Candidatus Sumerlaeia	Candidatus Sumerlaeales	Candidatus Sumerlaeaceae	Candidatus Sumerlaea	Candidatus Sumerlaea chitinivorans
26326555	26326555	PRJEB14175_P_NODE_55111_length_501_cov_9.556818_g52865_i0	PRJEB14175	55111	501	9.556818	47.87965818	Candidatus Sumerlaea chitinivorans	2250252	Bacteria	Bacteria	381	5.5e-101	NTclustered	gi\|1419285073\|gb\|CP030759.1\|	2250252	g52865	i0	81.02	297.570858283433	490	83	97	9	17	501	160348	160832	Candidatus Sumerlaea chitinivorans isolate BY40 chromosome, complete genome	blastn	149083	381	1	Bacteria	Bacteria candidate phyla	Candidatus Sumerlaeota	Candidatus Sumerlaeia	Candidatus Sumerlaeales	Candidatus Sumerlaeaceae	Candidatus Sumerlaea	Candidatus Sumerlaea chitinivorans
32959647	32959647	PRJEB14175_P_NODE_104546_length_348_cov_3.529617_g102280_i0	PRJEB14175	104546	348	3.529617	12.28306716	Candidatus Sumerlaeota bacterium	2107588	Bacteria	Bacteria	174	8.43e-49	NR	HNY25768.1	2107588	g102280	i0	87.5	1.6551724137931	96	12	82.8	0	347	60	540	635	HNY25768.1 nucleoside-diphosphate sugar epimerase/dehydratase [Candidatus Sumerlaeota bacterium]	diamond	576	174	1	Bacteria	Bacteria candidate phyla	Candidatus Sumerlaeota					Candidatus Sumerlaeota bacterium
32977624	32977624	PRJEB14175_P_NODE_194395_length_232_cov_18.087719_g192128_i0	PRJEB14175	194395	232	18.087719	41.96350808	Candidatus Sumerlaea chitinivorans	2250252	Bacteria	Bacteria	42.7	0.032	NR	AXA35187.1	2250252	g192128	i0	40	0.581896551724138	45	27	58.2	0	226	92	119	163	AXA35187.1 Glycosyltransferase [Candidatus Sumerlaea chitinivorans]	diamond	135	42.7	1	Bacteria	Bacteria candidate phyla	Candidatus Sumerlaeota	Candidatus Sumerlaeia	Candidatus Sumerlaeales	Candidatus Sumerlaeaceae	Candidatus Sumerlaea	Candidatus Sumerlaea chitinivorans
33061956	33061956	PRJEB14175_P_NODE_113957_length_330_cov_3.208178_g111691_i0	PRJEB14175	113957	330	3.208178	10.5869874	Candidatus Sumerlaeota bacterium	2107588	Bacteria	Bacteria	148	4.61e-39	NR	MBM3334065.1	2107588	g111691	i0	78.9	1.72727272727273	95	20	86.4	0	303	19	201	295	MBM3334065.1 polysaccharide biosynthesis protein [Candidatus Sumerlaeota bacterium]	diamond	570	148	1	Bacteria	Bacteria candidate phyla	Candidatus Sumerlaeota					Candidatus Sumerlaeota bacterium
33063572	33063572	PRJEB14175_P_NODE_48013_length_538_cov_47.488470_g45785_i0	PRJEB14175	48013	538	47.48847	255.4879686	Candidatus Sumerlaea chitinivorans	2250252	Bacteria	Bacteria	261	2.47e-84	NR	AXA36918.1	2250252	g45785	i0	85.6	0.853159851301115	153	22	85.3	0	479	21	81	233	AXA36918.1 hypothetical protein BRCON_2141 [Candidatus Sumerlaea chitinivorans]	diamond	459	261	1	Bacteria	Bacteria candidate phyla	Candidatus Sumerlaeota	Candidatus Sumerlaeia	Candidatus Sumerlaeales	Candidatus Sumerlaeaceae	Candidatus Sumerlaea	Candidatus Sumerlaea chitinivorans

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);;