metadata: contig_metadata: 6 rows where analysis = "diamond", bioproject = "PRJEB7799" and tax

6 rows where analysis = "diamond", bioproject = "PRJEB7799" 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
32947589	32947589	PRJEB7799l_S_NODE_13834_length_154_cov_0.991597_g13805_i0	PRJEB7799	13834	154	0.991597	1.52705938	Chloroflexota bacterium	2026724	Bacteria	Bacteria	80.1	7.48e-16	NR	MEK7216931.1	2026724	g13805	i0	66.7	0.993506493506494	51	17	99.4	0	153	1	261	311	MEK7216931.1 SNF2-related protein [Chloroflexota bacterium]	diamond	153	80.1	1	Bacteria	Bacillati	Chloroflexota					Chloroflexota bacterium
32957655	32957655	PRJEB7799p_S_NODE_23578_length_156_cov_1.983471_g23555_i0	PRJEB7799	23578	156	1.983471	3.09421476	Bacteria	2	Bacteria	Bacteria	43.1	0.00353	NR	HIB35690.1	2026734	g23555	i0	52.6	8.80769230769231	38	18	73.1	0	156	43	91	128	HIB35690.1 30S ribosomal protein S13 [Dehalococcoidia bacterium]	diamond	1374	43.5	0.990804597701149	Bacteria	Bacillati	Chloroflexota	Dehalococcoidia				Dehalococcoidia bacterium
32965390	32965390	PRJEB7799p_S_NODE_9682_length_194_cov_2.408805_g9659_i0	PRJEB7799	9682	194	2.408805	4.6730817	Herpetosiphon sp.	71864	Bacteria	Bacteria	107	9.17e-26	NR	WP_012189631.1	71864	g9659	i0	79.7	2.96907216494845	64	13	99	0	194	3	186	249	WP_012189631.1 diaminobutyrate--2-oxoglutarate transaminase [Herpetosiphon sp.]	diamond	576	107	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia	Herpetosiphonales	Herpetosiphonaceae	Herpetosiphon	Herpetosiphon sp.
32974694	32974694	PRJEB7799i_S_NODE_1066_length_448_cov_2.786925_g1036_i0	PRJEB7799	1066	448	2.786925	12.485424	PVC group	1783257	Bacteria	Bacteria	107	1.26e-23	NR	MCY3567538.1	2026724	g1036	i0	40.9	2.53794642857143	127	74	84.4	1	416	39	1099	1225	MCY3567538.1 AAA domain-containing protein [Chloroflexota bacterium]	diamond	1137	107	1	Bacteria	Bacillati	Chloroflexota					Chloroflexota bacterium
33066688	33066688	PRJEB7799i_S_NODE_10741_length_154_cov_2.184874_g10711_i0	PRJEB7799	10741	154	2.184874	3.36470596	Chloroflexota bacterium	2026724	Bacteria	Bacteria	76.6	6.2e-15	NR	MFC2041930.1	2026724	g10711	i0	82.6	1.81168831168831	46	8	89.6	0	14	151	109	154	MFC2041930.1 DNA adenine methylase [Chloroflexota bacterium]	diamond	279	76.6	1	Bacteria	Bacillati	Chloroflexota					Chloroflexota bacterium
33162171	33162171	PRJEB7799i_S_NODE_3928_length_232_cov_1.477157_g3898_i0	PRJEB7799	3928	232	1.477157	3.42700424	Bacteria	2	Bacteria	Bacteria	58.2	1.17e-7	NR	MEI8334807.1	2026724	g3898	i0	48.7	3.45258620689655	76	34	98.3	1	5	232	167	237	MEI8334807.1 IS1182 family transposase [Chloroflexota bacterium]	diamond	801	58.2	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);;