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

5 rows where analysis = "diamond", bioproject = "PRJNA724039" 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
24937651	24937651	PRJNA724039_S_NODE_17760_length_151_cov_4.008772_g17553_i0	PRJNA724039	17760	151	4.008772	6.05324572	Chloroflexota bacterium	2026724	Bacteria	Bacteria	70.9	7.2e-13	NR	HEY8286704.1	2026724	g17553	i0	67.3	2.9205298013245	49	14	93.4	1	149	9	71	119	HEY8286704.1 methyltransferase domain-containing protein [Chloroflexota bacterium]	diamond	441	70.9	1	Bacteria	Bacillati	Chloroflexota					Chloroflexota bacterium
29451872	29451872	PRJNA724039_S_NODE_11510_length_190_cov_1.470588_g11303_i0	PRJNA724039	11510	190	1.470588	2.7941172	Candidatus Chloroploca asiatica	1506545	Bacteria	Bacteria	44.3	0.00538	NR	WP_172451194.1	1506545	g11303	i0	46.8	0.742105263157895	47	25	74.2	0	141	1	596	642	WP_172451194.1 diguanylate cyclase [Candidatus Chloroploca asiatica]	diamond	141	44.3	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia	Chloroflexales	Oscillochloridaceae	Candidatus Chloroploca	Candidatus Chloroploca asiatica
29641312	29641312	PRJNA724039_S_NODE_16910_length_155_cov_1.915254_g16703_i0	PRJNA724039	16910	155	1.915254	2.9686437	Ktedonobacterales bacterium	2306968	Bacteria	Bacteria	57.8	5.52e-8	NR	HEX8997723.1	2306968	g16703	i0	55.1	0.948387096774194	49	21	94.8	1	8	154	364	411	HEX8997723.1 NADH-quinone oxidoreductase subunit N [Ktedonobacterales bacterium]	diamond	147	57.8	1	Bacteria	Bacillati	Chloroflexota	Ktedonobacteria	Ktedonobacterales			Ktedonobacterales bacterium
30305458	30305458	PRJNA724039_S_NODE_12452_length_182_cov_1.586207_g12245_i0	PRJNA724039	12452	182	1.586207	2.88689674	Anaerolineales bacterium	2073117	Bacteria	Bacteria	42.4	0.0233	NR	MCB9436685.1	2073117	g12245	i0	41.9	1.02197802197802	62	31	95.6	2	177	4	154	214	MCB9436685.1 DUF11 domain-containing protein [Anaerolineales bacterium]	diamond	186	42.4	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae	Anaerolineales			Anaerolineales bacterium
30557529	30557529	PRJNA724039_S_NODE_15553_length_162_cov_1.224000_g15346_i0	PRJNA724039	15553	162	1.224	1.98288	Anaerolineae bacterium	2052143	Bacteria	Bacteria	47	1.18e-4	NR	MCW5848612.1	2052143	g15346	i0	47.2	0.981481481481482	53	28	98.1	0	159	1	66	118	MCW5848612.1 profilin [Anaerolineae bacterium]	diamond	159	47	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae				Anaerolineae 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);;