metadata: contig_metadata: 8 rows where bioproject = "PRJNA382357", tax_clade = "Bacteria candidate phyla" and tax

8 rows where bioproject = "PRJNA382357", 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
26599980	26599980	PRJNA382357_P_NODE_53141_length_319_cov_6.031008_g52402_i0	PRJNA382357	53141	319	6.031008	19.23891552	Candidatus Parcubacteria bacterium	2762014	Bacteria	Bacteria	88.6	3.46e-19	NR	RMD61733.1	2762014	g52402	i0	58	0.827586206896552	88	28	75.2	2	3	242	120	206	RMD61733.1 MAG: hypothetical protein D6833_07845, partial [Candidatus Parcubacteria bacterium]	diamond	264	88.6	1	Bacteria	Bacteria candidate phyla	Candidatus Parcubacteria	Candidatus Parcubacteria bacterium
26948383	26948383	PRJNA382357_P_NODE_139562_length_209_cov_0.878378_g138823_i0	PRJNA382357	139562	209	0.878378	1.83581002	Candidatus Parcubacteria bacterium	2762014	Bacteria	Bacteria	61.2	7e-9	NR	MEN9552220.1	2762014	g138823	i0	80	1.11961722488038	35	7	50.2	0	207	103	85	119	MEN9552220.1 hypothetical protein [Candidatus Parcubacteria bacterium]	diamond	234	61.2	1	Bacteria	Bacteria candidate phyla	Candidatus Parcubacteria	Candidatus Parcubacteria bacterium
27422952	27422952	PRJNA382357_P_NODE_15543_length_548_cov_4.271047_g14817_i0	PRJNA382357	15543	548	4.271047	23.40533756	Candidatus Parcubacteria bacterium	2762014	Bacteria	Bacteria	70.9	2.19e-11	NR	RMD61733.1	2762014	g14817	i0	51	0.569343065693431	104	41	52	4	160	444	1	103	RMD61733.1 MAG: hypothetical protein D6833_07845, partial [Candidatus Parcubacteria bacterium]	diamond	312	70.9	1	Bacteria	Bacteria candidate phyla	Candidatus Parcubacteria	Candidatus Parcubacteria bacterium
27485939	27485939	PRJNA382357_P_NODE_71943_length_279_cov_12.811927_g71204_i0	PRJNA382357	71943	279	12.811927	35.74527633	Candidatus Parcubacteria bacterium	2762014	Bacteria	Bacteria	97.4	8.990000000000001e-22	NR	RMD61734.1	2762014	g71204	i0	69.9	0.78494623655914	73	22	78.5	0	10	228	104	176	RMD61734.1 MAG: N4-gp56 family major capsid protein [Candidatus Parcubacteria bacterium]	diamond	219	97.4	1	Bacteria	Bacteria candidate phyla	Candidatus Parcubacteria	Candidatus Parcubacteria bacterium
27738829	27738829	PRJNA382357_P_NODE_61244_length_300_cov_1.209205_g60505_i0	PRJNA382357	61244	300	1.209205	3.627615	Candidatus Parcubacteria bacterium	2762014	Bacteria	Bacteria	83.6	2.42e-16	NR	RMD61670.1	2762014	g60505	i0	75	0.56	56	12	56	1	240	73	190	243	RMD61670.1 MAG: site-specific DNA-methyltransferase, partial [Candidatus Parcubacteria bacterium]	diamond	168	83.6	1	Bacteria	Bacteria candidate phyla	Candidatus Parcubacteria	Candidatus Parcubacteria bacterium
28085715	28085715	PRJNA382357_P_NODE_48605_length_332_cov_56.848708_g47866_i0	PRJNA382357	48605	332	56.848708	188.73771056	Candidatus Parcubacteria bacterium	2762014	Bacteria	Bacteria	44.3	0.0269	NR	RMD61734.1	2762014	g47866	i0	100	0.180722891566265	20	0	18.1	0	208	149	326	345	RMD61734.1 MAG: N4-gp56 family major capsid protein [Candidatus Parcubacteria bacterium]	diamond	60	44.3	1	Bacteria	Bacteria candidate phyla	Candidatus Parcubacteria	Candidatus Parcubacteria bacterium
30169730	30169730	PRJNA382357_P_NODE_55452_length_313_cov_37.777778_g54713_i0	PRJNA382357	55452	313	37.777778	118.24444514	Candidatus Parcubacteria bacterium	2762014	Bacteria	Bacteria	49.7	3.17e-4	NR	NCN08044.1	2762014	g54713	i0	48.2	0.536741214057508	56	25	49.8	1	4	159	553	608	NCN08044.1 hypothetical protein [Candidatus Parcubacteria bacterium]	diamond	168	49.7	1	Bacteria	Bacteria candidate phyla	Candidatus Parcubacteria	Candidatus Parcubacteria bacterium
30296739	30296739	PRJNA382357_P_NODE_65152_length_292_cov_1.748918_g64413_i0	PRJNA382357	65152	292	1.748918	5.10684056	Candidatus Parcubacteria bacterium	2762014	Bacteria	Bacteria	91.7	1.65e-19	NR	MEN9880904.1	2762014	g64413	i0	48.5	1.03767123287671	101	46	98.6	4	4	291	33	132	MEN9880904.1 hypothetical protein [Candidatus Parcubacteria bacterium]	diamond	303	91.7	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);;