metadata: contig_metadata: 7 rows where bioproject = "PRJNA643700", tax_kingdom = "Bacillati" and tax

7 rows where bioproject = "PRJNA643700", 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
25385055	25385055	PRJNA643700_P_NODE_325920_length_197_cov_1.040541_g324364_i0	PRJNA643700	325920	197	1.040541	2.04986577	Chloroflexota	200795	Bacteria	Bacteria	130	7.66e-26	NTclustered	gi\|470482680\|ref\|NR_076546.1\|	65	g324364	i0	79.126	88.6040609137056	206	30	100	11	1	197	2139	2340	Herpetosiphon aurantiacus strain DSM 785 23S ribosomal RNA gene, complete sequence	blastn	17455	130	1	Bacteria		Bacillati	Chloroflexota	Chloroflexia	Herpetosiphonales	Herpetosiphonaceae	Herpetosiphon	Herpetosiphon aurantiacus
29228869	29228869	PRJNA643700_P_NODE_172489_length_306_cov_1.214008_g170933_i0	PRJNA643700	172489	306	1.214008	3.71486448	Chloroflexota bacterium	2026724	Bacteria	Bacteria	45.4	0.00261	NR	MEC9308483.1	2026724	g170933	i0	34.6	0.509803921568627	52	34	51	0	190	35	75	126	MEC9308483.1 hypothetical protein [Chloroflexota bacterium]	diamond	156	45.4	1	Bacteria		Bacillati	Chloroflexota					Chloroflexota bacterium
30030467	30030467	PRJNA643700_P_NODE_376231_length_173_cov_1.693548_g374675_i0	PRJNA643700	376231	173	1.693548	2.92983804	Chloroflexota	200795	Bacteria	Bacteria	41.2	0.0489	NR	MBU6361097.1	2026724	g374675	i0	38.6	3.46820809248555	44	27	76.3	0	39	170	79	122	MBU6361097.1 SCO1664 family protein [Chloroflexota bacterium]	diamond	600	41.6	0.990384615384615	Bacteria		Bacillati	Chloroflexota					Chloroflexota bacterium
30271081	30271081	PRJNA643700_P_NODE_406792_length_165_cov_1.543103_g405236_i0	PRJNA643700	406792	165	1.543103	2.54611995	Chloroflexota bacterium	2026724	Bacteria	Bacteria	42.7	0.0134	NR	MBI2912431.1	2026724	g405236	i0	50	1.6	30	15	54.5	0	67	156	314	343	MBI2912431.1 GNAT family N-acetyltransferase [Chloroflexota bacterium]	diamond	264	42.7	1	Bacteria		Bacillati	Chloroflexota					Chloroflexota bacterium
30535862	30535862	PRJNA643700_P_NODE_289253_length_215_cov_3.132530_g287697_i0	PRJNA643700	289253	215	3.13253	6.7349395	Bacteria	2	Bacteria	Bacteria	40.4	0.0301	NR	PKB64400.1	1926611	g287697	i0	36	1.3953488372093	50	32	69.8	0	188	39	3	52	PKB64400.1 MAG: hypothetical protein BZY80_03130 [SAR202 cluster bacterium Io17-Chloro-G2]	diamond	300	40.4	1	Bacteria	SAR202 cluster	Bacillati	Chloroflexota	Dehalococcoidia				SAR202 cluster bacterium Io17-Chloro-G2
31218328	31218328	PRJNA643700_P_NODE_255335_length_236_cov_1.358289_g253779_i0	PRJNA643700	255335	236	1.358289	3.20556204	Chloroflexota bacterium	2026724	Bacteria	Bacteria	43.9	0.0128	NR	HEY3083733.1	2026724	g253779	i0	48.8	0.546610169491525	43	20	53.4	2	102	227	292	333	HEY3083733.1 galactose-1-phosphate uridylyltransferase [Chloroflexota bacterium]	diamond	129	43.9	1	Bacteria		Bacillati	Chloroflexota					Chloroflexota bacterium
31377001	31377001	PRJNA643700_P_NODE_84396_length_455_cov_5.894089_g82847_i0	PRJNA643700	84396	455	5.894089	26.81810495	Anaerolineales bacterium	2073117	Bacteria	Bacteria	45.1	0.046	NR	MFN2303732.1	2073117	g82847	i0	44.4	0.356043956043956	54	30	35.6	0	266	105	69	122	MFN2303732.1 hypothetical protein [Anaerolineales bacterium]	diamond	162	45.1	1	Bacteria		Bacillati	Chloroflexota	Anaerolineae	Anaerolineales			Anaerolineales 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);;