metadata: contig_metadata: 11 rows where analysis = "diamond", bioproject = "PRJNA666695" and tax

11 rows where analysis = "diamond", bioproject = "PRJNA666695" and tax_phylum = "Fidelibacterota"

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_species
26733021	26733021	PRJNA666695_S_NODE_92941_length_227_cov_2.967742_g91847_i0	PRJNA666695	92941	227	2.967742	6.73677434	Fidelibacterota bacterium	2026760	Bacteria	Bacteria	66.6	1.14e-10	NR	RKY55170.1	2026760	g91847	i0	46.7	1.98237885462555	75	39	99.1	1	227	3	466	539	RKY55170.1 MAG: NAD-dependent malic enzyme [Fidelibacterota bacterium]	diamond	450	66.6	1	Bacteria	FCB group	Pseudomonadati	Fidelibacterota	Fidelibacterota bacterium
27176202	27176202	PRJNA666695_S_NODE_97202_length_222_cov_13.414365_g96108_i0	PRJNA666695	97202	222	13.414365	29.7798903	Fidelibacterota bacterium	2026760	Bacteria	Bacteria	74.7	1.43e-13	NR	MFB0515659.1	2026760	g96108	i0	51.5	5.35135135135135	68	32	91.9	1	221	18	355	421	MFB0515659.1 M28 family metallopeptidase [Fidelibacterota bacterium]	diamond	1188	74.7	1	Bacteria	FCB group	Pseudomonadati	Fidelibacterota	Fidelibacterota bacterium
27334525	27334525	PRJNA666695_S_NODE_127703_length_194_cov_2.104575_g126609_i0	PRJNA666695	127703	194	2.104575	4.0828755	Fidelibacterota bacterium	2026760	Bacteria	Bacteria	63.5	8.67e-10	NR	MCS5624013.1	2026760	g126609	i0	50	0.989690721649485	64	32	99	0	3	194	136	199	MCS5624013.1 MFS transporter [Fidelibacterota bacterium]	diamond	192	63.5	1	Bacteria	FCB group	Pseudomonadati	Fidelibacterota	Fidelibacterota bacterium
27366309	27366309	PRJNA666695_S_NODE_65963_length_263_cov_2.292793_g64869_i0	PRJNA666695	65963	263	2.292793	6.03004559	Fidelibacterota bacterium	2026760	Bacteria	Bacteria	44.7	0.00995	NR	MEA1986528.1	2026760	g64869	i0	28.2	0.809885931558935	71	48	81	2	227	15	158	225	MEA1986528.1 glycosyltransferase [Fidelibacterota bacterium]	diamond	213	44.7	1	Bacteria	FCB group	Pseudomonadati	Fidelibacterota	Fidelibacterota bacterium
28123867	28123867	PRJNA666695_S_NODE_67505_length_260_cov_4.141553_g66411_i0	PRJNA666695	67505	260	4.141553	10.7680378	Fidelibacterota bacterium	2026760	Bacteria	Bacteria	125	1.9299999999999995e-31	NR	GIR41949.1	2026760	g66411	i0	63.1	1.93846153846154	84	31	96.9	0	254	3	389	472	GIR41949.1 MAG: beta-glucosidase [Fidelibacterota bacterium]	diamond	504	125	1	Bacteria	FCB group	Pseudomonadati	Fidelibacterota	Fidelibacterota bacterium
28565811	28565811	PRJNA666695_S_NODE_24387_length_384_cov_12.078717_g23294_i0	PRJNA666695	24387	384	12.078717	46.38227328	Fidelibacterota bacterium	2026760	Bacteria	Bacteria	157	4.38e-43	NR	MBI65199.1	2026760	g23294	i0	59.8	3.59375	117	46	91.4	1	368	18	357	472	MBI65199.1 beta-glucosidase [Fidelibacterota bacterium]	diamond	1380	157	1	Bacteria	FCB group	Pseudomonadati	Fidelibacterota	Fidelibacterota bacterium
28629212	28629212	PRJNA666695_S_NODE_62687_length_268_cov_4.541850_g61593_i0	PRJNA666695	62687	268	4.54185	12.172158	Fidelibacterota bacterium	2026760	Bacteria	Bacteria	58.9	4.27e-8	NR	MCF7832119.1	2026760	g61593	i0	49.1	0.638059701492537	57	28	63.8	1	223	53	133	188	MCF7832119.1 GNAT family N-acetyltransferase [Fidelibacterota bacterium]	diamond	171	58.9	1	Bacteria	FCB group	Pseudomonadati	Fidelibacterota	Fidelibacterota bacterium
28798729	28798729	PRJNA666695_S_NODE_148247_length_179_cov_1.130435_g147153_i0	PRJNA666695	148247	179	1.130435	2.02347865	FCB group	1783270	Bacteria	Bacteria	54.3	1.33e-6	NR	MAX13596.1	2026760	g147153	i0	46	5.88268156424581	63	26	92.2	1	165	1	1546	1608	MAX13596.1 hypothetical protein [Fidelibacterota bacterium]	diamond	1053	54.7	0.992687385740402	Bacteria	FCB group	Pseudomonadati	Fidelibacterota	Fidelibacterota bacterium
28912932	28912932	PRJNA666695_S_NODE_71568_length_254_cov_3.455399_g70474_i0	PRJNA666695	71568	254	3.455399	8.77671346	Fidelibacterota bacterium	2026760	Bacteria	Bacteria	42.7	0.0418	NR	MED5474551.1	2026760	g70474	i0	39.6	0.625984251968504	53	29	62.6	1	88	246	78	127	MED5474551.1 IMP dehydrogenase [Fidelibacterota bacterium]	diamond	159	42.7	1	Bacteria	FCB group	Pseudomonadati	Fidelibacterota	Fidelibacterota bacterium
32653950	32653950	PRJNA666695_S_NODE_39960_length_320_cov_3.089606_g38866_i0	PRJNA666695	39960	320	3.089606	9.8867392	Pseudomonadati	3379134	Bacteria	Bacteria	43.5	0.00842	NR	MAX13326.1	2026760	g38866	i0	40	1.903125	50	30	46.9	0	29	178	36	85	MAX13326.1 BolA family transcriptional regulator [Fidelibacterota bacterium]	diamond	609	43.9	0.990888382687927	Bacteria	FCB group	Pseudomonadati	Fidelibacterota	Fidelibacterota bacterium
32748694	32748694	PRJNA666695_S_NODE_183280_length_157_cov_1.189655_g182186_i0	PRJNA666695	183280	157	1.189655	1.86775835	Pseudomonadati	3379134	Bacteria	Bacteria	71.6	5e-13	NR	MEE9572116.1	2026760	g182186	i0	53.8	1.96815286624204	52	24	99.4	0	1	156	46	97	MEE9572116.1 ectonucleotide pyrophosphatase/phosphodiesterase [Fidelibacterota bacterium]	diamond	309	71.6	1	Bacteria	FCB group	Pseudomonadati	Fidelibacterota	Fidelibacterota 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);;