metadata: contig_metadata: 5 rows where bioproject = "PRJNA335774", tax_phylum = "Armatimonadota" and tax

5 rows where bioproject = "PRJNA335774", tax_phylum = "Armatimonadota" and tax_superkingdom = "Bacteria"

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_genus	tax_species
27422527	27422527	PRJNA335774_P_NODE_8983_length_480_cov_1.641278_g8831_i0	PRJNA335774	8983	480	1.641278	7.8781344	Armatimonadota bacterium	2033014	Bacteria	Bacteria	80.1	6.33e-15	NR	GDX40226.1	2033014	g8831	i0	52.4	0.525	84	31	51.3	3	3	248	159	235	GDX40226.1 hypothetical protein LBMAG21_05180 [Armatimonadota bacterium]	diamond	252	80.1	1	Bacteria	Bacillati	Armatimonadota					Armatimonadota bacterium
28779838	28779838	PRJNA335774_P_NODE_5487_length_593_cov_2.353846_g5339_i0	PRJNA335774	5487	593	2.353846	13.95830678	Armatimonadota bacterium	2033014	Bacteria	Bacteria	130	8.83e-34	NR	GDX40226.1	2033014	g5339	i0	49	1.4468802698145	143	68	70.8	4	3	422	94	234	GDX40226.1 hypothetical protein LBMAG21_05180 [Armatimonadota bacterium]	diamond	858	130	1	Bacteria	Bacillati	Armatimonadota					Armatimonadota bacterium
30200763	30200763	PRJNA335774_P_NODE_16412_length_372_cov_0.832776_g16260_i0	PRJNA335774	16412	372	0.832776	3.09792672	Capsulimonas sp.	2494211	Bacteria	Bacteria	91.7	1.07e-18	NR	MCW3061757.1	2494211	g16260	i0	49.5	2.20161290322581	91	39	73.4	3	96	368	384	467	MCW3061757.1 putative glycosyl hydrolase [Capsulimonas sp.]	diamond	819	91.7	1	Bacteria	Bacillati	Armatimonadota	Armatimonadia	Capsulimonadales	Capsulimonadaceae	Capsulimonas	Capsulimonas sp.
31654731	31654731	PRJNA335774_P_NODE_35217_length_265_cov_1.604167_g35065_i0	PRJNA335774	35217	265	1.604167	4.25104255	Armatimonadota bacterium	2033014	Bacteria	Bacteria	103	4.68e-24	NR	MEI7985897.1	2033014	g35065	i0	59.8	0.984905660377358	87	34	98.5	1	5	265	138	223	MEI7985897.1 glycoside hydrolase family 5 protein [Armatimonadota bacterium]	diamond	261	103	1	Bacteria	Bacillati	Armatimonadota					Armatimonadota bacterium
31735287	31735287	PRJNA335774_P_NODE_557_length_1376_cov_1.535687_g515_i0	PRJNA335774	557	1376	1.535687	21.13105312	PVC group	1783257	Bacteria	Bacteria	359	2.3499999999999998e-112	NR	HET6386082.1	2033014	g515	i0	46.2	2.71656976744186	411	207	88.1	5	1348	137	40	443	HET6386082.1 pectinesterase family protein [Armatimonadota bacterium]	diamond	3738	359	1	Bacteria	Bacillati	Armatimonadota					Armatimonadota 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);;