metadata: contig_metadata: 14 rows where bioproject = "PRJNA498309", tax_clade = "FCB group" and tax

14 rows where bioproject = "PRJNA498309", 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
1756218	1756218	PRJNA498309_P_NODE_67642_length_295_cov_2.104651_g65493_i0	PRJNA498309	67642	295	2.104651	6.20872045	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	318	2.439999999999999e-82	NTclustered	gi\|2874253938\|emb\|OY970263.1\|	412054	g65493	i0	90.079	71.8745762711864	252	16	85	6	23	273	802189	802432	MAG: uncultured Gemmatimonadales bacterium isolate MFD02416.bin.2.26 genome assembly, chromosome: 1	blastn	21203	318	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
4308376	4308376	PRJNA498309_P_NODE_90944_length_217_cov_1.905556_g88795_i0	PRJNA498309	90944	217	1.905556	4.13505652	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	119	1.86e-22	NTclustered	gi\|2874253978\|emb\|OY970303.1\|	412054	g88795	i0	78.771	2.50230414746544	179	36	82	2	17	193	6091244	6091066	MAG: uncultured Gemmatimonadales bacterium isolate MFD01275.bin.c.12 genome assembly, chromosome: 1	blastn	543	119	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
10685893	10685893	PRJNA498309_S_NODE_28709_length_316_cov_37.494662_g26541_i0	PRJNA498309	28709	316	37.494662	118.48313192	Gemmatirosa kalamazoonensis	861299	Bacteria	Bacteria	342	1.5699999999999999e-89	NTclustered	gi\|575456455\|gb\|CP007128.1\|	861299	g26541	i0	93.534	245.354430379747	232	11	73	4	68	297	3043199	3042970	Gemmatirosa kalamazoonesis strain KBS708, complete genome	blastn	77532	342	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatirosa	Gemmatirosa kalamazoonensis
10686495	10686495	PRJNA498309_S_NODE_9829_length_813_cov_8.407455_g8085_i0	PRJNA498309	9829	813	8.407455	68.35260915	Gemmatirosa kalamazoonensis	861299	Bacteria	Bacteria	1105	0	NTclustered	gi\|575456455\|gb\|CP007128.1\|	861299	g8085	i0	91.929	203.671586715867	793	58	97	6	4	794	3043758	3042970	Gemmatirosa kalamazoonesis strain KBS708, complete genome	blastn	165585	1105	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatirosa	Gemmatirosa kalamazoonensis
15783541	15783541	PRJNA498309_P_NODE_49113_length_381_cov_4.436047_g46975_i0	PRJNA498309	49113	381	4.436047	16.90133907	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	588	2.2399999999999998e-163	NTclustered	gi\|2874253978\|emb\|OY970303.1\|	412054	g46975	i0	95.722	145.826771653543	374	0	94	2	1	358	1903676	1904049	MAG: uncultured Gemmatimonadales bacterium isolate MFD01275.bin.c.12 genome assembly, chromosome: 1	blastn	55560	588	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
22156745	22156745	PRJNA498309_P_NODE_110458_length_172_cov_1.318519_g108309_i0	PRJNA498309	110458	172	1.318519	2.26785268	FCB group	1783270	Bacteria	Bacteria	89	4.980000000000001e-21	NR	HEX3160727.1	2026741	g108309	i0	78.7	2.63372093023256	47	10	82	0	170	30	56	102	HEX3160727.1 alpha-amylase family glycosyl hydrolase [Gemmatimonadaceae bacterium]	diamond	453	89	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae		Gemmatimonadaceae bacterium
26712428	26712428	PRJNA498309_P_NODE_28161_length_539_cov_2.079681_g26193_i0	PRJNA498309	28161	539	2.079681	11.20948059	FCB group	1783270	Bacteria	Bacteria	83.2	1.11e-17	NR	MEW5926994.1	2026742	g26193	i0	73.6	1.59183673469388	53	14	29.5	0	69	227	6	58	MEW5926994.1 YjzC family protein [Gemmatimonadota bacterium]	diamond	858	84	0.990476190476191	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota					Gemmatimonadota bacterium
27487882	27487882	PRJNA498309_P_NODE_48483_length_385_cov_1.870690_g46346_i0	PRJNA498309	48483	385	1.87069	7.2021565	Gemmatimonadaceae bacterium	2026741	Bacteria	Bacteria	136	1.01e-35	NR	HEV8362425.1	2026741	g46346	i0	68.8	3.24155844155844	93	28	72.5	1	381	103	208	299	HEV8362425.1 UDP-galactopyranose mutase [Gemmatimonadaceae bacterium]	diamond	1248	136	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae		Gemmatimonadaceae bacterium
28719275	28719275	PRJNA498309_P_NODE_49607_length_378_cov_32.331378_g47466_i0	PRJNA498309	49607	378	32.331378	122.21260884	Gemmatimonadales bacterium	2448054	Bacteria	Bacteria	73.9	1.88e-12	NR	HEV8122923.1	2448054	g47466	i0	67.3	0.873015873015873	55	18	43.7	0	374	210	427	481	HEV8122923.1 pitrilysin family protein [Gemmatimonadales bacterium]	diamond	330	73.9	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			Gemmatimonadales bacterium
29919202	29919202	PRJNA498309_P_NODE_26371_length_559_cov_7.789272_g24418_i0	PRJNA498309	26371	559	7.789272	43.54203048	Longimicrobiales bacterium	2910168	Bacteria	Bacteria	87.8	2.11e-16	NR	HEX6939552.1	2910168	g24418	i0	45.3	1.16457960644007	106	57	56.4	1	357	43	358	463	HEX6939552.1 phage tail protein [Longimicrobiales bacterium]	diamond	651	87.8	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Longimicrobiia	Longimicrobiales			Longimicrobiales bacterium
30330315	30330315	PRJNA498309_S_NODE_47532_length_175_cov_4.257143_g45364_i0	PRJNA498309	47532	175	4.257143	7.45000025	Gemmatimonadaceae bacterium	2026741	Bacteria	Bacteria	62.4	1.75e-9	NR	HKO15694.1	2026741	g45364	i0	59.6	0.891428571428571	52	13	89.1	1	157	2	385	428	HKO15694.1 hypothetical protein [Gemmatimonadaceae bacterium]	diamond	156	62.4	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae		Gemmatimonadaceae bacterium
30393479	30393479	PRJNA498309_S_NODE_37953_length_226_cov_3.701571_g35785_i0	PRJNA498309	37953	226	3.701571	8.36555046	Gemmatimonadaceae bacterium	2026741	Bacteria	Bacteria	40.4	0.0376	NR	MEO8881459.1	2026741	g35785	i0	41.7	0.79646017699115	60	30	77	3	20	193	15	71	MEO8881459.1 DUF3565 domain-containing protein [Gemmatimonadaceae bacterium]	diamond	180	40.4	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae		Gemmatimonadaceae bacterium
30756110	30756110	PRJNA498309_P_NODE_105954_length_181_cov_1.458333_g103805_i0	PRJNA498309	105954	181	1.458333	2.63958273	Longimicrobium	1804994	Bacteria	Bacteria	51.6	1.11e-5	NR	HEX8245545.1	2029185	g103805	i0	50.8	2.98342541436464	61	26	96.1	2	176	3	219	278	HEX8245545.1 hypothetical protein [Longimicrobium sp.]	diamond	540	51.6	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Longimicrobiia	Longimicrobiales	Longimicrobiaceae	Longimicrobium	Longimicrobium sp.
31846954	31846954	PRJNA498309_P_NODE_27377_length_547_cov_38.531373_g25414_i0	PRJNA498309	27377	547	38.531373	210.76661031	Gemmatimonadota bacterium	2026742	Bacteria	Bacteria	127	2.4299999999999998e-34	NR	MDQ3223275.1	2026742	g25414	i0	65	0.548446069469835	100	35	54.8	0	58	357	1	100	MDQ3223275.1 hypothetical protein [Gemmatimonadota bacterium]	diamond	300	127	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);;