metadata: contig_metadata: 11 rows where bioproject = "PRJNA724039", tax_clade = "FCB group" and tax

11 rows where bioproject = "PRJNA724039", 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
3262534	3262534	PRJNA724039_S_NODE_5663_length_291_cov_1.811024_g5456_i0	PRJNA724039	5663	291	1.811024	5.27007984	Gemmatimonadota bacterium	2026742	Bacteria	Bacteria	152	2.58e-32	NTclustered	gi\|2893358400\|emb\|OZ220691.1\|	2026742	g5456	i0	83.529	148.199312714777	170	21	57	6	1	165	2518902	2519069	MAG: Gemmatimonadota bacterium isolate 1766b9ea-3269-4cc1-97f5-695b05480569 genome assembly, chromosome: 1	blastn	43126	152	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota					Gemmatimonadota bacterium
4539643	4539643	PRJNA724039_S_NODE_7344_length_247_cov_3.642857_g7137_i0	PRJNA724039	7344	247	3.642857	8.99785679	Gemmatirosa kalamazoonensis	861299	Bacteria	Bacteria	220	5.78e-53	NTclustered	gi\|575456455\|gb\|CP007128.1\|	861299	g7137	i0	83.265	188.234817813765	245	35	98	6	4	246	3042716	3042476	Gemmatirosa kalamazoonesis strain KBS708, complete genome	blastn	46494	220	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatirosa	Gemmatirosa kalamazoonensis
4539654	4539654	PRJNA724039_S_NODE_844_length_996_cov_18.532847_g719_i0	PRJNA724039	844	996	18.532847	184.58715612	Gemmatirosa kalamazoonensis	861299	Bacteria	Bacteria	1352	0	NTclustered	gi\|575456455\|gb\|CP007128.1\|	861299	g719	i0	91.44	145.718875502008	993	74	99	6	6	996	3044222	3043239	Gemmatirosa kalamazoonesis strain KBS708, complete genome	blastn	145136	1352	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatirosa	Gemmatirosa kalamazoonensis
7089861	7089861	PRJNA724039_S_NODE_1546_length_638_cov_17.008319_g719_i2	PRJNA724039	1546	638	17.008319	108.51307522	Gemmatirosa kalamazoonensis	861299	Bacteria	Bacteria	863	0	NTclustered	gi\|575456455\|gb\|CP007128.1\|	861299	g719	i2	91.25	42.5329153605016	640	47	99	8	3	638	3043873	3043239	Gemmatirosa kalamazoonesis strain KBS708, complete genome	blastn	27136	863	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatirosa	Gemmatirosa kalamazoonensis
9639573	9639573	PRJNA724039_S_NODE_1388_length_688_cov_16.897081_g719_i1	PRJNA724039	1388	688	16.897081	116.25191728	Gemmatirosa kalamazoonensis	861299	Bacteria	Bacteria	911	0	NTclustered	gi\|575456455\|gb\|CP007128.1\|	861299	g719	i1	92.178	35.3880813953488	652	40	94	11	42	688	3043884	3043239	Gemmatirosa kalamazoonesis strain KBS708, complete genome	blastn	24347	911	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatirosa	Gemmatirosa kalamazoonensis
9639777	9639777	PRJNA724039_S_NODE_8848_length_220_cov_9.289617_g8641_i0	PRJNA724039	8848	220	9.289617	20.4371574	Gemmatirosa kalamazoonensis	861299	Bacteria	Bacteria	285	1.7599999999999998e-72	NTclustered	gi\|575456455\|gb\|CP007128.1\|	861299	g8641	i0	90.09	54.45	222	18	100	4	1	220	3042548	3042329	Gemmatirosa kalamazoonesis strain KBS708, complete genome	blastn	11979	285	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatirosa	Gemmatirosa kalamazoonensis
12190372	12190372	PRJNA724039_S_NODE_1290_length_728_cov_13.030391_g1127_i0	PRJNA724039	1290	728	13.030391	94.86124648	Gemmatirosa kalamazoonensis	861299	Bacteria	Bacteria	918	0	NTclustered	gi\|575456455\|gb\|CP007128.1\|	861299	g1127	i0	89.581	289.167582417582	739	55	100	18	1	728	3043250	3042523	Gemmatirosa kalamazoonesis strain KBS708, complete genome	blastn	210514	918	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatirosa	Gemmatirosa kalamazoonensis
28000014	28000014	PRJNA724039_S_NODE_6365_length_270_cov_1.987124_g6158_i0	PRJNA724039	6365	270	1.987124	5.3652348	Gemmatimonadaceae bacterium	2026741	Bacteria	Bacteria	117	6.44e-29	NR	MCU0646502.1	2026741	g6158	i0	62.2	1	90	34	100	0	1	270	190	279	MCU0646502.1 metallophosphoesterase [Gemmatimonadaceae bacterium]	diamond	270	117	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae		Gemmatimonadaceae bacterium
29136717	29136717	PRJNA724039_S_NODE_1129_length_810_cov_4.652005_g981_i0	PRJNA724039	1129	810	4.652005	37.6812405	Gemmatimonadales bacterium	2448054	Bacteria	Bacteria	103	5.77e-22	NR	NIM48047.1	2448054	g981	i0	30.6	1.16296296296296	314	161	97.8	10	14	805	19	325	NIM48047.1 hypothetical protein [Gemmatimonadales bacterium]	diamond	942	103	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			Gemmatimonadales bacterium
29831062	29831062	PRJNA724039_S_NODE_5851_length_285_cov_4.616935_g5644_i0	PRJNA724039	5851	285	4.616935	13.15826475	Longimicrobiales bacterium	2910168	Bacteria	Bacteria	45.4	0.00705	NR	HSG49272.1	2910168	g5644	i0	41.1	1.51578947368421	73	35	70.5	3	267	67	471	541	HSG49272.1 hypothetical protein [Longimicrobiales bacterium]	diamond	432	45.4	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Longimicrobiia	Longimicrobiales			Longimicrobiales bacterium
32612994	32612994	PRJNA724039_S_NODE_2080_length_531_cov_2.026316_g1884_i0	PRJNA724039	2080	531	2.026316	10.75973796	Gemmatimonadales bacterium	2448054	Bacteria	Bacteria	169	1.0399999999999999e-46	NR	MDZ4257988.1	2448054	g1884	i0	52.2	7.99435028248588	178	82	98.9	1	530	6	121	298	MDZ4257988.1 oligosaccharide flippase family protein [Gemmatimonadales bacterium]	diamond	4245	169	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			Gemmatimonadales 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);;