metadata: contig_metadata: 13 rows where bioproject = "PRJEB11523", tax_clade = "Bacteria candidate phyla" and tax

13 rows where bioproject = "PRJEB11523", tax_clade = "Bacteria candidate phyla" and tax_phylum = "Candidatus Saccharimonadota"

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_species
7666018	7666018	PRJEB11523_P_NODE_967_length_605_cov_3.115108_g893_i0	PRJEB11523	967	605	3.115108	18.8464034	Candidatus Saccharimonadota bacterium	2026720	Bacteria	Bacteria	367	2.2799999999999997e-124	NR	MBP7767315.1	2026720	g893	i0	94.9	0.981818181818182	198	10	98.2	0	595	2	136	333	MBP7767315.1 translational GTPase TypA [Candidatus Saccharibacteria bacterium]	diamond	594	367	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota			Candidatus Saccharimonadota bacterium
10216545	10216545	PRJEB11523_P_NODE_6789_length_176_cov_2.283465_g6711_i0	PRJEB11523	6789	176	2.283465	4.0188984	Candidatus Saccharibacteria bacterium TM7i	2980174	Bacteria	Bacteria	220	3.85e-53	NTclustered	gi\|2306681518\|gb\|CP075337.1\|	2980174	g6711	i0	89.266	8.10795454545454	177	17	100	2	1	176	361090	361265	Candidatus Saccharibacteria bacterium TM7i chromosome, complete genome	blastn	1427	220	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota			Candidatus Saccharibacteria bacterium TM7i
23934959	23934959	PRJEB11523_P_NODE_6359_length_183_cov_1.261194_g6281_i0	PRJEB11523	6359	183	1.261194	2.30798502	Bacillati	1783272	Bacteria	Bacteria	120	4.04e-30	NR	AHB41879.1	1394711	g6281	i0	98.3	69.7704918032787	60	1	98.4	0	181	2	85	144	AHB41879.1 GTP-binding protein TypA [Candidatus Saccharibacteria bacterium RAAC3_TM7_1]	diamond	12768	121	0.991735537190083	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota			Candidatus Saccharibacteria bacterium RAAC3_TM7_1
27285593	27285593	PRJEB11523_P_NODE_6123_length_187_cov_1.478261_g6045_i0	PRJEB11523	6123	187	1.478261	2.76434807	Candidatus Saccharimonadota bacterium	2026720	Bacteria	Bacteria	106	2.81e-26	NR	MCA9331340.1	2026720	g6045	i0	78	1.89304812834225	59	13	94.7	0	2	178	199	257	MCA9331340.1 hypothetical protein [Candidatus Saccharibacteria bacterium]	diamond	354	106	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota			Candidatus Saccharimonadota bacterium
27443896	27443896	PRJEB11523_P_NODE_8063_length_164_cov_0.886957_g7985_i0	PRJEB11523	8063	164	0.886957	1.45460948	Candidatus Saccharimonadota bacterium	2026720	Bacteria	Bacteria	104	1.7999999999999997e-24	NR	MDB5162803.1	2026720	g7985	i0	90.7	5.92682926829268	54	5	98.8	0	164	3	153	206	MDB5162803.1 bipA [Candidatus Saccharibacteria bacterium]	diamond	972	104	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota			Candidatus Saccharimonadota bacterium
28012126	28012126	PRJEB11523_P_NODE_5965_length_189_cov_2.050000_g5887_i0	PRJEB11523	5965	189	2.05	3.8745	Candidatus Saccharimonadota bacterium	2026720	Bacteria	Bacteria	75.1	6.89e-14	NR	MBA2279235.1	2026720	g5887	i0	67.3	0.873015873015873	55	18	87.3	0	187	23	361	415	MBA2279235.1 recombinase family protein [Candidatus Saccharibacteria bacterium]	diamond	165	75.1	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota			Candidatus Saccharimonadota bacterium
28548882	28548882	PRJEB11523_P_NODE_1727_length_425_cov_38.683511_g1649_i0	PRJEB11523	1727	425	38.683511	164.40492175	Candidatus Saccharimonadales bacterium	2973664	Bacteria	Bacteria	82.8	5.4e-16	NR	HSD56392.1	2973664	g1649	i0	42.5	2.37882352941176	113	57	76.2	3	31	354	3	112	HSD56392.1 HAD family hydrolase [Candidatus Saccharimonadales bacterium]	diamond	1011	82.8	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Saccharimonadales	Candidatus Saccharimonadales bacterium
29621721	29621721	PRJEB11523_P_NODE_4070_length_237_cov_32.675532_g3992_i0	PRJEB11523	4070	237	32.675532	77.44101084	Candidatus Saccharimonadota bacterium	2026720	Bacteria	Bacteria	60.8	5.99e-9	NR	MDB5181518.1	2026720	g3992	i0	58.1	0.544303797468354	43	18	54.4	0	26	154	177	219	MDB5181518.1 hypothetical protein [Candidatus Saccharibacteria bacterium]	diamond	129	60.8	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota			Candidatus Saccharimonadota bacterium
30349265	30349265	PRJEB11523_P_NODE_3992_length_240_cov_7.151832_g3914_i0	PRJEB11523	3992	240	7.151832	17.1643968	Candidatus Saccharimonadales bacterium	2973664	Bacteria	Bacteria	100	2.0199999999999994e-23	NR	HSW79221.1	2973664	g3914	i0	76.6	0.8	64	15	80	0	224	33	216	279	HSW79221.1 phospholipase D-like domain-containing protein [Candidatus Saccharimonadales bacterium]	diamond	192	100	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Saccharimonadales	Candidatus Saccharimonadales bacterium
31233202	31233202	PRJEB11523_P_NODE_1835_length_408_cov_3.526462_g1757_i0	PRJEB11523	1835	408	3.526462	14.38796496	Candidatus Saccharimonadales bacterium	2973664	Bacteria	Bacteria	172	4.679999999999999e-52	NR	HSX44267.1	2973664	g1757	i0	72.2	1.86029411764706	126	35	92.6	0	384	7	22	147	HSX44267.1 50S ribosomal protein L15 [Candidatus Saccharimonadales bacterium]	diamond	759	172	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Saccharimonadales	Candidatus Saccharimonadales bacterium
31328233	31328233	PRJEB11523_P_NODE_4096_length_236_cov_25.026738_g4018_i0	PRJEB11523	4096	236	25.026738	59.06310168	Candidatus Saccharimonadota bacterium	2026720	Bacteria	Bacteria	108	2.61e-25	NR	MBQ6394575.1	2026720	g4018	i0	75.4	1.65254237288136	65	16	82.6	0	18	212	153	217	MBQ6394575.1 hypothetical protein [Candidatus Saccharibacteria bacterium]	diamond	390	108	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota			Candidatus Saccharimonadota bacterium
31644431	31644431	PRJEB11523_P_NODE_5177_length_205_cov_3.551282_g5099_i0	PRJEB11523	5177	205	3.551282	7.2801281	Candidatus Saccharimonadota bacterium	2026720	Bacteria	Bacteria	57.8	1.44e-8	NR	MEI6481547.1	2026720	g5099	i0	70.7	0.6	41	12	60	0	197	75	90	130	MEI6481547.1 pilin [Candidatus Saccharibacteria bacterium]	diamond	123	57.8	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota			Candidatus Saccharimonadota bacterium
32087497	32087497	PRJEB11523_P_NODE_3598_length_257_cov_1.639423_g3520_i0	PRJEB11523	3598	257	1.639423	4.21331711	Candidatus Saccharimonadota bacterium	2026720	Bacteria	Bacteria	158	8.480000000000001e-44	NR	MBA2279235.1	2026720	g3520	i0	85.9	0.992217898832685	85	12	99.2	0	255	1	237	321	MBA2279235.1 recombinase family protein [Candidatus Saccharibacteria bacterium]	diamond	255	158	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota			Candidatus Saccharimonadota 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);;