metadata: contig_metadata: 13 rows where bioproject = "PRJNA600413", tax_clade = "FCB group" and tax

13 rows where bioproject = "PRJNA600413", tax_clade = "FCB group" 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
573404	573404	PRJNA600413_P_NODE_148461_length_161_cov_0.910714_g147760_i0	PRJNA600413	148461	161	0.910714	1.46624954	Gemmatirosa kalamazoonensis	861299	Bacteria	Bacteria	198	1.6199999999999999e-46	NTclustered	gi\|575456455\|gb\|CP007128.1\|	861299	g147760	i0	88.957	1.67080745341615	163	14	100	4	1	161	5293998	5293838	Gemmatirosa kalamazoonesis strain KBS708, complete genome	blastn	269	198	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatirosa	Gemmatirosa kalamazoonensis
1849204	1849204	PRJNA600413_P_NODE_149842_length_161_cov_0.910714_g149141_i0	PRJNA600413	149842	161	0.910714	1.46624954	Gemmatimonadales bacterium	2448054	Bacteria	Bacteria	57.4	8.19e-8	NR	MEO6056204.1	2448054	g149141	i0	90.6	4.93788819875776	53	5	98.8	0	2	160	84	136	MEO6056204.1 efflux RND transporter periplasmic adaptor subunit [Gemmatimonadales bacterium]	diamond	795	57.4	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			Gemmatimonadales bacterium
3123757	3123757	PRJNA600413_P_NODE_103423_length_167_cov_0.864407_g102722_i0	PRJNA600413	103423	167	0.864407	1.44355969	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	99	1.77e-16	NTclustered	gi\|2874253938\|emb\|OY970263.1\|	412054	g102722	i0	86.667	0.538922155688623	90	10	53	2	58	146	88156	88068	MAG: uncultured Gemmatimonadales bacterium isolate MFD02416.bin.2.26 genome assembly, chromosome: 1	blastn	90	99	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
17150755	17150755	PRJNA600413_P_NODE_126934_length_164_cov_0.886957_g126233_i0	PRJNA600413	126934	164	0.886957	1.45460948	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	276	7.46e-70	NTclustered	gi\|2874253789\|emb\|OY969773.1\|	412054	g126233	i0	96.97	134.682926829268	165	3	100	2	1	164	421855	422018	MAG: uncultured Gemmatimonadales bacterium isolate MFD04580.bin.2.49 genome assembly, chromosome: 1	blastn	22088	276	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
26826913	26826913	PRJNA600413_P_NODE_73341_length_184_cov_1.511111_g72640_i0	PRJNA600413	73341	184	1.511111	2.78044424	Longimicrobium sp.	2029185	Bacteria	Bacteria	80.5	3.17e-16	NR	HEU0299523.1	2029185	g72640	i0	60	0.978260869565217	60	24	97.8	0	182	3	83	142	HEU0299523.1 hypothetical protein [Longimicrobium sp.]	diamond	180	80.5	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Longimicrobiia	Longimicrobiales	Longimicrobiaceae	Longimicrobium	Longimicrobium sp.
28879856	28879856	PRJNA600413_P_NODE_112208_length_166_cov_0.871795_g111507_i0	PRJNA600413	112208	166	0.871795	1.4471797	Longimicrobiaceae bacterium	3047548	Bacteria	Bacteria	97.8	5.04e-22	NR	HEU0078582.1	3047548	g111507	i0	92.6	0.975903614457831	54	4	97.6	0	164	3	200	253	HEU0078582.1 hypothetical protein [Longimicrobiaceae bacterium]	diamond	162	97.8	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Longimicrobiia	Longimicrobiales	Longimicrobiaceae		Longimicrobiaceae bacterium
30301561	30301561	PRJNA600413_P_NODE_97552_length_169_cov_1.800000_g96851_i0	PRJNA600413	97552	169	1.8	3.042	uncultured Gemmatimonadaceae bacterium	246130	Bacteria	Bacteria	41.6	0.0355	NR	CAA9357409.1	246130	g96851	i0	50	1.02958579881657	58	23	95.9	3	4	165	161	216	CAA9357409.1 MAG: Squalene synthase, partial [uncultured Gemmatimonadaceae bacterium]	diamond	174	41.6	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae		uncultured Gemmatimonadaceae bacterium
30819954	30819954	PRJNA600413_P_NODE_102814_length_167_cov_0.864407_g102113_i0	PRJNA600413	102814	167	0.864407	1.44355969	Pseudomonadati	3379134	Bacteria	Bacteria	91.7	7.63e-20	NR	MBC7788827.1	2026741	g102113	i0	78.4	1.90419161676647	51	11	91.6	0	163	11	302	352	MBC7788827.1 ABC transporter permease [Gemmatimonadaceae bacterium]	diamond	318	92	0.996739130434783	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae		Gemmatimonadaceae bacterium
31312173	31312173	PRJNA600413_P_NODE_117095_length_165_cov_0.879310_g116394_i0	PRJNA600413	117095	165	0.87931	1.4508615	Gemmatimonadaceae bacterium	2026741	Bacteria	Bacteria	79.3	1.6e-15	NR	HYD51083.1	2026741	g116394	i0	68.5	0.981818181818182	54	17	98.2	0	164	3	733	786	HYD51083.1 SusC/RagA family TonB-linked outer membrane protein [Gemmatimonadaceae bacterium]	diamond	162	79.3	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae		Gemmatimonadaceae bacterium
31818242	31818242	PRJNA600413_P_NODE_132277_length_163_cov_0.894737_g131576_i0	PRJNA600413	132277	163	0.894737	1.45842131	Gemmatimonadales bacterium	2448054	Bacteria	Bacteria	82.4	1.32e-16	NR	HWP36029.1	2448054	g131576	i0	64.2	0.975460122699387	53	19	97.5	0	4	162	164	216	HWP36029.1 Druantia anti-phage system protein DruA [Gemmatimonadales bacterium]	diamond	159	82.4	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			Gemmatimonadales bacterium
31944689	31944689	PRJNA600413_P_NODE_129997_length_163_cov_1.789474_g129296_i0	PRJNA600413	129997	163	1.789474	2.91684262	Longimicrobiaceae bacterium	3047548	Bacteria	Bacteria	62.4	1.43e-10	NR	HEV2130128.1	3047548	g129296	i0	54.7	1.95092024539877	53	24	97.5	0	5	163	26	78	HEV2130128.1 nuclear transport factor 2 family protein [Longimicrobiaceae bacterium]	diamond	318	62.4	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Longimicrobiia	Longimicrobiales	Longimicrobiaceae		Longimicrobiaceae bacterium
32829621	32829621	PRJNA600413_P_NODE_82480_length_178_cov_1.581395_g81779_i0	PRJNA600413	82480	178	1.581395	2.8148831	Gemmatimonadota bacterium	2026742	Bacteria	Bacteria	69.7	2.98e-12	NR	MDQ6831498.1	2026742	g81779	i0	50.9	0.960674157303371	57	28	96.1	0	7	177	192	248	MDQ6831498.1 ParA family protein [Gemmatimonadota bacterium]	diamond	171	69.7	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota					Gemmatimonadota bacterium
32861018	32861018	PRJNA600413_P_NODE_84540_length_177_cov_1.343750_g83839_i0	PRJNA600413	84540	177	1.34375	2.3784375	Gemmatimonadota bacterium	2026742	Bacteria	Bacteria	77.8	6.93e-15	NR	MEZ4415771.1	2026742	g83839	i0	67.8	1	59	19	100	0	1	177	536	594	MEZ4415771.1 amidohydrolase family protein [Gemmatimonadota bacterium]	diamond	177	77.8	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);;