metadata: contig_metadata: 5 rows where bioproject = "PRJNA734348", tax_clade = "Bacteria candidate phyla" and tax

5 rows where bioproject = "PRJNA734348", 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
26957335	26957335	PRJNA734348_P_NODE_117102_length_245_cov_0.895349_g116404_i0	PRJNA734348	117102	245	0.895349	2.19360505	Parcubacteria bacterium C7867-	2762014	Bacteria	Bacteria	99	5.47e-23	NR	KND51318.1	1659195	g116404	i0	90.4	0.636734693877551	52	5	63.7	0	168	13	1	52	KND51318.1 MAG: ribosomal protein L2 [Parcubacteria bacterium C7867-001]	diamond	156	99	1	Bacteria	Bacteria candidate phyla	Candidatus Parcubacteria	Parcubacteria bacterium C7867-001
27779112	27779112	PRJNA734348_P_NODE_121744_length_244_cov_0.900585_g121046_i0	PRJNA734348	121744	244	0.900585	2.1974274	Candidatus Parcubacteria bacterium	2762014	Bacteria	Bacteria	108	3.32e-25	NR	MEN9649533.1	2762014	g121046	i0	64.6	0.971311475409836	79	28	97.1	0	7	243	453	531	MEN9649533.1 hypothetical protein [Candidatus Parcubacteria bacterium]	diamond	237	108	1	Bacteria	Bacteria candidate phyla	Candidatus Parcubacteria	Candidatus Parcubacteria bacterium
30305676	30305676	PRJNA734348_P_NODE_117492_length_245_cov_0.895349_g116794_i0	PRJNA734348	117492	245	0.895349	2.19360505	Candidatus Parcubacteria bacterium	2762014	Bacteria	Bacteria	119	1.23e-30	NR	MEN9328360.1	2762014	g116794	i0	78.9	0.930612244897959	76	15	93.1	1	5	232	5	79	MEN9328360.1 hypothetical protein [Candidatus Parcubacteria bacterium]	diamond	228	119	1	Bacteria	Bacteria candidate phyla	Candidatus Parcubacteria	Candidatus Parcubacteria bacterium
30779177	30779177	PRJNA734348_P_NODE_80094_length_260_cov_2.834225_g79396_i0	PRJNA734348	80094	260	2.834225	7.368985	Candidatus Parcubacteria bacterium	2762014	Bacteria	Bacteria	52.8	1.34e-5	NR	MEN9390119.1	2762014	g79396	i0	36.9	0.969230769230769	84	42	84.2	3	235	17	246	329	MEN9390119.1 hypothetical protein [Candidatus Parcubacteria bacterium]	diamond	252	52.8	1	Bacteria	Bacteria candidate phyla	Candidatus Parcubacteria	Candidatus Parcubacteria bacterium
31864119	31864119	PRJNA734348_P_NODE_94117_length_251_cov_0.865169_g93419_i0	PRJNA734348	94117	251	0.865169	2.17157419	Bacteria	2	Bacteria	Bacteria	86.3	1.06e-18	NR	NCN52484.1	2762014	g93419	i0	50	2.73705179282869	78	39	93.2	0	18	251	95	172	NCN52484.1 2'-5' RNA ligase family protein [Candidatus Parcubacteria bacterium]	diamond	687	87	0.991954022988506	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);;