metadata: contig_metadata: 10 rows where analysis = "diamond", bioproject = "PRJNA358490" and tax

10 rows where analysis = "diamond", bioproject = "PRJNA358490" 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_species
4901190	4901190	PRJNA358490_P_NODE_5144_length_605_cov_1.674912_g2958_i1	PRJNA358490	5144	605	1.674912	10.1332176	Patescibacteria group bacterium	2052139	Bacteria	Bacteria	233	1.87e-73	NR	HSI98980.1	2052139	g2958	i1	99.2	1.2	121	1	60	0	383	21	78	198	HSI98980.1 ABC transporter permease [Patescibacteria group bacterium]	diamond	726	233	1	Bacteria	Bacteria candidate phyla			Patescibacteria group bacterium
6176230	6176230	PRJNA358490_P_NODE_3165_length_806_cov_1.764016_g2958_i0	PRJNA358490	3165	806	1.764016	14.21796896	Patescibacteria group bacterium	2052139	Bacteria	Bacteria	355	1.75e-120	NR	HSI98980.1	2052139	g2958	i0	91.4	0.73697270471464	198	17	73.7	0	614	21	1	198	HSI98980.1 ABC transporter permease [Patescibacteria group bacterium]	diamond	594	355	1	Bacteria	Bacteria candidate phyla			Patescibacteria group bacterium
14427715	14427715	PRJNA358490_P_NODE_12392_length_238_cov_1.125628_g12048_i0	PRJNA358490	12392	238	1.125628	2.67899464	Bacteria	2	Bacteria	Bacteria	158	1.4599999999999998e-43	NR	MDB5225014.1	1932010	g12048	i0	91.1	10.8781512605042	79	7	99.6	0	1	237	387	465	MDB5225014.1 hypothetical protein [Candidatus Adlerbacteria bacterium]	diamond	2589	159	0.993710691823899	Bacteria	Bacteria candidate phyla	Candidatus Adleribacteriota		Candidatus Adlerbacteria bacterium
26726294	26726294	PRJNA358490_P_NODE_7181_length_475_cov_1.756881_g6847_i0	PRJNA358490	7181	475	1.756881	8.34518475	Candidatus Binatia bacterium	2838779	Bacteria	Bacteria	122	3.96e-29	NR	HJY83301.1	2838779	g6847	i0	77.5	0.448421052631579	71	16	44.8	0	2	214	396	466	HJY83301.1 group II intron reverse transcriptase/maturase [Candidatus Binatia bacterium]	diamond	213	122	1	Bacteria	Bacteria candidate phyla	Candidatus Binatota	Candidatus Binatia	Candidatus Binatia bacterium
27534370	27534370	PRJNA358490_P_NODE_18443_length_150_cov_1.477477_g18099_i0	PRJNA358490	18443	150	1.477477	2.2162155	Bacteria	2	Bacteria	Bacteria	88.6	7.55e-19	NR	HSJ00526.1	2052139	g18099	i0	93.8	3.96	48	3	96	0	1	144	142	189	HSJ00526.1 ATP-dependent DNA helicase [Patescibacteria group bacterium]	diamond	594	88.6	1	Bacteria	Bacteria candidate phyla			Patescibacteria group bacterium
27643741	27643741	PRJNA358490_P_NODE_6104_length_538_cov_2.737475_g5785_i0	PRJNA358490	6104	538	2.737475	14.7276155	Candidatus Methylomirabilota bacterium	2072417	Bacteria	Bacteria	46.6	0.0147	NR	HWN97244.1	2072417	g5785	i0	31.7	1.19330855018587	104	60	58	3	109	420	114	206	HWN97244.1 FkbM family methyltransferase [Candidatus Methylomirabilota bacterium]	diamond	642	46.6	1	Bacteria	Bacteria candidate phyla	Candidatus Methylomirabilota		Candidatus Methylomirabilota bacterium
27787121	27787121	PRJNA358490_P_NODE_10044_length_330_cov_2.292096_g9702_i0	PRJNA358490	10044	330	2.292096	7.5639168	Bacteria	2	Bacteria	Bacteria	176	2.04e-50	NR	HSI98796.1	2052139	g9702	i0	77.3	2.98181818181818	110	24	99.1	1	329	3	361	470	HSI98796.1 extracellular solute-binding protein [Patescibacteria group bacterium]	diamond	984	176	1	Bacteria	Bacteria candidate phyla			Patescibacteria group bacterium
29727135	29727135	PRJNA358490_P_NODE_4870_length_629_cov_1.569492_g4596_i0	PRJNA358490	4870	629	1.569492	9.87210468	Candidatus Binatia bacterium	2838779	Bacteria	Bacteria	82	4.44e-16	NR	HEY2773387.1	2838779	g4596	i0	54.2	0.343402225755167	72	31	34.3	1	28	243	59	128	HEY2773387.1 diguanylate cyclase [Candidatus Binatia bacterium]	diamond	216	82	1	Bacteria	Bacteria candidate phyla	Candidatus Binatota	Candidatus Binatia	Candidatus Binatia bacterium
30628890	30628890	PRJNA358490_P_NODE_12013_length_250_cov_1.156398_g11669_i0	PRJNA358490	12013	250	1.156398	2.890995	Pseudomonadati	3379134	Bacteria	Bacteria	50.4	3.37e-5	NR	HYN70350.1	2212470	g11669	i0	61.9	2.988	42	15	50.4	1	230	105	117	157	HYN70350.1 YetF domain-containing protein [Candidatus Eiseniibacteriota bacterium]	diamond	747	50.4	1	Bacteria	Bacteria candidate phyla	Candidatus Eiseniibacteriota		Candidatus Eiseniibacteriota bacterium
32477904	32477904	PRJNA358490_P_NODE_15479_length_176_cov_1.766423_g15135_i0	PRJNA358490	15479	176	1.766423	3.10890448	Patescibacteria group bacterium	2052139	Bacteria	Bacteria	105	1.64e-24	NR	HSJ00526.1	2052139	g15135	i0	100	14.7784090909091	51	0	86.9	0	174	22	244	294	HSJ00526.1 ATP-dependent DNA helicase [Patescibacteria group bacterium]	diamond	2601	105	1	Bacteria	Bacteria candidate phyla			Patescibacteria group 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);;