metadata: contig_metadata: 10 rows where bioproject = "PRJNA195897", tax_clade = "Bacteria candidate phyla" and tax

10 rows where bioproject = "PRJNA195897", tax_clade = "Bacteria candidate phyla" and tax_superkingdom = "Bacteria"

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_species
24592239	24592239	PRJNA195897_P_NODE_5800_length_202_cov_2.235294_g5767_i0	PRJNA195897	5800	202	2.235294	4.51529388	Bacteria	2	Bacteria	Bacteria	88.2	5.47e-19	NR	MBI3336722.1	2030811	g5767	i0	64.6	1.93069306930693	65	23	96.5	0	197	3	29	93	MBI3336722.1 uridine phosphorylase [Candidatus Peregrinibacteria bacterium]	diamond	390	88.2	1	Bacteria	Bacteria candidate phyla	Candidatus Peregrinibacteriota				Candidatus Peregrinibacteria bacterium
26852702	26852702	PRJNA195897_P_NODE_8201_length_176_cov_0.803150_g8168_i0	PRJNA195897	8201	176	0.80315	1.413544	Candidatus Binatia bacterium	2838779	Bacteria	Bacteria	51.2	1.55e-5	NR	HWX21912.1	2838779	g8168	i0	52.9	0.869318181818182	51	24	86.9	0	22	174	585	635	HWX21912.1 HYR domain-containing protein [Candidatus Binatia bacterium]	diamond	153	51.2	1	Bacteria	Bacteria candidate phyla	Candidatus Binatota	Candidatus Binatia			Candidatus Binatia bacterium
26915732	26915732	PRJNA195897_P_NODE_9962_length_167_cov_0.881356_g9929_i0	PRJNA195897	9962	167	0.881356	1.47186452	Minisyncoccia bacterium	3120121	Bacteria	Bacteria	75.1	1.81e-14	NR	MFT7484495.1	3120121	g9929	i0	58.2	0.988023952095808	55	23	98.8	0	165	1	163	217	MFT7484495.1 hypothetical protein [Minisyncoccia bacterium]	diamond	165	75.1	1	Bacteria	Bacteria candidate phyla	Minisyncoccota	Minisyncoccia			Minisyncoccia bacterium
28021655	28021655	PRJNA195897_P_NODE_2365_length_328_cov_1.021505_g2332_i0	PRJNA195897	2365	328	1.021505	3.3505364	Candidatus Saccharibacteria bacterium 49-2	1895829	Bacteria	Bacteria	52	2.78e-5	NR	OJU87784.1	1895829	g2332	i0	38.8	0.61280487804878	67	41	61.3	0	4	204	11	77	OJU87784.1 MAG: hypothetical protein BGO17_02250 [Candidatus Saccharibacteria bacterium 49-20]	diamond	201	52	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota				Candidatus Saccharibacteria bacterium 49-20
29189905	29189905	PRJNA195897_P_NODE_989_length_537_cov_1.811475_g958_i0	PRJNA195897	989	537	1.811475	9.72762075	Candidatus Uhrbacteria bacterium	2053634	Bacteria	Bacteria	126	7.89e-31	NR	MCR4313913.1	2053634	g958	i0	39	3.94972067039106	172	96	96.1	2	521	6	68	230	MCR4313913.1 serpin family protein [Candidatus Uhrbacteria bacterium]	diamond	2121	126	1	Bacteria	Bacteria candidate phyla	Candidatus Uhriibacteriota				Candidatus Uhrbacteria bacterium
29442065	29442065	PRJNA195897_P_NODE_2490_length_318_cov_1.743494_g2457_i0	PRJNA195897	2490	318	1.743494	5.54431092	Candidatus Aminicenantes bacterium	2052149	Bacteria	Bacteria	43.5	0.0308	NR	MBN2199813.1	2052149	g2457	i0	30.9	0.641509433962264	68	47	64.2	0	318	115	84	151	MBN2199813.1 PH domain-containing protein [Candidatus Aminicenantes bacterium]	diamond	204	43.5	1	Bacteria	Bacteria candidate phyla	Candidatus Aminicenantota				Candidatus Aminicenantes bacterium
30597130	30597130	PRJNA195897_P_NODE_11693_length_164_cov_0.886957_g11660_i0	PRJNA195897	11693	164	0.886957	1.45460948	Bacteria	2	Bacteria	Bacteria	41.6	0.0328	NR	MCA9376664.1	2099670	g11660	i0	64	1.3719512195122	25	9	45.7	0	159	85	365	389	MCA9376664.1 elongation factor Tu [Candidatus Dojkabacteria bacterium]	diamond	225	41.6	1	Bacteria	Bacteria candidate phyla					Candidatus Dojkabacteria bacterium
31147787	31147787	PRJNA195897_P_NODE_7395_length_183_cov_2.328358_g7362_i0	PRJNA195897	7395	183	2.328358	4.26089514	Candidatus Babeliales bacterium	2803731	Bacteria	Bacteria	47.8	2.43e-4	NR	HTL78494.1	2803731	g7362	i0	41.9	1.01639344262295	62	23	95.1	2	5	178	163	215	HTL78494.1 hypothetical protein [Candidatus Babeliales bacterium]	diamond	186	47.8	1	Bacteria	Bacteria candidate phyla		Candidatus Babeliae	Candidatus Babeliales		Candidatus Babeliales bacterium
31591119	31591119	PRJNA195897_P_NODE_11556_length_164_cov_0.904348_g11523_i0	PRJNA195897	11556	164	0.904348	1.48313072	Candidatus Roizmanbacteria bacterium	2282149	Bacteria	Bacteria	72	2.12e-14	NR	MFS8160136.1	2282149	g11523	i0	60.8	2.85365853658537	51	20	93.3	0	5	157	51	101	MFS8160136.1 thioredoxin domain-containing protein [Candidatus Roizmanbacteria bacterium]	diamond	468	72	1	Bacteria	Bacteria candidate phyla	Candidatus Roizmaniibacteriota				Candidatus Roizmanbacteria bacterium
32571907	32571907	PRJNA195897_P_NODE_12639_length_162_cov_0.920354_g12606_i0	PRJNA195897	12639	162	0.920354	1.49097348	Candidatus Babeliaceae bacterium	2545253	Bacteria	Bacteria	89.4	2.51e-19	NR	MFA6066227.1	2545253	g12606	i0	77.8	2	54	12	100	0	162	1	61	114	MFA6066227.1 tRNA guanosine(34) transglycosylase Tgt [Candidatus Babeliaceae bacterium]	diamond	324	89.4	1	Bacteria	Bacteria candidate phyla		Candidatus Babeliae	Candidatus Babeliales	Candidatus Babeliaceae	Candidatus Babeliaceae 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);;