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

5 rows where analysis = "diamond", bioproject = "PRJNA1113956" and tax_clade = "Bacteria candidate phyla"

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
27352700	27352700	PRJNA1113956_P_NODE_2943_length_1076_cov_11.752742_g2717_i0	PRJNA1113956	2943	1076	11.752742	126.45950392	Patescibacteria group bacterium	2052139	Bacteria	Bacteria	48.9	0.0273	NR	MBP8689035.1	2052139	g2717	i0	23.7	0.482342007434944	173	124	48	4	273	788	128	293	MBP8689035.1 PEGA domain-containing protein [Patescibacteria group bacterium]	diamond	519	48.9	1	Bacteria	Bacteria candidate phyla		Patescibacteria group bacterium
31585178	31585178	PRJNA1113956_P_NODE_22656_length_241_cov_1.071429_g22316_i0	PRJNA1113956	22656	241	1.071429	2.58214389	Patescibacteria group bacterium	2052139	Bacteria	Bacteria	75.9	5.02e-14	NR	MCX7778890.1	2052139	g22316	i0	57.1	5.12863070539419	63	27	78.4	0	219	31	185	247	MCX7778890.1 peptide chain release factor 1 [Patescibacteria group bacterium]	diamond	1236	75.9	1	Bacteria	Bacteria candidate phyla		Patescibacteria group bacterium
31806384	31806384	PRJNA1113956_P_NODE_3137_length_1035_cov_10.410603_g2900_i0	PRJNA1113956	3137	1035	10.410603	107.74974105	Patescibacteria group bacterium	2052139	Bacteria	Bacteria	51.2	0.0046	NR	MBP8689035.1	2052139	g2900	i0	25	0.498550724637681	172	121	49.6	5	801	289	129	293	MBP8689035.1 PEGA domain-containing protein [Patescibacteria group bacterium]	diamond	516	51.2	1	Bacteria	Bacteria candidate phyla		Patescibacteria group bacterium
32312910	32312910	PRJNA1113956_P_NODE_20119_length_250_cov_0.870056_g19779_i0	PRJNA1113956	20119	250	0.870056	2.17514	Candidatus Saccharibacteria bacterium 49-2	1895829	Bacteria	Bacteria	127	1.85e-34	NR	OJU87484.1	1895829	g19779	i0	82.5	1.944	80	14	96	0	1	240	125	204	OJU87484.1 MAG: hypothetical protein BGO17_00590 [Candidatus Saccharibacteria bacterium 49-20]	diamond	486	127	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharibacteria bacterium 49-20
32786010	32786010	PRJNA1113956_P_NODE_22120_length_243_cov_0.905882_g21780_i0	PRJNA1113956	22120	243	0.905882	2.20129326	Candidatus Chisholmbacteria bacterium RIFCSPLOWO2_	2750073	Bacteria	Bacteria	45.1	0.00575	NR	OGY21556.1	1797593	g21780	i0	46.8	0.580246913580247	47	25	58	0	162	22	434	480	OGY21556.1 MAG: hypothetical protein A3A65_05550 [Candidatus Chisholmbacteria bacterium RIFCSPLOWO2_01_FULL_49_14]	diamond	141	45.1	1	Bacteria	Bacteria candidate phyla	Candidatus Chisholmiibacteriota	Candidatus Chisholmbacteria bacterium RIFCSPLOWO2_01_FULL_49_14

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