metadata: contig_metadata: 13 rows where bioproject = "PRJNA812001", tax_kingdom = "Bacillati" and tax

13 rows where bioproject = "PRJNA812001", 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_species
23762871	23762871	PRJNA812001_P_NODE_129239_length_242_cov_0.911243_g128993_i0	PRJNA812001	129239	242	0.911243	2.20520806	Candidatus Limnocylindrales bacterium	2952938	Bacteria	Bacteria	149	4.12e-42	NR	HEU0235319.1	2952938	g128993	i0	88.8	0.991735537190083	80	9	99.2	0	241	2	183	262	HEU0235319.1 glycosyltransferase [Candidatus Limnocylindrales bacterium]	diamond	240	149	1	Bacteria	Bacillati	Chloroflexota	Candidatus Limnocylindria	Candidatus Limnocylindrales		Candidatus Limnocylindrales bacterium
26674100	26674100	PRJNA812001_P_NODE_4801_length_706_cov_8.612954_g4567_i0	PRJNA812001	4801	706	8.612954	60.80745524	Chloroflexota bacterium	2026724	Bacteria	Bacteria	117	1.2599999999999998e-29	NR	HCF99586.1	2026724	g4567	i0	52.7	0.386685552407932	91	41	37.8	1	101	367	10	100	HCF99586.1 hypothetical protein [Chloroflexota bacterium]	diamond	273	117	1	Bacteria	Bacillati	Chloroflexota				Chloroflexota bacterium
26801026	26801026	PRJNA812001_P_NODE_8121_length_545_cov_2.012712_g7876_i0	PRJNA812001	8121	545	2.012712	10.9692804	Chloroflexota bacterium	2026724	Bacteria	Bacteria	163	5.2999999999999994e-46	NR	HUM70551.1	2026724	g7876	i0	52	1.65688073394495	152	73	83.7	0	75	530	18	169	HUM70551.1 mechanosensitive ion channel [Chloroflexota bacterium]	diamond	903	163	1	Bacteria	Bacillati	Chloroflexota				Chloroflexota bacterium
27243921	27243921	PRJNA812001_P_NODE_97403_length_248_cov_0.880000_g97157_i0	PRJNA812001	97403	248	0.88	2.1824	Chloroflexota bacterium	2026724	Bacteria	Bacteria	147	4e-39	NR	MFN8622296.1	2026724	g97157	i0	84.1	0.991935483870968	82	13	99.2	0	3	248	128	209	MFN8622296.1 phage holin family protein [Chloroflexota bacterium]	diamond	246	147	1	Bacteria	Bacillati	Chloroflexota				Chloroflexota bacterium
27568506	27568506	PRJNA812001_P_NODE_2064_length_1045_cov_10.765432_g1878_i0	PRJNA812001	2064	1045	10.765432	112.4987644	Chloroflexota	200795	Bacteria	Bacteria	382	5.909999999999999e-126	NR	MEZ4644498.1	2026724	g1878	i0	71.4	3.00861244019139	262	75	75.2	0	791	6	1	262	MEZ4644498.1 ABC-F family ATP-binding cassette domain-containing protein [Chloroflexota bacterium]	diamond	3144	382	1	Bacteria	Bacillati	Chloroflexota				Chloroflexota bacterium
27884319	27884319	PRJNA812001_P_NODE_46345_length_296_cov_1.381166_g46099_i0	PRJNA812001	46345	296	1.381166	4.08825136	Candidatus Hadersleviella	3140594	Bacteria	Bacteria	119	1.67e-30	NR	MEK6220982.1	2026724	g46099	i0	63.2	4.81418918918919	95	35	96.3	0	2	286	109	203	MEK6220982.1 mechanosensitive ion channel [Chloroflexota bacterium]	diamond	1425	119	1	Bacteria	Bacillati	Chloroflexota				Chloroflexota bacterium
27915769	27915769	PRJNA812001_P_NODE_84125_length_250_cov_0.870056_g83879_i0	PRJNA812001	84125	250	0.870056	2.17514	PVC group	1783257	Bacteria	Bacteria	150	6.7e-40	NR	HKZ87327.1	2052143	g83879	i0	85.4	2.952	82	12	98.4	0	248	3	697	778	HKZ87327.1 fructose 1,6-bisphosphatase [Anaerolineae bacterium]	diamond	738	151	0.993377483443709	Bacteria	Bacillati	Chloroflexota	Anaerolineae			Anaerolineae bacterium
28064980	28064980	PRJNA812001_P_NODE_70025_length_262_cov_1.158730_g69779_i0	PRJNA812001	70025	262	1.15873	3.0358726	Dehalococcoidia bacterium	2026734	Bacteria	Bacteria	63.9	1.55e-9	NR	MEX0800812.1	2026734	g69779	i0	40	0.973282442748092	85	50	96.2	1	3	254	50	134	MEX0800812.1 right-handed parallel beta-helix repeat-containing protein [Dehalococcoidia bacterium]	diamond	255	63.9	1	Bacteria	Bacillati	Chloroflexota	Dehalococcoidia			Dehalococcoidia bacterium
28191069	28191069	PRJNA812001_P_NODE_7726_length_557_cov_3.907025_g7481_i0	PRJNA812001	7726	557	3.907025	21.76212925	Dehalococcoidales bacterium	2026733	Bacteria	Bacteria	80.1	9.76e-16	NR	MDD4986684.1	2026733	g7481	i0	46.4	1.10412926391382	110	46	58.2	4	155	478	14	112	MDD4986684.1 hypothetical protein [Dehalococcoidales bacterium]	diamond	615	80.1	1	Bacteria	Bacillati	Chloroflexota	Dehalococcoidia	Dehalococcoidales		Dehalococcoidales bacterium
29327882	29327882	PRJNA812001_P_NODE_7609_length_562_cov_2.523517_g7364_i0	PRJNA812001	7609	562	2.523517	14.18216554	Ardenticatenaceae bacterium	2614247	Bacteria	Bacteria	143	8.98e-38	NR	HEX8683168.1	2614247	g7364	i0	73.4	0.501779359430605	94	25	50.2	0	344	63	260	353	HEX8683168.1 tryptophan--tRNA ligase [Ardenticatenaceae bacterium]	diamond	282	143	1	Bacteria	Bacillati	Chloroflexota	Ardenticatenia	Ardenticatenales	Ardenticatenaceae	Ardenticatenaceae bacterium
29778745	29778745	PRJNA812001_P_NODE_6611_length_602_cov_5.353497_g6367_i0	PRJNA812001	6611	602	5.353497	32.22805194	Bacteria	2	Bacteria	Bacteria	67.8	1.95e-9	NR	MEW5940205.1	2026724	g6367	i0	38.2	2.62126245847176	89	49	43.4	3	264	4	1	85	MEW5940205.1 creatininase family protein [Chloroflexota bacterium]	diamond	1578	68.2	0.994134897360704	Bacteria	Bacillati	Chloroflexota				Chloroflexota bacterium
31982352	31982352	PRJNA812001_P_NODE_54158_length_283_cov_1.600000_g53912_i0	PRJNA812001	54158	283	1.6	4.528	Dehalococcoidia bacterium	2026734	Bacteria	Bacteria	42.4	0.0299	NR	HJM88493.1	2026734	g53912	i0	30.1	0.985865724381625	93	57	96.5	3	3	275	12	98	HJM88493.1 hypothetical protein [Dehalococcoidia bacterium]	diamond	279	42.4	1	Bacteria	Bacillati	Chloroflexota	Dehalococcoidia			Dehalococcoidia bacterium
32709414	32709414	PRJNA812001_P_NODE_107840_length_246_cov_0.890173_g107594_i0	PRJNA812001	107840	246	0.890173	2.18982558	Chloroflexia bacterium	2448782	Bacteria	Bacteria	72.4	1.31e-12	NR	HYP42219.1	2448782	g107594	i0	47.4	0.926829268292683	76	37	92.7	1	229	2	257	329	HYP42219.1 HD domain-containing phosphohydrolase [Chloroflexia bacterium]	diamond	228	72.4	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia			Chloroflexia 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);;