metadata: contig_metadata: 4 rows where bioproject = "PRJNA453567" and tax

4 rows where bioproject = "PRJNA453567" and tax_phylum = "Lentisphaerota"

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_kingdom	tax_phylum	tax_class	tax_order	tax_species
26632951	26632951	PRJNA453567_P_NODE_27681_length_166_cov_2.077519_g27444_i0	PRJNA453567	27681	166	2.077519	3.44868154	Lentisphaerae bacterium RIFOXYA12_64_32	1798577	Bacteria	Bacteria	42	0.0243	NR	OGV74555.1	1798577	g27444	i0	48.1	0.939759036144578	52	27	94	0	9	164	257	308	OGV74555.1 MAG: hypothetical protein A3K18_15525 [Lentisphaerae bacterium RIFOXYA12_64_32]	diamond	156	42	1	Bacteria	PVC group	Pseudomonadati	Lentisphaerota			Lentisphaerae bacterium RIFOXYA12_64_32
26917938	26917938	PRJNA453567_P_NODE_27442_length_167_cov_1.500000_g27205_i0	PRJNA453567	27442	167	1.5	2.505	Victivallales bacterium	2212475	Bacteria	Bacteria	73.9	4.41e-14	NR	MBP5638526.1	2212475	g27205	i0	69.1	3.95209580838323	55	17	98.8	0	3	167	138	192	MBP5638526.1 3-methyl-2-oxobutanoate hydroxymethyltransferase [Victivallales bacterium]	diamond	660	73.9	1	Bacteria	PVC group	Pseudomonadati	Lentisphaerota	Lentisphaeria	Victivallales	Victivallales bacterium
29128979	29128979	PRJNA453567_P_NODE_10469_length_290_cov_2.063241_g10232_i0	PRJNA453567	10469	290	2.063241	5.9833989	Lentisphaerales bacterium	2448604	Bacteria	Bacteria	43.9	0.0207	NR	MCH2204714.1	2448604	g10232	i0	39.3	0.631034482758621	61	35	61	1	207	31	165	225	MCH2204714.1 RDD family protein [Lentisphaerales bacterium]	diamond	183	43.9	1	Bacteria	PVC group	Pseudomonadati	Lentisphaerota	Lentisphaeria	Lentisphaerales	Lentisphaerales bacterium
30218619	30218619	PRJNA453567_P_NODE_14112_length_242_cov_1.843902_g13875_i0	PRJNA453567	14112	242	1.843902	4.46224284	PVC group	1783257	Bacteria	Bacteria	54.7	2.13e-6	NR	RMD78462.1	1932692	g13875	i0	57.8	4.67355371900826	45	17	53.3	1	228	100	238	282	RMD78462.1 MAG: hypothetical protein D6820_09905, partial [Lentisphaerota bacterium]	diamond	1131	55.1	0.992740471869329	Bacteria	PVC group	Pseudomonadati	Lentisphaerota			Lentisphaerota 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);;