metadata: contig_metadata: 10 rows where bioproject = "PRJNA488043" and tax

10 rows where bioproject = "PRJNA488043" and tax_phylum = "Ignavibacteriota"

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_kingdom	tax_phylum	tax_class	tax_order	tax_family	tax_species
28844631	28844631	PRJNA488043_P_NODE_20048_length_171_cov_2.197183_g17806_i0	PRJNA488043	20048	171	2.197183	3.75718293	Ignavibacteriaceae bacterium	2651163	Bacteria	Bacteria	42.4	0.0128	NR	MFA6597938.1	2651163	g17806	i0	51.1	4.50877192982456	45	22	78.9	0	135	1	1	45	MFA6597938.1 hypothetical protein [Ignavibacteriaceae bacterium]	diamond	771	42.4	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota	Ignavibacteria	Ignavibacteriales	Ignavibacteriaceae	Ignavibacteriaceae bacterium
28939666	28939666	PRJNA488043_P_NODE_16908_length_203_cov_2.672414_g14666_i0	PRJNA488043	16908	203	2.672414	5.42500042	Ignavibacteriaceae bacterium	2651163	Bacteria	Bacteria	119	8.379999999999999e-31	NR	MBV6514005.1	2651163	g14666	i0	98.1	0.798029556650246	54	1	79.8	0	203	42	279	332	MBV6514005.1 hypothetical protein [Ignavibacteriaceae bacterium]	diamond	162	119	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota	Ignavibacteria	Ignavibacteriales	Ignavibacteriaceae	Ignavibacteriaceae bacterium
30139144	30139144	PRJNA488043_P_NODE_472_length_4954_cov_3.662741_g153_i0	PRJNA488043	472	4954	3.662741	181.45218914	Ignavibacteriaceae bacterium	2651163	Bacteria	Bacteria	726	6.83e-246	NR	MBV6514003.1	2651163	g153	i0	97.8	0.219216794509487	362	8	21.9	0	2499	1414	1	362	MBV6514003.1 hypothetical protein [Ignavibacteriaceae bacterium]	diamond	1086	726	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota	Ignavibacteria	Ignavibacteriales	Ignavibacteriaceae	Ignavibacteriaceae bacterium
30392735	30392735	PRJNA488043_P_NODE_13793_length_247_cov_1.990826_g11551_i0	PRJNA488043	13793	247	1.990826	4.91734022	Ignavibacteriota bacterium	2026749	Bacteria	Bacteria	57.8	9.24e-9	NR	MBX3045161.1	2026749	g11551	i0	58.1	0.522267206477733	43	18	52.2	0	168	40	42	84	MBX3045161.1 hypothetical protein [Ignavibacteriota bacterium]	diamond	129	57.8	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota				Ignavibacteriota bacterium
30550191	30550191	PRJNA488043_P_NODE_473_length_4954_cov_3.639188_g153_i1	PRJNA488043	473	4954	3.639188	180.28537352	Ignavibacteriaceae bacterium	2651163	Bacteria	Bacteria	723	5.34e-245	NR	MBV6514003.1	2651163	g153	i1	97.5	0.219216794509487	362	9	21.9	0	2456	3541	1	362	MBV6514003.1 hypothetical protein [Ignavibacteriaceae bacterium]	diamond	1086	723	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota	Ignavibacteria	Ignavibacteriales	Ignavibacteriaceae	Ignavibacteriaceae bacterium
30676490	30676490	PRJNA488043_P_NODE_10953_length_310_cov_2.309609_g8712_i0	PRJNA488043	10953	310	2.309609	7.1597879	Ignavibacteriaceae bacterium	2651163	Bacteria	Bacteria	161	2.07e-46	NR	MBV6514005.1	2651163	g8712	i0	85.4	0.861290322580645	89	13	86.1	0	308	42	244	332	MBV6514005.1 hypothetical protein [Ignavibacteriaceae bacterium]	diamond	267	161	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota	Ignavibacteria	Ignavibacteriales	Ignavibacteriaceae	Ignavibacteriaceae bacterium
30676494	30676494	PRJNA488043_P_NODE_17033_length_202_cov_1.774566_g14791_i0	PRJNA488043	17033	202	1.774566	3.58462332	Ignavibacteria bacterium	2053306	Bacteria	Bacteria	89	9e-21	NR	MFA5405010.1	2053306	g14791	i0	63.9	0.905940594059406	61	22	90.6	0	20	202	20	80	MFA5405010.1 D-Ala-D-Ala carboxypeptidase family metallohydrolase [Ignavibacteria bacterium]	diamond	183	89	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota	Ignavibacteria			Ignavibacteria bacterium
31972897	31972897	PRJNA488043_P_NODE_5398_length_565_cov_3.108209_g153_i2	PRJNA488043	5398	565	3.108209	17.56138085	Ignavibacteriaceae bacterium	2651163	Bacteria	Bacteria	362	6e-124	NR	MBV6514005.1	2651163	g153	i2	93.5	1.05663716814159	199	1	99.3	1	563	3	72	270	MBV6514005.1 hypothetical protein [Ignavibacteriaceae bacterium]	diamond	597	362	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota	Ignavibacteria	Ignavibacteriales	Ignavibacteriaceae	Ignavibacteriaceae bacterium
32162941	32162941	PRJNA488043_P_NODE_20618_length_166_cov_1.167883_g18376_i0	PRJNA488043	20618	166	1.167883	1.93868578	Ignavibacteria bacterium	2053306	Bacteria	Bacteria	88.6	8.74e-19	NR	MBP9095665.1	2053306	g18376	i0	85.2	0.975903614457831	54	8	97.6	0	3	164	285	338	MBP9095665.1 hypothetical protein [Ignavibacteria bacterium]	diamond	162	88.6	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota	Ignavibacteria			Ignavibacteria bacterium
32194479	32194479	PRJNA488043_S_NODE_1458_length_161_cov_3.310606_g1447_i0	PRJNA488043	1458	161	3.310606	5.33007566	Ignavibacteriota bacterium	2026749	Bacteria	Bacteria	55.1	5.4e-7	NR	MBI3258483.1	2026749	g1447	i0	61.4	0.819875776397516	44	17	82	0	135	4	82	125	MBI3258483.1 VWA domain-containing protein [Ignavibacteriota bacterium]	diamond	132	55.1	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota				Ignavibacteriota 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);;