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

6 rows where bioproject = "PRJNA675042", 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_clade	tax_kingdom	tax_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
7025567	7025567	PRJNA675042_P_NODE_3626_length_714_cov_6.207488_g3216_i0	PRJNA675042	3626	714	6.207488	44.32146432	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	329	2.95e-85	NTclustered	gi\|2874253788\|emb\|OY969772.1\|	1672391	g3216	i0	81.03	32.8935574229692	427	70	90	10	62	482	861072	861493	MAG: uncultured Chloroflexia bacterium isolate MFD02416.bin.2.42 genome assembly, chromosome: 1	blastn	23486	329	1	Bacteria		Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
18498222	18498222	PRJNA675042_P_NODE_116575_length_250_cov_0.870056_g116125_i0	PRJNA675042	116575	250	0.870056	2.17514	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	52.8	0.023	NTclustered	gi\|2874253788\|emb\|OY969772.1\|	1672391	g116125	i0	100	0.112	28	0	11	0	22	49	4055604	4055577	MAG: uncultured Chloroflexia bacterium isolate MFD02416.bin.2.42 genome assembly, chromosome: 1	blastn	28	52.8	1	Bacteria		Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
19774033	19774033	PRJNA675042_P_NODE_53936_length_317_cov_2.864754_g53486_i0	PRJNA675042	53936	317	2.864754	9.08127018	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	167	1.02e-36	NTclustered	gi\|2874253882\|emb\|OY969938.1\|	1672391	g53486	i0	87.248	24.2996845425867	149	16	47	1	42	190	2065108	2065253	MAG: uncultured Chloroflexia bacterium isolate MFD02416.bin.c.1 genome assembly, chromosome: 1	blastn	7703	167	1	Bacteria		Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
23599810	23599810	PRJNA675042_P_NODE_43419_length_336_cov_8.600760_g42969_i0	PRJNA675042	43419	336	8.60076	28.8985536	Candidatus Roseilinea sp.	2838777	Bacteria	Bacteria	265	3.74e-66	NTclustered	gi\|2314722916\|dbj\|AP024676.1\|	2838777	g42969	i0	84.043	28.1220238095238	282	37	82	8	50	326	3496145	3495867	MAG: Candidatus Roseilinea sp. KatS3mg053 DNA, complete genome	blastn	9449	265	1	Bacteria	Candidatus Thermofonsia Clade 3	Bacillati	Chloroflexota	Candidatus Thermofontia			Candidatus Roseilinea	Candidatus Roseilinea sp.
30492690	30492690	PRJNA675042_P_NODE_6713_length_569_cov_2.018145_g6275_i0	PRJNA675042	6713	569	2.018145	11.48324505	Anaerolineales bacterium	2073117	Bacteria	Bacteria	187	3.67e-57	NR	MBV6395674.1	2073117	g6275	i0	50.9	0.880492091388401	167	82	88	0	51	551	7	173	MBV6395674.1 hypothetical protein [Anaerolineales bacterium]	diamond	501	187	1	Bacteria		Bacillati	Chloroflexota	Anaerolineae	Anaerolineales			Anaerolineales bacterium
31061554	31061554	PRJNA675042_P_NODE_138995_length_247_cov_0.885057_g138545_i0	PRJNA675042	138995	247	0.885057	2.18609079	Ktedonobacteraceae bacterium	2740538	Bacteria	Bacteria	42.4	0.0237	NR	HTK05689.1	2740538	g138545	i0	36.5	0.631578947368421	52	33	63.2	0	170	15	68	119	HTK05689.1 hypothetical protein [Ktedonobacteraceae bacterium]	diamond	156	42.4	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);;