metadata: contig_metadata: 6 rows where analysis = "diamond", bioproject = "PRJNA951388" and tax

6 rows where analysis = "diamond", bioproject = "PRJNA951388" 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
17840181	17840181	PRJNA951388_S_NODE_3954_length_409_cov_3.782738_g3827_i0	PRJNA951388	3954	409	3.782738	15.47139842	Paludibacteraceae bacterium	2748031	Bacteria	Bacteria	123	1.1299999999999998e-31	NR	MCR5051016.1	2748031	g3827	i0	53.2	8.03178484107579	111	52	81.4	0	408	76	147	257	MCR5051016.1 glucosamine-6-phosphate deaminase [Paludibacteraceae bacterium]	diamond	3285	123	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Paludibacteraceae		Paludibacteraceae bacterium
20061407	20061407	PRJNA951388_S_NODE_2996_length_451_cov_17.867725_g2869_i0	PRJNA951388	2996	451	17.867725	80.58343975	root	1	Root_unresolved	Root_unresolved	187	1.05e-51	NR	WP_334246839.1	466084	g2869	i0	64.6	29.5343680709534	127	45	84.5	0	1	381	829	955	WP_334246839.1 aminomethyl-transferring glycine dehydrogenase [Limibacter armeniacum]	diamond	13320	188	0.99468085106383	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Flammeovirgaceae	Limibacter	Limibacter armeniacum
26899104	26899104	PRJNA951388_S_NODE_1141_length_620_cov_83.323583_g1025_i0	PRJNA951388	1141	620	83.323583	516.6062146	Candidatus Aegiribacteria sp.	2528271	Bacteria	Bacteria	94.7	1.44e-21	NR	MFO8183585.1	2528271	g1025	i0	57.7	1.65483870967742	78	33	37.7	0	50	283	2	79	MFO8183585.1 RNA-binding protein [Candidatus Aegiribacteria sp.]	diamond	1026	94.7	1	Bacteria	FCB group	Pseudomonadati					Candidatus Aegiribacteria	Candidatus Aegiribacteria sp.
29677847	29677847	PRJNA951388_S_NODE_9230_length_275_cov_2.054455_g9103_i0	PRJNA951388	9230	275	2.054455	5.64975125	Flavobacteriaceae bacterium	1871037	Bacteria	Bacteria	97.4	1.35e-21	NR	MDC0637698.1	1871037	g9103	i0	51.1	4.69090909090909	90	44	98.2	0	274	5	296	385	MDC0637698.1 proline dehydrogenase family protein [Flavobacteriaceae bacterium]	diamond	1290	97.4	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae		Flavobacteriaceae bacterium
30405155	30405155	PRJNA951388_S_NODE_8833_length_282_cov_2.578947_g8706_i0	PRJNA951388	8833	282	2.578947	7.27263054	Dysgonomonas sp. HDW5B	2714927	Bacteria	Bacteria	45.4	0.00624	NR	WP_166200152.1	2714927	g8706	i0	31.3	1.02127659574468	96	56	91.5	2	14	271	109	204	WP_166200152.1 glycosyltransferase [Dysgonomonas sp. HDW5B]	diamond	288	45.4	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Dysgonomonadaceae	Dysgonomonas	Dysgonomonas sp. HDW5B
31226123	31226123	PRJNA951388_S_NODE_7155_length_318_cov_2.636735_g7028_i0	PRJNA951388	7155	318	2.636735	8.3848173	Paludibacteraceae bacterium	2748031	Bacteria	Bacteria	43.9	0.0314	NR	MDR3706341.1	2748031	g7028	i0	28.4	0.69811320754717	74	53	69.8	0	313	92	222	295	MDR3706341.1 cation diffusion facilitator family transporter [Paludibacteraceae bacterium]	diamond	222	43.9	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Paludibacteraceae		Paludibacteraceae 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);;