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

9 rows where bioproject = "PRJNA493632" 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
10671951	10671951	PRJNA493632_P_NODE_688189_length_231_cov_6.810127_g684748_i0	PRJNA493632	688189	231	6.810127	15.73139337	Candidatus Sumerlaea chitinivorans	2250252	Bacteria	Bacteria	222	1.4899999999999999e-53	NTclustered	gi\|1419285073\|gb\|CP030759.1\|	2250252	g684748	i0	84.454	255.575757575758	238	23	100	12	1	231	161069	161299	Candidatus Sumerlaea chitinivorans isolate BY40 chromosome, complete genome	blastn	59038	222	1	Bacteria	Bacteria candidate phyla	Candidatus Sumerlaeota	Candidatus Sumerlaeia	Candidatus Sumerlaeales	Candidatus Sumerlaeaceae	Candidatus Sumerlaea	Candidatus Sumerlaea chitinivorans
18315452	18315452	PRJNA493632_P_NODE_436015_length_264_cov_6.748691_g432576_i0	PRJNA493632	436015	264	6.748691	17.81654424	Candidatus Sumerlaeia bacterium	2715255	Bacteria	Bacteria	104	2.2799999999999998e-24	NR	MCC5877378.1	2715255	g432576	i0	83.3	0.613636363636364	54	9	61.4	0	5	166	308	361	MCC5877378.1 peptide chain release factor 2 [Candidatus Sumerlaeia bacterium]	diamond	162	104	1	Bacteria	Bacteria candidate phyla	Candidatus Sumerlaeota	Candidatus Sumerlaeia				Candidatus Sumerlaeia bacterium
24687828	24687828	PRJNA493632_P_NODE_329720_length_287_cov_2.140187_g326281_i0	PRJNA493632	329720	287	2.140187	6.14233669	Candidatus Sumerlaea chitinivorans	2250252	Bacteria	Bacteria	244	4.08e-60	NTclustered	gi\|1419285073\|gb\|CP030759.1\|	2250252	g326281	i0	83.643	213.142857142857	269	34	92	9	4	267	161058	161321	Candidatus Sumerlaea chitinivorans isolate BY40 chromosome, complete genome	blastn	61172	244	1	Bacteria	Bacteria candidate phyla	Candidatus Sumerlaeota	Candidatus Sumerlaeia	Candidatus Sumerlaeales	Candidatus Sumerlaeaceae	Candidatus Sumerlaea	Candidatus Sumerlaea chitinivorans
26981771	26981771	PRJNA493632_P_NODE_717462_length_213_cov_4.192857_g714020_i0	PRJNA493632	717462	213	4.192857	8.93078541	Sumerlaeia bacterium	3066091	Bacteria	Bacteria	48.9	1.65e-4	NR	MEQ8819336.1	3066091	g714020	i0	34.3	0.985915492957746	70	46	98.6	0	3	212	265	334	MEQ8819336.1 hypothetical protein [Sumerlaeia bacterium]	diamond	210	48.9	1	Bacteria	Bacteria candidate phyla	Candidatus Sumerlaeota	Candidatus Sumerlaeia				Sumerlaeia bacterium
27677094	27677094	PRJNA493632_P_NODE_383684_length_275_cov_4.331683_g380245_i0	PRJNA493632	383684	275	4.331683	11.91212825	Candidatus Sumerlaeota bacterium	2107588	Bacteria	Bacteria	86.7	1.97e-17	NR	HMZ52036.1	2107588	g380245	i0	48.9	5.00727272727273	92	46	99.3	1	273	1	390	481	HMZ52036.1 alanine--tRNA ligase [Candidatus Sumerlaeota bacterium]	diamond	1377	86.7	1	Bacteria	Bacteria candidate phyla	Candidatus Sumerlaeota					Candidatus Sumerlaeota bacterium
28592594	28592594	PRJNA493632_P_NODE_512587_length_251_cov_0.865169_g509148_i0	PRJNA493632	512587	251	0.865169	2.17157419	Candidatus Sumerlaeota bacterium	2107588	Bacteria	Bacteria	43.9	0.0147	NR	MBI3736898.1	2107588	g509148	i0	32.7	1.31474103585657	55	37	65.7	0	175	11	26	80	MBI3736898.1 SGNH/GDSL hydrolase family protein [Candidatus Sumerlaeota bacterium]	diamond	330	43.9	1	Bacteria	Bacteria candidate phyla	Candidatus Sumerlaeota					Candidatus Sumerlaeota bacterium
29571146	29571146	PRJNA493632_P_NODE_355830_length_281_cov_4.971154_g352391_i0	PRJNA493632	355830	281	4.971154	13.96894274	candidate division BRC1 bacterium ADurb.Bin183	1852823	Bacteria	Bacteria	43.1	0.0417	NR	OQB22219.1	1852823	g352391	i0	37	0.576512455516014	54	34	57.7	0	27	188	1	54	OQB22219.1 MAG: Major Facilitator Superfamily protein [candidate division BRC1 bacterium ADurb.Bin183]	diamond	162	43.1	1	Bacteria	Bacteria candidate phyla	Candidatus Sumerlaeota					candidate division BRC1 bacterium ADurb.Bin183
30740164	30740164	PRJNA493632_P_NODE_668854_length_238_cov_4.527273_g665413_i0	PRJNA493632	668854	238	4.527273	10.77490974	Candidatus Sumerlaeota bacterium	2107588	Bacteria	Bacteria	61.6	6.62e-9	NR	MBI3735681.1	2107588	g665413	i0	43.3	1.6890756302521	67	37	83.2	1	27	224	15	81	MBI3735681.1 peptidoglycan DD-metalloendopeptidase family protein [Candidatus Sumerlaeota bacterium]	diamond	402	61.6	1	Bacteria	Bacteria candidate phyla	Candidatus Sumerlaeota					Candidatus Sumerlaeota bacterium
31308942	31308942	PRJNA493632_P_NODE_629095_length_243_cov_0.905882_g625654_i0	PRJNA493632	629095	243	0.905882	2.20129326	Candidatus Sumerlaeales bacterium	2925322	Bacteria	Bacteria	169	1.22e-46	NR	MDD4279109.1	2925322	g625654	i0	100	0.987654320987654	80	0	98.8	0	241	2	111	190	MDD4279109.1 AAA domain-containing protein [Candidatus Sumerlaeales bacterium]	diamond	240	169	1	Bacteria	Bacteria candidate phyla	Candidatus Sumerlaeota	Candidatus Sumerlaeia	Candidatus Sumerlaeales			Candidatus Sumerlaeales 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);;