metadata: contig_metadata: 11 rows where bioproject = "PRJNA832865", tax_kingdom = "Bacillati" and tax

11 rows where bioproject = "PRJNA832865", 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_species
12302829	12302829	PRJNA832865_S_NODE_73550_length_287_cov_1.808411_g68464_i0	PRJNA832865	73550	287	1.808411	5.19013957	Anaerolineae bacterium	2052143	Bacteria	Bacteria	177	7.789999999999997e-55	NR	MFO7743059.1	2052143	g68464	i0	91.5	0.982578397212544	94	8	98.3	0	285	4	59	152	MFO7743059.1 reverse transcriptase domain-containing protein [Anaerolineae bacterium]	diamond	282	177	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae	Anaerolineae bacterium
27465577	27465577	PRJNA832865_S_NODE_91123_length_255_cov_1.703297_g86037_i0	PRJNA832865	91123	255	1.703297	4.34340735	Anaerolineae bacterium	2052143	Bacteria	Bacteria	63.9	1.8e-10	NR	MFO7743059.1	2052143	g86037	i0	91.2	0.4	34	3	40	0	102	1	52	85	MFO7743059.1 reverse transcriptase domain-containing protein [Anaerolineae bacterium]	diamond	102	63.9	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae	Anaerolineae bacterium
27568571	27568571	PRJNA832865_S_NODE_4624_length_2430_cov_11.582520_g2161_i3	PRJNA832865	4624	2430	11.58252	281.455236	Bacillati	1783272	Bacteria	Bacteria	75.9	4.27e-10	NR	MCP4356419.1	2026724	g2161	i3	23.1	1.7	516	308	60.4	21	2138	672	53	506	MCP4356419.1 ATP-binding domain-containing protein [Chloroflexota bacterium]	diamond	4131	76.6	0.990861618798956	Bacteria	Bacillati	Chloroflexota		Chloroflexota bacterium
27844135	27844135	PRJNA832865_S_NODE_94464_length_251_cov_0.865169_g89378_i0	PRJNA832865	94464	251	0.865169	2.17157419	Chloroflexota bacterium	2026724	Bacteria	Bacteria	40	0.0333	NR	MEP7134160.1	2026724	g89378	i0	44.4	0.430278884462151	36	20	43	0	129	236	3	38	MEP7134160.1 hypothetical protein [Chloroflexota bacterium]	diamond	108	40	1	Bacteria	Bacillati	Chloroflexota		Chloroflexota bacterium
28223012	28223012	PRJNA832865_S_NODE_88866_length_259_cov_1.236559_g83780_i0	PRJNA832865	88866	259	1.236559	3.20268781	Chloroflexota bacterium	2026724	Bacteria	Bacteria	44.3	0.0123	NR	MBC8508466.1	2026724	g83780	i0	32.9	0.915057915057915	79	38	85.7	2	222	1	177	245	MBC8508466.1 GDP-mannose 4,6-dehydratase [Chloroflexota bacterium]	diamond	237	44.3	1	Bacteria	Bacillati	Chloroflexota		Chloroflexota bacterium
28254644	28254644	PRJNA832865_S_NODE_87646_length_261_cov_1.207447_g82560_i0	PRJNA832865	87646	261	1.207447	3.15143667	Chloroflexota bacterium	2026724	Bacteria	Bacteria	42.7	0.0473	NR	MCA2002683.1	2026724	g82560	i0	32.6	0.528735632183908	46	31	52.9	0	201	64	301	346	MCA2002683.1 serine/threonine-protein kinase [Chloroflexota bacterium]	diamond	138	42.7	1	Bacteria	Bacillati	Chloroflexota		Chloroflexota bacterium
28822833	28822833	PRJNA832865_S_NODE_84268_length_266_cov_3.497409_g79182_i0	PRJNA832865	84268	266	3.497409	9.30310794	Chloroflexi bacterium SZAS-1	2807729	Bacteria	Bacteria	42.7	0.0467	NR	MBS1964660.1	2807729	g79182	i0	50	0.451127819548872	40	12	36.1	1	156	251	55	94	MBS1964660.1 hypothetical protein [Chloroflexi bacterium SZAS-1]	diamond	120	42.7	1	Bacteria	Bacillati	Chloroflexota		Chloroflexi bacterium SZAS-1
32014436	32014436	PRJNA832865_S_NODE_70838_length_293_cov_1.400000_g65752_i0	PRJNA832865	70838	293	1.4	4.102	Anaerolineae bacterium	2052143	Bacteria	Bacteria	170	4.66e-52	NR	MFO7743059.1	2052143	g65752	i0	85.4	0.982935153583618	96	14	98.3	0	6	293	57	152	MFO7743059.1 reverse transcriptase domain-containing protein [Anaerolineae bacterium]	diamond	288	170	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae	Anaerolineae bacterium
32204299	32204299	PRJNA832865_S_NODE_54198_length_341_cov_1.361940_g49112_i0	PRJNA832865	54198	341	1.36194	4.6442154	Chloroflexota bacterium	2026724	Bacteria	Bacteria	52	6.5e-5	NR	MEC9321195.1	2026724	g49112	i0	39.3	0.536656891495601	61	37	53.7	0	306	124	601	661	MEC9321195.1 reverse transcriptase domain-containing protein [Chloroflexota bacterium]	diamond	183	52	1	Bacteria	Bacillati	Chloroflexota		Chloroflexota bacterium
32520980	32520980	PRJNA832865_S_NODE_70919_length_293_cov_1.313636_g65833_i0	PRJNA832865	70919	293	1.313636	3.84895348	Anaerolineae bacterium	2052143	Bacteria	Bacteria	168	1.89e-51	NR	MFO7743059.1	2052143	g65833	i0	87.9	0.931740614334471	91	11	93.2	0	21	293	1	91	MFO7743059.1 reverse transcriptase domain-containing protein [Anaerolineae bacterium]	diamond	273	168	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae	Anaerolineae bacterium
32772703	32772703	PRJNA832865_S_NODE_76620_length_281_cov_1.168269_g71534_i0	PRJNA832865	76620	281	1.168269	3.28283589	Anaerolineae bacterium	2052143	Bacteria	Bacteria	173	1.68e-53	NR	MFO7743059.1	2052143	g71534	i0	91.4	0.99288256227758	93	8	99.3	0	1	279	15	107	MFO7743059.1 reverse transcriptase domain-containing protein [Anaerolineae bacterium]	diamond	279	173	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae	Anaerolineae 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);;