metadata: contig_metadata: 9 rows where bioproject = "PRJNA944150", tax_clade = "FCB group" and tax

9 rows where bioproject = "PRJNA944150", 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
923730	923730	PRJNA944150_P_NODE_4321_length_412_cov_3.848485_g4071_i0	PRJNA944150	4321	412	3.848485	15.8557582	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	673	0	NTclustered	gi\|2874253789\|emb\|OY969773.1\|	412054	g4071	i0	96.117	129.121359223301	412	16	100	0	1	412	422093	421682	MAG: uncultured Gemmatimonadales bacterium isolate MFD04580.bin.2.49 genome assembly, chromosome: 1	blastn	53198	673	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
6026812	6026812	PRJNA944150_P_NODE_28345_length_180_cov_2.633588_g28094_i0	PRJNA944150	28345	180	2.633588	4.7404584	Gemmatimonadaceae bacterium	2026741	Bacteria	Bacteria	88.2	1.53e-18	NR	MFL5578617.1	2026741	g28094	i0	76.3	2.95	59	10	98.3	1	179	3	372	426	MFL5578617.1 penicillin-binding protein 1A [Gemmatimonadaceae bacterium]	diamond	531	88.2	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae		Gemmatimonadaceae bacterium
21325963	21325963	PRJNA944150_P_NODE_6177_length_345_cov_5.709459_g5926_i0	PRJNA944150	6177	345	5.709459	19.69763355	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	279	1.38e-70	NTclustered	gi\|2874253789\|emb\|OY969773.1\|	412054	g5926	i0	81.818	2.96231884057971	352	46	99	16	3	345	422425	422083	MAG: uncultured Gemmatimonadales bacterium isolate MFD04580.bin.2.49 genome assembly, chromosome: 1	blastn	1022	279	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
24210596	24210596	PRJNA944150_P_NODE_1559_length_661_cov_4.756536_g1347_i0	PRJNA944150	1559	661	4.756536	31.44070296	Gemmatirosa	1706036	Bacteria	Bacteria	728	0	NTclustered	gi\|2874253789\|emb\|OY969773.1\|	412054	g1347	i0	86.787	279.282904689864	666	72	99	15	4	661	420847	421504	MAG: uncultured Gemmatimonadales bacterium isolate MFD04580.bin.2.49 genome assembly, chromosome: 1	blastn	184606	728	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
27063673	27063673	PRJNA944150_P_NODE_43742_length_162_cov_0.902655_g43491_i0	PRJNA944150	43742	162	0.902655	1.4623011	Bacteria	2	Bacteria	Bacteria	50.8	1.59e-5	NR	NUQ13207.1	2026741	g43491	i0	50	3.01851851851852	52	22	90.7	2	16	162	35	85	NUQ13207.1 glycosyltransferase family 8 protein [Gemmatimonadaceae bacterium]	diamond	489	50.8	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae		Gemmatimonadaceae bacterium
27151280	27151280	PRJNA944150_P_NODE_42122_length_163_cov_0.894737_g41871_i0	PRJNA944150	42122	163	0.894737	1.45842131	Gemmatirosa sp.	2510638	Bacteria	Bacteria	87.8	3.27e-21	NR	HEY0776598.1	2510638	g41871	i0	86	0.920245398773006	50	7	92	0	14	163	1	50	HEY0776598.1 AbrB/MazE/SpoVT family DNA-binding domain-containing protein [Gemmatirosa sp.]	diamond	150	87.8	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatirosa	Gemmatirosa sp.
30151408	30151408	PRJNA944150_P_NODE_39712_length_164_cov_2.460870_g39461_i0	PRJNA944150	39712	164	2.46087	4.0358268	Gemmatimonadaceae bacterium	2026741	Bacteria	Bacteria	52.4	2.93e-7	NR	HSJ65562.1	2026741	g39461	i0	75.7	2.03048780487805	37	9	67.7	0	114	4	22	58	HSJ65562.1 exodeoxyribonuclease VII small subunit [Gemmatimonadaceae bacterium]	diamond	333	52.4	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae		Gemmatimonadaceae bacterium
31257539	31257539	PRJNA944150_P_NODE_22195_length_192_cov_2.300699_g21944_i0	PRJNA944150	22195	192	2.300699	4.41734208	Roseisolibacter sp. H3M3-2	3031323	Bacteria	Bacteria	102	1.59e-25	NR	WP_275831109.1	3031323	g21944	i0	72.6	0.96875	62	17	96.9	0	188	3	92	153	WP_275831109.1 BON domain-containing protein [Roseisolibacter sp. H3M3-2]	diamond	186	102	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Roseisolibacter	Roseisolibacter sp. H3M3-2
32143335	32143335	PRJNA944150_P_NODE_29118_length_179_cov_1.361538_g28867_i0	PRJNA944150	29118	179	1.361538	2.43715302	Gemmatimonadales bacterium	2448054	Bacteria	Bacteria	73.9	1.56e-13	NR	HEX5818121.1	2448054	g28867	i0	60.7	1.84357541899441	56	22	93.9	0	179	12	269	324	HEX5818121.1 xanthine dehydrogenase family protein molybdopterin-binding subunit [Gemmatimonadales bacterium]	diamond	330	73.9	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);;