metadata: contig_metadata: 12 rows where bioproject = "PRJNA1186363", tax_kingdom = "Bacillati" and tax

12 rows where bioproject = "PRJNA1186363", 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
23994119	23994119	PRJNA1186363_P_NODE_21079_length_409_cov_1.601190_g20191_i0	PRJNA1186363	21079	409	1.60119	6.5488671	root	1	Root_unresolved	Root_unresolved	52.8	0.039	NTclustered	gi\|2518551077\|emb\|OX638330.1\|	543031	g20191	i0	100	0.136919315403423	28	0	7	0	157	184	1898903	1898930	MAG: uncultured Caldilineaceae bacterium isolate 76db5b8c-001f-43e6-88b1-0bf759d03ef1 genome assembly, chromosome: 1	blastn	56	52.8	1	Bacteria	Bacillati	Chloroflexota	Caldilineae	Caldilineales	Caldilineaceae	uncultured Caldilineaceae bacterium
26648050	26648050	PRJNA1186363_P_NODE_28281_length_332_cov_0.899614_g27393_i0	PRJNA1186363	28281	332	0.899614	2.98671848	Bacillati	1783272	Bacteria	Bacteria	83.6	7.84e-17	NR	MBO9368882.1	2026724	g27393	i0	45.9	1.96987951807229	109	49	98.5	3	327	1	55	153	MBO9368882.1 spherulation-specific family 4 protein [Chloroflexota bacterium]	diamond	654	83.6	1	Bacteria	Bacillati	Chloroflexota				Chloroflexota bacterium
27008880	27008880	PRJNA1186363_P_NODE_25482_length_358_cov_2.712281_g24594_i0	PRJNA1186363	25482	358	2.712281	9.70996598	Ardenticatenaceae bacterium	2614247	Bacteria	Bacteria	199	1.26e-63	NR	MCB9430965.1	2614247	g24594	i0	86	0.955307262569832	114	16	95.5	0	15	356	1	114	MCB9430965.1 profilin [Ardenticatenaceae bacterium]	diamond	342	199	1	Bacteria	Bacillati	Chloroflexota	Ardenticatenia	Ardenticatenales	Ardenticatenaceae	Ardenticatenaceae bacterium
27420233	27420233	PRJNA1186363_P_NODE_42323_length_245_cov_0.906977_g41435_i0	PRJNA1186363	42323	245	0.906977	2.22209365	Anaerolineae bacterium	2052143	Bacteria	Bacteria	99	6.29e-22	NR	HLF26568.1	2052143	g41435	i0	56.8	10.1387755102041	81	33	99.2	1	243	1	420	498	HLF26568.1 penicillin acylase family protein [Anaerolineae bacterium]	diamond	2484	99	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae			Anaerolineae bacterium
27723562	27723562	PRJNA1186363_P_NODE_26004_length_353_cov_1.357143_g25116_i0	PRJNA1186363	26004	353	1.357143	4.79071479	Bacteria	2	Bacteria	Bacteria	98.6	8.419999999999999e-24	NR	MBE0408147.1	2073117	g25116	i0	60.6	2.75354107648725	66	26	56.1	0	154	351	4	69	MBE0408147.1 Mth938-like domain-containing protein [Anaerolineales bacterium]	diamond	972	99.4	0.991951710261569	Bacteria	Bacillati	Chloroflexota	Anaerolineae	Anaerolineales		Anaerolineales bacterium
28101899	28101899	PRJNA1186363_P_NODE_16145_length_487_cov_2.830918_g15258_i0	PRJNA1186363	16145	487	2.830918	13.78657066	Bacteria	2	Bacteria	Bacteria	60.5	2.53e-7	NR	MEM9777186.1	2026724	g15258	i0	46.9	0.788501026694045	64	32	39.4	1	192	1	73	134	MEM9777186.1 hypothetical protein [Chloroflexota bacterium]	diamond	384	60.8	0.995065789473684	Bacteria	Bacillati	Chloroflexota				Chloroflexota bacterium
28683077	28683077	PRJNA1186363_P_NODE_25287_length_360_cov_3.289199_g24399_i0	PRJNA1186363	25287	360	3.289199	11.8411164	Dehalococcoidia bacterium	2026734	Bacteria	Bacteria	45.8	0.0108	NR	MDO8617119.1	2026734	g24399	i0	35.2	0.591666666666667	71	44	57.5	1	43	249	246	316	MDO8617119.1 MFS transporter [Dehalococcoidia bacterium]	diamond	213	45.8	1	Bacteria	Bacillati	Chloroflexota	Dehalococcoidia			Dehalococcoidia bacterium
29125243	29125243	PRJNA1186363_P_NODE_28289_length_332_cov_0.806950_g27401_i0	PRJNA1186363	28289	332	0.80695	2.679074	Anaerolineae bacterium	2052143	Bacteria	Bacteria	67	2.42e-10	NR	MBN1427840.1	2052143	g27401	i0	45.3	1.69879518072289	64	34	57.8	1	292	101	91	153	MBN1427840.1 serine/threonine protein kinase [Anaerolineae bacterium]	diamond	564	67	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae			Anaerolineae bacterium
29156737	29156737	PRJNA1186363_P_NODE_22329_length_393_cov_1.950000_g21441_i0	PRJNA1186363	22329	393	1.95	7.6635	Ardenticatenaceae bacterium	2614247	Bacteria	Bacteria	227	2.25e-74	NR	MCB9430965.1	2614247	g21441	i0	88.1	0.961832061068702	126	15	96.2	0	7	384	1	126	MCB9430965.1 profilin [Ardenticatenaceae bacterium]	diamond	378	227	1	Bacteria	Bacillati	Chloroflexota	Ardenticatenia	Ardenticatenales	Ardenticatenaceae	Ardenticatenaceae bacterium
29459455	29459455	PRJNA1186363_P_NODE_3770_length_1073_cov_2.075000_g3227_i0	PRJNA1186363	3770	1073	2.075	22.26475	Bacteria	2	Bacteria	Bacteria	242	3.1e-73	NR	MCB9454316.1	2024896	g3227	i0	46.9	6.13420316868593	275	125	76.6	5	252	1073	6	260	MCB9454316.1 N-methyl-L-tryptophan oxidase [Anaerolineaceae bacterium]	diamond	6582	244	0.991803278688525	Bacteria	Bacillati	Chloroflexota	Anaerolineae	Anaerolineales	Anaerolineaceae	Anaerolineaceae bacterium
30293887	30293887	PRJNA1186363_P_NODE_44072_length_229_cov_2.500000_g43184_i0	PRJNA1186363	44072	229	2.5	5.725	Chloroflexota bacterium	2026724	Bacteria	Bacteria	48.5	2.6e-4	NR	HFC08405.1	2026724	g43184	i0	46.5	0.563318777292576	43	23	56.3	0	3	131	268	310	HFC08405.1 D-glycerate dehydrogenase [Chloroflexota bacterium]	diamond	129	48.5	1	Bacteria	Bacillati	Chloroflexota				Chloroflexota bacterium
31734736	31734736	PRJNA1186363_P_NODE_32617_length_295_cov_1.054054_g31729_i0	PRJNA1186363	32617	295	1.054054	3.1094593	Bacillati	1783272	Bacteria	Bacteria	127	2.64e-33	NR	MBI5288714.1	2026724	g31729	i0	60.4	2.76610169491525	91	36	92.5	0	275	3	159	249	MBI5288714.1 SDR family NAD(P)-dependent oxidoreductase [Chloroflexota bacterium]	diamond	816	128	0.9921875	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);;