metadata: contig_metadata: 5 rows where bioproject = "PRJNA561138", tax_kingdom = "Bacillati" and tax

5 rows where bioproject = "PRJNA561138", tax_kingdom = "Bacillati" and tax_phylum = "Chloroflexota"

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_kingdom	tax_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
5648815	5648815	PRJNA561138_P_NODE_15605_length_332_cov_1.486486_g15410_i0	PRJNA561138	15605	332	1.486486	4.93513352	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	217	1.05e-51	NTclustered	gi\|2874253725\|emb\|OY969567.1\|	1672391	g15410	i0	78.824	103.978915662651	340	58	100	13	1	332	684044	683711	MAG: uncultured Chloroflexia bacterium isolate MFD01561.bin.c.1 genome assembly, chromosome: 1	blastn	34521	217	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
27900141	27900141	PRJNA561138_P_NODE_12465_length_369_cov_1.253378_g12270_i0	PRJNA561138	12465	369	1.253378	4.62496482	Anaerolineaceae bacterium	2024896	Bacteria	Bacteria	65.1	6.13e-10	NR	MFA7407682.1	2024896	g12270	i0	41.7	0.585365853658537	72	41	57.7	1	2	214	135	206	MFA7407682.1 hypothetical protein [Anaerolineaceae bacterium]	diamond	216	65.1	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae	Anaerolineales	Anaerolineaceae		Anaerolineaceae bacterium
29131890	29131890	PRJNA561138_P_NODE_25529_length_249_cov_1.312500_g25334_i0	PRJNA561138	25529	249	1.3125	3.268125	Chloroflexota bacterium	2026724	Bacteria	Bacteria	96.3	5.91e-21	NR	MCP4415138.1	2026724	g25334	i0	65.9	0.987951807228916	82	28	98.8	0	248	3	1236	1317	MCP4415138.1 SDR family NAD(P)-dependent oxidoreductase [Chloroflexota bacterium]	diamond	246	96.3	1	Bacteria	Bacillati	Chloroflexota					Chloroflexota bacterium
31627631	31627631	PRJNA561138_P_NODE_10136_length_402_cov_1.395137_g9941_i0	PRJNA561138	10136	402	1.395137	5.60845074	Ktedonobacterales bacterium	2306968	Bacteria	Bacteria	65.5	1.96e-9	NR	HEX6817957.1	2306968	g9941	i0	56.9	2.55970149253731	58	25	43.3	0	217	390	1	58	HEX6817957.1 RNA ligase (ATP) [Ktedonobacterales bacterium]	diamond	1029	65.5	1	Bacteria	Bacillati	Chloroflexota	Ktedonobacteria	Ktedonobacterales			Ktedonobacterales bacterium
32450526	32450526	PRJNA561138_P_NODE_21959_length_273_cov_1.260000_g21764_i0	PRJNA561138	21959	273	1.26	3.4398	Ktedonosporobacter rubrisoli	2509675	Bacteria	Bacteria	42.7	0.0411	NR	WP_129888025.1	2509675	g21764	i0	41.3	0.505494505494505	46	25	50.5	1	101	238	93	136	WP_129888025.1 GNAT family N-acetyltransferase [Ktedonosporobacter rubrisoli]	diamond	138	42.7	1	Bacteria	Bacillati	Chloroflexota	Ktedonobacteria	Ktedonobacterales	Ktedonosporobacteraceae	Ktedonosporobacter	Ktedonosporobacter rubrisoli

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