metadata: contig_metadata: 11 rows where analysis = "diamond", bioproject = "PRJNA577226" and tax

11 rows where analysis = "diamond", bioproject = "PRJNA577226" 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_species
22239398	22239398	PRJNA577226_S_NODE_5438_length_598_cov_3.007130_g4530_i0	PRJNA577226	5438	598	3.00713	17.9826374	Dehalococcoidales bacterium	2026733	Bacteria	Bacteria	194	1.8e-54	NR	MEE9366989.1	2026733	g4530	i0	45.2	2.0819397993311	208	104	99.3	2	3	596	446	653	MEE9366989.1 DNA polymerase [Dehalococcoidales bacterium]	diamond	1245	194	1	Bacteria	Bacillati	Chloroflexota	Dehalococcoidia	Dehalococcoidales		Dehalococcoidales bacterium
27048028	27048028	PRJNA577226_S_NODE_17042_length_310_cov_3.476190_g16103_i0	PRJNA577226	17042	310	3.47619	10.776189	Anaerolineaceae bacterium	2024896	Bacteria	Bacteria	73.2	1.62e-13	NR	MFA7407862.1	2024896	g16103	i0	36.8	0.919354838709677	95	60	91.9	0	307	23	62	156	MFA7407862.1 nucleoside 2-deoxyribosyltransferase domain-containing protein [Anaerolineaceae bacterium]	diamond	285	73.2	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae	Anaerolineales	Anaerolineaceae	Anaerolineaceae bacterium
27093131	27093131	PRJNA577226_S_NODE_50582_length_175_cov_2.666667_g49643_i0	PRJNA577226	50582	175	2.666667	4.66666725	root	1	Root_unresolved	Root_unresolved	47.8	2.46e-4	NR	MBW3633016.1	2026724	g49643	i0	39.7	1.98857142857143	58	35	99.4	0	174	1	51	108	MBW3633016.1 SIMPL domain-containing protein [Chloroflexota bacterium]	diamond	348	47.8	1	Bacteria	Bacillati	Chloroflexota				Chloroflexota bacterium
27364415	27364415	PRJNA577226_S_NODE_40843_length_194_cov_4.184713_g39904_i0	PRJNA577226	40843	194	4.184713	8.11834322	Chloroflexota bacterium	2026724	Bacteria	Bacteria	42	0.0359	NR	MER3405008.1	2026724	g39904	i0	42.9	1.29896907216495	42	24	64.9	0	39	164	56	97	MER3405008.1 phytanoyl-CoA dioxygenase [Chloroflexota bacterium]	diamond	252	42	1	Bacteria	Bacillati	Chloroflexota				Chloroflexota bacterium
27837546	27837546	PRJNA577226_S_NODE_34944_length_211_cov_1.344828_g34005_i0	PRJNA577226	34944	211	1.344828	2.83758708	Ktedonobacteraceae bacterium	2740538	Bacteria	Bacteria	48.1	2.93e-4	NR	HET6903157.1	2740538	g34005	i0	47.1	1.62085308056872	51	24	72.5	1	163	11	207	254	HET6903157.1 LysR family transcriptional regulator [Ktedonobacteraceae bacterium]	diamond	342	48.1	1	Bacteria	Bacillati	Chloroflexota	Ktedonobacteria	Ktedonobacterales	Ktedonobacteraceae	Ktedonobacteraceae bacterium
28387943	28387943	PRJNA577226_S_NODE_71706_length_150_cov_1.646018_g70767_i0	PRJNA577226	71706	150	1.646018	2.469027	Bacteria	2	Bacteria	Bacteria	43.9	0.00419	NR	MXX32523.1	2026724	g70767	i0	52.6	5.04	38	18	76	0	1	114	147	184	MXX32523.1 ATP-binding protein [Chloroflexota bacterium]	diamond	756	44.3	0.99097065462754	Bacteria	Bacillati	Chloroflexota				Chloroflexota bacterium
28406096	28406096	PRJNA577226_S_NODE_14026_length_345_cov_3.584416_g13087_i0	PRJNA577226	14026	345	3.584416	12.3662352	Chloroflexota bacterium	2026724	Bacteria	Bacteria	75.1	8.68e-14	NR	MYE45147.1	2026724	g13087	i0	42.5	0.982608695652174	113	54	98.3	4	345	7	7	108	MYE45147.1 DUF1768 domain-containing protein [Chloroflexota bacterium]	diamond	339	75.1	1	Bacteria	Bacillati	Chloroflexota				Chloroflexota bacterium
28595692	28595692	PRJNA577226_S_NODE_58807_length_163_cov_5.785714_g57868_i0	PRJNA577226	58807	163	5.785714	9.43071382	Anaerolineales bacterium	2073117	Bacteria	Bacteria	43.9	0.0048	NR	HET9588558.1	2073117	g57868	i0	52.6	2.28220858895706	38	18	69.9	0	144	31	139	176	HET9588558.1 ABC-2 family transporter protein [Anaerolineales bacterium]	diamond	372	43.9	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae	Anaerolineales		Anaerolineales bacterium
28627303	28627303	PRJNA577226_S_NODE_35427_length_209_cov_2.250000_g34488_i0	PRJNA577226	35427	209	2.25	4.7025	Anaerolineae bacterium	2052143	Bacteria	Bacteria	103	4.75e-25	NR	MBZ0293954.1	2052143	g34488	i0	71	1.98086124401914	69	20	99	0	208	2	24	92	MBZ0293954.1 class I SAM-dependent methyltransferase [Anaerolineae bacterium]	diamond	414	103	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae			Anaerolineae bacterium
29700222	29700222	PRJNA577226_S_NODE_50430_length_176_cov_1.122302_g49491_i0	PRJNA577226	50430	176	1.122302	1.97525152	Chloroflexia bacterium	2448782	Bacteria	Bacteria	116	1.94e-28	NR	MFL5735281.1	2448782	g49491	i0	93.1	9.88636363636364	58	4	98.9	0	174	1	185	242	MFL5735281.1 beta-glucosidase BglX [Chloroflexia bacterium]	diamond	1740	116	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia			Chloroflexia bacterium
30111186	30111186	PRJNA577226_S_NODE_2952_length_926_cov_2.538808_g2153_i0	PRJNA577226	2952	926	2.538808	23.50936208	Candidatus Limnocylindrales bacterium	2952938	Bacteria	Bacteria	108	3.44e-24	NR	HEY8135192.1	2952938	g2153	i0	41.6	1.47408207343413	161	79	51.8	4	924	445	62	208	HEY8135192.1 SIMPL domain-containing protein [Candidatus Limnocylindrales bacterium]	diamond	1365	108	1	Bacteria	Bacillati	Chloroflexota	Candidatus Limnocylindria	Candidatus Limnocylindrales		Candidatus Limnocylindrales 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);;