metadata: contig_metadata: 6 rows where bioproject = "PRJNA944406", tax_clade = "Bacteria candidate phyla" and tax

6 rows where bioproject = "PRJNA944406", 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
27720845	27720845	PRJNA944406_P_NODE_92184_length_245_cov_0.895349_g91225_i0	PRJNA944406	92184	245	0.895349	2.19360505	Parcubacteria bacterium C7867-	2762014	Bacteria	Bacteria	72	1.84e-12	NR	KND51068.1	1659201	g91225	i0	86.8	0.46530612244898	38	5	46.5	0	244	131	590	627	KND51068.1 MAG: phenylalanyl-tRNA synthetase beta chain [Parcubacteria bacterium C7867-007]	diamond	114	72	1	Bacteria	Bacteria candidate phyla	Candidatus Parcubacteria	Parcubacteria bacterium C7867-007
29804154	29804154	PRJNA944406_P_NODE_82631_length_247_cov_0.885057_g81672_i0	PRJNA944406	82631	247	0.885057	2.18609079	Candidatus Parcubacteria bacterium	2762014	Bacteria	Bacteria	87.4	7.11e-18	NR	RMD63071.1	2762014	g81672	i0	51.9	2.95141700404858	81	35	98.4	1	3	245	343	419	RMD63071.1 MAG: hypothetical protein D6833_06050, partial [Candidatus Parcubacteria bacterium]	diamond	729	87.4	1	Bacteria	Bacteria candidate phyla	Candidatus Parcubacteria	Candidatus Parcubacteria bacterium
31289090	31289090	PRJNA944406_P_NODE_111315_length_236_cov_2.288344_g110356_i0	PRJNA944406	111315	236	2.288344	5.40049184	Candidatus Parcubacteria bacterium	2762014	Bacteria	Bacteria	107	4.01e-25	NR	MEN9921318.1	2762014	g110356	i0	69.1	0.864406779661017	68	21	86.4	0	33	236	290	357	MEN9921318.1 Deoxyribodipyrimidine photolyase [Candidatus Parcubacteria bacterium]	diamond	204	107	1	Bacteria	Bacteria candidate phyla	Candidatus Parcubacteria	Candidatus Parcubacteria bacterium
31605599	31605599	PRJNA944406_P_NODE_31836_length_280_cov_1.487923_g30877_i0	PRJNA944406	31836	280	1.487923	4.1661844	Candidatus Parcubacteria bacterium	2762014	Bacteria	Bacteria	156	8.259999999999998e-42	NR	MEN9920299.1	2762014	g30877	i0	78.5	1.98214285714286	93	20	99.6	0	280	2	1453	1545	MEN9920299.1 hypothetical protein [Candidatus Parcubacteria bacterium]	diamond	555	156	1	Bacteria	Bacteria candidate phyla	Candidatus Parcubacteria	Candidatus Parcubacteria bacterium
32143370	32143370	PRJNA944406_P_NODE_32258_length_280_cov_1.212560_g31299_i0	PRJNA944406	32258	280	1.21256	3.395168	Candidatus Parcubacteria bacterium	2762014	Bacteria	Bacteria	72.8	1.54e-12	NR	MBC7981626.1	2762014	g31299	i0	46.2	0.996428571428571	93	42	95.4	3	3	269	378	466	MBC7981626.1 peptidoglycan-binding protein [Candidatus Parcubacteria bacterium]	diamond	279	72.8	1	Bacteria	Bacteria candidate phyla	Candidatus Parcubacteria	Candidatus Parcubacteria bacterium
32869606	32869606	PRJNA944406_P_NODE_95740_length_244_cov_0.900585_g94781_i0	PRJNA944406	95740	244	0.900585	2.1974274	Candidatus Parcubacteria bacterium	2762014	Bacteria	Bacteria	128	1.29e-33	NR	MEN9920425.1	2762014	g94781	i0	73.8	0.983606557377049	80	21	98.4	0	3	242	160	239	MEN9920425.1 hypothetical protein [Candidatus Parcubacteria bacterium]	diamond	240	128	1	Bacteria	Bacteria candidate phyla	Candidatus Parcubacteria	Candidatus Parcubacteria 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);;