metadata: contig_metadata: 10 rows where bioproject = "PRJNA1166865", tax_clade = "FCB group" and tax

10 rows where bioproject = "PRJNA1166865", 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
20714946	20714946	PRJNA1166865_P_NODE_71777_length_258_cov_1.664865_g71536_i0	PRJNA1166865	71777	258	1.664865	4.2953517	Longimicrobiales bacterium	2910168	Bacteria	Bacteria	56.5	0.002	NTclustered	gi\|2531976028\|emb\|OY282361.1\|	2910168	g71536	i0	100	0.794573643410853	30	0	12	0	122	151	1174853	1174824	MAG: Longimicrobiales bacterium genome assembly, chromosome: 1	blastn	205	56.5	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Longimicrobiia	Longimicrobiales			Longimicrobiales bacterium
26596964	26596964	PRJNA1166865_P_NODE_34101_length_370_cov_3.565657_g33860_i0	PRJNA1166865	34101	370	3.565657	13.1929309	Gemmatimonadaceae bacterium	2026741	Bacteria	Bacteria	87	1.92e-17	NR	MEP7348242.1	2026741	g33860	i0	42.5	0.916216216216216	113	59	88.4	2	43	369	9	119	MEP7348242.1 zinc-binding dehydrogenase [Gemmatimonadaceae bacterium]	diamond	339	87	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae		Gemmatimonadaceae bacterium
27230065	27230065	PRJNA1166865_P_NODE_88663_length_244_cov_0.900585_g88422_i0	PRJNA1166865	88663	244	0.900585	2.1974274	Gemmatimonadota bacterium	2026742	Bacteria	Bacteria	42.7	0.0332	NR	NIP56612.1	2026742	g88422	i0	34.2	0.971311475409836	79	48	93.4	3	242	15	77	154	NIP56612.1 response regulator transcription factor [Gemmatimonadota bacterium]	diamond	237	42.7	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota					Gemmatimonadota bacterium
27249358	27249358	PRJNA1166865_P_NODE_4263_length_975_cov_1.868071_g4108_i0	PRJNA1166865	4263	975	1.868071	18.21369225	Longimicrobium	1804994	Bacteria	Bacteria	147	3.9e-38	NR	WP_329683785.1	2029185	g4108	i0	45.7	1.15076923076923	188	89	57.5	6	342	902	107	282	WP_329683785.1 M15 family metallopeptidase [Longimicrobium sp.]	diamond	1122	148	0.993243243243243	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Longimicrobiia	Longimicrobiales	Longimicrobiaceae	Longimicrobium	Longimicrobium sp.
27388319	27388319	PRJNA1166865_P_NODE_34143_length_370_cov_1.835017_g33902_i0	PRJNA1166865	34143	370	1.835017	6.7895629	Gemmatimonadota bacterium	2026742	Bacteria	Bacteria	57.4	1.15e-6	NR	NNE08319.1	2026742	g33902	i0	35.2	0.737837837837838	91	50	68.1	2	106	357	41	129	NNE08319.1 T9SS type A sorting domain-containing protein [Gemmatimonadota bacterium]	diamond	273	57.4	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota					Gemmatimonadota bacterium
27798798	27798798	PRJNA1166865_P_NODE_75544_length_251_cov_0.865169_g75303_i0	PRJNA1166865	75544	251	0.865169	2.17157419	Gemmatimonadota bacterium	2026742	Bacteria	Bacteria	42.7	0.0404	NR	MBV9773693.1	2026742	g75303	i0	39.7	0.752988047808765	63	38	75.3	0	246	58	411	473	MBV9773693.1 redoxin domain-containing protein [Gemmatimonadota bacterium]	diamond	189	42.7	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota					Gemmatimonadota bacterium
29156551	29156551	PRJNA1166865_P_NODE_82309_length_247_cov_2.655172_g82068_i0	PRJNA1166865	82309	247	2.655172	6.55827484	Gemmatimonadales bacterium	2448054	Bacteria	Bacteria	53.1	8.05e-6	NR	HEY7636934.1	2448054	g82068	i0	40	4.44534412955466	70	38	80.2	2	203	6	399	468	HEY7636934.1 leishmanolysin-related zinc metalloendopeptidase [Gemmatimonadales bacterium]	diamond	1098	53.1	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			Gemmatimonadales bacterium
29314162	29314162	PRJNA1166865_P_NODE_21749_length_461_cov_0.793814_g21508_i0	PRJNA1166865	21749	461	0.793814	3.65948254	Gemmatimonadaceae bacterium	2026741	Bacteria	Bacteria	136	9.74e-37	NR	HEU4630450.1	2026741	g21508	i0	55.7	0.852494577006508	131	51	83.9	3	391	5	5	130	HEU4630450.1 aquaporin [Gemmatimonadaceae bacterium]	diamond	393	136	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae		Gemmatimonadaceae bacterium
29806923	29806923	PRJNA1166865_P_NODE_87611_length_245_cov_0.895349_g87370_i0	PRJNA1166865	87611	245	0.895349	2.19360505	Bacteria	2	Bacteria	Bacteria	105	1.21e-26	NR	MFI5246079.1	2448054	g87370	i0	64.2	4.99591836734694	81	29	99.2	0	2	244	65	145	MFI5246079.1 SDR family NAD(P)-dependent oxidoreductase [Gemmatimonadales bacterium]	diamond	1224	105	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			Gemmatimonadales bacterium
30703947	30703947	PRJNA1166865_P_NODE_89474_length_244_cov_0.900585_g89233_i0	PRJNA1166865	89474	244	0.900585	2.1974274	Gemmatimonadota bacterium	2026742	Bacteria	Bacteria	76.6	8.42e-15	NR	MEE8551260.1	2026742	g89233	i0	64.9	0.700819672131147	57	20	70.1	0	171	1	14	70	MEE8551260.1 50S ribosomal protein L1 [Gemmatimonadota bacterium]	diamond	171	76.6	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);;