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

11 rows where bioproject = "PRJNA1144090", 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
4114451	4114451	PRJNA1144090_P_NODE_55804_length_340_cov_2.037453_g55269_i0	PRJNA1144090	55804	340	2.037453	6.9273402	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	54.7	0.009	NTclustered	gi\|2874253978\|emb\|OY970303.1\|	412054	g55269	i0	100	0.423529411764706	29	0	9	0	215	243	7334695	7334667	MAG: uncultured Gemmatimonadales bacterium isolate MFD01275.bin.c.12 genome assembly, chromosome: 1	blastn	144	54.7	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
26785837	26785837	PRJNA1144090_P_NODE_60641_length_326_cov_1.561265_g60106_i0	PRJNA1144090	60641	326	1.561265	5.0897239	Gemmatimonadaceae bacterium	2026741	Bacteria	Bacteria	47.8	0.00173	NR	HKV51836.1	2026741	g60106	i0	45	0.552147239263804	60	30	53.4	2	142	315	895	953	HKV51836.1 ankyrin repeat domain-containing protein [Gemmatimonadaceae bacterium]	diamond	180	47.8	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae		Gemmatimonadaceae bacterium
26943832	26943832	PRJNA1144090_P_NODE_52922_length_350_cov_1.808664_g52387_i0	PRJNA1144090	52922	350	1.808664	6.330324	Gemmatimonadota bacterium	2026742	Bacteria	Bacteria	75.1	5.44e-13	NR	PYP23140.1	2026742	g52387	i0	39.1	3.94285714285714	115	55	98.6	1	6	350	24	123	PYP23140.1 MAG: sodium-translocating pyrophosphatase, partial [Gemmatimonadota bacterium]	diamond	1380	75.1	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota					Gemmatimonadota bacterium
27702649	27702649	PRJNA1144090_P_NODE_59264_length_330_cov_1.198444_g58729_i0	PRJNA1144090	59264	330	1.198444	3.9548652	Gemmatimonadaceae bacterium	2026741	Bacteria	Bacteria	69.3	4.79e-11	NR	HMA01782.1	2026741	g58729	i0	35.7	5.09090909090909	112	63	97.3	3	5	325	537	644	HMA01782.1 serine hydrolase [Gemmatimonadaceae bacterium]	diamond	1680	69.3	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae		Gemmatimonadaceae bacterium
28081109	28081109	PRJNA1144090_P_NODE_60945_length_325_cov_1.813492_g60410_i0	PRJNA1144090	60945	325	1.813492	5.893849	Gemmatimonadota bacterium	2026742	Bacteria	Bacteria	82.8	2.52e-16	NR	MEK6609544.1	2026742	g60410	i0	45.3	3.87692307692308	106	52	97.8	3	320	3	21	120	MEK6609544.1 malate synthase A [Gemmatimonadota bacterium]	diamond	1260	82.8	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota					Gemmatimonadota bacterium
28333769	28333769	PRJNA1144090_P_NODE_50186_length_360_cov_2.554007_g49651_i0	PRJNA1144090	50186	360	2.554007	9.1944252	Gemmatimonadaceae bacterium	2026741	Bacteria	Bacteria	164	1.66e-44	NR	HXT48020.1	2026741	g49651	i0	68.8	7.44166666666667	112	35	93.3	0	359	24	618	729	HXT48020.1 aminomethyl-transferring glycine dehydrogenase [Gemmatimonadaceae bacterium]	diamond	2679	164	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae		Gemmatimonadaceae bacterium
29218014	29218014	PRJNA1144090_P_NODE_100789_length_250_cov_0.870056_g100254_i0	PRJNA1144090	100789	250	0.870056	2.17514	Longimicrobiales bacterium	2910168	Bacteria	Bacteria	85.9	9.89e-18	NR	MDT8370069.1	2910168	g100254	i0	51.2	2.004	82	36	98.4	3	250	5	128	205	MDT8370069.1 peptidyl-alpha-hydroxyglycine alpha-amidating lyase family protein [Longimicrobiales bacterium]	diamond	501	85.9	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Longimicrobiia	Longimicrobiales			Longimicrobiales bacterium
29312637	29312637	PRJNA1144090_P_NODE_91649_length_262_cov_1.624339_g91114_i0	PRJNA1144090	91649	262	1.624339	4.25576818	Gemmatimonadota bacterium	2026742	Bacteria	Bacteria	62.4	3.75e-9	NR	MCH9015900.1	2026742	g91114	i0	49.4	1.77480916030534	77	35	85.9	2	227	3	114	188	MCH9015900.1 SDR family oxidoreductase [Gemmatimonadota bacterium]	diamond	465	62.4	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota					Gemmatimonadota bacterium
30659740	30659740	PRJNA1144090_P_NODE_114773_length_242_cov_0.911243_g114238_i0	PRJNA1144090	114773	242	0.911243	2.20520806	Gemmatimonas	173479	Bacteria	Bacteria	146	2.06e-39	NR	WP_012682223.1	173480	g114238	i0	82.3	14.8636363636364	79	14	97.9	0	242	6	107	185	WP_012682223.1 methionine--tRNA ligase [Gemmatimonas aurantiaca]	diamond	3597	147	0.993197278911565	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatimonas	Gemmatimonas aurantiaca
30860359	30860359	PRJNA1144090_P_NODE_110314_length_244_cov_1.801170_g109779_i0	PRJNA1144090	110314	244	1.80117	4.3948548	Longimicrobium sp.	2029185	Bacteria	Bacteria	46.6	0.00141	NR	HET7461886.1	2029185	g109779	i0	44.4	1.34016393442623	54	26	61.5	1	242	93	7	60	HET7461886.1 zinc ribbon domain-containing protein [Longimicrobium sp.]	diamond	327	46.6	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Longimicrobiia	Longimicrobiales	Longimicrobiaceae	Longimicrobium	Longimicrobium sp.
32220285	32220285	PRJNA1144090_P_NODE_75578_length_290_cov_2.654378_g75043_i0	PRJNA1144090	75578	290	2.654378	7.6976962	Gemmatimonadales bacterium	2448054	Bacteria	Bacteria	90.5	8.44e-19	NR	HEX9488130.1	2448054	g75043	i0	41.7	3.97241379310345	96	55	99.3	1	290	3	206	300	HEX9488130.1 multicopper oxidase family protein [Gemmatimonadales bacterium]	diamond	1152	90.5	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);;