metadata: contig_metadata: 11 rows where bioproject = "PRJNA494251", tax_clade = "Bacteria candidate phyla" and tax

11 rows where bioproject = "PRJNA494251", 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
1750356	1750356	PRJNA494251_P_NODE_37822_length_250_cov_1.677966_g37508_i0	PRJNA494251	37822	250	1.677966	4.194915	Minisyncoccota bacterium	2053589	Bacteria	Bacteria	141	6.51e-41	NR	MDR3570573.1	2053589	g37508	i0	86.9	1.992	84	9	98.4	1	248	3	11	94	MDR3570573.1 TCP-1/cpn60 chaperonin family protein [Candidatus Paceibacterota bacterium]	diamond	498	141	1	Bacteria	Bacteria candidate phyla	Minisyncoccota	Minisyncoccota bacterium
3026020	3026020	PRJNA494251_P_NODE_12223_length_389_cov_0.974684_g11916_i0	PRJNA494251	12223	389	0.974684	3.79152076	Candidatus Pacebacteria bacterium GW2011_GWB1_47_8	1618470	Bacteria	Bacteria	100	1.31e-16	NTclustered	gi\|1118703619\|gb\|KX123532.1\|	1618470	g11916	i0	82.883	23.9228791773779	111	19	29	0	99	209	767	657	Candidatus Pacebacteria bacterium GW2011_GWB1_47_8 16S ribosomal RNA gene, partial sequence	blastn	9306	100	1	Bacteria	Bacteria candidate phyla	Minisyncoccota	Candidatus Pacebacteria bacterium GW2011_GWB1_47_8
27519319	27519319	PRJNA494251_P_NODE_35343_length_255_cov_1.346154_g35029_i0	PRJNA494251	35343	255	1.346154	3.4326927	Minisyncoccota bacterium	2053589	Bacteria	Bacteria	63.2	2.76e-9	NR	MDR3570672.1	2053589	g35029	i0	41.8	0.788235294117647	67	39	78.8	0	203	3	802	868	MDR3570672.1 hypothetical protein [Candidatus Paceibacterota bacterium]	diamond	201	63.2	1	Bacteria	Bacteria candidate phyla	Minisyncoccota	Minisyncoccota bacterium
28150924	28150924	PRJNA494251_P_NODE_17145_length_338_cov_1.713208_g16832_i0	PRJNA494251	17145	338	1.713208	5.79064304	Minisyncoccota bacterium	2053589	Bacteria	Bacteria	63.9	5.6e-10	NR	MFA6159322.1	2053589	g16832	i0	47.9	0.64792899408284	73	36	63	1	9	221	80	152	MFA6159322.1 hypothetical protein [Candidatus Paceibacterota bacterium]	diamond	219	63.9	1	Bacteria	Bacteria candidate phyla	Minisyncoccota	Minisyncoccota bacterium
28592902	28592902	PRJNA494251_P_NODE_22107_length_305_cov_1.655172_g21793_i0	PRJNA494251	22107	305	1.655172	5.0482746	Minisyncoccota bacterium	2053589	Bacteria	Bacteria	47.8	0.00126	NR	MDR3548387.1	2053589	g21793	i0	33.7	0.904918032786885	92	57	90.5	4	276	1	237	324	MDR3548387.1 hypothetical protein [Candidatus Paceibacterota bacterium]	diamond	276	47.8	1	Bacteria	Bacteria candidate phyla	Minisyncoccota	Minisyncoccota bacterium
29445102	29445102	PRJNA494251_P_NODE_35830_length_253_cov_2.677778_g35516_i0	PRJNA494251	35830	253	2.677778	6.77477834	Minisyncoccota bacterium	2053589	Bacteria	Bacteria	44.7	0.00847	NR	MFA6000351.1	2053589	g35516	i0	32.4	0.877470355731225	74	42	78.3	2	230	33	77	150	MFA6000351.1 ABC transporter ATP-binding protein [Candidatus Paceibacterota bacterium]	diamond	222	44.7	1	Bacteria	Bacteria candidate phyla	Minisyncoccota	Minisyncoccota bacterium
29792475	29792475	PRJNA494251_P_NODE_49991_length_241_cov_0.916667_g49677_i0	PRJNA494251	49991	241	0.916667	2.20916747	Minisyncoccota bacterium	2053589	Bacteria	Bacteria	63.5	1.65e-9	NR	MDR3582248.1	2053589	g49677	i0	43.9	1.0207468879668	82	44	99.6	2	240	1	167	248	MDR3582248.1 clusterin-associated protein 1 [Candidatus Paceibacterota bacterium]	diamond	246	63.5	1	Bacteria	Bacteria candidate phyla	Minisyncoccota	Minisyncoccota bacterium
29950621	29950621	PRJNA494251_P_NODE_851_length_1213_cov_1.821053_g703_i0	PRJNA494251	851	1213	1.821053	22.08937289	Minisyncoccota bacterium	2053589	Bacteria	Bacteria	47.4	0.00249	NR	HET9641418.1	2053589	g703	i0	61.3	0.0766694146743611	31	12	7.7	0	369	461	28	58	HET9641418.1 hypothetical protein [Candidatus Paceibacterota bacterium]	diamond	93	47.4	1	Bacteria	Bacteria candidate phyla	Minisyncoccota	Minisyncoccota bacterium
30393330	30393330	PRJNA494251_P_NODE_27173_length_282_cov_1.473684_g26859_i0	PRJNA494251	27173	282	1.473684	4.15578888	Minisyncoccota bacterium	2053589	Bacteria	Bacteria	105	3.83e-26	NR	MDR3549226.1	2053589	g26859	i0	57	0.98936170212766	93	40	98.9	0	2	280	46	138	MDR3549226.1 helix-turn-helix domain-containing protein [Candidatus Paceibacterota bacterium]	diamond	279	105	1	Bacteria	Bacteria candidate phyla	Minisyncoccota	Minisyncoccota bacterium
31340876	31340876	PRJNA494251_P_NODE_16136_length_347_cov_1.124088_g15823_i0	PRJNA494251	16136	347	1.124088	3.90058536	Minisyncoccota bacterium	2053589	Bacteria	Bacteria	61.6	9.41e-10	NR	MDR3572201.1	2053589	g15823	i0	64.6	0.414985590778098	48	17	41.5	0	342	199	40	87	MDR3572201.1 hypothetical protein [Candidatus Paceibacterota bacterium]	diamond	144	61.6	1	Bacteria	Bacteria candidate phyla	Minisyncoccota	Minisyncoccota bacterium
31910228	31910228	PRJNA494251_P_NODE_17037_length_339_cov_1.642857_g16724_i0	PRJNA494251	17037	339	1.642857	5.56928523	Minisyncoccota bacterium	2053589	Bacteria	Bacteria	46.2	7.67e-4	NR	HEY9480731.1	2053589	g16724	i0	82.6	0.389380530973451	23	4	20.4	0	270	338	30	52	HEY9480731.1 hypothetical protein [Candidatus Paceibacterota bacterium]	diamond	132	46.2	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);;