metadata: contig_metadata: 11 rows where bioproject = "PRJNA1164198" and tax

11 rows where bioproject = "PRJNA1164198" 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
9239911	9239911	PRJNA1164198_P_NODE_28688_length_245_cov_1.686047_g28419_i0	PRJNA1164198	28688	245	1.686047	4.13081515	Candidatus Saccharibacteria genomosp. TM7-H1	2080739	Bacteria	Bacteria	346	9.059999999999999e-91	NTclustered	gi\|1566427536\|gb\|CP026537.1\|	2080739	g28419	i0	92.917	75.1183673469388	240	14	98	3	7	245	543415	543652	Candidatus Saccharibacteria genomosp. TM7-H1 isolate E1 chromosome	blastn	18404	346	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharibacteria genomosp. TM7-H1
17617249	17617249	PRJNA1164198_P_NODE_31014_length_242_cov_0.923077_g30745_i0	PRJNA1164198	31014	242	0.923077	2.23384634	Bacillati	1783272	Bacteria	Bacteria	339	1.49e-88	NTclustered	gi\|1899225384\|gb\|MT967848.1\|	1983405	g30745	i0	91.837	950.165289256198	245	16	100	3	1	242	2036	1793	Uncultured Candidatus Saccharimonas sp. clone asv_347_2260 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	229940	339	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Saccharimonadales	Candidatus Saccharimonadaceae	Candidatus Saccharimonas	uncultured Candidatus Saccharimonas sp.
18163598	18163598	PRJNA1164198_P_NODE_27295_length_248_cov_0.891429_g27026_i0	PRJNA1164198	27295	248	0.891429	2.21074392	Candidatus Saccharimonadales bacterium	2973664	Bacteria	Bacteria	142	2.1299999999999998e-39	NR	HEY5268008.1	2973664	g27026	i0	82.9	11.9032258064516	82	14	99.2	0	247	2	14	95	HEY5268008.1 DEAD/DEAH box helicase family protein [Candidatus Saccharimonadales bacterium]	diamond	2952	142	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Saccharimonadales			Candidatus Saccharimonadales bacterium
24537862	24537862	PRJNA1164198_P_NODE_14180_length_329_cov_0.878906_g13911_i0	PRJNA1164198	14180	329	0.878906	2.89160074	Vermiphilus pyriformis	1763547	Bacteria	Bacteria	608	1.4599999999999995e-169	NTclustered	gi\|2207817285\|gb\|CP074345.1\|	1763547	g13911	i0	100	173.586626139818	329	0	100	0	1	329	973703	973375	MAG: Vermiphilus pyriformis isolate TW-EDP1-1 chromosome, complete genome	blastn	57110	608	1	Bacteria	Bacteria candidate phyla					Vermiphilus	Vermiphilus pyriformis
27103525	27103525	PRJNA1164198_P_NODE_21262_length_269_cov_1.989796_g20993_i0	PRJNA1164198	21262	269	1.989796	5.35255124	Minisyncoccota bacterium	2053589	Bacteria	Bacteria	79.7	5.14e-15	NR	MEZ0208637.1	2053589	g20993	i0	40	0.892193308550186	80	48	89.2	0	29	268	1237	1316	MEZ0208637.1 RNase H-like domain-containing protein [Candidatus Paceibacterota bacterium]	diamond	240	79.7	1	Bacteria	Bacteria candidate phyla	Minisyncoccota					Minisyncoccota bacterium
27893215	27893215	PRJNA1164198_P_NODE_8125_length_438_cov_1.594521_g7863_i0	PRJNA1164198	8125	438	1.594521	6.98400198	Minisyncoccota bacterium	2053589	Bacteria	Bacteria	123	2.5199999999999996e-29	NR	MEZ0208637.1	2053589	g7863	i0	41	0.986301369863014	144	85	98.6	0	433	2	785	928	MEZ0208637.1 RNase H-like domain-containing protein [Candidatus Paceibacterota bacterium]	diamond	432	123	1	Bacteria	Bacteria candidate phyla	Minisyncoccota					Minisyncoccota bacterium
29396549	29396549	PRJNA1164198_P_NODE_28529_length_246_cov_0.901734_g28260_i0	PRJNA1164198	28529	246	0.901734	2.21826564	Bacteria	2	Bacteria	Bacteria	73.9	3.86e-13	NR	KKR29838.1	1618552	g28260	i0	92.3	1.90243902439024	39	3	47.6	0	3	119	545	583	KKR29838.1 MAG: type II secretion system protein E [Candidatus Woesebacteria bacterium GW2011_GWA1_39_8]	diamond	468	74.3	0.994616419919246	Bacteria	Bacteria candidate phyla	Candidatus Woeseibacteriota					Candidatus Woesebacteria bacterium GW2011_GWA1_39_8
29787576	29787576	PRJNA1164198_P_NODE_21891_length_266_cov_1.093264_g21622_i0	PRJNA1164198	21891	266	1.093264	2.90808224	Candidatus Binatia bacterium	2838779	Bacteria	Bacteria	46.6	0.00193	NR	HEY5543938.1	2838779	g21622	i0	35.4	2.67293233082707	79	50	88	1	28	261	38	116	HEY5543938.1 alpha/beta hydrolase [Candidatus Binatia bacterium]	diamond	711	46.6	1	Bacteria	Bacteria candidate phyla	Candidatus Binatota	Candidatus Binatia				Candidatus Binatia bacterium
30071941	30071941	PRJNA1164198_P_NODE_26012_length_250_cov_0.881356_g25743_i0	PRJNA1164198	26012	250	0.881356	2.20339	Patescibacteria group bacterium	2052139	Bacteria	Bacteria	67.8	1.15e-11	NR	MDE1970990.1	2052139	g25743	i0	51.7	0.696	58	28	69.6	0	243	70	122	179	MDE1970990.1 HNH endonuclease [Patescibacteria group bacterium]	diamond	174	67.8	1	Bacteria	Bacteria candidate phyla						Patescibacteria group bacterium
30545981	30545981	PRJNA1164198_P_NODE_29893_length_243_cov_1.823529_g29624_i0	PRJNA1164198	29893	243	1.823529	4.43117547	Candidatus Delongbacteria bacterium	2044594	Bacteria	Bacteria	49.7	1.19e-4	NR	MFA6654012.1	2044594	g29624	i0	36.6	0.876543209876543	71	37	87.7	3	2	214	18	80	MFA6654012.1 hypothetical protein [Candidatus Delongbacteria bacterium]	diamond	213	49.7	1	Bacteria	Bacteria candidate phyla	Candidatus Delongiibacteriota					Candidatus Delongbacteria bacterium
31778736	31778736	PRJNA1164198_P_NODE_12297_length_354_cov_1.665480_g12029_i0	PRJNA1164198	12297	354	1.66548	5.8957992	Candidatus Binatia bacterium	2838779	Bacteria	Bacteria	43.9	0.038	NR	HEX6801329.1	2838779	g12029	i0	46.3	0.457627118644068	54	28	45.8	1	99	260	44	96	HEX6801329.1 HAMP domain-containing sensor histidine kinase [Candidatus Binatia bacterium]	diamond	162	43.9	1	Bacteria	Bacteria candidate phyla	Candidatus Binatota	Candidatus Binatia				Candidatus Binatia 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);;