metadata: contig_metadata: 13 rows where bioproject = "PRJEB75230", tax_clade = "FCB group" and tax

13 rows where bioproject = "PRJEB75230", 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
19263572	19263572	PRJEB75230_P_NODE_95676_length_267_cov_1.190722_g95494_i0	PRJEB75230	95676	267	1.190722	3.17922774	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	54.7	0.007	NTclustered	gi\|2874253789\|emb\|OY969773.1\|	412054	g95494	i0	100	0.108614232209738	29	0	11	0	151	179	822182	822154	MAG: uncultured Gemmatimonadales bacterium isolate MFD04580.bin.2.49 genome assembly, chromosome: 1	blastn	29	54.7	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
26939128	26939128	PRJEB75230_P_NODE_85942_length_275_cov_1.099010_g85760_i0	PRJEB75230	85942	275	1.09901	3.0222775	Gemmatimonadota bacterium	2026742	Bacteria	Bacteria	43.1	0.0214	NR	MBI4421445.1	2026742	g85760	i0	50	0.414545454545455	38	19	41.5	0	114	227	75	112	MBI4421445.1 hypothetical protein [Gemmatimonadota bacterium]	diamond	114	43.1	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota					Gemmatimonadota bacterium
27128587	27128587	PRJEB75230_P_NODE_155442_length_245_cov_0.895349_g155260_i0	PRJEB75230	155442	245	0.895349	2.19360505	Gemmatimonadetes bacterium SCN 7	1660163	Bacteria	Bacteria	43.1	0.0283	NR	ODT04080.1	1660163	g155260	i0	38.3	0.575510204081633	47	29	57.6	0	17	157	311	357	ODT04080.1 MAG: hypothetical protein ABS52_06790 [Gemmatimonadetes bacterium SCN 70-22]	diamond	141	43.1	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota					Gemmatimonadetes bacterium SCN 70-22
27128599	27128599	PRJEB75230_P_NODE_32962_length_342_cov_1.141264_g32780_i0	PRJEB75230	32962	342	1.141264	3.90312288	Gemmatimonadales bacterium	2448054	Bacteria	Bacteria	48.1	0.0013	NR	MEX0690478.1	2448054	g32780	i0	36.7	1.3859649122807	79	49	68.4	1	256	23	4	82	MEX0690478.1 ROK family protein [Gemmatimonadales bacterium]	diamond	474	48.1	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			Gemmatimonadales bacterium
27445335	27445335	PRJEB75230_P_NODE_68583_length_290_cov_1.313364_g68401_i0	PRJEB75230	68583	290	1.313364	3.8087556	Gemmatimonadaceae bacterium	2026741	Bacteria	Bacteria	42	0.0425	NR	MFL5614346.1	2026741	g68401	i0	30.9	0.703448275862069	68	45	70.3	1	240	37	47	112	MFL5614346.1 hypothetical protein [Gemmatimonadaceae bacterium]	diamond	204	42	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae		Gemmatimonadaceae bacterium
28139924	28139924	PRJEB75230_P_NODE_140405_length_248_cov_0.880000_g140223_i0	PRJEB75230	140405	248	0.88	2.1824	Longimicrobium sp.	2029185	Bacteria	Bacteria	114	8.48e-28	NR	HET7464503.1	2029185	g140223	i0	72.3	1.00403225806452	83	22	99.2	1	246	1	160	242	HET7464503.1 right-handed parallel beta-helix repeat-containing protein [Longimicrobium sp.]	diamond	249	114	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Longimicrobiia	Longimicrobiales	Longimicrobiaceae	Longimicrobium	Longimicrobium sp.
28992501	28992501	PRJEB75230_P_NODE_184348_length_241_cov_0.910714_g184166_i0	PRJEB75230	184348	241	0.910714	2.19482074	Longimicrobium sp.	2029185	Bacteria	Bacteria	112	9.77e-27	NR	HEX8692819.1	2029185	g184166	i0	68.4	2.95020746887967	79	25	98.3	0	239	3	63	141	HEX8692819.1 DUF262 domain-containing protein [Longimicrobium sp.]	diamond	711	112	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Longimicrobiia	Longimicrobiales	Longimicrobiaceae	Longimicrobium	Longimicrobium sp.
29781507	29781507	PRJEB75230_P_NODE_57871_length_302_cov_1.292576_g57689_i0	PRJEB75230	57871	302	1.292576	3.90357952	Longimicrobium sp.	2029185	Bacteria	Bacteria	43.5	0.0355	NR	WP_331054838.1	2029185	g57689	i0	43.1	0.506622516556291	51	29	50.7	0	138	290	131	181	WP_331054838.1 hypothetical protein [Longimicrobium sp.]	diamond	153	43.5	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Longimicrobiia	Longimicrobiales	Longimicrobiaceae	Longimicrobium	Longimicrobium sp.
29939628	29939628	PRJEB75230_P_NODE_64091_length_295_cov_1.040541_g63909_i0	PRJEB75230	64091	295	1.040541	3.06959595	Gemmatimonadaceae bacterium	2026741	Bacteria	Bacteria	43.5	0.0349	NR	HVB32262.1	2026741	g63909	i0	34.8	0.671186440677966	66	43	67.1	0	47	244	100	165	HVB32262.1 DUF2156 domain-containing protein [Gemmatimonadaceae bacterium]	diamond	198	43.5	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae		Gemmatimonadaceae bacterium
30128695	30128695	PRJEB75230_P_NODE_50232_length_312_cov_0.979079_g50050_i0	PRJEB75230	50232	312	0.979079	3.05472648	Gemmatimonadota bacterium	2026742	Bacteria	Bacteria	43.5	0.0416	NR	MCH7475704.1	2026742	g50050	i0	35.2	0.519230769230769	54	35	51.9	0	150	311	81	134	MCH7475704.1 helicase [Gemmatimonadota bacterium]	diamond	162	43.5	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota					Gemmatimonadota bacterium
30476703	30476703	PRJEB75230_P_NODE_25373_length_363_cov_1.772414_g25191_i0	PRJEB75230	25373	363	1.772414	6.43386282	Gemmatimonadales bacterium	2448054	Bacteria	Bacteria	43.9	0.0247	NR	HLB55388.1	2448054	g25191	i0	43.2	0.363636363636364	44	25	36.4	0	152	283	95	138	HLB55388.1 DUF433 domain-containing protein [Gemmatimonadales bacterium]	diamond	132	43.9	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			Gemmatimonadales bacterium
30855652	30855652	PRJEB75230_P_NODE_173554_length_242_cov_0.911243_g173372_i0	PRJEB75230	173554	242	0.911243	2.20520806	Gemmatimonadales bacterium	2448054	Bacteria	Bacteria	42.7	0.035	NR	MFN8653336.1	2448054	g173372	i0	46.3	0.669421487603306	54	25	66.9	2	219	58	100	149	MFN8653336.1 pyridoxal-phosphate dependent enzyme [Gemmatimonadales bacterium]	diamond	162	42.7	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			Gemmatimonadales bacterium
32405434	32405434	PRJEB75230_P_NODE_106479_length_259_cov_1.096774_g106297_i0	PRJEB75230	106479	259	1.096774	2.84064466	Gemmatimonadaceae bacterium	2026741	Bacteria	Bacteria	44.3	0.0129	NR	HZS57827.1	2026741	g106297	i0	37.9	0.764478764478765	66	38	73	1	59	247	205	270	HZS57827.1 amidohydrolase [Gemmatimonadaceae bacterium]	diamond	198	44.3	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);;