metadata: contig_metadata: 5 rows where analysis = "diamond", bioproject = "PRJNA1160211" and tax

5 rows where analysis = "diamond", bioproject = "PRJNA1160211" and tax_phylum = "Candidatus Altimarinota"

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
4137162	4137162	PRJNA1160211_S_NODE_287504_length_235_cov_3.604938_g286271_i0	PRJNA1160211	287504	235	3.604938	8.4716043	Candidatus Gracilibacteria bacterium GN	2044595	Bacteria	Bacteria	144	1.97e-41	NR	RAL56550.1	1914866	g286271	i0	98.6	0.94468085106383	74	1	94.5	0	2	223	41	114	RAL56550.1 ATP-dependent Clp protease proteolytic subunit [Candidatus Gracilibacteria bacterium GN02-873]	diamond	222	144	1	Bacteria	Bacteria candidate phyla	Candidatus Altimarinota	Candidatus Gracilibacteria bacterium GN02-873
28417955	28417955	PRJNA1160211_S_NODE_108746_length_441_cov_2.076087_g107518_i0	PRJNA1160211	108746	441	2.076087	9.15554367	Bacteria	2	Bacteria	Bacteria	182	1.79e-50	NR	MCH8518297.1	2044595	g107518	i0	67.9	11.6598639455782	134	40	91.2	2	3	404	429	559	MCH8518297.1 DEAD/DEAH box helicase family protein [Candidatus Altimarinota bacterium]	diamond	5142	183	0.994535519125683	Bacteria	Bacteria candidate phyla	Candidatus Altimarinota	Candidatus Altimarinota bacterium
29629499	29629499	PRJNA1160211_S_NODE_84510_length_488_cov_67.865060_g83291_i0	PRJNA1160211	84510	488	67.86506	331.1814928	Candidatus Altimarinota bacterium	2044595	Bacteria	Bacteria	129	3.2099999999999996e-31	NR	RKW24136.1	2044595	g83291	i0	100	0.418032786885246	68	0	41.8	0	101	304	709	776	RKW24136.1 MAG: DUF5011 domain-containing protein [Candidatus Altimarinota bacterium]	diamond	204	129	1	Bacteria	Bacteria candidate phyla	Candidatus Altimarinota	Candidatus Altimarinota bacterium
30545964	30545964	PRJNA1160211_S_NODE_80413_length_497_cov_11.655660_g79196_i0	PRJNA1160211	80413	497	11.65566	57.9286302	Candidatus Altimarinota bacterium	2044595	Bacteria	Bacteria	140	7.199999999999999e-38	NR	MBP7806433.1	2044595	g79196	i0	57.6	0.796780684104628	132	56	79.7	0	474	79	15	146	MBP7806433.1 hypothetical protein [Candidatus Altimarinota bacterium]	diamond	396	140	1	Bacteria	Bacteria candidate phyla	Candidatus Altimarinota	Candidatus Altimarinota bacterium
30956886	30956886	PRJNA1160211_S_NODE_75934_length_507_cov_21.481567_g74720_i0	PRJNA1160211	75934	507	21.481567	108.91154469	Candidatus Altimarinota bacterium	2044595	Bacteria	Bacteria	218	1.05e-63	NR	MFN7160311.1	2044595	g74720	i0	75.2	1.63905325443787	137	34	81.1	0	493	83	62	198	MFN7160311.1 ATP-binding cassette domain-containing protein [Candidatus Altimarinota bacterium]	diamond	831	218	1	Bacteria	Bacteria candidate phyla	Candidatus Altimarinota	Candidatus Altimarinota 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);;