metadata: contig_metadata: 6 rows where bioproject = "PRJEB55250" and tax

6 rows where bioproject = "PRJEB55250" and tax_phylum = "Armatimonadota"

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
26685251	26685251	PRJEB55250_P_NODE_2881_length_390_cov_1.252366_g2757_i0	PRJEB55250	2881	390	1.252366	4.8842274	Armatimonadota bacterium	2033014	Bacteria	Bacteria	65.9	1.25e-9	NR	HEX2952275.1	2033014	g2757	i0	33.3	0.946153846153846	123	79	94.6	2	4	372	204	323	HEX2952275.1 hypothetical protein [Armatimonadota bacterium]	diamond	369	65.9	1	Bacteria	Bacillati	Armatimonadota				Armatimonadota bacterium
27539216	27539216	PRJEB55250_P_NODE_11564_length_251_cov_0.865169_g11440_i0	PRJEB55250	11564	251	0.865169	2.17157419	Armatimonadota bacterium	2033014	Bacteria	Bacteria	107	2.46e-25	NR	MBV9852278.1	2033014	g11440	i0	76.5	3.27490039840637	68	16	81.3	0	1	204	384	451	MBV9852278.1 glucose-6-phosphate isomerase [Armatimonadota bacterium]	diamond	822	107	1	Bacteria	Bacillati	Armatimonadota				Armatimonadota bacterium
27602461	27602461	PRJEB55250_P_NODE_13764_length_247_cov_0.885057_g13640_i0	PRJEB55250	13764	247	0.885057	2.18609079	Armatimonadota bacterium	2033014	Bacteria	Bacteria	106	6.42e-26	NR	MBV9849069.1	2033014	g13640	i0	65.8	0.88663967611336	73	24	87.4	1	219	4	5	77	MBV9849069.1 sugar phosphate isomerase/epimerase [Armatimonadota bacterium]	diamond	219	106	1	Bacteria	Bacillati	Armatimonadota				Armatimonadota bacterium
29300552	29300552	PRJEB55250_P_NODE_15909_length_242_cov_0.911243_g15785_i0	PRJEB55250	15909	242	0.911243	2.20520806	Bacteria	2	Bacteria	Bacteria	75.1	1.44e-13	NR	MDQ2688327.1	2033014	g15785	i0	51.9	2.9504132231405	79	32	96.7	2	239	6	199	272	MDQ2688327.1 MG2 domain-containing protein [Armatimonadota bacterium]	diamond	714	75.5	0.994701986754967	Bacteria	Bacillati	Armatimonadota				Armatimonadota bacterium
31170769	31170769	PRJEB55250_P_NODE_12655_length_249_cov_0.875000_g12531_i0	PRJEB55250	12655	249	0.875	2.17875	Fimbriimonadaceae bacterium	2682144	Bacteria	Bacteria	85.5	3.55e-17	NR	HWA84085.1	2682144	g12531	i0	48.8	0.987951807228916	82	42	98.8	0	248	3	263	344	HWA84085.1 Cache 3/Cache 2 fusion domain-containing protein [Fimbriimonadaceae bacterium]	diamond	246	85.5	1	Bacteria	Bacillati	Armatimonadota	Fimbriimonadia	Fimbriimonadales	Fimbriimonadaceae	Fimbriimonadaceae bacterium
32373238	32373238	PRJEB55250_P_NODE_12719_length_249_cov_0.875000_g12595_i0	PRJEB55250	12719	249	0.875	2.17875	Chthonomonadaceae bacterium	2739509	Bacteria	Bacteria	143	9.94e-40	NR	MCS6775695.1	2739509	g12595	i0	86.3	1.95180722891566	80	11	96.4	0	8	247	162	241	MCS6775695.1 NAD-dependent epimerase/dehydratase family protein [Chthonomonadaceae bacterium]	diamond	486	143	1	Bacteria	Bacillati	Armatimonadota	Chthonomonadia	Chthonomonadales	Chthonomonadaceae	Chthonomonadaceae 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);;