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

6 rows where analysis = "diamond", bioproject = "PRJNA630162" and tax_phylum = "Candidatus Nomuraibacteriota"

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_clade	tax_phylum	tax_species
27744375	27744375	PRJNA630162_P_NODE_154944_length_163_cov_1.622807_g153421_i0	PRJNA630162	154944	163	1.6228070000000001	2.64517541	Candidatus Nomurabacteria bacterium	2052152	Bacteria	Bacteria	99	2.05e-24	NR	MEI6810529.1	2052152	g153421	i0	92.3	2.87116564417178	52	4	95.7	0	161	6	35	86	MEI6810529.1 transcription termination/antitermination protein NusG [Candidatus Nomurabacteria bacterium]	diamond	468	99	1	Bacteria	Bacteria candidate phyla	Candidatus Nomuraibacteriota	Candidatus Nomurabacteria bacterium
28154767	28154767	PRJNA630162_P_NODE_166625_length_157_cov_3.925926_g165102_i0	PRJNA630162	166625	157	3.925926	6.16370382	Candidatus Nomurabacteria bacterium	2052152	Bacteria	Bacteria	77.8	5.08e-15	NR	MCB9809989.1	2052152	g165102	i0	66.7	0.974522292993631	51	17	97.5	0	154	2	96	146	MCB9809989.1 hypothetical protein [Candidatus Nomurabacteria bacterium]	diamond	153	77.8	1	Bacteria	Bacteria candidate phyla	Candidatus Nomuraibacteriota	Candidatus Nomurabacteria bacterium
29240801	29240801	PRJNA630162_P_NODE_132569_length_169_cov_0.866667_g131046_i0	PRJNA630162	132569	169	0.866667	1.46466723	Bacteria	2	Bacteria	Bacteria	100	1.05e-24	NR	MCX6753908.1	2052152	g131046	i0	87	2.87573964497041	54	7	95.9	0	164	3	142	195	MCX6753908.1 transposase [Candidatus Nomurabacteria bacterium]	diamond	486	100	1	Bacteria	Bacteria candidate phyla	Candidatus Nomuraibacteriota	Candidatus Nomurabacteria bacterium
30649112	30649112	PRJNA630162_P_NODE_139873_length_167_cov_0.881356_g138350_i0	PRJNA630162	139873	167	0.881356	1.47186452	Candidatus Nomurabacteria bacterium	2052152	Bacteria	Bacteria	99.4	1.53e-22	NR	MCC6323895.1	2052152	g138350	i0	94.4	1.94011976047904	54	3	97	0	165	4	290	343	MCC6323895.1 type I DNA topoisomerase [Candidatus Nomurabacteria bacterium]	diamond	324	99.4	1	Bacteria	Bacteria candidate phyla	Candidatus Nomuraibacteriota	Candidatus Nomurabacteria bacterium
32211592	32211592	PRJNA630162_P_NODE_52818_length_242_cov_3.347150_g51295_i0	PRJNA630162	52818	242	3.34715	8.100103	Bacillati	1783272	Bacteria	Bacteria	42.7	0.0331	NR	NCU26960.1	2052152	g51295	i0	37.7	1.71074380165289	69	41	83.1	1	6	206	40	108	NCU26960.1 glycerate kinase [Candidatus Nomurabacteria bacterium]	diamond	414	42.7	1	Bacteria	Bacteria candidate phyla	Candidatus Nomuraibacteriota	Candidatus Nomurabacteria bacterium
32672746	32672746	PRJNA630162_P_NODE_166820_length_157_cov_3.055556_g165297_i0	PRJNA630162	166820	157	3.055556	4.79722292	Candidatus Nomurabacteria bacterium	2052152	Bacteria	Bacteria	94.7	5.21e-21	NR	HCU01437.1	2052152	g165297	i0	91.8	0.936305732484076	49	4	93.6	0	155	9	441	489	HCU01437.1 IS1634 family transposase [Candidatus Nomurabacteria bacterium]	diamond	147	94.7	1	Bacteria	Bacteria candidate phyla	Candidatus Nomuraibacteriota	Candidatus Nomurabacteria 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);;