metadata: contig_metadata: 15 rows where bioproject = "PRJNA1227535", tax_clade = "FCB group" and tax

15 rows where bioproject = "PRJNA1227535", 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
335511	335511	PRJNA1227535_P_NODE_5901_length_312_cov_4.376569_g5778_i0	PRJNA1227535	5901	312	4.376569	13.65489528	Gemmatimonadota bacterium	2026742	Bacteria	Bacteria	171	1.9499999999999993e-52	NR	MFS8636829.1	2026742	g5778	i0	91.3	0.990384615384615	103	5	99	1	3	311	39	137	MFS8636829.1 rod shape-determining protein MreD [Gemmatimonadota bacterium]	diamond	309	171	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota					Gemmatimonadota bacterium
335522	335522	PRJNA1227535_P_NODE_6561_length_312_cov_3.246862_g6438_i0	PRJNA1227535	6561	312	3.246862	10.13020944	Gemmatimonadota bacterium	2026742	Bacteria	Bacteria	98.2	2.88e-21	NR	MFS8637428.1	2026742	g6438	i0	81.2	0.663461538461538	69	12	65.4	1	3	206	331	399	MFS8637428.1 BamA/TamA family outer membrane protein [Gemmatimonadota bacterium]	diamond	207	98.2	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota					Gemmatimonadota bacterium
3597517	3597517	PRJNA1227535_P_NODE_23343_length_251_cov_1.331461_g23219_i0	PRJNA1227535	23343	251	1.331461	3.34196711	FCB group	1783270	Bacteria	Bacteria	129	3.97e-33	NR	HSU95088.1	2026741	g23219	i0	72.3	9.8725099601593609	83	22	98	1	249	4	233	315	HSU95088.1 Fic family protein [Gemmatimonadaceae bacterium]	diamond	2478	129	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae		Gemmatimonadaceae bacterium
4162480	4162480	PRJNA1227535_P_NODE_32924_length_228_cov_3.329032_g32800_i0	PRJNA1227535	32924	228	3.329032	7.59019296	Gemmatirosa kalamazoonensis	861299	Bacteria	Bacteria	206	1.4699999999999998e-48	NTclustered	gi\|575456455\|gb\|CP007128.1\|	861299	g32800	i0	90	12.5964912280702	160	15	70	1	60	219	3595804	3595962	Gemmatirosa kalamazoonesis strain KBS708, complete genome	blastn	2872	206	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatirosa	Gemmatirosa kalamazoonensis
7988798	7988798	PRJNA1227535_P_NODE_26967_length_246_cov_2.491329_g26843_i0	PRJNA1227535	26967	246	2.491329	6.12866934	Gemmatirosa kalamazoonensis	861299	Bacteria	Bacteria	163	9.84e-36	NTclustered	gi\|575456455\|gb\|CP007128.1\|	861299	g26843	i0	79.051	1.02845528455285	253	41	99	11	3	246	3093691	3093940	Gemmatirosa kalamazoonesis strain KBS708, complete genome	blastn	253	163	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatirosa	Gemmatirosa kalamazoonensis
10539392	10539392	PRJNA1227535_P_NODE_6789_length_312_cov_3.075314_g6666_i0	PRJNA1227535	6789	312	3.075314	9.59497968	Gemmatimonadales bacterium	2448054	Bacteria	Bacteria	93.6	3.01e-20	NR	HWB41250.1	2448054	g6666	i0	87.8	1.55769230769231	49	6	47.1	0	164	310	5	53	HWB41250.1 FG-GAP-like repeat-containing protein [Gemmatimonadales bacterium]	diamond	486	93.6	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			Gemmatimonadales bacterium
15074519	15074519	PRJNA1227535_P_NODE_17632_length_266_cov_1.616580_g17509_i0	PRJNA1227535	17632	266	1.61658	4.3001028	Gemmatimonadetes bacterium T265	2839016	Bacteria	Bacteria	127	3.2e-35	NR	GJG85273.1	2839016	g17509	i0	88	0.845864661654135	75	9	84.6	0	41	265	1	75	GJG85273.1 hypothetical protein tb265_04540 [Gemmatimonadetes bacterium T265]	diamond	225	127	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota					Gemmatimonadetes bacterium T265
18186769	18186769	PRJNA1227535_P_NODE_18255_length_264_cov_1.853403_g18131_i0	PRJNA1227535	18255	264	1.853403	4.89298392	Longimicrobium sp.	2029185	Bacteria	Bacteria	136	4.73e-35	NR	HEX8432664.1	2029185	g18131	i0	77	0.988636363636364	87	20	98.9	0	262	2	491	577	HEX8432664.1 class I SAM-dependent DNA methyltransferase [Longimicrobium sp.]	diamond	261	136	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Longimicrobiia	Longimicrobiales	Longimicrobiaceae	Longimicrobium	Longimicrobium sp.
19461158	19461158	PRJNA1227535_P_NODE_14156_length_278_cov_1.482927_g14033_i0	PRJNA1227535	14156	278	1.482927	4.12253706	Gemmatimonadaceae bacterium	2026741	Bacteria	Bacteria	162	1.84e-45	NR	HET7553900.1	2026741	g14033	i0	85.7	3.91726618705036	91	13	98.2	0	6	278	205	295	HET7553900.1 leucyl aminopeptidase [Gemmatimonadaceae bacterium]	diamond	1089	162	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae		Gemmatimonadaceae bacterium
23287447	23287447	PRJNA1227535_P_NODE_15739_length_272_cov_2.989950_g15616_i0	PRJNA1227535	15739	272	2.98995	8.132664	Gemmatimonadota	142182	Bacteria	Bacteria	78.2	1.58e-14	NR	CAA9343818.1	246130	g15616	i0	48.7	4.05882352941176	78	22	66.2	1	4	183	314	391	CAA9343818.1 MAG: Glucose-1-phosphate adenylyltransferase [uncultured Gemmatimonadaceae bacterium]	diamond	1104	78.2	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae		uncultured Gemmatimonadaceae bacterium
27957195	27957195	PRJNA1227535_P_NODE_6885_length_312_cov_3.016736_g6762_i0	PRJNA1227535	6885	312	3.016736	9.41221632	Gemmatimonadetes bacterium T265	2839016	Bacteria	Bacteria	89.7	4.78e-19	NR	GJG87996.1	2839016	g6762	i0	86	0.480769230769231	50	7	48.1	0	310	161	152	201	GJG87996.1 prolipoprotein diacylglyceryl transferase [Gemmatimonadetes bacterium T265]	diamond	150	89.7	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota					Gemmatimonadetes bacterium T265
29049553	29049553	PRJNA1227535_P_NODE_23208_length_251_cov_1.752809_g23084_i0	PRJNA1227535	23208	251	1.752809	4.39955059	Bacteria	2	Bacteria	Bacteria	61.2	1.2e-8	NR	HEX2717020.1	2026741	g23084	i0	72.2	1.43426294820717	36	10	43	0	120	13	353	388	HEX2717020.1 thioredoxin-like domain-containing protein [Gemmatimonadaceae bacterium]	diamond	360	61.6	0.993506493506494	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae		Gemmatimonadaceae bacterium
30641313	30641313	PRJNA1227535_P_NODE_20313_length_257_cov_2.755435_g20189_i0	PRJNA1227535	20313	257	2.755435	7.08146795	Gemmatimonadales bacterium	2448054	Bacteria	Bacteria	77.8	8.74e-17	NR	HSE45955.1	2448054	g20189	i0	51.6	0.723735408560311	62	30	72.4	0	70	255	1	62	HSE45955.1 DJ-1/PfpI family protein [Gemmatimonadales bacterium]	diamond	186	77.8	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			Gemmatimonadales bacterium
31684478	31684478	PRJNA1227535_P_NODE_9557_length_294_cov_2.619910_g9434_i0	PRJNA1227535	9557	294	2.61991	7.7025354	Gemmatimonadales bacterium	2448054	Bacteria	Bacteria	90.9	4.5e-19	NR	HEY8257470.1	2448054	g9434	i0	87.8	1.5	49	6	50	0	146	292	298	346	HEY8257470.1 glycosyltransferase family 4 protein [Gemmatimonadales bacterium]	diamond	441	90.9	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			Gemmatimonadales bacterium
31734850	31734850	PRJNA1227535_P_NODE_6497_length_312_cov_3.309623_g6374_i0	PRJNA1227535	6497	312	3.309623	10.32602376	Bacteria	2	Bacteria	Bacteria	92.8	2.25e-19	NR	MCU0616193.1	2026741	g6374	i0	91.8	1.88461538461538	49	4	47.1	0	311	165	616	664	MCU0616193.1 magnesium chelatase subunit H [Gemmatimonadaceae bacterium]	diamond	588	92.8	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae		Gemmatimonadaceae 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);;