metadata: contig_metadata: 15 rows where bioproject = "PRJNA719595" and tax

15 rows where bioproject = "PRJNA719595" and tax_phylum = "Gemmatimonadota"

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_genus	tax_species
5813064	5813064	PRJNA719595_P_NODE_7745_length_248_cov_0.891429_g7710_i0	PRJNA719595	7745	248	0.891429	2.21074392	Gemmatirosa kalamazoonensis	861299	Bacteria	Bacteria	274	4.399999999999999e-69	NTclustered	gi\|575456455\|gb\|CP007128.1\|	861299	g7710	i0	86.992	0.991935483870968	246	28	98	4	1	244	1513566	1513323	Gemmatirosa kalamazoonesis strain KBS708, complete genome	blastn	246	274	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatirosa	Gemmatirosa kalamazoonensis
9637971	9637971	PRJNA719595_P_NODE_7748_length_248_cov_0.891429_g7713_i0	PRJNA719595	7748	248	0.891429	2.21074392	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	191	4.56e-44	NTclustered	gi\|2874253728\|emb\|OY969570.1\|	412054	g7713	i0	82.727	0.887096774193548	220	32	88	5	32	248	5794446	5794662	MAG: uncultured Gemmatimonadales bacterium isolate MFD02840.bin.c.1 genome assembly, chromosome: 1	blastn	220	191	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
10913522	10913522	PRJNA719595_P_NODE_9329_length_242_cov_0.923077_g9294_i0	PRJNA719595	9329	242	0.923077	2.23384634	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	243	1.2100000000000004e-59	NTclustered	gi\|2874253728\|emb\|OY969570.1\|	412054	g9294	i0	86.425	4.97107438016529	221	30	91	0	6	226	1306510	1306730	MAG: uncultured Gemmatimonadales bacterium isolate MFD02840.bin.c.1 genome assembly, chromosome: 1	blastn	1203	243	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
12188798	12188798	PRJNA719595_P_NODE_9330_length_242_cov_0.923077_g9295_i0	PRJNA719595	9330	242	0.923077	2.23384634	FCB group	1783270	Bacteria	Bacteria	100	1.27e-22	NR	HEV8400734.1	2448054	g9295	i0	66.7	4.52479338842975	72	24	89.3	0	23	238	558	629	HEV8400734.1 GNAT family N-acetyltransferase [Gemmatimonadales bacterium]	diamond	1095	101	0.99009900990099	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			Gemmatimonadales bacterium
13463202	13463202	PRJNA719595_P_NODE_7351_length_250_cov_0.881356_g7316_i0	PRJNA719595	7351	250	0.881356	2.20339	FCB group	1783270	Bacteria	Bacteria	106	1.53e-27	NR	MBA3585577.1	2026742	g7316	i0	92	3.6	50	4	60	0	101	250	1	50	MBA3585577.1 alpha/beta hydrolase [Gemmatimonadota bacterium]	diamond	900	106	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota					Gemmatimonadota bacterium
17287485	17287485	PRJNA719595_P_NODE_6714_length_252_cov_0.871508_g6679_i0	PRJNA719595	6714	252	0.871508	2.19620016	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	215	2.75e-51	NTclustered	gi\|2874253978\|emb\|OY970303.1\|	412054	g6679	i0	82.558	1.02380952380952	258	31	98	7	1	247	3599513	3599767	MAG: uncultured Gemmatimonadales bacterium isolate MFD01275.bin.c.12 genome assembly, chromosome: 1	blastn	258	215	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
17287529	17287529	PRJNA719595_P_NODE_8934_length_244_cov_0.912281_g8899_i0	PRJNA719595	8934	244	0.912281	2.22596564	Gemmatirosa kalamazoonensis	861299	Bacteria	Bacteria	254	5.62e-63	NTclustered	gi\|575456455\|gb\|CP007128.1\|	861299	g8899	i0	85.833	4.66393442622951	240	32	98	2	5	243	543071	542833	Gemmatirosa kalamazoonesis strain KBS708, complete genome	blastn	1138	254	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatirosa	Gemmatirosa kalamazoonensis
19836427	19836427	PRJNA719595_P_NODE_8856_length_244_cov_0.912281_g8821_i0	PRJNA719595	8856	244	0.912281	2.22596564	Pseudogemmatithrix	3237678	Bacteria	Bacteria	91.7	1.63e-19	NR	MCC7003936.1	2026741	g8821	i0	77.8	3.95901639344262	54	12	66.4	0	83	244	1	54	MCC7003936.1 UDP-glucose/GDP-mannose dehydrogenase family protein [Gemmatimonadaceae bacterium]	diamond	966	92.4	0.992424242424242	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae		Gemmatimonadaceae bacterium
21112076	21112076	PRJNA719595_P_NODE_8057_length_247_cov_0.896552_g8022_i0	PRJNA719595	8057	247	0.896552	2.21448344	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	303	5.58e-78	NTclustered	gi\|2874253978\|emb\|OY970303.1\|	412054	g8022	i0	89.256	10.9676113360324	242	26	100	0	6	247	3077426	3077667	MAG: uncultured Gemmatimonadales bacterium isolate MFD01275.bin.c.12 genome assembly, chromosome: 1	blastn	2709	303	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
28504778	28504778	PRJNA719595_P_NODE_6587_length_253_cov_0.866667_g6552_i0	PRJNA719595	6587	253	0.866667	2.19266751	Longimicrobiales bacterium	2910168	Bacteria	Bacteria	99.8	1.75e-22	NR	HSK20400.1	2910168	g6552	i0	65	1.92094861660079	80	28	94.9	0	253	14	301	380	HSK20400.1 mechanosensitive ion channel family protein [Longimicrobiales bacterium]	diamond	486	99.8	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Longimicrobiia	Longimicrobiales			Longimicrobiales bacterium
28767798	28767798	PRJNA719595_P_NODE_8507_length_246_cov_0.901734_g8472_i0	PRJNA719595	8507	246	0.901734	2.21826564	Roseisolibacter	2093335	Bacteria	Bacteria	113	6.61e-27	NR	WP_284351320.1	2014610	g8472	i0	63.8	2.95121951219512	80	29	97.6	0	240	1	88	167	WP_284351320.1 ABC transporter permease [Roseisolibacter agri]	diamond	726	113	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Roseisolibacter	Roseisolibacter agri
28978553	28978553	PRJNA719595_P_NODE_7788_length_248_cov_0.891429_g7753_i0	PRJNA719595	7788	248	0.891429	2.21074392	Gemmatimonadaceae bacterium	2026741	Bacteria	Bacteria	148	3.46e-39	NR	HEX4682909.1	2026741	g7753	i0	87.8	2.9758064516129	82	10	99.2	0	246	1	852	933	HEX4682909.1 PDZ domain-containing protein [Gemmatimonadaceae bacterium]	diamond	738	148	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae		Gemmatimonadaceae bacterium
30431615	30431615	PRJNA719595_P_NODE_6833_length_252_cov_0.871508_g6798_i0	PRJNA719595	6833	252	0.871508	2.19620016	Gemmatimonadales bacterium	2448054	Bacteria	Bacteria	173	6.23e-50	NR	HVQ47397.1	2448054	g6798	i0	100	24	84	0	100	0	252	1	152	235	HVQ47397.1 serine/threonine-protein kinase [Gemmatimonadales bacterium]	diamond	6048	173	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			Gemmatimonadales bacterium
30747197	30747197	PRJNA719595_P_NODE_8494_length_246_cov_0.901734_g8459_i0	PRJNA719595	8494	246	0.901734	2.21826564	Gemmatimonadota bacterium	2026742	Bacteria	Bacteria	85.9	7.07e-18	NR	MDQ3997310.1	2026742	g8459	i0	58.4	0.939024390243902	77	31	93.9	1	232	2	2	77	MDQ3997310.1 hypothetical protein [Gemmatimonadota bacterium]	diamond	231	85.9	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota					Gemmatimonadota bacterium
30999979	30999979	PRJNA719595_P_NODE_8234_length_247_cov_0.896552_g8199_i0	PRJNA719595	8234	247	0.896552	2.21448344	Longimicrobiales bacterium	2910168	Bacteria	Bacteria	84.7	6.57e-17	NR	HUP88371.1	2910168	g8199	i0	51.9	1.97975708502024	81	39	98.4	0	247	5	252	332	HUP88371.1 hypothetical protein [Longimicrobiales bacterium]	diamond	489	84.7	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Longimicrobiia	Longimicrobiales			Longimicrobiales 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);;