metadata: contig_metadata: 9 rows where bioproject = "PRJNA1233465", tax_clade = "Bacteria candidate phyla" and tax

9 rows where bioproject = "PRJNA1233465", tax_clade = "Bacteria candidate phyla" and tax_phylum = "Candidatus Altimarinota"

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
25968502	25968502	PRJNA1233465f_S_NODE_62644_length_291_cov_1.723140_g60364_i0	PRJNA1233465	62644	291	1.72314	5.0143374	Candidatus Gracilibacteria bacterium HOT-871	1540872	Bacteria	Bacteria	383	8.42e-102	NTclustered	gi\|1275383184\|gb\|CP017714.1\|	1540872	g60364	i0	90.444	2.01374570446735	293	24	100	4	1	291	891261	891551	Candidatus Gracilibacteria bacterium HOT-871, complete genome	blastn	586	383	1	Bacteria	Bacteria candidate phyla	Candidatus Altimarinota	Candidatus Gracilibacteria bacterium HOT-871
32933253	32933253	PRJNA1233465e_S_NODE_139625_length_168_cov_1.714286_g138315_i0	PRJNA1233465	139625	168	1.714286	2.88000048	Candidatus Altimarinota bacterium	2044595	Bacteria	Bacteria	78.6	5.75e-16	NR	MBF0981400.1	2044595	g138315	i0	92.1	0.678571428571429	38	3	67.9	0	115	2	182	219	MBF0981400.1 type II secretion system protein [Candidatus Altimarinota bacterium]	diamond	114	78.6	1	Bacteria	Bacteria candidate phyla	Candidatus Altimarinota	Candidatus Altimarinota bacterium
33001636	33001636	PRJNA1233465e_S_NODE_129667_length_173_cov_2.467742_g128357_i0	PRJNA1233465	129667	173	2.467742	4.26919366	Candidatus Altimarinota bacterium	2044595	Bacteria	Bacteria	100	1.99e-24	NR	MBF0981399.1	2044595	g128357	i0	87.3	0.953757225433526	55	7	95.4	0	7	171	100	154	MBF0981399.1 hypothetical protein [Candidatus Altimarinota bacterium]	diamond	165	100	1	Bacteria	Bacteria candidate phyla	Candidatus Altimarinota	Candidatus Altimarinota bacterium
33002306	33002306	PRJNA1233465f_S_NODE_161755_length_194_cov_1.758621_g159475_i0	PRJNA1233465	161755	194	1.758621	3.41172474	Candidatus Altimarinota bacterium	2044595	Bacteria	Bacteria	51.2	1.5e-5	NR	MBF0981400.1	2044595	g159475	i0	92	0.38659793814433	25	2	38.7	0	193	119	140	164	MBF0981400.1 type II secretion system protein [Candidatus Altimarinota bacterium]	diamond	75	51.2	1	Bacteria	Bacteria candidate phyla	Candidatus Altimarinota	Candidatus Altimarinota bacterium
33086003	33086003	PRJNA1233465b_S_NODE_294238_length_176_cov_3.677165_g292553_i0	PRJNA1233465	294238	176	3.677165	6.4718104	Candidatus Altimarinota bacterium	2044595	Bacteria	Bacteria	53.9	1.69e-6	NR	RKW22889.1	2044595	g292553	i0	92.6	0.460227272727273	27	2	46	0	122	42	33	59	RKW22889.1 MAG: hypothetical protein D8B45_04215, partial [Candidatus Altimarinota bacterium]	diamond	81	53.9	1	Bacteria	Bacteria candidate phyla	Candidatus Altimarinota	Candidatus Altimarinota bacterium
33155783	33155783	PRJNA1233465f_S_NODE_190320_length_181_cov_3.257576_g188040_i0	PRJNA1233465	190320	181	3.257576	5.89621256	Candidatus Altimarinota bacterium	2044595	Bacteria	Bacteria	107	4.47e-27	NR	MBF0981399.1	2044595	g188040	i0	86.4	0.977900552486188	59	8	97.8	0	3	179	106	164	MBF0981399.1 hypothetical protein [Candidatus Altimarinota bacterium]	diamond	177	107	1	Bacteria	Bacteria candidate phyla	Candidatus Altimarinota	Candidatus Altimarinota bacterium
33155906	33155906	PRJNA1233465f_S_NODE_231272_length_167_cov_1.771186_g228992_i0	PRJNA1233465	231272	167	1.771186	2.95788062	Candidatus Altimarinota bacterium	2044595	Bacteria	Bacteria	47.8	2e-4	NR	MBF0981399.1	2044595	g228992	i0	86.4	0.395209580838323	22	3	39.5	0	69	134	77	98	MBF0981399.1 hypothetical protein [Candidatus Altimarinota bacterium]	diamond	66	47.8	1	Bacteria	Bacteria candidate phyla	Candidatus Altimarinota	Candidatus Altimarinota bacterium
33170870	33170870	PRJNA1233465a_S_NODE_63104_length_271_cov_3.581081_g61830_i0	PRJNA1233465	63104	271	3.581081	9.70472951	Candidatus Altimarinota bacterium	2044595	Bacteria	Bacteria	44.3	0.0122	NR	MBW7954228.1	2044595	g61830	i0	40	0.44280442804428	40	24	44.3	0	129	248	64	103	MBW7954228.1 UPF0489 family protein [Candidatus Altimarinota bacterium]	diamond	120	44.3	1	Bacteria	Bacteria candidate phyla	Candidatus Altimarinota	Candidatus Altimarinota bacterium
33171058	33171058	PRJNA1233465b_S_NODE_128680_length_250_cov_2.791045_g126995_i0	PRJNA1233465	128680	250	2.791045	6.9776125	Candidatus Altimarinota bacterium	2044595	Bacteria	Bacteria	42.4	0.00383	NR	MBF0981681.1	2044595	g126995	i0	95	0.96	20	1	24	0	144	85	1	20	MBF0981681.1 50S ribosomal protein L36 [Candidatus Altimarinota bacterium]	diamond	240	42.4	1	Bacteria	Bacteria candidate phyla	Candidatus Altimarinota	Candidatus Altimarinota 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);;