metadata: contig_metadata: 10 rows where bioproject = "PRJNA340009" and tax

10 rows where bioproject = "PRJNA340009" and tax_phylum = "Candidatus Berkelbacteria"

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
16969754	16969754	PRJNA340009_P_NODE_57154_length_173_cov_1.620968_g56847_i0	PRJNA340009	57154	173	1.620968	2.80427464	Candidatus Berkelbacteria bacterium	2053521	Bacteria	Bacteria	117	3.71e-29	NR	MCR4307145.1	2053521	g56847	i0	93	0.988439306358382	57	4	98.8	0	172	2	117	173	MCR4307145.1 hypothetical protein [Candidatus Berkelbacteria bacterium]	diamond	171	117	1	Bacteria	Bacteria candidate phyla	Candidatus Berkelbacteria	Candidatus Berkelbacteria bacterium
26789984	26789984	PRJNA340009_P_NODE_46501_length_189_cov_1.292857_g46194_i0	PRJNA340009	46501	189	1.292857	2.44349973	Candidatus Berkelbacteria bacterium	2053521	Bacteria	Bacteria	97.8	7.24e-22	NR	MCR4307871.1	2053521	g46194	i0	72.6	0.984126984126984	62	17	98.4	0	188	3	354	415	MCR4307871.1 type IV secretion system protein [Candidatus Berkelbacteria bacterium]	diamond	186	97.8	1	Bacteria	Bacteria candidate phyla	Candidatus Berkelbacteria	Candidatus Berkelbacteria bacterium
26979741	26979741	PRJNA340009_P_NODE_49302_length_184_cov_5.288889_g48995_i0	PRJNA340009	49302	184	5.288889	9.7315557600000009	Candidatus Berkelbacteria bacterium	2053521	Bacteria	Bacteria	96.3	2.4e-21	NR	MDO8650088.1	2053521	g48995	i0	86.5	2.44565217391304	52	7	84.8	0	184	29	272	323	MDO8650088.1 phosphoenolpyruvate synthase [Candidatus Berkelbacteria bacterium]	diamond	450	96.3	1	Bacteria	Bacteria candidate phyla	Candidatus Berkelbacteria	Candidatus Berkelbacteria bacterium
27724110	27724110	PRJNA340009_P_NODE_13104_length_323_cov_17.237226_g12797_i0	PRJNA340009	13104	323	17.237226	55.67623998	Bacteria	2	Bacteria	Bacteria	97.4	1.07e-21	NR	OGD65955.1	1797472	g12797	i0	62.5	1.9969040247678	72	27	66.9	0	323	108	247	318	OGD65955.1 MAG: hypothetical protein A2215_04120 [Candidatus Berkelbacteria bacterium RIFOXYA2_FULL_43_10]	diamond	645	98.2	0.991853360488798	Bacteria	Bacteria candidate phyla	Candidatus Berkelbacteria	Candidatus Berkelbacteria bacterium RIFOXYA2_FULL_43_10
28116873	28116873	PRJNA340009_P_NODE_38965_length_203_cov_4.714286_g38658_i0	PRJNA340009	38965	203	4.714286	9.57000058	Candidatus Berkelbacteria bacterium	2053521	Bacteria	Bacteria	102	1.1099999999999999e-23	NR	MDO8686728.1	2053521	g38658	i0	74.2	0.916256157635468	62	16	91.6	0	17	202	2	63	MDO8686728.1 replicative DNA helicase [Candidatus Berkelbacteria bacterium]	diamond	186	102	1	Bacteria	Bacteria candidate phyla	Candidatus Berkelbacteria	Candidatus Berkelbacteria bacterium
28116886	28116886	PRJNA340009_P_NODE_57405_length_172_cov_8.479675_g57098_i0	PRJNA340009	57405	172	8.479675	14.585041	Candidatus Berkelbacteria bacterium	2053521	Bacteria	Bacteria	82.8	8.09e-17	NR	MEI6040570.1	2053521	g57098	i0	79.6	0.854651162790698	49	10	85.5	0	151	5	171	219	MEI6040570.1 trigger factor [Candidatus Berkelbacteria bacterium]	diamond	147	82.8	1	Bacteria	Bacteria candidate phyla	Candidatus Berkelbacteria	Candidatus Berkelbacteria bacterium
28211499	28211499	PRJNA340009_P_NODE_37106_length_207_cov_10.189873_g36799_i0	PRJNA340009	37106	207	10.189873	21.09303711	Candidatus Berkelbacteria bacterium	2053521	Bacteria	Bacteria	66.6	2.82e-11	NR	MBI3495337.1	2053521	g36799	i0	67.3	0.710144927536232	49	16	71	0	153	7	172	220	MBI3495337.1 hypothetical protein [Candidatus Berkelbacteria bacterium]	diamond	147	66.6	1	Bacteria	Bacteria candidate phyla	Candidatus Berkelbacteria	Candidatus Berkelbacteria bacterium
30250146	30250146	PRJNA340009_P_NODE_69012_length_164_cov_0.886957_g68705_i0	PRJNA340009	69012	164	0.886957	1.45460948	Bacteria	2	Bacteria	Bacteria	52.8	3.61e-6	NR	PIT97274.1	1974513	g68705	i0	61.4	1.79268292682927	44	15	80.5	2	143	12	60	101	PIT97274.1 MAG: rod shape-determining protein [Candidatus Berkelbacteria bacterium CG10_big_fil_rev_8_21_14_0_10_41_12]	diamond	294	52.8	1	Bacteria	Bacteria candidate phyla	Candidatus Berkelbacteria	Candidatus Berkelbacteria bacterium CG10_big_fil_rev_8_21_14_0_10_41_12
31180234	31180234	PRJNA340009_P_NODE_60795_length_168_cov_1.714286_g60488_i0	PRJNA340009	60795	168	1.714286	2.88000048	Candidatus Berkelbacteria bacterium	2053521	Bacteria	Bacteria	58.5	1.98e-8	NR	MCR4307173.1	2053521	g60488	i0	65.8	0.678571428571429	38	13	67.9	0	114	1	17	54	MCR4307173.1 hypothetical protein [Candidatus Berkelbacteria bacterium]	diamond	114	58.5	1	Bacteria	Bacteria candidate phyla	Candidatus Berkelbacteria	Candidatus Berkelbacteria bacterium
32129703	32129703	PRJNA340009_P_NODE_55178_length_175_cov_12.714286_g54871_i0	PRJNA340009	55178	175	12.714286	22.2500005	Berkelbacteria bacterium GW2	2053521	Bacteria	Bacteria	41.6	0.0373	NR	KKU43394.1	1618335	g54871	i0	53.6	0.48	28	13	48	0	2	85	180	207	KKU43394.1 MAG: hypothetical protein UX60_C0027G0006 [Berkelbacteria bacterium GW2011_GWA2_46_7]	diamond	84	41.6	1	Bacteria	Bacteria candidate phyla	Candidatus Berkelbacteria	Berkelbacteria bacterium GW2011_GWA2_46_7

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);;