metadata: contig_metadata: 9 rows where analysis = "diamond", bioproject = "PRJNA685060" and tax

9 rows where analysis = "diamond", bioproject = "PRJNA685060" 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
27366962	27366962	PRJNA685060_P_NODE_543_length_1223_cov_3.296522_g500_i0	PRJNA685060	543	1223	3.296522	40.31646406	Candidatus Latescibacterota bacterium	2053570	Bacteria	Bacteria	49.3	0.0174	NR	MEE2753403.1	2053570	g500	i0	34.8	0.218315617334424	89	53	21.1	3	86	343	72	158	MEE2753403.1 hypothetical protein [Candidatus Latescibacterota bacterium]	diamond	267	49.3	1	Bacteria	FCB group	Pseudomonadati	Candidatus Latescibacterota					Candidatus Latescibacterota bacterium
27410111	27410111	PRJNA685060_P_NODE_5783_length_400_cov_0.941896_g5693_i0	PRJNA685060	5783	400	0.941896	3.767584	Bacteria	2	Bacteria	Bacteria	45.8	0.00421	NR	MBC7826799.1	1869212	g5693	i0	30.8	6.3825	91	47	56.3	2	83	307	15	105	MBC7826799.1 SET domain-containing protein-lysine N-methyltransferase [Chitinophagaceae bacterium]	diamond	2553	45.8	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae		Chitinophagaceae bacterium
27871833	27871833	PRJNA685060_P_NODE_13265_length_251_cov_1.730337_g13175_i0	PRJNA685060	13265	251	1.730337	4.34314587	Altibacter sp.	2024823	Bacteria	Bacteria	42.4	0.0438	NR	WP_290785504.1	2024823	g13175	i0	41.2	0.609561752988048	51	29	59.8	1	78	227	19	69	WP_290785504.1 IMPACT family protein [Altibacter sp.]	diamond	153	42.4	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Altibacter	Altibacter sp.
28483451	28483451	PRJNA685060_P_NODE_9306_length_311_cov_1.033613_g9216_i0	PRJNA685060	9306	311	1.033613	3.21453643	Pseudomonadati	3379134	Bacteria	Bacteria	99.8	1.86e-22	NR	BCX00657.1	1898104	g9216	i0	49.5	2.60450160771704	91	41	83	1	310	53	252	342	BCX00657.1 MAG: hypothetical protein KatS3mg041_0703 [Bacteroidota bacterium]	diamond	810	100	0.998	Bacteria	FCB group	Pseudomonadati	Bacteroidota					Bacteroidota bacterium
28913577	28913577	PRJNA685060_P_NODE_15108_length_247_cov_0.885057_g15018_i0	PRJNA685060	15108	247	0.885057	2.18609079	Pedobacter aquatilis	351343	Bacteria	Bacteria	84	1.11e-16	NR	WP_316739711.1	351343	g15018	i0	87.8	0.497975708502024	41	5	49.8	0	3	125	456	496	WP_316739711.1 RagB/SusD family nutrient uptake outer membrane protein [Pedobacter aquatilis]	diamond	123	84	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Sphingobacteriia	Sphingobacteriales	Sphingobacteriaceae	Pedobacter	Pedobacter aquatilis
31030321	31030321	PRJNA685060_P_NODE_13655_length_250_cov_2.372881_g13565_i0	PRJNA685060	13655	250	2.372881	5.9322025	Chitinophagales bacterium	2448779	Bacteria	Bacteria	45.1	0.00484	NR	MFK7907468.1	2448779	g13565	i0	45.7	1.296	46	20	55.2	1	25	162	26	66	MFK7907468.1 calcium-binding EGF-like domain-containing protein [Chitinophagales bacterium]	diamond	324	45.1	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales			Chitinophagales bacterium
31219303	31219303	PRJNA685060_P_NODE_17135_length_242_cov_0.911243_g17045_i0	PRJNA685060	17135	242	0.911243	2.20520806	Bacteroidales bacterium	2030927	Bacteria	Bacteria	57	3.22e-7	NR	HPT10631.1	2030927	g17045	i0	45	0.743801652892562	60	28	73.1	2	235	59	190	245	HPT10631.1 NAD-dependent epimerase/dehydratase family protein [Bacteroidales bacterium]	diamond	180	57	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales			Bacteroidales bacterium
32042135	32042135	PRJNA685060_P_NODE_8418_length_327_cov_2.641732_g8328_i0	PRJNA685060	8418	327	2.641732	8.63846364	Chitinophagaceae bacterium	1869212	Bacteria	Bacteria	44.3	0.0292	NR	HET9055784.1	1869212	g8328	i0	32.4	0.678899082568807	74	48	67	2	93	311	398	470	HET9055784.1 alpha-2-macroglobulin family protein [Chitinophagaceae bacterium]	diamond	222	44.3	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae		Chitinophagaceae bacterium
32674179	32674179	PRJNA685060_P_NODE_13360_length_251_cov_0.865169_g13270_i0	PRJNA685060	13360	251	0.865169	2.17157419	Bacteroidota bacterium	1898104	Bacteria	Bacteria	116	1.4599999999999999e-31	NR	MFN7821604.1	1898104	g13270	i0	74.7	0.99203187250996006	83	21	99.2	0	1	249	15	97	MFN7821604.1 F0F1 ATP synthase subunit A [Bacteroidota bacterium]	diamond	249	116	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota					Bacteroidota 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);;