metadata: contig_metadata: 7 rows where analysis = "diamond", bioproject = "PRJNA753151" and tax

7 rows where analysis = "diamond", 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
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);;