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

9 rows where bioproject = "PRJNA1226487", 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
1609584	1609584	PRJNA1226487_P_NODE_42102_length_285_cov_1.452830_g42000_i0	PRJNA1226487	42102	285	1.45283	4.1405655	Gemmatimonadales bacterium	2448054	Bacteria	Bacteria	159	1.2999999999999999e-46	NR	MFI5234654.1	2448054	g42000	i0	93.6	1.95789473684211	94	6	98.9	0	2	283	106	199	MFI5234654.1 PspA/IM30 family protein [Gemmatimonadales bacterium]	diamond	558	159	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			Gemmatimonadales bacterium
4161989	4161989	PRJNA1226487_P_NODE_54224_length_266_cov_1.595855_g54122_i0	PRJNA1226487	54224	266	1.595855	4.2449743	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	209	1.36e-49	NTclustered	gi\|2874253755\|emb\|OY969695.1\|	412054	g54122	i0	81.203	65.6578947368421	266	44	99	6	3	265	315851	315589	MAG: uncultured Gemmatimonadales bacterium isolate MFD04967.bin.1.34 genome assembly, chromosome: 1	blastn	17465	209	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
25273003	25273003	PRJNA1226487_P_NODE_65200_length_250_cov_1.740113_g65098_i0	PRJNA1226487	65200	250	1.740113	4.3502825	Gemmatirosa	1706036	Bacteria	Bacteria	219	2.11e-52	NTclustered	gi\|2874254107\|emb\|OY970192.1\|	412054	g65098	i0	82.54	14.976	252	40	100	4	1	250	5382749	5382500	MAG: uncultured Gemmatimonadales bacterium isolate MFD01721.bin.c.5 genome assembly, chromosome: 1	blastn	3744	219	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
29661711	29661711	PRJNA1226487_P_NODE_44190_length_282_cov_1.473684_g44088_i0	PRJNA1226487	44190	282	1.473684	4.15578888	Gemmatimonadota bacterium	2026742	Bacteria	Bacteria	53.5	9.78e-6	NR	MBK7908708.1	2026742	g44088	i0	28.6	0.893617021276596	84	60	89.4	0	16	267	74	157	MBK7908708.1 hypothetical protein [Gemmatimonadota bacterium]	diamond	252	53.5	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota					Gemmatimonadota bacterium
31273454	31273454	PRJNA1226487_P_NODE_47255_length_277_cov_1.509804_g47153_i0	PRJNA1226487	47255	277	1.509804	4.18215708	Longimicrobiaceae bacterium	3047548	Bacteria	Bacteria	62.8	5e-9	NR	HKP77071.1	3047548	g47153	i0	44.1	1.0072202166065	93	48	96.4	2	272	6	406	498	HKP77071.1 hypothetical protein [Longimicrobiaceae bacterium]	diamond	279	62.8	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Longimicrobiia	Longimicrobiales	Longimicrobiaceae		Longimicrobiaceae bacterium
32032671	32032671	PRJNA1226487_P_NODE_66578_length_249_cov_1.750000_g66476_i0	PRJNA1226487	66578	249	1.75	4.3575	Longimicrobium sp.	2029185	Bacteria	Bacteria	148	2.36e-40	NR	HEX2081522.1	2029185	g66476	i0	80.5	0.987951807228916	82	16	98.8	0	3	248	291	372	HEX2081522.1 hypothetical protein [Longimicrobium sp.]	diamond	246	148	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Longimicrobiia	Longimicrobiales	Longimicrobiaceae	Longimicrobium	Longimicrobium sp.
32317701	32317701	PRJNA1226487_P_NODE_81739_length_226_cov_2.013072_g81637_i0	PRJNA1226487	81739	226	2.013072	4.54954272	Gemmatimonadaceae bacterium	2026741	Bacteria	Bacteria	59.3	1.37e-9	NR	HMA03929.1	2026741	g81637	i0	84.2	0.504424778761062	38	6	50.4	0	111	224	23	60	HMA03929.1 hypothetical protein [Gemmatimonadaceae bacterium]	diamond	114	59.3	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae		Gemmatimonadaceae bacterium
32790679	32790679	PRJNA1226487_P_NODE_40240_length_288_cov_1.432558_g40138_i0	PRJNA1226487	40240	288	1.432558	4.12576704	Gemmatimonadaceae bacterium	2026741	Bacteria	Bacteria	138	3.16e-39	NR	HVZ49546.1	2026741	g40138	i0	97.2	1.63541666666667	72	2	75	0	73	288	1	72	HVZ49546.1 DUF4199 domain-containing protein [Gemmatimonadaceae bacterium]	diamond	471	138	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae		Gemmatimonadaceae bacterium
32822380	32822380	PRJNA1226487_P_NODE_54780_length_265_cov_1.604167_g54678_i0	PRJNA1226487	54780	265	1.604167	4.25104255	Gemmatimonadales bacterium	2448054	Bacteria	Bacteria	148	3.54e-39	NR	HEV2290997.1	2448054	g54678	i0	86.4	1.99245283018868	88	12	99.6	0	2	265	452	539	HEV2290997.1 helicase C-terminal domain-containing protein [Gemmatimonadales bacterium]	diamond	528	148	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);;