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

6 rows where bioproject = "PRJNA1129273", 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
1557825	1557825	PRJNA1129273_P_NODE_11122_length_227_cov_4.357143_g10842_i0	PRJNA1129273	11122	227	4.357143	9.89071461	Dehalococcoidia bacterium	2026734	Bacteria	Bacteria	161	3.22e-35	NTclustered	gi\|2626233621\|emb\|OY820591.1\|	2026734	g10842	i0	81.592	116.11013215859	201	31	87	5	28	225	2075667	2075470	MAG: Dehalococcoidia bacterium isolate bad7acc4-ca48-4abb-846f-85865ba1c961 genome assembly, chromosome: 1	blastn	26357	161	1	Bacteria	Bacillati	Chloroflexota	Dehalococcoidia				Dehalococcoidia bacterium
11761894	11761894	PRJNA1129273_P_NODE_8330_length_254_cov_1.690608_g8050_i0	PRJNA1129273	8330	254	1.6906080000000001	4.29414432	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	418	1.9699999999999995e-112	NTclustered	gi\|2874254102\|emb\|OY970185.1\|	1672391	g8050	i0	97.934	618.767716535433	242	3	95	2	10	251	1859208	1859447	MAG: uncultured Chloroflexia bacterium isolate MFD06435.bin.c.3 genome assembly, chromosome: 1	blastn	157167	418	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
19409188	19409188	PRJNA1129273_P_NODE_8976_length_249_cov_2.232955_g8696_i0	PRJNA1129273	8976	249	2.232955	5.56005795	Chloroflexota bacterium	2026724	Bacteria	Bacteria	164	1.61e-50	NR	MDQ3705110.1	2026724	g8696	i0	98.8	0.987951807228916	82	1	98.8	0	247	2	22	103	MDQ3705110.1 MFS transporter [Chloroflexota bacterium]	diamond	246	164	1	Bacteria	Bacillati	Chloroflexota					Chloroflexota bacterium
20158077	20158077	PRJNA1129273_P_NODE_1596_length_647_cov_4.027875_g1332_i0	PRJNA1129273	1596	647	4.027875	26.06035125	Roseiflexus	120961	Bacteria	Bacteria	339	4.41e-88	NTclustered	gi\|470482403\|ref\|NR_076530.1\|	120962	g1332	i0	77.383	129.119010819165	619	108	94	26	37	646	639	44	Roseiflexus castenholzii strain HLO8 23S ribosomal RNA gene, complete sequence	blastn	83540	339	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia	Chloroflexales	Roseiflexaceae	Roseiflexus	Roseiflexus castenholzii
28681109	28681109	PRJNA1129273_P_NODE_6287_length_284_cov_1.459716_g6007_i0	PRJNA1129273	6287	284	1.459716	4.14559344	Ardenticatenaceae bacterium	2614247	Bacteria	Bacteria	161	5.79e-49	NR	MCB9430965.1	2614247	g6007	i0	84.8	0.971830985915493	92	14	97.2	0	276	1	1	92	MCB9430965.1 profilin [Ardenticatenaceae bacterium]	diamond	276	161	1	Bacteria	Bacillati	Chloroflexota	Ardenticatenia	Ardenticatenales	Ardenticatenaceae		Ardenticatenaceae bacterium
29817443	29817443	PRJNA1129273_P_NODE_6011_length_288_cov_2.153488_g5731_i0	PRJNA1129273	6011	288	2.153488	6.20204544	Ktedonobacteraceae bacterium	2740538	Bacteria	Bacteria	123	2.97e-31	NR	MBO0781359.1	2740538	g5731	i0	60.6	0.979166666666667	94	37	97.9	0	287	6	88	181	MBO0781359.1 MFS transporter [Ktedonobacteraceae bacterium]	diamond	282	123	1	Bacteria	Bacillati	Chloroflexota	Ktedonobacteria	Ktedonobacterales	Ktedonobacteraceae		Ktedonobacteraceae 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);;