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

15 rows where bioproject = "PRJNA849822", 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
7216636	7216636	PRJNA849822_P_NODE_12766_length_411_cov_2.520710_g12592_i0	PRJNA849822	12766	411	2.52071	10.3601181	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	508	1.95e-139	NTclustered	gi\|2874253938\|emb\|OY970263.1\|	412054	g12592	i0	88.942	64.2895377128954	416	40	100	6	1	411	802709	802295	MAG: uncultured Gemmatimonadales bacterium isolate MFD02416.bin.2.26 genome assembly, chromosome: 1	blastn	26423	508	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
25064688	25064688	PRJNA849822_P_NODE_15140_length_374_cov_1.139535_g14966_i0	PRJNA849822	15140	374	1.139535	4.2618609	Gemmatimonadales bacterium	2448054	Bacteria	Bacteria	152	8.48e-40	NR	TFG45556.1	2448054	g14966	i0	63.1	1.98128342245989	122	44	97.9	1	367	2	31	151	TFG45556.1 MAG: aminomethyl-transferring glycine dehydrogenase [Gemmatimonadales bacterium]	diamond	741	152	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			Gemmatimonadales bacterium
26611554	26611554	PRJNA849822_P_NODE_14421_length_384_cov_1.376206_g14247_i0	PRJNA849822	14421	384	1.376206	5.28463104	Gemmatimonadales bacterium	2448054	Bacteria	Bacteria	54.3	1.7e-5	NR	NIM48975.1	2448054	g14247	i0	42.5	1.4375	80	41	62.5	2	348	109	523	597	NIM48975.1 tandem-95 repeat protein [Gemmatimonadales bacterium]	diamond	552	54.3	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			Gemmatimonadales bacterium
28191687	28191687	PRJNA849822_P_NODE_25666_length_287_cov_1.285047_g25492_i0	PRJNA849822	25666	287	1.285047	3.68808489	Gemmatimonadota bacterium	2026742	Bacteria	Bacteria	46.2	0.00342	NR	PYP41186.1	2026742	g25492	i0	57.9	0.397212543554007	38	16	39.7	0	14	127	255	292	PYP41186.1 MAG: esterase [Gemmatimonadota bacterium]	diamond	114	46.2	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota					Gemmatimonadota bacterium
28697343	28697343	PRJNA849822_P_NODE_8767_length_510_cov_1.599542_g8595_i0	PRJNA849822	8767	510	1.599542	8.1576642	Gemmatimonadaceae bacterium	2026741	Bacteria	Bacteria	56.6	7.61e-6	NR	NUQ12585.1	2026741	g8595	i0	33.9	0.970588235294118	165	104	97.1	4	3	497	96	255	NUQ12585.1 carboxypeptidase regulatory-like domain-containing protein [Gemmatimonadaceae bacterium]	diamond	495	56.6	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae		Gemmatimonadaceae bacterium
29580852	29580852	PRJNA849822_P_NODE_11430_length_438_cov_1.068493_g11256_i0	PRJNA849822	11430	438	1.068493	4.67999934	Gemmatimonadota bacterium	2026742	Bacteria	Bacteria	93.2	7.64e-19	NR	MBM3956824.1	2026742	g11256	i0	42.4	4.9041095890411	151	79	98.6	4	432	1	53	202	MBM3956824.1 tandem-95 repeat protein [Gemmatimonadota bacterium]	diamond	2148	93.2	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota					Gemmatimonadota bacterium
29738812	29738812	PRJNA849822_P_NODE_41390_length_244_cov_0.912281_g41216_i0	PRJNA849822	41390	244	0.912281	2.22596564	Gemmatimonadales bacterium	2448054	Bacteria	Bacteria	70.1	9.09e-12	NR	HEY7028701.1	2448054	g41216	i0	44.7	0.934426229508197	76	42	93.4	0	1	228	2760	2835	HEY7028701.1 Ig-like domain-containing protein [Gemmatimonadales bacterium]	diamond	228	70.1	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			Gemmatimonadales bacterium
29873694	29873694	PRJNA849822_P_NODE_10051_length_472_cov_1.441103_g9878_i0	PRJNA849822	10051	472	1.441103	6.80200616	Bacteria	2	Bacteria	Bacteria	53.9	1.62e-6	NR	KPJ81927.1	1703356	g9878	i0	39.7	3.29872881355932	63	36	40	1	193	5	2	62	KPJ81927.1 MAG: cold-shock protein [Gemmatimonas sp. SG8_23]	diamond	1557	53.9	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatimonas	Gemmatimonas sp. SG8_23
30244658	30244658	PRJNA849822_P_NODE_42512_length_243_cov_0.917647_g42338_i0	PRJNA849822	42512	243	0.917647	2.22988221	Gemmatimonadales bacterium	2448054	Bacteria	Bacteria	77.4	2.37e-14	NR	MEP7175361.1	2448054	g42338	i0	55.6	7.11111111111111	63	28	77.8	0	192	4	46	108	MEP7175361.1 glycoside hydrolase family 38 C-terminal domain-containing protein [Gemmatimonadales bacterium]	diamond	1728	77.4	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			Gemmatimonadales bacterium
31508810	31508810	PRJNA849822_P_NODE_23816_length_297_cov_1.044643_g23642_i0	PRJNA849822	23816	297	1.044643	3.10258971	Gemmatimonadaceae bacterium	2026741	Bacteria	Bacteria	58.9	1.44e-7	NR	HTJ23456.1	2026741	g23642	i0	42	0.818181818181818	81	45	79.8	2	40	276	6	86	HTJ23456.1 serine/threonine-protein kinase [Gemmatimonadaceae bacterium]	diamond	243	58.9	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae		Gemmatimonadaceae bacterium
31517107	31517107	PRJNA849822_P_NODE_30176_length_266_cov_1.461140_g30002_i0	PRJNA849822	30176	266	1.46114	3.8866324	Pseudomonadati	3379134	Bacteria	Bacteria	82	6.74e-16	NR	MEN8375436.1	2026742	g30002	i0	73.1	1.17293233082707	52	14	58.6	0	156	1	176	227	MEN8375436.1 M28 family metallopeptidase [Gemmatimonadota bacterium]	diamond	312	82	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota					Gemmatimonadota bacterium
31761697	31761697	PRJNA849822_P_NODE_7617_length_554_cov_1.854470_g7445_i0	PRJNA849822	7617	554	1.85447	10.2737638	Gemmatimonadales bacterium	2448054	Bacteria	Bacteria	65.5	9.51e-9	NR	MFN0179133.1	2448054	g7445	i0	28.7	4.09927797833935	174	113	92.1	5	44	553	334	500	MFN0179133.1 FAD-binding oxidoreductase [Gemmatimonadales bacterium]	diamond	2271	65.5	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			Gemmatimonadales bacterium
31801388	31801388	PRJNA849822_P_NODE_20257_length_322_cov_0.939759_g20083_i0	PRJNA849822	20257	322	0.939759	3.02602398	Pseudomonadati	3379134	Bacteria	Bacteria	47.8	0.0016	NR	MDH3296795.1	2026742	g20083	i0	37.3	1.04347826086957	67	39	59.6	2	54	245	52	118	MDH3296795.1 choice-of-anchor B family protein [Gemmatimonadota bacterium]	diamond	336	47.8	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota					Gemmatimonadota bacterium
32268105	32268105	PRJNA849822_P_NODE_42678_length_242_cov_1.846154_g42504_i0	PRJNA849822	42678	242	1.846154	4.46769268	Gemmatimonadaceae bacterium	2026741	Bacteria	Bacteria	83.2	2.08e-18	NR	HEY1952955.1	2026741	g42504	i0	55.4	3.65702479338843	74	33	91.7	0	11	232	31	104	HEY1952955.1 Hsp20/alpha crystallin family protein [Gemmatimonadaceae bacterium]	diamond	885	83.2	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae		Gemmatimonadaceae bacterium
32394539	32394539	PRJNA849822_P_NODE_21619_length_312_cov_0.979079_g21445_i0	PRJNA849822	21619	312	0.979079	3.05472648	Gemmatimonadota bacterium	2026742	Bacteria	Bacteria	96.7	4.86e-22	NR	HIF07464.1	2026742	g21445	i0	47.6	0.990384615384615	103	54	99	0	311	3	107	209	HIF07464.1 CAP domain-containing protein [Gemmatimonadota bacterium]	diamond	309	96.7	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);;