metadata: contig_metadata: 8 rows where bioproject = "PRJNA934472", tax_clade = "FCB group" and tax

8 rows where bioproject = "PRJNA934472", 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
911087	911087	PRJNA934472_P_NODE_30621_length_268_cov_2.953846_g30243_i0	PRJNA934472	30621	268	2.953846	7.91630728	Longimicrobiaceae bacterium	3047548	Bacteria	Bacteria	138	2.939999999999999e-38	NR	HET6763448.1	3047548	g30243	i0	79.8	1.99253731343284	89	18	99.6	0	1	267	125	213	HET6763448.1 3-methyl-2-oxobutanoate hydroxymethyltransferase [Longimicrobiaceae bacterium]	diamond	534	138	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Longimicrobiia	Longimicrobiales	Longimicrobiaceae		Longimicrobiaceae bacterium
2186232	2186232	PRJNA934472_P_NODE_20362_length_323_cov_0.948000_g19985_i0	PRJNA934472	20362	323	0.948	3.06204	Gemmatirosa kalamazoonensis	861299	Bacteria	Bacteria	274	5.95e-69	NTclustered	gi\|575456455\|gb\|CP007128.1\|	861299	g19985	i0	82.54	216.907120743034	315	51	97	4	3	314	3044434	3044747	Gemmatirosa kalamazoonesis strain KBS708, complete genome	blastn	70061	274	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatirosa	Gemmatirosa kalamazoonensis
2186409	2186409	PRJNA934472_P_NODE_28542_length_277_cov_1.470588_g28164_i0	PRJNA934472	28542	277	1.470588	4.07352876	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	407	4.72e-109	NTclustered	gi\|2874253728\|emb\|OY969570.1\|	412054	g28164	i0	93.165	190.653429602888	278	17	100	2	1	277	172531	172255	MAG: uncultured Gemmatimonadales bacterium isolate MFD02840.bin.c.1 genome assembly, chromosome: 1	blastn	52811	407	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
6014430	6014430	PRJNA934472_P_NODE_35485_length_250_cov_1.536723_g35107_i0	PRJNA934472	35485	250	1.536723	3.8418075	Pseudogemmatithrix spongiicola	3062599	Bacteria	Bacteria	372	1.53e-98	NTclustered	gi\|2557479348\|gb\|CP130613.1\|	3062599	g35107	i0	93.651	42.98	252	11	100	4	1	250	1552913	1552665	Pseudogemmatithrix spongiicola strain 318 chromosome, complete genome	blastn	10745	372	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Pseudogemmatithrix	Pseudogemmatithrix spongiicola
7289337	7289337	PRJNA934472_P_NODE_37586_length_244_cov_1.801170_g37208_i0	PRJNA934472	37586	244	1.80117	4.3948548	uncultured Gemmatimonadaceae bacterium	246130	Bacteria	Bacteria	263	9.34e-66	NTclustered	gi\|2874253995\|emb\|OY970320.1\|	246130	g37208	i0	86.531	43.0409836065574	245	25	99	8	1	241	231285	231525	MAG: uncultured Gemmatimonadaceae bacterium isolate MFD00031.bin.c.2 genome assembly, chromosome: 1	blastn	10502	263	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae		uncultured Gemmatimonadaceae bacterium
9838658	9838658	PRJNA934472_P_NODE_10368_length_441_cov_2.000000_g9991_i0	PRJNA934472	10368	441	2	8.82	Gemmatirosa kalamazoonensis	861299	Bacteria	Bacteria	577	5.689999999999998e-160	NTclustered	gi\|575456455\|gb\|CP007128.1\|	861299	g9991	i0	90.293	316.648526077098	443	40	100	3	1	441	3043126	3043567	Gemmatirosa kalamazoonesis strain KBS708, complete genome	blastn	139642	577	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatirosa	Gemmatirosa kalamazoonensis
18762878	18762878	PRJNA934472_P_NODE_36815_length_246_cov_1.953757_g36437_i0	PRJNA934472	36815	246	1.953757	4.80624222	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	257	4.39e-64	NTclustered	gi\|2874253789\|emb\|OY969773.1\|	412054	g36437	i0	85.83	1.00406504065041	247	30	99	5	2	246	602350	602593	MAG: uncultured Gemmatimonadales bacterium isolate MFD04580.bin.2.49 genome assembly, chromosome: 1	blastn	247	257	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
25137142	25137142	PRJNA934472_P_NODE_26520_length_286_cov_2.403756_g26142_i0	PRJNA934472	26520	286	2.403756	6.87474216	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	322	1.82e-83	NTclustered	gi\|2874254107\|emb\|OY970192.1\|	412054	g26142	i0	88.489	287.111888111888	278	16	93	15	7	273	1594009	1593737	MAG: uncultured Gemmatimonadales bacterium isolate MFD01721.bin.c.5 genome assembly, chromosome: 1	blastn	82114	322	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured 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);;