metadata: contig_metadata: 6 rows where bioproject = "PRJEB12237", tax_kingdom = "Bacillati" and tax

6 rows where bioproject = "PRJEB12237", 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
10223426	10223426	PRJEB12237_P_NODE_2209_length_476_cov_2.174603_g2018_i0	PRJEB12237	2209	476	2.174603	10.35111028	Cyanobacteriota/Melainabacteria group	1798711	Bacteria	Bacteria	76.3	1.01e-12	NR	MBM3150775.1	2026724	g2018	i0	46.5	4.58193277310924	86	42	54.2	1	467	210	1829	1910	MBM3150775.1 PAS domain S-box protein [Chloroflexota bacterium]	diamond	2181	76.6	0.996083550913838	Bacteria	Bacillati	Chloroflexota					Chloroflexota bacterium
28012366	28012366	PRJEB12237_P_NODE_7945_length_196_cov_1.739130_g7749_i0	PRJEB12237	7945	196	1.73913	3.4086948	Chloroflexota bacterium	2026724	Bacteria	Bacteria	40	0.0339	NR	HEX2037133.1	2026724	g7749	i0	75	0.306122448979592	20	5	30.6	0	122	63	55	74	HEX2037133.1 hypothetical protein [Chloroflexota bacterium]	diamond	60	40	1	Bacteria	Bacillati	Chloroflexota					Chloroflexota bacterium
28170046	28170046	PRJEB12237_P_NODE_6786_length_219_cov_1.945652_g6590_i0	PRJEB12237	6786	219	1.945652	4.26097788	Dehalococcoidales bacterium	2026733	Bacteria	Bacteria	135	8.079999999999999e-37	NR	MDO9333728.1	2026733	g6590	i0	86.1	0.986301369863014	72	10	98.6	0	218	3	168	239	MDO9333728.1 actin, cytoplasmic 2 [Dehalococcoidales bacterium]	diamond	216	135	1	Bacteria	Bacillati	Chloroflexota	Dehalococcoidia	Dehalococcoidales			Dehalococcoidales bacterium
28738399	28738399	PRJEB12237_P_NODE_6527_length_225_cov_1.842105_g6331_i0	PRJEB12237	6527	225	1.842105	4.14473625	Anaerolineae bacterium	2052143	Bacteria	Bacteria	50.1	1.64e-5	NR	MCW5848612.1	2052143	g6331	i0	57.4	0.626666666666667	47	20	62.7	0	23	163	78	124	MCW5848612.1 profilin [Anaerolineae bacterium]	diamond	141	50.1	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae				Anaerolineae bacterium
29995252	29995252	PRJEB12237_P_NODE_2551_length_440_cov_1.970370_g2355_i0	PRJEB12237	2551	440	1.97037	8.669628	Bacteria	2	Bacteria	Bacteria	144	3.73e-39	NR	MBQ6509321.1	2017390	g2355	i0	50.7	7.94318181818182	144	54	98.2	2	434	3	58	184	MBQ6509321.1 ROK family protein [Flexilinea sp.]	diamond	3495	144	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae	Anaerolineales	Anaerolineaceae	Flexilinea	Flexilinea sp.
30311553	30311553	PRJEB12237_P_NODE_9372_length_176_cov_1.418440_g9176_i0	PRJEB12237	9372	176	1.41844	2.4964544	Bacteria	2	Bacteria	Bacteria	102	7.91e-24	NR	WP_298982923.1	435295	g9176	i0	86.2	13.8409090909091	58	8	98.9	0	3	176	147	204	WP_298982923.1 sodium-translocating pyrophosphatase, partial [uncultured Caldilinea sp.]	diamond	2436	103	0.990291262135922	Bacteria	Bacillati	Chloroflexota	Caldilineae	Caldilineales	Caldilineaceae	Caldilinea	uncultured Caldilinea sp.

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