metadata: contig_metadata: 12 rows where bioproject = "PRJNA591127" and tax

12 rows where bioproject = "PRJNA591127" 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
9493378	9493378	PRJNA591127_P_NODE_11088_length_221_cov_2.244565_g10919_i0	PRJNA591127	11088	221	2.244565	4.96048865	Gemmatimonas phototrophica	1379270	Bacteria	Bacteria	292	1.06e-74	NTclustered	gi\|1015602748\|gb\|CP011454.1\|	1379270	g10919	i0	95.135	18.8235294117647	185	9	84	0	1	185	2075775	2075591	Gemmatimonas phototrophica strain AP64, complete genome	blastn	4160	292	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatimonas	Gemmatimonas phototrophica
10769377	10769377	PRJNA591127_P_NODE_28089_length_153_cov_4.310345_g27920_i0	PRJNA591127	28089	153	4.310345	6.59482785	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	215	1.51e-51	NTclustered	gi\|2874253755\|emb\|OY969695.1\|	412054	g27920	i0	96.875	11.9019607843137	128	4	84	0	26	153	341399	341272	MAG: uncultured Gemmatimonadales bacterium isolate MFD04967.bin.1.34 genome assembly, chromosome: 1	blastn	1821	215	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
12044275	12044275	PRJNA591127_P_NODE_3550_length_382_cov_1.962319_g3382_i0	PRJNA591127	3550	382	1.962319	7.49605858	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	442	1.8499999999999992e-119	NTclustered	gi\|2874253978\|emb\|OY970303.1\|	412054	g3382	i0	87.76	63.0157068062827	384	39	100	7	1	382	1903188	1903565	MAG: uncultured Gemmatimonadales bacterium isolate MFD01275.bin.c.12 genome assembly, chromosome: 1	blastn	24072	442	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
15867858	15867858	PRJNA591127_P_NODE_4953_length_328_cov_2.542955_g4785_i0	PRJNA591127	4953	328	2.542955	8.3408924	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	416	9.5e-112	NTclustered	gi\|2874253978\|emb\|OY970303.1\|	412054	g4785	i0	89.443	123.996951219512	341	20	99	4	3	327	1903971	1903631	MAG: uncultured Gemmatimonadales bacterium isolate MFD01275.bin.c.12 genome assembly, chromosome: 1	blastn	40671	416	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
15867898	15867898	PRJNA591127_P_NODE_9973_length_233_cov_2.117347_g9805_i0	PRJNA591127	9973	233	2.117347	4.93341851	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	303	5.21e-78	NTclustered	gi\|2874253978\|emb\|OY970303.1\|	412054	g9805	i0	91.189	238.248927038627	227	14	97	4	1	225	1902040	1901818	MAG: uncultured Gemmatimonadales bacterium isolate MFD01275.bin.c.12 genome assembly, chromosome: 1	blastn	55512	303	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
18990198	18990198	PRJNA591127_P_NODE_27575_length_156_cov_0.983193_g27406_i0	PRJNA591127	27575	156	0.983193	1.53378108	Pseudomonadati	3379134	Bacteria	Bacteria	209	7.2e-50	NTclustered	gi\|307722607\|gb\|GU195855.1\|	203437	g27406	i0	94.776	80.6346153846154	134	7	86	0	23	156	546	413	Uncultured Gemmatimonadetes bacterium clone P2A12 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	12579	211	0.990521327014218	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota					uncultured Gemmatimonadota bacterium
19691537	19691537	PRJNA591127_P_NODE_31036_length_151_cov_1.096491_g30867_i0	PRJNA591127	31036	151	1.096491	1.65570141	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	169	1.17e-37	NTclustered	gi\|2874253978\|emb\|OY970303.1\|	412054	g30867	i0	91.27	22.7284768211921	126	8	83	2	25	149	1904084	1903961	MAG: uncultured Gemmatimonadales bacterium isolate MFD01275.bin.c.12 genome assembly, chromosome: 1	blastn	3432	169	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
19691555	19691555	PRJNA591127_P_NODE_4436_length_345_cov_1.350649_g4268_i0	PRJNA591127	4436	345	1.350649	4.65973905	Gemmatimonas phototrophica	1379270	Bacteria	Bacteria	381	3.669999999999999e-101	NTclustered	gi\|1015602748\|gb\|CP011454.1\|	1379270	g4268	i0	87.283	681.791304347826	346	29	98	11	5	343	2076268	2076605	Gemmatimonas phototrophica strain AP64, complete genome	blastn	235218	381	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatimonas	Gemmatimonas phototrophica
20967128	20967128	PRJNA591127_P_NODE_10617_length_226_cov_1.174603_g10449_i0	PRJNA591127	10617	226	1.174603	2.65460278	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	230	8.659999999999999e-56	NTclustered	gi\|2874253978\|emb\|OY970303.1\|	412054	g10449	i0	86.175	373.592920353982	217	24	95	6	5	218	5915480	5915267	MAG: uncultured Gemmatimonadales bacterium isolate MFD01275.bin.c.12 genome assembly, chromosome: 1	blastn	84432	230	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
22242297	22242297	PRJNA591127_P_NODE_7018_length_277_cov_8.929167_g6850_i0	PRJNA591127	7018	277	8.929167	24.73379259	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	270	6.46e-68	NTclustered	gi\|2874253728\|emb\|OY969570.1\|	412054	g6850	i0	85.556	189.73285198556	270	26	95	12	12	274	173052	173315	MAG: uncultured Gemmatimonadales bacterium isolate MFD02840.bin.c.1 genome assembly, chromosome: 1	blastn	52556	270	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
28279636	28279636	PRJNA591127_P_NODE_8306_length_256_cov_1.894977_g8138_i0	PRJNA591127	8306	256	1.894977	4.85114112	Longimicrobiales bacterium	2910168	Bacteria	Bacteria	42.7	0.0396	NR	MDP2955286.1	2910168	g8138	i0	44.2	0.609375	52	25	60.9	1	33	188	241	288	MDP2955286.1 type II CAAX endopeptidase family protein [Longimicrobiales bacterium]	diamond	156	42.7	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Longimicrobiia	Longimicrobiales			Longimicrobiales bacterium
32166323	32166323	PRJNA591127_P_NODE_14298_length_197_cov_4.525000_g14129_i0	PRJNA591127	14298	197	4.525	8.91425	Gemmatimonadota bacterium	2026742	Bacteria	Bacteria	50.4	3.9e-5	NR	MDQ3950553.1	2026742	g14129	i0	38.5	0.989847715736041	65	40	99	0	1	195	337	401	MDQ3950553.1 PAS domain S-box protein [Gemmatimonadota bacterium]	diamond	195	50.4	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota					Gemmatimonadota 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);;