metadata: contig_metadata: 8 rows where bioproject = "PRJNA799842", tax_clade = "Bacteria candidate phyla" and tax

8 rows where bioproject = "PRJNA799842", tax_clade = "Bacteria candidate phyla" and tax_phylum = "Minisyncoccota"

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
26642401	26642401	PRJNA799842_P_NODE_147621_length_249_cov_0.875000_g146048_i0	PRJNA799842	147621	249	0.875	2.17875	Minisyncoccota bacterium	2053589	Bacteria	Bacteria	94.4	1.64e-20	NR	HEY6022359.1	2053589	g146048	i0	57.3	0.987951807228916	82	34	98.8	1	1	246	329	409	HEY6022359.1 ISKra4 family transposase [Candidatus Paceibacterota bacterium]	diamond	246	94.4	1	Bacteria	Bacteria candidate phyla	Minisyncoccota	Minisyncoccota bacterium
26864487	26864487	PRJNA799842_P_NODE_188001_length_241_cov_0.916667_g186428_i0	PRJNA799842	188001	241	0.916667	2.20916747	Minisyncoccota bacterium	2053589	Bacteria	Bacteria	80.9	1.4e-15	NR	MEZ0208857.1	2053589	g186428	i0	53.8	0.995850622406639	80	35	97.1	2	2	235	751	830	MEZ0208857.1 reverse transcriptase domain-containing protein [Candidatus Paceibacterota bacterium]	diamond	240	80.9	1	Bacteria	Bacteria candidate phyla	Minisyncoccota	Minisyncoccota bacterium
27379336	27379336	PRJNA799842_P_NODE_153343_length_248_cov_0.880000_g151770_i0	PRJNA799842	153343	248	0.88	2.1824	Bacteria	2	Bacteria	Bacteria	156	4.9199999999999985e-43	NR	HLP77005.1	2053589	g151770	i0	86.6	1.98387096774194	82	11	99.2	0	2	247	49	130	HLP77005.1 DEAD/DEAH box helicase family protein [Candidatus Paceibacterota bacterium]	diamond	492	156	1	Bacteria	Bacteria candidate phyla	Minisyncoccota	Minisyncoccota bacterium
27433483	27433483	PRJNA799842_P_NODE_143583_length_250_cov_0.870056_g142010_i0	PRJNA799842	143583	250	0.870056	2.17514	Minisyncoccota bacterium	2053589	Bacteria	Bacteria	92.4	1.38e-19	NR	HEY0980158.1	2053589	g142010	i0	84.6	1.248	52	8	62.4	0	249	94	234	285	HEY0980158.1 tail fiber domain-containing protein [Candidatus Paceibacterota bacterium]	diamond	312	92.4	1	Bacteria	Bacteria candidate phyla	Minisyncoccota	Minisyncoccota bacterium
28285572	28285572	PRJNA799842_P_NODE_74766_length_332_cov_1.181467_g73193_i0	PRJNA799842	74766	332	1.181467	3.92247044	Minisyncoccota bacterium	2053589	Bacteria	Bacteria	50.8	3.04e-5	NR	HEY6022510.1	2053589	g73193	i0	36.4	0.596385542168675	66	42	59.6	0	133	330	11	76	HEY6022510.1 hypothetical protein [Candidatus Paceibacterota bacterium]	diamond	198	50.8	1	Bacteria	Bacteria candidate phyla	Minisyncoccota	Minisyncoccota bacterium
28569829	28569829	PRJNA799842_P_NODE_103167_length_287_cov_1.172897_g101594_i0	PRJNA799842	103167	287	1.172897	3.36621439	Minisyncoccota bacterium	2053589	Bacteria	Bacteria	82	1.02e-15	NR	MCU0678066.1	2053589	g101594	i0	52.5	0.836236933797909	80	30	75.3	1	286	71	3137	3216	MCU0678066.1 hypothetical protein [Candidatus Paceibacterota bacterium]	diamond	240	82	1	Bacteria	Bacteria candidate phyla	Minisyncoccota	Minisyncoccota bacterium
30527889	30527889	PRJNA799842_P_NODE_172453_length_244_cov_0.900585_g170880_i0	PRJNA799842	172453	244	0.900585	2.1974274	Minisyncoccota bacterium	2053589	Bacteria	Bacteria	76.3	6.05e-14	NR	HWA32062.1	2053589	g170880	i0	58.4	1.61065573770492	77	30	94.7	2	237	7	130	204	HWA32062.1 CARDB domain-containing protein [Candidatus Paceibacterota bacterium]	diamond	393	76.3	1	Bacteria	Bacteria candidate phyla	Minisyncoccota	Minisyncoccota bacterium
32897993	32897993	PRJNA799842_P_NODE_136000_length_251_cov_0.865169_g134427_i0	PRJNA799842	136000	251	0.865169	2.17157419	Minisyncoccota bacterium	2053589	Bacteria	Bacteria	139	8.599999999999999e-38	NR	HMO77891.1	2053589	g134427	i0	84.1	0.9800796812749	82	13	98	0	6	251	1	82	HMO77891.1 pilus assembly protein PilM [Candidatus Paceibacterota bacterium]	diamond	246	139	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);;