metadata: contig_metadata: 5 rows where bioproject = "PRJNA564013", tax_clade = "FCB group" and tax

5 rows where bioproject = "PRJNA564013", tax_clade = "FCB group" and tax_phylum = "Ignavibacteriota"

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_family	tax_species
30237234	30237234	PRJNA564013_P_NODE_173652_length_330_cov_9.959108_g170802_i0	PRJNA564013	173652	330	9.959108	32.8650564	Ignavibacteriales bacterium	2049428	Bacteria	Bacteria	176	9.05e-51	NR	HOP49167.1	2049428	g170802	i0	95.7	0.836363636363636	92	4	83.6	0	46	321	1	92	HOP49167.1 radical SAM protein [Ignavibacteriales bacterium]	diamond	276	176	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota	Ignavibacteria	Ignavibacteriales		Ignavibacteriales bacterium
30995598	30995598	PRJNA564013_P_NODE_45494_length_581_cov_1.632692_g42753_i0	PRJNA564013	45494	581	1.632692	9.48594052	Ignavibacteriaceae bacterium	2651163	Bacteria	Bacteria	216	4.24e-61	NR	MDR3666736.1	2651163	g42753	i0	58	0.996557659208262	193	76	98.6	3	578	6	882	1071	MDR3666736.1 hypothetical protein [Ignavibacteriaceae bacterium]	diamond	579	216	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota	Ignavibacteria	Ignavibacteriales	Ignavibacteriaceae	Ignavibacteriaceae bacterium
31027316	31027316	PRJNA564013_P_NODE_91755_length_425_cov_10.112637_g88922_i0	PRJNA564013	91755	425	10.112637	42.97870725	Ignavibacteriaceae bacterium	2651163	Bacteria	Bacteria	142	5.3999999999999995e-36	NR	MDR3666736.1	2651163	g88922	i0	64.9	0.804705882352941	114	40	80.5	0	11	352	1171	1284	MDR3666736.1 hypothetical protein [Ignavibacteriaceae bacterium]	diamond	342	142	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota	Ignavibacteria	Ignavibacteriales	Ignavibacteriaceae	Ignavibacteriaceae bacterium
32021302	32021302	PRJNA564013_P_NODE_272978_length_243_cov_24.868132_g270126_i0	PRJNA564013	272978	243	24.868132	60.42956076	root	1	Root_unresolved	Root_unresolved	84	6.59e-17	NR	MCU7525651.1	2053306	g270126	i0	64.6	7.25925925925926	65	20	80.2	1	218	24	98	159	MCU7525651.1 phage portal protein [Ignavibacteria bacterium]	diamond	1764	84.3	0.99644128113879	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota	Ignavibacteria			Ignavibacteria bacterium
32671295	32671295	PRJNA564013_P_NODE_182240_length_323_cov_1.416031_g179390_i0	PRJNA564013	182240	323	1.416031	4.57378013	Ignavibacteriota bacterium	2026749	Bacteria	Bacteria	175	1.2799999999999999e-52	NR	MCP5063728.1	2026749	g179390	i0	80	2.78637770897833	100	20	92.9	0	8	307	79	178	MCP5063728.1 hypothetical protein [Ignavibacteriota bacterium]	diamond	900	175	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota				Ignavibacteriota 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);;