metadata: contig_metadata: 8 rows where bioproject = "PRJNA1241156" and tax

8 rows where bioproject = "PRJNA1241156" 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_species
5453401	5453401	PRJNA1241156_S_NODE_3765_length_554_cov_4.461840_g3354_i0	PRJNA1241156	3765	554	4.46184	24.7185936	Candidatus Saccharibacteria genomosp. TM7-H1	2080739	Bacteria	Bacteria	1007	0	NTclustered	gi\|1566427536\|gb\|CP026537.1\|	2080739	g3354	i0	99.458	64.5649819494585	554	3	100	0	1	554	543121	543674	Candidatus Saccharibacteria genomosp. TM7-H1 isolate E1 chromosome	blastn	35769	1007	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharibacteria genomosp. TM7-H1
8003256	8003256	PRJNA1241156_S_NODE_3987_length_543_cov_5.210000_g3568_i0	PRJNA1241156	3987	543	5.21	28.2903	Candidatus Dojkabacteria bacterium	2099670	Bacteria	Bacteria	58.4	0.001	NTclustered	gi\|2556884375\|gb\|CP129470.1\|	2099670	g3568	i0	94.595	0.0681399631675875	37	2	7	0	405	441	557346	557382	MAG: Candidatus Dojkabacteria bacterium isolate cMAG.26 chromosome, complete genome	blastn	37	58.4	1	Bacteria	Bacteria candidate phyla		Candidatus Dojkabacteria bacterium
10554020	10554020	PRJNA1241156_S_NODE_36789_length_311_cov_3.003731_g36329_i0	PRJNA1241156	36789	311	3.003731	9.34160341	Candidatus Saccharibacteria genomosp. TM7-H1	2080739	Bacteria	Bacteria	575	1.3899999999999995e-159	NTclustered	gi\|1566427536\|gb\|CP026537.1\|	2080739	g36329	i0	100	296.093247588424	311	0	100	0	1	311	542578	542888	Candidatus Saccharibacteria genomosp. TM7-H1 isolate E1 chromosome	blastn	92085	575	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharibacteria genomosp. TM7-H1
28368323	28368323	PRJNA1241156_S_NODE_68086_length_235_cov_5.572917_g67626_i0	PRJNA1241156	68086	235	5.572917	13.09635495	Candidatus Saccharibacteria bacterium	2026720	Bacteria	Bacteria	55.5	5.63e-7	NR	TAH34838.1	2026720	g67626	i0	37.1	0.893617021276596	70	43	88.1	1	28	234	84	153	TAH34838.1 MAG: hypothetical protein EYC59_02885 [Candidatus Saccharibacteria bacterium]	diamond	210	55.5	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadota bacterium
30926860	30926860	PRJNA1241156_S_NODE_53274_length_268_cov_2.760000_g52814_i0	PRJNA1241156	53274	268	2.76	7.3968	Candidatus Rifleibacteriota bacterium	2053586	Bacteria	Bacteria	46.2	0.00243	NR	MBU1107592.1	2053586	g52814	i0	38.5	0.727611940298508	65	28	72.8	2	43	237	149	201	MBU1107592.1 class I SAM-dependent methyltransferase [Candidatus Rifleibacteriota bacterium]	diamond	195	46.2	1	Bacteria	Bacteria candidate phyla	Candidatus Rifleibacteriota	Candidatus Rifleibacteriota bacterium
31418831	31418831	PRJNA1241156_S_NODE_27436_length_338_cov_6.671186_g26976_i0	PRJNA1241156	27436	338	6.671186	22.54860868	Bacteria	2	Bacteria	Bacteria	135	4.19e-36	NR	OQB10761.1	1852939	g26976	i0	55.2	1.87278106508876	105	47	93.2	0	329	15	2	106	OQB10761.1 MAG: hypothetical protein BWY21_00051 [Parcubacteria group bacterium ADurb.Bin216]	diamond	633	136	0.992647058823529	Bacteria	Bacteria candidate phyla		Parcubacteria group bacterium ADurb.Bin216
32318527	32318527	PRJNA1241156_S_NODE_29439_length_332_cov_4.816609_g28979_i0	PRJNA1241156	29439	332	4.816609	15.99114188	candidate division TM6 bacterium Zodletone_IIa	1511133	Bacteria	Bacteria	167	3.14e-51	NR	KHD90133.1	1511133	g28979	i0	100	1.42771084337349	79	0	71.4	0	94	330	1	79	KHD90133.1 2-hydroxyhepta-2,4-diene-1,7-dioate isomerase, partial [candidate division TM6 bacterium Zodletone_IIa]	diamond	474	167	1	Bacteria	Bacteria candidate phyla		candidate division TM6 bacterium Zodletone_IIa
32462986	32462986	PRJNA1241156_S_NODE_53599_length_267_cov_4.843750_g53139_i0	PRJNA1241156	53599	267	4.84375	12.9328125	Pseudomonadati	3379134	Bacteria	Bacteria	43.5	0.00381	NR	MEX0597906.1	2053589	g53139	i0	36.5	1.08988764044944	52	33	58.4	0	13	168	16	67	MEX0597906.1 hypothetical protein [Candidatus Paceibacterota bacterium]	diamond	291	43.5	1	Bacteria	Bacteria candidate phyla	Minisyncoccota	Minisyncoccota 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);;