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

6 rows where bioproject = "PRJNA728642" and tax_clade = "Bacteria candidate phyla"

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
712994	712994	PRJNA728642_P_NODE_9061_length_337_cov_3.901515_g8790_i0	PRJNA728642	9061	337	3.901515	13.14810555	Candidatus Saccharimonadota bacterium	2026720	Bacteria	Bacteria	534	2.59e-147	NTclustered	gi\|1958075319\|gb\|CP064995.1\|	2026720	g8790	i0	95.252	77.6854599406528	337	16	100	0	1	337	693960	693624	Candidatus Saccharibacteria bacterium isolate Hjor_18-Q3-R7-51_MAXAC.102_uni chromosome, complete genome	blastn	26180	534	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharimonadota bacterium
3264295	3264295	PRJNA728642_P_NODE_7043_length_385_cov_1.480769_g6772_i0	PRJNA728642	7043	385	1.480769	5.70096065	Candidatus Sumerlaea chitinivorans	2250252	Bacteria	Bacteria	392	1.91e-104	NTclustered	gi\|1419285073\|gb\|CP030759.1\|	2250252	g6772	i0	85.946	43.8285714285714	370	48	95	4	19	385	162079	161711	Candidatus Sumerlaea chitinivorans isolate BY40 chromosome, complete genome	blastn	16874	392	1	Bacteria	Bacteria candidate phyla	Candidatus Sumerlaeota	Candidatus Sumerlaeia	Candidatus Sumerlaeales	Candidatus Sumerlaeaceae	Candidatus Sumerlaea	Candidatus Sumerlaea chitinivorans
18564456	18564456	PRJNA728642_P_NODE_11175_length_303_cov_1.156522_g10904_i0	PRJNA728642	11175	303	1.156522	3.50426166	Candidatus Sumerlaea chitinivorans	2250252	Bacteria	Bacteria	303	7.06e-78	NTclustered	gi\|1419285073\|gb\|CP030759.1\|	2250252	g10904	i0	84.967	430.580858085809	306	39	100	5	1	303	160901	161202	Candidatus Sumerlaea chitinivorans isolate BY40 chromosome, complete genome	blastn	130466	303	1	Bacteria	Bacteria candidate phyla	Candidatus Sumerlaeota	Candidatus Sumerlaeia	Candidatus Sumerlaeales	Candidatus Sumerlaeaceae	Candidatus Sumerlaea	Candidatus Sumerlaea chitinivorans
27094186	27094186	PRJNA728642_P_NODE_17302_length_247_cov_0.885057_g17031_i0	PRJNA728642	17302	247	0.885057	2.18609079	Bacteria	2	Bacteria	Bacteria	90.5	3.91e-19	NR	TXI34042.1	2045217	g17031	i0	64.9	3.5587044534413	74	25	89.9	1	1	222	338	410	TXI34042.1 MAG: prolyl-tRNA synthetase [Candidatus Moraniibacteriota bacterium]	diamond	879	90.5	1	Bacteria	Bacteria candidate phyla	Candidatus Moraniibacteriota					Candidatus Moraniibacteriota bacterium
28852168	28852168	PRJNA728642_P_NODE_17428_length_247_cov_0.885057_g17157_i0	PRJNA728642	17428	247	0.885057	2.18609079	Candidatus Saccharimonadota bacterium	2026720	Bacteria	Bacteria	93.2	6.51e-20	NR	MBC7512538.1	2026720	g17157	i0	55.4	1.0080971659919	83	33	98.4	2	3	245	493	573	MBC7512538.1 phospho-sugar mutase [Candidatus Saccharibacteria bacterium]	diamond	249	93.2	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharimonadota bacterium
30557593	30557593	PRJNA728642_P_NODE_14633_length_262_cov_1.629630_g14362_i0	PRJNA728642	14633	262	1.62963	4.2696306	Candidatus Mycosynbacter amalyticus	2665156	Bacteria	Bacteria	175	9.38e-49	NR	WP_260764013.1	2665156	g14362	i0	98.9	3.98473282442748	87	1	99.6	0	1	261	528	614	WP_260764013.1 type IV secretory system conjugative DNA transfer family protein [Candidatus Mycosynbacter amalyticus]	diamond	1044	175	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota				Candidatus Mycosynbacter	Candidatus Mycosynbacter amalyticus

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