metadata: contig_metadata: 11 rows where bioproject = "PRJNA312615", tax_kingdom = "Bacillati" and tax

11 rows where bioproject = "PRJNA312615", 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
2339384	2339384	PRJNA312615_P_NODE_53302_length_166_cov_0.863248_g53151_i0	PRJNA312615	53302	166	0.863248	1.43299168	Bacteria	2	Bacteria	Bacteria	84.2	4.93e-12	NTclustered	gi\|2108129769\|gb\|CP070729.1\|	2026734	g53151	i0	90.625	3.80120481927711	64	4	38	2	20	82	944341	944279	MAG: Dehalococcoidia bacterium isolate bin423 chromosome	blastn	631	84.2	1	Bacteria	Bacillati	Chloroflexota	Dehalococcoidia				Dehalococcoidia bacterium
16366343	16366343	PRJNA312615_P_NODE_30133_length_223_cov_1.149425_g29982_i0	PRJNA312615	30133	223	1.149425	2.56321775	Dehalococcoidia bacterium	2026734	Bacteria	Bacteria	92.4	7.49e-20	NR	MCH2658239.1	2026734	g29982	i0	55.4	3.88789237668161	74	32	98.2	1	3	221	111	184	MCH2658239.1 DEAD/DEAH box helicase [Dehalococcoidia bacterium]	diamond	867	92.4	1	Bacteria	Bacillati	Chloroflexota	Dehalococcoidia				Dehalococcoidia bacterium
22740450	22740450	PRJNA312615_P_NODE_1158_length_940_cov_1.722783_g1055_i0	PRJNA312615	1158	940	1.722783	16.1941602	Anaerolineae bacterium	2052143	Bacteria	Bacteria	106	3.8600000000000003e-22	NR	MCU0466058.1	2052143	g1055	i0	32.2	1.53510638297872	236	145	74.4	5	712	14	2	225	MCU0466058.1 DUF917 domain-containing protein [Anaerolineae bacterium]	diamond	1443	106	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae				Anaerolineae bacterium
27516636	27516636	PRJNA312615_P_NODE_20703_length_268_cov_0.931507_g20552_i0	PRJNA312615	20703	268	0.931507	2.49643876	Dehalococcoidales bacterium	2026733	Bacteria	Bacteria	42	0.045	NR	MDO9333650.1	2026733	g20552	i0	36.5	0.828358208955224	74	42	81.7	3	240	22	74	143	MDO9333650.1 hypothetical protein [Dehalococcoidales bacterium]	diamond	222	42	1	Bacteria	Bacillati	Chloroflexota	Dehalococcoidia	Dehalococcoidales			Dehalococcoidales bacterium
28148245	28148245	PRJNA312615_P_NODE_27485_length_233_cov_1.402174_g27334_i0	PRJNA312615	27485	233	1.402174	3.26706542	Caldilineae bacterium	2420332	Bacteria	Bacteria	45.1	0.00494	NR	RME54287.1	2420332	g27334	i0	47.5	0.759656652360515	59	22	64.4	2	42	191	63	121	RME54287.1 MAG: glycogen debranching protein, partial [Caldilineae bacterium]	diamond	177	45.1	1	Bacteria	Bacillati	Chloroflexota	Caldilineae				Caldilineae bacterium
29127176	29127176	PRJNA312615_P_NODE_14749_length_320_cov_1.129151_g14598_i0	PRJNA312615	14749	320	1.129151	3.6132832	Dehalococcoidales bacterium	2026733	Bacteria	Bacteria	55.5	3.08e-6	NR	MDO9332954.1	2026733	g14598	i0	32.1	0.99375	106	65	93.8	3	17	316	359	463	MDO9332954.1 hypothetical protein [Dehalococcoidales bacterium]	diamond	318	55.5	1	Bacteria	Bacillati	Chloroflexota	Dehalococcoidia	Dehalococcoidales			Dehalococcoidales bacterium
29221816	29221816	PRJNA312615_P_NODE_28829_length_228_cov_1.139665_g28678_i0	PRJNA312615	28829	228	1.139665	2.5984362	Dehalococcoidales bacterium	2026733	Bacteria	Bacteria	147	9.38e-41	NR	MDO9333446.1	2026733	g28678	i0	90.7	0.986842105263158	75	7	98.7	0	3	227	80	154	MDO9333446.1 biotin/lipoyl-containing protein [Dehalococcoidales bacterium]	diamond	225	147	1	Bacteria	Bacillati	Chloroflexota	Dehalococcoidia	Dehalococcoidales			Dehalococcoidales bacterium
29459894	29459894	PRJNA312615_P_NODE_14410_length_323_cov_4.262774_g14259_i0	PRJNA312615	14410	323	4.262774	13.76876002	root	1	Root_unresolved	Root_unresolved	46.2	0.00597	NR	MFA5379264.1	2026734	g14259	i0	30.5	4.09597523219814	105	48	85.4	3	301	26	1728	1820	MFA5379264.1 PKD domain-containing protein [Dehalococcoidia bacterium]	diamond	1323	46.2	1	Bacteria	Bacillati	Chloroflexota	Dehalococcoidia				Dehalococcoidia bacterium
29694914	29694914	PRJNA312615_P_NODE_9810_length_395_cov_2.930636_g9660_i0	PRJNA312615	9810	395	2.930636	11.5760122	Chloroflexi bacterium CFX4	2293709	Bacteria	Bacteria	52	1.8e-5	NR	MCE7946516.1	2293709	g9660	i0	48.3	0.440506329113924	58	27	44.1	1	391	218	65	119	MCE7946516.1 hypothetical protein [Chloroflexi bacterium CFX4]	diamond	174	52	1	Bacteria	Bacillati	Chloroflexota					Chloroflexi bacterium CFX4
31514223	31514223	PRJNA312615_P_NODE_37776_length_200_cov_1.013245_g37625_i0	PRJNA312615	37776	200	1.013245	2.02649	Aggregatilinea	2806306	Bacteria	Bacteria	63.9	7.11e-10	NR	WP_119065806.1	913108	g37625	i0	56.5	2.475	62	27	93	0	1	186	483	544	WP_119065806.1 insulinase family protein [Aggregatilinea lenta]	diamond	495	63.9	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae	Aggregatilineales	Aggregatilineaceae	Aggregatilinea	Aggregatilinea lenta
32494874	32494874	PRJNA312615_P_NODE_41239_length_191_cov_0.957746_g41088_i0	PRJNA312615	41239	191	0.957746	1.82929486	root	1	Root_unresolved	Root_unresolved	55.8	4.35e-7	NR	MYE27109.1	2026724	g41088	i0	69.7	10.9633507853403	33	10	51.8	0	73	171	3	35	MYE27109.1 DnaJ domain-containing protein [Chloroflexota bacterium]	diamond	2094	55.8	1	Bacteria	Bacillati	Chloroflexota					Chloroflexota 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);;