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

10 rows where bioproject = "PRJNA939415", tax_clade = "Bacteria candidate phyla" and tax_phylum = "Candidatus Parcubacteria"

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
20042537	20042537	PRJNA939415_P_NODE_62316_length_271_cov_3.414141_g61894_i0	PRJNA939415	62316	271	3.414141	9.25232211	Bacteria	2	Bacteria	Bacteria	154	3.04e-42	NR	KND51425.1	1659195	g61894	i0	85.4	15.7638376383764	89	13	98.5	0	269	3	64	152	KND51425.1 MAG: CTP synthase [Parcubacteria bacterium C7867-001]	diamond	4272	155	0.993548387096774	Bacteria	Bacteria candidate phyla	Candidatus Parcubacteria	Parcubacteria bacterium C7867-001
26645025	26645025	PRJNA939415_P_NODE_71221_length_262_cov_4.507937_g70799_i0	PRJNA939415	71221	262	4.507937	11.81079494	Candidatus Parcubacteria bacterium	2762014	Bacteria	Bacteria	47	0.00149	NR	MEY4723709.1	2762014	g70799	i0	44.6	0.641221374045801	56	30	64.1	1	84	251	400	454	MEY4723709.1 hypothetical protein [Candidatus Parcubacteria bacterium]	diamond	168	47	1	Bacteria	Bacteria candidate phyla	Candidatus Parcubacteria	Candidatus Parcubacteria bacterium
27941153	27941153	PRJNA939415_P_NODE_22505_length_328_cov_2.090196_g22084_i0	PRJNA939415	22505	328	2.090196	6.85584288	Candidatus Parcubacteria bacterium	2762014	Bacteria	Bacteria	111	3.08e-26	NR	MCK4745078.1	2762014	g22084	i0	48.1	1.92987804878049	106	54	97	1	327	10	78	182	MCK4745078.1 N-6 DNA methylase [Candidatus Parcubacteria bacterium]	diamond	633	111	1	Bacteria	Bacteria candidate phyla	Candidatus Parcubacteria	Candidatus Parcubacteria bacterium
29141143	29141143	PRJNA939415_P_NODE_45009_length_288_cov_4.595349_g44587_i0	PRJNA939415	45009	288	4.595349	13.23460512	Candidatus Parcubacteria bacterium	2762014	Bacteria	Bacteria	82.4	6.45e-16	NR	MEA2701622.1	2762014	g44587	i0	50	1	96	47	99	1	3	287	260	355	MEA2701622.1 two-component system, NtrC family, sensor kinase [Candidatus Parcubacteria bacterium]	diamond	288	82.4	1	Bacteria	Bacteria candidate phyla	Candidatus Parcubacteria	Candidatus Parcubacteria bacterium
29141193	29141193	PRJNA939415_P_NODE_78829_length_255_cov_2.373626_g78407_i0	PRJNA939415	78829	255	2.373626	6.0527463	Candidatus Parcubacteria bacterium	2762014	Bacteria	Bacteria	120	1.22e-30	NR	MEN9413216.1	2762014	g78407	i0	76.2	4.87058823529412	84	20	98.8	0	3	254	133	216	MEN9413216.1 hypothetical protein [Candidatus Parcubacteria bacterium]	diamond	1242	120	1	Bacteria	Bacteria candidate phyla	Candidatus Parcubacteria	Candidatus Parcubacteria bacterium
30442903	30442903	PRJNA939415_P_NODE_33033_length_310_cov_2.683544_g32611_i0	PRJNA939415	33033	310	2.683544	8.3189864	Bacteria	2	Bacteria	Bacteria	97.4	5.3e-21	NR	KND50840.1	1659201	g32611	i0	95.9	10.858064516129	49	2	47.4	0	148	2	439	487	KND50840.1 MAG: excinuclease ABC subunit A [Parcubacteria bacterium C7867-007]	diamond	3366	97.4	1	Bacteria	Bacteria candidate phyla	Candidatus Parcubacteria	Parcubacteria bacterium C7867-007
31004565	31004565	PRJNA939415_P_NODE_31454_length_310_cov_2.928270_g31032_i0	PRJNA939415	31454	310	2.92827	9.077637	Parcubacteria bacterium C7867-	2762014	Bacteria	Bacteria	143	7.72e-38	NR	KND50485.1	1659201	g31032	i0	70.8	2.05161290322581	106	28	99.7	1	1	309	402	507	KND50485.1 MAG: chaperonin GroL [Parcubacteria bacterium C7867-007]	diamond	636	143	1	Bacteria	Bacteria candidate phyla	Candidatus Parcubacteria	Parcubacteria bacterium C7867-007
32238279	32238279	PRJNA939415_P_NODE_16038_length_388_cov_2.384127_g15618_i0	PRJNA939415	16038	388	2.384127	9.25041276	Candidatus Parcubacteria bacterium	2762014	Bacteria	Bacteria	86.3	3.17e-17	NR	MEY4747177.1	2762014	g15618	i0	57.8	0.641752577319588	83	32	62.6	2	257	15	84	165	MEY4747177.1 hypothetical protein [Candidatus Parcubacteria bacterium]	diamond	249	86.3	1	Bacteria	Bacteria candidate phyla	Candidatus Parcubacteria	Candidatus Parcubacteria bacterium
32238351	32238351	PRJNA939415_P_NODE_69658_length_264_cov_2.261780_g69236_i0	PRJNA939415	69658	264	2.26178	5.9710992	Candidatus Parcubacteria bacterium	2762014	Bacteria	Bacteria	48.5	4.23e-5	NR	MCI0597678.1	2762014	g69236	i0	96.2	0.886363636363636	26	1	29.5	0	80	3	1	26	MCI0597678.1 30S ribosomal protein S20 [Candidatus Parcubacteria bacterium]	diamond	234	48.5	1	Bacteria	Bacteria candidate phyla	Candidatus Parcubacteria	Candidatus Parcubacteria bacterium
32308579	32308579	PRJNA939415_P_NODE_33499_length_310_cov_2.586498_g33077_i0	PRJNA939415	33499	310	2.586498	8.0181438	Bacteria	2	Bacteria	Bacteria	80.5	3.21e-16	NR	KND51664.1	1659195	g33077	i0	83.7	3.31935483870968	49	8	47.4	0	163	309	17	65	KND51664.1 MAG: translation elongation factor Ts [Parcubacteria bacterium C7867-001]	diamond	1029	81.3	0.990159901599016	Bacteria	Bacteria candidate phyla	Candidatus Parcubacteria	Parcubacteria bacterium C7867-001

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