metadata: contig_metadata: 14 rows where bioproject = "PRJNA753151" and tax

14 rows where bioproject = "PRJNA753151" and tax_clade = "FCB group"

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
2477365	2477365	PRJNA753151_S_NODE_97282_length_286_cov_1.666667_g94992_i0	PRJNA753151	97282	286	1.666667	4.76666762	Mucilaginibacter	423349	Bacteria	Bacteria	496	1.02e-135	NTclustered	gi\|1085785005\|emb\|LT629740.1\|	652787	g94992	i0	97.909	370.325174825175	287	4	100	2	1	286	4557803	4558088	Mucilaginibacter mallensis strain MP1X4 genome assembly, chromosome: I	blastn	105913	496	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Sphingobacteriia	Sphingobacteriales	Sphingobacteriaceae	Mucilaginibacter	Mucilaginibacter mallensis
4557880	4557880	PRJNA753151_S_NODE_130244_length_253_cov_2.133333_g127954_i0	PRJNA753151	130244	253	2.133333	5.39733249	Mucilaginibacter sp. 14171R-50	2703789	Bacteria	Bacteria	351	2.02e-92	NTclustered	gi\|1804505538\|gb\|CP048115.1\|	2703789	g127954	i0	92.946	354.288537549407	241	17	95	0	13	253	720517	720757	Mucilaginibacter sp. 14171R-50 chromosome, complete genome	blastn	89635	351	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Sphingobacteriia	Sphingobacteriales	Sphingobacteriaceae	Mucilaginibacter	Mucilaginibacter sp. 14171R-50
13955891	13955891	PRJNA753151_S_NODE_266291_length_172_cov_2.705426_g264001_i0	PRJNA753151	266291	172	2.705426	4.65333272	Flavobacterium	237	Bacteria	Bacteria	63.9	6.66e-6	NTclustered	gi\|2243410383\|gb\|CP097434.1\|	907046	g264001	i0	93.023	5.68023255813953	43	3	25	0	35	77	24576	24618	Flavobacterium sp. B183 chromosome	blastn	977	63.9	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium sp. B183
15230393	15230393	PRJNA753151_S_NODE_161892_length_228_cov_3.470270_g159602_i0	PRJNA753151	161892	228	3.47027	7.9122156	Flavobacterium	237	Bacteria	Bacteria	422	1.34e-113	NTclustered	gi\|1993663771\|gb\|CP068294.1\|	2724135	g159602	i0	100	536.118421052632	228	0	100	0	1	228	807376	807603	Flavobacterium sp. CLA17 chromosome	blastn	122235	422	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium sp. CLA17
17308561	17308561	PRJNA753151_S_NODE_299614_length_160_cov_1.538462_g297324_i0	PRJNA753151	299614	160	1.538462	2.4615392	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	143	7.649999999999998e-30	NTclustered	gi\|2874253728\|emb\|OY969570.1\|	412054	g297324	i0	82.927	129.8625	164	22	100	5	1	160	171767	171606	MAG: uncultured Gemmatimonadales bacterium isolate MFD02840.bin.c.1 genome assembly, chromosome: 1	blastn	20778	143	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
21133270	21133270	PRJNA753151_S_NODE_55737_length_349_cov_10.921569_g53447_i0	PRJNA753151	55737	349	10.921569	38.11627581	uncultured Draconibacterium sp.	1573823	Bacteria	Bacteria	52.8	0.033	NTclustered	gi\|2621784655\|emb\|OY781113.1\|	1573823	g53447	i0	100	0.0802292263610315	28	0	8	0	310	337	425133	425106	MAG: uncultured Draconibacterium sp. isolate abe71d63-47d4-46f6-900f-15657cc07270 genome assembly, chromosome: 1	blastn	28	52.8	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Marinilabiliales	Prolixibacteraceae	Draconibacterium	uncultured Draconibacterium sp.
22879462	22879462	PRJNA753151_S_NODE_210658_length_198_cov_3.483871_g208368_i0	PRJNA753151	210658	198	3.483871	6.89806458	Phocaeicola	909656	Bacteria	Bacteria	366	5.4e-97	NTclustered	gi\|2290438071\|gb\|CP103067.1\|	821	g208368	i0	100	343.651515151515	198	0	100	0	1	198	320284	320481	Phocaeicola vulgatus strain BFG-626 chromosome, complete genome	blastn	68043	366	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Bacteroidaceae	Phocaeicola	Phocaeicola vulgatus
27305924	27305924	PRJNA753151_S_NODE_83443_length_303_cov_5.457692_g81153_i0	PRJNA753151	83443	303	5.457692	16.53680676	Cytophagaceae bacterium	2026729	Bacteria	Bacteria	51.6	3e-5	NR	HWZ21745.1	2026729	g81153	i0	35.2	0.702970297029703	71	43	67.3	1	302	99	118	188	HWZ21745.1 hypothetical protein [Cytophagaceae bacterium]	diamond	213	51.6	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Cytophagaceae		Cytophagaceae bacterium
28252990	28252990	PRJNA753151_S_NODE_298626_length_160_cov_2.307692_g296336_i0	PRJNA753151	298626	160	2.307692	3.6923072	Mucilaginibacter rigui	534635	Bacteria	Bacteria	41.2	0.0413	NR	WP_191174536.1	534635	g296336	i0	63.6	0.4125	22	8	41.3	0	155	90	349	370	WP_191174536.1 SGNH/GDSL hydrolase family protein [Mucilaginibacter rigui]	diamond	66	41.2	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Sphingobacteriia	Sphingobacteriales	Sphingobacteriaceae	Mucilaginibacter	Mucilaginibacter rigui
30147426	30147426	PRJNA753151_S_NODE_53972_length_353_cov_8.661290_g51683_i0	PRJNA753151	53972	353	8.66129	30.5743537	Psychroflexus montanilacus	2873598	Bacteria	Bacteria	44.3	0.0338	NR	WP_224464835.1	2873598	g51683	i0	29.3	0.696883852691218	82	55	67.1	1	79	315	205	286	WP_224464835.1 hypothetical protein [Psychroflexus montanilacus]	diamond	246	44.3	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Psychroflexus	Psychroflexus montanilacus
30179152	30179152	PRJNA753151_S_NODE_152112_length_235_cov_5.192708_g149822_i0	PRJNA753151	152112	235	5.192708	12.2028638	Alistipes sp.	1872444	Bacteria	Bacteria	152	3.289999999999999e-42	NR	MBR0362872.1	1872444	g149822	i0	98.7	0.982978723404255	77	1	98.3	0	233	3	220	296	MBR0362872.1 hypothetical protein [Alistipes sp.]	diamond	231	152	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Rikenellaceae	Alistipes	Alistipes sp.
30210638	30210638	PRJNA753151_S_NODE_312332_length_156_cov_1.194690_g310042_i0	PRJNA753151	312332	156	1.19469	1.8637164	Flavobacterium sp. 123	2135627	Bacteria	Bacteria	42	0.0225	NR	WP_121337442.1	2135627	g310042	i0	40	0.865384615384615	45	27	86.5	0	135	1	2032	2076	WP_121337442.1 HYR domain-containing protein [Flavobacterium sp. 123]	diamond	135	42	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium sp. 123
32076046	32076046	PRJNA753151_S_NODE_117038_length_265_cov_2.581081_g114748_i0	PRJNA753151	117038	265	2.581081	6.83986465	Cecembia lonarensis	645110	Bacteria	Bacteria	169	6.859999999999999e-48	NR	WP_009186673.1	645110	g114748	i0	100	0.984905660377358	87	0	98.5	0	263	3	351	437	WP_009186673.1 helicase HerA-like domain-containing protein [Cecembia lonarensis]	diamond	261	169	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Cyclobacteriaceae	Cecembia	Cecembia lonarensis
32896887	32896887	PRJNA753151_S_NODE_296800_length_161_cov_1.525424_g294510_i0	PRJNA753151	296800	161	1.525424	2.45593264	Prevotellamassilia sp.	1926673	Bacteria	Bacteria	67.4	2.44e-11	NR	MEE0904056.1	1926673	g294510	i0	67.9	0.987577639751553	53	17	98.8	0	161	3	619	671	MEE0904056.1 phage tail tape measure protein [Prevotellamassilia sp.]	diamond	159	67.4	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Prevotellaceae	Prevotellamassilia	Prevotellamassilia sp.

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);;