metadata: contig_metadata: 15 rows where bioproject = "PRJNA1255065" and tax

15 rows where bioproject = "PRJNA1255065" 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
360079	360079	PRJNA1255065_P_NODE_143841_length_163_cov_0.912281_g141613_i0	PRJNA1255065	143841	163	0.912281	1.48701803	Candidatus Nanosynbacter sp. BB002	3393757	Bacteria	Bacteria	246	5.8099999999999995e-61	NTclustered	gi\|2692798772\|gb\|CP146064.1\|	3393757	g141613	i0	93.865	2	163	10	100	0	1	163	200138	199976	Candidatus Nanosynbacter sp. BB002 chromosome, complete genome	blastn	326	246	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Nanosynbacterales	Candidatus Nanosynbacteraceae	Candidatus Nanosynbacter	Candidatus Nanosynbacter sp. BB002
6738001	6738001	PRJNA1255065_P_NODE_152206_length_162_cov_0.920354_g149978_i0	PRJNA1255065	152206	162	0.920354	1.49097348	uncultured Methylomirabilota bacterium	991135	Bacteria	Bacteria	110	7.89e-20	NTclustered	gi\|2874253892\|emb\|OY970067.1\|	991135	g149978	i0	82.787	3.12962962962963	122	21	75	0	34	155	1499766	1499887	MAG: uncultured candidate division NC10 bacterium isolate MFD01231.bin.c.1 genome assembly, chromosome: 1	blastn	507	110	1	Bacteria	Bacteria candidate phyla	Candidatus Methylomirabilota					uncultured Methylomirabilota bacterium
14389020	14389020	PRJNA1255065_P_NODE_118452_length_167_cov_0.881356_g116224_i0	PRJNA1255065	118452	167	0.881356	1.47186452	Candidatus Minimicrobia vallesae	2841264	Bacteria	Bacteria	281	1.64e-71	NTclustered	gi\|2052594292\|gb\|CP076459.1\|	2841264	g116224	i0	97.006	8	167	5	100	0	1	167	160090	160256	Candidatus Minimicrobia vallesae isolate IHU2 chromosome, complete genome	blastn	1336	281	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota				Candidatus Minimicrobia	Candidatus Minimicrobia vallesae
20761349	20761349	PRJNA1255065_P_NODE_107477_length_169_cov_0.866667_g105249_i0	PRJNA1255065	107477	169	0.866667	1.46466723	TM7 phylum sp. oral taxon 349	713051	Bacteria	Bacteria	313	5.859999999999999e-81	NTclustered	gi\|2028829559\|gb\|CP072328.1\|	713051	g105249	i0	100	1	169	0	100	0	1	169	636618	636450	TM7 phylum sp. oral taxon 349 strain PM007 chromosome, complete genome	blastn	169	313	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					TM7 phylum sp. oral taxon 349
28084422	28084422	PRJNA1255065_P_NODE_115085_length_168_cov_0.873950_g112857_i0	PRJNA1255065	115085	168	0.87395	1.468236	Candidatus Rokuibacteriota bacterium	2053607	Bacteria	Bacteria	48.5	3.74e-5	NR	PYN20038.1	2053607	g112857	i0	47.1	0.910714285714286	51	27	91.1	0	161	9	58	108	PYN20038.1 MAG: hypothetical protein DMD76_24725 [Candidatus Rokuibacteriota bacterium]	diamond	153	48.5	1	Bacteria	Bacteria candidate phyla	Candidatus Rokuibacteriota					Candidatus Rokuibacteriota bacterium
29063427	29063427	PRJNA1255065_P_NODE_109208_length_169_cov_0.866667_g106980_i0	PRJNA1255065	109208	169	0.866667	1.46466723	Candidatus Saccharimonadota bacterium	2026720	Bacteria	Bacteria	102	2.2999999999999994e-24	NR	MEO7617268.1	2026720	g106980	i0	81.8	0.976331360946746	55	10	97.6	0	3	167	155	209	MEO7617268.1 phenylalanine--tRNA ligase subunit alpha [Candidatus Saccharibacteria bacterium]	diamond	165	102	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharimonadota bacterium
29662839	29662839	PRJNA1255065_P_NODE_113370_length_168_cov_0.873950_g111142_i0	PRJNA1255065	113370	168	0.87395	1.468236	Candidatus Saccharimonadota bacterium	2026720	Bacteria	Bacteria	105	4.81e-25	NR	MBB1555000.1	2026720	g111142	i0	98.2	1	56	1	100	0	168	1	320	375	MBB1555000.1 Asp-tRNA(Asn)/Glu-tRNA(Gln) amidotransferase subunit GatB [Candidatus Saccharibacteria bacterium]	diamond	168	105	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharimonadota bacterium
29789372	29789372	PRJNA1255065_P_NODE_79811_length_201_cov_1.026316_g77583_i0	PRJNA1255065	79811	201	1.026316	2.06289516	Candidatus Altimarinota bacterium	2044595	Bacteria	Bacteria	48.1	1.35e-5	NR	GAB0174574.1	2044595	g77583	i0	66.7	0.492537313432836	33	11	49.3	0	138	40	14	46	GAB0174574.1 MAG: hypothetical protein HHAS10_04530 [Candidatus Altimarinota bacterium]	diamond	99	48.1	1	Bacteria	Bacteria candidate phyla	Candidatus Altimarinota					Candidatus Altimarinota bacterium
29820864	29820864	PRJNA1255065_P_NODE_122251_length_166_cov_1.547009_g120023_i0	PRJNA1255065	122251	166	1.547009	2.56803494	Candidatus Saccharimonadales bacterium	2973664	Bacteria	Bacteria	95.1	3.0500000000000003e-22	NR	HET7629805.1	2973664	g120023	i0	77.4	3.81325301204819	53	12	95.8	0	159	1	164	216	HET7629805.1 hypothetical protein [Candidatus Saccharimonadales bacterium]	diamond	633	95.1	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Saccharimonadales			Candidatus Saccharimonadales bacterium
29979040	29979040	PRJNA1255065_P_NODE_87591_length_189_cov_1.485714_g85363_i0	PRJNA1255065	87591	189	1.485714	2.80799946	Minisyncoccia bacterium	3120121	Bacteria	Bacteria	60.8	1.98e-9	NR	MFT7645060.1	3120121	g85363	i0	62.5	1.65079365079365	48	18	76.2	0	38	181	44	91	MFT7645060.1 hypothetical protein [Minisyncoccia bacterium]	diamond	312	60.8	1	Bacteria	Bacteria candidate phyla	Minisyncoccota	Minisyncoccia				Minisyncoccia bacterium
29979042	29979042	PRJNA1255065_P_NODE_96731_length_178_cov_0.875969_g94503_i0	PRJNA1255065	96731	178	0.875969	1.55922482	Patescibacteria group bacterium	2052139	Bacteria	Bacteria	42.7	0.0159	NR	MDD4412411.1	2052139	g94503	i0	45	0.674157303370786	40	22	67.4	0	139	20	246	285	MDD4412411.1 UDP-N-acetylmuramate--L-alanine ligase [Patescibacteria group bacterium]	diamond	120	42.7	1	Bacteria	Bacteria candidate phyla						Patescibacteria group bacterium
30136629	30136629	PRJNA1255065_P_NODE_137332_length_164_cov_0.904348_g135104_i0	PRJNA1255065	137332	164	0.904348	1.48313072	Candidatus Altimarinota bacterium	2044595	Bacteria	Bacteria	102	3.89e-25	NR	MBX9808961.1	2044595	g135104	i0	75.9	0.98780487804878	54	13	98.8	0	163	2	119	172	MBX9808961.1 DUF1361 domain-containing protein [Candidatus Altimarinota bacterium]	diamond	162	102	1	Bacteria	Bacteria candidate phyla	Candidatus Altimarinota					Candidatus Altimarinota bacterium
31021700	31021700	PRJNA1255065_P_NODE_135195_length_164_cov_1.121739_g132967_i0	PRJNA1255065	135195	164	1.121739	1.83965196	Patescibacteria group bacterium	2052139	Bacteria	Bacteria	56.2	5.78e-9	NR	HET7713239.1	2052139	g132967	i0	81.3	1.17073170731707	32	6	58.5	0	158	63	21	52	HET7713239.1 hypothetical protein [Patescibacteria group bacterium]	diamond	192	56.2	1	Bacteria	Bacteria candidate phyla						Patescibacteria group bacterium
32128808	32128808	PRJNA1255065_P_NODE_78578_length_203_cov_1.344156_g76350_i0	PRJNA1255065	78578	203	1.344156	2.72863668	Candidatus Babeliales bacterium	2803731	Bacteria	Bacteria	99.8	7.48e-23	NR	HJM68766.1	2803731	g76350	i0	70.1	0.990147783251232	67	20	99	0	1	201	28	94	HJM68766.1 nucleotide sugar dehydrogenase [Candidatus Babeliales bacterium]	diamond	201	99.8	1	Bacteria	Bacteria candidate phyla		Candidatus Babeliae	Candidatus Babeliales			Candidatus Babeliales bacterium
32760460	32760460	PRJNA1255065_P_NODE_81580_length_198_cov_1.355705_g79352_i0	PRJNA1255065	81580	198	1.355705	2.6842959	Minisyncoccota bacterium	2053589	Bacteria	Bacteria	42.4	0.0112	NR	HEX4104496.1	2053589	g79352	i0	43.1	0.878787878787879	58	29	83.3	3	11	175	39	95	HEX4104496.1 hypothetical protein [Candidatus Paceibacterota bacterium]	diamond	174	42.4	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);;